About this Dataset

AMS Pasadena Precipitation Data

The data in this data environment was collected from the Pasadena, California testbed, namely I-210, SR 134, and nearby arterials. The source of these data is from the National Center for Environmental Information – National Oceanic and Atmospheric Administration. Precipitation information from this data source is used in the cluster analysis.
Organization: Department of Transportation
Last updated: 2020-11-12T12:57:46.471662
Tags: ams-pasadena-testbed, analysis-modeling-and-simulation-ams-testbed-development, arterial, california, cluster-analysis, freeway, i-210, intelligent-transportation-systems-its, its-joint-program-office-jpo, pasadena, precipitation-data, sr-134

Tables

Table 1

@usgov.dot_gov_ams_pasadena_precipitation_data.table_1

9.49 kB
365 rows
8 columns

CREATE TABLE table_1 (
  "preliminary" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "temperature_f_24_hrs_ending_at_observation_time_max" BIGINT  -- Temperature (F) – 24 Hrs. Ending At Observation Time - Max,
  "temperature_f_24_hrs_ending_at_observation_time_min" BIGINT  -- Temperature (F) – 24 Hrs. Ending At Observation Time - Min,
  "temperature_f_at_observation" BIGINT  -- Temperature (F) – At Observation,
  "precipitation_24_hours_amount_ending_at_observation_ti_ba0e4b73" DOUBLE  -- Precipitation – 24 Hours Amount Ending At Observation Time – Rain, Melted Snow, Etc. (in)
);