AREAS
Contents |
What are AREAS
Areas are places, and usually can be described spatially using polygons. They are often used to provide contextual references about where an object or process occurs. For example, a well may be located in a specific county or municipality that is in turn located within a state, province or territory.
Areas may be described geographically or geopolitically. Geopolitical areas may indicate an extended boundary of influence, such as operations in one country that are governed in part by regulations in another country (such as conformance to Sarbanes-Oxley.
This module should not be used for aggregation or reserves / production reporting hierarchies. This function is supported by the REPORTING_HIERARCHIES module.
How to Use AREAS
Start by deciding which kinds of areas you are going to store in the AREA modules. Common choices include countries, states, provinces, territories, areas of interest, JV areas, environmental areas etc. Create this list in the reference table R_AREA_TYPE.
Each new area should be created in the AREA table, using the appropriate AREA_TYPE. For example, you may create an entry for the country Canada as
- AREA_ID = 'CANADA', AREA_TYPE = 'COUNTRY'
Next create entries for the provinces and territories (using other columns as appropriate):
- AREA_ID = 'BRITISH COLUMBIA', AREA_TYPE = 'PROVINCE'
- AREA_ID = 'ALBERTA', AREA_TYPE = 'PROVINCE'
- AREA_ID = 'SASKATCHEWAN', AREA_TYPE = 'PROVINCE'
- AREA_ID = 'MANITOBA', AREA_TYPE = 'PROVINCE'
and so on.
Each province is contained by Canada; this is an important relationship that helps us with geographic queries. These relationships can be captured by using spatial data types, or they can be captured relationally. To capture relationships using PPDM tables, go to AREA_CONTAIN. That table contains a CONTAINED_AREA_ID and a CONTAINING_AREA_ID, along with the appropriate AREA_TYPE columns.
- CONTAINED_AREA_ID = 'BRITISH COLUMBIA', CONTAINED_AREA_TYPE = 'PROVINCE', CONTAINING_AREA_ID = 'CANADA', CONTAINED_AREA_TYPE = 'COUNTRY'
CONTAIN_TYPE describes whether the containment is complete or partial. In this example, the containment is complete. In other kinds of relationships (such as the relationship between a JV area and an operating area), the contained area may only be partly contained by the containing area.
Finding Standard AREA Data
The World Fact Book contains lists of
- Country codes https://www.cia.gov/library/publications/the-world-factbook/appendix/appendix-d.html
- Hydrographic Codes https://www.cia.gov/library/publications/the-world-factbook/appendix/appendix-e.html
- Geographic names https://www.cia.gov/library/publications/the-world-factbook/appendix/appendix-f.html
