trees
7 rows where qSpecies_id = 179
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1218 | 39598 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 365 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 6 | Permit Number 41003 | 6011204.97691 | 2106670.11712 | 37.7651462828907 | -122.40444940203 | (37.7651462828907, -122.40444940203) | 8 | 3 | 8 | 28853 | 20 | |
| 47947 | 39599 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 365 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 5 | Permit Number 41003 | 6011204.16051 | 2106682.67681 | 37.7651807233399 | -122.404453109923 | (37.7651807233399, -122.404453109923) | 8 | 3 | 8 | 28853 | 20 | |
| 50790 | 39595 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 343 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 5 | Permit Number 41002 | 6011201.08685 | 2106729.17552 | 37.7653082265272 | -122.404467014363 | (37.7653082265272, -122.404467014363) | 8 | 3 | 8 | 28853 | 20 | |
| 79538 | 39594 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 343 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 3 | Permit Number 41002 | 6011202.82824 | 2106709.39136 | 37.7652540010087 | -122.404459598545 | (37.7652540010087, -122.404459598545) | 8 | 3 | 8 | 28853 | 20 | |
| 93894 | 39600 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 365 Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 6 | Permit Number 41003 | 6011203.37668 | 2106696.83712 | 37.7652195605499 | -122.404456817843 | (37.7652195605499, -122.404456817843) | 8 | 3 | 8 | 28853 | 20 | |
| 150028 | 39597 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 365 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 5 | Permit Number 41003 | 6011205.72817 | 2106654.35651 | 37.7651030497973 | -122.404445694115 | (37.7651030497973, -122.404445694115) | 8 | 3 | 8 | 28853 | 20 | |
| 189510 | 39596 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 365 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 3 | Permit Number 41003 | 6011206.39772 | 2106634.59416 | 37.7650488242625 | -122.404441987118 | (37.7650488242625, -122.404441987118) | 8 | 3 | 8 | 28853 | 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) );