MapInfo Pro

I am creating a map using the US_CNTY.TAB dataset provided by Pitney Bowes in MapInfo. I am working with counties that border the Great Lakes and the counties are overlapping into the area where the lakes are located.

How can I fix this?

Hi Amy, could you please share the dataset or a little more detail as to what you are trying to do, to see where the issue could be? You can attach it here itself.

Thanks,

Shweta

Quite possibly, the counties and lakes could be 2 different layers and/or having different projections.

Regards,

Shweta

Good morning Shweta,

Thank you for your response. I have attached the the data set. I attempted to bring in the lakes as a layer, but when I do that it fills in all the lakes. Filling in all lakes white makes the map looked speckled.

Thanks.

Hi Amy

You need to upload the other files that make up a table too - with the extensions .map .dat and .id. And the same with the Lakes table.

Yeah, it's not a good fit but you tend to get this with free data.

Next, what are you trying to do?? There are a lot of Lakes, so you need to select just the Great Lakes and perhaps save them as a new table called Great_Lakes.

Then you can query - SQL Select - to select the Counties. Even though the geometry isn't good, the Lakes still intersect the Counties. So you can Select from the US_CNTY and Great_Lakes tables where US_CNTY.obj Intersects Great_Lakes.obj

I get 81 Counties in my results

Amy, the county objects extending in to the Great Lakes (and in to the Ocean) are technically correct but I agree, they "look" incorrect.....

To resolve this, you can easily create a "shorelined" version of a copy the County table like this:

To create a "shorelined" County Table:

1) Open the US_CNTY and USA tables from the Pro Sample Data. Make a copy of the county table and open the copy.

2) Select all County objects from the copy and make the table editable. Go to Spatial> Set Target.

3) Select all State objects from the USA table and go to Spatial > Erase Outside and follow the prompts.

4) Pro will edit all county objects that extend beyond the State borders so that they "clip" the state objects.

4) Save the edits made to the County copy table.,

Pre:

Post:

Hope this helps!

Cheers!

Dave