INSPIRE Code List Register
Joint Research Centre
@ecjrc.jrc_10109_codelist
Table 1
@ecjrc.jrc_10109_codelist.table_1
- 49.64 KB
- 332 rows
- 18 columns
idID | languageLanguage | labelLabel | definitionDefinition | descriptionDescription | collectionCollection | parentParent | successorSuccessor | predecessorPredecessor | registryRegistry | registerRegister | extensibility_itemExtensibility-item | internalexternalInternalExternal | applicationschemaApplicationSchema | themeTheme | documentDocument | governance_level_itemGovernance-level-item | statusStatus |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| http://inspire.ec.europa.eu/codelist/GeometryMethodValue | en | Geometry Method | Description of how and by whom this geographic position of the address was created or derived. | NOTE Information on what type of spatial feature the geographic position of the address was created or derived from, is represented by the GeometrySpecificationValue. | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/ad | http://inspire.ec.europa.eu/theme/ad | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | ||||||||
| http://inspire.ec.europa.eu/codelist/GeometrySpecificationValue | en | Geometry Specification | Information defining the specification used to create or derive this geographic position of the address. | NOTE 1 Multiple address points can be derived from one polygon spatial object. \n\nNOTE 2 If the position of an address is derived from a polygon spatial object a number of different approaches is used.\n\nEXAMPLE 1 The same point (e.g., centre point of the polygon) is used for each address, thus, m… | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/ad | http://inspire.ec.europa.eu/theme/ad | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | ||||||||
| http://inspire.ec.europa.eu/codelist/LocatorDesignatorTypeValue | en | Locator Designator Type | Description of the semantics of the locator designator. | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/ad | http://inspire.ec.europa.eu/theme/ad | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | |||||||||
| http://inspire.ec.europa.eu/codelist/LocatorLevelValue | en | Locator Level | The level to which the locator refers. | NOTE The locator level attribute enables the comparison of locators from different countries. \n\nEXAMPLE In The Netherlands a single locator, the address number, identifies a dwelling or business entity unit (unit level locator). In Spain up to four locators could be needed to obtain the same level… | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/ad | http://inspire.ec.europa.eu/theme/ad | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | ||||||||
| http://inspire.ec.europa.eu/codelist/LocatorNameTypeValue | en | Locator Name Type | Description of the semantics of the locator name. | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/ad | http://inspire.ec.europa.eu/theme/ad | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | |||||||||
| http://inspire.ec.europa.eu/codelist/PartTypeValue | en | Part Type | A classification of the part of name according to its semantics in the complete thoroughfare name. | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/ad | http://inspire.ec.europa.eu/theme/ad | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | |||||||||
| http://inspire.ec.europa.eu/codelist/StatusValue | en | Status | Current validity of the real world address or address component. | NOTE 1 This element enables the application schema to represent a full life-cycle of an address and address component, from proposed to reserved, current and retired, or even alternative. \n\nNOTE 2 The status value relates to the real world address or address component and not to the property to wh… | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/ad | http://inspire.ec.europa.eu/theme/ad | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | ||||||||
| http://inspire.ec.europa.eu/codelist/BaselineSegmentTypeValue | en | Baseline Segment Type | The types of baselines used to measure the breadth of the territorial sea. | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/mu | http://inspire.ec.europa.eu/theme/au | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | |||||||||
| http://inspire.ec.europa.eu/codelist/MaritimeZoneTypeValue | en | Maritime Zone Type | Type of martime zone. | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/mu | http://inspire.ec.europa.eu/theme/au | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid | |||||||||
| http://inspire.ec.europa.eu/codelist/AdministrativeHierarchyLevel | en | Administrative Hierarchy Level | Levels of administration in the national administrative hierarchy. This code list reflects the level in the hierarchical pyramid of the administrative structures, which is based on geometric aggregation of territories and does not necessarily describe the subordination between the related administra… | http://inspire.ec.europa.eu/registry/extensibility/none | http://inspire.ec.europa.eu/applicationschema/au | http://inspire.ec.europa.eu/theme/au | http://inspire.ec.europa.eu/registry/governance-level/eu-legal | http://inspire.ec.europa.eu/registry/status/valid |
CREATE TABLE table_1 (
"id" VARCHAR,
"language" VARCHAR,
"label" VARCHAR,
"definition" VARCHAR,
"description" VARCHAR,
"collection" VARCHAR,
"parent" VARCHAR,
"successor" VARCHAR,
"predecessor" VARCHAR,
"registry" VARCHAR,
"register" VARCHAR,
"extensibility_item" VARCHAR,
"internalexternal" VARCHAR,
"applicationschema" VARCHAR,
"theme" VARCHAR,
"document" VARCHAR,
"governance_level_item" VARCHAR,
"status" VARCHAR
);