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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88368 | 88368 | 8563 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | |||
89362 | 89362 | 8562 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 3X3 | 6001214.7912099995 | 2113518.75863 | 37.7833875775095 | -122.43949393557101 | (37.7833875775095, -122.439493935571) | |||
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) | ||
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) | ||||
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) | ||
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) | ||
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) | ||
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) | |
100839 | 100839 | 111575 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1x SUNSET BLVD OFF RAMP | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 3x3 | 5984955.0 | 2095624.0 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | |||
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) | |
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) | ||
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) | ||
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 | ||||||||
141886 | 141886 | 21459 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2701X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
117254 | 117254 | 24789 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.779435386439204 | -122.50204978501301 | (37.7794353864392, -122.502049785013) | |||
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) | ||
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) | ||
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) | ||
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 | |||||||||
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) | ||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | ||
80466 | 80466 | 8349 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 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) | ||
88546 | 88546 | 8341 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 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) | ||
115283 | 115283 | 8342 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
117891 | 117891 | 8351 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
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) | ||
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 | ||||||||
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 | ||||||||
79809 | 79809 | 21491 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
84253 | 84253 | 21431 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
117137 | 117137 | 21429 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
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 | ||||||||
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 | ||||||||
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) | |||
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) | ||
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) | |||
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) | |||
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) | ||
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) | |||
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) | ||
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) | |||
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) | |||
25884 | 25884 | 186251 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1701 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984830.2927 | 2103110.5403 | 37.7538634572036 | -122.495409148018 | (37.7538634572036, -122.495409148018) | |||
28596 | 28596 | 186468 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984781.1405 | 2103769.7876 | 37.755670689824704 | -122.495627747424 | (37.7556706898247, -122.495627747424) | |||
28677 | 28677 | 187129 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 0ft | 5985149.8207 | 2097410.2322 | 37.738230663406604 | -122.493884107972 | (37.7382306634066, -122.493884107972) | |||
29067 | 29067 | 211025 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 95 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991234.71561 | 2092082.53367 | 37.723956281843705 | -122.472457461651 | (37.7239562818437, -122.472457461651) | |||
29859 | 29859 | 178135 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992385.6999699995 | 2087851.7958799999 | 37.7124062555186 | -122.46817110840401 | (37.7124062555186, -122.468171108404) | |||
30200 | 30200 | 185930 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985039.332 | 2101497.8374 | 37.7494476553955 | -122.494567371863 | (37.7494476553955, -122.494567371863) | |||
33005 | 33005 | 211017 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991258.9422 | 2092457.39845 | 37.724986969654495 | -122.47240103009399 | (37.7249869696545, -122.472401030094) | |||
33800 | 33800 | 178161 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 16 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5993106.56964 | 2087853.50799 | 37.7124525633948 | -122.46567970845899 | (37.7124525633948, -122.465679708459) | |||
34685 | 34685 | 200547 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016201.7309 | 2095635.0286 | 37.7351242000527 | -122.386397222999 | (37.7351242000527, -122.386397222999) | |||
35161 | 35161 | 211021 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991241.40021 | 2092233.4270099998 | 37.7243709844069 | -122.472445349599 | (37.7243709844069, -122.472445349599) | |||
35365 | 35365 | 186855 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985186.2801 | 2096278.9071 | 37.735126479902895 | -122.49367471051 | (37.7351264799029, -122.49367471051) | |||
36257 | 36257 | 186440 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984767.7413 | 2103960.7256 | 37.7561941679911 | -122.495688168642 | (37.7561941679911, -122.495688168642) | |||
36495 | 36495 | 178150 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 21 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991622.99627 | 2087995.81221 | 37.71275761073721 | -122.47081770347401 | (37.7127576107372, -122.470817703474) | |||
37001 | 37001 | 185960 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984855.8243 | 2101346.8117 | 37.7490222380818 | -122.49519080130301 | (37.7490222380818, -122.495190801303) | |||
37263 | 37263 | 185562 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2201 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.299 | 2099768.8111 | 37.7446909699364 | -122.494986371806 | (37.7446909699364, -122.494986371806) | |||
37669 | 37669 | 211009 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 25 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991341.559830001 | 2093667.8062200001 | 37.728315229259 | -122.472203623507 | (37.728315229259, -122.472203623507) | |||
38117 | 38117 | 185308 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985001.1798 | 2097292.5499 | 37.737898841519105 | -122.494389354717 | (37.7378988415191, -122.494389354717) | |||
38392 | 38392 | 178159 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 14 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993218.97583 | 2087844.63687 | 37.7124346884772 | -122.465290557432 | (37.7124346884772, -122.465290557432) | |||
39074 | 39074 | 186875 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985206.2214 | 2096387.7822 | 37.7354265885186 | -122.493613787113 | (37.7354265885186, -122.493613787113) | |||
40640 | 40640 | 178151 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5993597.52442 | 2087641.3827799999 | 37.7118984245322 | -122.46396744335199 | (37.7118984245322, -122.463967443352) | |||
40730 | 40730 | 178130 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5992655.54446 | 2087848.4586 | 37.7124126730818 | -122.4672382093 | (37.7124126730818, -122.4672382093) | |||
41068 | 41068 | 211024 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 94 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991236.61569 | 2092101.4351299999 | 37.7240082905392 | -122.472452270761 | (37.7240082905392, -122.472452270761) | |||
44219 | 44219 | 186081 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1901 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984821.8866 | 2101948.8735 | 37.7506733477582 | -122.49535255189899 | (37.7506733477582, -122.495352551899) | |||
44224 | 44224 | 186691 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984728.0673 | 2105259.502 | 37.7597579231437 | -122.49592118002701 | (37.7597579231437, -122.495921180027) | |||
44889 | 44889 | 178131 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992618.59421 | 2087849.2354599999 | 37.7124126730667 | -122.46736597596501 | (37.7124126730667, -122.467365975965) | |||
44904 | 44904 | 211027 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 157 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991179.7136 | 2091396.7999900002 | 37.7220702434165 | -122.47259762098 | (37.7220702434165, -122.47259762098) | |||
45126 | 45126 | 200542 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016191.4179 | 2095647.8311 | 37.735158782265394 | -122.38643377144 | (37.7351587822654, -122.38643377144) | |||
45298 | 45298 | 186040 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1900 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985014.7934 | 2102133.6877 | 37.7511920899125 | -122.49469909773998 | (37.7511920899125, -122.49469909774) | |||
45572 | 45572 | 200536 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016175.6148 | 2095666.5235 | 37.7352092330314 | -122.38648971191002 | (37.7352092330314, -122.38648971191) |
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");