{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "Raw Data (GWCD)", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LabName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Record_uid", "type": "esriFieldTypeString", "alias": "Record_uid", "length": 2000, "domain": null }, { "name": "VT_StateLab_id", "type": "esriFieldTypeString", "alias": "VT_StateLab_id", "length": 2000, "domain": null }, { "name": "LabName", "type": "esriFieldTypeString", "alias": "LabName", "length": 2000, "domain": null }, { "name": "LabMailingAddressLine1", "type": "esriFieldTypeString", "alias": "LabMailingAddressLine1", "length": 2000, "domain": null }, { "name": "LabMailingAddressLine2", "type": "esriFieldTypeString", "alias": "LabMailingAddressLine2", "length": 2000, "domain": null }, { "name": "LabMailingAddressCity", "type": "esriFieldTypeString", "alias": "LabMailingAddressCity", "length": 2000, "domain": null }, { "name": "LabMailingAddressState", "type": "esriFieldTypeString", "alias": "LabMailingAddressState", "length": 2000, "domain": null }, { "name": "LabMailingAddressZip", "type": "esriFieldTypeString", "alias": "LabMailingAddressZip", "length": 2000, "domain": null }, { "name": "LabContact", "type": "esriFieldTypeString", "alias": "LabContact", "length": 2000, "domain": null }, { "name": "LabContactEmail", "type": "esriFieldTypeString", "alias": "LabContactEmail", "length": 2000, "domain": null }, { "name": "LabCertificationExpirationDate", "type": "esriFieldTypeDate", "alias": "LabCertificationExpirationDate", "length": 8, "domain": null }, { "name": "ClientName", "type": "esriFieldTypeString", "alias": "ClientName", "length": 2000, "domain": null }, { "name": "ClientMailingAddressLine1", "type": "esriFieldTypeString", "alias": "ClientMailingAddressLine1", "length": 2000, "domain": null }, { "name": "ClientMailingAddressLine2", "type": "esriFieldTypeString", "alias": "ClientMailingAddressLine2", "length": 2000, "domain": null }, { "name": "ClientMailingAddressCity", "type": "esriFieldTypeString", "alias": "ClientMailingAddressCity", "length": 2000, "domain": null }, { "name": "ClientMailingAddressState", "type": "esriFieldTypeString", "alias": "ClientMailingAddressState", "length": 2000, "domain": null }, { "name": "ClientMailingAddressZip", "type": "esriFieldTypeString", "alias": "ClientMailingAddressZip", "length": 2000, "domain": null }, { "name": "ClientEmail", "type": "esriFieldTypeString", "alias": "ClientEmail", "length": 2000, "domain": null }, { "name": "ClientPhoneNumber", "type": "esriFieldTypeString", "alias": "ClientPhoneNumber", "length": 2000, "domain": null }, { "name": "Test_id", "type": "esriFieldTypeString", "alias": "Test_id", "length": 2000, "domain": null }, { "name": "ReceivedDateTime", "type": "esriFieldTypeDate", "alias": "ReceivedDateTime", "length": 8, "domain": null }, { "name": "SampleCollector", "type": "esriFieldTypeString", "alias": "SampleCollector", "length": 2000, "domain": null }, { "name": "SampleCollectionDateTime", "type": "esriFieldTypeDate", "alias": "SampleCollectionDateTime", "length": 8, "domain": null }, { "name": "SampleLocationPhysicalAddress1", "type": "esriFieldTypeString", "alias": "SampleLocationPhysicalAddressLine1", "length": 2000, "domain": null }, { "name": "SampleLocationPhysicalAddress2", "type": "esriFieldTypeString", "alias": "SampleLocationPhysicalAddressLine2", "length": 2000, "domain": null }, { "name": "SampleLocationPhysicalAddressCi", "type": "esriFieldTypeString", "alias": "SampleLocationPhysicalAddressCity", "length": 2000, "domain": null }, { "name": "SampleLocationPhysicalAddressSt", "type": "esriFieldTypeString", "alias": "SampleLocationPhysicalAddressState", "length": 2000, "domain": null }, { "name": "SampleLocationPhysicalAddressZi", "type": "esriFieldTypeString", "alias": "SampleLocationPhysicalAddressZip", "length": 2000, "domain": null }, { "name": "SamplingLocationDescription", "type": "esriFieldTypeString", "alias": "SamplingLocationDescription", "length": 2000, "domain": null }, { "name": "SPAN", "type": "esriFieldTypeString", "alias": "SPAN", "length": 2000, "domain": null }, { "name": "WaterSource", "type": "esriFieldTypeString", "alias": "WaterSource", "length": 2000, "domain": null }, { "name": "Chlorinated", "type": "esriFieldTypeString", "alias": "Chlorinated", "length": 2000, "domain": null }, { "name": "Composite", "type": "esriFieldTypeString", "alias": "Composite", "length": 2000, "domain": null }, { "name": "pH", "type": "esriFieldTypeDouble", "alias": "pH", "domain": null }, { "name": "Preservative", "type": "esriFieldTypeString", "alias": "Preservative", "length": 2000, "domain": null }, { "name": "SampleAmount", "type": "esriFieldTypeDouble", "alias": "SampleAmount", "domain": null }, { "name": "SampleAmountUnit", "type": "esriFieldTypeString", "alias": "SampleAmountUnit", "length": 2000, "domain": null }, { "name": "SampleVolume", "type": "esriFieldTypeDouble", "alias": "SampleVolume", "domain": null }, { "name": "SampleVolumeUnit", "type": "esriFieldTypeString", "alias": "SampleVolumeUnit", "length": 2000, "domain": null }, { "name": "SampleWeight", "type": "esriFieldTypeDouble", "alias": "SampleWeight", "domain": null }, { "name": "SampleWeightUnit", "type": "esriFieldTypeString", "alias": "SampleWeightUnit", "length": 2000, "domain": null }, { "name": "SampleStartTime", "type": "esriFieldTypeDate", "alias": "SampleStartTime", "length": 8, "domain": null }, { "name": "SampleFinishTime", "type": "esriFieldTypeDate", "alias": "SampleFinishTime", "length": 8, "domain": null }, { "name": "SampleStartVolume", "type": "esriFieldTypeDouble", "alias": "SampleStartVolume", "domain": null }, { "name": "SampleStartVolumeUnit", "type": "esriFieldTypeString", "alias": "SampleStartVolumeUnit", "length": 2000, "domain": null }, { "name": "SampleFinishVolume", "type": "esriFieldTypeDouble", "alias": "SampleFinishVolume", "domain": null }, { "name": "SampleFinishVolumeUnit", "type": "esriFieldTypeString", "alias": "SampleFinishVolumeUnit", "length": 2000, "domain": null }, { "name": "SampleTemperature", "type": "esriFieldTypeDouble", "alias": "SampleTemperature", "domain": null }, { "name": "SampleTemperatureUnit", "type": "esriFieldTypeString", "alias": "SampleTemperatureUnit", "length": 2000, "domain": null }, { "name": "AnalyteName", "type": "esriFieldTypeString", "alias": "AnalyteName", "length": 2000, "domain": null }, { "name": "CAS_RegistryNumber", "type": "esriFieldTypeString", "alias": "CAS_RegistryNumber", "length": 2000, "domain": null }, { "name": "Result", "type": "esriFieldTypeString", "alias": "Result", "length": 2000, "domain": null }, { "name": "WHResultValueNumeric", "type": "esriFieldTypeDouble", "alias": "WHResultValueNumeric", "domain": null }, { "name": "WHResultValueAlpha", "type": "esriFieldTypeString", "alias": "WHResultValueAlpha", "length": 2000, "domain": null }, { "name": "ResultUnit", "type": "esriFieldTypeString", "alias": "ResultUnit", "length": 2000, "domain": null }, { "name": "ResultUncertainty", "type": "esriFieldTypeDouble", "alias": "ResultUncertainty", "domain": null }, { "name": "WHResultUncertainty", "type": "esriFieldTypeDouble", "alias": "WHResultUncertainty", "domain": null }, { "name": "ResultType", "type": "esriFieldTypeString", "alias": "ResultType", "length": 2000, "domain": null }, { "name": "WHResultType", "type": "esriFieldTypeString", "alias": "WHResultType", "length": 2000, "domain": null }, { "name": "WHCombinedResult", "type": "esriFieldTypeString", "alias": "WHCombinedResult", "length": 2000, "domain": null }, { "name": "ReportingLimit", "type": "esriFieldTypeDouble", "alias": "ReportingLimit", "domain": null }, { "name": "ReportingLimitUnit", "type": "esriFieldTypeString", "alias": "ReportingLimitUnit", "length": 2000, "domain": null }, { "name": "ReportingLimitType", "type": "esriFieldTypeString", "alias": "ReportingLimitType", "length": 2000, "domain": null }, { "name": "QualifiersAndNotes", "type": "esriFieldTypeString", "alias": "QualifiersAndNotes", "length": 2000, "domain": null }, { "name": "RejectionReason", "type": "esriFieldTypeString", "alias": "RejectionReason", "length": 2000, "domain": null }, { "name": "AnalyzedDateTime", "type": "esriFieldTypeDate", "alias": "AnalyzedDateTime", "length": 8, "domain": null }, { "name": "AnalyzedAmount", "type": "esriFieldTypeDouble", "alias": "AnalyzedAmount", "domain": null }, { "name": "AnalyzedAmountUnit", "type": "esriFieldTypeString", "alias": "AnalyzedAmountUnit", "length": 2000, "domain": null }, { "name": "AnalysisType", "type": "esriFieldTypeString", "alias": "AnalysisType", "length": 2000, "domain": null }, { "name": "DilutionFactor", "type": "esriFieldTypeDouble", "alias": "DilutionFactor", "domain": null }, { "name": "TestMethodName", "type": "esriFieldTypeString", "alias": "TestMethodName", "length": 2000, "domain": null }, { "name": "TestMethodCode", "type": "esriFieldTypeString", "alias": "TestMethodCode", "length": 2000, "domain": null }, { "name": "LabQualifiersDefinition", "type": "esriFieldTypeString", "alias": "LabQualifiersDefinition", "length": 2000, "domain": null }, { "name": "ReportedDateTime", "type": "esriFieldTypeDate", "alias": "ReportedDateTime", "length": 8, "domain": null }, { "name": "ClientNotes", "type": "esriFieldTypeString", "alias": "ClientNotes", "length": 2000, "domain": null }, { "name": "ReportType", "type": "esriFieldTypeString", "alias": "ReportType", "length": 2000, "domain": null }, { "name": "SubcontractedResults", "type": "esriFieldTypeString", "alias": "SubcontractedResults", "length": 2000, "domain": null }, { "name": "VT_WellTag_id", "type": "esriFieldTypeString", "alias": "VT_WellTag_id", "length": 2000, "domain": null }, { "name": "SampleLatitude", "type": "esriFieldTypeString", "alias": "SampleLatitude", "length": 2000, "domain": null }, { "name": "SampleLongitude", "type": "esriFieldTypeString", "alias": "SampleLongitude", "length": 2000, "domain": null }, { "name": "SampleLatitudeLongitudeFormat", "type": "esriFieldTypeString", "alias": "SampleLatitudeLongitudeFormat", "length": 2000, "domain": null }, { "name": "PostTreatmentSample", "type": "esriFieldTypeString", "alias": "PostTreatmentSample", "length": 2000, "domain": null }, { "name": "AdditionalEmail", "type": "esriFieldTypeString", "alias": "AdditionalEmail", "length": 2000, "domain": null }, { "name": "FileName", "type": "esriFieldTypeString", "alias": "FileName", "length": 2000, "domain": null }, { "name": "FilePosition", "type": "esriFieldTypeString", "alias": "FilePosition", "length": 2000, "domain": null }, { "name": "InsertUser", "type": "esriFieldTypeString", "alias": "InsertUser", "length": 2000, "domain": null }, { "name": "InsertDate", "type": "esriFieldTypeDate", "alias": "InsertDate", "length": 8, "domain": null }, { "name": "LastUpdateUser", "type": "esriFieldTypeString", "alias": "LastUpdateUser", "length": 2000, "domain": null }, { "name": "LastUpdateDate", "type": "esriFieldTypeDate", "alias": "LastUpdateDate", "length": 8, "domain": null }, { "name": "ConcatAddress", "type": "esriFieldTypeString", "alias": "ConcatAddress", "length": 2000, "domain": null }, { "name": "AnalyteAlias", "type": "esriFieldTypeString", "alias": "AnalyteAlias", "length": 200, "domain": null } ], "indexes": [ { "name": "R305_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "RawDataIndex", "fields": "LabName,SampleLocationPhysicalAddressCi,WaterSource,AnalyteName", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "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 } }