{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "swInletInspectionForm", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspDate", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "Discovered", "type": "esriFieldTypeString", "alias": "Structure Found?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo_2", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Action", "type": "esriFieldTypeString", "alias": "Action Performed", "length": 255, "domain": { "type": "codedValue", "name": "Action_3", "description": "", "codedValues": [ { "name": "Inspection", "code": "Inspection" }, { "name": "Maintenance", "code": "Maintenance" }, { "name": "Cleaning", "code": "Cleaning" }, { "name": "Inspection and Cleaning", "code": "Inspection and Cleaning" }, { "name": "SCM Inspection", "code": "SCM Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sediment", "type": "esriFieldTypeString", "alias": "Level of Sediment Accumulation", "length": 255, "domain": { "type": "codedValue", "name": "Sediment_1_1", "description": "Sediment_1", "codedValues": [ { "name": "Sump less than half full", "code": "Sump less than half full" }, { "name": "Sump half full", "code": "Sump half full" }, { "name": "Sump full", "code": "Sump full" }, { "name": "Structure completely full", "code": "Structure completely full" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Overall Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition_1_1", "description": "Condition_1", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Failing", "code": "Failing" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "Attachments", "type": "esriFieldTypeBlob", "alias": "Attachments", "domain": null }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "GrateClogged", "type": "esriFieldTypeString", "alias": "Grate Clogged", "length": 255, "domain": { "type": "codedValue", "name": "YesNo_2", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "InspAffil", "type": "esriFieldTypeString", "alias": "Inspector Affiliation?", "length": 255, "domain": { "type": "codedValue", "name": "Affiliation", "description": "Affiliation", "codedValues": [ { "name": "MassDOT", "code": "MassDOT" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Accumulation Study", "code": "Accumulation Study" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IDDE", "type": "esriFieldTypeString", "alias": "Signs of Contamination?", "length": 255, "domain": { "type": "codedValue", "name": "IDDE_Signs", "description": "IDDE_Signs", "codedValues": [ { "name": "Visual Signs", "code": "Visual Signs" }, { "name": "Smell Sewage", "code": "Smell Sewage" }, { "name": "Smell Chemicals", "code": "Smell Chemicals" }, { "name": "Other (add notes)", "code": "Other (add notes)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FOLLOW_UP_NEEDED", "type": "esriFieldTypeString", "alias": "Maintenance Follow up Needed?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo_2", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLEAN_STRUCTURE", "type": "esriFieldTypeString", "alias": "Structure Cleaning", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLEAN_PIPE", "type": "esriFieldTypeString", "alias": "Pipe Cleaning", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REMOVE_DEBRIS", "type": "esriFieldTypeString", "alias": "Debris Removal", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIR_STRUCTURE", "type": "esriFieldTypeString", "alias": "Repair Structural Damage", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPLACE_GRATE_FRAME", "type": "esriFieldTypeString", "alias": "Frame/Grate Replacement", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIR_HOOD", "type": "esriFieldTypeString", "alias": "Hood Repair", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPLACE_HOOD", "type": "esriFieldTypeString", "alias": "Hood Replacement", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REBUILD_STRUCTURES", "type": "esriFieldTypeString", "alias": "Rebuild Structures", "length": 255, "domain": { "type": "codedValue", "name": "ConditionEval", "description": "ConditionEval", "codedValues": [ { "name": "Needed", "code": "Needed" }, { "name": "Completed", "code": "Completed" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DepthToSedimentBefore_ft", "type": "esriFieldTypeDouble", "alias": "DepthToSedimentBefore_ft", "domain": null }, { "name": "DepthToSedimentAfter_ft", "type": "esriFieldTypeDouble", "alias": "DepthToSedimentAfter_ft", "domain": null }, { "name": "SedimentVolumeRemoved_cy", "type": "esriFieldTypeDouble", "alias": "SedimentVolumeRemoved_cy", "domain": null } ], "indexes": [ { "name": "UUID_431", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R431_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "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": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1620033463000 } }