topic Help with Geocoding Format in ArcGIS Pro Questions

Help with Geocoding Format

KamillePreto — Tue, 25 Jan 2022 16:49:39 GMT

I have a .csv which I am trying to geocode in Pro. The rows I highlighted are the formatted cells. The columns to the left of each highlighted column is the original format.

I brought the table into Pro, and tried to display the XY data on the newly formatted cells, and the points do not land within our County (and they are supposed to). I confirmed the coordinate system is the same as the map.

Below is a screenshot of how off the points geocoded.

I tried changing the coordinate system, and that did not help.

Any suggestions? I need this data to geocode correctly to do some analysis.

Re: Help with Geocoding Format

HuubZwart — Tue, 25 Jan 2022 17:18:24 GMT

Sometimes Pro doesn't handle (csv) tables as expected, have you checked whether the coordinates in the Pro table match the ones in your original csv file?

Re: Help with Geocoding Format

KamillePreto — Tue, 25 Jan 2022 18:09:38 GMT

I always use CSV tables to display the XY data and have not encountered an issue until now.

Yes, they do match. The only thing is the additional 0s dropped off at the end of some cells. But that shouldn't create an issue since it is 0 and not another number.

Re: Help with Geocoding Format

DanPatterson — Tue, 25 Jan 2022 18:57:38 GMT

is there a chance that the coordinates prior to conversion represented degrees, minutes, decimal seconds?

Convert Coordinate Notation (Data Management)—ArcGIS Pro | Documentation

Re: Help with Geocoding Format

Anonymous User — Tue, 25 Jan 2022 19:00:09 GMT

Columns S and U are strange... are those weirdly formatted lat and longs? Normally if I had values like those I would assume they are decimal degrees and I would need to do a conversion to get them into Lat and Long.

Re: Help with Geocoding Format

KamillePreto — Tue, 25 Jan 2022 19:14:01 GMT

You can see in the screenshot that I did format them - in the highlighted columns. You can see the difference there.

Re: Help with Geocoding Format

KamillePreto — Tue, 25 Jan 2022 19:14:45 GMT

The spreadsheet is not ours, so I wouldn't have that information. It is data from the National Bridge Inventory.

Re: Help with Geocoding Format

DanPatterson — Tue, 25 Jan 2022 21:34:44 GMT

34.XX YY ZZZ you said the last 0 was dropped off

XX never goes above 59

YY never goes above 59

ZZZ any numbercould just be a strange coincidence but I got thinkin Degrees Decimal minutes 34 59.123

worth a check.

Also, what is the approximate distance that they are off?

Re: Help with Geocoding Format

Robert_LeClair — Tue, 25 Jan 2022 21:35:24 GMT

Unrelated to the positional error but you can add the National Bridge Inventory from ArcGIS Online to your ArcGIS Pro project by going to the Catalog Pane->click the cloud>search for National Bridge Inventory and add it as a web layer to your map. See graphic below.

Re: Help with Geocoding Format

DanPatterson — Tue, 25 Jan 2022 21:42:37 GMT

Recording and Coding Guide (dot.gov)

page 8 item 16 Degrees Minutes Seconds XX XX XX.xx

Re: Help with Geocoding Format

Robert_LeClair — Tue, 25 Jan 2022 21:45:43 GMT

So to Dan's point, you'll need to convert S & U to decimal degrees using the following formula -

dd = deg + min/60 + sec/3600

Once you parse out the data correctly.

Re: Help with Geocoding Format

DanPatterson — Tue, 25 Jan 2022 21:58:27 GMT

or my previous suggestion

Convert Coordinate Notation (Data Management)—ArcGIS Pro | Documentation

Re: Help with Geocoding Format

KamillePreto — Wed, 26 Jan 2022 13:45:21 GMT

That's great to know, thank you. I'm unfamiliar with the breakdown of the format so this is good information. I just did a quick scroll and confirmed that the XX and YY numbers do not go above 59. The points are anywhere between 7 and 20 miles off of where they should be.

Re: Help with Geocoding Format

KamillePreto — Wed, 26 Jan 2022 13:48:48 GMT

Oh this is fantastic, I would much rather just pull it into my project than try to dig in and figure this out, thank you! I attempted to download it from the NBI web app (National Bridge Inventory - Bridge Inspection - Safety - Bridges & Structures - Federal Highway Administration (dot.gov), but I could not find an option besides downloading the actual table. But I honestly didn't dig much further into other options.

Thank you again!

Re: Help with Geocoding Format

KamillePreto — Wed, 26 Jan 2022 13:51:49 GMT

Thank you everybody!

Re: Help with Geocoding Format

Robert_LeClair — Wed, 26 Jan 2022 22:05:31 GMT

Kamille - if you're satisfied that your question has been answered, please mark the solution that you feel was correct. That way it closes this thread and can provide answers to other folks. Have a great day!