Skip to main content
Geographic Information Systems

Return to Answer

edited body
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

QGIS cannot use esri'sEsri's geometry format so the error you are seeing ifis caused by something else.

When you create a feature class in arcgisArcGIS and specify that you want to use the PG_GEOMETRY option, arcgisArcGIS registers the table as having a generic geometry type column. You can see this in the public.geometry_columns table postgisPostGIS uses as a central registry of spatial tables.

You should change this to a specific geometry type, like POINT, LINESTRING, POLYGON, MULTILINESTRING or MULTIPOLYGON.

The naming of spatial types and functions are many times equal between postgisPostGIS and esriEsri. The big difference is that esriEsri stuff in stored in the sde schema. PostgisPostGIS keeps these things in the public schema.

QGIS cannot use esri's geometry format so the error you are seeing if caused by something else.

When you create a feature class in arcgis and specify that you want to use the PG_GEOMETRY option, arcgis registers the table as having a generic geometry type column. You can see this in the public.geometry_columns table postgis uses as a central registry of spatial tables.

You should change this to a specific geometry type, like POINT, LINESTRING, POLYGON, MULTILINESTRING or MULTIPOLYGON.

The naming of spatial types and functions are many times equal between postgis and esri. The big difference is that esri stuff in stored in the sde schema. Postgis keeps these things in the public schema.

QGIS cannot use Esri's geometry format so the error you are seeing is caused by something else.

When you create a feature class in ArcGIS and specify that you want to use the PG_GEOMETRY option, ArcGIS registers the table as having a generic geometry type column. You can see this in the public.geometry_columns table PostGIS uses as a central registry of spatial tables.

You should change this to a specific geometry type, like POINT, LINESTRING, POLYGON, MULTILINESTRING or MULTIPOLYGON.

The naming of spatial types and functions are many times equal between PostGIS and Esri. The big difference is that Esri stuff in stored in the sde schema. PostGIS keeps these things in the public schema.

Source Link
Duarte Carreira
Duarte Carreira
  • 416
  • 5
  • 8

QGIS cannot use esri's geometry format so the error you are seeing if caused by something else.

When you create a feature class in arcgis and specify that you want to use the PG_GEOMETRY option, arcgis registers the table as having a generic geometry type column. You can see this in the public.geometry_columns table postgis uses as a central registry of spatial tables.

You should change this to a specific geometry type, like POINT, LINESTRING, POLYGON, MULTILINESTRING or MULTIPOLYGON.

The naming of spatial types and functions are many times equal between postgis and esri. The big difference is that esri stuff in stored in the sde schema. Postgis keeps these things in the public schema.