trees
10 rows where qSpecies_id = 405 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27615 | 62686 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 10 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1986 12:00:00 AM | 8 | Permit Number 23022 | 6012810.13629 | 2107011.05284 | 37.7661719884608 | -122.398921439372 | (37.7661719884608, -122.398921439372) | 14 | 3 | 8 | 28856 | 20 | ||
47803 | 190627 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 10 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012810.38261 | 2107000.50042 | 37.7661430275937 | -122.398919846697 | (37.7661430275937, -122.398919846697) | 14 | 3 | 8 | 28856 | 20 | |||
122999 | 190629 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 10 Arkansas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012813.49135 | 2106926.75638 | 37.7659407161217 | -122.398903917896 | (37.7659407161217, -122.398903917896) | 14 | 3 | 8 | 28856 | 20 | |||
168570 | 190628 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 10 Arkansas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012814.04326 | 2106938.8215 | 37.7659738750056 | -122.398902855807 | (37.7659738750056, -122.398902855807) | 14 | 3 | 8 | 28856 | 20 | |||
156830 | 228367 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 2 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006418.48215 | 2105819.2284 | 37.7625412913763 | -122.420944338021 | (37.7625412913763, -122.420944338021) | 8 | 4 | 7 | 28859 | 19 | |||
120482 | 228366 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 2622 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010258.40115 | 2104006.9766 | 37.7577809567352 | -122.407535616302 | (37.7577809567352, -122.407535616302) | 10 | 4 | 7 | 28859 | 19 | |||
24149 | 228368 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 2882 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009558.02863 | 2102797.82938 | 37.754421682229 | -122.409872452475 | (37.754421682229, -122.409872452475) | 2 | 4 | 7 | 28859 | 19 | |||
97835 | 228371 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 2882 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009506.55438 | 2102796.14519 | 37.7544141729027 | -122.410050345568 | (37.7544141729027, -122.410050345568) | 2 | 4 | 7 | 28859 | 19 | |||
137732 | 228370 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 2882 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009524.753 | 2102796.54439 | 37.7544162890042 | -122.409987437966 | (37.7544162890042, -122.409987437966) | 2 | 4 | 7 | 28859 | 19 | |||
184095 | 228369 | DPW Maintained 1 | Gleditsia triacanthos 'Shademaster' :: Honey Locust 'Shademaster' 405 | 2882 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009544.49144 | 2102796.527 | 37.754417347508 | -122.409919175836 | (37.754417347508, -122.409919175836) | 2 | 4 | 7 | 28859 | 19 |
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) );