trees
3,709 rows where qSpecies_id = 9 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 264792 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
20 | 264793 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
67 | 99921 | Section 806 (d) 5 | Olea europaea :: Olive Tree 9 | 1740 Jones St | 1 | Front Yard : Yard | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Permit Number 774389 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | 5 | 1 | 10 | 308 | 21 | ||
136 | 11131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007074.9072505 | 2120528.613771 | 37.802966665104 | -122.419717737051 | (37.802966665104, -122.419717737051) | 5 | 1 | 1 | 28858 | 32 | |||
178 | 233603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 9 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6010152.72418 | 2099634.52308 | 37.7457692517475 | -122.407592814071 | (37.7457692517475, -122.407592814071) | 2 | 7 | 7 | 28859 | 2 | |||
191 | 244985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000147.9035 | 2108881.2284 | 37.7705933244615 | -122.442851810939 | (37.7705933244615, -122.442851810939) | 15 | 5 | 11 | 29492 | 9 | |||
269 | 194187 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014241.14855 | 2105287.11165 | 37.7615180580268 | -122.393851124637 | (37.7615180580268, -122.393851124637) | 10 | 3 | 8 | 28856 | 29 | |||
274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
304 | 132028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 33x Battery St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.399447311639 | (37.7911327033699, -122.399447311639) | 4 | 1 | 10 | 28854 | 6 | ||||
324 | 97786 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 810 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012446.82878 | 2118928.41788 | 37.7988740576432 | -122.401015485586 | (37.7988740576432, -122.401015485586) | 3 | 1 | 10 | 28860 | 6 | |||
357 | 232461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 11 | 6003612.68018 | 2095726.39764 | 37.7346701778724 | -122.429928614715 | (37.7346701778724, -122.429928614715) | 2 | 7 | 5 | 63 | 7 | ||||
593 | 1419 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 41 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5X5PL | 5995462.58605 | 2115703.10829 | 37.7890561644519 | -122.459552424818 | (37.7890561644519, -122.459552424818) | 11 | 6 | 1 | 54 | 11 | |||
642 | 260182 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
765 | 9065 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5537 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989786.9858 | 2112602.3503 | 37.7802143684845 | -122.478962158407 | (37.7802143684845, -122.478962158407) | 11 | 6 | 2 | 55 | 26 | |||
780 | 210671 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2043 Monterey Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992088.794 | 2095394.24092 | 37.7330988041611 | -122.469746063247 | (37.7330988041611, -122.469746063247) | 9 | 8 | 4 | 59 | 40 | |||
941 | 233728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4570 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000770.37011 | 2104674.3409 | 37.7590777197736 | -122.440396940071 | (37.7590777197736, -122.440396940071) | 2 | 4 | 5 | 28862 | 3 | |||
975 | 4380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007006.0129161 | 2120659.6131485 | 37.8033224749672 | -122.419965449311 | (37.8033224749672, -122.419965449311) | 5 | 1 | 1 | 28858 | 32 | |||
998 | 233796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 35 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6004294.34985 | 2098061.60809 | 37.74112071635 | -122.427738180998 | (37.74112071635, -122.427738180998) | 2 | 7 | 5 | 63 | 7 | |||
1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
1088 | 20259 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:41:00 AM | 3 | 3X3 | 6009947.7744 | 2120592.07204 | 37.8033023200197 | -122.40978056566 | (37.8033023200197, -122.40978056566) | 3 | 1 | 10 | 308 | 23 | ||
1155 | 117421 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 29 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996647.4398 | 2112726.9752 | 37.7809525538521 | -122.455237845507 | (37.7809525538521, -122.455237845507) | 11 | 6 | 2 | 54 | 16 | |||
1196 | 41203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41910 | 5993961.82877 | 2115413.43591 | 37.7881743948276 | -122.464723766289 | (37.7881743948276, -122.464723766289) | 11 | 6 | 1 | 54 | 11 | ||
1401 | 123788 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994626 | 2112195 | 37.7793757071335 | -122.46219235943 | (37.7793757071335, -122.46219235943) | 11 | 6 | 2 | 54 | 11 | |||
1512 | 177963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5988967.05933 | 2088996.09626 | 37.7153501871281 | -122.480070526755 | (37.7153501871281, -122.480070526755) | 1 | 8 | 4 | 64 | 14 | ||||
1571 | 56051 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.7684109649411 | -122.43229368198 | (37.7684109649411, -122.43229368198) | 15 | 5 | 5 | 28862 | 3 | ||
1714 | 216680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 430 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 07:33:00 AM | 3 | Width 3ft | 5995444.86919 | 2090582.23732 | 37.7200796093562 | -122.457795211804 | (37.7200796093562, -122.457795211804) | 9 | 8 | 6 | 28861 | 24 | ||
1727 | 249457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6006319.82833 | 2113698.46294 | 37.7841702168319 | -122.421845255461 | (37.7841702168319, -122.421845255461) | 7 | 9 | 11 | 28858 | 41 | |||
1763 | 184039 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984935.4051 | 2103815.5297 | 37.755805317385 | -122.4950976324 | (37.755805317385, -122.4950976324) | 1 | 8 | 3 | 56 | 35 | |||
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
1896 | 17856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | 13 | 9 | 11 | 29490 | 27 | ||
1912 | 261449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 306 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006931 | 2095728 | 37.7348619417662 | -122.418456144702 | (37.7348619417662, -122.418456144702) | 2 | 7 | 7 | 28859 | 2 | ||||
1958 | 244068 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 414 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998440.5999 | 2109109.2833 | 37.7711220225463 | -122.448773795857 | (37.7711220225463, -122.448773795857) | 15 | 5 | 11 | 29492 | 9 | |||
2003 | 56319 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 255 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 11 | Permit Number 12454 | 5993047.12459 | 2113743.61417 | 37.7835367452404 | -122.467766966515 | (37.7835367452404, -122.467766966515) | 11 | 6 | 2 | 54 | 11 | ||
2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
2096 | 3697 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016390.48971 | 2099364.75407 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | 10 | 3 | 8 | 58 | 1 | |||
2218 | 210632 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1695 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993073.70749 | 2104007.38642 | 37.7568051923228 | -122.46696694227 | (37.7568051923228, -122.46696694227) | 1 | 8 | 4 | 56 | 12 | |||
2291 | 29222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
2357 | 210723 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994792.87709 | 2087738.88584 | 37.7122349616579 | -122.459843056229 | (37.7122349616579, -122.459843056229) | 9 | 8 | 6 | 28861 | 24 | |||
2689 | 8750 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3301 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5996889.89707 | 2112871.05246 | 37.7813620597582 | -122.454409481549 | (37.7813620597582, -122.454409481549) | 11 | 6 | 2 | 54 | 16 | |||
2707 | 19008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3080X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000062.56676 | 2115470.42095 | 37.7886806928938 | -122.443620414474 | (37.7886806928938, -122.443620414474) | 13 | 6 | 1 | 29490 | 27 | |||
2720 | 194183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014273.14939 | 2105289.03804 | 37.7615251258084 | -122.393740580889 | (37.7615251258084, -122.393740580889) | 10 | 3 | 8 | 28856 | 29 | |||
2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
2976 | 138679 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1719 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000526.15 | 2114747.8117 | 37.7867230240237 | -122.441964602207 | (37.7867230240237, -122.441964602207) | 13 | 6 | 1 | 29490 | 27 | |||
3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
3065 | 131818 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 245 Alhambra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001145.96871 | 2120047.09018 | 37.8013087580395 | -122.440200340178 | (37.8013087580395, -122.440200340178) | 13 | 9 | 1 | 57 | 17 | |||
3298 | 210771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 115 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994196.30129 | 2105955.3306 | 37.7622184734172 | -122.463225970324 | (37.7622184734172, -122.463225970324) | 1 | 5 | 11 | 56 | 12 | |||
3566 | 246019 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 609 Clayton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 0ft | 5998477.1179 | 2108551.0541 | 37.7695913556898 | -122.448607268219 | (37.7695913556898, -122.448607268219) | 15 | 5 | 11 | 29492 | 9 | |||
3574 | 218861 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995517.64423 | 2107073.72636 | 37.7653653316693 | -122.458736946766 | (37.7653653316693, -122.458736946766) | 15 | 5 | 11 | 56 | 12 | |||
3596 | 264801 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011023 | 2089107 | 37.7169115603385 | -122.403842847789 | (37.7169115603385, -122.403842847789) | 10 | 7 | 8 | 309 | 39 | ||||
3619 | 55603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 655 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 2 | Permit Number 11578 | 5982556.76294 | 2111288.67841 | 37.7761848980348 | -122.503877074189 | (37.7761848980348, -122.503877074189) | 11 | 6 | 2 | 55 | 26 | ||
3655 | 131989 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006994.979 | 2120718.72375 | 37.803484156018 | -122.420007829916 | (37.803484156018, -122.420007829916) | 5 | 1 | 1 | 28858 | 32 | |||
3750 | 90460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 786 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | 11 | 6 | 2 | 55 | 26 | |||
3784 | 233206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 103 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007392.99224 | 2097693.10233 | 37.7402836768503 | -122.416998061628 | (37.7402836768503, -122.416998061628) | 2 | 7 | 7 | 28859 | 2 | |||
3891 | 232910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004811.55535 | 2109480.0616 | 37.7725023496476 | -122.426762832059 | (37.7725023496476, -122.426762832059) | 7 | 9 | 5 | 28852 | 10 | |||
3954 | 232446 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3742 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005626.63295 | 2100825.4971 | 37.7487850005374 | -122.423328051366 | (37.7487850005374, -122.423328051366) | 2 | 4 | 5 | 28859 | 19 | |||
3990 | 60261 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.412268813453 | (37.7575442102667, -122.412268813453) | 2 | 4 | 7 | 28859 | 19 | |
4050 | 173690 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
4113 | 194123 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
4117 | 17881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | 13 | 9 | 11 | 29490 | 27 | |||
4124 | 177990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 287 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003882.75599 | 2091839.3373 | 37.7240124714806 | -122.428717866434 | (37.7240124714806, -122.428717866434) | 9 | 7 | 6 | 28861 | 5 | |||
4236 | 233222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 300x Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
4258 | 232897 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 188 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004783.23018 | 2109050.50758 | 37.7713212969648 | -122.426830214663 | (37.7713212969648, -122.426830214663) | 7 | 9 | 5 | 28852 | 10 | |||
4278 | 236503 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4142 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008312.28371 | 2095873.575 | 37.7353393220422 | -122.413690843461 | (37.7353393220422, -122.413690843461) | 2 | 7 | 7 | 28859 | 2 | |||
4290 | 232871 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Putnam St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 9ft | 6009080.37891 | 2095903.22512 | 37.7354638376772 | -122.411037337111 | (37.7354638376772, -122.411037337111) | 10 | 7 | 7 | 28859 | 2 | |||
4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
4503 | 233620 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008954.95147 | 2103937.12232 | 37.7575161063958 | -122.412038565841 | (37.7575161063958, -122.412038565841) | 2 | 4 | 7 | 28859 | 19 | |||
4530 | 232895 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1621 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010456.86654 | 2100207.03244 | 37.7473582575881 | -122.406581465278 | (37.7473582575881, -122.406581465278) | 2 | 7 | 7 | 28859 | 2 | |||
4541 | 184962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983548.4855 | 2101665.8278 | 37.7498215412297 | -122.499735091789 | (37.7498215412297, -122.499735091789) | 1 | 8 | 3 | 29491 | 35 | |||
4573 | 232883 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2800 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009514.50062 | 2105024.85439 | 37.7605341511365 | -122.410180205851 | (37.7605341511365, -122.410180205851) | 2 | 4 | 7 | 28859 | 19 | |||
4903 | 88595 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 399 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52536 | 6004228 | 2109402 | 37.7722550008378 | -122.428775842479 | (37.7722550008378, -122.428775842479) | 7 | 9 | 11 | 28852 | 10 | ||
5173 | 169519 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1753 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 8x8 | Permit Number 779099 | 6003417.91334 | 2098032.77345 | 37.7409919262491 | -122.430766523865 | (37.7409919262491, -122.430766523865) | 2 | 7 | 5 | 63 | 7 | ||
5300 | 194149 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 40 | Front Yard : Yard | Tree | Private 2 | 1 | 6014236.41284 | 2106693.24116 | 37.765378718967 | -122.393965939285 | (37.765378718967, -122.393965939285) | 14 | 3 | 8 | 28856 | 20 | ||||
5371 | 210699 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995069.25472 | 2091142.27461 | 37.7215957521342 | -122.459134106263 | (37.7215957521342, -122.459134106263) | 9 | 8 | 6 | 28861 | 24 | |||
5468 | 19026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.7883609073807 | -122.44506178917 | (37.7883609073807, -122.44506178917) | 13 | 6 | 1 | 29490 | 27 | |||
5653 | 215048 | Private 9 | Olea europaea :: Olive Tree 9 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782897 | 5990885.18116 | 2103671.34742 | 37.7557559568771 | -122.474511074324 | (37.7557559568771, -122.474511074324) | 1 | 8 | 4 | 56 | 12 | |
5721 | 246522 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005173.73012 | 2109399.79549 | 37.7723024285329 | -122.425504318986 | (37.7723024285329, -122.425504318986) | 7 | 9 | 5 | 28852 | 10 | |||
5805 | 131998 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2526 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007014.37433 | 2120962.81861 | 37.8041554711661 | -122.419958043454 | (37.8041554711661, -122.419958043454) | 5 | 1 | 1 | 28858 | 32 | |||
5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
6043 | 235756 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 79 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2019 12:00:00 AM | 3 | 6x3 | 6005437.91175 | 2099305.91889 | 37.7446019335453 | -122.423872610632 | (37.7446019335453, -122.423872610632) | 2 | 7 | 5 | 28859 | 22 | ||
6115 | 39553 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.35036 | 2107006.086 | 37.7661739606766 | -122.397951878476 | (37.7661739606766, -122.397951878476) | 14 | 3 | 8 | 28856 | 20 | ||
6161 | 103626 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2729 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770186 | 5999911.184 | 2118103.33782 | 37.79590135493 | -122.444333461525 | (37.79590135493, -122.444333461525) | 13 | 9 | 1 | 57 | 17 | |
6173 | 210586 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1677 16th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5991138.28819 | 2103959.43747 | 37.7565616379133 | -122.47365677234 | (37.7565616379133, -122.47365677234) | 1 | 8 | 4 | 56 | 12 | |||
6324 | 233656 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 579 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6x6 | 6001434.06247 | 2101426.15638 | 37.7501967553975 | -122.437868930507 | (37.7501967553975, -122.437868930507) | 2 | 4 | 5 | 28862 | 22 | |||
6339 | 202874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 560 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011757.6465 | 2105763.90852 | 37.7626889070017 | -122.402474114009 | (37.7626889070017, -122.402474114009) | 8 | 3 | 8 | 28856 | 29 | |||
6369 | 55285 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1255 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11211 | 5988297.4779 | 2106775.5193 | 37.7641288996273 | -122.483687653384 | (37.7641288996273, -122.483687653384) | 1 | 8 | 3 | 56 | 35 | ||
6418 | 194172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 664 Wisconsin St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6012676.7573 | 2104370.99604 | 37.7589155441312 | -122.399197435936 | (37.7589155441312, -122.399197435936) | 10 | 3 | 8 | 28856 | 29 | |||
6532 | 119947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 326 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 5986858.05985 | 2113733.39411 | 37.783149373707 | -122.489177700438 | (37.783149373707, -122.489177700438) | 11 | 6 | 2 | 55 | 26 | |||
6614 | 233670 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 803 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002469.64412 | 2103508.89631 | 37.7559742970036 | -122.434436723671 | (37.7559742970036, -122.434436723671) | 2 | 4 | 5 | 28862 | 22 | |||
6647 | 233181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.7631858975236 | -122.446716299819 | (37.7631858975236, -122.446716299819) | 15 | 5 | 5 | 29492 | 9 | |||
6952 | 264732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1965 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012227 | 2095019 | 37.7332118929398 | -122.40009613746 | (37.7332118929398, -122.40009613746) | 10 | 3 | 8 | 58 | 1 | ||||
6963 | 177993 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 219 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004143.56512 | 2092257.28503 | 37.7251748209582 | -122.427846056457 | (37.7251748209582, -122.427846056457) | 9 | 7 | 6 | 28861 | 5 | |||
6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
6968 | 106969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 772815 | 6007433 | 2096444 | 37.7368561680545 | -122.416771259928 | (37.7368561680545, -122.416771259928) | 2 | 7 | 7 | 28859 | 2 | |
7099 | 103526 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
7121 | 13051 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 548 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:01:00 PM | 3 | 3x3 | 6009711.5863 | 2120552.0553 | 37.803179205163 | -122.410595078527 | (37.803179205163, -122.410595078527) | 3 | 1 | 10 | 308 | 23 | ||
7198 | 233017 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 89 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785451 | 6007345.5921 | 2098843.81852 | 37.7434406209891 | -122.417243474931 | (37.7434406209891, -122.417243474931) | 2 | 7 | 7 | 28859 | 2 | |
7300 | 183627 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1442 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981873.5609 | 2105253.9792 | 37.759575163504 | -122.505792929352 | (37.759575163504, -122.505792929352) | 1 | 8 | 3 | 56 | 35 | |||
7307 | 17780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005376.6767315 | 2115458.3552628 | 37.7889492101001 | -122.425233498798 | (37.7889492101001, -122.425233498798) | 13 | 9 | 1 | 28858 | 41 | |||
7404 | 210734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 270 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992990.46687 | 2089001.91036 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | 9 | 8 | 6 | 64 | 24 |
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) );