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 | ||||||||
| 3506 | 3506 | 247939 | Planning Code 138.1 required 4 | Quercus agrifolia :: Coast Live Oak 180 | 29 Joy St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 12 | Permit Number 775404 | 6010258.299769999 | 2098917.5156900003 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | |||
| 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 | ||||||||
| 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) | |||
| 22891 | 22891 | 247616 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6009490.26965 | 2096786.7692099998 | 37.737912836413706 | -122.409682528235 | (37.7379128364137, -122.409682528235) | ||||
| 23389 | 23389 | 43452 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.44355739787599 | (37.7220903846374, -122.443557397876) | |
| 23459 | 23459 | 240288 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3980 22nd St | 2 | : 4 | Tree 1 | Private 1 | 20 | 6001954.916780001 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | ||||
| 23907 | 23907 | 247195 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 900 Waller St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6001251.021869999 | 2108666.7471 | 37.7700672400275 | -122.43902074711201 | (37.7700672400275, -122.439020747112) | ||||
| 24401 | 24401 | 240280 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 691 29th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002099.074659999 | 2098828.06304 | 37.7431007968732 | -122.435383453493 | (37.7431007968732, -122.435383453493) | ||||
| 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) | |
| 24892 | 24892 | 197177 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6012740.291540001 | 2102830.02856 | 37.7546879247201 | -122.39886955298599 | (37.7546879247201, -122.398869552986) | ||||
| 25922 | 25922 | 197195 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1700x Quesada Ave | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6014229.96459 | 2095381.0032900001 | 37.734317354963395 | -122.393196613328 | (37.7343173549634, -122.393196613328) | ||||
| 26060 | 26060 | 43443 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 03/06/2004 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.722236528981206 | -122.44393453036999 | (37.7222365289812, -122.44393453037) | |
| 26728 | 26728 | 197173 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012739.26156 | 2102864.49072 | 37.7547824929244 | -122.39887553350201 | (37.7547824929244, -122.398875533502) | ||||
| 26754 | 26754 | 197191 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015839.12005 | 2099880.54912 | 37.7467614521736 | -122.38794706729799 | (37.7467614521736, -122.387947067298) | ||||
| 27096 | 27096 | 240267 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 517 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6008465.29724 | 2098131.45059 | 37.7415475462934 | -122.413321437934 | (37.7415475462934, -122.413321437934) | ||||
| 27927 | 27927 | 247528 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Waller St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | ||||
| 28166 | 28166 | 247620 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6009499.0149 | 2096845.5713799999 | 37.7380747845204 | -122.40965644069901 | (37.7380747845204, -122.409656440699) | ||||
| 28305 | 28305 | 247111 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2301 Castro St | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6002712.026930001 | 2098697.32849 | 37.7427766218445 | -122.43325469165899 | (37.7427766218445, -122.433254691659) | ||||
| 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) | |
| 29707 | 29707 | 197189 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6015936.19644 | 2099934.12978 | 37.7469139511226 | -122.387615121238 | (37.7469139511226, -122.387615121238) | ||||
| 30011 | 30011 | 247106 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2301 Castro St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6002702.97811 | 2098815.3340000003 | 37.7431001241765 | -122.433294410209 | (37.7431001241765, -122.433294410209) | ||||
| 30396 | 30396 | 136277 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2745 Larkin St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6006529.34062 | 2120636.08267 | 37.8032309995586 | -122.421613321221 | (37.8032309995586, -122.421613321221) | ||||
| 30845 | 30845 | 197201 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2001 Revere Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6012348.821330001 | 2096403.61302 | 37.737020542553395 | -122.399772154858 | (37.7370205425534, -122.399772154858) | ||||
| 31046 | 31046 | 247622 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6009485.42402 | 2096845.0974 | 37.7380727214716 | -122.409703397886 | (37.7380727214716, -122.409703397886) | ||||
| 31175 | 31175 | 247826 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 96 Banks St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008666.54857 | 2098148.46053 | 37.741605548963896 | -122.412626779128 | (37.7416055489639, -122.412626779128) | ||||
| 31284 | 31284 | 247949 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010404.2439 | 2098872.53529 | 37.7436910749942 | -122.406669401896 | (37.7436910749942, -122.406669401896) | ||||
| 31609 | 31609 | 240284 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 687 29th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002190.93807 | 2098832.7894099997 | 37.743118991043204 | -122.435066152888 | (37.7431189910432, -122.435066152888) | ||||
| 32035 | 32035 | 247948 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010393.64964 | 2098873.99577 | 37.7436944924075 | -122.406706137374 | (37.7436944924075, -122.406706137374) | ||||
| 32440 | 32440 | 197209 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6019354.09765 | 2093629.3399099999 | 37.729790960977205 | -122.375359249432 | (37.7297909609772, -122.375359249432) | ||||
| 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) | |
| 34358 | 34358 | 136279 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1151 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6006698.81265 | 2120089.55435 | 37.8017399263049 | -122.420988029784 | (37.8017399263049, -122.420988029784) | ||||
| 35699 | 35699 | 117207 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 13 | 6012255.77341 | 2102253.00873 | 37.753076544652 | -122.40050462841002 | (37.753076544652, -122.40050462841) | ||||
| 35786 | 35786 | 52156 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1771 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 11 | Permit Number 48348 | 6014341.22767 | 2095259.71993 | 37.733990516146996 | -122.392803455827 | (37.733990516147, -122.392803455827) | |
| 37501 | 37501 | 240270 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 527 Banks St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008672.46387 | 2098105.62692 | 37.7414882692663 | -122.412603298703 | (37.7414882692663, -122.412603298703) | ||||
| 37718 | 37718 | 197172 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 900x Carolina St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012477.22941 | 2103487.19338 | 37.756477694309204 | -122.39982544148998 | (37.7564776943092, -122.39982544149) | ||||
| 38549 | 38549 | 247912 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 399 Franconia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009971.111830001 | 2098794.45901 | 37.7434524515605 | -122.408161569622 | (37.7434524515605, -122.408161569622) | ||||
| 39173 | 39173 | 43441 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 7 | Permit Number 774294 | 5999448.10749 | 2091294.70392 | 37.7222650509726 | -122.444008586831 | (37.7222650509726, -122.444008586831) | |
| 39362 | 39362 | 214005 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 50 Circular Ave | 2 | : Yard 23 | Tree 1 | Private 1 | 17 | 6000114.23279 | 2093911.68117 | 37.7294886448689 | -122.441893693449 | (37.7294886448689, -122.441893693449) | ||||
| 40792 | 40792 | 247068 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2401 Castro St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6002725.312059999 | 2098419.39316 | 37.7420142296685 | -122.43318890084299 | (37.7420142296685, -122.433188900843) | ||||
| 41414 | 41414 | 197206 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6019299.00025 | 2093665.65157 | 37.729887633603504 | -122.37555224573799 | (37.7298876336035, -122.375552245738) | ||||
| 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) | ||||
| 42377 | 42377 | 202102 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1828 Egbert Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6012051.06489 | 2092865.44567 | 37.727288868066395 | -122.40055317110901 | (37.7272888680664, -122.400553171109) | ||||
| 43989 | 43989 | 197184 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1501 22nd St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6013333.16365 | 2103831.67556 | 37.7574712473141 | -122.39688944818701 | (37.7574712473141, -122.396889448187) | ||||
| 44984 | 44984 | 46658 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 239 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 12 | Permit Number 44789 | 5988674.72219 | 2113730.0699299998 | 37.7832461170437 | -122.482892615104 | (37.7832461170437, -122.482892615104) | |
| 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) | |
| 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) | |||
| 45782 | 45782 | 197198 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2001 Revere Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6012265.63539 | 2096460.02897 | 37.737170811179105 | -122.400063728568 | (37.7371708111791, -122.400063728568) | ||||
| 46293 | 46293 | 197175 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012742.61039 | 2102842.0361900004 | 37.7547210242675 | -122.398862376408 | (37.7547210242675, -122.398862376408) | ||||
| 46906 | 46906 | 197203 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 88 05th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6010503.85094 | 2113243.7691200003 | 37.7831568013875 | -122.407337895824 | (37.7831568013875, -122.407337895824) | ||||
| 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) | ||||
| 49448 | 49448 | 247614 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6009490.01081 | 2096755.59346 | 37.7378272200383 | -122.40968122331999 | (37.7378272200383, -122.40968122332) | ||||
| 51296 | 51296 | 248062 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 18 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6010668.82651 | 2099388.20833 | 37.74512180102921 | -122.405790850563 | (37.7451218010292, -122.405790850563) | ||||
| 52424 | 52424 | 43437 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 03/06/2004 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.9112200001 | 37.7223551630339 | -122.44424210479099 | (37.7223551630339, -122.444242104791) | |
| 53365 | 53365 | 248061 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 18 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010675.96291 | 2099385.23379 | 37.74511403267871 | -122.40576596453 | (37.7451140326787, -122.40576596453) | ||||
| 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) | |||
| 55653 | 55653 | 247619 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009506.60291 | 2096847.67057 | 37.738080973649 | -122.409630353184 | (37.738080973649, -122.409630353184) | ||||
| 55829 | 55829 | 197207 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 91 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6019325.738419999 | 2093646.8502 | 37.729837480194796 | -122.375458504919 | (37.7298374801948, -122.375458504919) | ||||
| 56515 | 56515 | 247841 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 77 Nevada St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009047.64568 | 2098175.65883 | 37.74170161093429 | -122.411310990032 | (37.7417016109343, -122.411310990032) | ||||
| 57894 | 57894 | 247954 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010443.052019999 | 2098860.23159 | 37.743659462916206 | -122.40653434529301 | (37.7436594629162, -122.406534345293) | ||||
| 57942 | 57942 | 240275 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 533 Powhattan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6008914.9227599995 | 2098091.07722 | 37.7414619236323 | -122.411763928179 | (37.7414619236323, -122.411763928179) | ||||
| 58471 | 58471 | 51501 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1828 Egbert Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | 3 | Permit Number 47813 | 6012094.35334 | 2092834.4343 | 37.7272061313316 | -122.40040134486901 | (37.7272061313316, -122.400401344869) | ||
| 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) | |||
| 59639 | 59639 | 240264 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 511 Powhattan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6008183.28194 | 2098148.67915 | 37.741579014462 | -122.414297772542 | (37.741579014462, -122.414297772542) | ||||
| 59926 | 59926 | 240276 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 533 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6008927.202269999 | 2098089.49395 | 37.7414582651784 | -122.411721357863 | (37.7414582651784, -122.411721357863) | ||||
| 60485 | 60485 | 136281 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 941 Vallejo St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008944.09485 | 2118690.11186 | 37.7980237126691 | -122.41311927755301 | (37.7980237126691, -122.413119277553) | ||||
| 61036 | 61036 | 240283 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 689 29th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002132.41034 | 2098830.92399 | 37.7431105455104 | -122.435268392422 | (37.7431105455104, -122.435268392422) | ||||
| 62246 | 62246 | 247899 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 353 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010040.64075 | 2098391.36717 | 37.7423495418983 | -122.407892736173 | (37.7423495418983, -122.407892736173) | ||||
| 63781 | 63781 | 43439 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 12 | Permit Number 774294 | 5999436.71838 | 2091300.71882 | 37.72228091680579 | -122.44404838812099 | (37.7222809168058, -122.444048388121) | |
| 64418 | 64418 | 247823 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3565 Folsom St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6008531.99478 | 2098373.38247 | 37.7422155824781 | -122.413107922691 | (37.7422155824781, -122.413107922691) | ||||
| 64503 | 64503 | 240265 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 513 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6008399.8056 | 2098135.45524 | 37.7415548649644 | -122.413548169632 | (37.7415548649644, -122.413548169632) | ||||
| 65300 | 65300 | 111749 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 4124 23rd St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002319.4 | 2102413.2 | 37.752957247271 | -122.434877962118 | (37.752957247271, -122.434877962118) | |||||
| 65314 | 65314 | 247610 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6009501.25197 | 2096696.3834 | 37.7376652719307 | -122.40963817905799 | (37.7376652719307, -122.409638179058) | ||||
| 65476 | 65476 | 43457 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999502.576 | 2091265.96486 | 37.722189247127105 | -122.443818239036 | (37.7221892471271, -122.443818239036) | |
| 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) | |||
| 66116 | 66116 | 246710 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1 Bonview St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6007732.83024 | 2099171.3128299997 | 37.7443616257 | -122.41592768580799 | (37.7443616257, -122.415927685808) | ||||
| 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) | |
| 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) | |||
| 67105 | 67105 | 197178 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012271.91368 | 2102115.47955 | 37.7526998195515 | -122.40043915236099 | (37.7526998195515, -122.400439152361) | ||||
| 67379 | 67379 | 197190 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6015846.29737 | 2099899.9246099996 | 37.7468150508735 | -122.387923600389 | (37.7468150508735, -122.387923600389) | ||||
| 68075 | 68075 | 43459 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999660.0285 | 2091185.4802700002 | 37.7219772346577 | -122.443268187573 | (37.7219772346577, -122.443268187573) | |
| 68869 | 68869 | 240273 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 533 Powhattan Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008878.25951 | 2098091.29342 | 37.7414604604356 | -122.41189071280199 | (37.7414604604356, -122.411890712802) | ||||
| 69103 | 69103 | 197179 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012255.14184 | 2102164.55152 | 37.7528336251844 | -122.40050059944099 | (37.7528336251844, -122.400500599441) | ||||
| 69204 | 69204 | 43747 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 271 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43383 | 5991501.55503 | 2113612.76885 | 37.7830881153357 | -122.47310444241998 | (37.7830881153357, -122.47310444242) | |
| 69778 | 69778 | 197200 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2001 Revere Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6012333.19446 | 2096408.64833 | 37.7370334972934 | -122.39982653777001 | (37.7370334972934, -122.39982653777) | ||||
| 69830 | 69830 | 179347 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 111 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6004743.78868 | 2092719.75542 | 37.726478599600505 | -122.42580404683001 | (37.7264785996005, -122.42580404683) | ||||
| 69987 | 69987 | 197193 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6015814.64437 | 2099848.11828 | 37.7466710478274 | -122.388029439803 | (37.7466710478274, -122.388029439803) |
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");