Agricultural and Aquaculture Facilities



The AF geodatabase template implements the application schemas within the Agricultural and Aquaculture Facilities data theme. To view the geodatabase model diagram, please refer to AF_model.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 Agricultural and Aquaculture Facilities (AF) 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.


Feature Datasets and Feature Classes

AF - Feature Dataset

afHoldingP
afHoldingS
afSiteP
afSiteS


Tables

afFarmAnimalSpecies
afFunction
afFunction_Activity
afInputOutputValue
afSiteActivity


Relationship Classes

afFunction_Function_Activity
afFunction_InputOutputValue
afHoldingP_afFunction
afHoldingP_SiteP
afHoldingP_SiteS
afHoldingS_Function
afHoldingS_SiteP
afHoldingS_SiteS
afSiteP_Activity
afSiteP_FarmAnimalSpecies
afSiteS_Activity
afSiteS_afFarmAnimalSpecies


Domains

dAquacultureSpeciesValue
dEconActivityNACEValue
dHoldingType
dInputOutputType
dProductCPAValue
dWasteValue
VoidReasonValue


AF - FeatureDataset

Name AF
Description This feature dataset contains the feature classes for the Agricultural and Aquaculture Facilities data theme.

afHoldingP - FeatureClass

Name afHoldingP
ShapeType Point
FeatureType Simple
HasM false
HasZ false
Description This feature class contains spatial features (point) for Agricultural and aquaculture facilities holding.

Field DataType UML Source Description
beginLifespanVersion Date(8) AC.ActivityComplex.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) AC.ActivityComplex.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) AC.ActivityComplex.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) AC.ActivityComplex.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
name_ String(255) AC.ActivityComplex.name Please refer to the equivalent UML description in the INSPIRE documentation
name_void SmallInteger(2) AC.ActivityComplex.name Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_identifier1 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifier Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_identifier2 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifier Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_identifier3 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifier Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_idScheme1 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifierScheme Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_idScheme2 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifierScheme Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_idScheme3 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifierScheme Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_from Date(8) AC.ActivityComplex.validFrom Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_from_void SmallInteger(2) AC.ActivityComplex.validFrom Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_to Date(8) AC.ActivityComplex.validTo Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_to_void SmallInteger(2) AC.ActivityComplex.validTo Please refer to the equivalent UML description in the INSPIRE documentation
holdingType String(50) either agriculture or aquaculture
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass


afHoldingS - FeatureClass

Name afHoldingS
ShapeType Polygon
FeatureType Simple
HasM false
HasZ false
Description This feature class contains spatial features (polygon) for Agricultural and aquaculture facilities holding.

Field DataType UML Source Description
beginLifespanVersion Date(8) AC.ActivityComplex.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
beginLifespanVersion_void SmallInteger(2) AC.ActivityComplex.beginLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion Date(8) AC.ActivityComplex.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
endLifespanVersion_void SmallInteger(2) AC.ActivityComplex.endLifespanVersion Please refer to the equivalent UML description in the INSPIRE documentation
id_localId String(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_namespace String(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId String(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
id_versionId_void SmallInteger(255) AC.ActivityComplex.inspireId Please refer to the equivalent UML description in the INSPIRE documentation
name_ String(255) AC.ActivityComplex.name Please refer to the equivalent UML description in the INSPIRE documentation
name_void SmallInteger(2) AC.ActivityComplex.name Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_identifier1 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifier Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_identifier2 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifier Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_identifier3 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifier Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_idScheme1 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifierScheme Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_idScheme2 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifierScheme Please refer to the equivalent UML description in the INSPIRE documentation
thematicId_idScheme3 String(255) AC.ActivityComplex.thematicId.ThematicIdentifier.identifierScheme Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_from Date(8) AC.ActivityComplex.validFrom Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_from_void SmallInteger(2) AC.ActivityComplex.validFrom Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_to Date(8) AC.ActivityComplex.validTo Please refer to the equivalent UML description in the INSPIRE documentation
validPeriod_to_void SmallInteger(2) AC.ActivityComplex.validTo Please refer to the equivalent UML description in the INSPIRE documentation
holdingType String(50) _ either agriculture or aquaculture
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass


afSiteP - FeatureClass

Name afSiteP
ShapeType Point
FeatureType Simple
HasM false
HasZ false
Description This feature class contains spatial features (point) for Agricultural and aquaculture facilities sites.

Field DataType UML Source Description
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass
includeAnimal_void SmallInteger(2) AF.Site.includesAnimal Please refer to the equivalent UML description in the INSPIRE documentation
rid Integer(4) _ It is a foreign key in the table, it references afHoldingS.IFCID and afHoldingP.IFCID


afSiteS - FeatureClass

Name afSiteS
ShapeType Polygon
FeatureType Simple
HasM false
HasZ false
Description This feature class contains spatial features (polygon) for Agricultural and aquaculture facilities sites.

Field DataType UML Source Description
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass
includeAnimal_void SmallInteger(2) AF.Site.includesAnimal Please refer to the equivalent UML description in the INSPIRE documentation
rid Integer(4) _ It is a foreign key in the table, it references afHoldingS.IFCID and afHoldingP.IFCID



afFarmAnimalSpecies - Table

Name afFarmAnimalSpecies
Description This table contains information about Agricultural and aquaculture facilities farm animal species.

Field DataType UML Source Description
aquaculture_code1 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_code2 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_code3 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_label1 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_label2 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_label3 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_uri1 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_uri2 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_uri3 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
aquaculture_void SmallInteger(2) AF.Site.IncludesAnimal.FarmAnimalSpecies.aquaculture.AquacultureSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass/table
livestock_code1 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_code2 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_code3 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_label1 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_label2 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_label3 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_uri1 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_uri2 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_uri3 String(255) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
livestock_void SmallInteger(2) AF.Site.IncludesAnimal.FarmAnimalSpecies.livestock.LivestockSpeciesValue Please refer to the equivalent UML description in the INSPIRE documentation
rid Integer(4) _ It is a foreign key in the table, it references afSiteP.IFCID and afSiteS.IFCID

afFunction - Table

Name afFunction
Description This table contains information about Agricultural and aquaculture facilities function.

Field DataType UML Source Description
description String(255) AC.function.Function.description Please refer to the equivalent UML description in the INSPIRE documentation
description_void SmallInteger(2) AC.function.Function.description Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass/table
input_void SmallInteger(2) AC.function.Function.input Please refer to the equivalent UML description in the INSPIRE documentation
output_void SmallInteger(2) AC.function.Function.output Please refer to the equivalent UML description in the INSPIRE documentation
rid Integer(4) _ It is a foreign key in the table, it references afHoldingP.IFCID and afHoldingS.IFCID

afFunction_Activity - Table

Name afFunction_Activity
Description This table contains information about Agricultural and aquaculture facilities function activities.

Field DataType UML Source Description
activityValue String(0) AC.function.Function.activity Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass/table
rid Integer(4) _ It is a foreign key in the table, it references afFunction.IFCID

afInputOutputValue - Table

Name afInputOutputValue
SubtypeFieldName subtype_code
Description This table contains information about Agricultural and aquaculture facilities function intput and output.

Field DataType UML Source Description
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass/table
inputOutputType String(255) Field used to identify if it is an input or output
inputOutputValue String(0) AC.function.Function.input.InputOutputValue, AC.function.Function.output.InputOutputValue Please refer to the equivalent UML description in the INSPIRE documentation
rid Integer(4) _ It is a foreign key in the table, it references afFunction.IFCID
subtype_code SmallInteger(2) _ Field to tell if sybtype is ProductCPAValue or WasteValue, see below

Subtype Code Subtype Name Field Info
1 afProductCPAValue Field:inputOutputValue
Domain:dProductCPAValue
DefaultValue:

2 afWasteValue Field:inputOutputValue
Domain:dWasteValue
DefaultValue:


afSiteActivity - Table

Name afSiteActivity
Description This table contains information about Agricultural and aquaculture facilities site activity.

Field DataType UML Source Description
activityValue String(255) AF.site.activity.EconomicActivityNACEValue Please refer to the equivalent UML description in the INSPIRE documentation
ifcid Integer(4) _ Identifier, the value must be unique in the featureclass/table
rid Integer(4) _ It is a foreign key in the table, it references afSiteActivity.IFCID

afHoldingP_afFunction - RelationshipClass

Name afHoldingP_afFunction
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afHoldingP and afFunction. Each feature in afHoldingP may relate to one or many features in afFunction.

Origin Class Name Origin Primary Key Origin Foreign Key
afHoldingP ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afFunction

afHoldingP_SiteP - RelationshipClass

Name afHoldingP_SiteP
Cardinality ZeroToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afHoldingP and afSiteP. Each feature in afHoldingP may relate to zero or many features in afSiteP.

Origin Class Name Origin Primary Key Origin Foreign Key
afHoldingP ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afSiteP

afHoldingP_SiteS - RelationshipClass

Name afHoldingP_SiteS
Cardinality ZeroToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afHoldingP and afSiteS. Each feature in afHoldingP may relate to zero or many features in afSiteS.

Origin Class Name Origin Primary Key Origin Foreign Key
afHoldingP ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afSiteS

afHoldingS_Function - RelationshipClass

Name afHoldingS_Function
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afHoldingS and afFunction. Each feature in afHoldingS may relate to one or many features in afFunction.

Origin Class Name Origin Primary Key Origin Foreign Key
afHoldingS ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afFunction

afHoldingS_SiteP - RelationshipClass

Name afHoldingS_SiteP
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afHoldingS and afSiteP. Each feature in afHoldingS may relate to zero or many features in afSiteP.

Origin Class Name Origin Primary Key Origin Foreign Key
afHoldingS ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afSiteP

afHoldingS_SiteS - RelationshipClass

Name afHoldingS_SiteS
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afHoldingS and afSiteS. Each feature in afHoldingS may relate to zero or many features in afSiteS.

Origin Class Name Origin Primary Key Origin Foreign Key
afHoldingS ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afSiteS

afSiteP_Activity - RelationshipClass

Name afSiteP_Activity
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afSiteP and afSiteActivity. Each feature in afSiteP may relate to one or many features in afSiteActivity.

Origin Class Name Origin Primary Key Origin Foreign Key
afSiteP ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afSiteActivity

afSiteP_FarmAnimalSpecies - RelationshipClass

Name afSiteP_FarmAnimalSpecies
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afSiteP and afFarmAnimalSpecies. Each feature in afSiteP may relate to zero or many features in afFarmAnimalSpecies.

Origin Class Name Origin Primary Key Origin Foreign Key
afSiteP ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afFarmAnimalSpecies

afSiteS_Activity - RelationshipClass

Name afSiteS_Activity
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afSiteP and afSiteActivity. Each feature in afSiteP may relate to one or many features in afSiteActivity.

Origin Class Name Origin Primary Key Origin Foreign Key
afSiteS ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afSiteActivity

afSiteS_afFarmAnimalSpecies - RelationshipClass

Name afSiteS_afFarmAnimalSpecies
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afSiteS and afFarmAnimalSpecies. Each feature in afSiteS may relate to one or many features in afFarmAnimalSpecies.

Origin Class Name Origin Primary Key Origin Foreign Key
afSiteS ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afFarmAnimalSpecies

afFunction_Function_Activity - RelationshipClass

Name afFunction_Function_Activity
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afFunction and afFunction_Activity. Each feature in afFunction may relate to one or many features in afFunction_Activity.

Origin Class Name Origin Primary Key Origin Foreign Key
afFunction ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afFunction_Activity

afFunction_InputOutputValue - RelationshipClass

Name afFunction_InputOutputValue
Cardinality OneToMany
IsAttributed false
IsComposite false
ForwardPathLabel to
BackwardPathLabel from
Description This relationship class defines the relationship between afFunction and afInputOutputValue. Each feature in afFunction may relate to one or many features in afInputOutputValue.

Origin Class Name Origin Primary Key Origin Foreign Key
afFunction ifcid rid

Destination Class Name Destination Primary Key Destination Foreign Key
afInputOutputValue

dAquacultureSpeciesValue - Domain

DomainName dAquacultureSpeciesValue
FieldType String
Domain Type CodedValue

Code Name
MyCodedValue MyCodeName


dEconActivityNACEValue - Domain

DomainName dEconActivityNACEValue
FieldType String
Domain Type CodedValue

Code Name
01 Crop and animal production, hunting and related service activities
01.1 Growing of non-perennial crops
01.11 Growing of cereals (except rice), leguminous crops and oil seeds
01.12 Growing of rice
01.13 Growing of vegetables and melons, roots and tubers
01.14 Growing of sugar cane
01.15 Growing of tobacco
01.16 Growing of fibre crops
01.19 Growing of other non-perennial crops
01.2 Growing of perennial crops
01.21 Growing of grapes
01.22 Growing of tropical and subtropical fruits
01.23 Growing of citrus fruits
01.24 Growing of pome fruits and stone fruits
01.25 Growing of other tree and bush fruits and nuts
01.26 Growing of oleaginous fruits
01.27 Growing of beverage crops
01.28 Growing of spices, aromatic, drug and pharmaceutical crops
01.29 Growing of other perennial crops
01.3 Plant propagation (01.3)
01.30 Plant propagation (01.30)
01.4 Animal production
01.41 Raising of dairy cattle
01.42 Raising of other cattle and buffaloes
01.43 Raising of horses and other equines
01.44 Raising of camels and camelids
01.45 Raising of sheep and goats
01.46 Raising of swine/pigs
01.47 Raising of poultry
01.49 Raising of other animals
01.5 Mixed farming (01.5)
01.50 Mixed farming (01.50)
01.6 Support activities to agriculture and post-harvest crop activities
01.61 Support activities for crop production
01.62 Support activities for animal production
01.63 Post-harvest crop activities
01.64 Seed processing for propagation
02 Forestry and logging
03 Fishing and aquaculture
03.2 Aquaculture
03.21 Marine aquaculture
03.22 Freshwater aquaculture


dHoldingType - Domain

DomainName dHoldingType
FieldType String
Domain Type CodedValue

Code Name
agriculture agriculture
aquaculture aquaculture


dInputOutputType - Domain

DomainName dInputOutputType
FieldType String
Domain Type CodedValue

Code Name
input input
output output


dProductCPAValue - Domain

DomainName dProductCPAValue
FieldType String
Domain Type CodedValue

Code Name
MyCodedValue MyCodeName


dWasteValue - Domain

DomainName dWasteValue
FieldType String
Domain Type CodedValue

Code Name
MyCodedValue MyCodeName


VoidReasonValue - Domain

DomainName VoidReasonValue
FieldType SmallInteger
Domain Type CodedValue

Code Name
0 No reason given
1 Unknown
2 Unpopulated
3 Withheld