Point File DeskGet COGO
Handoff notes

Keep leading zeros in survey point IDs during a CSV handoff

Point 007 and point 7 can be different identifiers. Follow one record through a column swap and check the actual CSV before sending it to CAD.

Vendrato ·

Read the first record as text

Consider the PNEZD record 007,5020.250,8100.750,12.40,Control. The first field names the point. Its three characters are part of the identifier. Northing and easting are quantities, but converting the point name to a number changes what the crew supplied.

Check the swap in a plain-text view

Choose PNEZD input and PENZD output in the formatter. The result should read 007,8100.750,5020.250,12.40,Control. Only the positions of the two horizontal coordinates change. Inspect the first and last records in a text editor before passing the file on.

A spreadsheet can display 007 as 7 when it infers the column type. In Excel, import the file through From Text/CSV and set the point column to Text before loading. Reopen any saved export in a text editor to confirm the literal characters.

Give the CAD technician a check point

In the handoff note, identify point 007 as northing 5020.250 and easting 8100.750 and state the job’s units. This one line lets the recipient test both the identifier and the axis order independently of the CSV header.

References

Get COGO on the App Store