trees

9 rows where DBH = 14 and qSpecies_id = 86

✎ 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)
42725 215295 DPW Maintained 1 Taxus baccata :: Irish Yew 86 25 Burnside Ave 5 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6001248.26665 2095899.59415 37.7350115506281 -122.43811558039 (37.7350115506281, -122.43811558039) 2 7 5 63 7
49026 179810 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1367 Cayuga Ave 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 0ft   5999324.75892 2089823.48937 37.7182183958423 -122.444329297662 (37.7182183958423, -122.444329297662) 9 7 6 28861 25
50876 39476 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1425 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM 14   Permit Number 40937 6002367.56738 2121559.91338 37.8055320445375 -122.436081393069 (37.8055320445375, -122.436081393069) 13 9 1 57 17
75958 136705 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1120 Greenwich St 3 Front Yard : Yard Tree Private 2     14     6007496.45618 2119889.74411 37.8012362277192 -122.418213633845 (37.8012362277192, -122.418213633845) 5 1 1 28858 32
92970 215331 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2095 09th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5993556.00602 2101376.01116 37.7496079377635 -122.465107874536 (37.7496079377635, -122.465107874536) 1 8 4 29491 40
93918 136660 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1599 North Point St 17 Side Yard : Yard Tree Private 2     14 Width 7ft   6003228.45993 2120985.21121 37.8040029344509 -122.433061071222 (37.8040029344509, -122.433061071222) 13 9 1 57 17
105158 215289 DPW Maintained 1 Taxus baccata :: Irish Yew 86 496 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     14 Width 6ft   5993555.20621 2101912.20382 37.7510801396391 -122.465149580605 (37.7510801396391, -122.465149580605) 1 8 4 29491 12
142951 197900 DPW Maintained 1 Taxus baccata :: Irish Yew 86 578 San Bruno Ave 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   6010959.66368 2105665.96946 37.7623754078088 -122.405227168994 (37.7623754078088, -122.405227168994) 8 3 8 28856 29
173768 136712 DPW Maintained 1 Taxus baccata :: Irish Yew 86 84 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     14     6008291.17542 2119130.0368 37.7991949618221 -122.415409734769 (37.7991949618221, -122.415409734769) 5 1 10 308 32

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