{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 34, "name": "SoCalProjects.DBO.wejo_speed_data", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "

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>

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>

<\/P><\/DIV><\/DIV><\/DIV>", "copyrightText": "Data processed from October 2022\nPlease 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#\n\nContact Information - Data Steward:\n\n\u2022 Name (Patrick McDonough)\n\u2022 Position (Database Engineer)\n\u2022 Fehr & Peers\n\u2022 Office address (1013 Galleria Boulevard Suite 255 Roseville, CA 95678)\n\u2022 E-mail: (p.mcdonough@fehrandpeers.com )\n\u2022 Phone: (925-977-3251)", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 6449038.085071132, "ymin": 1873929.0978906453, "xmax": 6478149.6689082235, "ymax": 1907336.4506952316, "spatialReference": { "wkid": 103007, "latestWkid": 6424, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 103007, "latestWkid": 6424, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 71, 173, 115, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "day_of_week", "type": "esriFieldTypeString", "alias": "Day of Week", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "day_of_week" }, { "name": "time_period", "type": "esriFieldTypeString", "alias": "Time Period", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "time_period" }, { "name": "network_id", "type": "esriFieldTypeInteger", "alias": "Network ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "network_id" }, { "name": "osm_id", "type": "esriFieldTypeInteger", "alias": "OSM ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "osm_id" }, { "name": "roadway_azimuth", "type": "esriFieldTypeDouble", "alias": "Azimuth of Roadway", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "roadway_azimuth" }, { "name": "direction_of_travel", "type": "esriFieldTypeString", "alias": "Direction of Travel", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "direction_of_travel" }, { "name": "name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "name" }, { "name": "num_lanes", "type": "esriFieldTypeInteger", "alias": "# Lanes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "num_lanes" }, { "name": "total_n_obs", "type": "esriFieldTypeInteger", "alias": "Total # of GPS Observations", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "total_n_obs" }, { "name": "total_n_trips", "type": "esriFieldTypeInteger", "alias": "Total # of Observed Trips", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "total_n_trips" }, { "name": "total_obs_time", "type": "esriFieldTypeDouble", "alias": "Total Duration of All Observations (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "total_obs_time" }, { "name": "n_moving_obs", "type": "esriFieldTypeInteger", "alias": "# of Moving GPS Observations", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "n_moving_obs" }, { "name": "n_moving_trips", "type": "esriFieldTypeInteger", "alias": "# of Moving Trips", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "n_moving_trips" }, { "name": "obs_moving_distance", "type": "esriFieldTypeInteger", "alias": "Observed Moving Trip Distance (Feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "obs_moving_distance" }, { "name": "obs_moving_duration", "type": "esriFieldTypeInteger", "alias": "Observed Moving Trip Duration (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "obs_moving_duration" }, { "name": "mean_speed", "type": "esriFieldTypeDouble", "alias": "Average Travel Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mean_speed" }, { "name": "sd_speed", "type": "esriFieldTypeDouble", "alias": "Standard Deviation of Observed Speeds (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sd_speed" }, { "name": "speed_ci_upper", "type": "esriFieldTypeDouble", "alias": "Upper Bound of the 95% C.I. Observed Speeds (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "speed_ci_upper" }, { "name": "speed_ci_lower", "type": "esriFieldTypeDouble", "alias": "Lower Bound of the 95% C.I. Observed Speeds (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "speed_ci_lower" }, { "name": "min_speed", "type": "esriFieldTypeDouble", "alias": "Min Observed Moving Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "min_speed" }, { "name": "speed_5", "type": "esriFieldTypeDouble", "alias": "5th Percentile of Observed Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "speed_5" }, { "name": "median_speed", "type": "esriFieldTypeDouble", "alias": "Median Observed Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "median_speed" }, { "name": "speed_85", "type": "esriFieldTypeDouble", "alias": "85th Percentile Observed Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "speed_85" }, { "name": "speed_95", "type": "esriFieldTypeDouble", "alias": "95th Percentile Observed Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "speed_95" }, { "name": "max_speed", "type": "esriFieldTypeDouble", "alias": "Max Observed Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "max_speed" }, { "name": "mean_time", "type": "esriFieldTypeDouble", "alias": "Mean Observed Travel Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mean_time" }, { "name": "sd_time", "type": "esriFieldTypeDouble", "alias": "Standard Deviation of Observed Travel Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sd_time" }, { "name": "median_time", "type": "esriFieldTypeDouble", "alias": "Median Observed Travel Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "median_time" }, { "name": "planning_time", "type": "esriFieldTypeDouble", "alias": "Planning Time - 95th Percentile Travel Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "planning_time" }, { "name": "n_stop_obs", "type": "esriFieldTypeInteger", "alias": "# of Stopped GPS Observations", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "n_stop_obs" }, { "name": "n_stop_trips", "type": "esriFieldTypeInteger", "alias": "# of Stopped Trips", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "n_stop_trips" }, { "name": "obs_stopped_time", "type": "esriFieldTypeDouble", "alias": "Total Observed Stopped Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "obs_stopped_time" }, { "name": "mean_stopped_time", "type": "esriFieldTypeDouble", "alias": "Average Stopped Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mean_stopped_time" }, { "name": "sd_stopped_time", "type": "esriFieldTypeDouble", "alias": "Standard Deviation of Stopped Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sd_stopped_time" }, { "name": "median_stopped_time", "type": "esriFieldTypeDouble", "alias": "Median Stopped Time (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "median_stopped_time" }, { "name": "complete_n_moving_obs", "type": "esriFieldTypeInteger", "alias": "# of Moving GPS Observations From Complete Trips", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_n_moving_obs" }, { "name": "complete_n_moving_trips", "type": "esriFieldTypeInteger", "alias": "# of Moving Trips From Complete Trips", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_n_moving_trips" }, { "name": "complete_obs_moving_distance", "type": "esriFieldTypeInteger", "alias": "Observed Moving Trip Distance From Complete Trips (Feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_obs_moving_distance" }, { "name": "complete_obs_moving_duration", "type": "esriFieldTypeInteger", "alias": "Observed Moving Trip Duration From Complete Trips (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_obs_moving_duration" }, { "name": "complete_mean_speed", "type": "esriFieldTypeDouble", "alias": "Average Travel Speed From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_mean_speed" }, { "name": "complete_sd_speed", "type": "esriFieldTypeDouble", "alias": "Standard Deviation of Observed Speeds From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_sd_speed" }, { "name": "complete_speed_ci_upper", "type": "esriFieldTypeDouble", "alias": "Upper Bound of the 95% C.I. Observed Speeds From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_speed_ci_upper" }, { "name": "complete_speed_ci_lower", "type": "esriFieldTypeDouble", "alias": "Lower Bound of the 95% C.I. Observed Speeds From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_speed_ci_lower" }, { "name": "complete_min_speed", "type": "esriFieldTypeDouble", "alias": "Min Observed Moving Speed From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_min_speed" }, { "name": "complete_speed_5", "type": "esriFieldTypeDouble", "alias": "5th Percentile of Observed Speed From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_speed_5" }, { "name": "complete_median_speed", "type": "esriFieldTypeDouble", "alias": "Median Observed Speed From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_median_speed" }, { "name": "complete_speed_85", "type": "esriFieldTypeDouble", "alias": "85th Percentile Observed Speed From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_speed_85" }, { "name": "complete_speed_95", "type": "esriFieldTypeDouble", "alias": "95th Percentile Observed Speed From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_speed_95" }, { "name": "complete_max_speed", "type": "esriFieldTypeDouble", "alias": "Max Observed Speed From Complete Trips (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_max_speed" }, { "name": "complete_mean_time", "type": "esriFieldTypeDouble", "alias": "Mean Observed Travel Time From Complete Trips (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_mean_time" }, { "name": "complete_sd_time", "type": "esriFieldTypeDouble", "alias": "Standard Deviation of Observed Travel Time From Complete Trips (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_sd_time" }, { "name": "complete_median_time", "type": "esriFieldTypeDouble", "alias": "Median Observed Travel Time From Complete Trips (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_median_time" }, { "name": "complete_planning_time", "type": "esriFieldTypeDouble", "alias": "Planning Time - 95th Percentile Travel Time From Complete Trips (Minutes)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "complete_planning_time" }, { "name": "state_name", "type": "esriFieldTypeString", "alias": "state_name", "domain": null, "editable": true, "nullable": true, "length": 512, "defaultValue": null, "modelName": "state_name" }, { "name": "county_name", "type": "esriFieldTypeString", "alias": "county_name", "domain": null, "editable": true, "nullable": true, "length": 512, "defaultValue": null, "modelName": "county_name" }, { "name": "osm_highway_tag", "type": "esriFieldTypeString", "alias": "osm_highway_tag", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "osm_highway_tag" }, { "name": "Bucket", "type": "esriFieldTypeInteger", "alias": "Bucket", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bucket" }, { "name": "Speed_Bucket_v2", "type": "esriFieldTypeInteger", "alias": "Speed_Bucket_v2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Speed_Bucket_v2" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R2072_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1996_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SoCalProjects.DBO.wejo_speed_data", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "be3f4c9e2e1740b5a0dff4df7883259e" }