View In:   ArcGIS Online Map Viewer

Name: SoCalProjects.DBO.wejo_speed_data

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Speed Summaries: Daily Average Observed Speed, Weekday Daily Average Observed Speed, Weekday AM Peak Period Average Observed Speed (6AM to 9AM), Weekday Midday Average Observed Speed (9PM to 4PM), Weekday PM Peak Period Average Observed Speed (4PM to 7PM), Weekday Evening/Early Morning Average Observed Speed (7PM to 6AM), Weekend Daily Average Observed Speed, </SPAN></P><P><SPAN>Event Summaries: Weekend Average Observed Parking Duration, Weekday Average Observed Parking Duration, Number of Excessive Speeding Events, Number of Hard Acceleration Events, Number of Harsh Braking Events</SPAN></P><P><SPAN /></P><P><SPAN /></P></DIV></DIV></DIV>

Service Item Id: be3f4c9e2e1740b5a0dff4df7883259e

Copyright Text: Data processed from October 2022 Please use the invoicing app to pay for data use: https://apps.powerapps.com/play/e/default-087dca4b-49c7-42c6-a766-49a3f29fc3f4/a/182e564f-38d6-4abc-9fff-1c5a17d8324b?tenantId=087dca4b-49c7-42c6-a766-49a3f29fc3f4&source=portal&skipmetadata=true# Contact Information - Data Steward: • Name (Patrick McDonough) • Position (Database Engineer) • Fehr & Peers • Office address (1013 Galleria Boulevard Suite 255 Roseville, CA 95678) • E-mail: (p.mcdonough@fehrandpeers.com ) • Phone: (925-977-3251)

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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: 6449038.085071132
YMin: 1873929.0978906453
XMax: 6478149.6689082235
YMax: 1907336.4506952316
Spatial Reference: 103007  (6424)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [71, 173, 115, 255]
Width: 1
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• day_of_week ( type: esriFieldTypeString, alias: Day of Week, editable: true, nullable: true, length: 255, defaultValue: null, modelName: day_of_week )
• time_period ( type: esriFieldTypeString, alias: Time Period, editable: true, nullable: true, length: 255, defaultValue: null, modelName: time_period )
• network_id ( type: esriFieldTypeInteger, alias: Network ID, editable: true, nullable: true, defaultValue: null, modelName: network_id )
• osm_id ( type: esriFieldTypeInteger, alias: OSM ID, editable: true, nullable: true, defaultValue: null, modelName: osm_id )
• roadway_azimuth ( type: esriFieldTypeDouble, alias: Azimuth of Roadway, editable: true, nullable: true, defaultValue: null, modelName: roadway_azimuth )
• direction_of_travel ( type: esriFieldTypeString, alias: Direction of Travel, editable: true, nullable: true, length: 255, defaultValue: null, modelName: direction_of_travel )
• name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: name )
• num_lanes ( type: esriFieldTypeInteger, alias: # Lanes, editable: true, nullable: true, defaultValue: null, modelName: num_lanes )
• total_n_obs ( type: esriFieldTypeInteger, alias: Total # of GPS Observations, editable: true, nullable: true, defaultValue: null, modelName: total_n_obs )
• total_n_trips ( type: esriFieldTypeInteger, alias: Total # of Observed Trips, editable: true, nullable: true, defaultValue: null, modelName: total_n_trips )
• total_obs_time ( type: esriFieldTypeDouble, alias: Total Duration of All Observations (Minutes), editable: true, nullable: true, defaultValue: null, modelName: total_obs_time )
• n_moving_obs ( type: esriFieldTypeInteger, alias: # of Moving GPS Observations, editable: true, nullable: true, defaultValue: null, modelName: n_moving_obs )
• n_moving_trips ( type: esriFieldTypeInteger, alias: # of Moving Trips, editable: true, nullable: true, defaultValue: null, modelName: n_moving_trips )
• obs_moving_distance ( type: esriFieldTypeInteger, alias: Observed Moving Trip Distance (Feet), editable: true, nullable: true, defaultValue: null, modelName: obs_moving_distance )
• obs_moving_duration ( type: esriFieldTypeInteger, alias: Observed Moving Trip Duration (Minutes), editable: true, nullable: true, defaultValue: null, modelName: obs_moving_duration )
• mean_speed ( type: esriFieldTypeDouble, alias: Average Travel Speed (MPH), editable: true, nullable: true, defaultValue: null, modelName: mean_speed )
• sd_speed ( type: esriFieldTypeDouble, alias: Standard Deviation of Observed Speeds (MPH), editable: true, nullable: true, defaultValue: null, modelName: sd_speed )
• speed_ci_upper ( type: esriFieldTypeDouble, alias: Upper Bound of the 95% C.I. Observed Speeds (MPH), editable: true, nullable: true, defaultValue: null, modelName: speed_ci_upper )
• speed_ci_lower ( type: esriFieldTypeDouble, alias: Lower Bound of the 95% C.I. Observed Speeds (MPH), editable: true, nullable: true, defaultValue: null, modelName: speed_ci_lower )
• min_speed ( type: esriFieldTypeDouble, alias: Min Observed Moving Speed (MPH), editable: true, nullable: true, defaultValue: null, modelName: min_speed )
• speed_5 ( type: esriFieldTypeDouble, alias: 5th Percentile of Observed Speed (MPH), editable: true, nullable: true, defaultValue: null, modelName: speed_5 )
• median_speed ( type: esriFieldTypeDouble, alias: Median Observed Speed (MPH), editable: true, nullable: true, defaultValue: null, modelName: median_speed )
• speed_85 ( type: esriFieldTypeDouble, alias: 85th Percentile Observed Speed (MPH), editable: true, nullable: true, defaultValue: null, modelName: speed_85 )
• speed_95 ( type: esriFieldTypeDouble, alias: 95th Percentile Observed Speed (MPH), editable: true, nullable: true, defaultValue: null, modelName: speed_95 )
• max_speed ( type: esriFieldTypeDouble, alias: Max Observed Speed (MPH), editable: true, nullable: true, defaultValue: null, modelName: max_speed )
• mean_time ( type: esriFieldTypeDouble, alias: Mean Observed Travel Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: mean_time )
• sd_time ( type: esriFieldTypeDouble, alias: Standard Deviation of Observed Travel Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: sd_time )
• median_time ( type: esriFieldTypeDouble, alias: Median Observed Travel Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: median_time )
• planning_time ( type: esriFieldTypeDouble, alias: Planning Time - 95th Percentile Travel Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: planning_time )
• n_stop_obs ( type: esriFieldTypeInteger, alias: # of Stopped GPS Observations, editable: true, nullable: true, defaultValue: null, modelName: n_stop_obs )
• n_stop_trips ( type: esriFieldTypeInteger, alias: # of Stopped Trips, editable: true, nullable: true, defaultValue: null, modelName: n_stop_trips )
• obs_stopped_time ( type: esriFieldTypeDouble, alias: Total Observed Stopped Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: obs_stopped_time )
• mean_stopped_time ( type: esriFieldTypeDouble, alias: Average Stopped Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: mean_stopped_time )
• sd_stopped_time ( type: esriFieldTypeDouble, alias: Standard Deviation of Stopped Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: sd_stopped_time )
• median_stopped_time ( type: esriFieldTypeDouble, alias: Median Stopped Time (Minutes), editable: true, nullable: true, defaultValue: null, modelName: median_stopped_time )
• complete_n_moving_obs ( type: esriFieldTypeInteger, alias: # of Moving GPS Observations From Complete Trips, editable: true, nullable: true, defaultValue: null, modelName: complete_n_moving_obs )
• complete_n_moving_trips ( type: esriFieldTypeInteger, alias: # of Moving Trips From Complete Trips, editable: true, nullable: true, defaultValue: null, modelName: complete_n_moving_trips )
• complete_obs_moving_distance ( type: esriFieldTypeInteger, alias: Observed Moving Trip Distance From Complete Trips (Feet), editable: true, nullable: true, defaultValue: null, modelName: complete_obs_moving_distance )
• complete_obs_moving_duration ( type: esriFieldTypeInteger, alias: Observed Moving Trip Duration From Complete Trips (Minutes), editable: true, nullable: true, defaultValue: null, modelName: complete_obs_moving_duration )
• complete_mean_speed ( type: esriFieldTypeDouble, alias: Average Travel Speed From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_mean_speed )
• complete_sd_speed ( type: esriFieldTypeDouble, alias: Standard Deviation of Observed Speeds From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_sd_speed )
• complete_speed_ci_upper ( type: esriFieldTypeDouble, alias: Upper Bound of the 95% C.I. Observed Speeds From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_speed_ci_upper )
• complete_speed_ci_lower ( type: esriFieldTypeDouble, alias: Lower Bound of the 95% C.I. Observed Speeds From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_speed_ci_lower )
• complete_min_speed ( type: esriFieldTypeDouble, alias: Min Observed Moving Speed From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_min_speed )
• complete_speed_5 ( type: esriFieldTypeDouble, alias: 5th Percentile of Observed Speed From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_speed_5 )
• complete_median_speed ( type: esriFieldTypeDouble, alias: Median Observed Speed From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_median_speed )
• complete_speed_85 ( type: esriFieldTypeDouble, alias: 85th Percentile Observed Speed From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_speed_85 )
• complete_speed_95 ( type: esriFieldTypeDouble, alias: 95th Percentile Observed Speed From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_speed_95 )
• complete_max_speed ( type: esriFieldTypeDouble, alias: Max Observed Speed From Complete Trips (MPH), editable: true, nullable: true, defaultValue: null, modelName: complete_max_speed )
• complete_mean_time ( type: esriFieldTypeDouble, alias: Mean Observed Travel Time From Complete Trips (Minutes), editable: true, nullable: true, defaultValue: null, modelName: complete_mean_time )
• complete_sd_time ( type: esriFieldTypeDouble, alias: Standard Deviation of Observed Travel Time From Complete Trips (Minutes), editable: true, nullable: true, defaultValue: null, modelName: complete_sd_time )
• complete_median_time ( type: esriFieldTypeDouble, alias: Median Observed Travel Time From Complete Trips (Minutes), editable: true, nullable: true, defaultValue: null, modelName: complete_median_time )
• complete_planning_time ( type: esriFieldTypeDouble, alias: Planning Time - 95th Percentile Travel Time From Complete Trips (Minutes), editable: true, nullable: true, defaultValue: null, modelName: complete_planning_time )
• state_name ( type: esriFieldTypeString, alias: state_name, editable: true, nullable: true, length: 512, defaultValue: null, modelName: state_name )
• county_name ( type: esriFieldTypeString, alias: county_name, editable: true, nullable: true, length: 512, defaultValue: null, modelName: county_name )
• osm_highway_tag ( type: esriFieldTypeString, alias: osm_highway_tag, editable: true, nullable: true, length: 255, defaultValue: null, modelName: osm_highway_tag )
• Bucket ( type: esriFieldTypeInteger, alias: Bucket, editable: true, nullable: true, defaultValue: null, modelName: Bucket )
• Speed_Bucket_v2 ( type: esriFieldTypeInteger, alias: Speed_Bucket_v2, editable: true, nullable: true, defaultValue: null, modelName: Speed_Bucket_v2 )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )

Templates:

• Name: SoCalProjects.DBO.wejo_speed_data
  Description:
  Prototype:
  Speed_Bucket_v2: null
  Bucket: null
  day_of_week: null
  time_period: null
  network_id: null
  osm_id: null
  roadway_azimuth: null
  direction_of_travel: null
  name: null
  num_lanes: null
  total_n_obs: null
  total_n_trips: null
  total_obs_time: null
  n_moving_obs: null
  n_moving_trips: null
  obs_moving_distance: null
  obs_moving_duration: null
  mean_speed: null
  sd_speed: null
  speed_ci_upper: null
  speed_ci_lower: null
  min_speed: null
  speed_5: null
  median_speed: null
  speed_85: null
  speed_95: null
  max_speed: null
  mean_time: null
  sd_time: null
  median_time: null
  planning_time: null
  n_stop_obs: null
  n_stop_trips: null
  obs_stopped_time: null
  mean_stopped_time: null
  sd_stopped_time: null
  median_stopped_time: null
  complete_n_moving_obs: null
  complete_n_moving_trips: null
  complete_obs_moving_distance: null
  complete_obs_moving_duration: null
  complete_mean_speed: null
  complete_sd_speed: null
  complete_speed_ci_upper: null
  complete_speed_ci_lower: null
  complete_min_speed: null
  complete_speed_5: null
  complete_median_speed: null
  complete_speed_85: null
  complete_speed_95: null
  complete_max_speed: null
  complete_mean_time: null
  complete_sd_time: null
  complete_median_time: null
  complete_planning_time: null
  state_name: null
  county_name: null
  osm_highway_tag: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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