Name: Transformer_04232025
Display Field: CreationUser
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. 2/11/2022 Update with Collector Eggers, Holder, Stamey, Fieldwork started 5/21/2019 - 10/7/2020, area studied: I25, J25, K21, K26, L23, L24, L25,L26, M24,M25,M26<N23,N24,N25,N26,R24,R25,S23,S24,S25. Link to raw data Here8/23/2021 Updated Stadium P3 area using a .dwg supplied by JW Hampton given to me by Dainel Gryder.10/20/2020Fiber and electrical are being installed October 2020 at ASU Water Plant. While the ditches are open I collected images and exact location with a high accuracy GPS, EOS Arrow Gold the afternoon of 10/14/2020. The GPS worked very well in open sky, accuracy .2-.4 of an Inch; however, beside structures and under tree canopy the accuracy fell to around 6 feet After this data is imported into the GIS Portal attribution will follow from Facilities Electrical Department and Tec Support. While I was there I also collected obvious above ground structure. See below email string:Scott EggersWed, Oct 14, 1:38 PM (21 hours ago)to me, Matt, MichaelEddie,ASU Electrical shop has been installing some infrastructure at the Water Plant on Rainbow Trail for some security cameras I believe. They are in the process of backfilling the trenches now. We thought you might want to GIS those ditches for future reference. If you could do it this week while digging is fresh would be best.Edward HyleWed, Oct 14, 2:06 PM (21 hours ago)Sure, when do you need me come by, and what am I looking at?Michael GreeneWed, Oct 14, 2:22 PM (20 hours ago)to meWe are putting 2-1" PVC from entrance gate all the way around the building to the exit gate for security cameras. There is a total of about 650' of ditch. It is open as of today but we will be backfilling tomorrow. If possible, it would be best to come out early in the morning tomorrow. Call me at (828)964-1698. I will have to open the gate to let you in if you are before 8:00. Let me know if you have any questions.Edward Hylehyleea@appstate.eduWed, Oct 14, 2:26 PM (20 hours ago)to MichaelI would like to see it open I can come by in a bit.Scott EggersWed, Oct 14, 2:38 PM (20 hours ago)to me, Matt, MichaelI think anytime would work. You may want to contact Michael Greene (copied in this email) for more details as they are actually doing the work.ScottEdward Hylehyleea@appstate.edu7:00 AM (4 hours ago)to Scott, Matt, MichaelHello all,I have gotten all of the ditches located and photographed as needed. Please give me a day or so to get is data into the GIS Portal to be viewed, then we can further attribute the data further.Thanks,EddieMichael Greene6:53 AM (3 hours ago)to me10-4. Thanks Eddie7/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. 4/17/2018 Updated by NRLP Staff8/22/2017 Images were attached to 93 of the 1443 points that came from Rochester’s many folders a python script was run to place all images into an organized folder. Rochester surveyed 95 transformers the remainder came from a NRLP CAD drawing. 4/11/2017 An spatial list of all NRLP transformers pad mount and pole mount count 1344.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/6/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.A power transformer is a device that transforms power from one circuit to another without changing the frequency. The voltage is either increased (stepped up) or decreased (stepped down). In this dataset 125 electrical transformers were geolocated, all two were photographed. They data points were collected between 8/19/2014 and 11/19/2014; however, 43 of the data points don’t have a date listed. The following columns do not have any data in them: owner, install_yr, and source. The PM_Number column stands for the name of a specific transformer, 45 of the 125 do not have a PM_Number listed. The Location_N column stands for the actual physical location on New River Light & Power map grid, 44 of the 125 do not have data listed in this column either. There are limited entries in the dimensions’ column they consist of: 7x6, (2) 6x7, 6x6, (2) 6x5, 5x7, (5) 5x6, (7) 5x5, (2) 5x4, 4x6, 3x3, 2x3, and 1.5x1.5. There are also limited comments in the comments column, they consist of: PM784, PM1906, PM1738, PM1724, PM1640, PM1542, PM1457, NC2, and 750.ESRI, 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: 1198629.24226822
YMin: 895327.252515808
XMax: 1263454.73860122
YMax: 943867.810618222
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":"esriPMS","url":"e0409d73b9d2be5210607a2ce0a63dd7","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAATCAYAAACUef2IAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABDElEQVQ4jbWUwQnCMBSGP6E7FB2iIHEFb3GDgrc4gAO0Z8EB9CZ0A4+dwUuHUNxCHkkxhKhN1f/UlseX1//9Lxl/UpZQOwOu/wAfAA1Mfgk2BegCaOwBm1+AZwLeAg5sgCNw+RasS1BL9yIH7KEGVt+AVQ6H0vsg4BZ0B+pd15/AdeksIICv4exsSgavZGACCSW2FDDtnn4ngasYtNcJmFuvk8Bm6Q0sphwoYdpYeD0ErKTwXbe9pKaBCuv35RPYSCfhwF51/Sp+IVgVbhmGynWt70H8sli8ctK0s/GTVV/EwEbi5S/DULn4KT9+mX8f5Pa3RkngnRe/Hiz37LEF1Y4EO936B9+KaNDH6gFRiTaDFZZOlwAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":14,"angle":0,"xoffset":0,"yoffset":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])
- CreationUser (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- DateCreated (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LastUser (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: 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)
- FacilityID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- FeederID (type: esriFieldTypeString, alias: Feeder ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- FeederID2 (type: esriFieldTypeString, alias: Feeder ID 2, SQL Type: sqlTypeOther, length: 20, 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)
- Hyperlink (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NominalVoltage (type: esriFieldTypeInteger, alias: NominalVoltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GroundReactance (type: esriFieldTypeInteger, alias: Ground Reactance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GroundResistance (type: esriFieldTypeInteger, alias: Ground Resistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HighSideGroundReactance (type: esriFieldTypeInteger, alias: High Side Ground Reactance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HighSideGroundResistance (type: esriFieldTypeInteger, alias: High Side Ground Resistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HighSideProtection (type: esriFieldTypeString, alias: High Side Protection, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [BR: Breaker], [BY: Bayonet Fuse], [DW: Dry Well Canister], ... 3 more ...)
- LocationType (type: esriFieldTypeString, alias: Location Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [DLV: Delivery Point], [GEN: Generator], [PRI: Primary Meter], ... 2 more ...)
- MagnetizingReactance (type: esriFieldTypeDouble, alias: Magnetizing Reactance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MagnetizingResistance (type: esriFieldTypeDouble, alias: Magnetizing Resistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LabelText (type: esriFieldTypeString, alias: Label Text, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- PhaseDesignation (type: esriFieldTypeInteger, alias: Phase Designation, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: A], [6: AB], [5: AC], ... 4 more ...)
- RatedKVA (type: esriFieldTypeDouble, alias: Rated kVA, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 kVA], [3: 3 kVA], [5: 5 kVA], ... 37 more ...)
- HighSideConfiguration (type: esriFieldTypeString, alias: High Side Configuration, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- LowSideConfiguration (type: esriFieldTypeString, alias: Low Side Configuration, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- LoadTapChangerIndicator (type: esriFieldTypeString, alias: Load Tap Changer Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- LowSideGroundReactance (type: esriFieldTypeDouble, alias: Low Side Ground Reactance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LowSideGroundResistance (type: esriFieldTypeDouble, alias: Low Side Ground Resistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LowSideProtection (type: esriFieldTypeString, alias: Low Side Protection, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- LowSideVoltage (type: esriFieldTypeInteger, alias: Low Side Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FilledWeight (type: esriFieldTypeDouble, alias: Filled Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EmptyWeight (type: esriFieldTypeDouble, alias: Empty Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HeightBushings (type: esriFieldTypeDouble, alias: Height with Bushings, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HeightNoBushings (type: esriFieldTypeDouble, alias: Height without Bushings, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RatedKVA65Rise (type: esriFieldTypeInteger, alias: Rated kVA 65 Rise, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RatedTertiaryKVA (type: esriFieldTypeInteger, alias: Rated Tertiary kVA, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SwitchType (type: esriFieldTypeString, alias: Switch Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- TertiaryConfiguration (type: esriFieldTypeString, alias: Tertiary Configuration, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- TertiaryVoltage (type: esriFieldTypeInteger, alias: Tertiary Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AlternateX (type: esriFieldTypeDouble, alias: Alternate - X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AlternateY (type: esriFieldTypeDouble, alias: Alternate - Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AlternateZ (type: esriFieldTypeDouble, alias: Alternate - Z, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AlternateSource (type: esriFieldTypeString, alias: Alternate Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [GPS: GPS], [IMG: Imagery], [LSR: Laser], ... 3 more ...)
- SupportStructureObjectID (type: esriFieldTypeInteger, alias: SupportStructureObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HFrameObjectID (type: esriFieldTypeInteger, alias: HFrameObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SurfaceStructureObjectID (type: esriFieldTypeInteger, alias: Surface Structure ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ElectricStationObjectID (type: esriFieldTypeInteger, alias: Electric Station ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [NRLP: NRLP], [ASU: ASU], [TOB: TOB], ... 9 more ...)
- 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)
- PMNumber (type: esriFieldTypeString, alias: PMNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Dimensions (type: esriFieldTypeString, alias: Dimensions, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- InstallYear (type: esriFieldTypeString, alias: InstallYear, SQL Type: sqlTypeOther, length: 30, 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)
- 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)
- Unique_ID (type: esriFieldTypeString, alias: Unique_ID, SQL Type: sqlTypeOther, length: 50, 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)
- 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 ...)
- KVA (type: esriFieldTypeSmallInteger, alias: KVA, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Voltage (type: esriFieldTypeString, alias: Voltage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Map_Number (type: esriFieldTypeString, alias: Map_Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Phase (type: esriFieldTypeString, alias: Phase, SQL Type: sqlTypeOther, length: 10, 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 ...)
- Accuracy (type: esriFieldTypeString, alias: Accuracy, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, 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)
- Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Stock - Main: Stock - Main], [Whse, Stock: Whse, Stock], [Longvue: Longvue], ... 2 more ...)
- Serial_No (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- PID (type: esriFieldTypeString, alias: PID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Impedance (type: esriFieldTypeDouble, alias: Impedance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Style (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Purchase_Dt (type: esriFieldTypeString, alias: Purchase_Dt, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Tap (type: esriFieldTypeString, alias: Tap, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Configuration (type: esriFieldTypeString, alias: Configuration, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [radial: radial], [feed-thru: feed-thru], [radial with feed-thru added: radial with feed-thru added], ... 1 more ...)
Templates:
Name: Transformer_04232025
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Enabled: 1
- SubtypeCD: 2
- ConstructionStatus: 5
- SymbolRotation: 0
- LocationType: SVC
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/23/2025 5:06:07 PM
Schema Last Edit Date: 4/23/2025 5:06:07 PM
Data Last Edit Date: 4/23/2025 5:06:07 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat