Latitude Longitude Format

[Pat Imbrogno]

I am using decimal Lat Long data with a minus sign in front of the USA longitudes which as far as my experience goes is a standard way to show it. These are Pennsylvania locations

When I create a map in Rockworks 17 and spot them on google earth they are in the Pacific Ocean so obviously the program won't recognize this format. Is it the negative Longitude or a program error?

 

I have several hundred wells in the project. and would like to know the specifics before playing with the data.

 

Thanks

 

[Mitch]

Hi Pat,

 

first of all it would help to know whether you're creating the map in the Utilities from a Data Sheet or from the Borehole Manager.

 

In the Borehole Manager the Project Dimensions can either be in Local, State Plane or UTM coordinates entered in meters or feet. You can enter Longitude Latitude in the Other Coordinate Projections but you still need to convert them to the Project Coordinate system.

 

If you're using the Spreadsheet you need to make sure that you assign the Coordinate Columns to XY Coordinate/Decimal Degrees. You can do this by right clicking on the header line of the spreadsheet.

 

Mitch

[Remelle]

Hi Mitch:  I am also mapped in the Pacific Ocean and this is Day 2 of my using the Rockworks 17 software.  My Excel spreadsheet that I imported into the borehole manager has columns with lat and long, which show up in the Borehole Manager, Borehole Data, Location, Other Coordinate Projections, Lon/Lat window correctly.  When I manually enter the Lat and Long into Google Earth, the points are projected where they belong, Wyoming.  When I click on Borehole Manager, Map, Borehole Locations-Google Earth (simple), the points are mapped in the Pacific Ocean.  My whole project is in UTM 13, WGS-84, feet.  I use a negative before my longitude, I recalculated all of my northings and eastings using Zonums, verified that my data points map correctly by themselves.  Is there, perhaps, a bust in my wells some place that can put the whole map in the ocean?   Also, I have not used the Utilities tab yet, so maybe I am premature in asking about the ocean location.  I was just clicking around to see where my data set maps.  Thanks for your help! 

[Mitch]

It sounds like you have the Long/Lat entered on the Other Coordinate Projections but haven't converted them to your Project Coordinate System (UTM). There's a "To Easting/Northing" button on the Other Coordinate Projections tab where you can do them one at a time or go to Edit/Coordinate Converter (to Easting/Northing) to convert all your boreholes.