Hi,

Sorry, but I do not quite understand what is your actual problem and what is 
your question. If you read data from Oracle database and publish it as WMS or 
WFS all the changes made to Oracle shows  immediately in web services. Is it 
that you lack an application, perhaps browser based one, that can send updates 
into Oracle? Can you clarify?

-Jukka Rahkonen-

Dipak [mailto:di...@banerjeemail.com]
Re: [Geoserver-users] Geoserver-users Digest, Vol 128, Issue 11

Hi there,

We have been utilising GeoServer for viewing our Utility network (Electrical 
EHT/HT/LT) extensively with great results & feedback from the end users. With 
our limited knowledge we have implemented quite a few query screens for the 
on-line managers. However, there is one stumbling block any changes in the GIS 
cannot be seen immediately since it requires the total GIS to be processed into 
the format recognised by GeoServer. Our managers are now demanding on-line 
updating and viewing immediately which we are unable to provide.

We are presently on the InterGraph platform using G/Designer - but due to 
certain constraints we are migrating to the ESRI Platform of ArcGIS & ArcFM. 
within a year or so.

I was wondering if anyone else had faced this problem and whether there are any 
ready made solutions for this? We would be grateful for any suggestions. Oracle 
Spatial is the RDBMS as well as the Graphic engine in G/Designer.

Thanks,

Dipak Kumar Banerjee
IT Consultant
Mobile: +91 98310 54606


From: 
geoserver-users-requ...@lists.sourceforge.net<mailto:geoserver-users-requ...@lists.sourceforge.net>
Sent: Tue, 10 Jan 2017 18:18:01 GMT+0530
To: 
geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>
Subject: Geoserver-users Digest, Vol 128, Issue 11

Send Geoserver-users mailing list submissions to
   
geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>

To subscribe or unsubscribe via the World Wide Web, visit
   
https://lists.sourceforge.net/lists/listinfo/geoserver-users<//prolinks.rediffmailpro.com/cgi-bin/prored.cgi?red=https%3A%2F%2Flists%2Esourceforge%2Enet%2Flists%2Flistinfo%2Fgeoserver%2Dusers&rediffng=0>
or, via email, send a message with subject or body 'help' to
   
geoserver-users-requ...@lists.sourceforge.net<mailto:geoserver-users-requ...@lists.sourceforge.net>

You can reach the person managing the list at
   
geoserver-users-ow...@lists.sourceforge.net<mailto:geoserver-users-ow...@lists.sourceforge.net>

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Geoserver-users digest..."


Today's Topics:

  1. WMS and Other Web Service Integration (Srikanth)
  2. Re: WMS and Other Web Service Integration (Srikanth)
  3. Re: WMS and Other Web Service Integration (Julian Hollingbery)
  4. Re: WMS and Other Web Service Integration (Julian Hollingbery)


----------------------------------------------------------------------

Message: 1
Date: Tue, 10 Jan 2017 16:09:27 +0530
From: Srikanth <srikanth1...@gmail.com<mailto:srikanth1...@gmail.com>>
Subject: [Geoserver-users] WMS and Other Web Service Integration
To: geoserver-users 
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
Message-ID:
   
<CAPZ5UyWEOLxu03f=j+teg6m26_bfv3arpq85ecdr7jrku3w...@mail.gmail.com<mailto:CAPZ5UyWEOLxu03f=j+teg6m26_bfv3arpq85ecdr7jrku3w...@mail.gmail.com>>
Content-Type: text/plain; charset="utf-8"

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.
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 2
Date: Tue, 10 Jan 2017 17:39:03 +0530
From: Srikanth <srikanth1...@gmail.com<mailto:srikanth1...@gmail.com>>
Subject: Re: [Geoserver-users] WMS and Other Web Service Integration
To: Julian Hollingbery <jul...@northtech.dk<mailto:jul...@northtech.dk>>
Cc: geoserver-users 
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
Message-ID:
   
<capz5uyxkgmtew5omj+znzyj4qcrf6h4lbc0g+embuw8wf28...@mail.gmail.com<mailto:capz5uyxkgmtew5omj+znzyj4qcrf6h4lbc0g+embuw8wf28...@mail.gmail.com>>
Content-Type: text/plain; charset="utf-8"

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 
<jul...@northtech.dk<mailto:jul...@northtech.dk>>
wrote:

> Have you tried GetFeatureInfo?
>
> http://docs.geoserver.org/stable/en/user/services/wms/reference.html<//prolinks.rediffmailpro.com/cgi-bin/prored.cgi?red=http%3A%2F%2Fdocs%2Egeoserver%2Eorg%2Fstable%2Fen%2Fuser%2Fservices%2Fwms%2Freference%2Ehtml&rediffng=0>
>
>
>
> Regards,
>
> /julian
>
>
>
> *Fra:* Srikanth [mailto:srikanth1...@gmail.com]
> *Sendt:* 10. januar 2017 11:39
> *Til:* geoserver-users 
> <geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
> *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<//prolinks.rediffmailpro.com/cgi-bin/prored.cgi?red=www%2Eservetheneedy%2Eorg&rediffng=0>
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 3
Date: Tue, 10 Jan 2017 12:00:32 +0000
From: Julian Hollingbery <jul...@northtech.dk<mailto:jul...@northtech.dk>>
Subject: Re: [Geoserver-users] WMS and Other Web Service Integration
To: Srikanth <srikanth1...@gmail.com<mailto:srikanth1...@gmail.com>>, 
geoserver-users
   
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
Message-ID:
   
<db6pr0502mb2902760880f55f8c94e56798bb...@db6pr0502mb2902.eurprd05.prod.outlook.com<mailto:db6pr0502mb2902760880f55f8c94e56798bb...@db6pr0502mb2902.eurprd05.prod.outlook.com>>

Content-Type: text/plain; charset="utf-8"

Have you tried GetFeatureInfo?
http://docs.geoserver.org/stable/en/user/services/wms/reference.html<//prolinks.rediffmailpro.com/cgi-bin/prored.cgi?red=http%3A%2F%2Fdocs%2Egeoserver%2Eorg%2Fstable%2Fen%2Fuser%2Fservices%2Fwms%2Freference%2Ehtml&rediffng=0>

Regards,
/julian

Fra: Srikanth [mailto:srikanth1...@gmail.com]
Sendt: 10. januar 2017 11:39
Til: geoserver-users 
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
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.
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 4
Date: Tue, 10 Jan 2017 12:29:55 +0000
From: Julian Hollingbery <jul...@northtech.dk<mailto:jul...@northtech.dk>>
Subject: Re: [Geoserver-users] WMS and Other Web Service Integration
To: Srikanth <srikanth1...@gmail.com<mailto:srikanth1...@gmail.com>>
Cc: geoserver-users 
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
Message-ID:
   
<db6pr0502mb29024a70c3997bd3e6c1c224bb...@db6pr0502mb2902.eurprd05.prod.outlook.com<mailto:db6pr0502mb29024a70c3997bd3e6c1c224bb...@db6pr0502mb2902.eurprd05.prod.outlook.com>>

Content-Type: text/plain; charset="utf-8"

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:srikanth1...@gmail.com]
Sendt: 10. januar 2017 13:09
Til: Julian Hollingbery <jul...@northtech.dk<mailto:jul...@northtech.dk>>
Cc: geoserver-users 
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
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 
<jul...@northtech.dk<mailto:jul...@northtech.dk<mailto:jul...@northtech.dk%3cmailto:jul...@northtech.dk>>>
 wrote:
Have you tried GetFeatureInfo?
http://docs.geoserver.org/stable/en/user/services/wms/reference.html<//prolinks.rediffmailpro.com/cgi-bin/prored.cgi?red=http%3A%2F%2Fdocs%2Egeoserver%2Eorg%2Fstable%2Fen%2Fuser%2Fservices%2Fwms%2Freference%2Ehtml&rediffng=0>

Regards,
/julian

Fra: Srikanth 
[mailto:srikanth1...@gmail.com<mailto:srikanth1...@gmail.com><mailto:srikanth1...@gmail.com%3cmailto:srikanth1...@gmail.com%3e>]
Sendt: 10. januar 2017 11:39
Til: geoserver-users 
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net%3cmailto:geoserver-users@lists.sourceforge.net>>>
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<http://www.servetheneedy.org><http://www.servetheneedy.org>
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

------------------------------------------------------------------------------
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<//prolinks.rediffmailpro.com/cgi-bin/prored.cgi?red=http%3A%2F%2Fsdm%2Elink%2Fxeonphi&rediffng=0>

------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users<//prolinks.rediffmailpro.com/cgi-bin/prored.cgi?red=https%3A%2F%2Flists%2Esourceforge%2Enet%2Flists%2Flistinfo%2Fgeoserver%2Dusers&rediffng=0>


End of Geoserver-users Digest, Vol 128, Issue 11
************************************************
------------------------------------------------------------------------------
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to