trees
193 rows where qSpecies_id = 256 sorted by DBH
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4669 | 259575 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 300 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 4x4 | 5994278 | 2098760 | 37.7424666368704 | -122.462421492412 | (37.7424666368704, -122.462421492412) | 1 | 8 | 4 | 59 | 40 | ||||
3251 | 214319 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 109 Edgewood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5996574.94596 | 2106340.51258 | 37.7634128279669 | -122.455027021201 | (37.7634128279669, -122.455027021201) | 15 | 5 | 11 | 29492 | 12 | |||
20257 | 178853 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 34 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012436.48238 | 2087819.01103 | 37.7134538649768 | -122.398866750723 | (37.7134538649768, -122.398866750723) | 10 | 3 | 8 | 309 | 1 | |||
45379 | 237887 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 169 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999396.06078 | 2107229.01514 | 37.7660138714542 | -122.44533362007 | (37.7660138714542, -122.44533362007) | 15 | 5 | 5 | 29492 | 9 | |||
48807 | 123051 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 544 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5991925.36829 | 2111718.74321 | 37.777912168825 | -122.471500177072 | (37.777912168825, -122.471500177072) | 11 | 6 | 2 | 54 | 11 | |||
50526 | 200068 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2025 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014532.2716 | 2093611.1753 | 37.7294745562967 | -122.392027707824 | (37.7294745562967, -122.392027707824) | 10 | 3 | 8 | 58 | 1 | |||
65928 | 237918 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 179 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998918.30257 | 2107113.8819 | 37.7656704608532 | -122.4469777966 | (37.7656704608532, -122.4469777966) | 15 | 5 | 11 | 29492 | 9 | |||
71671 | 178852 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 642 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6003293.17352 | 2089466.63658 | 37.71746417401 | -122.430586734103 | (37.71746417401, -122.430586734103) | 9 | 7 | 6 | 28861 | 5 | |||
86444 | 182193 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2830 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985470.896 | 2104355.1387 | 37.7573182698464 | -122.493285511535 | (37.7573182698464, -122.493285511535) | 1 | 8 | 3 | 56 | 35 | |||
92929 | 182339 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3081 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985312.4034 | 2104975.8588 | 37.759013323653 | -122.493879375972 | (37.759013323653, -122.493879375972) | 1 | 8 | 3 | 56 | 35 | |||
118298 | 237930 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4119 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002901.50765 | 2104134.40267 | 37.7577162927848 | -122.432987885294 | (37.7577162927848, -122.432987885294) | 2 | 4 | 5 | 28862 | 3 | |||
121176 | 135861 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 5 Dicha Aly | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 5998316.32407 | 2113776.61007 | 37.7839301859787 | -122.44954003255 | (37.7839301859787, -122.44954003255) | 15 | 6 | 1 | 54 | 31 | |||
129701 | 200001 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1450 Griffith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017674.9346 | 2092354.0887 | 37.7261968206849 | -122.381075736801 | (37.7261968206849, -122.381075736801) | 10 | 3 | 8 | 58 | 1 | |||
23810 | 214330 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 12 | Median : Yard | Tree | DPW 1 | 10 | Width 9ft | 5995527.4625 | 2099368.48178 | 37.7442092481691 | -122.458145280077 | (37.7442092481691, -122.458145280077) | 1 | 8 | 4 | 59 | 40 | |||
32097 | 237896 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3337 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007507.32958 | 2100885.13303 | 37.7490547108172 | -122.416828817304 | (37.7490547108172, -122.416828817304) | 2 | 4 | 7 | 28859 | 19 | |||
51898 | 105709 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 739 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5992855.21688 | 2110425.97288 | 37.7744163192706 | -122.468189464852 | (37.7744163192706, -122.468189464852) | 11 | 6 | 2 | 54 | 11 | |||
55742 | 237879 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6006275.05202 | 2097644.49058 | 37.7400872496179 | -122.420860008587 | (37.7400872496179, -122.420860008587) | 2 | 7 | 7 | 28859 | 2 | ||||
64901 | 214336 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 165 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998449.68813 | 2093175.59235 | 37.727372526598 | -122.447595198264 | (37.727372526598, -122.447595198264) | 9 | 7 | 4 | 28861 | 40 | ||||
108292 | 135873 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1002 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 6008628.64799 | 2118672.57502 | 37.7979578472257 | -122.414209576908 | (37.7979578472257, -122.414209576908) | 5 | 1 | 10 | 308 | 21 | ||||
115454 | 135863 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Kimball Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007998.64807 | 2116497.60836 | 37.7919505198577 | -122.416235439221 | (37.7919505198577, -122.416235439221) | 5 | 1 | 10 | 28858 | 21 | |||
116148 | 98003 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1904 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x12 | 6003782.57859 | 2119037.12075 | 37.7986853996597 | -122.431004385541 | (37.7986853996597, -122.431004385541) | 13 | 9 | 1 | 57 | 17 | |||
123915 | 237895 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010025.93602 | 2099871.47095 | 37.7464127607541 | -122.408047938455 | (37.7464127607541, -122.408047938455) | 2 | 7 | 7 | 28859 | 2 | |||
126456 | 58192 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 707 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1978 12:00:00 AM | 10 | Permit Number 17180 | 5992850.41876 | 2110607.08647 | 37.7749133313412 | -122.468219240401 | (37.7749133313412, -122.468219240401) | 11 | 6 | 2 | 54 | 11 | ||
126920 | 214314 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1630 09th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 6ft | 5993419.49404 | 2104375.41426 | 37.7578356535119 | -122.465797833501 | (37.7578356535119, -122.465797833501) | 1 | 8 | 4 | 56 | 12 | |||
145267 | 237932 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Lower Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6000437.08664 | 2106174.23917 | 37.7631770886698 | -122.441657229316 | (37.7631770886698, -122.441657229316) | 15 | 5 | 5 | 28862 | 3 | |||
155222 | 214321 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 166 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991310.02713 | 2104174.00205 | 37.7571607203998 | -122.473078490286 | (37.7571607203998, -122.473078490286) | 1 | 8 | 4 | 56 | 12 | |||
158815 | 214327 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999204.10164 | 2096073.93624 | 37.7353737849692 | -122.445195489605 | (37.7353737849692, -122.445195489605) | 9 | 7 | 4 | 63 | 40 | |||
4758 | 237915 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1295 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997519.793 | 2104903.62119 | 37.7595216458395 | -122.451655461936 | (37.7595216458395, -122.451655461936) | 15 | 5 | 11 | 29492 | 12 | |||
62395 | 178850 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 178 Dublin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004207.2935 | 2089409.65664 | 37.7173594632439 | -122.427422984776 | (37.7173594632439, -122.427422984776) | 9 | 7 | 6 | 28861 | 5 | |||
63930 | 214329 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 11 | Median : Yard | Tree | DPW 1 | 11 | Width 9ft | 5995487.46893 | 2099377.84768 | 37.7442326665051 | -122.458284246023 | (37.7442326665051, -122.458284246023) | 1 | 8 | 4 | 59 | 40 | |||
68421 | 178851 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 642 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002153.25457 | 2090190.26057 | 37.719386440714 | -122.434578616011 | (37.719386440714, -122.434578616011) | 9 | 7 | 6 | 28861 | 5 | |||
90648 | 113952 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1416 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009764.02998 | 2118627.67395 | 37.7978982689348 | -122.410277642896 | (37.7978982689348, -122.410277642896) | 3 | 1 | 10 | 308 | 4 | |||
113135 | 237873 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1200 San Jose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004198.3369 | 2096122.91618 | 37.7357920776323 | -122.427932046027 | (37.7357920776323, -122.427932046027) | 2 | 7 | 5 | 63 | 7 | |||
137500 | 214351 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999187.72445 | 2096110.16457 | 37.7354723245737 | -122.445254715344 | (37.7354723245737, -122.445254715344) | 9 | 7 | 4 | 63 | 40 | |||
141525 | 237882 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 814 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008528.1634 | 2103776.1584 | 37.7570501811472 | -122.413503191821 | (37.7570501811472, -122.413503191821) | 2 | 4 | 7 | 28859 | 19 | |||
28852 | 237869 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1180 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997415.00781 | 2106032.30946 | 37.762614737193 | -122.452099295361 | (37.762614737193, -122.452099295361) | 15 | 5 | 11 | 29492 | 9 | |||
77581 | 27414 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005892.4011 | 2118361.12861 | 37.7969486190501 | -122.423655628528 | (37.7969486190501, -122.423655628528) | 13 | 9 | 1 | 28858 | 32 | |||
98934 | 23463 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005896.8378 | 2118341.60488 | 37.7968952622641 | -122.423638887645 | (37.7968952622641, -122.423638887645) | 13 | 9 | 1 | 28858 | 32 | |||
107179 | 237926 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 23 Seward St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6001036.33691 | 2104228.71408 | 37.7578692773617 | -122.439445158788 | (37.7578692773617, -122.439445158788) | 2 | 4 | 5 | 28862 | 38 | |||
124031 | 214313 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1630 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 6ft | 5993420.04408 | 2104384.15571 | 37.7578596869935 | -122.465796566365 | (37.7578596869935, -122.465796566365) | 1 | 8 | 4 | 56 | 12 | |||
125030 | 178857 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 701 Delta St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6009291.72599 | 2087274.33794 | 37.711782574777 | -122.409697761866 | (37.711782574777, -122.409697761866) | 9 | 7 | 8 | 309 | 39 | |||
128567 | 214322 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 350x Kensington Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | Width 6ft | 5994251.85903 | 2099042.92229 | 37.7432419652355 | -122.462532396964 | (37.7432419652355, -122.462532396964) | 1 | 8 | 4 | 59 | 40 | |||
131455 | 237916 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1295 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5997518.24966 | 2104934.77487 | 37.7596070976188 | -122.451663046815 | (37.7596070976188, -122.451663046815) | 15 | 5 | 11 | 29492 | 12 | |||
136617 | 26103 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1557 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/1988 12:00:00 AM | 12 | 3x3 | 6015264.4135 | 2095277.0122 | 37.7340892301542 | -122.38961289841 | (37.7340892301542, -122.38961289841) | 10 | 3 | 8 | 58 | 1 | ||
154527 | 27415 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005889.8891 | 2118381.22689 | 37.7970036620469 | -122.423665750374 | (37.7970036620469, -122.423665750374) | 13 | 9 | 1 | 28858 | 32 | |||
160687 | 237907 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3911 21st St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6002340.71018 | 2103530.84091 | 37.7560272319733 | -122.434884188553 | (37.7560272319733, -122.434884188553) | 2 | 4 | 5 | 28862 | 22 | ||||
168860 | 237942 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 320 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003704.07001 | 2108683.26654 | 37.7702518672718 | -122.430536868479 | (37.7702518672718, -122.430536868479) | 15 | 9 | 11 | 29492 | 10 | |||
39674 | 214357 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 61 Stillings Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6000162.63322 | 2095683.16484 | 37.7343554844182 | -122.441853461362 | (37.7343554844182, -122.441853461362) | 9 | 7 | 5 | 63 | 40 | |||
75539 | 237900 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008886.65088 | 2103959.41051 | 37.7575734723481 | -122.412276352893 | (37.7575734723481, -122.412276352893) | 2 | 4 | 7 | 28859 | 19 | |||
76693 | 142495 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 471 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010670.1646 | 2119603.9064 | 37.800629516216 | -122.407210998267 | (37.800629516216, -122.407210998267) | 3 | 1 | 10 | 308 | 23 | |||
77592 | 135874 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 941 Vallejo St | 5 | Front Yard : Yard | Tree | Private 2 | 14 | 6008901.53322 | 2118681.17119 | 37.7979967743805 | -122.413265921012 | (37.7979967743805, -122.413265921012) | 3 | 1 | 10 | 308 | 21 | ||||
157438 | 237939 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 273 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000450.96835 | 2106715.6224 | 37.764664383877 | -122.441648071496 | (37.764664383877, -122.441648071496) | 15 | 5 | 5 | 28862 | 3 | |||
187537 | 237925 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 37 Seward St | 7 | Front Yard : Yard | Tree | Private 2 | 14 | Width 3ft | 6000968.93807 | 2104244.5163 | 37.7579088304528 | -122.439679384512 | (37.7579088304528, -122.439679384512) | 2 | 4 | 5 | 28862 | 38 | |||
28309 | 237924 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 47 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000838.40395 | 2104323.17709 | 37.7581173832271 | -122.440136465844 | (37.7581173832271, -122.440136465844) | 2 | 4 | 5 | 28862 | 38 | |||
54433 | 237944 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 26 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 15 | Width 2ft | 6002164.0262 | 2096336.81786 | 37.736264104808 | -122.434980737977 | (37.736264104808, -122.434980737977) | 2 | 7 | 5 | 63 | 7 | |||
116631 | 237922 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 167 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002705.54642 | 2104925.31615 | 37.7598768339596 | -122.433722125974 | (37.7598768339596, -122.433722125974) | 2 | 4 | 5 | 28862 | 3 | |||
80159 | 237941 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 84 Potomac St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003101.59687 | 2108830.30244 | 37.770621443648 | -122.432631322989 | (37.770621443648, -122.432631322989) | 15 | 5 | 5 | 29492 | 9 | |||
80997 | 214348 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993734.17627 | 2099649.69883 | 37.7448781944898 | -122.464366439256 | (37.7448781944898, -122.464366439256) | 1 | 8 | 4 | 29491 | 40 | |||
51337 | 237909 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3911 21st St | 5 | Side Yard : Yard | Tree | Private 2 | 17 | 6002350.80679 | 2103530.36749 | 37.7560265053261 | -122.434849237305 | (37.7560265053261, -122.434849237305) | 2 | 4 | 5 | 28862 | 22 | ||||
39718 | 237908 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3911 21st St | 4 | Side Yard : Yard | Tree | Private 2 | 18 | 6002345.78312 | 2103531.79558 | 37.7560301412935 | -122.43486671293 | (37.7560301412935, -122.43486671293) | 2 | 4 | 5 | 28862 | 22 | ||||
96174 | 237905 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3937 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6002227.46362 | 2103520.47073 | 37.7559923274905 | -122.435275090576 | (37.7559923274905, -122.435275090576) | 2 | 4 | 5 | 28862 | 22 | ||||
184666 | 237884 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1229 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 5997429.19812 | 2105587.88131 | 37.7613952627958 | -122.452018150436 | (37.7613952627958, -122.452018150436) | 15 | 5 | 11 | 29492 | 12 | |||
77860 | 196324 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2014 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6011723.18554 | 2105150.83196 | 37.761003611654 | -122.40255018945 | (37.761003611654, -122.40255018945) | 10 | 3 | 8 | 28856 | 29 | |||
52368 | 214315 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1643 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993376.02878 | 2104293.90166 | 37.7576093337224 | -122.465942230469 | (37.7576093337224, -122.465942230469) | 1 | 8 | 4 | 56 | 12 | |||
90482 | 237885 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 730 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997985.44903 | 2107861.40989 | 37.7676696429749 | -122.450258206855 | (37.7676696429749, -122.450258206855) | 15 | 5 | 11 | 29492 | 9 | |||
102207 | 214334 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 470 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5998312.15542 | 2094413.43188 | 37.7307634815435 | -122.448159739578 | (37.7307634815435, -122.448159739578) | 9 | 7 | 4 | 59 | 40 | |||
118841 | 196331 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013062.01072 | 2103694.01523 | 37.7570781653471 | -122.397817553962 | (37.7570781653471, -122.397817553962) | 10 | 3 | 8 | 28856 | 29 | ||||
129479 | 214340 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995647.31789 | 2089997.48145 | 37.7184856365862 | -122.457053144299 | (37.7184856365862, -122.457053144299) | 9 | 8 | 6 | 28861 | 24 | |||
132201 | 196330 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011759.95887 | 2105639.7656 | 37.7623481673595 | -122.402457386618 | (37.7623481673595, -122.402457386618) | 8 | 3 | 8 | 28856 | 29 | ||||
141635 | 237881 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6006228.09651 | 2097633.90585 | 37.7400555395259 | -122.42102161048 | (37.7400555395259, -122.42102161048) | 2 | 7 | 7 | 28859 | 2 | ||||
148401 | 196332 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013061.70024 | 2103702.02862 | 37.7571001510787 | -122.39781918981 | (37.7571001510787, -122.39781918981) | 10 | 3 | 8 | 28856 | 29 | ||||
168191 | 214331 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 13 | Median : Yard | Tree | DPW 1 | 2 | Width 9ft | 5995540.56521 | 2099364.92702 | 37.7442002405496 | -122.458099716827 | (37.7442002405496, -122.458099716827) | 1 | 8 | 4 | 59 | 40 | |||
192023 | 135862 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Kimball Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008000.71273 | 2116486.83875 | 37.7919210652522 | -122.416227532369 | (37.7919210652522, -122.416227532369) | 5 | 1 | 10 | 28858 | 21 | |||
193172 | 183467 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2534 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988330.845 | 2098043.4689 | 37.7401549687764 | -122.482932230746 | (37.7401549687764, -122.482932230746) | 1 | 8 | 3 | 29491 | 35 | |||
99778 | 237912 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3974 22nd St | 3 | : | Tree | Private 2 | 20 | 6002002.92886 | 2102961.58207 | 37.7544449998516 | -122.436011614667 | (37.7544449998516, -122.436011614667) | 2 | 4 | 5 | 28862 | 22 | ||||
43672 | 237890 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6009586.52326 | 2097993.57219 | 37.7412318491774 | -122.409434875633 | (37.7412318491774, -122.409434875633) | 10 | 7 | 7 | 28859 | 2 | |||
166314 | 214317 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 20 Belmont Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5996726.67758 | 2106195.56131 | 37.763023532129 | -122.454491761784 | (37.763023532129, -122.454491761784) | 15 | 5 | 11 | 29492 | 12 | ||||
17385 | 29888 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1126 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6005721.57126 | 2102405.52669 | 37.7531287556897 | -122.423112046809 | (37.7531287556897, -122.423112046809) | 2 | 4 | 5 | 28859 | 19 | |||
144998 | 237910 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 414 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6002101.86364 | 2103432.68582 | 37.7557441577743 | -122.435703175979 | (37.7557441577743, -122.435703175979) | 2 | 4 | 5 | 28862 | 22 | ||||
3700 | 60597 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 839 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 3 | Permit Number 20219 | 5999535.7853 | 2111409.5838 | 37.7775006284393 | -122.445150928593 | (37.7775006284393, -122.445150928593) | 15 | 5 | 11 | 54 | 16 | |
5265 | 214338 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995645.44763 | 2089954.09949 | 37.7183664125644 | -122.4570564727 | (37.7183664125644, -122.4570564727) | 9 | 8 | 6 | 28861 | 24 | |||
22709 | 237899 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 401 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007240.84354 | 2104941.30252 | 37.760177031273 | -122.418037841569 | (37.760177031273, -122.418037841569) | 2 | 4 | 7 | 28859 | 19 | |||
36902 | 214339 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995645.61653 | 2089973.75632 | 37.7184203952771 | -122.457057309964 | (37.7184203952771, -122.457057309964) | 9 | 8 | 6 | 28861 | 24 | |||
48652 | 196327 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6011756.69483 | 2105652.08155 | 37.7623818019909 | -122.402469541836 | (37.7623818019909, -122.402469541836) | 8 | 3 | 8 | 28856 | 29 | ||||
49088 | 237889 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 722 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007362.196 | 2095569.17155 | 37.7344500984995 | -122.416954096469 | (37.7344500984995, -122.416954096469) | 2 | 7 | 7 | 28859 | 2 | |||
91722 | 135867 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2881 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999809.28552 | 2117392.98346 | 37.7939450956373 | -122.444634966434 | (37.7939450956373, -122.444634966434) | 13 | 9 | 1 | 57 | 27 | |||
94201 | 214352 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 50 Garcia Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995162.00455 | 2099364.3275 | 37.744176835692 | -122.459408645009 | (37.744176835692, -122.459408645009) | 1 | 8 | 4 | 59 | 40 | |||
103932 | 196323 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1922 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 6012591.21229 | 2102864.69613 | 37.7547748064319 | -122.399387546319 | (37.7547748064319, -122.399387546319) | 10 | 3 | 8 | 28856 | 29 | ||||
104386 | 237875 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 200 Kingston St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | 6006243.16762 | 2098035.54696 | 37.7411592055212 | -122.420998010444 | (37.7411592055212, -122.420998010444) | 2 | 7 | 7 | 28859 | 2 | ||||
130359 | 117740 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 475 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5983746.49746 | 2112674.00016 | 37.7800584750229 | -122.499863945897 | (37.7800584750229, -122.499863945897) | 11 | 6 | 2 | 55 | 26 | |||
149035 | 135870 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001706.98139 | 2117190.01379 | 37.7934958986807 | -122.438054218747 | (37.7934958986807, -122.438054218747) | 13 | 6 | 1 | 29490 | 27 | |||
160624 | 68433 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2518 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 3 | Permit Number 32286 | 6002013.47223 | 2116725.04565 | 37.7922366418513 | -122.436960435397 | (37.7922366418513, -122.436960435397) | 13 | 6 | 1 | 29490 | 27 | ||
174153 | 196333 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013061.90076 | 2103711.91526 | 37.7571273088036 | -122.397819189808 | (37.7571273088036, -122.397819189808) | 10 | 3 | 8 | 28856 | 29 | ||||
187535 | 135865 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2518 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001998.80283 | 2116724.02313 | 37.7922330004913 | -122.437011118472 | (37.7922330004913, -122.437011118472) | 13 | 6 | 1 | 29490 | 27 | |||
188214 | 237893 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 48 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007622.58869 | 2099939.38246 | 37.7464643746486 | -122.416363270665 | (37.7464643746486, -122.416363270665) | 2 | 7 | 7 | 28859 | 2 | |||
194036 | 135868 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2881 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999820.06951 | 2117394.7311 | 37.7939505095535 | -122.444597778561 | (37.7939505095535, -122.444597778561) | 13 | 9 | 1 | 57 | 27 | |||
177598 | 18547 | Landmark tree 11 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1700X Quesada Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014668.27449 | 2095058.71423 | 37.733456755021 | -122.391658696189 | (37.733456755021, -122.391658696189) | 10 | 3 | 8 | 58 | 1 | |||
6807 | 60384 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1400 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19964 | 6015915.704 | 2094515.2497 | 37.7320336750995 | -122.387308043521 | (37.7320336750995, -122.387308043521) | 10 | 3 | 8 | 58 | 1 | |
16370 | 237937 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 272 Corbett Ave | 6 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 5999630.47363 | 2105335.88644 | 37.7608291899486 | -122.444386772443 | (37.7608291899486, -122.444386772443) | 15 | 5 | 5 | 28862 | 3 | |||
28682 | 214326 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 121 Miraloma Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5994581.43196 | 2096914.17176 | 37.7374159195969 | -122.461238551316 | (37.7374159195969, -122.461238551316) | 9 | 7 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );