September 13, 2018 / by Open Data Portal Team / In Open Data , Data Portal

Choropleth Maps of Datasets with Multiple Location Columns

We recently became aware of a technical quirk that affects our dashboard views if the underlying tabular dataset has more than one column of Location or Point type (generically referred to as “Location” in this post). We most commonly have this situation for travel-related datasets where there is both a starting and ending location.

Data Lens allows for choropleth maps that assign each Location value to a region (e.g., Community Area or Ward). While this works well if there is only one Location column in the dataset, it behaves unpredictably when there is more than one, leading to potentially invalid maps that purport to show the distribution of one Location column but really show a different one.

There is no known fix at this time. Therefore, we are removing all such cards from Data Lens pages that are based on datasets with multiple Location columns. At this time, the pages we have identified are:

Should there be significant updates to the situation, we will update this post and will re-add these cards someday if we are able to do so in a way that we consider reliable.

Note that some other types of map visualizations that end users can create are also subject to this quirk.

Socrata is tracking this problem as a known issue. If you have any questions about it, we recommend referring to that article or opening a support ticket directly with Socrata.