Hi Julain and Andrea,
Resolved this by using getfeatureinfo by json object fetching with primary key,
passing it to another webservice.
Thank you for your wonderful support.
-Srikanth
Sent from Mail for Windows 10
From: Srikanth
Sent: 10 January 2017 07:54 PM
To: Andrea Aime
Cc: Julian Hollingbery; geoserver-users
Subject: Re: [Geoserver-users] WMS and Other Web Service Integration
Thanks Juilan and Andrea. I shall try both your suggestions and keep you posted.
On Tue, Jan 10, 2017 at 7:10 PM, Andrea Aime <[email protected]>
wrote:
Try to go to your store configuration and check "expose primary keys", then do
a GetFetaureInfo again. Does that solve your problem?
Cheers
Andrea
On Tue, Jan 10, 2017 at 2:22 PM, Srikanth Kanaparthy <[email protected]>
wrote:
We have a foreign key which shall be the id itself. But when clicked on map
which is served by WMS, geoserver with getfeatureinfo provides the attribute
data stored in same table. How do I call other web service, essentially I need
to know only Id here.
From: Julian Hollingbery
Sent: 10-01-2017 05:59 PM
To: Srikanth
Cc: geoserver-users
Subject: SV: [Geoserver-users] WMS and Other Web Service Integration
Aha..
I believe that, in any case, you’ll need to store the id (foreign key, possibly
compound) of the parcel in both databases/servers.
Which columns/attributes besides geometry do you have in the geometry database?
Fra: Srikanth [mailto:[email protected]]
Sendt: 10. januar 2017 13:09
Til: Julian Hollingbery <[email protected]>
Cc: geoserver-users <[email protected]>
Emne: Re: [Geoserver-users] WMS and Other Web Service Integration
Hello Julian,
I understand GetFeatureInfo provides the attribute values for the same database
where the geometry is residing.
In my case, geometry resides in one database and related meta-data resides in a
different server which has to accessed by customer web service. Hence whenever
the user clicks on a particular parcel, I need to call customer provided web
service to get details of the parcel.
On Tue, Jan 10, 2017 at 5:30 PM, Julian Hollingbery <[email protected]> wrote:
Have you tried GetFeatureInfo?
http://docs.geoserver.org/stable/en/user/services/wms/reference.html
Regards,
/julian
Fra: Srikanth [mailto:[email protected]]
Sendt: 10. januar 2017 11:39
Til: geoserver-users <[email protected]>
Emne: [Geoserver-users] WMS and Other Web Service Integration
Hello,
We have a million parcels stored in MySQL and are fetching using WMS. The
meta-data related to these parcels is stored in other database in some other
location, hence we cannot and and are not supposed to access this meta-data
directly. For this purpose, we have been provided a web service which consumes
'id' and returns a json object.
We are finding it difficult to get the 'id' of the parcel with wms in order to
pass it to webservice. Any advise/direction in this regard is highly
appreciated.
--
Regards,
Srikanth K.
--
Regards,
Srikanth K.
www.servetheneedy.org
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo
è consentito esclusivamente al destinatario del messaggio, per le finalità
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro
sistema. Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse,
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the
attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act (Legislative
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in
accord with its purpose, any disclosure, reproduction, copying, distribution,
or either dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the intended
recipient, please contact immediately the sender by telephone, fax or e-mail
and delete the information in this message that has been received in error. The
sender does not give any warranty or accept liability as the content, accuracy
or completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.
-------------------------------------------------------
--
Regards,
Srikanth K.
www.servetheneedy.org
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users