View In:   ArcGIS Online Map Viewer

Name: Streetlights

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0bcee5d07c2d487c9a213a70a2423f1b

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: 437785.3289850503
YMin: 217518.82602605224
XMax: 593569.6187938005
YMax: 311756.1867635548
Spatial Reference: 103779  (103779)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [160, 59, 121, 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: true

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 )
• assetid ( type: esriFieldTypeString, alias: Streetlight ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• type ( type: esriFieldTypeString, alias: Fixture Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: type , Coded Values: [Cobra Head: Cobra Head] , [Shoebox: Shoebox] , [High Mast: High Mast] , ...6 more... )
• bulbtype ( type: esriFieldTypeString, alias: Bulb Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: bulbtype , Coded Values: [LED: LED] , [HPS: High Pressure Sodium] , [LPS: Low Pressure Sodium] , ...3 more... )
• smartlight ( type: esriFieldTypeString, alias: Smart Light, editable: true, nullable: true, length: 5, defaultValue: null, modelName: smartlight , Coded Values: [Yes: Yes] , [No: No] )
• wattage ( type: esriFieldTypeString, alias: Wattage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wattage )
• manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: manufacturer )
• warrantydate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: warrantydate )
• outage ( type: esriFieldTypeString, alias: Outage, editable: true, nullable: true, length: 5, defaultValue: null, modelName: outage , Coded Values: [0: Outage] , [1: Operational] )
• facingdirection ( type: esriFieldTypeString, alias: Facing Direction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: facingdirection , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• lateraloffset ( type: esriFieldTypeDouble, alias: Lateral Offset, editable: true, nullable: true, defaultValue: null, modelName: lateraloffset )
• latoffsetunits ( type: esriFieldTypeString, alias: Lateral Offset Units, editable: true, nullable: true, length: 20, defaultValue: null, modelName: latoffsetunits , Coded Values: [MI: Miles] , [KM: Kilometers] , [FT: Feet] , ...3 more... )
• mountheight ( type: esriFieldTypeDouble, alias: Mounting Height, editable: true, nullable: true, defaultValue: null, modelName: mountheight )
• mountunits ( type: esriFieldTypeString, alias: Mounting Height Units, editable: true, nullable: true, length: 20, defaultValue: null, modelName: mountunits , Coded Values: [MI: Miles] , [KM: Kilometers] , [FT: Feet] , ...3 more... )
• locdesc ( type: esriFieldTypeString, alias: Nearest Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: locdesc )
• municipality ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 150, defaultValue: null, modelName: municipality , Coded Values: [Baldwin Township: Baldwin Township] , [Becker: Becker] , [Becker Township: Becker Township] , ...13 more... )
• district ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 150, defaultValue: null, modelName: district )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: ownedby , Coded Values: [1: Our Agency] , [2: Private] , [3: Other] )
• maintainedby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: maintainedby , Coded Values: [1: Our Agency] , [2: Private] , [3: Other] )
• collectedby ( type: esriFieldTypeSmallInteger, alias: Collected By, editable: true, nullable: true, defaultValue: null, modelName: collectedby , Coded Values: [1: Our Agency] , [2: Private] , [3: Other] )
• inspectdate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspectdate )
• condition ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: condition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...3 more... )
• maintenance ( type: esriFieldTypeString, alias: Needs Maintenance, editable: true, nullable: true, length: 5, defaultValue: null, modelName: maintenance , Coded Values: [Yes: Yes] , [No: No] )
• replacement ( type: esriFieldTypeString, alias: Needs Replacement, editable: true, nullable: true, length: 5, defaultValue: null, modelName: replacement , Coded Values: [Yes: Yes] , [No: No] )
• retired ( type: esriFieldTypeString, alias: Is Retired, editable: true, nullable: true, length: 5, defaultValue: null, modelName: retired , Coded Values: [Yes: Yes] , [No: No] )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: notes )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• poleglobalid ( type: esriFieldTypeGUID, alias: Pole GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: poleglobalid )
• cabinetglobalid ( type: esriFieldTypeGUID, alias: Cabinet GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: cabinetglobalid )
• esrignss_positionsourcetype ( type: esriFieldTypeSmallInteger, alias: Position source type, editable: true, nullable: true, defaultValue: null, modelName: esrignss_positionsourcetype )
• esrignss_receiver ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: esrignss_receiver )
• esrignss_latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_latitude )
• esrignss_longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_longitude )
• esrignss_altitude ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_altitude )
• esrignss_h_rms ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_h_rms )
• esrignss_v_rms ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_v_rms )
• esrignss_fixdatetime ( type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: esrignss_fixdatetime )
• esrignss_fixtype ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: esrignss_fixtype )
• esrignss_correctionage ( type: esriFieldTypeDouble, alias: Correction Age, editable: true, nullable: true, defaultValue: null, modelName: esrignss_correctionage )
• esrignss_stationid ( type: esriFieldTypeSmallInteger, alias: Station ID, editable: true, nullable: true, defaultValue: null, modelName: esrignss_stationid )
• esrignss_numsats ( type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: esrignss_numsats )
• esrignss_pdop ( type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: esrignss_pdop )
• esrignss_hdop ( type: esriFieldTypeDouble, alias: HDOP, editable: true, nullable: true, defaultValue: null, modelName: esrignss_hdop )
• esrignss_vdop ( type: esriFieldTypeDouble, alias: VDOP, editable: true, nullable: true, defaultValue: null, modelName: esrignss_vdop )
• esrignss_direction ( type: esriFieldTypeDouble, alias: Direction of travel (°), editable: true, nullable: true, defaultValue: null, modelName: esrignss_direction )
• esrignss_speed ( type: esriFieldTypeDouble, alias: Speed (km/h), editable: true, nullable: true, defaultValue: null, modelName: esrignss_speed )
• esrisnsr_azimuth ( type: esriFieldTypeDouble, alias: Compass reading (°), editable: true, nullable: true, defaultValue: null, modelName: esrisnsr_azimuth )
• esrignss_avg_h_rms ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_avg_h_rms )
• esrignss_avg_v_rms ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_avg_v_rms )
• esrignss_avg_positions ( type: esriFieldTypeInteger, alias: Averaged Positions, editable: true, nullable: true, defaultValue: null, modelName: esrignss_avg_positions )
• esrignss_h_stddev ( type: esriFieldTypeDouble, alias: Standard Deviation (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_h_stddev )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )

