trees
135 rows where qSpecies_id = 201 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16262 | 6710 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1200X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/1997 12:00:00 AM | 6 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
163262 | 114533 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 31 BAY VIEW ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014415 | 2094670 | 37.7323753626402 | -122.392507164078 | (37.7323753626402, -122.392507164078) | 10 | 3 | 8 | 58 | 1 | ||||
185722 | 114530 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 31 BAY VIEW ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014415 | 2094670 | 37.7323753626402 | -122.392507164078 | (37.7323753626402, -122.392507164078) | 10 | 3 | 8 | 58 | 1 | ||||
189932 | 114531 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 31 BAY VIEW ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014415 | 2094670 | 37.7323753626402 | -122.392507164078 | (37.7323753626402, -122.392507164078) | 10 | 3 | 8 | 58 | 1 | ||||
191181 | 116120 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1649x NEWHALL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6014119 | 2095297 | 37.7340805339716 | -122.393574379436 | (37.7340805339716, -122.393574379436) | 10 | 3 | 8 | 58 | 1 | ||||
60646 | 116182 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
90877 | 116171 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
98985 | 116168 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
113188 | 116173 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
113837 | 116167 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
128074 | 116172 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
150153 | 116166 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
158095 | 116170 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
176160 | 116174 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
178958 | 116169 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
184431 | 116175 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
191995 | 116176 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
155511 | 114474 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1254 MONTGOMERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011527 | 2119680 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | 3 | 1 | 10 | 308 | 23 | ||||
108635 | 121694 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1225 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2016 12:00:00 AM | 3 | 3x3 | 6011141 | 2102636 | 37.7540659221604 | -122.404386709259 | (37.7540659221604, -122.404386709259) | 10 | 4 | 8 | 28859 | 19 | ||
8995 | 116073 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 88 MONTCALM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | ||||
82271 | 116074 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 88 MONTCALM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | ||||
154147 | 102390 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 30X Harriet St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010362 | 2111859 | 37.7793466114027 | -122.407730971847 | (37.7793466114027, -122.407730971847) | 14 | 2 | 9 | 28853 | 34 | ||||
58269 | 122812 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 889 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009956.83094511 | 2104043.07852524 | 37.7578631996098 | -122.40858112242 | (37.7578631996098, -122.40858112242) | 2 | 4 | 7 | 28859 | 19 | ||||
163371 | 66635 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 889 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1998 12:00:00 AM | Permit Number 29846 | 6009956.83094511 | 2104043.07852524 | 37.7578631996098 | -122.40858112242 | (37.7578631996098, -122.40858112242) | 2 | 4 | 7 | 28859 | 19 | ||
81223 | 108917 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 45 LANGTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x3 | 6010039 | 2111121 | 37.7773021497785 | -122.408796288569 | (37.7773021497785, -122.408796288569) | 8 | 2 | 9 | 28853 | 34 | |||
165266 | 108915 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 45 LANGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2x3 | 6010039 | 2111121 | 37.7773021497785 | -122.408796288569 | (37.7773021497785, -122.408796288569) | 8 | 2 | 9 | 28853 | 34 | |||
1673 | 124722 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 701x York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009904 | 2104980 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | 2 | 4 | 8 | 28859 | 19 | ||||
54397 | 124721 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 701x York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2016 12:00:00 AM | 3x3 | 6009904 | 2104980 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | 2 | 4 | 8 | 28859 | 19 | |||
56034 | 124720 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 701x York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2016 12:00:00 AM | 3 | 3x3 | 6009904 | 2104980 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | 2 | 4 | 8 | 28859 | 19 | ||
71267 | 124719 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 701x York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009904 | 2104980 | 37.7604328157288 | -122.408829935053 | (37.7604328157288, -122.408829935053) | 2 | 4 | 8 | 28859 | 19 | ||||
167377 | 116343 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 611 YORK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009887 | 2105445 | 37.7617086481783 | -122.408921539166 | (37.7617086481783, -122.408921539166) | 2 | 4 | 8 | 28859 | 19 | ||||
176336 | 86911 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2256 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49876 | 6009641 | 2104201 | 37.7582791230904 | -122.409684549013 | (37.7582791230904, -122.409684549013) | 2 | 4 | 7 | 28859 | 19 | |
32286 | 102868 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2761 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | .75X.75 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | |||
171462 | 102875 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2761 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
68425 | 121339 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 214 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009065 | 2096301 | 37.736555179089 | -122.411118596402 | (37.736555179089, -122.411118596402) | 10 | 7 | 7 | 28859 | 2 | ||||
8290 | 259333 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 240 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008972 | 2097246 | 37.739144727939 | -122.411506882934 | (37.739144727939, -122.411506882934) | 10 | 7 | 7 | 28859 | 2 | ||||
188310 | 112373 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 15 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009208 | 2121303 | 37.8052128657777 | -122.412390870606 | (37.8052128657777, -122.412390870606) | 3 | 1 | 10 | 308 | 23 | ||||
44201 | 58123 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 800 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1978 12:00:00 AM | Permit Number 17105 | 6008509.24459419 | 2120396.75874665 | 37.802685318336 | -122.414744832906 | (37.802685318336, -122.414744832906) | 5 | 1 | 10 | 308 | 32 | |||
27232 | 109017 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 111x 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
127127 | 109020 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 111x 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
106986 | 100896 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1800 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
179643 | 100895 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1800 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
46643 | 39172 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 736 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 8 | Permit Number 40834 | 6007488.6062833 | 2105367.57823812 | 37.761361427438 | -122.417211152399 | (37.761361427438, -122.417211152399) | 2 | 4 | 7 | 28859 | 19 | |
58602 | 85259 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2239 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49558 | 6007574 | 2120083 | 37.8017712241665 | -122.417959005089 | (37.8017712241665, -122.417959005089) | 5 | 1 | 1 | 28858 | 32 | |||
81368 | 122475 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 3201x 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6006946 | 2103163 | 37.7552776242638 | -122.41893143992 | (37.7552776242638, -122.41893143992) | 2 | 4 | 7 | 28859 | 19 | |||
83730 | 122473 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 3201x 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6006946 | 2103163 | 37.7552776242638 | -122.41893143992 | (37.7552776242638, -122.41893143992) | 2 | 4 | 7 | 28859 | 19 | |||
140199 | 122474 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 3201x 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6006946 | 2103163 | 37.7552776242638 | -122.41893143992 | (37.7552776242638, -122.41893143992) | 2 | 4 | 7 | 28859 | 19 | |||
24432 | 255551 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 277 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006741 | 2104530 | 37.7590195448546 | -122.419737382682 | (37.7590195448546, -122.419737382682) | 2 | 4 | 7 | 28859 | 19 | ||||
48075 | 12885 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 200X Larch St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006589.39642 | 2113072.01589 | 37.7824653447827 | -122.420868153744 | (37.7824653447827, -122.420868153744) | 7 | 9 | 11 | 28852 | 41 | |||
141620 | 12882 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 200X Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006589.39642 | 2113072.01589 | 37.7824653447827 | -122.420868153744 | (37.7824653447827, -122.420868153744) | 7 | 9 | 11 | 28852 | 41 | |||
187122 | 12883 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 200X Larch St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006589.39642 | 2113072.01589 | 37.7824653447827 | -122.420868153744 | (37.7824653447827, -122.420868153744) | 7 | 9 | 11 | 28852 | 41 | |||
28174 | 12897 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
30168 | 12899 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
101621 | 12901 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
134662 | 12898 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
180899 | 12896 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | ||
180945 | 113407 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1959X POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6006418 | 2117595 | 37.7948746770036 | -122.421782481899 | (37.7948746770036, -122.421782481899) | 13 | 9 | 10 | 28858 | 32 | |||
142176 | 104391 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 3506 24TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006060 | 2102069 | 37.7522238232197 | -122.421917788016 | (37.7522238232197, -122.421917788016) | 2 | 4 | 5 | 28859 | 19 | |||
80596 | 24372 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 196 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005439.3271375 | 2108485.5635222 | 37.7698071707032 | -122.42452055163 | (37.7698071707032, -122.42452055163) | 8 | 4 | 5 | 28853 | 19 | |||
177114 | 24373 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005439.3271375 | 2108485.5635222 | 37.7698071707032 | -122.42452055163 | (37.7698071707032, -122.42452055163) | 8 | 4 | 5 | 28853 | 19 | |||
108197 | 53283 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2606 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49537 | 6005355.41207376 | 2118914.02943872 | 37.7984364178674 | -122.42555310995 | (37.7984364178674, -122.42555310995) | 13 | 9 | 1 | 57 | 17 | |||
1905 | 40652 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 227 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 2 | Permit Number 41647 | 6004715.33788 | 2093887.46334 | 37.7296832590634 | -122.425985487752 | (37.7296832590634, -122.425985487752) | 9 | 7 | 6 | 28861 | 5 | |
21486 | 114737 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW for City Agency 14 | DPW | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
39505 | 12439 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
66425 | 12435 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
103348 | 12437 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
108252 | 12436 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
11297 | 12432 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
28792 | 12433 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
136130 | 12431 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
192508 | 12434 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
46728 | 2641 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1765X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004408.21795 | 2114879.70403 | 37.7873056200256 | -122.428542973686 | (37.7873056200256, -122.428542973686) | 13 | 9 | 11 | 29490 | 27 | |||
75110 | 2642 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1765X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6004408.21795 | 2114879.70403 | 37.7873056200256 | -122.428542973686 | (37.7873056200256, -122.428542973686) | 13 | 9 | 11 | 29490 | 27 | |||
179967 | 104844 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 395X Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003932.8304 | 2096688.95118 | 37.7373312570435 | -122.428890347629 | (37.7373312570435, -122.428890347629) | 2 | 7 | 5 | 63 | 7 | |||
29785 | 88720 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 301 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | ||
44098 | 2649 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1945 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004183.14856 | 2114926.81574 | 37.7874222375245 | -122.429325027076 | (37.7874222375245, -122.429325027076) | 13 | 9 | 11 | 29490 | 27 | |||
87715 | 2648 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1945 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004183.14856 | 2114926.81574 | 37.7874222375245 | -122.429325027076 | (37.7874222375245, -122.429325027076) | 13 | 9 | 11 | 29490 | 27 | |||
184820 | 2460 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1802X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6004009.7642795 | 2114616.5275781 | 37.7865604469042 | -122.429902759542 | (37.7865604469042, -122.429902759542) | 13 | 9 | 11 | 29490 | 27 | |||
194140 | 2459 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1801X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1998 12:00:00 AM | 3 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.7865210759478 | -122.430070036959 | (37.7865210759478, -122.430070036959) | 13 | 9 | 11 | 29490 | 27 | ||
19233 | 108674 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
36111 | 108671 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
40648 | 108668 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
88393 | 108669 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
153514 | 108676 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
171574 | 108672 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
173983 | 108670 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
176478 | 108673 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
178820 | 108675 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
12504 | 253674 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 600 x Sanchez St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 6003598 | 2104743 | 37.7594268373878 | -122.430622555907 | (37.7594268373878, -122.430622555907) | 2 | 4 | 5 | 28862 | 3 | ||||
56835 | 4258 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 4094X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003364.7569552 | 2100412.8299453 | 37.7475239975457 | -122.431120155296 | (37.7475239975457, -122.431120155296) | 2 | 4 | 5 | 63 | 22 | |||
75400 | 4259 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 4094X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6003364.7569552 | 2100412.8299453 | 37.7475239975457 | -122.431120155296 | (37.7475239975457, -122.431120155296) | 2 | 4 | 5 | 63 | 22 | |||
191669 | 4260 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 4094X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003303.5082097 | 2100409.5413687 | 37.7475114969278 | -122.431331714787 | (37.7475114969278, -122.431331714787) | 2 | 4 | 5 | 63 | 22 | |||
168126 | 102450 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2205 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | Permit Number 772662 | 6003508.7 | 2117188.3 | 37.7935934914571 | -122.431820013768 | (37.7935934914571, -122.431820013768) | 13 | 9 | 1 | 29490 | 27 | |||
84057 | 113779 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 322 LISBON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002684 | 2091576 | 37.723221487961 | -122.432842971004 | (37.723221487961, -122.432842971004) | 9 | 7 | 6 | 28861 | 5 | |||||
81324 | 104327 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 69 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002459 | 2106769 | 37.7649251496158 | -122.434706648196 | (37.7649251496158, -122.434706648196) | 15 | 5 | 5 | 28862 | 3 | ||||
114486 | 84965 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2503 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52401 | 6001033 | 2118263 | 37.7964036854154 | -122.440463231838 | (37.7964036854154, -122.440463231838) | 13 | 9 | 1 | 57 | 17 | ||
91987 | 58133 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 311 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | Permit Number 17115 | 6000220.45021465 | 2109949.44722515 | 37.7735305196789 | -122.442677584536 | (37.7735305196789, -122.442677584536) | 15 | 5 | 11 | 29492 | 16 | ||
80990 | 107306 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 191 CASELLI AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000068 | 2104828 | 37.7594596127231 | -122.442837096046 | (37.7594596127231, -122.442837096046) | 2 | 4 | 5 | 28862 | 3 | |||
25263 | 107955 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 105 Danvers St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999967.5 | 2105076.1 | 37.7601351040878 | -122.443202492583 | (37.7601351040878, -122.443202492583) | 2 | 4 | 5 | 28862 | 3 | ||||
82303 | 57313 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 3x3 | Permit Number 16136 | 5999704.4841929 | 2114025.1830868 | 37.784692017358 | -122.444755399201 | (37.784692017358, -122.444755399201) | 15 | 6 | 1 | 29490 | 31 |
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) );