trees
27,746 rows where qCaretaker_id = 1 sorted by qAddress descending
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6868 | 16475 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
144005 | 16473 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
169023 | 16470 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 9X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
186720 | 16472 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
187750 | 16478 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 9X Newhall St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/1997 12:00:00 AM | 6 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | ||
80686 | 13301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 1 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
152150 | 13304 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 4 | Median : Cutout | Tree | DPW 1 | 12 | 15 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
178562 | 13303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
183101 | 13302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 2 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
27484 | 12977 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 9X Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/1990 12:00:00 AM | 4 | 3X3 | 6002070.87849 | 2108590.79545 | 37.7699053099025 | -122.436179442539 | (37.7699053099025, -122.436179442539) | 15 | 5 | 5 | 29492 | 9 | ||
4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
12086 | 264891 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
13415 | 264888 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
15114 | 264890 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
17002 | 264889 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
18389 | 264893 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
38731 | 218719 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | 1 | 8 | 4 | 29491 | 40 | |||
39244 | 209213 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 23 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 5993777.82606 | 2100247.64237 | 37.7465225122089 | -122.464258910041 | (37.7465225122089, -122.464258910041) | 1 | 8 | 4 | 29491 | 40 | |||
40694 | 211249 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 4 | Median : Cutout | Tree | DPW 1 | 23 | Width 5ft | 5993726.26019 | 2100287.20967 | 37.7466281816478 | -122.464440090141 | (37.7466281816478, -122.464440090141) | 1 | 8 | 4 | 29491 | 40 | |||
40877 | 211250 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 9 | Median : Cutout | Tree | DPW 1 | 33 | Width 5ft | 5993746.09289 | 2100276.06203 | 37.7465987162755 | -122.464370702046 | (37.7465987162755, -122.464370702046) | 1 | 8 | 4 | 29491 | 40 | |||
55816 | 219165 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5993760.22324 | 2100276.50528 | 37.7466007478231 | -122.464321873352 | (37.7466007478231, -122.464321873352) | 1 | 8 | 4 | 29491 | 40 | |||
64350 | 211254 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 15 | Median : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5993790.37609 | 2100225.91603 | 37.7464635805444 | -122.464213936719 | (37.7464635805444, -122.464213936719) | 1 | 8 | 4 | 29491 | 40 | |||
69629 | 219167 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 13 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | 1 | 8 | 4 | 29491 | 40 | |||
72058 | 209212 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 22 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 5993771.94389 | 2100232.96399 | 37.7464818700511 | -122.4642781843 | (37.7464818700511, -122.4642781843) | 1 | 8 | 4 | 29491 | 40 | |||
75444 | 211251 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 10 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5993753.32003 | 2100266.28903 | 37.7465722986798 | -122.464345002125 | (37.7465722986798, -122.464345002125) | 1 | 8 | 4 | 29491 | 40 | |||
98701 | 218721 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.7466566307978 | -122.464476068412 | (37.7466566307978, -122.464476068412) | 1 | 8 | 4 | 29491 | 40 | |||
102337 | 219162 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5993732.15666 | 2100284.86554 | 37.7466220851571 | -122.464419530755 | (37.7466220851571, -122.464419530755) | 1 | 8 | 4 | 29491 | 40 | |||
103292 | 209210 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 20 | Median : Cutout | Tree | DPW 1 | 1 | Width 5ft | 5993788.41941 | 2100238.90873 | 37.7464991424297 | -122.464221645739 | (37.7464991424297, -122.464221645739) | 1 | 8 | 4 | 29491 | 40 | |||
109445 | 209209 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 19 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5993795.21392 | 2100243.94669 | 37.746513367011 | -122.464198516942 | (37.746513367011, -122.464198516942) | 1 | 8 | 4 | 29491 | 40 | |||
112437 | 209208 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 18 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5993802.83706 | 2100253.03783 | 37.7465387683529 | -122.464172817044 | (37.7465387683529, -122.464172817044) | 1 | 8 | 4 | 29491 | 40 | |||
115311 | 219166 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5993758.91368 | 2100249.51951 | 37.7465265762511 | -122.46432444273 | (37.7465265762511, -122.46432444273) | 1 | 8 | 4 | 29491 | 40 | |||
131893 | 218720 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.7466556145593 | -122.464499198102 | (37.7466556145593, -122.464499198102) | 1 | 8 | 4 | 29491 | 40 | |||
141325 | 209207 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 17 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5993815.86849 | 2100254.24474 | 37.7465428332992 | -122.464127843728 | (37.7465428332992, -122.464127843728) | 1 | 8 | 4 | 29491 | 40 | |||
142182 | 211253 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 14 | Median : Cutout | Tree | DPW 1 | 25 | Width 5ft | 5993783.32 | 2100243.82658 | 37.7465123516796 | -122.46423963577 | (37.7465123516796, -122.46423963577) | 1 | 8 | 4 | 29491 | 40 | |||
147688 | 219164 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5993746.9601 | 2100281.9643 | 37.7466149724013 | -122.464368131807 | (37.7466149724013, -122.464368131807) | 1 | 8 | 4 | 29491 | 40 | |||
151160 | 219163 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 99x San Marcos Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5993739.16637 | 2100264.73593 | 37.746567218412 | -122.464393830836 | (37.746567218412, -122.464393830836) | 1 | 8 | 4 | 29491 | 40 | |||
170757 | 211252 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99x San Marcos Ave | 11 | Median : Cutout | Tree | DPW 1 | 28 | Width 5ft | 5993772.95985 | 2100263.65639 | 37.7465662021668 | -122.464276899165 | (37.7465662021668, -122.464276899165) | 1 | 8 | 4 | 29491 | 40 | |||
179289 | 209211 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x San Marcos Ave | 21 | Median : Cutout | Tree | DPW 1 | 2 | Width 5ft | 5993782.2667 | 2100229.04683 | 37.7464717095186 | -122.464242205116 | (37.7464717095186, -122.464242205116) | 1 | 8 | 4 | 29491 | 40 | |||
9825 | 259868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
15935 | 259870 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
17026 | 259869 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
78678 | 13325 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 12 | 4x9 | 6004718.9472012 | 2089729.3577775 | 37.7182662183542 | -122.425677176757 | (37.7182662183542, -122.425677176757) | 9 | 7 | 6 | 309 | 18 | ||
180102 | 13326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011657.72731 | 2090650.48596 | 37.7211850991863 | -122.401757321938 | (37.7211850991863, -122.401757321938) | 10 | 7 | 8 | 309 | 28 | |||
88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
18667 | 259652 | DPW Maintained 1 | :: 45 | 99x Cora St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
44401 | 209215 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x Castenada Ave | 25 | Median : Cutout | Tree | DPW 1 | 15 | Width 5ft | 5993821.14503 | 2100240.07202 | 37.7465042227113 | -122.46410856948 | (37.7465042227113, -122.46410856948) | 1 | 8 | 4 | 29491 | 40 | |||
106758 | 209214 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 99x Castenada Ave | 24 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5993812.32227 | 2100226.93547 | 37.746467644571 | -122.464138123878 | (37.746467644571, -122.464138123878) | 1 | 8 | 4 | 29491 | 40 | |||
176353 | 206418 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x Castenada Ave | 16 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5993828.80673 | 2100251.01259 | 37.7465347043225 | -122.464082870453 | (37.7465347043225, -122.464082870453) | 1 | 8 | 4 | 29491 | 40 | |||
15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
18887 | 259638 | DPW Maintained 1 | :: 45 | 99x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
47175 | 24120 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016647.77235 | 2095170.83896 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | 10 | 3 | 8 | 58 | 1 | |||
36572 | 23617 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99X Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | 1 | 8 | 4 | 59 | 40 | |||
165634 | 23618 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99X Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 5992931.1771373 | 2097763.0006234 | 37.7396514793132 | -122.467005897689 | (37.7396514793132, -122.467005897689) | 1 | 8 | 4 | 59 | 40 | |||
113252 | 24476 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99X Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002281.2265789 | 2096676.7830479 | 37.7372042247503 | -122.43459982975 | (37.7372042247503, -122.43459982975) | 2 | 7 | 5 | 63 | 7 | |||
61728 | 18671 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99X Richardson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 13 | 2X2 | 5999533.57531 | 2119335.56991 | 37.7992631844067 | -122.445728714712 | (37.7992631844067, -122.445728714712) | 13 | 9 | 1 | 57 | 17 | ||
23662 | 24438 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 99X Peter Yorke Way | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | 13 | 9 | 1 | 28858 | 41 | ||
40117 | 24439 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 99X Peter Yorke Way | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | 13 | 9 | 1 | 28858 | 41 | ||
57993 | 24437 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 99X Peter Yorke Way | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | 13 | 9 | 1 | 28858 | 41 | ||
92278 | 24440 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 99X Peter Yorke Way | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | 13 | 9 | 1 | 28858 | 41 | ||
107361 | 24433 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 99X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | 13 | 9 | 1 | 28858 | 41 | ||
40345 | 17320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
64749 | 17324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
72154 | 17321 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
155474 | 17322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
173835 | 17323 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
15787 | 12969 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
121594 | 12970 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 5X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
134644 | 12968 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 4X4 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
186052 | 12967 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 99X Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001957.7757889 | 2095598.483465 | 37.7342250957668 | -122.435641023763 | (37.7342250957668, -122.435641023763) | 2 | 7 | 5 | 63 | 7 | |||
63794 | 10245 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 99X Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2008 12:00:00 AM | 6 | 3X3 | Permit Number 769626 | 6005669.1162393 | 2109600.6288971 | 37.7728818463732 | -122.423805014394 | (37.7728818463732, -122.423805014394) | 7 | 9 | 11 | 28852 | 10 | |
103835 | 10244 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 99X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 6 | 3X3 | 6005773.33687 | 2109613.89968 | 37.7729241676403 | -122.42344544616 | (37.7729241676403, -122.42344544616) | 7 | 9 | 11 | 28852 | 10 | ||
32681 | 9313 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 99X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
83199 | 9319 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
109724 | 9317 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Gold Mine Dr | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | ||
122652 | 9318 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
148302 | 9320 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
81435 | 103790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
123507 | 103789 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
189169 | 103788 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
152627 | 3925 | DPW Maintained 1 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 514 | 99X Castro St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
40249 | 28930 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008789.5968147 | 2111229.2885306 | 37.7775294243446 | -122.413126052308 | (37.7775294243446, -122.413126052308) | 8 | 2 | 9 | 28853 | 34 | |
105575 | 95093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
29520 | 102438 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 999X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
24916 | 20126 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 999X Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | 15 | 9 | 11 | 29492 | 10 | |||
123540 | 20129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999X Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2008 12:00:00 AM | 18 | 3X3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | 15 | 9 | 11 | 29492 | 10 | ||
45560 | 93296 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 999X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004559.2 | 2103505.3 | 37.7560828122733 | -122.427210089969 | (37.7560828122733, -122.427210089969) | 2 | 4 | 5 | 28862 | 22 | ||
25005 | 23302 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 999 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 4X4 | 6006475.49296 | 2113790.126 | 37.7844306784727 | -122.421313221929 | (37.7844306784727, -122.421313221929) | 7 | 9 | 11 | 28858 | 41 | |||
98789 | 23303 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 999 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 4X4 | 6006477.84301 | 2113768.62409 | 37.7843717719938 | -122.421303564123 | (37.7843717719938, -122.421303564123) | 7 | 9 | 11 | 28858 | 41 | |||
50197 | 91660 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | 2 | 4 | 7 | 28859 | 19 | ||
157319 | 12319 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | 7 | 9 | 11 | 29490 | 41 | |||
170770 | 12320 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 999 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004798.1051 | 2112124.4849 | 37.7797625287887 | -122.426997735879 | (37.7797625287887, -122.426997735879) | 7 | 9 | 11 | 29490 | 41 | |||
17536 | 264654 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 999 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:51:00 PM | 3x3 | |||||||||||||
138663 | 112172 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010071 | 2112545 | 37.7812139111906 | -122.408786077679 | (37.7812139111906, -122.408786077679) | 14 | 2 | 9 | 28853 | 34 | ||||
66291 | 6152 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6006127.91467 | 2113531.0311 | 37.7836996654557 | -122.422497308029 | (37.7836996654557, -122.422497308029) | 7 | 9 | 11 | 28858 | 41 | |||
89827 | 6151 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2x2 | 6006159.13113 | 2113535.212 | 37.7837129061562 | -122.422389607903 | (37.7837129061562, -122.422389607903) | 7 | 9 | 11 | 28858 | 41 | |||
133658 | 6149 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6006219.05208 | 2113544.77353 | 37.7837425397409 | -122.422182983282 | (37.7837425397409, -122.422182983282) | 7 | 9 | 11 | 28858 | 41 | |||
177796 | 6150 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6006191.74012 | 2113539.82354 | 37.7837274077384 | -122.42227712071 | (37.7837274077384, -122.42227712071) | 7 | 9 | 11 | 28858 | 41 | |||
191344 | 5220 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1995 12:00:00 AM | 3 | 3X4 | 6001495.4192 | 2111745.9646 | 37.7785359024219 | -122.438396022881 | (37.7785359024219, -122.438396022881) | 15 | 5 | 11 | 29490 | 41 | ||
2600 | 258371 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
5926 | 258370 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );