trees
142,615 rows where qLegalStatus_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 | ||
95648 | 115441 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
156023 | 115444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
6306 | 237343 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
9376 | 237344 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
17067 | 223124 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 99x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
102059 | 253188 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
108669 | 253189 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
125960 | 253190 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
144046 | 253187 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
156585 | 253184 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
160059 | 253185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
173231 | 253186 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014645 | 2117171 | 37.7941709756503 | -122.393285986986 | (37.7941709756503, -122.393285986986) | 12 | 2 | 10 | 28855 | 6 | ||||
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 | |||
98555 | 242320 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006209.1521 | 2102634.3543 | 37.75378456653 | -122.421442142453 | (37.75378456653, -122.421442142453) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||||||||||||
35312 | 251230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
116313 | 253374 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
153759 | 251232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007537 | 2096150 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | 2 | 7 | 7 | 28859 | 2 | ||||
1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
157055 | 173704 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |||
24037 | 108406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.415540737233 | (37.7814172463574, -122.415540737233) | 7 | 10 | 9 | 28852 | 36 | |
47186 | 108408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.415516217226 | (37.7812898924571, -122.415516217226) | 7 | 10 | 9 | 28852 | 36 | |
84973 | 108407 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | 7 | 10 | 9 | 28852 | 36 | |
114952 | 108409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.7812331371452 | -122.415505707716 | (37.7812331371452, -122.415505707716) | 7 | 10 | 9 | 28852 | 36 | |
137011 | 108405 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581 | (37.7814823069089, -122.41555124581) | 7 | 10 | 9 | 28852 | 36 | |
149589 | 108410 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530315 | -122.415496951018 | (37.781198530315, -122.415496951018) | 7 | 10 | 9 | 28852 | 36 | |
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 | |||
4451 | 209096 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99X Terrace Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 10ft | 5993033 | 2097048 | 37.7376941438167 | -122.466601883437 | (37.7376941438167, -122.466601883437) | 1 | 8 | 4 | 59 | 40 | |||
7800 | 209094 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99X Terrace Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993033 | 2097048 | 37.7376941438167 | -122.466601883437 | (37.7376941438167, -122.466601883437) | 1 | 8 | 4 | 59 | 40 | |||
10495 | 209095 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 99X Terrace Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 10ft | 5993033 | 2097048 | 37.7376941438167 | -122.466601883437 | (37.7376941438167, -122.466601883437) | 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 | |||
83645 | 242323 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006214.26543 | 2102686.33739 | 37.7539275884093 | -122.421428150793 | (37.7539275884093, -122.421428150793) | 2 | 4 | 5 | 28859 | 19 | |||
121510 | 242324 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006214.10132 | 2102706.48549 | 37.7539829011917 | -122.421430149091 | (37.7539829011917, -122.421430149091) | 2 | 4 | 5 | 28859 | 19 | |||
175437 | 242325 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006215.7234 | 2102729.1867 | 37.7540453249341 | -122.421426151609 | (37.7540453249341, -122.421426151609) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
76960 | 18670 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99X Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 5999509.53732 | 2119357.26289 | 37.7993213750517 | -122.445813455145 | (37.7993213750517, -122.445813455145) | 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 | |||
2105 | 227358 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007594.39314 | 2096161.75328 | 37.7360902568635 | -122.416193267317 | (37.7360902568635, -122.416193267317) | 2 | 7 | 7 | 28859 | 2 | |||
11598 | 227356 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007559.31004 | 2096165.80664 | 37.7360994137559 | -122.416314851151 | (37.7360994137559, -122.416314851151) | 2 | 7 | 7 | 28859 | 2 | |||
15724 | 227357 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007581.53732 | 2096160.90491 | 37.736087204549 | -122.416237655152 | (37.736087204549, -122.416237655152) | 2 | 7 | 7 | 28859 | 2 | |||
20359 | 111160 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003321.77346 | 2119803.50555 | 37.8007635719416 | -122.432653690929 | (37.8007635719416, -122.432653690929) | 13 | 9 | 1 | 57 | 17 | |||
35594 | 111164 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003392.25539 | 2119813.00098 | 37.8007936407819 | -122.432410472862 | (37.8007936407819, -122.432410472862) | 13 | 9 | 1 | 57 | 17 | |||
107681 | 111163 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003374.28365 | 2119810.99129 | 37.8007871036097 | -122.432472518919 | (37.8007871036097, -122.432472518919) | 13 | 9 | 1 | 57 | 17 | |||
117311 | 111161 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003338.31122 | 2119805.54449 | 37.8007701082019 | -122.432596609162 | (37.8007701082019, -122.432596609162) | 13 | 9 | 1 | 57 | 17 | |||
126173 | 111165 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.8008027913768 | -122.432345118256 | (37.8008027913768, -122.432345118256) | 13 | 9 | 1 | 57 | 17 |
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) );