POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
Defines geometry associated with geophysical acquisition (e.g., seismic, gravity or magnetics). This may represent a composition of lines (survey, line composed of segments) or a line composed of points (line). There is no predefined intent on composition except for the identity of the components. For example, a survey can be composed of multiple lines if that is the most accurate description of the acquisition, or a line can be uniquely identified without association with a survey. A geometry set (e.g., a survey) can be may be composed of both seismic and potential field geometries.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- earth_feature.identifier
The identifying name for the earth feature.
- instance_create_date (O: TIMESTAMP)
- e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
- last_updated (O: TIMESTAMP)
- e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
- entity_type_nm (M: CHAR VARYING(30))
- Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: potential_field_geometry_set, seismic_geometry_set.
- acquisition_index_sl (O: CHAR VARYING(16))
- seismic_geometry_set.acquisition_index
Defines "acquisition line index" and/or "acquisition point index" values at each station associated with this seismic geometry set. The grid used must be the same as is defined by seismic station uid. The values imply a relative ordering of the stations within the acquisition survey (i.e., 1 is next to 2, 2 is next to 3, etc.).
- acquisition_line_index (O: FLOAT(6))
- seismic_geometry_set.acquisition_line_index
Asserts that all seismic station uids have the same line index associated with them. This is the index which varies in the "crossline" direction. If this attribute is specified, then acquisition index should not specify a value for "acquisition line index".
- channel_connection_sl (O: CHAR VARYING(16))
- seismic_geometry_set.channel_connection
Defines a "receiver uid" value at each node of the 2D grid defined by field trace grid. This defines which receiver facility was utilized to record each field trace. This asserts fixed facility recording (e.g., land). A pair of values including "seismic geometry set uid" may be defined when "receiver uid" values from many seismic geometry sets are specified.
- channel_facility_sl (O: CHAR VARYING(16))
- seismic_geometry_set.channel_facility
Defines the sensor (i.e., receiver, uphole sensor, etc.) connected to each channel by specifying a "seismic facility uid" value at each node of the grid defined by channel uid. This asserts that the channel to receiver association was not transient (e.g., marine). The grid used must match the grid defined by channel uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.
- channel_number_sl (O: CHAR VARYING(16))
- seismic_geometry_set.channel_number
The channel number associated with each channel. The grid used must match the grid used by channel uid.
- channel_seismograph_sl (O: CHAR VARYING(16))
- seismic_geometry_set.channel_seismograph
Defines the seismograph associated with each channel by specifying a "seismic facility uid" value at each node of the grid defined by channel uid. The grid used must match the grid used by channel uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- instance_creator (O: CHAR VARYING(80))
- e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
- last_updated_by (O: CHAR VARYING(80))
- e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
- line_index (O: FLOAT(6))
- potential_field_geometry_set.line_index
Asserts that all measurement uids or station uids have the same line index associated with them within this geometry set. This is the index which varies in the "crossline" direction. If this attribute is specified, then measurement index or station index should not specify a value for "acquisition line index".
- measurement_index_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.measurement_index
Defines "acquisition line index" and/or "acquisition point index" values at each node defined by measurement uid. The values imply a relative spatial ordering of the measurements within the acquisition survey (i.e., 1 is next to 2, 2 is next to 3, etc.).
- measurement_name_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.measurement_name
The name associated with measurement. The grid used must match the grid used by measurement uid. The names should be unique within the array.
- measurement_seismic_station_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.measurement_seismic_station
Defines the "seismic station uid" value at each node of the grid defined by measurement uid. This asserts the "nearest" seismic station to each node. A pair of values including "seismic geometry set uid" may be defined when "seismic station uid" values from many seismic geometry sets are specified.
- measurement_sensor_facility_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.measurement_sensor_facility
Captures the sensor facility used for each measurement by specifying a "user unique identifier" value at each node of the grid defined by attribute measurement uid. The grid used must match the grid defined by attribute measurement uid. Each "user unique identifier" value must match the value of attribute facility uid in one of the sensor facilities referenced in attribute utilized facility. This enables the use of different or multiple sensors within the acquisition of a geometry set.
- measurement_station_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.measurement_station
Defines a "potential field station uid" value at each measurement. The grid used must match the grid used by attribute measurement uid. This asserts the potential field station at which each measurement occurred. If this attribute is populated, then each measurement must occur at one and only one station but each station may have zero, one or many measurements occur there.
- measurement_time_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.measurement_time
Defines the time of each measurement relative to measurement time origin. The grid used must match the grid defined by measurement uid.
- measurement_time_origin (O: TIMESTAMP)
measurement_time_origin_cd (O: CHAR(1))
measurement_time_origin_yr (O: FLOAT)
measurement_time_origin_yp (O: INTEGER)
measurement_time_origin_dy (O: INTEGER)
measurement_time_origin_hr (O: INTEGER)
measurement_time_origin_mt (O: INTEGER)
measurement_time_origin_st (O: FLOAT)
measurement_time_origin_of (O: FLOAT)
- potential_field_geometry_set.measurement_time_origin
The time reference for times in measurement time.
- receiver_facility_sl (O: CHAR VARYING(16))
- seismic_geometry_set.receiver_facility
Defines the receiver facility representing each receiver by specifying a "seismic facility uid" at each node of the grid defined by receiver uid. This asserts that fixed cable multi-component recording occurred. For fixed cable single component recording the facility can be defined by the relationship to typical seismic receiver. The grid used must match the grid defined by receiver uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.
- receiver_station_sl (O: CHAR VARYING(16))
- seismic_geometry_set.receiver_station
Defines the "seismic station uid" value at each node of the grid defined by receiver uid. This defines the location of each receiver facility. A pair of values including "seismic geometry set uid" may be defined when "seismic station uid" values from many seismic geometry sets are specified.
- seismic_geometry_set_uid (O: INTEGER)
- seismic_geometry_set.seismic_geometry_set_uid
A user assigned unique identifier of the geometry set. There is no semantic meaning implied by the value other than uniqueness within a user controllable scope of the data store. This value can be used within "arrays" of information as an implied relationship to this geometry set. This value must be unique within the scope of the data which points at it. The scope is generally within a survey but when geometry sets are derived from other geometry sets, the data in the new geometry set may point to geometry in the original geometry sets. It is not a problem for geometry sets within different surveys to have non-unique uid values unless information in those surveys will be combined. This of course assumes that applications faithfully populate the "usage" relationships which allow the scope to be explicitly determined.
- source (O: CHAR VARYING(80))
- e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
- source_content (O: CHAR VARYING(80))
- earth_feature.source_content
This is the original source of the data. This is the person, company or application that defined or specified the data (content) for this instance and is considered to be responslble for it. For example, POSC, EPSG, API, ISO, etc. This may be the same as or different from the provider of the instance (e.g., POSC).
- source_event_name_sl (O: CHAR VARYING(16))
- seismic_geometry_set.source_event_name
The name associated with each source event. The names should be unique within the array. The grid used must match the grid used by source event uid.
- source_event_order_sl (O: CHAR VARYING(16))
- seismic_geometry_set.source_event_order
Specifies a unique ordinal number at each node of the grid defined by source event uid. This defines the relative temporal order of the source events (i.e., 2 occurred before 3, 3 occurred before 4, etc). This may be derived from source start time information. The ordinal numbers should be unique within the context of the array. Any similarity to source event uid values should be considered coincidental.
- source_facility_sl (O: CHAR VARYING(16))
- seismic_geometry_set.source_facility
Defines the source facility activated by each source event by specifying a "seismic facility uid" value at each node of the grid defined by source event uid. The grid used must match the grid used by source event uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.
- source_reference (O: CHAR VARYING(2000))
- earth_feature.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
- source_station_sl (O: CHAR VARYING(16))
- seismic_geometry_set.source_station
Defines a "seismic station uid" value at each source event. The grid used must match the grid used by source event uid. A pair of values including "seismic geometry set uid" may be defined when "seismic station uid" values from many seismic geometry sets are specified.
- station_index_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.station_index
Defines "acquisition line index" and/or "acquisition point index" values at each node defined by attribute station uid. The values imply a relative spatial ordering of the stations within the acquisition survey (i.e., 1 is next to 2, 2 is next to 3, etc.).
- station_name_sl (O: CHAR VARYING(16))
- potential_field_geometry_set.station_name
The name associated with each potential field station. The grid used must match the grid used by station uid. The names should be unique within the array.
seismic_geometry_set.station_name
The name associated with each seismic station. The grid used must match the grid used by seismic station uid. The names should be unique within the array.
- status (O: CHAR VARYING(11))
- earth_feature.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
- surface_only (O: CHAR(1))
- earth_feature.surface_only
When set to TRUE, this earth_feature represents only the surface of the Earth and does not extend into the subsurface.
- channel_definition_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.channel_definition
The instance which defines the channel uid values.
Defines a foreign key to table geophysical_geometry_set.
- channel_uid_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.channel_uid
Defines a 1D grid which specifies a "channel uid" value at each node. The same grid can be used by many other attributes which assign information to a channel. There is no semantic meaning implied by the "uid" value.
Defines a foreign key to table grid_1d.
- field_trace_grid_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.field_trace_grid
Defines a 2D grid composed of the grids defined by channel uid and source event uid. This grid represents recorded field traces.
Defines a foreign key to table grid_defined_grid.
- kind_s (FSK, O: CHAR VARYING(19))
- earth_feature.kind
The class which asserts the fundamental nature of the feature.
Defines a foreign key to table earth_feature_class.
- measurement_uid_s (FSK, O: CHAR VARYING(19))
- potential_field_geometry_set.measurement_uid
Defines a grid and a "measurement uid" value at each node of that grid. Each node represents a point where a measurement was taken. There is no semantic meaning implied by the "uid" value other than uniqueness within the context of the grid. The same grid can be used by many other attributes which assign information to a measurement.
Defines a foreign key to table grid_1d.
- naming_system (FNK, O: CHAR VARYING(80))
- earth_feature.naming_system
The naming system in which the identifier is defined and unique.
Defines a foreign key to table naming_system.
- part_of_s (FSK, O: CHAR VARYING(19))
- geophysical_geometry_set.part_of
Defines the geometry set of which this geometry set is a part.
Defines a foreign key to table geophysical_geometry_set.
- receiver_class_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.receiver_class
Asserts that all receiver facilities are identical and are a member of the specified class.
Defines a foreign key to table facility_class.
- receiver_uid_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.receiver_uid
Defines a 1D grid which specifies a "receiver uid" value at each node. This represents fixed receiver facilities (e.g., land acquisition). There is no semantic meaning implied by the "uid" value.
Defines a foreign key to table grid_1d.
- seismic_station_uid_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.seismic_station_uid
Defines a 1D grid which specified a "seismic station uid" value at each node. Each node represents a surveyed station (e.g., land). There is no semantic meaning implied by the "uid" value.
Defines a foreign key to table grid_1d.
- source_event_uid_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.source_event_uid
Defines a 1D grid with a "source event uid" value specified at each node. Each node represents a different source event. The same grid can then be used by many other attributes which assign information to a source event. There is no semantic meaning implied by the "uid" value.
Defines a foreign key to table grid_1d.
- station_uid_s (FSK, O: CHAR VARYING(19))
- potential_field_geometry_set.station_uid
Defines a 1D grid which specified a "potential field station uid" value at each node. Each node represents a surveyed station (e.g., land). There is no semantic meaning implied by the "uid" value.
Defines a foreign key to table grid_1d.
- unique_within_s (FSK, O: CHAR VARYING(19))
unique_within_t (O: CHAR VARYING(30))
- earth_feature.unique_within
This is another earth feature within which this earth feature is uniquely identified.
unique_within_s: Implements a foreign key to a row in one of the tables projected from entity earth_feature depending on the value of the next column (See below).
unique_within_t: Defines the name of the referenced table. Possible values are defined in @earth_feature.
- version_s (FSK, O: CHAR VARYING(19))
- earth_feature.version
This describes the version of this instance as defined by the provider.
Defines a foreign key to table r_version.
- wellbore_s (FSK, O: CHAR VARYING(19))
- seismic_geometry_set.wellbore
The wellbore with which this geometry set is identified (e.g., for VSP).
Defines a foreign key to table wellbore.