View In:   ArcGIS Online Map Viewer

Name: PW_Streetlights

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Streetlight poles as located by Siemens and delivered to the city on 10/1/2019. Data was joined to existing PW_Streetlight_Poles layer (from APS) and fields containing links to asset photographs were brought over.

Service Item Id: a46a691a550e4153a7a0d7f24582b399

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 412464.7880577445
YMin: 592426.8700787425
XMax: 486388.7906824164
YMax: 629900.787073493
Spatial Reference: 2224  (2224)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [101, 53, 173, 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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Num ( type: esriFieldTypeDouble, alias: Num, editable: true, nullable: true, defaultValue: null, modelName: Num )
• LightType ( type: esriFieldTypeString, alias: LightType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LightType )
• DualHead ( type: esriFieldTypeString, alias: DualHead, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DualHead )
• PostWattage ( type: esriFieldTypeDouble, alias: PostWattage, editable: true, nullable: true, defaultValue: null, modelName: PostWattage )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Description )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• StreetName ( type: esriFieldTypeString, alias: StreetName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetName )
• APSPoleNum ( type: esriFieldTypeString, alias: APSPoleNum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: APSPoleNum )
• PoleNumTBA ( type: esriFieldTypeString, alias: PoleNumTBA, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleNumTBA )
• PoleNumOnPole ( type: esriFieldTypeString, alias: PoleNumOnPole, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleNumOnPole )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• InstallationNotes ( type: esriFieldTypeString, alias: InstallationNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InstallationNotes )
• Voltage ( type: esriFieldTypeString, alias: Voltage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Voltage )
• IndexNum ( type: esriFieldTypeDouble, alias: IndexNum, editable: true, nullable: true, defaultValue: null, modelName: IndexNum )
• Zone_ ( type: esriFieldTypeDouble, alias: Zone_, editable: true, nullable: true, defaultValue: null, modelName: Zone_ )
• MapPage ( type: esriFieldTypeString, alias: MapPage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MapPage )
• LampType ( type: esriFieldTypeString, alias: LampType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LampType )
• PoleType ( type: esriFieldTypeString, alias: PoleType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleType )
• FoundationType ( type: esriFieldTypeString, alias: FoundationType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FoundationType )
• PoleHeight ( type: esriFieldTypeDouble, alias: PoleHeight, editable: true, nullable: true, defaultValue: null, modelName: PoleHeight )
• ArmLength ( type: esriFieldTypeDouble, alias: ArmLength, editable: true, nullable: true, defaultValue: null, modelName: ArmLength )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Owner )
• Subdivision ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Subdivision )
• FunctionalClass ( type: esriFieldTypeString, alias: FunctionalClass, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FunctionalClass )
• Ycoordinate ( type: esriFieldTypeDouble, alias: Ycoordinate, editable: true, nullable: true, defaultValue: null, modelName: Ycoordinate )
• Xcoordinate ( type: esriFieldTypeDouble, alias: Xcoordinate, editable: true, nullable: true, defaultValue: null, modelName: Xcoordinate )
• CityLightID ( type: esriFieldTypeString, alias: CityLightID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CityLightID )
• CityPoleID ( type: esriFieldTypeString, alias: CityPoleID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CityPoleID )
• CityAddress ( type: esriFieldTypeString, alias: CityAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CityAddress )
• CityEquipment ( type: esriFieldTypeString, alias: CityEquipment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CityEquipment )
• FunctionalClass20180919 ( type: esriFieldTypeString, alias: FunctionalClass20180919, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FunctionalClass20180919 )
• F46 ( type: esriFieldTypeString, alias: F46, editable: true, nullable: true, length: 255, defaultValue: null, modelName: F46 )
• F47 ( type: esriFieldTypeString, alias: F47, editable: true, nullable: true, length: 255, defaultValue: null, modelName: F47 )
• F48 ( type: esriFieldTypeString, alias: F48, editable: true, nullable: true, length: 255, defaultValue: null, modelName: F48 )
• F49 ( type: esriFieldTypeString, alias: F49, editable: true, nullable: true, length: 255, defaultValue: null, modelName: F49 )
• F50 ( type: esriFieldTypeString, alias: F50, editable: true, nullable: true, length: 255, defaultValue: null, modelName: F50 )
• CityPoleID_1 ( type: esriFieldTypeString, alias: CityPoleID_1, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: CityPoleID )
• PicturePoleBase ( type: esriFieldTypeString, alias: PicturePoleBase, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: PicturePoleBase )
• PicturePoleNumber ( type: esriFieldTypeString, alias: PicturePoleNumber, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: PicturePoleNumber )
• General ( type: esriFieldTypeString, alias: General, editable: true, nullable: true, length: 2048, defaultValue: null, modelName: General )
• LucityAutoID ( type: esriFieldTypeInteger, alias: Link to Lucity, editable: true, nullable: true, defaultValue: null, modelName: LucityAutoID )
• InLucity ( type: esriFieldTypeSmallInteger, alias: In Lucity?, editable: true, nullable: true, defaultValue: 0, modelName: InLucity )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LastModBy )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModDate )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastSynDate )
• AltPoleID ( type: esriFieldTypeString, alias: Alt Pole ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PL_NUM )
• LightID ( type: esriFieldTypeString, alias: Streetlight AltID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LightID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 50, 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: 50, 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 )

Templates:

• Name: PW_Streetlights
  Description:
  Prototype:
  ArmLength: null
  LucityAutoID: null
  LightID: null
  Num: null
  LightType: null
  DualHead: null
  PostWattage: null
  Description: null
  Address: null
  StreetName: null
  APSPoleNum: null
  PoleNumTBA: null
  PoleNumOnPole: null
  InstallationDate: null
  InstallationNotes: null
  Voltage: null
  IndexNum: null
  Zone_: null
  MapPage: null
  LampType: null
  PoleType: null
  FoundationType: null
  PoleHeight: null
  Owner: City of Yuma
  Subdivision: null
  FunctionalClass: null
  Ycoordinate: null
  Xcoordinate: null
  CityLightID: null
  CityPoleID: null
  CityAddress: null
  CityEquipment: null
  FunctionalClass20180919: null
  F46: null
  F47: null
  F48: null
  F49: null
  F50: null
  CityPoleID_1: null
  PicturePoleBase: null
  PicturePoleNumber: null
  General: null
  InLucity: 1
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  AltPoleID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata