MAP
  FONTSET "../symbols/fontes.txt"
  SYMBOLSET "../symbols/simbolosv6.sym"
  LAYER
    CONNECTION "password=postgres user=postgres dbname=i3geosaude host=localhost port=5432"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from (select nome,gid,the_geom from i3geo_metaestat.testepontos) as foo using unique gid using srid=4326"
    METADATA
      "METAESTAT_ID_MEDIDA_VARIAVEL"	""
      "cache"	""
      "CLASSE"	"SIM"
      "EDITAVEL"	"SIM"
      "METAESTAT_CODIGO_TIPO_REGIAO"	""
      "metaestat"	""
      "ESQUEMATABELAEDITAVEL"	"i3geo_metaestat"
      "convcaracter"	""
      "TEMA"	"Teste de pontos"
      "COLUNAGEOMETRIA"	"the_geom"
      "COLUNAIDUNICO"	"gid"
      "TABELAEDITAVEL"	"testepontos"
    END # METADATA
    NAME "testepontos"
    STATUS OFF
    TEMPLATE "none.htm"
    TILEITEM "location"
    TYPE POINT
    UNITS METERS
    CLASS
      NAME ""
      STYLE
        COLOR 0 0 0
        SIZE 12
        SYMBOL "p0"
      END # STYLE
    END # CLASS
  END # LAYER

END # MAP