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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
344 | 344 | 251279 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | |||
393 | 393 | 251277 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/26/2011 12:00:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
409 | 409 | 251278 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 01/27/2016 09:31:00 AM | 3x3 | 6017356.0 | 2095183.0 | 37.733946845802 | -122.38237501907301 | (37.733946845802, -122.382375019073) | ||
3794 | 3794 | 29684 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6006028.673359999 | 2117355.72849 | 37.7941957348865 | -122.42311259358699 | (37.7941957348865, -122.423112593587) | ||||
5306 | 5306 | 23582 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005497.77155 | 2121198.52122 | 37.8047170896849 | -122.425223146826 | (37.8047170896849, -122.425223146826) | ||
5461 | 5461 | 23583 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3100X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005493.5455 | 2121226.7269099997 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | |||
8228 | 8228 | 23389 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006261.55669 | 2115711.13882 | 37.789693241290294 | -122.42218989455499 | (37.7896932412903, -122.422189894555) | |||
10392 | 10392 | 778 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1800X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 5984768.5556 | 2102340.232 | 37.7517447878795 | -122.49556583438999 | (37.7517447878795, -122.49556583439) | ||
13463 | 13463 | 29643 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015873.397999999 | 2095908.1157 | 37.7358558618741 | -122.38755144424499 | (37.7358558618741, -122.387551444245) | ||
13482 | 13482 | 3542 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 201X Cargo Way | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018537.99972 | 2097717.76917 | 37.7409720404334 | -122.378464368331 | (37.7409720404334, -122.378464368331) | ||
13627 | 13627 | 14879 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017057.00036 | 2098638.4724 | 37.743418358272706 | -122.383649254902 | (37.7434183582727, -122.383649254902) | |||
13711 | 13711 | 14895 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 3 | 3x3 | 6017124.7449900005 | 2098611.99106 | 37.743349390171105 | -122.383413165805 | (37.7433493901711, -122.383413165805) | ||
13742 | 13742 | 14945 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 200X Mendell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016835.656690001 | 2097927.0465 | 37.7414526902904 | -122.384365073909 | (37.7414526902904, -122.384365073909) | ||
13929 | 13929 | 30093 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 825 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 5 | 3x3 | 6015971.70273 | 2096663.92655 | 37.7379366099878 | -122.38726426784099 | (37.7379366099878, -122.387264267841) | ||
14574 | 14574 | 14944 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 200X Mendell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6016843.847680001 | 2097941.18235 | 37.7414919573859 | -122.384337736299 | (37.7414919573859, -122.384337736299) | ||
14657 | 14657 | 12132 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1400X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:53:00 AM | 3 | 3X3 | 6016426.995019999 | 2095242.04569 | 37.734057614557 | -122.385591017134 | (37.734057614557, -122.385591017134) | ||
14722 | 14722 | 14988 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 500 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2013 12:00:00 AM | 3 | 3x3 | 6016447.53347 | 2097406.0602 | 37.7400006988631 | -122.38567078067801 | (37.7400006988631, -122.385670780678) | ||
15131 | 15131 | 29653 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015651.7407 | 2096073.8877 | 37.73629875843729 | -122.38832937401199 | (37.7362987584373, -122.388329374012) | ||
15542 | 15542 | 14893 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2008 12:00:00 AM | 3 | 3x3 | 6017107.5762 | 2098575.41356 | 37.7432480069006 | -122.38346998587 | (37.7432480069006, -122.38346998587) | ||
16046 | 16046 | 29655 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015616.5769 | 2096101.5164 | 37.7363726727082 | -122.388452878787 | (37.7363726727082, -122.388452878787) | ||
16064 | 16064 | 29654 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015636.0426 | 2096086.4462 | 37.736332371666705 | -122.388384525603 | (37.7363323716667, -122.388384525603) | ||
16312 | 16312 | 14882 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017027.26925 | 2098565.83494 | 37.7432172671691 | -122.383747002247 | (37.7432172671691, -122.383747002247) | |||
16415 | 16415 | 3521 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 201X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018183.10085 | 2097983.12019 | 37.7416810722141 | -122.379709922198 | (37.7416810722141, -122.379709922198) | |||
16517 | 16517 | 14896 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/15/2016 12:00:00 AM | 3 | 3x3 | 6017148.9857 | 2098654.5103700003 | 37.743467479245794 | -122.38333230594601 | (37.7434674792458, -122.383332305946) | ||
23027 | 23027 | 14877 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 50 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017083.42225 | 2098683.73205 | 37.7435440924819 | -122.383561044027 | (37.7435440924819, -122.383561044027) | |||
23243 | 23243 | 14987 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 500 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 2 | 3X3 | 6016458.61367 | 2097424.13027 | 37.7400509287079 | -122.38563372862 | (37.7400509287079, -122.38563372862) | ||
23362 | 23362 | 1241 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3702X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X5 | 5992970.26911 | 2087627.9134799999 | 37.711825271896 | -122.466134417365 | (37.711825271896, -122.466134417365) | |||
33536 | 33536 | 214009 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5995820.98998 | 2092615.99547 | 37.725685426336206 | -122.45664209927799 | (37.7256854263362, -122.456642099278) | |||
35652 | 35652 | 249474 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6006395.0323 | 2114736.35179 | 37.7870242450239 | -122.421658817911 | (37.7870242450239, -122.421658817911) | ||||
37625 | 37625 | 119298 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 6700x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5986043.64284 | 2112521.4673099997 | 37.77977419975021 | -122.491905961239 | (37.7797741997502, -122.491905961239) | ||||
49786 | 49786 | 249475 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6006389.52859 | 2114780.4065099997 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | ||||
52916 | 52916 | 27593 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2200X San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/2001 12:00:00 AM | 12 | 3X3 | 6010149.0566544 | 2095763.2891253997 | 37.7351394742744 | -122.407332636882 | (37.7351394742744, -122.407332636882) | ||
68645 | 68645 | 249487 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6006262.64335 | 2115713.0194599996 | 37.789698466352704 | -122.42218626847901 | (37.7896984663527, -122.422186268479) | ||||
70317 | 70317 | 136294 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6006242.0943599995 | 2115852.50489 | 37.7900802996014 | -122.42226728033701 | (37.7900802996014, -122.422267280337) | ||||
77356 | 77356 | 10849 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1220X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 6 | 3X4 | 6017356.4574634 | 2095156.0177673001 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | ||
78265 | 78265 | 10877 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
78759 | 78759 | 23340 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1202X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 8 | 9x5 | 6006445.157123799 | 2114583.3806768996 | 37.7866070504124 | -122.42147452901001 | (37.7866070504124, -122.42147452901) | ||
78867 | 78867 | 1243 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3700X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/2004 12:00:00 AM | 3 | 3X5 | 5993218.71389 | 2087629.4001799999 | 37.71184368475021 | -122.46527583828698 | (37.7118436847502, -122.465275838287) | ||
79309 | 79309 | 10879 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1175X Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
80111 | 80111 | 10795 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x4 | 6017417.868009999 | 2094975.5240099998 | 37.733380574977204 | -122.382146691971 | (37.7333805749772, -122.382146691971) | ||
80247 | 80247 | 95980 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 6700 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 6 | 5986162.43558 | 2112587.6567 | 37.7799628795758 | -122.49149988415199 | (37.7799628795758, -122.491499884152) | |||
81890 | 81890 | 23390 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2003 12:00:00 AM | 6 | 9 | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | ||
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) | ||
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) | ||
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||||
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) | |||
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) | ||
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) | ||
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) | ||
145922 | 145922 | 23366 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1356X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/01/2003 12:00:00 AM | 6 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | ||
154476 | 154476 | 249478 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1300x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6006350.91475 | 2115079.54882 | 37.7879640914292 | -122.421835842261 | (37.7879640914292, -122.421835842261) | ||||
169889 | 169889 | 249473 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6006432.644069999 | 2114489.3949 | 37.7863482830936 | -122.42151114382901 | (37.7863482830936, -122.421511143829) | ||||
179912 | 179912 | 249490 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6006241.6595 | 2115852.2639200003 | 37.7900796134287 | -122.42226876779101 | (37.7900796134287, -122.422268767791) | ||||
183866 | 183866 | 136293 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6006248.16207 | 2115803.32411 | 37.789945603663604 | -122.42224279089899 | (37.7899456036636, -122.422242790899) | ||||
186488 | 186488 | 249476 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6006383.25331 | 2114827.68427 | 37.78727435725771 | -122.421706060208 | (37.7872743572577, -122.421706060208) |
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");