Data Management

Ontario Oil, Gas & Salt Resources Library

The Ontario Oil, Gas & Salt Resources (OGSR) Library is a not-for-profit organization that provides prospectors, drillers, consultants, the general public, and numerous other interested parties with information related to Ontario’s petroleum industry.

Currently, the Library is staffed by three employees: one Manager, one Data/Operations Administrator, and one Geographic Information Systems Technician (myself).  During the summer, we usually employ 1-2 students: one with a Geology background and/or one with a GIS background.  At any given time, we tend to be working on a few special projects that sometimes require additional staff hired on contract as needed.  The office of the Ontario Ministry of Natural Resources and Forestry’s (MNRF) Geologist is also located in our building.  The main MNRF building is conveniently located a few steps away from the Library, which is quite useful considering the inter-connectivity of our operations.

In Ontario, there are over 26,000 known petroleum wells.  In 2007, Wells Cards containing general information about every single one of these wells became available to the public online through our website.  To date, there are 26, 705 Well Cards available for public viewing online…click this link for a sample well card.  In early 2012, a project began to scan all 26,000 + of our physical well files.  Each well file is a folder containing Well Licences, location maps, licence applications, and various other paperwork that is relevant to a well’s history.   As well files were scanned, they became available online to paying members, and in April of 2015, the project was completed.  To date, well files consist of over 500,000 images and in 2014, our members viewed over 14,000 of these images!  This barely scratches the surface in terms of what is available online, however, as you can see that there is a lot more additional information that can be accessed from the well cards page (most of this information being reserved for paying members).  Ultimately, the accessibility of this data has reduced the need for the public and members to phone/e-mail us to request information, and there is even less of a need for people to physically be in the library to access our data.  In 2014, 150,000 well cards were accessed online by members alone.  This, of course, gives us more time to work on other projects and allows members to retrieve data more efficiently, but we always enjoy visitors to the library as some days it can get pretty quiet!

logsGeophysical logs (above) comprise some of the data that is reserved for paying members and are an on-going project to keep up to date.  Geophysical logs vary in what they represent, but basically they contain some sort of measurement (such as gamma ray or neutron density) that provides useful information to operators and prospectors.  Various instruments are lowered into a well borehole that gather data which is then represented visually on a log.  These logs are then sent to us at the library and we scan them and add them to our database.  In 2014, our members viewed over 10,000 logs online!  Currently, we are in the process of catching up with our backlog (no pun intended) of logs by scanning a certain number of logs each week.  We are on track to be caught up in a few months, and from there we will scan logs as they accumulate.   Roughly 100 new logs are generated each year, and all of these can be scanned in 2-3 days of continuous scanning.

Sample Tray

Sample Chip VialsAside from updating and maintaining well data, the OGSR Library also stores and maintains drill core and sample chips from wells drilled all over Ontario.   Drill core is a circular core that has been cut in half lengthwise and placed in boxes; this is what comes out of the ground when a hole is drilled for a well…a picture of drill core can be seen below in the section discussing our Core Photography project.  Sample chips are  ground up core that comes out of the ground also during the drilling of a hole for a well; operators must gather these samples at least every 3 or 6 meters depending on the type of well.  The operator will place these samples in bags labeled with the depth at which they were sampled, deliver them to us, at which point they are washed and placed vials (image to the right).  In our 3,600 square foot warehouse, there are over 1,100 drill cores from 1,000 different wells contained in over 100,000 boxes, and there are sample chips from over 10,800 different wells that are stored on over 12,000 trays (image above) inside over 1,000,000 vials!  In the image below, you can see all of the boxes that contain the drill core.  The grey cabinets under the boxes store the sample trays and vials.

OGSR Library Warehouse

Much of the spatial data that we manage can be found in our PxTools, a file compatible with Google Earth.  The file can be downloaded by clicking here.  Simply download the file, make sure you have Google Earth (or GE Pro) installed on your computer, double click the downloaded .kmz file, and you will be able to see 35 different layers such as petroleum wells, petroleum pools, and historic scanned and georeferenced maps!  We regularly update some of the layers found in PxTools and add new data as it becomes available.

One major project occurring at the OGSR Library on a yearly basis pertains to Production Records for active wells in Ontario; our Data/Operations Administrator carries out most of the tasks involved in this project.  Operators are required to submit information about their production, for example how many cubic meters were produced in a given year, to the library annually.  We receive roughly 2,000 forms at the beginning of each year, and we plan to have all of them scanned and digitized by the end of June.  These scans then get uploaded to our website for members to view, and this is another data set that is frequently utilized; in 2014, 12,000 production records were reviewed by our members.

Yet another project that will always be ongoing is our core photography project.  Many clients, members, prospectors, etc. find it useful to view the drill cores that we store in our warehouse.  Before our core photography project began, the only way to accomplish this was to physically be at the OGSR Library.  Now, upon request, we can photograph drill core and provide it to clients for a fee per box that is photographed.  To date, over 2,000 core boxes have been photographed; currently, we can photograph a maximum of roughly 40 core boxes per day.  The equipment for this project was generously donated by Charlie Fairbank, who owns and maintains historic oil lands in Oil Springs, Ontario, where much of Canada’s and the world’s first commercial oil production began in 1858.  Each core box is photographed three times: once under UV light, once under normal lighting, and once under normal lighting after wetting the core.  In the image below, you can see an example of the three different types of photos that are taken for each core box.  The bottom (purplish) portion of each core section is the UV photo; this type of light causes certain features of the core to fluoresce, features that are otherwise invisible to the naked eye.  The middle portion of each core section is the wet photo, and the top portion is the dry photo.

Core Photography Project

