Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181963 | 181963 | 104417 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 12 | Permit Number 770730 | 6001763.35391 | 2121819.4095799997 | 37.8062102070855 | -122.438190954371 | (37.8062102070855, -122.438190954371) | ||
| 187574 | 187574 | 31676 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770730 | 6001735.33868 | 2121814.4309799997 | 37.806194943810894 | -122.438287548749 | (37.8061949438109, -122.438287548749) | |||
| 160931 | 160931 | 126014 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2322 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5999611.42315 | 2120546.01877 | 37.8025911966964 | -122.445546423945 | (37.8025911966964, -122.445546423945) | |||
| 57244 | 57244 | 126010 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 85 Toledo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001465.00623 | 2119940.72568 | 37.801034867711 | -122.43908870440599 | (37.801034867711, -122.439088704406) | |||
| 137612 | 137612 | 116891 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2798X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5999182.98236 | 2118335.47511 | 37.796497168372795 | -122.446869879744 | (37.7964971683728, -122.446869879744) | |||
| 171439 | 171439 | 126013 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 5999233.22196 | 2117805.48778 | 37.795044834292895 | -122.44665788886499 | (37.7950448342929, -122.446657888865) | |||
| 23690 | 23690 | 126012 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5999234.571959999 | 2117780.83993 | 37.7949772349663 | -122.446651443424 | (37.7949772349663, -122.446651443424) | |||
| 166960 | 166960 | 126011 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 7ft | 5999243.15513 | 2117721.3039700002 | 37.7948142553315 | -122.446617458939 | (37.7948142553315, -122.446617458939) | |||
| 34064 | 34064 | 126015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009674.03362 | 2115055.86699 | 37.788085909974605 | -122.410336729273 | (37.7880859099746, -122.410336729273) | |||
| 181010 | 181010 | 126016 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009654.60353 | 2115055.05542 | 37.7880825923961 | -122.410403896944 | (37.7880825923961, -122.410403896944) | |||
| 32476 | 32476 | 126017 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009644.05128 | 2115053.2571900003 | 37.788077063340204 | -122.410440279012 | (37.7880770633402, -122.410440279012) | |||
| 131352 | 131352 | 126018 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009631.44446 | 2115049.8898 | 37.788067110556604 | -122.41048365871 | (37.7880671105566, -122.41048365871) | |||
| 37175 | 37175 | 126019 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 542 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6009096.37686 | 2114637.77725 | 37.7869055381056 | -122.412305766101 | (37.7869055381056, -122.412305766101) | |||
| 181029 | 181029 | 126020 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009058.631990001 | 2114632.0881 | 37.786887798972295 | -122.412435952882 | (37.7868877989723, -122.412435952882) | |||
| 188409 | 188409 | 126023 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 560 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009008.4198 | 2114630.0994700002 | 37.7868795207321 | -122.412609535497 | (37.7868795207321, -122.412609535497) | |||
| 34786 | 34786 | 126022 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009023.96612 | 2114628.9203 | 37.786877155513004 | -122.412555665234 | (37.786877155513, -122.412555665234) | |||
| 188481 | 188481 | 126021 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009038.2153900005 | 2114627.76765 | 37.7868747902962 | -122.412506284359 | (37.7868747902962, -122.412506284359) | |||
| 134896 | 134896 | 120285 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 151 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988326.80885 | 2115016.043 | 37.7867567842415 | -122.484190580999 | (37.7867567842415, -122.484190580999) | ||||
| 182738 | 182738 | 117701 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983015.82317 | 2113078.8166099996 | 37.7811270768141 | -122.502421605789 | (37.7811270768141, -122.502421605789) | |||
| 57727 | 57727 | 117702 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5983001.87469 | 2113075.50324 | 37.781117159673705 | -122.50246961447901 | (37.7811171596737, -122.502469614479) | |||
| 16787 | 16787 | 100332 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768623 | 6013356.21451 | 2111717.71239 | 37.779125829518705 | -122.397362747904 | (37.7791258295187, -122.397362747904) | |
| 22913 | 22913 | 100331 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6013371.56305 | 2111703.84537 | 37.779088608380206 | -122.397308677969 | (37.7790886083802, -122.397308677969) | |||
| 167510 | 167510 | 100330 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6013394.216680001 | 2111677.27832 | 37.7790169225246 | -122.39722844584601 | (37.7790169225246, -122.397228445846) | |||
| 16169 | 16169 | 100329 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768623 | 6013411.2884599995 | 2111661.36797 | 37.7789741867392 | -122.39716827132 | (37.7789741867392, -122.39716827132) | |
| 57603 | 57603 | 100328 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6013422.40904 | 2111650.3481099997 | 37.778944547796705 | -122.397129027591 | (37.7789445477967, -122.397129027591) | |||
| 43790 | 43790 | 100327 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6013441.178619999 | 2111631.13985 | 37.7788928511631 | -122.39706274847299 | (37.7788928511631, -122.397062748473) | |||
| 134762 | 134762 | 201676 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010275.73936 | 2109794.09532 | 37.7736720357783 | -122.40788373484301 | (37.7736720357783, -122.407883734843) | ||||
| 63791 | 63791 | 201677 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010264.4203699995 | 2109791.71635 | 37.7736648699818 | -122.407922721364 | (37.7736648699818, -122.407922721364) | ||||
| 27402 | 27402 | 201678 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010253.38486 | 2109790.37511 | 37.7736605694093 | -122.407960800466 | (37.7736605694093, -122.407960800466) | ||||
| 69677 | 69677 | 201679 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010240.772059999 | 2109788.80533 | 37.7736555529973 | -122.40800431955799 | (37.7736555529973, -122.408004319558) | ||||
| 72268 | 72268 | 201680 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010229.21797 | 2109787.73605 | 37.7736519701026 | -122.40804421168998 | (37.7736519701026, -122.40804421169) | ||||
| 159709 | 159709 | 201681 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6010219.21458 | 2109785.59098 | 37.7736455201492 | -122.408078663801 | (37.7736455201492, -122.408078663801) | ||||
| 70258 | 70258 | 201675 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010282.589459999 | 2109782.99387 | 37.7736419372697 | -122.40785925619801 | (37.7736419372697, -122.407859256198) | ||||
| 166477 | 166477 | 201674 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010278.21151 | 2109773.9479799997 | 37.773616854257604 | -122.407873762259 | (37.7736168542576, -122.407873762259) | ||||
| 151815 | 151815 | 201673 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010274.35746 | 2109764.89142 | 37.773591771276706 | -122.4078864553 | (37.7735917712767, -122.4078864553) | ||||
| 89297 | 89297 | 201672 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010270.770690001 | 2109756.0907799997 | 37.773567405955 | -122.407898241816 | (37.773567405955, -122.407898241816) | ||||
| 183572 | 183572 | 201671 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010268.2107 | 2109746.2247 | 37.7735401726656 | -122.407906401378 | (37.7735401726656, -122.407906401378) | ||||
| 177844 | 177844 | 190013 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 888 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 8ft | 6012319.46536 | 2108768.17498 | 37.7709692969125 | -122.40074203953002 | (37.7709692969125, -122.40074203953) | |||
| 40599 | 40599 | 190014 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 888 07th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 8ft | 6012452.605140001 | 2108628.1137900003 | 37.770592145536 | -122.400271663513 | (37.770592145536, -122.400271663513) | |||
| 71985 | 71985 | 190021 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015535.23888 | 2108524.8420599997 | 37.7704799937881 | -122.389601494338 | (37.7704799937881, -122.389601494338) | |||
| 174222 | 174222 | 190012 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 6ft | 6012453.688019999 | 2108575.49646 | 37.770447730615295 | -122.400264221637 | (37.7704477306153, -122.400264221637) | |||
| 49236 | 49236 | 190022 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015535.32333 | 2108481.6321099997 | 37.770361353431895 | -122.389598183934 | (37.7703613534319, -122.389598183934) | |||
| 44856 | 44856 | 190023 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015540.26875 | 2108442.1367599997 | 37.770253182080396 | -122.38957831879499 | (37.7702531820804, -122.389578318795) | |||
| 153266 | 153266 | 190024 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015540.58409 | 2108410.35977 | 37.7701659469215 | -122.389575008383 | (37.7701659469215, -122.389575008383) | |||
| 132041 | 132041 | 190025 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015543.83866 | 2108366.1327 | 37.7700446895441 | -122.389560661497 | (37.7700446895441, -122.389560661497) | |||
| 25509 | 25509 | 190026 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015544.83514 | 2108320.68008 | 37.769919941866895 | -122.389554039808 | (37.7699199418669, -122.389554039808) | |||
| 66360 | 66360 | 190027 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015553.64576 | 2108193.7384099998 | 37.7695718763733 | -122.389514697159 | (37.7695718763733, -122.389514697159) | |||
| 172905 | 172905 | 190028 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015555.80017 | 2108152.70829 | 37.7694593361018 | -122.389504379223 | (37.7694593361018, -122.389504379223) | |||
| 68768 | 68768 | 190029 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015559.81581 | 2108067.16285 | 37.7692246696975 | -122.38948451411999 | (37.7692246696975, -122.38948451412) | |||
| 130988 | 130988 | 190030 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015562.57352 | 2108029.9349599998 | 37.7691226029579 | -122.389472375051 | (37.7691226029579, -122.389472375051) | |||
| 27419 | 27419 | 190015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015573.49943 | 2107841.28907 | 37.768605228364 | -122.38942140686899 | (37.768605228364, -122.389421406869) | |||
| 163882 | 163882 | 190016 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015575.880530001 | 2107804.1814599996 | 37.7685034709891 | -122.38941057906099 | (37.7685034709891, -122.389410579061) | |||
| 181059 | 181059 | 190017 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015580.20075 | 2107759.76126 | 37.7683817423455 | -122.389392533258 | (37.7683817423455, -122.389392533258) | |||
| 182780 | 182780 | 190018 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015579.842180001 | 2107724.78714 | 37.7682856911689 | -122.38939133086399 | (37.7682856911689, -122.389391330864) | |||
| 49887 | 49887 | 190019 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015583.6961 | 2107674.48805 | 37.7681477945165 | -122.389374487455 | (37.7681477945165, -122.389374487455) | |||
| 160516 | 160516 | 190020 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015584.43667 | 2107642.2623 | 37.768059350697996 | -122.38936967519699 | (37.768059350698, -122.389369675197) | |||
| 97571 | 97571 | 225162 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2859 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007695.93122 | 2106747.75341 | 37.765162729690296 | -122.41659187291701 | (37.7651627296903, -122.416591872917) | |||
| 182331 | 182331 | 225163 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2859 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007679.26286 | 2106746.83875 | 37.7651592807999 | -122.416649460099 | (37.7651592807999, -122.416649460099) | |||
| 181288 | 181288 | 225164 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2861 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007651.46889 | 2106744.64503 | 37.7651516941295 | -122.416745437549 | (37.7651516941295, -122.416745437549) | |||
| 63388 | 63388 | 225185 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007746.072980001 | 2106673.2030700003 | 37.764960851679 | -122.41641316324 | (37.764960851679, -122.41641316324) | |||
| 166308 | 166308 | 225184 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007748.54808 | 2106641.05965 | 37.764872732518704 | -122.416402325519 | (37.7648727325187, -122.416402325519) | |||
| 76939 | 76939 | 225183 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007749.18821 | 2106563.04323 | 37.7646585535855 | -122.416394585035 | (37.7646585535855, -122.416394585035) | |||
| 147255 | 147255 | 225182 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007750.95097 | 2106539.82911 | 37.764594912141206 | -122.416386843697 | (37.7645949121412, -122.416386843697) | |||
| 166068 | 166068 | 225181 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007752.17494 | 2106512.16868 | 37.7645190318645 | -122.41638065094801 | (37.7645190318645, -122.416380650948) | |||
| 183184 | 183184 | 225180 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007753.3624 | 2106482.72591 | 37.7644382556423 | -122.416374458236 | (37.7644382556423, -122.416374458236) | |||
| 152995 | 152995 | 225179 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007756.33933 | 2106453.2465 | 37.764357479442 | -122.41636207364799 | (37.764357479442, -122.416362073648) | |||
| 55039 | 55039 | 225145 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 450 Florida St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6009179.2133599995 | 2106266.6276700003 | 37.76392497748579 | -122.41142754574899 | (37.7639249774858, -122.411427545749) | ||||
| 60112 | 60112 | 225210 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3641 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6004615.0966300005 | 2105985.22525 | 37.7628952609247 | -122.427193419352 | (37.7628952609247, -122.427193419352) | |||
| 155078 | 155078 | 32061 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3641 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 7 | Permit Number 35437 | 6004606.11173 | 2105983.62755 | 37.762890365909 | -122.4272243812 | (37.762890365909, -122.4272243812) | |
| 90022 | 90022 | 73786 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1996 12:00:00 AM | 6 | 3x3 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) | |
| 70063 | 70063 | 225186 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 252 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007150.88723 | 2105850.08612 | 37.762667276482894 | -122.418413397566 | (37.7626672764829, -122.418413397566) | |||
| 42492 | 42492 | 247161 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2399 Market St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 5ft | 6002372.95372 | 2105936.54637 | 37.7626345492748 | -122.43494472103998 | (37.7626345492748, -122.43494472104) | |||
| 154165 | 154165 | 246301 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3998 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6002344.4551 | 2105927.1578 | 37.7626071523851 | -122.435042615882 | (37.7626071523851, -122.435042615882) | |||
| 59914 | 59914 | 206025 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1366 16th Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5991157.5258599995 | 2106131.34791 | 37.76252624212071 | -122.473748679463 | (37.7625262421207, -122.473748679463) | |||
| 67868 | 67868 | 206024 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1366 16th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5991156.52884 | 2106111.8053099997 | 37.7624725256075 | -122.473750702041 | (37.7624725256075, -122.473750702041) | |||
| 156182 | 156182 | 189998 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1950 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011839.98262 | 2105629.53813 | 37.7623245520575 | -122.402179893599 | (37.7623245520575, -122.402179893599) | |||
| 60204 | 60204 | 189997 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1809 19th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6012307.781769999 | 2105132.0490099997 | 37.760984657528894 | -122.40052699363501 | (37.7609846575289, -122.400526993635) | |||
| 147063 | 147063 | 189996 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1809 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012291.07861 | 2105130.95435 | 37.7609807203027 | -122.400584686038 | (37.7609807203027, -122.400584686038) | |||
| 178754 | 178754 | 190010 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013000.60503 | 2104793.1604 | 37.7600927575897 | -122.398107028633 | (37.7600927575897, -122.398107028633) | |||
| 27211 | 27211 | 190009 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013000.6424 | 2104780.97852 | 37.7600593109036 | -122.39810604475099 | (37.7600593109036, -122.398106044751) | |||
| 154762 | 154762 | 190008 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013001.004319999 | 2104770.77292 | 37.7600313087249 | -122.39810407704901 | (37.7600313087249, -122.398104077049) | |||
| 45931 | 45931 | 190000 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 770 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6012104.84568 | 2104756.14819 | 37.7599411975544 | -122.401202450128 | (37.7599411975544, -122.401202450128) | |||
| 171539 | 171539 | 190001 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 790 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012095.84153 | 2104748.83564 | 37.759920616576 | -122.401233077439 | (37.759920616576, -122.401233077439) | ||||
| 52213 | 52213 | 190002 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 790 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012104.02513 | 2104748.44893 | 37.759920011313206 | -122.401204746997 | (37.7599200113132, -122.401204746997) | ||||
| 65401 | 65401 | 190004 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1745 20th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 6012733.96255 | 2104688.60274 | 37.7597908102085 | -122.399021884672 | (37.7597908102085, -122.399021884672) | |||
| 34445 | 34445 | 189999 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Carolina St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6012378.8382 | 2104615.7006200003 | 37.759570841431604 | -122.400244972539 | (37.7595708414316, -122.400244972539) | |||
| 180166 | 180166 | 225199 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3290 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008287.23317 | 2104481.08405 | 37.7589722149231 | -122.41438629998899 | (37.7589722149231, -122.414386299989) | |||
| 71331 | 71331 | 225208 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003395.5499 | 2104500.55449 | 37.758749668692495 | -122.431305421031 | (37.7587496686925, -122.431305421031) | |||
| 42322 | 42322 | 225209 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003378.3537099995 | 2104496.9744599997 | 37.7587388642274 | -122.431364637772 | (37.7587388642274, -122.431364637772) | |||
| 172254 | 172254 | 190033 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 651 Missouri St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6013606.61157 | 2104092.53416 | 37.7582027253025 | -122.39596202861901 | (37.7582027253025, -122.395962028619) | |||
| 181433 | 181433 | 190032 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 651 Missouri St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6013600.610230001 | 2104091.57262 | 37.7581997512359 | -122.395982716627 | (37.7581997512359, -122.395982716627) | |||
| 176830 | 176830 | 225187 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007244.27543 | 2104007.62921 | 37.7576135731224 | -122.417959784028 | (37.7576135731224, -122.417959784028) | |||
| 39929 | 39929 | 225188 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007247.90987 | 2103966.5437 | 37.757500966319604 | -122.417944302192 | (37.7575009663196, -122.417944302192) | |||
| 106572 | 106572 | 225189 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007250.88683 | 2103937.06131 | 37.757420182006605 | -122.41793191673901 | (37.7574201820066, -122.417931916739) | |||
| 27326 | 27326 | 190005 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012982.63799 | 2103818.56401 | 37.757415728567295 | -122.398100794529 | (37.7574157285673, -122.398100794529) | ||||
| 45520 | 45520 | 190006 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012982.38984 | 2103806.3309400002 | 37.7573821254062 | -122.398100794542 | (37.7573821254062, -122.398100794542) | ||||
| 148331 | 148331 | 190003 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1750 22nd St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6012781.6725699995 | 2103797.8962 | 37.7573477838951 | -122.398794366977 | (37.7573477838951, -122.398794366977) | ||||
| 158218 | 158218 | 190007 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012984.44615 | 2103792.30277 | 37.7573437216454 | -122.398092698838 | (37.7573437216454, -122.398092698838) | ||||
| 26101 | 26101 | 225190 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007254.11935 | 2103898.21255 | 37.7573136941774 | -122.41791798353998 | (37.7573136941774, -122.41791798354) | |||
| 165711 | 165711 | 225191 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007257.73573 | 2103878.07853 | 37.7572586143179 | -122.41790404944099 | (37.7572586143179, -122.417904049441) |
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");