{
 "layers": [
  {
   "currentVersion": 10.61,
   "cimVersion": "2.2.0",
   "id": 0,
   "name": "StreetLights",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102710,
    "latestWkid": 3437,
    "xyTolerance": 0.5,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -267423587,
    "falseY": -268169155,
    "xyUnits": 2048,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "drawingInfo": {
    "renderer": {
     "type": "uniqueValue",
     "field1": "PAID_BY",
     "field2": "LightType",
     "defaultSymbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       130,
       130,
       130,
       255
      ],
      "size": 4,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 0.7
      }
     },
     "defaultLabel": "<all other values>",
     "uniqueValueInfos": [
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         211,
         255,
         190,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "City,<Null>",
       "label": "City,UNK"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         255,
         255,
         0,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "City,HPS",
       "label": "City,HPS"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         56,
         168,
         0,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "City,LED",
       "label": "City,LED"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         255,
         255,
         0,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "City,SVST",
       "label": "City,SVST"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         247,
         212,
         252,
         255
        ],
        "size": 9,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.7
        }
       },
       "value": "City-Park,<Null>",
       "label": "City-Park,UNK"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         223,
         115,
         255,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "Private,<Null>",
       "label": "Private,UNK"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         223,
         115,
         255,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "Private,SVST",
       "label": "Private,SVST"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         0,
         112,
         255,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "State,<Null>",
       "label": "State,UNK"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         0,
         112,
         255,
         255
        ],
        "size": 10,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "State,LED",
       "label": "State,LED"
      }
     ],
     "fieldDelimiter": ","
    },
    "transparency": 0,
    "labelingInfo": [
     {
      "labelExpressionInfo": {"expression": "if ($feature.WATTAGE == 1) {return 'unk';}\nelse {return $feature.WATTAGE;}"},
      "labelPlacement": "esriServerPointLabelPlacementAboveRight",
      "deconflictionStrategy": "dynamic",
      "allowOverlapOfFeatureInterior": "allow",
      "stackLabel": true,
      "stackAlignment": "dynamic",
      "removeDuplicates": "none",
      "useCodedValues": true,
      "maxScale": 0,
      "minScale": 4800,
      "name": "Class 1",
      "priority": -1,
      "symbol": {
       "type": "esriTS",
       "color": [
        0,
        0,
        0,
        255
       ],
       "backgroundColor": null,
       "borderLineColor": null,
       "borderLineSize": null,
       "verticalAlignment": "bottom",
       "horizontalAlignment": "left",
       "rightToLeft": false,
       "angle": 0,
       "xoffset": 0,
       "yoffset": 0,
       "kerning": true,
       "haloColor": null,
       "haloSize": null,
       "font": {
        "family": "Tahoma",
        "size": 10,
        "style": "normal",
        "weight": "normal",
        "decoration": "none"
       }
      }
     }
    ]
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 993016.84765625,
    "ymin": 240073.7646484375,
    "xmax": 1038576.3823242188,
    "ymax": 288858.513671875,
    "spatialReference": {
     "wkid": 102710,
     "latestWkid": 3437,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -267423587,
     "falseY": -268169155,
     "xyUnits": 2048,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "PAID_BY",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "PAID_BY",
     "type": "esriFieldTypeString",
     "alias": "PAID_BY",
     "length": 10,
     "domain": null
    },
    {
     "name": "WATTAGE",
     "type": "esriFieldTypeSmallInteger",
     "alias": "WATTAGE",
     "domain": null
    },
    {
     "name": "LightType",
     "type": "esriFieldTypeString",
     "alias": "LightType",
     "length": 12,
     "domain": null
    },
    {
     "name": "newPoleID",
     "type": "esriFieldTypeString",
     "alias": "newPoleID",
     "length": 25,
     "domain": null
    },
    {
     "name": "PoleInt",
     "type": "esriFieldTypeSmallInteger",
     "alias": "PoleInt",
     "domain": null
    },
    {
     "name": "PoleChar",
     "type": "esriFieldTypeString",
     "alias": "PoleChar",
     "length": 2,
     "domain": null
    },
    {
     "name": "Wattage2012",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Wattage2012",
     "domain": null
    },
    {
     "name": "PoleType",
     "type": "esriFieldTypeString",
     "alias": "PoleType",
     "length": 20,
     "domain": null
    },
    {
     "name": "PoleMaterial",
     "type": "esriFieldTypeString",
     "alias": "PoleMaterial",
     "length": 20,
     "domain": null
    },
    {
     "name": "LastEditor",
     "type": "esriFieldTypeString",
     "alias": "LastEditor",
     "length": 12,
     "domain": null
    },
    {
     "name": "LastUpdate",
     "type": "esriFieldTypeDate",
     "alias": "LastUpdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "Notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 250,
     "domain": null
    },
    {
     "name": "Keep",
     "type": "esriFieldTypeString",
     "alias": "Keep",
     "length": 5,
     "domain": null
    },
    {
     "name": "LightStyle",
     "type": "esriFieldTypeString",
     "alias": "LightStyle",
     "length": 20,
     "domain": null
    },
    {
     "name": "RTEID",
     "type": "esriFieldTypeInteger",
     "alias": "RTEID",
     "domain": null
    },
    {
     "name": "LEDDesign",
     "type": "esriFieldTypeString",
     "alias": "LEDDesign",
     "length": 60,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "created_user",
     "type": "esriFieldTypeString",
     "alias": "created_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "created_date",
     "type": "esriFieldTypeDate",
     "alias": "created_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "last_edited_user",
     "type": "esriFieldTypeString",
     "alias": "last_edited_user",
     "length": 255,
     "domain": null
    },
    {
     "name": "last_edited_date",
     "type": "esriFieldTypeDate",
     "alias": "last_edited_date",
     "length": 8,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R2941_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_2941",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_12460_RTEID",
     "fields": "RTEID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "S1302_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "StreetLightMaintenance",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "RTEID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": true,
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, AMF, geoJSON",
   "isDataVersioned": false,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "supportsDatumTransformation": true,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true
  },
  {
   "currentVersion": 10.61,
   "cimVersion": "2.2.0",
   "id": 1,
   "name": "Repair Completed",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102710,
    "latestWkid": 3437,
    "xyTolerance": 0.5,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -267423587,
    "falseY": -268169155,
    "xyUnits": 2048,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       255,
       170,
       0,
       255
      ],
      "size": 16,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        0
       ],
       "width": 0.6
      }
     }
    },
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 993016.84765625,
    "ymin": 240073.7646484375,
    "xmax": 1038576.3823242188,
    "ymax": 288858.513671875,
    "spatialReference": {
     "wkid": 102710,
     "latestWkid": 3437,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -267423587,
     "falseY": -268169155,
     "xyUnits": 2048,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "sde.GIS.Trans_StreetLights.PAID_BY",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "sde.GIS.Trans_StreetLights.OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLights.Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.OBJECTID",
     "type": "esriFieldTypeInteger",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.LightGUID",
     "type": "esriFieldTypeGUID",
     "alias": "GID",
     "length": 38,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.LightID",
     "type": "esriFieldTypeSmallInteger",
     "alias": "LightID",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.Street",
     "type": "esriFieldTypeString",
     "alias": "Street",
     "length": 50,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.Location",
     "type": "esriFieldTypeString",
     "alias": "Address",
     "length": 50,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.PoleNumber",
     "type": "esriFieldTypeString",
     "alias": "PoleNumber",
     "length": 20,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.WattBefore",
     "type": "esriFieldTypeSmallInteger",
     "alias": "WattBefore",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.WattAfter",
     "type": "esriFieldTypeSmallInteger",
     "alias": "WattAfter",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.TypeBefore",
     "type": "esriFieldTypeString",
     "alias": "TypeBefore",
     "length": 12,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.TypeAfter",
     "type": "esriFieldTypeString",
     "alias": "TypeAfter",
     "length": 12,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.ReportBy",
     "type": "esriFieldTypeString",
     "alias": "ReportSource",
     "length": 20,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.ReportDate",
     "type": "esriFieldTypeDate",
     "alias": "ReportDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.WorkType",
     "type": "esriFieldTypeString",
     "alias": "WorkType",
     "length": 20,
     "domain": {
      "type": "codedValue",
      "name": "StreetLightWork",
      "description": "",
      "codedValues": [
       {
        "name": "Replace/Repair",
        "code": "Replace/Repair"
       },
       {
        "name": "Remove",
        "code": "Remove"
       },
       {
        "name": "Move Out",
        "code": "Move Out"
       },
       {
        "name": "Move In",
        "code": "Move In"
       },
       {
        "name": "Install New",
        "code": "Install New"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.WorkDate",
     "type": "esriFieldTypeDate",
     "alias": "WorkDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.PhotoCellReplaced",
     "type": "esriFieldTypeString",
     "alias": "PhotoCellReplaced",
     "length": 10,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.LightReplaced",
     "type": "esriFieldTypeString",
     "alias": "LightReplaced",
     "length": 10,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.WiringRepaired",
     "type": "esriFieldTypeString",
     "alias": "WiringRepaired",
     "length": 10,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.NewLightTaken",
     "type": "esriFieldTypeSmallInteger",
     "alias": "NewLightTaken",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.NewLightReturn",
     "type": "esriFieldTypeSmallInteger",
     "alias": "NewLightReturn",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.FaultyLightReturn",
     "type": "esriFieldTypeSmallInteger",
     "alias": "FaultyLightReturn",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.LightReturnDate",
     "type": "esriFieldTypeDate",
     "alias": "LightReturnDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.WarrantyRequest",
     "type": "esriFieldTypeDate",
     "alias": "WarrantyRequest",
     "length": 8,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.WarrantyReceived",
     "type": "esriFieldTypeDate",
     "alias": "WarrantyReceived",
     "length": 8,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.ShieldInstalled",
     "type": "esriFieldTypeString",
     "alias": "ShieldInstalled",
     "length": 50,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.UnitilCharge",
     "type": "esriFieldTypeDouble",
     "alias": "UtitilPaid",
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.PaymentDate",
     "type": "esriFieldTypeDate",
     "alias": "PaymentDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.Notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 100,
     "domain": null
    },
    {
     "name": "sde.GIS.Trans_StreetLightMaintenance.RTEID",
     "type": "esriFieldTypeInteger",
     "alias": "RTEID",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "sde.GIS.Trans_StreetLights.Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R2941_pk",
     "fields": "sde.GIS.Trans_StreetLights.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S1302_idx",
     "fields": "sde.GIS.Trans_StreetLights.Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "R2873_SDE_ROWID_UK",
     "fields": "sde.GIS.Trans_StreetLightMaintenance.OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_12339_LightG",
     "fields": "sde.GIS.Trans_StreetLightMaintenance.LightGUID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "GDB_12339_RTEID",
     "fields": "sde.GIS.Trans_StreetLightMaintenance.RTEID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "StreetLightMaintenance",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "RTEID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, AMF, geoJSON",
   "isDataVersioned": false,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "supportsDatumTransformation": true,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true
  }
 ],
 "tables": [
  {
   "currentVersion": 10.61,
   "cimVersion": "2.2.0",
   "id": 2,
   "name": "Street light maintenance history",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "LightID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "LightGUID",
     "type": "esriFieldTypeGUID",
     "alias": "GID",
     "length": 38,
     "domain": null
    },
    {
     "name": "LightID",
     "type": "esriFieldTypeSmallInteger",
     "alias": "LightID",
     "domain": null
    },
    {
     "name": "Street",
     "type": "esriFieldTypeString",
     "alias": "Street",
     "length": 50,
     "domain": null
    },
    {
     "name": "Location",
     "type": "esriFieldTypeString",
     "alias": "Address",
     "length": 50,
     "domain": null
    },
    {
     "name": "PoleNumber",
     "type": "esriFieldTypeString",
     "alias": "PoleNumber",
     "length": 20,
     "domain": null
    },
    {
     "name": "WattBefore",
     "type": "esriFieldTypeSmallInteger",
     "alias": "WattBefore",
     "domain": null
    },
    {
     "name": "WattAfter",
     "type": "esriFieldTypeSmallInteger",
     "alias": "WattAfter",
     "domain": null
    },
    {
     "name": "TypeBefore",
     "type": "esriFieldTypeString",
     "alias": "TypeBefore",
     "length": 12,
     "domain": null
    },
    {
     "name": "TypeAfter",
     "type": "esriFieldTypeString",
     "alias": "TypeAfter",
     "length": 12,
     "domain": null
    },
    {
     "name": "ReportBy",
     "type": "esriFieldTypeString",
     "alias": "ReportSource",
     "length": 20,
     "domain": null
    },
    {
     "name": "ReportDate",
     "type": "esriFieldTypeDate",
     "alias": "ReportDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "WorkType",
     "type": "esriFieldTypeString",
     "alias": "WorkType",
     "length": 20,
     "domain": {
      "type": "codedValue",
      "name": "StreetLightWork",
      "description": "",
      "codedValues": [
       {
        "name": "Replace/Repair",
        "code": "Replace/Repair"
       },
       {
        "name": "Remove",
        "code": "Remove"
       },
       {
        "name": "Move Out",
        "code": "Move Out"
       },
       {
        "name": "Move In",
        "code": "Move In"
       },
       {
        "name": "Install New",
        "code": "Install New"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "WorkDate",
     "type": "esriFieldTypeDate",
     "alias": "WorkDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PhotoCellReplaced",
     "type": "esriFieldTypeString",
     "alias": "PhotoCellReplaced",
     "length": 10,
     "domain": null
    },
    {
     "name": "LightReplaced",
     "type": "esriFieldTypeString",
     "alias": "LightReplaced",
     "length": 10,
     "domain": null
    },
    {
     "name": "WiringRepaired",
     "type": "esriFieldTypeString",
     "alias": "WiringRepaired",
     "length": 10,
     "domain": null
    },
    {
     "name": "NewLightTaken",
     "type": "esriFieldTypeSmallInteger",
     "alias": "NewLightTaken",
     "domain": null
    },
    {
     "name": "NewLightReturn",
     "type": "esriFieldTypeSmallInteger",
     "alias": "NewLightReturn",
     "domain": null
    },
    {
     "name": "FaultyLightReturn",
     "type": "esriFieldTypeSmallInteger",
     "alias": "FaultyLightReturn",
     "domain": null
    },
    {
     "name": "LightReturnDate",
     "type": "esriFieldTypeDate",
     "alias": "LightReturnDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "WarrantyRequest",
     "type": "esriFieldTypeDate",
     "alias": "WarrantyRequest",
     "length": 8,
     "domain": null
    },
    {
     "name": "WarrantyReceived",
     "type": "esriFieldTypeDate",
     "alias": "WarrantyReceived",
     "length": 8,
     "domain": null
    },
    {
     "name": "ShieldInstalled",
     "type": "esriFieldTypeString",
     "alias": "ShieldInstalled",
     "length": 50,
     "domain": null
    },
    {
     "name": "UnitilCharge",
     "type": "esriFieldTypeDouble",
     "alias": "UtitilPaid",
     "domain": null
    },
    {
     "name": "PaymentDate",
     "type": "esriFieldTypeDate",
     "alias": "PaymentDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "Notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 100,
     "domain": null
    },
    {
     "name": "RTEID",
     "type": "esriFieldTypeInteger",
     "alias": "RTEID",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R2873_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_12339_LightG",
     "fields": "LightGUID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "GDB_12339_RTEID",
     "fields": "RTEID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "StreetLights",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "RTEID",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false
    }
   ],
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, AMF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.61,
   "cimVersion": "2.2.0",
   "id": 3,
   "name": "Street lights, sensors, shields",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "InvDate",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "InvDate",
     "type": "esriFieldTypeDate",
     "alias": "ActionDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "InvType",
     "type": "esriFieldTypeString",
     "alias": "WorkType",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "LightInvType",
      "description": "Streetlight inventory type",
      "codedValues": [
       {
        "name": "Return Damaged",
        "code": "Return_D"
       },
       {
        "name": "Return Good",
        "code": "Return_G"
       },
       {
        "name": "Missing",
        "code": "Missing"
       },
       {
        "name": "Out to Install",
        "code": "To_Install"
       },
       {
        "name": "Warranty Requested",
        "code": "Warranty Req"
       },
       {
        "name": "Inventory Last",
        "code": "Inventory Last"
       },
       {
        "name": "Warranty Received",
        "code": "Warranty Recv"
       },
       {
        "name": "Purchase",
        "code": "Purchase"
       },
       {
        "name": "RTE Installed",
        "code": "RTE_Installed"
       },
       {
        "name": "Inventory Previous",
        "code": "Inventory Prev"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "C1_19W_T2U",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C1_19W",
     "domain": null
    },
    {
     "name": "C2_19W_T4W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C2_19W_T4W",
     "domain": null
    },
    {
     "name": "C3_24W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C3_24W",
     "domain": null
    },
    {
     "name": "C4_31W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C4_31W",
     "domain": null
    },
    {
     "name": "C5_63W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C5_63W",
     "domain": null
    },
    {
     "name": "C6_111W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C6_111W",
     "domain": null
    },
    {
     "name": "C7_131W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C7_131W",
     "domain": null
    },
    {
     "name": "C8_151W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "C8_151W",
     "domain": null
    },
    {
     "name": "F1_20W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "F1_20W",
     "domain": null
    },
    {
     "name": "F2_80W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "F2_80W",
     "domain": null
    },
    {
     "name": "F3_120W_AP",
     "type": "esriFieldTypeSmallInteger",
     "alias": "F3_120W_AP",
     "domain": null
    },
    {
     "name": "F4_120W_BK",
     "type": "esriFieldTypeSmallInteger",
     "alias": "F4_120W_BK",
     "domain": null
    },
    {
     "name": "F5_180W",
     "type": "esriFieldTypeSmallInteger",
     "alias": "F5_180W",
     "domain": null
    },
    {
     "name": "Photo_Cell",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Photo_Cell",
     "domain": null
    },
    {
     "name": "Shield_VGL",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Shield_VGL",
     "domain": null
    },
    {
     "name": "Shield_VGS",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Shield_VGS",
     "domain": null
    },
    {
     "name": "Shield_LS_Peri",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Shield_LS_Peri",
     "domain": null
    },
    {
     "name": "Stickers_City",
     "type": "esriFieldTypeString",
     "alias": "Stickers_City",
     "length": 20,
     "domain": null
    },
    {
     "name": "Note1",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 250,
     "domain": null
    },
    {
     "name": "Lineage",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Lineage",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R2949_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Query,Map,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, AMF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  }
 ]
}