Templates:

• Name: Streetlights
  Description:
  Prototype:
  esrignss_h_stddev: null
  esrignss_avg_positions: null
  assetid: null
  installdate: null
  type: null
  bulbtype: null
  smartlight: null
  wattage: null
  manufacturer: null
  warrantydate: null
  outage: null
  facingdirection: null
  lateraloffset: null
  latoffsetunits: null
  mountheight: null
  mountunits: null
  locdesc: null
  municipality: null
  district: null
  ownedby: null
  maintainedby: null
  collectedby: null
  inspectdate: null
  condition: null
  maintenance: null
  replacement: null
  retired: null
  notes: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  poleglobalid: null
  cabinetglobalid: null
  esrignss_positionsourcetype: null
  esrignss_receiver: null
  esrignss_latitude: null
  esrignss_longitude: null
  esrignss_altitude: null
  esrignss_h_rms: null
  esrignss_v_rms: null
  esrignss_fixdatetime: null
  esrignss_fixtype: null
  esrignss_correctionage: null
  esrignss_stationid: null
  esrignss_numsats: null
  esrignss_pdop: null
  esrignss_hdop: null
  esrignss_vdop: null
  esrignss_direction: null
  esrignss_speed: null
  esrisnsr_azimuth: null
  esrignss_avg_h_rms: null
  esrignss_avg_v_rms: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Streetlight_Maintenance (0) -- Related To: Streetlight_Maintenance (13)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata