Re: [Geoserver-users] Geoserver Web-Mapping
Hello! The GeoServer project has instructions for running from Eclipse (so I would use that because there is an example to follow). http://docs.geoserver.org/latest/en/developer/eclipse-guide/ -- Jody Garnett On 8 May 2015 at 14:54, ELKHATTABI Imane wrote: > Hello Jody > > I came across one of your posts on the How2map plateform. > > I really hope you don't mind me asking. But I'm in a same situation where > i need to run a Geoserver web-mapping project directly from an IDE like > Netbeans or Eclipse. > > I don't know witch IDE to use that can easily run Geoserver with libraries > (Openlayers, Ext, geoExt) > > I'd be very thankful to know how to overcome the problem . > > Any hint or help would be highly apreciated. > > Best regards > ᐧ > -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed in Geoserver
Stefano, I am going to do two tests. Publishing without the GeoserverRest and via the GeoserverRest. I’ll let you know. Best regards Anneliese Brouwer Van: Stefano Costa [mailto:stefano.co...@geo-solutions.it] Verzonden: woensdag 13 mei 2015 19:24 Aan: Rahkonen Jukka (MML) CC: Anneliese Brouwer | Crotec B.V.; geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed in Geoserver I finally managed to run GeoServer 1.6.2 on a VM, I published your shape file and I can see all the characters correctly: [cid:image001.png@01D08DB3.1A40EF70] So... not sure why it doesn't work for you... or it doesn't work only when you publish the layer via the rest interface? Regards, --S Il giorno mer, 13/05/2015 alle 17.17 +, Rahkonen Jukka (MML) ha scritto: Hi, Perhaps off-topic, but I would like to see stronger proof about ISO8859-1 being mandated in DBF or shapefiles. From the dBase history http://www.eweek.com/database/30-years-ago-the-rise-fall-and-survival-of-ashton-tates-dbase-2.html it appears that dBase II came in 1981, dBase III in 1984, and dBase IV 1988. On the other hand, in article http://en.wikipedia.org/wiki/ISO/IEC_8859-1 we are told that the standard is three years younger than dBase III: "ISO/IEC 8859-1:1998, Information technology — 8-bit single-byte coded graphic character sets — Part 1: Latin alphabet No. 1, is part of the ISO/IEC 8859 series of ASCII-based standard character encodings, first edition published in 1987." The shapefile specification http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf does not speak anything about codepages and very little about dbf, not even which dbf version should be used. In all shapefiles I have had a closer look the dbf part is marked to be version III in the headers. A blog http://dbaseblogs.com/kkolosky/2012/07/11/code-page-and-dbase-for-dos-system-is-not-configured-for-current-code-page/ shows that dBase IV 2.0 supported DOS codepages 437 and 850, http://en.wikipedia.org/wiki/Code_page_437 and http://en.wikipedia.org/wiki/Code_page_850. So no support for ISO8859-1 at all in a native dBase product. Well, I think I could have used my time better by trying to find something helpful for Anneliese instead of correcting an error in the Internet. -Jukka Rahkonen- Stefano Costa wrote: OK, now the picture is clearer. I can't try the Shapefile you generated with Geoserver 1.6 (as I said, it stubbornly refuses to start on my machine), but I tested it in GS 2.6.2 and it works fine, so I'm pretty confident your file is correct. I know that the Shapefile specification mandated ISO8859-1 charset be used in DBF files (see: http://gis.stackexchange.com/questions/3529/which-character-encoding-is-used-by-the-dbf-file-in-shapefiles), so probably GS 1.6 followed closely the standard and assumed any DBF file was encoded in ISO8859-1. I can't know for sure though, it's just a guess. Please always use the "Reply to all" button or the other people on the list won't be able to follow along and help you. Best regards, Stefano Il giorno mer, 13/05/2015 alle 15.23 +, Anneliese Brouwer|Crotec B.V. ha scritto: > Stefano, > > We have a web application in which we use Geoserver and OpenLayers. > The user can select a gml file. In code we upload the file, create json file, > with gdal we create the shape files (geometry types can be point, line, > region) , and with geoserverrest we create datastore and layers in Geoserver. > > Yes, I did try UTF-8. In some messages on the Internet about the issue people > mention ISO-8859-1. So I tried that one also. > > Thanks for the help. > > Best regards > > Anneliese Brouwer > Ontwikkelaar > > > > > > > -Oorspronkelijk bericht- > Van: Stefano Costa [mailto:stefano.co...@geo-solutions.it] > Verzonden: woensdag 13 mei 2015 16:57 > Aan: Anneliese Brouwer | Crotec B.V. > Onderwerp: Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed > in Geoserver > > Hi Anneliese, > > > > > I did some modifications in my code (C#) but still not seeing the'≤' > > chars. > > > > (Geoserver 1.6.0). > > Wow, quite an ancient version of GeoServer you've got there, I wasn't even > able to make it start on my machine. :-) > > > ISO-8859-1 > > > > > Did you try using UTF-8 as charset: > > UTF-8 > > Also, I'm wondering why you are using the REST interface to create / > configure datastores instead of the web admin interface... > > Best, > Stefano > > -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://
Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed in Geoserver
I finally managed to run GeoServer 1.6.2 on a VM, I published your shape file and I can see all the characters correctly: So... not sure why it doesn't work for you... or it doesn't work only when you publish the layer via the rest interface? Regards, --S Il giorno mer, 13/05/2015 alle 17.17 +, Rahkonen Jukka (MML) ha scritto: > Hi, > > Perhaps off-topic, but I would like to see stronger proof about ISO8859-1 > being mandated in DBF or shapefiles. > > From the dBase history > http://www.eweek.com/database/30-years-ago-the-rise-fall-and-survival-of-ashton-tates-dbase-2.html > it appears that dBase II came in 1981, dBase III in 1984, and dBase IV 1988. > On the other hand, in article http://en.wikipedia.org/wiki/ISO/IEC_8859-1 we > are told that the standard is three years younger than dBase III: > "ISO/IEC 8859-1:1998, Information technology — 8-bit single-byte coded > graphic character sets — Part 1: Latin alphabet No. 1, is part of the ISO/IEC > 8859 series of ASCII-based standard character encodings, first edition > published in 1987." > > The shapefile specification > http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf does not speak > anything about codepages and very little about dbf, not even which dbf > version should be used. In all shapefiles I have had a closer look the dbf > part is marked to be version III in the headers. > > A blog > http://dbaseblogs.com/kkolosky/2012/07/11/code-page-and-dbase-for-dos-system-is-not-configured-for-current-code-page/ > shows that dBase IV 2.0 supported DOS codepages 437 and 850, > http://en.wikipedia.org/wiki/Code_page_437 and > http://en.wikipedia.org/wiki/Code_page_850. So no support for ISO8859-1 at > all in a native dBase product. > > Well, I think I could have used my time better by trying to find something > helpful for Anneliese instead of correcting an error in the Internet. > > -Jukka Rahkonen- > > Stefano Costa wrote: > > OK, now the picture is clearer. > > I can't try the Shapefile you generated with Geoserver 1.6 (as I said, > it stubbornly refuses to start on my machine), but I tested it in GS > 2.6.2 and it works fine, so I'm pretty confident your file is correct. > > I know that the Shapefile specification mandated ISO8859-1 charset be > used in DBF files (see: > http://gis.stackexchange.com/questions/3529/which-character-encoding-is-used-by-the-dbf-file-in-shapefiles), > so probably GS 1.6 followed closely the standard and assumed any DBF file > was encoded in ISO8859-1. > I can't know for sure though, it's just a guess. > > Please always use the "Reply to all" button or the other people on the > list won't be able to follow along and help you. > > Best regards, > Stefano > > > Il giorno mer, 13/05/2015 alle 15.23 +, Anneliese Brouwer|Crotec > B.V. ha scritto: > > Stefano, > > > > We have a web application in which we use Geoserver and OpenLayers. > > The user can select a gml file. In code we upload the file, create json > > file, with gdal we create the shape files (geometry types can be point, > > line, region) , and with geoserverrest we create datastore and layers in > > Geoserver. > > > > Yes, I did try UTF-8. In some messages on the Internet about the issue > > people mention ISO-8859-1. So I tried that one also. > > > > Thanks for the help. > > > > Best regards > > > > Anneliese Brouwer > > Ontwikkelaar > > > > > > > > > > > > > > -Oorspronkelijk bericht- > > Van: Stefano Costa [mailto:stefano.co...@geo-solutions.it] > > Verzonden: woensdag 13 mei 2015 16:57 > > Aan: Anneliese Brouwer | Crotec B.V. > > Onderwerp: Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not > > showed in Geoserver > > > > Hi Anneliese, > > > > > > > > I did some modifications in my code (C#) but still not seeing the'≤' > > > chars. > > > > > > (Geoserver 1.6.0). > > > > Wow, quite an ancient version of GeoServer you've got there, I wasn't even > > able to make it start on my machine. :-) > > > > > ISO-8859-1 > > > > > > > > > Did you try using UTF-8 as charset: > > > > UTF-8 > > > > Also, I'm wondering why you are using the REST interface to create / > > configure datastores instead of the web admin interface... > > > > Best, > > Stefano > > > > > > > > -- > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- One dashboard for
Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed in Geoserver
Hi, Perhaps off-topic, but I would like to see stronger proof about ISO8859-1 being mandated in DBF or shapefiles. From the dBase history http://www.eweek.com/database/30-years-ago-the-rise-fall-and-survival-of-ashton-tates-dbase-2.html it appears that dBase II came in 1981, dBase III in 1984, and dBase IV 1988. On the other hand, in article http://en.wikipedia.org/wiki/ISO/IEC_8859-1 we are told that the standard is three years younger than dBase III: "ISO/IEC 8859-1:1998, Information technology ― 8-bit single-byte coded graphic character sets ― Part 1: Latin alphabet No. 1, is part of the ISO/IEC 8859 series of ASCII-based standard character encodings, first edition published in 1987." The shapefile specification http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf does not speak anything about codepages and very little about dbf, not even which dbf version should be used. In all shapefiles I have had a closer look the dbf part is marked to be version III in the headers. A blog http://dbaseblogs.com/kkolosky/2012/07/11/code-page-and-dbase-for-dos-system-is-not-configured-for-current-code-page/ shows that dBase IV 2.0 supported DOS codepages 437 and 850, http://en.wikipedia.org/wiki/Code_page_437 and http://en.wikipedia.org/wiki/Code_page_850. So no support for ISO8859-1 at all in a native dBase product. Well, I think I could have used my time better by trying to find something helpful for Anneliese instead of correcting an error in the Internet. -Jukka Rahkonen- Stefano Costa wrote: OK, now the picture is clearer. I can't try the Shapefile you generated with Geoserver 1.6 (as I said, it stubbornly refuses to start on my machine), but I tested it in GS 2.6.2 and it works fine, so I'm pretty confident your file is correct. I know that the Shapefile specification mandated ISO8859-1 charset be used in DBF files (see: http://gis.stackexchange.com/questions/3529/which-character-encoding-is-used-by-the-dbf-file-in-shapefiles), so probably GS 1.6 followed closely the standard and assumed any DBF file was encoded in ISO8859-1. I can't know for sure though, it's just a guess. Please always use the "Reply to all" button or the other people on the list won't be able to follow along and help you. Best regards, Stefano Il giorno mer, 13/05/2015 alle 15.23 +, Anneliese Brouwer|Crotec B.V. ha scritto: > Stefano, > > We have a web application in which we use Geoserver and OpenLayers. > The user can select a gml file. In code we upload the file, create json file, > with gdal we create the shape files (geometry types can be point, line, > region) , and with geoserverrest we create datastore and layers in Geoserver. > > Yes, I did try UTF-8. In some messages on the Internet about the issue people > mention ISO-8859-1. So I tried that one also. > > Thanks for the help. > > Best regards > > Anneliese Brouwer > Ontwikkelaar > > > > > > > -Oorspronkelijk bericht- > Van: Stefano Costa [mailto:stefano.co...@geo-solutions.it] > Verzonden: woensdag 13 mei 2015 16:57 > Aan: Anneliese Brouwer | Crotec B.V. > Onderwerp: Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed > in Geoserver > > Hi Anneliese, > > > > > I did some modifications in my code (C#) but still not seeing the'≤' > > chars. > > > > (Geoserver 1.6.0). > > Wow, quite an ancient version of GeoServer you've got there, I wasn't even > able to make it start on my machine. :-) > > > ISO-8859-1 > > > > > Did you try using UTF-8 as charset: > > UTF-8 > > Also, I'm wondering why you are using the REST interface to create / > configure datastores instead of the web admin interface... > > Best, > Stefano > > -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Oracle View Problem
Also see this page, which gives a good example of using the function-based index technique: http://gis.stackexchange.com/questions/92554/can-i-create-an-oracle-spatial-view-from-a-non-spatial-table That page also mentions the possiblity of defining a *materialized view* on the underlying table, which should be able to support a spatial index directly. On Wed, May 13, 2015 at 9:27 AM, Martin Davis wrote: > Have you tried creating a spatial function-based index on the table? > > > http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_exten.htm#SPATL799 > > See the example 9.2.1 - it creates a function creating the geometry out of > the X,Y values, and then uses that for indexing and querying. Hopefully > it's possible to define a view hiding the existence of the function, but > still using the spatial index. In this case, GeoServer might be able to > query the view (using SDO_FILTER as per normal) and Oracle will support the > query since it can use the index. > > Ironically, in my experience when working with tables containing XY data, > it's at least as fast to simply use normal B-tree indexes and range > queries. However, it doesn't sound like this can be made to work in > GeoServer (yet...) > > > > On Wed, May 13, 2015 at 7:10 AM, Alper Dinçer > wrote: > >> Hi, >> >> We have a table that includes X and Y columns for latitude and >> longitudes. We created a view with geom column from this table as follows : >> >> (SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE (ST.Y, ST.X, NULL), NULL, NULL)) >> >> Then we published this view from GeoServer and try to get the WMS >> request. >> >> The WMS request has following error : >> >> > ServiceExceptionReport SYSTEM " >> http://172.16.1.139:8084/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";> >>> code="internalError"> >> Rendering process failed >> java.io.IOExceptionORA-13226: interface not supported without a spatial >> index >> ORA-06512: at "MDSYS.MD", line 1723 >> ORA-06512: at "MDSYS.MDERR", line 8 >> ORA-06512: at "MDSYS.SDO_3GL", line 88 >> >> >> >> As far as I searched, this was a problem in Oracle 9, but we are working >> on 11g. >> >> How can we get rid of this error? There was no luck with creating spatial >> index on views. >> >> >> -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Oracle View Problem
Have you tried creating a spatial function-based index on the table? http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_exten.htm#SPATL799 See the example 9.2.1 - it creates a function creating the geometry out of the X,Y values, and then uses that for indexing and querying. Hopefully it's possible to define a view hiding the existence of the function, but still using the spatial index. In this case, GeoServer might be able to query the view (using SDO_FILTER as per normal) and Oracle will support the query since it can use the index. Ironically, in my experience when working with tables containing XY data, it's at least as fast to simply use normal B-tree indexes and range queries. However, it doesn't sound like this can be made to work in GeoServer (yet...) On Wed, May 13, 2015 at 7:10 AM, Alper Dinçer wrote: > Hi, > > We have a table that includes X and Y columns for latitude and longitudes. > We created a view with geom column from this table as follows : > > (SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE (ST.Y, ST.X, NULL), NULL, NULL)) > > Then we published this view from GeoServer and try to get the WMS request. > > The WMS request has following error : > > ServiceExceptionReport SYSTEM " > http://172.16.1.139:8084/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";> > code="internalError"> > Rendering process failed > java.io.IOExceptionORA-13226: interface not supported without a spatial > index > ORA-06512: at "MDSYS.MD", line 1723 > ORA-06512: at "MDSYS.MDERR", line 8 > ORA-06512: at "MDSYS.SDO_3GL", line 88 > > > > As far as I searched, this was a problem in Oracle 9, but we are working > on 11g. > > How can we get rid of this error? There was no luck with creating spatial > index on views. > > Best. > > A. > > > > -- > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed in Geoserver
OK, now the picture is clearer. I can't try the Shapefile you generated with Geoserver 1.6 (as I said, it stubbornly refuses to start on my machine), but I tested it in GS 2.6.2 and it works fine, so I'm pretty confident your file is correct. I know that the Shapefile specification mandated ISO8859-1 charset be used in DBF files (see: http://gis.stackexchange.com/questions/3529/which-character-encoding-is-used-by-the-dbf-file-in-shapefiles), so probably GS 1.6 followed closely the standard and assumed any DBF file was encoded in ISO8859-1. I can't know for sure though, it's just a guess. Please always use the "Reply to all" button or the other people on the list won't be able to follow along and help you. Best regards, Stefano Il giorno mer, 13/05/2015 alle 15.23 +, Anneliese Brouwer|Crotec B.V. ha scritto: > Stefano, > > We have a web application in which we use Geoserver and OpenLayers. > The user can select a gml file. In code we upload the file, create json file, > with gdal we create the shape files (geometry types can be point, line, > region) , and with geoserverrest we create datastore and layers in Geoserver. > > Yes, I did try UTF-8. In some messages on the Internet about the issue people > mention ISO-8859-1. So I tried that one also. > > Thanks for the help. > > Best regards > > Anneliese Brouwer > Ontwikkelaar > > > > > > > -Oorspronkelijk bericht- > Van: Stefano Costa [mailto:stefano.co...@geo-solutions.it] > Verzonden: woensdag 13 mei 2015 16:57 > Aan: Anneliese Brouwer | Crotec B.V. > Onderwerp: Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed > in Geoserver > > Hi Anneliese, > > > > > I did some modifications in my code (C#) but still not seeing the'≤' > > chars. > > > > (Geoserver 1.6.0). > > Wow, quite an ancient version of GeoServer you've got there, I wasn't even > able to make it start on my machine. :-) > > > ISO-8859-1 > > > > > Did you try using UTF-8 as charset: > > UTF-8 > > Also, I'm wondering why you are using the REST interface to create / > configure datastores instead of the web admin interface... > > Best, > Stefano > > -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Oracle View Problem
Hi Alper, nope, as far as I know, the problem is still there, known issue, we cannot query data that does not have a spatial index: https://osgeo-org.atlassian.net/browse/GEOT-4768 Some development is needed to recognize the source has no spatial indexes, and change the spatial operators we use for bbox queries Cheers Andrea On Wed, May 13, 2015 at 4:10 PM, Alper Dinçer wrote: > Hi, > > We have a table that includes X and Y columns for latitude and longitudes. > We created a view with geom column from this table as follows : > > (SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE (ST.Y, ST.X, NULL), NULL, NULL)) > > Then we published this view from GeoServer and try to get the WMS request. > > The WMS request has following error : > > ServiceExceptionReport SYSTEM " > http://172.16.1.139:8084/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";> > code="internalError"> > Rendering process failed > java.io.IOExceptionORA-13226: interface not supported without a spatial > index > ORA-06512: at "MDSYS.MD", line 1723 > ORA-06512: at "MDSYS.MDERR", line 8 > ORA-06512: at "MDSYS.SDO_3GL", line 88 > > > > As far as I searched, this was a problem in Oracle 9, but we are working > on 11g. > > How can we get rid of this error? There was no luck with creating spatial > index on views. > > Best. > > A. > > > > -- > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. --- -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Oracle View Problem
Hi, We have a table that includes X and Y columns for latitude and longitudes. We created a view with geom column from this table as follows : (SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE (ST.Y, ST.X, NULL), NULL, NULL)) Then we published this view from GeoServer and try to get the WMS request. The WMS request has following error : http://172.16.1.139:8084/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";> Rendering process failed java.io.IOExceptionORA-13226: interface not supported without a spatial index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 8 ORA-06512: at "MDSYS.SDO_3GL", line 88 As far as I searched, this was a problem in Oracle 9, but we are working on 11g. How can we get rid of this error? There was no luck with creating spatial index on views. Best. A. -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed in Geoserver
Hi Anneliese,
I just published the SHP you attached in Geoserver 2.6.2 and I can see
'≤' chars correctly displayed in GeoServer's OpenLayers-based preview :
Did you select the correct DBF charset when creating the store in
GeoServer?
Best regards,
Stefano
Il giorno mer, 13/05/2015 alle 01.14 -0700, AnnelieseBrouwer ha scritto:
> Hello community,
>
> It seems as if signs like 'b≤3.2' were not processed properly to dbf/shp
> files.
>
> I create shape files from JSON file with GDAL using the statement:
>
> ds.CopyLayer(srcLayer, fileNameWithoutExtension, null);
>
> or with cpg file:
>
> ds.CopyLayer(srcLayer, fileNameWithoutExtension, new string[] {
> "ENCODING=UTF-8" });
>
> All shape files were created, we can see them in Geoserver Preview
> (OpenLayers).
>
> But we have problems with signs like '≤'.
> In the JSON file those signs are fine but it looks like as if in the dbf
> file these signs were not written properly. Depending on what encoding we
> use in datasource.CopyLayer, you'll see a question mark or something else.
>
> We have tried using the config var. SHAPE_ENCODING but we did not get the
> right result.
>
> We think this is a GDAL issue?
> We need those signs in our website (Geoserver,OpenLayers).
>
> We are using GDAL: x86, gdal-111-1600-core
> Geoserver: 2.6.0
>
> Any idea what could be wrong and how we can solve this problem?
>
> Solve with GDAL?
> Or in Geoserver?
>
> Any feedback is appreciated!
>
> Best regards, A. Brouwer
> JSON_SHAPE.zip
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Signs-like-b-3-2-from-json-dbf-not-showed-in-Geoserver-tp5205499.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
> --
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] User login via PostGreSQL
Hi, This sounds like an error with the authentication to postgres. So I suggest to check the following points: * Check the version of postgres + postgis is not too old * It seems to do the login to the database with user admin, check the connection parameters. * Use GeoServer to create users, better on a clean db, without editing the tables with pgAdmin. 2015-05-12 10:23 GMT+02:00 Bahumut5 : > Hello and thanks for your response. > > - The following steps have been taken: > On Geoserver, I've created a Group Service using the JDBC option and > connected it through localhost (jdbc:postgresql://localhost:5432/Geoserver) > using a postgresql.Driver. The Username/Password I've used in this > connection are for a superuser on the database. The "Create Database > Tables" > has been enabled. > > - I have added users to this database both by adding them via phppgadmin > and > by using the GeoServer. Both worked and both users are seen by the > GeoServer. > > - Created a new Authentication Provider using previous made Group Service > and the same connection via localhost. Added the Authentication Provider to > the Selected Provider Chain. > > Tried logging in via users who were added to the Database Table. Does not > work. > > The following error cause is given when trying to login via a DB user > (Username used was "DB_User_Test"): Caused by: > org.postgresql.util.PSQLException: FATAL: password authentication failed > for > user "admin" > > It seems that GeoServer tried to login via an Admin user. However, I didn't > define this anywhere so I am not sure why it does this. > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/User-login-via-PostGreSQL-tp5204875p5205269.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > > -- > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Regards, Lorenzo Natali == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. == Dott. Ing. Lorenzo Natali Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 333 8128928 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. -- One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y__
[Geoserver-users] Signs like 'b≤3.2' from json/dbf not showed in Geoserver
Hello community,
It seems as if signs like 'b≤3.2' were not processed properly to dbf/shp
files.
I create shape files from JSON file with GDAL using the statement:
ds.CopyLayer(srcLayer, fileNameWithoutExtension, null);
or with cpg file:
ds.CopyLayer(srcLayer, fileNameWithoutExtension, new string[] {
"ENCODING=UTF-8" });
All shape files were created, we can see them in Geoserver Preview
(OpenLayers).
But we have problems with signs like '≤'.
In the JSON file those signs are fine but it looks like as if in the dbf
file these signs were not written properly. Depending on what encoding we
use in datasource.CopyLayer, you'll see a question mark or something else.
We have tried using the config var. SHAPE_ENCODING but we did not get the
right result.
We think this is a GDAL issue?
We need those signs in our website (Geoserver,OpenLayers).
We are using GDAL: x86, gdal-111-1600-core
Geoserver: 2.6.0
Any idea what could be wrong and how we can solve this problem?
Solve with GDAL?
Or in Geoserver?
Any feedback is appreciated!
Best regards, A. Brouwer
JSON_SHAPE.zip
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Signs-like-b-3-2-from-json-dbf-not-showed-in-Geoserver-tp5205499.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
--
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
