trees
27,746 rows where qCaretaker_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 | ||||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | ||
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 | ||||
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 | |||
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 | |
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 | |
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 | ||
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 | |||
194380 | 255779 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 45 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/08/2017 12:00:00 AM | 3 | 3x3 | 5999808 | 2089058 | 37.7161440949055 | -122.442604012325 | (37.7161440949055, -122.442604012325) | 9 | 7 | 6 | 28861 | 25 | |
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 | ||
194371 | 205154 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2008 12:00:00 AM | 7 | Width 3ft | 5995104.98822 | 2106728.27185 | 37.7643930764078 | -122.460139188574 | (37.7643930764078, -122.460139188574) | 15 | 5 | 11 | 56 | 12 | ||
194370 | 258049 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 576 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5x6 | Cross streets are also Jasper to Stockton; site is directly across from Via Ferlinghetti (alley) | 6010185.99879 | 2119580.18301 | 37.8005372695328 | -122.408884743211 | (37.8005372695328, -122.408884743211) | 3 | 1 | 10 | 308 | 23 | |||
194368 | 206128 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 2 | Width 3ft | 5995094.6325 | 2106669.72305 | 37.7642317209303 | -122.46017076378 | (37.7642317209303, -122.46017076378) | 15 | 5 | 11 | 56 | 12 | ||
194366 | 265027 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2623 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5997622 | 2089116 | 37.7161784966097 | -122.450164015076 | (37.7161784966097, -122.450164015076) | 9 | 8 | 6 | 28861 | 24 | |||
194361 | 265029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
194348 | 265030 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
194340 | 265026 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/07/2001 12:00:00 AM | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||
194323 | 264998 | DPW Maintained 1 | :: Tree 573 | 712 Francisco St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007843 | 2120971 | 37.8042245839852 | -122.417091095202 | (37.8042245839852, -122.417091095202) | 5 | 1 | 1 | 308 | 32 | |||||
194317 | 264994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194314 | 214535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194310 | 264995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 780527 | 5993564.21584 | 2106614.23574 | 37.7639912206449 | -122.465459964506 | (37.7639912206449, -122.465459964506) | 1 | 8 | 11 | 56 | 12 | |
194301 | 262312 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 1425x Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013385 | 2096525 | 37.7374115554262 | -122.396198099694 | (37.7374115554262, -122.396198099694) | 10 | 3 | 8 | 58 | 1 | ||||
194286 | 171103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001233.28844 | 2091580.94986 | 37.7231526917255 | -122.437858144945 | (37.7231526917255, -122.437858144945) | 9 | 7 | 6 | 28861 | 25 | ||
194285 | 171104 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001222.88972 | 2091557.90636 | 37.7230888281699 | -122.437892441496 | (37.7230888281699, -122.437892441496) | 9 | 7 | 6 | 28861 | 25 | ||
194284 | 4966 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000791.48606 | 2099581.9209 | 37.7450963646197 | -122.439958774198 | (37.7450963646197, -122.439958774198) | 2 | 7 | 5 | 63 | 7 | ||
194280 | 171105 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1802 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 4ft | Permit Number 785586 | 6001198.95061 | 2091509.82624 | 37.7229554497111 | -122.437971751813 | (37.7229554497111, -122.437971751813) | 9 | 7 | 6 | 28861 | 25 | ||
194279 | 249475 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 18 | Permit Number 787880 | 6006389.52859 | 2114780.40651 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | 13 | 9 | 1 | 28858 | 21 | |||
194271 | 15783 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 03:01:00 PM | 3 | 3X3 | Permit Number 785142 | 6001146.6106 | 2090614.741 | 37.7204947713768 | -122.43808859365 | (37.7204947713768, -122.43808859365) | 9 | 7 | 6 | 28861 | 25 | |
194268 | 15788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2020 12:00:00 AM | 12 | 3X3 | Permit Number 785142 | 6001054.6013 | 2090473.5841 | 37.7201019532463 | -122.438396531841 | (37.7201019532463, -122.438396531841) | 9 | 7 | 6 | 28861 | 25 | |
194266 | 15786 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4840 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2013 12:00:00 AM | 12 | 3x3 | Permit Number 785142 | 6001077.7653 | 2090502.844 | 37.7201836118857 | -122.43831855702 | (37.7201836118857, -122.43831855702) | 9 | 7 | 6 | 28861 | 25 | |
194263 | 15782 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4840 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/2015 12:38:00 PM | 3 | 3X3 | Permit Number 785142 | 6001159.6334 | 2090631.0194 | 37.7205402088092 | -122.438044743528 | (37.7205402088092, -122.438044743528) | 9 | 7 | 6 | 28861 | 25 | |
194261 | 15784 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 02:53:00 PM | 3 | 3X3 | Permit Number 785142 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | 9 | 7 | 6 | 28861 | 25 | |
194258 | 175137 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1802 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 4ft | Permit Number 785586 | 6001243.74865 | 2091600.63197 | 37.7232073291514 | -122.437823395139 | (37.7232073291514, -122.437823395139) | 9 | 7 | 6 | 28861 | 25 | ||
194257 | 4968 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000815.91312 | 2099549.13893 | 37.7450077436274 | -122.439871959934 | (37.7450077436274, -122.439871959934) | 2 | 7 | 5 | 63 | 7 | ||
194253 | 93351 | DPW Maintained 1 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 409 | 2100X Turk Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771488 | -122.443750351573 | (37.779314771488, -122.443750351573) | 15 | 5 | 1 | 29490 | 16 | ||
194248 | 1915 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 Bell Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016631.8921901 | 2095265.2766477 | 37.7341327371653 | -122.384884235042 | (37.7341327371653, -122.384884235042) | 10 | 3 | 8 | 58 | 1 | |||
194232 | 18350 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 459 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2015 06:59:00 AM | 3 | 3x3 | 6010395.85662 | 2106161.99214 | 37.7637058369709 | -122.407212144541 | (37.7637058369709, -122.407212144541) | 8 | 4 | 8 | 28859 | 19 | ||
194226 | 20570 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
194225 | 21968 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2580 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/1995 12:00:00 AM | 3 | 3x3 | 6015815.49965 | 2103569.56022 | 37.7568893941329 | -122.38828616762 | (37.7568893941329, -122.38828616762) | 10 | 3 | 8 | 28856 | 29 | ||
194223 | 14733 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 912X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | |||
194222 | 119595 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005470 | 2110737 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | 7 | 9 | 11 | 28852 | 10 | ||||
194215 | 14371 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2324 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002694.0419 | 2106348.375 | 37.7637835565652 | -122.433863631274 | (37.7637835565652, -122.433863631274) | 15 | 4 | 5 | 28862 | 3 | |||
194214 | 17745 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1600X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006152.6648 | 2115617.75127 | 37.7894306797229 | -122.422560011429 | (37.7894306797229, -122.422560011429) | 13 | 9 | 1 | 28858 | 41 | |||
194201 | 11511 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 101X Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5 | 6018385.91854 | 2096547.1526 | 37.7377493756286 | -122.378908940096 | (37.7377493756286, -122.378908940096) | 10 | 3 | 8 | 58 | 1 | |||
194193 | 108718 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1103 GOUGH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | 7 | 9 | 11 | 28858 | 41 | ||||
194191 | 29620 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 900X Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991161.61567 | 2090864.54697 | 37.7206077605242 | -122.472621393665 | (37.7206077605242, -122.472621393665) | 9 | 8 | 4 | 64 | 40 | ||
194188 | 96748 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 399X Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 1.5x2 | 6003700 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | 2 | 4 | 5 | 28862 | 3 | |||
194184 | 449 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 700x 23rd Ave | 9 | Median : Cutout | Tree | DPW 1 | 12 | 8-HOA | 5988819.75093 | 2110337.06115 | 37.7739383014913 | -122.482142223603 | (37.7739383014913, -122.482142223603) | 11 | 6 | 2 | 55 | 26 | |||
194183 | 16195 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 482 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998892.4801472 | 2094730.9663599 | 37.7316685147685 | -122.446176305405 | (37.7316685147685, -122.446176305405) | 9 | 7 | 4 | 59 | 40 | |||
194174 | 7713 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2005 12:00:00 AM | 3 | 3x3 | 6006483.35851 | 2110441.04443 | 37.7752353575277 | -122.421048133036 | (37.7752353575277, -122.421048133036) | 7 | 9 | 11 | 28852 | 10 | ||
194172 | 240286 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 5200x Diamond Heights Blvd | 42 | Median : Yard | Tree | DPW 1 | 2 | 6001709.51148 | 2098788.78469 | 37.7429708160432 | -122.436727644972 | (37.7429708160432, -122.436727644972) | 2 | 7 | 5 | 63 | 7 | ||||
194169 | 89654 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3021 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989260.15494 | 2111906.26324 | 37.7782725005109 | -122.480733712855 | (37.7782725005109, -122.480733712855) | 11 | 6 | 2 | 55 | 26 | ||
194161 | 23222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 655X Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6006626.36739 | 2112726.37233 | 37.7815183756303 | -122.420715704793 | (37.7815183756303, -122.420715704793) | 7 | 9 | 11 | 28852 | 41 | |||
194159 | 10077 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005621.78486 | 2105416.82041 | 37.7613914334809 | -122.423671214664 | (37.7613914334809, -122.423671214664) | 2 | 4 | 5 | 28859 | 19 | |||
194158 | 22602 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 871 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005851.84947 | 2112745.07106 | 37.7815260346282 | -122.423396497843 | (37.7815260346282, -122.423396497843) | 7 | 9 | 11 | 28852 | 41 | |||
194140 | 2459 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1801X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1998 12:00:00 AM | 3 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.7865210759478 | -122.430070036959 | (37.7865210759478, -122.430070036959) | 13 | 9 | 11 | 29490 | 27 | ||
194132 | 90370 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 401 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5994385.188155 | 2111417.285678 | 37.7772264433422 | -122.462968981972 | (37.7772264433422, -122.462968981972) | 11 | 6 | 2 | 54 | 11 | ||
194124 | 254846 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 790 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5984182.54238 | 2110499.30676 | 37.774112974271 | -122.498194837344 | (37.774112974271, -122.498194837344) | 11 | 6 | 2 | 55 | 26 | ||
194116 | 972 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1599 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6001888.30681 | 2092957.56794 | 37.7269697994111 | -122.435692320241 | (37.7269697994111, -122.435692320241) | 9 | 7 | 6 | 28861 | 25 | |||
194105 | 2593 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1717 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005272.31567 | 2115067.90207 | 37.7878712268979 | -122.425566774536 | (37.7878712268979, -122.425566774536) | 13 | 9 | 11 | 28858 | 27 | |||
194083 | 4978 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5200X Diamond Heights Blvd | 14 | Median : Cutout | Tree | DPW 1 | 48 | 12 | 6001055.51411 | 2099325.52296 | 37.7444073831894 | -122.439027441656 | (37.7444073831894, -122.439027441656) | 2 | 7 | 5 | 63 | 7 | |||
194078 | 26818 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1310 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001324.9368 | 2112970.4697 | 37.7818883840034 | -122.439073567606 | (37.7818883840034, -122.439073567606) | 15 | 5 | 11 | 29490 | 41 | |||
194072 | 29516 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1900X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6016223.32775 | 2092631.55928 | 37.7268784667079 | -122.386113243292 | (37.7268784667079, -122.386113243292) | 10 | 3 | 8 | 58 | 1 | ||
194069 | 9286 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 13X George Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017208.5497632 | 2094048.0250587 | 37.7308222832509 | -122.382805848563 | (37.7308222832509, -122.382805848563) | 10 | 3 | 8 | 58 | 1 | |||
194051 | 5069 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5541 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001780.21152 | 2097345.69555 | 37.7390124482591 | -122.436379924815 | (37.7390124482591, -122.436379924815) | 2 | 7 | 5 | 63 | 7 | |||
194047 | 90783 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3701X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984061.67765 | 2110354.79455 | 37.7737090977378 | -122.498602245888 | (37.7737090977378, -122.498602245888) | 11 | 6 | 2 | 55 | 26 | ||
194040 | 175614 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6011421.83278 | 2090628.04482 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | 10 | 7 | 8 | 309 | 28 | |||
194033 | 212143 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 650x Miramar Ave | 1 | Median : Yard | Tree | DPW 1 | 3 | 5995395.28868 | 2093711.39383 | 37.7286686754144 | -122.458192950462 | (37.7286686754144, -122.458192950462) | 9 | 7 | 4 | 28861 | 40 | ||||
194025 | 13640 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 579 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6012428.77503 | 2115545.54355 | 37.7895844826841 | -122.400840161846 | (37.7895844826841, -122.400840161846) | 12 | 2 | 9 | 28855 | 6 | |||
194016 | 18379 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 744 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/02/2005 12:00:00 AM | 3 | 3X4 | 6010385.67998 | 2104816.8587 | 37.7600118348065 | -122.407152518593 | (37.7600118348065, -122.407152518593) | 10 | 4 | 8 | 28859 | 19 | ||
194011 | 19212 | DPW Maintained 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 710X Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1998 12:00:00 AM | 3 | 3X3 | 6002366.0960506 | 2108316.0051988 | 37.7691675719148 | -122.435138635645 | (37.7691675719148, -122.435138635645) | 15 | 5 | 5 | 29492 | 9 | ||
194001 | 8648 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2800 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5998383.6283 | 2113204.2346 | 37.782362442714 | -122.449265934547 | (37.782362442714, -122.449265934547) | 15 | 6 | 1 | 54 | 31 | |||
193996 | 91442 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900X Portola Dr | 7 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 4x4 | 5996336.043197 | 2098916.600218 | 37.7430149203693 | -122.455316749086 | (37.7430149203693, -122.455316749086) | 9 | 7 | 4 | 59 | 40 | |||
193994 | 90675 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3808 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983782.70932 | 2110400.38504 | 37.7738179116671 | -122.499570595637 | (37.7738179116671, -122.499570595637) | 11 | 6 | 2 | 55 | 26 | ||
193993 | 24013 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 393 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 5991924.8305 | 2096676.2373 | 37.7366093650749 | -122.470406255119 | (37.7366093650749, -122.470406255119) | 1 | 8 | 4 | 59 | 40 | |||
193945 | 2569 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1616 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4X4 | 6005720.9755 | 2115211.89577 | 37.7882919383578 | -122.424024736347 | (37.7882919383578, -122.424024736347) | 13 | 9 | 1 | 28858 | 41 | |||
193930 | 10418 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1219X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 5999402.57096 | 2108712.61162 | 37.7700878253378 | -122.445417788957 | (37.7700878253378, -122.445417788957) | 15 | 5 | 11 | 29492 | 9 | |||
193925 | 1427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 65 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 5X5PL | 5995465.80895 | 2115602.75583 | 37.7887808090871 | -122.459534003067 | (37.7887808090871, -122.459534003067) | 11 | 6 | 1 | 54 | 11 | |||
193924 | 14229 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004655.4793 | 2108222.1981 | 37.7690397355533 | -122.427213099786 | (37.7690397355533, -122.427213099786) | 7 | 4 | 5 | 28862 | 3 | |||
193919 | 10634 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.430214699132 | (37.7760227838468, -122.430214699132) | 7 | 9 | 11 | 29492 | 10 | ||
193914 | 115028 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
193913 | 12078 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1241X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017245.0743814 | 2094442.9323579 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | 10 | 3 | 8 | 58 | 1 | |||
193910 | 85695 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6012881.28755 | 2114275.485576 | 37.7861224301769 | -122.399185316932 | (37.7861224301769, -122.399185316932) | 12 | 2 | 9 | 28855 | 6 | ||
193897 | 90817 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3145 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985785.77932 | 2110419.22548 | 37.7739869681874 | -122.492643140314 | (37.7739869681874, -122.492643140314) | 11 | 6 | 2 | 55 | 26 | ||
193892 | 96142 | DPW Maintained 1 | Tree(s) :: 17 | 1468X Innes Ave | 2 | Median : Yard | Tree | DPW 1 | 12 | 6016228.8 | 2096740.9 | 37.738162198215 | -122.386380713289 | (37.738162198215, -122.386380713289) | 10 | 3 | 8 | 58 | 1 | ||||
193891 | 105837 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100X SLOAT BLVD | 4 | Median : Yard | Tree | DPW 1 | 7 | 5984309 | 2095832 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | 1 | 8 | 3 | 64 | 35 | ||||
193872 | 18113 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1102X PORTOLA DR | 2 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 5995249 | 2098057 | 37.7405922403942 | -122.459013196083 | (37.7405922403942, -122.459013196083) | 1 | 7 | 4 | 59 | 40 |
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) );