<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<br>Rafael e Moretti,<div><br></div><div>OBRIGADO PELA AJUDA. FUNCIONOU AQUI.</div><div><br></div><div><br></div><div>Vejam que está tudo ok. Estou conseguindo conectar. Tinha outro problema. No Data "DATA "the_geom from (select * from Consumidores-Celg) as foo using unique gid using srid=4674" " substitui o the_geom por geom, que era o nome que estava no banco de dados.</div><div><br></div><div>Agora o meu problema é outro. Essa base de dados contem 163460 registros. É muito pesado para abrir. Queria ver, se é possível configurar um tipo de acesso em que ao aproximar o i3geo vai mostrando os registros. </div><div><br></div><div>Valeu e obrigado.</div><div> <br><div><br></div><div><form action="http://10.19.60.100/i3geo/testamapfile.php" method="post" id="f" style="color: rgb(47, 70, 50); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;">Nome do arquivo map existente no diretório i3geo/temas. Exemplo para uso manual da URL: testamapfile.php?map=biomashp (utilize "testamapfile.php?map=todos" na URL para testar todos de uma só vez)<br><br><br>Mostra apenas a legenda? <input type="radio" name="solegenda" value="sim" style="cursor: pointer;">sim <input type="radio" name="solegenda" value="nao" checked="" style="cursor: pointer;"> não<br><br><select id="nomemap"><option value="">Escolha o arquivo para testar</option><option value="acidmap">acidmap</option><option value="atlas_biomas">atlas_biomas</option><option value="atlas_ucse">atlas_ucse</option><option value="atlas_ucsef">atlas_ucsef</option><option value="atlas_ucsf">atlas_ucsf</option><option value="autolegenda_exemplo">autolegenda_exemplo</option><option value="bing">bing</option><option value="biomacon">biomacon</option><option value="biomaerro">biomaerro</option><option value="biomapg">biomapg</option><option value="biomashp">biomashp</option><option value="biomashpwms">biomashpwms</option><option value="cartobase">cartobase</option><option value="cbers">cbers</option><option value="cbersgeo">cbersgeo</option><option value="cbersi">cbersi</option><option value="cinzapalete">cinzapalete</option><option value="estadosl">estadosl</option><option value="geojs_ogr1">geojs_ogr1</option><option value="geonetworkindice">geonetworkindice</option><option value="geopr_ana_federais">geopr_ana_federais</option><option value="geopr_ana_microbacias">geopr_ana_microbacias</option><option value="geopr_ana_reghidro1">geopr_ana_reghidro1</option><option value="geopr_aneel_aproveitamentos">geopr_aneel_aproveitamentos</option><option value="geopr_aneel_eolicas">geopr_aneel_eolicas</option><option value="geopr_aneel_reservatorios">geopr_aneel_reservatorios</option><option value="geopr_aneel_subestacoes">geopr_aneel_subestacoes</option><option value="geopr_aneel_termeletricas">geopr_aneel_termeletricas</option><option value="geopr_dsainpe_focos_2dias">geopr_dsainpe_focos_2dias</option><option value="geopr_dsainpe_focos_acumulado">geopr_dsainpe_focos_acumulado</option><option value="geopr_dsainpe_fortracc">geopr_dsainpe_fortracc</option><option value="geopr_dsainpe_fortracc120">geopr_dsainpe_fortracc120</option><option value="geopr_dsainpe_goes10">geopr_dsainpe_goes10</option><option value="geopr_dsainpe_mrg12">geopr_dsainpe_mrg12</option><option value="geopr_dsainpe_mrp1">geopr_dsainpe_mrp1</option><option value="geopr_dsainpe_prec_inst">geopr_dsainpe_prec_inst</option><option value="geopr_incra_assentamentos">geopr_incra_assentamentos</option><option value="geopr_incra_quilobola">geopr_incra_quilobola</option><option value="geopr_sipam_aeroportos">geopr_sipam_aeroportos</option><option value="geopr_sipam_arco">geopr_sipam_arco</option><option value="geopr_sipam_ems">geopr_sipam_ems</option><option value="geopr_sipam_eso">geopr_sipam_eso</option><option value="geopr_sipam_goes">geopr_sipam_goes</option><option value="geopr_sipam_hfdf">geopr_sipam_hfdf</option><option value="geopr_sipam_localidades">geopr_sipam_localidades</option><option value="geopr_sipam_pcds">geopr_sipam_pcds</option><option value="geopr_sipam_radarm">geopr_sipam_radarm</option><option value="geopr_sipam_raios">geopr_sipam_raios</option><option value="geopr_sipam_solospo">geopr_sipam_solospo</option><option value="geopr_sipam_solospt">geopr_sipam_solospt</option><option value="geopr_sipam_tiros">geopr_sipam_tiros</option><option value="geopr_sipam_vege">geopr_sipam_vege</option><option value="geopr_sipam_vsat">geopr_sipam_vsat</option><option value="grid">grid</option><option value="itcd">itcd</option><option value="kml">kml</option><option value="locali">locali</option><option value="localilinux">localilinux</option><option value="meutema">meutema</option><option value="mosaicotm7">mosaicotm7</option><option value="municipios">municipios</option><option value="munpop">munpop</option><option value="osm">osm</option><option value="p2r2uf1">p2r2uf1</option><option value="postgis">postgis</option><option value="povoado">povoado</option><option value="teste">teste</option><option value="teste5">teste5</option><option value="testegml">testegml</option><option value="testept">testept</option><option value="testepttemplatekml">testepttemplatekml</option><option value="testesubsstring">testesubsstring</option><option value="testeutf8postgis">testeutf8postgis</option><option value="testeutm">testeutm</option><option value="testezoom">testezoom</option><option value="vegetacao">vegetacao</option><option value="visitantes">visitantes</option></select></form><br style="color: rgb(47, 70, 50); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;"><hr style="color: rgb(47, 70, 50); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;"><br style="color: rgb(47, 70, 50); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;"><br style="color: rgb(47, 70, 50); font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;"><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: red;"><b>Testando: temas/itcd.map</b></span><pre style="color: rgb(47, 70, 50); font-size: 12px;"><img src="http://10.19.60.100/ms_tmp/tgCBvsPuittestel.png"><br>Erros:</pre><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">Date: Wed, 27 Feb 2013 12:47:52 -0300<br>From: edmar.moretti@terra.com.br<br>To: i3geo@lists.osgeo.org<br>Subject: Re: [I3geo] Conectar com Banco de Dados Postgres<br><br>
  
    
  
  
    Sim. Deixe o type como point.<br>
    <br>
    Pq vc não altera o nome de uma tabela para testar antes de recriar
    todo o banco?<br>
    <br>
    <br>
    <div class="ecxmoz-cite-prefix">Em 27-02-2013 12:40, Benjamim Pereira
      Vilela escreveu:<br>
    </div>
    <blockquote cite="mid:SNT134-W50F03D82908BF3AD3EBC35C6FD0@phx.gbl">
      <style><!--
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}

--></style>
      <div dir="ltr">
        Moretti,
        <div><br>
        </div>
        <div>Estou criando outro banco e organizando tudo.</div>
        <div><br>
        </div>
        <div>Logo falo se deu certo. </div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Agora uma pergunta: o meu dado é do tipo ponto, então devo
          deixar o TYPE POINT?</div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Obrigado.<br>
          <div>
            <hr id="ecxstopSpelling">Date: Wed, 27 Feb 2013 11:29:42 -0300<br>
            From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:edmar.moretti@terra.com.br">edmar.moretti@terra.com.br</a><br>
            To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a><br>
            Subject: Re: [I3geo] Conectar com Banco de Dados Postgres<br>
            <br>
            É uma boa prática não usar nomes nas tabelas em caixa alta e
            evite caracteres especiais, como "-"<br>
            <br>
            Provavelmente seja esse o problema. Vc terá de renomear sua
            tabela no banco.<br>
            <br>
            <br>
            <div class="ecxmoz-cite-prefix">Em 27-02-2013 10:33,
              Benjamim Pereira Vilela escreveu:<br>
            </div>
            <blockquote cite="mid:SNT134-W85E245B7D65EB707AEED7C6FD0@phx.gbl">
              <style><!--
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}

--></style>
              <div dir="ltr"> Olá amigos,
                <div><br>
                </div>
                <div>Eu de novo... </div>
                <div><br>
                </div>
                <div>Veja a configuração do mapfile itcd.map</div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div>
                  <div>MAP</div>
                  <div>  FONTSET "../symbols/fontes.txt"</div>
                  <div>  SYMBOLSET "../symbols/simbolos.sym"</div>
                  <div>  LAYER</div>
                  <div>    CONNECTION "user=postgres password=123456
                    dbname=postgis host=localhost port=5432"</div>
                  <div>    #CONNECTION "postgres"</div>
                  <div>    CONNECTIONTYPE POSTGIS</div>
                  <div>    DATA "the_geom from (select * from
                    Consumidores-Celg) as foo using unique gid using
                    srid=4674"   </div>
                  <div>    METADATA</div>
                  <div>      "ID_MEDIDA_VARIAVEL"    ""</div>
                  <div>      "cache"    ""</div>
                  <div>      "CLASSE"    "SIM"</div>
                  <div>      "permitedownload"    "sim"</div>
                  <div>      "permiteogc"    "sim"</div>
                  <div>      "permitekml"    "sim"</div>
                  <div>      "TEMA"    "ITCD"</div>
                  <div>      "convcaracter"    ""</div>
                  <div>    END # METADATA</div>
                  <div>    NAME "itcd"</div>
                  <div>    STATUS DEFAULT</div>
                  <div>    TEMPLATE "none.htm"</div>
                  <div>    TYPE POINT</div>
                  <div>    CLASS</div>
                  <div>      NAME ""</div>
                  <div>      STYLE</div>
                  <div>        ANGLE 0</div>
                  <div>        OFFSET 0 0</div>
                  <div>        OUTLINECOLOR 255 0 0</div>
                  <div>        SYMBOL "p0"</div>
                  <div>      END # STYLE</div>
                  <div>      STYLE</div>
                  <div>        ANGLE 0</div>
                  <div>        COLOR 255 255 255</div>
                  <div>        OFFSET 0 0</div>
                  <div>        OPACITY 20</div>
                  <div>      END # STYLE</div>
                  <div>    END # CLASS</div>
                  <div>  END # LAYER</div>
                  <div><br>
                  </div>
                  <div>END # MAP</div>
                  <div><br>
                  </div>
                  <div><br>
                  </div>
                  <div>----------------</div>
                  <div><br>
                  </div>
                  <div><br>
                  </div>
                  <div>Erro da conexão:</div>
                  <div><br>
                  </div>
                  <div><br>
                  </div>
                  <br style="color:rgb(47, 70,\00000d\00000a                    50);font-family:Verdana,\00000d\00000a Arial,\00000d\00000a                    Helvetica, sans-serif;font-size:12px">
                  <br style="color:rgb(47, 70,\00000d\00000a                    50);font-family:Verdana,\00000d\00000a Arial,\00000d\00000a                    Helvetica, sans-serif;font-size:12px">
                  <span style="font-family:Verdana, Arial,\00000d\00000a                    Helvetica,\00000d\00000a\00000d\00000a                    sans-serif;font-size:12px;color:red"><b>Testando:
                      temas/itcd.map</b></span>
                  <pre style="color:rgb(47, 70, 50);font-size:12px">Problemas ao gerar o mapa

Error in %s: %s
msDrawMap()Failed to draw layer named 'itcd'.
Error in %s: %s
msPostGISLayerWhichShapes()Error (ERROR:  syntax error at or near "-"
LINE 1: ...x') as geom,"gid" from (select * from Consumidores-Celg) as ...
                                                             ^
) executing query: select encode(ST_AsBinary(ST_Force_2D("the_geom"),'NDR'),'hex') as geom,"gid" from (select * from Consumidores-Celg) as foo where the_geom && GeomFromText('POLYGON((-76.5125927 -39.3946085528634,-76.5125927 9.49218955277337,-29.5851853 9.49218955277337,-29.5851853 -39.3946085528634,-76.5125927 -39.3946085528634))',4674)</pre>
                  <pre style="color:rgb(47, 70, 50);font-size:12px">---------------------</pre>
                  <pre style="color:rgb(47, 70, 50);font-size:12px">Configuração no Postgres</pre>
                  <pre><font color="#2f4632"><span style="font-size:12px">-- Schema: public

-- DROP SCHEMA public;

CREATE SCHEMA public
  AUTHORIZATION postgres;

GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
COMMENT ON SCHEMA public
  IS 'standard public schema';</span></font></pre>
                  <pre><font color="#2f4632"><span style="font-size:12px">- Table: "Consumidores-Celg"

-- DROP TABLE "Consumidores-Celg";

CREATE TABLE "Consumidores-Celg"
(
  gid serial NOT NULL,
  "ORDEM" character varying(254),
  "IDENTIF_UC" character varying(254),
  "NOME_CLIEN" character varying(254),
  "INSCR_ESTA" character varying(254),
  "NOME_LOCAL" character varying(254),
  "NOME_BAIRR" character varying(254),
  "CEP" character varying(254),
  "TP_LOGRADO" character varying(254),
  "TIT_LOGRAD" character varying(254),
  "NOME_LOGRA" character varying(254),
  "NUM_PORTA" character varying(254),
  "NUM_QUADRA" character varying(254),
  "NUM_LOTE" character varying(254),
  "COMPLEMENT" character varying(254),
  "M11273_CON" double precision,
  "M11273_C_1" double precision,
  "Coordx" double precision,
  "CoordY" double precision,
  the_geom geometry,
  CONSTRAINT "Consumidores-Celg_pkey" PRIMARY KEY (gid),
  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL),
  CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4674)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Consumidores-Celg"
  OWNER TO postgres;
</span></font></pre>
                  <div><font color="#2f4632"><span style="font-size:12px"><br>
                      </span></font></div>
                  <div><font color="#2f4632"><span style="font-size:12px"><br>
                      </span></font></div>
                  <div><font color="#2f4632">
                      <div><span style="font-size:12px">-- Table:
                          geometry_columns</span></div>
                      <div><span style="font-size:12px"><br>
                        </span></div>
                      <div><span style="font-size:12px">-- DROP TABLE
                          geometry_columns;</span></div>
                      <div><span style="font-size:12px"><br>
                        </span></div>
                      <div><span style="font-size:12px">CREATE TABLE
                          geometry_columns</span></div>
                      <div><span style="font-size:12px">(</span></div>
                      <div><span style="font-size:12px"> 
                          f_table_catalog character varying(256) NOT
                          NULL,</span></div>
                      <div><span style="font-size:12px">  f_table_schema
                          character varying(256) NOT NULL,</span></div>
                      <div><span style="font-size:12px">  f_table_name
                          character varying(256) NOT NULL,</span></div>
                      <div><span style="font-size:12px"> 
                          f_geometry_column character varying(256) NOT
                          NULL,</span></div>
                      <div><span style="font-size:12px"> 
                          coord_dimension integer NOT NULL,</span></div>
                      <div><span style="font-size:12px">  srid integer
                          NOT NULL,</span></div>
                      <div><span style="font-size:12px">  type character
                          varying(30) NOT NULL,</span></div>
                      <div><span style="font-size:12px">  CONSTRAINT
                          geometry_columns_pk PRIMARY KEY
                          (f_table_catalog, f_table_schema,
                          f_table_name, f_geometry_column)</span></div>
                      <div><span style="font-size:12px">)</span></div>
                      <div><span style="font-size:12px">WITH (</span></div>
                      <div><span style="font-size:12px">  OIDS=TRUE</span></div>
                      <div><span style="font-size:12px">);</span></div>
                      <div><span style="font-size:12px">ALTER TABLE
                          geometry_columns</span></div>
                      <div><span style="font-size:12px">  OWNER TO
                          postgres;</span></div>
                      <div style="font-size:12px"><br>
                      </div>
                      <div style="font-size:12px"><br>
                      </div>
                      <div>
                        <div><span style="font-size:12px">-- Table:
                            spatial_ref_sys</span></div>
                        <div><span style="font-size:12px"><br>
                          </span></div>
                        <div><span style="font-size:12px">-- DROP TABLE
                            spatial_ref_sys;</span></div>
                        <div><span style="font-size:12px"><br>
                          </span></div>
                        <div><span style="font-size:12px">CREATE TABLE
                            spatial_ref_sys</span></div>
                        <div><span style="font-size:12px">(</span></div>
                        <div><span style="font-size:12px">  srid integer
                            NOT NULL,</span></div>
                        <div><span style="font-size:12px">  auth_name
                            character varying(256),</span></div>
                        <div><span style="font-size:12px">  auth_srid
                            integer,</span></div>
                        <div><span style="font-size:12px">  srtext
                            character varying(2048),</span></div>
                        <div><span style="font-size:12px">  proj4text
                            character varying(2048),</span></div>
                        <div><span style="font-size:12px">  CONSTRAINT
                            spatial_ref_sys_pkey PRIMARY KEY (srid)</span></div>
                        <div><span style="font-size:12px">)</span></div>
                        <div><span style="font-size:12px">WITH (</span></div>
                        <div><span style="font-size:12px">  OIDS=FALSE</span></div>
                        <div><span style="font-size:12px">);</span></div>
                        <div><span style="font-size:12px">ALTER TABLE
                            spatial_ref_sys</span></div>
                        <div><span style="font-size:12px">  OWNER TO
                            postgres;</span></div>
                        <div style="font-size:12px"><br>
                        </div>
                      </div>
                    </font></div>
                  <pre><font color="#2f4632"><span style="font-size:12px">
