Thanks for the answers.... I thought that the problem was the TYPE in the mapfile but the problem was another one... when I try to see data using the URL:<br> <br> http://localhost/cgi-bin/mapserv?map=/usr/local/apache2/htdocs/mapserver/ejemplo_postgis3.map&mode=map<br> <br> I receive the following errors:<br> <br> msDrawMap(): Image handling error. Unable to initialize image. <br> msPrepareImage(): General error message. Image dimensions not specified. <br> msCalculateScale(): General error message. Invalid image extent, minx=-1.000000, miny=-1.000000, maxx=-1.000000, maxy=-1.000000. <br> mapserv(): Web application error. No way to generate map extent. <br> <br> My .map file contains the following:<br> <br> LAYER<br> NAME pg_test<br> TYPE POINT<br> STATUS DEFAULT<br> CONNECTIONTYPE POSTGIS<br> CONNECTION "host=localhost port=5432 dbname=miprimergis password=**** user=*****"<br> DATA "the_geom FROM cities"<br> END<br>
END<br> <br> and my .sql to load data in the postgis database is:<br> <br> BEGIN;<br> CREATE TABLE "cities" (gid serial PRIMARY KEY,<br> "city_name" varchar(40),<br> "gmi_admin" varchar(7),<br> "admin_name" varchar(42),<br> "fips_cntry" varchar(2),<br> "cntry_name" varchar(40),<br> "status" varchar(50),<br> "pop_rank" int2,<br> "pop_class" varchar(22),<br> "port_id" int2);<br> SELECT AddGeometryColumn('','cities','the_geom','-1','POINT',2);<br> INSERT INTO "cities" ("city_name","gmi_admin","admin_name","fips_cntry","cntry_n<br> ame","status","pop_rank","pop_class","port_id",the_geom) VALUES ('Drammen','NOR-<br> BSK','Buskerud','NO','Norway','Provincial capital','6','50,000 to 100,000','2378<br> 0','01010000000000006066662440000000A099D94D40');<br> INSERT INTO "cities" ("city_name","gmi_admin","admin_name","fips_cntry","cntry_n<br> ame","status","pop_rank","pop_class","port_id",the_geom) VALUES ('Trinidad','BOL<br> -EBE','El Beni','BL','Bolivia','Provincial
capital','6','50,000 to 100,000','0',<br> '0101000000000000C0CA3950C00000008097AE2DC0');<br> END;<br> <br> I read the same error in the list but it was not the answer....<br> <br> Thanks!<br> Agustina<br> <br> <br> <br> <br> <br> <br> <br> <p>
<hr size=1>
<b>Preguntá. Respondé. Descubrí.</b><br>
Todo lo que querías saber, y lo que ni imaginabas,<br>
está en <b>Yahoo! Respuestas</b> (Beta).<br>
<b><a href="http://ar.answers.yahoo.com">Probalo ya!</a></b>