{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 20,
 "name": "Signs History",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "DateVisit",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "GMIID",
   "type": "esriFieldTypeString",
   "alias": "GMIID",
   "length": 24,
   "domain": null
  },
  {
   "name": "DateVisit",
   "type": "esriFieldTypeDate",
   "alias": "DateVisit",
   "length": 8,
   "domain": null
  },
  {
   "name": "Reason",
   "type": "esriFieldTypeString",
   "alias": "Reason",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "WS1_Sign_Reason_2",
    "description": "Sign_Reason\t\n",
    "codedValues": [
     {
      "name": "Anchor Broke",
      "code": "Anchor Broke"
     },
     {
      "name": "Anchor Buried",
      "code": "Anchor Buried"
     },
     {
      "name": "Anchor Loose",
      "code": "Anchor Loose"
     },
     {
      "name": "Bolt Missing",
      "code": "Bolt Missing"
     },
     {
      "name": "Bullet Holes",
      "code": "Bullet Holes"
     },
     {
      "name": "Check ID Sticker",
      "code": "Check ID Sticker"
     },
     {
      "name": "Checked Sign",
      "code": "Checked Sign"
     },
     {
      "name": "Commissioners Decision",
      "code": "Commissioners Decision"
     },
     {
      "name": "Construction Done",
      "code": "Construction Done"
     },
     {
      "name": "Graffiti",
      "code": "Graffiti"
     },
     {
      "name": "Graffiti / Post Bent",
      "code": "Graffiti / Post Bent"
     },
     {
      "name": "Graffiti / Post Broke",
      "code": "Graffiti / Post Broke"
     },
     {
      "name": "ID Sticker Missing",
      "code": "ID Sticker Missing"
     },
     {
      "name": "ID Sticker Faded",
      "code": "ID Sticker Faded"
     },
     {
      "name": "Ink Faded",
      "code": "Ink Faded"
     },
     {
      "name": "Not Needed",
      "code": "Not Needed"
     },
     {
      "name": "Old Sign",
      "code": "Old Sign"
     },
     {
      "name": "Paintball",
      "code": "Paintball"
     },
     {
      "name": "Post Bent",
      "code": "Post Bent"
     },
     {
      "name": "Post Bent / Anchor Damaged",
      "code": "Post Bent / Anchor Damaged"
     },
     {
      "name": "Post Bent / Sign Bent",
      "code": "Post Bent / Sign Bent"
     },
     {
      "name": "Post Broke",
      "code": "Post Broke"
     },
     {
      "name": "Post Broke / Sign Bent",
      "code": "Post Broke / Sign Bent"
     },
     {
      "name": "Post and Sign Missing",
      "code": "Post and Sign Missing"
     },
     {
      "name": "Post Leaning",
      "code": "Post Leaning"
     },
     {
      "name": "Post Stuck in Anchor",
      "code": "Post Stuck in Anchor"
     },
     {
      "name": "Rivet Out",
      "code": "Rivet Out"
     },
     {
      "name": "Road Construction",
      "code": "Road Construction"
     },
     {
      "name": "Sagebrush Blocking Sign",
      "code": "Sagebrush Blocking Sign"
     },
     {
      "name": "Shot Up",
      "code": "Shot Up"
     },
     {
      "name": "Sign Bent",
      "code": "Sign Bent"
     },
     {
      "name": "Sign Blocked",
      "code": "Sign Blocked"
     },
     {
      "name": "Sign Burnt",
      "code": "Sign Burnt"
     },
     {
      "name": "Sign Damaged",
      "code": "Sign Damaged"
     },
     {
      "name": "Sign Dirty",
      "code": "Sign Dirty"
     },
     {
      "name": "Sign Down",
      "code": "Sign Down"
     },
     {
      "name": "Sign Faded",
      "code": "Sign Faded"
     },
     {
      "name": "Sign Faded / Post Leaning",
      "code": "Sign Faded / Post Leaning"
     },
     {
      "name": "Sign Faded / Post Broke",
      "code": "Sign Faded / Post Broke"
     },
     {
      "name": "Sign Loose",
      "code": "Sign Loose"
     },
     {
      "name": "Sign Missing",
      "code": "Sign Missing"
     },
     {
      "name": "Sign Missing / Post Broke",
      "code": "Sign Missing / Post Broke"
     },
     {
      "name": "Sign Post and Anchor Missing",
      "code": "Sign Post and Anchor Missing"
     },
     {
      "name": "Sign Post and Anchor Out",
      "code": "Sign Post and Anchor Out"
     },
     {
      "name": "Sun Damage - Warranty",
      "code": "Sun Damage - Warranty"
     },
     {
      "name": "Took Down Tire Rim Stop Sign",
      "code": "Took Down Tire Rim Stop Sign"
     },
     {
      "name": "Tree Limbs",
      "code": "Tree Limbs"
     },
     {
      "name": "Weeds Blocking Sign",
      "code": "Weeds Blocking Sign"
     },
     {
      "name": "Wind Damage",
      "code": "Wind Damage"
     },
     {
      "name": "Wrong Angle",
      "code": "Wrong Angle"
     },
     {
      "name": "Wrong Location",
      "code": "Wrong Location"
     },
     {
      "name": "Wrong Sign",
      "code": "Wrong Sign"
     },
     {
      "name": "Other (Specify)",
      "code": "Other (Specify)"
     },
     {
      "name": "New Sign",
      "code": "New Sign"
     },
     {
      "name": "Wood Post",
      "code": "Wood Post"
     },
     {
      "name": "Night Inspection",
      "code": "Night Inspection"
     },
     {
      "name": "Sign Faded / Post Bent",
      "code": "Sign Faded / Post Bent"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ActionTakn",
   "type": "esriFieldTypeString",
   "alias": "ActionTakn",
   "length": 75,
   "domain": {
    "type": "codedValue",
    "name": "WS1_Sign_Action_2",
    "description": "\tSign_Action\t\n",
    "codedValues": [
     {
      "name": "Added Rivets",
      "code": "Added Rivets"
     },
     {
      "name": "Added Washers",
      "code": "Added Washers"
     },
     {
      "name": "Apply Vinyl Overlay",
      "code": "Apply Vinyl Overlay"
     },
     {
      "name": "Bullet Holes OK for Now",
      "code": "Bullet Holes OK for Now"
     },
     {
      "name": "Change ID # on Sign",
      "code": "Change ID # on Sign"
     },
     {
      "name": "Cleaned Sign",
      "code": "Cleaned Sign"
     },
     {
      "name": "Cut and Reset Post and Sign",
      "code": "Cut and Reset Post and Sign"
     },
     {
      "name": "Cut Down Tree",
      "code": "Cut Down Tree"
     },
     {
      "name": "Dug New Hole Reset Anchor Post & Sign",
      "code": "Dug New Hole Reset Anchor Post & Sign"
     },
     {
      "name": "Dug Out Anchor",
      "code": "Dug Out Anchor"
     },
     {
      "name": "Fixed Temporary",
      "code": "Fixed Temporary"
     },
     {
      "name": "ID Number OK",
      "code": "ID Number OK"
     },
     {
      "name": "Installed Grid Sign Above Stop Sign",
      "code": "Installed Grid Sign Above Stop Sign"
     },
     {
      "name": "Installed New Anchor",
      "code": "Installed New Anchor"
     },
     {
      "name": "Installed New Diamond Grade Sign",
      "code": "Installed New Diamond Grade Sign"
     },
     {
      "name": "Installed New HIP Sign",
      "code": "Installed New HIP Sign"
     },
     {
      "name": "Installed New HIP Sign and Reset Post",
      "code": "Installed New HIP Sign and Reset Post"
     },
     {
      "name": "Installed New HIP Sign and Tube Post and Reset Anchor",
      "code": "Installed New HIP Sign and Tube Post and Reset Anchor"
     },
     {
      "name": "Installed New HIP Sign and Straightened Post",
      "code": "Installed New HIP Sign and Straightened Post"
     },
     {
      "name": "Installed New HIP Sign and Tube Post and Anchor",
      "code": "Installed New HIP Sign and Tube Post and Anchor"
     },
     {
      "name": "Installed New HIP Sign and Tube Post",
      "code": "Installed New HIP Sign and Tube Post"
     },
     {
      "name": "Installed New ID Sticker",
      "code": "Installed New ID Sticker"
     },
     {
      "name": "Installed New Tube Post",
      "code": "Installed New Tube Post"
     },
     {
      "name": "Installed New Tube Post and Repaired Anchor",
      "code": "Installed New Tube Post and Repaired Anchor"
     },
     {
      "name": "Installed New Tube Post and Straightened Sign",
      "code": "Installed New Tube Post and Straightened Sign"
     },
     {
      "name": "Installed New U-Channel Post and HIP Sign",
      "code": "Installed New U-Channel Post and HIP Sign"
     },
     {
      "name": "Installed New U-Channel Post and Reset Sign",
      "code": "Installed New U-Channel Post and Reset Sign"
     },
     {
      "name": "Installed New U-Channel Post and Straightened Sign",
      "code": "Installed New U-Channel Post and Straightened Sign"
     },
     {
      "name": "Installed New Anchor, Tube Post, and Reset Sign",
      "code": "Installed New Anchor, Tube Post, and Reset Sign"
     },
     {
      "name": "Installed New Tube Post, Anchor, and Remounted Sign",
      "code": "Installed New Tube Post, Anchor, and Remounted Sign"
     },
     {
      "name": "OK for now",
      "code": "OK for now"
     },
     {
      "name": "Ordered New Sign",
      "code": "Ordered New Sign"
     },
     {
      "name": "Put on Correct ID#",
      "code": "Put on Correct ID#"
     },
     {
      "name": "Remounted Sign",
      "code": "Remounted Sign"
     },
     {
      "name": "Removed Weeds",
      "code": "Removed Weeds"
     },
     {
      "name": "Replaced Bolt",
      "code": "Replaced Bolt"
     },
     {
      "name": "Replaced Rivets",
      "code": "Replaced Rivets"
     },
     {
      "name": "Reset Anchor and Post",
      "code": "Reset Anchor and Post"
     },
     {
      "name": "Reset with Concrete",
      "code": "Reset with Concrete"
     },
     {
      "name": "Set Temporary Stop Sign on Tire Rim",
      "code": "Set Temporary Stop Sign on Tire Rim"
     },
     {
      "name": "Sign in Fair Shape",
      "code": "Sign in Fair Shape"
     },
     {
      "name": "Sign in Good Shape",
      "code": "Sign in Good Shape"
     },
     {
      "name": "Sign in Poor Shape",
      "code": "Sign in Poor Shape"
     },
     {
      "name": "Straightened Post",
      "code": "Straightened Post"
     },
     {
      "name": "Straightened Post and Reset Anchor",
      "code": "Straightened Post and Reset Anchor"
     },
     {
      "name": "Straightened Post and Sign",
      "code": "Straightened Post and Sign"
     },
     {
      "name": "Straightened Sign",
      "code": "Straightened Sign"
     },
     {
      "name": "Temporarily Removed Signs",
      "code": "Temporarily Removed Signs"
     },
     {
      "name": "Took Down Sign",
      "code": "Took Down Sign"
     },
     {
      "name": "Trimmed Sagebrush",
      "code": "Trimmed Sagebrush"
     },
     {
      "name": "Trimmed Tree",
      "code": "Trimmed Tree"
     },
     {
      "name": "Update Database",
      "code": "Update Database"
     },
     {
      "name": "Work Order Written",
      "code": "Work Order Written"
     },
     {
      "name": "Other (Specify)",
      "code": "Other (Specify)"
     },
     {
      "name": "NI Failed",
      "code": "NI Failed"
     },
     {
      "name": "NI Passed",
      "code": "NI Passed"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Vandalism",
   "type": "esriFieldTypeString",
   "alias": "Vandalism",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "WS1_YesNo",
    "description": "Yes or No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Crew",
   "type": "esriFieldTypeString",
   "alias": "Crew",
   "length": 10,
   "domain": null
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "Cost",
   "type": "esriFieldTypeDouble",
   "alias": "Cost",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGUID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Reason_Other",
   "type": "esriFieldTypeString",
   "alias": "Reason_Other",
   "length": 50,
   "domain": null
  },
  {
   "name": "Action_Taken_Other",
   "type": "esriFieldTypeString",
   "alias": "Action_Taken_Other",
   "length": 50,
   "domain": null
  },
  {
   "name": "GlobalID_1",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID_1",
   "length": 38,
   "domain": null
  },
  {
   "name": "Site_ID",
   "type": "esriFieldTypeString",
   "alias": "Site_ID",
   "length": 30,
   "domain": null
  },
  {
   "name": "Date_Sort",
   "type": "esriFieldTypeString",
   "alias": "Date_Sort",
   "length": 10,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R83_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_83",
   "fields": "GlobalID_1",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G190Site_ID",
   "fields": "Site_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G190GlobalID",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_83",
   "fields": "GlobalID_1,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "signs",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "Site_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{AFD31C96-B27D-4FCA-A3A9-1B38E173CE30}"
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "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": {
  "timeZone": "Mountain Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "6be0581d745e4fa0b88791e5cb29efb4"
}