As the GIS Technician, I am responsible for updating our annual “Oil & Gas Pools & Pipelines of Southern Ontario” map.  Each year, I make edits to the petroleum pools layer (which can be viewed in PxTools) based on newly drilled wells and new information that has been made available.  Some of the boundaries that still exist in the layer today were derived from geological studies that occurred many years ago.  The Pools and Pipelines map is accompanied by tabular data showing Cumulative and Annual Oil/Gas production by pool.  The data come from the Production Records project mentioned previously.

From time to time, clients will request maps for projects they are working on, so usually when this happens the client request becomes my priority.  We deliver high quality maps to clients digitally for the most part, but sometimes hard copies are needed so we will print them using our in-house plotter. We also create map books for some of our clients that require regular updates to spatial and attribute data.

As I’m sure you can tell, a lot of our work involves keeping our data up to date.  This is very important to the petroleum industry in Ontario because our data helps drillers, prospectors, consultants, etc. make informed decisions…this is a perfect example of the infamous ‘GIGO’ acronym (good [data] in, good [data] out).

Every now and then we also like to go on fields trips and learn about the geography that is happening in the real world.  During our most recent field trip, we visited Sulphur Springs Conservation Area in Hanover, Ontario.  We took a few interesting underwater video’s that can be viewed by clicking here…check out the video’s description to learn more!

Hopefully this post has provided some insights into what we do here at the OGSR Library.  It’s such an interesting place, yet many people do not even know it exists.  If anyone is ever in the London area, we would be more than happy to give you or your group a tour! Feel free to contact us with any questions you may have and be sure to check out our website at www.ogsrlibrary.com.  You can even receive a free seven day membership to explore the data that we have available – just visit www.ogsrlibrary.com/free to create your account!

What Does My Day of Geography Look Like? Map Library Associate/Geospatial Data Coordinator

I work in a fishbowl called the Map, there Data & GIS Library. I’m always on the frontline helping students with a variety of requests from navigating Mackenzie Chown Complex to extracting remote sensing data or using HTML to make a web mapping application! I LOVE to help students and thrive on geospatial data requests or GIS problem-solving issues. When I’m not helping students, I’m working on digitization projects that make historical map documents GIS-ready.

MapLibrary

For example: historical topo maps; historical air photos; and historical maps. I also try to keep the MDGL on the cutting edge of technology…often my ideas are ahead of their time. None-the-less, exploring geospatial data availability, quality and delivery are my priority so that the Brock University community is served the best data to meet their teaching and research needs. I love my job!

Posted on behalf of Sharon Janzen – Brock University Map, Data & GIS Library.

 

Map Library 1

 

 

 

 

 

 

 

 

My Spatial Career

My Geography Degree was the best thing that ever happened to me on all scales of my life (no pun intended…well maybe a little). I have worked (and yes I mean was paid) in the realms of Economic Development & Tourism, Heritage Planning, Development Compliance, Urban Planning, Geographic Information Systems & Asset Management – IT….yes I said ‘IT’ and now Engineering….what!

Yes my spatial career has been just that – all over the place overlapping multiple disciplines! There is so much I have done and so much I can do! Geographers can understand processes, data, mapping, SPACE! And with that comes many many many many disciplines!  I have held many titles throughout my life (Technology Analyst, Urban Planner, Tourist Ambassador, Technician) although they may not all sound geographical they all have been because of Geography! I have been blessed with meeting people all over the world! issued permits for new land uses and buildings! Built spatial databases! Created and manipulated data to create awesome Maps!

On this Day of Geography I am an Infrastructure and Environmental Technologist with Municipal Works at the City of Niagara Falls. I work primarily with Infrastructure and Asset Management. I map out our municipal infrastructure – sanitary, storm, water, roads etc and attach attribute information to these assets! I get to take care of the infrastructure that supports our daily lives! Nothing beats the knowledge of the space around you! Thanks for reading!

New to GIS, but loving it.

Hello to all. My name is Shaun and I am currently working on a GIS project for a reservation in Southern Manitoba. Our main goal and objective is to gather data using Trimble Geo7X units, click in order to make a map of the reserve. There is currently no way of Emergency crews to know where to go if they are called out, (which they regularly are). The crews usually end up driving around in search of a property, and when it comes to these situations time is of the essence. Sometimes the lack of information ends with tragic results. The map we are currently producing using ArcMap 10.3, will include various important information. Things like the number of people in each unit, main entrances and photos of the units will all be included. We plan to pass our information on to local emergency services and hopefully make a difference in the community by getting emergency crews to locations quicker and in turn, saving lives.

This is my first experience with GIS and I am finding it challenging and rewarding at the same time. I look forward to speaking with others about their experiences in the field. Thank you!!

A quick glimpse into my working world

Being the only GIS professional in my section means not only having all the responsibilities pertaining to GIS but also being the person that staff tend to go to for IT/computer help, graphic design, website maintenance, automation processes and database support.

Examples of my day-to-day tasks include providing technical support for GIS applications; creating specialized maps; assisting with GPS units; digital file management; supporting network connections to local servers; editing schematic drawings using graphic software; attending a teleconference on changes being made to our corporate web pages. Current larger projects involve Python scripting in ArcMap; uploading local spatial data to the geospatial depository; managing an Oracle database project and coordinating the development digital PDF smart forms.

As I was writing this, I was called upon three times. A couple inspectors asked for some computer help, our Chief Geologist needed assistance on an ArcMap procedure and our Chinese Intern needed me to continue training him on creating and distributing data for Water Static Level Maps.

I work in London, Ontario, Canada as the Data Management Specialist at a section of the provincial government that regulates the drilling, production and plugging of oil, gas and salt related wells. My job gives me much pride, is continually evolving and is full of technical tasks and projects. Awesome.

Hope this quick and casual blog entry provided a small insight into my working life. Next I think I’ll work on requests to enhance our customized ArcMap application…