Re: [Geoserver-users] Shapfile of type polygon showing point features in WMS

[Naresh N]

Naresh N 
Thu, Apr 25, 4:57 PM (16 hours ago)
to me
Dear Andrea,
I have found the code in the link
https://github.com/geotools/geotools/blob/13.4/modules/plugin/jdbc/jdbc-postgis/src/main/java/org/geotools/data/postgis/PostGISDialect.java
and
code is as follows

  String geomType = CLASS_TO_TYPE_MAP.get(gd.getType().getBinding());
if (geomType == null) {
geomType = "GEOMETRY";
}

If I want to do the changes and debug (like printing or alert messages) the
code , where do we can see the log/print messages in GeoServer?

Thanks,
Naresh



On Thu, Apr 25, 2019 at 3:34 PM Naresh N  wrote:

> Dear Andrea,
>
> Thanks a lot for your quick response.
>
> Thanks,
> Naresh
>
> On Thu, Apr 25, 2019 at 2:54 PM Andrea Aime 
> wrote:
>
>> On Thu, Apr 25, 2019 at 11:19 AM Naresh N  wrote:
>>
>>> * 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.*
>>>
>>
>> GeoServer 2.7.4 source code is here:
>> https://github.com/geoserver/geoserver/tree/2.7.4
>> It depends on a GeoTools 13.4, source code here:
>> https://github.com/geotools/geotools/tree/13.4
>>
>> The code you're looking for is quite likely in this module:
>>
>> https://github.com/geotools/geotools/tree/13.4/modules/plugin/jdbc/jdbc-postgis/src/main/java/org/geotools/data/postgis
>>
>> Good luck!
>>
>> 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

Re: [Geoserver-users] SQL Server Store

[Matt Barclay]

Hi Peter,

I just started using SQL Server with GeoServer (2.15.0).  What worked for
me was grabbing the latest MS JDBC driver:

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

Make sure that goes in your webapps/geoserver/WEB-INF/lib directory along
side the gt-jdbc-sqlserver extension.  After a restart, you should see SQL
Server on the "Add new Store" page.

But also check your console log to see if there are any exceptions being
thrown due to missing libraries.  I hit more than a few issues where the MS
JDBC driver wanted some other library installed.

Regards,
Matt


On Thu, Apr 25, 2019 at 1:35 PM Parker, Peter R (OIT) <
peter.par...@alaska.gov> wrote:

> Using GeoServer 2.14.3 running on RedHat Linux. Installed the appropriate
> SQL Server Drivers (sqljdbc42.jar and gt-jdbc-sqlserver-20.3.jar ) but when
> I go to the Stores Admin in the UI I do not see an option for MS SQL
> Server.
>
> I use Oracle as well and  with those driver installed, I see the Vector
> Datasource for Oracle in the Stores – New data source page.
>
> Any ideas why I am not seeing the SQL Server option? Thank you!  Peter
> ___
> 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
>
___
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

[Geoserver-users] GeoFence updates

[Jim Hughes]

Hi all,

From the State of GeoServer talk, I saw that the internal-to-GeoServer 
version of GeoFence has received a number of improvements.  Is the 
external web-app version of GeoFence still intended to be supported as 
well going forward?


I'm curious since managing the access separate from administering 
GeoServer seems like a good use case.  That said, if there's a way to 
set up 'GeoFence admins' in GeoServer and avoid issues like 
https://github.com/geoserver/geofence/issues/9 (securing the GeoFence 
REST api), I'd be all ears.


Cheers,

Jim



___
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

[Geoserver-users] SQL Server Store

[Parker, Peter R (OIT)]

Using GeoServer 2.14.3 running on RedHat Linux. Installed the appropriate SQL 
Server Drivers (sqljdbc42.jar and gt-jdbc-sqlserver-20.3.jar ) but when I go to 
the Stores Admin in the UI I do not see an option for MS SQL Server.
I use Oracle as well and  with those driver installed, I see the Vector 
Datasource for Oracle in the Stores - New data source page.
Any ideas why I am not seeing the SQL Server option? Thank you!  Peter
___
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

Re: [Geoserver-users] /data directory not writeable

[Russ Hore]

# ls -ld /data
drwxrwxrwx 2 tomcat tomcat 4096 Apr 25 15:10 /data


For info.,

