6,714 rows where qSpecies_id = 7 sorted by Latitude

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
604 20034 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
1515 31846 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
3055 20039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
3242 43297 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1501 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2000 12:00:00 AM     Permit Number 43066                    
4991 20043 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
6396 36746 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 5555 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39516                    
7114 20035 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
7286 33084 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
7976 20040 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
9521 35167 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 240 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1998 12:00:00 AM     Permit Number 38700                    
9968 31847 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
14278 31848 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
14721 20044 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 15 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
18188 33083 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
18800 20042 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
19322 46857 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2002 12:00:00 AM     Permit Number 44926                    
106448 44743 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 306 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 5   Permit Number 43861 5992021.82053 2086414.86847 37.7084397758389 -122.469324250627 (37.7084397758389, -122.469324250627) 9 8 4 64 24
188142 44742 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 276 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 4   Permit Number 43860 5992023.15498 2086637.27235 37.7090505207416 -122.469335815893 (37.7090505207416, -122.469335815893) 9 8 4 64 24
34501 178750 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 52 Tomaso Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009169.8221 2086336.97845 37.7092019449876 -122.410052964391 (37.7092019449876, -122.410052964391) 9 7 8 309 39
154565 178844 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 52 Tomaso Ct 1 : Tree Private 2     16 Width 2ft   6009171.05644 2086338.49099 37.7092061672978 -122.410048805012 (37.7092061672978, -122.410048805012) 9 7 8 309 39
100298 73606 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 40 Rhine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1995 12:00:00 AM 4     5994431.82308 2086668.63726 37.7092755401168 -122.461013433922 (37.7092755401168, -122.461013433922) 9 8 6 28861 25
4921 71593 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 34 Rhine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5994443.94493 2086683.28618 37.7093164601484 -122.46097260021 (37.7093164601484, -122.46097260021) 9 8 6 28861 25
91958 178753 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 288 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008616.33006 2086415.65366 37.7093869328198 -122.411971481801 (37.7093869328198, -122.411971481801) 9 7 8 309 39
43859 178848 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 284 Schwerin St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008617.09448 2086417.42045 37.7093918269511 -122.411968964603 (37.7093918269511, -122.411968964603) 9 7 8 309 39
5910 24288 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 340 Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6001280.10777 2086581.35963 37.7094275956588 -122.437338476184 (37.7094275956588, -122.437338476184) 9 7 6 28861 5
172914 178843 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 316 Naylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6002755.16684 2086552.83016 37.7094330059866 -122.432238395683 (37.7094330059866, -122.432238395683) 9 7 6 28861 5
135026 178752 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 276 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008629.54675 2086454.27777 37.7094937282293 -122.411928530185 (37.7094937282293, -122.411928530185) 9 7 8 309 39
133610 178847 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 272 Schwerin St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6008631.68261 2086459.28689 37.7095076020765 -122.411921502003 (37.7095076020765, -122.411921502003) 9 7 8 309 39
13743 31056 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 9 Toyon Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 7   Permit Number 34808 6003244.64588 2086572.31488 37.7095142480656 -122.430548065039 (37.7095142480656, -122.430548065039) 9 7 6 28861 5
162816 178705 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 980 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5996782.39454 2086708.52961 37.7095200567877 -122.452892407466 (37.7095200567877, -122.452892407466) 9 7 6 28861 25
118022 86728 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 980 Huron Ave   Sidewalk: Curb side : Cutout Tree Private 2   09/25/2007 12:00:00 AM     Permit Number 49704 5996769.2 2086717.1 37.7095428329763 -122.452938628006 (37.7095428329763, -122.452938628006) 9 7 6 28861 25
147029 178751 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 272 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008644.3214 2086482.2621 37.7095713963714 -122.411879442491 (37.7095713963714, -122.411879442491) 9 7 8 309 39
193023 178846 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 272 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008639.83625 2086484.9507 37.7095785270867 -122.411895133863 (37.7095785270867, -122.411895133863) 9 7 8 309 39
188355 178833 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 99 Drake St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 6ft   6001567.75342 2086664.56423 37.7096724055308 -122.436350277744 (37.7096724055308, -122.436350277744) 9 7 6 28861 5
46561 44740 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 235 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 5   Permit Number 43858 5992059.17709 2086878.10482 37.7097138705641 -122.469228836168 (37.7097138705641, -122.469228836168) 9 8 4 64 24
41462 178834 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 99 Drake St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6001553.31629 2086683.73815 37.7097242325659 -122.436401546312 (37.7097242325659, -122.436401546312) 9 7 6 28861 5
167855 178835 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 99 Drake St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001544.78334 2086699.50707 37.7097670456913 -122.436432165527 (37.7097670456913, -122.436432165527) 9 7 6 28861 5
46408 178836 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 99 Drake St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001534.96826 2086713.04585 37.7098036624786 -122.436467056534 (37.7098036624786, -122.436467056534) 9 7 6 28861 5
174872 44738 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 224 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 6   Permit Number 43855 5992028.81192 2086945.80589 37.7098980067533 -122.469338707219 (37.7098980067533, -122.469338707219) 9 8 4 64 24
41663 69408 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 981 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 4   Permit Number 33513 6001538.59804 2086768.97979 37.7099574510375 -122.436458512063 (37.7099574510375, -122.436458512063) 9 7 6 28861 5
183863 178837 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 981 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6001551.41306 2086770.97159 37.7099636482706 -122.436414363453 (37.7099636482706, -122.436414363453) 9 7 6 28861 5
108453 178838 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 981 Prague St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001561.30647 2086771.17725 37.7099647751299 -122.436380184711 (37.7099647751299, -122.436380184711) 9 7 6 28861 5
24451 178839 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 921 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 6ft   6001840.757 2086804.78662 37.7100729338953 -122.435416754499 (37.7100729338953, -122.435416754499) 9 7 6 28861 5
13656 78518 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 75 Laura St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   0     5997355.58596 2086978.87375 37.7102951905332 -122.450930851174 (37.7102951905332, -122.450930851174) 9 7 6 28861 25
5566 78781 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 75 Laura St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   0     5997342.70536 2086993.54413 37.7103347346378 -122.450976426135 (37.7103347346378, -122.450976426135) 9 7 6 28861 25
186144 178739 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 416 Peninsula Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6012199.66481 2086699.29311 37.7103661434655 -122.39960671289 (37.7103661434655, -122.39960671289) 10 3 8 309 1
121457 178842 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 856 Prague St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6002039.21061 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839) 9 7 6 28861 5
72436 178841 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 856 Prague St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   6002067.27688 2086921.00065 37.7104048943477 -122.434642162998 (37.7104048943477, -122.434642162998) 9 7 6 28861 5
3299 178756 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 47 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6008299.13366 2086795.43914 37.7104119441216 -122.413094604643 (37.7104119441216, -122.413094604643) 9 7 8 309 39
33603 178755 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 35 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008316.59647 2086843.35831 37.7105445006064 -122.413037635286 (37.7105445006064, -122.413037635286) 9 7 8 309 39
33040 178754 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 27 Garrison Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008327.5198 2086871.77855 37.7106231499219 -122.413001889918 (37.7106231499219, -122.413001889918) 9 7 8 309 39
11820 78914 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 219 Concord St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318) 9 7 6 28861 5
1128 178845 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 543 Sawyer St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007634.8415 2086934.39681 37.7107561785306 -122.415400376427 (37.7107561785306, -122.415400376427) 9 7 8 309 39
75080 84187 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 543 Sawyer St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50696 6007633.86618 2086936.80805 37.7107627444765 -122.415403917956 (37.7107627444765, -122.415403917956) 9 7 8 309 39
9340 78715 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 190 Schwerin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6008812.7369 2086938.04091 37.7108323187195 -122.411329543927 (37.7108323187195, -122.411329543927) 9 7 8 309 39
13649 178696 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1121 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6008480.05498 2086950.03889 37.7108465981642 -122.412480221081 (37.7108465981642, -122.412480221081) 9 7 8 309 39
73742 65746 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 252 Curtis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/20/1990 12:00:00 AM     Permit Number 28705 6000865.93587078 2087131.69490372 37.7109151403091 -122.438809330108 (37.7109151403091, -122.438809330108) 9 7 6 28861 5
128731 178832 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 26 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6002753.4939 2087126.65044 37.71100849683 -122.43228513165 (37.71100849683, -122.43228513165) 9 7 6 28861 5
191050 178697 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 170 Lawrence Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   5996822.29762 2087264.10807 37.7110478340594 -122.452794569318 (37.7110478340594, -122.452794569318) 9 7 6 28861 25
164218 65315 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 543 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/20/1989 12:00:00 AM 18   Permit Number 28137 6013067.51643 2086945.434 37.7110903360125 -122.39662445846 (37.7110903360125, -122.39662445846) 10 3 8 309 1
88023 178738 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 88 Gillette Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6013102.20794 2086955.43637 37.7111197312489 -122.39650525601 (37.7111197312489, -122.39650525601) 10 3 8 309 1
60314 178737 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 91 Gillette Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6013141.93389 2086956.08513 37.7111237233427 -122.396367997898 (37.7111237233427, -122.396367997898) 10 3 8 309 1
174383 178840 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1065 Munich St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002119.38667 2087187.39371 37.7111393094924 -122.434481095339 (37.7111393094924, -122.434481095339) 9 7 6 28861 5
23123 212611 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 241 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5994544.18385 2087742.4739 37.7122305082008 -122.460702867445 (37.7122305082008, -122.460702867445) 9 8 6 28861 24
70479 178704 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 Rae Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998308.33595 2087754.71225 37.7124799639485 -122.447693779246 (37.7124799639485, -122.447693779246) 9 7 6 28861 25
190799 178703 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 Rae Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998317.89725 2087761.99008 37.7125004936668 -122.447661256171 (37.7125004936668, -122.447661256171) 9 7 6 28861 25
68721 178702 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 Rae Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998336.16892 2087781.41779 37.7125548819847 -122.447599501525 (37.7125548819847, -122.447599501525) 9 7 6 28861 25
102506 178701 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 Rae Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998344.49014 2087790.45997 37.7125801853098 -122.447571391401 (37.7125801853098, -122.447571391401) 9 7 6 28861 25
110244 178700 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 20 Rae Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998352.64125 2087797.95549 37.7126012321305 -122.447543757946 (37.7126012321305, -122.447543757946) 9 7 6 28861 25
3097 52514 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 145 Naglee Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.2402014 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442) 9 7 6 28861 25
55937 52515 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 145 Naglee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.2402014 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442) 9 7 6 28861 25
56240 52518 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 145 Naglee Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.2402014 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442) 9 7 6 28861 25
67749 52517 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 145 Naglee Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.2402014 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442) 9 7 6 28861 25
148271 52516 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 145 Naglee Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.2402014 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442) 9 7 6 28861 25
31528 178735 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 110 Newton St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6000958.61329 2087891.23319 37.7130059360373 -122.438543401379 (37.7130059360373, -122.438543401379) 9 7 6 28861 5
171879 178734 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 110 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000949.06967 2087917.1354 37.7130765148503 -122.438578241996 (37.7130765148503, -122.438578241996) 9 7 6 28861 5
31436 31009 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 101 Morse St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34782 6000957.44438381 2087943.44267066 37.7131492251602 -122.438551179992 (37.7131492251602, -122.438551179992) 9 7 6 28861 5
167129 31008 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 101 Morse St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34782 6000957.44438381 2087943.44267066 37.7131492251602 -122.438551179992 (37.7131492251602, -122.438551179992) 9 7 6 28861 5
46143 178733 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 Morse St 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 1ft   6000880.0864 2087963.64183 37.7132002867365 -122.438820001354 (37.7132002867365, -122.438820001354) 9 7 6 28861 5
174108 178736 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 248 Hester Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6012387.77571 2087731.31879 37.713210365434 -122.39902894795 (37.713210365434, -122.39902894795) 10 3 8 309 1
37576 178732 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 Morse St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 1ft   6000912.22914 2087974.06631 37.7132307386797 -122.438709651846 (37.7132307386797, -122.438709651846) 9 7 6 28861 5
4910 65716 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 98 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1990 12:00:00 AM 7 3x3 Permit Number 28648 6000919.98791 2088014.07766 37.7133410423274 -122.438685700186 (37.7133410423274, -122.438685700186) 9 7 6 28861 5
105098 212668 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 162 Ramsell St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   5992987.49956 2088299.56272 37.7136704541029 -122.466123641711 (37.7136704541029, -122.466123641711) 9 8 6 64 24
87138 48580 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 170 Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2002 12:00:00 AM     Permit Number 45894 5992735.0311487 2088323.3092015 37.7137210870883 -122.466997982048 (37.7137210870883, -122.466997982048) 9 8 6 64 24
29862 48581 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 162 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2002 12:00:00 AM     Permit Number 45895 5992994.26817447 2088334.73866608 37.7137674293264 -122.466102801731 (37.7137674293264, -122.466102801731) 9 8 6 64 24
85773 62994 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 121 Chester Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1986 12:00:00 AM 1   Permit Number 23395 5991750.67961 2088373.72786 37.7138026589318 -122.470403898426 (37.7138026589318, -122.470403898426) 9 8 6 64 24
60978 178699 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 17 Sala Ter 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 1ft   5999039.32435 2088222.29438 37.7138055898272 -122.44520086393 (37.7138055898272, -122.44520086393) 9 7 6 28861 25
130100 178698 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 17 Sala Ter 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 1ft   5999028.57689 2088233.45107 37.7138356100938 -122.445238812629 (37.7138356100938, -122.445238812629) 9 7 6 28861 25
3972 73489 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 45 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000901.50106 2088195.84142 37.7138390733861 -122.438762613813 (37.7138390733861, -122.438762613813) 9 7 6 28861 5
15833 65712 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 52 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1990 12:00:00 AM 10   Permit Number 28641 6000856.2772 2088212.06754 37.7138810537462 -122.438920085998 (37.7138810537462, -122.438920085998) 9 7 6 28861 5
15164 70910 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 45 Newton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000896.54528 2088212.43618 37.7138843569546 -122.43878093122 (37.7138843569546, -122.43878093122) 9 7 6 28861 5
151063 84132 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 332 Sawyer St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 7 3x3 Permit Number 50694 6008018.96296 2088075.22634 37.713910242141 -122.41415342054 (37.713910242141, -122.41415342054) 9 7 8 309 39
17858 74088 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 25 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000890.32413 2088231.91583 37.7139374897944 -122.438803828836 (37.7139374897944, -122.438803828836) 9 7 6 28861 5
9561 73853 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 25 Newton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000885.5664 2088247.40697 37.713979754329 -122.438821382721 (37.713979754329, -122.438821382721) 9 7 6 28861 5
18455 70117 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 25 Newton St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6000875.39739 2088278.84235 37.7140654903181 -122.438858781914 (37.7140654903181, -122.438858781914) 9 7 6 28861 5
7370 78746 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 355 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6009102.50426 2088111.28549 37.7140700552715 -122.410410826197 (37.7140700552715, -122.410410826197) 9 7 8 309 39
49748 212610 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 278 Farallones St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5994199.47136 2088424.58434 37.7140835828601 -122.461943718748 (37.7140835828601, -122.461943718748) 9 8 6 28861 24
127034 48564 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 278 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/2002 12:00:00 AM     Permit Number 45983 5994240.83855888 2088432.11877754 37.7141066521182 -122.461801284944 (37.7141066521182, -122.461801284944) 9 8 6 28861 24
29142 35866 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 963 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1998 12:00:00 AM 5   Permit Number 39078 6002010.96914 2088348.68943 37.7143218168851 -122.434938810705 (37.7143218168851, -122.434938810705) 9 7 6 28861 5
188230 178730 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 38 Curtis St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6000522.25708 2088403.46522 37.7143875788973 -122.440088297264 (37.7143875788973, -122.440088297264) 9 7 6 28861 5

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);