Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
285 | 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) | |||
6567 | 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 | 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) | |||
17124 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
39405 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
53560 | 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 | 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 | 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) | |||
58805 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
146622 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
160536 | 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 | 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) | |||
165180 | 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 | 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 | 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) | |||
170671 | 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 | 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 | 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 | 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 | 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) | |||
177430 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
175844 | 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) | |
38807 | 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) | ||
2707 | 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) | ||
37992 | 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) | |
144327 | 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) | |
169961 | 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) | |
15860 | 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) | ||
53128 | 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) | ||
57900 | 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) | ||
161674 | 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) | |
159793 | 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) |
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");