trees
163,064 rows where qCaretaker_id = 2 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194517 | 265144 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2166 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782839 | 5997501.55835 | 2109896.92898 | 37.773230951126 | -122.452078795234 | (37.773230951126, -122.452078795234) | 15 | 5 | 11 | 29492 | 16 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 194507 | 265147 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1362 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993998 | 2106231 | 37.7629639639015 | -122.463931825158 | (37.7629639639015, -122.463931825158) | 1 | 5 | 11 | 56 | 12 | ||||
| 194504 | 265143 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995416 | 2096422 | 37.7361125310636 | -122.458317465478 | (37.7361125310636, -122.458317465478) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | |||||
| 194501 | 265145 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2021 12:00:00 AM | 3 | 3x3 | Permit Number 782838 | 5997529.09133 | 2109900.74605 | 37.7732430089022 | -122.451983830898 | (37.7732430089022, -122.451983830898) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | |||
| 194499 | 265142 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 75X Cedro Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5992440 | 2092965 | 37.7264490050903 | -122.468355192232 | (37.7264490050903, -122.468355192232) | 9 | 8 | 4 | 59 | 40 | ||||
| 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 | ||
| 194494 | 264749 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 1339 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785207 | 5991088 | 2106284 | 37.7629413570223 | -122.474000279679 | (37.7629413570223, -122.474000279679) | 1 | 8 | 11 | 56 | 12 | |
| 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 | ||
| 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 | ||||
| 194481 | 256359 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2655 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 3x3 | Permit Number 48401 | 6005661 | 2119519 | 37.8001147748179 | -122.424538736295 | (37.8001147748179, -122.424538736295) | 13 | 9 | 1 | 57 | 17 | ||
| 194479 | 265136 | Undocumented 4 | :: Tree 573 | 100 Winston Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | ||||
| 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 | ||
| 194475 | 207568 | Prune Opt Out 3 | Eriobotrya deflexa :: Bronze Loquat 8 | 1430 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | Permit Number 788015 | 5993375.17513 | 2105731.36286 | 37.7615561785078 | -122.466049635587 | (37.7615561785078, -122.466049635587) | 1 | 8 | 11 | 56 | 12 | ||
| 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 | ||
| 194470 | 254768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 415 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781626 | 5993212 | 2089957 | 37.7182343284954 | -122.4654680237 | (37.7182343284954, -122.4654680237) | 9 | 8 | 6 | 64 | 24 |
| 194467 | 265133 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 2166 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/11/2021 12:00:00 AM | 3 | 3x3 | Permit Number 783123 | 5983589.67085 | 2100408.11005 | 37.7463706120083 | -122.499499736486 | (37.7463706120083, -122.499499736486) | 1 | 8 | 3 | 29491 | 35 | |
| 194466 | 265098 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194465 | 63910 | Prune Opt Out 3 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1991 12:00:00 AM | 14 | Permit Number 788005 | 6009385.3216 | 2121038.8544 | 37.8044975370449 | -122.411758548847 | (37.8044975370449, -122.411758548847) | 3 | 1 | 10 | 308 | 23 | ||
| 194464 | 265097 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194463 | 265099 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194462 | 233115 | Prune Opt Out 3 | Olea europaea :: Olive Tree 9 | 29 Kronquist Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | Permit Number 788008 | 6002251.64499 | 2100180.50663 | 37.7468229532305 | -122.434952608978 | (37.7468229532305, -122.434952608978) | 2 | 7 | 5 | 63 | 22 | ||
| 194461 | 265095 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 1100 Junipero Serra Blvd | 1 | Side Yard : Cutout | Tree | Private 2 | 10x10 | 5991104 | 2090006 | 37.7182470667789 | -122.472757983106 | (37.7182470667789, -122.472757983106) | 9 | 8 | 4 | 64 | 40 | ||||
| 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 | |||
| 194459 | 248440 | Prune Opt Out 3 | Pittosporum undulatum :: Victorian Box 36 | 724 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Permit Number 788001 | 5997627.8337 | 2107978.5557 | 37.7679708233346 | -122.451503597918 | (37.7679708233346, -122.451503597918) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |||
| 194457 | 233114 | Prune Opt Out 3 | Olea europaea :: Olive Tree 9 | 29 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | Permit Number 788008 | 6002253.24641 | 2100155.04403 | 37.7467531298542 | -122.434945250724 | (37.7467531298542, -122.434945250724) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | |
| 194453 | 265096 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 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 | |||
| 194450 | 234943 | Prune Opt Out 3 | Pittosporum undulatum :: Victorian Box 36 | 4339 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 788007 | 6001670.90597 | 2100562.91239 | 37.7478399578525 | -122.436988118323 | (37.7478399578525, -122.436988118323) | 2 | 4 | 5 | 63 | 22 | ||
| 194449 | 262095 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3550 Cesar Chavez St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785078 | 6006203 | 2100616 | 37.7482422814736 | -122.421320098122 | (37.7482422814736, -122.421320098122) | 2 | 4 | 5 | 28859 | 19 | |||
| 194448 | 265090 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 784731 | 5994883.78198 | 2089306.03852 | 37.7165432206381 | -122.459642300713 | (37.7165432206381, -122.459642300713) | 9 | 8 | 6 | 28861 | 24 | |
| 194447 | 265091 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3550 Cesar Chavez St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6006085.39303 | 2100598.74488 | 37.7481882715663 | -122.421725554794 | (37.7481882715663, -122.421725554794) | 2 | 4 | 5 | 28859 | 19 | |
| 194446 | 4132 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3550 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6006390.9849 | 2100603.33536 | 37.7482181038931 | -122.420669151754 | (37.7482181038931, -122.420669151754) | 2 | 4 | 5 | 28859 | 19 | |
| 194443 | 231199 | Permitted Site 7 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3636 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785078 | 6005923.7545 | 2100590.88969 | 37.7481575867153 | -122.422283938475 | (37.7481575867153, -122.422283938475) | 2 | 4 | 5 | 28859 | 19 | |
| 194442 | 221796 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | Permit Number 787981 | 6004110.94859 | 2110346.00561 | 37.7748403836965 | -122.429248059072 | (37.7748403836965, -122.429248059072) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | ||
| 194440 | 221797 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | Permit Number 787981 | 6004113.21358 | 2110335.22701 | 37.7748109165297 | -122.429239455258 | (37.7748109165297, -122.429239455258) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 |
| 194438 | 225616 | Prune Opt Out 3 | Ginkgo biloba :: Maidenhair Tree 22 | 15 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 787984 | 6001852.25626 | 2097023.92467 | 37.7381330336073 | -122.436107807923 | (37.7381330336073, -122.436107807923) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | ||
| 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 | |
| 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 | |
| 194431 | 265089 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 747 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002550 | 2089172 | 37.7166130372881 | -122.433134500018 | (37.7166130372881, -122.433134500018) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |
| 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 | |
| 194425 | 221795 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 438 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | Permit Number 787981 | 6004107.34969 | 2110372.49722 | 37.7749129194169 | -122.42926239785 | (37.7749129194169, -122.42926239785) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |
| 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 | ||
| 194418 | 265072 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2027 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5983517.97374 | 2101348.17171 | 37.7489475550359 | -122.499817124771 | (37.7489475550359, -122.499817124771) | 1 | 8 | 3 | 29491 | 35 | ||||
| 194417 | 265061 | Section 806 (d) 5 | Prunus serrulata :: Ornamental Cherry 84 | 48 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | ||
| 194410 | 265060 | Section 806 (d) 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 48 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/28/2020 12:00:00 AM | 3 | 6x6 | Permit Number 782253 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | |
| 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 | ||
| 194408 | 254760 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 170 Arch St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781604 | 5992729.03192 | 2088323.37985 | 37.7137209347968 | -122.467018722529 | (37.7137209347968, -122.467018722529) | 9 | 8 | 6 | 64 | 24 |
| 194407 | 265071 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 430 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000887 | 2092304 | 37.7251183251209 | -122.439106989741 | (37.7251183251209, -122.439106989741) | 9 | 7 | 6 | 28861 | 25 | ||||
| 194406 | 265062 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 285 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992682 | 2089081 | 37.7157984624799 | -122.46723633367 | (37.7157984624799, -122.46723633367) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | ||
| 194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 194402 | 265049 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1595 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 5x5 | 5999367.57953 | 2109424.62482 | 37.7720408355473 | -122.445590032014 | (37.7720408355473, -122.445590032014) | 15 | 5 | 11 | 29492 | 9 | ||
| 194401 | 265056 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
| 194400 | 265055 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
| 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 | ||
| 194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 |
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) );