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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93662 | 93662 | 104651 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 21 Beaver St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770906 | 6002646.8 | 2106754.0 | 37.7648946232156 | -122.43405602387301 | (37.7648946232156, -122.434056023873) | |||||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 2718 | 2718 | 141991 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004002.4362 | 2111527.1662 | 37.7780774159831 | -122.429707688099 | (37.7780774159831, -122.429707688099) | |||
| 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) | |||
| 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) | |||||
| 4297 | 4297 | 50999 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3000X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2010 12:00:00 AM | 3 | 3x3 | Permit Number 774202 | 5999788.70466 | 2116412.94537 | 37.7912529948724 | -122.444635704772 | (37.7912529948724, -122.444635704772) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 7451 | 7451 | 28768 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6X6 | 5999147.2771 | 2111039.3503 | 37.7764618793954 | -122.446468260318 | (37.7764618793954, -122.446468260318) | |||
| 7686 | 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 | 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 | 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 24080 | 24080 | 58360 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 457 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1978 12:00:00 AM | 16 | Permit Number 17388 | 5997662.21392 | 2114878.66722 | 37.786918702384796 | -122.45188253354999 | (37.7869187023848, -122.45188253355) | ||
| 25298 | 25298 | 245131 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1264 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000494.8167 | 2109275.2528 | 37.7716949881709 | -122.44168011954399 | (37.7716949881709, -122.441680119544) | |||
| 26815 | 26815 | 68776 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 499 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | 16 | Permit Number 32706 | 5983126.84332 | 2112651.33679 | 37.7799598652159 | -122.50200589693199 | (37.7799598652159, -122.502005896932) | |
| 26817 | 26817 | 139262 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004035.029 | 2111258.7004 | 37.7773421207118 | -122.429575786462 | (37.7773421207118, -122.429575786462) | |||
| 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) | |||
| 27894 | 27894 | 128840 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 4 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011231.32586 | 2121455.9320099996 | 37.8057461137655 | -122.40539964187599 | (37.8057461137655, -122.405399641876) | |||
| 27922 | 27922 | 225842 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 6ft | 6006154.9324 | 2104068.30883 | 37.7577188162864 | -122.421731491214 | (37.7577188162864, -122.421731491214) | |||
| 28216 | 28216 | 58361 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1978 12:00:00 AM | 13 | Permit Number 17389 | 5997651.60838 | 2114939.03748 | 37.7870838556688 | -122.45192358310601 | (37.7870838556688, -122.451923583106) | ||
| 28615 | 28615 | 248431 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 721 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 5997917.0355 | 2108037.1532 | 37.7681482738929 | -122.450507510702 | (37.7681482738929, -122.450507510702) | |||
| 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) | ||||
| 29200 | 29200 | 245084 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 122 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6000331.4821 | 2109497.9077 | 37.772297034891 | -122.44226108892 | (37.772297034891, -122.44226108892) | |||
| 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) | |||
| 30539 | 30539 | 56277 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 70 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778721 | 6005870.964575401 | 2104060.4446756 | 37.757681205790206 | -122.42271301134599 | (37.7576812057902, -122.422713011346) | ||
| 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) | |||
| 31452 | 31452 | 138004 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1701 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6003467.7112 | 2114620.8384 | 37.7865415716279 | -122.431778436947 | (37.7865415716279, -122.431778436947) | |||
| 34776 | 34776 | 128838 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1614 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005643.34494 | 2118253.58513 | 37.7966392702321 | -122.42450976952499 | (37.7966392702321, -122.424509769525) | |||
| 34838 | 34838 | 138094 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1702 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003569.3298 | 2114583.3281 | 37.786444337602795 | -122.431424183077 | (37.7864443376028, -122.431424183077) | |||
| 35734 | 35734 | 54990 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 643 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 11 | Permit Number 10868 | 5990941.26745 | 2111008.08375 | 37.7759039123762 | -122.47485260799101 | (37.7759039123762, -122.474852607991) | ||
| 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) | |||
| 41509 | 41509 | 54991 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 646 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 13 | 3x3 | Permit Number 10869 | 5990991.81393 | 2111001.00614 | 37.7758874082105 | -122.474677239765 | (37.7758874082105, -122.474677239765) | |
| 42002 | 42002 | 247256 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 495 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998886.7546 | 2109090.8048 | 37.7710967882875 | -122.44722920696002 | (37.7710967882875, -122.44722920696) | |||
| 42651 | 42651 | 246257 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 271 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002925.2307 | 2106787.7129 | 37.7650029884026 | -122.433095412687 | (37.7650029884026, -122.433095412687) | |||
| 42999 | 42999 | 225871 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 187 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6006494.401190001 | 2098665.31091 | 37.742902554819004 | -122.420174017412 | (37.742902554819, -122.420174017412) | |||
| 43680 | 43680 | 225886 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 252 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003516.0044 | 2106734.0164 | 37.764889044418794 | -122.43104824187901 | (37.7648890444188, -122.431048241879) | |||
| 44362 | 44362 | 225855 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1619 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6004635.97757 | 2099333.5139200003 | 37.7446323980786 | -122.42664750570101 | (37.7446323980786, -122.426647505701) | |||
| 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) | ||||
| 46282 | 46282 | 225875 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 465 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008974.19744 | 2106120.42477 | 37.763512036680495 | -122.412126303697 | (37.7635120366805, -122.412126303697) | |||
| 46763 | 46763 | 225859 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998015.015430001 | 2107655.1459 | 37.7671049865286 | -122.450141071966 | (37.7671049865286, -122.450141071966) | |||
| 47911 | 47911 | 225862 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6006460.77519 | 2098675.0846599997 | 37.74292749660479 | -122.42029098054199 | (37.7429274966048, -122.420290980542) | |||
| 48870 | 48870 | 248472 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 739 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997932.4798 | 2107931.7687 | 37.7678597988713 | -122.45044649265101 | (37.7678597988713, -122.450446492651) | |||
| 48991 | 48991 | 225846 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 44 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 9ft | 6006029.75247 | 2104062.03373 | 37.7576945264884 | -122.422163969788 | (37.7576945264884, -122.422163969788) | |||
| 49132 | 49132 | 57220 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2525 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1975 12:00:00 AM | 8 | Permit Number 14507 | 5986650.329 | 2105697.8423 | 37.761073880118396 | -122.489305344609 | (37.7610738801184, -122.489305344609) | ||
| 49857 | 49857 | 225874 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 455 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008970.66577 | 2106145.68989 | 37.7635812107387 | -122.412140304358 | (37.7635812107387, -122.412140304358) | |||
| 51104 | 51104 | 218982 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 765 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994400.37766 | 2089911.3418700001 | 37.7181774299307 | -122.46135702892599 | (37.7181774299307, -122.461357028926) | |||
| 52930 | 52930 | 54989 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 639 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 8 | Permit Number 10867 | 5990941.20394 | 2111018.6338299997 | 37.77593287632679 | -122.474853597928 | (37.7759328763268, -122.474853597928) | ||
| 54303 | 54303 | 246260 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2298 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002933.4837 | 2106633.9471 | 37.7645812529976 | -122.433055880666 | (37.7645812529976, -122.433055880666) | |||
| 54662 | 54662 | 40381 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 336 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | Permit Number 41493 | 6002951.47000009 | 2101559.64792523 | 37.7506494618032 | -122.432631180412 | (37.7506494618032, -122.432631180412) | |||
| 54867 | 54867 | 141878 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1130 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6003852.9179 | 2112548.3998 | 37.7808730023316 | -122.4302978041 | (37.7808730023316, -122.4302978041) | |||
| 55325 | 55325 | 140447 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1147 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003727.7488 | 2112779.9316 | 37.781501640262 | -122.43074735248899 | (37.781501640262, -122.430747352489) | |||
| 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) | |||
| 61569 | 61569 | 142009 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 625 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004793.0024 | 2111561.975 | 37.7782177264629 | -122.426975313976 | (37.7782177264629, -122.426975313976) | |||
| 61678 | 61678 | 245995 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999389.3905 | 2108708.3738 | 37.770075436927705 | -122.44546307506901 | (37.7700754369277, -122.445463075069) | |||
| 61916 | 61916 | 57851 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | 20 | Permit Number 16792 | 6003796.0811 | 2112295.2301 | 37.780174641820004 | -122.430476360985 | (37.78017464182, -122.430476360985) | ||
| 62428 | 62428 | 225847 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 7ft | 6006004.32173 | 2104059.7557599996 | 37.75768683728929 | -122.42225175801501 | (37.7576868372893, -122.422251758015) | |||
| 63010 | 63010 | 141880 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1150 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003846.6211 | 2112606.9608 | 37.7810334395886 | -122.43032376712799 | (37.7810334395886, -122.430323767128) | |||
| 64040 | 64040 | 225877 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1186 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008049.26481 | 2101038.17068 | 37.749505385374604 | -122.414965625261 | (37.7495053853746, -122.414965625261) | |||
| 64512 | 64512 | 57085 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 725 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 15 | Permit Number 14352 | 6011859.01316 | 2104976.52396 | 37.7605325827245 | -122.40206816360799 | (37.7605325827245, -122.402068163608) | ||
| 66667 | 66667 | 246255 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002935.3332 | 2106713.0665 | 37.7647986005719 | -122.433055137007 | (37.7647986005719, -122.433055137007) | |||
| 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) | ||
| 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) | |||
| 69970 | 69970 | 142007 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 661 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004595.1648 | 2111534.8819999998 | 37.7781321470778 | -122.427657776048 | (37.7781321470778, -122.427657776048) | |||
| 70099 | 70099 | 141636 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999161.9551 | 2110417.0445 | 37.7747540254261 | -122.446372706542 | (37.7747540254261, -122.446372706542) | |||
| 70852 | 70852 | 247505 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1170 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5999449.0461 | 2108807.2233 | 37.7703502580574 | -122.44526383601999 | (37.7703502580574, -122.44526383602) | |||
| 71663 | 71663 | 245122 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001035.5995 | 2109350.537 | 37.7719324966998 | -122.43981492117099 | (37.7719324966998, -122.439814921171) | |||
| 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) | |||
| 73857 | 73857 | 245143 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1272 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000478.1977 | 2109271.929 | 37.7716849149487 | -122.441737366956 | (37.7716849149487, -122.441737366956) | |||
| 77057 | 77057 | 244222 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 403 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5998378.2216 | 2109230.1948 | 37.771450447350205 | -122.44899827507099 | (37.7714504473502, -122.448998275071) | |||
| 77091 | 77091 | 245948 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 751 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997946.7127 | 2107822.2959 | 37.7675600290425 | -122.45038937038099 | (37.7675600290425, -122.450389370381) | |||
| 77596 | 77596 | 56267 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 20 | 6x6 | Permit Number 12393 | 6006178.98761338 | 2104077.53782444 | 37.7577455134305 | -122.42164895373101 | (37.7577455134305, -122.421648953731) | |
| 80291 | 80291 | 21692 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1630X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003612.6236388 | 2114305.6361391004 | 37.7856843190794 | -122.431254568258 | (37.7856843190794, -122.431254568258) | |||
| 80650 | 80650 | 23768 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6003798.77229 | 2112300.9395 | 37.7801904708611 | -122.430467458421 | (37.7801904708611, -122.430467458421) | |||
| 80688 | 80688 | 14354 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778955 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |
| 82086 | 82086 | 16681 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 251 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 10X9 | 6002922.02909 | 2106861.1200599996 | 37.765204365015705 | -122.43311173153799 | (37.7652043650157, -122.433111731538) |
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");