{
 "layers": [],
 "tables": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 0,
   "name": "MDA_invinfo",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "INV_ID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "INV_ID",
     "type": "esriFieldTypeString",
     "alias": "Case File #",
     "length": 15,
     "domain": null
    },
    {
     "name": "INVLOCID",
     "type": "esriFieldTypeDouble",
     "alias": "Inv. Location ID",
     "domain": null
    },
    {
     "name": "OLDLOCID",
     "type": "esriFieldTypeString",
     "alias": "Old Invest. Location ID",
     "length": 12,
     "domain": null
    },
    {
     "name": "INC_SITE",
     "type": "esriFieldTypeString",
     "alias": "Case File Name",
     "length": 35,
     "domain": null
    },
    {
     "name": "LOC_DESCR",
     "type": "esriFieldTypeString",
     "alias": "Location Descr.",
     "length": 45,
     "domain": null
    },
    {
     "name": "GISDATA",
     "type": "esriFieldTypeString",
     "alias": "GIS Data Type",
     "length": 1,
     "domain": {
      "type": "codedValue",
      "name": "GISData",
      "description": "Incident Location GIS Data Type",
      "codedValues": [
       {
        "name": "Boundary Polygon",
        "code": "B"
       },
       {
        "name": "None",
        "code": "N"
       },
       {
        "name": "Old Emergency",
        "code": "O"
       },
       {
        "name": "Point",
        "code": "P"
       },
       {
        "name": "Data Needed",
        "code": "X"
       },
       {
        "name": "Line",
        "code": "L"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "INV_TYP",
     "type": "esriFieldTypeString",
     "alias": "Investigation Type",
     "length": 2,
     "domain": {
      "type": "codedValue",
      "name": "Inv_Typ",
      "description": "Investigation Type",
      "codedValues": [
       {
        "name": "Being Scored",
        "code": "BS"
       },
       {
        "name": "Comprehensive",
        "code": "C"
       },
       {
        "name": "Emergency",
        "code": "E"
       },
       {
        "name": "Misuse",
        "code": "M"
       },
       {
        "name": "Prioritized",
        "code": "PZ"
       },
       {
        "name": "Voluntary",
        "code": "V"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "INV_STAT",
     "type": "esriFieldTypeString",
     "alias": "Investigation Status",
     "length": 1,
     "domain": {
      "type": "codedValue",
      "name": "Inv_Stat",
      "description": "Investigation Status",
      "codedValues": [
       {
        "name": "Active",
        "code": "A"
       },
       {
        "name": "Closed",
        "code": "C"
       },
       {
        "name": "Inactive",
        "code": "I"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "MERLA",
     "type": "esriFieldTypeString",
     "alias": "MERLA",
     "length": 1,
     "domain": {
      "type": "codedValue",
      "name": "Yes_No",
      "description": "Yes/No",
      "codedValues": [
       {
        "name": "No",
        "code": "N"
       },
       {
        "name": "Yes",
        "code": "Y"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "CONTINGNCY",
     "type": "esriFieldTypeString",
     "alias": "Contingency",
     "length": 1,
     "domain": {
      "type": "codedValue",
      "name": "Yes_No",
      "description": "Yes/No",
      "codedValues": [
       {
        "name": "No",
        "code": "N"
       },
       {
        "name": "Yes",
        "code": "Y"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "CONTAMIN",
     "type": "esriFieldTypeString",
     "alias": "Contaminant",
     "length": 2,
     "domain": {
      "type": "codedValue",
      "name": "Contamin",
      "description": "Contaminant",
      "codedValues": [
       {
        "name": "Anhydrous Ammonia",
        "code": "AA"
       },
       {
        "name": "Fertilizer",
        "code": "F"
       },
       {
        "name": "None",
        "code": "N"
       },
       {
        "name": "Other",
        "code": "O"
       },
       {
        "name": "Pesticides",
        "code": "P"
       },
       {
        "name": "Pesticides & Fertilizer",
        "code": "PF"
       },
       {
        "name": "Swimming Pool",
        "code": "SP"
       },
       {
        "name": "Unknown",
        "code": "U"
       },
       {
        "name": "Wood Preservative",
        "code": "WP"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "CONTACT_NM",
     "type": "esriFieldTypeString",
     "alias": "Contact Name",
     "length": 30,
     "domain": {
      "type": "codedValue",
      "name": "Contact_NM",
      "description": "IRU Contact Name",
      "codedValues": [
       {
        "name": "Cathy Villas-Horns",
        "code": "Cathy Villas-Horns"
       },
       {
        "name": "Gary Elsner",
        "code": "Gary Elsner"
       },
       {
        "name": "Greg Hanson",
        "code": "Greg Hanson"
       },
       {
        "name": "MDA Data Practices Records Mng",
        "code": "MDA Data Practices Records Mng"
       },
       {
        "name": "Richard Rippley",
        "code": "Richard Rippley"
       },
       {
        "name": "Adreanne Johnson",
        "code": "Adreanne Johnson"
       },
       {
        "name": "Stuart Orlowski",
        "code": "Stuart Orlowski"
       },
       {
        "name": "Paul Haiker",
        "code": "Paul Haiker"
       },
       {
        "name": "Josh Leable",
        "code": "Josh Leable"
       },
       {
        "name": "Lee Zettler",
        "code": "Lee Zettler"
       },
       {
        "name": "Kayla Nelson",
        "code": "Kayla Nelson"
       },
       {
        "name": "Jared Schmaedeke",
        "code": "Jared Schmaedeke"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "CONTACT_PH",
     "type": "esriFieldTypeString",
     "alias": "Contact Phone",
     "length": 14,
     "domain": {
      "type": "codedValue",
      "name": "Contact_PH",
      "description": "IRU Contact Phone",
      "codedValues": [
       {
        "name": "CV (651) 201-6697",
        "code": "(651) 201-6697"
       },
       {
        "name": "GE (651) 201-6268",
        "code": "(651) 201-6268"
       },
       {
        "name": "GH (651) 201-6681",
        "code": "(651) 201-6681"
       },
       {
        "name": "DC (651) 201-6698",
        "code": "(651) 201-6698"
       },
       {
        "name": "RR (651) 201-6370",
        "code": "(651) 201-6370"
       },
       {
        "name": "SO (651) 201-6148",
        "code": "(651) 201-6148"
       },
       {
        "name": "PH (651) 201-6199",
        "code": "(651) 201-6199"
       },
       {
        "name": "JL (651) 201-6632",
        "code": "(651) 201-6632"
       },
       {
        "name": "AJ (651) 201-6455",
        "code": "(651) 201-6455"
       },
       {
        "name": "LZ (651) 201-6394",
        "code": "(651) 201-6394"
       },
       {
        "name": "KN (651) 201-6139",
        "code": "(651) 201-6139"
       },
       {
        "name": "JS (651) 201-6387",
        "code": "(651) 201-6387"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "CO_CODE",
     "type": "esriFieldTypeString",
     "alias": "County Code",
     "length": 3,
     "domain": {
      "type": "codedValue",
      "name": "Co_Code",
      "description": "County Fips",
      "codedValues": [
       {
        "name": "Aitkin",
        "code": "001"
       },
       {
        "name": "Anoka",
        "code": "003"
       },
       {
        "name": "Becker",
        "code": "005"
       },
       {
        "name": "Beltrami",
        "code": "007"
       },
       {
        "name": "Benton",
        "code": "009"
       },
       {
        "name": "Big Stone",
        "code": "011"
       },
       {
        "name": "Blue Earth",
        "code": "013"
       },
       {
        "name": "Brown",
        "code": "015"
       },
       {
        "name": "Carlton",
        "code": "017"
       },
       {
        "name": "Carver",
        "code": "019"
       },
       {
        "name": "Cass",
        "code": "021"
       },
       {
        "name": "Chippewa",
        "code": "023"
       },
       {
        "name": "Chisago",
        "code": "025"
       },
       {
        "name": "Clay",
        "code": "027"
       },
       {
        "name": "Clearwater",
        "code": "029"
       },
       {
        "name": "Cook",
        "code": "031"
       },
       {
        "name": "Cottonwood",
        "code": "033"
       },
       {
        "name": "Crow Wing",
        "code": "035"
       },
       {
        "name": "Dakota",
        "code": "037"
       },
       {
        "name": "Dodge",
        "code": "039"
       },
       {
        "name": "Douglas",
        "code": "041"
       },
       {
        "name": "Faribault",
        "code": "043"
       },
       {
        "name": "Fillmore",
        "code": "045"
       },
       {
        "name": "Freeborn",
        "code": "047"
       },
       {
        "name": "Goodhue",
        "code": "049"
       },
       {
        "name": "Grant",
        "code": "051"
       },
       {
        "name": "Hennepin",
        "code": "053"
       },
       {
        "name": "Houston",
        "code": "055"
       },
       {
        "name": "Hubbard",
        "code": "057"
       },
       {
        "name": "Isanti",
        "code": "059"
       },
       {
        "name": "Itasca",
        "code": "061"
       },
       {
        "name": "Jackson",
        "code": "063"
       },
       {
        "name": "Kanabec",
        "code": "065"
       },
       {
        "name": "Kandiyohi",
        "code": "067"
       },
       {
        "name": "Kittson",
        "code": "069"
       },
       {
        "name": "Koochiching",
        "code": "071"
       },
       {
        "name": "Lac Qui Parle",
        "code": "073"
       },
       {
        "name": "Lake",
        "code": "075"
       },
       {
        "name": "Lake of the Woods",
        "code": "077"
       },
       {
        "name": "Le Sueur",
        "code": "079"
       },
       {
        "name": "Lincoln",
        "code": "081"
       },
       {
        "name": "Lyon",
        "code": "083"
       },
       {
        "name": "McLeod",
        "code": "085"
       },
       {
        "name": "Mahnomen",
        "code": "087"
       },
       {
        "name": "Marshall",
        "code": "089"
       },
       {
        "name": "Martin",
        "code": "091"
       },
       {
        "name": "Meeker",
        "code": "093"
       },
       {
        "name": "Mille Lacs",
        "code": "095"
       },
       {
        "name": "Morrison",
        "code": "097"
       },
       {
        "name": "Mower",
        "code": "099"
       },
       {
        "name": "Murray",
        "code": "101"
       },
       {
        "name": "Nicollet",
        "code": "103"
       },
       {
        "name": "Nobles",
        "code": "105"
       },
       {
        "name": "Norman",
        "code": "107"
       },
       {
        "name": "Olmsted",
        "code": "109"
       },
       {
        "name": "Otter Tail",
        "code": "111"
       },
       {
        "name": "Pennington",
        "code": "113"
       },
       {
        "name": "Pine",
        "code": "115"
       },
       {
        "name": "Pipestone",
        "code": "117"
       },
       {
        "name": "Polk",
        "code": "119"
       },
       {
        "name": "Pope",
        "code": "121"
       },
       {
        "name": "Ramsey",
        "code": "123"
       },
       {
        "name": "Red Lake",
        "code": "125"
       },
       {
        "name": "Redwood",
        "code": "127"
       },
       {
        "name": "Renville",
        "code": "129"
       },
       {
        "name": "Rice",
        "code": "131"
       },
       {
        "name": "Rock",
        "code": "133"
       },
       {
        "name": "Roseau",
        "code": "135"
       },
       {
        "name": "Saint Louis",
        "code": "137"
       },
       {
        "name": "Scott",
        "code": "139"
       },
       {
        "name": "Sherburne",
        "code": "141"
       },
       {
        "name": "Sibley",
        "code": "143"
       },
       {
        "name": "Stearns",
        "code": "145"
       },
       {
        "name": "Steele",
        "code": "147"
       },
       {
        "name": "Stevens",
        "code": "149"
       },
       {
        "name": "Swift",
        "code": "151"
       },
       {
        "name": "Todd",
        "code": "153"
       },
       {
        "name": "Traverse",
        "code": "155"
       },
       {
        "name": "Wabasha",
        "code": "157"
       },
       {
        "name": "Wadena",
        "code": "159"
       },
       {
        "name": "Waseca",
        "code": "161"
       },
       {
        "name": "Washington",
        "code": "163"
       },
       {
        "name": "Watonwan",
        "code": "165"
       },
       {
        "name": "Wilkin",
        "code": "167"
       },
       {
        "name": "Winona",
        "code": "169"
       },
       {
        "name": "Wright",
        "code": "171"
       },
       {
        "name": "Yellow Medicine",
        "code": "173"
       },
       {
        "name": "None/UNK",
        "code": "998"
       },
       {
        "name": "Out of State",
        "code": "999"
       },
       {
        "name": "Mobile",
        "code": "000"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "DATCLOSED",
     "type": "esriFieldTypeDate",
     "alias": "Date Closed",
     "length": 8,
     "domain": null
    },
    {
     "name": "EDITBY",
     "type": "esriFieldTypeString",
     "alias": "Created/Last Edited By",
     "length": 3,
     "domain": {
      "type": "codedValue",
      "name": "Staff_Id",
      "description": "PFMD Staff ID Num",
      "codedValues": [
       {
        "name": "Other",
        "code": "000"
       },
       {
        "name": "Stan Kaminski",
        "code": "038"
       },
       {
        "name": "Jennifer Hayes",
        "code": "192"
       },
       {
        "name": "Roger Mackedanz",
        "code": "434"
       },
       {
        "name": "Gary Elsner",
        "code": "586"
       },
       {
        "name": "Pat Kelly",
        "code": "608"
       },
       {
        "name": "Bob Anderson",
        "code": "001"
       },
       {
        "name": "Paul McNelly",
        "code": "548"
       },
       {
        "name": "Terry McDill",
        "code": "501"
       },
       {
        "name": "Michele Puchalski",
        "code": "361"
       },
       {
        "name": "Greg Hanson",
        "code": "351"
       },
       {
        "name": "Cathy V. Horns",
        "code": "134"
       },
       {
        "name": "Rich Estum",
        "code": "018"
       },
       {
        "name": "Jim Freilinger",
        "code": "349"
       },
       {
        "name": "Duane Munter",
        "code": "500"
       },
       {
        "name": "Don Opdahl",
        "code": "355"
       },
       {
        "name": "Bob Rialson",
        "code": "356"
       },
       {
        "name": "Jeff Siira",
        "code": "503"
       },
       {
        "name": "Wayne Ulrich",
        "code": "494"
       },
       {
        "name": "Alice Waller",
        "code": "488"
       },
       {
        "name": "Theresa Paulson",
        "code": "362"
       },
       {
        "name": "Stan Kaminski",
        "code": "584"
       },
       {
        "name": "Sharon Emert",
        "code": "333"
       },
       {
        "name": "James Seaberg",
        "code": "791"
       },
       {
        "name": "Constance Holth",
        "code": "370"
       },
       {
        "name": "Glen Champion",
        "code": "830"
       },
       {
        "name": "Thomas Reppe",
        "code": "831"
       },
       {
        "name": "Terry Varing",
        "code": "999"
       },
       {
        "name": "Jeff Paddock",
        "code": "840"
       },
       {
        "name": "Annaliza Heesch",
        "code": "843"
       },
       {
        "name": "Richard Rippley",
        "code": "845"
       },
       {
        "name": "Anne Marie Wells",
        "code": "847"
       },
       {
        "name": "Michele Mabry",
        "code": "848"
       },
       {
        "name": "Stuart Orlowski",
        "code": "849"
       },
       {
        "name": "Deb Madsen",
        "code": "850"
       },
       {
        "name": "Paul Haiker",
        "code": "851"
       },
       {
        "name": "Erin Spry",
        "code": "852"
       },
       {
        "name": "Adreanne Johnson",
        "code": "846"
       },
       {
        "name": "Josh Leable",
        "code": "853"
       },
       {
        "name": "Lee Zettler",
        "code": "854"
       },
       {
        "name": "Kayla Nelson",
        "code": "855"
       },
       {
        "name": "Jared Schmaedeke",
        "code": "856"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "EDITDT",
     "type": "esriFieldTypeDate",
     "alias": "Created/Last Edited Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "GLOBALID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GLOBALID",
     "length": 38,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R1136_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_1136",
     "fields": "GLOBALID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "58582dd924c34eb6ae968c12716695ce"
  }
 ]
}