{ "currentVersion": 10.8, "cimVersion": "2.5.0", "id": 12, "name": "HSEW.DBO.ARCIMS_WELL", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "", "globalIdField": "", "displayField": "WELL_BUSINESS_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "FLUWID", "type": "esriFieldTypeString", "alias": "FLUWID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FLUWID" }, { "name": "WELL_TYPE", "type": "esriFieldTypeString", "alias": "WELL_TYPE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "WELL_TYPE" }, { "name": "WELL_STATUS", "type": "esriFieldTypeString", "alias": "WELL_STATUS", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "WELL_STATUS" }, { "name": "WELL_CASING_MATERIAL", "type": "esriFieldTypeString", "alias": "WELL_CASING_MATERIAL", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "WELL_CASING_MATERIAL" }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LONGITUDE" }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LATITUDE" }, { "name": "WELL_DEPTH", "type": "esriFieldTypeDouble", "alias": "WELL_DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WELL_DEPTH" }, { "name": "WELL_CASING_LENGTH", "type": "esriFieldTypeDouble", "alias": "WELL_CASING_LENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WELL_CASING_LENGTH" }, { "name": "WELL_CASING_DIAMETER", "type": "esriFieldTypeString", "alias": "WELL_CASING_DIAMETER", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "WELL_CASING_DIAMETER" }, { "name": "WELL_PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "WELL_PERMIT_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "WELL_PERMIT_NUMBER" }, { "name": "WELL_COMMENT", "type": "esriFieldTypeString", "alias": "WELL_COMMENT", "domain": null, "editable": true, "nullable": true, "length": 234, "defaultValue": null, "modelName": "WELL_COMMENT" }, { "name": "WELL_SANITARY_SEAL", "type": "esriFieldTypeString", "alias": "WELL_SANITARY_SEAL", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "WELL_SANITARY_SEAL" }, { "name": "WELL_BUSINESS_NAME", "type": "esriFieldTypeString", "alias": "WELL_BUSINESS_NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WELL_BUSINESS_NAME" }, { "name": "RESIDENT_FIRSTNAME", "type": "esriFieldTypeString", "alias": "RESIDENT_FIRSTNAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RESIDENT_FIRSTNAME" }, { "name": "RESIDENT_LASTNAME", "type": "esriFieldTypeString", "alias": "RESIDENT_LASTNAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RESIDENT_LASTNAME" }, { "name": "WELL_PHONE", "type": "esriFieldTypeString", "alias": "WELL_PHONE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "WELL_PHONE" }, { "name": "WELL_PHONE_EXT", "type": "esriFieldTypeString", "alias": "WELL_PHONE_EXT", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "WELL_PHONE_EXT" }, { "name": "DATUM", "type": "esriFieldTypeString", "alias": "DATUM", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "DATUM" }, { "name": "HAE", "type": "esriFieldTypeDouble", "alias": "HAE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HAE" }, { "name": "GPS_DATE", "type": "esriFieldTypeDate", "alias": "GPS_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "GPS_DATE" }, { "name": "LOCATION_METHOD", "type": "esriFieldTypeString", "alias": "LOCATION_METHOD", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "LOCATION_METHOD" }, { "name": "PROJECT_ID", "type": "esriFieldTypeString", "alias": "PROJECT_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PROJECT_ID" }, { "name": "INSPECTOR_FIRSTNAME", "type": "esriFieldTypeString", "alias": "INSPECTOR_FIRSTNAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "INSPECTOR_FIRSTNAME" }, { "name": "INSPECTOR_LASTNAME", "type": "esriFieldTypeString", "alias": "INSPECTOR_LASTNAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "INSPECTOR_LASTNAME" }, { "name": "INSPECTOR_COUNTY", "type": "esriFieldTypeString", "alias": "INSPECTOR_COUNTY", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "INSPECTOR_COUNTY" }, { "name": "PROPERTY_ID", "type": "esriFieldTypeString", "alias": "PROPERTY_ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PROPERTY_ID" }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "COUNTY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "COUNTY" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "HOUSE_NUMBER", "type": "esriFieldTypeString", "alias": "HOUSE_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "HOUSE_NUMBER" }, { "name": "PREDIRECTION", "type": "esriFieldTypeString", "alias": "PREDIRECTION", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PREDIRECTION" }, { "name": "PREFIX", "type": "esriFieldTypeString", "alias": "PREFIX", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "PREFIX" }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "STREET", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "STREET" }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "SUFFIX", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "SUFFIX" }, { "name": "POSTDIRECTION", "type": "esriFieldTypeString", "alias": "POSTDIRECTION", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "POSTDIRECTION" }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "ZIPCODE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ZIPCODE" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CITY" }, { "name": "WSRP_ID", "type": "esriFieldTypeString", "alias": "WSRP_ID", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "WSRP_ID" }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "ACTION", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "ACTION" }, { "name": "POTABLE_STATUS", "type": "esriFieldTypeString", "alias": "POTABLE_STATUS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "POTABLE_STATUS" }, { "name": "PETROLEUM_STATUS", "type": "esriFieldTypeString", "alias": "PETROLEUM_STATUS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PETROLEUM_STATUS" }, { "name": "SOLVENT_STATUS", "type": "esriFieldTypeString", "alias": "SOLVENT_STATUS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SOLVENT_STATUS" }, { "name": "NITRATES", "type": "esriFieldTypeString", "alias": "NITRATES", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "NITRATES" }, { "name": "EDB", "type": "esriFieldTypeString", "alias": "EDB", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EDB" }, { "name": "METALS", "type": "esriFieldTypeString", "alias": "METALS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "METALS" }, { "name": "VOC", "type": "esriFieldTypeString", "alias": "VOC", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VOC" }, { "name": "ARSENIC", "type": "esriFieldTypeString", "alias": "ARSENIC", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARSENIC" }, { "name": "PESTICIDES", "type": "esriFieldTypeString", "alias": "PESTICIDES", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PESTICIDES" }, { "name": "HIGH_PETROLEUM", "type": "esriFieldTypeString", "alias": "HIGH_PETROLEUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_PETROLEUM" }, { "name": "HIGH_SOLVENT", "type": "esriFieldTypeString", "alias": "HIGH_SOLVENT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_SOLVENT" }, { "name": "HIGH_NITRATES", "type": "esriFieldTypeString", "alias": "HIGH_NITRATES", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_NITRATES" }, { "name": "HIGH_EDB", "type": "esriFieldTypeString", "alias": "HIGH_EDB", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_EDB" }, { "name": "HIGH_METALS", "type": "esriFieldTypeString", "alias": "HIGH_METALS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_METALS" }, { "name": "HIGH_VOC", "type": "esriFieldTypeString", "alias": "HIGH_VOC", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_VOC" }, { "name": "HIGH_ARSENIC", "type": "esriFieldTypeString", "alias": "HIGH_ARSENIC", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_ARSENIC" }, { "name": "HIGH_PESTICIDES", "type": "esriFieldTypeString", "alias": "HIGH_PESTICIDES", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HIGH_PESTICIDES" }, { "name": "SCHEDULE", "type": "esriFieldTypeString", "alias": "SCHEDULE", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "SCHEDULE" }, { "name": "MAXIMUM_DATE", "type": "esriFieldTypeDate", "alias": "MAXIMUM_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MAXIMUM_DATE" }, { "name": "SCREENING_METHOD", "type": "esriFieldTypeString", "alias": "SCREENING_METHOD", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "SCREENING_METHOD" }, { "name": "CATS", "type": "esriFieldTypeString", "alias": "CATS", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "CATS" }, { "name": "UNMATCHED40", "type": "esriFieldTypeString", "alias": "UNMATCHED40", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "UNMATCHED40" }, { "name": "L_SAMPLE_DATE_PETROLEUM", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_PETROLEUM", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_PETROLEUM" }, { "name": "L_SAMPLE_DATE_SOLVENT", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_SOLVENT", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_SOLVENT" }, { "name": "L_SAMPLE_DATE_NITRATES", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_NITRATES", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_NITRATES" }, { "name": "L_SAMPLE_DATE_EDB", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_EDB", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_EDB" }, { "name": "L_SAMPLE_DATE_METALS", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_METALS", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_METALS" }, { "name": "L_SAMPLE_DATE_VOC", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_VOC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_VOC" }, { "name": "L_SAMPLE_DATE_ARSENIC", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_ARSENIC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_ARSENIC" }, { "name": "L_SAMPLE_DATE_PESTICIDES", "type": "esriFieldTypeDate", "alias": "L_SAMPLE_DATE_PESTICIDES", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "L_SAMPLE_DATE_PESTICIDES" }, { "name": "LAST_JOB_NAME_PETROLEUM", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_PETROLEUM", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LAST_JOB_NAME_PETROLEUM" }, { "name": "LAST_JOB_NAME_NITRATES", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_NITRATES", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LAST_JOB_NAME_NITRATES" }, { "name": "LAST_JOB_NAME_EDB", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_EDB", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LAST_JOB_NAME_EDB" }, { "name": "LAST_JOB_NAME_METALS", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_METALS", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LAST_JOB_NAME_METALS" }, { "name": "LAST_JOB_NAME_ARSENIC", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_ARSENIC", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LAST_JOB_NAME_ARSENIC" }, { "name": "LAST_JOB_NAME_PESTICIDES", "type": "esriFieldTypeString", "alias": "LAST_JOB_NAME_PESTICIDES", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LAST_JOB_NAME_PESTICIDES" }, { "name": "AUTONUMBER", "type": "esriFieldTypeInteger", "alias": "AUTONUMBER", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "AUTONUMBER" } ], "indexes": [ { "name": "FLUWID", "fields": "FLUWID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "HSEW.DBO.ARCIMS_WELL", "description": "", "prototype": { "attributes": { "LAST_JOB_NAME_PESTICIDES": null, "FLUWID": null, "WELL_TYPE": null, "WELL_STATUS": null, "WELL_CASING_MATERIAL": null, "LONGITUDE": null, "LATITUDE": null, "WELL_DEPTH": null, "WELL_CASING_LENGTH": null, "WELL_CASING_DIAMETER": null, "WELL_PERMIT_NUMBER": null, "WELL_COMMENT": null, "WELL_SANITARY_SEAL": null, "WELL_BUSINESS_NAME": null, "RESIDENT_FIRSTNAME": null, "RESIDENT_LASTNAME": null, "WELL_PHONE": null, "WELL_PHONE_EXT": null, "DATUM": null, "HAE": null, "GPS_DATE": null, "LOCATION_METHOD": null, "PROJECT_ID": null, "INSPECTOR_FIRSTNAME": null, "INSPECTOR_LASTNAME": null, "INSPECTOR_COUNTY": null, "PROPERTY_ID": null, "COUNTY": null, "ADDRESS": null, "HOUSE_NUMBER": null, "PREDIRECTION": null, "PREFIX": null, "STREET": null, "SUFFIX": null, "POSTDIRECTION": null, "ZIPCODE": null, "CITY": null, "WSRP_ID": null, "ACTION": null, "POTABLE_STATUS": null, "PETROLEUM_STATUS": null, "SOLVENT_STATUS": null, "NITRATES": null, "EDB": null, "METALS": null, "VOC": null, "ARSENIC": null, "PESTICIDES": null, "HIGH_PETROLEUM": null, "HIGH_SOLVENT": null, "HIGH_NITRATES": null, "HIGH_EDB": null, "HIGH_METALS": null, "HIGH_VOC": null, "HIGH_ARSENIC": null, "HIGH_PESTICIDES": null, "SCHEDULE": null, "MAXIMUM_DATE": null, "SCREENING_METHOD": null, "CATS": null, "UNMATCHED40": null, "L_SAMPLE_DATE_PETROLEUM": null, "L_SAMPLE_DATE_SOLVENT": null, "L_SAMPLE_DATE_NITRATES": null, "L_SAMPLE_DATE_EDB": null, "L_SAMPLE_DATE_METALS": null, "L_SAMPLE_DATE_VOC": null, "L_SAMPLE_DATE_ARSENIC": null, "L_SAMPLE_DATE_PESTICIDES": null, "LAST_JOB_NAME_PETROLEUM": null, "LAST_JOB_NAME_NITRATES": null, "LAST_JOB_NAME_EDB": null, "LAST_JOB_NAME_METALS": null, "LAST_JOB_NAME_ARSENIC": null, "AUTONUMBER": 0 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }