Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
qSiteInfo ✖
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 16610 | 16610 | 14901 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 175 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6017044.13522 | 2098333.33165 | 37.7425797926155 | -122.383672499702 | (37.7425797926155, -122.383672499702) | ||
| 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) | |||
| 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) | ||
| 25401 | 25401 | 27591 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 2100X San Bruno Ave | 4 | 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 96043 | 96043 | 49974 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 138 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/2003 12:00:00 AM | 10 | 3x6 | Permit Number 46725 | 6003736.17026094 | 2097556.1914573 | 37.739701367535 | -122.42963212654199 | (37.739701367535, -122.429632126542) |
| 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) | ||
| 105309 | 105309 | 14878 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.74349348316439 | -122.383634554347 | (37.7434934831644, -122.383634554347) | ||
| 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) | ||
| 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) | ||
| 119871 | 119871 | 15016 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 670 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 5 | 3x3 | 6016248.60441 | 2097127.21289 | 37.739224031366795 | -122.386339165233 | (37.7392240313668, -122.386339165233) | ||
| 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) | |||
| 126922 | 126922 | 15008 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 600X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 12 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | ||
| 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) | ||
| 138859 | 138859 | 93980 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53404 | 6016373.3 | 2096115.1 | 37.7364518752706 | -122.385837492382 | (37.7364518752706, -122.385837492382) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||||
| 25666 | 25666 | 179365 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 2300 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010237.42069 | 2095603.4903799999 | 37.7347056462347 | -122.407015869312 | (37.7347056462347, -122.407015869312) | |||
| 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) | |||
| 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) | |||
| 30199 | 30199 | 197244 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016639.49339 | 2097549.35813 | 37.7404047858594 | -122.38501703741699 | (37.7404047858594, -122.385017037417) | |||
| 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) | |||
| 36467 | 36467 | 197263 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017252.47245 | 2095336.30143 | 37.7343620620475 | -122.382743613324 | (37.7343620620475, -122.382743613324) | |||
| 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) | ||||
| 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) | |||
| 41463 | 41463 | 179363 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 2300 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010218.26631 | 2095644.80145 | 37.734818005735605 | -122.407085003796 | (37.7348180057356, -122.407085003796) | |||
| 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) | |||
| 41673 | 41673 | 214008 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 222 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994773.560409999 | 2087779.1496 | 37.7123444055547 | -122.459912734779 | (37.7123444055547, -122.459912734779) | |||
| 42259 | 42259 | 197246 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1339 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017203.85974 | 2095339.7013299998 | 37.7343687116489 | -122.382911921471 | (37.7343687116489, -122.382911921471) | |||
| 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) | |||
| 46248 | 46248 | 197252 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1333 Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017782.90663 | 2094656.28102 | 37.7325241508658 | -122.38086245283999 | (37.7325241508658, -122.38086245284) | |||
| 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) | |||
| 48528 | 48528 | 240361 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 138 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003708.025169999 | 2097591.62928 | 37.7397970779748 | -122.429731967151 | (37.7397970779748, -122.429731967151) | |||
| 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) | |||
| 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) | |||
| 52745 | 52745 | 197242 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017080.03361 | 2098493.68243 | 37.7430220675307 | -122.383559533147 | (37.7430220675307, -122.383559533147) | |||
| 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) | ||||
| 53585 | 53585 | 197269 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 623 Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016467.035209999 | 2097318.03546 | 37.7397600798502 | -122.385597217932 | (37.7397600798502, -122.385597217932) | |||
| 57512 | 57512 | 197265 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1328 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017187.84442 | 2095472.38417 | 37.734732147456604 | -122.382976523354 | (37.7347321474566, -122.382976523354) | |||
| 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) | ||||
| 59607 | 59607 | 197261 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017380.571719999 | 2095099.80246 | 37.7337197590624 | -122.38228428011499 | (37.7337197590624, -122.382284280115) | |||
| 60058 | 60058 | 179364 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 2300 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010224.85869 | 2095626.2161299998 | 37.7347673433273 | -122.40706090196501 | (37.7347673433273, -122.407060901965) | |||
| 60807 | 60807 | 197262 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017335.88738 | 2095181.6845 | 37.733942122725395 | -122.38244446375201 | (37.7339421227254, -122.382444463752) | |||
| 65823 | 65823 | 197268 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 623 Mendell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016457.45945 | 2097300.20103 | 37.7397105802781 | -122.385629084527 | (37.7397105802781, -122.385629084527) | |||
| 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) | |||
| 67475 | 67475 | 197240 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 301 Mendell St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016921.73157 | 2097930.91265 | 37.7414680650873 | -122.384067722948 | (37.7414680650873, -122.384067722948) | |||
| 70243 | 70243 | 197256 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1320 Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6018044.32152 | 2094632.22344 | 37.732472518087 | -122.37995699832899 | (37.732472518087, -122.379956998329) | |||
| 71356 | 71356 | 179370 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 2302 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010321.94566 | 2095411.6162900003 | 37.734183530441705 | -122.406710118682 | (37.7341835304417, -122.406710118682) | |||
| 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) | |||
| 72615 | 72615 | 197255 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1320 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6018070.99696 | 2094637.60558 | 37.7324887679223 | -122.379865147852 | (37.7324887679223, -122.379865147852) | |||
| 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) | |||
| 74976 | 74976 | 197271 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 621 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016522.123869999 | 2097389.36221 | 37.739958976617295 | -122.385411712102 | (37.7399589766173, -122.385411712102) | |||
| 75378 | 75378 | 197257 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017533.22144 | 2094905.154 | 37.733193723116 | -122.38174298627199 | (37.733193723116, -122.381742986272) | |||
| 75680 | 75680 | 197250 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1337 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017426.32364 | 2094968.1062 | 37.733360674138105 | -122.382116942362 | (37.7333606741381, -122.382116942362) | |||
| 75733 | 75733 | 179362 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 2300 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010207.20881 | 2095669.3235 | 37.7348847192535 | -122.407124961546 | (37.7348847192535, -122.407124961546) | |||
| 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) | ||||
| 105453 | 105453 | 197270 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 621 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016507.88272 | 2097368.67206 | 37.739901377747294 | -122.385459511073 | (37.7399013777473, -122.385459511073) | |||
| 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) | ||||
| 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) | |||
| 132253 | 132253 | 197245 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 401 Mendell St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016656.39457 | 2097572.2278400003 | 37.7404685163083 | -122.38496019216001 | (37.7404685163083, -122.38496019216) | |||
| 134620 | 134620 | 179366 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 2300 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010245.15068 | 2095586.7088400002 | 37.7346600002662 | -122.406987961537 | (37.7346600002662, -122.406987961537) | |||
| 134739 | 134739 | 197273 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 618 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016318.01168 | 2097190.59348 | 37.7394019032644 | -122.38610360101299 | (37.7394019032644, -122.386103601013) | |||
| 135294 | 135294 | 197266 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 818 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015992.3153099995 | 2096760.75352 | 37.738203618709 | -122.38719975136699 | (37.738203618709, -122.387199751367) | |||
| 137388 | 137388 | 197267 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 822 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6015954.57272 | 2096709.3738 | 37.738060450238706 | -122.387326664599 | (37.7380604502387, -122.387326664599) | |||
| 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) | |||
| 143664 | 143664 | 179368 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 2302 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010304.52848 | 2095452.39798 | 37.7342945337677 | -122.406773208834 | (37.7342945337677, -122.406773208834) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) |
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");