trees

9 rows where qSpecies_id = 487

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: SiteOrder, DBH, PermitNotes, YCoord

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)
59343 102927 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
65624 102929 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
81403 93416 DPW Maintained 1 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 1750X Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2015 03:07:00 PM 3 3x3   5987732.225 2098992.9724 37.7427272048793 -122.485071636504 (37.7427272048793, -122.485071636504) 1 8 3 29491 35
93289 102837 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 908 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2013 12:00:00 AM   3x3 Permit Number 770090 5999213 2107044 37.7654954148837 -122.445953479715 (37.7654954148837, -122.445953479715) 15 5 5 29492 9
95710 102928 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
117788 102930 Permitted Site 7 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 50X Frank Norris St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2013 12:00:00 AM   2.5x4 Permit Number 769193 6007010.8 2115561.5 37.7893246020524 -122.419586960708 (37.7893246020524, -122.419586960708) 13 9 10 28858 21
122086 93410 DPW Maintained 1 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 1500 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2015 03:13:00 PM 3 3x3   5988524.1321 2099019.3693 37.7428457803472 -122.482335414501 (37.7428457803472, -122.482335414501) 1 8 3 29491 35
122344 122333 DPW Maintained 1 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 950X Anza St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996124 2112291 37.7797254357482 -122.45701712634 (37.7797254357482, -122.45701712634) 11 6 2 54 16
149562 241294 DPW Maintained 1 Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 487 1342 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2017 12:00:00 AM 3 Width 3ft Permit Number 779705 6011123.66511 2102080.8508 37.7525406359468 -122.404407584468 (37.7525406359468, -122.404407584468) 10 4 8 28859 19

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