Pages Menu
Categories Menu

Posted by on Mar 30, 2012 in Featured Maps, R Spatial, Slideshow, Visualisation | 22 comments

Mapped: British, Spanish and Dutch Shipping 1750-1800

I recently stumbled upon a fascinating dataset which contains digitised information from the log books of ships (mostly from Britain, France, Spain and The Netherlands) sailing between 1750 and 1850. The creation of this dataset was completed as part of the Climatological Database for the World’s Oceans 1750-1850 (CLIWOC) project. The routes are plotted from the lat/long positions derived from the ships’ logs. I have played around with the original data a little to clean it up (I removed routes where there was a gap of over 1000km between known points, and only mapped to the year 1800). As you can see the British (above) and Spanish and Dutch (below) had very different trading priorities over this period. What fascinates me most about these maps is the thousands (if not millions) of man hours required to create them. Today we churn out digital spatial information all the time without thinking, but for each set of coordinates contained in these maps a ship and her crew had to sail there and someone had to work out a location without GPS or reliable charts.

These maps were produced with the latest version of R‘s ggplot2, maptools, geosphere and png packages. Formatting the data took the most work (it was a very large MS Access database). I used ggplot’s annotation_raster() to add the compass rose and title.

Update: For some nice animations and a much better critical analysis of the data see Ben Schmidts blog.


  1. Great graphics! I saw this dataset a while back, and was thinking it would be fun to make an little interactive site with it (I believe i saw it mentioned by

    Would you consider releasing a flat-file format of your cleaned dataset?

    Thanks again.

    • Hi Jim, glad you like the maps. See the R code above for a simpler way of getting the data.

  2. Great map! I work a lot with satellite telemetry locations of marine mammals and this would be a great visualization. Would you consider posting the code?

  3. Nice Work!

  4. Beautiful map!

    ..some wiggly waggly routes indeed – a few of them captains must have had too much rum, I guess!

    Is there a chance to view the code?

  5. That is a fascinating map, but what saddens me is that the atlantic triangle was still active at that time, from UK ports to africa, the west indies and back. I fear that some of those journeys are what the map shows.

    • I agree with you, Steve: it’s very fascinating, but important to realize that embedded in this data is one of the greatest holocausts in history. I wonder if there’s any data from Portugal? From what I understand, the slave trade between Angola and Brazil during this period was far heavier even than what Britain was doing.

      It would be amazing if someone could animate this, to show how it changed over time?

    • Traditional whaling practices in the north Atlantic can be added to this. Only by the Dutch? I doubt it.

  6. Beautiful. I’m guessing that’s Captain Cook down there near Antarctica on the British map.

  7. not that much code needed to get the data into R and make a quick plot the “uncleaned” data. try this:
    require(Hmisc) # need also mdbtools installed
    path <- "YOURWD"
    URL <- ";
    PATH <- "cliwoc/download/"
    FILE <- ""
    dir <- unzip(paste(path,"",sep=""))
    file <- substr(dir,3,nchar(dir))
    dat <- mdb.get(file)
    tmp <- dat$CLIWOC15[,c("Lon3","Lat3")]
    geom_point(alpha=0.01,size=1) +
    coord_map() +

    • Thanks for this Einar- it is a much better way of accessing the data than the method I used!

  8. Some fascinating mapped data. It shows visually how both Spain and The Netherlands had different overseas priorities (as you said) and if you look carefully, it coincided with the former colonies of these countries (sort of obvious, but worth mentioning).

    I am quite surprised to see how the Spanish concentrated pretty much on the Americas though, seeing how the Philippines were Spanish until 1898.

  9. Could you please provide bigger resolution versions, or a tutorial to recreated this data?
    I think its quite useful and interesting, I’m thinking of printing it as a decorative map.
    Thanks in advance

  10. Very interesting presentation. It would be useful to know which courses are E-W and which are W-E. That is, are the Spanish course heading N from Cuba to FL to catch the Gulf Stream, or is that E-W traffic.

    Not so much Spanish/ Portuguese slave traffic in late 1700s as it was often carried in “British” (but actually, American, esp Rhode Island) ships. I wonder, does the data set include American ships as part of the British data?

    Nice job, anyway. Look forward to seeing more.

  11. A point about the Atlantic Triangle. The British logbooks were entirely East India ships or naval vessels. The Dutch likewise were VOC plus a few naval vessels. The Spanish were mostly the postal service ships with a handful of naval vessels. No slave ships were used, and very few logs from these are extant anyway. Please be careful how you interpret this data. CLIWOC selected in the British case at least, the best of thousands of potential logs, based mainly on, long voyages and temporal and geographic data gaps. The choice was very selective.

  12. Hi there,
    thanks for the amazing posts, I have been trying to plot them in Mapinfo. I have no knowledge and experience in processing information, it has not been able to plot a point let alone paths taken. Would you have any advise?
    Thank you.

  13. Thanks for your work!
    We have made a post about this in our website

  14. Looks amazing, I would love to see the code as well!


  15. These maps make a wonderful introduction for a lay audience to the wind system over the oceanic gyres. Retired, I know give lectures, ashore and on cruise ships, and I would like permission to show one or two of these figures. Can you advise me how I might obtain such permission?

  16. Very nice illustrative graphic of the trade routes. Thank you!


  1. British and Spanish Shipping Lanes 1750-1800 « History For You - [...] Click to read more. [...]
  2. Shipping 1750-1855 visualised | unconsenting - [...] by Spatial Analysis’s blog post I thought I would look further at CLIWOC’s dataset of historic shipping.  In particular the…
  3. Mapped: British, Spanish and Dutch Shipping 1750-1800 | The Humanities Workshop - [...] Source – Mapped: British, Spanish and Dutch Shipping 1750-1800, [...]
  4. Mapped: British, Spanish and Dutch Shipping 1750-1800 (Stable Identifiers) « Another Word For It - [...] Mapped: British, Spanish and Dutch Shipping 1750-1800 by James Cheshire. [...]
  5. Things & Finds | Pearltrees - [...] Mapped: British, Spanish and Dutch Shipping 1750-1800 | Spatial Analysis These maps were produced with the latest version of…
  6. Mapping Storms 1 | R-tistician - [...] by Aaron Koblin’s flight patterns and by Mapped: British, Spanish and Dutch Shipping 1750-1800, I decided to play with…
  7. A Century of Ships | Learn to Dive Today Blog - [...] Yau’s FlowingData blog, which I follow religiously. Graduate student Ben Schmidt used a publicly available data set to map…
  8. Visualising Flows: Great Britain Journey-to-Work - [...] online recently, such as Paul Butler’s global facebook friend’s map, and maps of global trade and flight patterns. Inspired by…
  9. Wegen der Sonne - ~ liebe & stolz - [...] Visualizing Ocean Shipping Mapped: British, Spanish and Dutch Shipping 1750-1800 [...]
  10. Updated: Colonial Shipping Routes | - [...] of the most popular set of maps I produced last year showed English, Spanish and French Shipping between 1750-1800.…
  11. Del cuaderno de bitácora al mapa - La Cartoteca - [...] mapas e información: – Mapped: British, Spanish and Dutch Shipping 1750-1800. Sapping Attention – Visualizing Ocean [...]
  12. Charles Gordon w Chartumie (Powstanie Mahdiego część I) | Gavagai - Poszukiwanie treści - […]  Morskie szlaki kolonialne […]
  13. The Washington Post: 40 map pro porozumění světu II. – DATOVÁ ŽURNALISTIKA - […] Data source: Climatological Database for the World’s Oceans (James Cheshire) […]
  14. Educate Ourselves Department: 40 more global maps, plus reporter’s and readers’ comments | Exopermaculture - […] Data source: Climatological Database for the World’s Oceans (James Cheshire) […]
  15. limitless life - […] Data source: Climatological Database for the World’s Oceans (James Cheshire) […]
  16. Le monde expliqué en 40 cartes… par un américain | méridianes géo - […] Data source: Climatological Database for the World’s Oceans (James Cheshire) […]
  17. More Maps that explain the World | Cooldesign | Daily Inspiration on WhereCoolThingsHappen - […] Major shipping routes in the colonial era Climatological Database for the World’s Oceans (James Cheshire) […]
  18. biebuxin » 27张图了解世界 - […] 殖民时代主要航线 Climatological Database for the World’s Oceans (James Cheshire) […]
  19. Mapas: Rutas comerciales de España, Gran Bretaña y Holanda entre 1750 y 1800 - […] Mapas: Rutas comerciales de España, Gran Bretaña y Holanda entre 1750 y 1800 […]

Post a Reply

Your email address will not be published. Required fields are marked *