trees
8 rows where Police Districts = 8 and qSpecies_id = 12 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14109 | 215410 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1955 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993444.94344 | 2102189.18609 | 37.7518343030148 | -122.465550997481 | (37.7518343030148, -122.465550997481) | 1 | 8 | 4 | 29491 | 12 | |||
| 32676 | 94158 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53537 | 5993734.5 | 2104887.1 | 37.7592587757026 | -122.464745577182 | (37.7592587757026, -122.464745577182) | 1 | 8 | 4 | 56 | 12 | ||
| 51885 | 92266 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 29 Allston Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52717 | 5994298.9 | 2098344 | 37.7413256083624 | -122.462319061907 | (37.7413256083624, -122.462319061907) | 1 | 8 | 4 | 59 | 40 | ||
| 87777 | 104163 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 2127 12TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 76 | 4x3 | Permit Number 770670 | 5992542 | 2100965 | 37.7484208831153 | -122.468584409749 | (37.7484208831153, -122.468584409749) | 1 | 8 | 4 | 29491 | 40 | ||
| 92229 | 215408 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1478 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5993690.81703 | 2105468.21978 | 37.7608518609501 | -122.46493885685 | (37.7608518609501, -122.46493885685) | 1 | 8 | 11 | 56 | 12 | |||
| 105784 | 215409 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993712.25346 | 2104885.19549 | 37.7592522638043 | -122.464822377549 | (37.7592522638043, -122.464822377549) | 1 | 8 | 4 | 56 | 12 | |||
| 131589 | 81524 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1643 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53916 | 5993372.97126564 | 2104303.07947151 | 37.7576343572278 | -122.465953471382 | (37.7576343572278, -122.465953471382) | 1 | 8 | 4 | 56 | 12 | |
| 174934 | 155501 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 175 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781267 | 5994415.96169 | 2098613.76746 | 37.7420730624341 | -122.461933863951 | (37.7420730624341, -122.461933863951) | 1 | 8 | 4 | 59 | 40 |
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) );