[Geoserver-users] CSV and XLS
Hello everyone, Some time ago I was asked if it was possible to import CSV and/or XLS files into Geoserver. This because there was some 3rd party software that was able to just that, but requirements stated Geoserver has to be used for presentation of the data. I'm doing some research on this subject but was wondering what this community has to say on this subject. Would it be an absolute no-go or are there some smart plugins or ways to do this? Has anyone done it before? If so, how? Best regards, Martijn Coenen -- Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Oracle 11
To reply to myself, In a 32-bit situation we use the good-old ojdbc14.jar. In a 64-bit environment we use the new ojdbc6.jar to get successful connections with Oracle 11 and Geoserver. For some reason, when using the ojdbc5- or -6.jar from the 32-bit Oracle Client in a 32-bit situation we run into trouble but the old 14 works great. Regards, Martijn > -Oorspronkelijk bericht- > Van: Martijn Coenen [mailto:mart...@covadis.nl] > Verzonden: maandag 20 augustus 2012 15:57 > Aan: geoserver-users@lists.sourceforge.net > Onderwerp: Re: [Geoserver-users] Oracle 11 > > Hello, here I am again ;) > > Just a quick question for the Oracle 11 users here, any one of you having the > Oracle 11 running on 64-bit server(s)? It seems to go just fine on 32-bit > servers, but geoserver seems to go silent when adding an O11 on 64-bit > store. Using the ojdbc14_g.jar that we already have with "10". > > Regards, > Martijn Coenen > -- > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and threat > landscape has changed and how IT managers can respond. Discussions will > include endpoint security, mobile security and the latest in malware threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Oracle 11
Hello, here I am again ;) Just a quick question for the Oracle 11 users here, any one of you having the Oracle 11 running on 64-bit server(s)? It seems to go just fine on 32-bit servers, but geoserver seems to go silent when adding an O11 on 64-bit store. Using the ojdbc14_g.jar that we already have with "10". Regards, Martijn Coenen -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Oracle 11
Hello everyone, > We have also been using Oracle 11g with GeoServer trunk for years. We > obtained best results using the ojdbc14.jar included with the GeoServer > oracle plugin. (Some users reported occasional strange errors with the > ojdbc5.jar shipped by Oracle; might be coincidence, might not.) Thanks for all the information on this subject via this list and private. We're now running a few test setups with Oracle 11, Geoserver and our applications (via REST). The advice above about ojdbc14.jar seems to be a general one so unless we run into specific problems we'll continue to use this one. Thanks again for the replies! Best regards, Martijn Coenen -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Oracle 11
Good morning world, Until now we use Geoserver 2.1.2 with Oracle 10. We're considering going to Oracle 11. I'm trying to find out if... a) Geoserver 2.1.2 is compatible. >From what I have found here on the list and on the web is that some are using >11 with Geoserver and specifically 2.1.2, so I guess this will not be a >problem. b) If there are issues we should watch out for when using the Oracle 11 database regarding geoserver. Such as differences between Oracle 10 and 11 when talking about Geoserver. Do we need to worry, avoid 11, or is it safe to assume it's just like using version 10 and we wouldn't even notice it if we didn't know? Best regards, Martijn Coenen -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] 405, FTL and REST delete of SLD
Hello Everyone, To follow up on this 'FTL' issue: We just got a call from our customer the issue is resolved. Apparantly it was IIS that was blocking. By doing a reinstall of IIS and selecting a minimum of modules in it, Geoserver was able to work normally. So it must have been some sort of obscure module from IIS doing the bad stuff. Thanks for the help and effort, Best regards, Martijn Coenen [Beschrijving: Beschrijving: Beschrijving: http://www.covadis.nl/emailkop/logo.gif] Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: coe...@covadis.nl Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime Verzonden: donderdag 5 juli 2012 16:39 Aan: David Winslow CC: Martijn Coenen; geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] 405, FTL and REST delete of SLD On Thu, Jul 5, 2012 at 4:18 PM, David Winslow mailto:dwins...@opengeo.org>> wrote: FTL is the template language we use to generate HTML output in several places in GeoServer, including the REST API. If you are seeing FTL errors in the REST API it is a bug in GeoServer and a JIRA report would be appreciated. With a way to reproduce it :-) Looking at the logs I have the impression the ftl thing might be a red herring, maybe another request going on in parallel (we should really add the thread identifier to each log statement). Looking at the StyleResource I see no way the code can return a 405, besides maybe security settings or the lack of the style name in the URL Cheers Andrea -- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob:+39 339 8844549 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf <>-- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] 405, FTL and REST delete of SLD
Hello, We are using REST to DELETE style information from Geoserver. It works very well except on one implementation at one of our customers. A DELETE request returns a 405 error. Normally this would be a MIME-type issue, but in this case the mime types are just fine. The setup is: IIS 7, Geoserver (2.1.2) on Tomcat via ISAPI redirect. When looking in the Geoserver logfile, I noticed the following when trying to delete o10004_kol1.sld: 2012-07-05 12:19:52,269 DEBUG [security.RESTfulPathBasedFilterInvocationDefinitionMap] - ~~ antPath= /** methodList= [Ljava.lang.String;@22880c2b 2012-07-05 12:19:52,269 DEBUG [security.RESTfulPathBasedFilterInvocationDefinitionMap] - method[0]: GET 2012-07-05 12:19:52,269 DEBUG [security.RESTfulPathBasedFilterInvocationDefinitionMap] - Candidate is: '/rest/styles/o10004_kol1'; antPath is /**; matchedPath=true; matchedMethods=true 2012-07-05 12:19:52,269 DEBUG [ows.OWSHandlerMapping] - Looking up handler for [/rest/styles/O10004_kol1] 2012-07-05 12:19:52,269 DEBUG [catalog.rest] - GET style O10004_kol1 2012-07-05 12:19:52,285 DEBUG [geoserver.rest] - Failed to lookup template O10004_kol1.ftl java.io.FileNotFoundException: Template O10004_kol1.ftl not found. It says it cannot find a FTL file. What is this FTL file? Never heard of it and surely we never used it before for deleting a style via REST. Anyone with some indept knowledge about this? If needed, I have a complete logfile (on VERBOSE level). Best regards, Martijn Coenen [Beschrijving: Beschrijving: Beschrijving: http://www.covadis.nl/emailkop/logo.gif] Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: coe...@covadis.nl <>-- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Service Level
Hello, The settings page of Geoserver contains options for the Service Level. Basic, Transactional and Complete. These options can be switched manual. Is there also a reason for Geoserver to change these settings by itself, like "on error X, change to Basic"? I ask this, because we had a recent issue with this setting and I would like to exclude such automatic setting change as a reason of the reported issue but I'm not totally sure. Best regards, Martijn Coenen [http://www.covadis.nl/emailkop/logo.gif] Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: coe...@covadis.nl <>-- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Geoserver 2.1.2 REST and SLD
Lucas wrote: > > We have a problem with Geoserver 2.1.2 REST and SLD. > > > > I have used the default styles from Geoserver (nothing changed). When > I > > request the SLD through REST (/geoserver/rest/styles/…) we get a > different > > SLD. For example: > > Ian wrote: > They are actually the same as strokes default to 1px black lines if > nothing is set in them, Odd that they are formatted differently though > - are there two serialization paths in use here? Correct, when using non-default values, REST will return the correct SLD (or at least, the values saved) but with a default value used, it will return the value as "none" or in XML terms, as node without value or children. Best regards, Martijn Coenen -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] REST style delete returns 405
Good morning,
I'm using the REST api of Geoserver but having troubles with the DELETE of
Styles via this API.
Per API documentation
(http://docs.geoserver.org/latest/en/user/restconfig/rest-config-api.html ) I
do the CURL DELETE request to Geoserver with basic authentication, including
the following code in PHP in the CURL request:
curl_setopt($this->ch, CURLOPT_CUSTOMREQUEST, "DELETE");
curl_setopt($this->ch, CURLOPT_HTTPHEADER, array("Content-type:
application/atom+xml"));
//curl_setopt($this->ch, CURLOPT_HTTPHEADER,
array("application/vnd.ogc.sld+xml"));
The request send to Geoserver is the following:
"rest/styles/O10004_test2?purge=true" with the parameters above, creating the
request as can be found here:
http://docs.geoserver.org/latest/en/user/restconfig/rest-config-examples/rest-config-examples-php.html#delete-with-php-curl
When passed to Geoserver, the ResultCode is 405, a typical result when trying
to delete all styles at once with REST or doing some other method not allowed
at that moment. The style isn't deleted from Geoserver and the file (.sld)
isn't purged, consistent with the rejection of the request. PUT and GET
requests regarding styles are working fine in the setup.
Anyone able to point me in the right direction? Any help would be much
appreciated.
Best regards,
Martijn Coenen
--
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Security and IIS
Hello, I use the (new) user security options of Geoserver. Protecting certain layers. I have defined roles and users and they are stored in the security files of Tomcat\webapps\geoserver\data\security. We have a specific situation here: We do a redirect with the isapi_redirect to redirect HOSTNAME/geoserver tot the correct port HOSTNAME:8880/geoserver. I am testing this security functionality, and I discovered that Geoserver correctly indicates that the layer is locked and the know window opens to enter the user credentials. The authorization was denied. I found out, that it was IIS that was asking for the credentials. When entering the username in IE8, I noticed it was using the domain settings like "thisserver/username" as to log in to our network. But even then, there seems to be a mixup as my own windows network credentials are rejected too. Has anyone else noticed this or can point to where I should look? If you need more info, please ask! Best regards, Martijn Coenen [http://www.covadis.nl/emailkop/logo.gif] Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: mart...@covadis.nl -- Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Geoserver Windows Service in 64-bit
Hello Charles, Problem is, we have to use the Oracle support within Geoserver. It's a project constraint. That's why we had to go trough this kind of trouble to get it working. Running GS without Oracle support is peanuts on x64, we had that on day 1 or so ;-) Next step was to try the Windows Service setup of GS. Best regards, Martijn -Oorspronkelijk bericht- Van: Charles Galpin [mailto:cgal...@lhsw.com] Verzonden: wo 5-10-2011 14:27 Aan: Lucas Heezen - Covadis CC: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Geoserver Windows Service in 64-bit Your problem looked to be simply oracle setup related, which I know nothing about. But I just wanted to point out that we run geoserver just fine here on Windows Server 2008 R2 Standard (64bit) without oracle. I also wanted to mention that when you go to production, everything I have read suggests you use the .war version and run it in another container like tomcat, so you may just want to put your efforts into running it that way from the start. hth charles On Oct 5, 2011, at 2:23 AM, Lucas Heezen - Covadis wrote: > I have managed to get the geoserver service installer to work on Windows 2008 > R2 64-bit. > The following has been done to accomplish this. -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Problems supporting gdal in GeoServer 2.0.2
David, Use a relevant build from that website. They are good to test it. Do you have Visual Studio? If so, choose the version made with that version of VS. If not, choose the latest one and get (if needed) the relevant redistributable files. Check after installing with Dependency Walker if you are missing DLLs. If you like to try the lastest stable version build with Visual Studio 2010, you'll need: MSVC2010 (Win64) -stable release-1600-x64-gdal-1-8-mapserver-6-0. After selecting that build, you get a list of available builds. To test only the core of GDAL, I suggest gdal-18-1600-x64-core.msi. Install it on your test server. Add the paths to your environment variables. And fire up your server. Best regards, Martijn Coenen Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: mart...@covadis.nl > -Oorspronkelijk bericht- > Van: David Alda Fernandez de Lezea [mailto:da...@ikt.es] > Verzonden: vrijdag 15 juli 2011 11:43 > Aan: Martijn Coenen; geoserver-users@lists.sourceforge.net > Onderwerp: RE: [Geoserver-users] Problems supporting gdal in GeoServer > 2.0.2 > > Martijn, > > Thanks for your response. Just what I feared... > > Is there any gdal 64 bit compliation availabe to download from the > internet?? > > I've seeking on http://vbkto.dyndns.org/sdk/ but there are a lot of > possibilities and I don't which can be the right one... > > Thanks. > > Un saludo, > > ··· > ··· > > David Alda Fernández de Lezea > Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y > Biodiversidad > > IKT > Granja Modelo s/n · 01192 · Arkaute (Araba) > > ··· > ··· > Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 > ··· > ··· > email: da...@ikt.esweb: www.ikt.es > ······· > ··· > > -Mensaje original- > De: Martijn Coenen [mailto:mart...@covadis.nl] > Enviado el: viernes, 15 de julio de 2011 10:43 > Para: geoserver-users@lists.sourceforge.net > Asunto: Re: [Geoserver-users] Problems supporting gdal in GeoServer > 2.0.2 > > David, > > In this case, the DLL is a 32-bit version but is being loaded by 64-bit > JAVA. That isn't possible. You will need to use 64-bit build versions > of the GDAL DLLs. > You can use "Dependency Walker" to check the DLLs loaded to see if you > are using 32-bit versions in the 64-bit environment, but I can tell you > that your gdaljni.dll is 32-bit right now. > > Best regards, > Martijn Coenen > > Covadis b.v. > t: 026 3616600 > > Geograaf 12 > f: 026 3612317 > > 6921 EW Duiven > e: mart...@covadis.nl > > > > > -Oorspronkelijk bericht- > > Van: David Alda Fernandez de Lezea [mailto:da...@ikt.es] > > Verzonden: vrijdag 15 juli 2011 8:34 > > Aan: Simone Giannecchini > > CC: geoserver-users@lists.sourceforge.net > > Onderwerp: Re: [Geoserver-users] Problems supporting gdal in > GeoServer > > 2.0.2 > > > > Simone, > > > > Thanks for your response. So I suppose that on GeoServer 2.0.2 the > > gdal support works on win64 platform, doesn't it? Because in Tomcat's > > logs it appears > > > > Jul 15, 2011 8:13:05 AM > > it.geosolutions.imageio.gdalframework.GDALUtilities loadGDAL > > WARNING: Native library load failed.java.lang.UnsatisfiedLinkError: > > C:\Program Files\Java\jre6\bin\gdaljni.dll: Can't load IA 32-bit .dll > > on a AMD 64-bit platform > > > > Any idea what could be happening?? > > > > Thanks. > > > > Regards, > > > > Un saludo, > > > > > ·· > > · > > ··· > > > > David Alda Fernández de Lezea > > Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y > > Biodiversidad > > > > IKT > > Granja Modelo s/n · 01192 · Arkaute (Araba) > > > > > ·· > > · > > ··· > > Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 > > > ·· > > · > > ··· > > email: da...@ikt.esweb: www.ikt.es > > > ·· > &g
Re: [Geoserver-users] Problems supporting gdal in GeoServer 2.0.2
David, In this case, the DLL is a 32-bit version but is being loaded by 64-bit JAVA. That isn't possible. You will need to use 64-bit build versions of the GDAL DLLs. You can use "Dependency Walker" to check the DLLs loaded to see if you are using 32-bit versions in the 64-bit environment, but I can tell you that your gdaljni.dll is 32-bit right now. Best regards, Martijn Coenen Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: mart...@covadis.nl > -Oorspronkelijk bericht- > Van: David Alda Fernandez de Lezea [mailto:da...@ikt.es] > Verzonden: vrijdag 15 juli 2011 8:34 > Aan: Simone Giannecchini > CC: geoserver-users@lists.sourceforge.net > Onderwerp: Re: [Geoserver-users] Problems supporting gdal in GeoServer > 2.0.2 > > Simone, > > Thanks for your response. So I suppose that on GeoServer 2.0.2 the gdal > support works on win64 platform, doesn't it? Because in Tomcat's logs > it appears > > Jul 15, 2011 8:13:05 AM > it.geosolutions.imageio.gdalframework.GDALUtilities loadGDAL > WARNING: Native library load failed.java.lang.UnsatisfiedLinkError: > C:\Program Files\Java\jre6\bin\gdaljni.dll: Can't load IA 32-bit .dll > on a AMD 64-bit platform > > Any idea what could be happening?? > > Thanks. > > Regards, > > Un saludo, > > ··· > ··· > > David Alda Fernández de Lezea > Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y > Biodiversidad > > IKT > Granja Modelo s/n · 01192 · Arkaute (Araba) > > ··· > ··· > Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 > ··· > ··· > email: da...@ikt.esweb: www.ikt.es > ··· > ··· > > -Mensaje original- > De: simbo...@gmail.com [mailto:simbo...@gmail.com] En nombre de Simone > Giannecchini > Enviado el: jueves, 14 de julio de 2011 15:43 > Para: fg...@users.sourceforge.net > CC: David Alda Fernandez de Lezea; geoserver- > us...@lists.sourceforge.net > Asunto: Re: [Geoserver-users] Problems supporting gdal in GeoServer > 2.0.2 > > Dear All, > please, take into account that gdal support for GS 2.0.3 up to 2.1.1 > will not support the win64 platform. > > This is supported on trunk and soon on 2.1.x as well. > > Regards, > Simone Giannecchini > --- > Ing. Simone Giannecchini > GeoSolutions S.A.S. > Founder > > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584 962313 > fax: +39 0584 962313 > mob: +39 333 8128928 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.youtube.com/user/GeoSolutionsIT > http://www.linkedin.com/in/simonegiannecchini > http://twitter.com/simogeo > > --- > > > > On Thu, Jul 14, 2011 at 2:28 PM, Frank Gasdorf > wrote: > > I just downloaded the for geoserver 2.0.2 [1] the gdal plugin [2] and > > I can confirm, you should install gdal 1.4.5b, not the latest ;) > Frank > > > > [1] http://geoserver.org/display/GEOS/GeoServer+2.0.2 > > [2] > > http://downloads.sourceforge.net/geoserver/geoserver-2.0.2-gdal- > plugin > > .zip > > > > 2011/7/14 Frank Gasdorf > >> > >> David, > >> I had similar problems with geoserver 2.1.1 a few weeks ago. Please > >> have a look in the geoserver WEB-INF\lib\ directory of your > deployment folder. > >> Watch out for a imageio-ext-gdal-bindings-XXX.jar file I guess you > >> need to download the gdal-version which is used for the bindings, in > >> my case it was 1.4.5b, the imageio version is 1.0.8 for the > geoserver > >> 2.1.1 release. > >> Hopefully that helps a bit > >> Cheers, Frank > >> > >> 2011/7/14 David Alda Fernandez de Lezea > >>> > >>> Hi list, > >>> > >>> I'm trying to give my GeoServer 2.0.2 instance the abbility of > >>> serving gdal formats. I've tried it following different guidelines, > >>> tuts, geoserver_user_manual intructions but without success. > >>> > >>> First, here is how I've got it set up. > >>> > >>> OS: Windows Server 2003 R2 64Bit SP2 > >>> GeoServer: 2.0.2 (War file deployed over Tomca
Re: [Geoserver-users] Non-geometrytype column
Hi people,
A short question, would this view also be usable on Oracle? I know my
way in PostgrSQL but hardly on Oracle but I have such "text as geometry
point" data there too.
Any Oracle people here who can "translate" this? Any help would be
appreciated.
Best regards,
Martijn Coenen
http://www.covadis.nl/emailkop/logo.gif<http://www.covadis.nl/emailkop/l
ogo.gif>
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: mart...@covadis.nl
Van: Martijn Coenen [mailto:mart...@covadis.nl]
Verzonden: woensdag 13 juli 2011 16:44
Aan: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Non-geometrytype column
Just for the archives: I used the following SQL to add my table with
text as geometry to Geoserver as posted by David:
CREATE VIEW spatial_mytable AS SELECT id, name,
(ST_PointFromText('POINT(' || geometry || ')')) AS the_geom FROM
mytable;
INSERT INTO geometry_columns(f_table_catalog, f_table_schema,
f_table_name, f_geometry_column, coord_dimension, srid, "type") VALUES
('', '', 'spatial_mytable', 'the_geom', 2, 28992, 'POINT');
Mind that I needed to use the single quotes and the 'spatial_' in the
Insert into the geometry_columns table.
Next up is getting it to work with OpenLayers, as I see I need to tweak
the settings, I get the notice:
"ERROR: Operation on two geometries with different SRIDs". J
After working with GS for a year I still get confused around 4326,
28992, etc. J
Thanks for the help David!
Best regards,
Martijn Coenen
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: mart...@covadis.nl
<>--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Non-geometrytype column
Just for the archives: I used the following SQL to add my table with
text as geometry to Geoserver as posted by David:
CREATE VIEW spatial_mytable AS SELECT id, name,
(ST_PointFromText('POINT(' || geometry || ')')) AS the_geom FROM
mytable;
INSERT INTO geometry_columns(f_table_catalog, f_table_schema,
f_table_name, f_geometry_column, coord_dimension, srid, "type") VALUES
('', '', 'spatial_mytable', 'the_geom', 2, 28992, 'POINT');
Mind that I needed to use the single quotes and the 'spatial_' in the
Insert into the geometry_columns table.
Next up is getting it to work with OpenLayers, as I see I need to tweak
the settings, I get the notice:
"ERROR: Operation on two geometries with different SRIDs". J
After working with GS for a year I still get confused around 4326,
28992, etc. J
Thanks for the help David!
Best regards,
Martijn Coenen
http://www.covadis.nl/emailkop/logo.gif<http://www.covadis.nl/emailkop/l
ogo.gif>
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: mart...@covadis.nl
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Non-geometrytype column
David et al,
Shouldn't I point the geometry_columns table to the View somehow or will
Geoserver get the View by itself? I see the geometry_columns table would
get the "mytable" entry at f_table_name, not the View?
Best regards,
Martijn Coenen
http://www.covadis.nl/emailkop/logo.gif<http://www.covadis.nl/emailkop/l
ogo.gif>
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: mart...@covadis.nl
Van: David Winslow [mailto:dwins...@opengeo.org]
Verzonden: dinsdag 12 juli 2011 14:48
Aan: Martijn Coenen
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Non-geometrytype column
Would it be possible for you to use a VIEW?
CREATE VIEW spatial_mytable AS SELECT id, msg, ST_PointFromText("POINT("
|| coordinates || ")", 4326) AS the_geom FROM mytable;
INSERT INTO geometry_columns(f_table_catalog, f_table_schema,
f_table_name, f_geometry_column, coord_dimension, srid, "type") VALUES
('', '', 'mytable', 'the_geom', 2, 4326, 'POINT');
GeoServer would then be able to serve that view as if it were a normal
table with a full-fledged geometry column.
--
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Jul 12, 2011 at 3:37 AM, Martijn Coenen
wrote:
Hello,
Got an interesting question here at our company. Would it be possible to
get a table from a datasource like PostGIS or Oracle without a real
geometry column into Geoserver? The situation can be seen as one has a
table with ID, Name and Geometry, but the last colum is a normal
character colum. No fancy geometry but only with the lat/lon information
in it as a char. Such as "1, HelloWorld, 3.256031600246515
50.73412861353171" or something like that.
Would such be possible? And if so, any special actions that need to be
taken? In above example, it's about a single point, no polygons or
multipoints.
Best regards,
Martijn Coenen
Fout! Bestandsnaam niet opgegeven.
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: mart...@covadis.nl
--
All of the data generated in your IT infrastructure is seriously
valuable.
Why? It contains a definitive record of application performance,
security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Non-geometrytype column
Hello David,
Thanks for this, I will try it tomorrow!
Regards,
Martijn Coenen
http://www.covadis.nl/emailkop/logo.gif<http://www.covadis.nl/emailkop/l
ogo.gif>
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: mart...@covadis.nl
Van: David Winslow [mailto:dwins...@opengeo.org]
Verzonden: dinsdag 12 juli 2011 14:48
Aan: Martijn Coenen
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Non-geometrytype column
Would it be possible for you to use a VIEW?
CREATE VIEW spatial_mytable AS SELECT id, msg, ST_PointFromText("POINT("
|| coordinates || ")", 4326) AS the_geom FROM mytable;
INSERT INTO geometry_columns(f_table_catalog, f_table_schema,
f_table_name, f_geometry_column, coord_dimension, srid, "type") VALUES
('', '', 'mytable', 'the_geom', 2, 4326, 'POINT');
GeoServer would then be able to serve that view as if it were a normal
table with a full-fledged geometry column.
--
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Jul 12, 2011 at 3:37 AM, Martijn Coenen
wrote:
Hello,
Got an interesting question here at our company. Would it be possible to
get a table from a datasource like PostGIS or Oracle without a real
geometry column into Geoserver? The situation can be seen as one has a
table with ID, Name and Geometry, but the last colum is a normal
character colum. No fancy geometry but only with the lat/lon information
in it as a char. Such as "1, HelloWorld, 3.256031600246515
50.73412861353171" or something like that.
Would such be possible? And if so, any special actions that need to be
taken? In above example, it's about a single point, no polygons or
multipoints.
Best regards,
Martijn Coenen
Fout! Bestandsnaam niet opgegeven.
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: mart...@covadis.nl
--
All of the data generated in your IT infrastructure is seriously
valuable.
Why? It contains a definitive record of application performance,
security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Non-geometrytype column
Hello, Got an interesting question here at our company. Would it be possible to get a table from a datasource like PostGIS or Oracle without a real geometry column into Geoserver? The situation can be seen as one has a table with ID, Name and Geometry, but the last colum is a normal character colum. No fancy geometry but only with the lat/lon information in it as a char. Such as "1, HelloWorld, 3.256031600246515 50.73412861353171" or something like that. Would such be possible? And if so, any special actions that need to be taken? In above example, it's about a single point, no polygons or multipoints. Best regards, Martijn Coenen http://www.covadis.nl/emailkop/logo.gif<http://www.covadis.nl/emailkop/l ogo.gif> Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: mart...@covadis.nl -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Plugin GDAL for ECW support
Hello Geoffrey, ECW support on a 64-bit system like Windows 2008 (R2) is not the easiest right now. There are a few steps involved to "see" the plugin, but so far, we haven't been able to get it working with Geoserver on 64-bit. I recommend you to try one of these builds of Gdal: http://vbkto.dyndns.org/sdk/ One thing is that when entering the path to Gdal to your PATH environment variable, be sure that is placed in front of any other entries so that it is loaded FIRST before any other libraries. We came as far as loading the GDAL libs, including ECW, but it failed to load into Geoserver and is unusable. On a 32-bit system (Windows 2003) we haven't had any problems and have it deployed to production environments with Geoserver 1.7.x. If you (or any other) manages to get it working on 64-bit, be very welcome to tell us how you did it! Best regards, Martijn Coenen > -Oorspronkelijk bericht- > Van: gbrun [mailto:gb...@myopera.com] > Verzonden: vrijdag 1 juli 2011 15:23 > Aan: geoserver-users@lists.sourceforge.net > Onderwerp: [Geoserver-users] Plugin GDAL for ECW support > > Hi everybody! > > I'd like to import ECW rasters in my GeoServer. To this end, I did many > things. I'm deploying my application on a windows server 2008. > > First, I installed the JAI 1.1.3 and JAI ImageIO 1.0.01 libraries for > my > JRE 1.6. > > Then, I installed the GDAL library through this URL: > http://java.net/projects/imageio- > ext/downloads/directory/Releases/ImageIO-Ext/1.0.x/1.0.8/windows32- > installer, > and also the natives libraries. > > I created some environment variables that were needed. > > Finally, I installed the GDAL plugin for GeoServer. > > And it works great! I can now use 13 different raster formats. But > still > no ECW or JPEG2000... I'm quite confused! Does GeoServer really support > these both formats?? > > Geoffrey > > --- > --- > All of the data generated in your IT infrastructure is seriously > valuable. > Why? It contains a definitive record of application performance, > security > threats, fraudulent activity, and more. Splunk takes this data and > makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ECW fails on Geoserver in x64 environment
Hello everyone, We're still busy with implementing Geoserver in a 64-bit environment. It's all fine except that ECW support bugging us. I have one question: Does someone have had a successful implementation on a purely 64-bit environment _with ECW_? I mean not using 32-bit JAVA but the "real" x64 versions with whatever version of Geoserver, GDAL, etc.? If so, what version(s) and setup? Best regards, Martijn Coenen -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] ECW fails on Geoserver in x64 environment
Hello, good morning, I was pointed to this mailinglist by Simone Giannecchini via Twitter, thank you Simone! The company where I work has created a software package containing Tomcat, Geoserver and GDAL, running in Windows Server 2003 (with Tomcat Connector). For some years now this has been in operation on 32-bit. Users of the package use normal FeatureTypes but also some Coverages like GeoTIFF and ECW. This works all fine, without problems. Now the wish is to be able to have a 64-bit version of this package for a number of reasons. We managed to have everything working now, Geoserver and other applications do work as designed on x64. GeoTIFF images can be loaded and displayed in Geoserver as expected. Except ECW images. When entering the path to the ecw file, Geoserver keeps telling me that the URL is invalid: "Invalid url: 'file:c:\ecw\image.ecw' for format type:'ECW'. " I tried variations with the URL, capitals where needed. The variation shown here is a copy of the production server but that one is running W2K3 32-bit. I also tried to do network paths: //server/ecw/image.ecw. Same result. It does find the image file, as when I enter a path where no file will be found the message "Could not find file: C:\ecw\Foobar.ecw. Perhaps location was entered wrong?" - as expected. I also copied the ecw files to the Coverages directory to use the relative path: file:Coverages\ECW\image.ecw. Same, fails on the invalid message. The setup is as follows: * Windows Server 2008 R2 * IIS Application Request Routing (ARR) * Tomcat 64-bit * Geoserver 1.7.7 * GDAL 64-bit from http://vbkto.dyndns.org/sdk/ Also with the ECW installer * Latest JAVA JRE and JDK are both installed * Zend Server The funniest part of it all is that there are absolutely no registrations of an error in the logs of Geoserver, Tomcat and Zend. 0. I can try to add as many ECW files as I like, the single error message is this Invalid URL. Geoserver is showing ECW as Coverage plugin: Config > WCS > CoveragePlugins Gtopo30 / 1.0 Gtopo30 Coverage Format ImageMosaic / 1.0 Image mosaicking plugin GeoTIFF / 1.1 Tagged Image File Format with Geographic information JP2ECW / 1.0 JP2K (ECW) Coverage Format ArcGrid / 1.0 Arc Grid Coverage Format ECW / 1.0 ECW Coverage Format ERDASImg / 1.0 Erdas Imagine Coverage Format DTED / 1.0 DTED Coverage Format WorldImage / 1.0 A raster file accompanied by a spatial data file NITF / 1.0 NITF Coverage Format EHdr / 1.0 EHdr Coverage Format Gdalinfo -formats also show ECW and others. The DLL that is used is gdal_ECW_JP2ECW.dll, dated 23-01-2011, 10:57. I'm getting a bit lost here, there must be something blocking the use but without any messages in logfiles it's like talking to a wall. The users are licensed to use ECW on their servers. Any help to guide us to the source of the problems would be very appreciated. Best regards, Martijn Coenen The Netherlands -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
