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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 179437 | 179437 | 237912 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3974 22nd St | 3 | : 4 | Tree 1 | Private 1 | 20 | 6002002.928859999 | 2102961.58207 | 37.7544449998516 | -122.436011614667 | (37.7544449998516, -122.436011614667) | ||||
| 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) | |||
| 165498 | 165498 | 237910 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 414 Collingwood St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6002101.86364 | 2103432.6858200002 | 37.755744157774295 | -122.435703175979 | (37.7557441577743, -122.435703175979) | ||||
| 59899 | 59899 | 237911 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 414 Collingwood St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002101.71196 | 2103425.3535700003 | 37.7557240165608 | -122.435703175975 | (37.7557240165608, -122.435703175975) | ||||
| 29564 | 29564 | 237905 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3937 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6002227.46362 | 2103520.4707299997 | 37.7559923274905 | -122.435275090576 | (37.7559923274905, -122.435275090576) | ||||
| 138151 | 138151 | 237906 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3937 21st St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6002245.415080001 | 2103514.00804 | 37.755975601915104 | -122.43521254633 | (37.7559756019151, -122.43521254633) | |||
| 131366 | 131366 | 237944 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 26 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 2ft | 6002164.0262 | 2096336.8178599998 | 37.736264104808 | -122.43498073797701 | (37.736264104808, -122.434980737977) | |||
| 52362 | 52362 | 237943 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 22 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 3ft | 6002178.91966 | 2096366.0304900003 | 37.7363451615923 | -122.43493133373501 | (37.7363451615923, -122.434931333735) | |||
| 162501 | 162501 | 237907 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3911 21st St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6002340.71018 | 2103530.84091 | 37.75602723197329 | -122.43488418855301 | (37.7560272319733, -122.434884188553) | ||||
| 25440 | 25440 | 237908 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3911 21st St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6002345.78312 | 2103531.79558 | 37.7560301412935 | -122.43486671293002 | (37.7560301412935, -122.43486671293) | ||||
| 46954 | 46954 | 237909 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3911 21st St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6002350.80679 | 2103530.36749 | 37.7560265053261 | -122.43484923730499 | (37.7560265053261, -122.434849237305) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38247 | 38247 | 237913 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 256 Bemis St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6003021.95871 | 2096302.8591099998 | 37.736219537998 | -122.432012088491 | (37.736219537998, -122.432012088491) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 175815 | 175815 | 237928 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 310 Liberty St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6004144.43295 | 2103938.76991 | 37.75724955362679 | -122.428675392374 | (37.7572495536268, -122.428675392374) | |||
| 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) | |||
| 24177 | 24177 | 237873 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1200 San Jose Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6004198.3369 | 2096122.91618 | 37.7357920776323 | -122.427932046027 | (37.7357920776323, -122.427932046027) | |||
| 32056 | 32056 | 178850 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 178 Dublin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6004207.2935 | 2089409.6566400002 | 37.7173594632439 | -122.427422984776 | (37.7173594632439, -122.427422984776) | |||
| 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) | |||
| 8282 | 8282 | 27415 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 2300 Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 9 | 6005889.8891 | 2118381.22689 | 37.7970036620469 | -122.423665750374 | (37.7970036620469, -122.423665750374) | |||
| 6012 | 6012 | 27414 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 2300 Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 9 | 6005892.4011 | 2118361.12861 | 37.7969486190501 | -122.42365562852801 | (37.7969486190501, -122.423655628528) | |||
| 6873 | 6873 | 23463 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 2300 Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 9 | 6005896.8378 | 2118341.60488 | 37.7968952622641 | -122.423638887645 | (37.7968952622641, -122.423638887645) | |||
| 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) | |||
| 155852 | 155852 | 237881 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 400 Prospect Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6006228.09651 | 2097633.90585 | 37.7400555395259 | -122.42102161048 | (37.7400555395259, -122.42102161048) | ||||
| 184895 | 184895 | 237880 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 400 Prospect Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6006230.938630001 | 2097643.52174 | 37.7400821028175 | -122.42101246614901 | (37.7400821028175, -122.421012466149) | ||||
| 178991 | 178991 | 237875 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 200 Kingston St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006243.1676199995 | 2098035.54696 | 37.7411592055212 | -122.420998010444 | (37.7411592055212, -122.420998010444) | ||||
| 26673 | 26673 | 237878 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 400 Prospect Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6006265.8389800005 | 2097650.58343 | 37.7401034599156 | -122.420892296036 | (37.7401034599156, -122.420892296036) | ||||
| 50181 | 50181 | 237877 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 400 Prospect Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6006273.45555 | 2097651.54951 | 37.7401065418729 | -122.420866029569 | (37.7401065418729, -122.420866029569) | ||||
| 28893 | 28893 | 237879 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 400 Prospect Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6006275.052019999 | 2097644.49058 | 37.74008724961789 | -122.420860008587 | (37.7400872496179, -122.420860008587) | ||||
| 46245 | 46245 | 237876 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 400 Prospect Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6006280.46143 | 2097653.37775 | 37.740111956701 | -122.420841935814 | (37.740111956701, -122.420841935814) | ||||
| 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) | |||
| 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) | |||
| 25734 | 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 153689 | 153689 | 135873 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1002 Vallejo St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6008628.64799 | 2118672.57502 | 37.7979578472257 | -122.414209576908 | (37.7979578472257, -122.414209576908) | ||||
| 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) | |||
| 166052 | 166052 | 135874 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 941 Vallejo St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6008901.53322 | 2118681.17119 | 37.7979967743805 | -122.413265921012 | (37.7979967743805, -122.413265921012) | ||||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 37563 | 37563 | 178857 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 701 Delta St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6009291.72599 | 2087274.3379400002 | 37.711782574777004 | -122.409697761866 | (37.711782574777, -122.409697761866) | |||
| 175828 | 175828 | 237890 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 101 Bradford St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6009586.52326 | 2097993.57219 | 37.741231849177396 | -122.409434875633 | (37.7412318491774, -122.409434875633) | |||
| 37189 | 37189 | 196334 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 185 Hampshire St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 5ft | 6010020.7902 | 2107448.7072099997 | 37.767217864928206 | -122.408600163592 | (37.7672178649282, -122.408600163592) | |||
| 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) | |||
| 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) | |||
| 28120 | 28120 | 178856 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 121 Delta St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009824.00265 | 2088991.8165400003 | 37.71652823335621 | -122.407979098955 | (37.7165282333562, -122.407979098955) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 125300 | 125300 | 196327 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 582 Rhode Island St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6011756.69483 | 2105652.08155 | 37.7623818019909 | -122.402469541836 | (37.7623818019909, -122.402469541836) | ||||
| 186159 | 186159 | 196326 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 582 Rhode Island St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6011758.077269999 | 2105655.2615900002 | 37.7623906108466 | -122.40246498408001 | (37.7623906108466, -122.40246498408) | ||||
| 60249 | 60249 | 196325 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 582 Rhode Island St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011758.16915 | 2105659.78061 | 37.7624030241958 | -122.402464984075 | (37.7624030241958, -122.402464984075) | ||||
| 66220 | 66220 | 196329 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 582 Rhode Island St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011758.91837 | 2105646.20338 | 37.7623657859795 | -122.402461438042 | (37.7623657859795, -122.402461438042) | ||||
| 180365 | 180365 | 196328 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 582 Rhode Island St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011759.42256 | 2105649.40128 | 37.7623745948457 | -122.402459919101 | (37.7623745948457, -122.402459919101) | ||||
| 69505 | 69505 | 196330 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 582 Rhode Island St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6011759.958869999 | 2105639.7656 | 37.7623481673595 | -122.40245738661801 | (37.7623481673595, -122.402457386618) | ||||
| 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) | |||
| 47913 | 47913 | 196323 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1922 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012591.21229 | 2102864.69613 | 37.7547748064319 | -122.399387546319 | (37.7547748064319, -122.399387546319) | ||||
| 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) | |||
| 169509 | 169509 | 196332 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 801 Arkansas St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6013061.70024 | 2103702.02862 | 37.7571001510787 | -122.39781918981001 | (37.7571001510787, -122.39781918981) | ||||
| 187588 | 187588 | 196333 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 801 Arkansas St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013061.90076 | 2103711.9152599997 | 37.757127308803604 | -122.397819189808 | (37.7571273088036, -122.397819189808) | ||||
| 164953 | 164953 | 196331 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 801 Arkansas St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6013062.01072 | 2103694.01523 | 37.757078165347096 | -122.397817553962 | (37.7570781653471, -122.397817553962) | ||||
| 62511 | 62511 | 202088 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1 Gould St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012849.75876 | 2091137.38485 | 37.722588475066 | -122.397670917693 | (37.722588475066, -122.397670917693) | ||||
| 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) | |||
| 171890 | 171890 | 196322 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 320 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6014284.29861 | 2105571.05325 | 37.7623000976946 | -122.393721759867 | (37.7623000976946, -122.393721759867) | |||
| 174855 | 174855 | 196321 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1018 Pennsylvania Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 6ft | 6014465.23121 | 2102394.5848 | 37.753588252598796 | -122.392873735151 | (37.7535882525988, -122.392873735151) | |||
| 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) | |||
| 16525 | 16525 | 18547 | Landmark tree 9 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1700X Quesada Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014668.27449 | 2095058.7142299998 | 37.733456755021 | -122.391658696189 | (37.733456755021, -122.391658696189) | |||
| 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) | ||
| 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) | |
| 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) |
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");