{
 "currentVersion": 10.6,
 "id": 3,
 "name": "ELECTRIC.ELECTRIC_ADMIN.Pole_Inspections",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Status",
 "typeIdField": null,
 "subtypeFieldName": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PoleStatus",
    "description": "For pole inspections",
    "codedValues": [
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Needs Attention",
      "code": "Needs Attention"
     },
     {
      "name": "Needs Immediate Attention",
      "code": "Needs Immediate Attention"
     },
     {
      "name": "Incomplete",
      "code": "Incomplete"
     },
     {
      "name": "Not in Field",
      "code": "Not in Field"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Date",
   "type": "esriFieldTypeDate",
   "alias": "Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Pole_Owner",
   "type": "esriFieldTypeString",
   "alias": "Pole Owner",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PoleOwner",
    "description": "Pole Owner",
    "codedValues": [
     {
      "name": "Concord Telephone Company",
      "code": "CTC"
     },
     {
      "name": "Duke",
      "code": "Duke"
     },
     {
      "name": "Windstream",
      "code": "Windstream"
     },
     {
      "name": "NC DOT",
      "code": "NCDOT"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "City of Concord",
      "code": "COC"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Pole_Class",
   "type": "esriFieldTypeString",
   "alias": "Pole Class",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Pole:CLASS Domain",
    "description": "",
    "codedValues": [
     {
      "name": "1",
      "code": "1"
     },
     {
      "name": "2",
      "code": "2"
     },
     {
      "name": "3",
      "code": "3"
     },
     {
      "name": "4",
      "code": "4"
     },
     {
      "name": "5",
      "code": "5"
     },
     {
      "name": "6",
      "code": "6"
     },
     {
      "name": "7",
      "code": "7"
     },
     {
      "name": "UNK",
      "code": "UNK"
     },
     {
      "name": "H1",
      "code": "H1"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Added_Tag",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Added_Tag",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Simple Yes No",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SubCircuit",
   "type": "esriFieldTypeString",
   "alias": "SubCircuit",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SubCircuit",
    "description": "Sub Station and Circuit",
    "codedValues": [
     {
      "name": "A1",
      "code": "A1"
     },
     {
      "name": "A2",
      "code": "A2"
     },
     {
      "name": "A3",
      "code": "A3"
     },
     {
      "name": "A4",
      "code": "A4"
     },
     {
      "name": "B1",
      "code": "B1"
     },
     {
      "name": "B2",
      "code": "B2"
     },
     {
      "name": "B3",
      "code": "B3"
     },
     {
      "name": "B4",
      "code": "B4"
     },
     {
      "name": "C1",
      "code": "C1"
     },
     {
      "name": "C2",
      "code": "C2"
     },
     {
      "name": "C3",
      "code": "C3"
     },
     {
      "name": "C4",
      "code": "C4"
     },
     {
      "name": "D1",
      "code": "D1"
     },
     {
      "name": "D2",
      "code": "D2"
     },
     {
      "name": "D3",
      "code": "D3"
     },
     {
      "name": "D4",
      "code": "D4"
     },
     {
      "name": "E1",
      "code": "E1"
     },
     {
      "name": "E2",
      "code": "E2"
     },
     {
      "name": "E3",
      "code": "E3"
     },
     {
      "name": "E4",
      "code": "E4"
     },
     {
      "name": "F1",
      "code": "F1"
     },
     {
      "name": "F2",
      "code": "F2"
     },
     {
      "name": "F3",
      "code": "F3"
     },
     {
      "name": "F4",
      "code": "F4"
     },
     {
      "name": "G1",
      "code": "G1"
     },
     {
      "name": "G2",
      "code": "G2"
     },
     {
      "name": "G3",
      "code": "G3"
     },
     {
      "name": "G4",
      "code": "G4"
     },
     {
      "name": "H1",
      "code": "H1"
     },
     {
      "name": "H2",
      "code": "H2"
     },
     {
      "name": "H3",
      "code": "H3"
     },
     {
      "name": "H4",
      "code": "H4"
     },
     {
      "name": "I1",
      "code": "I1"
     },
     {
      "name": "I2",
      "code": "I2"
     },
     {
      "name": "I3",
      "code": "I3"
     },
     {
      "name": "I4",
      "code": "I4"
     },
     {
      "name": "J1",
      "code": "J1"
     },
     {
      "name": "J2",
      "code": "J2"
     },
     {
      "name": "J3",
      "code": "J3"
     },
     {
      "name": "J4",
      "code": "J4"
     },
     {
      "name": "K1",
      "code": "K1"
     },
     {
      "name": "K2",
      "code": "K2"
     },
     {
      "name": "K3",
      "code": "K3"
     },
     {
      "name": "K4",
      "code": "K4"
     },
     {
      "name": "K5",
      "code": "K5"
     },
     {
      "name": "K6",
      "code": "K6"
     },
     {
      "name": "K7",
      "code": "K7"
     },
     {
      "name": "K8",
      "code": "K8"
     },
     {
      "name": "L1",
      "code": "L1"
     },
     {
      "name": "L2",
      "code": "L2"
     },
     {
      "name": "L3",
      "code": "L3"
     },
     {
      "name": "L4",
      "code": "L4"
     },
     {
      "name": "M1",
      "code": "M1"
     },
     {
      "name": "M2",
      "code": "M2"
     },
     {
      "name": "M3",
      "code": "M3"
     },
     {
      "name": "M4",
      "code": "M4"
     },
     {
      "name": "M5",
      "code": "M5"
     },
     {
      "name": "M6",
      "code": "M6"
     },
     {
      "name": "M7",
      "code": "M7"
     },
     {
      "name": "M8",
      "code": "M8"
     },
     {
      "name": "O1",
      "code": "O1"
     },
     {
      "name": "O2",
      "code": "O2"
     },
     {
      "name": "O3",
      "code": "O3"
     },
     {
      "name": "O4",
      "code": "O4"
     },
     {
      "name": "O5",
      "code": "O5"
     },
     {
      "name": "O6",
      "code": "O6"
     },
     {
      "name": "O7",
      "code": "O7"
     },
     {
      "name": "P1",
      "code": "P1"
     },
     {
      "name": "P2",
      "code": "P2"
     },
     {
      "name": "P3",
      "code": "P3"
     },
     {
      "name": "P4",
      "code": "P4"
     },
     {
      "name": "P5",
      "code": "P5"
     },
     {
      "name": "P6",
      "code": "P6"
     },
     {
      "name": "P7",
      "code": "P7"
     },
     {
      "name": "T1",
      "code": "T1"
     },
     {
      "name": "T2",
      "code": "T2"
     },
     {
      "name": "T3",
      "code": "T3"
     },
     {
      "name": "T4",
      "code": "T4"
     },
     {
      "name": "T5",
      "code": "T5"
     },
     {
      "name": "T6",
      "code": "T6"
     },
     {
      "name": "T7",
      "code": "T7"
     },
     {
      "name": "T8",
      "code": "T8"
     },
     {
      "name": "Q1",
      "code": "Q1"
     },
     {
      "name": "Q2",
      "code": "Q2"
     },
     {
      "name": "Q3",
      "code": "Q3"
     },
     {
      "name": "Q4",
      "code": "Q4"
     },
     {
      "name": "Q5",
      "code": "Q5"
     },
     {
      "name": "Q6",
      "code": "Q6"
     },
     {
      "name": "Q7",
      "code": "Q7"
     },
     {
      "name": "Q8",
      "code": "Q8"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Pole_Year",
   "type": "esriFieldTypeString",
   "alias": "Pole_Year",
   "length": 50,
   "domain": null
  },
  {
   "name": "Pole_Height",
   "type": "esriFieldTypeInteger",
   "alias": "Pole Height",
   "domain": {
    "type": "codedValue",
    "name": "PoleHeight",
    "description": "Pole Height in Feet",
    "codedValues": [
     {
      "name": "30",
      "code": 30
     },
     {
      "name": "35",
      "code": 35
     },
     {
      "name": "40",
      "code": 40
     },
     {
      "name": "45",
      "code": 45
     },
     {
      "name": "50",
      "code": 50
     },
     {
      "name": "55",
      "code": 55
     },
     {
      "name": "60",
      "code": 60
     },
     {
      "name": "65",
      "code": 65
     },
     {
      "name": "70",
      "code": 70
     },
     {
      "name": "75",
      "code": 75
     },
     {
      "name": "80",
      "code": 80
     },
     {
      "name": "85",
      "code": 85
     },
     {
      "name": "90",
      "code": 90
     },
     {
      "name": "95",
      "code": 95
     },
     {
      "name": "100",
      "code": 100
     },
     {
      "name": "105",
      "code": 105
     },
     {
      "name": "110",
      "code": 110
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Treatment_Type",
   "type": "esriFieldTypeString",
   "alias": "Treatment Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "TreatmentType",
    "description": "Treatment Type",
    "codedValues": [
     {
      "name": "CCA",
      "code": "CCA"
     },
     {
      "name": "PENTA",
      "code": "PENTA"
     },
     {
      "name": "Creosote",
      "code": "Creosote"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Material",
   "type": "esriFieldTypeString",
   "alias": "Material",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PoleMaterial",
    "description": "Pole Material",
    "codedValues": [
     {
      "name": "Wood",
      "code": "W"
     },
     {
      "name": "Aluminum",
      "code": "A"
     },
     {
      "name": "Concrete",
      "code": "C"
     },
     {
      "name": "Steel",
      "code": "S"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "length": 50,
   "domain": null
  },
  {
   "name": "Visual_Only",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Visual_Only",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Simple Yes No",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Treatment_Needed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Treatment_Needed",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Simple Yes No",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Treatment_Applied",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Treatment_Applied",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Simple Yes No",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 250,
   "domain": null
  },
  {
   "name": "Pole_Tag_Number",
   "type": "esriFieldTypeString",
   "alias": "Pole_Tag_Number",
   "length": 50,
   "domain": null
  },
  {
   "name": "Address",
   "type": "esriFieldTypeString",
   "alias": "Address",
   "length": 50,
   "domain": null
  },
  {
   "name": "GuyGuard_Present",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Guy Guard Present",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Simple Yes No",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Issue1",
   "type": "esriFieldTypeString",
   "alias": "Issue1",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PoleIssues",
    "description": "Major Pole Issues",
    "codedValues": [
     {
      "name": "Wood Pecker Holes",
      "code": "Wood Pecker Holes"
     },
     {
      "name": "Broken Ground Wires",
      "code": "Broken Ground Wires"
     },
     {
      "name": "Right of Way Issue",
      "code": "Right of Way Issue"
     },
     {
      "name": "Pole Leaning",
      "code": "Pole Leaning"
     },
     {
      "name": "Missing Ground Wire",
      "code": "Missing Ground Wire"
     },
     {
      "name": "Loose Hardware",
      "code": "Loose Hardware"
     },
     {
      "name": "Ground Line Decay",
      "code": "Ground Line Decay"
     },
     {
      "name": "Split Top",
      "code": "Split Top"
     },
     {
      "name": "Pole Top Decay",
      "code": "Pole Top Decay"
     },
     {
      "name": "Broke Guy Wire",
      "code": "Broke Guy Wire"
     },
     {
      "name": "Conduit Issue",
      "code": "Conduit Issue"
     },
     {
      "name": "Missing Guy Guard",
      "code": "Missing Guy Guard"
     },
     {
      "name": "Cross Arm or Brace",
      "code": "Cross Arm or Brace"
     },
     {
      "name": "Broke or Loose Guy Wire",
      "code": "Broke or Loose Guy Wire"
     },
     {
      "name": "Anchor Rod",
      "code": "Anchor Rod"
     },
     {
      "name": "Pull Pole",
      "code": "Pull Pole"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Issue2",
   "type": "esriFieldTypeString",
   "alias": "Issue2",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PoleIssues",
    "description": "Major Pole Issues",
    "codedValues": [
     {
      "name": "Wood Pecker Holes",
      "code": "Wood Pecker Holes"
     },
     {
      "name": "Broken Ground Wires",
      "code": "Broken Ground Wires"
     },
     {
      "name": "Right of Way Issue",
      "code": "Right of Way Issue"
     },
     {
      "name": "Pole Leaning",
      "code": "Pole Leaning"
     },
     {
      "name": "Missing Ground Wire",
      "code": "Missing Ground Wire"
     },
     {
      "name": "Loose Hardware",
      "code": "Loose Hardware"
     },
     {
      "name": "Ground Line Decay",
      "code": "Ground Line Decay"
     },
     {
      "name": "Split Top",
      "code": "Split Top"
     },
     {
      "name": "Pole Top Decay",
      "code": "Pole Top Decay"
     },
     {
      "name": "Broke Guy Wire",
      "code": "Broke Guy Wire"
     },
     {
      "name": "Conduit Issue",
      "code": "Conduit Issue"
     },
     {
      "name": "Missing Guy Guard",
      "code": "Missing Guy Guard"
     },
     {
      "name": "Cross Arm or Brace",
      "code": "Cross Arm or Brace"
     },
     {
      "name": "Broke or Loose Guy Wire",
      "code": "Broke or Loose Guy Wire"
     },
     {
      "name": "Anchor Rod",
      "code": "Anchor Rod"
     },
     {
      "name": "Pull Pole",
      "code": "Pull Pole"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Issue3",
   "type": "esriFieldTypeString",
   "alias": "Issue3",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "PoleIssues",
    "description": "Major Pole Issues",
    "codedValues": [
     {
      "name": "Wood Pecker Holes",
      "code": "Wood Pecker Holes"
     },
     {
      "name": "Broken Ground Wires",
      "code": "Broken Ground Wires"
     },
     {
      "name": "Right of Way Issue",
      "code": "Right of Way Issue"
     },
     {
      "name": "Pole Leaning",
      "code": "Pole Leaning"
     },
     {
      "name": "Missing Ground Wire",
      "code": "Missing Ground Wire"
     },
     {
      "name": "Loose Hardware",
      "code": "Loose Hardware"
     },
     {
      "name": "Ground Line Decay",
      "code": "Ground Line Decay"
     },
     {
      "name": "Split Top",
      "code": "Split Top"
     },
     {
      "name": "Pole Top Decay",
      "code": "Pole Top Decay"
     },
     {
      "name": "Broke Guy Wire",
      "code": "Broke Guy Wire"
     },
     {
      "name": "Conduit Issue",
      "code": "Conduit Issue"
     },
     {
      "name": "Missing Guy Guard",
      "code": "Missing Guy Guard"
     },
     {
      "name": "Cross Arm or Brace",
      "code": "Cross Arm or Brace"
     },
     {
      "name": "Broke or Loose Guy Wire",
      "code": "Broke or Loose Guy Wire"
     },
     {
      "name": "Anchor Rod",
      "code": "Anchor Rod"
     },
     {
      "name": "Pull Pole",
      "code": "Pull Pole"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Inspector",
   "type": "esriFieldTypeString",
   "alias": "Inspector",
   "length": 100,
   "domain": {
    "type": "codedValue",
    "name": "Inspector",
    "description": "Inspoector Name",
    "codedValues": [
     {
      "name": "Petie Wheeler",
      "code": "Petie Wheeler"
     },
     {
      "name": "Allen Ferguson",
      "code": "Allen Ferguson"
     },
     {
      "name": "Ben Lam",
      "code": "Ben Lam"
     },
     {
      "name": "David Guevara",
      "code": "David Guevara"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Reject",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Reject",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "Simple Yes No",
    "codedValues": [
     {
      "name": "No",
      "code": 0
     },
     {
      "name": "Yes",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R64_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_2161_Pole_Ta",
   "fields": "Pole_Tag_Number",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "Pole",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "Pole_Tag_Number",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 0,
   "name": "Pole",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "Pole_Tag_Number",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}