Name: Surface Water Body

Display Field: euSurfaceWaterBodyCode

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 55a58faaa8e84ee68d4992e277268bf2

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SurfaceWaterBody_ID ( type: esriFieldTypeDouble, alias: Row ID, editable: true, nullable: false, defaultValue: null, modelName: SurfaceWaterBody_ID )
• SWB_ID ( type: esriFieldTypeDouble, alias: SWB ID, editable: true, nullable: false, defaultValue: null, modelName: SWB_ID )
• euSurfaceWaterBodyCode ( type: esriFieldTypeString, alias: EU SWB Code, editable: true, nullable: false, length: 42, defaultValue: null, modelName: euSurfaceWaterBodyCode )
• euSubUnitCode ( type: esriFieldTypeString, alias: EU Sub-unit Code, editable: true, nullable: true, length: 42, defaultValue: null, modelName: euSubUnitCode )
• surfaceWaterBodyCategory ( type: esriFieldTypeString, alias: SWB Category, editable: true, nullable: false, length: 3, defaultValue: null, modelName: surfaceWaterBodyCategory , Coded Values: [RW: River water body] , [LW: Lake water body] , [TW: Transitional water body] , ...2 more... )
• naturalAWBHMWB ( type: esriFieldTypeString, alias: SWB Condition, editable: true, nullable: false, length: 20, defaultValue: null, modelName: naturalAWBHMWB , Coded Values: [Natural: Natural] , [Artificial: Artificial] , [Heavily Modified: Heavily Modified] )
• reservoir ( type: esriFieldTypeString, alias: Reservoir, editable: true, nullable: true, length: 100, defaultValue: null, modelName: reservoir , Coded Values: [Reservoir in a water body that was originally a river / rivers: Reservoir in a water body that was originally a river / rivers] , [Reservoir in a water body that was originally a lake / lakes: Reservoir in a water body that was originally a lake / lakes] , [Reservoir in what were originally chained rivers and lakes: Reservoir in what were originally chained rivers and lakes] , ...2 more... )
• surfaceWaterBodyTypeCode ( type: esriFieldTypeString, alias: Member State code, editable: true, nullable: false, length: 100, defaultValue: null, modelName: surfaceWaterBodyTypeCode )
• surfaceWaterBodyTransboundary ( type: esriFieldTypeString, alias: SWB Transboundary, editable: true, nullable: false, length: 20, defaultValue: null, modelName: surfaceWaterBodyTransboundary , Coded Values: [Yes: True] , [No: False] , [Unknown: Unknown] )
• swSignificantPressureOther ( type: esriFieldTypeString, alias: Significant PressureType Other, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: swSignificantPressureOther )
• swSignificantImpactOther ( type: esriFieldTypeString, alias: Significant ImpactType Other, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: swSignificantImpactOther )
• swEcologicalStatusOrPotentialVa ( type: esriFieldTypeString, alias: Ecological status or potential, editable: true, nullable: false, length: 30, defaultValue: null, modelName: swEcologicalStatusOrPotentialValue , Coded Values: [1: High status] , [2: Good status or good or better potential] , [3: Moderate status or potential] , ...3 more... )
• swEcologicalAssessmentYear ( type: esriFieldTypeString, alias: Ecological Assessment Year, editable: true, nullable: false, length: 10, defaultValue: null, modelName: swEcologicalAssessmentYear )
• swEcologicalAssessmentConfidenc ( type: esriFieldTypeString, alias: Ecological Assessment Confidence, editable: true, nullable: false, length: 1, defaultValue: null, modelName: swEcologicalAssessmentConfidence , Coded Values: [0: No information] , [1: Low confidence] , [2: Medium confidence] , ...1 more... )
• swEcologicalStatusOrPotentialEx ( type: esriFieldTypeString, alias: Ecological Expected Achievement Date, editable: true, nullable: false, length: 50, defaultValue: null, modelName: swEcologicalStatusOrPotentialExpectedAchievementDate , Coded Values: [2021 or earlier: 2021 or earlier] , [2022--2027: 2022--2027] , [Beyond 2027: Beyond 2027] , ...2 more... )
• swChemicalStatusValue ( type: esriFieldTypeString, alias: SW Chemical Status Value, editable: true, nullable: false, length: 1, defaultValue: null, modelName: swChemicalStatusValue , Coded Values: [2: Good status] , [3: Failing to achieve good status] , [U: Unknown status] )
• swChemicalAssessmentYear ( type: esriFieldTypeString, alias: Chemical Assessment Year, editable: true, nullable: false, length: 10, defaultValue: null, modelName: swChemicalAssessmentYear )
• swChemicalAssessmentConfidence ( type: esriFieldTypeString, alias: Chemical Assessment Confidence, editable: true, nullable: false, length: 1, defaultValue: null, modelName: swChemicalAssessmentConfidence , Coded Values: [0: No information] , [1: Low confidence] , [2: Medium confidence] , ...1 more... )
• swChemicalMonitoringResults ( type: esriFieldTypeString, alias: Chemical Monitoring Results, editable: true, nullable: true, length: 35, defaultValue: null, modelName: swChemicalMonitoringResults , Coded Values: [Monitoring: Monitoring] , [Grouping: Grouping] , [Combination monitoring/grouping: Combination monitoring/grouping] , ...2 more... )
• swChemicalStatusExpectedAchieve ( type: esriFieldTypeString, alias: Chemical Status Expected Achievement Date, editable: true, nullable: false, length: 50, defaultValue: null, modelName: swChemicalStatusExpectedAchievementDate , Coded Values: [2021 or earlier: 2021 or earlier] , [2022--2027: 2022--2027] , [Beyond 2027: Beyond 2027] , ...2 more... )
• swMixingZones ( type: esriFieldTypeString, alias: Mixing Zones, editable: true, nullable: false, length: 15, defaultValue: null, modelName: swMixingZones , Coded Values: [Yes: Yes] , [No: No] , [No Information: No Information] )
• swMixingZonesProportion ( type: esriFieldTypeSmallInteger, alias: Mixing Zones Proportion, editable: true, nullable: true, defaultValue: null, modelName: swMixingZonesProportion )

