I have installed Mapserver 7.4.0 with PostGIS 2.4. However, I can't load any layer with geography
column.
This is my MAP file (with contents prior to LAYER
omitted):
MAP
<omitted>
LAYER
COMPOSITE
END # COMPOSITE
CONNECTION "host=127.0.0.1 dbname=testgis user=postgres password=****** port=5432"
CONNECTIONTYPE POSTGIS
DATA "geog from srwg"
METADATA
"coordsys_name" "Longitude-Latitude / WGS 84"
END # METADATA
NAME "New Layer"
PROJECTION
"proj=longlat"
"datum=WGS84"
"no_defs"
END # PROJECTION
STATUS ON
TEMPLATE "query"
TILEITEM "location"
TYPE POLYGON
UNITS METERS
CLASS
NAME "Class (0)"
STYLE
COLOR 255 255 255
OUTLINECOLOR 0 0 0
SIZE 8
END # STYLE
END # CLASS
END # LAYER
END # MAP
It comes with the following error:
msPostGISLayerWhichShapes(): Query error. Error executing query
Is Mapserver incompatible with geography
columns?
geometry
and try to find it inGEOMETRY_COLUMNS
table)using srid=
, so i hoped it may work for you.