trees
142,615 rows where qLegalStatus_id = 1 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194516 | 265149 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194515 | 265162 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1699 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006124 | 2116197 | 37.791019535338 | -122.422700369292 | (37.791019535338, -122.422700369292) | 13 | 9 | 1 | 28858 | 27 | ||||
194514 | 265151 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194513 | 265163 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1699 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006124 | 2116197 | 37.791019535338 | -122.422700369292 | (37.791019535338, -122.422700369292) | 13 | 9 | 1 | 28858 | 27 | ||||
194512 | 246989 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 74 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6004681.91881 | 2101068.44983 | 37.7493987293702 | -122.426612168643 | (37.7493987293702, -122.426612168643) | 2 | 4 | 5 | 28862 | 22 | |||
194511 | 23411 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006198.56305 | 2116531.68812 | 37.7919427119246 | -122.422466175278 | (37.7919427119246, -122.422466175278) | 13 | 9 | 10 | 28858 | 21 | |||
194510 | 133064 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006197.29283 | 2116545.94616 | 37.7919817892855 | -122.422471583817 | (37.7919817892855, -122.422471583817) | 13 | 9 | 10 | 28858 | 21 | |||
194509 | 134259 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1625 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6006170.6591 | 2116000.96505 | 37.7904839045708 | -122.422524994529 | (37.7904839045708, -122.422524994529) | 13 | 9 | 1 | 28858 | 27 | |||
194508 | 203796 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 460 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993728.30174 | 2101878.83793 | 37.7509985054805 | -122.464548580761 | (37.7509985054805, -122.464548580761) | 1 | 8 | 4 | 29491 | 12 | |||
194506 | 134257 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1625 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 4ft | 6006160.66305 | 2116055.60858 | 37.7906333781701 | -122.422563464854 | (37.7906333781701, -122.422563464854) | 13 | 9 | 1 | 28858 | 27 | |||
194505 | 134258 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1625 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6006165.05583 | 2116021.37931 | 37.7905396409395 | -122.422545832742 | (37.7905396409395, -122.422545832742) | 13 | 9 | 1 | 28858 | 27 | |||
194503 | 265148 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194502 | 265146 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3512 23rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006075 | 2102620 | 37.753737588166 | -122.421905052211 | (37.753737588166, -122.421905052211) | 2 | 4 | 5 | 28859 | 19 | |||||
194500 | 133065 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006194.66564 | 2116570.23884 | 37.7920483427106 | -122.422482400837 | (37.7920483427106, -122.422482400837) | 13 | 9 | 10 | 28858 | 21 | |||
194498 | 265150 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1201 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006404 | 2114579 | 37.7865927014925 | -122.421616611631 | (37.7865927014925, -122.421616611631) | 13 | 9 | 11 | 28858 | 41 | ||||
194497 | 161370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 530 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6002550.45613 | 2090822.0233 | 37.7211436611464 | -122.433250757115 | (37.7211436611464, -122.433250757115) | 9 | 7 | 6 | 28861 | 5 | |||
194496 | 265137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 90X Broadmoor Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x6 | 5991049 | 2093460 | 37.7277277099678 | -122.47319985648 | (37.7277277099678, -122.47319985648) | 9 | 8 | 4 | 64 | 40 | ||||
194495 | 265132 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 582 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2021 12:00:00 AM | 3 | Width 3ft | 6009649.44136 | 2111748.76797 | 37.779004025349 | -122.410188235924 | (37.779004025349, -122.410188235924) | 14 | 2 | 9 | 28853 | 34 | ||
194493 | 198350 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 582 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2021 12:00:00 AM | 3 | Width 3ft | 6009649.44136 | 2111748.76797 | 37.779004025349 | -122.410188235924 | (37.779004025349, -122.410188235924) | 14 | 2 | 9 | 28853 | 34 | ||
194492 | 198349 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 582 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2021 12:00:00 AM | 3 | Width 3ft | 6009676.44757 | 2111773.36743 | 37.7790730833855 | -122.410096547333 | (37.7790730833855, -122.410096547333) | 14 | 2 | 9 | 28853 | 34 | ||
194491 | 226546 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 53 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005228 | 2105709 | 37.7621714532816 | -122.425053942898 | (37.7621714532816, -122.425053942898) | 8 | 4 | 5 | 28859 | 19 | |||
194490 | 171446 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 130 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 2ft | 6004630.97691 | 2092622.98585 | 37.7262065159928 | -122.426187146329 | (37.7262065159928, -122.426187146329) | 9 | 7 | 6 | 28861 | 5 | ||
194489 | 64389 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1050 Van Ness Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 04/28/1988 12:00:00 AM | 4 | Permit Number 25231 | 6006529.57186 | 2114155.94695 | 37.7854381817627 | -122.421152111986 | (37.7854381817627, -122.421152111986) | 13 | 9 | 9 | 28858 | 36 | ||
194488 | 230144 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4363 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | Permit Number 784873 | 6001567.34631 | 2100557.57487 | 37.747819415532 | -122.437345839845 | (37.747819415532, -122.437345839845) | 2 | 4 | 5 | 63 | 22 | ||
194487 | 265122 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2100x Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6006061 | 2117676 | 37.7950769441166 | -122.423023514153 | (37.7950769441166, -122.423023514153) | 13 | 9 | 10 | 28858 | 32 | ||||
194486 | 86928 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 838 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774404 | 6011535 | 2104444 | 37.7590523005339 | -122.403151323818 | (37.7590523005339, -122.403151323818) | 10 | 3 | 8 | 28856 | 29 | |
194485 | 181039 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 55 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 4ft | 6000909.27168 | 2088176.54977 | 37.7137865448937 | -122.438734374192 | (37.7137865448937, -122.438734374192) | 9 | 7 | 6 | 28861 | 5 | ||
194484 | 27260 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6006404.26283 | 2115076.39725 | 37.7879584463594 | -122.421651043279 | (37.7879584463594, -122.421651043279) | 13 | 9 | 10 | 28858 | 21 | |||
194483 | 265134 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Winston Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | ||||
194482 | 265119 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6006128.11756 | 2117026.5772 | 37.7932975792601 | -122.422745102704 | (37.7932975792601, -122.422745102704) | 13 | 9 | 10 | 28858 | 32 | ||||
194480 | 265130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 119X 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2021 12:00:00 AM | 3 | 3x3 | 6009560.38235 | 2111747.77793 | 37.7789963145717 | -122.410496258221 | (37.7789963145717, -122.410496258221) | 14 | 2 | 9 | 28853 | 34 | ||
194478 | 35851 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001833.39372 | 2090697.41132 | 37.7207607999542 | -122.435720519401 | (37.7207607999542, -122.435720519401) | 9 | 7 | 6 | 28861 | 5 | |
194477 | 265131 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 582 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2021 12:00:00 AM | 3 | Width 3ft | 6009649.44136 | 2111748.76797 | 37.779004025349 | -122.410188235924 | (37.779004025349, -122.410188235924) | 14 | 2 | 9 | 28853 | 34 | ||
194476 | 179001 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | Permit Number 778923 | 6001827.05422 | 2090687.03762 | 37.7207319560017 | -122.435741691253 | (37.7207319560017, -122.435741691253) | 9 | 7 | 6 | 28861 | 5 | ||
194474 | 265121 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2100x Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6006061 | 2117676 | 37.7950769441166 | -122.423023514153 | (37.7950769441166, -122.423023514153) | 13 | 9 | 10 | 28858 | 32 | ||||
194473 | 258633 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 625 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2021 12:00:00 AM | 3 | 4x6 | 5997754 | 2090591 | 37.7202360579042 | -122.449813998345 | (37.7202360579042, -122.449813998345) | 9 | 8 | 6 | 28861 | 24 | ||
194472 | 203213 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 626 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 10x4 | Permit Number 781523 | 6001387 | 2090021 | 37.7188781603148 | -122.437215155763 | (37.7188781603148, -122.437215155763) | 9 | 7 | 6 | 28861 | 5 | |
194471 | 179002 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 778923 | 6001822.18343 | 2090679.74768 | 37.7207116627863 | -122.43575800674 | (37.7207116627863, -122.43575800674) | 9 | 7 | 6 | 28861 | 5 | ||
194469 | 28912 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 119X 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2021 12:00:00 AM | 3 | 3x3 | 6009560.38235 | 2111747.77793 | 37.7789963145717 | -122.410496258221 | (37.7789963145717, -122.410496258221) | 14 | 2 | 9 | 28853 | 34 | ||
194468 | 265112 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006404.26283 | 2115076.39725 | 37.7879584463594 | -122.421651043279 | (37.7879584463594, -122.421651043279) | 13 | 9 | 10 | 28858 | 21 | ||||
194460 | 234487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 380 Cumberland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | Width 3ft | 6003189.58252 | 2104492.34613 | 37.7587154557579 | -122.432017164278 | (37.7587154557579, -122.432017164278) | 2 | 4 | 5 | 28862 | 3 | |||
194458 | 238322 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 105 Danvers St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999967 | 2105076 | 37.7601348010019 | -122.443204214657 | (37.7601348010019, -122.443204214657) | 2 | 4 | 5 | 28862 | 3 | |||
194456 | 265094 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 172 Locksley Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994312 | 2104105 | 37.7571446085096 | -122.462691582653 | (37.7571446085096, -122.462691582653) | 1 | 5 | 4 | 63 | 12 | ||||
194455 | 238321 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 105 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999967 | 2105076 | 37.7601348010019 | -122.443204214657 | (37.7601348010019, -122.443204214657) | 2 | 4 | 5 | 28862 | 3 | |||
194454 | 160418 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 645 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 04:39:00 PM | 3 | Width 0ft | 6002625.21582 | 2089488.77592 | 37.7174871004251 | -122.432897134702 | (37.7174871004251, -122.432897134702) | 9 | 7 | 6 | 28861 | 5 | |
194452 | 237613 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 105 Danvers St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999967 | 2105076 | 37.7601348010019 | -122.443204214657 | (37.7601348010019, -122.443204214657) | 2 | 4 | 5 | 28862 | 3 | |||
194451 | 238323 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 105 Danvers St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999967 | 2105076 | 37.7601348010019 | -122.443204214657 | (37.7601348010019, -122.443204214657) | 2 | 4 | 5 | 28862 | 3 | |||
194445 | 24428 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1501 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 3 | 3X3 | 6005809.51077 | 2115255.80256 | 37.7884174936216 | -122.42372154163 | (37.7884174936216, -122.42372154163) | 13 | 9 | 1 | 28858 | 41 | ||
194444 | 4138 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 3550 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006105.41199 | 2100602.05875 | 37.7481984995675 | -122.421656565093 | (37.7481984995675, -122.421656565093) | 2 | 4 | 5 | 28859 | 19 | |||
194441 | 180986 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 363 Munich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/11/2017 09:24:00 AM | 3 | Width 10ft | 6004214.2336 | 2090323.21202 | 37.7198682794893 | -122.427464041535 | (37.7198682794893, -122.427464041535) | 9 | 7 | 6 | 28861 | 5 | ||
194439 | 62177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780357 | 6000151.49887 | 2091775.04378 | 37.7236240542963 | -122.441611590516 | (37.7236240542963, -122.441611590516) | 9 | 7 | 6 | 28861 | 25 |
194437 | 178494 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 122 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6004225.74636 | 2093744.10414 | 37.7292619446745 | -122.427667848611 | (37.7292619446745, -122.427667848611) | 9 | 7 | 6 | 28861 | 5 | ||
194436 | 15776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4804 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2017 12:00:00 AM | 3 | 3X3 | Permit Number 773279 | 6001272.7685 | 2090814.9657 | 37.7210517172508 | -122.437666839136 | (37.7210517172508, -122.437666839136) | 9 | 7 | 6 | 28861 | 25 | |
194435 | 103878 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 791 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2017 12:00:00 AM | 3 | 6x6 | Permit Number 776939 | 6002377.91546 | 2088944.75079 | 37.7159792979937 | -122.433713076995 | (37.7159792979937, -122.433713076995) | 9 | 7 | 6 | 28861 | 5 | |
194434 | 37829 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 450X Moscow St | 17 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:54:00 AM | 3 | 3x3 | Permit Number 40134 | 6003878.28183 | 2090416.42534 | 37.7201052157501 | -122.428631950629 | (37.7201052157501, -122.428631950629) | 9 | 7 | 6 | 28861 | 5 |
194433 | 211684 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780277 | 5995309.61761 | 2090529.04665 | 37.7199257893373 | -122.458258879737 | (37.7199257893373, -122.458258879737) | 9 | 8 | 6 | 28861 | 24 | |
194432 | 15774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4800 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773279 | 6001280.0938 | 2090832.0581 | 37.7210990656339 | -122.437642741249 | (37.7210990656339, -122.437642741249) | 9 | 7 | 6 | 28861 | 25 | |
194430 | 206231 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1283 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995148.67652 | 2106807.2788 | 37.7646125217846 | -122.459993807784 | (37.7646125217846, -122.459993807784) | 15 | 5 | 11 | 56 | 12 | |||
194429 | 160546 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 755 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:38:00 AM | 3 | 4x5 | 6002026.63127 | 2089400.9055 | 37.7172118584185 | -122.434959882691 | (37.7172118584185, -122.434959882691) | 9 | 7 | 6 | 28861 | 5 | |
194428 | 253435 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 793 Vienna St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/18/2017 11:49:00 AM | 3 | 6002373 | 2088903 | 37.7158643806251 | -122.433727084844 | (37.7158643806251, -122.433727084844) | 9 | 7 | 6 | 28861 | 5 | |||
194427 | 15775 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4808 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2017 12:00:00 AM | 3 | 3X3 | Permit Number 773279 | 6001261.3736 | 2090797.0594 | 37.7210019026793 | -122.437704946106 | (37.7210019026793, -122.437704946106) | 9 | 7 | 6 | 28861 | 25 | |
194426 | 211685 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780277 | 5995307.7579 | 2090507.37878 | 37.7198661876486 | -122.458263740606 | (37.7198661876486, -122.458263740606) | 9 | 8 | 6 | 28861 | 24 | |
194424 | 62181 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 18 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2017 12:00:00 AM | 3 | Permit Number 778619 | 6000227.93753 | 2091768.58709 | 37.7236106804803 | -122.441346893068 | (37.7236106804803, -122.441346893068) | 9 | 7 | 6 | 28861 | 25 | |
194423 | 15800 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4950 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2018 02:11:00 PM | 3 | 4x4 | 6000889.9210477 | 2090200.0223298 | 37.7193414459012 | -122.438946180066 | (37.7193414459012, -122.438946180066) | 9 | 7 | 6 | 28861 | 25 | ||
194422 | 37823 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:49:00 AM | 3 | 3x3 | Permit Number 40134 | 6003922.69393 | 2090463.29382 | 37.7202364196636 | -122.428481771941 | (37.7202364196636, -122.428481771941) | 9 | 7 | 6 | 28861 | 5 |
194421 | 257937 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 430 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6005729.4209 | 2111051.1148 | 37.7768679337671 | -122.423699563703 | (37.7768679337671, -122.423699563703) | 7 | 9 | 11 | 28852 | 10 | ||
194420 | 265068 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 500 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.434129316516 | (37.7179540086612, -122.434129316516) | 9 | 7 | 6 | 28861 | 5 | |||
194419 | 179076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 09:01:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
194416 | 179075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2017 08:37:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
194415 | 178030 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 745 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 10:06:00 AM | 3 | Width 3ft | 6003911.3035 | 2091023.37584 | 37.7217736371229 | -122.428561047149 | (37.7217736371229, -122.428561047149) | 9 | 7 | 6 | 28861 | 5 | |
194414 | 160553 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 490 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:20:00 PM | 3 | Width 0ft | 6002152 | 2089716 | 37.7180841555313 | -122.434549060041 | (37.7180841555313, -122.434549060041) | 9 | 7 | 6 | 28861 | 5 | |
194413 | 265067 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 500 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.434129316516 | (37.7179540086612, -122.434129316516) | 9 | 7 | 6 | 28861 | 5 | |||
194412 | 265063 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 475@ STILLMAN 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013048.0931 | 2112046.23235 | 37.7800107102631 | -122.398451730656 | (37.7800107102631, -122.398451730656) | 6 | 2 | 9 | 28856 | 34 | |||||
194411 | 236860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 785228 | 5996892.19398 | 2106024.42834 | 37.7625631359112 | -122.453906940775 | (37.7625631359112, -122.453906940775) | 15 | 5 | 11 | 29492 | 12 | ||
194409 | 176258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 09:09:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
194405 | 265066 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 475@ STILLMAN 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013048.0931 | 2112046.23235 | 37.7800107102631 | -122.398451730656 | (37.7800107102631, -122.398451730656) | 6 | 2 | 9 | 28856 | 34 | |||||
194404 | 162800 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 37 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2020 12:00:00 AM | 3 | 4x6 | 5996614.18155 | 2090524.98833 | 37.7199895242736 | -122.453749186181 | (37.7199895242736, -122.453749186181) | 9 | 8 | 6 | 28861 | 24 | ||
194399 | 183700 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1351 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
194398 | 162836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2020 12:00:00 AM | 0 | 4x6 | 5996489.45825 | 2090475.5577 | 37.7198466480955 | -122.454176740991 | (37.7198466480955, -122.454176740991) | 9 | 8 | 6 | 28861 | 24 | |
194397 | 160660 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 118 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6001728.7088 | 2090784.69907 | 37.7209945256629 | -122.436088625395 | (37.7209945256629, -122.436088625395) | 9 | 7 | 6 | 28861 | 5 | ||
194395 | 183689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1351 42nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
194394 | 160700 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 932 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6003612.41439 | 2089600.12112 | 37.7178487735724 | -122.429492779881 | (37.7178487735724, -122.429492779881) | 9 | 7 | 6 | 28861 | 5 | ||
194393 | 254878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3156 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:28:00 AM | 3 | 3x6 | 5995145 | 2086533 | 37.708944125162 | -122.458538785751 | (37.708944125162, -122.458538785751) | 9 | 8 | 6 | 28861 | 25 | ||
194392 | 162798 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 107 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996432.70685 | 2090525.92628 | 37.7199816938867 | -122.454376546047 | (37.7199816938867, -122.454376546047) | 9 | 8 | 6 | 28861 | 24 | ||
194391 | 109904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | 8 | 2 | 9 | 28853 | 19 | |
194390 | 8397 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6004036.9348 | 2113953.0096 | 37.7847401317276 | -122.429761413143 | (37.7847401317276, -122.429761413143) | 13 | 9 | 11 | 29490 | 41 | |||
194388 | 162793 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 201 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996142.86432 | 2090531.62526 | 37.7199807154151 | -122.455378837768 | (37.7199807154151, -122.455378837768) | 9 | 8 | 6 | 28861 | 24 | ||
194387 | 183688 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1351 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
194386 | 73728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2020 11:22:00 AM | 3 | Permit Number 782600 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) | 3 | 1 | 10 | 308 | 23 | |
194385 | 115926 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:25:00 AM | 3 | 3x3 | 6014797.50176 | 2113407.35792 | 37.7838453529251 | -122.392494926324 | (37.7838453529251, -122.392494926324) | 6 | 2 | 9 | 28856 | 6 | ||
194384 | 254279 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 12/24/2020 01:32:00 PM | 3 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||
194383 | 170708 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 77 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6000579.72538 | 2092917.63724 | 37.7267857432424 | -122.440213187895 | (37.7267857432424, -122.440213187895) | 9 | 7 | 6 | 28861 | 25 | ||
194382 | 259013 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 131 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996343 | 2090506 | 37.7199218359789 | -122.45468519116 | (37.7199218359789, -122.45468519116) | 9 | 8 | 6 | 28861 | 24 | ||
194381 | 259007 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 44 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x4 | 5996586 | 2090578 | 37.720133466152 | -122.453850425827 | (37.720133466152, -122.453850425827) | 9 | 8 | 6 | 28861 | 24 | ||
194379 | 68392 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.04413 | 37.7296331848184 | -122.436677841421 | (37.7296331848184, -122.436677841421) | 9 | 7 | 6 | 28861 | 25 |
194378 | 162678 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 208 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996153.38061 | 2090571.45956 | 37.7200906944144 | -122.455345364123 | (37.7200906944144, -122.455345364123) | 9 | 8 | 6 | 28861 | 24 | ||
194377 | 171274 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 134 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | Width 3ft | 6004391.75762 | 2092740.75057 | 37.726516347746 | -122.427022498699 | (37.726516347746, -122.427022498699) | 9 | 7 | 6 | 28861 | 5 | ||
194376 | 171271 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6004457.49043 | 2092972.68503 | 37.7271569051579 | -122.426811773162 | (37.7271569051579, -122.426811773162) | 9 | 7 | 6 | 28861 | 5 | ||
194375 | 206127 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 4 | Width 3ft | 5995066.94571 | 2106670.30306 | 37.7642317209355 | -122.460266565852 | (37.7642317209355, -122.460266565852) | 15 | 5 | 11 | 56 | 12 | ||
194373 | 53965 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | Permit Number 9680 | 6013049.65631 | 2119205.04164 | 37.799667209323 | -122.39894891638 | (37.799667209323, -122.39894891638) | 3 | 1 | 10 | 28860 | 6 |
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) );