{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 65,
 "name": "Sign Maintenance",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SignID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SignID",
   "type": "esriFieldTypeString",
   "alias": "SignID",
   "length": 50,
   "domain": null
  },
  {
   "name": "ReflectivityTest",
   "type": "esriFieldTypeString",
   "alias": "Retroreflective_Test",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SP_SignReflectivity",
    "description": "Support Pole Sign Reflectivity Test",
    "codedValues": [
     {
      "name": "Reflectivity OK",
      "code": "Pass"
     },
     {
      "name": "Replace Sign - Unreflective",
      "code": "Fail"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "MaintenanceActivity",
   "type": "esriFieldTypeString",
   "alias": "Maintenance_Activity",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SP_SignMaintenanceActivity",
    "description": "Support Pole Sign Maintenance Activity",
    "codedValues": [
     {
      "name": "New Install",
      "code": "1"
     },
     {
      "name": "Replace Stolen",
      "code": "2"
     },
     {
      "name": "Replace Faded",
      "code": "4"
     },
     {
      "name": "Replace Design",
      "code": "5"
     },
     {
      "name": "Replace Collision",
      "code": "6"
     },
     {
      "name": "Replace Down",
      "code": "7"
     },
     {
      "name": "Remove Temporarily",
      "code": "10"
     },
     {
      "name": "Clean Sign",
      "code": "8"
     },
     {
      "name": "Clear Vegetation",
      "code": "11"
     },
     {
      "name": "Graffiti",
      "code": "12"
     },
     {
      "name": "Retire",
      "code": "9"
     },
     {
      "name": "Replace Vandalism",
      "code": "3"
     },
     {
      "name": "Relocate",
      "code": "13"
     },
     {
      "name": "Visibility",
      "code": "14"
     },
     {
      "name": "Damaged",
      "code": "15"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "InspectionDate",
   "type": "esriFieldTypeDate",
   "alias": "Inspection_Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Technician",
   "type": "esriFieldTypeString",
   "alias": "Technician",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SP_Technicians",
    "description": "Support Pole Streets Team Members",
    "codedValues": [
     {
      "name": "Raymond Segovia",
      "code": "1"
     },
     {
      "name": "Clint Alexander",
      "code": "2"
     },
     {
      "name": "Bernard Jackson",
      "code": "3"
     },
     {
      "name": "Kerry Doster",
      "code": "5"
     },
     {
      "name": "Rusty Brashear",
      "code": "6"
     },
     {
      "name": "Jacob Prejean",
      "code": "4"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ParentSignID",
   "type": "esriFieldTypeGUID",
   "alias": "Parent Sign ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Callout",
   "type": "esriFieldTypeString",
   "alias": "Is this a Callout?",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Yes or No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "ZoneNum",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Zone Number",
   "domain": null
  },
  {
   "name": "TMUTCD_SignCode",
   "type": "esriFieldTypeString",
   "alias": "Sign Code",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "SP_TMUTCD-Regulatory",
    "description": "Support Pole TMUTCD Regulatory Signs",
    "codedValues": [
     {
      "name": "R1-1 STOP",
      "code": "R1-1"
     },
     {
      "name": "R1-2 YIELD",
      "code": "R1-2"
     },
     {
      "name": "R1-2aP TO ONCOMING TRAFFIC (PLAQUE)",
      "code": "R1-2aP"
     },
     {
      "name": "R1-2bP TO TRAFFIC IN CIRCLE",
      "code": "R1-2bP"
     },
     {
      "name": "R1-3P ALL WAY (PLAQUE)",
      "code": "R1-3P"
     },
     {
      "name": "R1-5 YIELD HERE TO PEDESTRIANS (SYMBOL)",
      "code": "R1-5"
     },
     {
      "name": "R1-5b STOP HERE FOR PEDESTRIANS (SYMBOL)",
      "code": "R1-5b"
     },
     {
      "name": "R1-6 IN-STREET PEDESTRIAN CROSSING (YIELD)",
      "code": "R1-6"
     },
     {
      "name": "R1-6a IN-STREET PEDESTRIAN CROSSING (STOP)",
      "code": "R1-6a"
     },
     {
      "name": "R1-6b IN-STREET SCHOOL CROSSING (YIELD)",
      "code": "R1-6b"
     },
     {
      "name": "R1-6c IN-STREET SCHOOL CROSSING (STOP)",
      "code": "R1-6c"
     },
     {
      "name": "R1-9 YIELD TO PEDESTRIANS IN CROSSWALK",
      "code": "R1-9"
     },
     {
      "name": "R1-9a STOP FOR PEDESTRIANS IN CROSSWALK",
      "code": "R1-9a"
     },
     {
      "name": "R1-10P EXCEPT RIGHT TURN (PLAQUE)",
      "code": "R1-10P"
     },
     {
      "name": "R2-1 SPEED LIMIT",
      "code": "R2-1"
     },
     {
      "name": "R3-1 NO RIGHT TURN (ICON)",
      "code": "R3-1"
     },
     {
      "name": "R3-2 NO LEFT TURN (ICON)",
      "code": "R3-2"
     },
     {
      "name": "R3-4 NO U TURN",
      "code": "R3-4"
     },
     {
      "name": "R3-5 TURN ONLY",
      "code": "R3-5"
     },
     {
      "name": "R3-5a STRAIGHT ONLY",
      "code": "R3-5a"
     },
     {
      "name": "R3-5bP LEFT LANE (PLAQUE) (FOR USE WITH R3-5, R3-6 SERIES SIGNS)",
      "code": "R3-5bP"
     },
     {
      "name": "R3-5eP CENTER LANE (PLAQUE) (FOR USE WITH R3-5, R3-6 SERIES SIGNS)",
      "code": "R3-5eP"
     },
     {
      "name": "R3-5fP RIGHT LANE (PLAQUE) (FOR USE WITH R3-5, R3-6 SERIES SIGNS)",
      "code": "R3-5fP"
     },
     {
      "name": "R3-6 OPTIONAL MOVEMENT (STRAIGHT AND LEFT OR RIGHT)",
      "code": "R3-6"
     },
     {
      "name": "R3-7 LEFT LANE MUST TURN LEFT / RIGHT LANE MUST TURN RIGHT",
      "code": "R3-7"
     },
     {
      "name": "R3-8 INTERSECTION LANE CONTROL (2 LANE)",
      "code": "R3-8"
     },
     {
      "name": "R3-8a INTERSECTION LANE CONTROL (3 LANE)",
      "code": "R3-8a"
     },
     {
      "name": "R3-8b INTERSECTION LANE CONTROL (3 LANE) (LEFT / STRAIGHT / RIGHT)",
      "code": "R3-8b"
     },
     {
      "name": "R3-8r INTERSECTION LANE CONTROL (2 LANE, ROUNDABOUT)",
      "code": "R3-8r"
     },
     {
      "name": "R3-8ULM INTERSECTION LANE CONTROL (3 LANE) (U-TURN / LEFT / LEFT-STRAIGHT)",
      "code": "R3-8ULM"
     },
     {
      "name": "R3-8uT TURNAROUND ONLY",
      "code": "R3-8uT"
     },
     {
      "name": "R3-9b TWO WAY LEFT TURN ONLY (POST-MOUNT) (CENTER LANE)",
      "code": "R3-9b"
     },
     {
      "name": "R3-9cP BEGIN (PLAQUE) (FOR USE WITH R3-9B)",
      "code": "R3-9cP"
     },
     {
      "name": "R3-9dP END (PLAQUE) (FOR USE WITH R3-9B)",
      "code": "R3-9dP"
     },
     {
      "name": "R3-11 BUSES ONLY (DAYS & TIMES)",
      "code": "R3-11"
     },
     {
      "name": "R3-17 BIKE LANE",
      "code": "R3-17"
     },
     {
      "name": "R3-17aP AHEAD (PLAQUE) (BIKE LANE AHEAD)",
      "code": "R3-17aP"
     },
     {
      "name": "R3-17bP ENDS (PLAQUE) (BIKE LANE ENDS)",
      "code": "R3-17bP"
     },
     {
      "name": "R3-18 NO LEFT OR U TURN",
      "code": "R3-18"
     },
     {
      "name": "R4-1 DO NOT PASS",
      "code": "R4-1"
     },
     {
      "name": "R4-2 PASS WITH CARE",
      "code": "R4-2"
     },
     {
      "name": "R4-3 SLOWER TRAFFIC KEEP RIGHT",
      "code": "R4-3"
     },
     {
      "name": "R4-7 KEEP RIGHT (ARROW AND ICON)",
      "code": "R4-7"
     },
     {
      "name": "R4-7a KEEP RIGHT (HORIZONTAL ARROW)",
      "code": "R4-7a"
     },
     {
      "name": "R4-7b KEEP RIGHT (DIAGONAL ARROW)",
      "code": "R4-7b"
     },
     {
      "name": "R4-7c KEEP RIGHT (NARROW)",
      "code": "R4-7c"
     },
     {
      "name": "R4-8 KEEP LEFT (ARROW AND ICON)",
      "code": "R4-8"
     },
     {
      "name": "R4-8a KEEP LEFT (HORIZONTAL ARROW)",
      "code": "R4-8a"
     },
     {
      "name": "R4-8b KEEP LEFT (DIAGONAL ARROW)",
      "code": "R4-8b"
     },
     {
      "name": "R4-8c KEEP LEFT (NARROW)",
      "code": "R4-8c"
     },
     {
      "name": "R4-11 BICYCLES MAY USE FULL LANE",
      "code": "R4-11"
     },
     {
      "name": "R4-16 KEEP RIGHT EXCEPT TO PASS",
      "code": "R4-16"
     },
     {
      "name": "R4-17 DO NOT DRIVE ON SHOULDER",
      "code": "R4-17"
     },
     {
      "name": "R4-18 DO NOT PASS ON SHOULDER",
      "code": "R4-18"
     },
     {
      "name": "R5-1 DO NOT ENTER",
      "code": "R5-1"
     },
     {
      "name": "R5-1a WRONG WAY",
      "code": "R5-1a"
     },
     {
      "name": "R5-2 NO TRUCKS (ICON)",
      "code": "R5-2"
     },
     {
      "name": "R5-2a NO TRUCKS (WORDS)",
      "code": "R5-2a"
     },
     {
      "name": "R5-11 FOR OFFICIAL OR EMERGENCY VEHICLE USE ONLY",
      "code": "R5-11"
     },
     {
      "name": "R6-1 ONE WAY (TEXT IN ARROW)",
      "code": "R6-1"
     },
     {
      "name": "R6-2 ONE WAY (TEXT ABOVE ARROW)",
      "code": "R6-2"
     },
     {
      "name": "R6-3 DIVIDED HIGHWAY CROSSING",
      "code": "R6-3"
     },
     {
      "name": "R6-3a DIVIDED HIGHWAY CROSSING (T INTERSECTION)",
      "code": "R6-3a"
     },
     {
      "name": "R6-4 ROUNDABOUT DIRECTIONAL (2 CHEVRONS)",
      "code": "R6-4"
     },
     {
      "name": "R6-4a ROUNDABOUT DIRECTIONAL (3 CHEVRONS)",
      "code": "R6-4a"
     },
     {
      "name": "R6-4b ROUNDABOUT DIRECTIONAL (4 CHEVRONS)",
      "code": "R6-4b"
     },
     {
      "name": "R6-5P ROUNDABOUT CIRCULATION (PLAQUE)",
      "code": "R6-5P"
     },
     {
      "name": "R6-6 BEGIN ONE WAY",
      "code": "R6-6"
     },
     {
      "name": "R6-7 END ONE WAY",
      "code": "R6-7"
     },
     {
      "name": "R7-1 NO PARKING ANY TIME (WORDS)",
      "code": "R7-1"
     },
     {
      "name": "R7-2 NO PARKING (SYMBOL) (TIMES)",
      "code": "R7-2"
     },
     {
      "name": "R7-2a NO PARKING (TIMES)",
      "code": "R7-2a"
     },
     {
      "name": "R7-3 NO PARKING EXCEPT (DAYS)",
      "code": "R7-3"
     },
     {
      "name": "R7-5 PARKING (TIMES) (HOUR PARKING)",
      "code": "R7-5"
     },
     {
      "name": "R7-6 NO PARKING LOADING ZONE",
      "code": "R7-6"
     },
     {
      "name": "R7-8 RESERVED PARKING (ACCESSIBLE)",
      "code": "R7-8"
     },
     {
      "name": "R7-8P VAN ACCESSIBLE (PLAQUE)",
      "code": "R7-8P"
     },
     {
      "name": "R7-13 NO PARKING THIS SIDE OF STREET",
      "code": "R7-13"
     },
     {
      "name": "R7-108 (TIME LIMIT) PARKING (TIMES)",
      "code": "R7-108"
     },
     {
      "name": "R7-200a NO PARKING/RESTRICTED PARKING",
      "code": "R7-200a"
     },
     {
      "name": "R9-2 CROSS ONLY AT CROSSWALKS",
      "code": "R9-2"
     },
     {
      "name": "R9-3 NO PEDESTRIANS (ICON ONLY)",
      "code": "R9-3"
     },
     {
      "name": "R9-3bP USE CROSSWALK (PLAQUE)",
      "code": "R9-3bP"
     },
     {
      "name": "R10-1 PEDESTRIAN SIGNAL SIGN",
      "code": "R10-1"
     },
     {
      "name": "R10-3 PUSH BUTTON",
      "code": "R10-3"
     },
     {
      "name": "R10-5 LEFT ON GREEN ARROW ONLY",
      "code": "R10-5"
     },
     {
      "name": "R10-6 STOP HERE ON RED (STRAIGHT ARROW)",
      "code": "R10-6"
     },
     {
      "name": "R10-6a STOP HERE ON RED (CURVED ARROW)",
      "code": "R10-6a"
     },
     {
      "name": "R10-7 DO NOT BLOCK INTERSECTION",
      "code": "R10-7"
     },
     {
      "name": "R10-10(L&R) TURN SIGNAL",
      "code": "R10-10"
     },
     {
      "name": "R10-11 NO TURN ON RED (SYMBOL)",
      "code": "R10-11"
     },
     {
      "name": "R10-12 LEFT TURN YIELD ON GREEN",
      "code": "R10-12"
     },
     {
      "name": "R10-13 EMERGENCY SIGNAL",
      "code": "R10-13"
     },
     {
      "name": "R10-15 TURNING VEHICLES YIELD TO PEDESTRIANS",
      "code": "R10-15"
     },
     {
      "name": "R10-16 U-TURN YIELD TO RIGHT TURN",
      "code": "R10-16"
     },
     {
      "name": "R10-25 PUSH BUTTON TO TURN ON WARNING LIGHTS",
      "code": "R10-25"
     },
     {
      "name": "R10-30 RIGHT TURN ON RED MUST YIELD TO U-TURN",
      "code": "R10-30"
     },
     {
      "name": "R10-31P AT SIGNAL (PLAQUE) (FOR USE WITH R10-12)",
      "code": "R10-31P"
     },
     {
      "name": "R11-1 KEEP OFF MEDIAN",
      "code": "R11-1"
     },
     {
      "name": "R11-2 ROAD CLOSED",
      "code": "R11-2"
     },
     {
      "name": "R11-3a ROAD CLOSED AHEAD LOCAL TRAFFIC ONLY",
      "code": "R11-3a"
     },
     {
      "name": "R11-3b BRIDGE OUT AHEAD LOCAL TRAFFIC ONLY",
      "code": "R11-3b"
     },
     {
      "name": "R11-4 ROAD CLOSED TO THRU TRAFFIC",
      "code": "R11-4"
     },
     {
      "name": "R12-1 WEIGHT LIMIT",
      "code": "R12-1"
     },
     {
      "name": "R14-1 TRUCK ROUTE",
      "code": "R14-1"
     },
     {
      "name": "R15-1 RAILROAD CROSSING",
      "code": "R15-1"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R1181_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_1181",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1689ParentSignI",
   "fields": "ParentSignID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1689SignID",
   "fields": "SignID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_1181",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 14,
   "name": "SPSignAttributes",
   "relatedTableId": 64,
   "role": "esriRelRoleDestination",
   "keyField": "ParentSignID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}