Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57041 | 57041 | 98796 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.40874722700701 | (37.7940014192822, -122.408747227007) | |
72352 | 72352 | 98801 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950@Washington Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010237.16405 | 2117207.30409 | 37.794024789059996 | -122.408540211182 | (37.79402478906, -122.408540211182) | |
74620 | 74620 | 98800 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950@Washington Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010265.98354 | 2117209.83013 | 37.7940333389111 | -122.408440670611 | (37.7940333389111, -122.408440670611) | |
115140 | 115140 | 98795 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.794749768385294 | -122.40882353278799 | (37.7947497683853, -122.408823532788) | |||
127158 | 127158 | 98799 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950@Washington Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.794749768385294 | -122.40882353278799 | (37.7947497683853, -122.408823532788) | ||
158337 | 158337 | 98798 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 950@Washington Clay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 22 | 3x3 | Permit Number 768771 | 6010098.5697800005 | 2117188.54171 | 37.7939655093431 | -122.409018439172 | (37.7939655093431, -122.409018439172) | |
178704 | 178704 | 98797 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950@Washington Clay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010116.35805 | 2117191.91562 | 37.793975769724796 | -122.408957127878 | (37.7939757697248, -122.408957127878) | |
89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
92075 | 92075 | 111588 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
119702 | 119702 | 111096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 15 | 5992079.0 | 2088073.0 | 37.712995910736204 | -122.46924723728901 | (37.7129959107362, -122.469247237289) | |||
77610 | 77610 | 109992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
83876 | 83876 | 109990 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
85949 | 85949 | 109996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
89691 | 89691 | 109988 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
90177 | 90177 | 109991 | Undocumented 2 | Quercus spp :: Oak 297 | 501X Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
92640 | 92640 | 109986 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
93134 | 93134 | 98908 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
95046 | 95046 | 109987 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
106116 | 106116 | 109995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
109915 | 109915 | 109999 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501X Shotwell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | ||||
121169 | 121169 | 109989 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
124070 | 124070 | 98909 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
124316 | 124316 | 109993 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
128369 | 128369 | 109998 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501X Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | ||||
142889 | 142889 | 109994 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
104559 | 104559 | 114737 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW for City Agency 10 | DPW 4 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
51360 | 51360 | 110401 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 419X 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 27 | 3x3 | 5990271.90904 | 2112469.3758 | 37.779877404965504 | -122.4772748837 | (37.7798774049655, -122.4772748837) | ||
132930 | 132930 | 110400 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 419X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 28 | 3x3 | 5990269.5497 | 2112500.03817 | 37.77996145844129 | -122.477285287094 | (37.7799614584413, -122.477285287094) | ||
101265 | 101265 | 110403 | Undocumented 2 | Ficus laurel :: 256 | 419X 18TH AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 22 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | ||
108530 | 108530 | 110402 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
115819 | 115819 | 110406 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
125272 | 125272 | 110420 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
144668 | 144668 | 110414 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
88711 | 88711 | 113813 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4101x 25TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
94059 | 94059 | 113817 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 02/16/2016 06:00:00 AM | 3 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
95213 | 95213 | 113810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |||
96370 | 96370 | 113818 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 02/16/2016 05:57:00 AM | 3 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
96735 | 96735 | 113809 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 06/15/2016 07:36:00 AM | 3 | 5x5 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
98563 | 98563 | 113820 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 4101x 25TH ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 10 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
101061 | 101061 | 113808 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4101x 25TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
105585 | 105585 | 113819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4101x 25TH ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 7 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
106701 | 106701 | 113812 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 1 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
122616 | 122616 | 113811 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4101x 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
124026 | 124026 | 113821 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4101x 25TH ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 10 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
124753 | 124753 | 113814 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
140997 | 140997 | 113815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4101x 25TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 8 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
141271 | 141271 | 113816 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4101x 25TH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 10 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
143896 | 143896 | 113822 | Undocumented 2 | Melaleuca spp :: Melaleuca spp 130 | 4101x 25TH ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 7 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
23495 | 23495 | 49666 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000245.17413 | 2120665.11682 | 37.8029543681198 | -122.443361894237 | (37.8029543681198, -122.443361894237) | ||
44297 | 44297 | 49663 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 7 | Permit Number 46510 | 6000228.83335 | 2120782.17575 | 37.8032748487093 | -122.44342685496599 | (37.8032748487093, -122.443426854966) | ||
46479 | 46479 | 49665 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000243.34961 | 2120687.49551 | 37.8030157099616 | -122.443369816371 | (37.8030157099616, -122.443369816371) | ||
61973 | 61973 | 47415 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45326 | 6000240.55787 | 2120707.38669 | 37.8030701666099 | -122.443380906816 | (37.8030701666099, -122.443380906816) | ||
74165 | 74165 | 49662 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000225.92137 | 2120807.31261 | 37.803343701723 | -122.44343873861 | (37.803343701723, -122.44343873861) | ||
133148 | 133148 | 49664 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3630 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 26 | Permit Number 46510 | 6000238.4271 | 2120737.0669299997 | 37.80315153908379 | -122.44339041353399 | (37.8031515390838, -122.443390413534) | ||
158201 | 158201 | 49667 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 8 | Permit Number 46510 | 6000232.6794300005 | 2120757.93136 | 37.8032084994456 | -122.443411803017 | (37.8032084994456, -122.443411803017) | ||
187997 | 187997 | 49658 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 3630 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 1 | Permit Number 46510 | 6000258.18089 | 2120685.13581 | 37.8030100766084 | -122.44331832298401 | (37.8030100766084, -122.443318322984) | ||
1586 | 1586 | 98725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006216.75471 | 2111460.37935 | 37.7780191723707 | -122.42204280683501 | (37.7780191723707, -122.422042806835) | |||
2933 | 2933 | 98726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006198.51355 | 2111464.4034 | 37.7780291926159 | -122.422106195562 | (37.7780291926159, -122.422106195562) | |||
3428 | 3428 | 98728 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006156.19882 | 2111456.14926 | 37.778004142027 | -122.42225199096 | (37.778004142027, -122.42225199096) | |||
6003 | 6003 | 98729 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006140.89781 | 2111454.63858 | 37.7779991309825 | -122.42230481531901 | (37.7779991309825, -122.422304815319) | |||
6064 | 6064 | 98727 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006176.94483 | 2111455.11485 | 37.7780024719703 | -122.422180149508 | (37.7780024719703, -122.422180149508) | |||
9030 | 9030 | 98730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006126.244940001 | 2111454.93961 | 37.777999130991205 | -122.42235552627899 | (37.7779991309912, -122.422355526279) | |||
83093 | 83093 | 98734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 14 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
89481 | 89481 | 98733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
107050 | 107050 | 98735 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
113650 | 113650 | 98731 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
145660 | 145660 | 98732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 12 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | |||
1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
5598 | 5598 | 103666 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
7764 | 7764 | 103662 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
8197 | 8197 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
8408 | 8408 | 103664 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
10665 | 10665 | 103665 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
11212 | 11212 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
11415 | 11415 | 103667 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
12113 | 12113 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
12885 | 12885 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
15949 | 15949 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
109029 | 109029 | 108973 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3485X SAN BRUNO AVE | 1 | Median : Yard 3 | Tree 1 | DPW for City Agency 10 | 6011510.0 | 2091910.0 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | |||||
37389 | 37389 | 95036 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
44837 | 44837 | 95043 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 9 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
82784 | 82784 | 95034 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
83793 | 83793 | 95035 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
84126 | 84126 | 95033 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
91879 | 91879 | 95040 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
94908 | 94908 | 95038 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
104986 | 104986 | 95041 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
105794 | 105794 | 95046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
108162 | 108162 | 95039 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
111208 | 111208 | 95042 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 11 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
115106 | 115106 | 95044 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
83640 | 83640 | 101808 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3149 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 02/03/2015 12:00:00 AM | 3 | 3x3 | 6008718.2 | 2100791.7 | 37.7488661984732 | -122.41263499808599 | (37.7488661984732, -122.412634998086) | ||
79317 | 79317 | 95366 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.42518303152201 | (37.8041229057048, -122.425183031522) | ||
62496 | 62496 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
98122 | 98122 | 103656 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
100981 | 100981 | 103655 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
121059 | 121059 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
125996 | 125996 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
43480 | 43480 | 111380 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | MTA 10 | 24 | 3x3 | 5999454.0 | 2091552.0 | 37.7229718629586 | -122.44400669588998 | (37.7229718629586, -122.44400669589) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");