Task Queue‎ > ‎

Task: Update Gulf Oil Platforms Dataset

Need to download data from here:


  • Platform Masters
  • Platform Structures
  • Platform Locations
After the merge, we should have one record for each distinct location
Create two data files
  • All platforms
  • Only platforms which have no removal date
Import both data files into Google Earth
Publish each as KMZ and add into the Gulf Monitoring Toolkit linked from this page: Gulf Monitoring Resources

Then rinse wash and repeat with the data sets here:


Document as you go - we will need to repeat this operation monthly. 

Process for importing original BOEMRE data into Google Earth
Case Study: Merging PlatformLocation data with PlatformStructure data

Notes: Please read!
Operations will fail if you do not follow these rules. 

1. Go to Boemre Link
2. Download PlatformLocation data AND PlatformStructure data. Click Save File when prompted. 
3. To view data fields explanations click on Platform Structures or Platform Locations hyperlinks
4. Data will download to a zipped folder.
5. Double click on zip and perform "Extract All Files" to a predetermined folder 
6. File will be saved as a .DAT file.
7. Right Click on file, scroll down to "Rename", and rename PlatformStructures.txt or PlatformLocations.txt. IMPORTANT TO SAVE AS A TXT FILE
8.Open Microsoft Office Access
9. Click "create a new file" - "Blank Database" 
10. Navigate to set folder pathway and save as PlatformStructuresData.mdb or PlatformLocationsData.mdb
11. Click "File" - "Get External Data" - "Import"
12. Make sure pathway is set to your folder. Under "Files of Type" tab navigate to "Text Files"
13. Click either text dataset (Locations or Structures) to upload to Access. Click "Import"
14. Import Text Wizard will appear. The data provided to us is in Fixed Width format. This means that the breaklines for each field must be set manually. Annoying but very important task! 
15. Leave the first window as default. Click "Next".
16. The second window will be the Field Breaks setting option. Use the information provided by Boemre under "FileName" to determine where breaks should be. IMPORTANT: Pay close attention to all line spaces and breaks. 
17. Keep all other defaults through wizard. Click "Finish"
18. You may encounter an "Import Error" notice. Ignore as long as all necessary fields are present.
19. Perform data qualitative check. Make sure all fields correspond to ComplexID and Lat/Long fields. Delete any extraneous fields where no Lat/Longs are present. 
20. Change field names to proper titles. ie. StructureName, Latitude, etc.
21. Click "Save"
22. Note* When importing the PlatformStructures data in the Import Text Wizard be sure to Specify "Data Type" as "Text" for all date fields. If you do not do this the final import will not show dates. 
23. Both files should now be saved as mdb. file types - these file types are then read by the GIS application and turned into shapefiles which are then imported into Google Earth.
24. Open GIS application (ArcGIS 10) 
25. Open Blank Map Document
26. Click the Add Data function. 
27. Navigate to saved folder pathway
28. Upload both Structures and Locations .mdb files DON'T FORGET TO SAVE ARC DOCUMENT PERIODICALLY
29. Right click on each file in the Table of Contents tab and click on the Attribute Table. Open table. Ensure all data is present and clean. 
30. Click on Catalog window (far left of screen) to open Catalog
31. Connect to your data folder using the "Connect to Folder" tool
32. Click Database Connections - Add OLE DB Connection
33. Click Microsoft Jet 4.0 OLE DB Provider
34. Enter DB name - Test Connection
35. Click OK - Perform action for each .mdb document
36. Open OLE DB Connection in Catalog and drag each now connected file into ArcMap
37. We will now perform all functions using the connected databases
38. Open Platform_Locations attribute table. The Lat/Long's may have rounded off to the whole number. Right click on each tab, navigate to Properties, click Numeric and change the number of decimal places from 0 to 6 or more. Click Apply and OK 
39. Perform join to connect Structures and Location data into one folder. 
40. Right click on Platform_Structures and click Join. Base join on ComplexID field. Make sure to perform join on Connected DB's! 
41. Export data from joined table to a txt file
42. Display x,y data X field = Longitude Y field = Latitude 
43. Export new data as a shapefile
44. Set new shapefile's coordinate system to WGS 84.prj in Catalog. 
45. Clean up attribute table's fields to show only what is necessary - Add/Delete Field function
46. Click Save and be sure to export your new shapfile for addition into Google Earth. 
47. Open Google Earth Pro - Open - Add Shapefile - Import All - Do not Apply a Style Template
48. Make sure all information is presented correctly.
49. Upload new file to Dropbox. 
50. Get a beer. You are done! 

Task 2: Make a shapefile and .kmz of only Platforms with No Removal Date
1. Navigate to original shapefile created 
2. Open Attribute Table
3. Click "Select by Attributes"
4. Enter query whereby "RemovalDat" = ' ' (NULL) 
5. All Platforms without removal dates will be selected in cyan color
6. Exit Attribute Table
7. Right click shapefile - Data - Export
8. In Export Data wizard Export: "Selected Features" and rename file to "Platform_NoRemovalDate"
9. Add the new layer to the map
10. Click Selection - Clear Selected Features 
11. Check Attribute Table of new Shapefile and ensure that all fields have no data in the RemovalDate column
12. Check that Geographic Coordinate System is still set at WGS84.prj
13. Save new layer and follow above procedure for upload to Google Earth and Dropbox