trees
193 rows where qSpecies_id = 256 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15259 | 178849 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 13 Liebig St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5995911.23484 | 2086261.34028 | 37.7082422172863 | -122.455870959398 | (37.7082422172863, -122.455870959398) | 7 | 6 | 28861 | 25 | ||||
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 | |||
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 | |||
30702 | 178854 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 401 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008573.82268 | 2088029.4794 | 37.7138157809362 | -122.412232379621 | (37.7138157809362, -122.412232379621) | 9 | 7 | 8 | 309 | 39 | |||
166266 | 214341 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 144 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995498.01894 | 2089341.34439 | 37.7166754640834 | -122.457521759431 | (37.7166754640834, -122.457521759431) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
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 | |||
188969 | 214342 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 331 Lakeview Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5996752.352 | 2089647.99235 | 37.7175894189894 | -122.453208302426 | (37.7175894189894, -122.453208302426) | 9 | 8 | 6 | 28861 | 24 | |||
141606 | 214343 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 105 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991402.99723 | 2089917.07257 | 37.7180201978552 | -122.47171800939 | (37.7180201978552, -122.47171800939) | 9 | 8 | 6 | 64 | 24 | |||
70720 | 214337 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995645.82098 | 2089943.68701 | 37.7183378437938 | -122.457054429431 | (37.7183378437938, -122.457054429431) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
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 | |||
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 | |||
172736 | 178855 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1101 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011864.77985 | 2089786.97938 | 37.7188256378672 | -122.400980956107 | (37.7188256378672, -122.400980956107) | 10 | 7 | 8 | 309 | 39 | |||
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 | |||
190908 | 214344 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 498 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992505.71978 | 2091140.82125 | 37.7214440535804 | -122.467995374584 | (37.7214440535804, -122.467995374584) | 9 | 8 | 6 | 64 | 24 | |||
58418 | 214345 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 498 Vernon St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992504.20594 | 2091177.71285 | 37.7215452614802 | -122.468003289546 | (37.7215452614802, -122.468003289546) | 9 | 8 | 6 | 64 | 24 | |||
168300 | 202088 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1 Gould St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012849.75876 | 2091137.38485 | 37.722588475066 | -122.397670917693 | (37.722588475066, -122.397670917693) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
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 | ||||
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 | |||
115839 | 214335 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 570 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5997650.4841 | 2094424.8417 | 37.730756962361 | -122.450448052843 | (37.730756962361, -122.450448052843) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
186104 | 214333 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 312 Hearst Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999316.02125 | 2094400.93218 | 37.7307864969836 | -122.444688331319 | (37.7307864969836, -122.444688331319) | 9 | 7 | 4 | 59 | 40 | |||
176476 | 214349 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 290 San Fernando Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992100.51565 | 2094983.26623 | 37.7319710480083 | -122.469675630143 | (37.7319710480083, -122.469675630143) | 9 | 8 | 4 | 59 | 40 | |||
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 | |
59134 | 214358 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 550 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998446.87478 | 2095010.46619 | 37.7324104972266 | -122.447736959314 | (37.7324104972266, -122.447736959314) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
79936 | 116119 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1649x Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2x2 | 6014063.16728 | 2095217.05774 | 37.7338579263887 | -122.393761818374 | (37.7338579263887, -122.393761818374) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | |||
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 | |||
147707 | 214356 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 811 Congo St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6000533.92821 | 2095885.0481 | 37.7349309587854 | -122.44058425268 | (37.7349309587854, -122.44058425268) | 9 | 7 | 4 | 63 | 40 | ||||
14352 | 214355 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 811 Congo St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6000531.25655 | 2095885.67636 | 37.734932531704 | -122.440593534571 | (37.734932531704, -122.440593534571) | 9 | 7 | 4 | 63 | 40 | ||||
137527 | 214328 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999189.95231 | 2096066.10598 | 37.7353514772763 | -122.44524384613 | (37.7353514772763, -122.44524384613) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
152210 | 214350 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100 Vista Verde Ct | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999173.54374 | 2096088.24984 | 37.735411342443 | -122.445302168061 | (37.735411342443, -122.445302168061) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
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 | |||
53090 | 237913 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 256 Bemis St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6003021.95871 | 2096302.85911 | 37.736219537998 | -122.432012088491 | (37.736219537998, -122.432012088491) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |||
193510 | 237943 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 22 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 6002178.91966 | 2096366.03049 | 37.7363451615923 | -122.434931333735 | (37.7363451615923, -122.434931333735) | 2 | 7 | 5 | 63 | 7 | |||
160402 | 214324 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 121 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5994586.44209 | 2096871.4866 | 37.7372990050334 | -122.461218135833 | (37.7372990050334, -122.461218135833) | 9 | 7 | 4 | 59 | 40 | |||
167408 | 214325 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 121 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5994585.09435 | 2096884.89716 | 37.7373357495539 | -122.461223767378 | (37.7373357495539, -122.461223767378) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
13595 | 183564 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2595 30th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5987057.6296 | 2097628.3948 | 37.7389411183073 | -122.487303955513 | (37.7389411183073, -122.487303955513) | 1 | 8 | 3 | 29491 | 35 | |||
157516 | 183563 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2593 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5987056.9644 | 2097643.917 | 37.7389836993781 | -122.487307395263 | (37.7389836993781, -122.487307395263) | 1 | 8 | 3 | 29491 | 35 | |||
113903 | 183562 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2591 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5987056.0774 | 2097655.4477 | 37.7390153079093 | -122.487311308785 | (37.7390153079093, -122.487311308785) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||||
193384 | 237880 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006230.93863 | 2097643.52174 | 37.7400821028175 | -122.421012466149 | (37.7400821028175, -122.421012466149) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
91173 | 237878 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006265.83898 | 2097650.58343 | 37.7401034599156 | -122.420892296036 | (37.7401034599156, -122.420892296036) | 2 | 7 | 7 | 28859 | 2 | ||||
177804 | 237877 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6006273.45555 | 2097651.54951 | 37.7401065418729 | -122.420866029569 | (37.7401065418729, -122.420866029569) | 2 | 7 | 7 | 28859 | 2 | ||||
171201 | 237876 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006280.46143 | 2097653.37775 | 37.740111956701 | -122.420841935814 | (37.740111956701, -122.420841935814) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
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 | ||||
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 | |||
100569 | 214323 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 211 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5994213.9284 | 2098746.30202 | 37.742425335868 | -122.462642037812 | (37.742425335868, -122.462642037812) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
67753 | 181899 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2374 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987671.986 | 2099129.3564 | 37.7430981701656 | -122.485289928402 | (37.7430981701656, -122.485289928402) | 1 | 8 | 3 | 29491 | 35 | |||
165907 | 181900 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2374 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5987672.3244 | 2099143.5701 | 37.7431372169369 | -122.485289801059 | (37.7431372169369, -122.485289801059) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
130829 | 214354 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Edgehill Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994911.61844 | 2099129.89576 | 37.7435187450863 | -122.460257437746 | (37.7435187450863, -122.460257437746) | 1 | 8 | 4 | 59 | 40 | |||
113311 | 237891 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 61 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007462.84884 | 2099058.94868 | 37.7440379165229 | -122.416853268066 | (37.7440379165229, -122.416853268066) | 2 | 7 | 7 | 28859 | 2 | |||
127191 | 237892 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 61 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007463.8743 | 2099061.81517 | 37.7440458449445 | -122.416849925291 | (37.7440458449445, -122.416849925291) | 2 | 7 | 7 | 28859 | 2 | |||
128972 | 214332 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 100x Idora Ave | 18 | Median : Yard | Tree | DPW 1 | 9 | Width 9ft | 5995718.21124 | 2099321.84536 | 37.7440921546362 | -122.457482343055 | (37.7440921546362, -122.457482343055) | 1 | 8 | 4 | 59 | 40 | |||
191326 | 214353 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 50 Garcia Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995149.72336 | 2099349.67966 | 37.7441359102383 | -122.459450049774 | (37.7441359102383, -122.459450049774) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
32573 | 237874 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 160 Coso Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6007471.90669 | 2099585.18417 | 37.7454833509872 | -122.416859223383 | (37.7454833509872, -122.416859223383) | 2 | 7 | 7 | 28859 | 2 | ||||
152943 | 237894 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010034.07785 | 2099858.60697 | 37.7463778949392 | -122.408018877775 | (37.7463778949392, -122.408018877775) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
63473 | 237903 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4120 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003087.27911 | 2100682.59751 | 37.7482489884214 | -122.432098917134 | (37.7482489884214, -122.432098917134) | 2 | 4 | 5 | 28862 | 22 | |||
174026 | 237902 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4120 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003116.41859 | 2100685.05072 | 37.7482573763929 | -122.43199832888 | (37.7482573763929, -122.43199832888) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
90527 | 237920 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1237 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003246.87227 | 2101064.36652 | 37.7493062835598 | -122.43157430031 | (37.7493062835598, -122.43157430031) | 2 | 4 | 5 | 28862 | 22 | |||
112904 | 237921 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1235 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003247.45246 | 2101075.30094 | 37.7493363397968 | -122.431573074532 | (37.7493363397968, -122.431573074532) | 2 | 4 | 5 | 28862 | 22 | |||
103259 | 237897 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1351 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009296.40092 | 2101303.05308 | 37.7503026946211 | -122.410671678154 | (37.7503026946211, -122.410671678154) | 2 | 4 | 7 | 28859 | 19 | |||
154055 | 214310 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1870 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5990380.69599 | 2102646.45339 | 37.7529126261287 | -122.476180871663 | (37.7529126261287, -122.476180871663) | 1 | 8 | 4 | 56 | 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 | |||
55518 | 196321 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1018 Pennsylvania Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 6014465.23121 | 2102394.5848 | 37.7535882525988 | -122.392873735151 | (37.7535882525988, -122.392873735151) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
82140 | 237898 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1087 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009471.98593 | 2102823.41576 | 37.754487114207 | -122.410171817891 | (37.754487114207, -122.410171817891) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
41063 | 237904 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 215 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000729.50411 | 2103183.58085 | 37.7549821289444 | -122.440431357129 | (37.7549821289444, -122.440431357129) | 2 | 4 | 5 | 28862 | 22 | |||
81293 | 237911 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 414 Collingwood St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002101.71196 | 2103425.35357 | 37.7557240165608 | -122.435703175975 | (37.7557240165608, -122.435703175975) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
175069 | 237929 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 741 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002446.47935 | 2103887.09921 | 37.7570114365341 | -122.434543876122 | (37.7570114365341, -122.434543876122) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | ||||
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 | ||||
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 |
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) );