Tables:

Table: MDA_invinfo (0)

Name: MDA_invinfo

Display Field: INV_ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 58582dd924c34eb6ae968c12716695ce

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• INV_ID ( type: esriFieldTypeString, alias: Case File #, length: 15 )
• INVLOCID ( type: esriFieldTypeDouble, alias: Inv. Location ID )
• OLDLOCID ( type: esriFieldTypeString, alias: Old Invest. Location ID, length: 12 )
• INC_SITE ( type: esriFieldTypeString, alias: Case File Name, length: 35 )
• LOC_DESCR ( type: esriFieldTypeString, alias: Location Descr., length: 45 )
• GISDATA ( type: esriFieldTypeString, alias: GIS Data Type, length: 1 , Coded Values: [B: Boundary Polygon] , [N: None] , [O: Old Emergency] , ...3 more... )
• INV_TYP ( type: esriFieldTypeString, alias: Investigation Type, length: 2 , Coded Values: [BS: Being Scored] , [C: Comprehensive] , [E: Emergency] , ...3 more... )
• INV_STAT ( type: esriFieldTypeString, alias: Investigation Status, length: 1 , Coded Values: [A: Active] , [C: Closed] , [I: Inactive] )
• MERLA ( type: esriFieldTypeString, alias: MERLA, length: 1 , Coded Values: [N: No] , [Y: Yes] )
• CONTINGNCY ( type: esriFieldTypeString, alias: Contingency, length: 1 , Coded Values: [N: No] , [Y: Yes] )
• CONTAMIN ( type: esriFieldTypeString, alias: Contaminant, length: 2 , Coded Values: [AA: Anhydrous Ammonia] , [F: Fertilizer] , [N: None] , ...6 more... )
• CONTACT_NM ( type: esriFieldTypeString, alias: Contact Name, length: 30 , 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, length: 14 , 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, length: 3 , Coded Values: [001: Aitkin] , [003: Anoka] , [005: Becker] , ...87 more... )
• DATCLOSED ( type: esriFieldTypeDate, alias: Date Closed, length: 8 )
• EDITBY ( type: esriFieldTypeString, alias: Created/Last Edited By, length: 3 , Coded Values: [000: Other] , [038: Stan Kaminski] , [192: Jennifer Hayes] , ...39 more... )
• EDITDT ( type: esriFieldTypeDate, alias: Created/Last Edited Date, length: 8 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )