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.