12 rows where Zip Codes = 57 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)
15374 125563 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 4 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5999907.90369 2121547.81116 37.8053587703434 -122.44459250045 (37.8053587703434, -122.44459250045) 13 9 1 57 17
15744 125562 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5999907.00069 2121550.96509 37.8053673786573 -122.444595852214 (37.8053673786573, -122.444595852214) 13 9 1 57 17
50429 99288 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 1 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998881.62913 2121328.006 37.8046966310161 -122.448128205765 (37.8046966310161, -122.448128205765) 13 9 1 57 17
53582 125566 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2809 Buchanan St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   6003481.18787 2118079.55095 37.7960390779962 -122.431978879228 (37.7960390779962, -122.431978879228) 13 9 1 57 17
54080 125567 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2809 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6003482.8439 2118067.55033 37.7960062212666 -122.431972291689 (37.7960062212666, -122.431972291689) 13 9 1 57 17
69401 125564 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 165 Marina Blvd 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 7ft   6002712.8181 2121563.83713 37.805562426341 -122.434886887435 (37.805562426341, -122.434886887435) 13 9 1 57 17
73720 125559 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 20 Mallorca Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001981.60949 2119919.32974 37.8010055012508 -122.437299505878 (37.8010055012508, -122.437299505878) 13 9 1 57 17
89333 101004 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2801X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2012 12:00:00 AM   3x3 Permit Number 769246 6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
115799 125561 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 627 Marina Blvd 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   5999906.36456 2121555.3188 37.8053792964712 -122.444598366729 (37.8053792964712, -122.444598366729) 13 9 1 57 17
148377 125560 DPW Maintained 1 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 20 Mallorca Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001979.15463 2119935.63772 37.8010501391173 -122.437309169106 (37.8010501391173, -122.437309169106) 13 9 1 57 17
173627 101003 Permitted Site 7 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 2801X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2012 12:00:00 AM   3x3 Permit Number 769246 6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
176820 99289 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 2 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998887.79124 2121333.18312 37.8047111982366 -122.448107254257 (37.8047111982366, -122.448107254257) 13 9 1 57 17

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