We already have the solution, thanks for the support. Greetings
Cristian 2009/4/21 Cristian Vera <[email protected]> > Walter, we only define a view crossing two tables with spatial information, > the result of this is what we want to show in pmapper. > > The tables are for example: cities and countries. And we want to show all > the cities contained in one country, with the particularity that we want to > do that using a spatial query defined before as a database view, and the > result of apliying this database view is what we want to see as a layer in > our pmapper application. > > Now the problem is that for some reason mapserver is not answering our call > and the consecuence of that it's pmapper doesn't do anything for drawing the > layer defined as a wrote before. > > Cristian, > > 2009/4/21 Armin Burger <[email protected]> > > There's nothing special with p.mapper and PG layers. If you cannot get >> it running with pure Mapserver, e.g. shp2img then it will not work >> neither with p.mapper. And the question should be placed on the >> Mapserver mailing list and not here. >> >> armin >> >> On Tue, Apr 21, 2009 at 8:23 AM, Walter Lorenzetti <[email protected]> >> wrote: >> > Hi Cristian, >> > >> > have you add your view in the geometry_columns table? >> > >> > Walter >> > >> > Cristian Vera ha scritto: >> >> Dear list, >> >> >> >> we want to load a layer from a database view, but we can't do it yet. >> >> >> >> we have the next .map file config for this >> >> >> >> LAYER >> >> NAME "layername" >> >> TYPE POINT >> >> CONNECTIONTYPE POSTGIS >> >> CONNECTION "user=* password=* dbname=* host=*" >> >> DATA "the_geom from (select * from mytable) USING SRID=4326" >> >> STATUS ON >> >> TRANSPARENCY 100 >> >> TEMPLATE void >> >> PROJECTION >> >> "init=epsg:4326" >> >> END >> >> METADATA >> >> "DESCRIPTION" "My description" >> >> "RESULT_HEADERS" "field1, field2, field3, field N" >> >> "RESULT_FIELDS" "field1, field2, field3, field N" >> >> "LAYER_ENCODING" "UTF-8" >> >> "ows_title" 'layername' >> >> END >> >> CLASS >> >> NAME "myclassname" >> >> COLOR 0 227 255 >> >> OUTLINECOLOR 0 0 0 >> >> SYMBOL "circulo" >> >> SIZE 6 >> >> END >> >> END >> >> >> >> Our database view definiton sql is: >> >> >> >> SELECT b.field1 AS nameb1, c.field1 AS namec1, c.field2 AS namec2 , >> >> c.field3 AS namec3, c.the_geom, c.gid FROM tablec c, tableb b WHERE >> >> contains(b.the_geom, c.the_geom) ORDER BY b.nameb1; >> >> >> >> by the way, we are using pmapper4-beta1, and we already read the >> faq of >> >> pmapper for try to doing this. >> >> >> >> i hope you can help us, >> >> >> >> Regards >> >> >> >> Cristian, >> >> >> ------------------------------------------------------------------------------ >> >> Stay on top of everything new and different, both inside and >> >> around Java (TM) technology - register by April 22, and save >> >> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. >> >> 300 plus technical and hands-on sessions. Register today. >> >> Use priority code J9JMT32. http://p.sf.net/sfu/p >> >> _______________________________________________ >> >> pmapper-users mailing list >> >> [email protected] >> >> https://lists.sourceforge.net/lists/listinfo/pmapper-users >> >> >> > >> > >> > -- >> > >> > Walter Lorenzetti >> > email: [email protected] >> > skype: aiki74 >> > Cell: (+39) 347-6597931 Tel+Fax: (+39) 0583 926684 >> > Via di Tofori 123a 55010, Camigliano-S.Gemma Lucca >> > Italy >> > >> > >> > >> ------------------------------------------------------------------------------ >> > Stay on top of everything new and different, both inside and >> > around Java (TM) technology - register by April 22, and save >> > $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. >> > 300 plus technical and hands-on sessions. Register today. >> > Use priority code J9JMT32. http://p.sf.net/sfu/p >> > _______________________________________________ >> > pmapper-users mailing list >> > [email protected] >> > https://lists.sourceforge.net/lists/listinfo/pmapper-users >> > >> > > ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
