Fwd: Re: Fwd: Re: [Mapbender_dev] Printing High Quality 288dpi Blank PDF

daveyclark dclark at tayside-vjb.gov.uk
Tue Jun 28 04:02:39 EDT 2011


Hi Armin

My versions of software are listed below:

PostgreSQL 8.4/pg Admin III/ PostGIS 1.5

Appache Web Server 2.2.15

Mapbender 2.7

MapServer 5.6.5 CGI and MapScript (CSharp, Java, PHP, Python)

PHP 5.3.2

I have also pasted my wms.map file below to see if you think there are any
problems in there.

Many Thanks 
Dave

*wms.map*

# The annotated map file (sort of)
# Created by Pericles S. Nacionales for the MapServer tutorial
# 20050408
#
# MapServer map file uses the pound sign (#) to denote the start of a line
# comment--each line that needs to be commented has to be prepended with a
"#".
#
# Map files begin with MAP keyword to signify the start of the map object.
# Well, the entire map file is THE map object.  Enclosed between MAP and END
# at the very bottom of this map file, are keyword/value pairs and other
# objects.
MAP
  *MAXSIZE 5000*  
  CONFIG "PROJ_LIB" "p:/ms4w/proj/nad/"
  IMAGETYPE      png24

EXTENT 334160 728620 348810 736430
#EXTENT 330000 725000 360000 740000



  SIZE           900 640
  SHAPEPATH      "../data"

  SYMBOLSET      "../symbols/symbols35.sym"
  FONTSET        "../fonts/fonts.list"
  TEMPLATEPATTERN 'test4*'

  PROJECTION
    "init=epsg:27700"
  END # This is the ending of the output projection


#  TEMPLATEPATTERN 'test2_page*'

# The web object is defined at the level below the map object.  All 
# web-related parameters (I interchange "parameters" and "keyword/value 
# pairs" quite frequently, sorry about that) are defined in this object.
  WEB
#    HEADER    '../templates/wms_header.html'
#    FOOTER    '../templates/wms_footer.html'
HEADER    '../templates/header.html'
FOOTER    '../templates/footer.html'
    TEMPLATE  'p:/ms4w/apps/tutorial/htdocs/wms_template.html'
    IMAGEPATH 'p:/ms4w/tmp/ms_tmp/'
    IMAGEURL  '/ms_tmp/'
    METADATA
      "wms_title"   "MY WMS Server"
       "wms_onlineresource"
"http://myserver/cgi-bin/mapserv.exe?MAP=p:/ms4w/apps/tutorial/htdocs/wms.map"
#     "wms_onlineresource" "http://myserver/cgi-bin/mapserv.exe?"
      "wms_srs"   "EPSG:27700"
      "wms_server_version" "1.1.1"
      "wms_feature_info_mime_type" "text/html"
      "wms_abstract"      "This server was setup by me and is powered by
MapServer. "
    END
  END # Every object in MapServer must have an END.;)

#  PROJECTION
#    "init=epsg:27700"
#  END # This is the ending of the output projection


  #
  # Start of legend
  #
  LEGEND
    KEYSIZE 12 12
    LABEL
      TYPE BITMAP
      SIZE MEDIUM
      COLOR 0 0 89
    END
    STATUS ON
  END
  

  # The reference object is used to define a reference map for your mapping 
  # application.  This typically involves defining a small image that covers 
  # the entire area of the map and defining a box that represents the
current  
  # view on in relation to the entire area.
  REFERENCE
    IMAGE '../images/ugl_ref1.png' # The reference image
    SIZE 155 105 # The size of the reference image in pixels

##    EXTENT 201621.496941 -294488.285333 1425518.020722 498254.511514 # The
extent of the reference image in map units
#    EXTENT     330000.000000 720000.000000 340000.000000 730000.000000
EXTENT 329999.683 725000.328 339999.672 740000.318
    STATUS ON
    MINBOXSIZE 10 # How small can the reference box be before it gets drawn
as a point, in pixels
    MAXBOXSIZE 150 # The maximum size of the reference box, in pixels
    COLOR -1 -1 -1 # The reference box fill color, negative numbers mean
transparent
    OUTLINECOLOR 128 0 0 # The reference box outline color 
    MARKERSIZE 8 # The size of the point marker
    MARKER 'star' # The marker symbol
  END
  
  # A scalebar object is defined one level below the map object.  This
object 
  # controls how a scalebar is drawn by MapServer.  Scalebars can be
embedded 
  # in the map itself or can be created as a separate image.  It has an 
  # associated MapServer CGI variable called "scalebar" (or [scalebar] when 
  # used in the HTML template).
SCALEBAR
INTERVALS 4
UNITS meters
STYLE 0
STATUS off
  LABEL
    SIZE large
    COLOR 0 0 0
  END
END

  #
  # A querymap object is used to highlight, or make prominent, the features
on a
  # map selected via a query or nquery request.   This means you can display
  # your query results and a map showing the features selected for the
query.
  QUERYMAP
    SIZE 200 150
    STATUS ON
    STYLE HILITE  # SELECTED | NORMAL
    COLOR 255 0 0
  END

  # Layer objects are defined beneath the map object.  You need at least one
  # layer defined in your map file before you can display a map...  You can
  # define as many layers as you'd like although a limit is typically
hard-coded
  # in map.h in the MapServer source.  The default limit is set at 100. 
You'd
  # have to have a very specialized application to need more than 100 layers
in
  # your application.

  # Start of LAYER DEFINITIONS ---------------------------------------------

  LAYER
    NAME tenk
    PROJECTION
      "init=epsg:27700"
    END

    TYPE RASTER
    STATUS ON
    TILEINDEX "p:\maps\10k\tay10.shp"
    TILEITEM "Location"

   MINSCALEDENOM 2000
   MAXSCALEDENOM 10000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"tenk"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "tenk" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED

    END
    END


  LAYER
    NAME twentyfivek
    PROJECTION
      "init=epsg:27700"
    END

    TYPE RASTER
    STATUS ON
    TILEINDEX "p:\maps\25k\tay25.shp"
    TILEITEM "Location"

   MINSCALEDENOM 10000
   MAXSCALEDENOM 25000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"twentyfivek"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "twentyfivek" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED

    END
    END

  LAYER
    NAME fiftyk
    PROJECTION
      "init=epsg:27700"
    END

    TYPE RASTER
    STATUS ON
    TILEINDEX "p:\maps\50k\tay50.shp"
    TILEITEM "Location"

   MINSCALEDENOM 25000
   MAXSCALEDENOM 50000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"fiftyk"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "fiftyk" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED

    END
    END

  LAYER
    NAME twofiftyk
    PROJECTION
      "init=epsg:27700"
    END

    TYPE RASTER
    STATUS ON
    TILEINDEX "p:\maps\250k\tay250.shp"
    TILEITEM "Location"

   MINSCALEDENOM 50000
   MAXSCALEDENOM 10000000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"twofiftyk"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "twofiftyk" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED

    END
    END

  LAYER # DDArea polygon layer begins here
    NAME         "topographicarea"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"
#    DATA         "the_geom from ddarea USING UNIQUE gid USING SRID=27700"
    DATA         "the_geom from topographicarea USING UNIQUE oid USING
SRID=27700"
#    MINSCALE     100000
    STATUS       ON
    TYPE         POLYGON

#    MINSCALEDENOM 50000
    MAXSCALEDENOM 2000
  PROJECTION
    "init=epsg:27700"
  END # This is the ending of the output projection

HEADER    '../templates/ddarea_header.html'
FOOTER    '../templates/ddarea_footer.html'

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"topographicarea"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wms_bgcolor"		"0xf0f0f0"
	"wfs_title"             "topographicarea" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    # The class object is defined within the layer object.  You can define
as
    # many classes as you need (well, there are limits as with layers, but
it's
    # senseless to define more than ten on a "normal" layer.  There are
    # situations, however, where you might have to do it.)

#   CLASSITEM "CLASS"

    CLASS
      TEMPLATE '../templates/ddarea_query.html'
NAME "Land"
      EXPRESSION ('[theme]' eq 'Land')
	STYLE
	 COLOR	200 255 200
	OUTLINECOLOR 32 32 32
	END
    END
    CLASS
      TEMPLATE '../templates/ddarea_query.html'
NAME "Buildings"
      EXPRESSION ('[theme]' eq 'Buildings')
	STYLE
	 COLOR	220 220 180
	OUTLINECOLOR 32 32 32
	END
    END
    CLASS
      TEMPLATE '../templates/ddarea_query.html'
NAME "Roads Tracks And Paths"
      EXPRESSION ('[theme]' eq 'Roads Tracks And Paths')
	STYLE
	 COLOR	200 200 240
	OUTLINECOLOR 32 32 32
	END
   END

    CLASS
      TEMPLATE '../templates/ddarea_query.html'
NAME "Water"
      EXPRESSION ('[theme]' eq 'Water')
	STYLE
#	 COLOR	200 200 255
	 COLOR	200 240 240
	OUTLINECOLOR 32 32 32
	END
    END

    CLASS
      TEMPLATE '../templates/ddarea_query.html'
NAME "Rail"
      EXPRESSION ('[theme]' eq 'Rail')
	STYLE
	 COLOR	180 180 140
	OUTLINECOLOR 32 32 32
	END
    END
    CLASS
      TEMPLATE '../templates/ddarea_query.html'
NAME "Structures"
      EXPRESSION ('[theme]' eq 'Structures')
	STYLE
#	 COLOR	200 240 240

#COLOR	180 180 140
#COLOR	220 220 180
COLOR	200 200 160

	OUTLINECOLOR 32 32 32


	END
    END
    CLASS
      TEMPLATE '../templates/ddarea_query.html'
	NAME       "DD Area"
      STYLE
        COLOR        232 232 232
        OUTLINECOLOR 32 32 32
      END
    END

  END # DDArea polygon layer ends here




LAYER # GAZ layer begins here

    NAME         "gazeteer"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

#    DATA "the_geom from (select g.gid, g.the_geom, g.UPRN, g.purn,
p.pdc_desc, p.address, p.location, p.system_code, d.band, d.band_date,
s.total_nav from ((gaz AS g LEFT JOIN domestic AS d on g.purn = d.purn) LEFT
JOIN shop AS s on g.purn = s.purn) LEFT JOIN property AS p on g.purn =
p.purn ORDER BY p.location) as subquery USING unique gid using srid=27700"
    DATA "the_geom from (select g.gid, g.the_geom, g.UPRN, g.purn,
p.pdc_desc, p.address, p.location, p.system_code from (gaz AS g LEFT JOIN
property AS p on g.purn = p.purn) ORDER BY p.location) as subquery USING
unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

    HEADER    '../templates/join_header.html'
    FOOTER    '../templates/join_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"gazeteer"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "gazeteer" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

   CLASS
     TEMPLATE '../templates/join_query.html'
        EXPRESSION ('[purn]' != '')
        STYLE
           SYMBOL "circle"
           COLOR        255 255 255
 	SIZE 3
        END
    END

   CLASS
NAME "GAZ NOT matched"
     TEMPLATE '../templates/join_query.html'
        EXPRESSION ('[purn]' eq '')
        STYLE
           SYMBOL "triangle"
           COLOR        255 0 0
           OUTLINECOLOR 255 255 0
 	   SIZE 20
        END
    END

END # GAZ Point layer ends here






LAYER # property layer begins here
    NAME         "property"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    DATA "the_geom from (select g.gid, g.the_geom, p.purn, p.system_code
from (gaz AS g INNER JOIN property AS p on g.purn = p.purn)) as subquery
USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

    SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"property"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "property" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
      NAME "Shop"
      EXPRESSION ('[system_code]' eq 'Shop')
       STYLE
            SYMBOL "circle"
            COLOR 0 0 255
            SIZE 10
       END
    END

    CLASS
      NAME "Office"
      EXPRESSION ('[system_code]' eq 'Office')
       STYLE
            SYMBOL "circle"
            COLOR 255 255 0
            SIZE 10
       END
    END

    CLASS
      NAME "Industrial"
      EXPRESSION ('[system_code]' eq 'Industrial')
       STYLE
            SYMBOL "circle"
            COLOR 0 255 0
            SIZE 10
       END
    END

    CLASS
      NAME "Part4"
      EXPRESSION ('[system_code]' eq 'Part4')
       STYLE
            SYMBOL "circle"
            COLOR 0 255 255
            SIZE 10
       END
    END

    CLASS
      NAME "Public House"
      EXPRESSION ('[system_code]' eq 'Public House')
       STYLE
            SYMBOL "circle"
            COLOR 128 0 255
            SIZE 10
       END
    END

    CLASS
      NAME "Hotel"
      EXPRESSION ('[system_code]' eq 'Hotel')
       STYLE
            SYMBOL "circle"
            COLOR 255 0 255
            SIZE 10
       END
    END

    CLASS
      NAME "Contractors"
      EXPRESSION ('[system_code]' eq 'Contractors')
       STYLE
            SYMBOL "circle"
            COLOR 128 128 128
            SIZE 10
       END
    END

    CLASS
      NAME "Genval"
      EXPRESSION ('[system_code]' eq 'Genval')
       STYLE
            SYMBOL "circle"
            COLOR 255 126 1
            SIZE 10
       END
    END

END # property layer ends here










LAYER # shop layer begins here
    NAME         "shop"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

    DATA "the_geom from (select g.gid, g.the_geom, s.purn, s.floor_area,
s.floor_red_area, s.floor_eff_area, s.floor_nav ,s.total_nav from (gaz AS g
INNER JOIN shop AS s on g.purn = s.purn)) as subquery USING unique gid using
srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/shop_header.html'
FOOTER    '../templates/shop_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"shop"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "shop" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Shop"
     TEMPLATE '../templates/shop_query.html'
       STYLE
#            SYMBOL "circle"
#            COLOR 0 0 255
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # Shop Point layer ends here


LAYER # office layer begins here
    NAME         "office"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

#      DATA         "the_geom from office USING UNIQUE gid USING SRID=27700"

DATA "the_geom from (select g.gid, g.the_geom, o.purn, o.floor_area,
o.floor_eff_area, o.total_nav from (gaz AS g INNER JOIN office AS o on
g.purn = o.purn)) as subquery USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/office_header.html'
FOOTER    '../templates/office_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"office"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "office" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Office"
     TEMPLATE '../templates/office_query.html'
       STYLE
#            SYMBOL "circle"
#            COLOR 255 255 0
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # Office Point layer ends here




LAYER # industrial layer begins here
    NAME         "industrial"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

#      DATA         "the_geom from industrial USING UNIQUE gid USING
SRID=27700"

DATA "the_geom from (select g.gid, g.the_geom, i.purn, i.total_area,
i.final_nav from (gaz AS g INNER JOIN industrial AS i on g.purn = i.purn))
as subquery USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/industrial_header.html'
FOOTER    '../templates/industrial_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"industrial"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "industrial" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Industrial"
     TEMPLATE '../templates/industrial_query.html'
       STYLE
#            SYMBOL "circle"
#            COLOR 0 255 0
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # industrial Point layer ends here



LAYER # part4 layer begins here
    NAME         "part4"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

DATA "the_geom from (select g.gid, g.the_geom, p.purn, p.total_area,
p.final_nav from (gaz AS g INNER JOIN part4 AS p on g.purn = p.purn)) as
subquery USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/part4_header.html'
FOOTER    '../templates/part4_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"part4"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "part4" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Part4"
     TEMPLATE '../templates/part4_query.html'
       STYLE
#            SYMBOL "circle"
#            COLOR 0 255 255
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # part4 Point layer ends here



LAYER # publichouse layer begins here
    NAME         "publichouse"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

DATA "the_geom from (select g.gid, g.the_geom, p.purn, p.nonresr, p.resr,
p.finalval from (gaz AS g INNER JOIN publichouse AS p on g.purn = p.purn))
as subquery USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/publichouse_header.html'
FOOTER    '../templates/publichouse_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"publichouse"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "publichouse" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Public House"
     TEMPLATE '../templates/publichouse_query.html'
       STYLE
#            SYMBOL "circle"
##            COLOR 0 0 255
#            COLOR 128 0 255
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # publichouse Point layer ends here




LAYER # hotel layer begins here
    NAME         "hotel"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

DATA "the_geom from (select g.gid, g.the_geom, h.purn, h.nonresr, h.resr,
h.finalval from (gaz AS g INNER JOIN hotel AS h on g.purn = h.purn)) as
subquery USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/hotel_header.html'
FOOTER    '../templates/hotel_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"hotel"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "hotel" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Hotel"
     TEMPLATE '../templates/hotel_query.html'
       STYLE
#            SYMBOL "circle"
#            COLOR 255 0 255
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # publichouse Point layer ends here



LAYER # genval layer begins here
    NAME         "genval"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

#    DATA         "the_geom from genval USING UNIQUE gid USING SRID=27700"

DATA "the_geom from (select g.gid, g.the_geom, gv.purn, gv.gv_type,
gv.sit_address_1, gv.buildings_nav, gv.total_adjustment_b, gv.total_ea_val,
gv.total_adjustment_a, gv.end_allowance2, gv.rounded_nav,
gv.calculated_rounded_nav from (gaz AS g INNER JOIN genval AS gv on g.purn =
gv.purn)) as subquery USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/genval_header.html'
FOOTER    '../templates/genval_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"genval"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "genval" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Genval"
     TEMPLATE '../templates/genval_query.html'
       STYLE
#            SYMBOL "circle"
#            COLOR 255 126 1
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # Genval Point layer ends here



LAYER # CBV layer begins here
    NAME         "cbv"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"

#    DATA         "the_geom from cbv USING UNIQUE gid USING SRID=27700"

DATA "the_geom from (select g.gid, g.the_geom, c.purn, c.sit_1,
c.adopted_buildings_arc, c.site_works_arc, c.adjusted_site_value,
c.total_ecv, c.nav, c.ancillary_value, c.redundancy_total,
c.end_allowance_total, c.total_nav, c.rounded_nav from (gaz AS g INNER JOIN
cbv AS c on g.purn = c.purn)) as subquery USING unique gid using srid=27700"

    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/cbv_header.html'
FOOTER    '../templates/cbv_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"genval"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "cbv" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
#NAME "Genval"
     TEMPLATE '../templates/cbv_query.html'
       STYLE
#            SYMBOL "circle"
#            COLOR 255 126 1
##            OUTLINECOLOR 0 0 0
#            SIZE 10
       END
    END

END # CBV Point layer ends here




LAYER # domestic layer begins here
    NAME         "domestic"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"
#      DATA         "the_geom from domestic USING UNIQUE gid USING
SRID=27700"

DATA "the_geom from (select g.gid, g.the_geom, d.purn, d.band, d.band_date
from (gaz AS g INNER JOIN domestic AS d on g.purn = d.purn)) as subquery
USING unique gid using srid=27700"
    STATUS       ON
    TYPE         POINT
    MAXSCALEDENOM 2000

    TOLERANCE 10

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/domestic_header.html'
FOOTER    '../templates/domestic_footer.html'

SYMBOLSCALE 1000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"domestic"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "domestic" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND A"
      EXPRESSION ('[band]' eq 'A')
       STYLE
	    SYMBOL "star"
#	    SYMBOL "bandA"
            COLOR 255 0 0
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND B"
      EXPRESSION ('[band]' eq 'B')
       STYLE
            SYMBOL "star"
#	    SYMBOL "bandB"
            COLOR 255 255 0
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND C"
      EXPRESSION ('[band]' eq 'C')
       STYLE
            SYMBOL "star"
#	    SYMBOL "bandC"
            COLOR 0 255 0
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND D"
      EXPRESSION ('[band]' eq 'D')
       STYLE
            SYMBOL "star"
#	    SYMBOL "bandD"
            COLOR 0 255 255
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND E"
      EXPRESSION ('[band]' eq 'E')
       STYLE
            SYMBOL "star"
#	    SYMBOL "bandE"
            COLOR 0 0 255
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND F"
      EXPRESSION ('[band]' eq 'F')
       STYLE
            SYMBOL "star"
#	    SYMBOL "bandF"
            COLOR 255 0 255
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND G"
      EXPRESSION ('[band]' eq 'G')
       STYLE
            SYMBOL "star"
#	    SYMBOL "bandG"
            COLOR 128 128 128
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

    CLASS
     TEMPLATE '../templates/domestic_query.html'
NAME "BAND H"
      EXPRESSION ('[band]' eq 'H')
       STYLE
            SYMBOL "star"
#	    SYMBOL "bandH"
            COLOR 255 126 1
#            OUTLINECOLOR 0 0 0
            SIZE 6
       END
    END

END # domestic Point layer ends here





#  LAYER # DDAnno line layer begins here
#    NAME         "ddanno"
#    CONNECTIONTYPE postgis
#    CONNECTION "dbname=database user=admin password=password"
#    PROCESSING "CLOSE_CONNECTION=DEFER"
#    DATA         "the_geom from ddanno USING UNIQUE gid USING SRID=27700"
#    STATUS       ON
#    TYPE         LINE
#
#    MAXSCALEDENOM 2000
#
#    PROJECTION
#      "init=epsg:27700"
#    END # This is the ending of the output projection
#
#    LABELITEM "text"
#
#    METADATA
#	"wms_srs"		"EPSG:27700"
#	"wms_name"		"ddanno"
#	"wms_server_version"	"1.1.1"
#	"wms_format"		"image/gif"
#	"wfs_title"             "ddanno" ##REQUIRED
#	"wfs_srs"               "EPSG:27700" ## REQUIRED
#	"gml_include_items"     "all" ## Optional (serves all attributes for
layer)
#	"gml_featureid"         "ID" ## REQUIRED
#    END
#
#    CLASS
#      EXPRESSION ('[theme]' eq 'Terrain And Height' OR '[theme]' eq
'Structures' OR '[theme]' eq 'Rail' OR '[theme]' eq 'Administrative
Boundaries'  OR '[theme]' eq 'Land' OR '[theme]' eq 'Water')
#	STYLE
## no color makes this invisible!!!
#	END
#    END
#
#    CLASS
#
#       LABEL
#          COLOR 0 0 0
#          TYPE TRUETYPE
#          FONT "arial"
#          SIZE 10
#          POSITION CC
##          ANGLE[textangle]
#       END # end of label
#
#    END
#
# END # end of layer object

  LAYER # cartographictext line layer begins here
    NAME         "cartographictext"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"
#    DATA         "the_geom from cartographictext USING UNIQUE gid USING
SRID=27700"
    DATA         "the_geom from cartographictext USING UNIQUE oid USING
SRID=27700"
    STATUS       ON
#    TYPE         POINT
    TYPE         ANNOTATION

    MAXSCALEDENOM 2000

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection


    LABELITEM textstring

SYMBOLSCALE 5000

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"cartographictext"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "cartographictext" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
      EXPRESSION ('[theme]' eq 'Terrain And Height' OR '[theme]' eq
'Structures' OR '[theme]' eq 'Rail' OR '[theme]' eq 'Land' OR '[theme]' eq
'Water')
	STYLE
# invisible!!!
	END
    END













CLASS
	EXPRESSION ([anchorposition] eq 0)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION ur
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 1)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION cr
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 2)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION lr
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 3)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION uc
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 4)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION cc
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 5)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION lc
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 6)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION ul
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 7)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION cl
			ANGLE [angle]
		END
END
CLASS
	EXPRESSION ([anchorposition] eq 8)
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			FONT [font]
			SIZE [height]
			POSITION ll
			ANGLE [angle]
		END
END


 END # end of layer object


  LAYER # district_borough_unitary_ward_region layer begins here
    NAME         "boundary"
    CONNECTIONTYPE postgis
    CONNECTION "dbname=database user=admin password=password"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    DATA "the_geom from district_borough_unitary_ward_region USING UNIQUE
gid USINGSRID=27700"
    STATUS       ON
#    TYPE         LINE
    TYPE         POLYGON

#    MINSCALEDENOM 2000
    MAXSCALEDENOM 100000

    PROJECTION
      "init=epsg:27700"
    END # This is the ending of the output projection

HEADER    '../templates/dbuwr_header.html'
FOOTER    '../templates/dbuwr_footer.html'

    OPACITY 100

    METADATA
	"wms_srs"		"EPSG:27700"
	"wms_name"		"boundary"
	"wms_server_version"	"1.1.1"
	"wms_format"		"image/gif"
	"wfs_title"             "boundary" ##REQUIRED
	"wfs_srs"               "EPSG:27700" ## REQUIRED
	"gml_include_items"     "all" ## Optional (serves all attributes for layer)
	"gml_featureid"         "ID" ## REQUIRED
    END

    CLASS
TEMPLATE '../templates/dbuwr_query.html'
	NAME "Wards"
	STYLE
	        #COLOR 255 255 255
        	OUTLINECOLOR 0 0 0
		WIDTH 3
		#ANTIALIAS TRUE
	END
    END


  END

# End of LAYER DEFINITIONS -------------------------------

END # All map files must come to an end just as all other things must come
to...



--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Fwd-Re-Fwd-Re-Mapbender-dev-Printing-High-Quality-288dpi-Blank-PDF-tp6520557p6524009.html
Sent from the mapbender-dev mailing list archive at Nabble.com.


More information about the Mapbender_dev mailing list