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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65708 | 65708 | 128832 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002198.1821 | 2116092.80029 | 37.7905111558262 | -122.436276069294 | (37.7905111558262, -122.436276069294) | |||
| 65804 | 65804 | 245998 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999402.4121 | 2108663.858 | 37.769953951156 | -122.445414832365 | (37.769953951156, -122.445414832365) | |||
| 66357 | 66357 | 246256 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002934.772000001 | 2106740.5678 | 37.764874080629994 | -122.43305904308998 | (37.76487408063, -122.43305904309) | |||
| 66667 | 66667 | 246255 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002935.3332 | 2106713.0665 | 37.7647986005719 | -122.433055137007 | (37.7647986005719, -122.433055137007) | |||
| 66920 | 66920 | 138005 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1701 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003469.0966 | 2114590.8212 | 37.7864592305121 | -122.431771499801 | (37.7864592305121, -122.431771499801) | |||
| 66955 | 66955 | 30368 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 406 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1956 12:00:00 AM | 43 | Permit Number 56 | 6012907.774259999 | 2105144.73435 | 37.761052931381 | -122.398452757696 | (37.761052931381, -122.398452757696) | ||
| 67585 | 67585 | 138435 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003509.4651 | 2114326.3540000003 | 37.785735358539206 | -122.431612946728 | (37.7857353585392, -122.431612946728) | |||
| 68047 | 68047 | 218985 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 735 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | |||
| 69085 | 69085 | 225826 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011095.54336 | 2102504.4626599997 | 37.7537022093019 | -122.40453465146601 | (37.7537022093019, -122.404534651466) | |||
| 69171 | 69171 | 201411 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Harbor Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6018303.48681 | 2094820.24532 | 37.7330030830165 | -122.379074046625 | (37.7330030830165, -122.379074046625) | |||
| 69771 | 69771 | 225837 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010874.71509 | 2102536.14279 | 37.7537768521194 | -122.405300559996 | (37.7537768521194, -122.405300559996) | |||
| 69970 | 69970 | 142007 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 661 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004595.1648 | 2111534.8819999998 | 37.7781321470778 | -122.427657776048 | (37.7781321470778, -122.427657776048) | |||
| 70099 | 70099 | 141636 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999161.9551 | 2110417.0445 | 37.7747540254261 | -122.446372706542 | (37.7747540254261, -122.446372706542) | |||
| 70325 | 70325 | 192365 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 21 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014917.078430001 | 2102437.6688900003 | 37.7537316396243 | -122.391314147037 | (37.7537316396243, -122.391314147037) | ||||
| 70390 | 70390 | 142068 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1000 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003893.9859 | 2112297.2467 | 37.780185724477604 | -122.43013780751001 | (37.7801857244776, -122.43013780751) | |||
| 70852 | 70852 | 247505 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1170 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5999449.0461 | 2108807.2233 | 37.7703502580574 | -122.44526383601999 | (37.7703502580574, -122.44526383602) | |||
| 70878 | 70878 | 95154 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 5988718.8555 | 2113711.8550400003 | 37.783198671909794 | -122.48273859805 | (37.7831986719098, -122.48273859805) | |||
| 71343 | 71343 | 138432 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003502.2144 | 2114406.5958 | 37.785955271305 | -122.43164376298 | (37.785955271305, -122.43164376298) | |||
| 71663 | 71663 | 245122 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001035.5995 | 2109350.537 | 37.7719324966998 | -122.43981492117099 | (37.7719324966998, -122.439814921171) | |||
| 71853 | 71853 | 139261 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 702 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004039.451 | 2111223.3243 | 37.777245237047794 | -122.429557965765 | (37.7772452370478, -122.429557965765) | |||
| 71992 | 71992 | 192382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6015926.910759999 | 2106504.64628 | 37.7649546850211 | -122.38810568434499 | (37.7649546850211, -122.388105684345) | |||
| 72530 | 72530 | 107389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 73189 | 73189 | 138436 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003517.0237 | 2114299.5361 | 37.7856621517715 | -122.431584880845 | (37.7856621517715, -122.431584880845) | |||
| 73452 | 73452 | 192387 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Quint St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 6ft | 6015746.952330001 | 2099779.40581 | 37.7464786270998 | -122.388258719272 | (37.7464786270998, -122.388258719272) | |||
| 73522 | 73522 | 138438 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003522.9999 | 2114255.78 | 37.7855423472789 | -122.431561079979 | (37.7855423472789, -122.431561079979) | |||
| 73857 | 73857 | 245143 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1272 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000478.1977 | 2109271.929 | 37.7716849149487 | -122.441737366956 | (37.7716849149487, -122.441737366956) | |||
| 73871 | 73871 | 247012 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6002599.35575 | 2099199.8727700002 | 37.744150098849204 | -122.43368018521299 | (37.7441500988492, -122.433680185213) | ||||
| 74402 | 74402 | 225834 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010880.09664 | 2102425.6694099996 | 37.7534738174881 | -122.40527417026001 | (37.7534738174881, -122.40527417026) | |||
| 74435 | 74435 | 192364 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 23 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014928.1243 | 2102399.042 | 37.7536261914184 | -122.391273247671 | (37.7536261914184, -122.391273247671) | ||||
| 75023 | 75023 | 225844 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 6006115.25271 | 2104066.0613700002 | 37.757710407621204 | -122.421868560489 | (37.7577104076212, -122.421868560489) | |||
| 77057 | 77057 | 244222 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 403 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5998378.2216 | 2109230.1948 | 37.771450447350205 | -122.44899827507099 | (37.7714504473502, -122.448998275071) | |||
| 77091 | 77091 | 245948 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 751 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997946.7127 | 2107822.2959 | 37.7675600290425 | -122.45038937038099 | (37.7675600290425, -122.450389370381) | |||
| 77445 | 77445 | 121460 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005944.89012346 | 2104064.54703238 | 37.757696640503895 | -122.42245763762101 | (37.7576966405039, -122.422457637621) | |||||
| 77596 | 77596 | 56267 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 20 | 6x6 | Permit Number 12393 | 6006178.98761338 | 2104077.53782444 | 37.7577455134305 | -122.42164895373101 | (37.7577455134305, -122.421648953731) | |
| 77925 | 77925 | 5942 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1155X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003738.78415 | 2112752.38886 | 37.781426639976 | -122.430707209452 | (37.781426639976, -122.430707209452) | |||
| 78070 | 78070 | 14506 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 6X6 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 78646 | 78646 | 107392 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | |||||
| 78824 | 78824 | 167 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | ||||
| 79285 | 79285 | 107390 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 80291 | 80291 | 21692 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1630X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003612.6236388 | 2114305.6361391004 | 37.7856843190794 | -122.431254568258 | (37.7856843190794, -122.431254568258) | |||
| 80650 | 80650 | 23768 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6003798.77229 | 2112300.9395 | 37.7801904708611 | -122.430467458421 | (37.7801904708611, -122.430467458421) | |||
| 80688 | 80688 | 14354 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778955 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |
| 82086 | 82086 | 16681 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 251 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 10X9 | 6002922.02909 | 2106861.1200599996 | 37.765204365015705 | -122.43311173153799 | (37.7652043650157, -122.433111731538) | |||
| 82292 | 82292 | 21704 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 82530 | 82530 | 14583 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 60 | 4X4 | 5999386.3171 | 2108834.4593 | 37.7704214603588 | -122.445482773554 | (37.7704214603588, -122.445482773554) | |||
| 82641 | 82641 | 10412 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1154X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 5999422.66976 | 2108913.34746 | 37.7706401425115 | -122.445362703114 | (37.7706401425115, -122.445362703114) | ||||
| 82907 | 82907 | 23711 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004027.2031566 | 2111122.3858595 | 37.776967391502296 | -122.42959313438801 | (37.7769673915023, -122.429593134388) | |||
| 83471 | 83471 | 142072 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1000 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003881.1199 | 2112378.2677 | 37.780407459294295 | -122.430188098643 | (37.7804074592943, -122.430188098643) | |||
| 83963 | 83963 | 23741 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 856 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003980.765967 | 2111671.7236867 | 37.7784731079824 | -122.429792966614 | (37.7784731079824, -122.429792966614) | |||
| 84315 | 84315 | 21700 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 84493 | 84493 | 14510 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X6 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 84578 | 84578 | 23777 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1006 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6003898.5093138 | 2112170.2011072 | 37.779837145034705 | -122.430113093173 | (37.7798371450347, -122.430113093173) | |||
| 84944 | 84944 | 56276 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 24 | Permit Number 12402 | 6005944.89012346 | 2104064.54703238 | 37.757696640503895 | -122.42245763762101 | (37.7576966405039, -122.422457637621) | ||
| 85524 | 85524 | 11012 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 95 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018177.8841382 | 2094612.4287261001 | 37.7324255328509 | -122.37949386114599 | (37.7324255328509, -122.379493861146) | |||
| 85681 | 85681 | 108040 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6006128.8 | 2104138.4 | 37.7579097966574 | -122.421826846578 | (37.7579097966574, -122.421826846578) | ||||
| 85744 | 85744 | 16627 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 144 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002842.6673683 | 2107423.1988343 | 37.7667431942981 | -122.43342639426099 | (37.7667431942981, -122.433426394261) | |||
| 86129 | 86129 | 4819 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 398X Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.42180414448299 | (37.7406342583881, -122.421804144483) | |||
| 87346 | 87346 | 22667 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1150X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5 | 6003840.4795818 | 2112671.8469471 | 37.781211252908896 | -122.43034964448499 | (37.7812112529089, -122.430349644485) | |||
| 87397 | 87397 | 14536 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 87454 | 87454 | 23720 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6004017.263545 | 2111409.9612221 | 37.77775643966329 | -122.429648033671 | (37.7777564396633, -122.429648033671) | |||
| 87546 | 87546 | 23742 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 856 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6003980.765967 | 2111671.7236867 | 37.7784731079824 | -122.429792966614 | (37.7784731079824, -122.429792966614) | |||
| 87820 | 87820 | 21706 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 88273 | 88273 | 120870 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 815 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x3 | 6001854.0 | 2108207.0 | 37.768839178210705 | -122.436902139783 | (37.7688391782107, -122.436902139783) | |||
| 88708 | 88708 | 17333 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 170 Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006561.617219999 | 2108839.89648 | 37.7708433996885 | -122.420663729244 | (37.7708433996885, -122.420663729244) | |||
| 88944 | 88944 | 56273 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 44 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 28 | Permit Number 12399 | 6006031.13656237 | 2104069.3331134 | 37.7577146469635 | -122.422159701591 | (37.7577146469635, -122.422159701591) | ||
| 89797 | 89797 | 23907 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1615 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6003522.428263701 | 2114237.5945626 | 37.785492382250794 | -122.43156175891899 | (37.7854923822508, -122.431561758919) | |||
| 90407 | 90407 | 23715 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 90802 | 90802 | 23739 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 848 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6003984.4734674 | 2111644.7647146 | 37.7783992952615 | -122.429778217597 | (37.7783992952615, -122.429778217597) | |||
| 90894 | 90894 | 109289 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 26X Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011707.98734 | 2087352.9647400002 | 37.7121335759116 | -122.401351970141 | (37.7121335759116, -122.401351970141) | |||||
| 91056 | 91056 | 17334 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 170 Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006561.617219999 | 2108839.89648 | 37.7708433996885 | -122.420663729244 | (37.7708433996885, -122.420663729244) | |||
| 92757 | 92757 | 23917 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1639 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003511.011206 | 2114320.0570948003 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | |||
| 92835 | 92835 | 21715 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1711X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6003474.1759741 | 2114557.4451345 | 37.7863678761913 | -122.431751542559 | (37.7863678761913, -122.431751542559) | |||
| 92924 | 92924 | 14535 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 93610 | 93610 | 192378 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 9ft | 6015920.68395 | 2106620.6403200002 | 37.765272834597894 | -122.388135317012 | (37.7652728345979, -122.388135317012) | |||
| 93662 | 93662 | 104651 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 21 Beaver St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770906 | 6002646.8 | 2106754.0 | 37.7648946232156 | -122.43405602387301 | (37.7648946232156, -122.434056023873) | |||||
| 93991 | 93991 | 107500 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1101x PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 773474 | 6001297.0 | 2109248.0 | 37.7716658315653 | -122.438903370258 | (37.7716658315653, -122.438903370258) | ||
| 93994 | 93994 | 17330 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 150 Otis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006661.1201948 | 2108857.0849494 | 37.770896202588 | -122.420320765713 | (37.770896202588, -122.420320765713) | |||
| 94242 | 94242 | 107394 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | |||||
| 94656 | 94656 | 11004 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 40 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018314.1623349 | 2094585.1363671 | 37.7323581084588 | -122.37902081553499 | (37.7323581084588, -122.379020815535) | |||
| 94677 | 94677 | 104328 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 21 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770906 | 6002767.0 | 2106786.0 | 37.76498930837 | -122.433642570245 | (37.76498930837, -122.433642570245) | |||
| 94937 | 94937 | 107393 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | |||||
| 95235 | 95235 | 11010 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 85 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018199.1590574 | 2094619.5131788002 | 37.7324461587057 | -122.379420799908 | (37.7324461587057, -122.379420799908) | |||
| 95437 | 95437 | 50967 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 225 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1974 12:00:00 AM | Permit Number 47461 | 6010511.43889259 | 2088929.82162599 | 37.7163964722207 | -122.40559860260099 | (37.7163964722207, -122.405598602601) | |||
| 96160 | 96160 | 23803 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6003835.7537369 | 2112705.7306783 | 37.7813040215007 | -122.430368411811 | (37.7813040215007, -122.430368411811) | |||
| 96482 | 96482 | 8109 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 790X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6004003.8918437995 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | |||
| 96659 | 96659 | 10421 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999421.35342 | 2108678.34127 | 37.7699947998181 | -122.44535035645 | (37.7699947998181, -122.44535035645) | |||
| 96681 | 96681 | 52015 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 97084 | 97084 | 11013 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 95 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018177.8841382 | 2094612.4287261001 | 37.7324255328509 | -122.37949386114599 | (37.7324255328509, -122.379493861146) | |||
| 97851 | 97851 | 21701 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 98046 | 98046 | 4434 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1246 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004452.33203 | 2101636.8791292 | 37.7509465218336 | -122.427446575049 | (37.7509465218336, -122.427446575049) | |||
| 98223 | 98223 | 10420 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999405.64403 | 2108687.20317 | 37.7700182355876 | -122.445405332062 | (37.7700182355876, -122.445405332062) | |||
| 98309 | 98309 | 52013 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 98357 | 98357 | 107387 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 98415 | 98415 | 23782 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1010 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003903.8361546 | 2112182.8886988997 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | |||
| 99128 | 99128 | 23906 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1605 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 4X4 | 6003542.7980522 | 2114194.1073783003 | 37.785374131922396 | -122.43148817988899 | (37.7853741319224, -122.431488179889) | |||
| 99996 | 99996 | 51601 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1250 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47896 | 6000577.00438268 | 2109291.24211111 | 37.7717435732091 | -122.44139697552001 | (37.7717435732091, -122.44139697552) | |||
| 100980 | 100980 | 14347 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |||
| 101591 | 101591 | 11007 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 60 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018282.6314 | 2094636.8214067002 | 37.7324982868599 | -122.379133414916 | (37.7324982868599, -122.379133414916) | |||
| 101861 | 101861 | 59133 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 24 | Permit Number 18438 | 5992594.65054267 | 2110474.91091897 | 37.7745356377316 | -122.46909436740499 | (37.7745356377316, -122.469094367405) | ||
| 101917 | 101917 | 107391 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) |
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");