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: 3205bec891c14960ab3417294c22738d

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: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata