Street_Tree_List

Data source: data.sfgov.org

195 rows where qSpecies = 72 sorted by qSiteInfo

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
285 98003 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1904 Filbert St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x12   6003782.57859 2119037.12075 37.7986853996597 -122.431004385541 (37.7986853996597, -122.431004385541)
2707 14854 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1357 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/1992 12:00:00 AM 6 3x3   6002671.377 2111611.0853 37.7782323757584 -122.43431829621201 (37.7782323757584, -122.434318296212)
6567 18905 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2602 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6002286.89222 2115779.97328 37.789657253131 -122.435946744753 (37.789657253131, -122.435946744753)
7597 98002 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1904 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x12   6003787.47736 2119037.49851 37.7986867144679 -122.430987461215 (37.7986867144679, -122.430987461215)
15860 26103 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1557 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/22/1988 12:00:00 AM 12 3x3   6015264.4135 2095277.0122 37.734089230154204 -122.38961289841002 (37.7340892301542, -122.38961289841)
17124 29888 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1126 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   6005721.57126 2102405.52669 37.7531287556897 -122.42311204680901 (37.7531287556897, -122.423112046809)
28940 237901 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 185 Graystone Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5999340.2051099995 2104037.6986700003 37.7572481219159 -122.44529733780399 (37.7572481219159, -122.445297337804)
30122 214346 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1477 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994262.65159 2105461.9553900003 37.7608676152654 -122.46296069458201 (37.7608676152654, -122.462960694582)
32055 116119 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1649x Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 2x2   6014063.167280001 2095217.05774 37.7338579263887 -122.393761818374 (37.7338579263887, -122.393761818374)
32082 214339 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 10 Granada Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5995645.61653 2089973.7563200002 37.7184203952771 -122.45705730996401 (37.7184203952771, -122.457057309964)
32478 237902 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 4120 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003116.41859 2100685.05072 37.7482573763929 -122.43199832888 (37.7482573763929, -122.43199832888)
32673 178855 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1101 Girard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011864.77985 2089786.97938 37.718825637867205 -122.400980956107 (37.7188256378672, -122.400980956107)
33055 237896 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 3337 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007507.329580001 2100885.13303 37.749054710817205 -122.416828817304 (37.7490547108172, -122.416828817304)
35669 237903 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 4120 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003087.27911 2100682.5975099998 37.748248988421395 -122.432098917134 (37.7482489884214, -122.432098917134)
36891 135862 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 8 Kimball Pl 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6008000.712730001 2116486.83875 37.791921065252204 -122.416227532369 (37.7919210652522, -122.416227532369)
36992 181899 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2374 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5987671.9860000005 2099129.3564 37.7430981701656 -122.48528992840201 (37.7430981701656, -122.485289928402)
37992 87842 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 150 Golden Gate Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008797.68605 2112863.51271 37.7820170689709 -122.41321365958099 (37.7820170689709, -122.413213659581)
38807 58192 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 707 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/1978 12:00:00 AM 10   Permit Number 17180 5992850.41876 2110607.08647 37.7749133313412 -122.468219240401 (37.7749133313412, -122.468219240401)
39405 237883 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 74 Oakwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005237.83328 2105067.23866 37.7604098837378 -122.424974271161 (37.7604098837378, -122.424974271161)
39539 135867 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2881 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5999809.285519999 2117392.98346 37.7939450956373 -122.44463496643401 (37.7939450956373, -122.444634966434)
41254 178854 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 401 Leland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008573.82268 2088029.4794 37.7138157809362 -122.41223237962099 (37.7138157809362, -122.412232379621)
41869 214310 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1870 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 1ft   5990380.69599 2102646.45339 37.752912626128705 -122.476180871663 (37.7529126261287, -122.476180871663)
42168 237919 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1182 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5998950.43455 2105771.37241 37.7619861021088 -122.446770052318 (37.7619861021088, -122.446770052318)
42697 214340 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 10 Granada Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5995647.3178900005 2089997.48145 37.7184856365862 -122.457053144299 (37.7184856365862, -122.457053144299)
42845 214337 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 10 Granada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995645.82098 2089943.6870099998 37.7183378437938 -122.457054429431 (37.7183378437938, -122.457054429431)
43791 214321 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 166 Lomita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5991310.02713 2104174.00205 37.757160720399796 -122.47307849028601 (37.7571607203998, -122.473078490286)
43929 178852 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 642 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 1ft   6003293.17352 2089466.63658 37.71746417401 -122.43058673410299 (37.71746417401, -122.430586734103)
47260 237897 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1351 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6009296.40092 2101303.05308 37.7503026946211 -122.41067167815399 (37.7503026946211, -122.410671678154)
47411 237892 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 61 Elsie St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007463.8743 2099061.8151700003 37.7440458449445 -122.416849925291 (37.7440458449445, -122.416849925291)
48934 237929 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 741 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002446.47935 2103887.0992099997 37.7570114365341 -122.43454387612199 (37.7570114365341, -122.434543876122)
50511 237941 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 84 Potomac St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6003101.59687 2108830.30244 37.770621443648 -122.43263132298901 (37.770621443648, -122.432631322989)
50748 237891 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 61 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007462.84884 2099058.94868 37.7440379165229 -122.416853268066 (37.7440379165229, -122.416853268066)
52740 237918 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 179 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5998918.302569999 2107113.8819 37.76567046085321 -122.4469777966 (37.7656704608532, -122.4469777966)
53128 51089 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/26/2004 12:00:00 AM 6   Permit Number 47546 6001713.34736 2117152.10978 37.7933921861489 -122.438029475688 (37.7933921861489, -122.438029475688)
53560 135870 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6001706.98139 2117190.01379 37.7934958986807 -122.438054218747 (37.7934958986807, -122.438054218747)
55556 214319 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 109 Edgewood Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5996574.94596 2106340.51258 37.7634128279669 -122.455027021201 (37.7634128279669, -122.455027021201)
57776 237917 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1295 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5997516.67396 2104938.08371 37.7596160926213 -122.45166873503 (37.7596160926213, -122.45166873503)
57900 68433 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2518 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/26/1993 12:00:00 AM 3   Permit Number 32286 6002013.47223 2116725.04565 37.7922366418513 -122.436960435397 (37.7922366418513, -122.436960435397)
58805 237927 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 4780 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5999842.984730001 2104684.3807599996 37.75905243893521 -122.44360498998999 (37.7590524389352, -122.44360498999)
59986 237923 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 552 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6002969.94721 2104996.10401 37.7600861997348 -122.43281275041299 (37.7600861997348, -122.432812750413)
60135 237893 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 48 Mirabel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6007622.588690001 2099939.38246 37.746464374648596 -122.416363270665 (37.7464643746486, -122.416363270665)
60540 135872 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6001695.18556 2117280.97246 37.7937449767048 -122.43810155185601 (37.7937449767048, -122.438101551856)
61323 178851 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 642 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   6002153.25457 2090190.2605700002 37.719386440714004 -122.43457861601101 (37.719386440714, -122.434578616011)
61362 182193 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2830 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5985470.896000001 2104355.1387 37.757318269846394 -122.49328551153499 (37.7573182698464, -122.493285511535)
62151 214338 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 10 Granada Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5995645.44763 2089954.0994900002 37.7183664125644 -122.4570564727 (37.7183664125644, -122.4570564727)
64453 214316 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1898 08th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993790.06824 2102612.96107 37.7530177802481 -122.464388282898 (37.7530177802481, -122.464388282898)
65870 237887 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 169 Delmar St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5999396.06078 2107229.0151400003 37.7660138714542 -122.44533362007 (37.7660138714542, -122.44533362007)
67839 135863 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 8 Kimball Pl 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6007998.64807 2116497.60836 37.7919505198577 -122.416235439221 (37.7919505198577, -122.416235439221)
70609 237916 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1295 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5997518.24966 2104934.77487 37.7596070976188 -122.451663046815 (37.7596070976188, -122.451663046815)
71736 214350 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100 Vista Verde Ct 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999173.543740001 2096088.2498400002 37.735411342443 -122.445302168061 (37.735411342443, -122.445302168061)
73967 181900 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2374 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5987672.3244 2099143.5701 37.7431372169369 -122.485289801059 (37.7431372169369, -122.485289801059)
74881 237899 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 401 Capp St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007240.84354 2104941.30252 37.760177031272995 -122.418037841569 (37.760177031273, -122.418037841569)
76982 135865 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2518 Jackson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001998.80283 2116724.02313 37.792233000491294 -122.437011118472 (37.7922330004913, -122.437011118472)
84232 105709 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 739 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5992855.21688 2110425.97288 37.7744163192706 -122.468189464852 (37.7744163192706, -122.468189464852)
94247 237894 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Franconia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6010034.07785 2099858.60697 37.7463778949392 -122.408018877775 (37.7463778949392, -122.408018877775)
130531 237915 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1295 Stanyan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5997519.793 2104903.6211900003 37.7595216458395 -122.451655461936 (37.7595216458395, -122.451655461936)
136222 142495 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 471 UNION ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6010670.1646 2119603.9064 37.800629516216 -122.407210998267 (37.800629516216, -122.407210998267)
144327 87840 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 150 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008834.949469999 2112868.30248 37.78203231246879 -122.413085083511 (37.7820323124688, -122.413085083511)
146622 237895 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Franconia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6010025.93602 2099871.47095 37.746412760754104 -122.40804793845501 (37.7464127607541, -122.408047938455)
147556 214315 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1643 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5993376.02878 2104293.90166 37.7576093337224 -122.465942230469 (37.7576093337224, -122.465942230469)
147995 135868 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2881 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5999820.06951 2117394.7311 37.7939505095535 -122.444597778561 (37.7939505095535, -122.444597778561)
148360 237940 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 67 Potomac St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003085.03748 2108738.20516 37.7703676280017 -122.432682022255 (37.7703676280017, -122.432682022255)
148782 237922 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 167 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6002705.54642 2104925.31615 37.7598768339596 -122.433722125974 (37.7598768339596, -122.433722125974)
150930 237889 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 722 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007362.196 2095569.17155 37.7344500984995 -122.416954096469 (37.7344500984995, -122.416954096469)
153128 200001 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1450 Griffith St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6017674.9346 2092354.0887 37.7261968206849 -122.381075736801 (37.7261968206849, -122.381075736801)
153732 237942 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 320 Hermann St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6003704.07001 2108683.26654 37.770251867271796 -122.43053686847901 (37.7702518672718, -122.430536868479)
154507 237885 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 730 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5997985.449030001 2107861.4098900002 37.767669642974894 -122.450258206855 (37.7676696429749, -122.450258206855)
154593 237939 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 273 States St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6000450.96835 2106715.6224 37.764664383877 -122.44164807149599 (37.764664383877, -122.441648071496)
155130 237898 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1087 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6009471.98593 2102823.41576 37.754487114207 -122.41017181789101 (37.754487114207, -122.410171817891)
155167 214341 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 144 Montana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5995498.01894 2089341.3443900002 37.7166754640834 -122.457521759431 (37.7166754640834, -122.457521759431)
155769 237900 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2495 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6008886.650880001 2103959.41051 37.757573472348106 -122.412276352893 (37.7575734723481, -122.412276352893)
158382 142479 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 472 UNION ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6010643.4105 2119643.0095 37.8007353864259 -122.407306336996 (37.8007353864259, -122.407306336996)
159793 58839 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2385 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/27/1979 12:00:00 AM 8   Permit Number 18096 6002233.54572 2117374.3754 37.7940320393926 -122.43624546807699 (37.7940320393926, -122.436245468077)
160536 200068 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2025 Lane St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6014532.2716 2093611.1753 37.7294745562967 -122.392027707824 (37.7294745562967, -122.392027707824)
161002 237921 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1235 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003247.45246 2101075.30094 37.7493363397968 -122.431573074532 (37.7493363397968, -122.431573074532)
161674 60384 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1400 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/06/1982 12:00:00 AM 4   Permit Number 19964 6015915.704 2094515.2497 37.7320336750995 -122.387308043521 (37.7320336750995, -122.387308043521)
165180 214347 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 649 Parnassus Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995088.00725 2106121.15655 37.762725118180704 -122.460153932955 (37.7627251181807, -122.460153932955)
168000 135869 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6001710.05375 2117173.2312 37.7934499927743 -122.43804238544901 (37.7934499927743, -122.438042385449)
169138 139121 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1501 LAGUNA ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6004511.3378 2114128.6273 37.785249186429 -122.428132654809 (37.785249186429, -122.428132654809)
169961 87841 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 150 Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008821.92164 2112867.3350299997 37.782028924727705 -122.41313008558599 (37.7820289247277, -122.413130085586)
170671 237888 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1294 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997563.8752 2104944.75074 37.7596371016855 -122.451505971246 (37.7596371016855, -122.451505971246)
171158 135864 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2451 Steiner St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6002234.27154 2116544.43758 37.791753285928294 -122.43618353624201 (37.7917532859283, -122.436183536242)
171658 214349 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 290 San Fernando Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5992100.51565 2094983.26623 37.7319710480083 -122.46967563014299 (37.7319710480083, -122.469675630143)
173368 237884 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1229 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   5997429.19812 2105587.8813099996 37.761395262795794 -122.452018150436 (37.7613952627958, -122.452018150436)
174239 196324 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2014 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   6011723.18554 2105150.8319599996 37.761003611654 -122.40255018945 (37.761003611654, -122.40255018945)
175844 60597 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 839 Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/1983 12:00:00 AM 3   Permit Number 20219 5999535.7853 2111409.5838 37.7775006284393 -122.44515092859301 (37.7775006284393, -122.445150928593)
177430 214323 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 211 Granville Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   5994213.9284 2098746.3020200003 37.742425335868 -122.462642037812 (37.742425335868, -122.462642037812)
179831 178849 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 13 Liebig St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5995911.23484 2086261.34028 37.7082422172863 -122.455870959398 (37.7082422172863, -122.455870959398)
180799 135866 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 200 Presidio Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5999037.7073 2115878.6146 37.7897429809958 -122.447195652882 (37.7897429809958, -122.447195652882)
181167 214351 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100 Vista Verde Ct 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5999187.72445 2096110.16457 37.735472324573706 -122.445254715344 (37.7354723245737, -122.445254715344)
182515 178853 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 34 Lois Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6012436.48238 2087819.01103 37.7134538649768 -122.398866750723 (37.7134538649768, -122.398866750723)
182972 135871 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6001702.83254 2117214.86813 37.7935639062924 -122.43807035526001 (37.7935639062924, -122.43807035526)
183312 237930 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 4119 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6002901.50765 2104134.40267 37.75771629278479 -122.432987885294 (37.7577162927848, -122.432987885294)
186984 113952 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1416 Powell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6009764.02998 2118627.67395 37.7978982689348 -122.410277642896 (37.7978982689348, -122.410277642896)
187088 237920 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1237 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003246.872269999 2101064.36652 37.7493062835598 -122.43157430031 (37.7493062835598, -122.43157430031)
188194 237882 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 814 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008528.1634 2103776.1584 37.7570501811472 -122.41350319182101 (37.7570501811472, -122.413503191821)
25734 237874 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 160 Coso Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6007471.906690001 2099585.1841700003 37.74548335098721 -122.41685922338301 (37.7454833509872, -122.416859223383)
29426 117740 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 475 39th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5983746.49746 2112674.00016 37.7800584750229 -122.499863945897 (37.7800584750229, -122.499863945897)
33471 182339 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 3081 Kirkham St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985312.4034 2104975.8588 37.759013323653 -122.493879375972 (37.759013323653, -122.493879375972)
36470 237886 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 286 Upper Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5999373.81016 2106048.64713 37.7627716059584 -122.445325703321 (37.7627716059584, -122.445325703321)

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