Name: HSEW.DBO.ARCIMS_WELL

Display Field: WELL_BUSINESS_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• FLUWID ( type: esriFieldTypeString, alias: FLUWID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FLUWID )
• WELL_TYPE ( type: esriFieldTypeString, alias: WELL_TYPE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: WELL_TYPE )
• WELL_STATUS ( type: esriFieldTypeString, alias: WELL_STATUS, editable: true, nullable: true, length: 9, defaultValue: null, modelName: WELL_STATUS )
• WELL_CASING_MATERIAL ( type: esriFieldTypeString, alias: WELL_CASING_MATERIAL, editable: true, nullable: true, length: 11, defaultValue: null, modelName: WELL_CASING_MATERIAL )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• WELL_DEPTH ( type: esriFieldTypeDouble, alias: WELL_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: WELL_DEPTH )
• WELL_CASING_LENGTH ( type: esriFieldTypeDouble, alias: WELL_CASING_LENGTH, editable: true, nullable: true, defaultValue: null, modelName: WELL_CASING_LENGTH )
• WELL_CASING_DIAMETER ( type: esriFieldTypeString, alias: WELL_CASING_DIAMETER, editable: true, nullable: true, length: 6, defaultValue: null, modelName: WELL_CASING_DIAMETER )
• WELL_PERMIT_NUMBER ( type: esriFieldTypeString, alias: WELL_PERMIT_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WELL_PERMIT_NUMBER )
• WELL_COMMENT ( type: esriFieldTypeString, alias: WELL_COMMENT, editable: true, nullable: true, length: 234, defaultValue: null, modelName: WELL_COMMENT )
• WELL_SANITARY_SEAL ( type: esriFieldTypeString, alias: WELL_SANITARY_SEAL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WELL_SANITARY_SEAL )
• WELL_BUSINESS_NAME ( type: esriFieldTypeString, alias: WELL_BUSINESS_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WELL_BUSINESS_NAME )
• RESIDENT_FIRSTNAME ( type: esriFieldTypeString, alias: RESIDENT_FIRSTNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RESIDENT_FIRSTNAME )
• RESIDENT_LASTNAME ( type: esriFieldTypeString, alias: RESIDENT_LASTNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RESIDENT_LASTNAME )
• WELL_PHONE ( type: esriFieldTypeString, alias: WELL_PHONE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WELL_PHONE )
• WELL_PHONE_EXT ( type: esriFieldTypeString, alias: WELL_PHONE_EXT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: WELL_PHONE_EXT )
• DATUM ( type: esriFieldTypeString, alias: DATUM, editable: true, nullable: true, length: 6, defaultValue: null, modelName: DATUM )
• HAE ( type: esriFieldTypeDouble, alias: HAE, editable: true, nullable: true, defaultValue: null, modelName: HAE )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• LOCATION_METHOD ( type: esriFieldTypeString, alias: LOCATION_METHOD, editable: true, nullable: true, length: 13, defaultValue: null, modelName: LOCATION_METHOD )
• PROJECT_ID ( type: esriFieldTypeString, alias: PROJECT_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PROJECT_ID )
• INSPECTOR_FIRSTNAME ( type: esriFieldTypeString, alias: INSPECTOR_FIRSTNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: INSPECTOR_FIRSTNAME )
• INSPECTOR_LASTNAME ( type: esriFieldTypeString, alias: INSPECTOR_LASTNAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: INSPECTOR_LASTNAME )
• INSPECTOR_COUNTY ( type: esriFieldTypeString, alias: INSPECTOR_COUNTY, editable: true, nullable: true, length: 12, defaultValue: null, modelName: INSPECTOR_COUNTY )
• PROPERTY_ID ( type: esriFieldTypeString, alias: PROPERTY_ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PROPERTY_ID )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COUNTY )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 80, defaultValue: null, modelName: ADDRESS )
• HOUSE_NUMBER ( type: esriFieldTypeString, alias: HOUSE_NUMBER, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HOUSE_NUMBER )
• PREDIRECTION ( type: esriFieldTypeString, alias: PREDIRECTION, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PREDIRECTION )
• PREFIX ( type: esriFieldTypeString, alias: PREFIX, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PREFIX )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 40, defaultValue: null, modelName: STREET )
• SUFFIX ( type: esriFieldTypeString, alias: SUFFIX, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SUFFIX )
• POSTDIRECTION ( type: esriFieldTypeString, alias: POSTDIRECTION, editable: true, nullable: true, length: 2, defaultValue: null, modelName: POSTDIRECTION )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIPCODE )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CITY )
• WSRP_ID ( type: esriFieldTypeString, alias: WSRP_ID, editable: true, nullable: true, length: 9, defaultValue: null, modelName: WSRP_ID )
• ACTION ( type: esriFieldTypeString, alias: ACTION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ACTION )
• POTABLE_STATUS ( type: esriFieldTypeString, alias: POTABLE_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POTABLE_STATUS )
• PETROLEUM_STATUS ( type: esriFieldTypeString, alias: PETROLEUM_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PETROLEUM_STATUS )
• SOLVENT_STATUS ( type: esriFieldTypeString, alias: SOLVENT_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOLVENT_STATUS )
• NITRATES ( type: esriFieldTypeString, alias: NITRATES, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NITRATES )
• EDB ( type: esriFieldTypeString, alias: EDB, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EDB )
• METALS ( type: esriFieldTypeString, alias: METALS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: METALS )
• VOC ( type: esriFieldTypeString, alias: VOC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VOC )
• ARSENIC ( type: esriFieldTypeString, alias: ARSENIC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ARSENIC )
• PESTICIDES ( type: esriFieldTypeString, alias: PESTICIDES, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PESTICIDES )
• HIGH_PETROLEUM ( type: esriFieldTypeString, alias: HIGH_PETROLEUM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_PETROLEUM )
• HIGH_SOLVENT ( type: esriFieldTypeString, alias: HIGH_SOLVENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_SOLVENT )
• HIGH_NITRATES ( type: esriFieldTypeString, alias: HIGH_NITRATES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_NITRATES )
• HIGH_EDB ( type: esriFieldTypeString, alias: HIGH_EDB, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_EDB )
• HIGH_METALS ( type: esriFieldTypeString, alias: HIGH_METALS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_METALS )
• HIGH_VOC ( type: esriFieldTypeString, alias: HIGH_VOC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_VOC )
• HIGH_ARSENIC ( type: esriFieldTypeString, alias: HIGH_ARSENIC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_ARSENIC )
• HIGH_PESTICIDES ( type: esriFieldTypeString, alias: HIGH_PESTICIDES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HIGH_PESTICIDES )
• SCHEDULE ( type: esriFieldTypeString, alias: SCHEDULE, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SCHEDULE )
• MAXIMUM_DATE ( type: esriFieldTypeDate, alias: MAXIMUM_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAXIMUM_DATE )
• SCREENING_METHOD ( type: esriFieldTypeString, alias: SCREENING_METHOD, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SCREENING_METHOD )
• CATS ( type: esriFieldTypeString, alias: CATS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CATS )
• UNMATCHED40 ( type: esriFieldTypeString, alias: UNMATCHED40, editable: true, nullable: true, length: 250, defaultValue: null, modelName: UNMATCHED40 )
• L_SAMPLE_DATE_PETROLEUM ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_PETROLEUM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_PETROLEUM )
• L_SAMPLE_DATE_SOLVENT ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_SOLVENT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_SOLVENT )
• L_SAMPLE_DATE_NITRATES ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_NITRATES, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_NITRATES )
• L_SAMPLE_DATE_EDB ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_EDB, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_EDB )
• L_SAMPLE_DATE_METALS ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_METALS, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_METALS )
• L_SAMPLE_DATE_VOC ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_VOC, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_VOC )
• L_SAMPLE_DATE_ARSENIC ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_ARSENIC, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_ARSENIC )
• L_SAMPLE_DATE_PESTICIDES ( type: esriFieldTypeDate, alias: L_SAMPLE_DATE_PESTICIDES, editable: true, nullable: true, length: 8, defaultValue: null, modelName: L_SAMPLE_DATE_PESTICIDES )
• LAST_JOB_NAME_PETROLEUM ( type: esriFieldTypeString, alias: LAST_JOB_NAME_PETROLEUM, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LAST_JOB_NAME_PETROLEUM )
• LAST_JOB_NAME_NITRATES ( type: esriFieldTypeString, alias: LAST_JOB_NAME_NITRATES, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LAST_JOB_NAME_NITRATES )
• LAST_JOB_NAME_EDB ( type: esriFieldTypeString, alias: LAST_JOB_NAME_EDB, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LAST_JOB_NAME_EDB )
• LAST_JOB_NAME_METALS ( type: esriFieldTypeString, alias: LAST_JOB_NAME_METALS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LAST_JOB_NAME_METALS )
• LAST_JOB_NAME_ARSENIC ( type: esriFieldTypeString, alias: LAST_JOB_NAME_ARSENIC, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LAST_JOB_NAME_ARSENIC )
• LAST_JOB_NAME_PESTICIDES ( type: esriFieldTypeString, alias: LAST_JOB_NAME_PESTICIDES, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LAST_JOB_NAME_PESTICIDES )
• AUTONUMBER ( type: esriFieldTypeInteger, alias: AUTONUMBER, editable: true, nullable: false, defaultValue: null, modelName: AUTONUMBER )

Templates:

• Name: HSEW.DBO.ARCIMS_WELL
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata