trees
9 rows where Zip Codes = 28857 and qSpecies_id = 6
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42267 | 83686 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.29288 | 2117660.17543 | 37.7952218082983 | -122.411440210903 | (37.7952218082983, -122.411440210903) | 3 | 1 | 10 | 28857 | 4 | |
| 74010 | 129386 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | 5 | 1 | 10 | 28857 | 21 | |||
| 80490 | 83685 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009407.14931 | 2117677.56911 | 37.7952695029448 | -122.411445397284 | (37.7952695029448, -122.411445397284) | 3 | 1 | 10 | 28857 | 4 | |
| 81222 | 83687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009414.65188 | 2117634.89994 | 37.7951527646548 | -122.411416421158 | (37.7951527646548, -122.411416421158) | 3 | 1 | 10 | 28857 | 4 | |
| 81750 | 129385 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 722 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009662.68842 | 2115877.38276 | 37.7903409582254 | -122.41043401253 | (37.7903409582254, -122.41043401253) | 5 | 1 | 10 | 28857 | 21 | |||
| 127633 | 52071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.410515038747 | (37.7954949369081, -122.410515038747) | 3 | 1 | 10 | 28857 | 4 | ||
| 154237 | 60223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.59197 | 2117542.6242 | 37.7949000677337 | -122.411368584404 | (37.7949000677337, -122.411368584404) | 3 | 1 | 10 | 28857 | 4 | |
| 166093 | 88438 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Mason St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52242 | 6009421 | 2117567 | 37.7949666840821 | -122.411389656386 | (37.7949666840821, -122.411389656386) | 3 | 1 | 10 | 28857 | 4 | |||
| 194195 | 52070 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.51311 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | 3 | 1 | 10 | 28857 | 4 |
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) );