Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH
PlantType ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110388 | 110388 | 112172 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010071.0 | 2112545.0 | 37.7812139111906 | -122.40878607767901 | (37.7812139111906, -122.408786077679) | ||||
| 51291 | 51291 | 100875 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 995 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6010609.42845 | 2112029.4559299997 | 37.7798284914364 | -122.406887026109 | (37.7798284914364, -122.406887026109) | ||||
| 188646 | 188646 | 100874 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 995 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6010596.8170300005 | 2112015.71985 | 37.7797900696951 | -122.40692968637501 | (37.7797900696951, -122.406929686375) | ||||
| 54820 | 54820 | 199491 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 991 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6010160.462780001 | 2112475.94927 | 37.7810293246804 | -122.408471707117 | (37.7810293246804, -122.408471707117) | |||
| 139382 | 139382 | 30858 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 70541 | 70541 | 102432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 4x4 | 6010557.78599 | 2112071.21552 | 37.779940263668706 | -122.40706862532801 | (37.7799402636687, -122.407068625328) | |||
| 146701 | 146701 | 102431 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6010575.8749400005 | 2112088.03468 | 37.7799874573922 | -122.40700723309601 | (37.7799874573922, -122.407007233096) | |||
| 120258 | 120258 | 28637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 955 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 24 | 5XX5 | 5996975.36021 | 2091606.08521 | 37.7229786625948 | -122.452578702244 | (37.7229786625948, -122.452578702244) | ||
| 129269 | 129269 | 28636 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 955 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 20 | 5X5 | 5996968.04232 | 2091607.5946900002 | 37.7229823879791 | -122.452604107446 | (37.7229823879791, -122.452604107446) | ||
| 16923 | 16923 | 24346 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 95 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6006149.34547 | 2108468.08439 | 37.769799248359796 | -122.422063370746 | (37.7697992483598, -122.422063370746) | |||
| 24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
| 161827 | 161827 | 203197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.39615821213499 | (37.7932554199655, -122.396158212135) | |||
| 165364 | 165364 | 203196 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 10ft | 6013792.252169999 | 2116838.17263 | 37.7932096975269 | -122.39621327133301 | (37.7932096975269, -122.396213271333) | |||
| 18428 | 18428 | 25049 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 30 | 20 | 6005065.417330001 | 2102966.79857 | 37.7546328277698 | -122.425421098419 | (37.7546328277698, -122.425421098419) | ||
| 21999 | 21999 | 25056 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291722999 | (37.7540464140318, -122.42537291723) | |||
| 23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
| 27058 | 27058 | 247653 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | |||
| 28662 | 28662 | 247652 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001539.54665 | 2108297.82153 | 37.7690706742937 | -122.437996315894 | (37.7690706742937, -122.437996315894) | |||
| 36914 | 36914 | 247654 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | |||
| 43387 | 43387 | 247655 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 11 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001504.48718 | 2108295.83572 | 37.769063227919105 | -122.43811744198601 | (37.7690632279191, -122.438117441986) | |||
| 52425 | 52425 | 247649 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001576.55462 | 2108299.96127 | 37.7690786539981 | -122.437868461073 | (37.7690786539981, -122.437868461073) | |||
| 60522 | 60522 | 247645 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001626.8491400005 | 2108303.83597 | 37.7690921528084 | -122.437694773193 | (37.7690921528084, -122.437694773193) | |||
| 130003 | 130003 | 247648 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001589.80232 | 2108300.84932 | 37.76908184567821 | -122.43782270177 | (37.7690818456782, -122.43782270177) | |||
| 131340 | 131340 | 247647 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001603.04575 | 2108301.54357 | 37.7690845049709 | -122.437776943351 | (37.7690845049709, -122.437776943351) | |||
| 133845 | 133845 | 247651 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 7 | : 4 | Tree 1 | Private 1 | 16 | Width 5ft | 6001551.81383 | 2108298.34241 | 37.7690728021064 | -122.437953921852 | (37.7690728021064, -122.437953921852) | |||
| 155493 | 155493 | 247650 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001564.47006 | 2108298.85523 | 37.7690749298967 | -122.437910181532 | (37.7690749298967, -122.437910181532) | |||
| 160869 | 160869 | 124558 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5995920.27647 | 2113881.21497 | 37.7840800415509 | -122.457836994738 | (37.7840800415509, -122.457836994738) | |||
| 183818 | 183818 | 124559 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995921.75191 | 2113853.09729 | 37.7840029226817 | -122.45782985493 | (37.7840029226817, -122.45782985493) | |||
| 44790 | 44790 | 244846 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6006641.954969999 | 2103569.5656 | 37.75637683445171 | -122.42001177073901 | (37.7563768344517, -122.420011770739) | |||
| 52123 | 52123 | 244847 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 6006653.79898 | 2103383.59728 | 37.7558668756582 | -122.41995761356002 | (37.7558668756582, -122.41995761356) | |||
| 59728 | 59728 | 244843 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 9ft | 6006632.98295 | 2103729.04135 | 37.7568142125173 | -122.4200541162 | (37.7568142125173, -122.4200541162) | |||
| 64107 | 64107 | 244844 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006630.92083 | 2103720.4372 | 37.7567904713264 | -122.420060637198 | (37.7567904713264, -122.420060637198) | |||
| 134129 | 134129 | 244845 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6006641.10837 | 2103579.2022 | 37.756403246631606 | -122.42001538241999 | (37.7564032466316, -122.42001538242) | |||
| 137010 | 137010 | 244855 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 899 Hampshire St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6010216.96114 | 2104085.25819 | 37.7579935807494 | -122.407684453192 | (37.7579935807494, -122.407684453192) | |||
| 169980 | 169980 | 203189 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 889 Vermont St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6011337.056059999 | 2104206.57613 | 37.758389331013205 | -122.403819204816 | (37.7583893310132, -122.403819204816) | ||||
| 62292 | 62292 | 217468 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992024.3496199995 | 2105944.9682299998 | 37.76206465879179 | -122.47073710353999 | (37.7620646587918, -122.47073710354) | |||
| 161568 | 161568 | 217470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5991963.05013 | 2105942.50613 | 37.7620543534437 | -122.47094893346501 | (37.7620543534437, -122.470948933465) | |||
| 165440 | 165440 | 217469 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5991984.27655 | 2105943.70129 | 37.7620588626465 | -122.470875607232 | (37.7620588626465, -122.470875607232) | |||
| 183675 | 183675 | 217467 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 870 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992049.56384 | 2105945.3755799998 | 37.762067235345796 | -122.47064992776801 | (37.7620672353458, -122.470649927768) | |||
| 988 | 988 | 199496 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 6010015.0817 | 2112492.094 | 37.781065511609604 | -122.40897579419399 | (37.7810655116096, -122.408975794194) | |||
| 50542 | 50542 | 56949 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | ||
| 164885 | 164885 | 199495 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6010059.4721800005 | 2112539.81003 | 37.78119901506621 | -122.408825592144 | (37.7811990150662, -122.408825592144) | |||
| 154136 | 154136 | 119374 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 866 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5986063.1424 | 2109995.79652 | 37.7728405660437 | -122.49165253211099 | (37.7728405660437, -122.491652532111) | |||
| 43226 | 43226 | 118483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.50908477858499 | (37.7788963529663, -122.509084778585) | ||||
| 130131 | 130131 | 118484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.50916782963499 | (37.7788922504996, -122.509167829635) | ||||
| 84014 | 84014 | 99843 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 124863 | 124863 | 99842 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 142378 | 142378 | 99841 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 142737 | 142737 | 99840 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44828 | 5992070.0 | 2105943.0 | 37.762061894358794 | -122.47057907460301 | (37.7620618943588, -122.470579074603) | ||||
| 128606 | 128606 | 104928 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 143894 | 143894 | 104927 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 144760 | 144760 | 104926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 87968 | 87968 | 116597 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
| 124601 | 124601 | 116596 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
| 142918 | 142918 | 116595 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
| 163853 | 163853 | 247589 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 800 Tompkins Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008947.19059 | 2096447.5550400002 | 37.7369509800105 | -122.411536266603 | (37.7369509800105, -122.411536266603) | ||||
| 1512 | 1512 | 243955 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007056.3814199995 | 2109908.18867 | 37.773804548164705 | -122.419028109365 | (37.7738045481647, -122.419028109365) | |
| 30281 | 30281 | 181242 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011652.37664 | 2087363.09382 | 37.7121582854612 | -122.40154488951099 | (37.7121582854612, -122.401544889511) | |||
| 39171 | 39171 | 181241 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011651.716019999 | 2087377.2812700002 | 37.712197204501294 | -122.401548169322 | (37.7121972045013, -122.401548169322) | |||
| 45399 | 45399 | 181238 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011635.346940001 | 2087388.95322 | 37.7122283399444 | -122.401605565857 | (37.7122283399444, -122.401605565857) | |||
| 48172 | 48172 | 181243 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011666.62378 | 2087363.7492099998 | 37.7121608800013 | -122.40149569296699 | (37.7121608800013, -122.401495692967) | |||
| 48576 | 48576 | 181244 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6011665.41223 | 2087374.1682099998 | 37.7121894208913 | -122.40150061225701 | (37.7121894208913, -122.401500612257) | |||
| 64658 | 64658 | 181240 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011635.880469999 | 2087370.3686799998 | 37.71217734028421 | -122.40160241642499 | (37.7121773402842, -122.401602416425) | |||
| 181637 | 181637 | 181239 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011624.41356 | 2087381.7363 | 37.7122079136246 | -122.40164284814699 | (37.7122079136246, -122.401642848147) | |||
| 59707 | 59707 | 243931 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6001427.70796 | 2099722.90348 | 37.7455196665071 | -122.437768930406 | (37.7455196665071, -122.437768930406) | |||
| 61157 | 61157 | 243933 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001410.80109 | 2099722.64145 | 37.7455179856652 | -122.437827372845 | (37.7455179856652, -122.437827372845) | |||
| 147181 | 147181 | 243932 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 784 Duncan St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001413.8789800005 | 2099722.88395 | 37.745518826532 | -122.43781674736799 | (37.745518826532, -122.437816747368) | |||
| 185076 | 185076 | 244824 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 773 Dolores St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 6005057.02214 | 2103838.7107 | 37.757026420139 | -122.42551217995701 | (37.757026420139, -122.425512179957) | |||
| 187338 | 187338 | 243937 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 77 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007851.00528 | 2099783.60145 | 37.7460494768943 | -122.415562401881 | (37.7460494768943, -122.415562401881) | |||
| 184860 | 184860 | 181218 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 765 Delano Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 5998962.78764 | 2090178.0255900002 | 37.719171212271796 | -122.445605954547 | (37.7191712122718, -122.445605954547) | |||
| 185654 | 185654 | 243921 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 755 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009331.41321 | 2104703.53182 | 37.759641608198706 | -122.41079073042101 | (37.7596416081987, -122.410790730421) | |||
| 85176 | 85176 | 104920 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 101258 | 101258 | 104921 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 111624 | 111624 | 104922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | missing? | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 51670 | 51670 | 181284 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 75 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6006132.8407 | 2093885.45886 | 37.7297577652023 | -122.421084877777 | (37.7297577652023, -122.421084877777) | ||||
| 158682 | 158682 | 65148 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 7330 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 17 | Permit Number 27125 | 5984217.18812 | 2112512.23092 | 37.7796419140825 | -122.498223688652 | (37.7796419140825, -122.498223688652) | ||
| 110201 | 110201 | 32558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 138405 | 138405 | 32559 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 145462 | 145462 | 32560 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 727 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | |||
| 34386 | 34386 | 199497 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 72 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010024.2102 | 2112481.0403 | 37.7810356721041 | -122.408943433887 | (37.7810356721041, -122.408943433887) | |||
| 75130 | 75130 | 181288 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6002649.9412 | 2087357.15211 | 37.7116355320158 | -122.432659488848 | (37.7116355320158, -122.432659488848) | |||
| 150487 | 150487 | 217444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Holloway Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994706.40918 | 2091208.56862 | 37.721756913341295 | -122.46039315802601 | (37.7217569133413, -122.460393158026) | |||
| 34652 | 34652 | 243942 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 3ft | 6004361.46086 | 2104388.80864 | 37.7584975338534 | -122.427956893407 | (37.7584975338534, -122.427956893407) | |||
| 41272 | 41272 | 243941 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 3ft | 6004362.39063 | 2104350.06977 | 37.758391218686796 | -122.4279509174 | (37.7583912186868, -122.4279509174) | |||
| 153835 | 153835 | 217441 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 4ft | 5997030.67735 | 2094719.72249 | 37.731531141041295 | -122.45261208429 | (37.7315311410413, -122.45261208429) | |||
| 78182 | 78182 | 16288 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | |||
| 84266 | 84266 | 16289 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
| 59148 | 59148 | 49326 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013271.22314 | 2110393.4980200003 | 37.7754851058895 | -122.39756387047501 | (37.7754851058895, -122.397563870475) | ||
| 69461 | 69461 | 49325 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013241.30936 | 2110424.30224 | 37.7755680215912 | -122.397669511153 | (37.7755680215912, -122.397669511153) | ||
| 72808 | 72808 | 203199 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6013299.63411 | 2110362.29852 | 37.77540102106779 | -122.397463400913 | (37.7754010210678, -122.397463400913) | |||
| 35759 | 35759 | 117922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 683 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983174.6969099995 | 2111166.71748 | 37.775886344567496 | -122.501730482451 | (37.7758863445675, -122.501730482451) | |||
| 11503 | 11503 | 27099 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 681 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6005896.77811 | 2093584.4181099997 | 37.7289178631699 | -122.421879597869 | (37.7289178631699, -122.421879597869) | |||
| 11318 | 11318 | 27101 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 675 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3X3 | 6005857.71837 | 2093582.84449 | 37.7289113394736 | -122.42201451865101 | (37.7289113394736, -122.422014518651) | |||
| 153692 | 153692 | 181286 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 675 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6005845.63379 | 2093583.6017 | 37.7289127370316 | -122.42205634973999 | (37.7289127370316, -122.42205634974) | |||
| 178669 | 178669 | 243943 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 671 Church St | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6004315.82343 | 2105235.1157 | 37.7608187101375 | -122.428175041065 | (37.7608187101375, -122.428175041065) | |||
| 117607 | 117607 | 16269 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 670X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997650.6660656 | 2094749.4324283001 | 37.731648221723205 | -122.450470814769 | (37.7316482217232, -122.450470814769) | ||
| 118455 | 118455 | 16270 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 670X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997650.6660656 | 2094749.4324283001 | 37.731648221723205 | -122.450470814769 | (37.7316482217232, -122.450470814769) | ||
| 62777 | 62777 | 49327 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 17 | Permit Number 46321 | 6013204.31889 | 2110464.18207 | 37.77567546267289 | -122.397800268992 | (37.7756754626729, -122.397800268992) | ||
| 139139 | 139139 | 49324 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | Permit Number 46321 | 6013145.06683573 | 2110537.17362663 | 37.775872581057 | -122.39801035954599 | (37.775872581057, -122.398010359546) | |||
| 181886 | 181886 | 49328 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 19 | Permit Number 46321 | 6013181.12431 | 2110489.32106 | 37.775743196927294 | -122.397882269155 | (37.7757431969273, -122.397882269155) |
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");