{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "Asset Points", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102740, "latestWkid": 2278, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "assettype", "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": "", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "fac5aa33c55f81991c99701961e76854", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAPCAYAAADtc08vAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABF0lEQVQokaXSPUuCURgG4Gt4XXKxD4yo0UEIIoJcjECKaChwCfpAaZCgAm1pEYIgGhpbanFtFCL6AQVR/yD8AUGbEQ0GLQ01vMWbZj3L4TyH++LhnBP4ZwUdzqc+15u/AAMjVDH2wCwaXQE9bK0wPUj8kMoTm90A6VG2F4mncMXyJcdRU0QCvVQ2SaY+9yUS15y+kPsNMJVleT7UyGCObJ08ztsCSXZLJL73K8RuqT52APILzGQixkqhyPgRJdSigPQQ1XXiEXlQIHbG/sPHv2h8AfpZKzKe+imNPuwwvMdWi3IYSE+yUSDWJg9WUadwxwkaAR/PNkGyiWYnATkS9xw8sxTAK281LmqdkqEKwnfQotzqIhyud8qWNdIM9aVuAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "0", "label": "0" }, { "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 76, 230, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "1", "label": "1" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 252, 209, 255 ], "toColor": [ 202, 252, 209, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 251, 255 ], "toColor": [ 252, 179, 251, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 191, 179, 255 ], "toColor": [ 252, 191, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 202, 223, 252, 255 ], "toColor": [ 202, 223, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 238, 179, 255 ], "toColor": [ 252, 238, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 198, 187, 252, 255 ], "toColor": [ 198, 187, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 245, 255 ], "toColor": [ 252, 210, 245, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 187, 252, 249, 255 ], "toColor": [ 187, 252, 249, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 232, 212, 255 ], "toColor": [ 252, 232, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 228, 252, 179, 255 ], "toColor": [ 228, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 222, 255 ], "toColor": [ 252, 179, 222, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 238, 252, 207, 255 ], "toColor": [ 238, 252, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 246, 252, 255 ], "toColor": [ 215, 246, 252, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2161201.363148883, "ymin": 1.3773631153038979E7, "xmax": 2288002.293601632, "ymax": 1.3849221177055478E7, "spatialReference": { "wkid": 102740, "latestWkid": 2278, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -126725700, "falseY": -77828800, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "assetid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetid", "type": "esriFieldTypeString", "alias": "AssetID", "length": 25, "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "General Notes", "length": 2000, "domain": null }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "Z", "type": "esriFieldTypeDouble", "alias": "Z", "domain": null }, { "name": "updatedgis", "type": "esriFieldTypeString", "alias": "Updated in GIS", "length": 5, "domain": null }, { "name": "lifecyclestatus", "type": "esriFieldTypeSmallInteger", "alias": "Lifecycle Status", "domain": null }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "Date Installed", "length": 8, "domain": null }, { "name": "retireddate", "type": "esriFieldTypeDate", "alias": "Date Retired", "length": 8, "domain": null }, { "name": "abandoneddate", "type": "esriFieldTypeDate", "alias": "Abandoned Date", "length": 8, "domain": null }, { "name": "assettype", "type": "esriFieldTypeSmallInteger", "alias": "Asset Type", "domain": null }, { "name": "ESRIGNSS_POSITIONSOURCETYPE", "type": "esriFieldTypeSmallInteger", "alias": "Position source type", "domain": { "type": "codedValue", "name": "ESRI_POSITIONSOURCETYPE_DOMAIN", "description": "Position Source Type", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "User defined", "code": 1 }, { "name": "Integrated (System) Location Provider", "code": 2 }, { "name": "External GNSS Receiver", "code": 3 }, { "name": "Network Location Provider", "code": 4 }, { "name": "Snapped", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ESRIGNSS_RECEIVER", "type": "esriFieldTypeString", "alias": "Receiver Name", "length": 50, "domain": null }, { "name": "ESRIGNSS_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "ESRIGNSS_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "ESRIGNSS_ALTITUDE", "type": "esriFieldTypeDouble", "alias": "Altitude", "domain": null }, { "name": "ESRIGNSS_H_RMS", "type": "esriFieldTypeDouble", "alias": "Horizontal Accuracy (m)", "domain": null }, { "name": "ESRIGNSS_V_RMS", "type": "esriFieldTypeDouble", "alias": "Vertical Accuracy (m)", "domain": null }, { "name": "ESRIGNSS_FIXDATETIME", "type": "esriFieldTypeDate", "alias": "Fix Time", "length": 8, "domain": null }, { "name": "ESRIGNSS_FIXTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Fix Type", "domain": { "type": "codedValue", "name": "ESRI_FIX_TYPE_DOMAIN", "description": "Fix Type", "codedValues": [ { "name": "Fix not valid", "code": 0 }, { "name": "GPS", "code": 1 }, { "name": "Differential GPS", "code": 2 }, { "name": "RTK Fixed", "code": 4 }, { "name": "RTK Float", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ESRIGNSS_CORRECTIONAGE", "type": "esriFieldTypeDouble", "alias": "Correction Age", "domain": null }, { "name": "ESRIGNSS_STATIONID", "type": "esriFieldTypeSmallInteger", "alias": "Station ID", "domain": { "type": "range", "name": "ESRI_STATION_ID_DOMAIN", "description": "Station ID", "range": [ 0, 1023 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ESRIGNSS_NUMSATS", "type": "esriFieldTypeSmallInteger", "alias": "Number of Satellites", "domain": { "type": "range", "name": "ESRI_NUM_SATS_DOMAIN", "description": "Number of Satellites", "range": [ 0, 99 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ESRIGNSS_PDOP", "type": "esriFieldTypeDouble", "alias": "PDOP", "domain": null }, { "name": "ESRIGNSS_HDOP", "type": "esriFieldTypeDouble", "alias": "HDOP", "domain": null }, { "name": "ESRIGNSS_VDOP", "type": "esriFieldTypeDouble", "alias": "VDOP", "domain": null }, { "name": "ESRIGNSS_DIRECTION", "type": "esriFieldTypeDouble", "alias": "Direction of travel (°)", "domain": null }, { "name": "ESRIGNSS_SPEED", "type": "esriFieldTypeDouble", "alias": "Speed (km/h)", "domain": null }, { "name": "ESRISNSR_AZIMUTH", "type": "esriFieldTypeDouble", "alias": "Compass reading (°)", "domain": null }, { "name": "ESRIGNSS_AVG_H_RMS", "type": "esriFieldTypeDouble", "alias": "Average Horizontal Accuracy (m)", "domain": null }, { "name": "ESRIGNSS_AVG_V_RMS", "type": "esriFieldTypeDouble", "alias": "Average Vertical Accuracy (m)", "domain": null }, { "name": "ESRIGNSS_AVG_POSITIONS", "type": "esriFieldTypeSmallInteger", "alias": "Averaged Positions", "domain": null }, { "name": "ESRIGNSS_H_STDDEV", "type": "esriFieldTypeDouble", "alias": "Standard Deviation (m)", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "trans_CO1", "type": "esriFieldTypeInteger", "alias": "transCO1", "domain": null }, { "name": "serial_num1", "type": "esriFieldTypeString", "alias": "SerialNum", "length": 255, "domain": null }, { "name": "order_type", "type": "esriFieldTypeString", "alias": "order_type", "length": 255, "domain": { "type": "codedValue", "name": "Order_type", "description": "Order_type", "codedValues": [ { "name": "Set", "code": "S" }, { "name": "Remove", "code": "R" }, { "name": "Change", "code": "C" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "address", "type": "esriFieldTypeString", "alias": "address", "length": 255, "domain": null }, { "name": "work_order", "type": "esriFieldTypeInteger", "alias": "work_order", "domain": null }, { "name": "pole_tag", "type": "esriFieldTypeInteger", "alias": "pole_tag", "domain": null }, { "name": "phases", "type": "esriFieldTypeSmallInteger", "alias": "phases", "domain": { "type": "codedValue", "name": "Num_Phase", "description": "Num_Phase", "codedValues": [ { "name": "1", "code": 1 }, { "name": "3", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "phasing_code1", "type": "esriFieldTypeString", "alias": "phasing_code1", "length": 255, "domain": { "type": "codedValue", "name": "Phasing_code", "description": "Phasing_code", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "ABC", "code": "ABC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KVA1", "type": "esriFieldTypeString", "alias": "KVA1", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "secondary_voltage1", "type": "esriFieldTypeString", "alias": "secondary_voltage1", "length": 255, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "trans_CO2", "type": "esriFieldTypeInteger", "alias": "trans_CO2", "domain": null }, { "name": "KVA2", "type": "esriFieldTypeString", "alias": "KVA2", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "secondary_voltage2", "type": "esriFieldTypeString", "alias": "secondary_voltage2", "length": 255, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "serial_num2", "type": "esriFieldTypeString", "alias": "serial_num2", "length": 255, "domain": null }, { "name": "transCO3", "type": "esriFieldTypeInteger", "alias": "transCO3", "domain": null }, { "name": "phasing_code2", "type": "esriFieldTypeString", "alias": "phasing_code2", "length": 255, "domain": { "type": "codedValue", "name": "Phasing_code", "description": "Phasing_code", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "ABC", "code": "ABC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "phasing_code3", "type": "esriFieldTypeString", "alias": "phasing_code3", "length": 255, "domain": { "type": "codedValue", "name": "Phasing_code", "description": "Phasing_code", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "ABC", "code": "ABC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KVA3", "type": "esriFieldTypeString", "alias": "KVA3", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "secondary_voltage3", "type": "esriFieldTypeString", "alias": "secondary_voltage3", "length": 255, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "trx_type", "type": "esriFieldTypeInteger", "alias": "trx_type", "domain": { "type": "codedValue", "name": "Asset_Category_ID", "description": "Asset_Category", "codedValues": [ { "name": "Conventional", "code": 5 }, { "name": "Pad Mount", "code": 6 }, { "name": "Recloser", "code": 9 }, { "name": "Regulator", "code": 10 }, { "name": "High Voltage", "code": 11 }, { "name": "Switch", "code": 12 }, { "name": "PD MT Stainless", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "serial_num3", "type": "esriFieldTypeString", "alias": "serial_num3", "length": 255, "domain": null }, { "name": "Unit_Valid1", "type": "esriFieldTypeString", "alias": "Unit_Valid1", "length": 255, "domain": null }, { "name": "Unit_Valid2", "type": "esriFieldTypeInteger", "alias": "Unit_Valid2", "domain": null }, { "name": "Unit_Valid3", "type": "esriFieldTypeInteger", "alias": "Unit_Valid3", "domain": null }, { "name": "trans_CO1_R", "type": "esriFieldTypeInteger", "alias": "trans_CO1_R", "domain": null }, { "name": "trans_CO2_R", "type": "esriFieldTypeInteger", "alias": "trans_CO2_R", "domain": null }, { "name": "trans_CO3_R", "type": "esriFieldTypeInteger", "alias": "trans_CO3_R", "domain": null }, { "name": "phasing_code1_R", "type": "esriFieldTypeString", "alias": "phasing_code1_R", "length": 255, "domain": { "type": "codedValue", "name": "Phasing_code", "description": "Phasing_code", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "ABC", "code": "ABC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "phasing_code2_R", "type": "esriFieldTypeString", "alias": "phasing_code2_R", "length": 255, "domain": { "type": "codedValue", "name": "Phasing_code", "description": "Phasing_code", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "ABC", "code": "ABC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "phasing_code3_R", "type": "esriFieldTypeString", "alias": "phasing_code3_R", "length": 255, "domain": { "type": "codedValue", "name": "Phasing_code", "description": "Phasing_code", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "ABC", "code": "ABC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KVA1_R", "type": "esriFieldTypeString", "alias": "KVA1_R", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KVA2_R", "type": "esriFieldTypeString", "alias": "KVA2_R", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KVA3_R", "type": "esriFieldTypeString", "alias": "KVA3_R", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "serial_num1_R", "type": "esriFieldTypeString", "alias": "serial_num1_R", "length": 255, "domain": null }, { "name": "serial_num2_R", "type": "esriFieldTypeString", "alias": "serial_num2_R", "length": 255, "domain": null }, { "name": "serial_num3_R", "type": "esriFieldTypeString", "alias": "serial_num3_R", "length": 255, "domain": null }, { "name": "secondary_voltage1_R", "type": "esriFieldTypeString", "alias": "secondary_voltage1_R", "length": 255, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "secondary_voltage2_R", "type": "esriFieldTypeString", "alias": "secondary_voltage2_R", "length": 255, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "secondary_voltage3_R", "type": "esriFieldTypeString", "alias": "secondary_voltage3_R", "length": 255, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "trx_type_R", "type": "esriFieldTypeInteger", "alias": "trx_type_R", "domain": { "type": "codedValue", "name": "Asset_Category_ID", "description": "Asset_Category", "codedValues": [ { "name": "Conventional", "code": 5 }, { "name": "Pad Mount", "code": 6 }, { "name": "Recloser", "code": 9 }, { "name": "Regulator", "code": 10 }, { "name": "High Voltage", "code": 11 }, { "name": "Switch", "code": 12 }, { "name": "PD MT Stainless", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pole_tag_R", "type": "esriFieldTypeInteger", "alias": "pole_tag_R", "domain": null }, { "name": "manufacturer2", "type": "esriFieldTypeString", "alias": "manufacturer2", "length": 255, "domain": null }, { "name": "manufacturer3", "type": "esriFieldTypeString", "alias": "manufacturer3", "length": 255, "domain": null }, { "name": "manufacturer1_R", "type": "esriFieldTypeString", "alias": "manufacturer1_R", "length": 255, "domain": null }, { "name": "manufacturer2_R", "type": "esriFieldTypeString", "alias": "manufacturer2_R", "length": 255, "domain": null }, { "name": "manufacturer3_R", "type": "esriFieldTypeString", "alias": "manufacturer3_R", "length": 255, "domain": null }, { "name": "manufacturer1", "type": "esriFieldTypeString", "alias": "manufacturer1", "length": 255, "domain": null }, { "name": "phases_R", "type": "esriFieldTypeSmallInteger", "alias": "phases_R", "domain": { "type": "codedValue", "name": "Num_Phase", "description": "Num_Phase", "codedValues": [ { "name": "1", "code": 1 }, { "name": "3", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R25_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_25", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_25", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S6_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "NBUAssets.DBO.Transformer_Unit", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "assetid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "Transformer Unit", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "assetid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetid", "type": "esriFieldTypeString", "alias": "AssetID", "length": 25, "domain": null }, { "name": "UnitID", "type": "esriFieldTypeInteger", "alias": "UnitID", "domain": null }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "length": 255, "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": "KVA", "type": "esriFieldTypeString", "alias": "KVA", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Manufacturer", "type": "esriFieldTypeInteger", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "Department_ID", "description": "Manufacturer", "codedValues": [ { "name": "ABB", "code": 7 }, { "name": "KUHLMAN", "code": 8 }, { "name": "HOWARD", "code": 9 }, { "name": "GRAYBAR", "code": 10 }, { "name": "ALLIS CHALMERS", "code": 11 }, { "name": "WEST/HOUSE", "code": 12 }, { "name": "MAGNETIC", "code": 13 }, { "name": "TEMPLE", "code": 14 }, { "name": "ALAMO TRANSFORMER", "code": 15 }, { "name": "ERMCO", "code": 16 }, { "name": "WAGNER", "code": 17 }, { "name": "LINE MATERIAL INDUSTRIES", "code": 19 }, { "name": "SOUTHWAY", "code": 20 }, { "name": "ARKANSAS ELECTRIC", "code": 22 }, { "name": "FAPCO", "code": 23 }, { "name": "ELECTRIC", "code": 25 }, { "name": "GE - PROLEC", "code": 28 }, { "name": "RTE", "code": 30 }, { "name": "PAUWEL CHANCE", "code": 31 }, { "name": "MOLONEY", "code": 32 }, { "name": "HIPER CORE", "code": 34 }, { "name": "CARTER", "code": 35 }, { "name": "GREENVILLE TRANSFORMER", "code": 36 }, { "name": "MID-CENT.", "code": 37 }, { "name": "SIEMENS", "code": 38 }, { "name": "CTE", "code": 39 }, { "name": "JFR", "code": 41 }, { "name": "AF", "code": 42 }, { "name": "HEVI DUTY ELECTRIC", "code": 43 }, { "name": "LEXINGTON", "code": 46 }, { "name": "SUNBELT SOLOMON", "code": 47 }, { "name": "DIST. TRANS.", "code": 48 }, { "name": "KYLE", "code": 49 }, { "name": "ATSCO", "code": 50 }, { "name": "EDISON", "code": 51 }, { "name": "VANTRAN ELECTRIC", "code": 52 }, { "name": "ZINCO", "code": 53 }, { "name": "VAN TRAN.", "code": 54 }, { "name": "H & I", "code": 55 }, { "name": "S I D", "code": 56 }, { "name": "DELTA STAR", "code": 57 }, { "name": "POLE STAR", "code": 59 }, { "name": "PENN", "code": 60 }, { "name": "CENTRAL TRAN CORP", "code": 61 }, { "name": "PRECISION", "code": 62 }, { "name": "AEC", "code": 63 }, { "name": "TEC", "code": 64 }, { "name": "CG POWER", "code": 65 }, { "name": "POWER PARTNER", "code": 66 }, { "name": "WEG TRANSF.", "code": 67 }, { "name": "UNITED TRS. ELECTRIC", "code": 68 }, { "name": "EMERALD TRANSFORMERS", "code": 69 }, { "name": "DELTA ELECTRIC", "code": 70 }, { "name": "MIDWEST TRANSF.", "code": 71 }, { "name": "TST", "code": 72 }, { "name": "MADDOX TRANSF.", "code": 73 }, { "name": "RYMEL", "code": 74 }, { "name": "DAELIM", "code": 75 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Serial_Num", "type": "esriFieldTypeString", "alias": "Serial_Num", "length": 50, "domain": null }, { "name": "Secondary_Volt", "type": "esriFieldTypeString", "alias": "Secondary_Volt", "length": 30, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "trx_type", "type": "esriFieldTypeInteger", "alias": "trx_type", "domain": { "type": "codedValue", "name": "Asset_Category_ID", "description": "Asset_Category", "codedValues": [ { "name": "Conventional", "code": 5 }, { "name": "Pad Mount", "code": 6 }, { "name": "Recloser", "code": 9 }, { "name": "Regulator", "code": 10 }, { "name": "High Voltage", "code": 11 }, { "name": "Switch", "code": 12 }, { "name": "PD MT Stainless", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R28_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_39_assetid", "fields": "assetid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_39_UnitID", "fields": "UnitID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_28", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_28", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "NBUAssets.DBO.AssetPoints", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "assetid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "Transformer_Assets_AGOL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetDescription", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeInteger", "alias": "Asset ID", "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "KVA", "length": 255, "domain": { "type": "codedValue", "name": "KVA", "description": "KVA values for Transformers", "codedValues": [ { "name": "1", "code": "1" }, { "name": "15", "code": "15" }, { "name": "25", "code": "25" }, { "name": "37.5", "code": "37.5" }, { "name": "45", "code": "45" }, { "name": "50", "code": "50" }, { "name": "75", "code": "75" }, { "name": "100", "code": "100" }, { "name": "112.5", "code": "112.5" }, { "name": "150", "code": "150" }, { "name": "167", "code": "167" }, { "name": "225", "code": "225" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "500", "code": "500" }, { "name": "750", "code": "750" }, { "name": "1000", "code": "1000" }, { "name": "1500", "code": "1500" }, { "name": "2000", "code": "2000" }, { "name": "2500", "code": "2500" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssetCategoryID", "type": "esriFieldTypeInteger", "alias": "Asset Category ID", "domain": { "type": "codedValue", "name": "Asset_Category_ID", "description": "Asset_Category", "codedValues": [ { "name": "Conventional", "code": 5 }, { "name": "Pad Mount", "code": 6 }, { "name": "Recloser", "code": 9 }, { "name": "Regulator", "code": 10 }, { "name": "High Voltage", "code": 11 }, { "name": "Switch", "code": 12 }, { "name": "PD MT Stainless", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": { "type": "codedValue", "name": "Status_ID", "description": "Status", "codedValues": [ { "name": "Warehouse", "code": 2 }, { "name": "In Service", "code": 6 }, { "name": "Repair", "code": 7 }, { "name": "Junk", "code": 8 }, { "name": "Sold", "code": 12 }, { "name": "Unknown", "code": 13 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Manufacturer", "type": "esriFieldTypeInteger", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "Department_ID", "description": "Manufacturer", "codedValues": [ { "name": "ABB", "code": 7 }, { "name": "KUHLMAN", "code": 8 }, { "name": "HOWARD", "code": 9 }, { "name": "GRAYBAR", "code": 10 }, { "name": "ALLIS CHALMERS", "code": 11 }, { "name": "WEST/HOUSE", "code": 12 }, { "name": "MAGNETIC", "code": 13 }, { "name": "TEMPLE", "code": 14 }, { "name": "ALAMO TRANSFORMER", "code": 15 }, { "name": "ERMCO", "code": 16 }, { "name": "WAGNER", "code": 17 }, { "name": "LINE MATERIAL INDUSTRIES", "code": 19 }, { "name": "SOUTHWAY", "code": 20 }, { "name": "ARKANSAS ELECTRIC", "code": 22 }, { "name": "FAPCO", "code": 23 }, { "name": "ELECTRIC", "code": 25 }, { "name": "GE - PROLEC", "code": 28 }, { "name": "RTE", "code": 30 }, { "name": "PAUWEL CHANCE", "code": 31 }, { "name": "MOLONEY", "code": 32 }, { "name": "HIPER CORE", "code": 34 }, { "name": "CARTER", "code": 35 }, { "name": "GREENVILLE TRANSFORMER", "code": 36 }, { "name": "MID-CENT.", "code": 37 }, { "name": "SIEMENS", "code": 38 }, { "name": "CTE", "code": 39 }, { "name": "JFR", "code": 41 }, { "name": "AF", "code": 42 }, { "name": "HEVI DUTY ELECTRIC", "code": 43 }, { "name": "LEXINGTON", "code": 46 }, { "name": "SUNBELT SOLOMON", "code": 47 }, { "name": "DIST. TRANS.", "code": 48 }, { "name": "KYLE", "code": 49 }, { "name": "ATSCO", "code": 50 }, { "name": "EDISON", "code": 51 }, { "name": "VANTRAN ELECTRIC", "code": 52 }, { "name": "ZINCO", "code": 53 }, { "name": "VAN TRAN.", "code": 54 }, { "name": "H & I", "code": 55 }, { "name": "S I D", "code": 56 }, { "name": "DELTA STAR", "code": 57 }, { "name": "POLE STAR", "code": 59 }, { "name": "PENN", "code": 60 }, { "name": "CENTRAL TRAN CORP", "code": 61 }, { "name": "PRECISION", "code": 62 }, { "name": "AEC", "code": 63 }, { "name": "TEC", "code": 64 }, { "name": "CG POWER", "code": 65 }, { "name": "POWER PARTNER", "code": 66 }, { "name": "WEG TRANSF.", "code": 67 }, { "name": "UNITED TRS. ELECTRIC", "code": 68 }, { "name": "EMERALD TRANSFORMERS", "code": 69 }, { "name": "DELTA ELECTRIC", "code": 70 }, { "name": "MIDWEST TRANSF.", "code": 71 }, { "name": "TST", "code": 72 }, { "name": "MADDOX TRANSF.", "code": 73 }, { "name": "RYMEL", "code": 74 }, { "name": "DAELIM", "code": 75 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Vendor", "type": "esriFieldTypeInteger", "alias": "Vendor", "domain": { "type": "codedValue", "name": "Vendor_ID", "description": "Vendor_Name", "codedValues": [ { "name": "SUNBELT SOLOMON", "code": 1 }, { "name": "Priester Supply", "code": 3 }, { "name": "KBS", "code": 4 }, { "name": "CENT. MOLONEY", "code": 6 }, { "name": "POWER SUPPLY", "code": 7 }, { "name": "WESCO", "code": 8 }, { "name": "HOWARD", "code": 9 }, { "name": "TECHLINE", "code": 10 }, { "name": "TEMPLE", "code": 11 }, { "name": "MCGRAW", "code": 12 }, { "name": "PRIESTER MELL & NICHOLSON", "code": 13 }, { "name": "ALAMO TRANSFORMER", "code": 14 }, { "name": "CITY OF SEGUIN", "code": 15 }, { "name": "SOUTH WAY", "code": 16 }, { "name": "UNKNOWN", "code": 17 }, { "name": "TRI-ELECTRIC", "code": 18 }, { "name": "LINE MATERIAL INDUSTRIES", "code": 20 }, { "name": "POLINE", "code": 21 }, { "name": "PERRY SHANKLE", "code": 22 }, { "name": "STERETT SUPPLY CO.", "code": 23 }, { "name": "SIEMANS", "code": 24 }, { "name": "GRAYBAR", "code": 30 }, { "name": "G E SUPPLY", "code": 31 }, { "name": "RTE", "code": 32 }, { "name": "S.W.E.U.S.", "code": 37 }, { "name": "WESTINGHOUSE", "code": 38 }, { "name": "GREENVILLE TRANSFORMER", "code": 41 }, { "name": "FAPCO", "code": 42 }, { "name": "ATSCO", "code": 45 }, { "name": "SOMMERS", "code": 46 }, { "name": "AZTEC", "code": 47 }, { "name": "TEC", "code": 48 }, { "name": "SOLOMANN", "code": 49 }, { "name": "BOERNE", "code": 51 }, { "name": "SAN ANGELO ELECTRIC SERVICE", "code": 52 }, { "name": "AB CHANCE", "code": 55 }, { "name": "ROY HARRIS", "code": 58 }, { "name": "ALLIS-CHALMERS", "code": 59 }, { "name": "BANDERA", "code": 60 }, { "name": "C E D", "code": 61 }, { "name": "WAGNER", "code": 62 }, { "name": "ALAMO SUPPLY", "code": 63 }, { "name": "SWEUS", "code": 64 }, { "name": "GVEC", "code": 66 }, { "name": "CENTRAL TRANS CORP", "code": 68 }, { "name": "WHOLESALE ELECTRIC", "code": 69 }, { "name": "CEN. TEX. ELECTRIC", "code": 70 }, { "name": "ZACHRY COMPANY", "code": 71 }, { "name": "HUGHES ELECT.", "code": 73 }, { "name": "T DAVIS & ASSOCIATES", "code": 74 }, { "name": "S M ELECTRIC SUPPLY", "code": 75 }, { "name": "MOLONEY ELECTRIC CO", "code": 76 }, { "name": "C P S B, SOUTH TEXAS DEPT", "code": 77 }, { "name": "SIMMONS & SIMMONS", "code": 78 }, { "name": "UTILCO", "code": 79 }, { "name": "TEX. -ELECT. COOP.", "code": 80 }, { "name": "IRBY", "code": 87 }, { "name": "HD SUPPLY", "code": 88 }, { "name": "CG Power Systems", "code": 89 }, { "name": "UTILITECH POWER PROD.", "code": 90 }, { "name": "ANIXTER", "code": 91 }, { "name": "UNITED TRS. ELEC", "code": 92 }, { "name": "MIDWEST TRANSF.", "code": 93 }, { "name": "EMERALD TRANSF.", "code": 94 }, { "name": "MADDOX TRANSF.", "code": 95 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PrimaryVoltage", "type": "esriFieldTypeString", "alias": "Primary Voltage", "length": 50, "domain": { "type": "codedValue", "name": "PrimaryVoltage", "description": "Primary Voltage for Transformers", "codedValues": [ { "name": "7200", "code": "1" }, { "name": "7200/12400", "code": "2" }, { "name": "7200/12470", "code": "3" }, { "name": "1200/7200", "code": "4" }, { "name": "1200/12470", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "SecondaryVoltage", "type": "esriFieldTypeString", "alias": "Secondary Voltage", "length": 30, "domain": { "type": "codedValue", "name": "Secondary_Voltage", "description": "Secondary Voltage for Transformers", "codedValues": [ { "name": "120/240", "code": "1" }, { "name": "120/208", "code": "2" }, { "name": "277/480", "code": "3" }, { "name": "280/477", "code": "4" }, { "name": "120", "code": "5" }, { "name": "240", "code": "6" }, { "name": "277", "code": "7" }, { "name": "120/240/208", "code": "8" }, { "name": "240/480", "code": "9" }, { "name": "240/480/15", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseOrderNumber", "type": "esriFieldTypeInteger", "alias": "PO Number", "domain": null }, { "name": "ReceivedBy", "type": "esriFieldTypeString", "alias": "Received By", "length": 50, "domain": null }, { "name": "DateAcquired", "type": "esriFieldTypeDate", "alias": "Date Acquired", "length": 8, "domain": null }, { "name": "DateSold", "type": "esriFieldTypeDate", "alias": "Date Sold", "length": 8, "domain": null }, { "name": "PurchasePrice", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "length": 50, "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "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 Edit User", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "OldAssetID", "type": "esriFieldTypeInteger", "alias": "OldAssetID", "domain": null } ], "indexes": [ { "name": "R32_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }