view flys-artifacts/doc/mapserver/mosel-mapfile.map @ 5200:42bb6ff78d1b 2.9.11

Directly set the connectionInitSqls on the datasource Somehow the factory fails to set the connectionInitSqls if we add it to the dbcpProperties. So we now set it directly
author Andre Heinecke <aheinecke@intevation.de>
date Fri, 08 Mar 2013 11:48:33 +0100
parents 2aa727cefb0c
children
line wrap: on
line source
MAP
    NAME "Mosel"
    STATUS ON
    SIZE 600 400
    MAXSIZE 4000
    EXTENT 2457864.326387 5297459.306295 2634771.191263 5586961.449130
    UNITS DD
    FONTSET "fontset.txt"
    SYMBOLSET './symbols/symbols.sym'
    IMAGECOLOR 255 255 255
    PROJECTION
        "init=epsg:31466"
    END


    OUTPUTFORMAT
        NAME agg
        DRIVER AGG/PNG
        IMAGEMODE RGB
    END

    CONFIG "MS_ERRORFILE" "logs/flys-mosel-wms.log"
    DEBUG 5

    WEB
      METADATA
        "wms_title"             "FLYS-3.0 WMS (SAAR)"
        "wms_onlineresource"    "http://czech-republic.atlas.intevation.de/cgi-bin/saar-wms"
        "wms_accessconstraints" "none"
        "wms_fees"              "none"
        "wms_addresstype"       "postal"
        "wms_address"           "Any Street"
        "wms_city"              "Any City"
        "wms_stateorprovince"   "Any state"
        "wms_postcode"          "My Postalcode"
        "wms_country"           "Any Country"
        "wms_contactperson"     "Any Person"
        "wms_contactorganization" "Any Orga"
        "wms_contactelectronicmailaddress" "any-email@example.com"
        "wms_contactvoicetelephone" "Any's telephone number"
        "wms_srs" "EPSG:31466 EPSG:4326"
        "wms_feature_info_mime_type" "text/html"
        "ows_enable_request"   "*"
      END
    END

    LAYER
        NAME catchment 
	EXTENT 2457864.326387 5297459.306295 2634771.191263 5586961.449130
        DEBUG 0
  
        METADATA
            "wms_title" "catchment"
        END

        TYPE POLYGON
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM catchment USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "catchment"
            STYLE
                COLOR "#000080"
                OUTLINECOLOR "#000000"
            END
        END
    END
    LAYER
        NAME km 
	GROUP km
	EXTENT 2525910.000000 5481666.000000 2614362.250000 5582403.000000
        DEBUG 0
	DUMP TRUE
  
        METADATA
            "wms_title" "km"
        END

        TYPE POINT 
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM river_axes_km USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "km"
  	    STYLE
             COLOR "#ff0000"
  	     SYMBOL 'square'
  	     SIZE 5
  	   END
        END
    END

    LAYER
	NAME km_annotation 
	GROUP km
	EXTENT 2525910.000000 5481666.000000 2614362.250000 5582403.000000
        DEBUG 5
	DUMP TRUE
  
        METADATA
            "wms_title" "km_annotation"
        END
  	
	TYPE ANNOTATION 
  	STATUS ON 
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM river_axes_km USING SRID 31466"
        FILTER 'river_id=2'
  	LABELITEM km

        MAXSCALE 25000 

  	CLASS 
  	  LABEL 
  	    ANGLE auto 
  	    SIZE 10
  	    COLOR "#000000" 
  	    TYPE truetype 
  	    FONT LiberationSans-Italic 
	    POSITION ur
	    OFFSET 2 2
  	  END
  	END 
    END

    LAYER
        NAME buildings 
	Extent 2526389.654387 5492305.031511 2612653.500000 5582427.500000
        DEBUG 0
  
        METADATA
            "wms_title" "buildings (Bauwerke/Wehre)"
        END

        TYPE LINE
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM buildings USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "buildings"
            STYLE
        	COLOR "#ff2222"
            END
        END
    END
    LAYER
        NAME fixpoints 
	EXTENT 2525789.640000 5481448.110000 2614324.201153 5582705.474713
        DEBUG 0
  
        METADATA
            "wms_title" "fixpoints (Geodaesie/Festpunkte)"
        END

        TYPE POINT 
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM fixpoints USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "fixpoints"
  	    STYLE
             COLOR "#ffff00"
  	     SYMBOL 'square'
  	     SIZE 6
  	   END
        END
    END
    LAYER
        NAME riveraxis
	EXTENT 2525866.883066 5480800.000000 2614283.382914 5582578.641600
        DEBUG 0
  
        METADATA
            "wms_title" "River Axes"
        END

        TYPE LINE
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM river_axes USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "riveraxes"
            STYLE
       		 COLOR "#0000ff"
            END
        END
    END
    
    LAYER
        NAME qps
	EXTENT 2525526.058176 5481412.836939 2614739.057487 5582746.998120
        DEBUG 0
  
        METADATA
            "wms_title" "QPS (CrossSectionTracks)"
        END

        TYPE LINE
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM cross_section_tracks USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

	MAXSCALEDENOM 100000

        CLASS
            NAME "qps"
            STYLE
        	COLOR "#0000ff"
            END
        END
    END

    LAYER
        NAME hws 
	EXTENT 2531846.270698 5501745.060309 2580199.261246 5535383.855597
        DEBUG 0
  
        METADATA
            "wms_title" "HWS"
        END

        TYPE LINE
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM hws USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "hws"
            STYLE
        	COLOR "#ff2222" 
            END
        END
    END
    LAYER
        NAME floodplain 
        EXTENT 2583046.060000 5556912.223213 2614325.275661 5582743.883699
        DEBUG 0
  
        METADATA
            "wms_title" "floodplain (Hydr. Grenzen/Talaue)"
        END

        TYPE POLYGON
        STATUS ON
        INCLUDE "oracle_dbconnection.include"
	DATA "GEOM FROM floodplain USING SRID 31466"
        FILTER 'river_id=2'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "floodplain"
            STYLE
                COLOR "#800080"
		OUTLINECOLOR "#000080"
            END
        END
    END
END

http://dive4elements.wald.intevation.org