Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) |
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");