I have .mdb file ( Microsoft Access file ) which appears to be a shapefile index ( snapshot as attached ) and i need to get longitude and latitude from this so that file can be fed to Tableau or PowerBI for visualization purpose.

enter image description here

  • You can add it to ArcMap if it has geometries. Then use tool Add Geometry Attributes to calculate centroids or whatever you are asking. – BERA Mar 10 '18 at 8:50
  • Have you looked inside your .mdb with ArcCatalog? It's probably a personal geodatabase, in which case I wouldn't be poking around too much in the system tables (which table is this?), if only tables can bee seen then it's not a personal geodatabase in which case you need to find out what coordinate system the numbers are in; the X values are far too large for UTM and there's no decimals which makes me think those numbers may not be coordinates at all. – Michael Stimson Mar 10 '18 at 11:47

These are probably easting/northing values so it depends on where the data is on the globe. To get Longitude Latitude you need to transform it and for that, you need to find out the projection system. You can use QGIS with OpenLayers plugin to help in locating the points in the basemap.


you have to project them to latlon system. QGIS can project to latlon system.

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

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.