How do I map my own spreadsheet data in indiemapper?
Posted by daveSince launching indiemapper, a lot of you have asked: “How do I map my own spreadsheet data?” We are currently working on building this functionality right into indiemapper. In the meantime, here is a simple workaround so you can start mapping your data right away.
This article is reprinted from the indiemapper help website. You can access this article and many others at http://support.indiemapper.com/forums. If you’re looking for additional help or more tips and tricks, you can always email us at support@indiemapper.com or drop by our office hours on Tuesdays and Thursdays.
If you have thematic data in a spreadsheet (*.csv or *.xls) and want to map it, you’ll first need to join it to an existing data source and then load it into indiemapper. In the example below, we’ll join data from a CSV file to an existing DBF (*.dbf) file. DBF files contain the thematic data that is associated with the geographic features in Shapefiles.
1. Get OpenOffice at http://www.openoffice.org
We use OpenOffice (Calc), but any spreadsheet editing program that can open and save DBF files will work.
2. Open the existing DBF in OpenOffice
Here, we’ve opened a Natural Earth DBF downloaded from Natural Earth:
attachment: [50m-admin-0-countries.dbf]
It comes with the following Shapefile:
attachment: [50m-admin-0-countries.shp]
The DBF already has three columns in it for country, feature class, and sovereign nation.
3. Add new columns and column names to the Natural Earth DBF
This is where your thematic data will go in step 5.
4. Grab some thematic data at the country level
We found some free data at the CIA World Factbook on population, internet users, and internet hosts and converted it to CSV (comma delimited *.csv file) for use in Open Office .
attachment: [rawdata_2119_POP.csv]
attachment: [rawdata_2153_USERS.csv]
attachment: [ rawdata_2184_HOSTS.csv]
5. Open the World Factbook files in OpenOffice and copy+paste the cells into the empty columns you created in step 3
Be sure to match up the data correctly – to do this easily, both DBF and CSV should have one column in common. Here, both datasets have a column of country names.
Note: This step can be labor intensive, depending on the number of rows of data you have and because sometimes the two datasets do NOT match up perfectly. In this example, although both datasets have a country name column, the rows differ. For example, the World Factbook file has some countries (e.g., Akrotiri) that are not in the Natural Earth DBF, and vice-versa.
6. Save the DBF
Here is the newly joined data:
attachment: [50m-admin-0-countries_internet.dbf]
7. Launch indiemapper and open the Natural Earth Shapefile (see file above) along with your newly joined DBF
The file names do not have to match. Your new thematic data (from the CSV) will appear in the attributes list when you click on the orange plus button to add a new layer. You are then ready to make your map.
Open the SHP + DBF:
Review your new attributes in the list:
Make your map:
