trees

13 rows where PlotSize = "Width 5ft" and qLegalStatus_id = 9 sorted by qLegalStatus_id

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 5ft · 13 ✖
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
5864 189275 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015964.59668 2107087.77889 37.7665579289401 -122.388016032733 (37.7665579289401, -122.388016032733) 14 3 9 310 20
8331 191528 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2017 12:00:00 AM 3 Width 5ft   6016052.47786 2107208.19392 37.76689343092 -122.387720466935 (37.76689343092, -122.387720466935) 14 3 9 310 20
9264 188788 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015967.32751 2107012.0323 37.7663500965054 -122.388001300914 (37.7663500965054, -122.388001300914) 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
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
14181 188787 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015968.04519 2106982.6549 37.7662694722874 -122.387996768362 (37.7662694722874, -122.387996768362) 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
18169 189274 Private 9 Tristaniopsis laurina :: Swamp Myrtle 1 409 Illinois St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015965.43281 2107064.27168 37.7664934295578 -122.388011500129 (37.7664934295578, -122.388011500129) 14 3 9 310 20
18958 191526 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015996.43331 2107204.26168 37.7668795291963 -122.387914043316 (37.7668795291963, -122.387914043316) 14 3 9 310 20
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

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