trees
261 rows where qSpecies_id = 177 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1199 | 116255 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 1346 | 260123 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3195X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 2233 | 256484 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 2 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
| 2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 3302 | 256186 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 4599 | 172187 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 721 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 3ft | 6003854.60179 | 2091058.27085 | 37.7218662421102 | -122.428759536545 | (37.7218662421102, -122.428759536545) | 9 | 7 | 6 | 28861 | 5 | ||
| 4868 | 256192 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 4989 | 256185 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 5224 | 229828 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1456 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6010092.99129 | 2100772.65012 | 37.7488909550714 | -122.407879605175 | (37.7488909550714, -122.407879605175) | 2 | 4 | 7 | 28859 | 19 | ||
| 5642 | 13071 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
| 5671 | 13046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.410413314112 | (37.8032072253646, -122.410413314112) | 3 | 1 | 10 | 308 | 23 | |||
| 5804 | 253280 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2335 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007032 | 2120361 | 37.8025040230696 | -122.419854317954 | (37.8025040230696, -122.419854317954) | 5 | 1 | 1 | 28858 | 32 | ||||
| 6110 | 13007 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.407780718516 | (37.8034055135257, -122.407780718516) | 3 | 1 | 10 | 308 | 23 | ||
| 6215 | 256187 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 8112 | 172239 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 285 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002395.65434 | 2092018.35321 | 37.7244197321571 | -122.433871328009 | (37.7244197321571, -122.433871328009) | 9 | 7 | 6 | 28861 | 5 | ||
| 8763 | 13089 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | 3 | 1 | 10 | 308 | 23 | |||
| 9500 | 256189 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 9548 | 13006 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | 3 | 1 | 10 | 308 | 23 | ||
| 9697 | 172238 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 285 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002385.64302 | 2092003.99063 | 37.7243797276157 | -122.433904909592 | (37.7243797276157, -122.433904909592) | 9 | 7 | 6 | 28861 | 5 | ||
| 10093 | 172178 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 350 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6004331.00068 | 2091119.78411 | 37.7220620955851 | -122.427117126271 | (37.7220620955851, -122.427117126271) | 9 | 7 | 6 | 28861 | 5 | ||
| 10133 | 12999 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 349 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 09:03:00 AM | 3 | 3X3 | 6010644.3554 | 2120634.1907 | 37.8034569792808 | -122.407372982577 | (37.8034569792808, -122.407372982577) | 3 | 1 | 10 | 308 | 23 | ||
| 10237 | 243286 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 552 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 4x5 | 6005074.488 | 2107832.11687 | 37.7679923530051 | -122.425736005029 | (37.7679923530051, -122.425736005029) | 8 | 4 | 5 | 28853 | 19 | ||
| 10503 | 233771 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 35 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2019 03:11:00 PM | 3 | Width 3ft | 6003168.16978 | 2108097.17278 | 37.7686122241979 | -122.432348677773 | (37.7686122241979, -122.432348677773) | 15 | 5 | 5 | 28862 | 3 | ||
| 11154 | 13008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.8034189676022 | -122.407688696484 | (37.8034189676022, -122.407688696484) | 3 | 1 | 10 | 308 | 23 | ||
| 11709 | 13039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | 3 | 1 | 10 | 308 | 23 | |||
| 12604 | 116259 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 13587 | 13088 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 06:03:00 AM | 3 | 3X3 | 6008925.6016 | 2120449.3844 | 37.8028531997518 | -122.413307745784 | (37.8028531997518, -122.413307745784) | 3 | 1 | 10 | 308 | 23 | ||
| 13736 | 90469 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.484556541536 | (37.778596339842, -122.484556541536) | 11 | 6 | 2 | 55 | 26 | |
| 14797 | 264653 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 982 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:50:00 PM | 3x3 | 6014279.95597 | 2089795.48577 | 37.71898342396 | -122.39263318135 | (37.71898342396, -122.39263318135) | 10 | 3 | 8 | 58 | 1 | |||
| 15675 | 256190 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 16011 | 131781 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2758 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 3ft | 5999580.2108 | 2118368.89391 | 37.7966116124855 | -122.445497792185 | (37.7966116124855, -122.445497792185) | 13 | 9 | 1 | 57 | 17 | ||
| 16151 | 13005 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | 3 | 1 | 10 | 308 | 23 | ||
| 16281 | 13043 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 526 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 11:51:00 AM | 3 | 3x3 | 6009812.0026 | 2120568.2515 | 37.8032293051326 | -122.410248727784 | (37.8032293051326, -122.410248727784) | 3 | 1 | 10 | 308 | 23 | ||
| 16520 | 121489 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Judah St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | ||||||||||||||
| 17402 | 12986 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.406869163124 | (37.8036540726688, -122.406869163124) | 3 | 1 | 10 | 308 | 23 | ||
| 17536 | 264654 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 999 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:51:00 PM | 3x3 | |||||||||||||
| 17835 | 146870 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 747 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:07:00 PM | 0 | Width 3ft | 5983198.23429 | 2110712.37785 | 37.7746402422966 | -122.501615441996 | (37.7746402422966, -122.501615441996) | 11 | 6 | 2 | 55 | 26 | ||
| 18840 | 83046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.377512501614 | (37.740707968002, -122.377512501614) | 10 | 3 | 8 | 58 | 1 | ||||
| 18862 | 256188 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 19019 | 13004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 368 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:38:00 AM | 3 | 4X4 | 6010562.3418 | 2120670.5672 | 37.8035522695821 | -122.407659361785 | (37.8035522695821, -122.407659361785) | 3 | 1 | 10 | 308 | 23 | ||
| 20378 | 116241 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 22838 | 143258 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.411677153186 | (37.8029290843214, -122.411677153186) | 3 | 1 | 10 | 308 | 23 | |||
| 30042 | 258516 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 30538 | 258520 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 31119 | 255523 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 34396 | 116471 | Section 143 10 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 882 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | 6012399.9 | 2103853.8 | 37.757480004392 | -122.400118621436 | (37.757480004392, -122.400118621436) | 10 | 3 | 8 | 28856 | 29 | |||
| 34675 | 13072 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
| 35337 | 143011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650-654 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2017 12:26:00 PM | 3 | Width 0ft | 6009188.4253 | 2120483.2963 | 37.8029610657241 | -122.412400635876 | (37.8029610657241, -122.412400635876) | 3 | 1 | 10 | 308 | 23 | ||
| 35355 | 13022 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 431 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:20:00 AM | 3 | 3X3 | 6010276.62799 | 2120585.425 | 37.8033024923724 | -122.408642082138 | (37.8033024923724, -122.408642082138) | 3 | 1 | 10 | 308 | 23 | ||
| 42180 | 114695 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
| 42496 | 116243 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 42853 | 113802 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 806 SHOTWELL ST | 4 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
| 45752 | 143037 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 510 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:44:00 AM | 19 | Width 0ft | 6009884.4437 | 2120577.0857 | 37.8032576219869 | -122.409998666067 | (37.8032576219869, -122.409998666067) | 3 | 1 | 10 | 308 | 23 | ||
| 48637 | 114696 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
| 49933 | 258519 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 53358 | 12988 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 324 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:56:00 AM | 3 | 3X3 | 6010748.7594 | 2120699.4941 | 37.8036421292086 | -122.407016292062 | (37.8036421292086, -122.407016292062) | 3 | 1 | 10 | 308 | 23 | ||
| 53752 | 121107 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608 | 2106030 | 37.7623895873424 | -122.465266089176 | (37.7623895873424, -122.465266089176) | 1 | 8 | 11 | 56 | 12 | ||
| 54561 | 16816 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2105 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/2015 01:25:00 PM | 3 | 4x4 | 6001234.7809998 | 2113147.0836075 | 37.7823681904894 | -122.439398128028 | (37.7823681904894, -122.439398128028) | 15 | 5 | 11 | 29490 | 41 | ||
| 55911 | 100649 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003141 | 2108015 | 37.7683850571797 | -122.432436785894 | (37.7683850571797, -122.432436785894) | 15 | 5 | 5 | 28862 | 3 | ||||
| 56227 | 116244 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 58253 | 13040 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:26:00 AM | 3 | 3X3 | 6009890.5899 | 2120540.3695 | 37.8031571528751 | -122.409974803368 | (37.8031571528751, -122.409974803368) | 3 | 1 | 10 | 308 | 23 | ||
| 59182 | 116252 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 61397 | 13017 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 412 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3X3 | 6010331 | 2120658 | 37.8035048104324 | -122.408459047408 | (37.8035048104324, -122.408459047408) | 3 | 1 | 10 | 308 | 23 | ||
| 61488 | 254585 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1236 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995818 | 2107128 | 37.7655316119834 | -122.457702020035 | (37.7655316119834, -122.457702020035) | 15 | 5 | 11 | 29492 | 12 | ||||
| 63720 | 13009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 378 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 02:11:00 PM | 3 | 4X4 | 6010539.0395 | 2120665.4782 | 37.8035369920045 | -122.407739641802 | (37.8035369920045, -122.407739641802) | 3 | 1 | 10 | 308 | 23 | ||
| 66864 | 117270 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 481 JERSEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6002050 | 2101440 | 37.7502697725383 | -122.435739974128 | (37.7502697725383, -122.435739974128) | 2 | 4 | 5 | 28862 | 22 | |||
| 68114 | 8974 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5991343.5266 | 2112609.97523 | 37.7803255698787 | -122.473577979119 | (37.7803255698787, -122.473577979119) | 11 | 6 | 2 | 54 | 26 | ||
| 68237 | 13015 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2016 12:00:00 AM | 12 | 3X3 | 6010332.686 | 2120602.2788 | 37.8033519082048 | -122.408449280112 | (37.8033519082048, -122.408449280112) | 3 | 1 | 10 | 308 | 23 | ||
| 69531 | 116248 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 69900 | 254752 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 70345 | 255525 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 70827 | 13016 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | 3 | 1 | 10 | 308 | 23 | ||
| 72042 | 13024 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 445 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/04/2014 02:58:00 PM | 3 | 3X3 | 6010214.1933 | 2120583.5975 | 37.8032939775537 | -122.40885801149 | (37.8032939775537, -122.40885801149) | 3 | 1 | 10 | 308 | 23 | ||
| 72719 | 90526 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | 11 | 6 | 2 | 55 | 26 | |
| 72976 | 13010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:16:00 AM | 3 | 3X3 | 6010502.3453 | 2120665.4782 | 37.8035349377887 | -122.407866624342 | (37.8035349377887, -122.407866624342) | 3 | 1 | 10 | 308 | 23 | ||
| 74249 | 116261 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 76872 | 13011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524598 | (37.8035195251148, -122.40795524598) | 3 | 1 | 10 | 308 | 23 | ||
| 77164 | 17862 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.430996333749 | (37.7882072868246, -122.430996333749) | 13 | 9 | 11 | 29490 | 27 | ||
| 77866 | 13055 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 08:41:00 AM | 3 | 3x3 | 6009605.5749 | 2120542.0431 | 37.8031457701614 | -122.410961227909 | (37.8031457701614, -122.410961227909) | 3 | 1 | 10 | 308 | 23 | ||
| 80914 | 255524 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 83740 | 116253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 88367 | 95578 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501@ 6th Ave Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||||
| 88961 | 252853 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
| 90969 | 115004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1050 MCALLISTER ST | 5 | Front Yard : Cutout | Tree | Office of Mayor 9 | DPW | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148 | 2111858 | 37.7789940453007 | -122.429227726914 | (37.7789940453007, -122.429227726914) | 7 | 9 | 11 | 29490 | 41 | |
| 91501 | 12995 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010707.244 | 2120695.2086 | 37.8036280390364 | -122.407159656622 | (37.8036280390364, -122.407159656622) | 3 | 1 | 10 | 308 | 23 | |||
| 92392 | 116250 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 93318 | 111178 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
| 94001 | 143039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 520 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6009841.4502 | 2120571.1962 | 37.8032390411539 | -122.410147031042 | (37.8032390411539, -122.410147031042) | 3 | 1 | 10 | 308 | 23 | |||
| 94231 | 258514 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 94466 | 255395 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
| 99264 | 90510 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.484726269831 | (37.7790336942222, -122.484726269831) | 11 | 6 | 2 | 55 | 26 | |
| 101932 | 116717 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 690X 03RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 5 | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | ||
| 102162 | 216685 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.87199 | 37.7202447887441 | -122.462335661261 | (37.7202447887441, -122.462335661261) | 9 | 8 | 6 | 28861 | 24 | ||
| 102218 | 252854 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
| 102477 | 116246 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 102669 | 255526 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 102780 | 116254 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
| 102904 | 258517 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 103816 | 116240 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
| 107470 | 112520 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 |
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) );