Street_Tree_List

Data source: data.sfgov.org

6,719 rows where qSpecies = 16 sorted by YCoord

View and edit SQL

Suggested facets: qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▼ Latitude Longitude Location
3019 20034 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
3951 20035 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
4351 36746 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 5555 Woodward St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39516          
5302 35167 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 240 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/1998 12:00:00 AM     Permit Number 38700          
5746 31847 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7293 31848 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7527 20039 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
9510 46857 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2002 12:00:00 AM     Permit Number 44926          
10575 20040 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 ST            
10952 43297 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1501 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2000 12:00:00 AM     Permit Number 43066          
11795 31846 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
11812 20044 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
12976 20042 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
13223 33083 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14695 20043 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
14881 33084 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
28269 178750 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 52 Tomaso Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009169.8221 2086336.97845 37.709201944987605 -122.410052964391 (37.7092019449876, -122.410052964391)
40286 178844 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 52 Tomaso Ct 1 : 4 Tree 1 Private 1     16 Width 2ft   6009171.05644 2086338.49099 37.7092061672978 -122.410048805012 (37.7092061672978, -122.410048805012)
165215 44743 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 306 Saint Charles Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2001 12:00:00 AM 5   Permit Number 43861 5992021.82053 2086414.86847 37.7084397758389 -122.469324250627 (37.7084397758389, -122.469324250627)
33909 178753 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 288 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008616.33006 2086415.6536599998 37.7093869328198 -122.41197148180099 (37.7093869328198, -122.411971481801)
165737 178848 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 284 Schwerin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6008617.09448 2086417.42045 37.709391826951105 -122.411968964603 (37.7093918269511, -122.411968964603)
44971 178752 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 276 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008629.54675 2086454.27777 37.7094937282293 -122.411928530185 (37.7094937282293, -122.411928530185)
171245 178847 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 272 Schwerin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6008631.68261 2086459.28689 37.7095076020765 -122.411921502003 (37.7095076020765, -122.411921502003)
39728 178751 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 272 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008644.3214 2086482.2621 37.709571396371395 -122.411879442491 (37.7095713963714, -122.411879442491)
51803 178846 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 272 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008639.83625 2086484.9507 37.7095785270867 -122.411895133863 (37.7095785270867, -122.411895133863)
155545 178843 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 316 Naylor St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6002755.16684 2086552.83016 37.7094330059866 -122.432238395683 (37.7094330059866, -122.432238395683)
178309 31056 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 9 Toyon Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1995 12:00:00 AM 7   Permit Number 34808 6003244.645880001 2086572.31488 37.7095142480656 -122.430548065039 (37.7095142480656, -122.430548065039)
123650 24288 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 340 Winding Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6001280.10777 2086581.3596299998 37.709427595658795 -122.43733847618401 (37.7094275956588, -122.437338476184)
34347 44742 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 276 Saint Charles Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2001 12:00:00 AM 4   Permit Number 43860 5992023.15498 2086637.27235 37.7090505207416 -122.469335815893 (37.7090505207416, -122.469335815893)
176572 178833 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 99 Drake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 6ft   6001567.75342 2086664.56423 37.709672405530796 -122.43635027774401 (37.7096724055308, -122.436350277744)
146572 73606 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 40 Rhine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 4     5994431.8230800005 2086668.6372599998 37.7092755401168 -122.461013433922 (37.7092755401168, -122.461013433922)
55122 71593 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 34 Rhine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1995 12:00:00 AM 4     5994443.94493 2086683.2861799998 37.70931646014839 -122.46097260021001 (37.7093164601484, -122.46097260021)
167416 178834 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 99 Drake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 6ft   6001553.31629 2086683.73815 37.7097242325659 -122.43640154631201 (37.7097242325659, -122.436401546312)
57287 178739 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 416 Peninsula Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6012199.66481 2086699.2931099997 37.7103661434655 -122.39960671288999 (37.7103661434655, -122.39960671289)
30587 178835 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 99 Drake St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001544.783340001 2086699.50707 37.709767045691294 -122.436432165527 (37.7097670456913, -122.436432165527)
134446 178705 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 980 Huron Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5996782.39454 2086708.5296099999 37.7095200567877 -122.452892407466 (37.7095200567877, -122.452892407466)
53625 178836 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 99 Drake St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001534.9682599995 2086713.04585 37.7098036624786 -122.436467056534 (37.7098036624786, -122.436467056534)
108284 86728 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 980 Huron Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2007 12:00:00 AM     Permit Number 49704 5996769.2 2086717.1 37.7095428329763 -122.452938628006 (37.7095428329763, -122.452938628006)
40596 69408 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 981 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 4   Permit Number 33513 6001538.598040001 2086768.9797900002 37.7099574510375 -122.43645851206301 (37.7099574510375, -122.436458512063)
99158 178837 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 981 Prague St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001551.41306 2086770.9715900002 37.7099636482706 -122.43641436345301 (37.7099636482706, -122.436414363453)
60318 178838 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 981 Prague St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001561.306469999 2086771.17725 37.7099647751299 -122.436380184711 (37.7099647751299, -122.436380184711)
45234 178756 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 47 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6008299.13366 2086795.4391400001 37.710411944121596 -122.413094604643 (37.7104119441216, -122.413094604643)
178112 178839 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 921 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6001840.757 2086804.7866200001 37.7100729338953 -122.435416754499 (37.7100729338953, -122.435416754499)
31556 178755 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 35 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008316.596469999 2086843.3583099998 37.710544500606396 -122.413037635286 (37.7105445006064, -122.413037635286)
185410 178754 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 27 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6008327.5198 2086871.77855 37.7106231499219 -122.41300188991801 (37.7106231499219, -122.413001889918)
58904 44740 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 235 Saint Charles Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2001 12:00:00 AM 5   Permit Number 43858 5992059.17709 2086878.10482 37.7097138705641 -122.469228836168 (37.7097138705641, -122.469228836168)
137051 178842 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 856 Prague St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
59060 178841 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 856 Prague St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6002067.276880001 2086921.00065 37.710404894347704 -122.434642162998 (37.7104048943477, -122.434642162998)
164778 178845 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 543 Sawyer St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007634.8415 2086934.3968099998 37.7107561785306 -122.415400376427 (37.7107561785306, -122.415400376427)
71089 84187 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 543 Sawyer St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50696 6007633.86618 2086936.80805 37.7107627444765 -122.41540391795601 (37.7107627444765, -122.415403917956)
130109 78715 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 190 Schwerin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2000 12:00:00 AM 5     6008812.7369 2086938.0409099997 37.710832318719504 -122.411329543927 (37.7108323187195, -122.411329543927)
162407 65315 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 543 Blanken Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/20/1989 12:00:00 AM 18   Permit Number 28137 6013067.51643 2086945.4340000001 37.711090336012504 -122.39662445846001 (37.7110903360125, -122.39662445846)
179704 44738 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 224 Saint Charles Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2001 12:00:00 AM 6   Permit Number 43855 5992028.811919999 2086945.8058900002 37.7098980067533 -122.46933870721901 (37.7098980067533, -122.469338707219)
76801 178696 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1121 Sunnydale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6008480.0549800005 2086950.0388900002 37.7108465981642 -122.41248022108101 (37.7108465981642, -122.412480221081)
40726 178738 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 88 Gillette Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6013102.20794 2086955.43637 37.7111197312489 -122.39650525601002 (37.7111197312489, -122.39650525601)
72038 178737 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 91 Gillette Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6013141.93389 2086956.08513 37.7111237233427 -122.39636799789801 (37.7111237233427, -122.396367997898)
182397 78518 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 75 Laura St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/2000 12:00:00 AM 0     5997355.58596 2086978.87375 37.7102951905332 -122.450930851174 (37.7102951905332, -122.450930851174)
39626 78781 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 75 Laura St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/2000 12:00:00 AM 0     5997342.70536 2086993.5441299998 37.7103347346378 -122.450976426135 (37.7103347346378, -122.450976426135)
57825 78914 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 219 Concord St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/2003 12:00:00 AM 3     5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
183711 178832 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 26 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6002753.4939 2087126.6504400002 37.711008496830004 -122.43228513165 (37.71100849683, -122.43228513165)
88240 65746 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 252 Curtis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/20/1990 12:00:00 AM     Permit Number 28705 6000865.93587078 2087131.69490372 37.7109151403091 -122.438809330108 (37.7109151403091, -122.438809330108)
133075 178840 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1065 Munich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6002119.38667 2087187.3937099997 37.711139309492395 -122.434481095339 (37.7111393094924, -122.434481095339)
68434 178697 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 170 Lawrence Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   5996822.297619999 2087264.10807 37.7110478340594 -122.452794569318 (37.7110478340594, -122.452794569318)
36157 178736 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 248 Hester Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6012387.77571 2087731.3187900002 37.713210365434 -122.39902894795 (37.713210365434, -122.39902894795)
130179 212611 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 241 Sadowa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5994544.18385 2087742.4739 37.7122305082008 -122.460702867445 (37.7122305082008, -122.460702867445)
162276 178704 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Rae Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5998308.33595 2087754.71225 37.712479963948496 -122.44769377924601 (37.7124799639485, -122.447693779246)
73556 178703 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Rae Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5998317.89725 2087761.99008 37.712500493666795 -122.447661256171 (37.7125004936668, -122.447661256171)
159346 178702 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Rae Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5998336.16892 2087781.41779 37.7125548819847 -122.447599501525 (37.7125548819847, -122.447599501525)
43021 178701 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Rae Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5998344.49014 2087790.45997 37.7125801853098 -122.447571391401 (37.7125801853098, -122.447571391401)
71553 178700 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Rae Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5998352.64125 2087797.95549 37.712601232130496 -122.447543757946 (37.7126012321305, -122.447543757946)
25402 52514 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 145 Naglee Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.240201401 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442)
81604 52515 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 145 Naglee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.240201401 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442)
83381 52518 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 145 Naglee Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.240201401 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442)
85420 52517 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 145 Naglee Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.240201401 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442)
111902 52516 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 145 Naglee Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48619 5998354.240201401 2087816.66554809 37.7126526970659 -122.447539577442 (37.7126526970659, -122.447539577442)
138062 178735 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 110 Newton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6000958.61329 2087891.23319 37.7130059360373 -122.438543401379 (37.7130059360373, -122.438543401379)
45832 178734 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 110 Newton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000949.06967 2087917.1354 37.7130765148503 -122.438578241996 (37.7130765148503, -122.438578241996)
119263 31008 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 101 Morse St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1995 12:00:00 AM     Permit Number 34782 6000957.44438381 2087943.44267066 37.7131492251602 -122.438551179992 (37.7131492251602, -122.438551179992)
127132 31009 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 101 Morse St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1995 12:00:00 AM     Permit Number 34782 6000957.44438381 2087943.44267066 37.7131492251602 -122.438551179992 (37.7131492251602, -122.438551179992)
149450 178733 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 100 Morse St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 1ft   6000880.0864 2087963.6418299999 37.713200286736495 -122.438820001354 (37.7132002867365, -122.438820001354)
134948 178732 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 100 Morse St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 1ft   6000912.22914 2087974.06631 37.713230738679705 -122.43870965184601 (37.7132307386797, -122.438709651846)
69810 65716 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 98 Newton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/18/1995 12:00:00 AM 7 3x3 Permit Number 28648 6000919.98791 2088014.07766 37.7133410423274 -122.438685700186 (37.7133410423274, -122.438685700186)
75937 84132 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 332 Sawyer St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 7 3x3 Permit Number 50694 6008018.96296 2088075.22634 37.713910242141 -122.41415342053999 (37.713910242141, -122.41415342054)
176147 78746 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 355 Raymond Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2000 12:00:00 AM 8     6009102.50426 2088111.2854900002 37.7140700552715 -122.410410826197 (37.7140700552715, -122.410410826197)
55579 178749 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 309 Elliot St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008837.67953 2088153.65534 37.7141715446555 -122.411329156315 (37.7141715446555, -122.411329156315)
62438 73489 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 45 Newton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/18/1995 12:00:00 AM 7     6000901.50106 2088195.8414200002 37.713839073386104 -122.438762613813 (37.7138390733861, -122.438762613813)
152001 65712 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 52 Newton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/18/1995 12:00:00 AM 10   Permit Number 28641 6000856.2772 2088212.0675400002 37.713881053746206 -122.438920085998 (37.7138810537462, -122.438920085998)
126754 70910 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 45 Newton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/18/1995 12:00:00 AM 8     6000896.54528 2088212.43618 37.7138843569546 -122.43878093122 (37.7138843569546, -122.43878093122)
179163 178699 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 17 Sala Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 1ft   5999039.32435 2088222.2943799999 37.7138055898272 -122.44520086393 (37.7138055898272, -122.44520086393)
183519 74088 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 25 Newton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/18/1995 12:00:00 AM 8     6000890.324130001 2088231.9158299998 37.7139374897944 -122.438803828836 (37.7139374897944, -122.438803828836)
70802 178698 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 17 Sala Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 1ft   5999028.57689 2088233.4510700002 37.713835610093795 -122.445238812629 (37.7138356100938, -122.445238812629)
34700 73853 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 25 Newton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/18/1995 12:00:00 AM 8     6000885.5664 2088247.4069700001 37.713979754329 -122.438821382721 (37.713979754329, -122.438821382721)
45829 70117 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 25 Newton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/18/1995 12:00:00 AM 7     6000875.3973900005 2088278.84235 37.714065490318106 -122.438858781914 (37.7140654903181, -122.438858781914)
40814 212668 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 162 Ramsell St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   5992987.499559999 2088299.56272 37.713670454102896 -122.46612364171101 (37.7136704541029, -122.466123641711)
97486 48580 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 170 Arch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2002 12:00:00 AM     Permit Number 45894 5992735.0311487 2088323.3092015 37.713721087088295 -122.466997982048 (37.7137210870883, -122.466997982048)
127810 48581 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 162 Ramsell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2002 12:00:00 AM     Permit Number 45895 5992994.26817447 2088334.73866608 37.7137674293264 -122.466102801731 (37.7137674293264, -122.466102801731)
49129 35866 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 963 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1998 12:00:00 AM 5   Permit Number 39078 6002010.96914 2088348.68943 37.714321816885096 -122.43493881070499 (37.7143218168851, -122.434938810705)
49728 35867 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 963 Vienna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1998 12:00:00 AM 5   Permit Number 39078 6002026.003769999 2088372.6219 37.7143883838026 -122.434888555678 (37.7143883838026, -122.434888555678)
135511 62994 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 121 Chester Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/16/1986 12:00:00 AM 1   Permit Number 23395 5991750.67961 2088373.7278599998 37.7138026589318 -122.470403898426 (37.7138026589318, -122.470403898426)
48367 49748 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 109@ BRUSSELS Campbell Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 5   Permit Number 46547 6011907.8290099995 2088398.1624200002 37.715014627609 -122.400734636294 (37.715014627609, -122.400734636294)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2681.485ms · Data source: data.sfgov.org