Layer: Median upload speed by block (Ookla® Nov 2022

View In: Map Viewer

Name: Median upload speed by block (Ookla® Nov 2022 - Oct 2023)

Display Field: geoid

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Raw data

Raw data are monthly CSV files, which are aggregated 12 months at a time. We use Ookla’s suggested filters for quality assurance. Note: filtering excludes mobile tests, which are defined as browser-based using a cellular connection.

Point aggregation

A unique ID field is created (i.e., “Agg_ID”) by combining the Longitude, Latitude, and User ID fields. The mean download and upload speeds (per user) are found by aggregating to this unique ID. A second unique ID field is created (i.e., “Agg_2ndID”) by combining Longitude and Latitude. Aggregating again to this second unique ID results in the following statistics per coordinate point: mean, median, standard deviation, count, min, max, 10th percentile, and 90th percentile.

Block aggregation

Ookla points are spatially joined to Census blocks. The mean download and upload speeds (per user) are aggregated to Census blocks using the following statistics: mean, median, standard deviation, count, min, max, 10th percentile, and 90th percentile.

Based on ASU analysis of Ookla® Speedtest Intelligence® data for November 2022 through October 2023. Ookla trademarks used under license and reprinted with permission.

Copyright Text: Ookla®

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"classBreaks","authoringInfo":{"type":"classedColor","colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[186,87,37,255],"toColor":[186,87,37,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,177,118,255],"toColor":[222,177,118,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,209,184,255],"toColor":[230,209,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[163,198,209,255],"toColor":[163,198,209,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[94,158,171,255],"toColor":[94,158,171,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[0,98,105,255],"toColor":[0,98,105,255]}]},"classificationMethod":"esriClassifyManual"},"field":"median_upload","classificationMethod":"esriClassifyManual","minValue":0.001,"classBreakInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[186,88,38,255],"outline":{"type":"esriSLS","style":"esriSLSNull","color":[240,237,233,255],"width":0}},"classMaxValue":1,"label":"0 - 1"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[221,176,118,255],"outline":{"type":"esriSLS","style":"esriSLSNull","color":[240,237,233,255],"width":0}},"classMaxValue":3,"label":"1.1 - 3"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[230,209,184,255],"outline":{"type":"esriSLS","style":"esriSLSNull","color":[240,237,233,255],"width":0}},"classMaxValue":20,"label":"3.1 - 20"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[163,199,210,255],"outline":{"type":"esriSLS","style":"esriSLSNull","color":[240,237,233,255],"width":0}},"classMaxValue":100,"label":"20.1 - 100"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[93,158,170,255],"outline":{"type":"esriSLS","style":"esriSLSNull","color":[240,237,233,255],"width":0}},"classMaxValue":1000,"label":"100.1 - 1,000"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,98,105,255],"outline":{"type":"esriSLS","style":"esriSLSNull","color":[240,237,233,255],"width":0}},"classMaxValue":7942.2855,"label":"1,000 +"}],"legendOptions":{"order":"ascendingValues"}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
geoid (type: esriFieldTypeString, alias: GEOID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
mean_download (type: esriFieldTypeDouble, alias: MEAN_DOWNLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
standard_deviation_download (type: esriFieldTypeDouble, alias: STANDARD_DEVIATION_DOWNLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
median_download (type: esriFieldTypeDouble, alias: MEDIAN_DOWNLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_download (type: esriFieldTypeInteger, alias: COUNT_DOWNLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
maximum_download (type: esriFieldTypeDouble, alias: MAXIMUM_DOWNLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
mean_pct_90_download (type: esriFieldTypeDouble, alias: MEAN_PCT_90_DOWNLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
mean_pct_10_download (type: esriFieldTypeDouble, alias: MEAN_PCT_10_DOWNLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
mean_upload (type: esriFieldTypeDouble, alias: MEAN_UPLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
standard_deviation_upload (type: esriFieldTypeDouble, alias: STANDARD_DEVIATION_UPLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
median_upload (type: esriFieldTypeDouble, alias: MEDIAN_UPLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_upload (type: esriFieldTypeInteger, alias: COUNT_UPLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
maximum_upload (type: esriFieldTypeDouble, alias: MAXIMUM_UPLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
mean_pct_90_upload (type: esriFieldTypeDouble, alias: MEAN_PCT_90_UPLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
mean_pct_10_upload (type: esriFieldTypeDouble, alias: MEAN_PCT_10_UPLOAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
id (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
served_status (type: esriFieldTypeString, alias: served_status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/22/2023 6:18:57 PM

Schema Last Edit Date: 11/22/2023 6:18:57 PM

Data Last Edit Date: 11/22/2023 6:18:57 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Median upload speed by block (Ookla® Nov 2022 - Oct 2023) (ID:4)