{ "currentVersion": 10.61, "id": 1, "name": "Monitoring Data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPECTOR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "OUTFALL_ID", "type": "esriFieldTypeSmallInteger", "alias": "OUTFALL_ID", "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "INSPECTION_DATE", "length": 8, "domain": null }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "INSPECTOR", "length": 50, "domain": null }, { "name": "ABLE_TO_ACCESS", "type": "esriFieldTypeString", "alias": "ABLE_TO_ACCESS", "length": 10, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TEMPERATURE", "type": "esriFieldTypeDouble", "alias": "TEMPERATURE", "domain": null }, { "name": "RECENT_PRECIP", "type": "esriFieldTypeString", "alias": "RECENT_PRECIP", "length": 10, "domain": null }, { "name": "PHOTO_TAKEN", "type": "esriFieldTypeString", "alias": "PHOTO_TAKEN", "length": 10, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SAMPLING_STRUCTURE", "type": "esriFieldTypeString", "alias": "SAMPLING_STRUCTURE", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitorStructure", "description": "Structure Where Sampling Taken", "codedValues": [ { "name": "Outfall", "code": "Outfall" }, { "name": "Catch Basin", "code": "Catch Basin" }, { "name": "Manhole", "code": "Manhole" }, { "name": "Interconnection", "code": "Interconnection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SAMPLING_TYPE", "type": "esriFieldTypeString", "alias": "SAMPLING_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitorSamplingEvent", "description": "Type of sampling event", "codedValues": [ { "name": "Dry Weather Screening", "code": "Dry Weather Screening" }, { "name": "Dry Weather Sampling", "code": "Dry Weather Sampling" }, { "name": "Wet Weather Sampling", "code": "Wet Weather Sampling" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "CONDITION", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitorCondition", "description": "Outfall Monitor Condition", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Collapsed", "code": "Collapsed" }, { "name": "Submerged", "code": "Submerged" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FLOW", "type": "esriFieldTypeString", "alias": "FLOW", "length": 10, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FLOW_DESCRIPTION", "type": "esriFieldTypeString", "alias": "FLOW_DESCRIPTION", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitorFlowDesc", "description": "Description of Flow", "codedValues": [ { "name": "Damp", "code": "Damp" }, { "name": "Trickle", "code": "Trickle" }, { "name": "Moderate", "code": "Moderate" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REC_MAINTENANCE", "type": "esriFieldTypeString", "alias": "REC_MAINTENANCE", "length": 100, "domain": null }, { "name": "MAINTENANCE_PRIORITY", "type": "esriFieldTypeString", "alias": "MAINTENANCE_PRIORITY", "length": 50, "domain": null }, { "name": "EROSION_CONDITION", "type": "esriFieldTypeString", "alias": "EROSION_CONDITION", "length": 50, "domain": null }, { "name": "GULLY_LENGTH", "type": "esriFieldTypeDouble", "alias": "GULLY_DIMENSIONS", "domain": null }, { "name": "GULLY_WIDTH", "type": "esriFieldTypeDouble", "alias": "GULLY_DEPTH", "domain": null }, { "name": "GULLY_DEPTH", "type": "esriFieldTypeDouble", "alias": "GULLY_DEPTH", "domain": null }, { "name": "SEDIMENT_ACCUMULATION", "type": "esriFieldTypeString", "alias": "SEDIMENT_ACCUMULATION", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRESSED_VEG", "type": "esriFieldTypeString", "alias": "STRESSED_VEG", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_TURBIDITY", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_TURBIDITY", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_FLOATABLES", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_FLOATABLES", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_OIL_SHEEN", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_OIL_SHEEN", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_ALGAE", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_ALGAE", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_FOAM", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_FOAM", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_SANITARY_WASTE", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_SANITARY_WASTE", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_DIRT", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_DIRT", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_QUALITY_COLOR", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_COLOR", "length": 50, "domain": null }, { "name": "WATER_QUALITY_OTHER", "type": "esriFieldTypeString", "alias": "WATER_QUALITY_OTHER", "length": 50, "domain": null }, { "name": "OLFACTORY_SEWAGE", "type": "esriFieldTypeString", "alias": "OLFACTORY_SEWAGE", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OLFACTORY_MUSTY", "type": "esriFieldTypeString", "alias": "OLFACTORY_MUSTY", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OLFACTORY_ROTTEN_EGGS", "type": "esriFieldTypeString", "alias": "OLFACTORY_ROTTEN_EGGS", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OLFACTORY_AMMONIA", "type": "esriFieldTypeString", "alias": "OLFACTORY_AMMONIA", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OLFACTORY_PETROLEUM", "type": "esriFieldTypeString", "alias": "OLFACTORY_PETROLEUM", "length": 50, "domain": { "type": "codedValue", "name": "OutfallMonitor_YN", "description": "YN for Outfall Monitoring Fields", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OLFACTORY_OTHER", "type": "esriFieldTypeString", "alias": "OLFACTORY_OTHER", "length": 50, "domain": null }, { "name": "SAMPLING_TEMP", "type": "esriFieldTypeDouble", "alias": "SAMPLING_TEMP", "domain": null }, { "name": "SAMPLING_CONDUCTIVITY", "type": "esriFieldTypeString", "alias": "SAMPLING_CONDUCTIVITY", "length": 50, "domain": null }, { "name": "SAMPLING_SALINITY", "type": "esriFieldTypeString", "alias": "SAMPLING_SALINITY", "length": 50, "domain": null }, { "name": "SAMPLING_POLLUTANTOFCONCERN", "type": "esriFieldTypeString", "alias": "SAMPLING_POLLUTANTOFCONCERN", "length": 50, "domain": null }, { "name": "SAMPLING_AMMONIA", "type": "esriFieldTypeString", "alias": "SAMPLING_AMMONIA", "length": 50, "domain": null }, { "name": "SAMPLING_SURFACTANTS", "type": "esriFieldTypeString", "alias": "SAMPLING_SURFACTANTS", "length": 50, "domain": null }, { "name": "SAMPLING_BACTERIA", "type": "esriFieldTypeString", "alias": "SAMPLING_BACTERIA", "length": 50, "domain": null }, { "name": "SAMPLING_CHLORINE", "type": "esriFieldTypeString", "alias": "SAMPLING_CHLORINE", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R804_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4375_GlobalI", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "OUTFALLS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }