trees

10 rows where DBH = 5 and qLegalStatus_id = 9

✎ View and edit SQL

This data as json, CSV (advanced)

qCareAssistant ✖

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)
2898 191530 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016138.64503 2107209.62915 37.7669021444474 -122.387422526024 (37.7669021444474, -122.387422526024) 14 3 9 310 20
3180 191527 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016025.61335 2107205.30438 37.7668840087222 -122.387813186138 (37.7668840087222, -122.387813186138) 14 3 9 310 20
10235 191533 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016236.27796 2107216.03359 37.7669251365154 -122.387085273085 (37.7669251365154, -122.387085273085) 14 3 9 310 20
10795 188785 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6015978.05896 2106829.43815 37.7658493270204 -122.38795143981 (37.7658493270204, -122.38795143981) 14 3 9 310 20
11397 191531 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016181.25153 2107212.70143 37.7669129399083 -122.387275369984 (37.7669129399083, -122.387275369984) 14 3 9 310 20
13982 189273 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015966.51086 2107036.5181 37.7664172839651 -122.388005834417 (37.7664172839651, -122.388005834417) 14 3 9 310 20
17659 188786 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 499 Illinois St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6015977.25571 2106854.57611 37.7659183059205 -122.387955972402 (37.7659183059205, -122.387955972402) 14 3 9 310 20
18111 191532 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016209.16515 2107214.5091 37.766919449199 -122.38717894647 (37.766919449199, -122.38717894647) 14 3 9 310 20
143868 80518 Private 9 Pyrus spp :: Pear Tree 281 1769X Armstrong Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 5     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
166399 39628 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 199X Carmel St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM 5   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12

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