# ps -efl |grep tomcat
4 S tomcat1232 1 49  80   0 - 1716271 futex_ 16:49 ?  00:00:46 
/usr/lib/jvm/default-java/bin/java 
-Djava.util.logging.config.file=/var/lib/tomcat9/conf/logging.properties 
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 
-Djava.awt.headless=true -XX:+UseG1GC -Djdk.tls.ephemeralDHKeySize=2048 
-Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
-Dorg.apache.catalina.security.SecurityListener.UMASK=0027 
-DGEOSERVER_DATA_DIR=/data -Dignore.endorsed.dirs= -classpath 
/usr/share/tomcat9/bin/bootstrap.jar:/usr/share/tomcat9/bin/tomcat-juli.jar 
-Dcatalina.base=/var/lib/tomcat9 -Dcatalina.home=/usr/share/tomcat9 
-Djava.io.tmpdir=/tmp org.apache.catalina.startup.Bootstrap start

Russ

> On 25 Apr 2019, at 17:22, Ian Turton  wrote:
> 
> can you paste the result of "ls -ld /data" in here, I suspect that is isn't 
> what you think it is
> 
> Ian
> 
> On Thu, 25 Apr 2019 at 17:05, Russ Hore  > wrote:
> I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9, 
> installed OpenJDK 11 and installed GS 2.15
> 
> I have a folder called /data to which I point GeoServer by editing web.xml
> 
>
>GEOSERVER_DATA_DIR
>/data/
> 
> 
> Now when I start GeoServer I get an error in /var/log/syslog saying /data is 
> not writeable !
> 
> Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR 
> [storage.DefaultStorageFinder] - Found Servlet context parameter 
> GEOSERVER_DATA_DIR set to /data/ , which is not writeable
> 
> Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat with 
> permissions 777 (I know that is not the best but I am trying to get things 
> working)
> 
> I have tried setting the data folder in her setclasspath.sh
> 
> CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
> 
> But I get the same error.
> 
> Has anybody else seen this?
> 
> Russ
> ___
> 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 
> 
> 
> 
> -- 
> Ian Turton

___
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

Re: [Geoserver-users] /data directory not writeable

[Ian Turton]

can you paste the result of "ls -ld /data" in here, I suspect that is isn't
what you think it is

Ian

On Thu, 25 Apr 2019 at 17:05, Russ Hore  wrote:

> I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9,
> installed OpenJDK 11 and installed GS 2.15
>
> I have a folder called /data to which I point GeoServer by editing web.xml
>
>
>GEOSERVER_DATA_DIR
>/data/
> 
>
> Now when I start GeoServer I get an error in /var/log/syslog saying /data
> is not writeable !
>
> Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR
> [storage.DefaultStorageFinder] - Found Servlet context parameter
> GEOSERVER_DATA_DIR set to /data/ , which is not writeable
>
> Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat
> with permissions 777 (I know that is not the best but I am trying to get
> things working)
>
> I have tried setting the data folder in her setclasspath.sh
>
> CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
>
> But I get the same error.
>
> Has anybody else seen this?
>
> Russ
> ___
> 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
>


-- 
Ian Turton
___
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

Re: [Geoserver-users] /data directory not writeable

[Vera Green]

Sorry...you said. I can't recall 100% but the 777might be causing the issue.

On Thu, Apr 25, 2019, 10:19 AM Vera Green  wrote:

> Who's the owner of the data folder? I think it has to be tomcat...chown
> tomcat:tomcat data.
>
> On Thu, Apr 25, 2019, 10:03 AM Russ Hore  wrote:
>
>> I have just done a clean installation of Ubuntu 19.04, installed Tomcat
>> 9, installed OpenJDK 11 and installed GS 2.15
>>
>> I have a folder called /data to which I point GeoServer by editing web.xml
>>
>>
>>GEOSERVER_DATA_DIR
>>/data/
>> 
>>
>> Now when I start GeoServer I get an error in /var/log/syslog saying /data
>> is not writeable !
>>
>> Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR
>> [storage.DefaultStorageFinder] - Found Servlet context parameter
>> GEOSERVER_DATA_DIR set to /data/ , which is not writeable
>>
>> Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat
>> with permissions 777 (I know that is not the best but I am trying to get
>> things working)
>>
>> I have tried setting the data folder in her setclasspath.sh
>>
>> CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
>>
>> But I get the same error.
>>
>> Has anybody else seen this?
>>
>> Russ
>> ___
>> 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
>>
>
___
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

Re: [Geoserver-users] /data directory not writeable

[Vera Green]

Who's the owner of the data folder? I think it has to be tomcat...chown
tomcat:tomcat data.

On Thu, Apr 25, 2019, 10:03 AM Russ Hore  wrote:

