Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2538 | 2538 | 39950 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 6380 | 6380 | 46722 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 6817 | 6817 | 39953 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 7518 | 7518 | 39946 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 8803 | 8803 | 39951 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 10505 | 10505 | 39952 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 10637 | 10637 | 46729 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 11296 | 11296 | 39947 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 11344 | 11344 | 46730 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 11625 | 11625 | 46731 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 12724 | 12724 | 39945 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 12755 | 12755 | 39949 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 13635 | 13635 | 39944 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 15467 | 15467 | 46732 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15759 | 15759 | 39948 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 0 Ervine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41215 | ||||||||
| 64858 | 64858 | 179339 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 340 Tocoloma Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6012524.83653 | 2086861.1237299999 | 37.7108286189149 | -122.398494192156 | (37.7108286189149, -122.398494192156) | |||
| 58993 | 58993 | 84117 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 61 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50688 | 6010623.589380001 | 2086904.22894 | 37.710840875768206 | -122.40506840807899 | (37.7108408757682, -122.405068408079) | |
| 117606 | 117606 | 86758 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 85882 | 85882 | 111097 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 SAINT CHARLES AVE | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992079.0 | 2088073.0 | 37.712995910736204 | -122.46924723728901 | (37.7129959107362, -122.469247237289) | |||||
| 103668 | 103668 | 44146 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 SAINT CHARLES AVE | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992079.0 | 2088073.0 | 37.712995910736204 | -122.46924723728901 | (37.7129959107362, -122.469247237289) | |||
| 20652 | 20652 | 44154 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 58708 | 58708 | 44145 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 77694 | 77694 | 44160 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 78157 | 78157 | 44147 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 78542 | 78542 | 44139 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 81499 | 81499 | 44142 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 85601 | 85601 | 44157 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 86989 | 86989 | 44153 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 91360 | 91360 | 44137 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 94782 | 94782 | 44151 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 99766 | 99766 | 44156 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 100809 | 100809 | 44144 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 103969 | 103969 | 44148 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 109360 | 109360 | 44138 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 114459 | 114459 | 44152 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 119821 | 119821 | 44143 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 122454 | 122454 | 44158 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 122711 | 122711 | 44155 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 123610 | 123610 | 44140 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 124765 | 124765 | 44161 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 140284 | 140284 | 44159 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 141214 | 141214 | 44136 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 144394 | 144394 | 44150 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 67 Saint Charles Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | |||
| 42150 | 42150 | 179345 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 96 Alpha St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011048.99338 | 2088244.3601799998 | 37.7145443783829 | -122.40369233834 | (37.7145443783829, -122.40369233834) | ||||
| 152793 | 152793 | 30885 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 248 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 16 | Permit Number 34717 | 6003986.5052 | 2089044.44729 | 37.716344188011796 | -122.42816013477899 | (37.7163441880118, -122.428160134779) | ||
| 169713 | 169713 | 179343 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 26 Ervine St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009596.1537 | 2089161.02063 | 37.716980073455204 | -122.408778591782 | (37.7169800734552, -122.408778591782) | ||||
| 159644 | 159644 | 179344 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 26 Ervine St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009638.385919999 | 2089289.7734599998 | 37.7173359675679 | -122.40864169245899 | (37.7173359675679, -122.408641692459) | ||||
| 49187 | 49187 | 197204 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 961 Le Conte Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6013357.29959 | 2089363.32814 | 37.71774551972621 | -122.395792202474 | (37.7177455197262, -122.395792202474) | ||||
| 129752 | 129752 | 214001 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 10 Caine Ave | 14 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5997555.121730001 | 2089578.9570799998 | 37.717445842242604 | -122.450428532174 | (37.7174458422426, -122.450428532174) | |||
| 19833 | 19833 | 26915 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 10 Caine Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.1443599998 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | ||
| 48006 | 48006 | 200173 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1022 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6013894.556 | 2089735.8088 | 37.71879815104911 | -122.39396119350599 | (37.7187981510491, -122.393961193506) | |||
| 132465 | 132465 | 200174 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1022 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6013889.8173 | 2089740.206 | 37.718809961526 | -122.393977881076 | (37.718809961526, -122.393977881076) | |||
| 87184 | 87184 | 96226 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 14X CAINE AVE | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/24/2011 12:00:00 AM | 3 | 6x300 | 5997641.2 | 2089761.8 | 37.7179528127364 | -122.450144172407 | (37.7179528127364, -122.450144172407) | ||
| 99950 | 99950 | 96227 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 14X CAINE AVE | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/24/2011 12:00:00 AM | 3 | 6x300 | 5997641.2 | 2089761.8 | 37.7179528127364 | -122.450144172407 | (37.7179528127364, -122.450144172407) | ||
| 42338 | 42338 | 179342 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 700x Mansell St | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6009054.2584 | 2089931.4323900002 | 37.7190650967554 | -122.410706045769 | (37.7190650967554, -122.410706045769) | |||
| 149405 | 149405 | 113507 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 200x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6011128.47606 | 2090549.92676 | 37.720879434926 | -122.40357972973999 | (37.720879434926, -122.40357972974) | |||
| 181252 | 181252 | 113496 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 200x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6011235.51183 | 2090583.52363 | 37.7209776633755 | -122.403212099473 | (37.7209776633755, -122.403212099473) | |||
| 26939 | 26939 | 179341 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 100x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6011434.8537800005 | 2090631.08875 | 37.7211193983363 | -122.40252637270599 | (37.7211193983363, -122.402526372706) | |||
| 65331 | 65331 | 179340 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 10x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6011654.04439 | 2090707.0392200002 | 37.721340177375204 | -122.40177402596301 | (37.7213401773752, -122.401774025963) | |||
| 77580 | 77580 | 52426 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 300 Seneca Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.44452732141501 | (37.7211856330713, -122.444527321415) | |||
| 81287 | 81287 | 52425 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 300 Seneca Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.44452732141501 | (37.7211856330713, -122.444527321415) | |||
| 83268 | 83268 | 52423 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.44452732141501 | (37.7211856330713, -122.444527321415) | |||
| 88367 | 88367 | 52424 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 300 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.44452732141501 | (37.7211856330713, -122.444527321415) | |||
| 120138 | 120138 | 52422 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.44452732141501 | (37.7211856330713, -122.444527321415) | |||
| 66008 | 66008 | 43425 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 66742 | 66742 | 43420 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 83160 | 83160 | 43430 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 89914 | 89914 | 43431 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 92984 | 92984 | 43422 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 104433 | 104433 | 43429 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 107296 | 107296 | 43423 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 109115 | 109115 | 43421 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 114843 | 114843 | 43426 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 115515 | 115515 | 43427 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 117335 | 117335 | 43428 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 123196 | 123196 | 43424 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 310 Seneca Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | |||
| 182202 | 182202 | 111445 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 7 | 5999980.8477300005 | 2091017.84349 | 37.721535231343296 | -122.442147171851 | (37.7215352313433, -122.442147171851) | |||
| 12923 | 12923 | 111444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.721551640364396 | -122.442184051271 | (37.7215516403644, -122.442184051271) | ||
| 45429 | 45429 | 111443 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | |||
| 180178 | 180178 | 111442 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 8 | 5999909.42688 | 2091057.1743400001 | 37.721639154299204 | -122.44239687581002 | (37.7216391542992, -122.44239687581) | |||
| 162227 | 162227 | 111441 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5 | 5999897.1183 | 2091063.84845 | 37.721656778309494 | -122.442439902078 | (37.7216567783095, -122.442439902078) | |||
| 54575 | 54575 | 111440 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 12 | 5999883.47669 | 2091070.55057 | 37.72167440322979 | -122.442487538293 | (37.7216744032298, -122.442487538293) | |||
| 183638 | 183638 | 111439 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6 | 5999870.68262 | 2091075.2427400001 | 37.721686557579204 | -122.44253210058201 | (37.7216865575792, -122.442532100582) | |||
| 28704 | 28704 | 43445 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999858.82768 | 2091082.35027 | 37.7217053974709 | -122.44257358990299 | (37.7217053974709, -122.442573589903) | |
| 24577 | 24577 | 43433 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | |
| 33677 | 33677 | 43434 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.8327900001 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | |
| 45283 | 45283 | 43435 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 14 | Permit Number 43162 | 5999819.49506 | 2091104.19362 | 37.7217631321556 | -122.44271111962699 | (37.7217631321556, -122.442711119627) | |
| 93570 | 93570 | 111448 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | |||
| 96890 | 96890 | 111446 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||||
| 111981 | 111981 | 43455 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||
| 113461 | 113461 | 111447 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | ||||
| 123447 | 123447 | 43449 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999756.32409 | 2091134.05765 | 37.7218415305512 | -122.442931628018 | (37.7218415305512, -122.442931628018) | |
| 135134 | 135134 | 43451 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.131580001 | 2091140.9715900002 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | |
| 19137 | 19137 | 29594 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 900X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991181.08119 | 2091145.24325 | 37.7213796099522 | -122.472574562389 | (37.7213796099522, -122.472574562389) | ||
| 133363 | 133363 | 43450 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999728.91774 | 2091148.65353 | 37.72188004492379 | -122.443027412104 | (37.7218800449238, -122.443027412104) | |
| 66622 | 66622 | 43448 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999710.3638 | 2091158.16281 | 37.721905097333 | -122.443092230725 | (37.721905097333, -122.443092230725) | |
| 151274 | 151274 | 179338 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2134 San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5998927.16036 | 2091160.9726 | 37.7218681244079 | -122.44579975756201 | (37.7218681244079, -122.445799757562) | |||
| 155143 | 155143 | 43447 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999697.54909 | 2091165.42889 | 37.7219243176433 | -122.443137049362 | (37.7219243176433, -122.443137049362) | |
| 187095 | 187095 | 43432 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999683.18724 | 2091173.0602 | 37.7219444525549 | -122.443187242296 | (37.7219444525549, -122.443187242296) | |
| 162642 | 162642 | 43446 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999670.6407 | 2091179.60867 | 37.721961717728 | -122.44323108247299 | (37.721961717728, -122.443231082473) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");