Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72210 | 72210 | 16475 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
115131 | 115131 | 16473 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
118199 | 118199 | 16470 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 9X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
140227 | 140227 | 16472 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
142877 | 142877 | 16478 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 9X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 6 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | ||
96198 | 96198 | 13301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
138487 | 138487 | 13304 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
141679 | 141679 | 13302 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
142098 | 142098 | 13303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
23018 | 23018 | 12977 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 9X Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1990 12:00:00 AM | 4 | 3X3 | 6002070.87849 | 2108590.79545 | 37.7699053099025 | -122.436179442539 | (37.7699053099025, -122.436179442539) | ||
41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
42882 | 42882 | 211250 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 33 | Width 5ft | 5993746.09289 | 2100276.06203 | 37.7465987162755 | -122.464370702046 | (37.7465987162755, -122.464370702046) | |||
43117 | 43117 | 219165 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993760.22324 | 2100276.5052799997 | 37.7466007478231 | -122.46432187335199 | (37.7466007478231, -122.464321873352) | |||
44102 | 44102 | 209213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993777.82606 | 2100247.64237 | 37.7465225122089 | -122.46425891004101 | (37.7465225122089, -122.464258910041) | |||
47921 | 47921 | 211249 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5993726.26019 | 2100287.2096700002 | 37.74662818164779 | -122.464440090141 | (37.7466281816478, -122.464440090141) | |||
56613 | 56613 | 211254 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 5ft | 5993790.37609 | 2100225.91603 | 37.7464635805444 | -122.46421393671899 | (37.7464635805444, -122.464213936719) | |||
60137 | 60137 | 209212 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993771.94389 | 2100232.96399 | 37.746481870051106 | -122.4642781843 | (37.7464818700511, -122.4642781843) | |||
60262 | 60262 | 219167 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | |||
61181 | 61181 | 211251 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993753.32003 | 2100266.28903 | 37.746572298679794 | -122.464345002125 | (37.7465722986798, -122.464345002125) | |||
74481 | 74481 | 218721 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.746656630797794 | -122.464476068412 | (37.7466566307978, -122.464476068412) | |||
75541 | 75541 | 209208 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993802.83706 | 2100253.03783 | 37.7465387683529 | -122.46417281704399 | (37.7465387683529, -122.464172817044) | |||
76824 | 76824 | 219162 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993732.15666 | 2100284.86554 | 37.74662208515711 | -122.46441953075501 | (37.7466220851571, -122.464419530755) | |||
123719 | 123719 | 209209 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993795.21392 | 2100243.94669 | 37.746513367011 | -122.464198516942 | (37.746513367011, -122.464198516942) | |||
134757 | 134757 | 209210 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 5993788.41941 | 2100238.90873 | 37.746499142429705 | -122.464221645739 | (37.7464991424297, -122.464221645739) | |||
147824 | 147824 | 218720 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.746655614559295 | -122.464499198102 | (37.7466556145593, -122.464499198102) | |||
153512 | 153512 | 219166 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993758.91368 | 2100249.51951 | 37.7465265762511 | -122.46432444273 | (37.7465265762511, -122.46432444273) | |||
154163 | 154163 | 219163 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993739.16637 | 2100264.73593 | 37.746567218412 | -122.46439383083599 | (37.746567218412, -122.464393830836) | |||
156535 | 156535 | 219164 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993746.9601 | 2100281.9643 | 37.7466149724013 | -122.464368131807 | (37.7466149724013, -122.464368131807) | |||
157795 | 157795 | 209207 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993815.86849 | 2100254.24474 | 37.7465428332992 | -122.46412784372801 | (37.7465428332992, -122.464127843728) | |||
160858 | 160858 | 211253 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 5993783.32 | 2100243.82658 | 37.7465123516796 | -122.46423963577 | (37.7465123516796, -122.46423963577) | |||
178018 | 178018 | 209211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993782.2667 | 2100229.04683 | 37.7464717095186 | -122.46424220511601 | (37.7464717095186, -122.464242205116) | |||
184665 | 184665 | 211252 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 5ft | 5993772.95985 | 2100263.65639 | 37.7465662021668 | -122.464276899165 | (37.7465662021668, -122.464276899165) | |||
13137 | 13137 | 13326 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011657.72731 | 2090650.48596 | 37.72118509918629 | -122.40175732193799 | (37.7211850991863, -122.401757321938) | |||
93628 | 93628 | 13325 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 99x Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 12 | 4x9 | 6004718.9472012 | 2089729.3577775 | 37.7182662183542 | -122.42567717675699 | (37.7182662183542, -122.425677176757) | ||
43528 | 43528 | 209215 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x Castenada Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5993821.14503 | 2100240.07202 | 37.746504222711295 | -122.46410856948 | (37.7465042227113, -122.46410856948) | |||
134453 | 134453 | 209214 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x Castenada Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993812.322269999 | 2100226.93547 | 37.746467644571 | -122.464138123878 | (37.746467644571, -122.464138123878) | |||
180603 | 180603 | 206418 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x Castenada Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5993828.80673 | 2100251.01259 | 37.7465347043225 | -122.464082870453 | (37.7465347043225, -122.464082870453) | |||
13964 | 13964 | 24120 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6016647.77235 | 2095170.8389599998 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | |||
77908 | 77908 | 23617 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | |||
118929 | 118929 | 23618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | |||
101415 | 101415 | 24476 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99X Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002281.226578901 | 2096676.7830479 | 37.73720422475029 | -122.43459982975 | (37.7372042247503, -122.43459982975) | |||
5846 | 5846 | 18671 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 13 | 2X2 | 5999533.57531 | 2119335.56991 | 37.799263184406705 | -122.445728714712 | (37.7992631844067, -122.445728714712) | ||
78086 | 78086 | 24438 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
83108 | 83108 | 24439 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
90479 | 90479 | 24437 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
93710 | 93710 | 24440 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
97951 | 97951 | 24433 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
81456 | 81456 | 17320 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
87430 | 87430 | 17324 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
90076 | 90076 | 17321 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
119477 | 119477 | 17322 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
142907 | 142907 | 17323 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
34310 | 34310 | 12969 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X4 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
106673 | 106673 | 12970 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 5X4 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
112623 | 112623 | 12968 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
143021 | 143021 | 12967 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 99X Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001957.7757889 | 2095598.483465 | 37.734225095766796 | -122.43564102376301 | (37.7342250957668, -122.435641023763) | |||
20029 | 20029 | 10244 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 99X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 6 | 3X3 | 6005773.33687 | 2109613.89968 | 37.7729241676403 | -122.42344544616002 | (37.7729241676403, -122.42344544616) | ||
89922 | 89922 | 10245 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 99X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2008 12:00:00 AM | 6 | 3X3 | Permit Number 769626 | 6005669.1162393 | 2109600.6288971 | 37.7728818463732 | -122.42380501439399 | (37.7728818463732, -122.423805014394) | |
94044 | 94044 | 9319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
98684 | 98684 | 9317 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | ||
109307 | 109307 | 9318 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
112931 | 112931 | 9320 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
126064 | 126064 | 9313 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 99X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
95984 | 95984 | 103790 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
108374 | 108374 | 103789 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
139518 | 139518 | 103788 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
121943 | 121943 | 3925 | DPW Maintained 3 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 99X Castro St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
83147 | 83147 | 28930 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008789.5968147 | 2111229.2885306 | 37.7775294243446 | -122.413126052308 | (37.7775294243446, -122.413126052308) | |
97734 | 97734 | 95093 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2006 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | |
127485 | 127485 | 102438 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 999X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6010518.0 | 2112007.0 | 37.77976171638 | -122.40720173555799 | (37.77976171638, -122.407201735558) | ||||
105254 | 105254 | 20129 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 18 | 3X3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | ||
127665 | 127665 | 20126 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 999X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | |||
83398 | 83398 | 93296 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 999X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004559.2 | 2103505.3 | 37.7560828122733 | -122.42721008996901 | (37.7560828122733, -122.427210089969) | ||
23047 | 23047 | 23302 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4X4 | 6006475.4929599995 | 2113790.126 | 37.7844306784727 | -122.421313221929 | (37.7844306784727, -122.421313221929) | |||
23192 | 23192 | 23303 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4X4 | 6006477.84301 | 2113768.62409 | 37.7843717719938 | -122.42130356412301 | (37.7843717719938, -122.421303564123) | |||
82540 | 82540 | 91660 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | ||
8115 | 8115 | 12319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | |||
8760 | 8760 | 12320 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 999 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004798.1051 | 2112124.4849 | 37.7797625287887 | -122.426997735879 | (37.7797625287887, -122.426997735879) | |||
110388 | 110388 | 112172 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010071.0 | 2112545.0 | 37.7812139111906 | -122.40878607767901 | (37.7812139111906, -122.408786077679) | ||||
22493 | 22493 | 6152 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6006127.91467 | 2113531.0311 | 37.78369966545571 | -122.42249730802901 | (37.7836996654557, -122.422497308029) | |||
22553 | 22553 | 6151 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2x2 | 6006159.131130001 | 2113535.212 | 37.783712906156204 | -122.422389607903 | (37.7837129061562, -122.422389607903) | |||
22674 | 22674 | 6149 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6006219.052080001 | 2113544.77353 | 37.7837425397409 | -122.422182983282 | (37.7837425397409, -122.422182983282) | |||
22754 | 22754 | 6150 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6006191.740119999 | 2113539.8235400002 | 37.7837274077384 | -122.42227712071 | (37.7837274077384, -122.42227712071) | |||
8944 | 8944 | 5220 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 998X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1995 12:00:00 AM | 3 | 3X4 | 6001495.4192 | 2111745.9646 | 37.7785359024219 | -122.438396022881 | (37.7785359024219, -122.438396022881) | ||
118824 | 118824 | 13860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 998 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009623.0562505 | 2112946.0496627 | 37.78228999836271 | -122.41036407382201 | (37.7822899983627, -122.410364073822) | |||
19146 | 19146 | 10156 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 998 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6005679.7391 | 2103202.59116 | 37.7553149491356 | -122.423313367215 | (37.7553149491356, -122.423313367215) | |||
90755 | 90755 | 5867 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 998 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/1997 12:00:00 AM | 3 | 3X3 | 6005664.3899300005 | 2113122.17635 | 37.782550891124004 | -122.424071844531 | (37.782550891124, -122.424071844531) | ||
140680 | 140680 | 5866 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 998 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 3 | 3X3 | 6005664.3899300005 | 2113122.17635 | 37.782550891124004 | -122.424071844531 | (37.782550891124, -122.424071844531) | ||
7078 | 7078 | 95163 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 998 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001491.8688 | 2111772.0851 | 37.7786074207661 | -122.438410176931 | (37.7786074207661, -122.438410176931) | |
80339 | 80339 | 7861 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 995X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2014 12:00:00 AM | 6 | 4x4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.42272801205799 | (37.7835590051167, -122.422728012058) | ||
125384 | 125384 | 7863 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 995X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.42272801205799 | (37.7835590051167, -122.422728012058) | |||
128100 | 128100 | 7862 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 995X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.42272801205799 | (37.7835590051167, -122.422728012058) | |||
14240 | 14240 | 13858 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/1990 12:00:00 AM | 35 | 4X4 | 6009732.8033 | 2112958.8474 | 37.7823312894321 | -122.40998529993901 | (37.7823312894321, -122.409985299939) | ||
15291 | 15291 | 13859 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 995 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6009742.5413 | 2112949.1095 | 37.7823050972444 | -122.409950922983 | (37.7823050972444, -122.409950922983) | |||
286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
23132 | 23132 | 25364 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000636.2417 | 2088870.0556299998 | 37.7156752201082 | -122.43972775363001 | (37.7156752201082, -122.43972775363) | |||
9882 | 9882 | 173729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
81145 | 81145 | 13856 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 991 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6009733.829934901 | 2112955.195175 | 37.782321318828394 | -122.409981490315 | (37.7823213188284, -122.409981490315) | |||
88590 | 88590 | 13857 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 991 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2007 12:00:00 AM | 6 | 4X4 | 6009733.829934901 | 2112955.195175 | 37.782321318828394 | -122.409981490315 | (37.7823213188284, -122.409981490315) |
JSON shape: default, array, newline-delimited
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");