POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
This modification reorganizes the subtypes of earth_feature. The goals of this change is to eliminate the multiple inheritance created as part of the license_and_lease change proposal. This also adds an exploration area. It also insures that all subtypes of earth_feature have another feature as part of its identity.
CHANGE ESM2_earth_feature (*<CHANGE> CHANGE ESM2_earth_feature *) (*<desc> This modification reorganizes the subtypes of earth_feature. The goals of this change is to eliminate the multiple inheritance created as part of the license_and_lease change proposal. This also adds an exploration area. It also insures that all subtypes of earth_feature have another feature as part of its identity.*) -- moving attributes of earth_surface_feature ALTER ENTITY earth_feature; ADD unique_within : OPTIONAL earth_feature (*<desc> This is another earth feature within which this earth feature is uniquely identified.*) (*<verb> be identified within*); ADD surface_only : OPTIONAL ndt_boolean (*<desc> When set to TRUE, this earth_feature represents only the surface of the Earth and does not extend into the subsurface.*); INVERSE ADD unique_part : SET[0:?] OF earth_feature FOR unique_within (*<desc> These are the other earth features for which this earth feature is a unique part of their identities*) (*<verb> identify*); ADD local_rock_feature : SET[0:?] OF local_rock_feature FOR earth_feature (*<desc> These are the local_rock_features that this earth_feature provides identification for.*) (*<verb> identify*); ADD coordinate_system : SET[0:?] OF coordinate_system_earth_usage FOR earth_feature (*<desc> This describes the coordinate systems that have been defined as appropriate to this portion of the Earth.*) (*<change> Promoted from earth_surface_feature, generalized to apply to subsurface portions of the Earth.*) (*<verb> described using*); ADD coordinate_transformation : SET[0:?] OF coordinate_trfrm_earth_usage FOR earth_feature (*<desc> This describes the coordinate transformations that have been defined as appropriate to this portion of the Earth.*) (*<change> Promoted from earth_surface_feature, generalized to apply to subsurface portions of the Earth.*) (*<verb> described using*); ADD well_log : SET[0:?] OF well_log FOR earth_feature (*<desc> Well logs may contain information, such as well log traces, typical of an earth feature.*) (*<change> Promoted from earth_surface_feature, generalized to apply to subsurface portions of the Earth.*) (*<verb> be described by*); END_ENTITY; ALTER ENTITY earth_surface_feature AS technical_earth_feature (*<desc> These are natural or man-made features of the earth that are at the surface and/or in the subsurface of the earth.*); INVERSE DROP local_rock_feature (*<change> Promoted to earth_feature*); DROP coordinate_system (*<change> Promoted to earth_feature*); DROP coordinate_transformation (*<change> Promoted to earth_feature*); DROP well_log (*<change> Promoted to earth_feature*); END_ENTITY; ADD ENTITY leaseable_earth_feature (*<desc> This represents a surface or subsurface portion of the Earth that may be included in a license right.*) ABSTRACT SUPERTYPE OF (ONEOF(legal_survey_area, geopolitical_feature, land_property_parcel)) SUBTYPE OF (pfnu, earth_feature); INVERSE pty_population_density : SET[0:?] OF pty_population_density FOR earth_surface_feature (*<verb> have a property of*); pty_population : SET[0:?] OF pty_population FOR earth_surface_feature (*<verb> have a property of*); Apty_geothermal_gradient : SET[0:?] OF pty_geothermal_gradient FOR earth_surface_feature (*<verb> have a property of*); pty_avg_earth_surface_elev : SET[0:?] OF pty_avg_earth_surface_elev FOR earth_surface_feature (*<verb> have a property of*); END_ENTITY; ALTER ENTITY local_rock_feature; ALTER earth_surface_feature AS earth_feature ALTER TYPE AS earth_feature (*<desc> This is the earth_feature that locates this local_rock_feature and can provide part of the identity of this local_rock_feature. For example, for the Viking Graben in the Gullfaks area, Gullfaks is the earth_feature that provides part of the identification.*); END_ENTITY; ALTER ENTITY coordinate_system_earth_usage (*<desc> This association asserts that it is appropriate to use a coordinate system within a portion of the Earth.*); ALTER earth_surface_feature AS earth_feature ALTER TYPE AS earth_feature (*<desc> This is the portion of the Earth that is defined as appropriate to use the coordinate system.*) (*<change> This has been generalized to apply to subsurface earth features.*); ALTER coordinate_system (*<desc> This is the coordinate system that has been defined as appropriate to the portion of the Earth.*); END_ENTITY; ALTER ENTITY coordinate_trfrm_earth_usage (*<desc> This association asserts that it is appropriate to use a coordinate system transformation within a portion of the surface of the Earth.*); ALTER earth_surface_feature AS earth_feature ALTER TYPE AS earth_feature (*<desc> This is the portion of the Earth that is defined as appropriate to use the coordinate transformation.*) (*<change> This has been generalized to apply to subsurface earth features.*); ALTER coordinate_transformation (*<desc> This is the coordinate transformation that has been defined as appropriate to the portion of the Earth.*); END_ENTITY; ALTER ENTITY coordinate_transformation; ALTER coordinate_transformation_aoi (*<desc> These are the areas of the Earth that are defined as appropriate to use this coordinate transformation.*); END_ENTITY; ALTER ENTITY well_log; ALTER earth_surface_feature AS earth_feature ALTER TYPE AS earth_feature (*<desc> The earth feature that is characterized by the well log trace data contained in this well log.*) (*<change> This has been generalized to apply to subsurface earth features.*); WHERE ALTER ose1 : NOT (EXISTS(wellbore) AND EXISTS(earth_feature)) (*<DESC>A well log may be related to either a wellbore or an earth feature but not both.*); END_ENTITY; ALTER ENTITY pty_population_density; ADD leaseable_earth_feature : OPTIONAL leaseable_earth_feature (*<verb> be a property of*); END_ENTITY; ALTER ENTITY pty_population ; ADD leaseable_earth_feature : OPTIONAL leaseable_earth_feature (*<verb> be a property of*); END_ENTITY; ALTER ENTITY pty_geothermal_gradient ; ADD leaseable_earth_feature : OPTIONAL leaseable_earth_feature (*<verb> be a property of*); END_ENTITY; ALTER ENTITY pty_avg_earth_surface_elev; ADD leaseable_earth_feature : OPTIONAL leaseable_earth_feature (*<verb> be a property of*); END_ENTITY; -- new entity hierarchy ALTER ENTITY legal_survey_area DROP SUBTYPE OF (earth_surface_feature); END_ENTITY; ALTER ENTITY geopolitical_feature DROP SUBTYPE OF (earth_surface_feature); DROP unique_member_of (*<change> Replaced by earth_feature.unique_within*); INVERSE DROP unique_owner_of (*<change> Replaced by earth_feature.unique_parts*); UNIQUE ALTER si DROP unique_member_of ADD unique_within FIRST; END_ENTITY; ALTER ENTITY land_property_parcel AS earth_parcel DROP SUBTYPE OF (earth_surface_feature) (*<desc> A contiguous portion of the Earth, which may be onshore, in coastal or internal waters, or offshore and may be at the surface and/or in the subsurface. Each earth parcel has a single outer boundary (when represented at the surface) but may have several inner boundaries (holes).*); DROP surface_right; ADD start_date : OPTIONAL ndt_date (*<desc> This is the date when this land property parcel was created.*); ADD end_date : optional ndt_date (*<desc> This is the date when this land property parcel was deprecated.*); ALTER gross_acreage (*<desc> The nominal gross acreage assigned to the earth parcel.*); ALTER net_acreage (*<desc> The nominal net acreage assigned to the earth parcel.*); INVERSE DROP land_property_volume (*<change> merged with land_property_parcel to create earth_parcel.*); ADD mineral_zone : SET[0:?] OF mineral_zone FOR earth_parcel (*<desc> These are the specific mineral zones that are included in this earth parcel. Each mineral zone describes a distinct vertical interval of the Earth. If no mineral zones are defined, the earth parcel is either surface only or contains all the mineral zones (depending upon the value of surface_only).*) (*<verb> contain*); ALTER pty_land_legal_description ALTER FOR AS earth_parcel; END_ENTITY; ALTER ENTITY mineral_zone; INVERSE ALTER land_property_volume AS earth_parcel INVERT ADD OPTIONAL DROP AGGREGATE ALTER TYPE AS earth_parcel (*<desc> This is the specific part of the Earth for which this mineral zone is defined.*) (*<verb> is contained within*); UNIQUE ALTER si ADD earth_parcel LAST; END_ENTITY; -- eliminate obviated concepts DROP ENTITY land_property_volume; ALTER ENTITY specific_fluid_component; INVERSE DROP land_property_volume; END_ENTITY; ALTER ENTITY mineral_right; INVERSE DROP land_property_volume; END_ENTITY; DROP ENTITY unitized_land_parcel_area; ALTER ENTITY unitization_agreement; INVERSE DROP unitized_land_parcel_area; END_ENTITY; -- clean up other behavior ALTER ENTITY land_parcel_reclamation_assn AS earth_parcel_reclamation_assn (*<desc> This association asserts that a reclamation certificate authorizes the abandonment of an earth parcel.*); ALTER land_property_parcel AS earth_parcel (*<desc> This is the earth parcel which is addressed by the reclamation certificate.*); END_ENTITY; ALTER ENTITY reclamation_certificate (*<desc> A clearance by regulatory authority for the abandonment and surrender of rights to an earth parcel.*); INVERSE ALTER land_property_parcel AS earth_parcel (*<desc> Indicates various earth parcels which are addressed by this reclamation certificate.*); END_ENTITY; ALTER ENTITY pty_land_legal_description (*<desc> The description of an earth parcel using terms and elements defined within a land legal survey system.*); ALTER land_property_parcel AS earth_parcel; ALTER data_value (*<desc> The free form textual legal description of the earth parcel.*); END_ENTITY; ALTER ENTITY outcrop DROP SUBTYPE OF (earth_surface_feature) ADD SUBTYPE OF (geologic_feature) (*<DESC>A feature which is characterized by exposure of one or more rock features, such as lithostratigraphic units.*); END_ENTITY; ADD ENTITY exploration_area (*<desc> This is an area on the surface of the Earth that has been designated by a business associate as an exploration area. This area is considered to be a unit for exploration planning and reporting purposes.*) SUBTYPE OF (earth_surface_feature); effective_date : OPTIONAL ndt_date (*<desc> The date at which the exploration area becomes effective.*); expiry_date : OPTIONAL ndt_date (*<desc> The date at which the exploration area expires.*); business_associate : OPTIONAL business_associate (*<desc> This is the business associate that created or defined this exploration area. If the area was designated by a government agency, then this is the government agency.*) (*<verb>be defined by*); UNIQUE si: identifier, unique_within, effective_date; END_ENTITY; ALTER ENTITY business_associate; INVERSE ADD exploration_area : SET[0:?] OF exploration_area FOR business_associate (*<desc> These are the exploration areas defined by this business associate.*) (*<verb>define*); END_ENTITY; ---- identity ALTER ENTITY earth_surface_feature (*<REMARK>Renamed to technical_earth_feature.*); DROP geophysical_geometry_set (*<change>Redundant to Earth_feature.unique_part.*); END_ENTITY; ALTER ENTITY geophysical_geometry_set; DROP acquisition_area (*<CHANGE>Redundant to Earth_feature.unique_within.*); END_ENTITY; ALTER ENTITY potential_field_geometry_set; UNIQUE ALTER si ADD unique_within AFTER identifier DROP acquisition_area; END_ENTITY; ALTER ENTITY seismic_geometry_set; UNIQUE ALTER si ADD unique_within AFTER identifier DROP acquisition_area; END_ENTITY; ALTER ENTITY seismic_traverse; UNIQUE ALTER si ADD unique_within AFTER identifier DROP binset_grid; END_ENTITY; ALTER ENTITY carter_legal_survey_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY fed_permit_sys_legal_srvy_area ; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY dominion_land_legal_srvy_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY congressional_legal_srvy_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY european_legal_survey_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY north_east_usa_legal_srvy_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY nts_legal_survey_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY ohio_legal_survey_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY texas_legal_survey_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY land_property_parcel (*<REMARK>Renamed to earth_parcel.*); UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY regulatory_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY geophysical_acquisition_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY geographic_feature; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY discovery_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY magnetic_polarity_zone; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY geodetic_zone; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY geologic_province; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY legal_survey_feature; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY damage_area; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY rock_feature; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY stratigraphic_marker; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY fluid_feature_contact; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY geologic_fault; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY rock_surface; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY aquifer; UNIQUE ALTER si ADD unique_within LAST; END_ENTITY; ALTER ENTITY pool; UNIQUE ALTER si ADD field LAST; END_ENTITY; END_CHANGE;