view flys-artifacts/doc/mapserver/saar-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 63db3b08f328
children
line wrap: on
line source
MAP
    NAME "Saar"
    STATUS ON
    SIZE 600 400
    MAXSIZE 4000
    EXTENT 2539488.036000 5450928.892000 2575486.407000 5507352.839000
    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-saar-wms.log"
    DEBUG 0

    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 2520667.897954 5376316.575645 2634771.191263 5508288.005707
        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=1'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "catchment"
            STYLE
                COLOR "#000080"
                OUTLINECOLOR "#000000"
            END
        END
    END
    LAYER
        NAME km 
	GROUP km
	EXTENT 2539489.068000 5450953.000500 2575482.527500 5507278.634500
        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=1'

        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 2539489.068000 5450953.000500 2575482.527500 5507278.634500
        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=1'
  	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 2540544.253718 5456266.217464 2567747.834199 5502557.982120
        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=1'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "buildings"
            STYLE
        	COLOR "#ff2222"
            END
        END
    END
    LAYER
        NAME fixpoints 
        EXTENT 2539388.036000 5450896.688000 2575586.296000 5507370.606000
        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=1'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "fixpoints"
  	    STYLE
             COLOR "#ffff00"
  	     SYMBOL 'square'
  	     SIZE 6
  	   END
        END
    END
    LAYER
        NAME riveraxes
        EXTENT 2539488.036000 5450928.892000 2575486.407000 5507352.839000
        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=1'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "riveraxes"
            STYLE
       		 COLOR "#0000ff"
            END
        END
    END
    
    LAYER
        NAME qps
        EXTENT 2539289.724000 5450852.896743 2576589.878311 5507289.656000
        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=1'

        PROJECTION
            "init=epsg:31466"
        END

	MAXSCALEDENOM 100000

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

    LAYER
        NAME hws 
	EXTENT 2539778.101933 5456638.161347 2567463.841704 5500605.745332
        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=1'

        PROJECTION
            "init=epsg:31466"
        END

        CLASS
            NAME "hws"
            STYLE
        	COLOR "#ff2222" 
            END
        END
    END
    LAYER
        NAME floodplain 
        EXTENT 2539343.776823 5451397.340027 2576021.009478 5507230.640000
        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=1'

        PROJECTION
            "init=epsg:31466"
        END

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

http://dive4elements.wald.intevation.org