trees

14 rows where DBH = 12 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)
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
18173 241284 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011470.02474 2101959.91095 37.7522279111039 -122.403201300403 (37.7522279111039, -122.403201300403) 10 4 8 28859 19
34046 31982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 232 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 12 3x3 Permit Number 35382 5994946.26899 2113981.48738 37.7842993574965 -122.461213955921 (37.7842993574965, -122.461213955921) 11 6 2 54 11
39500 32941 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1546 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 12   Permit Number 37260 6013066.21805 2105223.63069 37.7612783887065 -122.397910300117 (37.7612783887065, -122.397910300117) 10 3 8 28856 29
39857 8913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4455X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5993194.92162 2112721.50101 37.7807388335807 -122.467181309852 (37.7807388335807, -122.467181309852) 11 6 2 54 11
74281 34259 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 164 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 12   Permit Number 39598 5993996.78061 2114472.4725 37.7855927810379 -122.464534489449 (37.7855927810379, -122.464534489449) 11 6 1 54 11
81234 241340 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009746.5481 2105459.14432 37.7617396168174 -122.409408306065 (37.7617396168174, -122.409408306065) 2 4 8 28859 19
89090 34965 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1997 12:00:00 AM 12   Permit Number 38553 6014443.03671 2102833.9751 37.7547934916369 -122.392981229311 (37.7547934916369, -122.392981229311) 10 3 8 28856 29
90241 241363 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 York St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009795.29828 2105395.5079 37.7615676169818 -122.409235207249 (37.7615676169818, -122.409235207249) 2 4 8 28859 19
94223 136177 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2028 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003216.31619 2118958.46656 37.7984373333682 -122.432958210354 (37.7984373333682, -122.432958210354) 13 9 1 57 17
94675 35355 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1315 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 12   Permit Number 38817 6011731.8197 2102219.99473 37.7529566614441 -122.402314252327 (37.7529566614441, -122.402314252327) 10 3 8 28856 29
116896 124090 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 601 Funston Ave 5 Sidewalk: Property side : Yard Tree Private 2     12     5991893.39709 2111137.10441 37.7763132974782 -122.471568380763 (37.7763132974782, -122.471568380763) 11 6 2 54 11
142984 31525 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1330 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 12 4x4 Permit Number 35080 6011118.50482 2102111.69571 37.7526250409161 -122.404427600678 (37.7526250409161, -122.404427600678) 10 4 8 28859 19
187496 241285 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011473.17853 2101977.48291 37.75227633599 -122.403191629999 (37.75227633599, -122.403191629999) 10 4 8 28859 19

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