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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
119708 | 119708 | 98480 | Permitted Site 1 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 531X Franconia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
119921 | 119921 | 92522 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6009005.0 | 2109688.0 | 37.773309499001996 | -122.412271934387 | (37.773309499002, -122.412271934387) | ||
123447 | 123447 | 43449 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999756.32409 | 2091134.05765 | 37.7218415305512 | -122.442931628018 | (37.7218415305512, -122.442931628018) | |
125403 | 125403 | 91180 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
126214 | 126214 | 91181 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
126279 | 126279 | 41431 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 352-360 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2005 12:00:00 AM | Permit Number 42039 | 6011197.0 | 2111276.0 | 37.7777925370097 | -122.40480128596201 | (37.7777925370097, -122.404801285962) | |||
127072 | 127072 | 99201 | Permitted Site 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | DPW 2 | FUF 1 | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | ||
128147 | 128147 | 98486 | Permitted Site 1 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 531X Franconia St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
133363 | 133363 | 43450 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999728.91774 | 2091148.65353 | 37.72188004492379 | -122.443027412104 | (37.7218800449238, -122.443027412104) | |
134509 | 134509 | 43456 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999514.70275 | 2091259.45123 | 37.722172053891704 | -122.44377585219699 | (37.7221720538917, -122.443775852197) | |
135134 | 135134 | 43451 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.131580001 | 2091140.9715900002 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | |
137253 | 137253 | 43440 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999628.40371 | 2091200.8294 | 37.722017576445204 | -122.44337860813499 | (37.7220175764452, -122.443378608135) | |
138660 | 138660 | 18033 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2800X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2013 12:00:00 AM | 18 | 3X3 | Permit Number 769913 | 6000469.28268 | 2114833.17246 | 37.7869541618338 | -122.44216747883002 | (37.7869541618338, -122.44216747883) | |
139243 | 139243 | 98475 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
139756 | 139756 | 539 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2862 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2016 07:55:00 AM | 3 | 3X3 | 6009630.84107 | 2102242.33848 | 37.752900508699206 | -122.40958144339399 | (37.7529005086992, -122.409581443394) | ||
141160 | 141160 | 95162 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 932 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2013 12:00:00 AM | 3 | 3x3 | 6001579.15015 | 2111647.55622 | 37.778270460106 | -122.438099315048 | (37.778270460106, -122.438099315048) | ||
141680 | 141680 | 107889 | Permitted Site 1 | Tree(s) :: 17 | 941 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 11/03/2014 12:00:00 AM | 3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | |
141796 | 141796 | 98484 | Permitted Site 1 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 531X Franconia St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
143298 | 143298 | 98479 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
143402 | 143402 | 98476 | Permitted Site 1 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 531X Franconia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
143504 | 143504 | 98481 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
144928 | 144928 | 98487 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
147696 | 147696 | 43438 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999550.19859 | 2091242.74615 | 37.7221282101348 | -122.443651952598 | (37.7221282101348, -122.443651952598) | |
153063 | 153063 | 43436 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999647.9704599995 | 2091192.0487400002 | 37.721994582572606 | -122.44331034060801 | (37.7219945825726, -122.443310340608) | |
154142 | 154142 | 91184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | 5 | Permit Number 51891 | 6007394.40571 | 2110929.76906 | 37.776628592972 | -122.417931258428 | (37.776628592972, -122.417931258428) | |
155143 | 155143 | 43447 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999697.54909 | 2091165.42889 | 37.7219243176433 | -122.443137049362 | (37.7219243176433, -122.443137049362) | |
162227 | 162227 | 111441 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 5 | 5999897.1183 | 2091063.84845 | 37.721656778309494 | -122.442439902078 | (37.7216567783095, -122.442439902078) | |||
162642 | 162642 | 43446 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999670.6407 | 2091179.60867 | 37.721961717728 | -122.44323108247299 | (37.721961717728, -122.443231082473) | |
180178 | 180178 | 111442 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 8 | 5999909.42688 | 2091057.1743400001 | 37.721639154299204 | -122.44239687581002 | (37.7216391542992, -122.44239687581) | |||
181064 | 181064 | 43454 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 11 | Permit Number 43162 | 5999613.63458 | 2091208.86715 | 37.722038804018204 | -122.443430238238 | (37.7220388040182, -122.443430238238) | |
182202 | 182202 | 111445 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 7 | 5999980.8477300005 | 2091017.84349 | 37.721535231343296 | -122.442147171851 | (37.7215352313433, -122.442147171851) | |||
183638 | 183638 | 111439 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 6 | 5999870.68262 | 2091075.2427400001 | 37.721686557579204 | -122.44253210058201 | (37.7216865575792, -122.442532100582) | |||
187095 | 187095 | 43432 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999683.18724 | 2091173.0602 | 37.7219444525549 | -122.443187242296 | (37.7219444525549, -122.443187242296) | |
185 | 185 | 251243 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008953.0 | 2098186.0 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | ||||
761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
825 | 825 | 244349 | Undocumented 2 | Shrub :: Shrub 98 | 300 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:48:00 PM | 3 | Width 0ft | 6005619.6911 | 2110403.6421 | 37.77508393621179 | -122.424033097665 | (37.7750839362118, -122.424033097665) | ||
1276 | 1276 | 229197 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3186 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 4x4 | 6008575.05448 | 2100617.97477 | 37.7483811527748 | -122.41311771451599 | (37.7483811527748, -122.413117714516) | |||
1278 | 1278 | 231178 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3298 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x6 | 6007881.72523 | 2100615.5936 | 37.7483356677609 | -122.41551506969101 | (37.7483356677609, -122.415515069691) | ||
1280 | 1280 | 231193 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x6 | 6007038.27508 | 2100609.92371 | 37.7482726540762 | -122.41843130396799 | (37.7482726540762, -122.418431303968) | ||
1281 | 1281 | 231175 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 4x4 | 6008989.553669999 | 2100618.8922900003 | 37.7484069327314 | -122.41168444520599 | (37.7484069327314, -122.411684445206) | ||
1284 | 1284 | 235428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2869 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | 3x3 | 6010306.81938 | 2100635.6894799997 | 37.74852686004171 | -122.40713053105101 | (37.7485268600417, -122.407130531051) | ||
1285 | 1285 | 234575 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2990 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009677.1610900005 | 2100624.0529099996 | 37.7484596510092 | -122.409307067568 | (37.7484596510092, -122.409307067568) | ||
1291 | 1291 | 234571 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2892 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x4 | 6010196.53099 | 2100680.54575 | 37.7486438528311 | -122.407515070373 | (37.7486438528311, -122.407515070373) | ||
1296 | 1296 | 231177 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6008330.40398 | 2100615.02413 | 37.7483593136265 | -122.41396350442 | (37.7483593136265, -122.41396350442) | |||
1304 | 1304 | 231176 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3100 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008965.15097 | 2100617.87341 | 37.7484027661782 | -122.411768757547 | (37.7484027661782, -122.411768757547) | |||
1308 | 1308 | 231174 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3092 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6009165.99895 | 2100621.73745 | 37.7484246412851 | -122.411074499805 | (37.7484246412851, -122.411074499805) | |||
1311 | 1311 | 237352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3186 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6008549.69387 | 2100618.49329 | 37.7483811527756 | -122.413205447889 | (37.7483811527756, -122.413205447889) | |||
2100 | 2100 | 178279 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.714643374877895 | -122.48368218070499 | (37.7146433748779, -122.483682180705) | |||
2206 | 2206 | 252954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2208 | 2208 | 252955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2370 | 2370 | 112542 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.9257400003 | 37.7982159634572 | -122.40460495956002 | (37.7982159634572, -122.40460495956) | ||
2573 | 2573 | 253125 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 1 Oak Park Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5996419.0 | 2103319.0 | 37.7551075738744 | -122.455348004876 | (37.7551075738744, -122.455348004876) | ||||
3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
4899 | 4899 | 109487 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 10/31/2017 02:27:00 PM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
5081 | 5081 | 253792 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5085 | 5085 | 253795 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5092 | 5092 | 253791 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
6247 | 6247 | 112539 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | ||
6998 | 6998 | 112530 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.40458390283199 | (37.7980434339179, -122.404583902832) | ||
9596 | 9596 | 102839 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
9702 | 9702 | 104171 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2607 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6002306.0 | 2096613.0 | 37.7370304975493 | -122.43450961762501 | (37.7370304975493, -122.434509617625) | |||
10209 | 10209 | 173905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1930 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6004432.0 | 2115392.0 | 37.7887136017889 | -122.428497222364 | (37.7887136017889, -122.428497222364) | ||||
10214 | 10214 | 173907 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 Jerrold Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6012443.0 | 2099218.0 | 37.7447535037256 | -122.399644080592 | (37.7447535037256, -122.399644080592) | |||||
10276 | 10276 | 82028 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2787 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2017 09:51:00 AM | 3 | 6000618.2299 | 2114794.6459999997 | 37.7868568655877 | -122.441649390834 | (37.7868568655877, -122.441649390834) | |||
10756 | 10756 | 110237 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Winston Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | 6x18 | 5989487.1744800005 | 2093569.3277200002 | 37.7279373404144 | -122.47860704469 | (37.7279373404144, -122.47860704469) | |||
11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
11524 | 11524 | 78382 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 606 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2000 12:00:00 AM | 12 | 6001696.66297 | 2089972.42102 | 37.7187623714737 | -122.436141300492 | (37.7187623714737, -122.436141300492) | |||
13240 | 13240 | 187608 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
13241 | 13241 | 187609 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 100 Northridge Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018548.0 | 2094208.0 | 37.7313354560629 | -122.37818620453699 | (37.7313354560629, -122.378186204537) | ||||
13243 | 13243 | 187610 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 100 Northridge Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018548.0 | 2094208.0 | 37.7313354560629 | -122.37818620453699 | (37.7313354560629, -122.378186204537) | ||||
13246 | 13246 | 187614 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
13247 | 13247 | 187613 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
13248 | 13248 | 187615 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
13249 | 13249 | 187612 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
13250 | 13250 | 187606 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
13251 | 13251 | 187611 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 100 Northridge Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018548.0 | 2094208.0 | 37.7313354560629 | -122.37818620453699 | (37.7313354560629, -122.378186204537) | ||||
13256 | 13256 | 187607 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
15108 | 15108 | 117609 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1227 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6009518.3962 | 2110117.1687 | 37.774516691037505 | -122.41052633045099 | (37.7745166910375, -122.410526330451) | |||
15485 | 15485 | 111661 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1398x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/25/2015 01:32:00 PM | 3 | 3x3 | 6011721.86925 | 2101900.7924099998 | 37.7520796461774 | -122.402326221379 | (37.7520796461774, -122.402326221379) | ||
16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
24536 | 24536 | 112533 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 381 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 5x5 | 6011666.379930001 | 2118683.35655 | 37.7981576118354 | -122.403698857532 | (37.7981576118354, -122.403698857532) | |||
26254 | 26254 | 116994 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 600M Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6001630.0135 | 2110553.7073 | 37.775269918649705 | -122.43784499428999 | (37.7752699186497, -122.43784499429) | ||||
30520 | 30520 | 108631 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008465.6 | 2113811.6 | 37.784601639353795 | -122.41442963530001 | (37.7846016393538, -122.4144296353) | ||||
35219 | 35219 | 136329 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6011341.08824 | 2118636.57968 | 37.7980109971731 | -122.404821173685 | (37.7980109971731, -122.404821173685) | |||
35927 | 35927 | 117079 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1520 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5x5 | 6003184.5706 | 2113558.6463 | 37.7836090062437 | -122.43268212910499 | (37.7836090062437, -122.432682129105) | |||
39902 | 39902 | 117084 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1548 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5x5 | 6003183.0 | 2113711.0 | 37.7840272420603 | -122.43269844956801 | (37.7840272420603, -122.432698449568) | |||
42744 | 42744 | 113684 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
43899 | 43899 | 214548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 4ft | 5993241.508719999 | 2106665.1801299998 | 37.7641124834295 | -122.46657980664 | (37.7641124834295, -122.46657980664) | |||
44055 | 44055 | 111970 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 1x STORRIE ST | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | |||
45047 | 45047 | 111915 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2107 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6012063.63789 | 2087784.79558 | 37.7133391339723 | -122.400153039325 | (37.7133391339723, -122.400153039325) | |||
45602 | 45602 | 109669 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 200X GELLERT DR | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||
46733 | 46733 | 112534 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 381 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 5x5 | 6011694.00633 | 2118688.46507 | 37.7981731818154 | -122.40360362112601 | (37.7981731818154, -122.403603621126) | |||
46910 | 46910 | 116450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299X Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6016873.48707 | 2095860.59847 | 37.735780731778895 | -122.384090400246 | (37.7357807317789, -122.384090400246) | ||||
48328 | 48328 | 117078 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1506 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 5x5 | 6003016.0 | 2114040.0 | 37.7849211205465 | -122.433299725252 | (37.7849211205465, -122.433299725252) | |||
51510 | 51510 | 113673 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X THE EMBARCADERO | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6013440.0 | 2119057.0 | 37.7992824654164 | -122.3975877866 | (37.7992824654164, -122.3975877866) | ||||
54364 | 54364 | 112535 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011575.94717 | 2118734.81197 | 37.798293843836 | -122.404015406282 | (37.798293843836, -122.404015406282) |
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");