Webinar: Making Bubble Maps

Learn how to make proportional bubbles and pie charts around wells and other point data sets.

---

Closed Caption:

hello and welcome to petras webinars my
name is all custom Belknap and I will be
moderating today's webinar topic making
bubble maps this webinar will be
recorded and uploaded to the petrous
website in the next few days
please keep in mind the webinar last
roughly 20 minutes if you have any
questions or comments throughout the
webinar please feel free to enter them
in the questions panel as I will be
keeping an eye on it throughout all
questions and comments will be answered
at the end of the presentation I would
like to welcome senior technical
business analyst from our purchases
Houston office
Alec lingos the presenter for today's
webinar Alex hello everyone thanks for
showing up
I just quickly before we get going here
just a quick agenda we're going to have
just a couple of seconds on discussing
what exactly we're talking about when we
say bubble map just so everybody's on
the same page
the majority of the show will be the
demonstration of course we'll have a
short summary and then we'll spend as
much time as anybody would like on a
question-and-answer period at the end of
the show
ok first off what we mean by babel maps
that bubble maps are just essentially
circles that represents some numerical
value of the size of the circle
obviously being representative of the
size of the number you can have multiple
numbers included in the bubbles which
essentially gives you a pie chart and
typical example of this is oil gas and
water ratios for Wells but you can use
this for any numerical data we also
support elliptical bubbles which can
give you a directional component to your
map and don't forget you can stack
bubbles on top of one another and show
some other bit of information that's
varying for instance this is data
varying over time so with that let's
just get into the show but first off how
do you display a bubble map you can use
this shortcut icon right here that looks
like a pie chart or you can go to
display bubble map and the first thing
you need to do is bring in some data to
make a bubble map from and we can bring
in information from a variety of
third-party data sources and XL and txt
files or probably the most common things
that people make bubble
that's from but these third-party
sources can be quite powerful as well
now if you don't see one of the third
party sources that you want to make
bubbles from for instance you might have
data in a patrol project or petrol
project and you don't see it in this
list
don't forget you can use well data files
so the tetris data transfer tool and
specifically well import wizard can be
used to bring data into a well data file
from any third-party data source that we
support so if you don't see in this list
your best option is to bring the data
annual well data file and make bubbles
from there for today's show I'm just
going to use excel files so the first
thing you want to do is pick some input
data I've just got a spreadsheet that
has some oil water gas values in some
lat Long's and don't forget you can
always click this format button your
input data source does have to have some
sort of a location for positioning the
bubble and you can pick whatever columns
in your spreadsheet to specify the
locations and the locations can be
easton northerns decimal degrees that
longs or degrees minutes seconds lat
Long's and then you want to have some
numbers to make bubbles from the next
thing you want to do is go to this
variable selection tab and we can add
what variables who want to have making
up our bubbles so for instance i click
Add I'll see all the numerical columns
and the input data and i'll just add in
my oil value for right now the next
thing you want to do is set the
graphical attributes for that variable
so if i click the attribute button one
thing we can do is we can color the
bubbles based on a color gradient you
can specify very specific user find
ranges and apply colors to those i'm
just going to do something simple to use
a solid fill option and we'll set this
to solid and i'm going to color my oil
values in green
it's helpful if you use a translucency
on these bubbles can overlap one another
say okay and that gives us our first
initial display let me drag into the
bottom of the map if we go back to that
layer i can start adding in some other
variables
so I'll add my gas values i will set the
color fill for my gas variable to read
again using a translucency and i'm going
to add in the water values as well and
we will set those two blue and again
specifying translucency so kind of that
gives us some initial sort of a pie
chart around everything but if you'll
notice most everything is completely
dominated by the red gas values and zoom
in so you can see things a little bit
more clearly the reason why that's
happening is because the data in my
spreadsheet has not been really
normalized over the same unit so right
now the gas volume needs to be adjusted
to barrels of oil equivalent so i can do
that right here rather than just using
the variable itself and click this and
go to formula and I key in any quick
kind of formula so if i divide that
value by six just to convert into
barrels of oil equivalent we get a
slightly better display next the
annotations you can post inside the pie
wedge is the name of the variable and
the value the name only the value or
only or nothing at all and if we go back
and zoom down even closer will notice it
doesn't look very good oil on your score
volume gas volume divided by 6 so if you
don't want to show the actual variable
name which is what it's showing right
now for each of these i can go down here
to this alternative posting key and oil
for that one
gasps barrels of oil equivalent for that
one and simply water for that one you
say okay to that gives a slightly better
display on our annotations right now the
sizes are all set to a constant size to
go back and modify the display
parameters for that the Scott sizing is
set here on the scaling parameters tab
and you can see I've got this set to a
constant and all of my bubbles are
currently displayed at 25 millimeter
diameter but you don't have to do that
you can you can scale the size of these
bubbles according to the total value
that summed up in these variables and
when you're thinking about sizing things
you really have to consider are we
talking about the diameter of the circle
or the area of the circle so for
instance if somebody says I want my
circles twice as big
the numbers twice as big but what do you
mean by twice as big I mean it can be
the area's twice the size or the
diameter is twice the size also we want
to set up a distribution function and
what do I mean by distribution function
you want to think of a graph
I'm so here's a graph and my x-axis i
have the data values this is the value
coming from the variable selection list
that I've added my water gas number this
summed up on the y-axis i have the size
of the bubble inside of millimeters you
always have a point zero zero so
essentially at the data values zero you
get zero bubble size essentially knows
no no bubble at all the user then
specifies second point on this graph and
you specify a value in a size through
the interface so these options down here
reference value and reference diameter
graph backup are what specifying the
second . so that's up to you as to where
the second point is going to go next
you set a scaling type and the scaling
type can either be linear if its linear
you can get really large bubbles as this
value gets large that the size of the
bubbles can get unreasonably large as
well so you can kind of taper the size
down by using a logarithmic distribution
function they'll both pass through both
points on your graph but logarithmic
allows increase the size of the bubbles
as our value gets bigger but it will
help control bubbles that are too big
altogether so for instance by just set
this to linear and scale based on the
diameter and hit okay i get this just
ridiculous looking display so that's not
going to work for me in this particular
situation i can say well what would
happen if i set it to just the area
that helped somewhat but the bubbles are
still pretty unreasonable and just
really kind of wild you can change the
point to try to help this and you can
keep adjusting these values until you
get something that's going to work for
you
so for instance if i set it to
logarithmic to prevent those bubbles
from just exploding sit a diameter and
hit apply
I get slightly better display and go to
area and apply again it's getting a
little bit better take this size down
210 and 220 and maybe a little smaller
15 i'll say okay to that gives us a
reasonable looking map so that's how the
raw interface works
one other thing on the scaling
parameters you don't have to rely on
these distribution function options if
you'd like you can use scale against
another variable and in this way you can
include things in your bubble but
control the size of the bubble according
to something that's not in your variable
list and you can avoid everything all
together just by using use size
categories and in this option is pretty
simple if anything is less than 1000 you
can set the bubble size 23 millimeters
anything between 1001 and 10,000 we can
set it to another value and on and on
specifying user-defined sort of step
function now there's another example
just open up another map based on
porosity values in this case of some
creating bubbles just one value inside
the bubble which is controlling the
color if i go to my variable selection
you can see I'm making bubbles based on
porosity and i'm coloring the bubbles
according to a gradient this time I'm
not using solid villages and gradient so
anything that has zero porosity is going
to be purple anything with ten percent
process is going to be bright red also
the scaling parameters option i am using
this scale against another variable
even so I'm scaling the size of the
bubbles according to the oil value
column in my spreadsheet but i'm
coloring the things according to my
porosity values another example of
something else you can do is you can
make elliptical bottle maps and
analytical bubble maps can be quite
interesting so if you have some data
that has a directional component in it
like perhaps fracture patterns something
like that you can use this elliptical
bubble option and how those created my
kind of skipped over this little toggle
at the top right of the display bubble
map screen if you have it set to
circular that's what you get when all
the examples shown so far but you can
set this to elliptical and when you set
that to elliptical this size tab changes
in the science tab now that i'm under
the ellipse mode I can pick one of my
columns to control the azimuth and you
do have to have a column in your data
set that's going to specify the the
azimuth and that's just normal map map
azmuth the size of the ellipsis can
control in two ways you can pick just
major and minor in which case you can
pick two columns from your input data on
this isn't real world map sheet unit so
if your map she doesn't feet you'd have
to have columns in this in the
spreadsheet that would define the major
axis and feet in the minor axis and feet
or you can use this option aspect ratio
and you can use one of your columns to
find the aspect ratio so for instance i
know my porosity Tsar varying between
one in about eight or nine so if i'm
just using the porosity specify the
aspect ratio so though the closer these
things are to circle the closer my
porosity value is to being one longer
and thinner things i have higher
porosity values as a final example bring
up this multi-year map
and these can be quite interesting don't
forget you can stack bubbles on top of
one another
you don't have to vary the size
according to any of the data if we look
at how this map is generated i have
several layers they're making maps and
each one of these layers i have a
hard-coded constant diameter size and we
can zoom down in here what are we
looking at
we're looking at well gasps ratios over
years from 2008 2014 and they're very
interesting i think for instance this
well you can see water has been
encroaching overtime and this is real
data from the vom this is kind of an
interesting well i thought you can see
water have been drastically increasing
over time and obviously and this year
2013 they tried to do something and
whatever they did on this well really
increase the the water production and
then they corrected themselves back in
2014 and gotten back for more sort of
reasonable production and these this
idea of overlapping bubbles on top of
one another can make really just I think
very very interesting displays and
convey a lot of information to the end
users
alright that's really the end of the
demonstration go back just a brief final
thoughts
don't forget bubble maps are just visual
representations of numerical values and
the relative sizing of the pie watches
and the diameter quickly reflect the
magnitudes of the numbers that you're
using inside the bubble display their
commonly used for oil water and gas
ratios that they can be used for any
numerical values at all
don't forget you can also use ellipsis
it can be really helpful if you've got a
preferred direction in your data in
finally these multiple overlapping
bubbles can really be helpful as well
that's really all I had to say but just
like to thank everybody for taking the
time to view this and will now cover
your questions