Hello everyone,
I would like to know if I can make a getfeatureinfo, from wms layer, taking
also data from other database tables (tables with relations).
Thanks a lot
--
View this message in context: http://old.nabble.com/getfeatureinfo-from-other-database-table-tp30473679p30473679.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
On Thu, Dec 16, 2010 at 4:35 PM, paolotome <paolo_tome@anonymised.com> wrote:
Hello everyone,
I would like to know if I can make a getfeatureinfo, from wms layer, taking
also data from other database tables (tables with relations).
There is no explicit support for this, but maybe you can get away
using sql views?
http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.html
Mind, this is new functionality in the 2.1 series
Cheers
Andrea
-----------------------------------------------------
Ing. Andrea Aime
Senior Software Engineer
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584962313
fax: +39 0584962313
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-----------------------------------------------------
Thanks for your interest. the link you suggested is very interesting. That's
the solution I was looking for and I could not find. I hope to be able to
use this method!
thanks again, your help is always very important
Paolo
Andrea Aime-5 wrote:
On Thu, Dec 16, 2010 at 4:35 PM, paolotome <paolo_tome@anonymised.com> wrote:
Hello everyone,
I would like to know if I can make a getfeatureinfo, from wms layer,
taking
also data from other database tables (tables with relations).There is no explicit support for this, but maybe you can get away
using sql views?
http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.htmlMind, this is new functionality in the 2.1 series
Cheers
Andrea-----------------------------------------------------
Ing. Andrea Aime
Senior Software EngineerGeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italyphone: +39 0584962313
fax: +39 0584962313http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf-----------------------------------------------------
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://old.nabble.com/getfeatureinfo-from-other-database-table-tp30473679p30479764.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
hello,
I created a test query from a MySQL database. The connection to the database
seems to occur correctly. But there is a problem: as you can see from the
photo, the_geom field is treated as a "bit " field.
Is there a way to change the formatting of the_geom field? (double checked
and corrected, as suggested by the guide, it does not work).
thanks again
http://old.nabble.com/file/p30487170/sql.jpg
paolotome wrote:
Thanks for your interest. the link you suggested is very interesting.
That's the solution I was looking for and I could not find. I hope to be
able to use this method!
thanks again, your help is always very important
PaoloAndrea Aime-5 wrote:
On Thu, Dec 16, 2010 at 4:35 PM, paolotome <paolo_tome@anonymised.com>
wrote:Hello everyone,
I would like to know if I can make a getfeatureinfo, from wms layer,
taking
also data from other database tables (tables with relations).There is no explicit support for this, but maybe you can get away
using sql views?
http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.htmlMind, this is new functionality in the 2.1 series
Cheers
Andrea-----------------------------------------------------
Ing. Andrea Aime
Senior Software EngineerGeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italyphone: +39 0584962313
fax: +39 0584962313http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf-----------------------------------------------------
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://old.nabble.com/getfeatureinfo-from-other-database-table-tp30473679p30487170.html
Sent from the GeoServer - User mailing list archive at Nabble.com.