Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 87290 | 87290 | 25474 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 830X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6015988.777980001 | 2096759.23326 | 37.7381992484921 | -122.387211875796 | (37.7381992484921, -122.387211875796) | ||
| 87342 | 87342 | 14977 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 495X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016593.7594099995 | 2097492.39708 | 37.7402458525216 | -122.385171201108 | (37.7402458525216, -122.385171201108) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 89435 | 89435 | 10777 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2014 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 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) | ||
| 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) | ||
| 90100 | 90100 | 10790 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 8 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | ||
| 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) | ||
| 91634 | 91634 | 10820 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x4 | 6017736.87901 | 2094664.32601 | 37.7325437003489 | -122.38102214211901 | (37.7325437003489, -122.381022142119) | ||
| 92367 | 92367 | 98130 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1120X Hudson Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 4 | 3x4 | 6017903.8 | 2094987.0 | 37.733438911814 | -122.38046746904399 | (37.733438911814, -122.380467469044) | ||
| 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) | ||
| 94314 | 94314 | 11430 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 810X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 3 | 3x3 | 6016021.05885 | 2096802.45168 | 37.738319705118705 | -122.387103277147 | (37.7383197051187, -122.387103277147) | ||
| 94700 | 94700 | 14884 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6017061.80062 | 2098665.73573 | 37.74349348316439 | -122.383634554347 | (37.7434934831644, -122.383634554347) | ||
| 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) |
| 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) | ||||
| 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) | ||
| 96804 | 96804 | 14891 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 108283 | 108283 | 10782 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2016 09:31:00 AM | 3 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | ||
| 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) | ||
| 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) | |||||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 127727 | 127727 | 26705 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | ||
| 128155 | 128155 | 10791 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200X Hudson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3x4 | 6017221.84081 | 2095393.05521 | 37.734516204285605 | -122.382853466196 | (37.7345162042856, -122.382853466196) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||||
| 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) | ||
| 141733 | 141733 | 10733 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | ||
| 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) | ||
| 142275 | 142275 | 14923 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 190 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2015 08:59:00 AM | 3 | 3x3 | 6016976.73758 | 2098306.80908 | 37.7425032414108 | -122.383903696919 | (37.7425032414108, -122.383903696919) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 152190 | 152190 | 240360 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 138 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003696.80727 | 2097599.2611700003 | 37.7398173981643 | -122.429771298113 | (37.7398173981643, -122.429771298113) | |||
| 152349 | 152349 | 197264 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 1322 Hudson Ave | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017243.9601 | 2095358.62855 | 37.734422897596005 | -122.382774596779 | (37.734422897596, -122.382774596779) | |||
| 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) |
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");