trees

10 rows where SiteOrder = 2, Zip Codes = 56 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
15715 70376 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1434 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     5982801.126 2105356.1278 37.7599101850833 -122.502592561024 (37.7599101850833, -122.502592561024) 1 8 3 56 35
41585 37085 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1487 45th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM 13   Permit Number 39685 5982149.7032 2104986.8677 37.7588580004754 -122.504818115198 (37.7588580004754, -122.504818115198) 1 8 3 56 35
77208 37072 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1426 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 14   Permit Number 39847 5982799.9219 2105403.4894 37.7600401558558 -122.502600230953 (37.7600401558558, -122.502600230953) 1 8 3 56 35
88120 38113 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1296 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM 9   Permit Number 40278 5987108.7979 2106493.9222 37.7632864483052 -122.487778208637 (37.7632864483052, -122.487778208637) 1 8 3 56 35
101240 44243 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4005 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2001 12:00:00 AM 12   Permit Number 43678 5983313.0175 2106265.8208 37.7624380119611 -122.500889481832 (37.7624380119611, -122.500889481832) 1 8 3 56 35
109884 183265 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1249 46th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   5981784.0294 2106586.8909 37.7632296873576 -122.506201404659 (37.7632296873576, -122.506201404659) 1 8 3 56 35
179876 181650 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1265 32nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   5986125.2828 2106621.5286 37.7635794036098 -122.49118920801 (37.7635794036098, -122.49118920801) 1 8 3 56 35
16596 203511 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1359 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992377.24702 2106218.29367 37.7628355396396 -122.469536476251 (37.7628355396396, -122.469536476251) 1 8 11 56 12
80302 203507 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 920 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   5991972.62617 2105259.84917 37.7601805116332 -122.470866084321 (37.7601805116332, -122.470866084321) 1 8 4 56 12
43499 203561 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 509 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5992707.23353 2104539.55392 37.7582452263566 -122.468273046583 (37.7582452263566, -122.468273046583) 1 8 4 56 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)
);