Street_Tree_List

Data source: data.sfgov.org

396 rows where qCaretaker = 1 and qSpecies = 10

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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 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 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 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)
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)
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)
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)
2724 141999 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 818 WEBSTER ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6003970.657000001 2111746.2039 37.778677039760794 -122.429833251248 (37.7786770397608, -122.429833251248)
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 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 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 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 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)
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)
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)
5689 51000 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 3000X Jackson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/31/2010 12:00:00 AM 3 3x3 Permit Number 774202 5999777.56327 2116411.2536400002 37.7912477140612 -122.444674131902 (37.7912477140612, -122.444674131902)
6955 23850 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1401X Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6003612.0155 2113606.6244 37.7837649741264 -122.43120675986401 (37.7837649741264, -122.431206759864)
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)
7937 28767 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500X Masonic Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 6X6   5999141.8623 2111078.2688 37.7765684303305 -122.44648979216299 (37.7765684303305, -122.446489792163)
8799 23802 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1160 Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     70 3X3   6003829.6195 2112722.1937 37.7813488773836 -122.43039080821998 (37.7813488773836, -122.43039080822)
9109 23140 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1621X Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3x3   6004632.02812 2099337.8259 37.744644014501205 -122.42666146912599 (37.7446440145012, -122.426661469126)
9261 23750 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 900X Webster St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 4x4   6003934.1806 2112005.4294 37.779386743058296 -122.429977933491 (37.7793867430583, -122.429977933491)
9347 23747 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 900X Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     38 4x4   6003945.3133 2111922.8931 37.779160749313895 -122.42993353175301 (37.7791607493139, -122.429933531753)
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)
19125 28638 Permitted Site 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 740 Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     80 4X4   6004036.2280897 2111271.8185656 37.777378207850795 -122.42957257421499 (37.7773782078508, -122.429572574215)
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)
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)
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)
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)
24409 139234 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1401 WEBSTER ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6003647.0002 2113350.0697 37.783062521715 -122.431067408706 (37.783062521715, -122.431067408706)
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 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 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)
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 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)
27348 225835 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1201 Utah St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6010878.34698 2102482.51525 37.7536298057935 -122.40528422380899 (37.7536298057935, -122.405284223809)
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 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)
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)
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)
28273 245996 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1211 Masonic Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   5999394.2357 2108683.5418 37.7700075311334 -122.445444529843 (37.7700075311334, -122.445444529843)
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 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)
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)
29096 225825 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1200 San Bruno Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6011093.6138 2102532.5721400003 37.7537792839011 -122.404543302929 (37.7537792839011, -122.404543302929)
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 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 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 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 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)
31636 141879 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1140 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6003851.0289 2112571.0685 37.7809351379405 -122.430305956855 (37.7809351379405, -122.430305956855)
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)
32970 176487 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 14 Blanken Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     31 Width 4ft   6011797.051530001 2087306.90558 37.7120120754601 -122.401040902239 (37.7120120754601, -122.401040902239)
33163 225882 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 2080 17th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6007844.8323099995 2106218.97723 37.763719206299896 -122.41603940859 (37.7637192062999, -122.41603940859)
33850 225838 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1201 Utah St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6010873.380419999 2102595.51297 37.753939794896105 -122.40530935625799 (37.7539397948961, -122.405309356258)
34669 128830 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 435 Locust St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5997658.68844 2114896.31526 37.7869669572999 -122.451896004506 (37.7869669572999, -122.451896004506)
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 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)
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 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)
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)
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)
36251 128836 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 2610 Clay St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6001965.16531 2116062.35333 37.790414314124796 -122.43708011086399 (37.7904143141248, -122.437080110864)
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)
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)
38405 138431 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1601 Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6003497.8639 2114427.3813 37.786012096449106 -122.431660299037 (37.7860120964491, -122.431660299037)
39496 128828 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 435 Locust St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5997654.94419 2114925.25732 37.7870462100671 -122.45191104747101 (37.7870462100671, -122.451911047471)
39523 103291 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 50 Francisco St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6011052.07349 2121439.56361 37.8056911462811 -122.406018820613 (37.8056911462811, -122.406018820613)
39958 139227 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1401 WEBSTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6003610.8493 2113629.9476 37.783828947693294 -122.43121245981199 (37.7838289476933, -122.431212459812)
40024 225850 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 58 Liberty St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 9ft   6005957.80102 2104057.14664 37.7576770490776 -122.42241246056001 (37.7576770490776, -122.42241246056)
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)
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)
41861 225839 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1201 Utah St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6010870.72267 2102625.60051 37.754022260038 -122.40532066611 (37.754022260038, -122.40532066611)
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 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 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)
43107 141795 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1280 WEBSTER ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6003792.0243 2113029.1397 37.7821895448546 -122.43054277764 (37.7821895448546, -122.43054277764)
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)
44123 201434 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 200 Harbor Rd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   6018235.129430001 2094913.6539 37.7332557952224 -122.37931686450099 (37.7332557952224, -122.379316864501)
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)
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)
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)
45480 247292 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1177 Masonic Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5999383.1114 2108836.268 37.770426243584104 -122.44549399211701 (37.7704262435841, -122.445493992117)
46057 246266 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 2298 Noe St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6002930.282000001 2106697.9127 37.7647567053947 -122.43307152499901 (37.7647567053947, -122.433071524999)
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)
46467 225824 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1200 San Bruno Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6011091.77167 2102559.41951 37.753852897909105 -122.404551563217 (37.7538528979091, -122.404551563217)
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)
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)
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 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 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)
49098 225864 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 190 Coleridge St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6006484.93585 2098722.65542 37.7430594766165 -122.420210814975 (37.7430594766165, -122.420210814975)
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 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)
50660 225854 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 70 Liberty St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 7ft   6005875.84915 2104054.64821 37.757665565633395 -122.422695706548 (37.7576655656334, -122.422695706548)
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)
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)
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)
52003 128837 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 2610 Clay St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6001930.71219 2116056.5883 37.790396526424104 -122.43719890322399 (37.7903965264241, -122.437198903224)
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)

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 405.365ms · Data source: data.sfgov.org