</span></font></pre>
                  <pre><font color="#2f4632"><span style="font-size:12px">
</span></font></pre>
                  <pre><font color="#2f4632"><span style="font-size:12px">
</span></font></pre>
                  <pre><font color="#2f4632"><span style="font-size:12px">
</span></font></pre>
                  <div>
                    <hr id="ecxstopSpelling">Date: Tue, 26 Feb 2013
                    21:20:07 -0300<br>
                    From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:edmar.moretti@terra.com.br">edmar.moretti@terra.com.br</a><br>
                    To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a><br>
                    Subject: Re: [I3geo] Conectar com Banco de Dados
                    Postgres<br>
                    <br>
                    Pelo que mostra a sua imagem as tabelas estão no
                    esquema "public", nesse caso não é necessário
                    incluir o nome do esquema no sql, pois o public é o
                    default.<br>
                    <br>
                    Utilize dessa forma:<br>
                    <br>
                    DATA "the_geom from (select * from nomedaminhatabela
                    ) as foo using unique gid using srid=4326"<br>
                    <br>
                    Edmar Moretti<br>
                    <br>
                    <br>
                    <div class="ecxmoz-cite-prefix">Em 26-02-2013 09:58,
                      Rafael Dantas escreveu:<br>
                    </div>
                    <blockquote cite="mid:CAJc++doNSa+iNdxMopokey0qqTueWNyvs8cJuo5if_geNvwtwg@mail.gmail.com">
                      <div dir="ltr">Olá Benjamin,
                        <div><br>
                        </div>
                        <div style="">posso estar enganado, mas faça o
                          seguinte: </div>
                        <div style=""><br>
                        </div>
                        <div style="">abra o pgAdmin III, conecte seu
                          banco de dados, dentro dele verifique quantos
                          SCHEMAS há, e coloque no lugar de <font color="#ff00ff">esquema</font> o nome do
                          SCHEMA que estão suas tabelas de dados.</div>
                        <div style=""><br>
                        </div>
                        <div style="">veja o meu printscreen</div>
                        <div style=""><br>
                        </div>
                        <div style="">Minhas tabelas estão no SCHEMA <font color="#ff00ff">public</font></div>
                        <div style=""><br>
                        </div>
                      </div>
                      <div class="ecxgmail_extra"><br>
                        <br>
                        <div class="ecxgmail_quote">Em 26 de fevereiro
                          de 2013 09:36, Benjamim Pereira Vilela <span dir="ltr"><<a href="mailto:bpvilela@hotmail.com">bpvilela@hotmail.com</a>></span>
                          escreveu:<br>
                          <blockquote class="ecxgmail_quote" style="border-left:1px #ccc\00000d\00000a                            solid;padding-left:1ex">
                            <div>
                              <div dir="ltr"> Pessoal,
                                <div><br>
                                </div>
                                <div>Agradeço a todos pela ajuda.
                                  Consegui conectar, porém o meu projeto
                                  dá o seguinte erro:</div>
                                <div><br>
                                </div>
                                <div><span style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;color:red"><b>Testando:


                                      temas/itcd.map</b></span>
                                  <pre style="color:rgb(47,70,50);font-size:12px">Problemas ao gerar o mapa

