{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 4,
 "name": "END_DF48_LatestSubmission_Status",
 "type": "Feature Layer",
 "description": "dbo.END_Submission_Status",
 "geometryType": "esriGeometryPolygon",
 "sourceSpatialReference": {
  "wkid": 102100,
  "latestWkid": 3857,
  "xyTolerance": 0.001,
  "zTolerance": 0.001,
  "mTolerance": 0.001,
  "falseX": -20037700,
  "falseY": -30241100,
  "xyUnits": 10000,
  "falseZ": -100000,
  "zUnits": 10000,
  "falseM": -100000,
  "mUnits": 10000
 },
 "spatialReference": {
  "wkid": 102100,
  "latestWkid": 3857,
  "xyTolerance": 0.001,
  "zTolerance": 0.001,
  "mTolerance": 0.001,
  "falseX": -20037700,
  "falseY": -30241100,
  "xyUnits": 10000,
  "falseZ": -100000,
  "zUnits": 10000,
  "falseM": -100000,
  "mUnits": 10000
 },
 "copyrightText": "",
 "parentLayer": null,
 "subLayers": [],
 "minScale": 0,
 "maxScale": 0,
 "referenceScale": 0.0,
 "drawingInfo": {
  "renderer": {
   "type": "uniqueValue",
   "valueExpression": "// DF48 OVERALL STATUS (filtered by declared sources + missing handling)\n\n// Define statuses by priority\nvar correction = \"CORRECTION_REQUESTED\";\nvar feedback = \"FINAL_FEEDBACK\";\nvar accepted = \"TECHNICALLY_ACCEPTED\";\n\n// Pair each DF48 field with its declaration flag\nvar sources = [\n    {status: $feature.DF48_MAir_status, declared: $feature.declarationMajorAirportSource},\n    {status: $feature.DF48_MRail_status, declared: $feature.declarationMajorRailwaySource},\n    {status: $feature.DF48_MRoad_status, declared: $feature.declarationMajorRoadSource},\n    {status: $feature.DF48_Agg_status, declared: $feature.declarationAgglomerationSource}\n];\n\n// Track flags\nvar hasCorrection = false;\nvar hasFeedback = false;\nvar hasMissing = false;\nvar isComplete = true;\n\nfor (var i in sources) {\n    var src = sources[i];\n    var declared = Upper(Trim(Text(src.declared))) == \"YES\";\n    if (!declared) continue;\n    var val = Trim(Text(src.status));\n    if (IsEmpty(val)) {\n        hasMissing = true;\n        isComplete = false;\n        continue;\n    }\n    val = Upper(val);\n    if (val == correction) {\n        hasCorrection = true;\n        break; // Most restrictive, stop here\n    } else if (val == feedback) {\n        hasFeedback = true;\n    } else if(val!=accepted){\n        isComplete = false;\n    }\n}\n\n// Decide overall result based on priority\nif (hasCorrection) {\n    return \"Correction requested\";\n} else if (hasFeedback) {\n    return \"Final feedback\";\n} else if (hasMissing) {\n    return \"Incomplete\";\n} else if (isComplete && $feature.DF48_Complete==100) {\n    return \"Complete\";\n} else {\n    return \"Pending - not submitted\"; // optional fallback\n}",
   "valueExpressionTitle": "DF48_Overall_status",
   "uniqueValueGroups": [
    {
     "heading": "DF48_Overall_status",
     "classes": [
      {
       "label": "Complete",
       "description": "Complete",
       "symbol": {
        "type": "esriSFS",
        "style": "esriSFSSolid",
        "color": [
         0,
         82,
         71,
         255
        ],
        "outline": null
       },
       "values": [
        [
         "Complete"
        ]
       ]
      },
      {
       "label": "Correction requested",
       "description": "Correction requested",
       "symbol": {
        "type": "esriSFS",
        "style": "esriSFSSolid",
        "color": [
         195,
         85,
         39,
         255
        ],
        "outline": null
       },
       "values": [
        [
         "Correction requested"
        ]
       ]
      },
      {
       "label": "Incomplete",
       "description": "Incomplete",
       "symbol": {
        "type": "esriSFS",
        "style": "esriSFSSolid",
        "color": [
         252,
         232,
         192,
         255
        ],
        "outline": null
       },
       "values": [
        [
         "Incomplete"
        ]
       ]
      },
      {
       "label": "Pending - not submitted",
       "description": "Pending - not submitted",
       "symbol": {
        "type": "esriSFS",
        "style": "esriSFSSolid",
        "color": [
         212,
         212,
         212,
         255
        ],
        "outline": null
       },
       "values": [
        [
         "Pending - not submitted"
        ]
       ]
      }
     ]
    }
   ],
   "uniqueValueInfos": [
    {
     "symbol": {
      "type": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       0,
       82,
       71,
       255
      ],
      "outline": null
     },
     "value": "Complete",
     "label": "Complete"
    },
    {
     "symbol": {
      "type": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       195,
       85,
       39,
       255
      ],
      "outline": null
     },
     "value": "Correction requested",
     "label": "Correction requested"
    },
    {
     "symbol": {
      "type": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       252,
       232,
       192,
       255
      ],
      "outline": null
     },
     "value": "Incomplete",
     "label": "Incomplete"
    },
    {
     "symbol": {
      "type": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       212,
       212,
       212,
       255
      ],
      "outline": null
     },
     "value": "Pending - not submitted",
     "label": "Pending - not submitted"
    }
   ],
   "fieldDelimiter": ",",
   "authoringInfo": {
    "colorRamp": {
     "type": "multipart",
     "colorRamps": [
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        202,
        252,
        206,
        255
       ],
       "toColor": [
        202,
        252,
        206,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        228,
        179,
        252,
        255
       ],
       "toColor": [
        228,
        179,
        252,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        252,
        197,
        184,
        255
       ],
       "toColor": [
        252,
        197,
        184,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        189,
        221,
        252,
        255
       ],
       "toColor": [
        189,
        221,
        252,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        252,
        215,
        247,
        255
       ],
       "toColor": [
        252,
        215,
        247,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        252,
        245,
        179,
        255
       ],
       "toColor": [
        252,
        245,
        179,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        187,
        252,
        250,
        255
       ],
       "toColor": [
        187,
        252,
        250,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        184,
        189,
        252,
        255
       ],
       "toColor": [
        184,
        189,
        252,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        252,
        244,
        212,
        255
       ],
       "toColor": [
        252,
        244,
        212,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        217,
        252,
        179,
        255
       ],
       "toColor": [
        217,
        252,
        179,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        252,
        189,
        212,
        255
       ],
       "toColor": [
        252,
        189,
        212,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        252,
        182,
        236,
        255
       ],
       "toColor": [
        252,
        182,
        236,
        255
       ]
      },
      {
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm",
       "fromColor": [
        180,
        252,
        179,
        255
       ],
       "toColor": [
        180,
        252,
        179,
        255
       ]
      }
     ]
    }
   }
  },
  "scaleSymbols": true,
  "transparency": 0,
  "labelingInfo": null
 },
 "defaultVisibility": false,
 "extent": {
  "xmin": -7029958.048800001,
  "ymin": -2438312.6744000018,
  "xmax": 6215609.012999998,
  "ymax": 1.1464514069E7,
  "spatialReference": {
   "wkid": 102100,
   "latestWkid": 3857,
   "xyTolerance": 0.001,
   "zTolerance": 0.001,
   "mTolerance": 0.001,
   "falseX": -20037700,
   "falseY": -30241100,
   "xyUnits": 10000,
   "falseZ": -100000,
   "zUnits": 10000,
   "falseM": -100000,
   "mUnits": 10000
  }
 },
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
 "displayField": "countryName",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "countryCode",
   "type": "esriFieldTypeString",
   "alias": "countryCode",
   "length": 3,
   "domain": null
  },
  {
   "name": "reportingCycle",
   "type": "esriFieldTypeString",
   "alias": "reportingCycle",
   "length": 200,
   "domain": null
  },
  {
   "name": "declarationAgglomerationSource",
   "type": "esriFieldTypeString",
   "alias": "declarationAgglomerationSource",
   "length": 255,
   "domain": null
  },
  {
   "name": "declarationMajorRoadSource",
   "type": "esriFieldTypeString",
   "alias": "declarationMajorRoadSource",
   "length": 255,
   "domain": null
  },
  {
   "name": "declarationMajorRailwaySource",
   "type": "esriFieldTypeString",
   "alias": "declarationMajorRailwaySource",
   "length": 255,
   "domain": null
  },
  {
   "name": "declarationMajorAirportSource",
   "type": "esriFieldTypeString",
   "alias": "declarationMajorAirportSource",
   "length": 255,
   "domain": null
  },
  {
   "name": "DF15_Complete",
   "type": "esriFieldTypeSmallInteger",
   "alias": "DF15_Complete",
   "domain": null
  },
  {
   "name": "DF48_Complete",
   "type": "esriFieldTypeSmallInteger",
   "alias": "DF48_Complete",
   "domain": null
  },
  {
   "name": "DF48_Accepted",
   "type": "esriFieldTypeSmallInteger",
   "alias": "DF48_Accepted",
   "domain": null
  },
  {
   "name": "DF15_status",
   "type": "esriFieldTypeString",
   "alias": "DF15_status",
   "length": 100,
   "domain": null
  },
  {
   "name": "DF48_MAir_status",
   "type": "esriFieldTypeString",
   "alias": "DF48_MAir_status",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "DF48_MRail_status",
   "type": "esriFieldTypeString",
   "alias": "DF48_MRail_status",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "DF48_MRoad_status",
   "type": "esriFieldTypeString",
   "alias": "DF48_MRoad_status",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "DF48_Agg_status",
   "type": "esriFieldTypeString",
   "alias": "DF48_Agg_status",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "DF15_ReleaseDate",
   "type": "esriFieldTypeDate",
   "alias": "DF15_ReleaseDate",
   "length": 8,
   "precision": 1,
   "domain": null
  },
  {
   "name": "DF48_Agg_ReleaseDate",
   "type": "esriFieldTypeString",
   "alias": "DF48_Agg_ReleaseDate",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "DF48_Air_ReleaseDate",
   "type": "esriFieldTypeString",
   "alias": "DF48_Air_ReleaseDate",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "DF48_Rail_ReleaseDate",
   "type": "esriFieldTypeString",
   "alias": "DF48_Rail_ReleaseDate",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "DF48_Road_ReleaseDate",
   "type": "esriFieldTypeString",
   "alias": "DF48_Road_ReleaseDate",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "countryName",
   "type": "esriFieldTypeString",
   "alias": "countryName",
   "length": 50,
   "domain": null
  },
  {
   "name": "eeaGroup",
   "type": "esriFieldTypeString",
   "alias": "eeaGroup",
   "length": 50,
   "domain": null
  },
  {
   "name": "eurostatGroup",
   "type": "esriFieldTypeString",
   "alias": "eurostatGroup",
   "length": 50,
   "domain": null
  },
  {
   "name": "CNTR_ID",
   "type": "esriFieldTypeString",
   "alias": "CNTR_ID",
   "length": 2147483647,
   "domain": null
  },
  {
   "name": "EU_STAT",
   "type": "esriFieldTypeString",
   "alias": "EU_STAT",
   "length": 2147483647,
   "domain": null
  },
  {
   "name": "EFTA_STAT",
   "type": "esriFieldTypeString",
   "alias": "EFTA_STAT",
   "length": 2147483647,
   "domain": null
  },
  {
   "name": "CC_STAT",
   "type": "esriFieldTypeString",
   "alias": "CC_STAT",
   "length": 2147483647,
   "domain": null
  },
  {
   "name": "GEOM",
   "type": "esriFieldTypeGeometry",
   "alias": "GEOM",
   "domain": null
  },
  {
   "name": "ESRI_OID",
   "type": "esriFieldTypeOID",
   "alias": "ESRI_OID",
   "length": 8,
   "domain": null
  },
  {
   "name": "GEOM_Length",
   "type": "esriFieldTypeDouble",
   "alias": "GEOM_Length",
   "domain": null
  },
  {
   "name": "GEOM_Area",
   "type": "esriFieldTypeDouble",
   "alias": "GEOM_Area",
   "domain": null
  }
 ],
 "geometryField": {
  "name": "GEOM",
  "type": "esriFieldTypeGeometry",
  "alias": "GEOM"
 },
 "indexes": [
  {
   "name": "FDO_ESRI_OID",
   "fields": "ESRI_OID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "FDO_GEOM",
   "fields": "GEOM",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "canModifyLayer": true,
 "canScaleSymbols": false,
 "hasLabels": false,
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "maxSelectionCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "isDataVersioned": false,
 "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
 "useStandardizedQueries": true,
 "supportedSpatialRelationships": [
  "esriSpatialRelIntersects",
  "esriSpatialRelContains",
  "esriSpatialRelCrosses",
  "esriSpatialRelEnvelopeIntersects",
  "esriSpatialRelIndexIntersects",
  "esriSpatialRelOverlaps",
  "esriSpatialRelTouches",
  "esriSpatialRelWithin",
  "esriSpatialRelRelation"
 ],
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsPagination": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsTrueCurve": true,
  "supportsQueryWithDatumTransformation": true,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": false,
  "supportsCurrentUserQueries": true
 },
 "supportsDatumTransformation": true,
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasGeometryProperties": true,
 "geometryProperties": {
  "shapeAreaFieldName": "GEOM_Area",
  "shapeLengthFieldName": "GEOM_Length",
  "units": "esriMeters",
  "mapUnits": {"uwkid": 9001}
 },
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsCoordinatesQuantization": true,
 "supportsDynamicLegends": true,
 "serviceItemId": "774c20e38b1a4379882351da5f89389f"
}