Street_Tree_List

Data source: data.sfgov.org

141 rows where qCaretaker = 2 and qSpecies = 10

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
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)
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 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)
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)
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 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 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)
2725 141994 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 818 Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 Width 0ft   6003989.735 2111607.5325 37.7782973627546 -122.429757359707 (37.7782973627546, -122.429757359707)
2728 142000 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 818 WEBSTER ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 0ft   6003967.2401 2111768.9836 37.7787393936814 -122.429846696894 (37.7787393936814, -122.429846696894)
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)
4608 4436 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1292 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/29/2017 12:00:00 AM 3 3X3   6004456.3598 2101397.3807200002 37.75028914274171 -122.42741558697901 (37.7502891427417, -122.427415586979)
5289 5945 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1415 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   6003671.9554 2112797.4667 37.7815466261115 -122.43094162257 (37.7815466261115, -122.43094162257)
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 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)
6042 14515 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 515 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 4X4   5999080.7636 2111027.2361 37.7764248176545 -122.44669747668699 (37.7764248176545, -122.446697476687)
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)
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)
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)
7466 23749 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 900X Webster St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6003935.7161 2111981.6282 37.779321477825704 -122.429970923277 (37.7793214778257, -122.429970923277)
7469 23746 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 900X Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4x4   6003946.8489 2111892.9498 37.779078619397396 -122.429926083012 (37.7790786193974, -122.429926083012)
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)
7686 23718 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 760 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/19/1992 12:00:00 AM 12 4X4   6004031.4914 2111284.7902 37.7774135565599 -122.429589885322 (37.7774135565599, -122.429589885322)
8490 23932 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1737 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 4x4   6003450.6245 2114754.2993 37.7869070529375 -122.43184708562299 (37.7869070529375, -122.431847085623)
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)
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)
9527 9961 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 700X Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6004044.3152 2111193.6969 37.777164162929 -122.429539025484 (37.777164162929, -122.429539025484)
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)
17342 16656 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 200 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4X4   6002872.09203 2107040.69534 37.7656946022435 -122.433297284454 (37.7656946022435, -122.433297284454)
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)
17501 16632 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 150 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002845.7066 2107359.01628 37.7665671370879 -122.433411295115 (37.7665671370879, -122.433411295115)
17618 16652 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 198 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4X5   6002855.56746 2107156.83131 37.7660125458771 -122.43336273892 (37.7660125458771, -122.43336273892)
17700 4504 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1780 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 4X4   6004619.48057 2098494.87239 37.7423287477646 -122.426644841002 (37.7423287477646, -122.426644841002)
18104 23633 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 198X Coleridge St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6006450.06706 2098653.35241 37.7428672213344 -122.42032646421801 (37.7428672213344, -122.420326464218)
18178 4495 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1618 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1990 12:00:00 AM 18 3x3   6004570.56721 2099356.4076799997 37.744691560861895 -122.426875312064 (37.7446915608619, -122.426875312064)
18347 14360 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 299X Noe St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X5   6002944.99981 2106698.0348400003 37.7647578756004 -122.43302062870501 (37.7647578756004, -122.433020628705)
18383 4503 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1767 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6004674.71192 2098595.28716 37.742607586167395 -122.42646101595601 (37.7426075861674, -122.426461015956)
18531 16655 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 200 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 5X4   6002860.3108 2107045.92477 37.765708292624296 -122.433338406847 (37.7657082926243, -122.433338406847)
18603 14356 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 299X Noe St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002946.4626400005 2106656.3475200003 37.764643495314296 -122.43301259056801 (37.7646434953143, -122.433012590568)
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)
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)
19858 10411 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1160 Masonic Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4X4   5999445.7253 2108826.6734 37.7704034735557 -122.445276721272 (37.7704034735557, -122.445276721272)
19909 16683 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 255 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 10X9   6002919.68827 2106838.75041 37.7651428106103 -122.433118229438 (37.7651428106103, -122.433118229438)
20159 14361 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 299X Noe St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5X5   6002933.12369 2106696.89177 37.764754063359796 -122.433061623395 (37.7647540633598, -122.433061623395)
20195 16682 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 259 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 10X9   6002924.1082 2106824.1942 37.76510309351521 -122.43310190188 (37.7651030935152, -122.43310190188)
20237 16633 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 150 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002856.03732 2107366.99767 37.7665896381334 -122.43337613341002 (37.7665896381334, -122.43337613341)
20277 16663 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 207 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002906.06809 2107042.07255 37.7657003111441 -122.43317986716002 (37.7657003111441, -122.43317986716)
20745 14359 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 299X Noe St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002945.74556 2106677.88542 37.7647025924854 -122.433016609656 (37.7647025924854, -122.433016609656)
20771 4502 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1763 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4x4   6004673.08752 2098626.19455 37.7426923589722 -122.426468832889 (37.7426923589722, -122.426468832889)
20858 14357 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 299X Noe St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002936.44481 2106655.1660700003 37.764639683102395 -122.43304715512899 (37.7646396831024, -122.433047155129)
21077 16677 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 247 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 6X8   6002925.629869999 2106851.64017 37.7651785397952 -122.433098599934 (37.7651785397952, -122.433098599934)
21088 16664 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 207 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002919.64524 2107042.50705 37.7657022743565 -122.433132937832 (37.7657022743565, -122.433132937832)
21343 14358 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 299X Noe St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002934.58534 2106677.65284 37.764701320838796 -122.43305519326599 (37.7647013208388, -122.433055193266)
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)
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)
23227 2679 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 2085 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3x3   6003592.8137 2114862.3516 37.7872117965975 -122.43136285998101 (37.7872117965975, -122.431362859981)
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 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 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)
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)
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)
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 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 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 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)
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)
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)
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 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)
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 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 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)
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)
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 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 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)
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)
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)
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)
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)
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)
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 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)
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 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 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 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)
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)
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 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)
102303 2686 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1785 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 4X4   6003432.16121 2114811.6647200002 37.787063517212296 -122.431915062035 (37.7870635172123, -122.431915062035)
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)
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)
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)
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)
104401 17335 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 170 Otis St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006561.617219999 2108839.89648 37.7708433996885 -122.420663729244 (37.7708433996885, -122.420663729244)
105887 16639 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 159 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002897.330053501 2107339.8890724997 37.766517547095106 -122.43323137202299 (37.7665175470951, -122.433231372023)
105990 11009 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 80 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6018206.0401963 2094670.6666495 37.7325869956158 -122.379400561989 (37.7325869956158, -122.379400561989)
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)
108953 8080 DPW Maintained 3 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 677 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6004653.03771 2111392.08692 37.7777433402869 -122.427447397341 (37.7777433402869, -122.427447397341)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 424.18ms · Data source: data.sfgov.org