[mapserver-users] postgres layer not visible
Maiorano Pasquale
Pasquale.Maiorano at ssi.it
Thu Jan 15 05:58:30 PST 2015
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 following folder
C:\ms4w\apps\pmapper\pmapper-4.3.2\config\gabon where I stored the
pmapper_demo.map. In the dir config I stored the file config_gabon.xml.
You can find hereinafter the file pmapper_demo.map:
########################################################################
########################
# Adapt settings in map file <tt>pmapper_demo.map</tt> for the following
tags to match settings
# on your machine (see additionally MapServer documentation for detailed
information):
#
# MAP
# SHAPEPATH
# FONTSET
# SYMBOLSET
#
# WEB
# IMAGEPATH
# IMAGEURL
#
########################################################################
##########################
#
# Start of map file
#
MAP
EXTENT 83684.2557031431 48040.09765625 455660.392391208 642189.8125
UNITS meters
#EXTENT -15 30 40 70
#UNITS dd
SIZE 600 500
SHAPEPATH "../../../pmapper_demodata"
SYMBOLSET "../common/symbols/symbols-pmapper.sym"
FONTSET "../common/fonts/msfontset.txt"
RESOLUTION 96
IMAGETYPE png
INTERLACE OFF
#CONFIG "PROJ_LIB" "C:/proj/nad/"
PROJECTION
"proj=tmerc"
"lat_0=0"
"lon_0=12"
"k=0.9996"
"x_0=500000"
"y_0=500000"
"datum=WGS84"
"units=m"
"no_defs"
END # PROJECTION
#
# Start of web interface definition
#
WEB
TEMPLATE "map.html"
IMAGEPATH "/ms4w/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
METADATA
#"MAPFILE_ENCODING" "ISO-8859-1"
#"ows_title" "WMS Demo Server"
#"ows_onlineresource" "http://wms.yourserver.org?owskey=test&"
#"ows_srs" "EPSG:3035 EPSG:4326"
END # Metadata
END # Web
#
# Start of Reference map definition
#
REFERENCE
EXTENT 83684.2557031431 48040.09765625 455660.392391208 642189.8125
IMAGE "../../images/gabon.png"
SIZE 199 149
COLOR -1 -1 -1
OUTLINECOLOR 255 0 0
END # Reference
#
# Start of legend object
#
LEGEND
STATUS OFF
IMAGECOLOR 255 255 255
# OUTLINECOLOR 0 0 0
POSITION ll
KEYSIZE 18 12
KEYSPACING 10 5
TEMPLATE "void"
LABEL
TYPE TRUETYPE
FONT "FreeSans"
SIZE small
POSITION AUTO
COLOR 0 0 89
OUTLINECOLOR 255 255 255
ANTIALIAS TRUE
END
END
#
# Start of ScaleBar definition
#
SCALEBAR
STATUS off
TRANSPARENT off
INTERVALS 4
SIZE 200 3
UNITS kilometers
COLOR 250 250 250
OUTLINECOLOR 0 0 0
BACKGROUNDCOLOR 100 100 100
STYLE 0
POSTLABELCACHE true
LABEL
COLOR 0 0 90
#OUTLINECOLOR 200 200 200
SIZE small
END # Label
END # Reference
# SYMBOLS USED IN PMAPPER
# - 'circle' always necessary (used e.g. for highlight)
# - 'square' used in currecnt map file
# Symbols can also be defined via tag SYMBOLSET (see above)
Symbol
Name 'circle'
Type ELLIPSE
Filled TRUE
Points
1 1
END
END
Symbol
Name 'square'
Type VECTOR
Filled TRUE
Points
0 1
0 0
1 0
1 1
0 1
END
END
#================== START OF LAYER SECTION =====================#
LAYER
CONNECTION "dbname='gabon' host=localhost port=5432 user='postgres'
password='nicoletta' sslmode=disable"
CONNECTIONTYPE POSTGIS
DATA 'the_geom FROM "gabon_coastline_riproiettato" USING UNIQUE GID
USING SRID=5223'
EXTENT 131038.078125 48040.09765625 433953.28125 642189.8125
METADATA
"ows_title" "gabon_coastline_riproiettato"
END # METADATA
NAME "gabon_coastline_riproiettato"
PROJECTION
"proj=tmerc"
"lat_0=0"
"lon_0=12"
"k=0.9996"
"x_0=500000"
"y_0=500000"
"datum=WGS84"
"units=m"
"no_defs"
END # PROJECTION
STATUS ON
TILEITEM "location"
TYPE LINE
UNITS METERS
CLASS
NAME "gabon_coastline_riproiettato"
STYLE
COLOR 121 8 226
WIDTH 1
END # STYLE
END # CLASS
END # LAYER
LAYER
CONNECTION "dbname='gabon' host=localhost port=5432 user='postgres'
password='nicoletta' sslmode=disable"
CONNECTIONTYPE POSTGIS
DATA 'the_geom FROM "public"."Fiumi_riproiettato" USING UNIQUE gid
USING UNIQUE 5223'
EXTENT 150981.730577697 166673.281916046 346296.768620565
389978.665308564
METADATA
"ows_title" "Fiumi_riproiettato"
END # METADATA
NAME "Fiumi_riproiettato"
PROJECTION
"proj=tmerc"
"lat_0=0"
"lon_0=12"
"k=0.9996"
"x_0=500000"
"y_0=500000"
"datum=WGS84"
"units=m"
"no_defs"
END # PROJECTION
STATUS ON
TILEITEM "location"
TYPE LINE
UNITS METERS
CLASS
NAME "Fiumi_riproiettato"
STYLE
COLOR 62 186 93
WIDTH 1
END # STYLE
END # CLASS
END # LAYER
LAYER
CONNECTION "dbname='gabon' host=localhost port=5432 user='postgres'
password='nicoletta' sslmode=disable"
CONNECTIONTYPE POSTGIS
DATA 'the_geom FROM "public"."Confini_Gabon_SR_GabonTM" USING UNIQUE
gid USING UNIQUE 5223'
EXTENT 128874.546875 56689.61328125 781735.125 760206.0625
METADATA
"ows_title" "Confini_Gabon_SR_GabonTM"
END # METADATA
NAME "Confini_Gabon_SR_GabonTM"
PROJECTION
"proj=tmerc"
"lat_0=0"
"lon_0=12"
"k=0.9996"
"x_0=500000"
"y_0=500000"
"datum=WGS84"
"units=m"
"no_defs"
END # PROJECTION
STATUS OFF
TILEITEM "location"
TYPE POLYGON
UNITS METERS
CLASS
NAME "Confini_Gabon_SR_GabonTM"
STYLE
COLOR 133 45 126
OUTLINECOLOR 0 0 0
WIDTH 1
END # STYLE
END # CLASS
END # LAYER
END #Map
Have you got any ideas where I am wrong?
Any advice will be appreciated.
Pasquale Maiorano
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150115/185d8404/attachment-0001.html>
More information about the mapserver-users
mailing list