Dear Andrea and Brad, Thanks for responding and suggestions
As per my understanding when we are publishing postgresql table in Geoserver 2.7.4, some have misinterpreted the-geom type and it is showing as Geometry and assigned default point SLD. GeoServer assigning for all the PostgreSQL/PostGIS tables(point/polygon/line) published layers to default SLD. I have tested by deploying separate GeoServer 2.7.4 Instance and PostgreSQL 10.6/PostGIS 2.5.2 Instance and the result is same. If we use PostgreSQL9.6/9.2 and if we publish the PostgreSQL table in GeoServer 2.7.4 , it is assigning proper SLD based on PostgreSQL table geometry type Now I understand that, *GeoServer 2.7.4 not able to find the proper 'the_geom' type form PostgreSQL10.6 table geometry type and assigning default point sld to every table* * Is it possible to find the in GeoServer2.7.4, which part of the code deals with PostgreSQL table layer publishing? Kindly help me in this regard.* *Thanks&Regards,* *Naresh* On Thu, Apr 25, 2019 at 11:44 AM Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Wed, Apr 24, 2019 at 2:21 PM Naresh N <naresh...@gmail.com> wrote: > >> Dear Brad, >> Thanks for quick response. >> 1. I am deploying GeoNode 2.4 version which has customized version of >> GeoServer which is 2.7.4. So I can not upgrade to higher version of >> GeoServer. >> > > As Brad said, upgrade if you can, you're running on a really old version, > hard to get any support for it (free or otherwise), I believe the current > stable is 2.8. > > >> 2. In database after uploading shape file 9f type polygon , i have >> verified geom column type it showing as property with multi polygon. >> > > The open shapefile specification ( > https://www.esri.com/library/whitepapers/pdfs/shapefile.pdf) has no > distinction between polygon and multipolygon, > so the code defaults to multipolygon. ESRI might have added some extra > sidecar file with a better description, but if there is any such file, > GeoTools (the library reading the shapefile) cannot read it. > > As per my understanding when we are publishing postgresql table in >> Geoserver 2.7.4, some have misinterpreted the-geom type and it is showing >> as Geometry and assigned default point SLD. >> > > This seems to be unlikely, the default style selector picks the "polygon" > style for both simple and multi-polygons. But then again, I don't know how > GeoNode interacts with GeoServer so maybe it's not using the GeoServer > defaults and doing its own custom thing, you should ask on the GeoNode > lists. > Or maybe someone modified the style, by SLD rules a polygon is to be > depicted as a point if the style uses a point symbolizer. > > Cheers > Andrea > > == > > 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 > ------------------------------------------------------- *Con riferimento > alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - > Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni > circostanza inerente alla presente email (il suo contenuto, gli eventuali > allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i > destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per > errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le > sarei comunque grato se potesse darmene notizia. This email is intended > only for the person or entity to which it is addressed and may contain > information that is privileged, confidential or otherwise protected from > disclosure. We remind that - as provided by European Regulation 2016/679 > “GDPR” - copying, dissemination or use of this e-mail or the information > herein by anyone other than the intended recipient is prohibited. If you > have received this email by mistake, please notify us immediately by > telephone or e-mail.* >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users