{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 41, "name": "Elec_SwitchData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 12, "name": "ElecSwitch", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "Name", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "State", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Quantity" }, { "name": "Sizes", "type": "esriFieldTypeString", "alias": "Size", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Sizes" }, { "name": "Units", "type": "esriFieldTypeString", "alias": "Unit", "domain": { "type": "codedValue", "name": "ElecUnits", "description": "Units", "codedValues": [ { "name": "Amps", "code": "Amps" }, { "name": "Volts", "code": "Volts" }, { "name": "Kva", "code": "Kva" }, { "name": "Kv", "code": "Kv" }, { "name": "Watts", "code": "Watts" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Unit" }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "domain": { "type": "codedValue", "name": "ElecState", "description": "Elec State", "codedValues": [ { "name": "On", "code": "On" }, { "name": "Off", "code": "Off" }, { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "On", "modelName": "State" }, { "name": "Fuse", "type": "esriFieldTypeString", "alias": "Fuse", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Fuse" }, { "name": "Mfg", "type": "esriFieldTypeString", "alias": "Mfg", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Mfg" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNo", "type": "esriFieldTypeString", "alias": "SerialNo", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SerialNo" }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "domain": { "type": "codedValue", "name": "ElecPhase", "description": "Elec Phase ABC", "codedValues": [ { "name": "A", "code": "A" }, { "name": "AB", "code": "AB" }, { "name": "ABC", "code": "ABC" }, { "name": "AC", "code": "AC" }, { "name": "ACB", "code": "ACB" }, { "name": "AD", "code": "AD" }, { "name": "ADC", "code": "ADC" }, { "name": "B", "code": "B" }, { "name": "BA", "code": "BA" }, { "name": "BAC", "code": "BAC" }, { "name": "BC", "code": "BC" }, { "name": "BCA", "code": "BCA" }, { "name": "BDD", "code": "BDD" }, { "name": "C", "code": "C" }, { "name": "CA", "code": "CA" }, { "name": "CAB", "code": "CAB" }, { "name": "CB", "code": "CB" }, { "name": "CBA", "code": "CBA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Phase" }, { "name": "Phasing", "type": "esriFieldTypeString", "alias": "Phasing", "domain": { "type": "codedValue", "name": "ElecPhasingText", "description": "Phasing 123 as text", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Phasing" }, { "name": "SubSta", "type": "esriFieldTypeString", "alias": "SubSta", "domain": { "type": "codedValue", "name": "ElecSubSta", "description": "Substations", "codedValues": [ { "name": "A St", "code": "A St" }, { "name": "College", "code": "College" }, { "name": "F St", "code": "F St" }, { "name": "I St", "code": "I St" }, { "name": "Laurel St", "code": "Laurel St" }, { "name": "Valley St", "code": "Valley St" }, { "name": "Washington St", "code": "Washington St" }, { "name": "Peabody St", "code": "Peabody St" }, { "name": "Albert St", "code": "Albert St" }, { "name": "BPA", "code": "BPA" }, { "name": "PUD", "code": "PUD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "SubSta" }, { "name": "Feeder", "type": "esriFieldTypeString", "alias": "Feeder", "domain": { "type": "codedValue", "name": "ElecFeeder", "description": "Elec Feeder", "codedValues": [ { "name": "PUD", "code": "PUD" }, { "name": "BPA", "code": "BPA" }, { "name": "1201", "code": "1201" }, { "name": "1202", "code": "1202" }, { "name": "1203", "code": "1203" }, { "name": "1204", "code": "1204" }, { "name": "1205", "code": "1205" }, { "name": "1206", "code": "1206" }, { "name": "1207", "code": "1207" }, { "name": "1208", "code": "1208" }, { "name": "1209", "code": "1209" }, { "name": "PA1", "code": "PA1" }, { "name": "PA2", "code": "PA2" }, { "name": "Sub", "code": "Sub" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "Feeder" }, { "name": "SubSta2", "type": "esriFieldTypeString", "alias": "SubSta2", "domain": { "type": "codedValue", "name": "ElecSubSta", "description": "Substations", "codedValues": [ { "name": "A St", "code": "A St" }, { "name": "College", "code": "College" }, { "name": "F St", "code": "F St" }, { "name": "I St", "code": "I St" }, { "name": "Laurel St", "code": "Laurel St" }, { "name": "Valley St", "code": "Valley St" }, { "name": "Washington St", "code": "Washington St" }, { "name": "Peabody St", "code": "Peabody St" }, { "name": "Albert St", "code": "Albert St" }, { "name": "BPA", "code": "BPA" }, { "name": "PUD", "code": "PUD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "SubSta2" }, { "name": "Feeder2", "type": "esriFieldTypeString", "alias": "Feeder2", "domain": { "type": "codedValue", "name": "ElecFeeder", "description": "Elec Feeder", "codedValues": [ { "name": "PUD", "code": "PUD" }, { "name": "BPA", "code": "BPA" }, { "name": "1201", "code": "1201" }, { "name": "1202", "code": "1202" }, { "name": "1203", "code": "1203" }, { "name": "1204", "code": "1204" }, { "name": "1205", "code": "1205" }, { "name": "1206", "code": "1206" }, { "name": "1207", "code": "1207" }, { "name": "1208", "code": "1208" }, { "name": "1209", "code": "1209" }, { "name": "PA1", "code": "PA1" }, { "name": "PA2", "code": "PA2" }, { "name": "Sub", "code": "Sub" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "FeederPg" }, { "name": "FeederPg", "type": "esriFieldTypeString", "alias": "FeederPg", "domain": null, "editable": true, "nullable": true, "length": 55, "defaultValue": null, "modelName": "FeederPg" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "Name" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Hyperlink" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Location" }, { "name": "LocateID", "type": "esriFieldTypeString", "alias": "LocateID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Intersection" }, { "name": "Cancelled", "type": "esriFieldTypeString", "alias": "Cancelled", "domain": { "type": "codedValue", "name": "Yes-No", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Select", "code": "Sel" }, { "name": "Y", "code": "Y" }, { "name": "N", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Cancelled" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "ElecStatus", "description": "Elec Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Demolished", "code": "Demolished" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Sold", "code": "Sold" }, { "name": "Maintenance", "code": "Maintenance" }, { "name": "Obsolete", "code": "Obsolete" }, { "name": "Replace", "code": "Replace" }, { "name": "Outage", "code": "Outage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": "Proposed", "modelName": "Status" }, { "name": "Activity", "type": "esriFieldTypeString", "alias": "Activity", "domain": { "type": "codedValue", "name": "Activity", "description": "WO activity", "codedValues": [ { "name": "Inspection", "code": "Inspection" }, { "name": "Installation", "code": "Installation" }, { "name": "Maintenance", "code": "Maintenance" }, { "name": "Relocation", "code": "Relocation" }, { "name": "Removal", "code": "Removal" }, { "name": "Repair", "code": "Repair" }, { "name": "Replace", "code": "Replace" }, { "name": "Changeout", "code": "Changeout" }, { "name": "Mow", "code": "Mow" }, { "name": "Trim", "code": "Trim" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": "Installation", "modelName": "Activity" } ], "indexes": [ { "name": "R838_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2324Name", "fields": "Name", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Elec_SwitchData", "description": "", "prototype": { "attributes": { "Status": "Proposed", "Activity": "Installation", "Quantity": null, "Sizes": null, "Units": null, "State": "On", "Fuse": null, "Mfg": null, "Model": null, "SerialNo": null, "Phase": null, "Phasing": null, "SubSta": null, "Feeder": null, "SubSta2": null, "Feeder2": null, "FeederPg": null, "Name": null, "Notes": null, "Hyperlink": null, "Location": null, "LocateID": null, "Cancelled": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 2000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }