{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Production.LI.PrivateWaterWells", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103191, "latestWkid": 6609, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118083400, "falseY": -97411200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "02ffdb8d8976cc94251b044cb47e3dce", "imageData": "iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEW0lEQVRYhe1Xa0xbdRQ/t/dBX7Qd7YAOFgoTKTBtIoOYoC7RoYt+8NNcdDNjCQ7M5nj4QeOzGvUbg01xOEk2o4tBjckcmH1Ak2mWCRMNOqAdoYWU0UJpoS9uex9c86+6wO1tbzc1i9Ff0jQ5//M/53fO/zxaAm4ziP8JwL/pCTo6h22qHKotwiV2xTh2U5znlMIahqlInFbjxJIapy4E+Ojxvvadk38rgRd6f7JxDH/WEw1XUxwOVl0emDdpIJeikucRhtF4V2MaRzjYzPB8c2v38GgIiz95pnXn1F8mYO8ZsztXgq/pSArbv60SakwFgGMKSV1eWIPRpQUY8LhrGE5wdJwYOXLsaN3JWybwas/Pn42Hlvbcm2+GvaUVQKRx/CcQsbrNZrjHVAD9Lqdi2O99v6P7StWxttrnbprAGx+MvXU1sLTnsa1lsLvIktFxilFMAfu2VYJRqYKvPa4jHSdGJtJlgpASdvVdrR8J+F9Ckd+s8/VAdwNxGkYDi+81Hr84JFUThNRFLx3/WEdQGEp7OggAEGWZ5HcuSQGWRm9vWQVcCy8rlALxKQDskCXQ9aHjwcv+66X776iSfHNeEOCb+Vn4bmEOQgyTlOkpCh4oKIaHtpQAjm2kgmw8WlwGZ6cnapq6LlaKW5QQO4ivsW05OA41xnxJ56ecv8DESmCDHBE573HBdCQEhyruTiGxw5QPX8w4wYhrWwGgJSMBP03XW/V5kq2GIhc7Xw90hnQeFtUNslWhy4OFeGy3+A4hFkR5NrdaZUwxjt4apV0OSKehyJJSE4VqDbhjIZMsgRjLkjry9wm3HhGWufHmmYB0kK7Yho6igGZ5lSyBdBBQCrJEuo7AFKlWCLFAQ5BcmGVS5CgCVO1yWUA6WqkMMgwocSIuSyCXpKI+OmZIYQ8A9xcUw4DHlZEAakepDHhXYyi4ZVkCm1XqK+PL/gbUcuJ22rWlBFyRUNpOqDIYk7NAakk5wkEo0eiHZAkYcqieOM83jAYWoM5UuOEMEUJ9PjQ/C99nOYgQ0IZkeB7oBNMtS6DlQPm5F9/90TfocRWiYSSeB8jBI0WWZK+HGQaQv0yjmBPWYHDODVu1uvHOo7VjsgQQLFr9oRnf3Ff97mvwVJkVpID9Ebkc+t1OCLOMYNCo9kmdE1LCloPl5zv7Js9cXpxvNOYokxHfCi5cn4EfFr1QrTe9aW+xjWVNAOH5psqDb5/8tXzA46oPJOLwROmdsj9I1qcdRY6cW/V5n9sP2+zpdIlMhl5+9q77OvsmT4/4fY3OUDC51dBiyfiTLLAIgx4XhDlG2G40vfN6s+2VTD4IuWhQJnpPT305Ew2d+mR6ohBtNbSszGptsvjQiAyzDPjoGDhCQUjwPFhy9W6rXv90e9P2S3L2CcgCqCYAwNz70dTjKwnmsJ9erZ2NRrQxjk3e15Akq8XJSJXBeEmpILvbn7F+m43drAncIHKg/BwAoM9/9J/RP4HbTuA3dK/IM7DG4bwAAAAASUVORK5CYII=", "contentType": "image/png", "width": 24, "height": 24, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1690690.9838192165, "ymin": -97045.44398710132, "xmax": 2559548.6634232253, "ymax": 1235806.7026392221, "spatialReference": { "wkid": 103191, "latestWkid": 6609, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118121300, "falseY": -97418300, "xyUnits": 3.750193294826451E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "LASTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SAMPLE", "type": "esriFieldTypeInteger", "alias": "SAMPLE", "domain": null }, { "name": "TAXID", "type": "esriFieldTypeString", "alias": "TAXID", "length": 20, "domain": null }, { "name": "LAT", "type": "esriFieldTypeString", "alias": "LAT", "length": 50, "domain": null }, { "name": "LONG", "type": "esriFieldTypeString", "alias": "LONG", "length": 50, "domain": null }, { "name": "WI_WELL_ID", "type": "esriFieldTypeString", "alias": "WI_WELL_ID", "length": 20, "domain": null }, { "name": "LASTNAME", "type": "esriFieldTypeString", "alias": "LASTNAME", "length": 20, "domain": null }, { "name": "FIRSTNAME", "type": "esriFieldTypeString", "alias": "FIRSTNAME", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 25, "domain": null }, { "name": "DATE_COLL", "type": "esriFieldTypeDate", "alias": "DATE_COLL", "length": 8, "domain": null }, { "name": "TIME_COLL", "type": "esriFieldTypeString", "alias": "TIME_COLL", "length": 20, "domain": null }, { "name": "COLL_BY", "type": "esriFieldTypeString", "alias": "COLL_BY", "length": 20, "domain": null }, { "name": "DATE_ANA", "type": "esriFieldTypeDate", "alias": "DATE_ANA", "length": 8, "domain": null }, { "name": "ANALYST", "type": "esriFieldTypeString", "alias": "ANALYST", "length": 10, "domain": null }, { "name": "COLIF_RES", "type": "esriFieldTypeString", "alias": "COLIF_RES", "length": 10, "domain": null }, { "name": "E_COLI_RES", "type": "esriFieldTypeString", "alias": "E_COLI_RES", "length": 10, "domain": null }, { "name": "NITR_RES", "type": "esriFieldTypeDouble", "alias": "NITR_RES", "domain": null }, { "name": "ARSEN_RES", "type": "esriFieldTypeString", "alias": "ARSEN_RES", "length": 15, "domain": null }, { "name": "OWN_EMAIL", "type": "esriFieldTypeString", "alias": "OWN_EMAIL", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R769_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_769", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_769", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S679_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Private_GWR", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D60F7969-D466-452F-AAAC-0B6B75107CB5}" }, { "id": 5, "name": "Private_Inorganics", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{31580AFA-2921-4BBD-A2F0-2DC1846B177F}" }, { "id": 2, "name": "Private_Arsenic", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7F96A700-B9FE-40B2-8E96-36B523A370E8}" }, { "id": 0, "name": "Private_Bacteria", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{204FFFAE-DDB7-4043-8754-40C4C1AE8FD2}" }, { "id": 3, "name": "Private_Nitrate", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{60D0BB69-846D-4F8B-BE4A-AE0C5D79278D}" }, { "id": 4, "name": "PrivateWells_SiteVisitForm", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6A09E27D-2F6B-4F92-ADA6-CFA4B9CA7813}" }, { "id": 6, "name": "Private_Lead", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{43267FC2-6D25-4350-B45E-FD75BF9F9C45}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Production.LI.PublicWaterWells", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103191, "latestWkid": 6609, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118083400, "falseY": -97411200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "7c54d6a9c29dd0af73e4578eb46c1a56", "imageData": "iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEdUlEQVRYhe1Xa0wcVRQ+uzuzM/uC7gNYFqFKrUlZEwoLJeFhEyPqPxPTagwxUjVCbAnV6A8tsdVQ/aGpbSIIxgfGENNqmrT94w80qQgKZbcSAQ1FsIussB0W9j2zOztjzlY2ZXeGxVLTGP2Sycycufec757HPXcIuM0g/icA/6YQtPQMltMEcTjKxh/g4qIxFk/QogAKNaWMUqSKUZOqr7hI/NSHL+z9+ZYSaOsZKU9Aop/xRe0EwYOtQAvGXDVo6OvToyyvW/HHdJ6lSAvPCy0tXYNOjhee6Gvfe2XLBF78aOTYAhN+TUsTioY9BbCjJAeUSoXkWEEQ4Vd3AFwTPgfHJX5p7R061NNS9/5NE2j/+Icz84uh/feU5kBtZQGoZAyvAYntvDMXSktyYNi5pLwyF+h+vmu4rPtgbdvfJvBS30jnVU9ov+NeC+wuM0mOWV5hk3ezkV4nR6IN1VYw6NTgmmAOtfYOTcl5gpASvnL6Ut3sb6FXceVyxhGuSV/y3lhvk/yOc4PhGMy6g+81n7o4IJUThNTEoD/+mZZWKtDtcrjm48DtCaWe80yU5LhaRwF4vFGlmlB8DgBVWQl0nBm/f3qGueu+GuuGMXdNMqnny1MMPFhfJDkOdVTazTA4uuh49t2Lu9JLlEifEOe4wwShhNJig6xxxsfC73+EU+/znnBSZjGtz4U17CgxwPcuL1Bash0AWjck4A/F6oqsWtlSQ0PfjXkz5Cirr8qXJIG6cO/wB2MPp38j0gVcTDAUF6ozlGCc0dW4Wiksr7JwbsANxTYdVJRZMnLCmKMGry9qyUqAZXlS+9cOl1S8wiazfS3hsgEJ4lVi00Ol3ZQqUY2GgBgnaLISAFjvejHtfStQKEHMSoCmVHyE5VNyi5FK1jnG3jm5vC75pHBHoQ4q7ZkhiLI8qEkVm5WAhlaFVgOxbelyTK6HGorg2jILQ05vMuY3wryNlk1CxIo/BhSpWMlKwGAgL80vhBsFEUCqEPLMNNQ58uH81+518o2MY5PyLEUgz0QPZCegIbvivNA46w7A3dtzJBUiCXT1Wjgw8+WMI7BD8rwALM+fzEqg49GKc229w4vOCcaKm5HcfuCwm1MEsOzkkBDEZBVZTJrJ7tba8awEEBYz9Zx3hj2PsW6olu4HuGIsNYRcH0AMu5YgwvKinqKapL4TUsKj+xwXjvSP9U3P+ZsNehJ275LuiBV2MygyKyuFH6d8MD0bgOIC/RsnnqkZ3zQBxPGmqgMvfzq60/kTUxcMxaHWkZ/RnLBE5dyOK0fjNqvuixNP1xy7qRPR20/tqT/SP/bJzNVAs8cbTtY3NpaNjmSz80FwTjAQYQVxu03/5jvNNR1bOhMeb6o68PqXzrPMMvfBt6OLVuxq2KyMudT1Q6koYoxhNRCDhcVIMtvzLZo5q5V88q3Hq4duyan46D7HBQAo7Dx7+ZFgNH4wGIxXMz5Oz3IJZAA0TcQptTJYXKgbIinqZOdj5d9sRu+mCdxYogCA13/0z+ifwG0n8Ce0EtDL0v3POAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 24, "height": 24, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2200793.166696802, "ymin": 114409.70429597795, "xmax": 2482546.6763513833, "ymax": 345894.5366009772, "spatialReference": { "wkid": 103191, "latestWkid": 6609, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118121300, "falseY": -97418300, "xyUnits": 3.750193294826451E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Id", "type": "esriFieldTypeInteger", "alias": "Id", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "DNR_Pub_ID", "type": "esriFieldTypeInteger", "alias": "DNR_Pub_ID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 30, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 15, "domain": { "type": "codedValue", "name": "WellStatus", "description": "The status of a Water Well", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "County", "type": "esriFieldTypeString", "alias": "County", "length": 10, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 20, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 50, "domain": null }, { "name": "RecentSurv", "type": "esriFieldTypeDate", "alias": "RecentSurv", "length": 8, "domain": null }, { "name": "Tax_Key", "type": "esriFieldTypeString", "alias": "Tax_Key", "length": 15, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 50, "domain": null }, { "name": "Nitrate", "type": "esriFieldTypeString", "alias": "Nitrate", "length": 20, "domain": null }, { "name": "Coliform_Bac", "type": "esriFieldTypeString", "alias": "Coliform_Bac", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LabResults", "type": "esriFieldTypeString", "alias": "LabResults", "length": 100, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R768_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_768", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_768", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S678_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "PublicWells_SiteVisitForm", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{02C38C69-3173-42C2-B1EF-286EE87A2B9D}" }, { "id": 7, "name": "Public_Bacteria", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{02D2080D-523C-425B-AE80-393C52B0D192}" }, { "id": 10, "name": "Public_GWR", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EDBECC8B-5C4C-4DA1-BF2D-42B074420905}" }, { "id": 11, "name": "Public_Nitrate", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8BC14E33-5AD4-463D-95B5-4A1C3B910402}" }, { "id": 13, "name": "Public_Inorganics", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F6EE4B91-5C7A-458E-A0C4-65EEBD3939CA}" }, { "id": 9, "name": "Public_Lead", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{09940724-827D-462D-8785-C1BCDB3EF4F4}" }, { "id": 12, "name": "Public_Arsenic", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9CC3BA37-9F43-4B1E-9FC7-F277D9E3BE4F}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Production.LI.PrivateWells_SiteVisitForm", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SystemName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SystemName", "type": "esriFieldTypeString", "alias": "System Name", "length": 50, "domain": null }, { "name": "PWSID", "type": "esriFieldTypeString", "alias": "PWSID#", "length": 50, "domain": null }, { "name": "ChangesLandUse", "type": "esriFieldTypeString", "alias": "Changes in nearby land use activity/potential new contamination sources (blasting, fire suppression, land spreading, septic issues)", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChangesVisibleIndicators", "type": "esriFieldTypeString", "alias": "ChangesVisibleIndicators", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChangesOther", "type": "esriFieldTypeString", "alias": "Other Changes", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChangesOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other changes", "length": 255, "domain": null }, { "name": "SourceConduitDamage", "type": "esriFieldTypeString", "alias": "Conduit damaged/missing", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceFloodwater", "type": "esriFieldTypeString", "alias": "Floodwater / runoff ponding / topped well", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceSealDamage", "type": "esriFieldTypeString", "alias": "Grout or seal around well damaged", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceVentDamage", "type": "esriFieldTypeString", "alias": "Vent damaged / unscreened", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceWellCasingDamage", "type": "esriFieldTypeString", "alias": "Well casing damaged / corroded", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceWellCapDamage", "type": "esriFieldTypeString", "alias": "Well cap / well seal damaged", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceOpenings", "type": "esriFieldTypeString", "alias": "Openings through well cap not watertight (bolts/wires/lines)", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceOther", "type": "esriFieldTypeString", "alias": "Other Source Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other source issues", "length": 255, "domain": null }, { "name": "ControlFlow", "type": "esriFieldTypeString", "alias": "Noncomplying flowing well piping", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlPipe", "type": "esriFieldTypeString", "alias": "Piping leak/ponding/wet along buried piping", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlFaucet", "type": "esriFieldTypeString", "alias": "Noncomplying well / entry point sampling faucet", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlOther", "type": "esriFieldTypeString", "alias": "Other Control Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other control issues", "length": 255, "domain": null }, { "name": "StoragePressure", "type": "esriFieldTypeString", "alias": "Pressure not holding", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StorageTank", "type": "esriFieldTypeString", "alias": "Tank deterioration, rust, holes", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StorageOther", "type": "esriFieldTypeString", "alias": "Other Storage Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StorageOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other storage issues", "length": 255, "domain": null }, { "name": "DistributionAirGaps", "type": "esriFieldTypeString", "alias": "Air gaps missing", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionDeadEnds", "type": "esriFieldTypeString", "alias": "Dead-end plumbing lines/devices not in use", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionLeak", "type": "esriFieldTypeString", "alias": "Leaking distribution piping", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionVacuum", "type": "esriFieldTypeString", "alias": "Vacuum breaker/backflow protection device missing or device required testing not current", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionProcedures", "type": "esriFieldTypeString", "alias": "Improper sample collection sites / procedures", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionOther", "type": "esriFieldTypeString", "alias": "Other Distribution Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other distribution issues", "length": 255, "domain": null }, { "name": "CorrectiveAction", "type": "esriFieldTypeString", "alias": "Description of Corrective Action (If required)", "length": 2000, "domain": null }, { "name": "CorrectiveActionDue", "type": "esriFieldTypeDate", "alias": "Corrective Action Due Date", "length": 8, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 50, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PrivateSiteVisitForm_GUID", "type": "esriFieldTypeGUID", "alias": "PrivateSiteVisitForm_GUID", "length": 38, "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R761_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_761", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3100PrivateSite", "fields": "PrivateSiteVisitForm_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_761", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PrivateSiteVisitForm_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6A09E27D-2F6B-4F92-ADA6-CFA4B9CA7813}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Production.LI.PublicWells_SiteVisitForm", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SystemName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SystemName", "type": "esriFieldTypeString", "alias": "System Name", "length": 50, "domain": null }, { "name": "PWSID", "type": "esriFieldTypeString", "alias": "PWSID#", "length": 50, "domain": null }, { "name": "ChangesLandUse", "type": "esriFieldTypeString", "alias": "Changes in nearby land use activity/potential new contamination sources (blasting, fire suppression, land spreading, septic issues)", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChangesVisibleIndicators", "type": "esriFieldTypeString", "alias": "ChangesVisibleIndicators", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChangesOther", "type": "esriFieldTypeString", "alias": "Other Changes", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ChangesOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other changes", "length": 255, "domain": null }, { "name": "SourceConduitDamage", "type": "esriFieldTypeString", "alias": "Conduit damaged/missing", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceFloodwater", "type": "esriFieldTypeString", "alias": "Floodwater / runoff ponding / topped well", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceSealDamage", "type": "esriFieldTypeString", "alias": "Grout or seal around well damaged", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceVentDamage", "type": "esriFieldTypeString", "alias": "Vent damaged / unscreened", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceWellCasingDamage", "type": "esriFieldTypeString", "alias": "Well casing damaged / corroded", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceWellCapDamage", "type": "esriFieldTypeString", "alias": "Well cap / well seal damaged", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceOpenings", "type": "esriFieldTypeString", "alias": "Openings through well cap not watertight (bolts/wires/lines)", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceOther", "type": "esriFieldTypeString", "alias": "Other Source Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other source issues", "length": 255, "domain": null }, { "name": "ControlFlow", "type": "esriFieldTypeString", "alias": "Noncomplying flowing well piping", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlPipe", "type": "esriFieldTypeString", "alias": "Piping leak/ponding/wet along buried piping", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlFaucet", "type": "esriFieldTypeString", "alias": "Noncomplying well / entry point sampling faucet", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlOther", "type": "esriFieldTypeString", "alias": "Other Control Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ControlOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other control issues", "length": 255, "domain": null }, { "name": "StoragePressure", "type": "esriFieldTypeString", "alias": "Pressure not holding", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StorageTank", "type": "esriFieldTypeString", "alias": "Tank deterioration, rust, holes", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StorageOther", "type": "esriFieldTypeString", "alias": "Other Storage Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StorageOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other storage issues", "length": 255, "domain": null }, { "name": "DistributionAirGaps", "type": "esriFieldTypeString", "alias": "Air gaps missing", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionDeadEnds", "type": "esriFieldTypeString", "alias": "Dead-end plumbing lines/devices not in use", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionLeak", "type": "esriFieldTypeString", "alias": "Leaking distribution piping", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionVacuum", "type": "esriFieldTypeString", "alias": "Vacuum breaker/backflow protection device missing or device required testing not current", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionProcedures", "type": "esriFieldTypeString", "alias": "Improper sample collection sites / procedures", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionOther", "type": "esriFieldTypeString", "alias": "Other Distribution Issues", "length": 50, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "Yes No N/A", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DistributionOtherDescription", "type": "esriFieldTypeString", "alias": "If other, describe the other distribution issues", "length": 255, "domain": null }, { "name": "CorrectiveAction", "type": "esriFieldTypeString", "alias": "Description of Corrective Action (If required)", "length": 2000, "domain": null }, { "name": "CorrectiveActionDue", "type": "esriFieldTypeDate", "alias": "Corrective Action Due Date", "length": 8, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 50, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "PublicSiteVisitForm_GUID", "type": "esriFieldTypeGUID", "alias": "PublicSiteVisitForm_GUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R758_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_758", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3097PublicSiteV", "fields": "PublicSiteVisitForm_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_758", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "PublicSiteVisitForm_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{02C38C69-3173-42C2-B1EF-286EE87A2B9D}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Production.LI.Public_Nitrate", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "PublicStatusTypes", "description": "Public Status Types", "codedValues": [ { "name": "Additional Routine", "code": "A" }, { "name": "Confirmation (Check)", "code": "C" }, { "name": "Compliance Sample", "code": "D" }, { "name": "Grab Sample", "code": "G" }, { "name": "Investigation", "code": "I" }, { "name": "Other Compliance", "code": "O" }, { "name": "Repeat", "code": "R" }, { "name": "Triggered Source Water", "code": "T" }, { "name": "Unknown", "code": "U" }, { "name": "Raw Water Sample", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Monitoring Point ID", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_ID_Num", "type": "esriFieldTypeString", "alias": "Laboratory ID Number\n", "length": 25, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Laboratory Name", "description": "Lab Name", "codedValues": [ { "name": "Walworth County Health and Human Services", "code": "Walworth County Health and Human Services" }, { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" }, { "name": "TGA Laboratories", "code": "TGA Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Smple_Recieved", "type": "esriFieldTypeDate", "alias": "Date Sample Recieved", "length": 8, "domain": null }, { "name": "ChlorineResidual_in_Sample", "type": "esriFieldTypeString", "alias": "Chlorine Residual in Sample", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Cond_Sample_Upon_Reciept", "type": "esriFieldTypeString", "alias": "Condition of Sample Upon Reciept / Other Comment", "length": 50, "domain": null }, { "name": "Recieving_Lab_Official", "type": "esriFieldTypeString", "alias": "Recieving Lab Official", "length": 50, "domain": null }, { "name": "Date_Reported_to_PWS", "type": "esriFieldTypeDate", "alias": "Date Reported to PWS", "length": 8, "domain": null }, { "name": "Storet_Code", "type": "esriFieldTypeString", "alias": "Storet Code", "length": 50, "domain": null }, { "name": "SDWA_Method", "type": "esriFieldTypeString", "alias": "SDWA Method", "length": 20, "domain": null }, { "name": "MDL", "type": "esriFieldTypeString", "alias": "MDL", "length": 50, "domain": null }, { "name": "MCL", "type": "esriFieldTypeString", "alias": "MCL", "length": 20, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "SamplePreserved_in_Field", "type": "esriFieldTypeString", "alias": "Sample Preserved in Field?", "length": 15, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "QualifierCode", "type": "esriFieldTypeString", "alias": "Qualifier Code", "length": 30, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Parameter", "type": "esriFieldTypeString", "alias": "Parameter", "length": 50, "domain": null }, { "name": "Results", "type": "esriFieldTypeDouble", "alias": "Nitrate Results", "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R753_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_753", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3092GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_753", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8BC14E33-5AD4-463D-95B5-4A1C3B910402}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Production.LI.Public_Arsenic", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": null }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "Lead_Sample_Type", "description": "Lead Sample Type", "codedValues": [ { "name": "Annual Test", "code": "Annual Test" }, { "name": "Taste/Odor", "code": "Taste/Odor" }, { "name": "Pump Work", "code": "Pump Work" }, { "name": "Previous Unsafe", "code": "Previous Unsafe" }, { "name": "Real Estate", "code": "Real Estate" }, { "name": "Infant Use", "code": "Infant Use" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Sample_Point_Description", "type": "esriFieldTypeString", "alias": "Sample Point Description", "length": 75, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Results", "type": "esriFieldTypeDouble", "alias": "Results", "domain": null } ], "indexes": [ { "name": "R754_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_754", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3093GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_754", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9CC3BA37-9F43-4B1E-9FC7-F277D9E3BE4F}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Production.LI.Public_Bacteria", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SmpleC_or_R_Pos_smple_Date", "type": "esriFieldTypeDate", "alias": "Sample Type C or R Positive Sample Date", "length": 8, "domain": null }, { "name": "SmpleC_or_R_Pos_smple_ID", "type": "esriFieldTypeString", "alias": "Sample Type C or R Positive Sample ID\n", "length": 50, "domain": null }, { "name": "WI_Unique_Well_Num", "type": "esriFieldTypeString", "alias": "WI Unique Well Number", "length": 50, "domain": null }, { "name": "Entry_Pnt_ID", "type": "esriFieldTypeString", "alias": "Entry Point ID\n", "length": 50, "domain": null }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Approved_Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Approved Monitoring Point ID\n\n", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_ID_Num", "type": "esriFieldTypeString", "alias": "Laboratory ID Number\n", "length": 25, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Laboratory Name", "description": "Lab Name", "codedValues": [ { "name": "Walworth County Health and Human Services", "code": "Walworth County Health and Human Services" }, { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" }, { "name": "TGA Laboratories", "code": "TGA Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Smple_Recieved", "type": "esriFieldTypeDate", "alias": "Date Sample Recieved", "length": 8, "domain": null }, { "name": "ChlorineResidual_in_Sample", "type": "esriFieldTypeString", "alias": "Chlorine Residual in Sample", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Cond_Sample_Upon_Reciept", "type": "esriFieldTypeString", "alias": "Condition of Sample Upon Reciept / Other Comment", "length": 50, "domain": null }, { "name": "Recieving_Lab_Official", "type": "esriFieldTypeString", "alias": "Recieving Lab Official", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Total_Coliform_Storet", "type": "esriFieldTypeString", "alias": "Total Coliform Storet", "length": 50, "domain": null }, { "name": "Total_Coliform_Description", "type": "esriFieldTypeString", "alias": "Total Coliform Description", "length": 50, "domain": null }, { "name": "Total_Coliform_SDWA_Method", "type": "esriFieldTypeString", "alias": "Total Coliform SDWA Method", "length": 50, "domain": null }, { "name": "Total_Coliform_Result", "type": "esriFieldTypeString", "alias": "Total Coliform Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Total_Coliform_Units", "type": "esriFieldTypeString", "alias": "Total Coliform Units", "length": 50, "domain": null }, { "name": "E_Coli_Storet", "type": "esriFieldTypeString", "alias": "E Coli Storet", "length": 50, "domain": null }, { "name": "E_Coli_Description", "type": "esriFieldTypeString", "alias": "E Coli Description", "length": 50, "domain": null }, { "name": "E_Coli_SDWA_Method", "type": "esriFieldTypeString", "alias": "E Coli SDWA Method", "length": 50, "domain": null }, { "name": "E_Coli_Result", "type": "esriFieldTypeString", "alias": "E Coli Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "E_Coli_Units", "type": "esriFieldTypeString", "alias": "E Coli Units", "length": 50, "domain": null }, { "name": "Qualifier_Code", "type": "esriFieldTypeString", "alias": "Qualifier Code", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Qual_Code", "description": "Qualifier Code", "codedValues": [ { "name": "0- Non-Numeric/Not Verified", "code": "0- Non-Numeric/Not Verified" }, { "name": "1-Normal(No Problem with sample)", "code": "1-Normal(No Problem with sample)" }, { "name": "2- Non-Detect", "code": "2- Non-Detect" }, { "name": "3- Between LOD and LOQ", "code": "3- Between LOD and LOQ" }, { "name": "5- Too much contaminant to quantify", "code": "5- Too much contaminant to quantify" }, { "name": "6-Screen Detect", "code": "6-Screen Detect" }, { "name": "F- Field Result", "code": "F- Field Result" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 200, "domain": { "type": "codedValue", "name": "PublicStatusTypes", "description": "Public Status Types", "codedValues": [ { "name": "Additional Routine", "code": "A" }, { "name": "Confirmation (Check)", "code": "C" }, { "name": "Compliance Sample", "code": "D" }, { "name": "Grab Sample", "code": "G" }, { "name": "Investigation", "code": "I" }, { "name": "Other Compliance", "code": "O" }, { "name": "Repeat", "code": "R" }, { "name": "Triggered Source Water", "code": "T" }, { "name": "Unknown", "code": "U" }, { "name": "Raw Water Sample", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R752_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_752", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3091GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_752", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{02D2080D-523C-425B-AE80-393C52B0D192}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Production.LI.Public_GWR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 100, "domain": { "type": "codedValue", "name": "GWR_SampleType", "description": "GWR Sample Type", "codedValues": [ { "name": "T - Triggered Source Water sample following Total Coliforn-positive Compliance sample", "code": "T - Triggered Source Water sample following Total Coliforn-positive Compliance sample" }, { "name": "R - Repeat Source Water sample following E-Coli positive trigger Source Water sample", "code": "R - Repeat Source Water sample following E-Coli positive trigger Source Water sample" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SmpleC_or_R_Pos_smple_Date", "type": "esriFieldTypeDate", "alias": "Sample Type C or R Positive Sample Date", "length": 8, "domain": null }, { "name": "SmpleC_or_R_Pos_smple_ID", "type": "esriFieldTypeString", "alias": "Sample Type C or R Positive Sample ID\n", "length": 50, "domain": null }, { "name": "WI_Unique_Well_Num", "type": "esriFieldTypeString", "alias": "WI Unique Well Number", "length": 50, "domain": null }, { "name": "Entry_Pnt_ID", "type": "esriFieldTypeString", "alias": "Entry Point ID\n", "length": 50, "domain": null }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Approved_Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Approved Monitoring Point ID\n\n", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_ID_Num", "type": "esriFieldTypeString", "alias": "Laboratory ID Number\n", "length": 25, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Laboratory Name", "description": "Lab Name", "codedValues": [ { "name": "Walworth County Health and Human Services", "code": "Walworth County Health and Human Services" }, { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" }, { "name": "TGA Laboratories", "code": "TGA Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Smple_Recieved", "type": "esriFieldTypeDate", "alias": "Date Sample Recieved", "length": 8, "domain": null }, { "name": "ChlorineResidual_in_Sample", "type": "esriFieldTypeString", "alias": "Chlorine Residual in Sample", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Cond_Sample_Upon_Reciept", "type": "esriFieldTypeString", "alias": "Condition of Sample Upon Reciept / Other Comment", "length": 50, "domain": null }, { "name": "Recieving_Lab_Official", "type": "esriFieldTypeString", "alias": "Recieving Lab Official", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Total_Coliform_Storet", "type": "esriFieldTypeString", "alias": "Total Coliform Storet", "length": 50, "domain": null }, { "name": "Total_Coliform_Description", "type": "esriFieldTypeString", "alias": "Total Coliform Description", "length": 50, "domain": null }, { "name": "Total_Coliform_SDWA_Method", "type": "esriFieldTypeString", "alias": "Total Coliform SDWA Method", "length": 50, "domain": null }, { "name": "Total_Coliform_Result", "type": "esriFieldTypeString", "alias": "Total Coliform Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Total_Coliform_Units", "type": "esriFieldTypeString", "alias": "Total Coliform Units", "length": 50, "domain": null }, { "name": "E_Coli_Storet", "type": "esriFieldTypeString", "alias": "E Coli Storet", "length": 50, "domain": null }, { "name": "E_Coli_Description", "type": "esriFieldTypeString", "alias": "E Coli Description", "length": 50, "domain": null }, { "name": "E_Coli_SDWA_Method", "type": "esriFieldTypeString", "alias": "E Coli SDWA Method", "length": 50, "domain": null }, { "name": "E_Coli_Result", "type": "esriFieldTypeString", "alias": "E Coli Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "E_Coli_Units", "type": "esriFieldTypeString", "alias": "E Coli Units", "length": 50, "domain": null }, { "name": "Qualifier_Code", "type": "esriFieldTypeString", "alias": "Qualifier Code", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Qual_Code", "description": "Qualifier Code", "codedValues": [ { "name": "0- Non-Numeric/Not Verified", "code": "0- Non-Numeric/Not Verified" }, { "name": "1-Normal(No Problem with sample)", "code": "1-Normal(No Problem with sample)" }, { "name": "2- Non-Detect", "code": "2- Non-Detect" }, { "name": "3- Between LOD and LOQ", "code": "3- Between LOD and LOQ" }, { "name": "5- Too much contaminant to quantify", "code": "5- Too much contaminant to quantify" }, { "name": "6-Screen Detect", "code": "6-Screen Detect" }, { "name": "F- Field Result", "code": "F- Field Result" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R756_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_756", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3095GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_756", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EDBECC8B-5C4C-4DA1-BF2D-42B074420905}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Production.LI.Public_Inorganics", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "Inorganic_SampleType", "description": "Inorganic_SampleType", "codedValues": [ { "name": "D - Compliance Sample", "code": "D - Compliance Sample" }, { "name": "C - Confirmation Sample", "code": "C - Confirmation Sample" }, { "name": "I - Investigation Sample", "code": "I - Investigation Sample" }, { "name": "W - Raw Water Sample", "code": "W - Raw Water Sample" }, { "name": "Annual Test", "code": "Annual Test" }, { "name": "Taste/Odor", "code": "Taste/Odor" }, { "name": "Pump Work", "code": "Pump Work" }, { "name": "Previous Unsafe", "code": "Previous Unsafe" }, { "name": "Real Estate", "code": "Real Estate" }, { "name": "Infant Use", "code": "Infant Use" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Monitoring Point ID", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Inorganic_LabName", "description": "Inorganic LabName", "codedValues": [ { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Parameter", "type": "esriFieldTypeString", "alias": "Parameter", "length": 50, "domain": { "type": "codedValue", "name": "Inorganic_Parameter", "description": "Inorganic_Parameter", "codedValues": [ { "name": "Nitrite", "code": "Nitrite" }, { "name": "Nitrite + Nitrate Total", "code": "Nitrite + Nitrate Total" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Results", "type": "esriFieldTypeString", "alias": "Results", "length": 50, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R759_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_759", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3098GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_759", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F6EE4B91-5C7A-458E-A0C4-65EEBD3939CA}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Production.LI.Public_Lead", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": null }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "Lead_Sample_Type", "description": "Lead Sample Type", "codedValues": [ { "name": "Annual Test", "code": "Annual Test" }, { "name": "Taste/Odor", "code": "Taste/Odor" }, { "name": "Pump Work", "code": "Pump Work" }, { "name": "Previous Unsafe", "code": "Previous Unsafe" }, { "name": "Real Estate", "code": "Real Estate" }, { "name": "Infant Use", "code": "Infant Use" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Sample_Point_Description", "type": "esriFieldTypeString", "alias": "Sample Point Description", "length": 75, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Results", "type": "esriFieldTypeDouble", "alias": "Results", "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R755_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_755", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3094GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_755", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{09940724-827D-462D-8785-C1BCDB3EF4F4}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Production.LI.Private_Nitrate", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "PrivateStatusTypes", "description": "Private Status Types", "codedValues": [ { "name": "Urban Air", "code": "UA" }, { "name": "Annual Test", "code": "A" }, { "name": "Real Estate", "code": "E" }, { "name": "Pump Work - Existing Well", "code": "KE" }, { "name": "Pump Work - New Well", "code": "KN" }, { "name": "Previous Unsafe Following Pump Work", "code": "KU" }, { "name": "New Well or New Construction", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Monitoring Point ID", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_ID_Num", "type": "esriFieldTypeString", "alias": "Laboratory ID Number\n", "length": 25, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Laboratory Name", "description": "Lab Name", "codedValues": [ { "name": "Walworth County Health and Human Services", "code": "Walworth County Health and Human Services" }, { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" }, { "name": "TGA Laboratories", "code": "TGA Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Smple_Recieved", "type": "esriFieldTypeDate", "alias": "Date Sample Recieved", "length": 8, "domain": null }, { "name": "ChlorineResidual_in_Sample", "type": "esriFieldTypeString", "alias": "Chlorine Residual in Sample", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Cond_Sample_Upon_Reciept", "type": "esriFieldTypeString", "alias": "Condition of Sample Upon Reciept / Other Comment", "length": 50, "domain": null }, { "name": "Recieving_Lab_Official", "type": "esriFieldTypeString", "alias": "Recieving Lab Official", "length": 50, "domain": null }, { "name": "Date_Reported_to_PWS", "type": "esriFieldTypeDate", "alias": "Date Reported to PWS", "length": 8, "domain": null }, { "name": "Storet_Code", "type": "esriFieldTypeString", "alias": "Storet Code", "length": 50, "domain": null }, { "name": "SDWA_Method", "type": "esriFieldTypeString", "alias": "SDWA Method", "length": 20, "domain": null }, { "name": "MDL", "type": "esriFieldTypeString", "alias": "MDL", "length": 50, "domain": null }, { "name": "MCL", "type": "esriFieldTypeString", "alias": "MCL", "length": 20, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "SamplePreserved_in_Field", "type": "esriFieldTypeString", "alias": "Sample Preserved in Field?", "length": 15, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "QualifierCode", "type": "esriFieldTypeString", "alias": "Qualifier Code", "length": 30, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Parameter", "type": "esriFieldTypeString", "alias": "Parameter", "length": 50, "domain": null }, { "name": "Results", "type": "esriFieldTypeDouble", "alias": "Nitrate Results", "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R767_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_767", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3106GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_767", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{60D0BB69-846D-4F8B-BE4A-AE0C5D79278D}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Production.LI.Private_Arsenic", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": null }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "Lead_Sample_Type", "description": "Lead Sample Type", "codedValues": [ { "name": "Annual Test", "code": "Annual Test" }, { "name": "Taste/Odor", "code": "Taste/Odor" }, { "name": "Pump Work", "code": "Pump Work" }, { "name": "Previous Unsafe", "code": "Previous Unsafe" }, { "name": "Real Estate", "code": "Real Estate" }, { "name": "Infant Use", "code": "Infant Use" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Sample_Point_Description", "type": "esriFieldTypeString", "alias": "Sample Point Description", "length": 75, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Results", "type": "esriFieldTypeDouble", "alias": "Results", "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R765_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_765", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3104GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_765", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7F96A700-B9FE-40B2-8E96-36B523A370E8}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Production.LI.Private_Bacteria", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SmpleC_or_R_Pos_smple_Date", "type": "esriFieldTypeDate", "alias": "Sample Type C or R Positive Sample Date", "length": 8, "domain": null }, { "name": "SmpleC_or_R_Pos_smple_ID", "type": "esriFieldTypeString", "alias": "Sample Type C or R Positive Sample ID\n", "length": 50, "domain": null }, { "name": "WI_Unique_Well_Num", "type": "esriFieldTypeString", "alias": "WI Unique Well Number", "length": 50, "domain": null }, { "name": "Entry_Pnt_ID", "type": "esriFieldTypeString", "alias": "Entry Point ID\n", "length": 50, "domain": null }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Approved_Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Approved Monitoring Point ID\n\n", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_ID_Num", "type": "esriFieldTypeString", "alias": "Laboratory ID Number\n", "length": 25, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Laboratory Name", "description": "Lab Name", "codedValues": [ { "name": "Walworth County Health and Human Services", "code": "Walworth County Health and Human Services" }, { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" }, { "name": "TGA Laboratories", "code": "TGA Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Smple_Recieved", "type": "esriFieldTypeDate", "alias": "Date Sample Recieved", "length": 8, "domain": null }, { "name": "ChlorineResidual_in_Sample", "type": "esriFieldTypeString", "alias": "Chlorine Residual in Sample", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Cond_Sample_Upon_Reciept", "type": "esriFieldTypeString", "alias": "Condition of Sample Upon Reciept / Other Comment", "length": 50, "domain": null }, { "name": "Recieving_Lab_Official", "type": "esriFieldTypeString", "alias": "Recieving Lab Official", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Total_Coliform_Storet", "type": "esriFieldTypeString", "alias": "Total Coliform Storet", "length": 50, "domain": null }, { "name": "Total_Coliform_Description", "type": "esriFieldTypeString", "alias": "Total Coliform Description", "length": 50, "domain": null }, { "name": "Total_Coliform_SDWA_Method", "type": "esriFieldTypeString", "alias": "Total Coliform SDWA Method", "length": 50, "domain": null }, { "name": "Total_Coliform_Result", "type": "esriFieldTypeString", "alias": "Total Coliform Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Total_Coliform_Units", "type": "esriFieldTypeString", "alias": "Total Coliform Units", "length": 50, "domain": null }, { "name": "E_Coli_Storet", "type": "esriFieldTypeString", "alias": "E Coli Storet", "length": 50, "domain": null }, { "name": "E_Coli_Description", "type": "esriFieldTypeString", "alias": "E Coli Description", "length": 50, "domain": null }, { "name": "E_Coli_SDWA_Method", "type": "esriFieldTypeString", "alias": "E Coli SDWA Method", "length": 50, "domain": null }, { "name": "E_Coli_Result", "type": "esriFieldTypeString", "alias": "E Coli Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "E_Coli_Units", "type": "esriFieldTypeString", "alias": "E Coli Units", "length": 50, "domain": null }, { "name": "Qualifier_Code", "type": "esriFieldTypeString", "alias": "Qualifier Code", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Qual_Code", "description": "Qualifier Code", "codedValues": [ { "name": "0- Non-Numeric/Not Verified", "code": "0- Non-Numeric/Not Verified" }, { "name": "1-Normal(No Problem with sample)", "code": "1-Normal(No Problem with sample)" }, { "name": "2- Non-Detect", "code": "2- Non-Detect" }, { "name": "3- Between LOD and LOQ", "code": "3- Between LOD and LOQ" }, { "name": "5- Too much contaminant to quantify", "code": "5- Too much contaminant to quantify" }, { "name": "6-Screen Detect", "code": "6-Screen Detect" }, { "name": "F- Field Result", "code": "F- Field Result" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 200, "domain": { "type": "codedValue", "name": "PrivateStatusTypes", "description": "Private Status Types", "codedValues": [ { "name": "Urban Air", "code": "UA" }, { "name": "Annual Test", "code": "A" }, { "name": "Real Estate", "code": "E" }, { "name": "Pump Work - Existing Well", "code": "KE" }, { "name": "Pump Work - New Well", "code": "KN" }, { "name": "Previous Unsafe Following Pump Work", "code": "KU" }, { "name": "New Well or New Construction", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R763_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_763", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3102GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_763", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{204FFFAE-DDB7-4043-8754-40C4C1AE8FD2}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Production.LI.Private_GWR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 100, "domain": { "type": "codedValue", "name": "GWR_SampleType", "description": "GWR Sample Type", "codedValues": [ { "name": "T - Triggered Source Water sample following Total Coliforn-positive Compliance sample", "code": "T - Triggered Source Water sample following Total Coliforn-positive Compliance sample" }, { "name": "R - Repeat Source Water sample following E-Coli positive trigger Source Water sample", "code": "R - Repeat Source Water sample following E-Coli positive trigger Source Water sample" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SmpleC_or_R_Pos_smple_Date", "type": "esriFieldTypeDate", "alias": "Sample Type C or R Positive Sample Date", "length": 8, "domain": null }, { "name": "SmpleC_or_R_Pos_smple_ID", "type": "esriFieldTypeString", "alias": "Sample Type C or R Positive Sample ID\n", "length": 50, "domain": null }, { "name": "WI_Unique_Well_Num", "type": "esriFieldTypeString", "alias": "WI Unique Well Number", "length": 50, "domain": null }, { "name": "Entry_Pnt_ID", "type": "esriFieldTypeString", "alias": "Entry Point ID\n", "length": 50, "domain": null }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Approved_Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Approved Monitoring Point ID\n\n", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_ID_Num", "type": "esriFieldTypeString", "alias": "Laboratory ID Number\n", "length": 25, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Laboratory Name", "description": "Lab Name", "codedValues": [ { "name": "Walworth County Health and Human Services", "code": "Walworth County Health and Human Services" }, { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" }, { "name": "TGA Laboratories", "code": "TGA Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Smple_Recieved", "type": "esriFieldTypeDate", "alias": "Date Sample Recieved", "length": 8, "domain": null }, { "name": "ChlorineResidual_in_Sample", "type": "esriFieldTypeString", "alias": "Chlorine Residual in Sample", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Yes_No", "description": "Yes_No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Cond_Sample_Upon_Reciept", "type": "esriFieldTypeString", "alias": "Condition of Sample Upon Reciept / Other Comment", "length": 50, "domain": null }, { "name": "Recieving_Lab_Official", "type": "esriFieldTypeString", "alias": "Recieving Lab Official", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Total_Coliform_Storet", "type": "esriFieldTypeString", "alias": "Total Coliform Storet", "length": 50, "domain": null }, { "name": "Total_Coliform_Description", "type": "esriFieldTypeString", "alias": "Total Coliform Description", "length": 50, "domain": null }, { "name": "Total_Coliform_SDWA_Method", "type": "esriFieldTypeString", "alias": "Total Coliform SDWA Method", "length": 50, "domain": null }, { "name": "Total_Coliform_Result", "type": "esriFieldTypeString", "alias": "Total Coliform Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Total_Coliform_Units", "type": "esriFieldTypeString", "alias": "Total Coliform Units", "length": 50, "domain": null }, { "name": "E_Coli_Storet", "type": "esriFieldTypeString", "alias": "E Coli Storet", "length": 50, "domain": null }, { "name": "E_Coli_Description", "type": "esriFieldTypeString", "alias": "E Coli Description", "length": 50, "domain": null }, { "name": "E_Coli_SDWA_Method", "type": "esriFieldTypeString", "alias": "E Coli SDWA Method", "length": 50, "domain": null }, { "name": "E_Coli_Result", "type": "esriFieldTypeString", "alias": "E Coli Result", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Absent_Present", "description": "Absent or Present", "codedValues": [ { "name": "Absent", "code": "Absent" }, { "name": "Present", "code": "Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "E_Coli_Units", "type": "esriFieldTypeString", "alias": "E Coli Units", "length": 50, "domain": null }, { "name": "Qualifier_Code", "type": "esriFieldTypeString", "alias": "Qualifier Code", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Qual_Code", "description": "Qualifier Code", "codedValues": [ { "name": "0- Non-Numeric/Not Verified", "code": "0- Non-Numeric/Not Verified" }, { "name": "1-Normal(No Problem with sample)", "code": "1-Normal(No Problem with sample)" }, { "name": "2- Non-Detect", "code": "2- Non-Detect" }, { "name": "3- Between LOD and LOQ", "code": "3- Between LOD and LOQ" }, { "name": "5- Too much contaminant to quantify", "code": "5- Too much contaminant to quantify" }, { "name": "6-Screen Detect", "code": "6-Screen Detect" }, { "name": "F- Field Result", "code": "F- Field Result" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R766_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_766", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3105GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_766", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D60F7969-D466-452F-AAAC-0B6B75107CB5}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "Production.LI.Private_Inorganics", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": { "type": "codedValue", "name": "Bact_SampleClassification", "description": "Sample Classification", "codedValues": [ { "name": "Compliance", "code": "Compliance" }, { "name": "Private", "code": "Private" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleSource", "type": "esriFieldTypeString", "alias": "Sample Source", "length": 50, "domain": { "type": "codedValue", "name": "Bact_Sampl_Source", "description": "Bacteria Sample Source", "codedValues": [ { "name": "D - Distribution Well", "code": "D - Distribution Well" }, { "name": "W - Well/Source", "code": "W - Well/Source" }, { "name": "E - Entry Point", "code": "E - Entry Point" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "Inorganic_SampleType", "description": "Inorganic_SampleType", "codedValues": [ { "name": "D - Compliance Sample", "code": "D - Compliance Sample" }, { "name": "C - Confirmation Sample", "code": "C - Confirmation Sample" }, { "name": "I - Investigation Sample", "code": "I - Investigation Sample" }, { "name": "W - Raw Water Sample", "code": "W - Raw Water Sample" }, { "name": "Annual Test", "code": "Annual Test" }, { "name": "Taste/Odor", "code": "Taste/Odor" }, { "name": "Pump Work", "code": "Pump Work" }, { "name": "Previous Unsafe", "code": "Previous Unsafe" }, { "name": "Real Estate", "code": "Real Estate" }, { "name": "Infant Use", "code": "Infant Use" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Monitoring_PointID", "type": "esriFieldTypeString", "alias": "Monitoring Point ID", "length": 50, "domain": null }, { "name": "Monitoring_Point_Description", "type": "esriFieldTypeString", "alias": "Monitoring Point Description\n\n", "length": 50, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Lab_Name", "type": "esriFieldTypeString", "alias": "Laboratory Name\n", "length": 50, "domain": { "type": "codedValue", "name": "Inorganic_LabName", "description": "Inorganic LabName", "codedValues": [ { "name": "Wisconsin State Lab of Hygiene", "code": "Wisconsin State Lab of Hygiene" }, { "name": "Suburban Laboratories", "code": "Suburban Laboratories" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Parameter", "type": "esriFieldTypeString", "alias": "Parameter", "length": 50, "domain": { "type": "codedValue", "name": "Inorganic_Parameter", "description": "Inorganic_Parameter", "codedValues": [ { "name": "Nitrite", "code": "Nitrite" }, { "name": "Nitrite + Nitrate Total", "code": "Nitrite + Nitrate Total" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Results", "type": "esriFieldTypeString", "alias": "Results", "length": 50, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R762_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_762", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3101GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_762", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{31580AFA-2921-4BBD-A2F0-2DC1846B177F}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "Production.LI.Private_Lead", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name_of_Sampler", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleClassification", "type": "esriFieldTypeString", "alias": "Sample Classification", "length": 50, "domain": null }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "length": 50, "domain": { "type": "codedValue", "name": "Lead_Sample_Type", "description": "Lead Sample Type", "codedValues": [ { "name": "Annual Test", "code": "Annual Test" }, { "name": "Taste/Odor", "code": "Taste/Odor" }, { "name": "Pump Work", "code": "Pump Work" }, { "name": "Previous Unsafe", "code": "Previous Unsafe" }, { "name": "Real Estate", "code": "Real Estate" }, { "name": "Infant Use", "code": "Infant Use" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sample_Collect_Date", "type": "esriFieldTypeDate", "alias": "Sample Collection Date\n", "length": 8, "domain": null }, { "name": "Sample_Collection_Address", "type": "esriFieldTypeString", "alias": "Sample Collection Address\n", "length": 50, "domain": null }, { "name": "Sample_Point_Description", "type": "esriFieldTypeString", "alias": "Sample Point Description", "length": 75, "domain": null }, { "name": "Name_of_Sampler", "type": "esriFieldTypeString", "alias": "Name of Sampler\n", "length": 50, "domain": null }, { "name": "Sampler_Phone", "type": "esriFieldTypeString", "alias": "Sampler Phone\n", "length": 50, "domain": null }, { "name": "Laboratory_SampleID", "type": "esriFieldTypeString", "alias": "Laboratory Sample ID", "length": 50, "domain": null }, { "name": "Date_Reported_to_System", "type": "esriFieldTypeDate", "alias": "Date Reported to System", "length": 8, "domain": null }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Units", "length": 20, "domain": null }, { "name": "GUI", "type": "esriFieldTypeGUID", "alias": "GUI", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Results", "type": "esriFieldTypeDouble", "alias": "Results", "domain": null }, { "name": "guid_copy", "type": "esriFieldTypeString", "alias": "guid_copy", "length": 100, "domain": null } ], "indexes": [ { "name": "R764_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_764", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3103GUI", "fields": "GUI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_764", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{43267FC2-6D25-4350-B45E-FD75BF9F9C45}" } ], "capabilities": "Query,Map,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, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "77185000662a4ed79aa70dd9f3cff930" } ] }