trees

12 rows where DBH = 13 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: 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)
24305 31508 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2419 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 13   Permit Number 35068 6011299.52328 2102275.53688 37.7530850270762 -122.403813131691 (37.7530850270762, -122.403813131691) 10 4 8 28859 19
57071 31514 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2537 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 13   Permit Number 35072 6010934.2499 2102257.13766 37.7530140939364 -122.405075029795 (37.7530140939364, -122.405075029795) 10 4 8 28859 19
57267 241390 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 381 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004068.12547 2098354.29911 37.7419115792635 -122.428541241382 (37.7419115792635, -122.428541241382) 2 7 5 63 7
60153 34963 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1997 12:00:00 AM 13   Permit Number 38553 6014444.86373 2102867.97159 37.7548869402077 -122.392977289379 (37.7548869402077, -122.392977289379) 10 3 8 28856 29
76553 123210 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993133.98431 2112655.94122 37.7805553064396 -122.467387351051 (37.7805553064396, -122.467387351051) 11 6 2 54 11
82690 241362 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009794.30933 2105409.48411 37.7616059370772 -122.409239613928 (37.7616059370772, -122.409239613928) 2 4 8 28859 19
86392 241360 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 600 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009793.68997 2105435.76266 37.7616780573116 -122.409243610512 (37.7616780573116, -122.409243610512) 2 4 8 28859 19
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
116652 123211 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993134.492 2112639.50466 37.7805102054167 -122.467384399185 (37.7805102054167, -122.467384399185) 11 6 2 54 11
153220 241354 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 10 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 6ft   6009719.71418 2105928.26145 37.7630262022081 -122.409534224627 (37.7630262022081, -122.409534224627) 8 4 8 28859 19
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
190579 241272 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 67 Webster St 1 : Tree Private 2     13 Width 4ft   6004275.92505 2108860.93687 37.7707720854826 -122.428571490982 (37.7707720854826, -122.428571490982) 7 9 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)
);