Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102473 | 102473 | 95360 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
111421 | 111421 | 95362 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | ||
112944 | 112944 | 95359 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
114297 | 114297 | 95361 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
118079 | 118079 | 95358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 25 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
126442 | 126442 | 95363 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 20 | 3x3 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | ||
1043 | 1043 | 81845 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 04/28/2017 08:33:00 AM | 3 | 3x3 | Permit Number 50020 | 6007103.87391 | 2115697.8037 | 37.789704100621705 | -122.419274608151 | (37.7897041006217, -122.419274608151) |
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) | |||
2825 | 2825 | 81846 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) |
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) | |||
4610 | 4610 | 129875 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 771149 | 6000472.54237 | 2120960.44245 | 37.8037782163629 | -122.44259630138399 | (37.8037782163629, -122.442596301384) | |
4623 | 4623 | 129872 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 7 | Width 4ft | Permit Number 771149 | 6000353.54628 | 2120943.15919 | 37.803723977330996 | -122.44300685090401 | (37.803723977331, -122.443006850904) | ||
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) | |||
9748 | 9748 | 173655 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 100 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW for City Agency 10 | ||||||||||
9751 | 9751 | 173659 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 200 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW for City Agency 10 | 5993693.06683 | 2104628.21116 | 37.7585455452803 | -122.46487007071998 | (37.7585455452803, -122.46487007072) | |||||
12506 | 12506 | 98216 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.50150154301201 | (37.7576365448231, -122.501501543012) | ||
19689 | 19689 | 99005 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||||
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) | ||
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) | ||||
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) | ||
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) | |||
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) | ||
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) | |
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) | ||
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) | |
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) | ||
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) | |
78503 | 78503 | 98221 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501X 42nd Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 6 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
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) | ||
79502 | 79502 | 98996 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2190X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 3x3 | 6000702.0 | 2120685.0 | 37.803035002067396 | -122.441782472194 | (37.8030350020674, -122.441782472194) | |||
81617 | 81617 | 81843 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
82710 | 82710 | 99003 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||||
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) | ||||
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) | |||
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) | ||
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) | ||||
84926 | 84926 | 98219 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
88938 | 88938 | 82383 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 09/11/2012 12:00:00 AM | 3 | 3x3 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) | |
89194 | 89194 | 99308 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.49918869137501 | (37.7494969779561, -122.499188691375) | ||
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) | |||
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) | |||
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) | ||||
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) | |||
92792 | 92792 | 98222 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
93890 | 93890 | 98217 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
94016 | 94016 | 99008 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||||
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) | ||||
94914 | 94914 | 99004 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||||
94965 | 94965 | 99002 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |||
96054 | 96054 | 99000 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |||
97025 | 97025 | 81841 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
98857 | 98857 | 97214 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300X Claremont Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 12 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | ||||
100401 | 100401 | 81842 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
102667 | 102667 | 98999 | DPW Maintained 3 | Tristania conferta :: 79 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |
104962 | 104962 | 97215 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 20 | 4x12 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||
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) | |||
106760 | 106760 | 99309 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.49918869137501 | (37.7494969779561, -122.499188691375) | ||
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) | |||
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) | ||||
110121 | 110121 | 49668 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | Private 3 | 04/18/2011 12:00:00 AM | Permit Number 46510 | 6000239.54014865 | 2120711.44405841 | 37.8030812490195 | -122.44338472026199 | (37.8030812490195, -122.443384720262) | ||
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) | |||
111252 | 111252 | 81840 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
113315 | 113315 | 13091 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1439X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 08/02/2016 06:38:00 AM | 3 | 4x5 | 6005488.541730001 | 2119878.23932 | 37.8010914133698 | -122.425161084884 | (37.8010914133698, -122.425161084884) | ||
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) | |||
114359 | 114359 | 98998 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |||
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) | ||||
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) | |||
115219 | 115219 | 98995 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2190X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6000922.9 | 2115860.7 | 37.7898013277865 | -122.44067180053001 | (37.7898013277865, -122.44067180053) | ||||
118995 | 118995 | 97217 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 4 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 18 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | ||||
119065 | 119065 | 98218 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1501X 42nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 3 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
120277 | 120277 | 99001 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |||
120466 | 120466 | 99006 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||||
120505 | 120505 | 98220 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1501X 42nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
121378 | 121378 | 99007 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
123900 | 123900 | 98997 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | ||||
126814 | 126814 | 99009 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
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) | ||
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) | ||
141753 | 141753 | 81839 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
143072 | 143072 | 97216 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 3 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||||
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) | |||
145968 | 145968 | 98223 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1501X 42nd Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
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) | ||
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) | |
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) | ||
89093 | 89093 | 116527 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5732 GEARY BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | MTA 6 | DPW for City Agency 2 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
127092 | 127092 | 116522 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 324 08TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW for City Agency 2 | 8 | 3x3 | 5993416.0 | 2113304.0 | 37.7823509768718 | -122.466458848407 | (37.7823509768718, -122.466458848407) | ||
92 | 92 | 98091 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007129.633230001 | 2115568.12393 | 37.789349482642606 | -122.41917628075599 | (37.7893494826426, -122.419176280756) | ||
463 | 463 | 234072 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Width 3ft | 6011140.67766 | 2101759.7310900004 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | ||
590 | 590 | 98625 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002285.2374 | 2120040.8430000003 | 37.8013564005351 | -122.43625752618999 | (37.8013564005351, -122.43625752619) | ||
760 | 760 | 38424 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1451 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/24/2005 12:00:00 AM | 12 | 3x3 | Permit Number 48015 | 6007280.7970900005 | 2117415.82487 | 37.79443132398921 | -122.418784361633 | (37.7944313239892, -122.418784361633) |
1400 | 1400 | 235284 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.43653915428499 | (37.7591334867264, -122.436539154285) | ||
1405 | 1405 | 228661 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 13 | Width 3ft | 6001838.07707 | 2104669.16217 | 37.7591242363206 | -122.436703937943 | (37.7591242363206, -122.436703937943) | ||
1407 | 1407 | 220312 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/05/1995 12:00:00 AM | 15 | Width 3ft | 6002007.42492 | 2104678.29116 | 37.759158924972404 | -122.436118906483 | (37.7591589249724, -122.436118906483) |
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");