{ "currentVersion": 10.8, "id": 12, "name": "HSEW.DBO.ARCIMS_WELL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WELL_BUSINESS_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "FLUWID", "type": "esriFieldTypeString", "alias": "FLUWID", "length": 10, "domain": null }, { "name": "WELL_TYPE", "type": "esriFieldTypeString", "alias": "WELL_TYPE", "length": 2, "domain": null }, { "name": "WELL_STATUS", "type": "esriFieldTypeString", "alias": "WELL_STATUS", "length": 9, "domain": null }, { "name": "WELL_CASING_MATERIAL", "type": "esriFieldTypeString", "alias": "WELL_CASING_MATERIAL", "length": 11, "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "WELL_DEPTH", "type": "esriFieldTypeDouble", "alias": "WELL_DEPTH", "domain": null }, { "name": "WELL_CASING_LENGTH", "type": "esriFieldTypeDouble", "alias": "WELL_CASING_LENGTH", "domain": null }, { "name": "WELL_CASING_DIAMETER", "type": "esriFieldTypeString", "alias": "WELL_CASING_DIAMETER", "length": 6, "domain": null }, { "name": "WELL_PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "WELL_PERMIT_NUMBER", "length": 20, "domain": null }, { "name": "WELL_COMMENT", "type": "esriFieldTypeString", "alias": "WELL_COMMENT", "length": 234, "domain": null }, { "name": "WELL_SANITARY_SEAL", "type": "esriFieldTypeString", "alias": "WELL_SANITARY_SEAL", "length": 3, "domain": null }, { "name": "WELL_BUSINESS_NAME", "type": "esriFieldTypeString", "alias": "WELL_BUSINESS_NAME", "length": 50, "domain": null }, { "name": "RESIDENT_FIRSTNAME", "type": "esriFieldTypeString", "alias": "RESIDENT_FIRSTNAME", "length": 20, "domain": null }, { "name": "RESIDENT_LASTNAME", "type": "esriFieldTypeString", "alias": "RESIDENT_LASTNAME", "length": 20, "domain": null }, { "name": "WELL_PHONE", "type": "esriFieldTypeString", "alias": "WELL_PHONE", "length": 20, "domain": null }, { "name": "WELL_PHONE_EXT", "type": "esriFieldTypeString", "alias": "WELL_PHONE_EXT", "length": 5, "domain": null }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "DATUM", "length": 6, "domain": null }, { "name": "HAE", "type": "esriFieldTypeDouble", "alias": "HAE", "domain": null }, { "name": "GPS_DATE", "type": "esriFieldTypeDate", "alias": "GPS_DATE", "length": 8, "domain": null }, { "name": "LOCATION_METHOD", "type": "esriFieldTypeString", "alias": "LOCATION_METHOD", "length": 13, "domain": null }, { "name": "PROJECT_ID", "type": "esriFieldTypeString", "alias": "PROJECT_ID", "length": 15, "domain": null }, { "name": "INSPECTOR_FIRSTNAME", "type": "esriFieldTypeString", "alias": "INSPECTOR_FIRSTNAME", "length": 20, "domain": null }, { "name": "INSPECTOR_LASTNAME", "type": "esriFieldTypeString", "alias": "INSPECTOR_LASTNAME", "length": 20, "domain": null }, { "name": "INSPECTOR_COUNTY", "type": "esriFieldTypeString", "alias": "INSPECTOR_COUNTY", "length": 12, "domain": null }, { "name": "PROPERTY_ID", "type": "esriFieldTypeString", "alias": "PROPERTY_ID", "length": 30, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "COUNTY", "length": 30, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 80, "domain": null }, { "name": "HOUSE_NUMBER", "type": "esriFieldTypeString", "alias": "HOUSE_NUMBER", "length": 8, "domain": null }, { "name": "PREDIRECTION", "type": "esriFieldTypeString", "alias": "PREDIRECTION", "length": 2, "domain": null }, { "name": "PREFIX", "type": "esriFieldTypeString", "alias": "PREFIX", "length": 4, "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "STREET", "length": 40, "domain": null }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "SUFFIX", "length": 4, "domain": null }, { "name": "POSTDIRECTION", "type": "esriFieldTypeString", "alias": "POSTDIRECTION", "length": 2, "domain": null }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "ZIPCODE", "length": 10, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 25, "domain": null }, { "name": "WSRP_ID", "type": "esriFieldTypeString", "alias": "WSRP_ID", "length": 9, "domain": null }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "ACTION", "length": 200, "domain": null }, { "name": "POTABLE_STATUS", "type": "esriFieldTypeString", "alias": "POTABLE_STATUS", "length": 20, "domain": null }, { "name": "PETROLEUM_STATUS", "type": "esriFieldTypeString", "alias": "PETROLEUM_STATUS", "length": 20, "domain": null }, { "name": "SOLVENT_STATUS", "type": "esriFieldTypeString", "alias": "SOLVENT_STATUS", "length": 20, "domain": null }, { "name": "NITRATES", "type": "esriFieldTypeString", "alias": "NITRATES", "length": 20, "domain": null }, { "name": "EDB", "type": "esriFieldTypeString", "alias": "EDB", "length": 20, "domain": null }, { "name": "METALS", "type": "esriFieldTypeString", "alias": "METALS", "length": 20, "domain": null }, { "name": "VOC", "type": "esriFieldTypeString", "alias": "VOC", "length": 20, "domain": null }, { "name": "ARSENIC", "type": "esriFieldTypeString", "alias": "ARSENIC", "length": 20, "domain": null }, { "name": "PESTICIDES", "type": "esriFieldTypeString", "alias": "PESTICIDES", "length": 20, "domain": null }, { "name": "HIGH_PETROLEUM", "type": "esriFieldTypeString", "alias": "HIGH_PETROLEUM", "length": 50, "domain": null }, { "name": "HIGH_SOLVENT", "type": "esriFieldTypeString", "alias": "HIGH_SOLVENT", "length": 50, "domain": null }, { "name": "HIGH_NITRATES", "type": "esriFieldTypeString", "alias": "HIGH_NITRATES", "length": 50, "domain": null }, { "name": "HIGH_EDB", "type": "esriFieldTypeString", "alias": "HIGH_EDB", "length": 50, "domain": null }, { "name": "HIGH_METALS", "type": "esriFieldTypeString", "alias": "HIGH_METALS", "length": 50, "domain": null }, { "name": "HIGH_VOC", "type": "esriFieldTypeString", "alias": "HIGH_VOC", "length": 50, "domain": null }, { "name": "HIGH_ARSENIC", "type": "esriFieldTypeString", "alias": "HIGH_ARSENIC", "length": 50, "domain": null }, { "name": "HIGH_PESTICIDES", "type": "esriFieldTypeString", "alias": "HIGH_PESTICIDES", "length": 50, "domain": null }, { "name": "SCHEDULE", "type": "esriFieldTypeString", "alias": "SCHEDULE", "length": 250, "domain": null }, { "name": "MAXIMUM_DATE", "type": "esriFieldTypeDate", "alias": "MAXIMUM_DATE", "length": 8, "domain": null }, { "name": "SCREENING_METHOD", "type": "esriFieldTypeString", "alias": "SCREENING_METHOD", "length": 250, "domain": null }, { "name": "CATS", "type": "esriFieldTypeString", "alias": "CATS", "length": 250, "domain": null }, { "name": "UNMATCHED40", "type": "esriFieldTypeString", "alias": "UNMATCHED40", "length": 250, "domain": null }, { "name": "L_SAMPLE_DATE_PETROLEUM", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_PETROLEUM", "length": 8, "domain": null }, { "name": "L_SAMPLE_DATE_SOLVENT", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_SOLVENT", "length": 8, "domain": null }, { "name": "L_SAMPLE_DATE_NITRATES", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_NITRATES", "length": 8, "domain": null }, { "name": "L_SAMPLE_DATE_EDB", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_EDB", "length": 8, "domain": null }, { "name": "L_SAMPLE_DATE_METALS", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_METALS", "length": 8, "domain": null }, { "name": "L_SAMPLE_DATE_VOC", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_VOC", "length": 8, "domain": null }, { "name": "L_SAMPLE_DATE_ARSENIC", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_ARSENIC", "length": 8, "domain": null }, { "name": "L_SAMPLE_DATE_PESTICIDES", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_PESTICIDES", "length": 8, "domain": null }, { "name": "LAST_JOB_NAME_PETROLEUM", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_PETROLEUM", "length": 200, "domain": null }, { "name": "LAST_JOB_NAME_NITRATES", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_NITRATES", "length": 200, "domain": null }, { "name": "LAST_JOB_NAME_EDB", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_EDB", "length": 200, "domain": null }, { "name": "LAST_JOB_NAME_METALS", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_METALS", "length": 200, "domain": null }, { "name": "LAST_JOB_NAME_ARSENIC", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_ARSENIC", "length": 200, "domain": null }, { "name": "LAST_JOB_NAME_PESTICIDES", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_PESTICIDES", "length": 200, "domain": null }, { "name": "AUTONUMBER", "type": "esriFieldTypeInteger", "alias": "AUTONUMBER", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }