WEBVTT 00:00:09.630 --> 00:00:10.660 Good morning, everyone, 00:00:10.660 --> 00:00:12.740 and thank you for attending this webinar. 00:00:12.740 --> 00:00:14.310 You'll be able to submit questions 00:00:14.310 --> 00:00:16.140 throughout the presentation by clicking 00:00:16.140 --> 00:00:17.680 the Q&A button in the center 00:00:17.680 --> 00:00:19.250 of the bottom of your window. 00:00:19.250 --> 00:00:20.620 You will see both the questions 00:00:20.620 --> 00:00:23.240 and responses after they have been answered. 00:00:23.240 --> 00:00:25.210 Some questions may be held for answer 00:00:25.210 --> 00:00:27.600 until the end of the presentation. 00:00:27.600 --> 00:00:29.670 Presentations and webinar recordings 00:00:29.670 --> 00:00:31.460 are all available by navigating 00:00:31.460 --> 00:00:33.930 to the RRC Regulatory webinars 00:00:33.930 --> 00:00:36.470 from the Oil and Gas Workshops and Seminars page 00:00:36.470 --> 00:00:39.120 on the Railroad Commission of Texas website. 00:00:39.120 --> 00:00:41.010 All right, let's go ahead and get started. 00:00:41.010 --> 00:00:43.070 Our presenters this morning are Matt Brown 00:00:43.070 --> 00:00:45.320 and Mark Maddox from the Well Mapping Department 00:00:45.320 --> 00:00:47.070 in the Administrative Compliance section 00:00:47.070 --> 00:00:48.470 of the Oil and Gas Division. 00:00:49.350 --> 00:00:51.000 Matt, Mark whenever you're ready. 00:00:57.247 --> 00:00:59.380 GIS Well Mapping Department, 00:00:59.380 --> 00:01:01.350 Prior to being at the Railroad Commission 00:01:01.350 --> 00:01:02.800 I was previously working in the 00:01:02.800 --> 00:01:06.310 Oil Field Services industry here in Texas. 00:01:06.310 --> 00:01:08.750 In addition, presenting will be Mark Maddox, 00:01:08.750 --> 00:01:12.120 also of the GIS Well Mapping Department. 00:01:12.120 --> 00:01:15.410 Today's presentation will review the functionality 00:01:15.410 --> 00:01:18.720 of the public GIS Viewer and spacial data 00:01:18.720 --> 00:01:21.510 available from the Railroad Commission. 00:01:21.510 --> 00:01:25.820 If you have any questions, please open the chat Q&A window 00:01:25.820 --> 00:01:27.800 and type in your questions. 00:01:27.800 --> 00:01:30.100 We will do our best to answer them both 00:01:30.100 --> 00:01:33.513 during the presentation and take questions at the end. 00:01:35.160 --> 00:01:36.383 Here's Mark Maddox. 00:01:37.960 --> 00:01:39.860 And thank you, Matt. 00:01:39.860 --> 00:01:42.400 Welcome to everybody attending the webinar. 00:01:42.400 --> 00:01:44.500 It's a little bit of a different format for us 00:01:44.500 --> 00:01:46.630 but we'll get through it. 00:01:46.630 --> 00:01:48.382 It'll be a good presentation. 00:01:48.382 --> 00:01:52.740 I think you'll allow for some extra attention, 00:01:52.740 --> 00:01:54.360 some further details that sometimes 00:01:54.360 --> 00:01:55.960 we might not be able to provide in 00:01:55.960 --> 00:01:58.500 in person environments so it's something new for us 00:01:58.500 --> 00:02:00.958 and hopefully everybody enjoys it. 00:02:00.958 --> 00:02:03.880 With that said, again, my name is Mark Maddox. 00:02:03.880 --> 00:02:05.730 Been with the Railroad Commission about 10 years. 00:02:05.730 --> 00:02:08.170 Started in Drilling Permits and moved over 00:02:08.170 --> 00:02:11.210 to Well Mapping and then been here 00:02:11.210 --> 00:02:12.710 in this department ever since. 00:02:16.440 --> 00:02:17.943 So with that said, 00:02:19.799 --> 00:02:21.347 what is the the Well Mapping Department, 00:02:21.347 --> 00:02:23.793 and what do we have to do with the GIS Viewer? 00:02:24.950 --> 00:02:27.150 The department maintains most of the layers 00:02:27.150 --> 00:02:28.440 that are in the Viewer. 00:02:28.440 --> 00:02:31.330 So we're responsible for editing survey lines, 00:02:31.330 --> 00:02:36.180 oil and gas wells, conducting research on well locations. 00:02:36.180 --> 00:02:39.590 Different well spots, if we have API number discrepancies. 00:02:39.590 --> 00:02:41.840 Wells that should or should not be there, 00:02:41.840 --> 00:02:43.083 maybe missing wells. 00:02:43.970 --> 00:02:46.993 Locations that have been misplaced. 00:02:47.960 --> 00:02:51.230 And before we get into the Viewer and the data itself 00:02:51.230 --> 00:02:52.603 and how we can use it, 00:02:54.041 --> 00:02:57.140 what I wanna talk about is where we came from 00:02:57.140 --> 00:03:00.103 'cause that plays a big role into what we do. 00:03:01.290 --> 00:03:05.940 So before GIS, all of the well locations 00:03:05.940 --> 00:03:08.740 were kept on cloth or linen maps. 00:03:08.740 --> 00:03:12.340 And each county has a minimum of one map with up to, 00:03:12.340 --> 00:03:15.520 I think the most I've seen is four maps for a county, 00:03:15.520 --> 00:03:20.000 depending the county size and the well density. 00:03:20.000 --> 00:03:22.070 Typical scales are one to 2,000 00:03:22.070 --> 00:03:24.920 or one inch equals 4,000 feet. 00:03:24.920 --> 00:03:27.753 And to add wells to those, they were hand posted. 00:03:28.660 --> 00:03:30.940 So what a processor would do 00:03:30.940 --> 00:03:32.660 is they would take a scale bar, 00:03:32.660 --> 00:03:35.060 similar to what you see on the screen here, 00:03:35.060 --> 00:03:37.400 take the form one or the W one that was submitted 00:03:37.400 --> 00:03:40.010 along with the plat and scale 00:03:40.010 --> 00:03:43.933 off the well location and put a dot on the map. 00:03:44.850 --> 00:03:47.000 And that presents some issues when you 00:03:47.000 --> 00:03:49.730 get into keeping track of wells 00:03:49.730 --> 00:03:54.328 that might be 200 feet apart, 300 feet apart. 00:03:54.328 --> 00:03:58.000 You know, some of the issues might become evident 00:03:58.000 --> 00:04:00.940 when you look at the picture we have on the slide here. 00:04:00.940 --> 00:04:02.670 So in the lower right hand corner 00:04:02.670 --> 00:04:07.640 that is a picture of a typical busy area 00:04:07.640 --> 00:04:09.100 on one of our linen maps. 00:04:09.100 --> 00:04:12.740 So you see our map storage up on the top left hand corner. 00:04:12.740 --> 00:04:16.160 We roll out those maps and all well locations 00:04:16.160 --> 00:04:18.283 were tracked on there. 00:04:19.980 --> 00:04:21.810 That presents an issue as far 00:04:21.810 --> 00:04:24.460 as data associated with those wells. 00:04:24.460 --> 00:04:26.690 In the GIS it's easy nowadays, click on the well, 00:04:26.690 --> 00:04:28.790 pulls up anything you wanna know about it. 00:04:29.690 --> 00:04:32.260 Before that, everything had to be handwritten 00:04:32.260 --> 00:04:35.110 on the map to tell you what that spot is. 00:04:35.110 --> 00:04:36.710 You can kinda see the spaghetti lines 00:04:36.710 --> 00:04:39.750 that go out from the middle to the pieces 00:04:39.750 --> 00:04:43.010 of information on the far left hand side, 00:04:43.010 --> 00:04:45.373 down in this area right over here, 00:04:46.550 --> 00:04:48.823 or up in the right hand corner. 00:04:50.390 --> 00:04:51.400 That presents a problem, 00:04:51.400 --> 00:04:54.390 so that's one of the reasons that we are still 00:04:54.390 --> 00:04:57.220 in a constant state of maintenance of the layers. 00:04:57.220 --> 00:05:01.400 Some well locations predate even our linen maps, 00:05:01.400 --> 00:05:04.310 that's not to say we don't have the records for them, 00:05:04.310 --> 00:05:07.800 it's just that when we created the maps 00:05:07.800 --> 00:05:10.290 we had to add every one of these spots manually 00:05:10.290 --> 00:05:12.560 into the GIS and at that time we didn't 00:05:12.560 --> 00:05:15.640 have any information to associate with that spot. 00:05:15.640 --> 00:05:17.690 So if you ever see a well that doesn't have 00:05:17.690 --> 00:05:20.090 an API number, doesn't have a well number, 00:05:20.090 --> 00:05:22.950 all it says is the FIPS code, 00:05:22.950 --> 00:05:26.210 so one, two, three, that's one of those wells 00:05:26.210 --> 00:05:28.050 that's gonna require research. 00:05:28.050 --> 00:05:29.560 That's one of the things that we can go through 00:05:29.560 --> 00:05:33.313 and correct as part of the Well Mapping Department. 00:05:35.130 --> 00:05:36.850 So where do we go to now? 00:05:36.850 --> 00:05:38.820 Now we're at the public GIS Viewer. 00:05:38.820 --> 00:05:40.540 We took all of the well locations, 00:05:40.540 --> 00:05:42.300 like we saw on those linen maps, 00:05:42.300 --> 00:05:46.613 copied them over, and put them into digital format. 00:05:47.490 --> 00:05:51.210 To get everything built and transferred over 00:05:51.210 --> 00:05:54.290 from survey lines to well locations, 00:05:54.290 --> 00:05:57.350 attribute information, that was approximately 00:05:57.350 --> 00:06:02.240 a 10-year process that was initially funded 00:06:02.240 --> 00:06:04.390 by a grant from the federal government 00:06:04.390 --> 00:06:08.320 to help keep track of land, wells on federal land. 00:06:08.320 --> 00:06:10.604 And we kept going with that outside of the counties 00:06:10.604 --> 00:06:13.063 where there's federal land in Texas. 00:06:14.100 --> 00:06:18.980 And we're on the current iteration of the GIS Viewer. 00:06:18.980 --> 00:06:20.840 We'll go ahead and take a quick look at that now, 00:06:20.840 --> 00:06:23.370 kind of elaborate on what you see 00:06:23.370 --> 00:06:25.883 when you open up the Viewer. 00:06:28.252 --> 00:06:30.210 So as you open up the Viewer, 00:06:30.210 --> 00:06:34.330 it basically is composed of three different parks. 00:06:34.330 --> 00:06:37.200 The first one is your Viewer screen 00:06:37.200 --> 00:06:38.763 which is the map itself, 00:06:39.630 --> 00:06:43.880 that has your scroll bar up in the upper left hand corner, 00:06:43.880 --> 00:06:45.193 you can zoom in and out. 00:06:47.110 --> 00:06:49.590 You could also hold down the Shift key 00:06:49.590 --> 00:06:52.440 and it'll allow you to draw a box on the map, 00:06:52.440 --> 00:06:54.540 if you know the area you're interested in. 00:06:56.939 --> 00:07:00.997 And if you zoom in closer, find your area of interest, 00:07:02.961 --> 00:07:07.080 it has a detail window up in the top right hand corner 00:07:07.080 --> 00:07:08.960 so if you zoom in and just need a little bit 00:07:08.960 --> 00:07:11.310 of a better idea of where you're at, 00:07:11.310 --> 00:07:14.070 you can open and close that as you need. 00:07:14.070 --> 00:07:15.800 If you need to get out of the Viewer 00:07:15.800 --> 00:07:17.700 and go back to RRC Home Page 00:07:17.700 --> 00:07:21.080 to access a completion report or something like that, 00:07:21.080 --> 00:07:23.540 the RRC logo in the lower right hand corner 00:07:24.450 --> 00:07:27.120 will open up the Railroad Commission home page 00:07:27.120 --> 00:07:29.360 and then you can navigate to wherever you need 00:07:29.360 --> 00:07:33.030 to go from there, say, the data online research queries, 00:07:33.030 --> 00:07:35.893 or one of the other sections of the website. 00:07:37.080 --> 00:07:41.020 Also if you need coordinates for a specific location 00:07:41.020 --> 00:07:43.460 there is an interactive coordinate tool 00:07:43.460 --> 00:07:46.850 down in the lower right hand corner of the screen. 00:07:46.850 --> 00:07:48.300 That'll give you the coordinates 00:07:48.300 --> 00:07:51.150 for wherever your mouse pointer is at that point in time, 00:07:52.040 --> 00:07:54.823 and it is in WGS 84, 00:07:55.742 --> 00:07:56.900 and we'll talk a little bit about 00:07:56.900 --> 00:07:59.270 the different coordinate systems and datums 00:07:59.270 --> 00:08:01.743 that we use at the Commission here. 00:08:03.270 --> 00:08:08.250 The second part of the Viewer screen is the toolbar. 00:08:08.250 --> 00:08:10.040 This is how you will interact with any 00:08:10.040 --> 00:08:13.313 of the layers on the map itself. 00:08:14.240 --> 00:08:17.300 Tools are all opened by clicking on 'em 00:08:17.300 --> 00:08:20.530 and when they have a light blue color behind them, 00:08:20.530 --> 00:08:21.800 that's the active tool. 00:08:21.800 --> 00:08:25.040 So right now this would be the What's Here tool. 00:08:25.040 --> 00:08:26.980 If you're gonna the measurement tool, 00:08:26.980 --> 00:08:28.103 you'll open that up. 00:08:29.100 --> 00:08:31.213 You close it, it'll inactivate it. 00:08:32.960 --> 00:08:35.210 The third portion of the Viewer screen 00:08:35.210 --> 00:08:38.510 is the visibility and legend pane 00:08:38.510 --> 00:08:41.430 and that's on the left hand side over here. 00:08:41.430 --> 00:08:42.970 And there's two buttons up in the far 00:08:42.970 --> 00:08:45.770 left hand corner for visibility 00:08:45.770 --> 00:08:47.570 and the other one for legend. 00:08:47.570 --> 00:08:51.503 Visibility is the layers that are viewable on the map. 00:08:52.640 --> 00:08:53.690 So what can you see? 00:08:53.690 --> 00:08:56.570 Right now you'll notice pipelines is turned off, 00:08:56.570 --> 00:08:58.060 most of the layers are turned off, 00:08:58.060 --> 00:09:01.720 so this is the default orientation for the layers. 00:09:01.720 --> 00:09:05.710 Basically wells, surveys, and districts 00:09:05.710 --> 00:09:07.900 are the three main layers that we have turned on. 00:09:07.900 --> 00:09:10.690 If you need anything else, you can come through 00:09:10.690 --> 00:09:14.340 and check those specific layers and turn 'em on. 00:09:14.340 --> 00:09:16.140 One thing you will notice here 00:09:17.980 --> 00:09:21.560 is that just because a layer is turned on 00:09:21.560 --> 00:09:25.640 doesn't mean it will display at any scale on the map. 00:09:25.640 --> 00:09:29.320 So we'll jump over to the legend real quick 00:09:29.320 --> 00:09:31.530 and we see this is the only thing we have right now 00:09:31.530 --> 00:09:34.100 is districts, even though we have wells, 00:09:34.100 --> 00:09:37.623 pipelines, surveys, and a few other layers turned on. 00:09:38.530 --> 00:09:42.140 So the layers in the Viewer are scale dependent, 00:09:42.140 --> 00:09:44.450 they don't show up until you've zoomed 00:09:44.450 --> 00:09:46.960 into an appropriate level. 00:09:46.960 --> 00:09:48.860 So, if you noticed, I zoomed in a little closer 00:09:48.860 --> 00:09:51.250 and now we can see pipelines, alert areas, 00:09:51.250 --> 00:09:54.580 counties, and a few of our wells, 00:09:54.580 --> 00:09:56.883 excuse me, OCP and VCP sites. 00:09:57.950 --> 00:10:01.680 We do that in order to try and keep the clutter down. 00:10:01.680 --> 00:10:03.330 If we showed wells out at the state level, 00:10:03.330 --> 00:10:04.650 it would just be a mass of dots 00:10:04.650 --> 00:10:06.713 and you couldn't make any sense of it. 00:10:13.430 --> 00:10:14.780 So now you see well locations, 00:10:14.780 --> 00:10:16.750 but, still, even though we're zoomed in, 00:10:16.750 --> 00:10:19.820 the wells show up, the API numbers aren't there, 00:10:19.820 --> 00:10:21.690 you'll have to zoom in a little bit further 00:10:21.690 --> 00:10:23.163 for that information to show. 00:10:24.580 --> 00:10:28.520 As far as the items from the legend, 00:10:28.520 --> 00:10:30.840 it's interactive so it'll only show 00:10:30.840 --> 00:10:33.370 what you have checked in the visibility pane. 00:10:33.370 --> 00:10:38.370 If you do need a copy of all of the symbols that we have, 00:10:39.190 --> 00:10:42.530 you can click on the PDF symbol 00:10:42.530 --> 00:10:45.200 in the upper right hand corner of the legend 00:10:45.200 --> 00:10:48.210 and that will open the public GIS view legend 00:10:48.210 --> 00:10:50.150 which is anything and everything 00:10:50.150 --> 00:10:51.870 that could show up on the map, 00:10:51.870 --> 00:10:53.943 and its associated symbol. 00:10:55.740 --> 00:10:58.420 So that's good to have if you're just not familiar 00:10:58.420 --> 00:10:59.910 with what one of the symbols is, 00:10:59.910 --> 00:11:01.010 something pops up on the map. 00:11:01.010 --> 00:11:02.160 I find it easier than trying 00:11:02.160 --> 00:11:04.223 to scroll through the legend over here. 00:11:05.450 --> 00:11:09.300 You can close this pane if you'd like by clicking the X. 00:11:09.300 --> 00:11:10.810 If you need to get it back, 00:11:10.810 --> 00:11:13.810 just click on your legend or visibility button 00:11:13.810 --> 00:11:15.393 in the upper left hand corner. 00:11:17.430 --> 00:11:19.263 Mark, I have a couple of questions. 00:11:20.660 --> 00:11:21.493 Sure. 00:11:21.493 --> 00:11:24.650 Let's see, so the first one preferred internet browser. 00:11:24.650 --> 00:11:27.043 I prefer, there's not a preferred one. 00:11:27.880 --> 00:11:30.590 It should work in Chrome, Firefox, 00:11:30.590 --> 00:11:32.490 or Internet Explorer. 00:11:32.490 --> 00:11:36.280 Depending on the settings on your computer 00:11:36.280 --> 00:11:40.690 or sometimes the IT department's restrictions, 00:11:40.690 --> 00:11:44.270 we get calls from people that have problems 00:11:44.270 --> 00:11:46.210 with one Viewer or another. 00:11:46.210 --> 00:11:48.990 So if you can't get it to work in Chrome, 00:11:48.990 --> 00:11:51.640 try Firefox, try Internet Explorer 00:11:51.640 --> 00:11:54.040 to see if one of those will work better for you. 00:11:56.630 --> 00:11:57.463 Let's see. 00:11:57.463 --> 00:11:59.600 I personally work in Chrome, here at the Commission. 00:11:59.600 --> 00:12:00.800 That's the one that I work in. 00:12:00.800 --> 00:12:03.960 I have some coworkers that use Firefox 00:12:03.960 --> 00:12:05.870 and others that use Internet Explorer 00:12:05.870 --> 00:12:08.710 and we're all able to get our work done 00:12:08.710 --> 00:12:12.100 and use the public Viewer to help us 00:12:12.100 --> 00:12:15.203 accomplish our work in any of those three browsers. 00:12:17.700 --> 00:12:18.760 Looks like we got another question. 00:12:18.760 --> 00:12:23.320 Says, are we showing the surface wells or the bottom wells? 00:12:23.320 --> 00:12:27.350 So every well symbol, and we'll get into this 00:12:27.350 --> 00:12:28.690 a little bit later when we show you some 00:12:28.690 --> 00:12:30.350 of our downloadable data, 00:12:30.350 --> 00:12:34.460 but every symbol and well location is composed of two spots. 00:12:34.460 --> 00:12:35.507 You have a surface location, 00:12:35.507 --> 00:12:37.750 and you have a bottom location. 00:12:37.750 --> 00:12:40.290 And that is true for a vertical well 00:12:40.290 --> 00:12:42.130 or a horizontal well. 00:12:42.130 --> 00:12:45.120 The way we simplify in our GIS Viewer 00:12:45.120 --> 00:12:47.030 is for a vertical well, 00:12:47.030 --> 00:12:49.320 we only show the bottom hole location 00:12:50.400 --> 00:12:52.160 'cause there's really no other information 00:12:52.160 --> 00:12:55.190 that's associated with a surface for a vertical well 00:12:55.190 --> 00:12:58.940 'cause they're essentially one on top of the other 00:12:58.940 --> 00:13:00.660 and that's determined based on a review 00:13:00.660 --> 00:13:03.340 of either the inclination report 00:13:03.340 --> 00:13:06.740 or the directional survey if our engineering department 00:13:06.740 --> 00:13:09.200 needs to see one for some reason. 00:13:09.200 --> 00:13:11.630 When we get to horizontal and directional wells, 00:13:11.630 --> 00:13:14.740 that's where we show you both the surface location 00:13:14.740 --> 00:13:17.220 and the bottom hole location. 00:13:17.220 --> 00:13:19.297 So an example of that would be, 00:13:19.297 --> 00:13:22.373 let me clear our pipelines here, unclutter it. 00:13:25.410 --> 00:13:27.910 Like this well right here. 00:13:27.910 --> 00:13:31.520 So this well number 16H, horizontal well, 00:13:31.520 --> 00:13:35.130 indicated by the pentagon symbol. 00:13:35.130 --> 00:13:37.430 That would be your surface location. 00:13:37.430 --> 00:13:40.793 And then your bottom hole location will be the, 00:13:42.140 --> 00:13:46.520 always be a circular symbol of some sort 00:13:46.520 --> 00:13:49.580 with different identifying characteristics 00:13:49.580 --> 00:13:50.993 based on the type of well. 00:13:52.017 --> 00:13:52.920 And those are in the legend, 00:13:52.920 --> 00:13:54.600 so a green dot is an oil well, 00:13:54.600 --> 00:13:58.300 a open red circle with the rays coming off of it, 00:13:58.300 --> 00:13:59.933 kinda like a sun, is a gas well. 00:14:01.040 --> 00:14:02.990 That will be your bottom hole location. 00:14:04.110 --> 00:14:06.730 That's determined if it's a permitted well, 00:14:06.730 --> 00:14:09.030 that's determined based on the plat that's submitted. 00:14:09.030 --> 00:14:11.210 And if it's a completed well that's determined 00:14:11.210 --> 00:14:13.060 based upon the directional survey 00:14:13.060 --> 00:14:15.323 that accompanies the W-2 or G-1. 00:14:17.770 --> 00:14:19.280 We do use the same symbology 00:14:19.280 --> 00:14:21.560 for all bottom hole locations, 00:14:21.560 --> 00:14:24.730 whether it's a vertical well or a directional horizontal, 00:14:24.730 --> 00:14:28.203 so the bottom hole location will remain the same. 00:14:35.350 --> 00:14:36.820 And then one other quick thing 00:14:36.820 --> 00:14:38.980 is there are highlights that are associated 00:14:40.600 --> 00:14:43.499 with the wells to do well logs, 00:14:43.499 --> 00:14:45.640 (indistinct) high cost type sands, things like that. 00:14:45.640 --> 00:14:47.810 You can turn these on and off 00:14:47.810 --> 00:14:51.600 but only one highlight can be applied at a time 00:14:51.600 --> 00:14:54.820 so you can't do well logs and the high cost type sands, 00:14:54.820 --> 00:14:56.470 so you can only do one at a time. 00:14:57.513 --> 00:14:59.820 I think that pretty much covers the main features 00:14:59.820 --> 00:15:02.770 and the three biggest parts of the Viewer. 00:15:02.770 --> 00:15:06.090 We'll talk a little bit about navigating with it, 00:15:06.090 --> 00:15:08.810 identifying wells, and what you can get 00:15:08.810 --> 00:15:11.490 to through the Viewer here in just a little bit. 00:15:11.490 --> 00:15:13.703 So we'll jump back over to the presentation. 00:15:19.100 --> 00:15:21.910 And we're gonna talk a little bit about datums. 00:15:21.910 --> 00:15:25.033 This is where I get kind of into the GIS side of things, 00:15:26.080 --> 00:15:28.880 you know, get a little bit nerdy, I guess you could say. 00:15:30.270 --> 00:15:33.350 But it's important to using our data 00:15:33.350 --> 00:15:36.690 and understanding how you're entering information. 00:15:36.690 --> 00:15:38.780 So what is a datum? 00:15:38.780 --> 00:15:41.200 It's essentially a representation 00:15:41.200 --> 00:15:45.500 of the earth's surface in one form or fashion. 00:15:45.500 --> 00:15:48.730 And that representation can be either a local 00:15:48.730 --> 00:15:50.293 or a global representation. 00:15:51.800 --> 00:15:53.600 When we think of the earth, 00:15:53.600 --> 00:15:55.210 if you look at a globe, 00:15:55.210 --> 00:15:57.320 I've gone one sitting in my son's room at home, 00:15:57.320 --> 00:16:00.290 it's a nice, round circle, perfectly smooth, 00:16:00.290 --> 00:16:02.363 just like a basketball, let's say. 00:16:03.210 --> 00:16:06.370 But that's not the way the earth actually is. 00:16:06.370 --> 00:16:07.820 The earth is an ellipsoid, 00:16:07.820 --> 00:16:09.920 which is kinda like a squashed basketball 00:16:09.920 --> 00:16:12.720 where it's a little bit wider at the equator 00:16:12.720 --> 00:16:16.420 and a little bit narrower or skinnier from pole to pole, 00:16:16.420 --> 00:16:18.470 north pole to south pole. 00:16:18.470 --> 00:16:20.070 So how do we deal with that? 00:16:20.070 --> 00:16:22.490 That's where we get into datums. 00:16:22.490 --> 00:16:24.740 And the datum can be moved around 00:16:24.740 --> 00:16:29.060 and adjusted to best fit an area locally. 00:16:29.060 --> 00:16:31.740 So an example of that would be like 00:16:31.740 --> 00:16:36.740 the Clarke 1866 ellipsoid that is used for NAD 27. 00:16:37.450 --> 00:16:39.210 So that's a specific ellipsoid 00:16:39.210 --> 00:16:42.580 that fits the North American continent 00:16:42.580 --> 00:16:46.623 and can accurately portray coordinates in that system. 00:16:48.440 --> 00:16:51.513 Another one would be GRS 80, which is the NAD 83. 00:16:53.170 --> 00:16:55.770 That's essentially an updated version of where, 00:16:55.770 --> 00:16:59.330 rather than using Meades Ranch Kansas 00:16:59.330 --> 00:17:00.870 for the center of the system, 00:17:00.870 --> 00:17:03.760 like is used for NAD 27, 00:17:03.760 --> 00:17:06.800 it's an earth centric datum. 00:17:06.800 --> 00:17:08.230 So they use satellite measurements 00:17:08.230 --> 00:17:10.420 to determine the center of the earth 00:17:10.420 --> 00:17:12.810 as best they could and then use that ellipsoid 00:17:12.810 --> 00:17:15.233 to fit the North American continent. 00:17:16.280 --> 00:17:19.490 Another example of that would be the WGS 84. 00:17:19.490 --> 00:17:20.733 So that's a world. 00:17:21.800 --> 00:17:23.370 It's applicable to anywhere in the world, 00:17:23.370 --> 00:17:26.350 so if your coordinates are in WGS 84 00:17:26.350 --> 00:17:28.700 you can use those in Australia, 00:17:28.700 --> 00:17:29.910 you can use them in the U.S., 00:17:29.910 --> 00:17:31.830 you can use them in South America, 00:17:31.830 --> 00:17:33.457 you can use that datum anywhere in the world. 00:17:33.457 --> 00:17:36.810 And it's generally what you'll see in Google Maps. 00:17:36.810 --> 00:17:38.870 Usually your GPS systems are defaulted 00:17:38.870 --> 00:17:41.850 to WGS 84, things like that, 00:17:41.850 --> 00:17:45.123 because it's applicable outside of just the U.S. 00:17:49.060 --> 00:17:51.530 It looks like we have a question related to forms. 00:17:51.530 --> 00:17:55.300 So it says, is the map updated as soon 00:17:55.300 --> 00:17:57.543 as RRC receives forms? 00:17:58.430 --> 00:18:02.440 So the map is updated after the form has made 00:18:02.440 --> 00:18:05.463 its way through its review and approval process. 00:18:06.340 --> 00:18:09.963 So if we go, jump back to the Viewer. 00:18:29.030 --> 00:18:31.230 When a form comes into the Commission, 00:18:31.230 --> 00:18:35.600 the mapping department is not the department that decides 00:18:35.600 --> 00:18:39.330 is it gonna be approved or is it not. 00:18:39.330 --> 00:18:42.180 So we have Drilling Permits that works drilling permits. 00:18:42.180 --> 00:18:44.610 We have Well Compliance that works the completions. 00:18:44.610 --> 00:18:48.130 W-3s is a team effort from the, 00:18:48.130 --> 00:18:50.430 well completions are a team effort as well, 00:18:50.430 --> 00:18:54.000 from District Office and several units here 00:18:54.000 --> 00:18:55.760 at the Commission, engineering, 00:18:55.760 --> 00:18:58.050 law compliance and a couple of others. 00:18:58.050 --> 00:19:00.660 So they will all review the forms, 00:19:00.660 --> 00:19:02.950 process them, and then provide them to us. 00:19:02.950 --> 00:19:05.910 So as soon as a drilling permit 00:19:05.910 --> 00:19:07.250 is submitted to the Commission, 00:19:07.250 --> 00:19:10.600 it's added to the Viewer as a permitted location, 00:19:10.600 --> 00:19:12.370 but that symbol won't be changed 00:19:12.370 --> 00:19:15.500 until the well is drilled. 00:19:15.500 --> 00:19:18.620 The operator submits their paperwork 00:19:18.620 --> 00:19:21.810 and then gets approved 00:19:21.810 --> 00:19:24.410 by the appropriate department here. 00:19:24.410 --> 00:19:27.390 So we won't say that well is plugged 00:19:27.390 --> 00:19:29.840 until the W-3 has been approved 00:19:29.840 --> 00:19:31.220 by the Railroad Commission. 00:19:31.220 --> 00:19:35.800 As soon as that's done, then we will go in 00:19:35.800 --> 00:19:37.840 and we'll make the change to the symbol 00:19:37.840 --> 00:19:39.810 and change it over from say an oil well, 00:19:39.810 --> 00:19:40.710 like number sever here, 00:19:40.710 --> 00:19:43.693 over to a plug location, like this 2407. 00:19:44.770 --> 00:19:46.630 So it's after the form approval, 00:19:46.630 --> 00:19:50.023 that's when we'll update the GIS. 00:19:51.130 --> 00:19:52.840 And that can take varying amounts of time 00:19:52.840 --> 00:19:55.230 depending on the form, the workload, 00:19:55.230 --> 00:19:56.670 how many they're getting, 00:19:56.670 --> 00:19:59.030 are there any issues with the forms, 00:19:59.030 --> 00:20:03.070 those all affect how quickly that symbol will updated 00:20:03.070 --> 00:20:05.433 based upon the work that was done at the field. 00:20:10.350 --> 00:20:12.650 Jump back over to coordinates here. 00:20:12.650 --> 00:20:16.040 So, what do we accept at the Commission? 00:20:16.040 --> 00:20:17.900 The three systems that we use are 00:20:17.900 --> 00:20:22.503 NAD 27, NAD 83, and WGS 84. 00:20:24.589 --> 00:20:28.690 There are basically two different types 00:20:28.690 --> 00:20:30.830 of coordinate systems you can submit for geographic, 00:20:30.830 --> 00:20:33.530 it's either in degrees, minutes, and seconds, 00:20:33.530 --> 00:20:35.083 or in decimal degrees. 00:20:36.000 --> 00:20:38.530 And we'll also use state plane coordinate systems 00:20:38.530 --> 00:20:42.380 and those are either NAD 27, or NAD 83. 00:20:42.380 --> 00:20:45.270 In Texas there's five different zones 00:20:45.270 --> 00:20:49.450 to allow for the most accurate representation. 00:20:49.450 --> 00:20:53.130 They go from north to south, one through five, 00:20:53.130 --> 00:20:56.420 and all of their coordinates will always be positive. 00:20:56.420 --> 00:20:58.810 So remember that, that you'll never have 00:20:58.810 --> 00:21:02.370 a negative value for the state plane system. 00:21:02.370 --> 00:21:05.560 And there's two different things that are required. 00:21:05.560 --> 00:21:09.420 You're gonna need the datum, so NAD 27 or NAD 83, 00:21:09.420 --> 00:21:12.080 and then the zone to be able to use 00:21:12.080 --> 00:21:13.780 the state plane coordinate system. 00:21:20.850 --> 00:21:23.023 So search and navigation. 00:21:25.390 --> 00:21:27.770 There's different ways to move around on the Viewer. 00:21:27.770 --> 00:21:30.077 The three biggest ones I put on this slide here 00:21:30.077 --> 00:21:34.393 are API number, lease ID number, or survey information. 00:21:36.470 --> 00:21:41.470 Not all of the information has to be entered for each one 00:21:41.620 --> 00:21:42.670 with the exception of API, 00:21:42.670 --> 00:21:44.840 obviously you need the whole API number. 00:21:44.840 --> 00:21:47.100 The lease ID number, you can put that in 00:21:47.100 --> 00:21:49.840 but you don't necessarily have to have the district, 00:21:49.840 --> 00:21:51.160 but if you don't have the district 00:21:51.160 --> 00:21:54.240 you could end up with different leases 00:21:54.240 --> 00:21:57.533 'cause the oil IDs can, 00:21:59.170 --> 00:22:01.410 they can repeat throughout 00:22:01.410 --> 00:22:03.110 the Railroad Commission districts. 00:22:04.980 --> 00:22:06.830 Survey information, you kinda have to be careful with 00:22:06.830 --> 00:22:09.750 because spelling, punctuation is important. 00:22:09.750 --> 00:22:12.840 Even spaces can affect what's gonna show up in the results. 00:22:12.840 --> 00:22:16.840 So this is a situation where I would say less is more. 00:22:16.840 --> 00:22:20.710 So if we have less information, 00:22:20.710 --> 00:22:23.363 so if you know it's the H and TCRR Company, 00:22:24.570 --> 00:22:27.560 maybe you put H space and, 00:22:27.560 --> 00:22:29.840 in case we have TCRR Company 00:22:29.840 --> 00:22:32.890 spaced out a little bit differently, enter it, 00:22:32.890 --> 00:22:35.603 and then it'll bring up any results that match that. 00:22:38.530 --> 00:22:39.850 When you're in Viewer, you can navigate it 00:22:39.850 --> 00:22:41.580 to an area you're interested in. 00:22:41.580 --> 00:22:43.830 There's a few different ways to provide 00:22:43.830 --> 00:22:46.020 or to pull information about the well. 00:22:46.020 --> 00:22:47.510 The first one is the Hover tool. 00:22:47.510 --> 00:22:51.650 This provides the most concise set of information. 00:22:51.650 --> 00:22:53.380 Push your mouse cursor over a well 00:22:53.380 --> 00:22:56.990 and it will display a small amount of information 00:22:56.990 --> 00:23:00.070 about the well, as well as the operator 00:23:00.070 --> 00:23:01.920 that's currently operating that well. 00:23:04.200 --> 00:23:06.130 The Identify tool, this is gonna provide 00:23:06.130 --> 00:23:08.960 a complete set of information about the well. 00:23:08.960 --> 00:23:11.200 It will elaborate on things, 00:23:11.200 --> 00:23:13.750 like the last permit that was submitted, 00:23:13.750 --> 00:23:15.200 coordinates for the location. 00:23:17.162 --> 00:23:20.270 It will talk about any lease IDs 00:23:20.270 --> 00:23:23.240 that were applied to that well, 00:23:23.240 --> 00:23:24.730 so not just the current ID, 00:23:24.730 --> 00:23:27.021 but any historic information. 00:23:27.021 --> 00:23:30.470 It will provide links to different portions 00:23:30.470 --> 00:23:31.980 of the Railroad Commission website. 00:23:31.980 --> 00:23:35.800 So the Viewer is a tool to provide information. 00:23:35.800 --> 00:23:39.130 So it's not gonna give you the answer, necessarily, 00:23:39.130 --> 00:23:43.630 it will provide the answer through the forms 00:23:43.630 --> 00:23:45.343 that we process here. 00:23:46.640 --> 00:23:48.210 Could be through the drilling permits, 00:23:48.210 --> 00:23:51.270 disposal permits, any historic information 00:23:51.270 --> 00:23:53.480 through our new distributed doc system, 00:23:53.480 --> 00:23:55.680 which we'll talk about here in a little bit. 00:23:57.430 --> 00:24:01.190 Here's a larger picture of the identify results. 00:24:01.190 --> 00:24:02.720 One thing I do wanna mentioned about this 00:24:02.720 --> 00:24:06.570 is the completion is current and historical records. 00:24:06.570 --> 00:24:08.860 So that could be, it could have multiple 00:24:08.860 --> 00:24:13.490 completion records, you know, if the well was drilled, 00:24:13.490 --> 00:24:16.340 re-completed, maybe it was plugged, 00:24:16.340 --> 00:24:17.690 and then they came back and reentered it 00:24:17.690 --> 00:24:19.450 and completed it in a different formation. 00:24:19.450 --> 00:24:21.160 So that would be an example where you'd have 00:24:21.160 --> 00:24:24.210 three different completion records for that well, 00:24:24.210 --> 00:24:27.400 two inactive and one that would be 00:24:27.400 --> 00:24:29.003 on schedule or currently active. 00:24:33.000 --> 00:24:34.210 Another way to pull information. 00:24:34.210 --> 00:24:37.570 So we talked about how to identify a single well, 00:24:37.570 --> 00:24:41.333 how can you get well information for multiple wells? 00:24:42.810 --> 00:24:46.193 We have the download wells within a defined radius. 00:24:47.560 --> 00:24:49.670 That's a long way to say, pull information 00:24:49.670 --> 00:24:52.150 about the wells within this circle. 00:24:52.150 --> 00:24:57.150 And you can do a radius anywhere from zero up to 2.5 miles. 00:24:59.060 --> 00:25:02.500 You'll enter that information into the radius box 00:25:02.500 --> 00:25:05.390 and it will 00:25:05.390 --> 00:25:07.830 place a circle on the map 00:25:07.830 --> 00:25:11.890 and it's going to highlight all the locations 00:25:11.890 --> 00:25:13.420 that are within that circle. 00:25:13.420 --> 00:25:15.260 It'll tell you how many service locations 00:25:15.260 --> 00:25:17.590 are within there, that would be like the 00:25:17.590 --> 00:25:19.710 pentagon symbol we looked at earlier. 00:25:19.710 --> 00:25:22.830 It'll tell you how many bottom locations are in there, 00:25:22.830 --> 00:25:25.670 those'll be the either horizontal or directional, 00:25:25.670 --> 00:25:27.780 or vertical locations. 00:25:27.780 --> 00:25:31.220 And it will allow you to export those results 00:25:31.220 --> 00:25:34.683 to a CSV file that you can then use. 00:25:39.010 --> 00:25:42.270 So one thing is we did have to put a limit 00:25:42.270 --> 00:25:44.690 on the number of wells that you can download, 00:25:44.690 --> 00:25:49.050 and that is to minimize the interruptions 00:25:49.050 --> 00:25:52.160 and disruptions this tool can cause 00:25:52.160 --> 00:25:55.770 if there are a area of high well density. 00:25:55.770 --> 00:25:58.510 So that is 1,000 results. 00:25:58.510 --> 00:26:00.590 So if there's more than a thousand results 00:26:00.590 --> 00:26:04.160 inside of your radius, you're gonna get a few boxes 00:26:04.160 --> 00:26:05.770 that show up on the screen. 00:26:05.770 --> 00:26:09.603 There's gonna be one that says the page is unresponsive, 00:26:10.550 --> 00:26:13.300 but just be patient and wait, it shouldn't take too long. 00:26:13.300 --> 00:26:15.800 Kinda depends on your internet connection a little bit, 00:26:15.800 --> 00:26:16.960 but it shouldn't take very long, 00:26:16.960 --> 00:26:18.830 that will go away, and it'll pop up 00:26:19.810 --> 00:26:22.330 the window similar to this here. 00:26:22.330 --> 00:26:26.550 It'll tell you how many results you have 00:26:26.550 --> 00:26:29.170 for surface and bottoms, and it's one thousand of each. 00:26:29.170 --> 00:26:30.880 So it's not a combined total. 00:26:30.880 --> 00:26:33.903 It will be 1,000 of each, either surface or bottoms. 00:26:35.250 --> 00:26:37.030 And typically this isn't a problem 00:26:37.030 --> 00:26:42.030 unless you're doing a larger radius in, say, somewhere, 00:26:42.570 --> 00:26:44.020 this is out just west of Odessa, 00:26:44.020 --> 00:26:46.430 the screenshot we have here. 00:26:46.430 --> 00:26:47.590 Or if you're down near the coast 00:26:47.590 --> 00:26:48.890 and see one of the salt dome areas, 00:26:48.890 --> 00:26:51.300 those are kind of the typical areas 00:26:51.300 --> 00:26:53.763 where you might run into an issue. 00:26:55.600 --> 00:26:58.270 So if you needed all those wells in there, 00:26:58.270 --> 00:27:00.960 we do provide another way 00:27:00.960 --> 00:27:01.793 and that is, 00:27:04.464 --> 00:27:06.260 we'll talk about that on the next slide. 00:27:06.260 --> 00:27:08.510 Actually we'll talk about the download well results 00:27:08.510 --> 00:27:11.083 that it displays as a CSV file. 00:27:13.200 --> 00:27:17.393 So the well location and 00:27:17.393 --> 00:27:19.550 the coordinates 00:27:19.550 --> 00:27:22.400 are two things that are entered by Commission personnel. 00:27:22.400 --> 00:27:25.400 So the well location source document 00:27:25.400 --> 00:27:26.840 would be like that linen map 00:27:26.840 --> 00:27:28.260 that we talked about earlier. 00:27:28.260 --> 00:27:29.540 So that would be, you know, 00:27:29.540 --> 00:27:31.580 where did we get this location from? 00:27:31.580 --> 00:27:34.713 How do we decide where to put it in our GIS? 00:27:36.040 --> 00:27:38.430 That is important because it determines 00:27:38.430 --> 00:27:41.090 how comfortable we are with that location being 00:27:44.868 --> 00:27:46.823 as correct as we can get it. 00:27:49.134 --> 00:27:51.730 And this kind of gets to, there's another question here. 00:27:51.730 --> 00:27:53.820 So say you download these well results, 00:27:53.820 --> 00:27:54.660 one of them is half, 00:27:54.660 --> 00:27:59.023 how do you know if the well is just a misspotted location? 00:27:59.870 --> 00:28:04.550 You would have to go back to the original documentation 00:28:04.550 --> 00:28:05.610 to see how that 00:28:11.415 --> 00:28:12.440 compares to the location 00:28:12.440 --> 00:28:14.130 that we currently have it. 00:28:14.130 --> 00:28:18.020 And I would say the well source document, 00:28:18.020 --> 00:28:21.860 or what's labeled as the location source 00:28:21.860 --> 00:28:24.520 in the downloaded wells data, 00:28:24.520 --> 00:28:26.200 is gonna give you the first indication 00:28:26.200 --> 00:28:29.493 of whether you need to look into that location more. 00:28:30.830 --> 00:28:32.680 So you have to back to the original plat 00:28:32.680 --> 00:28:35.083 or the original permit to see, 00:28:36.500 --> 00:28:41.213 is it in there in its correct location. 00:28:44.460 --> 00:28:45.600 The other thing that we're going 00:28:45.600 --> 00:28:49.070 to put in here is the latitude and longitude. 00:28:49.070 --> 00:28:52.220 So if we enter it with a set of coordinates, 00:28:52.220 --> 00:28:55.020 like the operator reported coordinates that we see here, 00:28:56.030 --> 00:28:58.680 the system will convert those over 00:28:58.680 --> 00:29:03.100 to a Lat and Long 27 and a Lat and Long 83. 00:29:03.100 --> 00:29:06.160 And then those are associated with that spot in our GIS. 00:29:06.160 --> 00:29:10.030 So even if the coordinates are submitted in WSG 84, 00:29:10.030 --> 00:29:12.680 then we will change those, 00:29:12.680 --> 00:29:17.210 the system automatically changes those over to 27 and 83. 00:29:17.210 --> 00:29:19.190 So those are the two main datums 00:29:19.190 --> 00:29:21.690 that you're gonna get information back from us in. 00:29:25.110 --> 00:29:27.520 Mark, we have a couple other questions. 00:29:27.520 --> 00:29:31.010 There's a question on if there's a GIS layer 00:29:31.010 --> 00:29:34.160 for mainstream assets or lines 00:29:34.160 --> 00:29:36.373 or is it only major transmission lines? 00:29:40.607 --> 00:29:43.773 The pipelines go all the way down to usually the, 00:29:46.260 --> 00:29:47.447 trying to think of the right term for it right now, 00:29:47.447 --> 00:29:50.710 'cause we don't do a lot of work with pipelines here. 00:29:50.710 --> 00:29:52.790 Pipeline has their OWn GIS section. 00:29:52.790 --> 00:29:56.010 So as far as what's in the Viewer, 00:29:56.010 --> 00:29:58.750 it goes all the way down, I believe, to some of the 00:30:02.190 --> 00:30:03.920 gathering lines that are on leases. 00:30:03.920 --> 00:30:05.330 I don't know that it's comprehensive 00:30:05.330 --> 00:30:08.720 for all of them, but it does goes down that far, 00:30:08.720 --> 00:30:11.363 but it doesn't distinguish between those. 00:30:13.920 --> 00:30:16.763 You have to identify the particular lines. 00:30:18.410 --> 00:30:20.690 You can download the pipeline data. 00:30:20.690 --> 00:30:21.880 A little while later on, 00:30:21.880 --> 00:30:22.910 I'll show you where that's at. 00:30:22.910 --> 00:30:27.550 You can kind of manipulate it more in a GIS system 00:30:27.550 --> 00:30:30.280 outside of the public Viewer here. 00:30:30.280 --> 00:30:31.800 The public Viewer is mainly designed 00:30:31.800 --> 00:30:35.580 to display information and provide information 00:30:35.580 --> 00:30:37.860 about a specific feature, 00:30:37.860 --> 00:30:42.043 but not to pull a subset of information out. 00:30:42.890 --> 00:30:45.490 So, for example, with the download well results tool 00:30:45.490 --> 00:30:47.500 you can't say I want only the producing 00:30:47.500 --> 00:30:49.790 oil wells in this area. 00:30:49.790 --> 00:30:51.693 It's kind of an all or nothing thing. 00:30:53.150 --> 00:30:55.583 So you get all the wells, whether it's a permitted, 00:30:55.583 --> 00:30:58.253 a plug producing, or anything in between. 00:31:00.597 --> 00:31:02.960 And then we have another question. 00:31:02.960 --> 00:31:05.450 Do horizontal wells ever get updated 00:31:05.450 --> 00:31:07.753 with adjunct data on the map? 00:31:10.560 --> 00:31:13.353 Obviously they're not drilled exactly the same, 00:31:14.420 --> 00:31:15.893 what is a straight line? 00:31:17.440 --> 00:31:20.020 Yeah, so that question, 00:31:20.020 --> 00:31:22.290 if you look at the wells in our Viewer, 00:31:22.290 --> 00:31:24.210 and we'll look at some in a little bit here, 00:31:24.210 --> 00:31:27.570 so if I don't elaborate on a datum, try to remind me, Matt, 00:31:27.570 --> 00:31:30.470 when we look at some of our downloaded well data. 00:31:30.470 --> 00:31:32.643 But the way, you know, 00:31:32.643 --> 00:31:34.440 no well is ever drilled straight 00:31:34.440 --> 00:31:35.420 and if you look at our Viewer, 00:31:35.420 --> 00:31:38.550 the line always goes in a perfectly straight 00:31:38.550 --> 00:31:42.780 as the crow flies line from the surface location 00:31:42.780 --> 00:31:44.550 to the bottom hole location. 00:31:44.550 --> 00:31:48.130 That is not how the vast majority, 00:31:48.130 --> 00:31:49.983 if any of the wells, are drilled. 00:31:50.840 --> 00:31:52.110 When we input the wells, 00:31:52.110 --> 00:31:54.600 we only input the surface location 00:31:54.600 --> 00:31:57.730 and then we input the as drilled bottom hole location 00:31:57.730 --> 00:32:00.350 based upon the coordinates 00:32:00.350 --> 00:32:02.960 that were submitted on the directional survey 00:32:02.960 --> 00:32:04.410 or the measurements that were submitted 00:32:04.410 --> 00:32:05.710 on the directional survey. 00:32:06.600 --> 00:32:10.270 So in order to ascertain the exact wellbore path 00:32:10.270 --> 00:32:14.040 you would have to open up the directional survey 00:32:14.040 --> 00:32:17.270 and review that and look at the measurements 00:32:17.270 --> 00:32:18.710 that were taken for each shot point 00:32:18.710 --> 00:32:20.430 along the wellbore path 00:32:20.430 --> 00:32:23.693 to determine where that well falls. 00:32:24.870 --> 00:32:26.680 And that's not something that we currently do 00:32:26.680 --> 00:32:31.070 in our GIS system, so you're not going to see, 00:32:31.070 --> 00:32:32.910 like you typically would a curved wellbore 00:32:32.910 --> 00:32:36.470 where they have a well pad with eight surfaces on it. 00:32:36.470 --> 00:32:41.053 It's not going to have those curved wells radiating out. 00:32:42.090 --> 00:32:44.520 They're all gonna go right from the center of that pad 00:32:44.520 --> 00:32:46.773 out towards their bottom hole locations. 00:32:52.580 --> 00:32:56.700 So now if you need to look at a larger area or you need, 00:32:56.700 --> 00:32:58.930 there's more than a thousand wells within your radius 00:32:58.930 --> 00:33:00.834 but you need all of them, 00:33:00.834 --> 00:33:02.860 you know, what are you gonna do at that point? 00:33:02.860 --> 00:33:04.220 This is where we have all the data 00:33:04.220 --> 00:33:06.370 that is in our GIS Viewer, 00:33:06.370 --> 00:33:07.980 it's available to download, 00:33:07.980 --> 00:33:11.773 it used to be purchased, but now it's free. 00:33:12.740 --> 00:33:15.700 We'll take a look at that data here in just a little bit, 00:33:15.700 --> 00:33:18.380 but this is the basic way to it get to it, 00:33:18.380 --> 00:33:20.130 About Us, Resource Center, 00:33:20.130 --> 00:33:23.160 and data sets available for download. 00:33:23.160 --> 00:33:25.923 We'll get to that here in just a little bit. 00:33:28.880 --> 00:33:31.890 When you download the file, you'll select 00:33:31.890 --> 00:33:35.920 what you want from the digital map data selection 00:33:36.820 --> 00:33:40.950 and then select the layer based upon its FIPS code, 00:33:40.950 --> 00:33:42.970 so its county FIPS code. 00:33:42.970 --> 00:33:45.880 One of the handouts that accompanied the presentation, 00:33:45.880 --> 00:33:46.713 if you downloaded that, 00:33:46.713 --> 00:33:48.930 was what the FIPS code for each county. 00:33:48.930 --> 00:33:49.830 If you don't have that, 00:33:49.830 --> 00:33:52.450 if you go to the search bar on our website 00:33:52.450 --> 00:33:53.823 and type in county FIPS, 00:33:55.330 --> 00:33:56.700 one of the links will pop up. 00:33:56.700 --> 00:33:59.990 We have a list what each counties name is, its FIPS code, 00:33:59.990 --> 00:34:02.400 its district code, and other codes 00:34:02.400 --> 00:34:03.870 we have associated with those. 00:34:03.870 --> 00:34:07.160 So, for example, the well 001, 00:34:07.160 --> 00:34:09.940 that's gonna be the wells in Anderson County. 00:34:09.940 --> 00:34:14.020 Well 003 is gonna be the wells in Andrews County and so on 00:34:14.020 --> 00:34:15.770 until you get down to the very end. 00:34:17.700 --> 00:34:18.640 A couple of new layers 00:34:18.640 --> 00:34:20.880 since the last time we had a presentation. 00:34:20.880 --> 00:34:23.300 There's the Voluntary Cleanup Program Sites 00:34:23.300 --> 00:34:25.823 and the Brownfield Response Program Sites. 00:34:26.860 --> 00:34:29.280 Voluntary Cleanup Program is when an operator 00:34:30.220 --> 00:34:32.570 works with the Commission to clean up pollution 00:34:32.570 --> 00:34:35.270 at a site that they did not cause. 00:34:35.270 --> 00:34:38.340 So maybe they took over the lease from a previous operator 00:34:38.340 --> 00:34:40.071 and being good stewards of the environment, 00:34:40.071 --> 00:34:42.260 they wanna make sure that everything 00:34:42.260 --> 00:34:44.180 gets cleaned up and that 00:34:45.820 --> 00:34:49.033 the conditions on that lease don't get 00:34:51.950 --> 00:34:53.800 put on them so they're gonna clean it up 00:34:53.800 --> 00:34:55.480 and be good stewards 00:34:55.480 --> 00:34:58.690 and they work with our Voluntary Cleanup Program site 00:34:58.690 --> 00:35:00.880 individuals to take care of that. 00:35:00.880 --> 00:35:02.410 Brownfield Response Program sites, 00:35:02.410 --> 00:35:05.310 those are sites that are associated 00:35:05.310 --> 00:35:07.530 with like a municipality or something 00:35:07.530 --> 00:35:09.770 that maybe wants to remediate an area 00:35:09.770 --> 00:35:11.590 to make it a shopping center, 00:35:11.590 --> 00:35:13.390 or turn it into a subdivision, 00:35:13.390 --> 00:35:15.770 but there's some need for remediation out there. 00:35:15.770 --> 00:35:16.603 They can work with our 00:35:16.603 --> 00:35:20.720 Brownfield Response Program Sites department, 00:35:20.720 --> 00:35:23.010 I believe it's within our site remediation section, 00:35:23.010 --> 00:35:24.660 in order to get those cleaned up. 00:35:26.070 --> 00:35:28.970 A couple of other ones are Commercial Wast Disposal sites, 00:35:30.390 --> 00:35:32.460 pretty much self-explanatory there. 00:35:32.460 --> 00:35:34.340 And Discharge Permits. 00:35:34.340 --> 00:35:37.830 So if an operator's permitted to discharge, you know, 00:35:37.830 --> 00:35:40.833 say, some produced water or something along those lines, 00:35:41.810 --> 00:35:43.640 you know we have locations now 00:35:43.640 --> 00:35:45.823 identifiable on our GIS Viewer. 00:35:48.340 --> 00:35:51.720 Now let's get into some of the download wells data 00:35:51.720 --> 00:35:54.400 and I'll show you where to find it, 00:35:54.400 --> 00:35:57.990 what we have, and how it can be used. 00:35:57.990 --> 00:36:01.013 So we're gonna jump out of the presentation here. 00:36:03.850 --> 00:36:06.780 And we'll go to the Railroad Commission home page, 00:36:06.780 --> 00:36:08.750 earlier I went over it really quickly, 00:36:08.750 --> 00:36:10.363 but if you go to About Us, 00:36:11.220 --> 00:36:12.760 and you go to Resource Center 00:36:14.220 --> 00:36:16.790 and scroll down to our research section, 00:36:16.790 --> 00:36:18.730 that is where our data sets available 00:36:18.730 --> 00:36:20.203 for download are located. 00:36:23.640 --> 00:36:26.250 And we have various data sets. 00:36:26.250 --> 00:36:27.640 The ones we're gonna focus on today 00:36:27.640 --> 00:36:29.370 are digital map data, 00:36:29.370 --> 00:36:31.052 but before we get into that, 00:36:31.052 --> 00:36:33.433 there's drilling permit information, 00:36:34.640 --> 00:36:37.490 field data, production information, 00:36:37.490 --> 00:36:40.070 regulatory data, wellbore, 00:36:40.070 --> 00:36:42.193 so it's in our wellbore system here. 00:36:43.180 --> 00:36:46.920 Various data sets in different formats 00:36:47.770 --> 00:36:49.370 that are available for download. 00:36:50.340 --> 00:36:51.940 Since we're talking about the GIS Viewer, 00:36:51.940 --> 00:36:54.473 we're gonna focus on the digital map data. 00:36:55.660 --> 00:36:56.770 There are 00:36:59.410 --> 00:37:03.300 three main categories that I usually recommend to people 00:37:03.300 --> 00:37:06.950 would be surveys, that provides you a frame of reference, 00:37:06.950 --> 00:37:10.373 wells, and then the API data. 00:37:11.469 --> 00:37:15.820 The API data is the information about the well. 00:37:15.820 --> 00:37:18.116 And when I show you, I'll elaborate on it 00:37:18.116 --> 00:37:19.980 and then I'll show you some examples 00:37:19.980 --> 00:37:24.003 of why you need both the wells layer and the API data. 00:37:25.390 --> 00:37:30.390 When you open up one of the Shape File download links here 00:37:31.780 --> 00:37:35.433 we're looking at surveys, you'll click on a surveys, 00:37:37.020 --> 00:37:39.398 and this is where it will pop up 00:37:39.398 --> 00:37:42.023 your different counties available for download. 00:37:43.050 --> 00:37:47.160 What you'll do is just click on your particular county 00:37:51.350 --> 00:37:53.743 and then, for example, mine opened up here. 00:37:54.610 --> 00:37:56.940 You can open it up, you can save it. 00:37:56.940 --> 00:37:58.810 It's a zip file so you have to unzip it 00:37:58.810 --> 00:38:00.544 and then, at the point, you'll have access 00:38:00.544 --> 00:38:03.340 to what's inside of that file. 00:38:03.340 --> 00:38:06.130 These are all gonna be in Shape File format 00:38:06.130 --> 00:38:07.570 so you're going to need some type 00:38:07.570 --> 00:38:10.730 of GIS software to open them. 00:38:10.730 --> 00:38:13.960 Here at the Commission we have ESRI products, 00:38:13.960 --> 00:38:16.440 currently using ArcMap, so you can use that. 00:38:16.440 --> 00:38:18.590 If you were using ArcPro you could do that. 00:38:18.590 --> 00:38:20.563 Use the Q-G-I-S or QGIS. 00:38:21.440 --> 00:38:23.710 That's a free open-source program you can download 00:38:23.710 --> 00:38:26.930 so if you're limited on your availability 00:38:26.930 --> 00:38:28.823 to some of the other products, 00:38:30.130 --> 00:38:33.713 go check them out, that's a good one. 00:38:35.180 --> 00:38:36.560 Some of this information you can even 00:38:36.560 --> 00:38:37.940 import into Google Maps. 00:38:37.940 --> 00:38:40.640 So you can take that and display the locations 00:38:40.640 --> 00:38:43.260 in Google Maps if you wanna go that route. 00:38:43.260 --> 00:38:44.910 There's various options 00:38:44.910 --> 00:38:47.490 but it's all based upon location of the wells, 00:38:47.490 --> 00:38:49.580 which is determined by the coordinates 00:38:49.580 --> 00:38:50.993 that we assign to that spot. 00:38:53.260 --> 00:38:56.960 So what can we do with that data after we download it? 00:38:56.960 --> 00:38:59.790 So here I put together, this is in ArcMap again, 00:38:59.790 --> 00:39:03.780 this is just quick little map I put together, 00:39:03.780 --> 00:39:08.780 kind of an example of what you're going to get. 00:39:09.330 --> 00:39:12.770 So earlier I went and I downloaded some well data 00:39:15.620 --> 00:39:17.100 with the download wells tool, 00:39:17.100 --> 00:39:21.820 and this is the CSV file that it gave me, 00:39:21.820 --> 00:39:23.380 is this one here. 00:39:28.524 --> 00:39:29.430 We have a quick question, 00:39:29.430 --> 00:39:31.520 says, can you please share the best free GIS 00:39:31.520 --> 00:39:33.133 software available again? 00:39:34.870 --> 00:39:36.730 The one that I'm most familiar with, 00:39:36.730 --> 00:39:38.600 and I can't say it's the best one 00:39:38.600 --> 00:39:40.520 'cause I don't have any personal experience with it 00:39:40.520 --> 00:39:42.970 but it seems to be the one I hear the most about, 00:39:44.130 --> 00:39:49.130 it's called Q-G-I-S or QGIS, as some people refer to it. 00:39:50.580 --> 00:39:54.750 That would be the first one I would investigate 00:39:54.750 --> 00:39:57.330 but obviously I'd also recommend checking out 00:39:57.330 --> 00:40:00.210 additional programs that might suit your needs better. 00:40:00.210 --> 00:40:02.410 There might be something that's more easy 00:40:02.410 --> 00:40:04.293 to manipulate or to work with. 00:40:05.340 --> 00:40:06.910 There are viewers you can download for free 00:40:06.910 --> 00:40:09.060 if all you need to do is look at the data. 00:40:09.060 --> 00:40:10.660 I believe ESRI has some pretty viewers 00:40:10.660 --> 00:40:11.493 you can download. 00:40:11.493 --> 00:40:13.170 So if you're just looking at it, 00:40:13.170 --> 00:40:14.970 that might be the route you wanna go 00:40:16.510 --> 00:40:19.560 as opposed to looking at the open-source software. 00:40:19.560 --> 00:40:21.443 But again, that's the Q-G-I-S, 00:40:23.040 --> 00:40:25.993 is the open-source software that I'm most familiar with. 00:40:28.040 --> 00:40:30.180 So the download well data that I went to earlier, 00:40:30.180 --> 00:40:31.780 I found a well location, 00:40:31.780 --> 00:40:34.070 I put in a half mile radius, 00:40:34.070 --> 00:40:36.860 and I clicked the download wells 00:40:36.860 --> 00:40:39.623 and this is the CSV file that it exported. 00:40:41.590 --> 00:40:44.080 A number of different fields on here 00:40:45.480 --> 00:40:49.590 from permits to surveys to locations, abstract numbers. 00:40:49.590 --> 00:40:51.770 Anything you see in the identify results window 00:40:51.770 --> 00:40:55.660 that we looked at is gonna show up in this list here. 00:40:55.660 --> 00:40:57.240 So what can you do with this? 00:40:57.240 --> 00:40:59.790 If you, say you need to submit an injection permit, 00:41:01.219 --> 00:41:05.507 you might be required to send in a plat with that. 00:41:05.507 --> 00:41:07.380 What you can do is you can take this 00:41:07.380 --> 00:41:10.083 and the steps here are specific to ArcMap, 00:41:11.110 --> 00:41:12.520 so I wouldn't really focus on the steps, 00:41:12.520 --> 00:41:13.500 it's more the concepts 00:41:13.500 --> 00:41:17.020 that we're looking at in this instance. 00:41:17.020 --> 00:41:21.340 So I'm gonna use the latitude and longitude 00:41:21.340 --> 00:41:22.343 that were provided. 00:41:26.260 --> 00:41:29.540 And then I'll make sure that I say it's NAD 83 data 00:41:30.504 --> 00:41:31.733 and I'll click Okay. 00:41:39.094 --> 00:41:41.761 I'm not sure it showed up there. 00:41:48.270 --> 00:41:49.103 Let's try again. 00:41:49.103 --> 00:41:51.300 Of course I worked on it this morning, it works. 00:42:06.847 --> 00:42:07.680 There we go. 00:42:07.680 --> 00:42:09.660 I must've entered something wrong in the last one. 00:42:09.660 --> 00:42:11.990 So it displays your well locations 00:42:11.990 --> 00:42:13.940 and this is where you get into 00:42:14.840 --> 00:42:16.567 how are you going to identify 'em? 00:42:16.567 --> 00:42:20.330 And that can be specific, you can add additional fields. 00:42:20.330 --> 00:42:23.340 But the dots on the map don't really tell you much 00:42:23.340 --> 00:42:25.290 so you're gonna have to do a few things 00:42:26.793 --> 00:42:30.690 to provide context to what you're looking at here. 00:42:31.720 --> 00:42:35.500 So we could go to the labels 00:42:35.500 --> 00:42:37.320 and we can say, in this case, 00:42:37.320 --> 00:42:39.970 I'm gonna label it with well number 00:42:46.340 --> 00:42:47.493 and the API. 00:42:50.530 --> 00:42:55.530 And then also I'm going to apply symbology, 00:42:55.550 --> 00:42:56.900 so you can come up with your own symbology 00:42:56.900 --> 00:42:59.050 as to what the wells look like. 00:42:59.050 --> 00:43:02.520 I have our layer file here that we used 00:43:02.520 --> 00:43:05.523 for the wells in our internal systems. 00:43:13.663 --> 00:43:15.663 So I'm gonna apply that. 00:43:17.700 --> 00:43:19.780 Now you can see we've got 00:43:24.340 --> 00:43:25.290 the well locations. 00:43:43.870 --> 00:43:45.523 Forgot the L in there. 00:43:49.870 --> 00:43:52.820 So we've got our well number on top 00:43:52.820 --> 00:43:54.580 with our API underneath it. 00:43:54.580 --> 00:43:58.390 The location shows you, symbol shows you 00:43:58.390 --> 00:43:59.450 what type of location it is, 00:43:59.450 --> 00:44:01.503 plugged, producing, permitted. 00:44:02.620 --> 00:44:06.990 And then if you're familiar with your GIS software, 00:44:06.990 --> 00:44:09.860 you can add additional information to the map. 00:44:09.860 --> 00:44:13.730 So, for example, with this one, I added 00:44:22.037 --> 00:44:24.590 a well buffer to show half mile location 00:44:24.590 --> 00:44:26.733 around this well number six right here. 00:44:29.180 --> 00:44:31.730 So that's a way you can use the downloaded well results 00:44:31.730 --> 00:44:35.460 and put them into a GIS program 00:44:35.460 --> 00:44:39.430 to get a specific map 00:44:39.430 --> 00:44:41.243 or document out of it. 00:44:42.860 --> 00:44:44.830 So that's with the download well results. 00:44:44.830 --> 00:44:46.040 Now let's say you need this, 00:44:46.040 --> 00:44:47.420 but you also need the context 00:44:47.420 --> 00:44:50.540 of all the other information and wells behind it. 00:44:50.540 --> 00:44:52.490 That is where the downloaded well data 00:44:52.490 --> 00:44:53.510 will come into play. 00:44:53.510 --> 00:44:56.593 So you can get all of our information. 00:44:59.910 --> 00:45:02.350 What you get, again, 00:45:02.350 --> 00:45:05.130 if I turn off our radius results, 00:45:05.130 --> 00:45:07.280 which is from our GI Viewer, 00:45:07.280 --> 00:45:08.894 there's not a lot of context there. 00:45:08.894 --> 00:45:09.810 So you're gonna have to go in 00:45:09.810 --> 00:45:12.340 and do some massaging of the data 00:45:12.340 --> 00:45:16.410 'cause if this how our map defaults 00:45:16.410 --> 00:45:18.103 to show the different layers. 00:45:19.380 --> 00:45:21.150 So y'all don't have to sit and watch me do all that, 00:45:21.150 --> 00:45:24.290 I've gone through and done that. 00:45:24.290 --> 00:45:27.870 So I added our surveys 00:45:27.870 --> 00:45:30.873 with our abstract lines, 00:45:32.330 --> 00:45:34.360 excuse me, abstract numbers, 00:45:34.360 --> 00:45:36.760 section numbers, and survey names. 00:45:36.760 --> 00:45:38.970 So now we have a context of where we're at 00:45:40.500 --> 00:45:43.030 and you can add in 00:45:47.163 --> 00:45:47.996 the well locations, 00:45:47.996 --> 00:45:49.250 so there's the bottom holes, 00:45:50.800 --> 00:45:55.800 our surface locations, and then the well lines. 00:45:55.850 --> 00:45:58.383 So earlier we were talking about the well lines. 00:46:02.050 --> 00:46:05.440 This is an example of the well going straight 00:46:05.440 --> 00:46:10.440 from the surface location to a bottom hole. 00:46:10.640 --> 00:46:13.930 So this particular well right here 00:46:13.930 --> 00:46:16.500 probably will not be drilled exactly 00:46:17.810 --> 00:46:19.280 in that straight line. 00:46:19.280 --> 00:46:20.600 You know, they might come off a little bit 00:46:20.600 --> 00:46:22.500 and they're gonna curve back and forth, 00:46:22.500 --> 00:46:24.280 trying to stay within their, you know, 00:46:24.280 --> 00:46:26.430 within their target zone, 00:46:26.430 --> 00:46:28.820 but nothing is drilled perfectly straight. 00:46:28.820 --> 00:46:31.470 Like I mentioned earlier, we don't spot 00:46:31.470 --> 00:46:33.450 every single shop point that's included 00:46:33.450 --> 00:46:35.220 in that directional survey. 00:46:35.220 --> 00:46:39.060 We just get the surface location 00:46:39.060 --> 00:46:41.690 and then the as drilled bottom location 00:46:41.690 --> 00:46:43.093 after the well is completed. 00:46:46.930 --> 00:46:49.420 Mark, there's a question. 00:46:49.420 --> 00:46:50.630 Yes, let me see. 00:46:50.630 --> 00:46:53.050 So the question is, what attributes do you get 00:46:53.050 --> 00:46:54.800 from the radius download 00:46:54.800 --> 00:46:56.960 and what do I need to do a larger download 00:46:56.960 --> 00:46:59.323 by digital data to get the same information? 00:47:01.790 --> 00:47:05.280 So if you download just the well data, 00:47:05.280 --> 00:47:06.597 so let's start with the first part, 00:47:06.597 --> 00:47:07.720 let get back to... 00:47:16.309 --> 00:47:17.142 Bring this up. 00:47:17.142 --> 00:47:21.450 So what you're gonna get is basically everything 00:47:21.450 --> 00:47:26.450 that's on the identified results window. 00:47:26.750 --> 00:47:29.090 So everything from the API section, 00:47:29.090 --> 00:47:31.740 which is API number, well number, symbol description, 00:47:33.000 --> 00:47:36.720 and I don't wanna read off every one of these. 00:47:36.720 --> 00:47:39.170 But you'll get depths, you'll get completed fields, 00:47:39.170 --> 00:47:40.180 I'll try and highlight some 00:47:40.180 --> 00:47:44.680 of the most pertinent ones you'll get. 00:47:44.680 --> 00:47:47.283 The operator, lease name, 00:47:49.580 --> 00:47:51.653 the well type, is it an on schedule well, 00:47:53.188 --> 00:47:55.680 so is it currently a producing well 00:47:55.680 --> 00:47:56.950 or is it an off schedule well, 00:47:56.950 --> 00:47:59.300 where it's not on an operation schedule? 00:47:59.300 --> 00:48:02.200 Plug dates, if that's applicable. 00:48:02.200 --> 00:48:04.350 Those are probably the most pertinent ones. 00:48:05.270 --> 00:48:07.870 If you have specific questions about the attributes, 00:48:07.870 --> 00:48:09.210 email us and let us know. 00:48:09.210 --> 00:48:10.570 We'll show a contact information 00:48:10.570 --> 00:48:13.193 at the end of the presentation here. 00:48:14.070 --> 00:48:16.360 Now if you download our well data, 00:48:16.360 --> 00:48:18.260 what you're going to get is 00:48:29.821 --> 00:48:31.310 a very small subset of information. 00:48:31.310 --> 00:48:34.590 So you're gonna get coordinates, our reliability, 00:48:34.590 --> 00:48:38.540 which is how comfortable we are with that spot, API number, 00:48:38.540 --> 00:48:40.480 what type of well it is. 00:48:40.480 --> 00:48:42.960 So the symbol number relates to a type, 00:48:42.960 --> 00:48:45.133 so a two would a permitted location. 00:48:46.090 --> 00:48:48.170 It will be an ID number 00:48:48.170 --> 00:48:52.410 and then a portion of the API number called the well ID, 00:48:52.410 --> 00:48:54.630 which is just the last five digits. 00:48:54.630 --> 00:48:57.100 So if you want the same set of information 00:48:57.100 --> 00:48:59.030 for on a county level that you had 00:48:59.030 --> 00:49:01.270 for the download well results, 00:49:01.270 --> 00:49:03.603 that's where the API data file comes in. 00:49:06.100 --> 00:49:08.710 And that has the additional information, 00:49:08.710 --> 00:49:11.850 fields, lease names, ID numbers, 00:49:11.850 --> 00:49:13.970 operators, permit numbers, 00:49:13.970 --> 00:49:15.310 all the same stuff that you saw 00:49:15.310 --> 00:49:16.640 with the download well results, 00:49:16.640 --> 00:49:19.140 it will have it but for all the locations 00:49:19.140 --> 00:49:20.283 within that county. 00:49:21.250 --> 00:49:24.350 In order to use that in a GIS system, 00:49:24.350 --> 00:49:27.930 you have to establish a link between 00:49:27.930 --> 00:49:29.810 what would be your surface location, 00:49:29.810 --> 00:49:33.513 or excuse me, your bottom locations and your API data. 00:49:34.580 --> 00:49:38.013 So what I've done here in this example, 00:49:39.096 --> 00:49:40.263 get back here, 00:49:46.350 --> 00:49:50.050 is I have joined the well location data 00:49:50.050 --> 00:49:54.040 with the API data through a process 00:49:54.040 --> 00:49:55.960 in ArcMap called Make a Query Table. 00:49:55.960 --> 00:49:57.670 And it's not a one to one 00:49:57.670 --> 00:49:59.650 'cause you can have three results 00:49:59.650 --> 00:50:01.650 for one well in the API data. 00:50:01.650 --> 00:50:02.950 So the example I used earlier 00:50:02.950 --> 00:50:05.890 where it was plugged, drilled, re-completed, 00:50:05.890 --> 00:50:07.780 and then plugged and then re-entered, 00:50:07.780 --> 00:50:09.220 you'd have three results. 00:50:09.220 --> 00:50:13.090 So you're gonna have three results in the API data table 00:50:13.090 --> 00:50:14.860 and you're only gonna have one well location 00:50:14.860 --> 00:50:17.450 in the GIS data. 00:50:17.450 --> 00:50:20.360 So you have to go through a process to join those 00:50:20.360 --> 00:50:21.310 and join them appropriately, 00:50:21.310 --> 00:50:23.140 so you don't lose any results. 00:50:23.140 --> 00:50:24.760 And that's where kinda the GIS side 00:50:24.760 --> 00:50:26.430 and your GIS technicians can get in there 00:50:26.430 --> 00:50:28.840 and help you do that either through a relate 00:50:28.840 --> 00:50:32.660 or Make a Query Table, or some other options. 00:50:32.660 --> 00:50:35.360 But I joined the well data, 00:50:35.360 --> 00:50:37.710 which had the very limited results 00:50:37.710 --> 00:50:40.650 with our API data to come up with a master list 00:50:40.650 --> 00:50:42.443 that has everything included in it. 00:50:43.680 --> 00:50:45.320 That's where you get into the GIS side of it, 00:50:45.320 --> 00:50:48.540 and you're gonna use GIS experience and software 00:50:48.540 --> 00:50:51.593 in order to use the data that you download. 00:50:54.260 --> 00:50:56.450 But then you can go through and do the same thing. 00:50:56.450 --> 00:50:59.080 You can select the wells that are within that radius 00:50:59.080 --> 00:51:01.540 and export those results 00:51:02.684 --> 00:51:04.410 and you'll end up with the same table you would 00:51:04.410 --> 00:51:07.507 from the download well results, 00:51:07.507 --> 00:51:09.850 but that allows more customization 00:51:09.850 --> 00:51:11.480 in how you can acquire the results. 00:51:11.480 --> 00:51:15.210 So you can tell it you only want oil wells within there. 00:51:15.210 --> 00:51:19.520 So using the download data inside of the GIS software 00:51:19.520 --> 00:51:22.063 definitely gives you greater flexibility 00:51:22.063 --> 00:51:23.883 in what you need to get done. 00:51:25.770 --> 00:51:29.963 So with that, we'll jump back over to the presentation. 00:51:31.950 --> 00:51:35.300 Now, if you find something that is not correct, 00:51:35.300 --> 00:51:37.280 what do you do at that point? 00:51:37.280 --> 00:51:38.440 You know, contact us and let us know. 00:51:38.440 --> 00:51:40.390 We're more than happy to work with you. 00:51:42.060 --> 00:51:44.310 We need as much information as possible about that well, 00:51:44.310 --> 00:51:45.790 so if the historic well records, 00:51:45.790 --> 00:51:48.150 the original well documents, permits, 00:51:48.150 --> 00:51:50.123 plats, any maps for the area, 00:51:52.470 --> 00:51:55.400 we'll need that to make a change to the well. 00:51:55.400 --> 00:51:57.890 So if that well is permitted one place 00:51:57.890 --> 00:52:00.040 but not drilled in another, 00:52:00.040 --> 00:52:01.920 but not drill where it was permitted, 00:52:01.920 --> 00:52:03.660 we might have to go back and say 00:52:03.660 --> 00:52:05.880 a revised permit needs to be submitted 00:52:05.880 --> 00:52:08.450 so that the historic records actually match 00:52:08.450 --> 00:52:10.050 with what was done in the field. 00:52:11.240 --> 00:52:15.420 We can't do anything just based on a new set of coordinates 00:52:15.420 --> 00:52:18.440 'cause we have to make sure that somebody doesn't come back 00:52:18.440 --> 00:52:19.840 at a later date and say, well, 00:52:19.840 --> 00:52:21.670 the original permit says it's over here, 00:52:21.670 --> 00:52:23.603 but you moved it over there. 00:52:25.640 --> 00:52:29.590 We have to have the paperwork match the location. 00:52:29.590 --> 00:52:31.000 And we'll do that through, 00:52:31.000 --> 00:52:33.820 if the historical records say to move it, we'll move it, 00:52:33.820 --> 00:52:35.880 or we might say you need to get an omitted permit 00:52:35.880 --> 00:52:37.840 so that the records at the Commission 00:52:37.840 --> 00:52:39.640 correctly reflect the well location. 00:52:41.870 --> 00:52:43.290 Submit anything you have to us, 00:52:43.290 --> 00:52:44.800 we'll look it over, 00:52:44.800 --> 00:52:46.800 we might ask for additional information. 00:52:48.490 --> 00:52:52.110 If we do, work with us, do what we can. 00:52:52.110 --> 00:52:53.670 If we've already worked on that spot, 00:52:53.670 --> 00:52:54.980 we'll tell you what we did, 00:52:54.980 --> 00:52:58.700 why we might've moved it, and what we did. 00:52:58.700 --> 00:53:02.283 And if you have something that's contrary to what we did, 00:53:03.140 --> 00:53:05.013 by all means, we'll definitely take a look at it, 00:53:05.013 --> 00:53:07.883 and see if there's anything else that needs to be done. 00:53:09.520 --> 00:53:10.353 Oops. 00:53:11.831 --> 00:53:12.664 Uh-oh. 00:53:14.400 --> 00:53:15.233 Forgot to. 00:53:19.290 --> 00:53:20.140 Get back in here. 00:53:23.290 --> 00:53:25.390 We'll take a look at it, we'll address it, 00:53:26.449 --> 00:53:29.020 and we'll be in touch throughout the process. 00:53:29.020 --> 00:53:31.030 Anytime we've made a determination 00:53:31.030 --> 00:53:33.540 and say the well needs to be moved, 00:53:33.540 --> 00:53:37.370 we need to let y'all know, 00:53:37.370 --> 00:53:38.520 and we'll make the changes, 00:53:38.520 --> 00:53:40.660 and they will viewable 24 hours 00:53:40.660 --> 00:53:43.130 after we've made the change in the GIS Viewer. 00:53:43.130 --> 00:53:46.890 So anything we change internally will update overnight 00:53:46.890 --> 00:53:49.563 and show up tomorrow in the public Viewer. 00:53:52.950 --> 00:53:54.170 If you need to get in touch with us, 00:53:54.170 --> 00:53:55.653 say, for any reason, 00:53:56.920 --> 00:54:00.400 the best contact is the RRC.Mapping email. 00:54:00.400 --> 00:54:02.850 Anyone in the department here has access to that. 00:54:03.780 --> 00:54:06.130 We all get in there and we'll take a look at it 00:54:06.984 --> 00:54:08.390 and there will always be somebody 00:54:08.390 --> 00:54:10.630 that will respond out of that one. 00:54:10.630 --> 00:54:12.580 But if you need to get in touch with me, personally, 00:54:12.580 --> 00:54:15.270 or Matt, who's my manager, 00:54:15.270 --> 00:54:17.270 here's our contact information. 00:54:17.270 --> 00:54:19.340 Feel free to get in touch. 00:54:19.340 --> 00:54:21.510 We are on the remote working schedule still 00:54:21.510 --> 00:54:25.423 so phone number right now is not the best way to reach us, 00:54:26.680 --> 00:54:28.730 definitely recommend email at this point. 00:54:30.560 --> 00:54:33.437 With that being said, are there any additional questions? 00:54:33.437 --> 00:54:35.330 If you have any questions now, 00:54:35.330 --> 00:54:37.940 go ahead and enter them into the Q&A window 00:54:39.090 --> 00:54:42.063 and we'll do our best to give an answer. 00:54:51.980 --> 00:54:53.290 We'll wait a minute or two 00:54:53.290 --> 00:54:56.693 to see if anybody has any last minute questions. 00:54:56.693 --> 00:54:57.860 Yeah. 00:55:09.153 --> 00:55:09.986 We have a question 00:55:09.986 --> 00:55:11.773 about downloading the presentation. 00:55:16.200 --> 00:55:17.180 I will submit the linkage 00:55:17.180 --> 00:55:19.173 in just a second for everyone. 00:55:20.301 --> 00:55:21.968 Let me just grab it. 00:55:23.610 --> 00:55:24.537 Here's another one. 00:55:24.537 --> 00:55:28.873 The free GIS software, it's Q-G-I-S, 00:55:30.380 --> 00:55:33.540 is the software, and that's not necessarily one 00:55:33.540 --> 00:55:36.990 that we have experience with here, 00:55:36.990 --> 00:55:38.923 it's just the one I'm familiar with. 00:55:43.743 --> 00:55:45.326 Let me see if I can 00:55:48.195 --> 00:55:49.367 pull it up for you. 00:55:59.425 --> 00:56:02.008 And just Q-G-I-S. 00:56:03.920 --> 00:56:04.753 This is their website. 00:56:04.753 --> 00:56:06.183 It's an open-source software. 00:56:07.680 --> 00:56:12.680 So you can use it as you see fit, 00:56:13.460 --> 00:56:15.810 download it, it's free, 00:56:15.810 --> 00:56:17.293 and then potentially even, 00:56:20.810 --> 00:56:22.196 you know, you can contribute to it 00:56:22.196 --> 00:56:24.770 if you have programming skills to do that. 00:56:24.770 --> 00:56:26.520 If you find it useful and it helps you out, 00:56:26.520 --> 00:56:27.353 you know, help contribute, 00:56:27.353 --> 00:56:29.520 that's how the whole program got started. 00:56:29.520 --> 00:56:31.803 But this is the first option 00:56:36.010 --> 00:56:39.700 that I would investigate in addition to others, 00:56:39.700 --> 00:56:41.280 but I'd have to do a little more research 00:56:41.280 --> 00:56:42.663 to name any others. 00:56:44.840 --> 00:56:45.673 Let's see. 00:56:45.673 --> 00:56:48.253 What about the best, most economical paid software? 00:56:49.160 --> 00:56:51.120 I don't really have experience 00:56:51.120 --> 00:56:53.810 with pricing out softwares, 00:56:53.810 --> 00:56:56.890 that's done outside of my department here. 00:56:56.890 --> 00:57:00.620 Our IT department has a big hand in that so, 00:57:00.620 --> 00:57:03.190 as well as the state using ESRI. 00:57:07.670 --> 00:57:09.520 I can comment on that. 00:57:09.520 --> 00:57:11.110 If you reach out to ESRI, 00:57:11.110 --> 00:57:15.060 you might be surprised that the pricing 00:57:15.060 --> 00:57:16.070 you might get from them. 00:57:16.070 --> 00:57:19.220 So you might just reach out to them 00:57:19.220 --> 00:57:22.540 and find out for yourself what they charge 00:57:22.540 --> 00:57:26.963 and you might be surprised on how economical it is. 00:57:31.606 --> 00:57:35.273 And we have another question about, 00:57:36.310 --> 00:57:38.610 says, on the link do you have to use the bottom wells, 00:57:38.610 --> 00:57:40.900 or can I use the surface? 00:57:40.900 --> 00:57:42.950 You can use the surface location as well, 00:57:43.960 --> 00:57:48.910 whichever one would fit your needs best. 00:57:48.910 --> 00:57:51.940 You can even combine the two layers together 00:57:54.921 --> 00:57:58.710 and then you can select surface locations 00:57:58.710 --> 00:58:01.530 or bottom holes that fall within your radius. 00:58:01.530 --> 00:58:02.363 Either one. 00:58:04.030 --> 00:58:06.070 They're gonna be the same with the exception 00:58:06.070 --> 00:58:07.570 of horizontal and directional wells 00:58:07.570 --> 00:58:09.990 where the two spots are gonna be separated. 00:58:09.990 --> 00:58:12.970 So if you need to know the surface locations 00:58:12.970 --> 00:58:15.770 that fall within your radius, 00:58:15.770 --> 00:58:19.900 I would recommend maybe joining or relating the API data 00:58:19.900 --> 00:58:21.810 with your surface locations in that instance. 00:58:21.810 --> 00:58:25.840 So it kinda depends on which way you wanna go, 00:58:25.840 --> 00:58:27.590 but there is a surface for every spot 00:58:27.590 --> 00:58:29.393 in the GIS, even on vertical well. 00:58:42.920 --> 00:58:46.650 Well I think we've answered quite a bit in here 00:58:46.650 --> 00:58:50.340 and I think that if there's any more questions, 00:58:50.340 --> 00:58:52.090 please email us. 00:58:52.090 --> 00:58:55.630 And we wanna thank you for listening 00:58:55.630 --> 00:58:57.400 and participating today. 00:58:57.400 --> 00:59:00.140 We appreciate all your questions. 00:59:00.140 --> 00:59:05.140 In the future, please do not hesitate to reach out us 00:59:05.180 --> 00:59:08.020 if you have additional questions or concerns. 00:59:08.020 --> 00:59:12.610 We're glad to provide the service that we provide you 00:59:12.610 --> 00:59:14.360 in representing the state of Texas. 00:59:16.450 --> 00:59:18.020 All right, that concludes our webinar. 00:59:18.020 --> 00:59:20.370 Thank you, everyone, so much for participating.