trees
13 rows where Supervisor Districts = 1 and qSpecies_id = 2 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102280 | 131010 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3099 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001935.38679 | 2118702.33437 | 37.7976613236686 | -122.437372261923 | (37.7976613236686, -122.437372261923) | 13 | 9 | 1 | 57 | 17 | |||
111986 | 131011 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002300.20603 | 2120865.81933 | 37.8036224187107 | -122.436264801676 | (37.8036224187107, -122.436264801676) | 13 | 9 | 1 | 57 | 17 | |||
60588 | 125087 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
164641 | 125088 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
185594 | 135722 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
103060 | 13103 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1516 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2008 12:00:00 AM | 3 | 3x3 | 6005111 | 2119918 | 37.8011792509168 | -122.426470375667 | (37.8011792509168, -122.426470375667) | 13 | 9 | 1 | 57 | 17 | ||
78957 | 51994 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3858 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1977 12:00:00 AM | Permit Number 769135 | 5995734.40748516 | 2115851.40858603 | 37.78947898308 | -122.458622703992 | (37.78947898308, -122.458622703992) | 11 | 6 | 1 | 54 | 31 | |||
79656 | 2 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 850X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 5992872.52482 | 2114854.21479 | 37.7865760666822 | -122.468451837381 | (37.7865760666822, -122.468451837381) | 11 | 6 | 1 | 54 | 11 | ||
128897 | 87882 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50853 | 6002283.00879 | 2120864.77597 | 37.8036185768076 | -122.436324238766 | (37.8036185768076, -122.436324238766) | 13 | 9 | 1 | 57 | 17 | |
25318 | 16583 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 810X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2008 12:00:00 AM | 2 | 3X3 | 5992991.92524 | 2114858.80829 | 37.7865955752076 | -122.468039078982 | (37.7865955752076, -122.468039078982) | 11 | 6 | 1 | 54 | 11 | ||
56547 | 124911 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3234 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998736.95045 | 2116593.12953 | 37.7916876606053 | -122.448287711302 | (37.7916876606053, -122.448287711302) | 11 | 6 | 1 | 54 | 30 | |
63660 | 124910 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3234 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998760.11738 | 2116596.00833 | 37.7916968894517 | -122.4482077616 | (37.7916968894517, -122.4482077616) | 11 | 6 | 1 | 54 | 30 | |
15650 | 261311 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3368 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2019 12:00:00 AM | 3 | 3x3 | 5998140.71226 | 2116180.16914 | 37.7905196763565 | -122.450320900484 | (37.7905196763565, -122.450320900484) | 13 | 6 | 1 | 54 | 31 |
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) );