Weather Measurement

Entity

Name: Weather Measurement

Weather Observation at a specific atmospheric property.

Details

Table: Properties

Name General Data Type Oracle Data Type Relational Column Required? Primary Key? Validations Related Graph Object
measurement id string VARCHAR2 MEASUREMENT_ID Yes Yes Must match regex pattern: ^\S{1,}$ weather:WeatherMeasurement
latitude double NUMBER LATITUDE Yes   Must match regex pattern: ^[+|-]?([1-8]?[0-9]|[1-9]0)\.{0,1}\d{1,10} geo:GeoPoint
longitude double NUMBER LONGITUDE Yes   Must match regex pattern: ^[+|-]?([1]?[0-7][0-9]|[1]?[1-8][0]|[1-9]?[0-9])\.{0,1}\d{0,10} geo:GeoPoint
altitude double NUMBER ALTITUDE       geo:GeoPoint
end timestamp dateTimeStamp TIMESTAMP END_TIMESTAMP Yes     weather:WeatherMeasurement
start timestamp dateTimeStamp TIMESTAMP START_TIMESTAMP Yes     weather:WeatherMeasurement
interval type string VARCHAR2 INTERVAL_TYPE Yes   Must match values in enumerated list from graph weather:IntervalType
accuracy category string VARCHAR2 ACCURACY_CATEGORY Yes   Must match values in enumerated list from graph weather:AccuracyCategory
observation category string VARCHAR2 OBSERVATION_CATEGORY     Must match values in enumerated list from graph weather:ObservationCategory
model type string VARCHAR2 MODEL_TYPE Yes   Must match values in enumerated list from graph weather:WeatherModelType
aspect string VARCHAR2 ASPECT Yes   Must match values in enumerated list from graph weather:Aspect
unit of measure string VARCHAR2 UNIT_OF_MEASURE Yes   Must match values in enumerated list from graph uom:UnitOfMeasure
measurement value double NUMBER MEASUREMENT_VALUE Yes     weather:WeatherMeasurement