Templates:

• Name: Surface Water Body
  Description:
  Prototype:
  swMixingZones:
  SurfaceWaterBody_ID: 0
  SWB_ID: 0
  euSurfaceWaterBodyCode:
  euSubUnitCode: null
  surfaceWaterBodyCategory:
  naturalAWBHMWB:
  reservoir: null
  surfaceWaterBodyTypeCode:
  surfaceWaterBodyTransboundary:
  swSignificantPressureOther: null
  swSignificantImpactOther: null
  swEcologicalStatusOrPotentialVa:
  swEcologicalAssessmentYear:
  swEcologicalAssessmentConfidenc:
  swEcologicalStatusOrPotentialEx:
  swChemicalStatusValue:
  swChemicalAssessmentYear:
  swChemicalAssessmentConfidence:
  swChemicalMonitoringResults: null
  swChemicalStatusExpectedAchieve:
  swMixingZonesProportion: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• QualityElement (81) -- Related To: SWB Quality Element (79)
• SWEcologicalExemptionType (93) -- Related To: SW Ecological Exemption Type (100)
• SurfaceWaterBodyLine (5) -- Related To: Surface Water Body Line (3)
• SWChemicalStatusGrouping (94) -- Related To: SW Chemical Status Grouping (99)
• surfaceWaterBodyIntercalibrationType (95) -- Related To: SWB IntercalibrationType (97)
• SurfaceWaterBody_a (12) -- Related To: Surface Water Body polygon (6)
• SWBhmwbWaterUse (96) -- Related To: SW HMWB Water Use (96)
• swSignificantImpactType (97) -- Related To: SW Significant Impact Types (104)
• SWBhmwbPhysicalAlteration (98) -- Related To: SW HMWB Physical Alteration (95)
• SWAssociatedProtectedArea (99) -- Related To: SW Associated Protected Area (93)
• swSignificantPressureType (100) -- Related To: SW Significant Pressure Types (105)
• swFailingRBSP (36) -- Related To: Failing RBSP (30)
• SWPrioritySubstance (101) -- Related To: SW Priority Substance (101)
• SurfaceWaterBodyCentreline (6) -- Related To: Surface Water Body Centreline (4)
• SWB (102) -- Related To: SWB (94)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata