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: ‘geoserver-users@lists.sourceforge.net’
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
gaps in wms images.zip (127 KB)