<div dir="ltr">Que bom que resolveu o problema Benjamin, já tive o mesmo por aqui e só descobri depois de apanhar um bocado também.<div><br></div><div style>Bons trabalhos aí.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
Em 27 de fevereiro de 2013 20:34, Benjamim Pereira Vilela <span dir="ltr"><<a href="mailto:bpvilela@hotmail.com" target="_blank">bpvilela@hotmail.com</a>></span> escreveu:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">



<div><div dir="ltr">
Prezado Valente,<br> <br>Infelizmente essa url não é pública, visto que roda dentro da RedeSEFAZ, entendidade governamental onde trabalho. Vou tentar colocar o serviço num servidor público.<br> <br> <br>Obrigado.<br> <br>
<div><div></div><hr>Date: Wed, 27 Feb 2013 19:36:51 -0300<div><div class="h5"><br>From: <a href="mailto:edmar.moretti@terra.com.br" target="_blank">edmar.moretti@terra.com.br</a><br>To: <a href="mailto:i3geo@lists.osgeo.org" target="_blank">i3geo@lists.osgeo.org</a><br>
Subject: Re: [I3geo] Conectar com Banco de Dados Postgres<br><br>
  
    
  
  
    Além de não ser pública, a url deveria ser:<br>
    <br>
    <a href="http://10.19.60.100/i3geo/ms_criamapa.php?temasa=meumapfile&layers=itcd" target="_blank">http://10.19.60.100/i3geo/ms_criamapa.php?temasa=itcd&layers=itcd</a><br>
    <br>
    <br>
    <div>Em 27-02-2013 17:56, Valenty Gonzalez
      escreveu:<br>
    </div>
    <blockquote>
      
      <div>Benjamin, la dirección <a href="http://10.19.60.100/" target="_blank">http://10.19.60.100/</a> no es
        pública así que no podemos visualizarla.<br>
        <br>
        Respecto al nombre del campo de las geometrías, si bien no es
        obligatorio, es recomendable que se llame 'the_geom' por ser el
        nombre por defecto que usan la mayoría de las aplicaciones.<br>
        <br>
        Saludos,<br>
        <br>
        Valenty<br>
        <br>
        El 27/02/13 12:55, Benjamim Pereira Vilela escribió:<br>
      </div>
      <blockquote>
        
        <div dir="ltr"> Pessoal,
          <div><br>
          </div>
          <div>Como falei, tenho muitos dados e gostaria de visualizar
            gradativamente  os dados. Mas utilizando o endereço</div>
          <div><br>
          </div>
          <div><a href="http://10.19.60.100/i3geo/ms_criamapa.php?temasa=meumapfile&layers=itcd" target="_blank">http://10.19.60.100/i3geo/ms_criamapa.php?temasa=meumapfile&layers=itcd</a></div>
          <div><br>
          </div>
          <div>Não aparece nada. Será que tenho que configurar outros
            itens para visualizar os dados? Quando vou em mapfile, vejo
            que o sistema está conectado e tudo.</div>
          <div><br>
          </div>
          <div>Obrigado.</div>
          <div><br>
            <br>
            <div>
              <hr>From: <a href="mailto:bpvilela@hotmail.com" target="_blank">bpvilela@hotmail.com</a><br>
              To: <a href="mailto:i3geo@lists.osgeo.org" target="_blank">i3geo@lists.osgeo.org</a><br>
              Date: Wed, 27 Feb 2013 17:19:16 +0000<br>
              Subject: Re: [I3geo] Conectar com Banco de Dados Postgres<br>
              <br>
              
              <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>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 value="sim" type="radio">sim <input value="nao" type="radio"> não<br>
                    <br>
                    <select>
                      <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>
                    <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="color:red;font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px"><b>Testando:
                        temas/itcd.map</b></span>
                    <pre style="color:rgb(47,70,50);font-size:12px"><img>
