trees

10 rows where qSpecies_id = 454

✎ 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)
41413 92089 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 440 Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2009 12:00:00 AM   3x3 Permit Number 52198 6011453 2106318 37.764193305924 -122.403566769567 (37.764193305924, -122.403566769567) 8 3 8 28856 29
54355 92088 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 440 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2009 12:00:00 AM   3x3 Permit Number 52198 6011453 2106318 37.764193305924 -122.403566769567 (37.764193305924, -122.403566769567) 8 3 8 28856 29
58865 112524 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 2435 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3 3x3 Permit Number 778367 6009761.3 2103168.6 37.7554511252743 -122.409195646414 (37.7554511252743, -122.409195646414) 2 4 7 28859 19
63167 40017 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 25X Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM   3x3 Permit Number 50722 6014441 2094547 37.7320390734938 -122.392408675195 (37.7320390734938, -122.392408675195) 10 3 8 58 1
70994 88763 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 2131 12th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/21/2008 12:00:00 AM   3x3 Permit Number 51685 5992543.2 2100941 37.7483550545978 -122.468578514228 (37.7483550545978, -122.468578514228) 1 8 4 29491 40
74972 106230 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 4016 20th St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 772780 6003554 2104234.5 37.7580281248998 -122.430738442051 (37.7580281248998, -122.430738442051) 2 4 5 28862 3
85006 88654 DPW Maintained 1 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 94 Danton St   Sidewalk: Property side : Cutout Landscaping Private 2   08/05/2008 12:00:00 AM     Permit Number 51634 6002844 2094598 37.7315282931893 -122.432505629551 (37.7315282931893, -122.432505629551) 9 7 5 28861 25
140549 92668 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 791 San Bruno Ave 6 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
160786 92667 Permitted Site 7 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 791 San Bruno Ave 5 Sidewalk: Property side : Cutout Tree Private 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
174827 88656 DPW Maintained 1 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 94 Danton St   Sidewalk: Property side : Cutout Landscaping Private 2   08/05/2008 12:00:00 AM     Permit Number 51634 6002844 2094598 37.7315282931893 -122.432505629551 (37.7315282931893, -122.432505629551) 9 7 5 28861 25

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