Tuesday, 24 March 2015

A day in the life of a petroleum professional - shorthand

This is Part II of a A day in the life of posts, to introduc Basic petroleum data manipulation for professionals who aren't data managers. This is however a much simpler workflow that lends itself more to rapid project start-ups for petroleum rather than data professionals.
This class aims to put simple processes in the hands of those who do the prospecting, when tighter economics reduce the available specialist staff, using tools that may already be at hand.
click to enlarge


A class-notes brief is posted on my companion blog.

This will be outlined at Esri PUG in Houston early April.

click to enlarge

Full class notes may eventually be posted on the PPDM site.

click to enlarge

The resulting map is also posted on my zolnai.ca portfolio page:

click to enlarge

Wednesday, 4 February 2015

Esri, Google and if the shoe fits...

[Here is a further update based on input from other people on what is surely a timely topic. Originally posted on LinkedIn Pulse as The (Geo) Internet of Things, it's posted there for a wider audience.]

Friday, 30 January 2015

Professional portfolio of Esri maps

As I went solo in the new year, I collected my previous works also seen in the banner map gallery, and posted the Esri maps as a map story. Go here if it's too slow to load.

Monday, 22 December 2014

A day in the life of a petro-data manager - shorthand

[Update: a simpler workflow that uses  for-fee & for-free software is posted here]

After intoducing the process to extract, transform & load  (ETL) www.boem.gov well data into a www.ppdm.org database, here is the short version expanded over on my sister blog.

Sunday, 23 November 2014

Web Maps on Steroids, Part II

I showed a couple of months ago ways to post mega-datasets online without choking the system. This month OSGeoUK gave me the opportunity to present the same on PostGIS Day 2014, as postGIS was the backbone of two of these examples on GIScloud and GeoCloud2. Thanks to OSGeoUK and British Computer Society for hosting this.

Sunday, 9 November 2014

A day in the life of a petro-data manager - intro

[Update: Talend made the early version complex, so simpler one was posted later]

Have you ever been given plain text geodata and wondered how to database and map it? And has this happened to you lately with tens of thousands of lines of data? Well help is at hand! Here is an ETL  workflow (extract, transform, load) useful to any data manager in or out of petroleum using free tools:

Saturday, 4 October 2014

Big data and maps reloaded

Social media really work! +Vicky Gallardo posted on Google+ that the map is not the territory, with a wonderful big data map by Ben Allen of Denton TX (near where I used to live). That prompted a post by the same title on my companion map blog. The distinction between data and maps has long kept me up at night (see my blog tagline), and many others to judging by exhibits and media only in London (near where I live now).

Saturday, 27 September 2014

Web maps on steroids

The last 6 blog posts over the last 3 months chronicled the use of dynamic maps using time attribute - years for historic ship tracks and wind data from same 150-350 yrs ago - not to animate maps but to filter them by decade and manage data fetches on ArcGIS Online. A parallel series of posts showed mega data sets on Amazon Web Services, as Mapcentia assured me postGIS handled giga datasets...

Saturday, 6 September 2014

On joining and merging historic multi-lingual geodata

Earlier posts chronicled the history even the beauty of historic shipping and climate data from CLIWOC. British, Dutch, French and Spanish maritime agencies transferred paper logs to digital records. In doing so look-up tables allowed to convert multi-lingual records into quantifiable attributes. Something odd (to me) happened in the process of mapping these: over 1/4M records doubled to almost 1/2M when look-ups were joined and then wind and direction tables merged to create maps symbolised by wind force and orientation.

Wednesday, 27 August 2014

The happenstance art of maps

I showed recently how CLIWOC weather data from ships captains logs dating 1662 to 1885 totalled almost 1/2M points. It started with a 1/4M ships tracks, and combining look-up tables from four maritime agencies they yield numeric wind force and direction...