{
"currentVersion": 11.4,
"cimVersion": "3.4.0",
"id": 9,
"name": "In Field Investigation FM",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [
{
"id": 1,
"name": "SDE.SpotInvestigation_FM",
"relatedTableId": 4,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "UniqueID",
"composite": false,
"catalogID": "{2E5DFDA0-92D2-4854-A465-58B95C8DFCBC}"
}
],
"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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryAttachments": true,
"supportsQueryAttachmentsWithReturnUrl": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsReturningGeometryEnvelope": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": true,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON,PBF"
},
"hasMetadata": true,
"hasAttachments": true,
"supportsAttachmentsByUploadId": true,
"supportsAttachmentsResizing": true,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "OBJECTID",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "UniqueID",
"type": "esriFieldTypeString",
"alias": "UniqueID",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "UniqueID"
},
{
"name": "Staff",
"type": "esriFieldTypeString",
"alias": "Staff- Who is completing investigation",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "Staff"
},
{
"name": "Date_of_investigaton",
"type": "esriFieldTypeDate",
"alias": "Date of investigation",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "Date_of_investigaton"
},
{
"name": "Project_Type",
"type": "esriFieldTypeString",
"alias": "Project Type ",
"domain": {
"type": "codedValue",
"name": "Project_Type",
"description": "",
"codedValues": [
{
"name": "Erosion and Sediment Control",
"code": "ESC"
},
{
"name": "Water Quality Issues",
"code": "WQI"
},
{
"name": "Vegetation Management",
"code": "VM"
},
{
"name": "Drainage",
"code": "D"
},
{
"name": "Litter",
"code": "L"
},
{
"name": "Education",
"code": "E"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "Project_Type"
},
{
"name": "Weather_Conditions",
"type": "esriFieldTypeString",
"alias": "Weather Conditions",
"domain": null,
"editable": true,
"nullable": true,
"length": 200,
"defaultValue": null,
"modelName": "Weather_Conditions"
},
{
"name": "Rain_within_last_3_days",
"type": "esriFieldTypeString",
"alias": "Rain within last 3 days",
"domain": {
"type": "codedValue",
"name": "Rain_within_last_3_days",
"description": "Has there been rain in the last 3 days",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "Rain_within_last_3_days"
},
{
"name": "Description",
"type": "esriFieldTypeString",
"alias": "Description of site visit",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "Description"
},
{
"name": "General_Comments",
"type": "esriFieldTypeString",
"alias": "General Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 1000,
"defaultValue": null,
"modelName": "General_Comments"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"name": "description1",
"type": "esriFieldTypeString",
"alias": "description1",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description1"
},
{
"name": "description2",
"type": "esriFieldTypeString",
"alias": "description2",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description2"
},
{
"name": "description3",
"type": "esriFieldTypeString",
"alias": "description3",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description3"
},
{
"name": "description4",
"type": "esriFieldTypeString",
"alias": "description4",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description4"
},
{
"name": "description5",
"type": "esriFieldTypeString",
"alias": "description5",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description5"
},
{
"name": "description6",
"type": "esriFieldTypeString",
"alias": "description6",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description6"
},
{
"name": "description7",
"type": "esriFieldTypeString",
"alias": "description7",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description7"
},
{
"name": "description8",
"type": "esriFieldTypeString",
"alias": "description8",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description8"
},
{
"name": "description9",
"type": "esriFieldTypeString",
"alias": "description9",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description9"
},
{
"name": "description10",
"type": "esriFieldTypeString",
"alias": "description10",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description10"
},
{
"name": "description11",
"type": "esriFieldTypeString",
"alias": "description11",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description11"
},
{
"name": "description12",
"type": "esriFieldTypeString",
"alias": "description12",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "description12"
}
],
"indexes": [
{
"name": "R237_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_237",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "GDB_3821_UniqueI",
"fields": "UniqueID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_237",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"timeZoneIANA": "Etc/UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "In Field Investigation FM",
"description": "",
"prototype": {
"attributes": {
"description11": null,
"UniqueID": null,
"Staff": null,
"Date_of_investigaton": null,
"Project_Type": null,
"Weather_Conditions": null,
"Rain_within_last_3_days": null,
"Description": null,
"General_Comments": null,
"description12": null,
"description1": null,
"description2": null,
"description3": null,
"description4": null,
"description5": null,
"description6": null,
"description7": null,
"description8": null,
"description9": null,
"description10": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"attachmentProperties": [
{
"name": "id",
"fieldName": "ATTACHMENTID",
"isEnabled": true
},
{
"name": "globalId",
"fieldName": "GLOBALID",
"isEnabled": true
},
{
"name": "name",
"fieldName": "ATT_NAME",
"isEnabled": true
},
{
"name": "size",
"fieldName": "DATA_SIZE",
"isEnabled": true
},
{
"name": "contentType",
"fieldName": "CONTENT_TYPE",
"isEnabled": true
},
{
"name": "keywords",
"fieldName": "KEYWORDS",
"isEnabled": false
},
{
"name": "exifInfo",
"fieldName": "EXIFINFO",
"isEnabled": false
}
],
"attachmentFields": [
{
"name": "ATTACHMENTID",
"type": "esriFieldTypeOID",
"alias": "ATTACHMENTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null
},
{
"name": "GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null
},
{
"name": "ATT_NAME",
"type": "esriFieldTypeString",
"alias": "ATT_NAME",
"domain": null,
"editable": true,
"nullable": false,
"length": 250,
"defaultValue": null
},
{
"name": "DATA_SIZE",
"type": "esriFieldTypeInteger",
"alias": "DATA_SIZE",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null
},
{
"name": "CONTENT_TYPE",
"type": "esriFieldTypeString",
"alias": "CONTENT_TYPE",
"domain": null,
"editable": true,
"nullable": false,
"length": 150,
"defaultValue": null
}
],
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 2000,
"maxRecordCountFactor": 1,
"serviceItemId": "23ec184b9b034f74bd756574aa2f2dab"
}