July 29, 2022

Joining data and more

Finding map data can be frustrating. It's one thing to find the geospatial part - the boundaries, street centerlines, points - but even harder to find data with the right attributes. You might end up with an identifier, a name, maybe a few helpful properties, but it's unlikely that you can find something like a pre-made dataset of US states with income data, or country boundaries with their formation dates. There's no "one stop shop" for data like that, and there probably won't ever be one. Instead, we need great tools for working with the data we have.

Which brings us to today: Placemark now supports joins.

States data joined with income data

What's a join? It's when you take a geospatial file, like a GeoJSON file of states, and put it on your map. Then you take a spreadsheet, like a table of states and their average incomes, and add that to the map too - and Placemark matches the table with the map data, and makes you an enhanced new file with the extra data. It's like an Microsoft Excel "Merge", or a database "JOIN."

Joins let you create custom, hybrid datasets by adding extra attributes to geospatial data from tabular data. We think you'll really like it.

All you need is tabular data - a CSV or an Excel file - with a column that matches the map data. Maybe that's a state's name, or a country's ISO code, or a zip code against ZCTAs. Placemark does the matching, combines the attributes, and updates your map with the new data.

Here's a tutorial example of joins in action:

Check out the new documentation page on joining tabular data for all the details!

Other updates

Showing summary statistics for geometry information

The geometry information menu, noted by the ruler icon, now works with multi-selections - so you can select multiple features on the map and get a summary of their geometry types as well as information like total area for polygons and total length of lines.

Custom winding order for GeoJSON

The already quite flexible GeoJSON export got even more custom: you can specify the winding order of the exported GeoJSON files. 99.9% of the time you shouldn't worry about this at all. But in that 0.1%, in which you're using d3-geo or Azure Cosmos DB, you'll want to select the second option, "D3" to wind polygons in the opposite direction to the one specified in the GeoJSON specification. If that's you, check it out, and see the new documentation on winding order.