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 <[email protected]>
>> Sent: 10-01-2017 05:59 PM
>> To: Srikanth <[email protected]>
>> Cc: geoserver-users <[email protected]>
>> 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 <+39%200584%20962313>
> fax: +39 0584 1660272 <+39%200584%20166%200272>
> mob: +39 339 8844549 <+39%20339%20884%204549>
>
> 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
