trees

5 rows where DBH = 15 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

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)
20176 196977 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 209 Mississippi St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6014040.95878 2106120.30389 37.7637946944947 -122.394601850808 (37.7637946944947, -122.394601850808) 14 3 8 28856 29
121788 213854 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 494 Mangels Ave 4 Sidewalk: Property side : Yard Tree Private 2     15     5998170.4747 2095280.37565 37.7331358031646 -122.448711968308 (37.7331358031646, -122.448711968308) 9 7 4 59 40
149145 197006 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 6ft   6015876.10983 2114035.38454 37.7856296114719 -122.388807169036 (37.7856296114719, -122.388807169036) 6 2 9 28856 6
170905 196976 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 209 Mississippi St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6014043.63491 2106091.78418 37.7637165344031 -122.39459059759 (37.7637165344031, -122.39459059759) 14 3 8 28856 29
190505 85250 - 12 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1335 Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.12437 2111060.02557 37.7766442216524 -122.438849483935 (37.7766442216524, -122.438849483935) 15 5 11 29492 10

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