{ "tables": [ { "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "MDR_Template_Non_Technical_Survey_audience_repeat", "relatedTableId": 0, "id": "0", "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "audience_repeat_individual_repeat", "relatedTableId": 2, "id": "2", "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.2, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "audience_repeat", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniquerowid", "length": 38, "alias": "RowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_aud_id", "type": "codedValue", "codedValues": [ { "code": "audience_id_1", "name": "Audience ID 1" }, { "code": "audience_id_2", "name": "Audience ID 2" } ] }, "name": "aud_id", "length": 255, "alias": "Audience ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_sect", "type": "codedValue", "codedValues": [ { "code": "section_1", "name": "DPTS" }, { "code": "section_2", "name": "DGPN" }, { "code": "section_3", "name": "ENP" }, { "code": "section_4", "name": "DSE" }, { "code": "section_5", "name": "MSECU" }, { "code": "section_6", "name": "CPFC" }, { "code": "section_7", "name": "DRC" }, { "code": "section_8", "name": "AVAD" }, { "code": "section_9", "name": "HELP" }, { "code": "section_10", "name": "OCADES" }, { "code": "section_11", "name": "DRAAH-CN" }, { "code": "section_12", "name": "ICAHD" }, { "code": "section_13", "name": "PLAN" } ] }, "name": "sect", "length": 255, "alias": "Section (Dept.)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_org_type", "type": "codedValue", "codedValues": [ { "code": "org_type_1", "name": "UN" }, { "code": "org_type_2", "name": "NGO" }, { "code": "org_type_3", "name": "Government" }, { "code": "org_type_4", "name": "Other" } ] }, "name": "org_type", "length": 255, "alias": "The Type (category) of organization.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_organisation_subtype", "type": "codedValue", "codedValues": [ { "code": "organisation_subtype_1", "name": "CCP-O" }, { "code": "organisation_subtype_2", "name": "CPA Baskuy" }, { "code": "organisation_subtype_3", "name": "CPA BGD" }, { "code": "organisation_subtype_4", "name": "CPA Ouaga2000" }, { "code": "organisation_subtype_5", "name": "CPA SNG" }, { "code": "organisation_subtype_6", "name": "CPA-BLMG" }, { "code": "organisation_subtype_7", "name": "CPA-NonGr-Mâasom" }, { "code": "organisation_subtype_8", "name": "DGPN" }, { "code": "organisation_subtype_9", "name": "DPTS" }, { "code": "organisation_subtype_10", "name": "IMF" }, { "code": "organisation_subtype_11", "name": "PN Région Kaya" }, { "code": "organisation_subtype_12", "name": "Police-Secours CCP-O" }, { "code": "organisation_subtype_13", "name": "SRCSR" }, { "code": "organisation_subtype_14", "name": "SRSCR-C" }, { "code": "organisation_subtype_15", "name": "UNDP" }, { "code": "organisation_subtype_16", "name": "UNDSS" }, { "code": "organisation_subtype_17", "name": "UNFPA" }, { "code": "organisation_subtype_18", "name": "UNICEF" }, { "code": "organisation_subtype_19", "name": "WFP" }, { "code": "organisation_subtype_20", "name": "WHO" }, { "code": "organisation_subtype_21", "name": "World Bank" } ] }, "name": "organisation_subtype", "length": 255, "alias": "The sub-Type of organization.", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "org_trained", "length": 255, "alias": "Organization trained", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "start_dt", "length": 29, "alias": "Operational start date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "end_dt", "length": 29, "alias": "Operational end date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_training_cat", "type": "codedValue", "codedValues": [ { "code": "training_cat_1", "name": "IED Threat Mitigation" }, { "code": "training_cat_2", "name": "EOD" }, { "code": "training_cat_3", "name": "Safety / Security" }, { "code": "training_cat_4", "name": "Other" } ] }, "name": "training_cat", "length": 255, "alias": "Category of training", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_training_sub", "type": "codedValue", "codedValues": [ { "code": "training_sub_1", "name": "FoFo_Sensi" }, { "code": "training_sub_2", "name": "SensiEEI" }, { "code": "training_sub_3", "name": "IFAK" } ] }, "name": "training_sub", "length": 255, "alias": "Subtype of training", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ben_female_adult", "alias": "Direct female adult beneficiaries", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ben_male_adult", "alias": "Direct male adult beneficiaries", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ben_female_child", "alias": "Direct female children beneficiaries", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ben_male_child", "alias": "Direct male children beneficiaries", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trainees_passed", "alias": "Trainees passed", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trainees_failed", "alias": "Trainees failed", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_trained", "alias": "Total Trained (auto-calculation)", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "r1110_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1110", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "ad34d0edda75428ba5f67f0c6f5fc1b1", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Sync,Query,Extract,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true }, { "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "audience_repeat_individual_repeat", "relatedTableId": 1, "id": "2", "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.2, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "individual_repeat", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "f_name", "length": 255, "alias": "First Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "s_name", "length": 255, "alias": "Surname", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_sex", "type": "codedValue", "codedValues": [ { "code": "gender_1", "name": "Male" }, { "code": "gender_2", "name": "Female" }, { "code": "gender_3", "name": "Other" } ] }, "name": "sex", "length": 255, "alias": "Gender", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_func", "type": "codedValue", "codedValues": [ { "code": "function_1", "name": "Account Associate" }, { "code": "function_2", "name": "Adjudant de Police" }, { "code": "function_3", "name": "Admin" }, { "code": "function_4", "name": "Administrateur de Programme" }, { "code": "function_5", "name": "Archiviste" }, { "code": "function_6", "name": "Assistant Com." }, { "code": "function_7", "name": "Assistant Terrain" }, { "code": "function_8", "name": "Assistante" }, { "code": "function_9", "name": "Assistante Admin." }, { "code": "function_10", "name": "Assistante Prog." }, { "code": "function_11", "name": "CCP-O" }, { "code": "function_12", "name": "Chargé de programme" }, { "code": "function_13", "name": "Chargée de Programme" }, { "code": "function_14", "name": "Chauffeur" }, { "code": "function_15", "name": "Chef de Division de la Medecine Legale/DPTS" }, { "code": "function_16", "name": "Chef de projet" }, { "code": "function_17", "name": "Chef d'encadrement technique" }, { "code": "function_18", "name": "Chef du Service de Securite et de Protection" }, { "code": "function_19", "name": "Cheffe du Service des Incendies et Explosifs" }, { "code": "function_20", "name": "Comite de Pilotage de la Formation Continue" }, { "code": "function_21", "name": "Commissaire de Police-Comité de Pilotage de la Formation Continue" }, { "code": "function_22", "name": "Commissaire Médecin - DGPN" }, { "code": "function_23", "name": "Communication Officer" }, { "code": "function_24", "name": "CPA" }, { "code": "function_25", "name": "CPA SNG" }, { "code": "function_26", "name": "Dep. Rep. Operations" }, { "code": "function_27", "name": "Direction de la Surete de l'Etat(DSE)" }, { "code": "function_28", "name": "Driver" }, { "code": "function_29", "name": "Executive Assistant" }, { "code": "function_30", "name": "Finance" }, { "code": "function_31", "name": "Finance Specialist" }, { "code": "function_32", "name": "FSA" }, { "code": "function_33", "name": "Governance Specialist" }, { "code": "function_34", "name": "Hact" }, { "code": "function_35", "name": "ICT Specialist" }, { "code": "function_36", "name": "Innovation Officer" }, { "code": "function_37", "name": "Lieutenant de Police - Com Formation Continue" }, { "code": "function_38", "name": "Lieutenant de Police-CPA Ouaga2000" }, { "code": "function_39", "name": "Local Security Officer" }, { "code": "function_40", "name": "Monitoring Assistant" }, { "code": "function_41", "name": "NPO /Jeunes" }, { "code": "function_42", "name": "NPO /SR-PF" }, { "code": "function_43", "name": "Ocades" }, { "code": "function_44", "name": "Ocades B'Ayaym" }, { "code": "function_45", "name": "Opérateur Radio" }, { "code": "function_46", "name": "Operations Assistant" }, { "code": "function_47", "name": "OPS/ICT" }, { "code": "function_48", "name": "Point focal WFP" }, { "code": "function_49", "name": "Police Secours" }, { "code": "function_50", "name": "Prog. Assocoate" }, { "code": "function_51", "name": "Programme Associate" }, { "code": "function_52", "name": "R AdmFin" }, { "code": "function_53", "name": "Représentant" }, { "code": "function_54", "name": "Security Coordinator" }, { "code": "function_55", "name": "Senior Driver" }, { "code": "function_56", "name": "Senior Executive Assistant" }, { "code": "function_57", "name": "Sergent de Police" }, { "code": "function_58", "name": "Sergent de Police-CPA-BLMG" }, { "code": "function_59", "name": "Sergent de Police-Police-Secours CCP/O" }, { "code": "function_60", "name": "Sergent de Police-SRCSR-C" }, { "code": "function_61", "name": "Sergent de Police-SRSCR-C" }, { "code": "function_62", "name": "Sergent-chef de Police-Police-Secours CCP-O" }, { "code": "function_63", "name": "Sergent-chef de Police-SRCSR" }, { "code": "function_64", "name": "Sergent-chef de Police-SRSCR-C" }, { "code": "function_65", "name": "Service de Perfectionnement des Formateurs/ENP" }, { "code": "function_66", "name": "Service de Securite au Ministere de la Securite (SS/MSECU)" }, { "code": "function_67", "name": "Service de Securite et de Protection" }, { "code": "function_68", "name": "Sous-lieutenant de Police-CPA Baskuy" }, { "code": "function_69", "name": "Sous-lieutenant de Police-CPA BGD" }, { "code": "function_70", "name": "Sr Finance Associate" }, { "code": "function_71", "name": "Stagiaire" }, { "code": "function_72", "name": "Suivi évaluation" }, { "code": "function_73", "name": "Superviseur" }, { "code": "function_74", "name": "WASH Officer" } ] }, "name": "func", "length": 255, "alias": "Function", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_grd", "type": "codedValue", "codedValues": [ { "code": "grade_1", "name": "Commissaire de Police" }, { "code": "grade_2", "name": "Lieutenant de Police" }, { "code": "grade_3", "name": "Sergent-Chef de Police" }, { "code": "grade_4", "name": "Sous-Lieutenant de Police" }, { "code": "grade_5", "name": "Capitaine de Police" }, { "code": "grade_6", "name": "Sergent de Police" }, { "code": "grade_7", "name": "Adjudant de Police" } ] }, "name": "grd", "length": 255, "alias": "Grade", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_lev", "type": "codedValue", "codedValues": [ { "code": "level_1", "name": "Level 1" }, { "code": "level_2", "name": "Level 2" } ] }, "name": "lev", "length": 255, "alias": "Level", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contact", "length": 255, "alias": "contact", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "r1111_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1111", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "ad34d0edda75428ba5f67f0c6f5fc1b1", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Sync,Query,Extract,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true }, { "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "MDR_Template_Non_Technical_Survey_image_rep", "relatedTableId": 0, "id": "1", "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.2, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "image_rep", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "re_image_file", "length": 255, "alias": "File Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": true, "indexes": [ { "name": "r1112_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1112", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "ad34d0edda75428ba5f67f0c6f5fc1b1", "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Sync,Query,Extract,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true } ], "layers": [ { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "MDR_Template_Non_Technical_Survey_audience_repeat", "relatedTableId": 1, "id": "0", "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "MDR_Template_Non_Technical_Survey_image_rep", "relatedTableId": 3, "id": "1", "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.2, "hasZ": false, "objectIdField": "objectid", "timeInfo": { "startTimeField": "survey_start_dt", "trackIdField": null, "endTimeField": "survey_end_dt", "timeInterval": 0, "timeExtent": [], "timeReference": { "timeZone": "UTC", "respectDaylightSaving": false }, "hasLiveData": false, "timeIntervalUnits": "esriTimeUnitsMilliseconds" }, "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "MDR_Template_Non_Technical_Survey", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniquerowid", "length": 38, "alias": "RowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "training_id", "length": 255, "alias": "Training ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "report_dt", "length": 29, "alias": "Training report date and time", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_funding_type", "type": "codedValue", "codedValues": [ { "code": "vtf", "name": "VTF (UN Voluntary Trust Fund)" }, { "code": "eu_vtf", "name": "EU VTF (European Union Voluntary Trust Fund)" }, { "code": "ab", "name": "AB (UN Assessed Budget)" }, { "code": "cerf", "name": "CERF (Central Emergency Reponse Fund)" }, { "code": "undp", "name": "UNDP (UN Development Program)" }, { "code": "rb", "name": "RB (DPA Regular Budget)" }, { "code": "ocha", "name": "OCHA (Office for the Coordination of Humanitarian Affairs)" }, { "code": "mptf", "name": "MPTF (Multi Partner Trust Fund)" }, { "code": "other", "name": "Other" } ] }, "name": "funding_type", "length": 255, "alias": "Funding source (type of funding)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_vtf_country", "type": "codedValue", "codedValues": [ { "code": "un", "name": "United Nations" }, { "code": "eu", "name": "European Union (DEVCO)" }, { "code": "australia", "name": "Government of Australia" }, { "code": "canada", "name": "Government of Canada" }, { "code": "czech", "name": "Government of Czech Republic" }, { "code": "denmark", "name": "Government of Denmark" }, { "code": "estonia", "name": "Government of Estonia" }, { "code": "finland", "name": "Government of Finland" }, { "code": "italy", "name": "Government of Italy" }, { "code": "germany", "name": "Government of Germany" }, { "code": "japan", "name": "Government of Japan" }, { "code": "luxembourg", "name": "Government of Luxembourg" }, { "code": "norway", "name": "Government of Norway" }, { "code": "portugal", "name": "Government of Portugal" }, { "code": "south_korea", "name": "Government of South Korea" }, { "code": "sweden", "name": "Government of Sweden (SIDA)" }, { "code": "switzerland", "name": "Government of Switzerland" }, { "code": "uk", "name": "Government of UK (DFID)" }, { "code": "usa", "name": "Government of USA (USAID)" }, { "code": "other", "name": "Other" } ] }, "name": "vtf_country", "length": 255, "alias": "Select VTF Country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_funding_source", "type": "codedValue", "codedValues": [ { "code": "minurso", "name": "MINURSO" }, { "code": "unops", "name": "UNOPS" } ] }, "name": "funding_source", "length": 255, "alias": "Funding source (original donors)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 255, "alias": "Description / comments", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_country", "type": "codedValue", "codedValues": [ { "code": "Mauretania", "name": "Mauretania" }, { "code": "Burkina Faso", "name": "Burkina Faso" }, { "code": "Morocco", "name": "Morocco" }, { "code": "Algeria", "name": "Algeria" }, { "code": "Western Sahara", "name": "Western Sahara" } ] }, "name": "country", "length": 255, "alias": "Country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region", "length": 255, "alias": "Region", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "province", "length": 255, "alias": "Province", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "department", "length": 255, "alias": "Department", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_src_coordnts", "type": "codedValue", "codedValues": [ { "code": "src_coordnts_1", "name": "GPS recorded on the spot" }, { "code": "src_coordnts_2", "name": "GPS recorded closeby" }, { "code": "src_coordnts_3", "name": "reported by unit on the ground without GPS" }, { "code": "src_coordnts_4", "name": "map estimation" } ] }, "name": "src_coordnts", "length": 255, "alias": "Source of coordinates", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_geoswitch", "type": "codedValue", "codedValues": [ { "code": "dgms_map", "name": "DGMS (Map)" }, { "code": "dgms_manual", "name": "DGMS (Manual Entry)" }, { "code": "gps", "name": "GPS (Manual Entry)" } ] }, "name": "geoswitch", "length": 255, "alias": "How would you like to enter the coordinates?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "device_latitude_manual", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "device_longitude_manual", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dgms_man_degrees_lat", "alias": "Degrees (North/South)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dgms_man_mins_lat", "alias": "Minutes (North/South)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dgms_man_seconds_lat", "alias": "Seconds (North/South)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dgms_man_degrees_long", "alias": "Degrees (East/West)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dgms_man_mins_long", "alias": "Minutes (East/West)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dgms_man_seconds_long", "alias": "Seconds (East/West)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feature", "length": 255, "alias": "Nearest Feature(s)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flat", "length": 255, "alias": "Nearest known Feature(s) (Latitude)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flong", "length": 255, "alias": "Nearest known Feature(s) (Longitude)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flat_var", "length": 255, "alias": "flat_var", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flong_var", "length": 255, "alias": "flong_var", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat_var", "length": 255, "alias": "lat_var", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "long_var", "length": 255, "alias": "long_var", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "loc_details", "length": 255, "alias": "Location Details", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_validation_status_ops", "type": "codedValue", "codedValues": [ { "code": "pending", "name": "Pending" }, { "code": "validated", "name": "Validated" }, { "code": "rejected", "name": "Rejected" } ] }, "name": "validation_status_ops", "length": 255, "alias": "Validation Status (Operations)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "validation_comments_ops", "length": 255, "alias": "Validation Comments (Operations)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_validation_status_im", "type": "codedValue", "codedValues": [ { "code": "pending", "name": "Pending" }, { "code": "validated", "name": "Validated" }, { "code": "rejected", "name": "Rejected" } ] }, "name": "validation_status_im", "length": 255, "alias": "Validation Status (IM)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "validation_comments_im", "length": 255, "alias": "Validation Comments (IM)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sys_device_id", "length": 255, "alias": "Device ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sys_platform", "length": 255, "alias": "Platform", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sys_username", "length": 255, "alias": "Username", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "survey_start_dt", "length": 29, "alias": "survey_start_dt", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "survey_end_dt", "length": 29, "alias": "survey_end_dt", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nts_id", "length": 255, "alias": "NTS ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_status", "type": "codedValue", "codedValues": [ { "code": "planned", "name": "Planned \u2013 The activity is planned but implementation have not yet started;" }, { "code": "in_progress", "name": "In progress \u2013 The implementation of the activity has started and is ongoing;" }, { "code": "suspended", "name": "Suspended \u2013 Implementation of the activity has started but is currently suspended;" }, { "code": "completed", "name": "Completed \u2013 The implementation of the activity has been completed." } ] }, "name": "status", "length": 255, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "start_dt", "length": 29, "alias": "Operational start date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "end_dt", "length": 29, "alias": "Operational end date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "org_id", "length": 255, "alias": "Organisation ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_2347495d0332405e83afacc557ce743c_cvd_nts_result", "type": "codedValue", "codedValues": [ { "code": "result", "name": "Evidence of contamination found and reported" } ] }, "name": "nts_result", "length": 255, "alias": "Non-technical survey result", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "resurv_id", "length": 255, "alias": "Resurvey contamination ID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "r1109_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1109", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true }, { "name": "a721_ix1", "isUnique": false, "description": "", "fields": "shape", "isAcsending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "ad34d0edda75428ba5f67f0c6f5fc1b1", "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Sync,Query,Extract,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "Survey Data Locations", "label": "MDR Template Non-Technical Survey", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }