topic Re: Auto Populate Lat / Long Fields in ArcGIS Pro in ArcGIS Pro Questions

Auto Populate Lat / Long Fields in ArcGIS Pro

CameronKoehler — Thu, 17 Oct 2024 03:29:30 GMT

Is there a way to auto populate Lat / Long coordinates in decimal degrees in ArcGIS Pro? We have deployed ESRI's Address Data Management solution and use that to assign and maintain our address points and road centerlines. In the attribute rules, I have added one to try and populate the coordinates but it will not auto populate in the decimal degree format. The map project shows the decimal degree is set to default, the map itself uses the format when working on the map, it will let me manually get the decimal degree format, but it will not go to that format automatically. I have attached some pictures of what is going on.

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

brianwaddle — Thu, 17 Oct 2024 14:58:49 GMT

Hello Cameron,

- Is there a way to "auto populate" Lat / Long coordinates in decimal degrees

I'm not certain I understand your question. From the attached pictures it appears that the table attributes "Latitude_Y, Longitude_X" ARE populated with coordinate pairs displayed in decimal degrees. i.e. 36.93051

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

CameronKoehler — Thu, 17 Oct 2024 15:04:23 GMT

Thank you for responding to the post! The Lat / Long fields are populated in decimal degrees because I went to calculate fields and was able to do it that way. If you look at picture 5, that is the way that the attribute rule is auto-populating the coordinates. They are only populating in decimal degree format when I manually do calculate fields.

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

brianwaddle — Thu, 17 Oct 2024 15:13:55 GMT

Okay, Let's take a look at the table attribute "fields view" to better understand how the coordinates pairs are stored. i.e. Numeric, Direction, etc...

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

CameronKoehler — Thu, 17 Oct 2024 15:20:11 GMT

Attached it the fields view of the address points. The current data type is FLOAT with number format Numeric.

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

brianwaddle — Thu, 17 Oct 2024 15:28:16 GMT

Interesting... A float data type is a single-precision 32-bit floating point number that can precisely store numbers that contain up to six digits only. For example, you could not store the number 515297.15 precisely in a float field. Is there a reason for NOT storing these numeric values with DOUBLE-PRECISION?

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

CameronKoehler — Thu, 17 Oct 2024 15:33:40 GMT

Our state service board has requested that Lat / Long fields have the Float data type.

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

brianwaddle — Thu, 17 Oct 2024 15:57:19 GMT

Okay, fair enough. Have you tried changing the Fields View "Number Format" such that the value represents Decimal Degrees?

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

BillFox — Thu, 17 Oct 2024 16:15:46 GMT

hi Cameron,

can you share these details with your board? GPS metadata such as Lat/Long is baked in as double

ArcGIS Pro 3.3 >

Add GPS Metadata Fields (Data Management)

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-gps-metadata-fields.htm

ArcGIS field data types

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/arcgis-field-data-types.htm#GUID-70728949-2016-4DB5-A723-5493B4330AE0

Examples:

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

brianwaddle — Thu, 17 Oct 2024 22:16:20 GMT

Again, if I understand your intentions correctly, you want X and Y coordinates in a table "display" as decimal degrees. Looking closer at your photo Arcpro5.png. I see numbers that appear to be coordinates that are expressed in Linear Units 4427846, -10456310(Meters or feet).

If the coordinates are indeed Lat/Lon, I'd expect to see DMS 40° 42' 46", or Radians 57.2958, or DD 40.7128°

Then in photo Arcpro2.png it appears to me (I could be wrong) you're using the field calculator to "convert" Linear values to degrees. This wouldn't be the recommended method. The Field Calculator does not handle the spatial reprojection.

I think it would be helpful to know the units of the X and Y coordinates. i.e. projected coordinate system or geographic system... Feet, meters, degrees?

You need to know the projected coordinate system (PCS) from which your data comes. This might be something like UTM (Universal Transverse Mercator), State Plane Coordinate System (SPCS), or another projection.

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

CameronKoehler — Fri, 18 Oct 2024 20:32:33 GMT

I believe this is the information you are asking about. Attached is the Spatial Reference from the point data.

Re: Auto Populate Lat / Long Fields in ArcGIS Pro

brianwaddle — Mon, 21 Oct 2024 23:20:43 GMT

Sorry, I'm at a loss... "SITEADDRESSPOINT" shows that you can calculate the x,y data fields to Decimal Degrees. I'm not sure what you mean, "auto-populate Lat / Long coordinates in decimal degrees."