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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 5059 | 5059 | 83040 | Private 5 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.37788821227699 | (37.740925933998, -122.377888212277) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 53146 | 53146 | 240348 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1201 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004340.86769 | 2095971.0086599998 | 37.7353830362869 | -122.42742844278798 | (37.7353830362869, -122.427428442788) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 78265 | 78265 | 10877 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 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) | |||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 153213 | 153213 | 83039 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 12 | 6018611.72965 | 2097767.00037 | 37.741111283369705 | -122.378212851336 | (37.7411112833697, -122.378212851336) | |||
| 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) | ||||
| 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) | ||||
| 170255 | 170255 | 65579 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 670 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/1990 12:00:00 AM | 4 | Permit Number 28479 | 6016251.26211 | 2097105.4929099998 | 37.739164539819 | -122.386328462099 | (37.739164539819, -122.386328462099) | ||
| 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) | ||||
| 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) | ||||
| 180361 | 180361 | 240347 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1201 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004297.07476 | 2095945.05367 | 37.7353092927844 | -122.42757800273701 | (37.7353092927844, -122.427578002737) | ||||
| 182991 | 182991 | 240346 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1201 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004285.4248 | 2095936.19817 | 37.7352843186184 | -122.42761765024099 | (37.7352843186184, -122.427617650241) | ||||
| 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) | ||||
| 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) | ||||
| 13463 | 13463 | 29643 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015873.397999999 | 2095908.1157 | 37.7358558618741 | -122.38755144424499 | (37.7358558618741, -122.387551444245) | ||
| 15131 | 15131 | 29653 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015651.7407 | 2096073.8877 | 37.73629875843729 | -122.38832937401199 | (37.7362987584373, -122.388329374012) | ||
| 16046 | 16046 | 29655 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015616.5769 | 2096101.5164 | 37.7363726727082 | -122.388452878787 | (37.7363726727082, -122.388452878787) | ||
| 16064 | 16064 | 29654 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015636.0426 | 2096086.4462 | 37.736332371666705 | -122.388384525603 | (37.7363323716667, -122.388384525603) | ||
| 117647 | 117647 | 29644 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015992.691127599 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | ||
| 126688 | 126688 | 119910 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12x31 | 6015992.691127599 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | ||||
| 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) | |
| 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) | ||
| 13482 | 13482 | 3542 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 201X Cargo Way | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018537.99972 | 2097717.76917 | 37.7409720404334 | -122.378464368331 | (37.7409720404334, -122.378464368331) | ||
| 13742 | 13742 | 14945 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 200X Mendell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016835.656690001 | 2097927.0465 | 37.7414526902904 | -122.384365073909 | (37.7414526902904, -122.384365073909) | ||
| 13872 | 13872 | 15042 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1024 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2008 12:00:00 AM | 3 | 3X3 | 6015618.91517 | 2096257.6222 | 37.7368014371311 | -122.388455686999 | (37.7368014371311, -122.388455686999) | ||
| 14574 | 14574 | 14944 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 200X Mendell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016843.847680001 | 2097941.18235 | 37.7414919573859 | -122.384337736299 | (37.7414919573859, -122.384337736299) | ||
| 14657 | 14657 | 12132 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1400X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:53:00 AM | 3 | 3X3 | 6016426.995019999 | 2095242.04569 | 37.734057614557 | -122.385591017134 | (37.734057614557, -122.385591017134) | ||
| 14916 | 14916 | 15036 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1011 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6015667.53207 | 2096259.4401099999 | 37.7368091227302 | -122.38828772241501 | (37.7368091227302, -122.388287722415) | |||
| 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) | ||
| 16096 | 16096 | 14971 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 400X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016631.74011 | 2097650.02311 | 37.740680762618396 | -122.385050857322 | (37.7406807626184, -122.385050857322) | ||
| 16415 | 16415 | 3521 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 201X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018183.10085 | 2097983.12019 | 37.7416810722141 | -122.379709922198 | (37.7416810722141, -122.379709922198) | |||
| 22353 | 22353 | 3591 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018372.01456 | 2097944.0595 | 37.741584237724396 | -122.37905400254499 | (37.7415842377244, -122.379054002545) | ||
| 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) | |||
| 23243 | 23243 | 14987 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 500 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 2 | 3X3 | 6016458.61367 | 2097424.13027 | 37.7400509287079 | -122.38563372862 | (37.7400509287079, -122.38563372862) | ||
| 52916 | 52916 | 27593 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2200X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/2001 12:00:00 AM | 12 | 3X3 | 6010149.0566544 | 2095763.2891253997 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | ||
| 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) | ||
| 84773 | 84773 | 15001 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 501 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6016547.419430001 | 2097394.04536 | 37.739973235060205 | -122.38532457596901 | (37.7399732350602, -122.385324575969) | ||
| 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) | ||
| 85875 | 85875 | 3577 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 88338 | 88338 | 14961 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 355 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016837.91572 | 2097829.62207 | 37.741185307463496 | -122.384350479174 | (37.7411853074635, -122.384350479174) | |||
| 88729 | 88729 | 27589 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 2100X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.9494349998 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | ||
| 89967 | 89967 | 27594 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2200X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/2001 12:00:00 AM | 16 | 3X3 | 6010149.05665 | 2095763.28912 | 37.7351394742594 | -122.407332636897 | (37.7351394742594, -122.407332636897) | ||
| 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) | ||
| 91104 | 91104 | 27588 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 2100X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.9494349998 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | ||
| 100424 | 100424 | 27595 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2200X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/2001 12:00:00 AM | 8 | 3X3 | 6010149.0566544 | 2095763.2891253997 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | ||
| 103993 | 103993 | 3578 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 104312 | 104312 | 15003 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 501 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016547.419430001 | 2097394.04536 | 37.739973235060205 | -122.38532457596901 | (37.7399732350602, -122.385324575969) | ||
| 107792 | 107792 | 14957 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 275 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2007 12:00:00 AM | 3 | 3X3 | 6016965.76785 | 2098027.33997 | 37.7417352694795 | -122.38392217193301 | (37.7417352694795, -122.383922171933) | ||
| 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) | ||
| 118418 | 118418 | 14981 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 495X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3X3 | 6016593.7594099995 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | ||
| 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) | ||
| 120755 | 120755 | 27590 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 2100X San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.9494349998 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | ||
| 122065 | 122065 | 27592 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 2100X San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/21/2001 12:00:00 AM | 3 | 3X3 | 6009789.2811665 | 2096218.9494349998 | 37.7363704769246 | -122.408608649696 | (37.7363704769246, -122.408608649696) | ||
| 124664 | 124664 | 15000 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 501 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6016547.419430001 | 2097394.04536 | 37.739973235060205 | -122.38532457596901 | (37.7399732350602, -122.385324575969) | |||
| 129167 | 129167 | 27596 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2200X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 6 | 3X3 | 6010149.0566544 | 2095763.2891253997 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | ||
| 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) | ||
| 77356 | 77356 | 10849 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1220X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 6 | 3X4 | 6017356.4574634 | 2095156.0177673001 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | ||
| 79309 | 79309 | 10879 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 84694 | 84694 | 10824 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X4 | 6017795.47201 | 2094639.5860099997 | 37.732479003154104 | -122.38081785069599 | (37.7324790031541, -122.380817850696) | ||
| 89270 | 89270 | 10851 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1220X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 3X4 | 6017356.4574634 | 2095156.0177673001 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | ||
| 96624 | 96624 | 10823 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X4 | 6017777.243009999 | 2094650.0030099999 | 37.7325066000949 | -122.38088159725099 | (37.7325066000949, -122.380881597251) | ||
| 102835 | 102835 | 10749 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 103746 | 103746 | 10775 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 48 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 108454 | 108454 | 10829 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2006 12:00:00 AM | 3 | 3X4 | 6017900.94101 | 2094609.6380099999 | 37.7324025921986 | -122.380451134764 | (37.7324025921986, -122.380451134764) | ||
| 140228 | 140228 | 10876 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 144183 | 144183 | 10760 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 23362 | 23362 | 1241 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3702X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X5 | 5992970.26911 | 2087627.9134799999 | 37.711825271896 | -122.466134417365 | (37.711825271896, -122.466134417365) | |||
| 78867 | 78867 | 1243 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3700X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/2004 12:00:00 AM | 3 | 3X5 | 5993218.71389 | 2087629.4001799999 | 37.71184368475021 | -122.46527583828698 | (37.7118436847502, -122.465275838287) | ||
| 89666 | 89666 | 1227 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3600X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/2004 12:00:00 AM | 8 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 125239 | 125239 | 93191 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 220 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x10 | 5994811.8 | 2087851.3 | 37.712544712734896 | -122.459785791066 | (37.7125447127349, -122.459785791066) | |||
| 344 | 344 | 251279 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | |||
| 393 | 393 | 251277 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/26/2011 12:00:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 409 | 409 | 251278 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 01/27/2016 09:31:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
| 13627 | 13627 | 14879 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017057.00036 | 2098638.4724 | 37.743418358272706 | -122.383649254902 | (37.7434183582727, -122.383649254902) | |||
| 13711 | 13711 | 14895 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 3 | 3x3 | 6017124.7449900005 | 2098611.99106 | 37.743349390171105 | -122.383413165805 | (37.7433493901711, -122.383413165805) | ||
| 13929 | 13929 | 30093 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 825 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 5 | 3x3 | 6015971.70273 | 2096663.92655 | 37.7379366099878 | -122.38726426784099 | (37.7379366099878, -122.387264267841) | ||
| 14722 | 14722 | 14988 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 500 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 3x3 | 6016447.53347 | 2097406.0602 | 37.7400006988631 | -122.38567078067801 | (37.7400006988631, -122.385670780678) | ||
| 14805 | 14805 | 15047 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 1115 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 6015512.6554 | 2096045.3172 | 37.7362126017611 | -122.388808259867 | (37.7362126017611, -122.388808259867) | ||
| 15542 | 15542 | 14893 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2008 12:00:00 AM | 3 | 3x3 | 6017107.5762 | 2098575.41356 | 37.7432480069006 | -122.38346998587 | (37.7432480069006, -122.38346998587) | ||
| 16312 | 16312 | 14882 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017027.26925 | 2098565.83494 | 37.7432172671691 | -122.383747002247 | (37.7432172671691, -122.383747002247) | |||
| 16393 | 16393 | 14881 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017041.97386 | 2098599.86831 | 37.743311528701504 | -122.383698526073 | (37.7433115287015, -122.383698526073) |
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");