{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 0,
 "name": "MDA_invinfo",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [],
 "isDataVersioned": false,
 "isDataArchived": false,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GLOBALID",
 "displayField": "INV_ID",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "INV_ID",
   "type": "esriFieldTypeString",
   "alias": "Case File #",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 15,
   "defaultValue": null,
   "modelName": "Inv_ID"
  },
  {
   "name": "INVLOCID",
   "type": "esriFieldTypeDouble",
   "alias": "Inv. Location ID",
   "domain": null,
   "editable": true,
   "nullable": false,
   "defaultValue": null,
   "modelName": "INVLOCID"
  },
  {
   "name": "OLDLOCID",
   "type": "esriFieldTypeString",
   "alias": "Old Invest. Location ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 12,
   "defaultValue": null,
   "modelName": "OLDLOCID"
  },
  {
   "name": "INC_SITE",
   "type": "esriFieldTypeString",
   "alias": "Case File Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 35,
   "defaultValue": null,
   "modelName": "Inc_Site"
  },
  {
   "name": "LOC_DESCR",
   "type": "esriFieldTypeString",
   "alias": "Location Descr.",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 45,
   "defaultValue": null,
   "modelName": "Loc_Descr"
  },
  {
   "name": "GISDATA",
   "type": "esriFieldTypeString",
   "alias": "GIS Data Type",
   "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"
   },
   "editable": true,
   "nullable": false,
   "length": 1,
   "defaultValue": "X",
   "modelName": "GISData"
  },
  {
   "name": "INV_TYP",
   "type": "esriFieldTypeString",
   "alias": "Investigation Type",
   "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"
   },
   "editable": true,
   "nullable": false,
   "length": 2,
   "defaultValue": "E",
   "modelName": "Inv_Typ"
  },
  {
   "name": "INV_STAT",
   "type": "esriFieldTypeString",
   "alias": "Investigation Status",
   "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"
   },
   "editable": true,
   "nullable": false,
   "length": 1,
   "defaultValue": "A",
   "modelName": "Inv_Stat"
  },
  {
   "name": "MERLA",
   "type": "esriFieldTypeString",
   "alias": "MERLA",
   "domain": {
    "type": "codedValue",
    "name": "Yes_No",
    "description": "Yes/No",
    "codedValues": [
     {
      "name": "No",
      "code": "N"
     },
     {
      "name": "Yes",
      "code": "Y"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 1,
   "defaultValue": "N",
   "modelName": "MERLA"
  },
  {
   "name": "CONTINGNCY",
   "type": "esriFieldTypeString",
   "alias": "Contingency",
   "domain": {
    "type": "codedValue",
    "name": "Yes_No",
    "description": "Yes/No",
    "codedValues": [
     {
      "name": "No",
      "code": "N"
     },
     {
      "name": "Yes",
      "code": "Y"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 1,
   "defaultValue": "N",
   "modelName": "Contingncy"
  },
  {
   "name": "CONTAMIN",
   "type": "esriFieldTypeString",
   "alias": "Contaminant",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 2,
   "defaultValue": null,
   "modelName": "Contamin"
  },
  {
   "name": "CONTACT_NM",
   "type": "esriFieldTypeString",
   "alias": "Contact Name",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "Contact_Nm"
  },
  {
   "name": "CONTACT_PH",
   "type": "esriFieldTypeString",
   "alias": "Contact Phone",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 14,
   "defaultValue": "(651) 201-6387",
   "modelName": "Contact_Ph"
  },
  {
   "name": "CO_CODE",
   "type": "esriFieldTypeString",
   "alias": "County Code",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 3,
   "defaultValue": null,
   "modelName": "Co_Code"
  },
  {
   "name": "DATCLOSED",
   "type": "esriFieldTypeDate",
   "alias": "Date Closed",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DatClosed"
  },
  {
   "name": "EDITBY",
   "type": "esriFieldTypeString",
   "alias": "Created/Last Edited By",
   "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"
   },
   "editable": true,
   "nullable": false,
   "length": 3,
   "defaultValue": "586",
   "modelName": "EditBy"
  },
  {
   "name": "EDITDT",
   "type": "esriFieldTypeDate",
   "alias": "Created/Last Edited Date",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 8,
   "defaultValue": null,
   "modelName": "EditDt"
  },
  {
   "name": "GLOBALID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GLOBALID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "GLOBALID"
  }
 ],
 "indexes": [
  {
   "name": "R1136_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_1136",
   "fields": "GLOBALID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "MDA_invinfo",
   "description": "",
   "prototype": {
    "attributes": {
     "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
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb",
 "capabilities": "Query",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "f6385225255744dc9d0b2e4039c7520c"
}