Name: Switch_04232025
Display Field: AncillaryRole
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: 4/11/2022, I finished importing the fieldwork into the SDE at University Village. University Village has gone from overhead power to underground power. The work started the Summer of 2021 and completed Spring of 2022. I went out on 4/4/2022 and GPS the above ground infrastructure. The receiver in good sky was getting better than an inch accuracy; however, much of this neighborhood has thick evergreen tree cover. Robert Holder and Mike Stamey held the GPS receiver to speed up the collection process. The powerlines are drawn connecting the collected points unless it was noticed that trenching was done. I also used a model given to me by Matt Makdad. Here Is a link to the entire project. 8/31/2021 Updated Forest Hill Area using GPS and a site visit 8/23/2021, further attribution will come later. The GPS worked pretty good in most areas struggled in dense canopy setting.8/23/2021 Updated Stadium P3 area using a .dwg supplied by JW Hampton given to me by Dainel Gryder.5/13/2021 Email request from Matt Makdad: Matt Makdad2:31 PMEddieWould like the following items added to Switch Feature Class, Attribute SUBTYPE CD NRLP:OVERHEAD - GANG OPERATED SWITCHOVERHEAD - KNIFE BLADE(S)OVERHEAD - FUSE SAVER(S)OVERHEAD - FUSED DISCONNECT(S)JUNCTION CABINET - 1 PHASE JUNCTION CABINET - 3 PHASE - 2 POINT JUNCTION CABINET - 3 PHASE - 3 POINTJUNCTION CABINET - 3 PHASE - 4 POINTDelete:JUNCTION CABINETSWITCHBOARD7/9/2018 This, feature class was updated with a 2017 survey. The Old High School property was surveyed by Timothy W. Caldwell License number L-5232, September 27, 2017, Mattern & Crag Engineers and Surveyors. Data is considered 90% accurate, and data was collected between 8/ 5-18 / 2017. All coordinates are based on NCGS NAD/83/ 2011 and all elevations are based on NAVD 88. 1/5/2018 Added 40 switches from NRLP CAD needs to be spatialy edited and atributed. Images would also be helpful. 8/22/2017 Images were attached to all 51 points that came from Rochester’s many folders a python script was run to place all images into an organized folder.Scott Eggers data from 03/14/2017 has been transferred to this feature class today 08/07/2017. Some electrical switches were attributed by Rochester as transformers and some transformers were attributed as electrical switches. As Scott discovers these small mix-ups are being corrected.3/14/2017 Under construction in NRLP GeoDatebase3/3/2017 Editor Tracker has been added to this feature class. All of the attributes have been appropriately updated and meaningless columns omitted. However, this is a work in progress.An electrical switch is a device that can break an electrical circuit, interrupting the current diverting it from one conductor to another. In this dataset 47 electrical switches were geolocated and photographed between 9/9/2014 and 11/3/2014; however, 16 of those do not have a date listed. Nothing is entered in the following columns: id, owner, install_yr and source. The PM_Number column tells the name of the specific electrical switch, all but one has a listed name, pointid63, 52882. There are only a few entries in the following columns, dimensions, comments, and they are: dimensions column 6x6, (7) 5x5, 4x5, and 2.5x2.5, comments column, NC2, WC3, WC2, and NC3. Woodard & Curran, Rochester & Associates, Inc. New River Light & Power, Highland Mapping, ASU Technology support, Art Rex and Edward Hyle
Copyright Text: Appalachian GIS
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 1201686.6045918
YMin: 898898.106594563
XMax: 1218278.82993747
YMax: 911858.99963598
Spatial Reference: PROJCS["NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.002616666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-79.0],PARAMETER["Standard_Parallel_1",34.33333333333334],PARAMETER["Standard_Parallel_2",36.16666666666666],PARAMETER["Latitude_Of_Origin",33.75],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Foot_US",0.3048006096012192]]
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[0,0,0,255],"size":13,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- AncillaryRole (type: esriFieldTypeSmallInteger, alias: AncillaryRole, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- DateModified (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SubtypeCD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OperatingVoltage (type: esriFieldTypeInteger, alias: Operating Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [120: 4.16 kV Grounded Wye], [160: 7.2 kV Grounded Wye], [210: 12.5 kV Grounded Wye], ... 8 more ...)
- ConstructionStatus (type: esriFieldTypeInteger, alias: Construction Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Proposed], [5: Existing], [10: Waiting For Staking], ... 5 more ...)
- WorkOrderID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- InstallationDate (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ElectricTraceWeight (type: esriFieldTypeInteger, alias: Electric Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FeederInfo (type: esriFieldTypeInteger, alias: Feeder Information, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SymbolRotation (type: esriFieldTypeDouble, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NominalVoltage (type: esriFieldTypeInteger, alias: NominalVoltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [120: 4.16 kV Grounded Wye], [160: 7.2 kV Grounded Wye], [210: 12.5 kV Grounded Wye], ... 8 more ...)
- PhaseDesignation (type: esriFieldTypeInteger, alias: Phase Designation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: A], [6: AB], [5: AC], ... 4 more ...)
- ManuallyOperated (type: esriFieldTypeString, alias: Manually Operated Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- MaxContinuousCurrent (type: esriFieldTypeDouble, alias: Maximum Continuous Current, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MaxOperatingVoltage (type: esriFieldTypeInteger, alias: Maximum Operating Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [120: 4.16 kV Grounded Wye], [160: 7.2 kV Grounded Wye], [210: 12.5 kV Grounded Wye], ... 8 more ...)
- NormalPosition_A (type: esriFieldTypeInteger, alias: Normal Position - A, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: NULL], [2: NO], [3: NC])
- NormalPosition_B (type: esriFieldTypeInteger, alias: Normal Position - B, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: NULL], [2: NO], [3: NC])
- NormalPosition_C (type: esriFieldTypeInteger, alias: Normal Position - C, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: NULL], [2: NO], [3: NC])
- PresentPosition_A (type: esriFieldTypeInteger, alias: Present Position - A, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Closed], [0: Open], [2: Not Applicable])
- PresentPosition_B (type: esriFieldTypeInteger, alias: Present Position - B, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Closed], [0: Open], [2: Not Applicable])
- PresentPosition_C (type: esriFieldTypeInteger, alias: Present Position - C, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Closed], [0: Open], [2: Not Applicable])
- TieSwitchIndicator (type: esriFieldTypeString, alias: Tie Switch Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- SCADAControlID (type: esriFieldTypeString, alias: SCADA Control ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SCADAMonitorID (type: esriFieldTypeString, alias: SCADA Monitor ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- GangOperated (type: esriFieldTypeString, alias: Gang Operated Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- OPERATINGCLASS (type: esriFieldTypeString, alias: OPERATINGCLASS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CONSTRUCTIONTYPE (type: esriFieldTypeString, alias: CONSTRUCTIONTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SW_Number (type: esriFieldTypeString, alias: SW_Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Dimensions (type: esriFieldTypeString, alias: Dimensions, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Install_Year (type: esriFieldTypeString, alias: Install_Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- LocalEllip (type: esriFieldTypeDouble, alias: LocalEllip, SQL Type: sqlTypeOther, nullable: true, editable: true)
- H_Prec_Obs (type: esriFieldTypeDouble, alias: H_Prec_Obs, SQL Type: sqlTypeOther, nullable: true, editable: true)
- V_Prec_Obs (type: esriFieldTypeDouble, alias: V_Prec_Obs, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Time_Obs (type: esriFieldTypeString, alias: Time_Obs, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Photo (type: esriFieldTypeString, alias: Photo, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- Elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SUBSTATION (type: esriFieldTypeSmallInteger, alias: SUBSTATION, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Winklers Creek], [2: ASU], [3: Oak Grove], ... 3 more ...)
- CIRCUIT (type: esriFieldTypeSmallInteger, alias: CIRCUIT, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [101: 101 GREENWAY (Winklers Creek)], [102: 102 PAYNE BRANCH (Winklers Creek)], [103: 103 BLOWING ROCK (Winklers Creek)], ... 30 more ...)
- GRIDNO (type: esriFieldTypeString, alias: GRIDNO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COMPART1 (type: esriFieldTypeString, alias: COMPART1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COMPART2 (type: esriFieldTypeString, alias: COMPART2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COMPART3 (type: esriFieldTypeString, alias: COMPART3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COMPART4 (type: esriFieldTypeString, alias: COMPART4, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SUBTYPE_CD (type: esriFieldTypeInteger, alias: SUBTYPE CD NRLP, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: AUTO TRANSFER ENCLOSURE], [3: FOUR-CABINET PAD-MOUNTED], [5: TWO-CABINET PAD-MOUNTED], ... 8 more ...)
- FEEDER_ID (type: esriFieldTypeSmallInteger, alias: FEEDER_ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [101: 101 GREENWAY (Winklers Creek)], [102: 102 PAYNE BRANCH (Winklers Creek)], [103: 103 BLOWING ROCK (Winklers Creek)], ... 30 more ...)
- FEEDER_ID2 (type: esriFieldTypeSmallInteger, alias: FEEDER_ID2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [101: 101 GREENWAY (Winklers Creek)], [102: 102 PAYNE BRANCH (Winklers Creek)], [103: 103 BLOWING ROCK (Winklers Creek)], ... 30 more ...)
- PreferredCircuitSource (type: esriFieldTypeSmallInteger, alias: PreferredCircuitSource, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [101: 101 GREENWAY (Winklers Creek)], [102: 102 PAYNE BRANCH (Winklers Creek)], [103: 103 BLOWING ROCK (Winklers Creek)], ... 30 more ...)
- MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MFR_DATE (type: esriFieldTypeDate, alias: MFR_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SERIAL_No (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Templates:
Name: Switch_04232025
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Enabled: 1
- SubtypeCD: 4
- ConstructionStatus: 5
- SymbolRotation: 0
- MaxOperatingVoltage: 210
- NormalPosition_A: 1
- NormalPosition_B: 1
- NormalPosition_C: 1
- PresentPosition_A: 1
- PresentPosition_B: 1
- PresentPosition_C: 1
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/23/2025 4:58:29 PM
Schema Last Edit Date: 4/23/2025 4:58:29 PM
Data Last Edit Date: 4/23/2025 4:58:29 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat