Re: [mapserver-users] postgres layer not visible

On 2015-01-23 2:31 PM, Jeff McKenna wrote: Hi Pasquale, Did you resolve this issue? If I had to guess, it would be that this issue is caused by PostGIS using an older PROJ4 library for projections, that does not contain the EPSG (SRID) that you need (5223 or http://epsg.io/5223). You could use

Re: [mapserver-users] postgres layer not visible

Hi Pasquale, Did you resolve this issue? If I had to guess, it would be that this issue is caused by PostGIS using an older PROJ4 library for projections, that does not contain the EPSG (SRID) that you need (5223 or http://epsg.io/5223). You could use the commandline utility psql and check i

[mapserver-users] postgres layer not visible

Dear Jeff, I implemented your advice and set the OIDS=true. Now the utility shp2img return the following: ... error executing query: ERRORE: find_SRID() could not find the corresponding SRID Take into account that the used SRID is directly returned by the QGIS plugin named "RT MapServe

Re: [mapserver-users] postgres layer not visible

Your PRIMARY KEY is "gid" not ID. try: /DATA 'the_geom FROM "public"."Fiumi_riproiettato" USING UNIQUE gid USING SRID=5223'/ *Worth Lutz* -- On 01/19/2015 04:26 AM, Maiorano Pasquale wrote: Dear Brent Fraser and everybody, The “Create Table” statement from Postgres is the

Re: [mapserver-users] postgres layer not visible

On 2015-01-19 5:26 AM, Maiorano Pasquale wrote: WITH ( OIDS=FALSE This is your mistake. When creating tables in Postgres for use with MapServer/GDAL, I always always create with OIDS. (this can be set as the default in your postgresql.conf file as well) Please generate a new table wit

Re: [mapserver-users] postgres layer not visible

Hi, You wrote earlier: "When I run the shp2img utility it replies that the ID column does not exist, but using the pgadmin, I see the column named ID and is also the primary key of the table "Fiumi_riproiettato"!!!" I wonder how you can see column "ID" is the table is created as to have a col

[mapserver-users] postgres layer not visible

Dear Brent Fraser and everybody, The "Create Table" statement from Postgres is the following: CREATE TABLE "Fiumi_riproiettato" ( gid serial NOT NULL, "Nome" character varying(80), "Luinghezza" integer, the_geom geometry(LineString), CONSTRAINT "Fiumi_riproiettato_pkey" PRIM

Re: [mapserver-users] postgres layer not visible

-users@lists.osgeo.org Subject: [mapserver-users] postgres layer not visible I tried to use the simple quote, the double quote, the lower case, the upper case: nothing change. The id/ID/Id column is unknown!! Help!! ___ mapserver-user

[mapserver-users] postgres layer not visible

Is there anyone that is able to publish on the web a simple QGIS project, composed of a couple of shapefile and stored in postgres, in MapServer? I am on Windows 7 platform. I need the map file generated by the RT MapServer export QGIS plugin, or better, the map file used by MapServer to show the r

[mapserver-users] postgres layer not visible

I tried to use the simple quote, the double quote, the lower case, the upper case: nothing change. The id/ID/Id column is unknown!! Help!! ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-

Re: [mapserver-users] postgres layer not visible

I just guessing but a few things to try: /DATA 'the_geom FROM "public"."Fiumi_riproiettato" USING UNIQUE "ID" USING UNIQUE 5223' ///DATA 'the_geom FROM "public"."Fiumi_riproiettato" USING UNIQUE "ID" USING SRID=5223' ///DATA 'the_geom FROM "public"."Fiumi_riproiettato" USING UNIQ

[mapserver-users] postgres layer not visible

Hi there I'm deep in the bull-shit. Help me! I used the utility shp2img but I do not understand where the map file is wrong. Hereinafter are the three rows in the LAYER tag in the map file that "should allow" the connection to postgres: CONNECTION "dbname='gabon' host=localhost port=5432

Re: [mapserver-users] postgres layer not visible

Hi, This is another reported issue with a pmapper demo, kassandraxx had similar troubles yesterday. Is there some workshop going on, I do not remember any mails about pmapper since many years. Kassandraxx sent the following report which seems to mean that MapServer is using a deprecated functi

Re: [mapserver-users] postgres layer not visible

Hi Pasquale, I always test my mapfile with the shp2img commandline utility (http://mapserver.org/utilities/shp2img.html). An example command would be: shp2img -m pmapper_demo.map -o ttt.png -map_debug 3 That utility is often a massive help to diagnosing problems with layers. :) -jeff -

[mapserver-users] postgres layer not visible

Dear Sirs, I followed a Youtube tutorial trying to show a couple of shape file previously save on postgres DB. I modified the pmapper_demo.map and the related config_xxx.xml. When a run the following page http://localhost/pmapper/map_default.phtml?config=gabon nothing happens. I created the fo