Postgis-Sharpmap Query

Question

I want to display a map in offline mode (without Internet connectivity), so I have imported OSM data into my PostgreSQL database using osm2pgsql installer. I went through various links and tutorials and now I am currently using this link: https://sharpmap.codeplex.com/wikipage?title=Add%20a%20PostGIS%20layer

When I run this code using SharpMap, it gives the error of "geometry column not found" in the table. I am stuck as i don't know what should I enter as "tablename" and "idColumn" in the above reference link code and particularly WHY?

Can anyone guide me?

Answer 1

You should use the constructor that takes connectionString, tableName, objectIdColumn, geometryColumn.

So your code should look like this:

C#
var p = new SharpMap.Data.Providers.PostGIS(connectionString, "plant_osm_polygon", "way", "osm_id");

If you don't provide the name of the geometry column (in your case: "way"), the PostGIS provider attempts to query the geometry column name from the geometry_columns view. That seems to fail somehow.