Match Mapinfo map to Lat/Long Coordinates

[Taren Sanders]

Hi All,

I think this should be fairly simple, but I am new to GIS and can't seem to find an answer.

I have a Mapinfo file (.MIF) which contains boundary points for geographical areas. Each area has a unique name/code. In a seperate file (xls/csv) I have a list of places, each with a latitude and longitude coordinates.

I'd like to match each item in the xls to it's geographical area, and then export the result to excel. Could somebody help give me an idea of what I should be doing?

I can open the MIF in MapInfo, and it looks like it should, but I can't find the way to match the lat/long in the second file.

Many thanks.

[Jamie]

If you open both files in mapinfo then you can use table > update column to do what you need.

Match where a unique id matches in both tables. To pull information from one table to the other.

[KTG Infotech]

Jamie is right. Do column update

On Saturday, July 11, 2015, Jamie <jamie...@gmail.com> wrote:
> If you open both files in mapinfo then you can use table > update column to do what you need.
>
> Match where a unique id matches in both tables. To pull information from one table to the other.
>

> --
> --
> You received this message because you are subscribed to the
> Google Groups "MapInfo-L" group.To post a message to this group, send
> email to mapi...@googlegroups.com
> To unsubscribe from this group, go to:
> http://groups.google.com/group/mapinfo-l/subscribe?hl=en
> For more options, information and links to MapInfo resources (searching
> archives, feature requests, to visit our Wiki, visit the Welcome page at
> http://groups.google.com/group/mapinfo-l?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

--

Thanks & Regards

Kalai Selvan

skypes - ktgcad

[Timothy Mashford]

Hi Taren,

Since you've said you're new to GIS, I'll provide some slightly more detailed instructions for this (you may need to consult the help file for the specifics). After you have the Area MIF opened:

1. Open the .csv file using File -> Open, change the file type to .csv, tick option 'Create copy for read/write'

2. Go Table -> Create Points, select your X/Long and Y/Lat coordinate columns, and set the correct projection (Long/Lat WGS84?)

3. Go Table -> Maintenance -> Table Structure, click Add Field then set the new column as required to store the area name/code (e.g. Character, 20 width?)

4. Go Table -> Update Column, set the correct table and column names. Then select 'Get Value from Table' = your Area table, press Join and specify the correct join type, i.e. objects from your .csv table are Within objects from your MIF table. Then select the name/code column from your Area table.

5. This should update the new column with the area name/code for each row. You can then export your results using Table -> Export, and select .csv file type.

Tim

--