Alternate_Position

[Columns] [Composed Of] [Referenced By] [Refers To]

Name	Alternate_Position
Entity Type	Table
Description	A position is a type of vertex that is located in, on, or above the Earth but is always locatable using a geo-referenced coordinate system. Physical objects such as wells and other facilities have a position on the Earth. The exact position of a facility may be reported differently due to the vagaries of the various instruments used to determine positions or rules imposed by company or government bodies. These differing positions can be reported as "alternate" positions.
Submodel	Spatial
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations	Entity , IT_Object , Tracked_Object
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain / Measurement	Description	Required / Default	Type
Abstract_Number	CODE NA	An abstract is a collection of recorded instruments affecting the title to a tract of land. The Abstract Number is an identifier assigned to the abstract.	No	VARCHAR2(64)
Alternate_X_Longitude	double No_Unit	X coordinate, or longitude, of the alternate position.	No	NUMBER
Alternate_Y_Latitude	double No_Unit	Y coordinate, or latitude, of the alternate position.	No	NUMBER
Block_Fraction	STRING255 NA	A block fraction is a portion of a sub-divided lease block. Block Fraction identifies the portion of the block in which the position is situated.	No	VARCHAR2(255)
Block_Prefix	STRING255 NA	Alpha prefix to block number; e.g., A in addition area in U.S. Outer Continental Shelf (OCS).	No	VARCHAR2(255)
Block_Suffix	STRING255 NA	Block number suffix, used to distinguish a lease block by, for example, denoting license or relinquishment of a block.	No	VARCHAR2(255)
City_Name	STRING255 NA	Name of the city containing the position.	No	VARCHAR2(255)
Country_Code	R_Country	The unique identifier of the country in which the position resides. The codes are assigned by the International Standards Organization (ISO) as documented in standard 3166 and uniquely identify a national government, i.e., a country. Examples are US for the United States and UK for the United Kingdom.	No	VARCHAR2(64)
Country_Name	STRING255 NA	Name of the country containing the position.	No	VARCHAR2(255)
County_Name	STRING255 NA	Name of a county or other first political subdivision below state/province containing the position.	No	VARCHAR2(255)
District_Name	STRING255 NA	Name of the regulatory district in which the position is located.	No	VARCHAR2(255)
East_West_Distance	double Length	The distance of the offset in the east/west direction.	No	NUMBER
East_West_Line	CODE NA	This is the legal survey line (East or West), from which the East West Distance is measured. This line is generally north-south in orientation.	No	VARCHAR2(64)
Existence_Kind	REF_EXISTENCE_KIND NA	A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual.	Yes Actual	VARCHAR2(64)
GUID	STRING128 NA	Globally Unique IDentifier for an instance of a class. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers.	No	VARCHAR2(128)
Grid_Block_E_W	STRING255 NA	East or west direction.	No	VARCHAR2(255)
Grid_Block_N_S	STRING255 NA	North or south direction.	No	VARCHAR2(255)
Grid_Block_Range	STRING255 NA	Measure of Universal Transverse Mercator (UTM) grid-number of range blocks from central meridian.	No	VARCHAR2(255)
Grid_Block_Tier	STRING255 NA	Number of tiers of blocks measured from the equator.	No	VARCHAR2(255)
Id	ID No_Unit	Unique identifier for this entity.	Yes	NUMBER(38)
Insert_Date	DATE NA	Date the entity was created in the repository	No	DATE
Insert_User	STRING64 NA	The name of the user responsible for the creation of this entity in the repository.	No	VARCHAR2(64)
Labor	CODE NA	Labor identifier	No	VARCHAR2(64)
League	CODE NA	League number - alphanumeric	No	VARCHAR2(64)
Lot_Number	CODE NA	The description of a lot number.	No	VARCHAR2(64)
Name	ENTITY_NAME NA	The name given to any object or data item, e.g. Name of Well, Name of Field, etc.	No	VARCHAR2(255)
North_South_Distance	double Length	The distance of the offset in the North/South direction.	No	NUMBER
North_South_Line	CODE NA	This is the legal survey line (North or South), from which the North South Distance is measured. This line is generally East-West in orientation.	No	VARCHAR2(64)
Offshore_Area	STRING255 NA	Name of an offshore area or concession; e.g., Green Canyon or Haltenbank.	No	VARCHAR2(255)
Offshore_Block	STRING255 NA	Block or parcel number within a specified quadrant.	No	VARCHAR2(255)
Original_Elevation	double Length	Elevation of the alternate Position relative to the Coordinate System elevation reference for the input dataset. Elevations are positive going away from the center of the earth and negative going into the earth.	No	NUMBER
Original_Source	STRING64 NA	The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15"	No	VARCHAR2(64)
Position_Id	Position	The identifier of the original position, for which this is an alternate position.	No	NUMBER(38)
Principal_Meridian	CODE NA	Principal Meridian, designated by its longitude, often omitted from formal land descriptions by local governments as all the land in their jurisdiction refers to the same one.	No	VARCHAR2(64)
Produced_By	STRING64 NA	ID of the activity that was executing when the entity was created, for data created programmatically.	No	VARCHAR2(64)
Quadrant	STRING255 NA	Name or number of a quadrant.	No	VARCHAR2(255)
Quadrant_Prefix	STRING255 NA	Quadrant prefix denoting name if designated by letters or abbreviation of offshore area.	No	VARCHAR2(255)
Range_Number	CODE NA	Jeffersonian Range Number, e.g., 3 in R3W for a parcel W12 NE14 S11 T5N R3W.	No	VARCHAR2(64)
Regulatory_Agency	STRING255 NA	Name of the regulatory agency defining the District_Name.	No	VARCHAR2(255)
Remarks	STRING2000 NA	Any type of remarks added to an entity instance.	No	VARCHAR2(2000)
SDAT_Label	int No_Unit	Label used by the security system for entitlements. SDAT is Secure Data Access Technology.	No	NUMBER(10)
Section_Number	CODE NA	Section Number, e.g., 11 for a parcel W12 NE14 S11 T5N R3W.	No	VARCHAR2(64)
Section_Subdivision	CODE NA	A subdivision of a section, usually described by consecutive splitting of the section into halves and quarters, e.g., W12 NE14.	No	VARCHAR2(64)
Section_Suffix	CODE NA	A subsection single letter, e.g., as used in California, USA.	No	VARCHAR2(64)
Section_Type	CODE NA	Section Type, e.g., Lot, Block, Militia, Donation, Bay, etc.	No	VARCHAR2(64)
Source	STRING64 NA	Name of the person or organization responsible for this entity"s E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User.	No	VARCHAR2(64)
Spot_Code	CODE NA	Geographic location within a section.	No	VARCHAR2(64)
State_Name	STRING255 NA	Name of a state, province or other first political subdivision below country containing the position.	No	VARCHAR2(255)
Survey	CODE NA	Texas Survey Name.	No	VARCHAR2(64)
Survey_East_West	CODE NA	Range is East or West from principal meridian, e.g., W in R3W for the parcel W12 NE14 S11 T5N R3W or FEL in Texas.	No	VARCHAR2(64)
Survey_North_South	CODE NA	Township is North or South from base line, e.g., N in T5N for the parcel W12 NE14 S11 T5N R3W or FNL in Texas.	No	VARCHAR2(64)
Timezone	R_Timezone	The unique identifier of the time zone in which the position resides.	No	VARCHAR2(64)
Township_Name	CODE NA	The name of the township, as used in the state of Michigan, USA.	No	VARCHAR2(64)
Township_Number	CODE NA	Jeffersonian Township Number, e.g., 5 in T5N for the parcel W12 NE14 S11 T5N R3W.	No	VARCHAR2(64)
Update_Date	DATE NA	Date of the most-recent modification to the entity.	No	DATE
Update_User	STRING64 NA	The name of the user responsible for the last modification to this entity.	No	VARCHAR2(64)
Version	STRING255 NA	The form or variant of the entity.	Yes 1	VARCHAR2(255)
Water_Bottom_Zone	ZONE_NAME NA	Zone or water bottom identifier.	No	VARCHAR2(255)
Water_Depth	double Length	Distance from the mudline or seafloor to sea level.	No	NUMBER
Water_Ref	STRING255 NA	Sea level reference used for the Water Depth property (e.g., Mean Sea Level, Least Astronomic Tide, Caspian Sea Level, etc.).	No	VARCHAR2(255)

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Country_Code	R_Country	The unique identifier of the country in which the position resides. The codes are assigned by the International Standards Organization (ISO) as documented in standard 3166 and uniquely identify a national government, i.e., a country. Examples are US for the United States and UK for the United Kingdom.	Restrict	No
Timezone	R_Timezone	The unique identifier of the time zone in which the position resides.	Restrict	No
Position	Position	The identifier of the original position, for which this is an alternate position.	Cascade	No

[Seabed Objects] [Entities in Schema Seabed] [Index]

Alternate_Position

Copyright © 2009 Schlumberger. All rights reserved.