Debbie's Blog
mapping
2 min read

Geocoding: From Excel to TileMill (Part II)

Screen Shot 2012-11-08 at 10.36.40 AM.png

This continues from the previous post, where the iPhone GPS data has been batch exported to Excel BUT in a weird DMS format rather than the DD format that we need in order to import into TileMill. Unfortunately, there is no magic button or plugin for this, but in the end… it turns out… its not that hard after all. Doh.

D + M/60 + S/3600 = DD
In Excel:
=SUM([@[D-Lat]]+[@[M-Lat]]/60+[@[S-Lat]]/3600)
=SUM([@[D-Lon]]+[@[M-Lon]]/60+[@[S-Lon]]/3600)

Note that iPhone’s format may actually be D,M(in decimals) without an S value.

Screen Shot 2012-11-08 at 10.36.40 AM.png
Degree:Minutes:Seconds GPS values converted to Decimal Degrees!
(See Lat and Lon column. TileMill will understand any of the following column headers: latitude, longitude, lat, long,lon, x, y.)

Screen Shot 2012-11-08 at 10.20.00 AM.png

Data successfully imported into TileMill Layer!

Screen Shot 2012-11-08 at 10.44.06 AM.png

Plotted successfully! But what is this? IT IS ALL EMPTY!?????
Screen Shot 2012-11-08 at 10.32.13 AM.png

Oh so I forgot to add in any shape layers. So next we need an ESRI Shapefile for city of Paris available here here and here from metro.teczno.com and downloads.cloudmade.com respectively, based on OpenStreetMap data. [See also: Adding Layers in TileMill]

Screen Shot 2012-11-08 at 12.49.08 PM.png
Successful loading of shape layers for buildings and main roads.
Some random slapbang colours here just for testing purposes.

SUCCESS!!!

Now I will finetune it from here…

Related posts:

Screen Shot 2012-11-08 at 6.49.15 AM.pngGeocoding: From the streets to Adobe Bridge and then Excel (Part I) Microsoft ExcelTilemill – Conditional Label Placement, Pseudo 3D Building Effects, and Polygon Patterns havanagilabandparisField Recording: “Hava Nagila” (27 September 2012, Paris) P9079128Field Recording: French Rap and Derbouka on Paris Metro (12 October 2012, Paris) iSeismograph on the MRT UntitledLessons in 3D Printing: Raft Vs Brim Vs Skirt Photo by Elio GermaniField Recording: Paris Gypsy Band on the Metro, 11 September 2012 Screen shot 2012-06-28 at AM 07UP Singapore Urban Prototyping Weekend – Postcode Postcard

csvdecimal degreesexcelexifexporting csvgpsgpslatitudegpslongitudeiphone geotaggingiphone4mac excelmapboxmetadatanamespacesopenstreetmapparistilemillxmp

By Debbie Ding
November 8, 2012
Screen Shot 2012-11-08 at 6.49.15 AM.png
Previous Geocoding: From the streets to Adobe Bridge and then Excel (Part I)
Elio Germani - Postcar (Work-in-progress) (2012)
Next “Primavera” – Works by artists at the Dena Foundation Paris Residency 2012-2013

More Stories

mapping
6 min read

The Making of StrangeLah

art design game mapping
3 min read

A Shopfront in Blender and Unity: Lazy Speedrun using UV Project from View

Back to top