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 | ||||||||
| 3107 | 3107 | 18939 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2760 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001611.94448 | 2115686.46462 | 37.78936213699829 | -122.438275289198 | (37.7893621369983, -122.438275289198) | |||
| 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 | ||||||||
| 7701 | 7701 | 18936 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2721 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001590.13521 | 2115636.51425 | 37.7892237457171 | -122.43834716658199 | (37.7892237457171, -122.438347166582) | |||
| 8602 | 8602 | 18938 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2730 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/2001 12:00:00 AM | 6 | 4X4 | 6001751.73398 | 2115704.11419 | 37.7894185478752 | -122.437792899137 | (37.7894185478752, -122.437792899137) | ||
| 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 | ||||||||
| 9553 | 9553 | 173610 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 344 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6001093.0 | 2097562.0 | 37.739567297515705 | -122.43877147759301 | (37.7395672975157, -122.438771477593) | |||
| 10494 | 10494 | 117130 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2671 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5988936.0754 | 2097168.6937 | 37.737788261480105 | -122.480775587362 | (37.7377882614801, -122.480775587362) | |||
| 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 | ||||||||
| 10598 | 10598 | 95755 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.901459999 | 2092257.0440599998 | 37.725134950402705 | -122.43024050589399 | (37.7251349504027, -122.430240505894) |
| 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 | |||||||||
| 10694 | 10694 | 95758 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003422.17585 | 2092210.8120900001 | 37.7250063806226 | -122.43033651031901 | (37.7250063806226, -122.430336510319) |
| 10839 | 10839 | 95753 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003478.85461 | 2092303.3656900001 | 37.7252637225375 | -122.430147177848 | (37.7252637225375, -122.430147177848) |
| 11117 | 11117 | 97240 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003400.64895 | 2092179.59067 | 37.7249194341684 | -122.430408699814 | (37.7249194341684, -122.430408699814) |
| 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 | |||||||||
| 11480 | 11480 | 95754 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464.56282 | 2092279.46461 | 37.7251972860232 | -122.43019487878999 | (37.7251972860232, -122.43019487879) |
| 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 | |||||||||
| 12446 | 12446 | 95750 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003564.18987 | 2092436.8443200001 | 37.7256350580097 | -122.429861698861 | (37.7256350580097, -122.429861698861) |
| 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 | ||||||||
| 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) | ||
| 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 | ||||||||
| 14428 | 14428 | 51357 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.6145900001 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) |
| 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 | ||||||||
| 19990 | 19990 | 10459 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1569 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1994 12:00:00 AM | 25 | 3X3 | 5998651.396000001 | 2108625.3987 | 37.76980545066029 | -122.44800980256201 | (37.7698054506603, -122.448009802562) | ||
| 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) | |||
| 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) | |
| 24546 | 24546 | 200029 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1575 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015274.8561 | 2094571.5849 | 37.7321528483199 | -122.38952754545 | (37.7321528483199, -122.38952754545) | |||
| 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) | |
| 25422 | 25422 | 240306 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 134 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003388.16897 | 2105086.9505 | 37.7603593535203 | -122.43137280722901 | (37.7603593535203, -122.431372807229) | |||
| 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) | |
| 26361 | 26361 | 200031 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1575 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015313.8786 | 2094541.9059 | 37.732073519349896 | -122.389390563006 | (37.7320735193499, -122.389390563006) | |||
| 26786 | 26786 | 118668 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4240 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982392.892440001 | 2111033.85887 | 37.7754756009165 | -122.504425054608 | (37.7754756009165, -122.504425054608) | |||
| 28535 | 28535 | 136276 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1927 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004921.8107 | 2117075.88034 | 37.7933648188709 | -122.426922521966 | (37.7933648188709, -122.426922521966) | |||
| 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) | |
| 30649 | 30649 | 240300 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002726.96622 | 2100956.54522 | 37.748980749680705 | -122.433364440431 | (37.7489807496807, -122.433364440431) | |||
| 30995 | 30995 | 240260 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005682.645959999 | 2097069.8371299999 | 37.7384759711765 | -122.42286747885001 | (37.7384759711765, -122.42286747885) | |||
| 31729 | 31729 | 240297 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002954.68882 | 2100970.7991299997 | 37.74903280421721 | -122.432577993181 | (37.7490328042172, -122.432577993181) | |||
| 33136 | 33136 | 240242 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 351 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006956.98547 | 2096047.9435299998 | 37.73574189906971 | -122.41838898186701 | (37.7357418990697, -122.418388981867) | |||
| 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) | |
| 35779 | 35779 | 136278 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2507 Larkin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006657.1862 | 2120015.9614 | 37.8015355122184 | -122.421126848223 | (37.8015355122184, -122.421126848223) | |||
| 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) | |
| 36600 | 36600 | 246014 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1569 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998668.6573 | 2108626.9128 | 37.7698105946696 | -122.44795020544599 | (37.7698105946696, -122.447950205446) | |||
| 37017 | 37017 | 240304 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4185 25th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002908.0812800005 | 2101214.2225599997 | 37.7496985444673 | -122.43275654908899 | (37.7496985444673, -122.432756549089) | |||
| 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) | |
| 41790 | 41790 | 240299 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002905.19719 | 2100966.1852 | 37.7490173286825 | -122.432748805907 | (37.7490173286825, -122.432748805907) | |||
| 42487 | 42487 | 240258 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005731.26515 | 2097042.3638799998 | 37.7384032789939 | -122.422697425158 | (37.7384032789939, -122.422697425158) | |||
| 43393 | 43393 | 142293 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 475 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000600.6108 | 2110614.5346 | 37.775378345569 | -122.441410289609 | (37.775378345569, -122.441410289609) | |||
| 44760 | 44760 | 240250 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005931.12973 | 2096935.89086 | 37.738122202171 | -122.42199882818599 | (37.738122202171, -122.421998828186) | |||
| 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) | |||
| 47436 | 47436 | 97241 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464.0 | 2092306.9 | 37.725272585613105 | -122.430198780788 | (37.7252725856131, -122.430198780788) |
| 47788 | 47788 | 240303 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4185 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002751.21968 | 2101207.63188 | 37.7496715504081 | -122.43329851112101 | (37.7496715504081, -122.433298511121) | |||
| 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) | |||
| 49600 | 49600 | 122372 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006071.0 | 2097171.0 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | ||||
| 51027 | 51027 | 46627 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1426 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 0 | 3x3 | Permit Number 51060 | 6016155.81653285 | 2095029.68224774 | 37.7334594988152 | -122.386513771605 | (37.7334594988152, -122.386513771605) | |
| 51666 | 51666 | 83005 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1601 Lane St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52363 | 6015179.2236 | 2094481.4485 | 37.7319000489922 | -122.38985187728201 | (37.7319000489922, -122.389851877282) | |
| 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) | |
| 53346 | 53346 | 240262 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 316 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006842.705 | 2097236.1672799997 | 37.7389980645073 | -122.41886834032302 | (37.7389980645073, -122.418868340323) | |||
| 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) | |||
| 57304 | 57304 | 240309 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3962 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003941.52222 | 2104241.24585 | 37.7580685950116 | -122.429398706289 | (37.7580685950116, -122.429398706289) | |||
| 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) | ||
| 58605 | 58605 | 123184 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 695 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993153.85102 | 2110782.22133 | 37.775411724638296 | -122.467182349196 | (37.7754117246383, -122.467182349196) | |||
| 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) | |||
| 58756 | 58756 | 240302 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 4185 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002703.68408 | 2101206.46382 | 37.7496656463533 | -122.43346280736601 | (37.7496656463533, -122.433462807366) | |||
| 58988 | 58988 | 240249 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005950.84346 | 2096924.8962700001 | 37.7380931253039 | -122.42192988707501 | (37.7380931253039, -122.421929887075) | |||
| 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) | |
| 59461 | 59461 | 142294 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 465 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000605.0602 | 2110593.7708 | 37.7753215869011 | -122.441393407901 | (37.7753215869011, -122.441393407901) | |||
| 59516 | 59516 | 240248 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005969.6802 | 2096914.3608799998 | 37.7380652597989 | -122.421864010821 | (37.7380652597989, -122.421864010821) | |||
| 59847 | 59847 | 240257 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005753.61776 | 2097030.43222 | 37.7383717784318 | -122.422619292971 | (37.7383717784318, -122.422619292971) | |||
| 60357 | 60357 | 240277 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 877 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007991.30005 | 2102784.81683 | 37.7542980236532 | -122.415289699587 | (37.7542980236532, -122.415289699587) | |||
| 60937 | 60937 | 240295 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003122.09767 | 2100979.63955 | 37.7490665701795 | -122.431999723717 | (37.7490665701795, -122.431999723717) | |||
| 61542 | 61542 | 240243 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006173.885419999 | 2096803.38775 | 37.7377720664226 | -122.421150093012 | (37.7377720664226, -122.421150093012) | |||
| 61908 | 61908 | 240245 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006078.33577 | 2096854.32708 | 37.737906547445995 | -122.42148407153 | (37.737906547446, -122.42148407153) | |||
| 62611 | 62611 | 83004 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1601 Lane St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52363 | 6015190.2158 | 2094494.6392 | 37.7319368775726 | -122.38981479563 | (37.7319368775726, -122.38981479563) | |
| 63067 | 63067 | 240291 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2854 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009093.93311 | 2103358.72756 | 37.7559357619427 | -122.411517046282 | (37.7559357619427, -122.411517046282) | |||
| 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) | |
| 64415 | 64415 | 240255 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005819.32929 | 2096993.7833099999 | 37.7382748557875 | -122.422389490999 | (37.7382748557875, -122.422389490999) | |||
| 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) | |||
| 66346 | 66346 | 46622 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1601 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015162.1856 | 2094456.1663 | 37.7318296842946 | -122.389909016355 | (37.7318296842946, -122.389909016355) | |
| 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) | |||
| 67579 | 67579 | 240292 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009059.85584 | 2103354.08041 | 37.7559210904145 | -122.41163456879801 | (37.7559210904145, -122.411634568798) | |||
| 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) | |
| 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) | |
| 70306 | 70306 | 142295 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 455 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000605.8018 | 2110575.2317 | 37.7752707254694 | -122.44138951197901 | (37.7752707254694, -122.441389511979) | |||
| 70864 | 70864 | 43453 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999638.45654 | 2091195.87208 | 37.7220045380552 | -122.443343502225 | (37.7220045380552, -122.443343502225) | |
| 71105 | 71105 | 240301 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Clipper St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002699.64344 | 2100954.0355700003 | 37.7489723086445 | -122.43345874332701 | (37.7489723086445, -122.433458743327) | |||
| 71345 | 71345 | 244078 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1768 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998103.3126 | 2108943.7673 | 37.7706482646329 | -122.449928548475 | (37.7706482646329, -122.449928548475) | |||
| 71624 | 71624 | 240279 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1369 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006475.19087 | 2101646.9491 | 37.7510883747358 | -122.42045203565701 | (37.7510883747358, -122.420452035657) | |||
| 71753 | 71753 | 43458 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999537.11613 | 2091248.65338 | 37.72214368387 | -122.443697599487 | (37.72214368387, -122.443697599487) | |
| 74074 | 74074 | 43442 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.72225447314511 | -122.443973794765 | (37.7222544731451, -122.443973794765) | |
| 75670 | 75670 | 43444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999490.75065 | 2091271.846 | 37.722204720867204 | -122.443859538611 | (37.7222047208672, -122.443859538611) | |
| 76799 | 76799 | 53858 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 730 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1972 12:00:00 AM | 6 | Permit Number 9568 | 6015422.25071 | 2105620.89151 | 37.762500112301 | -122.389789458021 | (37.762500112301, -122.389789458021) |
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");