Skip to main content
  • EN

I have a collection of points in a .CSV which are currently in OSGB36 and have been through the OSTN02 transformation.

The CSV file has the following headers;

IDXYZabTypeDescription

I want to put them through the OSTN15 transformation. Is the way my CSV file is formatted causing the problem ?

I have been playing around with the GridInQuestII Reprojector, but I have not been able to transform my coordinates successfully. As my points are in the Scottish highlands I know there should be some change, even if it's just a few CM in the Z.

Should I re project into ETRS89 Geodetic first then re project into OSTN15 ?

I am currently using FME Workbench 2017.0 (32) beta and I'm fairly new to FME so I could be missing something obvious.

Hi @jgillespie

Just a question, have you set up the CSV Reader to convert the X_COORD, Y_COORD, Z_COORD values into a geometry in the parameters form?

You'll need a geometry to work with. Alternative would be to add a VertexCreator transformer after the Reader and use the attribute values to create the geometry. You can always extract the values after reprojection using CoordinateExtractor transformer back into attributes.

Hi @jgillespie

Just a question, have you set up the CSV Reader to convert the X_COORD, Y_COORD, Z_COORD values into a geometry in the parameters form?

You'll need a geometry to work with. Alternative would be to add a VertexCreator transformer after the Reader and use the attribute values to create the geometry. You can always extract the values after reprojection using CoordinateExtractor transformer back into attributes.

@mark_1spatial I've tried both of your suggestions and I've still not had any luck. I've inserted my fmw and the most recent log file - if you'd be able to look over them and spot any errors on my behalf. ostn02-ostn15-test.fmwostn02-ostn15-test.txt

I've been in contact with Dave Campanas from safe.com support. He has solved my query, so I thought i'd post the solution on here.

He suggested adding a CoordinateExtractor transformer to extract the re-projected coordinates into the X_COORD, Y_COORD, and Z_COORD attributes before writing out to the new CSV file.

Further to this, I've added an AttributeManager before my writer to help with replacing the old coordinates.

The resulting CSV shows the changes I was expecting, so I am currently happy with my results. Please see the attached screen clip.

@mark_1spatial I've tried both of your suggestions and I've still not had any luck. I've inserted my fmw and the most recent log file - if you'd be able to look over them and spot any errors on my behalf. ostn02-ostn15-test.fmwostn02-ostn15-test.txt

Sorry was annual leave last week and didn't see your reply until now. Glad you got it sorted out.

 

 

Reply


Community Stats

30,133
Posts
114,389
Replies
37,772
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.