10 rows where Zip Codes = 63 and qSpecies_id = 202

View and edit SQL

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)
15125 221968 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 155 Farnum St 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   6002473.47377 2097229.09787 37.7387316655458 -122.433974612434 (37.7387316655458, -122.433974612434) 2 7 5 63 7
27858 203619 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 2ft   6000138.38202 2095835.33472 37.7347719253748 -122.441948223841 (37.7347719253748, -122.441948223841) 9 7 5 63 40
41523 221967 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 448 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003863.12438 2096025.37276 37.7355052757557 -122.429084054179 (37.7355052757557, -122.429084054179) 2 7 5 63 7
62425 221952 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1636 Diamond St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6002001.1942 2099218.33488 37.7441668325278 -122.435749813916 (37.7441668325278, -122.435749813916) 2 7 5 63 22
71295 204746 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 2ft   6000138.08456 2095837.9726 37.7347791514248 -122.441949441533 (37.7347791514248, -122.441949441533) 9 7 5 63 40
81720 204747 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 624 Congo St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   6000136.90983 2095840.80392 37.7347868586248 -122.441953706121 (37.7347868586248, -122.441953706121) 9 7 5 63 40
129751 169719 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 163 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 Width 3ft Permit Number 779875 6004059.21605 2097368.19833 37.7392034678777 -122.428501775552 (37.7392034678777, -122.428501775552) 2 7 5 63 7
143401 221955 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 271 Bemis St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6002975.66032 2096224.16146 37.7360008273625 -122.432166542558 (37.7360008273625, -122.432166542558) 2 7 5 63 7
179588 221951 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 1636 Diamond St 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6002000.14888 2099232.59033 37.7442059152698 -122.435754448124 (37.7442059152698, -122.435754448124) 2 7 5 63 22
186533 221954 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 10 Mateo St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003651.78928 2096634.42206 37.7371656211922 -122.429858148341 (37.7371656211922, -122.429858148341) 2 7 5 63 7

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