trees
665 rows where qSpecies_id = 89 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77941 | 125515 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | 5 | 1 | 10 | 308 | 32 | |||
159811 | 125516 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008584.50737 | 2119027.0667 | 37.7989287139392 | -122.414387412476 | (37.7989287139392, -122.414387412476) | 5 | 1 | 10 | 308 | 32 | |||
50122 | 125517 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008575.41519 | 2119026.37821 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | 5 | 1 | 10 | 308 | 32 | |||
146670 | 125518 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008573.08581 | 2119026.43144 | 37.7989263280573 | -122.414426890005 | (37.7989263280573, -122.414426890005) | 5 | 1 | 10 | 308 | 32 | |||
95831 | 125519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.7989271266439 | -122.414431021472 | (37.7989271266439, -122.414431021472) | 5 | 1 | 10 | 308 | 32 | |||
24223 | 125520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.7989262722777 | -122.414435828363 | (37.7989262722777, -122.414435828363) | 5 | 1 | 10 | 308 | 32 | |||
10180 | 125521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008568.41134 | 2119026.06198 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | 5 | 1 | 10 | 308 | 32 | |||
88253 | 125522 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | 5 | 1 | 1 | 308 | 32 | |||
64506 | 125523 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 6011207.16585 | 2120734.52957 | 37.8037639692824 | -122.405432414094 | (37.8037639692824, -122.405432414094) | 3 | 1 | 10 | 308 | 23 | |||
189345 | 125524 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011207.68462 | 2120726.93894 | 37.8037431562814 | -122.405430083952 | (37.8037431562814, -122.405430083952) | 3 | 1 | 10 | 308 | 23 | |||
144847 | 125525 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | 3 | 1 | 10 | 308 | 23 | |||
80015 | 125526 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010063.61505 | 2116985.54141 | 37.7934061616158 | -122.409125055588 | (37.7934061616158, -122.409125055588) | 3 | 1 | 10 | 28857 | 4 | |||
31391 | 125527 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Miller Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010066.41664 | 2116970.44466 | 37.7933648665474 | -122.409114296086 | (37.7933648665474, -122.409114296086) | 3 | 1 | 10 | 28857 | 4 | |||
33069 | 125528 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Miller Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010067.56823 | 2116961.57421 | 37.7933405749546 | -122.409109685279 | (37.7933405749546, -122.409109685279) | 3 | 1 | 10 | 28857 | 4 | |||
88185 | 125529 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010076.61244 | 2116904.10673 | 37.793183289838 | -122.40907433472 | (37.793183289838, -122.40907433472) | 3 | 1 | 10 | 28857 | 4 | |||
34525 | 125530 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010077.84381 | 2116891.68093 | 37.7931492405824 | -122.40906919691 | (37.7931492405824, -122.40906919691) | 3 | 1 | 10 | 28857 | 4 | |||
136839 | 125531 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010078.15064 | 2116889.31743 | 37.7931427681724 | -122.409067968409 | (37.7931427681724, -122.409067968409) | 3 | 1 | 10 | 28857 | 4 | |||
187380 | 125532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010078.47215 | 2116887.6611 | 37.7931382383022 | -122.409066739034 | (37.7931382383022, -122.409066739034) | 3 | 1 | 10 | 28857 | 4 | |||
115378 | 125533 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010078.6629 | 2116885.41787 | 37.7931320896218 | -122.409065920669 | (37.7931320896218, -122.409065920669) | 3 | 1 | 10 | 28857 | 4 | |||
41938 | 125534 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010079.0906 | 2116883.16981 | 37.793125940953 | -122.409064282098 | (37.793125940953, -122.409064282098) | 3 | 1 | 10 | 28857 | 4 | |||
154365 | 125535 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010079.40223 | 2116881.04203 | 37.7931201160419 | -122.409063053629 | (37.7931201160419, -122.409063053629) | 3 | 1 | 10 | 28857 | 4 | |||
44724 | 125536 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010079.47478 | 2116878.80155 | 37.7931139682908 | -122.409062644439 | (37.7931139682908, -122.409062644439) | 3 | 1 | 10 | 28857 | 4 | |||
133904 | 125537 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010079.43392 | 2116876.79887 | 37.7931084671277 | -122.409062644443 | (37.7931084671277, -122.409062644443) | 3 | 1 | 10 | 28857 | 4 | |||
68453 | 125538 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010079.83492 | 2116873.25499 | 37.7930987589554 | -122.409061006782 | (37.7930987589554, -122.409061006782) | 3 | 1 | 10 | 28857 | 4 | |||
21355 | 125539 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 31 Spofford St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6010570.5264 | 2117382.56278 | 37.7945246709392 | -122.407399099212 | (37.7945246709392, -122.407399099212) | 3 | 1 | 10 | 28857 | 4 | |||
24461 | 16391 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 248X Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2003 12:00:00 AM | 3 | 3X3 | 6006237.34556 | 2114081.50477 | 37.7852173036048 | -122.422157838958 | (37.7852173036048, -122.422157838958) | 13 | 9 | 11 | 28858 | 41 | ||
44580 | 16399 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 12 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
166460 | 16400 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2005 12:00:00 AM | 3 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
69039 | 16401 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
193686 | 16402 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
166235 | 16403 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
66789 | 16404 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
173456 | 16405 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
162324 | 16406 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
161362 | 16907 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 452 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004778.47873 | 2110233.49325 | 37.7745692194762 | -122.426930917012 | (37.7745692194762, -122.426930917012) | 7 | 9 | 11 | 28852 | 10 | |||
87885 | 16912 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 474 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3X3 | 6004730.16481 | 2110223.37403 | 37.7745387026084 | -122.427097323497 | (37.7745387026084, -122.427097323497) | 7 | 9 | 11 | 28852 | 10 | |||
131213 | 16913 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 477 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004718.6652 | 2110142.96999 | 37.7743172824327 | -122.42713137469 | (37.7743172824327, -122.42713137469) | 7 | 9 | 11 | 28852 | 10 | |||
12247 | 16942 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
100911 | 16943 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
2235 | 16944 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
30749 | 17018 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.77961 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | 15 | 5 | 11 | 29492 | 10 | ||
169624 | 17031 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.438444795925 | (37.7730732545652, -122.438444795925) | 15 | 5 | 11 | 29492 | 10 | |||
184630 | 17102 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1711 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998685.53291 | 2109300.56616 | 37.771661239802 | -122.447940341436 | (37.771661239802, -122.447940341436) | 15 | 5 | 11 | 29492 | 9 | |||
37507 | 17121 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1931 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997743.85041 | 2109170.01524 | 37.7712489089965 | -122.451188245827 | (37.7712489089965, -122.451188245827) | 15 | 5 | 11 | 29492 | 9 | |||
16888 | 171233 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 65 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003693 | 2093019 | 37.7272408214237 | -122.42945790991 | (37.7272408214237, -122.42945790991) | 9 | 7 | 6 | 28861 | 5 | ||
89690 | 17228 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6000994.27294 | 2091122.49333 | 37.721880279621 | -122.438651538532 | (37.721880279621, -122.438651538532) | 9 | 7 | 6 | 28861 | 25 | |||
157420 | 175151 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 285 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000727.04119 | 2093604.3094 | 37.7286795733875 | -122.439753131624 | (37.7286795733875, -122.439753131624) | 9 | 7 | 6 | 28861 | 25 | |
183254 | 175152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.39297 | 37.7286399726426 | -122.43966968351 | (37.7286399726426, -122.43966968351) | 9 | 7 | 6 | 28861 | 25 | |
103751 | 175153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6001323.55262 | 2092431.04941 | 37.7254920046417 | -122.437606970601 | (37.7254920046417, -122.437606970601) | 9 | 7 | 6 | 28861 | 25 | |||
148998 | 175154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.441897095593 | (37.7250574153596, -122.441897095593) | 9 | 7 | 6 | 28861 | 25 | |||
84672 | 175155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | 9 | 7 | 6 | 28861 | 25 | |||
147929 | 175156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | 9 | 7 | 6 | 28861 | 25 | |||
193901 | 175157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | 9 | 7 | 6 | 28861 | 25 | |||
76065 | 175158 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.441868929714 | (37.7250771680567, -122.441868929714) | 9 | 7 | 6 | 28861 | 25 | |||
98841 | 175159 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000090.18527 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | 9 | 7 | 6 | 28861 | 25 | |||
83370 | 175160 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | 9 | 7 | 6 | 28861 | 25 | |||
111278 | 175161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000095.42068 | 2092313.25863 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | 9 | 7 | 6 | 28861 | 25 | |||
125410 | 175162 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000098.01412 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | 9 | 7 | 6 | 28861 | 25 | |||
36532 | 175163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.441826421457 | (37.7251102235329, -122.441826421457) | 9 | 7 | 6 | 28861 | 25 | |||
133109 | 175164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000102.23368 | 2092318.39014 | 37.7251131517233 | -122.441820869043 | (37.7251131517233, -122.441820869043) | 9 | 7 | 6 | 28861 | 25 | |||
41103 | 175165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | 9 | 7 | 6 | 28861 | 5 | |||
163550 | 175166 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004672.7463 | 2094000.25869 | 37.7299905627997 | -122.426140758388 | (37.7299905627997, -122.426140758388) | 9 | 7 | 6 | 28861 | 5 | |||
46905 | 175167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | 9 | 7 | 6 | 28861 | 5 | |||
38269 | 175168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004674.59943 | 2093952.62434 | 37.7298598742113 | -122.426130962075 | (37.7298598742113, -122.426130962075) | 9 | 7 | 6 | 28861 | 5 | |||
8425 | 175169 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 728 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009133.75655 | 2092888.51191 | 37.7271890729929 | -122.41063996266 | (37.7271890729929, -122.41063996266) | 9 | 3 | 7 | 309 | 28 | |||
170949 | 175170 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 364 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004288.38035 | 2091053.98491 | 37.7218790151804 | -122.427259769545 | (37.7218790151804, -122.427259769545) | 9 | 7 | 6 | 28861 | 5 | |||
100507 | 175171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003766.26192 | 2091125.79977 | 37.7220466613948 | -122.429069717203 | (37.7220466613948, -122.429069717203) | 9 | 7 | 6 | 28861 | 5 | |||
49839 | 175172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003774.22148 | 2091143.66189 | 37.7220961573958 | -122.42904347589 | (37.7220961573958, -122.42904347589) | 9 | 7 | 6 | 28861 | 5 | |||
103260 | 175173 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003787.7125 | 2091165.48018 | 37.7221568292683 | -122.428998395553 | (37.7221568292683, -122.428998395553) | 9 | 7 | 6 | 28861 | 5 | |||
48353 | 175174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003793.29108 | 2091173.56486 | 37.7221793437874 | -122.428979687879 | (37.7221793437874, -122.428979687879) | 9 | 7 | 6 | 28861 | 5 | |||
13926 | 176734 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.415256704327 | (37.7245056282085, -122.415256704327) | 9 | 3 | 7 | 309 | 28 | ||
1455 | 176735 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.415235340041 | (37.7245113883837, -122.415235340041) | 9 | 3 | 7 | 309 | 28 | ||
129154 | 17785 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1798X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005398.04469 | 2115519.90556 | 37.7891194189645 | -122.425163949857 | (37.7891194189645, -122.425163949857) | 13 | 9 | 1 | 28858 | 41 | |||
105504 | 18245 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1815X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003482.1216 | 2114150.20266 | 37.7852501414757 | -122.431694966286 | (37.7852501414757, -122.431694966286) | 13 | 9 | 11 | 29490 | 13 | |||
37305 | 189152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1665 Hudson Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6015368.44602 | 2097645.03721 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | 10 | 3 | 8 | 58 | 1 | |||
57858 | 189153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012332.53447 | 2112551.48713 | 37.7813581348078 | -122.400962694499 | (37.7813581348078, -122.400962694499) | 6 | 2 | 9 | 28856 | 34 | |||
108852 | 189154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.7813157722581 | -122.401025754031 | (37.7813157722581, -122.401025754031) | 6 | 2 | 9 | 28856 | 34 | |||
144036 | 189155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.401205471869 | (37.7811537953404, -122.401205471869) | 6 | 2 | 9 | 28856 | 34 | |||
23055 | 189156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012246.95244 | 2112466.10025 | 37.7811189079475 | -122.401252766302 | (37.7811189079475, -122.401252766302) | 6 | 2 | 9 | 28856 | 34 | |||
57639 | 189157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.7810840205508 | -122.401309519845 | (37.7810840205508, -122.401309519845) | 6 | 2 | 9 | 28856 | 34 | |||
100444 | 189158 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6008181.20874 | 2109420.17856 | 37.7725278642987 | -122.415102589323 | (37.7725278642987, -122.415102589323) | 8 | 2 | 9 | 28853 | 19 | |||
139089 | 189159 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6008170.01676 | 2109410.076 | 37.7724994960939 | -122.415140588393 | (37.7724994960939, -122.415140588393) | 8 | 2 | 9 | 28853 | 19 | |||
88873 | 189160 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6008158.83722 | 2109400.58141 | 37.772472797918 | -122.415178587445 | (37.772472797918, -122.415178587445) | 8 | 2 | 9 | 28853 | 19 | |||
317 | 189161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.415210253457 | (37.7724477670719, -122.415210253457) | 8 | 2 | 9 | 28853 | 19 | |||
121797 | 189162 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6008137.74771 | 2109383.99653 | 37.7724260745213 | -122.41525036412 | (37.7724260745213, -122.41525036412) | 8 | 2 | 9 | 28853 | 19 | |||
168658 | 189163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2324 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010839.47216 | 2105097.25682 | 37.7608071304715 | -122.405602811334 | (37.7608071304715, -122.405602811334) | 10 | 3 | 8 | 28856 | 29 | |||
182127 | 189164 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6014453.29453 | 2102557.37778 | 37.7540345843346 | -122.392926403935 | (37.7540345843346, -122.392926403935) | 10 | 3 | 8 | 28856 | 29 | ||||
20384 | 189165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | 10 | 3 | 8 | 28856 | 29 | |||
179959 | 189166 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 20 | Median : Yard | Tree | DPW 1 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951887 | (37.752778669414, -122.40048951887) | 10 | 3 | 8 | 28856 | 29 | ||||
32468 | 189167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 18 | Median : Yard | Tree | DPW 1 | 1 | 6012264.80612 | 2102152.75254 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | 10 | 3 | 8 | 28856 | 29 | ||||
50975 | 189168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 606 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011490.76938 | 2105489.27118 | 37.7619199120061 | -122.40337783013 | (37.7619199120061, -122.40337783013) | 10 | 3 | 8 | 28856 | 29 | |||
157070 | 189169 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2098 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6011892.76134 | 2104699.04319 | 37.7597725656737 | -122.401931937014 | (37.7597725656737, -122.401931937014) | 10 | 3 | 8 | 28856 | 29 | |||
45527 | 189170 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 360 Texas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013732.7365 | 2105419.19303 | 37.7618524574395 | -122.395618779897 | (37.7618524574395, -122.395618779897) | 10 | 3 | 8 | 28856 | 29 | |||
47611 | 189171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 672 Missouri St | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013547.27138 | 2103937.27162 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | 10 | 3 | 8 | 28856 | 29 | |||
162596 | 189172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1947 Quesada Ave | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6013391.6303 | 2095988.75639 | 37.7359395106896 | -122.396137605077 | (37.7359395106896, -122.396137605077) | 10 | 3 | 8 | 58 | 1 | |||
72478 | 189173 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1960 Quesada Ave | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.7361619750843 | -122.396301660307 | (37.7361619750843, -122.396301660307) | 10 | 3 | 8 | 58 | 1 | |||
58064 | 189174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Waterville St | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6011435.76202 | 2096086.73565 | 37.7360995216629 | -122.402906748143 | (37.7360995216629, -122.402906748143) | 10 | 3 | 8 | 58 | 1 | |||
119465 | 189175 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012666.59913 | 2115298.53532 | 37.7889195185657 | -122.399999956726 | (37.7889195185657, -122.399999956726) | 12 | 2 | 9 | 28855 | 6 | |||
176265 | 189176 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012661.31608 | 2115304.65409 | 37.7889360247231 | -122.400018665349 | (37.7889360247231, -122.400018665349) | 12 | 2 | 9 | 28855 | 6 | |||
67570 | 189177 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012656.64503 | 2115309.49846 | 37.7889490657959 | -122.400035166996 | (37.7889490657959, -122.400035166996) | 12 | 2 | 9 | 28855 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );