topic Re: Offset Coordinates in Coordinate Reference Systems Questions

Offset Coordinates

DavidCobb1 — Mon, 11 Jul 2016 20:45:04 GMT

I have an excel file that has XY data in state plane format. The coordinates were taken from a survey plat and each coordinate has its own offset value. Is there an easy way or a tool that I can use that will shift the coordinates to their actual location after the offset is applied?

Thank you!

Esri Community

Esri Surveying

Re: Offset Coordinates

DarrenWiens2 — Mon, 11 Jul 2016 20:55:21 GMT

Can you provide a simple example of your data? I'm imagining you could add two new columns to your Excel file, calculate the new coordinates into the new columns using x,y offset values from other columns, and plot your plots using those coordinates, but that seems too easy...

Re: Offset Coordinates

DavidCobb1 — Mon, 11 Jul 2016 21:11:22 GMT

The data has been attached to the post. Thank you for taking a look at it.

Re: Offset Coordinates

DarrenWiens2 — Mon, 11 Jul 2016 21:18:58 GMT

That dataset only has one offset value. Do you have any more information? Simple situation that shows this doesn't work, as is: you're standing at (0,0). I tell you to "Move 10". Where do you go? You need more numbers, or more rules.

Re: Offset Coordinates

DavidCobb1 — Mon, 11 Jul 2016 21:25:22 GMT

I do not have any more information. The table on the original survey plat only shows what I have provided and then a station value such as 1700+530.387.

Re: Offset Coordinates

AbdullahAnter — Mon, 11 Jul 2016 21:34:59 GMT

I think that link is discuss same your problem:

Converting Cartesian coordinates (meters) into UTM

Re: Offset Coordinates

DarrenWiens2 — Mon, 11 Jul 2016 21:51:23 GMT

It appears as though your points are in reference to some other line (like I've guessed below, negative offsets blue, positive offsets red). Are you trying to move those points to their position on the line, or what is the objective?

Re: Offset Coordinates

DavidCobb1 — Mon, 11 Jul 2016 21:56:47 GMT

Most of the locations are "found iron pins" along the roadway you see on the map to the west of the line you have drawn. Once I have the dots in the correct location I can georeference in an image from the survey plat so that I can get the location of easements and right of way boundaries.

Re: Offset Coordinates

MelitaKennedy — Mon, 11 Jul 2016 22:16:01 GMT

If the table lists easting/northing values, that should be fine unless they're ground coordinates rather than grid (projected) coordinates. I have a feeling that the plat has more information like the direction of the lines that these station coordinates plus offsets refer to.

Melita

Re: Offset Coordinates

DarrenWiens2 — Mon, 11 Jul 2016 22:22:46 GMT

If I understand correctly, your point coordinates are "correct" for some coordinate reference system slightly different from State Plane Meters, like there is an offset of 30m or so (as I've mapped above). The offset value in your spreadsheet corresponds to the offset from the road center, where zero would be the center of the road. Unfortunately, as they are, the coordinates don't correspond to the road in terms of regular State Plane Meters. Does your survey plan give any other hints about the coordinate reference system?

Re: Offset Coordinates

DavidCobb1 — Tue, 12 Jul 2016 13:25:51 GMT

No it does not.

Re: Offset Coordinates

DavidCobb1 — Tue, 12 Jul 2016 13:27:58 GMT

I do not see any other information on the Plat that would be able to help me identify how I can account for the offset distances when plotting the northing/easting values.