View In:   ArcGIS Online Web Map

Name: Street Lights

Display Field: LOC_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer contains the data for the street lights for the Transportation Department in the City of Round Rock, located in Williamson County, Texas. This layer is part of an orignal dataset provided and maintained by the City of Round Rock GIS/IT Department and the Planning and Development Services Department. The data in this layer are represented as points.A street light is the large lamp post situated at the edges of roads for the purpose of providing light to the surrounding areas at night or when it is dark outside. This layer includes only street lights that are in and around the downtown Round Rock area.The City of Round Rock currently has 221 street lights in this layer.

Service Item Id: fc0f22866afb4a47b29c14102b0843ab

Copyright Text: City of Round Rock GIS/IT and PDS Departments

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 3089305.9185379744
YMin: 1.0138985021459058E7
XMax: 3164393.005568221
YMax: 1.0189388724457234E7
Spatial Reference: 102739  (2277)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [108, 160, 78, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• UID ( type: esriFieldTypeString, alias: UID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UID )
• RR_ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 130, defaultValue: null, modelName: ADDRESS )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOCATION )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• FIELD_PN ( type: esriFieldTypeString, alias: Field Pole Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FIELD_PN )
• ADDTNL_PN ( type: esriFieldTypeString, alias: Additional Field Pole Numbers, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ADDTNL_PN )
• UTIL_PN ( type: esriFieldTypeString, alias: Utility Pole Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UTIL_PN )
• FIXTURTYPE ( type: esriFieldTypeString, alias: Fixture Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FIXTURTYPE , Coded Values: [Antique: Antique] , [Bollard: Bollard] , [Cobra: Cobra Head] , ...5 more... )
• LAMPTYPE ( type: esriFieldTypeString, alias: Current Lamp Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LAMPTYPE , Coded Values: [HPS: HPS] , [INC: INC] , [LED: LED] , ...3 more... )
• OLDWATT ( type: esriFieldTypeString, alias: Current Wattage, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OLDWATT )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OWNERSHIP , Coded Values: [CORR: CORR] , [Georgetown: Georgetown] , [HOA: HOA] , ...5 more... )
• ISSUES ( type: esriFieldTypeString, alias: Field Issues, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ISSUES )
• AUDIT_DATE ( type: esriFieldTypeString, alias: Audit Date, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AUDIT_DATE )
• HEADS ( type: esriFieldTypeString, alias: Number of Heads on Pole, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: HEADS , Coded Values: [Single: Single] , [Twin: Twin] , [Triple: Triple] , ...2 more... )
• ALONEVDIST ( type: esriFieldTypeString, alias: Standalone or Distribution, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ALONEVDIST )
• FEED ( type: esriFieldTypeString, alias: Feed Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FEED , Coded Values: [Underground: Powered Undereground] , [Overhead: Powered Overhead] , [Solar: Solar] )
• POLEMAT ( type: esriFieldTypeString, alias: Pole Material, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: POLEMAT , Coded Values: [Alum: Aluminum] , [CastIron: Cast Iron] , [Cement: Cement] , ...5 more... )
• ARM_LENGTH ( type: esriFieldTypeString, alias: Arm Length, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ARM_LENGTH , Coded Values: [1: 1 ft] , [2: 2-4 ft] , [3: 5-7 ft] , ...3 more... )
• ARM_DIR ( type: esriFieldTypeString, alias: Arm Angle, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ARM_DIR , Coded Values: [45: 45 degree] , [90: 90 degree] , [DoesNotLight: Fixture Does Not Light Street] , ...2 more... )
• MOUNT_HT ( type: esriFieldTypeString, alias: Mounting Height, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: MOUNT_HT )
• STREETDESN ( type: esriFieldTypeString, alias: Street Design, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STREETDESN , Coded Values: [Culdesac: Cul-de-sac] , [DeadEnd: Dead End] , [Donut: Donut] , ...5 more... )
• CROSSWALK ( type: esriFieldTypeString, alias: Crosswalk, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CROSSWALK , Coded Values: [Yes: Yes] , [No: No] )
• LT_SHIELD ( type: esriFieldTypeString, alias: Light Shield, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LT_SHIELD )
• LOC_NAME ( type: esriFieldTypeString, alias: Additional Scope Location Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LOC_NAME )
• UTIL_ADDR ( type: esriFieldTypeString, alias: Utility Address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UTIL_ADDR )
• APPRX_ADDR ( type: esriFieldTypeString, alias: Approximate Address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: APPRX_ADDR )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LAT_LONG ( type: esriFieldTypeString, alias: Latitude, Longitude, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LAT_LONG )
• TANKO_ID ( type: esriFieldTypeInteger, alias: Tanko ID, editable: true, nullable: true, defaultValue: null, modelName: TANKO_ID )
• AUDITED_BY ( type: esriFieldTypeString, alias: Audited By, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AUDITED_BY )
• MTN_OSHIP ( type: esriFieldTypeString, alias: Maintenance Ownership, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MTN_OSHIP , Coded Values: [CORR: CORR] , [Georgetown: Georgetown] , [HOA: HOA] , ...5 more... )
• PHOTO_1 ( type: esriFieldTypeString, alias: Photo 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_1 )
• PHOTO_2 ( type: esriFieldTypeString, alias: Photo 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_2 )
• PHOTO_3 ( type: esriFieldTypeString, alias: PHOTO_3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_3 )
• PHOTO_4 ( type: esriFieldTypeString, alias: Photo 4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_4 )
• PHOTO_5 ( type: esriFieldTypeString, alias: Photo 5, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_5 )
• PHOTO_6 ( type: esriFieldTypeString, alias: Photo 6, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PHOTO_6 )
• LED_RANGE ( type: esriFieldTypeString, alias: LED Wattage Range, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LED_RANGE )
• FixtureTypeBackup ( type: esriFieldTypeString, alias: Fixture Type with Domain, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FixtureTypeBackup , Coded Values: [Antique: Antique] , [Bollard: Bollard] , [Cobra: Cobra Head] , ...5 more... )
• StreetDesnBackup ( type: esriFieldTypeString, alias: Street Design Backup, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetDesnBackup )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Voltage ( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Voltage , Coded Values: [120v: 120v] , [240v: 240v] , [480v: 480v] )
• AuditDate ( type: esriFieldTypeDate, alias: AuditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AuditDate )

Templates:

• Name: Street Lights
  Description:
  Prototype:
  Voltage: null
  AuditDate: null
  UID: null
  RR_ADDRESS: null
  LOCATION: null
  INSTALL_DATE: null
  StreetDesnBackup: null
  FixtureTypeBackup: null
  LED_RANGE: null
  PHOTO_6: null
  FIELD_PN: null
  ADDTNL_PN: null
  UTIL_PN: null
  FIXTURTYPE: null
  LAMPTYPE: null
  OLDWATT: null
  OWNERSHIP: null
  ISSUES: null
  AUDIT_DATE: null
  HEADS: null
  ALONEVDIST: null
  FEED: null
  POLEMAT: null
  ARM_LENGTH: null
  ARM_DIR: null
  MOUNT_HT: null
  STREETDESN: null
  CROSSWALK: null
  LT_SHIELD: null
  LOC_NAME: null
  UTIL_ADDR: null
  APPRX_ADDR: null
  LATITUDE: null
  LONGITUDE: null
  LAT_LONG: null
  TANKO_ID: null
  AUDITED_BY: null
  MTN_OSHIP: null
  PHOTO_1: null
  PHOTO_2: null
  PHOTO_3: null
  PHOTO_4: null
  PHOTO_5: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata