trees
11 rows where Supervisor Districts = 10 and qSpecies_id = 69 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15141 | 126353 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 504 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 6011954.85437 | 2117463.17081 | 37.7948233852421 | -122.40261479406 | (37.7948233852421, -122.40261479406) | 3 | 1 | 10 | 28860 | 4 | |||
20802 | 99981 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 535@Clay Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6012012.90465 | 2117729.4246 | 37.7955576951954 | -122.402432661541 | (37.7955576951954, -122.402432661541) | 3 | 1 | 10 | 28860 | 4 | ||||
24240 | 126352 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 502 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012121.48389 | 2117472.15309 | 37.7948573499363 | -122.402038861028 | (37.7948573499363, -122.402038861028) | 3 | 1 | 10 | 28860 | 4 | |||
37193 | 126350 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 537 Washington St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011989.04393 | 2117728.77909 | 37.7955545907368 | -122.402515178844 | (37.7955545907368, -122.402515178844) | 3 | 1 | 10 | 28860 | 4 | |||
69233 | 126349 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 537 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6011875.41872 | 2117711.58246 | 37.7955010289084 | -122.402907133964 | (37.7955010289084, -122.402907133964) | 3 | 1 | 10 | 28860 | 4 | |||
93835 | 126351 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 502 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6012136.18847 | 2117471.88695 | 37.7948574398751 | -122.401987962086 | (37.7948574398751, -122.401987962086) | 3 | 1 | 10 | 28860 | 4 | |||
107714 | 126354 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 504 Clay St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 6011865.58602 | 2117449.65237 | 37.7947812825955 | -122.402922725517 | (37.7947812825955, -122.402922725517) | 3 | 1 | 10 | 28860 | 4 | |||
108297 | 99985 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 535 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
163853 | 99986 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 535 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
177588 | 99982 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 535@Clay Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
178138 | 99997 | Permitted Site 7 | Corymbia maculata :: Spotted Gum 69 | 600@Clay Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 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) );