trees

109 rows where qSpecies_id = 76 sorted by PlotSize

✎ View and edit SQL

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)
136126 228387 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 2821 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 6ft   6009877.21401 2102774.76445 37.7543762340935 -122.408766995019 (37.7543762340935, -122.408766995019) 2 4 7 28859 19
22907 228378 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 1102 York St 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 7ft   6009982.64105 2102733.41799 37.7542686104241 -122.408399483453 (37.7542686104241, -122.408399483453) 2 4 7 28859 19
68128 228377 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 1102 York St 2 Sidewalk: Curb side : Yard Tree Private 2     11 Width 7ft   6009982.45484 2102743.64364 37.7542966773511 -122.408400848645 (37.7542966773511, -122.408400848645) 2 4 7 28859 19
75666 228381 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 1102 York St 6 Sidewalk: Curb side : Yard Tree Private 2     13 Width 7ft   6009986.01041 2102705.04224 37.7541908856248 -122.408385829946 (37.7541908856248, -122.408385829946) 2 4 7 28859 19
80678 228389 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 2801 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 7ft   6009950.79392 2102777.20836 37.7543870655202 -122.40851270809 (37.7543870655202, -122.40851270809) 2 4 7 28859 19
84081 228374 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 2671 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 7ft   6010033.20472 2103949.49956 37.7576105298272 -122.408310388508 (37.7576105298272, -122.408310388508) 2 4 7 28859 19
154811 228379 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 1102 York St 4 Sidewalk: Curb side : Yard Tree Private 2     13 Width 7ft   6009985.1643 2102722.04384 37.754237520846 -122.408389955153 (37.754237520846, -122.408389955153) 2 4 7 28859 19
162162 228380 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 1102 York St 5 Sidewalk: Curb side : Yard Tree Private 2     12 Width 7ft   6009984.61612 2102714.1131 37.7542157141043 -122.408391291543 (37.7542157141043, -122.408391291543) 2 4 7 28859 19
47585 219148 DPW Maintained 1 Grevillea robusta :: Silk Oak Tree 76 413 Arch St 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   5992701.46724 2089902.6388 37.7180556077517 -122.467228752923 (37.7180556077517, -122.467228752923) 9 8 6 64 24

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