{
 "currentVersion": 10.81,
 "cimVersion": "2.6.0",
 "id": 1,
 "name": "Signs_Table",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "A_SignCode",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "A_SignCode",
   "type": "esriFieldTypeString",
   "alias": "Sign Code",
   "length": 50,
   "domain": null
  },
  {
   "name": "A_Surface",
   "type": "esriFieldTypeString",
   "alias": "Surface",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Signs_Surface",
    "description": "Sign Surface",
    "codedValues": [
     {
      "name": "Reflective",
      "code": "Reflective"
     },
     {
      "name": "Nonreflective",
      "code": "Nonreflective"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "A_Shape",
   "type": "esriFieldTypeString",
   "alias": "Shape",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Signs_Shape",
    "description": "Sign Shape",
    "codedValues": [
     {
      "name": "Xbar",
      "code": "Xbar"
     },
     {
      "name": "Shield",
      "code": "Shield"
     },
     {
      "name": "Octagon",
      "code": "Octagon"
     },
     {
      "name": "Vertical Rectangle",
      "code": "Vertial Rectangle"
     },
     {
      "name": "Triangle",
      "code": "Triangle"
     },
     {
      "name": "Horizontal Rectangle",
      "code": "Horizontal Rectangle"
     },
     {
      "name": "Diagonal",
      "code": "Diagonal"
     },
     {
      "name": "Square",
      "code": "Square"
     },
     {
      "name": "Pentagon",
      "code": "Pentagon"
     },
     {
      "name": "Circle",
      "code": "Circle"
     },
     {
      "name": "Tombstone",
      "code": "Tombstone"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "A_Color",
   "type": "esriFieldTypeString",
   "alias": "Color",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Signs_Color",
    "description": "Sign Color",
    "codedValues": [
     {
      "name": "Black on White",
      "code": "Black on White"
     },
     {
      "name": "Black on Yellow",
      "code": "Black on Yellow"
     },
     {
      "name": "White on Red",
      "code": "White on Red"
     },
     {
      "name": "White on Green",
      "code": "White on Green"
     },
     {
      "name": "White on Black",
      "code": "White on Black"
     },
     {
      "name": "Green on White",
      "code": "Green on White"
     },
     {
      "name": "Yellow",
      "code": "Yellow"
     },
     {
      "name": "Red/Yellow/White",
      "code": "Red/Yellow/White"
     },
     {
      "name": "Red on White",
      "code": "Red on White"
     },
     {
      "name": "Red",
      "code": "Red"
     },
     {
      "name": "Black on Neon Yellow",
      "code": "Black on Neon Yellow"
     },
     {
      "name": "Red/Black/White",
      "code": "Red/Black/White"
     },
     {
      "name": "Red on Yellow",
      "code": "Red on Yellow"
     },
     {
      "name": "White on Brown",
      "code": "White on Brown"
     },
     {
      "name": "White and Blue",
      "code": "White and Blue"
     },
     {
      "name": "Miscellaneous",
      "code": "Miscellaneous"
     },
     {
      "name": "Blue",
      "code": "Blue"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "A_Dimension1",
   "type": "esriFieldTypeDouble",
   "alias": "Dimension 1",
   "domain": null
  },
  {
   "name": "A_Dimension2",
   "type": "esriFieldTypeDouble",
   "alias": "Dimension 1",
   "domain": null
  },
  {
   "name": "A_Dimension3",
   "type": "esriFieldTypeDouble",
   "alias": "Dimension 3",
   "domain": null
  },
  {
   "name": "A_Material",
   "type": "esriFieldTypeString",
   "alias": "Material",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Signs_Material",
    "description": "Sign Material",
    "codedValues": [
     {
      "name": ".080 Aluminum",
      "code": ".080 Aluminum"
     },
     {
      "name": "Wood",
      "code": "Wood"
     },
     {
      "name": ".063 Aluminum",
      "code": ".063 Aluminum"
     },
     {
      "name": ".100 Aluminum",
      "code": ".100 Aluminum"
     },
     {
      "name": "FL Steel",
      "code": "FL Steel"
     },
     {
      "name": "Fiberglass",
      "code": "Fiberglass"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "A_AnchorFacing",
   "type": "esriFieldTypeString",
   "alias": "Anchor Facing",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Sign_AnchorFacing",
    "description": "Sign Anchor Facing ",
    "codedValues": [
     {
      "name": "Facing",
      "code": "Facing"
     },
     {
      "name": "Opposing",
      "code": "Opposing"
     },
     {
      "name": "Parallel",
      "code": "Parallel"
     },
     {
      "name": "Oblique",
      "code": "Oblique"
     },
     {
      "name": "Parallel Opposing",
      "code": "Parallel Opposing"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "A_OrdinanceNumber",
   "type": "esriFieldTypeString",
   "alias": "Ordinance Number",
   "length": 50,
   "domain": null
  },
  {
   "name": "A_Responsibility",
   "type": "esriFieldTypeString",
   "alias": "Responsibility",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Signs_Responsibility",
    "description": "Signs Responsibility",
    "codedValues": [
     {
      "name": "City",
      "code": "City"
     },
     {
      "name": "Transit",
      "code": "Transit"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "B_Destinations",
   "type": "esriFieldTypeString",
   "alias": "Destinations",
   "length": 300,
   "domain": null
  },
  {
   "name": "B_Condition",
   "type": "esriFieldTypeString",
   "alias": "Condition",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Condition",
    "description": "The condition of the asset",
    "codedValues": [
     {
      "name": "Excellent",
      "code": "Excellent"
     },
     {
      "name": "Very Good",
      "code": "Very Good"
     },
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Very Poor",
      "code": "Very Poor"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "B_SignComments",
   "type": "esriFieldTypeString",
   "alias": "Sign Comments",
   "length": 300,
   "domain": null
  },
  {
   "name": "CreatedBy",
   "type": "esriFieldTypeString",
   "alias": "Created By",
   "length": 50,
   "domain": null
  },
  {
   "name": "CreatDate",
   "type": "esriFieldTypeDate",
   "alias": "Creat Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "EditBy",
   "type": "esriFieldTypeString",
   "alias": "EditBy",
   "length": 50,
   "domain": null
  },
  {
   "name": "EditDate",
   "type": "esriFieldTypeDate",
   "alias": "Edit Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "GUID_Pole",
   "type": "esriFieldTypeGUID",
   "alias": "GUID_Pole",
   "length": 38,
   "domain": null
  },
  {
   "name": "Wayfinding",
   "type": "esriFieldTypeString",
   "alias": "Wayfinding Sign?",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SignOrderFromTop",
   "type": "esriFieldTypeString",
   "alias": "Sign Order(from top)",
   "length": 50,
   "domain": null
  },
  {
   "name": "AnchorType",
   "type": "esriFieldTypeString",
   "alias": "AnchorType",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Sign_AnchorType",
    "description": "Sign Anchor Type",
    "codedValues": [
     {
      "name": "Ground",
      "code": "Ground"
     },
     {
      "name": "Concrete",
      "code": "Concrete"
     },
     {
      "name": "Collar",
      "code": "Collar"
     },
     {
      "name": "Clamp",
      "code": "Clamp"
     },
     {
      "name": "Band",
      "code": "Band"
     },
     {
      "name": "Bracket",
      "code": "Bracket"
     },
     {
      "name": "Breakaway",
      "code": "Breakaway"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SignDescription",
   "type": "esriFieldTypeString",
   "alias": "Sign Description",
   "length": 200,
   "domain": null
  },
  {
   "name": "Original_Install",
   "type": "esriFieldTypeDate",
   "alias": "Original Install Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "DateReplaced",
   "type": "esriFieldTypeDate",
   "alias": "Date Replaced",
   "length": 8,
   "domain": null
  },
  {
   "name": "MUTCD",
   "type": "esriFieldTypeString",
   "alias": "MUTCD Code",
   "length": 50,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "POINT_X",
   "type": "esriFieldTypeDouble",
   "alias": "POINT_X",
   "domain": null
  },
  {
   "name": "POINT_Y",
   "type": "esriFieldTypeDouble",
   "alias": "POINT_Y",
   "domain": null
  },
  {
   "name": "SignCode_Int",
   "type": "esriFieldTypeInteger",
   "alias": "Sign Code Integer",
   "domain": null
  },
  {
   "name": "Man_SignDescript",
   "type": "esriFieldTypeString",
   "alias": "Manual Sign Description",
   "length": 255,
   "domain": null
  },
  {
   "name": "URL",
   "type": "esriFieldTypeString",
   "alias": "URL",
   "length": 500,
   "domain": null
  },
  {
   "name": "SignCode",
   "type": "esriFieldTypeInteger",
   "alias": "Enter Sign Code",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "UUID_354",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_3667_GUID_Po",
   "fields": "GUID_Pole",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "gdb_ct3_354",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "GDB_3667_SignCod",
   "fields": "SignCode_Int",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 2,
   "name": "CityOfSheboygan.OWNER.Sign_Pole_WOs",
   "relatedTableId": 2,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 1,
   "name": "SignPoles",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "GUID_Pole",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 3,
   "name": "CityOfSheboygan.OWNER.SignCodeTable2023",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "SignCode_Int",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,Data",
 "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
 },
 "dateFieldsTimeReference": null,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1595446289000
 },
 "serviceItemId": "f0438499ad8f4b72a421e851145a5a05"
}