1

As the title says I have a huge database containing (among other data) a pair of coordinates using ED50 standard for each record.

I'm tasked to update the whole thing and convert all the ED50 entries to WGS84. The whole database is used in FileMaker, I can export it in csv,xls,tab and some other formats.

Is there a "function" that I can apply to all these fields and change them all at once?

I searched on the internet but have found nothing useful.

  • 1
    What did you search for? This was the first result from google when I searched: tool-online.com/en/coordinate-converter.php – jbalk Dec 21 '16 at 3:07
  • Export to CSV and use GDAL/OGR. – BradHards Dec 21 '16 at 9:03
  • 3
    Are the coordinates contained within one country or multiple countries? That will affect whether you can do the whole lot at once or whether you should split it up into groups to take advantage of local transformations. – mkennedy Dec 21 '16 at 16:16
  • @BradHards I think your comment is worth expanding as a full answer. – AndreJ Dec 22 '16 at 6:36
1

It looks like FileMaker (which I know nothing about) is capable of implementing coordinate conversion functions:

https://community.filemaker.com/thread/64899

but you'll have to find the equations and implement that yourself.

Alternatively, export to a spatial database (PostGIS - free, open source) or a GIS (QGIS - free, open source) do the conversion (plenty of help online), export from there, load back into FileMaker.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.