> I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9,
> installed OpenJDK 11 and installed GS 2.15
>
> I have a folder called /data to which I point GeoServer by editing web.xml
>
>
>GEOSERVER_DATA_DIR
>/data/
> 
>
> Now when I start GeoServer I get an error in /var/log/syslog saying /data
> is not writeable !
>
> Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR
> [storage.DefaultStorageFinder] - Found Servlet context parameter
> GEOSERVER_DATA_DIR set to /data/ , which is not writeable
>
> Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat
> with permissions 777 (I know that is not the best but I am trying to get
> things working)
>
> I have tried setting the data folder in her setclasspath.sh
>
> CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"
>
> But I get the same error.
>
> Has anybody else seen this?
>
> Russ
> ___
> 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
>
___
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

[Geoserver-users] /data directory not writeable

[Russ Hore]

I have just done a clean installation of Ubuntu 19.04, installed Tomcat 9, 
installed OpenJDK 11 and installed GS 2.15

I have a folder called /data to which I point GeoServer by editing web.xml

   
   GEOSERVER_DATA_DIR
   /data/


Now when I start GeoServer I get an error in /var/log/syslog saying /data is 
not writeable !

Apr 25 15:14:05 hostname tomcat9[13480]: 25 Apr 15:14:05 ERROR 
[storage.DefaultStorageFinder] - Found Servlet context parameter 
GEOSERVER_DATA_DIR set to /data/ , which is not writeable

Tomcat is running as user ‘tomcat’. The /data folder is owned by tomcat with 
permissions 777 (I know that is not the best but I am trying to get things 
working)

I have tried setting the data folder in her setclasspath.sh

CATALINA_OPTS="-DGEOSERVER_DATA_DIR=/data"

But I get the same error.

Has anybody else seen this?

Russ___
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

[Geoserver-users] JMS vs. Hazelcast

[Jason Cradit]

Hello all,

I'm looking for recommendations on clustering 2+ Geoservers together.  I'll
be building this in AWS and putting them behind a load balancer.  I have
tools like EFS to create a shared data directory and RDS to build JDBC.  We
really want this to be a pretty elastic environment to scale based on load.

So my use-case is one where I want all Geoservers to respond to the load
balancer with the same data.  Like, if we change the Style of a layer on
one Geoserver, all Geoservers know about it and respond with the update.

I've built Hazelcast and it seems to work well.  My only issue is around
the down operations.  Since we can't use multicast for joining, i'm
building the tcp-ip field in the hazelcast.xml file dynamically at build
time.  Works pretty well, but i'd be open to suggestions here.  Also,
interested as it feels like it's not heavily maintained in the community.
Am I just out of touch here?  It seems like Boundless was the primary
driver behind this, historically.

I haven't built JMS, but reading the documentation it looks pretty complex
for what we are trying to do I'm concerned about resiliency in an elastic
environment and any guidance for building it in AWS with AmazonMQ.  This
feels more of the mainstream clustering option for Geoserver from what i've
read.

I appreciate all your input and guidance.

Thanks,
Jason
___
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

Re: [Geoserver-users] Shapfile of type polygon showing point features in WMS

[Naresh N]

Dear Andrea,

Thanks a lot for your quick response.

Thanks,
Naresh

On Thu, Apr 25, 2019 at 2:54 PM Andrea Aime 
wrote:

> On Thu, Apr 25, 2019 at 11:19 AM Naresh N  wrote:
>
>> * 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.*
>>
>
> GeoServer 2.7.4 source code is here:
> https://github.com/geoserver/geoserver/tree/2.7.4
> It depends on a GeoTools 13.4, source code here:
> https://github.com/geotools/geotools/tree/13.4
>
> The code you're looking for is quite likely in this module:
>
> https://github.com/geotools/geotools/tree/13.4/modules/plugin/jdbc/jdbc-postgis/src/main/java/org/geotools/data/postgis
>
> Good luck!
>
> 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

Re: [Geoserver-users] Shapfile of type polygon showing point features in WMS

[Andrea Aime]

On Thu, Apr 25, 2019 at 11:19 AM Naresh N  wrote:

> * 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.*
>

GeoServer 2.7.4 source code is here:
https://github.com/geoserver/geoserver/tree/2.7.4
It depends on a GeoTools 13.4, source code here:
https://github.com/geotools/geotools/tree/13.4

The code you're looking for is quite likely in this module:
https://github.com/geotools/geotools/tree/13.4/modules/plugin/jdbc/jdbc-postgis/src/main/java/org/geotools/data/postgis

Good luck!

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

Re: [Geoserver-users] Shapfile of type polygon showing point features in WMS

[Naresh N]

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,*
*Naresh*




On Thu, Apr 25, 2019 at 11:44 AM Andrea Aime 
wrote:

> On Wed, Apr 24, 2019 at 2:21 PM Naresh N  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

Re: [Geoserver-users] Shapfile of type polygon showing point features in WMS

[Andrea Aime]

On Wed, Apr 24, 2019 at 2:21 PM Naresh N  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