Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109599 | 109599 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 600 Front St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.39944985704099 | (37.7974274520849, -122.399449857041) | ||||
| 144047 | 144047 | 108298 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 10X Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 774449 | 6012830.0 | 2116175.0 | 37.791335193350896 | -122.399496166675 | (37.7913351933509, -122.399496166675) | ||
| 12961 | 12961 | 87019 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 10 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 77629 | 77629 | 87016 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 83316 | 83316 | 87018 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1200 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | |||
| 92148 | 92148 | 87013 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1184 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49946 | 6017813.5 | 2093492.6 | 37.7293305991048 | -122.380675823117 | (37.7293305991048, -122.380675823117) | |||
| 101397 | 101397 | 87015 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 120538 | 120538 | 87017 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1200 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | |||
| 122533 | 122533 | 87014 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 114243 | 114243 | 115834 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 900X LAKE MERCED BLVD | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | Permit Number 777492 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | |
| 84289 | 84289 | 115997 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 20X Park St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 08/30/2016 09:25:00 AM | 3 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | |||
| 9904 | 9904 | 61559 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1096 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/25/1984 12:00:00 AM | 16 | Permit Number 21519 | 6012461.11053783 | 2102868.78681941 | 37.75477878641421 | -122.399837764002 | (37.7547787864142, -122.399837764002) | ||
| 109790 | 109790 | 100068 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 303 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990392.0 | 2090762.0 | 37.720281613079 | -122.47527420247 | (37.720281613079, -122.47527420247) | |||
| 18734 | 18734 | 94234 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 84102 | 84102 | 94231 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 88999 | 88999 | 94233 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 107755 | 107755 | 94230 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Everglade Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 116587 | 116587 | 94232 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 141881 | 141881 | 94235 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 27 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 86601 | 86601 | 27299 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.779227117259296 | -122.503705073784 | (37.7792271172593, -122.503705073784) | ||
| 92056 | 92056 | 27295 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.779242313567295 | -122.50336180684499 | (37.7792423135673, -122.503361806845) | ||
| 111288 | 111288 | 27297 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.863919999 | 2112396.64212 | 37.7792343387449 | -122.50352984750401 | (37.7792343387449, -122.503529847504) | ||
| 114112 | 114112 | 27296 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.7930900003 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | ||
| 128707 | 128707 | 27300 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1999 12:00:00 AM | 6 | 5x5 | 5982547.933540001 | 2112415.51016 | 37.7792783288562 | -122.50399109880101 | (37.7792783288562, -122.503991098801) | ||
| 143978 | 143978 | 27298 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982658.07107 | 2112395.9042 | 37.7792309725957 | -122.503608641413 | (37.7792309725957, -122.503608641413) | ||
| 6954 | 6954 | 8532 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001535.4351 | 2113580.6442 | 37.783575742772705 | -122.438389071264 | (37.7835757427727, -122.438389071264) | ||
| 8796 | 8796 | 8530 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.783676377346794 | -122.438063730933 | (37.7836763773468, -122.438063730933) | |||
| 129015 | 129015 | 8536 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651002 | (37.7837972495813, -122.43786449651) | ||
| 140538 | 140538 | 8537 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 3 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651002 | (37.7837972495813, -122.43786449651) | ||
| 5837 | 5837 | 8395 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004192.8617 | 2113973.9777 | 37.7848065332396 | -122.429223453232 | (37.7848065332396, -122.429223453232) | ||
| 77480 | 77480 | 8344 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 80484 | 80484 | 8339 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 92710 | 92710 | 8340 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 108857 | 108857 | 8348 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/08/1994 12:00:00 AM | 6 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | ||
| 81272 | 81272 | 87834 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 114533 | 114533 | 87835 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 3479 | 3479 | 8471 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/03/1994 12:00:00 AM | 6 | 8 | 6002124.2891 | 2113678.9558 | 37.783879157642104 | -122.43635890448 | (37.7838791576421, -122.43635890448) | ||
| 7244 | 7244 | 8475 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/03/1994 12:00:00 AM | 6 | 8 | 6001831.8926 | 2113645.1136 | 37.7837696172579 | -122.43736806210899 | (37.7837696172579, -122.437368062109) | ||
| 99151 | 99151 | 8561 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | ||
| 100876 | 100876 | 8560 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | ||
| 71190 | 71190 | 91505 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 80059 | 80059 | 91504 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 86211 | 86211 | 91503 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 106088 | 106088 | 91502 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 96458 | 96458 | 116067 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 4150X CLEMENT ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 89948 | 89948 | 98838 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1101X Portola Dr | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5994967.957909999 | 2097979.30417 | 37.740362747150996 | -122.459979297607 | (37.740362747151, -122.459979297607) | |||
| 107428 | 107428 | 101036 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||
| 118896 | 118896 | 101040 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1010X Portola Dr | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||
| 118805 | 118805 | 2266 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 22 | 14M | Permit Number 772491 | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |
| 102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 9654 | 9654 | 114138 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/16/2016 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 125546 | 125546 | 27294 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 02/12/2001 12:00:00 AM | 6 | 5X5 | 5982752.16339 | 2112399.44122 | 37.77924621575129 | -122.503283404585 | (37.7792462157513, -122.503283404585) | ||
| 92410 | 92410 | 98278 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 500 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
| 110779 | 110779 | 98279 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 501 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
| 280 | 280 | 194427 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 1103 | 1103 | 211013 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.47222310103399 | (37.727880584217, -122.472223101034) | |||
| 1116 | 1116 | 8576 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | |||
| 1548 | 1548 | 8472 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6002074.2026 | 2113678.2789 | 37.7838744530021 | -122.436532136471 | (37.7838744530021, -122.436532136471) | |||
| 2179 | 2179 | 252925 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 4472 | 4472 | 8393 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004320.9581 | 2113985.4149 | 37.7848451877241 | -122.428781097193 | (37.7848451877241, -122.428781097193) | |||
| 4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
| 4769 | 4769 | 194422 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 5ft | 6007901.53326 | 2109054.5781799997 | 37.771508291196 | -122.41604412194401 | (37.771508291196, -122.416044121944) | |||
| 5263 | 5263 | 8574 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6001134.4053 | 2113480.9790000003 | 37.783279269060294 | -122.43976932905301 | (37.7832792690603, -122.439769329053) | |||
| 5271 | 5271 | 8390 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.784923768316396 | -122.428202546761 | (37.7849237683164, -122.428202546761) | |||
| 5273 | 5273 | 8391 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004438.3798 | 2114005.2394 | 37.784906265949004 | -122.428376269712 | (37.784906265949, -122.428376269712) | |||
| 5280 | 5280 | 8392 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004378.143999999 | 2113996.8521 | 37.784879827842296 | -122.428584068109 | (37.7848798278423, -122.428584068109) | |||
| 5311 | 5311 | 8577 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.783194913277796 | -122.440376203878 | (37.7831949132778, -122.440376203878) | |||
| 6394 | 6394 | 8581 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | |||
| 6395 | 6395 | 8394 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004234.0356 | 2113977.7901 | 37.784819331933 | -122.429081276927 | (37.784819331933, -122.429081276927) | |||
| 6405 | 6405 | 8469 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6002244.0904 | 2113695.2 | 37.7839305664786 | -122.435945599699 | (37.7839305664786, -122.435945599699) | |||
| 6701 | 6701 | 8474 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001879.2717 | 2113651.8819999998 | 37.7837908949329 | -122.437204633286 | (37.7837908949329, -122.437204633286) | |||
| 7041 | 7041 | 20305 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 7070 | 7070 | 8575 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | |||
| 7257 | 7257 | 8535 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2100 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001300.5704 | 2113502.1304 | 37.7833468021346 | -122.439195981768 | (37.7833468021346, -122.439195981768) | |||
| 7433 | 7433 | 19666 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 7700 | 7700 | 8586 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.782952673809795 | -122.442300177437 | (37.7829526738098, -122.442300177437) | |||
| 8091 | 8091 | 8578 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6000905.6321 | 2113444.4294 | 37.7831658887746 | -122.44055816885599 | (37.7831658887746, -122.440558168856) | |||
| 8635 | 8635 | 8582 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6000649.7853 | 2113412.1102 | 37.7830625764785 | -122.441440973241 | (37.7830625764785, -122.441440973241) | |||
| 9646 | 9646 | 114139 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9658 | 9658 | 114124 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9665 | 9665 | 114123 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9672 | 9672 | 114137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9686 | 9686 | 173637 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | ||||
| 9922 | 9922 | 173745 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
| 9930 | 9930 | 173744 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
| 9932 | 9932 | 173746 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
| 10919 | 10919 | 19986 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY46 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 11206 | 11206 | 20301 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 11841 | 11841 | 19663 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 11943 | 11943 | 19664 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 14276 | 14276 | 19667 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 16176 | 16176 | 19976 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY45 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 16885 | 16885 | 19980 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY45 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 18019 | 18019 | 111271 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 42 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 20409 | 20409 | 4367 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 973 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001101.12966 | 2096102.69208 | 37.7355608412513 | -122.438638832041 | (37.7355608412513, -122.438638832041) | |||
| 25615 | 25615 | 178137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992316.61451 | 2087859.0919400002 | 37.712422298533895 | -122.46841041712901 | (37.7124222985339, -122.468410417129) |
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");