{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "wrl_cntry_data_t_unhcr", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "update_date", "editorField": "update_by" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "gis_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "iso3", "type": "esriFieldTypeString", "alias": "Country territory (ISO3)", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": "AAA", "modelName": "iso3" }, { "name": "gis_name", "type": "esriFieldTypeString", "alias": "gis_name", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "gis_name" }, { "name": "ref_conv_1951", "type": "esriFieldTypeSmallInteger", "alias": "Refugee Convention 1951", "domain": { "type": "codedValue", "name": "status", "description": "Status", "codedValues": [ { "name": "Inactive", "code": 13 }, { "name": "Active", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 13, "modelName": "ref_conv_1951" }, { "name": "ref_conv_1951_date", "type": "esriFieldTypeDate", "alias": "ref_conv_1951_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ref_conv_1951_date" }, { "name": "ref_prot_1967", "type": "esriFieldTypeSmallInteger", "alias": "Refugee Protocol 1967", "domain": { "type": "codedValue", "name": "status", "description": "Status", "codedValues": [ { "name": "Inactive", "code": 13 }, { "name": "Active", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 13, "modelName": "ref_prot_1967" }, { "name": "ref_prot_1967_date", "type": "esriFieldTypeDate", "alias": "ref_prot_1967_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ref_prot_1967_date" }, { "name": "ref_conv_prot_note", "type": "esriFieldTypeString", "alias": "Notes on Refugee Convention and Protocol", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ref_conv_prot_note" }, { "name": "sta_conv_1954", "type": "esriFieldTypeSmallInteger", "alias": "Stateless Convention 1954", "domain": { "type": "codedValue", "name": "status", "description": "Status", "codedValues": [ { "name": "Inactive", "code": 13 }, { "name": "Active", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 13, "modelName": "sta_conv_1954" }, { "name": "sta_conv_1954_date", "type": "esriFieldTypeDate", "alias": "sta_conv_1954_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "sta_conv_1954_date" }, { "name": "sta_conv_1961", "type": "esriFieldTypeSmallInteger", "alias": "Stateless Convention 1961", "domain": { "type": "codedValue", "name": "status", "description": "Status", "codedValues": [ { "name": "Inactive", "code": 13 }, { "name": "Active", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 13, "modelName": "sta_conv_1961" }, { "name": "sta_conv_1961_date", "type": "esriFieldTypeDate", "alias": "sta_conv_1961_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "sta_conv_1961_date" }, { "name": "sta_conv_prot_note", "type": "esriFieldTypeString", "alias": "Notes on Stateless Convention", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "sta_conv_prot_note" }, { "name": "unhcr_region", "type": "esriFieldTypeString", "alias": "unhcr_region", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "unhcr_region" }, { "name": "region", "type": "esriFieldTypeString", "alias": "region", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "region" }, { "name": "subregion", "type": "esriFieldTypeString", "alias": "subregion", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "subregion" }, { "name": "code_op", "type": "esriFieldTypeString", "alias": "code_op", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "code_op" }, { "name": "excom", "type": "esriFieldTypeSmallInteger", "alias": "excom", "domain": { "type": "codedValue", "name": "status", "description": "Status", "codedValues": [ { "name": "Inactive", "code": 13 }, { "name": "Active", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 13, "modelName": "excom" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "comments" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "region_pcode", "type": "esriFieldTypeString", "alias": "region_pcode", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "region_pcode" }, { "name": "m49code", "type": "esriFieldTypeSmallInteger", "alias": "m49code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "m49code" }, { "name": "short_name_en", "type": "esriFieldTypeString", "alias": "short_name_en", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "short_name_en" }, { "name": "short_name_sp", "type": "esriFieldTypeString", "alias": "short_name_sp", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "short_name_sp" }, { "name": "short_name_ar", "type": "esriFieldTypeString", "alias": "short_name_ar", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "short_name_ar" }, { "name": "short_name_fr", "type": "esriFieldTypeString", "alias": "short_name_fr", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "short_name_fr" }, { "name": "short_name_ru", "type": "esriFieldTypeString", "alias": "short_name_ru", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "short_name_ru" }, { "name": "short_name_ch", "type": "esriFieldTypeString", "alias": "short_name_ch", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "short_name_ch" }, { "name": "m49_region", "type": "esriFieldTypeString", "alias": "m49_region", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "m49_region" }, { "name": "m49_region_group", "type": "esriFieldTypeString", "alias": "m49_region_group", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "m49_region_group" }, { "name": "m49_sub_region", "type": "esriFieldTypeString", "alias": "m49_sub_region", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "m49_sub_region" }, { "name": "hcr3", "type": "esriFieldTypeString", "alias": "hcr3", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "hcr3" }, { "name": "color_code", "type": "esriFieldTypeString", "alias": "color_code", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "color_code" }, { "name": "territory", "type": "esriFieldTypeSmallInteger", "alias": "territory", "domain": { "type": "codedValue", "name": "yes_no", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 60 }, { "name": "Yes", "code": 61 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "territory" }, { "name": "entity_last_update", "type": "esriFieldTypeDate", "alias": "entity_last_update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "entity_last_update" } ], "indexes": [ { "name": "r53_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_53", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_oid_53", "fields": "globalid,objectid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "wrl_cntry_data_t_unhcr", "description": "", "prototype": { "attributes": { "color_code": null, "territory": null, "iso3": "AAA", "gis_name": null, "ref_conv_1951": 13, "ref_conv_1951_date": null, "ref_prot_1967": 13, "ref_prot_1967_date": null, "ref_conv_prot_note": null, "sta_conv_1954": 13, "sta_conv_1954_date": null, "sta_conv_1961": 13, "sta_conv_1961_date": null, "sta_conv_prot_note": null, "unhcr_region": null, "region": null, "subregion": null, "code_op": null, "excom": 13, "comments": null, "entity_last_update": null, "region_pcode": null, "m49code": null, "short_name_en": null, "short_name_sp": null, "short_name_ar": null, "short_name_fr": null, "short_name_ru": null, "short_name_ch": null, "m49_region": null, "m49_region_group": null, "m49_sub_region": null, "hcr3": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }