6 rows where qSpecies_id = 313 sorted by XCoord

View and edit SQL

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)
165746 97397 DPW Maintained 1 Butia capitata :: Pindo Palm 313 1203X Sunset Blvd 17 Median : Yard Tree DPW 1           5989104.6 2108557.5 37.7690686805765 -122.481026569546 (37.7690686805765, -122.481026569546) 11 6 2 55 8
114727 2784 DPW Maintained 1 Butia capitata :: Pindo Palm 313 430 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/22/2011 12:00:00 AM 3 3x3   5994258.3425 2110780.94497 37.7754719143848 -122.463361589743 (37.7754719143848, -122.463361589743) 11 6 2 54 11
182749 220767 DPW Maintained 1 Butia capitata :: Pindo Palm 313 431 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5998500.20863 2106686.18201 37.764472209537 -122.448393083084 (37.764472209537, -122.448393083084) 15 5 11 29492 9
7435 239668 Private 9 Butia capitata :: Pindo Palm 313 180 Dolores St 3 Sidewalk: Property side : Pot Landscaping Private 2     23 Width 4ft   6004776.3298 2107329.36682 37.7665950691341 -122.426731495165 (37.7665950691341, -122.426731495165) 8 4 5 28862 3
152565 220766 DPW Maintained 1 Butia capitata :: Pindo Palm 313 450 Florida St 7 Sidewalk: Property side : Yard Tree Private 2     18     6009178.84988 2106288.47151 37.7639849352727 -122.411430346242 (37.7639849352727, -122.411430346242) 8 4 7 28859 19
145417 116754 DPW Maintained 1 Butia capitata :: Pindo Palm 313 601x Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6012731.525 2104592.99284 37.7595281506183 -122.399023604158 (37.7595281506183, -122.399023604158) 10 3 8 28856 29

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);