MapInfo Pro: Make table mappable - No geometry

[Nico]

Hi there

I would like to access spatial data of an existing PostGIS database (PostgreSQL 9.4 / PostGIS 2.1.4) in MapInfo Pro15.0.

After making a table mappable I get the attribute table but I am missing the geometry.

When I want to open a table I made mappable (set to "download data") I get the following error message: "The map objects in the table you have downloaded cannot be edited. See the MapInfo User's Guide for more information."

When I want to open the table (set to "Live Access") I get no geometry.

I uploaded a TAB-file in the database in order to get information about the entries in the mapinfo_mapcatalog table (see upper entry)

The lower entry is from the database.

Does anyone know how to access the geometry?

Thanks in advance.

Best Nico

19.2	Landschaftsruhezonen_LFG	public	SP_GEOMETRY	634471.3	93892.3	833839.8	188481.7	634471.3	93892.3	833839.8	188481.7	Earth Projection 25, 158, "m", 7.439583333333, 46.952405555556, 600000, 200000 Bounds (400000, 0) (900000, 400000)		NO_COLUMN	NO_COLUMN	1	MI_STYLE		0
19.3	tlm_stehendes_gewaesser	public	wkb_geometry	3000000	2000000	3000000	2000000	0	0	0	0	Earth Projection 25, 158, "m", 7.439583333333, 46.952405555556, 2600000, 1200000 Bounds (1000000, 0) (5000000, 4000000)	Symbol (35,0,12)  Pen (1,2,0)  Pen (1,2,0)  Brush (2,16777215,16777215)	NO_COLUMN	NO_COLUMN	0			39624

[Nico]

Hi there

I just wanted to post the answer to this problem.

The data in the PostGIS database has 3d-geometry (x,y,z coordinates).

MapInfo is not able to read 3d-geometry.

That's it.

Best Nico

[Peter Horsbøll Møller]

Typically, MapInfo Pro would just read the 2D part of the features and ignore the Z-values on the nodes.

 

Have you tried making the layer mappable by first adding the MapCatalog to the database via EasyLoader and then using MapInfo Pro to add a spatial registration of the table to the MapCatalog?

 

Peter Horsbøll Møller

Pitney Bowes

--
--
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.

---

[Nico]

Hi Peter

That is what I did. I first created the mapinfo.mapcatalog file using EasyLoader. After that I used "make table mappable" to get the geometries. However that did not work.

Do you see another possibility to get the geometries?

Best Nico

[Peter Horsbøll Møller]

What error did you get when you tried to “Make Table Mappable”?

 

There might be a number of reasons why it fails and the error might give me a clue what is wrong.

 

Peter Horsbøll Møller

Pitney Bowes

 

From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Nico
Sent: 29. juni 2017 15:43
To: MapInfo-L <mapi...@googlegroups.com>
Subject: [MI-L] Re: MapInfo Pro: Make table mappable - No geometry

 

Hi Peter

--

--
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.

[Nico]

There is no error when making a table mappable. The entry in the mapinfo_map.mapcatalog works for every dataset I made mappable. However the geometry is still not visible.

After that I was in contact with the PitneyBowes Support for quiet a long time and I sent them an export file. They then told me, that most of the geometry cells were defined as 3-dimensional and that MapInfo Pro would not support 3d geometries. For me that was answer enough to stop trying to access the geometries of PostGIS database using MapInfo Pro.

Only as you said, that MapInfo would just ignore the z-values on the nodes I was wondering again...

Best Nico