Is there a proper way to order a field column for lat and long ?

757
11
08-30-2017 12:09 PM
Highlighted
Regular Contributor II

Is there a proper way to order column for latitude and longitude ? I have seen some people put their columns vice versa So, I am wondering if there is a proper way for this. So, would add for new column for latitude first and then longitude second ..but I am not sure...

Here is the example :

Another example here:

Reply
0 Kudos
11 Replies
Highlighted
MVP Regular Contributor

I don't think think there is any specific order as such...generally we mention Lat ahead of Long...

however check this thread for a more formal response:

google maps - Preferred order of writing latitude & longitude tuples - Stack Overflow 

Highlighted
Honored Contributor

As long as you are keeping the values in the columns correctly, the order shouldn't matter.

We usually write the coordinates as XY. So X (Longitude) could be placed before Y (Latitude) in an attribute table.

But there is no mandate that says Longitude should be placed before Latitude values.

Highlighted
Regular Contributor II

In order from XY   to LONG LAT  to UTM  should be like this  UTM Easting and UTM Northing ? Am I correct ?

Reply
0 Kudos
Highlighted
MVP Regular Contributor

Yes!

The terms easting and northing are geographic Cartesian coordinates for a point. Easting refers to the eastward-measured distance (or the x-coordinate), while northing refers to the northward-measured distance (or the y-coordinate).

Source: Easting and northing - Wikipedia 

Highlighted
Regular Contributor II

Thanks. Had to make sure it is correct... Phew... and thanks for the link too.

Reply
0 Kudos
Highlighted
Regular Contributor II

It can go pretty confusing so that is why I got to be careful.

Reply
0 Kudos
Highlighted
New Contributor II

I've found that if I use field names XCOORD (Longitude) & YCOORD (Latitude) they are often automatically recognised by the software and pop up conveniently in selection boxes. It used to work that way in MapInfo.

Highlighted
Regular Contributor II

Yes I saw that after I post this question and in a few hours later I looked it around and I saw that tool that does that .. It would be nice if they just label Longitude and Latitude instead of XCOORD and YCOORD...

Thanks for the info.

Reply
0 Kudos
Highlighted
New Contributor II

I consider 'Latitude and Longitude' as jargon, it confuses non-GIS colleagues and clients, virtually everyone knows which way up 'X and Y' are.

Because I don't use that terminology I forget which is which myself (I'm a Forester that does GIS, not the other way around) it wasn't until I read Dava Sobel's excellent book Longitude, that I can consistently remember Longitude is 'X'