weather_station.cql

CREATE TABLE weather_station (
    id text PRIMARY KEY,  // Composite of Air Force Datsav3 station number and NCDC WBAN number
    name text,            // Name of reporting station
    country_code text,    // 2 letter ISO Country ID
    state_code text,      // 2 letter state code for US stations
    call_sign text,       // International station call sign
    lat double,            // Latitude in decimal degrees
    long double,           // Longitude in decimal degrees
    elevation double       // Elevation in meters
);