Street_Tree_List

Data source: data.sfgov.org

195 rows where qSpecies = 72 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

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
29426 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 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)
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)
128545 128545 183562 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2591 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5987056.0774 2097655.4477 37.7390153079093 -122.487311308785 (37.7390153079093, -122.487311308785)
65313 65313 183563 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2593 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5987056.9644 2097643.917 37.738983699378096 -122.487307395263 (37.7389836993781, -122.487307395263)
147966 147966 183564 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2595 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5987057.6296 2097628.3948 37.738941118307295 -122.487303955513 (37.7389411183073, -122.487303955513)
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)
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)
171405 171405 183467 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2534 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5988330.845 2098043.4689 37.740154968776395 -122.482932230746 (37.7401549687764, -122.482932230746)
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)
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)
62044 62044 214343 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 105 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5991402.99723 2089917.07257 37.7180201978552 -122.47171800938999 (37.7180201978552, -122.47171800939)
75667 75667 123051 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 544 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991925.368290001 2111718.74321 37.777912168825004 -122.47150017707199 (37.777912168825, -122.471500177072)
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)
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)
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)
67614 67614 214345 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 498 Vernon St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5992504.20594 2091177.71285 37.7215452614802 -122.46800328954599 (37.7215452614802, -122.468003289546)
28361 28361 214344 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 498 Vernon St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5992505.71978 2091140.82125 37.7214440535804 -122.467995374584 (37.7214440535804, -122.467995374584)
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)
135434 135434 214312 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1616 09th Ave 2 Front Yard : Yard 7 Tree 1 Private 1     8 Width 6ft   5993417.09067 2104452.78428 37.758047952866605 -122.465811766705 (37.7580479528666, -122.465811766705)
62421 62421 214311 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1616 09th Ave 1 Front Yard : Yard 7 Tree 1 Private 1     8 Width 6ft   5993417.73262 2104465.9003 37.7580840030825 -122.46581049954901 (37.7580840030825, -122.465810499549)
56030 56030 214314 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1630 09th Ave 2 Front Yard : Yard 7 Tree 1 Private 1     10 Width 6ft   5993419.49404 2104375.41426 37.7578356535119 -122.465797833501 (37.7578356535119, -122.465797833501)
177811 177811 214313 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1630 09th Ave 1 Front Yard : Yard 7 Tree 1 Private 1     12 Width 6ft   5993420.04408 2104384.15571 37.7578596869935 -122.465796566365 (37.7578596869935, -122.465796566365)
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)
131846 131846 214348 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   5993734.17627 2099649.69883 37.7448781944898 -122.464366439256 (37.7448781944898, -122.464366439256)
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)
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)
153868 153868 214322 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 350x Kensington Way 2 Median : Cutout 11 Tree 1 DPW 2     12 Width 6ft   5994251.85903 2099042.92229 37.7432419652355 -122.462532396964 (37.7432419652355, -122.462532396964)
137397 137397 214320 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1518 05th Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4     5994627.9467 2105254.67875 37.7603195216609 -122.46168228042801 (37.7603195216609, -122.461682280428)
39041 39041 214326 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 121 Miraloma Dr 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   5994581.43196 2096914.1717599998 37.7374159195969 -122.461238551316 (37.7374159195969, -122.461238551316)
62287 62287 214325 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 121 Miraloma Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   5994585.09435 2096884.89716 37.7373357495539 -122.461223767378 (37.7373357495539, -122.461223767378)
158642 158642 214324 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 121 Miraloma Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   5994586.44209 2096871.4866 37.7372990050334 -122.461218135833 (37.7372990050334, -122.461218135833)
46702 46702 214354 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 8 Edgehill Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994911.61844 2099129.8957599998 37.7435187450863 -122.460257437746 (37.7435187450863, -122.460257437746)
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)
71198 71198 214353 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 50 Garcia Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995149.72336 2099349.67966 37.74413591023829 -122.45945004977399 (37.7441359102383, -122.459450049774)
186227 186227 214352 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 50 Garcia Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5995162.00455 2099364.3275 37.744176835692 -122.459408645009 (37.744176835692, -122.459408645009)
51364 51364 214329 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 11 Median : Yard 3 Tree 1 DPW 2     11 Width 9ft   5995487.46893 2099377.84768 37.744232666505106 -122.45828424602301 (37.7442326665051, -122.458284246023)
38489 38489 214330 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 12 Median : Yard 3 Tree 1 DPW 2     10 Width 9ft   5995527.4625 2099368.48178 37.7442092481691 -122.458145280077 (37.7442092481691, -122.458145280077)
174532 174532 214331 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 13 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995540.56521 2099364.9270200003 37.7442002405496 -122.458099716827 (37.7442002405496, -122.458099716827)
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)
137327 137327 214332 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 18 Median : Yard 3 Tree 1 DPW 2     9 Width 9ft   5995718.21124 2099321.8453599997 37.7440921546362 -122.457482343055 (37.7440921546362, -122.457482343055)
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)
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)
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)
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)
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)
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)
55084 55084 214318 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 16 Belmont Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5996661.1210199995 2106238.0269400002 37.763136371875895 -122.454721566453 (37.7631363718759, -122.454721566453)
57881 57881 214317 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 20 Belmont Ave 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21     5996726.67758 2106195.56131 37.763023532129004 -122.454491761784 (37.763023532129, -122.454491761784)
186903 186903 214342 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 331 Lakeview Ave 1 : 4 Tree 1 Private 1     8 Width 3ft   5996752.352000001 2089647.99235 37.7175894189894 -122.45320830242599 (37.7175894189894, -122.453208302426)
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)
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)
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)
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)
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)
74387 74387 214335 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 570 Hearst Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     5997650.4841 2094424.8417 37.730756962361 -122.450448052843 (37.730756962361, -122.450448052843)
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)
46324 46324 135861 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 5 Dicha Aly 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   5998316.32407 2113776.61007 37.783930185978704 -122.44954003254999 (37.7839301859787, -122.44954003255)
57629 57629 214334 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 470 Hearst Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 10ft   5998312.15542 2094413.4318799998 37.7307634815435 -122.448159739578 (37.7307634815435, -122.448159739578)
29047 29047 214358 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 550 Joost Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     5998446.87478 2095010.46619 37.7324104972266 -122.447736959314 (37.7324104972266, -122.447736959314)
64642 64642 214336 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 165 Marston Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     5998449.688130001 2093175.59235 37.727372526598 -122.44759519826401 (37.727372526598, -122.447595198264)
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)
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)
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)
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)
36470 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)
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)
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)
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)
154466 154466 214328 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100 Vista Verde Ct 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 10ft   5999189.95231 2096066.10598 37.735351477276296 -122.44524384613001 (37.7353514772763, -122.44524384613)
130582 130582 214327 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100 Vista Verde Ct 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 10ft   5999204.10164 2096073.9362400002 37.7353737849692 -122.44519548960501 (37.7353737849692, -122.445195489605)
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)
23870 23870 214333 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 312 Hearst Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5999316.02125 2094400.93218 37.7307864969836 -122.44468833131901 (37.7307864969836, -122.444688331319)
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)
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)
56881 56881 237937 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 272 Corbett Ave 6 Side Yard : Yard 17 Tree 1 Private 1     4 Width 3ft   5999630.47363 2105335.88644 37.7608291899486 -122.44438677244301 (37.7608291899486, -122.444386772443)
166087 166087 237935 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 272 Corbett Ave 4 Side Yard : Yard 17 Tree 1 Private 1     6 Width 3ft   5999636.03267 2105332.26436 37.7608195617885 -122.444367285948 (37.7608195617885, -122.444367285948)
66579 66579 237936 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 272 Corbett Ave 5 Side Yard : Yard 17 Tree 1 Private 1     4 Width 3ft   5999637.58135 2105322.06296 37.7607916396321 -122.444361196632 (37.7607916396321, -122.444361196632)
174607 174607 237938 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 272 Corbett Ave 7 Side Yard : Yard 17 Tree 1 Private 1     4 Width 3ft   5999643.14509 2105335.6231299997 37.7608291899369 -122.44434292871 (37.7608291899369, -122.44434292871)
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)
164027 164027 237931 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 18 Temple St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999994.62286 2105880.85812 37.7623463174434 -122.443166486857 (37.7623463174434, -122.443166486857)
30466 30466 214357 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 61 Stillings Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   6000162.633219999 2095683.1648400002 37.7343554844182 -122.441853461362 (37.7343554844182, -122.441853461362)
50009 50009 237932 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Lower Ter 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   6000437.08664 2106174.23917 37.7631770886698 -122.44165722931601 (37.7631770886698, -122.441657229316)
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)
45763 45763 237933 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Lower Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6000440.92976 2106173.77589 37.7631760355812 -122.441643904037 (37.7631760355812, -122.441643904037)
47303 47303 237934 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Lower Ter 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6000443.264219999 2106174.87839 37.76317919578 -122.441635909067 (37.76317919578, -122.441635909067)
138178 138178 214355 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 811 Congo St 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6000531.25655 2095885.67636 37.734932531704004 -122.440593534571 (37.734932531704, -122.440593534571)
46953 46953 214356 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 811 Congo St 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6000533.92821 2095885.0481 37.7349309587854 -122.44058425268 (37.7349309587854, -122.44058425268)
43511 43511 237904 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 215 Grand View Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6000729.50411 2103183.58085 37.7549821289444 -122.440431357129 (37.7549821289444, -122.440431357129)
51929 51929 237924 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 47 Seward St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 3ft   6000838.40395 2104323.1770900004 37.7581173832271 -122.440136465844 (37.7581173832271, -122.440136465844)
71993 71993 237925 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 37 Seward St 7 Front Yard : Yard 7 Tree 1 Private 1     14 Width 3ft   6000968.93807 2104244.5163 37.7579088304528 -122.439679384512 (37.7579088304528, -122.439679384512)
72296 72296 237926 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 23 Seward St 1 Front Yard : Yard 7 Tree 1 Private 1     12 Width 3ft   6001036.33691 2104228.71408 37.757869277361706 -122.43944515878799 (37.7578692773617, -122.439445158788)
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)
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)
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)
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)
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)
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)
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)
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)

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