trees

17 rows where SiteOrder = 4 and qLegalStatus_id = 9

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: SiteOrder

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)
18444 259521 Private 9 :: 45 190 Parker Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
18909 262153 Private 9 Lagunaria patersonii :: Primrose Tree 6 1295 47th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
19392 191529 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6016082.02245 2107209.57323 37.7668988547309 -122.387618372283 (37.7668988547309, -122.387618372283) 14 3 9 310 20
41193 16883 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 300X Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3X3   6005538.3415996 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733) 7 9 11 28852 10
91676 104449 Private 9 Acacia melanoxylon :: Blackwood Acacia 70 2490X Folsom St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
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
154962 22381 Private 9 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
156160 108314 Private 9 Corymbia ficifolia :: Red Flowering Gum 28 2501X DIAMOND ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002141 2097265 37.7388113707969 -122.435126715418 (37.7388113707969, -122.435126715418) 2 7 5 63 7
165107 104627 Private 9 Platanus x hispanica :: Sycamore: London Plane 27 49 BRODERICK ST 4 Sidewalk: Curb side : Cutout Tree Private 2     17 5X5   6001306 2108720 37.7702165872443 -122.438834395611 (37.7702165872443, -122.438834395611) 15 5 11 29492 9

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