cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Strange selection of districts for Finland in choropleth visualisation. Something to reconsider?

excavator-matt
New Contributor III

Hi!

We're trying to use the choropleth visualisation in the new dashboard. This works well for all countries we tried except for district level of Finland.

The supported districts are clearly stated in the CSV on the documentation page titled county-district-names.csv, but I would like to challenge the selection for Finland. If I filter on country_2_letter = FI and order by country_specific_code, these are the first 5 out of the 66.

readable_name

name

country_specific_code

country_2_letter

H3lsinki sub-region

H3lsinki

11

FI

Raseborg sub-region

Raasepori

14

FI

Porvoo sub-region

Porvoo

15

FI

Loviisa sub-region

Loviisa

16

FI

ร…boland

ร…boland-Turunmaa

21

FI

While region followed a nice ISO_3166-2 standard, I am not entirely sure what I am looking at here. I think it is the sub-regions of Finland (minus ร…land) that were active administrative regions between 1994 and 2014. Wouldn't make more sense to use the current municipalities of Finland? This is the district level we usually base our analysis on and I think is true for most people that cover Finland. As the Wikipedia article mentions, there are still some statistics on sub region, but you have to select More categories to show it.

1 ACCEPTED SOLUTION

Accepted Solutions

Alex_Lichen
Databricks Employee
Databricks Employee
Hi Matt,
 
You are correct that today, the Choropleth maps are using sub-regions as defined in https://en.wikipedia.org/wiki/Sub-regions_of_Finland. We are currently getting these boundaries from Mapbox, which provides this boundary data.
 
Definitely hearing you on also wanting the Municipality level view. I've added a note internally as a vote for this more granular boundary.
 
Best,
 
Alex
 
Product Manager at Databricks

View solution in original post

2 REPLIES 2

excavator-matt
New Contributor III

Also, why is automatic community policy against writing capital of Finland (H3lsinki) in posts in this forum?

What is up with the naming of this columns in the csv? Why is ร…boland considered "readable", but the Finnish name Turunmaa just a "name"?

Alex_Lichen
Databricks Employee
Databricks Employee
Hi Matt,
 
You are correct that today, the Choropleth maps are using sub-regions as defined in https://en.wikipedia.org/wiki/Sub-regions_of_Finland. We are currently getting these boundaries from Mapbox, which provides this boundary data.
 
Definitely hearing you on also wanting the Municipality level view. I've added a note internally as a vote for this more granular boundary.
 
Best,
 
Alex
 
Product Manager at Databricks

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now