{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.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": "68010af72191411893ef02613194078b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEc0lEQVRYhe2WbUxbVRjH/7e390LpG6MdpcBCYUNahiORlyxBt8S9ZjHx0yTLZoQEAZ3CgA8a3xiJ+g2B6TacJJvRxbAZ4wSMJmAyzHQwq0HHS0doIWWUUgr0jZZ7e3v9YFgGty8wp8Zk/4/POef//O45z3nOFeM/lvgRwP8KoL55IF8SR5/yBFf2+4LsFj/LSQBAQpH+BFI8n0DS3zk5b1tH3d7RhwrwWvuv+UGGu2z1unfSQRJ6RRK0W6SQ0zQAwMMwUtuyTzrmXqhiOK6qtnXA6CICxy7V7h3/2wCnzw6dNi0tvKOgaOLEdgMK1BqQhCjsXI4PwThvR7fVUsAE+bH6M4OvfFBTfP6BAd4++9uVYdf80d3JWpRm5kAcIfGqSEKE4q1aPKHWoNNsEg04bOca2m4ZmmuLajYN0PTx0Lu3nfNHn9mWhUNpuqiJBaaECMe3G6CKl+Bbq/nV+jODo5F2IixAS8ftkkGn443dydpNJ79fh9N0cAb8MDrnPipru94bribCAtj8gc8UYpoozcyJaM4D8LAMAEBO0SAizCvNysEd96Ionhd/AaAwJkDLJ2NP/+y4m3liR27YM+d4Hn0zU+i3T8PF/AWgpGns0aRjX2oGSGItipgQ4Uh6Fi5PjBRUtFw3rL+iAoBAiD0VR5IoUGnCJr9g+h0jS841cRfDoMtqxoTHhcqcXQKIQnUyrk6aoCJltQCqowI4/P4SvTJJYAIAfTNTguT3a2TJib6ZKRxcVzckIYJekQR7wHd4/RoBgJdj5TslKoE5D6DfPh0x+ar67dM4kKYT1ERKghQWn0sdE8DHspSCogXGHpa5d+bR5GIYeFgG6z0UNI3V1h0V4N+WAEAqpoJulhHE5RQNJU3H3AUlTUMebgcZBhKK9McEkFO0d9bvS1wfJwA8pUlHt9UcFWCPJj1sT7At+yAVU4sxAbZKEm4NLzoOcDwvuAn7UzNg9rgi3oTcRBX2pWYI4hwfwph7ARlSZW9MAAUVdy7AcQeMTjuK1SlrxkiCQGXOLvTOTOHHDTYiADDO28FwHPwrTGtMgJfLd3z9+oe/zPZYzSkFqmTB00sSBA6l6XAwTbehVhzkQ+iZtmCbTDHcXFM0FBMAAHQyZeXk7PQ3Vyx3cCxLH9aYAARXLZw6LSa4WYZPlEqOhxsPC1Bdnt3V3DF66ae5mbKkuPgHfhG/vzuJm3M25CnVTY3V+YKvjwgAAA0VhvL3zv+R3W01lzhXAngu87GYPySrCvIhdFpMuDlng16ZdLXxZH5TpLlRG9GbLz3+ZHPH6MVBx2yZybWAI+lZKFQL62JVHB+C0TmHHqsZ7iDD56nU7zdW5b8VLUfMTthQYShvvzj+1aTXdeHziZGULydN0CuToE2QQS6mAABulsGs34cx1wJWOA46udKiVyqfr6vIuxHLf0OtuLo8uwuAtv3T8WeXVpiTDv9y0ZTXI/MFWTEASCmKlZGUJzdRdSNeRLXWvaj/YSO+Gwa4B/JC9jUA1zaz5qEC/BN6BPAnSdm/MP7Dnv4AAAAASUVORK5CYII=", "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": 0, "name": "Private_GWR", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Private_Inorganics", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Private_Arsenic", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "Private_Bacteria", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "Private_Nitrate", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "PrivateWells_SiteVisitForm", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "Private_Lead", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "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 }, "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": 10.91, "cimVersion": "2.9.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": "4ad0960786adc4b32d51dc8184a6a964", "imageData": "iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEqUlEQVRYhe2Wb2wTZRzHv71ee9c/G7S9bV3Him5CMhoztm4sWTdJjFPfGQ1ozGLcEuOWIIJGXyhTXAL6QoOQyBzGPxhDjGCIwBtfoAnChhtrJ3FjOsaQVurWXW/r/7v2eucLpWb0rh2KMSb83t3v93ue7+d5nt9zv4fEf2zkHYD/FUDP4Nl6miR3pvjMA0JGtghC1gAAeopIUTotq9dpvxaSmQMfvrB56rYCbB8cqc8ie4TlUi6SFOGoMMKySg8D/cfwFC+aFiNpU3A+2SOKUk/PwbNeQZSePLxj8+V/DPDiRyNvXGcTrxtpUtO+qQK1zlIQhEYxV5JkXPFH4Zvg3IKQ/an30NBzgz2e9/82wI6Pvz8amItvXV9TitbGCmhVhG8YQWiw7q5VqHGWYtg7T1y+Gh3YNjhUd7DX8/wtA7x0eGTPtWB8q/teBhvrrIo57KIADWTYLPQyv5bQoL3ZjhKTHr4JdnvvoaEptZ1QBHjliwue2V/ir66vKVUVB4DxyTAAoKPNoRjfuMGKWCKNWX/sva4DZ04r1YQiQCyS+cxIE5rWxgpVcZbj4Q/GAQALnIAyK6WY1+quQDCUIvSk5nMATUUB+o5evH96hr37vhZ7wTP3/rl6ABi/xOLBtirFPC2hQaPLhrOjc+5n3j1Td/MVzQPICMJOkiRQ4yxVFWc5Hr/+lsh9B4IJsBwPxkor5tc6S3DeFwJl1O0A0FsQIBJPe6rsRqgtnuV4nBsL5fnPjYXQ1lSuCEEQGjgqjIjE0g/fHMsDENJSSXWlPm+SBU7A+CUWgWAiLwYA4SUeJ077Ue0woWEDk1cTllI9QlyKKQrA86LOSP/lDi/y8E1yuYIrZoFgAoFgAk6HGY0ua+6KGgwk0oJkKAoALN97GYV/PoVsJWPzAGhKKyZ5MednLBQ62hxgOR7eyfCy4lOyNZUmNLryjyDFi6AobaoogIHWxpei6dU3+xkrjYfaq7AQ5jHkDSG8xC+L21bTqkUIAIuRNCidZrEoQEmJ7kLgeqJDkqF4E8psNDzucpz8xr/MX0hckmQE55Mos9KniwKYjcRARpQ6Zv1R3LNW+V9QZqOxptKUO45qh0lVHACu+KMQRQm8KO4vCvDao01fbT80POedYO011SWqrdftsuUAGjbk3a6cZSUZvkkOjNUwOdDberEoAAAwNurZ0Ax/ctgbQluzcj9grDScDjMAqPYBABj2zSPJi7KZojqV4ooAu7e4T+06Mnb456uRLrNZp9oRG1w2aCCriv8wxWF6NorqSnP/vu6WvNWrAgDA3s6m7pc/HV3n/ZH1xOIZtLrL85oTY1FeeVaSMeybx/RsFA676di+7pZ+NZ2CL6K3n97UtuvI2Ccz16JdwVACjS4GtU71upAkGbOBGLwTLJK8JK91mN98p6ulr5BG0Tfh3s6m7v4vvcfZsPDBd6Nz9vO+EKrsRlhWUTBQWgBAkhexFE3j+lwSoiihnDFctdt1T731RPNQsflX9CrevcV9CkDlnuPjj8RSmW2xWKaZ5QQzL2RJQAZNkxlKT8SqK01DOorav+fx+m9XMu+KAW5Y32MNJwCcuJUxtxXg37A7AL8DYQDNyhqRsuYAAAAASUVORK5CYII=", "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": 7, "name": "PublicWells_SiteVisitForm", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "Public_Bacteria", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "Public_GWR", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "Public_Nitrate", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "Public_Inorganics", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "Public_Lead", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "Public_Arsenic", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "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 }, "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": 10.91, "cimVersion": "2.9.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": 5, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PrivateSiteVisitForm_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 7, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "PublicSiteVisitForm_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 10, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 13, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 8, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 9, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 11, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 12, "name": "PublicWaterWells", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 4, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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 } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 3, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 0, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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": 1, "name": "PrivateWaterWells", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUI", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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": 10.91, "cimVersion": "2.9.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 } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": 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" } ] }