It seems that there is a bug in GeoServer SQL view creation which resulted in 
slow rendering of images and some image never appeared on the browser. The 
issue resolved by creating oracle views and publishing layer using that oracle 
view.

Does anyone know if there is an outstanding issue regarding this?

Regards,
Manish

From: Barapatre,M,Manish,TAL4 C
Sent: 21 February 2013 11:33
To: '[email protected]'
Subject: RE: Gaps in data from WMS images

Hi,

I created a sql view in geoserver to publish a layer something like below
SELECT * FROM CABLE  WHERE(CATEGORY_NAME NOT IN ('FIBER','FIBRE') AND TYPE_NAME 
NOT IN ('FIBRE', 'FIBER'))

Can this hamper WMS? Do I need to take care of anything else while creating a 
view? Some tile are not getting render when I do this..see attached.

Regards,
Manish Barapatre

From: Barapatre,M,Manish,TAL4 C
Sent: 20 February 2013 14:49
To: '[email protected]'
Subject: FW: Gaps in data from WMS images

Hi,

We are finding that segments of our network data from the database are being 
excluded from the images generated by the WMS. The extent of missing data is 
different  in different zoom scales. The attached images highlights the same. 
The image shows two WMS services (one is yellow and other is black). There 
layers are published from a oracle spatial table using GeoServer. GeoHUB server 
applies some clauses to filter out some data from WMS. It will be fare to say 
these layers arebased on a view from GeoServer on top of oracle table.

Currently we have our OpenLayers application calling network data overlays as a 
set of tiled images 256 x 256 pixels. In some cases, parts of features close to 
the edge of each tile are not being rendered.

If I publish the oracle table without creating a view and without creating a 
filter in GeoServer the gaps in images do not appear.

Can you suggest a reason why this may be happening?    This behaviour seems 
somewhat inconsistent, it does not happen for all features intersecting the 
tile boundaries, but seemingly on every map refresh there is at least one patch 
of missing data.  I would be very grateful for any inputs on this problem and 
also our other observation that features seem to disappear altogether when we 
zoom in very close.

Many thanks and best regards

Regards,
Manish Barapatre

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to