|Rummaging in the Toolbox: Getting Coordinates into your Table |
| ||A common request I get is how to extract coordinate values from a table. There are lots of ways this can be done in MapInfo Pro, including using the SQL Select or Update Column capabilities. While it is not hard to use those features within MapInfo Pro to get X and Y values, they do require multiple steps. |
To make this an easy process within MapInfo Pro you can use the Coordinate Extractor tool.
The Coordinate Extractor does exactly what its name describes. It can extract coordinate values from a table either in the table's native projection or using another projection for each object in the table. The coordinate extractor is found within the Tool Manager. To use it, follow the steps below.
Using the Coordinate Extractor
- Make sure the table you wish to extract values from is open. Keep in mind, this tool will not work on selections, seamless tables, raster images, read-only tables and tables opened via ODBC.
- Run the tool. It is found in the Tool manager.
32-bit versions: The Tool Manager is accessed from the Tools menu.
Version 12.5 (64 bit) - this release did not include the Coordinate Extractor tool in the Tool Manager. If you have it available you can run the Coordinate Extractor from the 32 bit versions of MapInfo Pro. To do this, use the Run Program command in the Tool Manager
Version 15.2: The Coordinate Extractor tool is available from the Tool Manager. You will find the Tool Manager on the Home tab. Click the Registered tab to find the list of all the tools.
To extract coordinates from a table in the 32 bit versions you will find the menu command in Tools > Coordinate Extractor > Extract Coordinates...
To extract coordinates from a table in the 64 bit version go to the Tool Manager window, and double-click on the Coordinate Extractor command in the Running tab
Coordinate Extractor dialog box
When the Coordinate Extractor dialog displays, it's now a matter of filling it out.
Identify your table, specify the columns to populate the x and y values into. You can build in new columns to house the coordinate values if needed. Choose whether you want to use the table's native projection or to use a non-native projection for the coordinates.
Press the OK button and you're done!
Want more tools?
The Tool Manager in MapInfo Pro has a number of useful tools but did you know there is a Community Downloads site with many more great tools and utilities for MapInfo Pro? This is thanks to a generous community and dedicated Pitney Bowes staff members.
Here is the link to the Community Downloads site: http://communitydownloads.pbinsight.com/
Article by Sue Disy, Senior Sales Engineer
When not writing articles for "The MapInfo Pro" journal, Sue works with Pitney Bowes Customers all over North America as a Sales Engineer. When not working Sue enjoys staying active. You may find her horseback riding in the Adirondack mountains, practicing yoga, enjoying personal travel or staying home and cooking in her kitchen.