Name: MDA_invinfo

Display Field: INV_ID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: b5a3ab6b253949669ff50752ab7b4796

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INV_ID ( type: esriFieldTypeString, alias: Case File #, editable: true, nullable: false, length: 15, defaultValue: null, modelName: Inv_ID )
• INVLOCID ( type: esriFieldTypeDouble, alias: Inv. Location ID, editable: true, nullable: false, defaultValue: null, modelName: INVLOCID )
• OLDLOCID ( type: esriFieldTypeString, alias: Old Invest. Location ID, editable: true, nullable: true, length: 12, defaultValue: null, modelName: OLDLOCID )
• INC_SITE ( type: esriFieldTypeString, alias: Case File Name, editable: true, nullable: true, length: 35, defaultValue: null, modelName: Inc_Site )
• LOC_DESCR ( type: esriFieldTypeString, alias: Location Descr., editable: true, nullable: true, length: 45, defaultValue: null, modelName: Loc_Descr )
• GISDATA ( type: esriFieldTypeString, alias: GIS Data Type, editable: true, nullable: false, length: 1, defaultValue: X, modelName: GISData , Coded Values: [B: Boundary Polygon] , [N: None] , [O: Old Emergency] , ...3 more... )
• INV_TYP ( type: esriFieldTypeString, alias: Investigation Type, editable: true, nullable: false, length: 2, defaultValue: E, modelName: Inv_Typ , Coded Values: [BS: Being Scored] , [C: Comprehensive] , [E: Emergency] , ...3 more... )
• INV_STAT ( type: esriFieldTypeString, alias: Investigation Status, editable: true, nullable: false, length: 1, defaultValue: A, modelName: Inv_Stat , Coded Values: [A: Active] , [C: Closed] , [I: Inactive] )
• MERLA ( type: esriFieldTypeString, alias: MERLA, editable: true, nullable: false, length: 1, defaultValue: N, modelName: MERLA , Coded Values: [N: No] , [Y: Yes] )
• CONTINGNCY ( type: esriFieldTypeString, alias: Contingency, editable: true, nullable: false, length: 1, defaultValue: N, modelName: Contingncy , Coded Values: [N: No] , [Y: Yes] )
• CONTAMIN ( type: esriFieldTypeString, alias: Contaminant, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Contamin , Coded Values: [AA: Anhydrous Ammonia] , [F: Fertilizer] , [N: None] , ...6 more... )
• CONTACT_NM ( type: esriFieldTypeString, alias: Contact Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contact_Nm , Coded Values: [Cathy Villas-Horns: Cathy Villas-Horns] , [Gary Elsner: Gary Elsner] , [Greg Hanson: Greg Hanson] , ...9 more... )
• CONTACT_PH ( type: esriFieldTypeString, alias: Contact Phone, editable: true, nullable: true, length: 14, defaultValue: (651) 201-6387, modelName: Contact_Ph , Coded Values: [(651) 201-6697: CV (651) 201-6697] , [(651) 201-6268: GE (651) 201-6268] , [(651) 201-6681: GH (651) 201-6681] , ...9 more... )
• CO_CODE ( type: esriFieldTypeString, alias: County Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Co_Code , Coded Values: [001: Aitkin] , [003: Anoka] , [005: Becker] , ...87 more... )
• DATCLOSED ( type: esriFieldTypeDate, alias: Date Closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DatClosed )
• EDITBY ( type: esriFieldTypeString, alias: Created/Last Edited By, editable: true, nullable: false, length: 3, defaultValue: 586, modelName: EditBy , Coded Values: [000: Other] , [038: Stan Kaminski] , [192: Jennifer Hayes] , ...39 more... )
• EDITDT ( type: esriFieldTypeDate, alias: Created/Last Edited Date, editable: true, nullable: false, length: 8, defaultValue: null, modelName: EditDt )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: MDA_invinfo
  Description:
  Prototype:
  EDITDT: -2209161600000
  EDITBY: 586
  INV_ID:
  INVLOCID: 0
  OLDLOCID: null
  INC_SITE: null
  LOC_DESCR: null
  GISDATA: X
  INV_TYP: E
  INV_STAT: A
  MERLA: N
  CONTINGNCY: N
  CONTAMIN: null
  CONTACT_NM: null
  CONTACT_PH: (651) 201-6387
  CO_CODE: null
  DATCLOSED: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata