# 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
  NAME "MapSiagas"
  IMAGECOLOR 255 255 255
  IMAGETYPE png
  FONTSET   "fontset.txt"
  SYMBOLSET "Symbols.txt"
  
  WEB
    IMAGEPATH "../tmp/"
    IMAGEURL "../tmp/"
  END

   EXTENT -50.1701903173785 -16.2497925668022 -47.3133616035064 -13.5468463986688
  UNITS dd

  SIZE 200 500
  RESOLUTION 96
  IMAGETYPE png
  INTERLACE OFF
  CONFIG "PROJ_LIB" "C:/proj/nad/"
  PROJECTION
    "+proj=longlat +datum=WGS84"
  END  


  #
  # Image formates for GD
  #
  OUTPUTFORMAT
    NAME "png"
    DRIVER "GD/PNG"
    MIMETYPE "image/png"
    IMAGEMODE RGB
    FORMATOPTION  INTERLACE=OFF
    TRANSPARENT OFF
    EXTENSION "png"
  END

  OUTPUTFORMAT
    NAME "png8"
    DRIVER "GD/PNG"
    MIMETYPE "image/png"
    IMAGEMODE PC256
    FORMATOPTION  INTERLACE=OFF
    TRANSPARENT OFF
    EXTENSION "png"
  END

  OUTPUTFORMAT
    NAME "jpeg"
    DRIVER "GD/JPEG"
    MIMETYPE "image/jpeg"
    IMAGEMODE RGB
    FORMATOPTION "QUALITY=70"
    EXTENSION "jpg"
  END

  #
  # Image formates for AGG
  #
  OUTPUTFORMAT
    # 24 bit PNG
    NAME 'agg_png'
    DRIVER AGG/PNG
    IMAGEMODE RGB
  END

  OUTPUTFORMAT
    # 32 bit PNG with alpha channel from transparency
    NAME 'agg_pnga'
    DRIVER AGG/PNG
    IMAGEMODE RGBA
  END

  OUTPUTFORMAT
    # 8 bit PNG
    NAME 'agg_png8'  
    DRIVER AGG/PNG
    IMAGEMODE RGB
    FORMATOPTION "QUANTIZE_FORCE=ON"
    FORMATOPTION "QUANTIZE_DITHER=OFF"
    FORMATOPTION "QUANTIZE_COLORS=256"
  END

  OUTPUTFORMAT
    NAME 'agg_jpeg'
    DRIVER AGG/JPEG
    IMAGEMODE RGB
  END

  OUTPUTFORMAT
    NAME GTiff
    DRIVER "GDAL/GTiff"
    MIMETYPE "image/tiff"
    IMAGEMODE RGB
    #FORMATOPTION "TFW=YES"
    #FORMATOPTION "COMPRESS=PACKBITS"
    EXTENSION "tif"
  END

  OUTPUTFORMAT
    NAME imagemap
    MIMETYPE "text/html"
    FORMATOPTION SKIPENDTAG=OFF
    DRIVER imagemap
  END

  #
  # Start of Reference map definition
  #
  REFERENCE
     EXTENT -50.1701903173785 -16.2497925668022 -47.3133616035064 -13.5468463986688
    IMAGE "image/sub-bacia20.png"
    SIZE 191 175
    COLOR -1 -1 -1
    OUTLINECOLOR 255 0 0
  END  # Reference

  LEGEND
  END


  #================== START OF LAYER SECTION =====================#
  #
  # Start of Layer Brazil.shp
  #

  LAYER
    NAME 'brazil'
    PROJECTION
      "+proj=longlat +datum=WGS84"
    END
    STATUS DEFAULT
    TYPE Polygon
    TEMPLATE void
    INCLUDE 'MapDBConnection.txt'
    DATA 'the_geom FROM "sub-bacia20" USING UNIQUE gid using srid=4326'
    #FILTER "bacia = 'ATLANTICO LESTE'"
    CLASS
      OUTLINECOLOR 176 173 166
      
    END
    METADATA
      "DESCRIPTION" "Municípios"
      "RESULT_FIELDS" "code,admin_name,pop_admin, sqkm_admin"
      "RESULT_HEADERS" "UF,Nome,População, Área Km²"
      "LAYER_ENCODING" "UTF-8"
    END  # Metadata  	  
  END #brazil			
	LAYER
    NAME 'estados'
    PROJECTION
      "+proj=longlat +datum=WGS84"
    END
    STATUS DEFAULT
    TYPE Polygon
    TEMPLATE void
    INCLUDE 'MapDBConnection.txt'
    DATA 'the_geom FROM brazil USING UNIQUE gid'
    #FILTER "SUBSTR(admin_name,1,1) = 'A'"
    CLASS
	  Name 'Estados'
       STYLE
        OUTLINECOLOR 0 0 0
      END #end of style 
    END
    METADATA
      "DESCRIPTION" "Estados"
      "RESULT_FIELDS" "code,admin_name,pop_admin, sqkm_admin"
      "RESULT_HEADERS" "UF,Nome,População, Área Km²"
      "LAYER_ENCODING" "UTF-8"
    END  # Metadata  	  
  END #brazil	
  LAYER
    NAME 'municipios'
    PROJECTION
      "+proj=longlat +datum=WGS84"
    END
    STATUS DEFAULT
    TYPE Polygon
    TEMPLATE void
    INCLUDE 'MapDBConnection.txt'
    DATA 'the_geom from (select r.* from municipios r, "sub-bacia20" br WHERE ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
    #FILTER "SUBSTR(admin_name,1,1) = 'A'"
    CLASS
	  Name 'Municípios'
       STYLE
        OUTLINECOLOR 176 173 166
      END #end of style 
    END
    METADATA
      "DESCRIPTION" "Municípios"		
      "LAYER_ENCODING" "UTF-8"
    END  # Metadata  	  
  END #municipios
		
  LAYER
	NAME 'br_rdline'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
		DATA 'the_geom from (select r.* from br_rdline r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		#DATA "the_geom from br_rdline USING unique gid using srid=4326"
	#FILTER "SUBSTR(admin_name,1,1) = 'A'"
		  CLASS
			Name 'Rodovias'
			STYLE
			OUTLINECOLOR 176 0 0
      
		    END #end of style 
          END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Rodovias"
	  END  # Metadata  	
	 
	END #br_rdline
			
  LAYER
    NAME 'br_rivers_bg'
    PROJECTION
      "+proj=longlat +datum=WGS84"
    END
    STATUS DEFAULT
    TYPE LINE
    TEMPLATE void
    INCLUDE 'MapDBConnection.txt'
    DATA 'the_geom from (select r.* from br_rivers_bg r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
    CLASS
	  Name 'Rios'
       STYLE
        OUTLINECOLOR 125 166 194
      END #end of style 
    END
    METADATA
      "LAYER_ENCODING" "UTF-8"
      "DESCRIPTION" "Rios"
    END  # Metadata  	
  END #br_rivers_bg

  LAYER
    NAME 'station_spatial'
    PROJECTION
      "+proj=longlat +datum=WGS84"
    END
    STATUS DEFAULT
    TYPE POINT
    TEMPLATE void
    INCLUDE 'SiagasDBConnection.txt'
    DATA 'the_geom from (SELECT	gid,idt_ponto,str_uf_sureg,str_local_ponto,natureza_ponto,ne,nd ,vazao_estabilizacao ,station_spatial.the_geom,"BACIA_SUBBACIA"."STR_SUBBACIA" AS SUBBACIA,"BACIA_SUBBACIA"."STR_BACIA" as BACIA,"PONTO"."IDT_CODIGO_ANA" as ANA FROM station_spatial Left JOIN "PONTO" on station_spatial.idt_ponto = "PONTO"."IDT_PONTO" Left JOIN "BACIA_SUBBACIA" On "PONTO"."IDT_CODIGO_ANA" = "BACIA_SUBBACIA"."IDT_CODIGO_ANA") as subquery using unique gid using srid=4326' 
	FILTER "ANA = 20"
    CLASS
      Name 'poços'
      STYLE
        SYMBOL 'circle'
        COLOR 0 0 255
        OUTLINECOLOR 0 0 255
        SIZE 2
      END #end of style
    END #end of class
    METADATA
	"RESULT_FIELDS" "idt_ponto,str_uf_sureg,str_local_ponto,natureza_ponto, ne, nd , vazao_estabilizacao"
      "RESULT_HEADERS" "Numero do Ponto, UF, Localidade, Natureza, Ne (m) , Nd (m), Vazão Estabilização (m<sub>3</sub>/h)"
      "LAYER_ENCODING" "UTF-8"
      "DESCRIPTION" "Poços"
    END  # Metadata
  END #station_spatial
LAYER
	NAME 'Aldeia_Indig'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from Aldeia_Indig r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'

		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Aldeias"
	  "RESULT_FIELDS" "gid,md_longitu,md_latitud, estado, uf, nm_nome"
	  "RESULT_HEADERS" "ID,Longitude,Latitude, Estado, UF, Nome"
	  END  # Metadata  	
	 
	END #Aldeia_Indig
	
	
			LAYER
	NAME 'area_edif'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from area_edif r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		  CLASS
		  Name 'Áreas Edificadas'
		  STYLE
			SYMBOL 'circle'
			COLOR 0 0 255
			OUTLINECOLOR 125 166 194
			SIZE 2
		  END #end of style
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Áreas Edificadas"
	  END  # Metadata  	
	 
	END #area_edif
	
	
	
		LAYER
	NAME 'capital_estadual'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from capital_estadual r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'

	
		CLASS
		  Name 'Capitais'
		  STYLE
			SYMBOL 'circle'
			COLOR 128 0 0
			OUTLINECOLOR 125 166 194
			SIZE 2
		  END #end of style
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Capitais"
	  END  # Metadata  	
	 
	END #capital_estadual

	
	
	LAYER
	NAME 'cidade'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from cidade r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		  CLASS
		  Name 'Cidades'
		  STYLE
			SYMBOL 'circle'
			COLOR 0 128 0
			OUTLINECOLOR 125 166 194
			SIZE 2
		  END #end of style
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Cidades"
	  END  # Metadata  	
	 
	END #cidade
	
	

	LAYER
	NAME 'outras_localidade'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from outras_localidade r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		  CLASS
		  Name 'Outras Localidades'
		  STYLE
			SYMBOL 'circle'
			COLOR 255 128 0
			OUTLINECOLOR 125 166 194
			SIZE 2
		  END #end of style
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Outras Localidades"
	  END  # Metadata  	
	 
	END #outras_localidade
	
	
		LAYER
	NAME 'povoado'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from povoado r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		 CLASS
		  Name 'Povoados'
		  STYLE
			SYMBOL 'square'
			COLOR 128 64 0
			OUTLINECOLOR 125 166 194
			SIZE 2
		  END #end of style
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Povoados"
	  END  # Metadata  	
	 
	END #povoado
	
	
	
		LAYER
	NAME 'vila'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from vila r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		  CLASS
		  Name 'Vilas'
		  STYLE
			SYMBOL 'square'
			COLOR 255 0 0
			OUTLINECOLOR 125 166 194
			SIZE 2
		  END #end of style
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Vilas"
	  END  # Metadata  	
	 
	END #vila
	
	
		LAYER
	NAME 'drenagem_unifilar'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	#DATA 'the_geom from (select r.* from drenagem_unifilar r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
	DATA 'the_geom from drenagem_unifilar USING unique gid using srid=4326'
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Unifilar"
	  END  # Metadata  	
	 
	END #drenagem_unifilar
	
	
		LAYER
	NAME 'drenagem_bifilar'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	#DATA 'the_geom from (select r.* from drenagem_bifilar r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
	DATA 'the_geom from drenagem_bifilar USING unique gid using srid=4326'
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Bifilar"
	  END  # Metadata  	
	 
	END #drenagem_bifilar
	
	
	
	
	
		LAYER
	NAME 'arcos_altos'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from arcos_altos r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Arcos Altos"
	  END  # Metadata  	
	 
	END #arcos_altos
	
	
		LAYER
	NAME 'diques_gr'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from diques_gr r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Diques"
	  END  # Metadata  	
	 
	END #diques_gr
	
	
		LAYER
	NAME 'estruturas_selecionadas'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POINT
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA 'the_geom from (select r.* from estruturas_selecionadas r, "sub-bacia20" br where ST_Intersects(r.the_geom,br.the_geom)) as subquery USING unique gid using srid=4326'
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Estruturas Selecionadas"
	  END  # Metadata  	
	 
	END #estruturas_selecionadas
	
	
	
		LAYER
	NAME 'batimetria_final_geo'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA "the_geom from batimetria_final_geo USING unique gid using srid=4326"
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Batimetria"
	  END  # Metadata  	
	 
	END #batimetria_final_geo
	
	
	
	LAYER
	NAME 'campos_oleo'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POLYGON
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA "the_geom from campos_oleo USING unique gid using srid=4326"
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Campos de Oleo"
	  END  # Metadata  	
	 
	END #campos_oleo
	
	
	
	LAYER
	NAME 'estrutmc_shp'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA "the_geom from estrutmc_shp USING unique gid using srid=4326"
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Estruturas de Margem Continental"
	  END  # Metadata  	
	 
	END #estrutmc_shp
	
	
	LAYER
	NAME 'feicoes1_shp'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE POLYGON
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA "the_geom from feicoes1_shp USING unique gid using srid=4326"
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Feições 1"
	  END  # Metadata  	
	 
	END #feicoes1_shp
	
	LAYER
	NAME 'feicoes2_shp'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA "the_geom from feicoes2_shp USING unique gid using srid=4326"
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Feições 2"
	  END  # Metadata  	
	 
	END #feicoes2_shp
	
	
	
	LAYER
	NAME 'isopaca'
	 PROJECTION
      "+proj=longlat +datum=WGS84"
    END
	STATUS DEFAULT
	TYPE LINE
	
	TEMPLATE void
	INCLUDE 'MapDBConnection.txt'
	DATA "the_geom from isopaca USING unique gid using srid=4326"
		  CLASS
		  OUTLINECOLOR 125 166 194
		  COLOR 0 0 255
		  
		  END
	  METADATA
		"LAYER_ENCODING" "UTF-8"
		"DESCRIPTION" "Isopaca"
	  END  # Metadata  	
	 
	END #isopaca


END  #Map