Need to download data from here: http://www.gomr.boemre.gov/homepg/pubinfo/freeasci/platform/freeplat.html Merge
Create two data files
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: http://www.gomr.boemre.gov/homepg/pubinfo/pacificfreeasci/platform/pacificfreeplat.html 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! DO NOT USE SPACES, HYPHENS OR PERIODS IN ANY FILE NAMES. MAKE SURE ALL WINDOWS ARE CLOSED BEFORE PERFORMING ANY SAVE OR OPERATION. 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 |
Task Queue >