Name: StreetLights_NRLP_ASU_Clip
Display Field: FacilityID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: 2/10/2021 Major update Eggers, Holder, and Stamey, fieldwork 8/2/2019 - 10/27/2020, using collector, no images were taken. Areas studied: C22, D22, D23, C25, D25, F21, G21, G22, H10, H11, I10, I11, I12, I13, J13, J12, J21, K19, K20, K21, K22, K23, K24, K25, K26, L18, L21, M20, M21, L23, L24, M23, M24, M25,M26, N23, N24, N25, and N26. Link to raw Data10/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 Eddie3/20/2020 Made a copy to this feature class, removed non old features form the Leon Levine building updated images as requested by Art Rex.7/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 Surveyers. 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. 11/302017 added to the SDE.11/29/17 Matthew Makdad, deleted unnecessary features from the NRLP poles and merged them to streetlight feature class making this new streetlight feature class. He did this using in house spreadsheets from Scott Eggers and Diana Wilcox. He had difficulty using ARC 10.4 because it does not have the functionality of ARC 10.5.1 so we repeated the procedure on my computer with success. There are now 1983 streetlights. He has ask the remaining streetlight feature class be renamed StreetLight_Rochester.9/28/2017 Edward Hyle, Changed light name as requested from cobra head safety light to cobra head light. Also removed the lights from the old Broyhill Inn site.9/27/2017 Met with Duane Reese in Sanford Mall today and he showed me were the WIFI fiber and one underground secondary power line was located. The electric power line is (2) 120 volt circuits #10 THHN. The fiber in the middle of the Mall is 6-strand fiber that runs to the electrical manhole and goes into IG Greer. The other WIFI connected on all buildings is CAT 5 cable. Explanation two 1-inch conduits go through the middle of the mall depth unknown. A ¾-inch conduit goes from the Sternberg to a manhole in the wide walk then to IG Greer. Collector was used for geolocation with images.Edited Streetlights, removed duplicates, add missing with NRLP poles, and added attribution just around ASU properties.9/05/2017 Images were attached to 1273 of the 1290 points that came from Rochester’s many folders a python script was run to place all images into an organized folder. Ownership has been assigned to the known 728 points, (ASU Sternberg lights). Two duplicate images have been omitted. 8/23/2017 Ready to attach the 1275 Rochester images to this feature class that now contains 1290 points.3/4/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.The definition of a light pole in this dataset is any outside light used for safety lighting as well as accent lighting. Examples of different styles of lights in this dataset are: New River Light and Power cobra head street lights, Appalachian State University Physical Plant Sternberg lights, various landscape accent lights, and other vertical style safety lights which can be viewed along the crosstie steps descending from Greenwood Parking lot, and behind Frank Residence Hall. In this dataset 1292 light poles were gelocated between 8/19/2014 and 11/20/2014 all but 5 were photographed. 392 of the 1292 light poles are not dated. The following columns are blank: owner, install_yr, and source. The id column has one comment: NRS. The comments column has limited comments, they are: NR5313, NR5310, L2501C, L2501B, K2608P, K2608N, K2608M, K2608L, K2608K, K2608H, K2608G, K2605F, K2605D, K2605C, K2605B, J2130C, (2), J2130C, F1716B, AREA UNDER CON., 168820, 168818, and 168817.Updated 08/09/2016 by Edward Hyle all lighting features now have a name and ownership. The duplicated light pole points have been deleted.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: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 1207830.89348431
YMin: 903047.769883141
XMax: 1212848.37688763
YMax: 907409.353351563
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":"uniqueValue","field1":"SubtypeCD","field2":null,"field3":null,"defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[40,143,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,146,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"3","label":"Area Light","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[32,161,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"4","label":"Other","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,3,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"2","label":"Parking Lot Light","description":""},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[115,168,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"1","label":"Streetlight","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}
HasZ: true
HasM: true
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: SubtypeCD
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])
- SubtypeCD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FacilityID (type: esriFieldTypeString, alias: AIM ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- 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: AIM Workorder, 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)
- NominalVoltage (type: esriFieldTypeInteger, alias: NominalVoltage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [10: 120 V], [20: 120/208 V], [30: 120/240 V], ... 2 more ...)
- BallastType (type: esriFieldTypeString, alias: Ballast Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [HPF: High Power Factor], [NPF: Normal Power Factor])
- FixtureSupport (type: esriFieldTypeString, alias: Fixture Support, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Cobra: Cobra], [Other: Other], [Secu: Security], ... 1 more ...)
- LampType (type: esriFieldTypeString, alias: Lamp Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [FLUO: Fluorescent], [HPS: High Pressure Sodium], [INC: Incandescent], ... 4 more ...)
- LensType (type: esriFieldTypeString, alias: Lens Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [DIF: Diffuser], [RFL: Reflector], [RFR: Refractor])
- LightCount (type: esriFieldTypeInteger, alias: Light Count, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
- LightStyle (type: esriFieldTypeString, alias: Light Style, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Other: Other], [Ornam: Ornamental Light], [Stand: Standard], ... 1 more ...)
- MountHeight (type: esriFieldTypeSmallInteger, alias: Mount Height, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [25: 25], [30: 30], [35: 35], ... 11 more ...)
- Ownership (type: esriFieldTypeString, alias: LT_Owner2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [NRLP: New River Light & Power], [ASU: Appalachain State University], [TOB: Town of Boone], ... 3 more ...)
- PhotocellType (type: esriFieldTypeString, alias: Photocell Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [BUT: Button], [NTL: Nema Twist Lock], [NONE: None])
- Shielding (type: esriFieldTypeString, alias: Shielding Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
- StreetLightRole (type: esriFieldTypeString, alias: Streetlight Role, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [AL: Area Light], [COM: Commercial Area Lighting], [FPL: Family Protective Light], ... 5 more ...)
- TimeControl (type: esriFieldTypeString, alias: Time Control Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
- SupportStructureObjectID (type: esriFieldTypeInteger, alias: SupportStructureObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HFrameObjectID (type: esriFieldTypeInteger, alias: HFrameObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONSTRUCTIONTYPE (type: esriFieldTypeString, alias: CONSTRUCTIONTYPE, SQL Type: sqlTypeOther, length: 50, 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)
- 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)
- LIGHT_TYPE (type: esriFieldTypeString, alias: LIGHT_TYPE, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Cobra Head Light: Cobra Head Light], [Emergency Siren: Emergency Siren], [Landscape Accent Light: Landscape Accent Light], ... 4 more ...)
- 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)
- ROC_COMMENTS (type: esriFieldTypeString, alias: ROC_COMMENTS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ACCURACY (type: esriFieldTypeString, alias: ACCURACY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- 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)
- OWNER_1 (type: esriFieldTypeString, alias: OWNER_1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NRLP: NRLP], [ASU: ASU], [TOB: TOB], ... 7 more ...)
- PID (type: esriFieldTypeString, alias: PID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- UNIQUEID (type: esriFieldTypeString, alias: UNIQUEID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LAYER (type: esriFieldTypeString, alias: LAYER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SOURCE (type: esriFieldTypeSmallInteger, alias: SOURCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GRID_ID (type: esriFieldTypeString, alias: GRID_ID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- OWNER_2 (type: esriFieldTypeString, alias: OWNER_2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [NRLP: NRLP], [ASU: ASU], [TOB: TOB], ... 7 more ...)
- Wattage (type: esriFieldTypeDouble, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [50: 50 W], [80: 80 W], [100: 100 W], ... 13 more ...)
Types:
ID: 3
Name: Area Light
Domains:
- Field Name: Enabled
Inherited
- Field Name: ConstructionStatus
Inherited
- Field Name: NominalVoltage
Inherited
- Field Name: BallastType
Inherited
- Field Name: FixtureSupport
Inherited
- Field Name: LampType
Inherited
- Field Name: LensType
Inherited
- Field Name: LightCount
Coded Values:[1, 4]
- Field Name: LightStyle
Inherited
- Field Name: MountHeight
Inherited
- Field Name: Ownership
Inherited
- Field Name: PhotocellType
Inherited
- Field Name: Shielding
Inherited
- Field Name: StreetLightRole
Inherited
- Field Name: TimeControl
Inherited
- Field Name: LIGHT_TYPE
Inherited
- Field Name: OWNER_1
Inherited
- Field Name: OWNER_2
Inherited
- Field Name: Wattage
Inherited
Templates:
Name: Area Light
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Enabled: 1
- Shielding: Y
- StreetLightRole: AL
- SubtypeCD: 3
- ConstructionStatus: 5
- BallastType: NPF
- TimeControl: N
- SOURCE: 0
ID: 4
Name: Other
Domains:
- Field Name: Enabled
Inherited
- Field Name: ConstructionStatus
Inherited
- Field Name: NominalVoltage
Inherited
- Field Name: BallastType
Inherited
- Field Name: FixtureSupport
Inherited
- Field Name: LampType
Inherited
- Field Name: LensType
Inherited
- Field Name: LightCount
Inherited
- Field Name: LightStyle
Inherited
- Field Name: MountHeight
Inherited
- Field Name: Ownership
Inherited
- Field Name: PhotocellType
Inherited
- Field Name: Shielding
Inherited
- Field Name: StreetLightRole
Inherited
- Field Name: TimeControl
Inherited
- Field Name: LIGHT_TYPE
Inherited
- Field Name: OWNER_1
Inherited
- Field Name: OWNER_2
Inherited
- Field Name: Wattage
Inherited
Templates:
Name: Other
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Enabled: 1
- Shielding: Y
- StreetLightRole: AL
- SubtypeCD: 4
- ConstructionStatus: 5
- BallastType: NPF
- TimeControl: N
- SOURCE: 0
ID: 2
Name: Parking Lot Light
Domains:
- Field Name: Enabled
Inherited
- Field Name: ConstructionStatus
Inherited
- Field Name: NominalVoltage
Inherited
- Field Name: BallastType
Inherited
- Field Name: FixtureSupport
Inherited
- Field Name: LampType
Inherited
- Field Name: LensType
Inherited
- Field Name: LightCount
Coded Values:[1, 4]
- Field Name: LightStyle
Inherited
- Field Name: MountHeight
Inherited
- Field Name: Ownership
Inherited
- Field Name: PhotocellType
Inherited
- Field Name: Shielding
Inherited
- Field Name: StreetLightRole
Inherited
- Field Name: TimeControl
Inherited
- Field Name: LIGHT_TYPE
Inherited
- Field Name: OWNER_1
Inherited
- Field Name: OWNER_2
Inherited
- Field Name: Wattage
Inherited
Templates:
Name: Parking Lot Light
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Enabled: 1
- Shielding: Y
- StreetLightRole: AL
- SubtypeCD: 2
- ConstructionStatus: 5
- BallastType: NPF
- TimeControl: N
- SOURCE: 0
ID: 1
Name: Streetlight
Domains:
- Field Name: Enabled
Inherited
- Field Name: ConstructionStatus
Inherited
- Field Name: NominalVoltage
Inherited
- Field Name: BallastType
Inherited
- Field Name: FixtureSupport
Inherited
- Field Name: LampType
Inherited
- Field Name: LensType
Inherited
- Field Name: LightCount
Coded Values:[1, 4]
- Field Name: LightStyle
Inherited
- Field Name: MountHeight
Inherited
- Field Name: Ownership
Inherited
- Field Name: PhotocellType
Inherited
- Field Name: Shielding
Inherited
- Field Name: StreetLightRole
Inherited
- Field Name: TimeControl
Inherited
- Field Name: LIGHT_TYPE
Inherited
- Field Name: OWNER_1
Inherited
- Field Name: OWNER_2
Inherited
- Field Name: Wattage
Inherited
Templates:
Name: Streetlight
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Enabled: 1
- Shielding: Y
- StreetLightRole: AL
- SubtypeCD: 1
- ConstructionStatus: 5
- BallastType: NPF
- TimeControl: N
- SOURCE: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/21/2022 9:15:08 PM
Schema Last Edit Date: 3/21/2022 9:15:08 PM
Data Last Edit Date: 3/21/2022 9:15:08 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat