{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 22, "name": "swCatchBasinActivity", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STRUCTURE_TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "STRUCTURE_TYPE", "type": "esriFieldTypeString", "alias": "STRUCTURE_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "dm_CatchBasin_StructureType", "description": "Sturcture type dropdown for the catch basin form ", "codedValues": [ { "name": "Catchbasin Manhole", "code": "Catchbasin Manhole" }, { "name": "Double Catchbasin Manhole", "code": "Double Catchbasin Manhole" }, { "name": "Manhole", "code": "Manhole" }, { "name": "Single Catchbasin", "code": "Single Catchbasin" }, { "name": "Single Side Inlet Catchbasin", "code": "Single Side Inlet Catchbasin" }, { "name": "Single Ditch Inlet Catchbasin", "code": "Single Ditch Inlet Catchbasin" }, { "name": "Double Catchbasin", "code": "Double Catchbasin" }, { "name": "Double Side Inlet Catchbasin", "code": "Double Side Inlet Catchbasin" }, { "name": "Double Ditch Inlet Catchbasin", "code": "Double Ditch Inlet Catchbasin" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SINK_HOLE", "type": "esriFieldTypeString", "alias": "SINK_HOLE", "length": 50, "domain": { "type": "codedValue", "name": "dmn_CatchBasin_YesNo", "description": "Domain for swCatchbasin inspection form", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CASTING", "type": "esriFieldTypeString", "alias": "CASTING", "length": 50, "domain": { "type": "codedValue", "name": "dmn_Catch_Basin_GFP", "description": "Catch basin dropdown for good/fair/poor", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CASTING_CONDITION", "type": "esriFieldTypeString", "alias": "CASTING_CONDITION", "length": 50, "domain": { "type": "codedValue", "name": "dmn_CatchBasin_Casting", "description": "Casting Type Dropdown for the catch basin form ", "codedValues": [ { "name": "Protruding", "code": "Protruding" }, { "name": "Depression", "code": "Depression" }, { "name": "Okay", "code": "Okay" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPAIRS_REQUIRED", "type": "esriFieldTypeString", "alias": "REPAIRS_REQUIRED", "length": 50, "domain": { "type": "codedValue", "name": "dmn_CatchBasin_YesNo", "description": "Domain for swCatchbasin inspection form", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REASON_FOR_REPAIR", "type": "esriFieldTypeString", "alias": "Reason_For_Repair", "length": 50, "domain": { "type": "codedValue", "name": "dm_CatchBasin_RepairReason", "description": "Reason for Repair for the catch basin form ", "codedValues": [ { "name": "Cracked/Broken Casting", "code": "Cracked/Broken Casting" }, { "name": "Failed Risers", "code": "Failed Risers" }, { "name": "Sinkhole", "code": "Sinkhole" }, { "name": "Pipe/Structure Deficiency", "code": "Pipe/Structure Deficiency" }, { "name": "Parging Required", "code": "Parging" }, { "name": "Ladder Rung Deficiency (MH only)", "code": "Ladder Rung Deficiency (MH only)" }, { "name": "Benching Deficiency (MH only)", "code": "Benching Deficiency (MH only)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCTURE_CONDITION", "type": "esriFieldTypeString", "alias": "Structure Condition", "length": 50, "domain": { "type": "codedValue", "name": "dmn_Catch_Basin_GFP", "description": "Catch basin dropdown for good/fair/poor", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SERVICE_CONNECTION", "type": "esriFieldTypeString", "alias": "Service Connection", "length": 50, "domain": { "type": "codedValue", "name": "dmn_CatchBasin_YesNo", "description": "Domain for swCatchbasin inspection form", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLEANING_NEEDED", "type": "esriFieldTypeString", "alias": "Cleaning_Needed", "length": 50, "domain": { "type": "codedValue", "name": "dmn_CatchBasin_YesNo", "description": "Domain for swCatchbasin inspection form", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OIL_SHEEN", "type": "esriFieldTypeString", "alias": "OIL_SHEEN", "length": 50, "domain": { "type": "codedValue", "name": "dmn_CatchBasin_YesNo", "description": "Domain for swCatchbasin inspection form", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 50, "domain": null }, { "name": "CONDITION_OF_RISERS", "type": "esriFieldTypeString", "alias": "CONDITION_OF_RISERS", "length": 50, "domain": { "type": "codedValue", "name": "dmn_Catch_Basin_GFP", "description": "Catch basin dropdown for good/fair/poor", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DEPTH_OF_MANHOLE", "type": "esriFieldTypeSmallInteger", "alias": "DEPTH_OF_MANHOLE", "domain": null }, { "name": "PIPE_DIAMETER_IN_INCHES", "type": "esriFieldTypeSmallInteger", "alias": "PIPE_DIAMETER_IN_INCHES", "domain": null }, { "name": "INSPECTED_BY", "type": "esriFieldTypeString", "alias": "INSPECTED_BY", "length": 50, "domain": { "type": "codedValue", "name": "dmn_SWM_inspectors", "description": "pond inspectors", "codedValues": [ { "name": "Roger Ludwig", "code": "Roger Ludwig" }, { "name": "Dene Schieck", "code": "Dene Schieck" }, { "name": "Dax McAllister", "code": "Dax McAllister" }, { "name": "Ben Godin", "code": "Ben Godin" }, { "name": "John Plomske", "code": "John Plomske" }, { "name": "Paola Mendez", "code": "Paola Mendez" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINKEDDOCUMENTS", "type": "esriFieldTypeString", "alias": "LINKEDDOCUMENTS", "length": 1000, "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeInteger", "alias": "ASSET_ID", "domain": null }, { "name": "LASTACTIVITY", "type": "esriFieldTypeString", "alias": "LASTACTIVITY", "length": 50, "domain": { "type": "codedValue", "name": "dmnLastActivity_SWS", "description": "Activity drop down for SW&S", "codedValues": [ { "name": "Inspection", "code": "INSP" }, { "name": "Update", "code": "UPDT" }, { "name": "Repair / Replacement", "code": "RPR" }, { "name": "Installation", "code": "INST" }, { "name": "Abandon / Remove", "code": "ABAN" }, { "name": "Flushing", "code": "FLUSH" }, { "name": "Cleaning", "code": "CLEN" }, { "name": "Lateral Flushing", "code": "LATFL" }, { "name": "Contractor Cleaning", "code": "CC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATESTAMP", "type": "esriFieldTypeDate", "alias": "DATESTAMP", "length": 8, "domain": null }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null }, { "name": "MANHOLE_EXIST", "type": "esriFieldTypeString", "alias": "MANHOLE_EXIST", "length": 3, "domain": { "type": "codedValue", "name": "dmnYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUMP_EXISTS", "type": "esriFieldTypeString", "alias": "SUMP_EXISTS", "length": 50, "domain": { "type": "codedValue", "name": "dmn_CatchBasin_YesNo", "description": "Domain for swCatchbasin inspection form", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPUTERNAME", "type": "esriFieldTypeString", "alias": "COMPUTERNAME", "length": 30, "domain": null }, { "name": "OPERATEDBY", "type": "esriFieldTypeString", "alias": "OPERATEDBY", "length": 30, "domain": null }, { "name": "CONTRACTOR_CLEANING", "type": "esriFieldTypeString", "alias": "CONTRACTOR_CLEANING", "length": 30, "domain": { "type": "codedValue", "name": "dmn_swContractor", "description": "Status of Contractor_Cleaning field", "codedValues": [ { "name": "Cleaned", "code": "Cleaned" }, { "name": "Obstructed (1stVisit)", "code": "Obstructed (1stVisit)" }, { "name": "Obstructed (2ndVisit)", "code": "Obstructed (2ndVisit)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LADDER_RUNGS", "type": "esriFieldTypeString", "alias": "LADDER_RUNGS", "length": 15, "domain": { "type": "codedValue", "name": "dmn_Activity_InspCondition", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BENCHING", "type": "esriFieldTypeString", "alias": "BENCHING", "length": 15, "domain": { "type": "codedValue", "name": "dmn_Activity_InspCondition", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Inspected", "code": "Not Inspected" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INFILTRATION", "type": "esriFieldTypeString", "alias": "INFILTRATION", "length": 4, "domain": { "type": "codedValue", "name": "dmnInfiltration", "description": "", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Low", "code": "Low" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R981_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "SWCATCHBASINACT_ASSETID_IDX1", "fields": "ASSET_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "SWCATCHBASINACT_ASSETID_IDX2", "fields": "ASSET_ID,LASTACTIVITY", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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 }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }