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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28971 | 28971 | 192361 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 10 | : Yard 23 | Tree 1 | Private 1 | 10 | 6015010.08641 | 2102185.10422 | 37.7530433120206 | -122.390974850809 | (37.7530433120206, -122.390974850809) | ||||
| 31965 | 31965 | 192372 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 11 | : Yard 23 | Tree 1 | Private 1 | 18 | 6015021.64054 | 2102392.08058 | 37.753612266314796 | -122.39094935864401 | (37.7536122663148, -122.390949358644) | ||||
| 35549 | 35549 | 192359 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 3 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015007.494080001 | 2102120.97523 | 37.7528670835631 | -122.390979333923 | (37.7528670835631, -122.390979333923) | ||||
| 35640 | 35640 | 192367 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 6 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014979.384930001 | 2102511.0329 | 37.75393653934321 | -122.39110380282101 | (37.7539365393432, -122.391103802821) | ||||
| 36486 | 36486 | 192371 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 10 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015009.21329 | 2102415.55606 | 37.7536760354269 | -122.390993975811 | (37.7536760354269, -122.390993975811) | ||||
| 40383 | 40383 | 192366 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 20 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014913.1297 | 2102461.68379 | 37.7537973602844 | -122.39132948139 | (37.7537973602844, -122.39132948139) | ||||
| 51964 | 51964 | 192363 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014946.149019999 | 2102349.52066 | 37.753491216648705 | -122.39120745237899 | (37.7534912166487, -122.391207452379) | ||||
| 54292 | 54292 | 192358 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015008.12096 | 2102140.25985 | 37.752920069827 | -122.39097851376499 | (37.752920069827, -122.390978513765) | ||||
| 60000 | 60000 | 192362 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 20 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014965.98324 | 2102248.74822 | 37.7532156176115 | -122.391131817592 | (37.7532156176115, -122.391131817592) | ||||
| 60677 | 60677 | 192360 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 8 | : Yard 23 | Tree 1 | Private 1 | 5 | 6015020.29565 | 2102164.4791599996 | 37.75298724647129 | -122.39093810360399 | (37.7529872464713, -122.390938103604) | ||||
| 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) | ||||
| 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) | ||||
| 148293 | 148293 | 192370 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 9 | : Yard 23 | Tree 1 | Private 1 | 8 | 6015014.73228 | 2102443.11605 | 37.7537520155509 | -122.390976815833 | (37.7537520155509, -122.390976815833) | ||||
| 171000 | 171000 | 192369 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 8 | : Yard 23 | Tree 1 | Private 1 | 7 | 6014983.64642 | 2102476.35721 | 37.7538415637469 | -122.391086641939 | (37.7538415637469, -122.391086641939) | ||||
| 173611 | 173611 | 192357 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 1 | : Yard 23 | Tree 1 | Private 1 | 16 | 6015039.28391 | 2102127.23317 | 37.7528860304727 | -122.39086983518801 | (37.7528860304727, -122.390869835188) | ||||
| 184577 | 184577 | 192373 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 18 | : Yard 23 | Tree 1 | Private 1 | 17 | 6015020.94183 | 2102357.50513 | 37.7535172906979 | -122.390949358625 | (37.7535172906979, -122.390949358625) | ||||
| 188821 | 188821 | 192368 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 7 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014962.221059999 | 2102496.55555 | 37.753895835135104 | -122.39116214813801 | (37.7538958351351, -122.391162148138) | ||||
| 3257 | 3257 | 253379 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3262 | 3262 | 253382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3270 | 3270 | 253380 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3271 | 3271 | 253381 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3279 | 3279 | 253383 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 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) | ||||
| 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) | ||||
| 154669 | 154669 | 248242 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6006789.286590001 | 2099004.18236 | 37.7438496308664 | -122.419178415757 | (37.7438496308664, -122.419178415757) | ||||
| 166798 | 166798 | 248247 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006821.11352 | 2098989.33644 | 37.743810659629204 | -122.419067312628 | (37.7438106596292, -122.419067312628) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 5918 | 5918 | 23710 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003962.5277 | 2111419.0963 | 37.77777842285779 | -122.429838035535 | (37.7777784228578, -122.429838035535) | |||
| 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) | |||
| 23844 | 23844 | 192384 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6015929.33713 | 2106466.90045 | 37.7648511775542 | -122.38809465775 | (37.7648511775542, -122.38809465775) | |||
| 28136 | 28136 | 247011 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002619.5945 | 2099198.996 | 37.7441488398068 | -122.433610141488 | (37.7441488398068, -122.433610141488) | ||||
| 28691 | 28691 | 247010 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002631.32186 | 2099201.86815 | 37.74415739146121 | -122.433569796116 | (37.7441573914612, -122.433569796116) | ||||
| 36930 | 36930 | 123091 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 625 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5992511.629819999 | 2111163.49628 | 37.776421509726795 | -122.46943168307301 | (37.7764215097268, -122.469431683073) | |||
| 51030 | 51030 | 192383 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6015928.566269999 | 2106487.94693 | 37.7649089239349 | -122.38809879283501 | (37.7649089239349, -122.388098792835) | |||
| 57475 | 57475 | 192380 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6015923.02581 | 2106586.6192099997 | 37.7651795497335 | -122.388124842588 | (37.7651795497335, -122.388124842588) | |||
| 64244 | 64244 | 192381 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 6015923.36734 | 2106564.05052 | 37.7651175999097 | -122.38812208619 | (37.7651175999097, -122.38812208619) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 135950 | 135950 | 192385 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 9ft | 6015934.883119999 | 2106386.4235799997 | 37.7646305127095 | -122.388069858948 | (37.7646305127095, -122.388069858948) | |||
| 157332 | 157332 | 192376 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6015917.31296 | 2106690.54623 | 37.7654645943419 | -122.388151855539 | (37.7654645943419, -122.388151855539) | |||
| 160429 | 160429 | 192377 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 9ft | 6015920.48189 | 2106647.80141 | 37.7653474018847 | -122.38813791154499 | (37.7653474018847, -122.388137911545) | |||
| 162650 | 162650 | 192374 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 6015916.946 | 2106720.28142 | 37.765546220411295 | -122.38815520010901 | (37.7655462204113, -122.388155200109) | |||
| 169571 | 169571 | 218978 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 635 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5997875.75574 | 2094965.1361 | 37.7322533730829 | -122.449708177017 | (37.7322533730829, -122.449708177017) | ||||
| 175345 | 175345 | 192379 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6015920.8983 | 2106611.50942 | 37.7652477749961 | -122.38813393835 | (37.7652477749961, -122.38813393835) | |||
| 180521 | 180521 | 192375 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6015916.65317 | 2106707.2255 | 37.765510355454204 | -122.38815530173001 | (37.7655103554542, -122.38815530173) | |||
| 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) | ||||
| 52261 | 52261 | 247740 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6001271.06334 | 2108691.18463 | 37.770135479706 | -122.43895317566299 | (37.770135479706, -122.438953175663) | ||||
| 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) | ||||
| 57480 | 57480 | 247197 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6001288.44424 | 2108651.52945 | 37.7700275853458 | -122.43889021322501 | (37.7700275853458, -122.438890213225) | ||||
| 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) | |||
| 103164 | 103164 | 109415 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 4 GUY PL | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6014378.1 | 2114502.6 | 37.786829336844605 | -122.394022608955 | (37.7868293368446, -122.394022608955) | |||||
| 146890 | 146890 | 192388 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Quint St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6015744.90256 | 2099774.65774 | 37.7464654763079 | -122.388265475891 | (37.7464654763079, -122.388265475891) | |||
| 147885 | 147885 | 247198 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6001308.18443 | 2108654.86509 | 37.7700378672708 | -122.438822171426 | (37.7700378672708, -122.438822171426) | ||||
| 149445 | 149445 | 247196 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6001271.526330001 | 2108649.87649 | 37.7700220841792 | -122.438948613411 | (37.7700220841792, -122.438948613411) | ||||
| 149635 | 149635 | 247736 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6001355.82425 | 2108703.21094 | 37.770173323178895 | -122.438660851038 | (37.7701733231789, -122.438660851038) | ||||
| 160176 | 160176 | 247741 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6001253.60455 | 2108688.62285 | 37.77012745234 | -122.43901338168101 | (37.77012745234, -122.439013381681) | ||||
| 161108 | 161108 | 247739 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6001290.39565 | 2108693.08102 | 37.7701417866389 | -122.43888644146799 | (37.7701417866389, -122.438886441468) | ||||
| 163451 | 163451 | 247200 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6001346.7374 | 2108658.67533 | 37.7700505225398 | -122.438689090625 | (37.7700505225398, -122.438689090625) | ||||
| 177512 | 177512 | 247199 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6001327.32822 | 2108657.34908 | 37.770045776808 | -122.43875613150699 | (37.770045776808, -122.438756131507) | ||||
| 178439 | 178439 | 247738 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6001307.4111 | 2108694.6373099997 | 37.7701470278921 | -122.438827696866 | (37.7701470278921, -122.438827696866) | ||||
| 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) | |||||
| 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) | ||||
| 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) | |||
| 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) | |||||
| 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) | |||
| 117322 | 117322 | 107388 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 715 | 715 | 246970 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 2 | : 4 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.764583763244794 | -122.43300776749099 | (37.7645837632448, -122.433007767491) | |||
| 719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
| 31134 | 31134 | 246971 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002932.26985 | 2106723.06084 | 37.7648258688387 | -122.433066446456 | (37.7648258688387, -122.433066446456) | |||
| 63759 | 63759 | 246972 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6002932.11099 | 2106737.87543 | 37.764866537093894 | -122.433068054458 | (37.7648665370939, -122.433068054458) | |||
| 131504 | 131504 | 246974 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 255 Noe St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 7ft | 6002927.8614 | 2106813.40847 | 37.7650736914197 | -122.433088149808 | (37.7650736914197, -122.433088149808) | |||
| 149834 | 149834 | 246978 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 4 | : 4 | Tree 1 | Private 1 | 21 | Width 8ft | 6002919.18964 | 2107068.61942 | 37.765773946726604 | -122.433136379546 | (37.7657739467266, -122.433136379546) | |||
| 159226 | 159226 | 192386 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 725 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 24 | Width 4ft | 6011857.61784 | 2104994.61162 | 37.7605821695415 | -122.40207426103399 | (37.7605821695415, -122.402074261034) | |||
| 162178 | 162178 | 246975 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 247 Noe St | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 7ft | 6002924.19309 | 2106865.87751 | 37.7652175505697 | -122.43310458672899 | (37.7652175505697, -122.433104586729) | |||
| 181235 | 181235 | 246973 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6002929.82417 | 2106784.67092 | 37.764994896425705 | -122.433079307674 | (37.7649948964257, -122.433079307674) | |||
| 184825 | 184825 | 246977 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 3 | : 4 | Tree 1 | Private 1 | 27 | Width 8ft | 6002905.92105 | 2107067.14879 | 37.765769156055704 | -122.433182167637 | (37.7657691560557, -122.433182167637) | |||
| 23876 | 23876 | 218979 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 551 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991462.95986 | 2093729.88952 | 37.7284927194476 | -122.47178846497101 | (37.7284927194476, -122.471788464971) | |||
| 27154 | 27154 | 192389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 450 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6018217.012999999 | 2099612.2395900004 | 37.746156176965606 | -122.37970582128901 | (37.7461561769656, -122.379705821289) | |||
| 27230 | 27230 | 218984 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 145 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5994984.805980001 | 2099511.62786 | 37.744571095774 | -122.46003202358101 | (37.744571095774, -122.460032023581) | |||
| 44535 | 44535 | 245182 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 101 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 0ft | 6000783.8214 | 2109356.5198 | 37.771934589146596 | -122.440686267053 | (37.7719345891466, -122.440686267053) | |||
| 55255 | 55255 | 218981 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991484.23887 | 2094055.3535200001 | 37.7293875934485 | -122.47173861195 | (37.7293875934485, -122.47173861195) | |||
| 58382 | 58382 | 245183 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 101 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 6000788.1423 | 2109334.9151 | 37.77187551412229 | -122.44066977084299 | (37.7718755141223, -122.440669770843) | |||
| 61784 | 61784 | 124031 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 101 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991786.57969 | 2114495.60147 | 37.785528628097296 | -122.472182755667 | (37.7855286280973, -122.472182755667) | |||
| 131678 | 131678 | 218980 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991479.42203 | 2093975.5381 | 37.729168161565596 | -122.47174944968 | (37.7291681615656, -122.47174944968) | |||
| 150110 | 150110 | 218983 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 145 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5994996.58862 | 2099522.38942 | 37.7446013220014 | -122.459992061292 | (37.7446013220014, -122.459992061292) | |||
| 17 | 17 | 145278 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 0 | Width 3ft | Permit Number 779614 | 5992589.961569999 | 2110455.11477 | 37.774481011910204 | -122.469109146279 | (37.7744810119102, -122.469109146279) | |
| 696 | 696 | 5946 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003699.8521 | 2112803.046 | 37.7815635260957 | -122.43084551167601 | (37.7815635260957, -122.430845511676) | |||
| 1161 | 1161 | 228132 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 236 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 23 | Width 3ft | Permit Number 12386 | 5997539.90606 | 2106468.8722 | 37.7638205814857 | -122.451698812867 | (37.7638205814857, -122.451698812867) | |
| 1385 | 1385 | 23847 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1370 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003735.9392 | 2113413.2165 | 37.7832409463281 | -122.43076422395599 | (37.7832409463281, -122.430764223956) | |||
| 1657 | 1657 | 251641 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1785 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6003432.0 | 2114811.0 | 37.787061682920395 | -122.43191557230301 | (37.7870616829204, -122.431915572303) | ||||
| 1662 | 1662 | 251640 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1785 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6003432.0 | 2114811.0 | 37.787061682920395 | -122.43191557230301 | (37.7870616829204, -122.431915572303) | ||||
| 2038 | 2038 | 23713 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 709 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003942.7402 | 2111225.1787 | 37.7772448524761 | -122.429892651683 | (37.7772448524761, -122.429892651683) | |||
| 2117 | 2117 | 5944 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1415 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003654.4203 | 2112794.2785 | 37.78153687853621 | -122.43100205797701 | (37.7815368785362, -122.431002057977) | |||
| 2149 | 2149 | 225887 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 42143 | 6001804.962730001 | 2096660.33983 | 37.73713202700829 | -122.436245312495 | (37.7371320270083, -122.436245312495) | |
| 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) | |||
| 2714 | 2714 | 141996 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6003983.1859 | 2111655.6546 | 37.7784291232811 | -122.42978344870899 | (37.7784291232811, -122.429783448709) | |||
| 2717 | 2717 | 141997 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6003978.0604 | 2111685.2682 | 37.7785101446541 | -122.42980329253 | (37.7785101446541, -122.42980329253) |
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");