trees
11 rows where Supervisor Districts = 11 and qSpecies_id = 2 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189245 | 52671 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1234@ LINCOLN 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53911 | 5993637.83557736 | 2107090.14039952 | 37.7653021756316 | -122.465239907967 | (37.7653021756316, -122.465239907967) | 11 | 8 | 11 | 56 | 12 | |
42966 | 10342 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 935 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 4x4 | 6001663.93706 | 2109024.15924 | 37.7710720905099 | -122.437618081823 | (37.7710720905099, -122.437618081823) | 15 | 5 | 11 | 29492 | 9 | ||
144860 | 10236 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 33 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2002 12:00:00 AM | 8 | 4X4 | 6005944.57875 | 2109639.18298 | 37.7730032531225 | -122.422854896447 | (37.7730032531225, -122.422854896447) | 7 | 9 | 11 | 28852 | 10 | ||
30278 | 10232 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2002 12:00:00 AM | 8 | 6005984.55063 | 2109644.68395 | 37.7730206127534 | -122.422717019597 | (37.7730206127534, -122.422717019597) | 7 | 9 | 11 | 28852 | 10 | |||
180205 | 230377 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 2 | : | Tree | Private 2 | 6 | Width 4ft | 6006012.13878 | 2109648.33208 | 37.7730321861234 | -122.422621847921 | (37.7730321861234, -122.422621847921) | 7 | 9 | 11 | 28852 | 10 | |||
175044 | 230378 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6006027.69558 | 2109650.1201 | 37.7730379732539 | -122.422568162015 | (37.7730379732539, -122.422568162015) | 7 | 9 | 11 | 28852 | 10 | |||
41844 | 108873 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 137 Cole St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773403 | 5997771.92218 | 2110131.23662 | 37.7738897825389 | -122.451160475717 | (37.7738897825389, -122.451160475717) | 15 | 5 | 11 | 29492 | 16 | |
70138 | 88771 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 461 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775199 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | |
159858 | 17177 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058392 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | 13 | 9 | 11 | 28858 | 27 | ||
21886 | 12447 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1989X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2004 12:00:00 AM | 4 | 3x3 | 6004432.6263962 | 2115327.1853144 | 37.7885356724235 | -122.428490433403 | (37.7885356724235, -122.428490433403) | 13 | 9 | 11 | 28858 | 27 | ||
37211 | 87647 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1989X PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2008 12:00:00 AM | 3 | 3x3 | 6004432 | 2115332 | 37.7885488568913 | -122.428492943957 | (37.7885488568913, -122.428492943957) | 13 | 9 | 11 | 28858 | 27 |
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) );