noaa_stations_map (view)

Table actions

1 row where good = 0 and latitude = "40.865"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid stationId latitude longitude refStationId stationType parentGeoGroupId seq geoGroupId geoGroupName level geoGroupType abbrev good
205 9418865 40.865 -124.148 9418767 S 1678 9   Mad River Slough, Arcata Bay 3     0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW noaa_stations_map AS 
    select rowid, stationId, lat as latitude, lon as longitude,
        refStationId, stationType, parentGeoGroupId, seq,
        geoGroupId, geoGroupName, level, geoGroupType, abbrev, good
    from noaa_stations;