Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3202 | 3202 | 14513 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999073.0679 | 2111076.7771 | 37.776560404910796 | -122.4467276636 | (37.7765604049108, -122.4467276636) | |||
| 7737 | 7737 | 8094 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 104204 | 104204 | 14512 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 107403 | 107403 | 14539 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 110122 | 110122 | 14584 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1159 Masonic Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 100 | 4x4 | 5999323.48045 | 2108827.83023 | 37.7703996711999 | -122.445699648114 | (37.7703996711999, -122.445699648114) | |||
| 112962 | 112962 | 14532 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 116039 | 116039 | 14534 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 119891 | 119891 | 14538 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 120313 | 120313 | 14531 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 123150 | 123150 | 14511 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 124314 | 124314 | 14533 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 145939 | 145939 | 10418 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5999402.57096 | 2108712.61162 | 37.7700878253378 | -122.445417788957 | (37.7700878253378, -122.445417788957) | |||
| 4904 | 4904 | 23927 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6003460.7841 | 2114695.1886 | 37.7867453258178 | -122.43180771362199 | (37.7867453258178, -122.431807713622) | |||
| 17417 | 17417 | 14589 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1221 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999408.7715 | 2108648.7165 | 37.769912739454604 | -122.445391746523 | (37.7699127394546, -122.445391746523) | |||
| 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) | |||
| 114151 | 114151 | 23765 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 911 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003870.64227 | 2111837.18218 | 37.778921179361504 | -122.430185733043 | (37.7789211793615, -122.430185733043) | |||
| 127379 | 127379 | 23712 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 703 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003969.6344427 | 2111125.8223490003 | 37.7769735674529 | -122.42979252742599 | (37.7769735674529, -122.429792527426) | |||
| 140685 | 140685 | 23738 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 848 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 6003984.4734674 | 2111644.7647146 | 37.7783992952615 | -122.429778217597 | (37.7783992952615, -122.429778217597) | |||
| 5913 | 5913 | 23706 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 8X8 | 6003994.1877 | 2111257.6303 | 37.7773368699173 | -122.42971699343799 | (37.7773368699173, -122.429716993438) | |||
| 7253 | 7253 | 23719 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1999 12:00:00 AM | 80 | 4X4 | 6004022.2052 | 2111346.6982 | 37.777583014840296 | -122.429626425718 | (37.7775830148403, -122.429626425718) | ||
| 19125 | 19125 | 28638 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 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) | |||
| 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) | |||
| 102845 | 102845 | 23717 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 755 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6003929.8516061 | 2111310.486379 | 37.7774783563958 | -122.429943324105 | (37.7774783563958, -122.429943324105) | |||
| 112079 | 112079 | 23714 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 2242 | 2242 | 23928 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003464.0168 | 2114669.7894 | 37.7866757692841 | -122.431794715065 | (37.7866757692841, -122.431794715065) | |||
| 8799 | 8799 | 23802 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6003829.6195 | 2112722.1937 | 37.7813488773836 | -122.43039080821998 | (37.7813488773836, -122.43039080822) | |||
| 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) | |||
| 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) | |||
| 111505 | 111505 | 21714 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1711X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4x4 | 6003474.1759741 | 2114557.4451345 | 37.7863678761913 | -122.431751542559 | (37.7863678761913, -122.431751542559) | |||
| 112090 | 112090 | 23724 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 802X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003990.015324599 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | |||
| 114713 | 114713 | 23916 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1639 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003511.011206 | 2114320.0570948003 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | |||
| 119571 | 119571 | 14537 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 70 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 176872 | 176872 | 248241 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 63 | 6006778.03314 | 2099006.59157 | 37.743855612256 | -122.419217498503 | (37.743855612256, -122.419217498503) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 107352 | 107352 | 22668 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1150X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6003840.4795818 | 2112671.8469471 | 37.781211252908896 | -122.43034964448499 | (37.7812112529089, -122.430349644485) | |||
| 129085 | 129085 | 8110 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 790X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6004003.8918437995 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | |||
| 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) | |||
| 45137 | 45137 | 248182 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 216 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6007496.06144 | 2098688.36246 | 37.743022237487004 | -122.41671217793899 | (37.743022237487, -122.416712177939) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 102315 | 102315 | 21703 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 128834 | 128834 | 1324 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 4051X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5991764.76245 | 2086963.37686 | 37.709930989883496 | -122.47025258193399 | (37.7099309898835, -122.470252581934) | |||
| 144856 | 144856 | 21705 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 7229 | 7229 | 23933 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1737 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6003453.8571 | 2114739.0598 | 37.7868653923719 | -122.431834813039 | (37.7868653923719, -122.431834813039) | |||
| 9878 | 9878 | 14590 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1221 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999397.8697 | 2108638.7231 | 37.7698846777669 | -122.44542873681401 | (37.7698846777669, -122.445428736814) | |||
| 115931 | 115931 | 23905 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 45 | 4X4 | 6003552.240720401 | 2114183.8642161 | 37.7853465419578 | -122.431454779618 | (37.7853465419578, -122.431454779618) | ||
| 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) | ||
| 9109 | 9109 | 23140 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1621X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004632.02812 | 2099337.8259 | 37.744644014501205 | -122.42666146912599 | (37.7446440145012, -122.426661469126) | |||
| 9261 | 9261 | 23750 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4x4 | 6003934.1806 | 2112005.4294 | 37.779386743058296 | -122.429977933491 | (37.7793867430583, -122.429977933491) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 110605 | 110605 | 23778 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1006 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 40 | 3X3 | 6003898.5093138 | 2112170.2011072 | 37.779837145034705 | -122.430113093173 | (37.7798371450347, -122.430113093173) | ||
| 110610 | 110610 | 23784 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1010 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003903.8361546 | 2112182.8886988997 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | |||
| 116208 | 116208 | 23716 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 138391 | 138391 | 21699 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 142013 | 142013 | 23800 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6003835.7537369 | 2112705.7306783 | 37.7813040215007 | -122.430368411811 | (37.7813040215007, -122.430368411811) | |||
| 8983 | 8983 | 23748 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x4 | 6003941.8583 | 2111953.2204 | 37.779243824898295 | -122.42994764790701 | (37.7792438248983, -122.429947647907) | |||
| 9347 | 9347 | 23747 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 4x4 | 6003945.3133 | 2111922.8931 | 37.779160749313895 | -122.42993353175301 | (37.7791607493139, -122.429933531753) | |||
| 126441 | 126441 | 23918 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1639 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 4X4 | 6003511.011206 | 2114320.0570948003 | 37.7857181564596 | -122.431607147924 | (37.7857181564596, -122.431607147924) | |||
| 18912 | 18912 | 4820 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 398X Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4x4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.42180414448299 | (37.7406342583881, -122.421804144483) | |||
| 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) | ||||
| 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) | |||
| 104075 | 104075 | 171 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6X6 | 6002921.63124 | 2107202.49362 | 37.7661416711925 | -122.433137500753 | (37.7661416711925, -122.433137500753) | |||
| 29363 | 29363 | 225885 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 144 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 3ft | 6002594.52334 | 2107398.5197 | 37.76666135005579 | -122.43428291715 | (37.7666613500558, -122.43428291715) | |||
| 58945 | 58945 | 2685 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1785 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6003437.92088 | 2114825.67122 | 37.7871023020297 | -122.431896135366 | (37.7871023020297, -122.431896135366) | |||
| 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) | |||
| 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) | |||
| 143117 | 143117 | 21718 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1649X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 4X4 | 6003506.2579819 | 2114354.3884348 | 37.785812152244894 | -122.431626044652 | (37.7858121522449, -122.431626044652) | |||
| 155580 | 155580 | 225869 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 5ft | 6006549.95034 | 2098834.86462 | 37.743371240990896 | -122.419993973142 | (37.7433712409909, -122.419993973142) | |||
| 7093 | 7093 | 23752 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 4X4 | 6003928.8061 | 2112053.0316 | 37.7795171425157 | -122.429999922728 | (37.7795171425157, -122.429999922728) | |||
| 54831 | 54831 | 247742 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6001240.13282 | 2108686.18743 | 37.7701199987585 | -122.43905980557699 | (37.7701199987585, -122.439059805577) | ||||
| 8689 | 8689 | 23745 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 4x4 | 6003951.3115 | 2111867.7982 | 37.779009812059 | -122.429908850506 | (37.779009812059, -122.429908850506) | |||
| 21368 | 21368 | 4571 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 229 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 4x4 | 6006415.89392 | 2098506.82504 | 37.7424629643998 | -122.42043422728399 | (37.7424629643998, -122.420434227284) | |||
| 47445 | 47445 | 248181 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 218 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6007478.19635 | 2098656.7324200002 | 37.7429343836221 | -122.41677171036999 | (37.7429343836221, -122.41677171037) | ||||
| 155214 | 155214 | 225860 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1400 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 5997829.91039 | 2105879.4144599997 | 37.7622186838636 | -122.450653279939 | (37.7622186838636, -122.450653279939) | |||
| 32970 | 32970 | 176487 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 14 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 4ft | 6011797.051530001 | 2087306.90558 | 37.7120120754601 | -122.401040902239 | (37.7120120754601, -122.401040902239) | |||
| 185136 | 185136 | 225866 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6006516.03586 | 2098775.00428 | 37.7432049671495 | -122.42010699366199 | (37.7432049671495, -122.420106993662) | |||
| 19713 | 19713 | 16653 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6X6 | 6002873.0768099995 | 2107160.80802 | 37.7660244582848 | -122.43330246186399 | (37.7660244582848, -122.433302461864) | |||
| 22065 | 22065 | 4564 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 203 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6006429.48639 | 2098539.4739099997 | 37.7425533768305 | -122.42038954535101 | (37.7425533768305, -122.420389545351) | |||
| 36001 | 36001 | 247737 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6001325.389909999 | 2108698.90723 | 37.770159774875005 | -122.438765814492 | (37.770159774875, -122.438765814492) | ||||
| 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) | |||
| 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) | |||
| 113136 | 113136 | 56271 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 38 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 30 | Permit Number 12397 | 6006068.09932512 | 2104071.38429116 | 37.75772236378771 | -122.422032014666 | (37.7577223637877, -122.422032014666) | ||
| 113693 | 113693 | 23776 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1006 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6003898.5093138 | 2112170.2011072 | 37.779837145034705 | -122.430113093173 | (37.7798371450347, -122.430113093173) | |||
| 124375 | 124375 | 23910 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1620 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003617.383911 | 2114271.2538834 | 37.785590183829996 | -122.43123564401199 | (37.78559018383, -122.431235644012) | |||
| 143500 | 143500 | 23908 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1620 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003617.383911 | 2114271.2538834 | 37.785590183829996 | -122.43123564401199 | (37.78559018383, -122.431235644012) | |||
| 7515 | 7515 | 23751 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 29 | 4x4 | 6003930.3417 | 2112029.9983 | 37.7794539857546 | -122.42999296692899 | (37.7794539857546, -122.429992966929) |
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");