trees

12 rows where PlotSize = "Width 3ft" and qLegalStatus_id = 5 sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 3ft · 12 ✖
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)
194318 264973 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 3135 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2020 12:00:00 AM 3 Width 3ft Permit Number 781901 6001403 2119193 37.7989782820217 -122.43924964791 (37.7989782820217, -122.43924964791) 13 9 1 57 17
3076 228280 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3160 228282 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3306 228286 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
6383 228279 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
7100 228281 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
8602 228283 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 6 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
10725 228284 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 7 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
10740 228285 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 8 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
17710 169495 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 150 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 Width 3ft Permit Number 770415 6004561.3283 2097566.6275 37.7397767110236 -122.426779823841 (37.7397767110236, -122.426779823841) 2 7 5 63 7
18916 152848 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 160 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2019 12:00:00 AM 3 Width 3ft Permit Number 781252 6006654.74312 2105190.58967 37.7608285109489 -122.420082580673 (37.7608285109489, -122.420082580673) 2 4 7 28859 19
9877 126318 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 752 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2020 12:00:00 AM 3 Width 3ft Permit Number 778828 6010086.22048 2116329.20443 37.791605285407 -122.409000507567 (37.791605285407, -122.409000507567) 5 1 10 28857 21

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