{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 81, "name": "Catchbasin Sampling", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Temperature_Range", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Temperature", "type": "esriFieldTypeDouble", "alias": "Temperature", "domain": null }, { "name": "Temperature_Range", "type": "esriFieldTypeString", "alias": "Acceptable temperature range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Temperature", "description": "", "codedValues": [ { "name": "Celsius", "code": "Celsius" }, { "name": "Farhenheit", "code": "Farhenheit" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Temperature_Acceptable", "type": "esriFieldTypeString", "alias": "Is temperature within acceptable range?", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pH", "type": "esriFieldTypeDouble", "alias": "pH", "domain": null }, { "name": "pH_Range", "type": "esriFieldTypeString", "alias": "Acceptable pH range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_ph", "description": "\tph\t\n", "codedValues": [ { "name": "pH6 to pH9", "code": "pH6 to pH9" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pH_Acceptable", "type": "esriFieldTypeString", "alias": "Is pH within acceptable range?", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pH7_Standard", "type": "esriFieldTypeDouble", "alias": "pH 7.0 Standard", "domain": null }, { "name": "pH7_Standard_Range", "type": "esriFieldTypeString", "alias": "Acceptable pH 7.0 Standard range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_pH7 standard", "description": "pH7 standard", "codedValues": [ { "name": "pH 7.0", "code": "pH 7.0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pH7_Standard_Acceptable", "type": "esriFieldTypeString", "alias": "Is pH 7.0 Standard within acceptable range?", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Conductivity", "type": "esriFieldTypeDouble", "alias": "Conductivity", "domain": null }, { "name": "Conductivity_Range", "type": "esriFieldTypeString", "alias": "Conductivity_Range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Conductivity range", "description": "Conductivity range", "codedValues": [ { "name": "50 to 1500 uS/cm", "code": "50 to 1500 uS/cm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Conductivity_Acceptable", "type": "esriFieldTypeString", "alias": "Conductivity_Acceptable", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Conductivity_Standard", "type": "esriFieldTypeDouble", "alias": "Conductivity_Standard", "domain": null }, { "name": "Conductivity_Standard_Range", "type": "esriFieldTypeString", "alias": "Conductivity_Standard", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Conductivity Standard Rang", "description": "Conductivity Standard Rang", "codedValues": [ { "name": "447 uS/cm", "code": "447 uS/cm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Conductivity_Standard_Acceptabl", "type": "esriFieldTypeString", "alias": "Conductivity_Standard", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Salinity", "type": "esriFieldTypeDouble", "alias": "Salinity", "domain": null }, { "name": "Salinity_Range", "type": "esriFieldTypeString", "alias": "Salinity_Range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Salinity Range", "description": "Salinity Range", "codedValues": [ { "name": "0.5 to 30 ppt", "code": "0.5 to 30 ppt" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Salinity_Acceptable", "type": "esriFieldTypeString", "alias": "Salinity_Acceptable", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Detergents_Range", "type": "esriFieldTypeString", "alias": "Detergents_Range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Detergent Range", "description": "Detergent Range", "codedValues": [ { "name": "<0.25 mg/l", "code": "<0.25 mg/l" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Detergents_Acceptable", "type": "esriFieldTypeString", "alias": "Detergents_Acceptable", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Chlorine", "type": "esriFieldTypeDouble", "alias": "Chlorine", "domain": null }, { "name": "Chlorine_Range", "type": "esriFieldTypeString", "alias": "Chlorine_Range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Chlorine Range", "description": "Chlorine Range", "codedValues": [ { "name": "<0.02 mg/l", "code": "<0.02 mg/l" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Chlorine_Acceptable", "type": "esriFieldTypeString", "alias": "Chlorine_Acceptable", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Ammonia", "type": "esriFieldTypeDouble", "alias": "Ammonia", "domain": null }, { "name": "Ammonia_Range", "type": "esriFieldTypeString", "alias": "Acceptable ammonia range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Ammonia Range", "description": "Ammonia Range", "codedValues": [ { "name": "<0.5 mg/l", "code": "<0.5 mg/l" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Ammonia_Acceptable", "type": "esriFieldTypeString", "alias": "Ia ammonia in acceptable range?", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Lab_Sample", "type": "esriFieldTypeString", "alias": "LabSample", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Collected_From", "type": "esriFieldTypeString", "alias": "Collected_From", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Collected from", "description": "Collected from", "codedValues": [ { "name": "Flow", "code": "Flow" }, { "name": "Pool", "code": "Pool" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Type", "type": "esriFieldTypeString", "alias": "Sample_Type", "length": 50, "domain": { "type": "codedValue", "name": "WS12_sample Type", "description": "sample Type", "codedValues": [ { "name": "E. Coli", "code": "E. Coli" }, { "name": "Enterococci", "code": "Enterococci" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Labelled", "type": "esriFieldTypeString", "alias": "Sample_Labelled", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Collector", "type": "esriFieldTypeString", "alias": "Collector", "length": 50, "domain": null }, { "name": "LabResult_Ecoli", "type": "esriFieldTypeDouble", "alias": "LabResult_Ecoli", "domain": null }, { "name": "LabResult_Ecoli_Range", "type": "esriFieldTypeString", "alias": "LabResult_Ecoli_Range", "length": 50, "domain": { "type": "codedValue", "name": "WS12_E. Coli Range", "description": "E. Coli Range", "codedValues": [ { "name": "235 cfu per100 ml", "code": "235 cfu per100 ml" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LabResult_Ecoli_Acceptable", "type": "esriFieldTypeString", "alias": "_LabResult_Ecoli_Acceptable", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LabResult_Enterocci", "type": "esriFieldTypeDouble", "alias": "LabResult_Enterocci", "domain": null }, { "name": "LabResult_Enterocci_Range", "type": "esriFieldTypeString", "alias": "LabResult_Enterocci", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Enterococci Range", "description": "Enterococci Range", "codedValues": [ { "name": "61 cfu per 100ml", "code": "61 cfu per 100ml" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LabResult_Enterocci_Acceptable", "type": "esriFieldTypeString", "alias": "LabResult_Enterocci", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Name of inspector", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Inspection date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Name of editor", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Date record was last edited", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "LabResult_Fecal", "type": "esriFieldTypeDouble", "alias": "LabResult_Fecal", "domain": null }, { "name": "LabResult_Fecal_Range", "type": "esriFieldTypeString", "alias": "LabResult_FecalColiform_RANGE", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Fecal Coliform Range", "description": "Fecal Coliform Range", "codedValues": [ { "name": "??? cfu per 100ml", "code": "??? cfu per 100ml" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LabResult_Fecal_Acceptable", "type": "esriFieldTypeString", "alias": "LabResult_Fecal_Acceptable", "length": 50, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Duplicate_Sampling", "type": "esriFieldTypeString", "alias": "Duplicate Sampling", "length": 5, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Control_Sampling", "type": "esriFieldTypeString", "alias": "Control Sampling", "length": 5, "domain": { "type": "codedValue", "name": "WS12_Yes/No", "description": "Yes No Selection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Conductivity_Standard_Temperatu", "type": "esriFieldTypeString", "alias": "pH7 Standard Temperature", "length": 50, "domain": null }, { "name": "pH7_Standard_Temperature", "type": "esriFieldTypeString", "alias": "pH7 Standard Temperature", "length": 50, "domain": null }, { "name": "Detergents", "type": "esriFieldTypeString", "alias": "Detergents", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R111_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1053GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "dCatchbasin", "relatedTableId": 94, "role": "esriRelRoleDestination", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2F6915A6-2D0B-4ADC-9507-D3F818FA9AE4}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 4000, "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": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }