{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 16, "name": "wSamplingActivity", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SITE_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CODE", "type": "esriFieldTypeString", "alias": "CODE", "length": 10, "domain": null }, { "name": "SITE_NAME", "type": "esriFieldTypeString", "alias": "SITE_NAME", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "SAMPLE_LOCATION", "type": "esriFieldTypeString", "alias": "SAMPLE_LOCATION", "length": 50, "domain": null }, { "name": "TOTAL", "type": "esriFieldTypeDouble", "alias": "TOTAL", "domain": null }, { "name": "FREE", "type": "esriFieldTypeDouble", "alias": "FREE", "domain": null }, { "name": "COMBINED", "type": "esriFieldTypeDouble", "alias": "COMBINED", "domain": null }, { "name": "AF_TOTAL", "type": "esriFieldTypeDouble", "alias": "AF_TOTAL", "domain": null }, { "name": "AF_FREE", "type": "esriFieldTypeDouble", "alias": "AF_FREE", "domain": null }, { "name": "AF_COMBINED", "type": "esriFieldTypeDouble", "alias": "AF_COMBINED", "domain": null }, { "name": "SAMPLED_BY", "type": "esriFieldTypeString", "alias": "SAMPLED_BY", "length": 50, "domain": null }, { "name": "ACTIVITYID", "type": "esriFieldTypeString", "alias": "ACTIVITYID", "length": 20, "domain": null }, { "name": "LASTACTIVITY", "type": "esriFieldTypeString", "alias": "LastActivity", "length": 30, "domain": { "type": "codedValue", "name": "dmnChlorineLastActivity", "description": "City Utilities Drinking Water sampling", "codedValues": [ { "name": "Chlorine Monitoring", "code": "Chlorine Monitoring" }, { "name": "Autoflusher", "code": "Autoflusher" }, { "name": "Dead End Flushing", "code": "Dead End Flushing" }, { "name": "Monochloramine / FA", "code": "Monochloramine / FA" }, { "name": "Adverse Water Quality Incident", "code": "Adverse Water Quality Incident" }, { "name": "Customer Concern", "code": "Customer Concern" }, { "name": "RoW Notification", "code": "RoW Notification" }, { "name": "New Watermain Connection", "code": "New Watermain Connection" }, { "name": "Final Watermain Connection", "code": "Final Watermain Connection" }, { "name": "Watermain Break", "code": "Watermain Break" }, { "name": "New Service Connection", "code": "New Service Connection" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATESTAMP", "type": "esriFieldTypeDate", "alias": "DATESTAMP", "length": 8, "domain": null }, { "name": "OPTIME_OLD", "type": "esriFieldTypeString", "alias": "OPTIME", "length": 5, "domain": null }, { "name": "COMPUTERNAME", "type": "esriFieldTypeString", "alias": "COMPUTERNAME", "length": 30, "domain": null }, { "name": "OPERATEDBY", "type": "esriFieldTypeString", "alias": "OPERATEDBY", "length": 30, "domain": null }, { "name": "MONOCHLORAMINE", "type": "esriFieldTypeDouble", "alias": "MONOCHLORAMINE", "domain": null }, { "name": "FREE_AMMONIA", "type": "esriFieldTypeDouble", "alias": "FREE_AMMONIA", "domain": null }, { "name": "SAMPLE_TIME_OLD", "type": "esriFieldTypeSingle", "alias": "SAMPLE_TIME", "domain": null }, { "name": "CONDUCTIVITY", "type": "esriFieldTypeSingle", "alias": "CONDUCTIVITY", "domain": null }, { "name": "PH", "type": "esriFieldTypeSingle", "alias": "PH", "domain": null }, { "name": "TEMPERATURE", "type": "esriFieldTypeSingle", "alias": "TEMPERATURE", "domain": null }, { "name": "WAIT_TIME", "type": "esriFieldTypeSingle", "alias": "WAIT_TIME", "domain": null }, { "name": "ULTRACHECK_RLU", "type": "esriFieldTypeInteger", "alias": "ULTRACHECK_RLU", "domain": null }, { "name": "ATP_RLU", "type": "esriFieldTypeSmallInteger", "alias": "ATP_RLU", "domain": null }, { "name": "VOLUME_FILTERED", "type": "esriFieldTypeSmallInteger", "alias": "VOLUME_FILTERED", "domain": null }, { "name": "ANALYZED_BY", "type": "esriFieldTypeString", "alias": "ANALYZED_BY", "length": 50, "domain": null }, { "name": "CATP", "type": "esriFieldTypeDouble", "alias": "CATP", "domain": null }, { "name": "CELL_COUNT", "type": "esriFieldTypeDouble", "alias": "CELL_COUNT", "domain": null }, { "name": "HT_PLATE_CNT", "type": "esriFieldTypeSmallInteger", "alias": "HT_PLATE_CNT", "domain": null }, { "name": "PA_ECOLI", "type": "esriFieldTypeString", "alias": "PA_ECOLI", "length": 20, "domain": null }, { "name": "PA_TC", "type": "esriFieldTypeString", "alias": "PA_TC", "length": 20, "domain": null }, { "name": "PRESENCE_ABSENCE", "type": "esriFieldTypeString", "alias": "PRESENCE_ABSENCE", "length": 20, "domain": null }, { "name": "LOAD_DATE", "type": "esriFieldTypeDate", "alias": "LOAD_DATE", "length": 8, "domain": null }, { "name": "RECORD_NUMBER", "type": "esriFieldTypeString", "alias": "RECORD_NUMBER", "length": 10, "domain": null }, { "name": "AF_TIME_OLD", "type": "esriFieldTypeSingle", "alias": "AF_TIME", "domain": null }, { "name": "FL_START_TIME_OLD", "type": "esriFieldTypeDouble", "alias": "FL_START_TIME", "domain": null }, { "name": "FL_FINISH_TIME_OLD", "type": "esriFieldTypeDouble", "alias": "FL_FINISH_TIME", "domain": null }, { "name": "TEST_TYPE", "type": "esriFieldTypeString", "alias": "TEST_TYPE", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 100, "domain": null }, { "name": "FLOW_RATE", "type": "esriFieldTypeSmallInteger", "alias": "FLOW_RATE", "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeInteger", "alias": "ASSET_ID", "domain": null }, { "name": "CREATE_USER", "type": "esriFieldTypeString", "alias": "CREATE_USER", "length": 50, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "CREATE_DATE", "length": 8, "domain": null }, { "name": "UPDATE_USER", "type": "esriFieldTypeString", "alias": "UPDATE_USER", "length": 50, "domain": null }, { "name": "UPDATE_DATE", "type": "esriFieldTypeDate", "alias": "UPDATE_DATE", "length": 8, "domain": null }, { "name": "ACTIVITY", "type": "esriFieldTypeString", "alias": "ACTIVITY", "length": 30, "domain": { "type": "codedValue", "name": "dmnChlorineLastActivity", "description": "City Utilities Drinking Water sampling", "codedValues": [ { "name": "Chlorine Monitoring", "code": "Chlorine Monitoring" }, { "name": "Autoflusher", "code": "Autoflusher" }, { "name": "Dead End Flushing", "code": "Dead End Flushing" }, { "name": "Monochloramine / FA", "code": "Monochloramine / FA" }, { "name": "Adverse Water Quality Incident", "code": "Adverse Water Quality Incident" }, { "name": "Customer Concern", "code": "Customer Concern" }, { "name": "RoW Notification", "code": "RoW Notification" }, { "name": "New Watermain Connection", "code": "New Watermain Connection" }, { "name": "Final Watermain Connection", "code": "Final Watermain Connection" }, { "name": "Watermain Break", "code": "Watermain Break" }, { "name": "New Service Connection", "code": "New Service Connection" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SAMPLE_TIME_TXT", "type": "esriFieldTypeString", "alias": "SAMPLE_TIME_TXT", "length": 20, "domain": null }, { "name": "SAMPLE_TIME", "type": "esriFieldTypeDate", "alias": "SAMPLE_TIME", "length": 8, "domain": null }, { "name": "AF_TIME", "type": "esriFieldTypeDate", "alias": "AF_TIME", "length": 8, "domain": null }, { "name": "FL_START_TIME", "type": "esriFieldTypeDate", "alias": "FL_START_TIME", "length": 8, "domain": null }, { "name": "FL_FINISH_TIME", "type": "esriFieldTypeDate", "alias": "FL_FINISH_TIME", "length": 8, "domain": null }, { "name": "OPTIME", "type": "esriFieldTypeDate", "alias": "OPTIME", "length": 8, "domain": null } ], "indexes": [ { "name": "IDX_ASSET_ID_1", "fields": "ASSET_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IDX_CODE", "fields": "CODE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1044_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "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 } }