{"id":319,"date":"2012-11-08T09:45:00","date_gmt":"2012-11-08T09:45:00","guid":{"rendered":"http:\/\/dbbd.sg\/blog\/uncategorized\/geocoding-from-excel-to-tilemill-part-ii\/"},"modified":"2021-06-12T02:37:21","modified_gmt":"2021-06-12T02:37:21","slug":"geocoding-from-excel-to-tilemill-part-ii","status":"publish","type":"post","link":"https:\/\/dbbd.sg\/blog\/2012\/11\/geocoding-from-excel-to-tilemill-part-ii\/","title":{"rendered":"Geocoding: From Excel to TileMill (Part II)"},"content":{"rendered":"

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.<\/p>\n

D + M\/60 + S\/3600 = DD<\/b><\/center>In Excel:
\n=SUM([@[D-Lat]]+[@[M-Lat]]\/60+[@[S-Lat]]\/3600)
\n=SUM([@[D-Lon]]+[@[M-Lon]]\/60+[@[S-Lon]]\/3600)<\/p>\n

Note that iPhone’s format may actually be D,M(in decimals) without an S value.<\/p>\n

\"Screen<\/center>Degree:Minutes:Seconds GPS values converted to Decimal Degrees!
\n(See Lat and Lon column. TileMill will understand any of the following column headers: latitude, longitude, lat, long,lon, x, y.)<\/p>\n

\"Screen<\/p>\n

Data successfully imported into TileMill Layer!<\/p>\n

\"Screen<\/p>\n

Plotted successfully! But what is this? IT IS ALL EMPTY!?????
\n\"Screen<\/p>\n

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

\"Screen<\/center>Successful loading of shape layers for buildings and main roads.
\nSome random slapbang colours here just for testing purposes.<\/p>\n

SUCCESS!!!<\/b><\/p>\n

Now I will finetune it from here…<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":3226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1057],"tags":[775,771,777,780,779,770,781,782,778,773,776,586,769,774,585,544,587,772],"jetpack_featured_media_url":"https:\/\/dbbd.sg\/blog\/wp-content\/uploads\/2021\/06\/8166334878_337043cbfc_c.jpg","_links":{"self":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts\/319"}],"collection":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/comments?post=319"}],"version-history":[{"count":2,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts\/319\/revisions"}],"predecessor-version":[{"id":3236,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts\/319\/revisions\/3236"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/media\/3226"}],"wp:attachment":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/media?parent=319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/categories?post=319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/tags?post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}