Cimis
Explore the interactive ERD
Table & Field Reference
station_zipcode
| Column | Type | Keys |
|---|
id | Long | PKFK |
station_id | Long | PKFK |
station
| Column | Type | Keys |
|---|
id | Long | PK |
city | String | |
connect_date | Unknown | |
county | String | |
disconnect_date | Unknown | |
elevation | Long | |
ground_cover | String | |
hms_latitude | String | |
hms_longitude | String | |
is_active | Boolean | |
is_eto_station | Boolean | |
name | String | |
regional_office | String | |
siting_desc | String | |
spatial_zipcode
| Column | Type | Keys |
|---|
id | Long | PK |
connect_date | Unknown | |
disconnect_date | Unknown | |
is_active | Boolean | |
data_item_record
| Column | Type | Keys |
|---|
_fivetran_id | String | PK |
station_id | Unknown | FK |
station_zipcode_id | Unknown | FK |
date | Unknown | |
day_air_tmp_avg_qc | Unknown | |
day_air_tmp_avg_unit | Unknown | |
day_air_tmp_avg_value | Unknown | |
day_air_tmp_max_qc | Unknown | |
day_air_tmp_max_unit | Unknown | |
day_air_tmp_max_value | Unknown | |
day_air_tmp_min_qc | Unknown | |
day_air_tmp_min_unit | Unknown | |
day_air_tmp_min_value | Unknown | |
day_asce_eto_qc | Unknown | |
day_asce_eto_unit | Unknown | |
day_asce_eto_value | Unknown | |
day_dew_pnt_qc | Unknown | |
day_dew_pnt_unit | Unknown | |
day_dew_pnt_value | Unknown | |
day_precip_qc | Unknown | |
day_precip_unit | Unknown | |
day_precip_value | Unknown | |
day_rel_hum_avg_qc | Unknown | |
day_rel_hum_avg_unit | Unknown | |
day_rel_hum_avg_value | Unknown | |
day_rel_hum_max_qc | Unknown | |
day_rel_hum_max_unit | Unknown | |
day_rel_hum_max_value | Unknown | |
day_rel_hum_min_qc | Unknown | |
day_rel_hum_min_unit | Unknown | |
day_rel_hum_min_value | Unknown | |
day_soil_tmp_avg_qc | Unknown | |
day_soil_tmp_avg_unit | Unknown | |
day_soil_tmp_avg_value | Unknown | |
day_sol_rad_avg_qc | Unknown | |
day_sol_rad_avg_unit | Unknown | |
day_sol_rad_avg_value | Unknown | |
day_vap_pres_avg_qc | Unknown | |
day_vap_pres_avg_unit | Unknown | |
day_vap_pres_avg_value | Unknown | |
day_wind_run_qc | Unknown | |
day_wind_run_unit | Unknown | |
day_wind_run_value | Unknown | |
day_wind_spd_avg_qc | Unknown | |
day_wind_spd_avg_unit | Unknown | |
day_wind_spd_avg_value | Unknown | |
julian | Unknown | |
scope | Unknown | |
standard | Unknown | |
data_item
| Column | Type | Keys |
|---|
_fivetran_id | String | PK |
station_id | Long | FK |
name | String | |
owner | Unknown | |
type | Unknown | |
