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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127245 | 127245 | 165 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 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) | ||||
| 129349 | 129349 | 169 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6X6 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 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) | |||
| 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) | |||
| 23227 | 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 | 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) | |||
| 102303 | 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) | |||
| 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) | |||
| 4608 | 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) | ||
| 18178 | 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) | ||
| 20771 | 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) | |||
| 18383 | 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) | |||
| 17700 | 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) | |||
| 125201 | 125201 | 4506 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1799 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004678.8435244 | 2098420.1905157 | 37.7421270443151 | -122.42643426555 | (37.7421270443151, -122.42643426555) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 124676 | 124676 | 5941 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1155X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003735.29014 | 2112772.66113 | 37.7814821046204 | -122.43072074410699 | (37.7814821046204, -122.430720744107) | |||
| 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) | |||
| 141516 | 141516 | 5943 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1407 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003673.95863 | 2112759.04875 | 37.781441253516704 | -122.430931949696 | (37.7814412535167, -122.430931949696) | |||
| 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) | |||
| 5289 | 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) | |||
| 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) | |||
| 118966 | 118966 | 8065 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 631 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6004732.981000001 | 2111553.11801 | 37.7781900132645 | -122.427182319007 | (37.7781900132645, -122.427182319007) | |||
| 108953 | 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) | |||
| 145998 | 145998 | 8081 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 679 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004653.03771 | 2111392.08692 | 37.7777433402869 | -122.427447397341 | (37.7777433402869, -122.427447397341) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 9527 | 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) | |||
| 115922 | 115922 | 10410 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1154 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 5999422.7 | 2108913.3 | 37.770640013924606 | -122.44536259510099 | (37.7706400139246, -122.445362595101) | |||
| 19858 | 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 118584 | 118584 | 10550 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 217 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018348.7736836 | 2094772.4250311002 | 37.7328742748645 | -122.378914156582 | (37.7328742748645, -122.378914156582) | ||
| 128617 | 128617 | 10559 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 266 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1992 12:00:00 AM | 18 | 3X4 | 6018220.577079 | 2094928.7869737998 | 37.733296545147795 | -122.379368227321 | (37.7332965451478, -122.379368227321) | ||
| 124482 | 124482 | 10997 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018318.9881754005 | 2094475.1533634998 | 37.732056382705004 | -122.378996495822 | (37.732056382705, -122.378996495822) | |||
| 122617 | 122617 | 11001 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018345.6932697 | 2094533.4513275002 | 37.7322179299469 | -122.37890821657899 | (37.7322179299469, -122.378908216579) | |||
| 117497 | 117497 | 11002 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 25 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018294.3685242 | 2094521.575214 | 37.7321824905391 | -122.379084835175 | (37.7321824905391, -122.379084835175) | |||
| 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) | |||
| 110819 | 110819 | 11005 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018298.396867501 | 2094610.9788869 | 37.7324281976732 | -122.37907711517201 | (37.7324281976732, -122.379077115172) | |||
| 142601 | 142601 | 11006 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 55 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018247.9816681 | 2094597.6118588 | 37.7323887144105 | -122.37925048612 | (37.7323887144105, -122.37925048612) | |||
| 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) | |||
| 105990 | 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 111750 | 111750 | 14345 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |||
| 141650 | 141650 | 14346 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |||
| 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) | |||
| 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) | |
| 116404 | 116404 | 14355 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |||
| 18603 | 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) | |||
| 20858 | 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) | |||
| 21343 | 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) | |||
| 20745 | 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) | |||
| 18347 | 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) | |||
| 20159 | 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 6042 | 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17501 | 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) | |||
| 20237 | 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) | |||
| 105887 | 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) | |||
| 17618 | 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) | |||
| 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) | |||
| 18531 | 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) | |||
| 17342 | 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) | |||
| 139945 | 139945 | 16657 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002910.8788077 | 2107093.8667075 | 37.765842798192395 | -122.433166929024 | (37.7658427981924, -122.433166929024) | |||
| 142548 | 142548 | 16658 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002910.8788077 | 2107093.8667075 | 37.765842798192395 | -122.433166929024 | (37.7658427981924, -122.433166929024) | |||
| 17793 | 17793 | 16659 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6002918.29496 | 2107052.8377799997 | 37.765730563431894 | -122.43313834635 | (37.7657305634319, -122.43313834635) | |||
| 19670 | 19670 | 16660 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X3 | 6002906.0863 | 2107052.64489 | 37.76572934125 | -122.433180559653 | (37.76572934125, -122.433180559653) | |||
| 20277 | 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) | |||
| 21088 | 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) | |||
| 21077 | 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) | |||
| 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) | |||
| 20195 | 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) | |||
| 19909 | 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) | |||
| 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) |
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");