trees

7 rows where Neighborhoods (old) = 6 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

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)
4814 72022 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 550 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6010599.26481 2116134.30998 37.7910988780658 -122.407211626534 (37.7910988780658, -122.407211626534) 5 1 10 28857 6
58857 197005 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6015945.83282 2113971.21012 37.7854572671771 -122.388561464349 (37.7854572671771, -122.388561464349) 6 2 9 28856 6
74677 197008 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 15 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015819.96471 2114109.17282 37.7858291053701 -122.389006570307 (37.7858291053701, -122.389006570307) 6 2 9 28856 6
87499 197007 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 14 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 6ft   6015822.85417 2114091.9182 37.7857818882589 -122.388995368366 (37.7857818882589, -122.388995368366) 6 2 9 28856 6
135225 197004 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6015943.64363 2113959.00175 37.7854236244348 -122.388568185881 (37.7854236244348, -122.388568185881) 6 2 9 28856 6
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
184093 197003 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6015964.6605 2113962.87673 37.7854354289412 -122.38849574371 (37.7854354289412, -122.38849574371) 6 2 9 28856 6

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