Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5461 | 5461 | 23583 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3100X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005493.5455 | 2121226.7269099997 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | |||
| 5306 | 5306 | 23582 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005497.77155 | 2121198.52122 | 37.8047170896849 | -122.425223146826 | (37.8047170896849, -122.425223146826) | ||
| 104579 | 104579 | 23581 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3100X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005553.2513401 | 2120985.4040713003 | 37.804135058960796 | -122.42501598068701 | (37.8041350589608, -122.425015980687) | ||
| 130689 | 130689 | 136295 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2600x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 6005728.53037 | 2119520.31629 | 37.800122202431204 | -122.42430514856899 | (37.8001222024312, -122.424305148569) | |||
| 86396 | 86396 | 23507 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2600X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 9 | 6005789.5650879005 | 2119282.8766016 | 37.799473699725 | -122.424077049734 | (37.799473699725, -122.424077049734) | |||
| 167594 | 167594 | 104600 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1945 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770083 | 6007230.70015 | 2119043.68461 | 37.798898199037396 | -122.419073222948 | (37.7988981990374, -122.419073222948) | |
| 25723 | 25723 | 104601 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1945 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770083 | 6007231.00881 | 2119029.9690799997 | 37.7988605570185 | -122.419071181514 | (37.7988605570185, -122.419071181514) | |
| 59395 | 59395 | 104602 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1945 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770083 | 6007233.0949099995 | 2119016.60883 | 37.7988239906011 | -122.41906301476001 | (37.7988239906011, -122.41906301476) | |
| 7029 | 7029 | 13296 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 2770 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2016 12:00:00 AM | 2 | 3X3 | Permit Number 770074 | 5999335.521430001 | 2119120.5005900003 | 37.79866135180829 | -122.446398566642 | (37.7986613518083, -122.446398566642) | |
| 3794 | 3794 | 29684 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6006028.673359999 | 2117355.72849 | 37.7941957348865 | -122.42311259358699 | (37.7941957348865, -122.423112593587) | ||||
| 100979 | 100979 | 29780 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2000X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2006 12:00:00 AM | 4 | 5x5 | 6006071.7874482 | 2117255.4874461996 | 37.79392293103879 | -122.422956286012 | (37.7939229310388, -122.422956286012) | ||
| 114620 | 114620 | 29785 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2000x Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2006 12:00:00 AM | 4 | 5x5 | 6006071.7874482 | 2117255.4874461996 | 37.79392293103879 | -122.422956286012 | (37.7939229310388, -122.422956286012) | ||
| 70317 | 70317 | 136294 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6006242.0943599995 | 2115852.50489 | 37.7900802996014 | -122.42226728033701 | (37.7900802996014, -122.422267280337) | ||||
| 179912 | 179912 | 249490 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6006241.6595 | 2115852.2639200003 | 37.7900796134287 | -122.42226876779101 | (37.7900796134287, -122.422268767791) | ||||
| 111911 | 111911 | 249489 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6006246.93776 | 2115807.86331 | 37.7899579981201 | -122.422247349544 | (37.7899579981201, -122.422247349544) | ||||
| 183866 | 183866 | 136293 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6006248.16207 | 2115803.32411 | 37.789945603663604 | -122.42224279089899 | (37.7899456036636, -122.422242790899) | ||||
| 68645 | 68645 | 249487 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6006262.64335 | 2115713.0194599996 | 37.789698466352704 | -122.42218626847901 | (37.7896984663527, -122.422186268479) | ||||
| 8228 | 8228 | 23389 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006261.55669 | 2115711.13882 | 37.789693241290294 | -122.42218989455499 | (37.7896932412903, -122.422189894555) | |||
| 81890 | 81890 | 23390 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2003 12:00:00 AM | 6 | 9 | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | ||
| 128478 | 128478 | 23388 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | G | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | ||
| 145922 | 145922 | 23366 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1356X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/01/2003 12:00:00 AM | 6 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | ||
| 154476 | 154476 | 249478 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1300x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6006350.91475 | 2115079.54882 | 37.7879640914292 | -122.421835842261 | (37.7879640914292, -122.421835842261) | ||||
| 186488 | 186488 | 249476 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6006383.25331 | 2114827.68427 | 37.78727435725771 | -122.421706060208 | (37.7872743572577, -122.421706060208) | ||||
| 49786 | 49786 | 249475 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6006389.52859 | 2114780.4065099997 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | ||||
| 93088 | 93088 | 23354 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1250X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | ||
| 114873 | 114873 | 23355 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1250X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/10/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | ||
| 35652 | 35652 | 249474 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6006395.0323 | 2114736.35179 | 37.7870242450239 | -122.421658817911 | (37.7870242450239, -122.421658817911) | ||||
| 117797 | 117797 | 99962 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1202X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 9x5 | 6006588.9 | 2114703.0 | 37.78694359926921 | -122.420985708971 | (37.7869435992692, -122.420985708971) | |||
| 78759 | 78759 | 23340 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1202X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 8 | 9x5 | 6006445.157123799 | 2114583.3806768996 | 37.7866070504124 | -122.42147452901001 | (37.7866070504124, -122.42147452901) | ||
| 101935 | 101935 | 23339 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1202X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 9x5 | 6006445.157123799 | 2114583.3806768996 | 37.7866070504124 | -122.42147452901001 | (37.7866070504124, -122.42147452901) | ||
| 169889 | 169889 | 249473 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6006432.644069999 | 2114489.3949 | 37.7863482830936 | -122.42151114382901 | (37.7863482830936, -122.421511143829) | ||||
| 88242 | 88242 | 23333 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1142X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441004 | 37.7861918455124 | -122.42129095338001 | (37.7861918455124, -122.42129095338) | ||
| 89183 | 89183 | 23332 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1142X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441004 | 37.7861918455124 | -122.42129095338001 | (37.7861918455124, -122.42129095338) | ||
| 118845 | 118845 | 23324 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1108X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/01/2003 12:00:00 AM | 3 | 3x3 | 6006505.7907443 | 2114265.3196898997 | 37.7857371517591 | -122.421242157065 | (37.7857371517591, -122.421242157065) | ||
| 139456 | 139456 | 23323 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1108X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/01/2003 12:00:00 AM | 3 | 3x3 | 6006505.7907443 | 2114265.3196898997 | 37.7857371517591 | -122.421242157065 | (37.7857371517591, -122.421242157065) | ||
| 80247 | 80247 | 95980 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 6700 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 6 | 5986162.43558 | 2112587.6567 | 37.7799628795758 | -122.49149988415199 | (37.7799628795758, -122.491499884152) | |||
| 37625 | 37625 | 119298 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 6700x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5986043.64284 | 2112521.4673099997 | 37.77977419975021 | -122.491905961239 | (37.7797741997502, -122.491905961239) | ||||
| 159509 | 159509 | 136290 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006768.37866 | 2112062.5093799997 | 37.7797035719992 | -122.42017728376601 | (37.7797035719992, -122.420177283766) | |||
| 51251 | 51251 | 136291 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006783.12153 | 2111963.42533 | 37.779432341874 | -122.420119247825 | (37.779432341874, -122.420119247825) | |||
| 48790 | 48790 | 136292 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006812.66695 | 2111768.16026 | 37.7788978558793 | -122.420003176823 | (37.7788978558793, -122.420003176823) | |||
| 97905 | 97905 | 23180 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 300X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.41977270620701 | (37.778265495762, -122.419772706207) | |||
| 127602 | 127602 | 29669 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 300X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.41977270620701 | (37.778265495762, -122.419772706207) | ||||
| 139625 | 139625 | 29670 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 300X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.41977270620701 | (37.778265495762, -122.419772706207) | ||||
| 150321 | 150321 | 201670 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 08th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6010207.48998 | 2109776.17317 | 37.773619004556295 | -122.408118556848 | (37.7736190045563, -122.408118556848) | ||||
| 58897 | 58897 | 201668 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 08th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010243.64351 | 2109736.80769 | 37.7735129403066 | -122.407990719097 | (37.7735129403066, -122.407990719097) | ||||
| 170701 | 170701 | 201667 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 08th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010257.0488 | 2109725.83328 | 37.7734835576458 | -122.40794357396099 | (37.7734835576458, -122.407943573961) | ||||
| 37860 | 37860 | 201665 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 08th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010317.6274 | 2109676.05195 | 37.7733502610444 | -122.407730511973 | (37.7733502610444, -122.407730511973) | ||||
| 173028 | 173028 | 197225 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015963.59101 | 2106011.38061 | 37.7636023160031 | -122.38794439272199 | (37.7636023160031, -122.387944392722) | |||
| 153574 | 153574 | 197226 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015965.03581 | 2105988.90006 | 37.7635406692923 | -122.387937826789 | (37.7635406692923, -122.387937826789) | |||
| 161864 | 161864 | 197227 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015965.05283 | 2105966.21151 | 37.7634783723591 | -122.38793618463001 | (37.7634783723591, -122.38793618463) | |||
| 110792 | 110792 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 76 | 109 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996563.8 | 2106359.1 | 37.763463224843996 | -122.455066914463 | (37.763463224844, -122.455066914463) | |||||
| 46894 | 46894 | 197228 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015966.4036 | 2105950.82285 | 37.7634361932415 | -122.38793043883301 | (37.7634361932415, -122.387930438833) | |||
| 182318 | 182318 | 197229 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015967.79725 | 2105937.5599700003 | 37.7633998534335 | -122.387924693077 | (37.7633998534335, -122.387924693077) | |||
| 19657 | 19657 | 111332 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 79966 | 79966 | 111329 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 86333 | 86333 | 111325 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 87939 | 87939 | 111326 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 96081 | 96081 | 111327 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 99321 | 99321 | 111328 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 118605 | 118605 | 111330 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 123526 | 123526 | 111333 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 124838 | 124838 | 111331 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 698x ILLINOIS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015875.0 | 2105932.0 | 37.7633794456224 | -122.38824526349899 | (37.7633794456224, -122.388245263499) | ||||
| 137449 | 137449 | 197230 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015968.5174 | 2105926.2015 | 37.763368705413896 | -122.387921409661 | (37.7633687054139, -122.387921409661) | |||
| 39134 | 39134 | 197231 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015968.40199 | 2105908.71514 | 37.7633206852369 | -122.38792058857901 | (37.7633206852369, -122.387920588579) | |||
| 71369 | 71369 | 197232 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 670 Illinois St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015969.52981 | 2105893.92675 | 37.763280141978605 | -122.38791565581002 | (37.7632801419786, -122.38791565581) | |||
| 145391 | 145391 | 98540 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 5998512.0 | 2105692.0 | 37.7617431097225 | -122.448280704282 | (37.7617431097225, -122.448280704282) | ||||
| 169362 | 169362 | 240349 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 5998465.34509 | 2105692.76775 | 37.76174255039739 | -122.44844211950199 | (37.7617425503974, -122.448442119502) | |||
| 150816 | 150816 | 240350 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 4746 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5998436.06596 | 2105691.7221 | 37.761738005233205 | -122.44854330852199 | (37.7617380052332, -122.448543308522) | |||
| 176013 | 176013 | 240359 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6004303.32084 | 2105026.7227 | 37.760245805120604 | -122.42820342995199 | (37.7602458051206, -122.428203429952) | |||
| 41507 | 41507 | 240358 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6004302.67089 | 2105008.5073599997 | 37.760195753352 | -122.428204379638 | (37.760195753352, -122.428204379638) | |||
| 151575 | 151575 | 240356 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6004321.88535 | 2104984.17972 | 37.760130042589005 | -122.428136192158 | (37.760130042589, -122.428136192158) | |||
| 158778 | 158778 | 240357 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6004316.61445 | 2104979.98621 | 37.7601182299832 | -122.42815412283701 | (37.7601182299832, -122.428154122837) | |||
| 174587 | 174587 | 240355 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6004321.65497 | 2104972.99929 | 37.7600993307501 | -122.42813619214701 | (37.7600993307501, -122.428136192147) | |||
| 74575 | 74575 | 240354 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 3ft | 6004324.4915 | 2104963.9062200002 | 37.7600745238281 | -122.428125733918 | (37.7600745238281, -122.428125733918) | |||
| 173614 | 173614 | 240353 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | Width 3ft | 6004318.107530001 | 2104946.3678099997 | 37.7600260063222 | -122.42814656311701 | (37.7600260063222, -122.428146563117) | |||
| 34089 | 34089 | 240352 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 671 Church St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6004316.09652 | 2104917.27177 | 37.759946001726604 | -122.428151444657 | (37.7599460017266, -122.428151444657) | |||
| 27153 | 27153 | 197239 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 830 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394588999 | (37.7592018783746, -122.40214394589) | |||
| 102484 | 102484 | 113196 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 4090X 20th St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6003325.9669699995 | 2104184.75857 | 37.7578786248615 | -122.43152352597099 | (37.7578786248615, -122.431523525971) | |||||
| 146754 | 146754 | 240351 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 4090 20th St | 1 | : Yard 23 | Tree 1 | Private 1 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | |||
| 67130 | 67130 | 197238 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1101 Illinois St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6016145.70434 | 2103719.54836 | 37.757319520883705 | -122.38715464767901 | (37.7573195208837, -122.387154647679) | |||
| 158951 | 158951 | 197237 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1101 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016149.20682 | 2103671.84274 | 37.757188725307294 | -122.38713920722401 | (37.7571887253073, -122.387139207224) | |||
| 150540 | 150540 | 197236 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1101 Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016150.0851300005 | 2103652.1356900004 | 37.7571346625573 | -122.38713479513001 | (37.7571346625573, -122.38713479513) | |||
| 45949 | 45949 | 197235 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1101 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016151.23089 | 2103629.8826099997 | 37.75707362375729 | -122.387129280509 | (37.7570736237573, -122.387129280509) | |||
| 28170 | 28170 | 197234 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1201 Illinois St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6016171.82655 | 2103275.3753400003 | 37.756101362207296 | -122.387033327344 | (37.7561013622073, -122.387033327344) | |||
| 147369 | 147369 | 197233 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1201 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016183.784440001 | 2103092.78575 | 37.7556006718551 | -122.38697923850799 | (37.7556006718551, -122.386979238508) | |||
| 78226 | 78226 | 27556 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 82165 | 82165 | 27558 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 84083 | 84083 | 27571 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 85613 | 85613 | 27570 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 90033 | 90033 | 27553 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 119050 | 119050 | 27573 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 138353 | 138353 | 27569 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 10 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 142220 | 142220 | 27550 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1299X Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 144322 | 144322 | 27547 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1301X Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6016173.411126 | 2103023.95301 | 37.755411097271704 | -122.387010312465 | (37.7554110972717, -122.387010312465) | ||
| 15090 | 15090 | 27536 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1300 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016135.46193 | 2102904.74697 | 37.7550816812001 | -122.38713323933099 | (37.7550816812001, -122.387133239331) | ||
| 111596 | 111596 | 27542 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1390 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2006 12:00:00 AM | 3 | 3X3 | 6016157.095863 | 2102619.361637 | 37.7542992711205 | -122.387038518734 | (37.7542992711205, -122.387038518734) | ||
| 10392 | 10392 | 778 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1800X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 5984768.5556 | 2102340.232 | 37.7517447878795 | -122.49556583438999 | (37.7517447878795, -122.49556583439) | ||
| 97253 | 97253 | 21043 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
| 22320 | 22320 | 3658 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 94 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3x3 | 6017265.726009999 | 2098814.03291 | 37.7439119466908 | -122.382939742901 | (37.7439119466908, -122.382939742901) | |||
| 23027 | 23027 | 14877 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017083.42225 | 2098683.73205 | 37.7435440924819 | -122.383561044027 | (37.7435440924819, -122.383561044027) |
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");