{
"currentVersion": 11.1,
"cimVersion": "3.1.0",
"id": 8,
"name": "IDDE_INSP_ADDITIONAL",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"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,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "",
"displayField": "IDDE_NUM",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "IDDE_INSP_ID",
"type": "esriFieldTypeGUID",
"alias": "IDDE_INSP_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "IDDE_INSP_ADD_ID"
},
{
"name": "FEATURE_ID",
"type": "esriFieldTypeGUID",
"alias": "FEATURE_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "OUTFALL_ADD_ID"
},
{
"name": "IDDE_NUM",
"type": "esriFieldTypeString",
"alias": "IDDE_NUM",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "IDDE_NUM"
},
{
"name": "SCREEN_DATE",
"type": "esriFieldTypeDate",
"alias": "SCREEN_DATE",
"domain": null,
"editable": true,
"nullable": false,
"length": 8,
"defaultValue": null,
"modelName": "SCREEN_DATE"
},
{
"name": "TEST_NUM",
"type": "esriFieldTypeString",
"alias": "TEST_NUM",
"domain": null,
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "TEST_NUM"
},
{
"name": "LAST_RAIN",
"type": "esriFieldTypeDate",
"alias": "LAST_RAIN",
"domain": null,
"editable": true,
"nullable": false,
"length": 8,
"defaultValue": null,
"modelName": "LAST_RAIN"
},
{
"name": "SCREEN_TIME",
"type": "esriFieldTypeString",
"alias": "SCREEN_TIME",
"domain": null,
"editable": true,
"nullable": false,
"length": 10,
"defaultValue": null,
"modelName": "SCREEN_TIME"
},
{
"name": "OBSERV_FLOW",
"type": "esriFieldTypeString",
"alias": "OBSERV_FLOW",
"domain": {
"type": "codedValue",
"name": "D_True_False",
"description": "True / False",
"codedValues": [
{
"name": "True",
"code": "True"
},
{
"name": "False",
"code": "False"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 5,
"defaultValue": null,
"modelName": "OBSERV_FLOW"
},
{
"name": "AIR_TEMP",
"type": "esriFieldTypeDouble",
"alias": "AIR_TEMP",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "AIR_TEMP"
},
{
"name": "CHEM_TEST",
"type": "esriFieldTypeString",
"alias": "CHEM_TEST",
"domain": {
"type": "codedValue",
"name": "D_True_False",
"description": "True / False",
"codedValues": [
{
"name": "True",
"code": "True"
},
{
"name": "False",
"code": "False"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 5,
"defaultValue": null,
"modelName": "CHEM_TEST"
},
{
"name": "ALGAEGROW",
"type": "esriFieldTypeString",
"alias": "ALGAEGROW",
"domain": {
"type": "codedValue",
"name": "D_True_False",
"description": "True / False",
"codedValues": [
{
"name": "True",
"code": "True"
},
{
"name": "False",
"code": "False"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 5,
"defaultValue": null,
"modelName": "ALGAEGROW"
},
{
"name": "ODOR",
"type": "esriFieldTypeString",
"alias": "ODOR",
"domain": {
"type": "codedValue",
"name": "D_Odor",
"description": "Odor",
"codedValues": [
{
"name": "Gas",
"code": "Gas"
},
{
"name": "None",
"code": "None"
},
{
"name": "Oil",
"code": "Oil"
},
{
"name": "Rancid-Sour",
"code": "Rancid-Sour"
},
{
"name": "Sewage",
"code": "Sewage"
},
{
"name": "Sulfur",
"code": "Sulfur"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "ODOR"
},
{
"name": "DEPOSITS",
"type": "esriFieldTypeString",
"alias": "DEPOSITS",
"domain": {
"type": "codedValue",
"name": "D_Deposits",
"description": "Deposits",
"codedValues": [
{
"name": "Oil",
"code": "Oil"
},
{
"name": "None",
"code": "None"
},
{
"name": "Sediment",
"code": "Sediment"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "DEPOSITS"
},
{
"name": "VEG_COND",
"type": "esriFieldTypeString",
"alias": "VEG_COND",
"domain": {
"type": "codedValue",
"name": "D_Veg_Cond",
"description": "Vegetation Condition ",
"codedValues": [
{
"name": "Excessive Growth",
"code": "Excessive Growth"
},
{
"name": "Inhibited Growth",
"code": "Inhibited Growth"
},
{
"name": "Normal",
"code": "Normal"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "VEG_COND"
},
{
"name": "STRUCT_COND",
"type": "esriFieldTypeString",
"alias": "STRUCT_COND",
"domain": {
"type": "codedValue",
"name": "D_StructCond",
"description": "Structural Condition ",
"codedValues": [
{
"name": "Concrete Cracking",
"code": "Concrete Cracking"
},
{
"name": "Concrete Spalling",
"code": "Concrete Spalling"
},
{
"name": "Normal",
"code": "Normal"
},
{
"name": "Other",
"code": "Other"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "STRUCT_COND"
},
{
"name": "EROSION",
"type": "esriFieldTypeString",
"alias": "EROSION",
"domain": {
"type": "codedValue",
"name": "D_Erosion",
"description": "Erosion",
"codedValues": [
{
"name": "Moderate",
"code": "Moderate"
},
{
"name": "None",
"code": "None"
},
{
"name": "Severe",
"code": "Severe"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 50,
"defaultValue": null,
"modelName": "EROSION"
},
{
"name": "COMPLA_NUM",
"type": "esriFieldTypeString",
"alias": "COMPLA_NUM",
"domain": {
"type": "codedValue",
"name": "D_True_False",
"description": "True / False",
"codedValues": [
{
"name": "True",
"code": "True"
},
{
"name": "False",
"code": "False"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": false,
"length": 5,
"defaultValue": null,
"modelName": "COMPLA_NUM"
},
{
"name": "REPORTING_YEAR",
"type": "esriFieldTypeString",
"alias": "REPORTING_YEAR",
"domain": null,
"editable": true,
"nullable": true,
"length": 4,
"defaultValue": null,
"modelName": "REPORTING_YEAR"
},
{
"name": "MDE_COMMENTS",
"type": "esriFieldTypeString",
"alias": "MDE_COMMENTS",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "MDE_COMMENTS"
},
{
"name": "ADTNL_COMMENTS",
"type": "esriFieldTypeString",
"alias": "ADTNL_COMMENTS",
"domain": null,
"editable": true,
"nullable": true,
"length": 1073741822,
"defaultValue": null,
"modelName": "ADTNL_COMMENTS"
},
{
"name": "IDDE_CASE",
"type": "esriFieldTypeGUID",
"alias": "IDDE_CASE",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "IDDE_CASE"
}
],
"indexes": [
{
"name": "I842IDDE_INSP_ID",
"fields": "IDDE_INSP_ID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "R119_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "IDDE_INSP_ADDITIONAL",
"description": "",
"prototype": {
"attributes": {
"ADTNL_COMMENTS": null,
"IDDE_CASE": null,
"IDDE_INSP_ID": null,
"FEATURE_ID": null,
"IDDE_NUM": null,
"SCREEN_DATE": -2209161600000,
"TEST_NUM": " ",
"LAST_RAIN": -2209161600000,
"SCREEN_TIME": " ",
"OBSERV_FLOW": " ",
"AIR_TEMP": 0,
"CHEM_TEST": " ",
"ALGAEGROW": " ",
"ODOR": " ",
"DEPOSITS": " ",
"VEG_COND": " ",
"STRUCT_COND": " ",
"EROSION": " ",
"COMPLA_NUM": " ",
"REPORTING_YEAR": null,
"MDE_COMMENTS": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 2000,
"maxRecordCountFactor": 1
}