Error in %s: %s
msDrawMap()Failed to draw layer named 'itcd'.
Error in %s: %s
msPostGISLayerWhichShapes()Error (ERROR:  schema "esquema" does not exist
LINE 1: ...),'NDR'),'hex') as geom,"gid" from (select * from esquema.ta...
                                                             ^
) executing query: select encode(ST_AsBinary(ST_Force_2D("the_geom"),'NDR'),'hex') as geom,"gid" from (select * from esquema.tabela) as foo where the_geo</pre>
                                  <pre style="color:rgb(47,70,50);font-size:12px">Como o dados que possuo no Banco são em formato de ponto, será tem algo a ver?</pre>
                                  <pre style="color:rgb(47,70,50);font-size:12px">Obrigado.</pre>
                                  <br>
                                  <div>
                                    <hr>Date: Mon, 25 Feb 2013 21:15:39
                                    -0300<br>
                                    From: <a href="mailto:edmar.moretti@terra.com.br">edmar.moretti@terra.com.br</a><br>
                                    To: <a href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a><br>
                                    Subject: Re: [I3geo] Conectar com
                                    Banco de Dados Postgres
                                    <div>
                                      <div class="h5"><br>
                                        <br>
                                        Para criar uma camada no i3Geo
                                        utilize o sistema de
                                        administração (<a href="http://localhost/i3geo/admin" target="_blank">http://localhost/i3geo/admin</a>).<br>
                                        <br>
                                        Se vc quiser fazer um teste,
                                        crie um arquivo dentro da pasta
                                        i3geo/temas com o nome
                                        meumapfile.map e cole o texto
                                        abaixo. Altere o DATA conforme o
                                        seu banco de dados e inicie o
                                        i3geo pela url:<br>
                                        <a href="http://localhost/i3geo/ms_criamapa.php?temasa=meumapfile&layers=meumapfile" target="_blank">http://localhost/i3geo/ms_criamapa.php?temasa=meumapfile&layers=meumapfile</a><br>
                                        <br>
                                        Você pode também testar seu
                                        mapfile usando <a href="http://localhost/i3geo/testamapfile.php?map=meumapfile" target="_blank">http://localhost/i3geo/testamapfile.php?map=meumapfile</a><br>
                                        <br>
                                        texto para o meumapfile.map:<br>
                                        <br>
                                        <br>
                                        <br>
                                        <br>
                                        MAP<br>
                                          FONTSET
                                        "../symbols/fontes.txt"<br>
                                          SYMBOLSET
                                        "../symbols/simbolos.sym"<br>
                                          LAYER<br>
                                            CONNECTION "user=postgres
                                        password=postgres
                                        dbname=nomedobanco
                                        host=localhost port=5432"<br>
                                            #CONNECTION "postgres"<br>
                                            CONNECTIONTYPE POSTGIS<br>
                                            DATA "the_geom from (select
                                        * from esquema.tabela) as foo
                                        using unique gid using
                                        srid=4326"<br>
                                            METADATA<br>
                                              "ID_MEDIDA_VARIAVEL"    ""<br>
                                              "cache"    ""<br>
                                              "CLASSE"    "SIM"<br>
                                              "permitedownload"    "sim"<br>
                                              "permiteogc"    "sim"<br>
                                              "permitekml"    "sim"<br>
                                              "TEMA"    "Minha camada"<br>
                                              "convcaracter"    ""<br>
                                            END # METADATA<br>
                                            NAME "meumapfile"<br>
                                            STATUS DEFAULT<br>
                                            TEMPLATE "none.htm"<br>
                                            TYPE POLYGON<br>
                                            CLASS<br>
                                              NAME ""<br>
                                              STYLE<br>
                                                ANGLE 0<br>
                                                OFFSET 0 0<br>
                                                OUTLINECOLOR 255 0 0<br>
                                                SYMBOL "p0"<br>
                                              END # STYLE<br>
                                              STYLE<br>
                                                ANGLE 0<br>
                                                COLOR 255 255 255<br>
                                                OFFSET 0 0<br>
                                                OPACITY 20<br>
                                              END # STYLE<br>
                                            END # CLASS<br>
                                          END # LAYER<br>
                                        <br>
                                        END # MAP<br>
                                        <br>
                                        <br>
                                        <br>
                                        <br>
                                        <br>
                                        <br>
                                        <br>
                                        <br>
                                        <br>
                                        <div>Em 25-02-2013 12:38,
                                          Benjamim Pereira Vilela
                                          escreveu:<br>
                                        </div>
                                        <blockquote>
                                          <div dir="ltr"> Pessoal,
                                            <div><br>
                                            </div>
                                            <div>Estou apanhando aqui.
                                              Consegui instalar o i3geo
                                              no ubuntu server. Tenho
                                              neste servidor uma banco
                                              de dados no postgres.
                                              Acesso o mesmo por meio do
                                              qgis. Gostaria de
                                              estabelecer a conexão do
                                              igeo como o mesmo. Como
                                              configurar?</div>
                                            <div><br>
                                            </div>
                                            <div>Alguém teria um
                                              passo-a-passo?</div>
                                            <div><br>
                                            </div>
                                            <div>Obrigado.</div>
                                            <div><br>
                                            </div>
                                            <div>Benjamim</div>
                                          </div>
                                          <br>
                                          <fieldset></fieldset>
                                          <br>
                                          <pre>_______________________________________________
i3geo mailing list
<a href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a>
</pre>
                                        </blockquote>
                                        <br>
                                        <div>-- <br>
                                          <br>
                                          <a target="_blank">http://edmarmoretti.com.br</a></div>
                                        <br>
                                        _______________________________________________


                                        i3geo mailing list <a href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a>
                                        <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a></div>
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </div>
                            <br>
_______________________________________________<br>
                            i3geo mailing list<br>
                            <a href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a><br>
                            <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a><br>
                            <br>
                          </blockquote>
                        </div>
                        <br>
                        <br clear="all">
                        <div><br>
                        </div>
                        -- <br>
                        Rafael Dantas </div>
                      <br>
                      <fieldset class="ecxmimeAttachmentHeader"></fieldset>
                      <br>
                      <pre>_______________________________________________
i3geo mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a>
</pre>
                    </blockquote>
                    <br>
                    <div class="ecxmoz-signature">-- <br>
                      <br>
                      <a target="_blank">http://edmarmoretti.com.br</a></div>
                    <br>
                    _______________________________________________
                    i3geo mailing list <a class="ecxmoz-txt-link-abbreviated" href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a>
                    <a class="ecxmoz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a></div>
                </div>
              </div>
              <br>
              <fieldset class="ecxmimeAttachmentHeader"></fieldset>
              <br>
              <pre>_______________________________________________
i3geo mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a>
</pre>
            </blockquote>
            <br>
            <div class="ecxmoz-signature">-- <br>
              <br>
              <a target="_blank">http://edmarmoretti.com.br</a></div>
            <br>
            _______________________________________________
            i3geo mailing list
            <a class="ecxmoz-txt-link-abbreviated" href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a>
            <a class="ecxmoz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a></div>
        </div>
      </div>
      <br>
      <fieldset class="ecxmimeAttachmentHeader"></fieldset>
      <br>
      <pre>_______________________________________________
i3geo mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:i3geo@lists.osgeo.org">i3geo@lists.osgeo.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</a>
</pre>
    </blockquote>
    <br>
    <div class="ecxmoz-signature">-- <br>
      <br>
      <a target="_blank">http://edmarmoretti.com.br</a></div>
  

<br>_______________________________________________
i3geo mailing list
i3geo@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/i3geo</div></div></div>                                         </div></body>
</html>