Erros:</pre>
                    <div>
                      <hr>Date: Wed, 27 Feb 2013
                      12:47:52 -0300<br>
                      From: <a href="mailto:edmar.moretti@terra.com.br" target="_blank">edmar.moretti@terra.com.br</a><br>
                      To: <a href="mailto:i3geo@lists.osgeo.org" target="_blank">i3geo@lists.osgeo.org</a><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>Em 27-02-2013
                        12:40, Benjamim Pereira Vilela escreveu:<br>
                      </div>
                      <blockquote>
                        
                        <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>Date: Wed, 27 Feb
                              2013 11:29:42 -0300<br>
                              From: <a href="mailto:edmar.moretti@terra.com.br" target="_blank">edmar.moretti@terra.com.br</a><br>
                              To: <a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>Em
                                27-02-2013 10:33, Benjamim Pereira
                                Vilela escreveu:<br>
                              </div>
                              <blockquote>
                                
                                <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,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="color:red;font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px"><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>Date:
                                      Tue, 26 Feb 2013 21:20:07 -0300<br>
                                      From: <a href="mailto:edmar.moretti@terra.com.br" target="_blank">edmar.moretti@terra.com.br</a><br>
                                      To: <a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>Em
                                        26-02-2013 09:58, Rafael Dantas
                                        escreveu:<br>
                                      </div>
                                      <blockquote>
                                        <div dir="ltr">Olá Benjamin,
                                          <div><br>
                                          </div>
                                          <div>posso estar
                                            enganado, mas faça o
                                            seguinte: </div>
                                          <div><br>
                                          </div>
                                          <div>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><br>
                                          </div>
                                          <div>veja o meu
                                            printscreen</div>
                                          <div><br>
                                          </div>
                                          <div>Minhas tabelas
                                            estão no SCHEMA <font color="#ff00ff">public</font></div>
                                          <div><br>
                                          </div>
                                        </div>
                                        <div><br>
                                          <br>
                                          <div>Em
                                            26 de fevereiro de 2013
                                            09:36, Benjamim Pereira
                                            Vilela <span dir="ltr"><<a href="mailto:bpvilela@hotmail.com" target="_blank">bpvilela@hotmail.com</a>></span>
                                            escreveu:<br>
                                            <blockquote style="padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
                                              <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="color:red;font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px"><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" target="_blank">edmar.moretti@terra.com.br</a><br>
                                                      To: <a href="mailto:i3geo@lists.osgeo.org" target="_blank">i3geo@lists.osgeo.org</a><br>
                                                      Subject: Re:
                                                      [I3geo] Conectar
                                                      com Banco de Dados
                                                      Postgres
                                                      <div>
                                                        <div><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" target="_blank">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>http://edmarmoretti.com.br</a></div>
                                                          <br>
                                                          _______________________________________________




                                                          i3geo mailing
                                                          list <a href="mailto:i3geo@lists.osgeo.org" target="_blank">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" target="_blank">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></fieldset>
                                        <br>
                                        <pre>_______________________________________________
i3geo mailing list
<a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>http://edmarmoretti.com.br</a></div>
                                      <br>
                                      _______________________________________________


                                      i3geo mailing list <a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>
                                <br>
                                <fieldset></fieldset>
                                <br>
                                <pre>_______________________________________________
i3geo mailing list
<a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>http://edmarmoretti.com.br</a></div>
                              <br>
                              _______________________________________________


                              i3geo mailing list <a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>
                        <br>
                        <fieldset></fieldset>
                        <br>
                        <pre>_______________________________________________
i3geo mailing list
<a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>http://edmarmoretti.com.br</a></div>
                      <br>
                      _______________________________________________
                      i3geo mailing list <a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>
              <br>
              _______________________________________________ i3geo
              mailing list <a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>
        <br>
        <fieldset></fieldset>
        <br>
        <pre>_______________________________________________
i3geo mailing list
<a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>
      <br>
      <fieldset></fieldset>
      <br>
      <pre>_______________________________________________
i3geo mailing list
<a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>http://edmarmoretti.com.br</a></div>
  

<br>_______________________________________________
i3geo mailing list
<a href="mailto:i3geo@lists.osgeo.org" target="_blank">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>
<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>