trees
10 rows where Zip Codes = 54 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
167492 | 123228 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 790 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 5993224.04217 | 2110104.87798 | 37.7735559729611 | -122.466890291652 | (37.7735559729611, -122.466890291652) | 11 | 6 | 2 | 54 | 11 | |||
137188 | 123227 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 790 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 5993222.74872 | 2110119.7569 | 37.7735967518389 | -122.466895847723 | (37.7735967518389, -122.466895847723) | 11 | 6 | 2 | 54 | 11 | |||
145137 | 93572 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 757 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2010 12:00:00 AM | 14 | Permit Number 53252 | 5994718.18671 | 2110428.47346 | 37.7745306031117 | -122.46174532831 | (37.7745306031117, -122.46174532831) | 11 | 6 | 2 | 54 | 11 | ||
160089 | 97887 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1030 Cabrillo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/23/2011 12:00:00 AM | 1 | Permit Number 768379 | 5992385.79681 | 2110712.74988 | 37.7751766093559 | -122.469834146271 | (37.7751766093559, -122.469834146271) | 11 | 6 | 2 | 54 | 11 | ||
55533 | 123429 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 690 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5995057.91765 | 2110847.92629 | 37.7757018603334 | -122.460600543143 | (37.7757018603334, -122.460600543143) | 11 | 6 | 2 | 54 | 11 | |||
137530 | 123393 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 667 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5995006.92654 | 2111007.28114 | 37.7761364727826 | -122.460788484161 | (37.7761364727826, -122.460788484161) | 11 | 6 | 2 | 54 | 11 | |||
43318 | 115333 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 667 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776458 | 5994991 | 2111007.6 | 37.7761364319113 | -122.460843601074 | (37.7761364319113, -122.460843601074) | 11 | 6 | 2 | 54 | 11 | ||
65494 | 121978 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991208.06978 | 2113958.75361 | 37.7840210969883 | -122.474145024774 | (37.7840210969883, -122.474145024774) | 11 | 6 | 2 | 54 | 26 | |||
87180 | 121977 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5991207.54931 | 2113971.26516 | 37.7840554200842 | -122.474147738612 | (37.7840554200842, -122.474147738612) | 11 | 6 | 2 | 54 | 26 | |||
84362 | 121976 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991206.08725 | 2113988.74508 | 37.7841033304005 | -122.474154072624 | (37.7841033304005, -122.474154072624) | 11 | 6 | 2 | 54 | 26 |
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) );