trees
11 rows where Zip Codes = 28856 and qSpecies_id = 202 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87275 | 189229 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1459 Rhode Island St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6012049.05152 | 2101579.41636 | 37.7512154759161 | -122.401172188849 | (37.7512154759161, -122.401172188849) | 10 | 3 | 8 | 28856 | 29 | ||||
| 41702 | 189228 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1300x De Haro St | 16 | Median : Yard | Tree | DPW 1 | 1 | 6012274.47933 | 2102155.74686 | 37.752810527903 | -122.40043310802 | (37.752810527903, -122.40043310802) | 10 | 3 | 8 | 28856 | 29 | ||||
| 87270 | 189221 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1310 Indiana St | 14 | : Yard | Tree | Private 2 | 1 | 6015010.96324 | 2102373.36426 | 37.7535602828051 | -122.390984975379 | (37.7535602828051, -122.390984975379) | 10 | 3 | 8 | 28856 | 29 | ||||
| 173458 | 189230 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6012335.96177 | 2103730.27512 | 37.7571372669841 | -122.400331070924 | (37.7571372669841, -122.400331070924) | 10 | 3 | 8 | 28856 | 29 | |||
| 160605 | 189231 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012362.34011 | 2103730.31063 | 37.7571388353939 | -122.4002398464 | (37.7571388353939, -122.4002398464) | 10 | 3 | 8 | 28856 | 29 | |||
| 110052 | 189232 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012390.79704 | 2103733.87239 | 37.7571502019395 | -122.400141680908 | (37.7571502019395, -122.400141680908) | 10 | 3 | 8 | 28856 | 29 | |||
| 185073 | 189233 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6012396.53776 | 2103734.18422 | 37.7571513782439 | -122.400121849061 | (37.7571513782439, -122.400121849061) | 10 | 3 | 8 | 28856 | 29 | |||
| 133070 | 189234 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012405.15003 | 2103734.72302 | 37.7571533378622 | -122.400092102164 | (37.7571533378622, -122.400092102164) | 10 | 3 | 8 | 28856 | 29 | |||
| 166041 | 189227 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1766 18th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 1ft | 6012472.41099 | 2105663.34278 | 37.7624526523798 | -122.399994920552 | (37.7624526523798, -122.399994920552) | 14 | 3 | 8 | 28856 | 29 | |||
| 41840 | 108726 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 460 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773097 | 6011176.24234 | 2106141.01313 | 37.7636918767911 | -122.404511540684 | (37.7636918767911, -122.404511540684) | 8 | 3 | 8 | 28856 | 29 |
| 167158 | 189226 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101 Pennsylvania Ave | 37 | Front Yard : Yard | Tree | Private 2 | 1 | 6014251.36443 | 2106690.81124 | 37.7653728778851 | -122.393914054695 | (37.7653728778851, -122.393914054695) | 14 | 3 | 8 | 28856 | 20 |
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) );