{ "currentVersion": 10.61, "id": 14, "name": "WQMS.dbo.WQMSMain", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GISSourceName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "BasinCode", "type": "esriFieldTypeString", "alias": "BasinCode", "length": 8, "domain": null }, { "name": "GISSourceNameID", "type": "esriFieldTypeSmallInteger", "alias": "GISSourceNameID", "domain": null }, { "name": "BasinCodeAlpha", "type": "esriFieldTypeString", "alias": "BasinCodeAlpha", "length": 3, "domain": null }, { "name": "BasinCodeNumeric", "type": "esriFieldTypeString", "alias": "BasinCodeNumeric", "length": 4, "domain": null }, { "name": "BasinCodeSeries", "type": "esriFieldTypeString", "alias": "BasinCodeSeries", "length": 1, "domain": null }, { "name": "Segment", "type": "esriFieldTypeString", "alias": "Segment", "length": 2, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 1, "domain": null }, { "name": "InactiveDate", "type": "esriFieldTypeDate", "alias": "InactiveDate", "length": 8, "domain": null }, { "name": "StationTypeNew", "type": "esriFieldTypeString", "alias": "StationTypeNew", "length": 13, "domain": null }, { "name": "StationType", "type": "esriFieldTypeString", "alias": "StationType", "length": 5, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 200, "domain": null }, { "name": "DetailInformation", "type": "esriFieldTypeString", "alias": "DetailInformation", "length": 1000, "domain": null }, { "name": "Ecoregion", "type": "esriFieldTypeString", "alias": "Ecoregion", "length": 4, "domain": null }, { "name": "DateOpened", "type": "esriFieldTypeDate", "alias": "DateOpened", "length": 8, "domain": null }, { "name": "County", "type": "esriFieldTypeString", "alias": "County", "length": 2, "domain": null }, { "name": "County_NonAR", "type": "esriFieldTypeString", "alias": "County_NonAR", "length": 20, "domain": null }, { "name": "StateAbbrev", "type": "esriFieldTypeString", "alias": "StateAbbrev", "length": 2, "domain": null }, { "name": "HUC", "type": "esriFieldTypeString", "alias": "HUC", "length": 12, "domain": null }, { "name": "Flow", "type": "esriFieldTypeString", "alias": "Flow", "length": 2, "domain": null }, { "name": "WebsiteYN", "type": "esriFieldTypeString", "alias": "WebsiteYN", "length": 1, "domain": null }, { "name": "USGSNumber", "type": "esriFieldTypeString", "alias": "USGSNumber", "length": 8, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeString", "alias": "Latitude", "length": 8, "domain": null }, { "name": "LatDMS", "type": "esriFieldTypeString", "alias": "LatDMS", "length": 9, "domain": null }, { "name": "LatitudeDMS", "type": "esriFieldTypeDouble", "alias": "LatitudeDMS", "domain": null }, { "name": "LatDMSDegree", "type": "esriFieldTypeString", "alias": "LatDMSDegree", "length": 2, "domain": null }, { "name": "LatDMSMinute", "type": "esriFieldTypeString", "alias": "LatDMSMinute", "length": 2, "domain": null }, { "name": "LatDMSSecond", "type": "esriFieldTypeDouble", "alias": "LatDMSSecond", "domain": null }, { "name": "LatitudeDecimal", "type": "esriFieldTypeDouble", "alias": "LatitudeDecimal", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeString", "alias": "Longitude", "length": 9, "domain": null }, { "name": "LongDMS", "type": "esriFieldTypeString", "alias": "LongDMS", "length": 10, "domain": null }, { "name": "LongitudeDMS", "type": "esriFieldTypeDouble", "alias": "LongitudeDMS", "domain": null }, { "name": "LongDMSDegree", "type": "esriFieldTypeString", "alias": "LongDMSDegree", "length": 3, "domain": null }, { "name": "LongDMSMinute", "type": "esriFieldTypeString", "alias": "LongDMSMinute", "length": 2, "domain": null }, { "name": "LongDMSSecond", "type": "esriFieldTypeDouble", "alias": "LongDMSSecond", "domain": null }, { "name": "LongitudeDecimal", "type": "esriFieldTypeDouble", "alias": "LongitudeDecimal", "domain": null }, { "name": "GISSourceName", "type": "esriFieldTypeString", "alias": "GISSourceName", "length": 50, "domain": null }, { "name": "ADEQCollectorCode", "type": "esriFieldTypeString", "alias": "ADEQCollectorCode", "length": 10, "domain": null }, { "name": "CollectorName", "type": "esriFieldTypeString", "alias": "CollectorName", "length": 50, "domain": null }, { "name": "DateMeasured", "type": "esriFieldTypeDate", "alias": "DateMeasured", "length": 8, "domain": null }, { "name": "GPSReceiverTypeName", "type": "esriFieldTypeString", "alias": "GPSReceiverTypeName", "length": 50, "domain": null }, { "name": "ReceiverChannels", "type": "esriFieldTypeString", "alias": "ReceiverChannels", "length": 10, "domain": null }, { "name": "BaseStationName", "type": "esriFieldTypeString", "alias": "BaseStationName", "length": 50, "domain": null }, { "name": "Distance", "type": "esriFieldTypeString", "alias": "Distance", "length": 3, "domain": null }, { "name": "GISComment", "type": "esriFieldTypeString", "alias": "GISComment", "length": 50, "domain": null }, { "name": "ProjectInformation", "type": "esriFieldTypeString", "alias": "ProjectInformation", "length": 50, "domain": null }, { "name": "StationOriginatedBy", "type": "esriFieldTypeString", "alias": "StationOriginatedBy", "length": 50, "domain": null }, { "name": "InspectorRunCode", "type": "esriFieldTypeString", "alias": "InspectorRunCode", "length": 10, "domain": null }, { "name": "WQXMonLocTypeCode", "type": "esriFieldTypeString", "alias": "WQXMonLocTypeCode", "length": 2, "domain": null }, { "name": "WellType", "type": "esriFieldTypeString", "alias": "WellType", "length": 255, "domain": null }, { "name": "AquiferName", "type": "esriFieldTypeString", "alias": "AquiferName", "length": 120, "domain": null }, { "name": "WellFormationType", "type": "esriFieldTypeString", "alias": "WellFormationType", "length": 50, "domain": null }, { "name": "WellHoleDepthMeasure", "type": "esriFieldTypeString", "alias": "WellHoleDepthMeasure", "length": 12, "domain": null }, { "name": "WellHoleDepthMeasureUnit", "type": "esriFieldTypeString", "alias": "WellHoleDepthMeasureUnit", "length": 12, "domain": null }, { "name": "RecordCreatedBy", "type": "esriFieldTypeString", "alias": "RecordCreatedBy", "length": 20, "domain": null }, { "name": "RecordCreatedByID", "type": "esriFieldTypeString", "alias": "RecordCreatedByID", "length": 8, "domain": null }, { "name": "RecordCreatedDate", "type": "esriFieldTypeDate", "alias": "RecordCreatedDate", "length": 8, "domain": null }, { "name": "RecordModifiedBy", "type": "esriFieldTypeString", "alias": "RecordModifiedBy", "length": 20, "domain": null }, { "name": "RecordModifiedByID", "type": "esriFieldTypeString", "alias": "RecordModifiedByID", "length": 8, "domain": null }, { "name": "RecordModifiedDate", "type": "esriFieldTypeDate", "alias": "RecordModifiedDate", "length": 8, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null }, { "name": "Reach", "type": "esriFieldTypeString", "alias": "Reach", "length": 4, "domain": null }, { "name": "AssessmentUnit", "type": "esriFieldTypeString", "alias": "AssessmentUnit", "length": 20, "domain": null }, { "name": "WatershedSize", "type": "esriFieldTypeString", "alias": "WatershedSize", "length": 15, "domain": null } ], "indexes": [ { "name": "FDO_ESRI_OID", "fields": "ESRI_OID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I4BasinCode", "fields": "BasinCode", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": false, "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 }