View In:   ArcGIS Online Map Viewer

Name: PublicService_OtherUtilities.DBO.iWorQSignage_2024

Display Field: Road_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Midvale City street sign data collected in fall 2024 using iWorq's street scan technology.

Copyright Text:

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: 1523827.34460859
YMin: 7384725.7965756655
XMax: 1541739.8419200033
YMax: 7398325.872393832
Spatial Reference: 102743  (3566)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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 )
• signid ( type: esriFieldTypeSmallInteger, alias: signid, editable: true, nullable: true, defaultValue: null, modelName: signid )
• ogc_fid ( type: esriFieldTypeSmallInteger, alias: ogc_fid, editable: true, nullable: true, defaultValue: null, modelName: ogc_fid )
• wkb_geomet ( type: esriFieldTypeInteger, alias: wkb_geomet, editable: true, nullable: true, defaultValue: null, modelName: wkb_geomet )
• iworqid ( type: esriFieldTypeString, alias: iworqid, editable: true, nullable: true, length: 4, defaultValue: null, modelName: iworqid )
• Loc_ID ( type: esriFieldTypeString, alias: Loc ID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Loc_ID )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MUTCD )
• MUTCD_Description ( type: esriFieldTypeString, alias: MUTCD Description, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MUTCD_Description , Coded Values: [1: Miscellaneous] , [2: Recreation] , [3: Regulatory] , ...3 more... )
• Current_RSL ( type: esriFieldTypeString, alias: Current RSL, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Current_RSL )
• Last_Treatment_Date ( type: esriFieldTypeString, alias: Last Treatment Date, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Last_Treatment_Date )
• Last_Rating_Date ( type: esriFieldTypeString, alias: Last Rating Date, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Last_Rating_Date )
• Recommended_Treatment ( type: esriFieldTypeString, alias: Recommended Treatment, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Recommended_Treatment )
• Background_Reflectivity ( type: esriFieldTypeString, alias: Background Reflectivity, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Background_Reflectivity )
• Value ( type: esriFieldTypeString, alias: Value, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Value )
• iWorQ_Code ( type: esriFieldTypeString, alias: iWorQ Code, editable: true, nullable: true, length: 254, defaultValue: null, modelName: iWorQ_Code )
• Road_Name ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Road_Name )
• From_Address ( type: esriFieldTypeString, alias: From Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: From_Address )
• To_Address ( type: esriFieldTypeString, alias: To Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: To_Address )
• Pole_Type ( type: esriFieldTypeString, alias: Pole Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Pole_Type , Coded Values: [1: 2" Square galvanized] , [2: 4x4 wood] , [3: Break Away Round] , ...2 more... )
• Sign_Facing_Direction ( type: esriFieldTypeString, alias: Sign Facing Direction, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Sign_Facing_Direction , Coded Values: [1: East] , [2: West] , [3: North] , ...5 more... )
• Base_Type ( type: esriFieldTypeString, alias: Base Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Base_Type , Coded Values: [1: Anchor] , [2 : Break Away] , [3: Direct Bury] )
• Latitude ( type: esriFieldTypeString, alias: Latitude, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeString, alias: Longitude, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Longitude )
• Rating_Date ( type: esriFieldTypeString, alias: Rating Date, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Rating_Date )
• Sign_Condition ( type: esriFieldTypeString, alias: Sign Condition, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Sign_Condition )
• Support_Condition ( type: esriFieldTypeString, alias: Support Condition, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Support_Condition )
• 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: 100, 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: 100, 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 )
• TASK ( type: esriFieldTypeString, alias: TASK, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TASK )
• NEW_FIELD ( type: esriFieldTypeString, alias: DUDE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NEW_FIELD )
• NEXT_NEW_FIELD ( type: esriFieldTypeDouble, alias: NEXT NEW FIELD, editable: true, nullable: true, defaultValue: null, modelName: NEXT_NEW_FIELD )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ESRIGNSS_RECEIVER )
• 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_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_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_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• 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 , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_NUMSATS , Range: [0, 99] )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ESRIGNSS_FIXDATETIME )
• 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: esriFieldTypeSmallInteger, 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 )

Templates:

• Name: PublicService_OtherUtilities.DBO.iWorQSignage_2024
  Description:
  Prototype:
  ESRIGNSS_AVG_POSITIONS: null
  signid: null
  ogc_fid: null
  wkb_geomet: null
  iworqid: null
  Loc_ID: null
  MUTCD: null
  MUTCD_Description: null
  Current_RSL: null
  Last_Treatment_Date: null
  Last_Rating_Date: null
  Recommended_Treatment: null
  Background_Reflectivity: null
  Value: null
  iWorQ_Code: null
  Road_Name: null
  From_Address: null
  To_Address: null
  Pole_Type: null
  Sign_Facing_Direction: null
  Base_Type: null
  Latitude: null
  Longitude: null
  Rating_Date: null
  Sign_Condition: null
  Support_Condition: null
  ESRIGNSS_H_STDDEV: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_NUMSATS: null
  TASK: null
  NEW_FIELD: null
  NEXT_NEW_FIELD: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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