The SU geodatabase template implements the application schemas within the Statistical Units data theme, including Statistical Units Base, Statistical Units Grid, Statistical Units Vector.
To view the geodatabase model diagram, please refer to model for
SU_diagram.pdf.
This document only provides ArcGIS geodatabase specific implementation details. For original description of each fields, please refer to the equivalent UML description in the Statistical Units (SU) section of INSPIRE documentation. While creating the ArcGIS for INSPIRE geodatabase templates implementation of the INSPIRE UML, some general guidelines about identifiers, code lists, flattening of INSPIRE data types, attribute definitions, relationships, etc. are developed and followed, those information is available at here (to be updated).
Feature Datasets and Feature Classes
SU - Feature DatasetTables
suAreaStatisticalUnitLineageRelationship Classes
suAreaStatisticalUnit_AreaStatisticalUnitLineageDomains
baseCountryCodeSU - FeatureDataset
Name | SU |
Description | This feature dataset contains the feature classes for the INSPIRE Statistical Units data theme. |
suStatisticalGridCellS - FeatureClass
Name | suStatisticalGridCellS |
ShapeType | Polygon |
FeatureType | Simple |
HasM | false |
HasZ | false |
Description | This feature class contains spatial features (polygon) for statistical grid cell. |
Field | DataType (Length) | UML Source | Description |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
rid | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalGridCell.IFCID |
suVectorStatisticalUnitGeometryL - FeatureClass
Name | suVectorStatisticalUnitGeometryL |
ShapeType | Polyline |
FeatureType | Simple |
HasM | false |
HasZ | false |
Description | This feature class contains spatial features (line) for vector statistical units. |
Field | DataType (Length) | UML Source | Description |
geo_geometryType_code | String(255) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_geometryType_label | String(255) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_geometryType_uri | String(255) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_leastDetailedScale | Integer(4) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.leastDetailedScale | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_mostDetailedScale | Integer(4) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.mostDetailedScale | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
rid | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
suVectorStatisticalUnitGeometryP - FeatureClass
Name | suVectorStatisticalUnitGeometryP |
ShapeType | Point |
FeatureType | Simple |
HasM | false |
HasZ | false |
Description | This feature class contains spatial features (point) for vector statistical units. |
Field | DataType (Length) | UML Source | Description |
geo_geometryType_code | String(255) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_geometryType_label | String(255) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_geometryType_uri | String(255) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_leastDetailedScale | Integer(4) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.leastDetailedScale | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_mostDetailedScale | Integer(4) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.mostDetailedScale | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
rid | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
suVectorStatisticalUnitGeometryS - FeatureClass
Name | suVectorStatisticalUnitGeometryS |
ShapeType | Polygon |
FeatureType | Simple |
HasM | false |
HasZ | false |
Description | This feature class contains spatial features (polygon) for vector statistical units. |
Field | DataType (Length) | UML Source | Description |
geo_geometryType_code | String(255) | SU..SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_geometryType_label | String(255) | SU..SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_geometryType_uri | String(255) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.geometryType | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_leastDetailedScale | Integer(4) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.leastDetailedScale | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_mostDetailedScale | Integer(4) | SU.SUV.VectorStatisticalUnitGeometry.geometryDescriptor.mostDetailedScale | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
rid | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
suAreaStatisticalUnitLineage - Table
Name | suAreaStatisticalUnitLineage |
Description | This table contains information from INSPIRE UML SU.SUV.AreaStatisticalUnit.Lineage |
Field | DataType (Length) | UML Source | Description |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID, rid2 would reference records that are rid1's lineage. |
suAreaStatisticalUnitLowers - Table
Name | suAreaStatisticalUnitLowers |
Description | This table contains information from INSPIRE UML SU.SUV.AreaStatisticalUnit.lowers |
Field | DataType (Length) | UML Source | Description |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID, rid2 would reference records that are rid1's lower level units. |
suAreaStatisticalUnitPredecessors - Table
Name | suAreaStatisticalUnitPredecessors |
Description | This table contains information from INSPIRE UML SU.SUV.AreaStatisticalUnit.predecessors. |
Field | DataType (Length) | UML Source | Description |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID, rid2 would reference records that are rid1's predecessor units. |
suAreaStatisticalUnitUppers - Table
Name | suAreaStatisticalUnitUppers |
Description | This table contains information from INSPIRE UML SU.SUV.AreaStatisticalUnit.uppers |
Field | DataType (Length) | UML Source | Description |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID, rid2 would reference records that are rid1's upper level units. |
suEvolution - Table
Name | suEvolution |
Description | This table contains information from INSPIRE UML SU.SUV.Evolution. |
Field | DataType (Length) | UML Source | Description |
areaVariation_uom | String(255) | SU.SUV.Evolution.areaVariation | Please refer to the equivalent UML description in the INSPIRE documentation |
areaVariation_value | Double(8) | SU.SUV.Evolution.areaVariation | Please refer to the equivalent UML description in the INSPIRE documentation |
areaVariation_void | SmallInteger(2) | SU.SUV.Evolution.areaVariation | Please refer to the equivalent UML description in the INSPIRE documentation |
evoDate | Date(8) | SU.SUV.Evolution.date | Please refer to the equivalent UML description in the INSPIRE documentation |
evolutionType_code | String(255) | SU.SUV.Evolution.evolutionType | Please refer to the equivalent UML description in the INSPIRE documentation |
evolutionType_label | String(255) | SU.SUV.Evolution.evolutionType | Please refer to the equivalent UML description in the INSPIRE documentation |
evolutionType_uri | String(255) | SU.SUV.Evolution.evolutionType | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
populationVariation | Integer(4) | SU.SUV.Evolution.populationVariation | Please refer to the equivalent UML description in the INSPIRE documentation |
populationVariation_void | SmallInteger(2) | SU.SUV.Evolution.populationVariation | Please refer to the equivalent UML description in the INSPIRE documentation |
rid | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
suStatisticalGrid - Table
Name | suStatisticalGrid |
Description | This table contains information from INSPIRE UML SU.SUG.StatisticalGrid. |
Field | DataType (Length) | UML Source | Description |
EPSGCode | Integer(4) | SU.SUG.StatisticalGrid.EPSGCode | Please refer to the equivalent UML description in the INSPIRE documentation |
height | Integer(4) | SU.SUG.StatisticalGrid.height | Please refer to the equivalent UML description in the INSPIRE documentation |
id_localId | String(255) | SU.SUG.StatisticalGrid.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_namespace | String(255) | SU.SUG.StatisticalGrid.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId | String(255) | SU.SUG.StatisticalGrid.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId_void | SmallInteger(2) | SU.SUG.StatisticalGrid.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
ori_coordinate | String(255) | SU.SUG.StatisticalGrid.origin.coordinate | Please refer to the equivalent UML description in the INSPIRE documentation |
ori_dimension | Integer(4) | SU.SUG.StatisticalGrid.origin.dimension | Please refer to the equivalent UML description in the INSPIRE documentation |
res_angleResolution_uom | String(255) | SU.SUG.StatisticalGrid.resolution.angleResolution.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
res_angleResolution_value | Double(8) | SU.SUG.StatisticalGrid.resolution.angleResolution.value | Please refer to the equivalent UML description in the INSPIRE documentation |
res_lengthResolution_uom | String(255) | SU.SUG.StatisticalGrid.resolution.lengthResolution.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
res_lengthResolution_value | Double(8) | SU.SUG.StatisticalGrid.resolution.lengthResolution.value | Please refer to the equivalent UML description in the INSPIRE documentation |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalGrid.IFCID, it references records that are IFCID's lower level cell. |
rid1_lower_void | SmallInteger(2) | SU.SUG.StatisticalGrid.lower | |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalGrid.IFCID, it references records that are IFCID's upper level cell. |
rid2_upper_void | SmallInteger(2) | SU.SUG.StatisticalGrid.upper | |
width | Integer(4) | SU.SUG.StatisticalGrid.width | Please refer to the equivalent UML description in the INSPIRE documentation |
suStatisticalGridCell - Table
Name | suStatisticalGridCell |
Description | This table contains information from INSPIRE UML SU.SUG.StatisticalGridCell. |
Field | DataType (Length) | UML Source | Description |
cellCode | String(255) | SU.SUG.StatisticalGridCell.code | Please refer to the equivalent UML description in the INSPIRE documentation |
cellCode_void | SmallInteger(2) | SU.SUG.StatisticalGridCell.code | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_coordinate | String(255) | SU.SUG.StatisticalGridCell. | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_dimension | Integer(4) | SU.SUG.StatisticalGridCell. | Please refer to the equivalent UML description in the INSPIRE documentation |
geo_void | SmallInteger(2) | SU.SUG.StatisticalGridCell. | Please refer to the equivalent UML description in the INSPIRE documentation |
geometry_void | SmallInteger(2) | SU.SUG.StatisticalGridCell. | Please refer to the equivalent UML description in the INSPIRE documentation |
grid_void | SmallInteger(2) | SU.SUG.StatisticalGridCell.gridPosition | Please refer to the equivalent UML description in the INSPIRE documentation |
grid_x | Integer(4) | SU.SUG.StatisticalGridCell.gridPosition.x | Please refer to the equivalent UML description in the INSPIRE documentation |
grid_y | Integer(4) | SU.SUG.StatisticalGridCell.gridPosition.y | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
rid | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalGrid.IFCID |
rid_lower_void | SmallInteger(2) | SU.SUG.StatisticalGridCell.lowers | |
rid_upper | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalGridCell.IFCID, it references records that are IFCID's upper level cells. |
rid_upper_void | SmallInteger(2) | SU.SUG.StatisticalGridCell.upper |
suStatisticalGridCellLower - Table
Name | suStatisticalGridCellLower |
Description | This table contains information from INSPIRE UML SU.SUG.StatisticalGridCell.lowers |
Field | DataType (Length) | UML Source | Description |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalGridCell.IFCID |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalGridCell.IFCID, it references records that are IFCID's lower level cells. |
suStatisticalTesselation - Table
Name | suStatisticalTesselation |
AliasName | StatisticalTessellation |
Description | This table contains information from INSPIRE UML SU.SUV.StatisticalTessellation. |
Field | DataType (Length) | UML Source | Description |
id_localId | String(255) | SU.SUV.StatisticalTessellation.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_namespace | String(255) | SU.SUV.StatisticalTessellation.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId | String(255) | SU.SUV.StatisticalTessellation.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId_void | SmallInteger(255) | SU.SUV.StatisticalTessellation.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalTessellation.IFCID, it references records that are IFCID's lower level record. |
rid1_lower_void | SmallInteger(255) | SU.SUV.StatisticalTessellation.lower | |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalTessellation.IFCID, it references records that are IFCID's upper level record. |
rid2_upper_void | SmallInteger(255) | SU.SUV.StatisticalTessellation.upper | |
suAreaStatisticalUnit_void | SmallInteger(2) | SU.SUV.AreaStatisticalUnit.units | Please refer to the equivalent UML description in the INSPIRE documentation |
suVectorStatisticalUnit - Table
Name | suVectorStatisticalUnit |
SubtypeFieldName | subtypeCode |
Description | This table contains information from INSPIRE UML SU.SUV.VectorStatisticalUnit. |
Field | DataType (Length) | UML Source | Description |
areaValue_uom | String(255) | SU.SUV.AreaStatisticalUnit.areaValue.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
areaValue_value | Double(8) | SU.SUV.AreaStatisticalUnit.areaValue.value | Please refer to the equivalent UML description in the INSPIRE documentation |
auAdmUnitS_void | SmallInteger(2) | Please refer to the equivalent UML description in the INSPIRE documentation | |
beginLifespanVersion | Date(8) | SU.SUV.VectorStatisticalUnit.beginLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
beginLifespanVersion_void | SmallInteger(2) | SU.SUV.VectorStatisticalUnit.beginLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
countryCode | String(50) | SU.SUV.VectorStatisticalUnit.country | Please refer to the equivalent UML description in the INSPIRE documentation |
endLifespanVersion | Date(8) | SU.SUV.VectorStatisticalUnit.endLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
endLifespanVersion_void | SmallInteger(2) | SU.SUV.VectorStatisticalUnit.endLifespanVersion | Please refer to the equivalent UML description in the INSPIRE documentation |
evolution_void | SmallInteger(2) | SU.SUV.Evolution.evolutions | Please refer to the equivalent UML description in the INSPIRE documentation |
geographicalName1 | String(255) | SU.SUV.VectorStatisticalUnit.geographicalName.spelling.text | Please refer to the equivalent UML description in the INSPIRE documentation |
geographicalName2 | String(255) | SU.SUV.VectorStatisticalUnit.geographicalName.spelling.text | Please refer to the equivalent UML description in the INSPIRE documentation |
geographicalName3 | String(255) | SU.SUV.VectorStatisticalUnit.geographicalName.spelling.text | Please refer to the equivalent UML description in the INSPIRE documentation |
id_localId | String(255) | SU.SUV.VectorStatisticalUnit.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_namespace | String(255) | SU.SUV.VectorStatisticalUnit.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId | String(255) | SU.SUV.VectorStatisticalUnit.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
id_versionId_void | SmallInteger(255) | SU.SUV.VectorStatisticalUnit.inspireId | Please refer to the equivalent UML description in the INSPIRE documentation |
ifcid | Integer(4) | _ | Identifier, the value must be unique in the table |
landAreaValue_uom | String(255) | SU.SUV.VectorStatisticalUnit.landAreaValue.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
landAreaValue_value | Double(8) | SU.SUV.VectorStatisticalUnit.landAreaValue.value | Please refer to the equivalent UML description in the INSPIRE documentation |
landAreaValue_void | SmallInteger(2) | SU.SUV.VectorStatisticalUnit.landAreaValue | Please refer to the equivalent UML description in the INSPIRE documentation |
livableAreaValue_uom | String(255) | SU.SUV.VectorStatisticalUnit.livableAreaValue.uom | Please refer to the equivalent UML description in the INSPIRE documentation |
livableAreaValue_value | Double(8) | SU.SUV.VectorStatisticalUnit.livableAreaValue.value | Please refer to the equivalent UML description in the INSPIRE documentation |
livableAreaValue_void | SmallInteger(2) | SU.SUV.VectorStatisticalUnit.livableAreaValue | Please refer to the equivalent UML description in the INSPIRE documentation |
lowers_void | SmallInteger(2) | SU.SUV.AreaStatisticalUnit.lowers | Please refer to the equivalent UML description in the INSPIRE documentation |
predecessors_void | SmallInteger(2) | SU.SUV.AreaStatisticalUnit.predecessors | Please refer to the equivalent UML description in the INSPIRE documentation |
referencePeriod_begin | Date(8) | SU.SUV.VectorStatisticalUnit.referencePeriod | Please refer to the equivalent UML description in the INSPIRE documentation |
referencePeriod_end | Date(8) | SU.SUV.VectorStatisticalUnit.referencePeriod | Please refer to the equivalent UML description in the INSPIRE documentation |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suStatisticalTesselation.IFCID |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references suEvolution.IFCID |
statisticalTessellation_void | SmallInteger(2) | SU.SUV.StatisticalTessellation.tesselation | Please refer to the equivalent UML description in the INSPIRE documentation |
subtypeCode | SmallInteger(2) | _ | Please refer to the equivalent UML description in the INSPIRE documentation |
successors_void | SmallInteger(2) | SU.SUV.AreaStatisticalUnit.successors | Please refer to the equivalent UML description in the INSPIRE documentation |
the_identifier1 | String(255) | SU.SUV.VectorStatisticalUnit.thematicId.identifier | Please refer to the equivalent UML description in the INSPIRE documentation |
the_identifier2 | String(255) | SU.SUV.VectorStatisticalUnit.thematicId.identifier | Please refer to the equivalent UML description in the INSPIRE documentation |
the_identifier3 | String(255) | SU.SUV.VectorStatisticalUnit.thematicId.identifier | Please refer to the equivalent UML description in the INSPIRE documentation |
the_identifierScheme1 | String(255) | SU.SUV.VectorStatisticalUnit.thematicId.identifierScheme | Please refer to the equivalent UML description in the INSPIRE documentation |
the_identifierScheme2 | String(255) | SU.SUV.VectorStatisticalUnit.thematicId.identifierScheme | Please refer to the equivalent UML description in the INSPIRE documentation |
the_identifierScheme3 | String(255) | SU.SUV.VectorStatisticalUnit.thematicId.identifierScheme | Please refer to the equivalent UML description in the INSPIRE documentation |
uppers_void | SmallInteger(2) | SU.SUV.AreaStatisticalUnit.uppers | Please refer to the equivalent UML description in the INSPIRE documentation |
validityPeriod_begin | Date(8) | SU.SUV.VectorStatisticalUnit.validityPeriod | Please refer to the equivalent UML description in the INSPIRE documentation |
validityPeriod_end | Date(8) | SU.SUV.VectorStatisticalUnit.validityPeriod | Please refer to the equivalent UML description in the INSPIRE documentation |
Subtype Code | Subtype Name | Field Info | ||||||||||||
1 | OtherTypes |
Field:beginLifespanVersion_void Domain:VoidReasonValue DefaultValue: |
Field:countryCode Domain:baseCountryCode DefaultValue: |
Field:endLifespanVersion_void Domain:VoidReasonValue DefaultValue: |
Field:evolution_void Domain:VoidReasonValue DefaultValue: |
Field:id_versionId_void Domain:VoidReasonValue DefaultValue: |
||||||||
2 | AreaStatisticalUnit |
Field:auAdmUnitS_void Domain:VoidReasonValue DefaultValue: |
Field:beginLifespanVersion_void Domain:VoidReasonValue DefaultValue: |
Field:countryCode Domain:baseCountryCode DefaultValue: |
Field:endLifespanVersion_void Domain:VoidReasonValue DefaultValue: |
Field:evolution_void Domain:VoidReasonValue DefaultValue: |
Field:id_versionId_void Domain:VoidReasonValue DefaultValue: |
Field:landAreaValue_void Domain:VoidReasonValue DefaultValue: |
Field:livableAreaValue_void Domain:VoidReasonValue DefaultValue: |
Field:lowers_void Domain:VoidReasonValue DefaultValue: |
Field:predecessors_void Domain:VoidReasonValue DefaultValue: |
Field:statisticalTessellation_void Domain:VoidReasonValue DefaultValue: |
Field:successors_void Domain:VoidReasonValue DefaultValue: |
Field:uppers_void Domain:VoidReasonValue DefaultValue: |
suVSUauAdmUnit - Table
Name | suVSUauAdmUnit |
Description | This table contains information from INSPIRE UML SU.SUV.VectorStatisticalUnit and AU.AU.AdministrativeUnit. |
Field | DataType (Length) | UML Source | Description |
rid1 | Integer(4) | _ | It is a foreign key in the table, it references suVectorStatisticalUnit.IFCID |
rid2 | Integer(4) | _ | It is a foreign key in the table, it references auAdmUnitS.IFCID |
suAreaStatisticalUnit_AreaStatisticalUnitLineage - RelationshipClass
Name | suAreaStatisticalUnit_AreaStatisticalUnitLineage |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasLineage |
BackwardPathLabel | fromUnit |
Description | This relationship class defines the relationship between suVectorStatisticalUnit (AreaStatisticalUnit) and suAreaStatisticalUnitLineage. Eeach feature in suVectorStatisticalUnit (AreaStatisticalUnit) can contain zero or many features in suAreaStatisticalUnitLineage. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suAreaStatisticalUnitLineage |
suAreaStatisticalUnit_AreaStatisticalUnitLowers - RelationshipClass
Name | suAreaStatisticalUnit_AreaStatisticalUnitLowers |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasLowers |
BackwardPathLabel | fromUnit |
Description | This relationship class defines the relationship between suVectorStatisticalUnit (AreaStatisticalUnit) and suAreaStatisticalUnitLowers. Eeach feature in suVectorStatisticalUnit (AreaStatisticalUnit) can contain zero or many features in suAreaStatisticalUnitLowers. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suAreaStatisticalUnitLowers |
suAreaStatisticalUnit_AreaStatisticalUnitPredecessors - RelationshipClass
Name | suAreaStatisticalUnit_AreaStatisticalUnitPredecessors |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasPredecessors |
BackwardPathLabel | fromUnit |
Description | This relationship class defines the relationship between suVectorStatisticalUnit (AreaStatisticalUnit) and suAreaStatisticalUnitPredecessors. Eeach feature in suVectorStatisticalUnit (AreaStatisticalUnit) can contain zero or many features in suAreaStatisticalUnitPredecessors. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suAreaStatisticalUnitPredecessors |
suAreaStatisticalUnit_AreaStatisticalUnitUppers - RelationshipClass
Name | suAreaStatisticalUnit_AreaStatisticalUnitUppers |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasUppers |
BackwardPathLabel | fromUnit |
Description | This relationship class defines the relationship between suVectorStatisticalUnit (AreaStatisticalUnit) and suAreaStatisticalUnitUppers. Eeach feature in suVectorStatisticalUnit (AreaStatisticalUnit) can contain zero or many features in suAreaStatisticalUnitUppers. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suAreaStatisticalUnitUppers |
suEvolution_StatisticalUnit - RelationshipClass
Name | suEvolution_StatisticalUnit |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | fromEvolution |
BackwardPathLabel | hasUnits |
Description | This relationship class defines the relationship between suEvolution and suVectorStatisticalUnit. Eeach feature in suEvolution can contain zero or many features in suVectorStatisticalUnit (each evolution can contain many statistical units). |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suEvolution | ifcid | rid2 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suVectorStatisticalUnit |
suStatisticalGrid_StatisticalGridCell - RelationshipClass
Name | suStatisticalGrid_StatisticalGridCell |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasCells |
BackwardPathLabel | belongsToGrid |
Description | This relationship class defines the relationship between suStatisticalGrid and suStatisticalGridCell. Eeach feature in suStatisticalGrid can contain zero or many features in suStatisticalGridCell. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suStatisticalGrid | ifcid | rid |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suStatisticalGridCell |
suStatisticalGridCell_StatisticalGridCellLower - RelationshipClass
Name | suStatisticalGridCell_StatisticalGridCellLower |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasLower |
BackwardPathLabel | partOf |
Description | This relationship class defines the relationship between suStatisticalGridCell and suStatisticalGridCellLower. Eeach feature in suStatisticalGridCell can contain zero or many features in suStatisticalGridCellLower. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suStatisticalGridCell | ifcid | rid1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suStatisticalGridCellLower |
suStatisticalGridCell_StatisticalGridCellS - RelationshipClass
Name | suStatisticalGridCell_StatisticalGridCellS |
Cardinality | OneToOne |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasGeometry |
BackwardPathLabel | geometryOf |
Description | This relationship class defines the relationship between suStatisticalGridCell and suStatisticalGridCellS. Eeach feature in suStatisticalGridCell can contain zero or one features in suStatisticalGridCellS. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suStatisticalGridCell | ifcid | rid |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suStatisticalGridCellS |
suVectorStatisticalUnit_auAdmUnitS - RelationshipClass
Name | suVectorStatisticalUnit_auAdmUnitS |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | contains |
BackwardPathLabel | partOf |
Description | This relationship class defines the relationship between suVectorStatisticalUnit and suVSUauAdmUnit. Eeach feature in suVectorStatisticalUnit can contain zero or one features in suVSUauAdmUnit. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suVSUauAdmUnit |
suVectorStatisticalUnit_Evolution - RelationshipClass
Name | suVectorStatisticalUnit_Evolution |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | hasEvolutions |
BackwardPathLabel | fromUnits |
Description | This relationship class defines the relationship between suVectorStatisticalUnit and suEvolution. Eeach feature in suVectorStatisticalUnit can contain zero or one features in suEvolution (each suVectorStatisticalUnit can have multiple versions). |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suEvolution |
suVectorStatisticalUnit_GeometryL - RelationshipClass
Name | suVectorStatisticalUnit_GeometryL |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | to |
BackwardPathLabel | from |
Description | This relationship class defines the relationship between suVectorStatisticalUnit and suVectorStatisticalUnitGeometryL. Eeach feature in suVectorStatisticalUnit can contain zero or one features in suVectorStatisticalUnitGeometryL. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suVectorStatisticalUnitGeometryL |
suVectorStatisticalUnit_GeometryP - RelationshipClass
Name | suVectorStatisticalUnit_GeometryP |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | to |
BackwardPathLabel | from |
Description | This relationship class defines the relationship between suVectorStatisticalUnit and suVectorStatisticalUnitGeometryP. Eeach feature in suVectorStatisticalUnit can contain zero or one features in suVectorStatisticalUnitGeometryP. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suVectorStatisticalUnitGeometryP |
suVectorStatisticalUnit_GeometryS - RelationshipClass
Name | suVectorStatisticalUnit_GeometryS |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | to |
BackwardPathLabel | from |
Description | This relationship class defines the relationship between suVectorStatisticalUnit and suVectorStatisticalUnitGeometryS. Eeach feature in suVectorStatisticalUnit can contain zero or one features in suVectorStatisticalUnitGeometryS. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suVectorStatisticalUnit | ifcid | rid |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suVectorStatisticalUnitGeometryS |
suVectorStatisticalUnit_StatisticalTesselation - RelationshipClass
Name | suVectorStatisticalUnit_StatisticalTesselation |
Cardinality | OneToMany |
IsAttributed | false |
IsComposite | false |
ForwardPathLabel | to |
BackwardPathLabel | from |
Description | This relationship class defines the relationship between suStatisticalTesselation and suVectorStatisticalUnit. Eeach feature in suStatisticalTesselation can contain zero or one features in suVectorStatisticalUnit. |
Origin Class Name | Origin Primary Key | Origin Foreign Key |
suStatisticalTesselation | ifcid | rid1 |
Destination Class Name | Destination Primary Key | Destination Foreign Key |
suVectorStatisticalUnit |
baseCountryCode - Domain
DomainName | baseCountryCode |
Description | Country code as defined in the Interinstitutional style guide published by the Publications Office of the European Union. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
AT | AT |
BE | BE |
BG | BG |
CY | CY |
CZ | CZ |
DE | DE |
DK | DK |
EE | EE |
EL | EL |
ES | ES |
FI | FI |
FR | FR |
HR | HR |
HU | HU |
IE | IE |
IT | IT |
LT | LT |
LU | LU |
LV | LV |
MT | MT |
NL | NL |
PL | PL |
PT | PT |
RO | RO |
SE | SE |
SI | SI |
SK | SK |
TR | TR |
UK | UK |
VoidReasonValue - Domain
DomainName | VoidReasonValue |
FieldType | SmallInteger |
Domain Type | CodedValue |
Code | Name |
0 | No reason given |
1 | Unknown |
2 | Unpopulated |
3 | Withheld |