MAP
  FONTSET "../symbols/fontes.txt"
  SYMBOLSET "../symbols/simbolosv6.sym"
  LAYER
    CONNECTION "user=postgres password=postgres dbname=i3geosaude host=localhost port=5432 "
      CONNECTIONTYPE POSTGIS
   DATA "geom from (select * from pocos) as foo using unique id using srid=4326"
    METADATA
      "METAESTAT_ID_MEDIDA_VARIAVEL"    ""
      "tip"    "id,obs,ne"    
      "itensdesc"    "COD,OBS,NE"
      "EDITAVEL"    "SIM"
      "escala"    "10000"
      "METAESTAT_CODIGO_TIPO_REGIAO"    ""
      "extensao"    "-49.096526863281156 -25.057909302411357 -46.89514136523428 -23.995963132049212"
       "ESQUEMATABELAEDITAVEL"    "public"
      "download"    "NAO"
       "TEMA"    "Poços cadastrados"
      "COLUNAGEOMETRIA"    "geom"
      "COLUNAIDUNICO"    "id"
      "TABELAEDITAVEL"    "pocos"
      "ltempoitemfim"    ""
    END # METADATA
    NAME "pocos"
    PROCESSING "LABEL_NO_CLIP=True"
    PROCESSING "POLYLINE_NO_CLIP=True"
    STATUS OFF
    TEMPLATE "none.htm"
    TILEITEM "location"
    TYPE POINT
    UNITS METERS
    CLASS
      NAME "Poços cadastrados"
      STYLE
        COLOR 0 0 0
        OUTLINECOLOR 0 0 0
        SIZE 10
        SYMBOL "ponto"
      END # STYLE
    END # CLASS
  END # LAYER
END # MAP