trees
10 rows where Neighborhoods (old) = 20 and qSpecies_id = 50 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28655 | 116872 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013499.86788 | 2106650.27714 | 37.7652197871992 | -122.396510483775 | (37.7652197871992, -122.396510483775) | 14 | 3 | 8 | 28856 | 20 | |||
171733 | 190694 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013445.19565 | 2106684.95045 | 37.7653119497171 | -122.396702014197 | (37.7653119497171, -122.396702014197) | 14 | 3 | 8 | 28856 | 20 | |||
32204 | 116873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013484.98836 | 2106649.50082 | 37.7652168275233 | -122.396561894417 | (37.7652168275233, -122.396561894417) | 14 | 3 | 8 | 28856 | 20 | |||
153794 | 190695 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013444.76571 | 2106699.32295 | 37.7653513894931 | -122.396704508917 | (37.7653513894931, -122.396704508917) | 14 | 3 | 8 | 28856 | 20 | |||
69954 | 190696 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013444.35032 | 2106714.41309 | 37.7653928005592 | -122.396707003628 | (37.7653928005592, -122.396707003628) | 14 | 3 | 8 | 28856 | 20 | |||
113872 | 190697 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013439.7362 | 2106789.19698 | 37.7655978837597 | -122.396728206045 | (37.7655978837597, -122.396728206045) | 14 | 3 | 8 | 28856 | 20 | |||
130744 | 190698 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013440.07088 | 2106805.70814 | 37.7656432383768 | -122.396728206061 | (37.7656432383768, -122.396728206061) | 14 | 3 | 8 | 28856 | 20 | |||
28919 | 190699 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Missouri St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013438.17718 | 2106819.03274 | 37.7656797193792 | -122.3967356902 | (37.7656797193792, -122.3967356902) | 14 | 3 | 8 | 28856 | 20 | |||
32924 | 190747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 200 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6011390.12769 | 2107238.80287 | 37.7667181107881 | -122.403849027209 | (37.7667181107881, -122.403849027209) | 8 | 2 | 8 | 28853 | 20 | |||
109658 | 190748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 200 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6011391.69355 | 2107207.84436 | 37.7666331931997 | -122.403841432442 | (37.7666331931997, -122.403841432442) | 8 | 2 | 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) );