{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 32, "name": "RBM_FRM.DBO.FHRM_HazardAreaFloodMechanism", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "META_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "META_ID", "type": "esriFieldTypeString", "alias": "META ID", "length": 64, "domain": null }, { "name": "COUNTRY", "type": "esriFieldTypeString", "alias": "Country Code", "length": 3, "domain": { "type": "codedValue", "name": "ISO3166_CD", "description": "", "codedValues": [ { "name": "Albania", "code": "AL" }, { "name": "Austria", "code": "AT" }, { "name": "Bosnia and Herzegovina", "code": "BA" }, { "name": "Bulgaria", "code": "BG" }, { "name": "Croatia", "code": "HR" }, { "name": "Czech Republic", "code": "CZ" }, { "name": "Germany", "code": "DE" }, { "name": "Hungary", "code": "HU" }, { "name": "Italy", "code": "IT" }, { "name": "Moldova, Republic of", "code": "MD" }, { "name": "Montenegro", "code": "ME" }, { "name": "Poland", "code": "PL" }, { "name": "Romania", "code": "RO" }, { "name": "Serbia", "code": "RS" }, { "name": "Slovakia", "code": "SK" }, { "name": "Slovenia", "code": "SI" }, { "name": "Switzerland", "code": "CH" }, { "name": "Ukarine", "code": "UA" }, { "name": "North Macedonia", "code": "MK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BIHENTITY", "type": "esriFieldTypeString", "alias": "B&H Entity", "length": 4, "domain": { "type": "codedValue", "name": "BIHEntity", "description": "", "codedValues": [ { "name": "Federation of BIH", "code": "FBIH" }, { "name": "Republic of Srpska", "code": "RS" }, { "name": "BrĨko District", "code": "BD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RBMP_YEAR", "type": "esriFieldTypeInteger", "alias": "RBMP Year", "domain": { "type": "codedValue", "name": "RBMP_Year", "description": "", "codedValues": [ { "name": "RBMP 2016-2021.", "code": 2015 }, { "name": "RBMP 2022-2027.", "code": 2021 }, { "name": "RBMP 2028-2033.", "code": 2027 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FRMP_YEAR", "type": "esriFieldTypeInteger", "alias": "FRMP Year", "domain": { "type": "codedValue", "name": "FRMP_Year", "description": "", "codedValues": [ { "name": "FRMP 2022-2027.", "code": 2021 }, { "name": "FRMP 2028-2033.", "code": 2027 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WORK_STAT", "type": "esriFieldTypeInteger", "alias": "Working Status", "domain": { "type": "codedValue", "name": "WorkStatus", "description": "", "codedValues": [ { "name": "Active", "code": 0 }, { "name": "Working", "code": 1 }, { "name": "Passive", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACT_STAT", "type": "esriFieldTypeInteger", "alias": "Active Status", "domain": null }, { "name": "DATA_DATE", "type": "esriFieldTypeDate", "alias": "Date of data", "length": 8, "domain": null }, { "name": "INS_WHEN", "type": "esriFieldTypeDate", "alias": "Insert date", "length": 8, "domain": null }, { "name": "INS_BY", "type": "esriFieldTypeString", "alias": "Inserted by", "length": 30, "domain": null }, { "name": "HFMECH_ID", "type": "esriFieldTypeDouble", "alias": "Row ID", "domain": null }, { "name": "FHA_ID", "type": "esriFieldTypeDouble", "alias": "FHA ID", "domain": null }, { "name": "EUCD_FHA", "type": "esriFieldTypeString", "alias": "EU FHA code", "length": 42, "domain": null }, { "name": "FLOOD_MECH", "type": "esriFieldTypeString", "alias": "Flood Mechanism", "length": 3, "domain": { "type": "codedValue", "name": "FloodMechanism", "description": "", "codedValues": [ { "name": "Natural Exceedance", "code": "A21" }, { "name": "Defence Exceedance", "code": "A22" }, { "name": "Defence or Infrastructural Failure", "code": "A23" }, { "name": "Blockage / Restriction", "code": "A24" }, { "name": "Other, Flooding of land by water due to other mechanisms", "code": "A25" }, { "name": "No data available on the mechanism of flooding", "code": "A26" }, { "name": "Mechanism of flooding uncertain", "code": "A27" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OTH_MECH", "type": "esriFieldTypeString", "alias": "Description for Other", "length": 1000, "domain": null }, { "name": "MechUncertainDesc", "type": "esriFieldTypeString", "alias": "Mech Uncertain Desc", "length": 1000, "domain": null } ], "indexes": [ { "name": "R14_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G107FHA_ID", "fields": "FHA_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "Hazard Area", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "FHA_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "779d9faf75b94bd08ceb6e6f31de7a6b" }