[Geoserver-users] GeoServer without PostGIS, is it a good idea?
Dear GeoServer users, my company develops systems in meteorology, climatology, radiation monitoring etc. It's mostly data collection, storing and later retrieval. Our customers started to demand maps, recently. What we need is a map client serving customers' data, both rasters (e.g. forecasts from GRIB files) and vector (e.g. various values measured by stations from a national climatology network). We looked out for some options and settled on a combination of a GeoServer OpenLayers integrated into our existing web interface. After several weeks of playing with GeoServer I got an impression that GeoServer works great in combination with a local PostGIS instance. PostGIS fits well into our scenario, too: it would contain metadata about our rasters with time dimensions, and whole vector layers. The problem is we already have our own infrastructure which does all the bookkeeping of all our datasets. E.g. we already store our raster data somewhere in the filesystem and there is a table in our database which tracks metadata (origin, time, etc.) about these rasters. For climatology data, we use Oracle database and have our own schema which stores information about weather stations (e.g. name, location) and current and historical measured values. Because of this, my manager does not want to allow me to create a PostGIS instance along with a GeoServer instance. His arguments is it's unnecessary duplicity, it won't be consistent with our database unless we invest heavily in syncing the two and it needs additional maintenance. His original idea was that our system will provide data to a GeoServer instance via some Web Service / WFS / whatever and GeoServer will just render it. The problem is our system does not have a WFS interface (yet?) and our existing interfaces are not OGC standardized. Of course, if we implement WFS we won't need GeoServer (mostly). I tried to explain to him that we should treat the PostGIS store as some kind of internal GeoServer store (just like various index files on disk - he is a database guy and does not care about all those files created by GeoServer - he cares about databases) and not try to mess with it in order to speed up development (deadlines are tight, as usual). I need either better arguments in this debate or an alternative solution. I stumbled upon DataStore Development tutorial on GeoTools ( http://docs.geotools.org/latest/tutorials/advanced/datastore.html ) which looks promising, but I'm not quite sure if it's the right thing. I'll try to implement a proof-of-concept to see if I'm able to convert our existing database schema into a new Data Store type recognized by GeoSever. In the meantime I'd love to hear your opinion about the case. Is it common to implement custom DataStores from existing databases or mirroring it in PostGIS is the preferred way? Are there any other options? -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.sk -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical virtual servers, alerts via email sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] GeoServer startup time (>2h)
Hi eting, I have a short experience with ImageMosaic datastores. I think you might be interested. We have an installation with approximately 14000 GeoTiffs (and growing) organized into several Image Mosaic layers. The starting time is just a minute or two and geoserver is able to serve them smoothly (no noticeable difference to individual GeoTiff layers). We serve multidimensional meteorological datasets (forecasts with time, forecast hour and sometimes ensemble dimensions) so it makes a lot of sense to use Image Mosaic datastores. For example we are able to iterate over all forecasts for a given runtime of a meteorological model. Cheers, Peter -- Peter Kovac IMS Programmer MicroStep-MIS http://www.microstep-mis.com peter.ko...@microstep-mis.sk On 27. 10. 2015 16:57, eting123 wrote: > Good question and I have been thinking about the same thing, whether we > should have done this differently by combining the layers. > > I'm wondering how scalable is an image mosaic? If we currently have 30,000 > layers, should we put all of them into a single Image Mosaic? At which point > should we consider separating things into a separate mosaic? > > Thank you very much for your help > eting > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/GeoServer-startup-time-2h-tp5232511p5232855.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > -- > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.sk -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Labels drawn over graphic elements
Dear Andrea, thank you for clearing it up for me. As you'd might guess, my company is interested in the "drawImmediately" vendor option. So we either code it ourselves or we will fund core developers, depending on time/money costs. Do you remember if this feature was discussed among developers before? Who and where should I ask about GeoServer developers' time and money estimates? Regards, Peter Kovac On 12. 10. 2015 19:50, Andrea Aime wrote: On Mon, Oct 12, 2015 at 6:45 PM, Peter Kovac <peter.ko...@microstep-mis.sk <mailto:peter.ko...@microstep-mis.sk>> wrote: It seems to me all graphics are rendered first and all labels are rendered after. What can I do about it? I tried using shapes from SLD styles but I need to use more than one shape for every feature. GeoServer renders multiple shapes centered around anchor point and there is no possibility to use Displacement for graphic (AFAIK it's possible only with text labels). That's why I use ExternalGraphic, I need to show all shapes side by side. Displacement for graphics is supported in recent versions of GeoServer (since 2.7 I believe). About the ability to avoid drawing all labels at the end, it has been discussed, in normal situation it just breaks maps big time, as the WMS user can compose them in any order they want and labels need to stay on top to be legible, but we understand there are cases in which this might not be desirable (for example when labels are not really labels, but more parts of symbols). For this we'd need to add and code support for a new "drawImmediately" vendor option. So far no one has provided either their own coding time to make it a reality, or funding to allow core developers to add this features during working hours. Maybe you could be the one? ;-) 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 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. ------- -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.sk -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Labels drawn over graphic elements
Dear GeoServer users, I have a layer which shows data from a meteorology station network in using very specific graphics symbol. The symbol consists of a colored square to the left and a colored rectangle to the right of feature's anchor point, with a possibility of label drawn over the rectangle. I'm using my custom PNG icons as and choose the right colors according to feature data as follows: stations image/png TEXT Arial 14 normal bold 0 0 -2 4 #FF The problem is that the icons might overlap and when they do the text is drawn always on top, regardless of relative z-index of the icon it belongs to. Here's an example: http://imgur.com/YxwieHW It seems to me all graphics are rendered first and all labels are rendered after. What can I do about it? I tried using shapes from SLD styles but I need to use more than one shape for every feature. GeoServer renders multiple shapes centered around anchor point and there is no possibility to use Displacement for graphic (AFAIK it's possible only with text labels). That's why I use ExternalGraphic, I need to show all shapes side by side. Many thanks -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.sk -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] bulk geotiff import
Hi Alex, try this if you have the file on your local computer: curl -u "user:password" -XPUT -H 'Content-type: image/tiff' \ --data-binary @"$LOCAL_GEOTIFF"\ "http://$HOSTNAME:$PORT/geoserver/rest/workspaces/$WORKSPACE/coveragestores/$STORE_NAME/file.geotiff where variables are the following: $LOCAL_GEOTIFF - path to the file on your local computer $HOSTNAME, $PORT - obviously GeoServer instance hostname and port $WORKSPACE - workspace name $STORE_NAME - name of the datastore that will be created for your GeoTIFF If the file is already on the server where the GeoServer runs (and the file is readable by the GeoServer process), try it like this REMOTE_GEOTIFF="file:///path/to/your/remote/geotiff.tiff" curl -w "%{http_code}" -u "admin:Merc4tr99" -XPUT -H 'Content-type: text/plain' \ -d "$REMOTE_GEOTIFF"\ "http://$HOSTNAME:$PORT/geoserver/rest/workspaces/$WORKSPACE/coveragestores/$STORE_NAME/external.geotiff; I think your confusion stems from using incorrect documentation: you have raster data, so you should read "Coverage stores" section of the manual: http://docs.geoserver.org/stable/en/user/rest/api/coveragestores.html Data stores are for vector data (citing http://docs.geoserver.org/stable/en/user/rest/api/datastores.html ): A data store contains vector format spatial data. It can be a file (such as a shapefile), a database (such as PostGIS), or a server (such as a /remote Web Feature Service/ <http://docs.geoserver.org/stable/en/user/data/cascaded/wfs.html#data-external-wfs>). On 12. 1. 2016 18:25, Alex O'Ree wrote: HTTP PUT to http://localhost:8080/geoserver/rest/workspaces/myworkspace/datastores/test/external.shp with the content text/plain file://data_dir/maps/xyz.tiff fails with "unable to configure datastore, bad parameters. I'm assuming this is from the .shp extension. Changing the extension of the put url to .tiff I get unsupported format: tiff I've tried with a few other variants. It looks like REST API creation of datastores is limited to shape files. Is that correct? On Thu, Jan 7, 2016 at 12:59 PM, Alex O'Ree <spyhunte...@gmail.com> wrote: Jody, et al I'm having some issues get the geotiffs imported via the REST API. I can import from the web app without any issues. I think I may either be misinterpreting the documentation and/or the docs may be slightly inaccurate. First a bit more info for my setup. v 2.8.RC1 All geotiff files are located in data_dir/maps I have a workspace called "maps" I've tried a number of different combinations HTTP verb: POST URL http://localhost:8080/geoserver/rest/workspaces/maps/datastores.json Content-type application/json Body contents { Location: "file:///data_dir/maps/MyGeoTiff.tiff" } I'm getting an 500 internal server error. The server logs say, cannot resolve class exception "Location". I'm not sure what "right" looks like here. Any pointers to examples? On Wed, Jan 6, 2016 at 3:57 PM, Alex O'Ree <spyhunte...@gmail.com> wrote: Found it here, http://docs.geoserver.org/stable/en/user/rest/api/datastores.html thanks for the pointer! On Wed, Jan 6, 2016 at 12:54 PM, Alex O'Ree <spyhunte...@gmail.com> wrote: Fantastic, can you point me towards the documentation or any where with more info? On Wed, Jan 6, 2016 at 12:36 PM, Jody Garnett <jody.garn...@gmail.com> wrote: The REST API can be used to load and configure raster content. The importer can also be pointed at a directory of spatial files and do a bulk import ... and the importer is also available via a REST API :) -- Jody Garnett On 6 January 2016 at 09:24, Alex O'Ree <spyhunte...@gmail.com> wrote: I have a large collection of geotiff files, is there a process to getting them all bulk imported into geoserver? Any kind of script or command line interface I can use? Perhaps a rest api? -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140 ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.sk -- Site24x7 AP
Re: [Geoserver-users] GeoServer 2.9.0 Released
Hi Jody et al. Thank you for your outstanding work. I was eager to try the custom legend image for a style but I'm not able to make it work. I'm using a clean 2.9.0 war deployment on Tomcat 8.0.30. This is what I did: 1. Add a new style, let's name it "another_raster" and generate a raster SLD for it. 2. Add legend, type the name of an existing "grass_fill.png" file. 3. Click the "Auto-detect image and size" link. At this point I get "Field 'styleEditor' is required." error at the top of the screen, but all legend fields are auto filled with correct values (width and height is 32, format is image/png;charset=UTF-8). 4. Save the style and let the layer Pk50095 use it as additional style. 5. Now, when I do a WMS GetCapabilites request and track down the URL for the legend of Pk50095 I get the following: link http://hostname:port/geoserver/grass_fill.png which is incorrect. The correct link is http://hostname:port/geoserver/styles/grass_fill.png (also the docs say so: http://docs.geoserver.org/stable/en/user/datadirectory/structure.html#styles ) Also another inconvenience is that when I set a workspace (say nurc), edit the style via web UI, save it, edit it again and save it again the workspace is lost (despite the fact that during the second edit the workspace combobox is populated with what I assume is the correct value and it is sent over to the server as HTTP POST request parameter when I click on Submit). Are these known issues or should I open a JIRA bug reports? On 31. 5. 2016 0:41, Jody Garnett wrote: The GeoServer team is happy to announce the release of GeoServer 2.9.0: * http://geoserver.org/release/2.9.0/ This is the new stable release suitable for use in production. This release *requires the use of Java 8*. Important updates: * Web admin application layer, preview, global settings, image processing and raster access screens have been updated. * User guide has been restructured for ease of navigation and to reduce duplication * The REST API can now be used to manage icons, fonts and configuration files and report on the status of installed components. * Internally this release features Wicket 7 and Spring 4 and the latest JAI-Ext library. * Layer bounds can now be generated from spatial reference systems extent * Styles can now be configured with a custom legend. * For more details please see the blog post <http://blog.geoserver.org/2016/05/30/geoserver-2-9-0-released/> and release notes (2.9.0 <https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=13003>|RC1 <https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=12502>|beta2 <https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=12700>|beta <https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=12100>|M0 <https://osgeo-org.atlassian.net/secure/ReleaseNote.jspa?projectId=1=11401>) Thanks to Jody and Devon (from Boundless) for publishing this release. This release was delayed for two months due to incompatibility with Java 8. Thanks for the dedicated testing a fix support from Andrea, Alessandro, Alex, Ben, Brad, Jukka, Niels, Torben and others during this long release cycle. Special thanks to sponsors of the Wicket 7 upgrade <https://wiki.osgeo.org/wiki/GeoServer_Code_Sprint_2016> sprint: OSGeo <http://www.osgeo.org/>, Boundless <http://boundlessgeo.com/>, Vivid Solutions <http://www.vividsolutions.com/>, How 2 Map <http://www.how2map.com/>, San Jose Water Company <https://www.sjwater.com/>, Transient <http://transient.nz/>, Geobeyond <http://www.geobeyond.it/> (with in-kind sponsors GeoSolutions, CCRi, Astun Technology and Voyager). -- The GeoServer Team -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacit
Re: [Geoserver-users] Reload ImageMosaic store via Rest API
Hi Ivan, what you want to do is what ImageMosaic calls "reindexing granules". You can reindex the whole layer, but it is time consuming and inefficient, because GeoServer will reexamine each granule (individual GeoTIFF raster) and delete it from the index or add it to the index. It might take a couple of minutes and performance for ordinary WMS requests drops badly during that period. curl -v -u username:password -XPOST -H "Content-type: text/plain" \ -d "file:/path/to/dir/with/geotiff/files/" \ "http://localhost:8080/geoserver/rest/workspaces//coveragestores//external.imagemosaic <http://localhost:8080/geoserver/rest/workspaces/POVAPSYS/coveragestores/aladin_test3temperature/external.imagemosaic>" Much better approach (at least in my scenario) is to index each granule individually just when the file is ready and is copied to the ImageMosaic directory. curl -v -u username:password -XPOST -H "Content-type: text/plain" \ -d "file:/path/to/dir/with/geotiff/files/your_file.tiff" \ "http://localhost:8080/geoserver/rest/workspaces//coveragestores//external.imagemosaic" Use another REST call to delete old granules. You can use filter to e.g. delete all granules older than 1st January 2016 (assuming you use the time dimension). curl -u "user:pass" -XDELETE "http://localhost:8080/geoserver/rest/workspaces//coveragestores//coverages//index/granules.xml?filter=time%20BEFORE%202016-01-01T00:00:00Z <http://localhost:8080/geoserver/rest/workspaces/RADMON/coveragestores/radmon_short_range/coverages/short_range/index/granules.xml?filter=time%20BEFORE%202016-01-01T00:00:00Z>" Useful resources are online tutorial by GeoSolutions ( http://geoserver.geo-solutions.it/multidim/en/index.html ) and REST API docs ( http://docs.geoserver.org/stable/en/user/rest/api/coverages.html#structured-coverages ). Peter On 31. 5. 2016 16:14, Ivan Kotev wrote: Hello All, This might be quite trivial but I cannot seem to be able to figure it out based on the Rest API documentation. I have several ImageMosaic stores (each of them has exactly 1 layer) which are in turn backed by GeoTIFF data files. Every few hours I refresh the data by uploading new GeoTIFF files and removing the old ones (external operation to GeoServer). I am looking for a Rest API based approach to the reload the data for a particular ImageMosaic store. Currently what I am doing is: "POST /geoserver/rest/reload", followed by: "POST /geoserver/rest/reset" This seems to be working but it reloads the data for *all* datastores which is a bit of overkill. Is there a Rest API to reload the data for a given ImageMosaic store/layer? Thanks much in advance. Cheers, Ivan -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] How to serve large spatio-temporal dataset with GeoServer?
Dear Andrea, thank you for this deep insight into why Postgres/PostGIS with GeoServer rocks! You were totally right! I just made an exact clone of the lightning table in PostGIS and there is no observable difference in performance whether I'm looking at whole Europe (just a couple hundred ms) or just a tiny village unfortunate enough to have a major thunderstorm. It's amazing. BTW, if there's anybody wondering how to migrate table from Oracle Locator/Spatial to PostGIS, here's a link describing usage of another excellent open source software ogr2ogr: http://words.mixedbredie.net/archives/1751 Thank you again! On 22. 6. 2016 14:31, Andrea Aime wrote: On Wed, Jun 22, 2016 at 2:15 PM, Jonathan Moules <jonathan-li...@lightpear.com <mailto:jonathan-li...@lightpear.com>> wrote: While Andrea has an (understandable) leaning towards PostGres, I'd be surprised if you can't optimise Oracle to get the desired result too if you're fixed with that (but if you're not - PostGres would probably be a worthwhile change). The leaning has some explanation, that goes beyond the natural sympathy for another open source project. GeoServer is translating every OGC request into the best query it can setup, but the translation is still, after all, automatic, with little or no control on the admin side (sql views might help to some extent). In Oracle developers decided to add query hints, every time a query misbehaves you can add one of those to force the better execution path... that's nice, as long as you can control how the queries are written but that's not the case in GeoServer. Of course that reduced pressure to improve the query planner (and made the Oracle consultant market a bigger and more profitable one). In PostgreSql developers instead refused to add query hints support, and treated every case in which the optimizer took the wrong path as a bug. At the beginning that was pretty painful, but over time the planner evolved to the point that it's actually very good... this couples well with an automatic query generator, as long as the query is valid the db should not need any help using the best access path. If you think about it setting up a WFS (or a WMS with CQL_FILTER) is really like saying "hey, here is my database, hit it with whatever you want", since people can literally write the filter they feel like, with no limitation on complexity. The is no query hint salvation there, each query is dynamic and defined by the user at the time the request is made... either the database is smart and fast on its own, without query specific help from a human, or you're in for a pile of troubles. 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 *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. ------- -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -
Re: [Geoserver-users] REST API creating of a composite layer "Layer Group"
Hi Alex, from what I have learned how people usually work with REST API is that they do what they want on a small scale using the web GUI and then do a GET request using the XML format. The XML returned usually is in the exact format a PUT request needs. So, make one small layer group, GET it via REST and use that as a template for your PUT requests. On 13. 1. 2016 16:58, Alex O'Ree wrote: > So I've just imported a large number of geotiff files that are grouped > logically on the file system by resolution (1:2M, 1:1M, 1:250K, etc) > > Since the volume is high, I want to use the REST api to create a layer > group, One for each resolution set. > > I've found this > http://docs.geoserver.org/stable/en/user/rest/examples/curl.html#creating-a-layer-group > > but it doesn't provide the complete syntax for referencing a raster > layer set, workspace, coordinate reference system, output formats, > gridsets etc. > > Are there additional examples, documentation or a scheme file for > defining what the request needs to look like for creating a layer > group? > > -- > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140 > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.sk -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140 ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] How to point GeoServer to MOSAIC_DIR?
Hi Padhrig, I recommend using XML indexer, not .properties file for configuring image mosaics: http://geoserver.geo-solutions.it/multidim/en/imagemosaic/mosaic_indexer.html Then provide appropriate parameters in your indexer.xml and you can store granules anywhere on your filesystem: ... Cheers On 24. 2. 2016 17:10, Padhrig Mccarthy wrote: Hi- I am a novice GeoServer user, and I am tasked with setting up multiple timeseries ImageMosaics for our project. I have a MOSAIC_DIR set up and configured according to the tutorial at http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html. Based on information in that tutorial, it seems MOSAIC_DIR can be anywhere on our system. However, when I go to create the ImageMosaic data store in GeoServer, all of the configuration seems to use relative paths from MOSAIC_DIR. How do I tell GeoServer where my MOSAIC_DIR is? Or do I need to place MOSAIC_DIR in some location where GeoServer expects it? Alternatively, do I need to define MOSAIC_DIR env var for the user running the tomcat container? I have tried this last option, yet still have no joy. Thank you in advance for any hints. -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140 ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.sk -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151=/4140___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] SLD: Is it possible to get relative displacement between and in ?
Hi Victor, as an alternative to what Andrea has suggested you might try to prepare a custom image for the graphic symbol, which is appropriately offset and has transparent background. Then use the displacement only to displace the label. However, I'm not sure if GeoServer is clever enough to figure out that transparent parts of the images are actually not overlapping, you'll have to try it. Peter On 26. 7. 2016 8:41, Victor.Sinceac wrote: Hi Peter, Nope, separating Graphic and Label elements in 2 different rules would of course handle well the relative displacement but wouldn’t manage the labels overlapping. The labels overlapping is the main reason of using both Graphic and Label in the same rule: it ensures that each Label is drawn over a Marker, then also avoids the overlapping of different pairs Marker+Label. My particular requirement is to have: - a pair Marker+Label for each point - pairs Marker+Label shall not overlap when zooming the map - the Marker is centered on the point geom (X,Y) - the Label is centered on the point geom (X+DELTAX,Y) Something similar with the well-known case of roads shields (the road number in the middle of a road marker) but where the road number is not centered on the marker but it is written on the right side of the marker. Did someone already find a solution to this? Thanks, Victor > Date: Mon, 25 Jul 2016 12:51:25 +0200 > From: Peter Kovac <peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>> > Subject: Re: [Geoserver-users] SLD: Is it possible to get relative displacement between and in ? > To: geoserver-users@lists.sourceforge.net <mailto:geoserver-users@lists.sourceforge.net> > Message-ID: <90e7c4a5-488f-462b-4fa8-6bab429c7...@microstep-mis.com <mailto:90e7c4a5-488f-462b-4fa8-6bab429c7...@microstep-mis.com>> > Content-Type: text/plain; charset=windows-1252; format=flowed > > Hi Victor, > just split it into 2 rules: one for the graphic and one for the text label. > Then you can use different displacement in each of them. > Cheers, > Peter > On 25. 7. 2016 12:00, Victor.Sinceac wrote: > > Hi All, > > > > In a SLD rule, I need to use a with both and > elements (something similar to Highways Shields use case): > > > > > > ... > > ... > > ... > > . > > > > > > This works well when the requirement is to get the same position X,Y for > > both Graphic and Label elements. > > If I had well understood, the element in such a rule > > would apply to both elements Label and Graphic. > > Is it possible to define in such a rule a displacement which would only apply > > to the element Label? > > Thanks, > > Victor This message is subject to and does not create or vary any contractual relationship between Campbell Scientific Limited, its subsidiaries or affiliates ("CSL") and you. Internet communications are not secure and therefore CSL does not accept legal responsibility for the contents of this message. The message is intended for the addressee only and its contents and any attached files are strictly confidential. If you have received it in error, please telephone +44 (0)1509 601141 or email postmas...@campbellsci.co.uk. Thank you. Campbell Scientific Ltd. Company Registration Number: 1933935 (England and Wales) Registered Address: Campbell Park, 80 Hathern Road, Shepshed, Loughborough, Leicestershire LE12 9GX, UK Tel: +44 (0) 1509 601141 Fax: +44 (0) 1509 601091 Web: www.campbellsci.co.uk -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] SLD: Is it possible to get relative displacement between and in ?
Hi Victor, just split it into 2 rules: one for the graphic and one for the text label. Then you can use different displacement in each of them. Cheers, Peter On 25. 7. 2016 12:00, Victor.Sinceac wrote: > Hi All, > > In a SLD rule, I need to use a with both and > elements (something similar to Highways Shields use case): > > > ... > ... > ... > ... ... > ... > > > > This works well when the requirement is to get the same position X,Y for both > Graphic and Label elements. > If I had well understood, the element in such a rule would > apply to both elements Label and Graphic. > Is it possible to define in such a rule a displacement which would only apply > to the element Label? > > Thanks, > Victor > > This message is subject to and does not create or vary any contractual > relationship between Campbell Scientific Limited, its subsidiaries or > affiliates ("CSL") and you. Internet communications are not secure and > therefore CSL does not accept legal responsibility for the contents of this > message. The message is intended for the addressee only and its contents and > any attached files are strictly confidential. If you have received it in > error, please telephone +44 (0)1509 601141 or email > postmas...@campbellsci.co.uk. Thank you. > Campbell Scientific Ltd. > Company Registration Number: 1933935 (England and Wales) Registered Address: > Campbell Park, 80 Hathern Road, Shepshed, Loughborough, Leicestershire LE12 > 9GX, UK > Tel: +44 (0) 1509 601141 > Fax: +44 (0) 1509 601091 > Web: www.campbellsci.co.uk > > > > -- > What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic > patterns at an interface-level. Reveals which users, apps, and protocols are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity planning > reports.http://sdm.link/zohodev2dev > _______ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Raster symbology
Hi Don, have you tried the "extended" attribute of the element? extended The extended attribute specifies whether the color map gradient uses 256 (8-bit) or 65536 (16-bit) colors. The value false (the default) specifies that the color scale is calculated using 8-bit color, and true specifies using 16-bit color. http://docs.geoserver.org/latest/en/user/styling/sld-reference/rastersymbolizer.html Cheers On 22. 7. 2016 0:48, Brown, Donald wrote: Is there any way to get GeoServer to render more than 255 colors for my geotiff? I can create a .sld with over 500 'colorMapEntries', add it to GeoServer, and even add it as the default style for my layer. However, GeoServer throws an error when I subsequently do a 'GetMap' request on the WMS. Maybe there's a way to embed a large colormap into my tiff that I'm not aware of? Thanks for any help. Don -- Don Brown U.S. Geological Survey Fort Collins Science Center 2150 Centre Ave. Bldg. C Fort Collins, CO 80526 (970) 226-9155 _brownd@usgs.gov_ <mailto:bro...@usgs.gov> -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Is use of the Marlin renderer recommended
Hi Paul, you can verify the renderer GeoServer is using by checking the "Java Rendering Engine" on the "Server Status" screen (the first link in web admin GUI). If you use Marlin, you'll have "org.marlin.pisces.PiscesRenderingEngine" in there. Cheers, Peter On 8. 8. 2016 12:14, Paul Wittle wrote: > I thought it might do that. In text form for point 2: > > - I put the *.jar reference in the Java Classpath of the w.exe Java tab and > then added: > -Dsun.java2d.renderer=org.marlin.pisces.PiscesRenderingEngine > -Dsun.java2d.renderer.useThreadLocal=false > > to the Java Options. > > However, I don't think I've seen a reference to Marlin in the GeoServer logs > so I wonder if I've put the *.jar reference in the wrong place? > > Thanks, > Paul > > -- > > Message: 1 > Date: Mon, 8 Aug 2016 09:52:17 + > From: Paul Wittle <p.wit...@dorsetcc.gov.uk> > Subject: [Geoserver-users] Is use of the Marlin renderer recommended > To: "geoserver-users@lists.sourceforge.net" > <geoserver-users@lists.sourceforge.net> > Message-ID: > > <D67B8B2041F8004B9C0534736661A4D1FB444AAB@VMCREXCHMBOX01.dorsetcc.local> > > Content-Type: text/plain; charset="us-ascii" > > Hi, > > I have found a blog post from 2014 suggesting that there is an improved > renderer for Oracle available. This appears to be the Marlin Renderer and I > have attempted to follow the installation instructions; however I'm never > quite certain how that fits with the Tomcat service deployment. Two questions: > > 1) Is it recommended to use Marlin still (I'm using GeoServer 2.8.4)? > 2) Is this the correct place to put the settings (hopefully there will be a > screenshot below: > [cid:image001.png@01D1F162.EE166870] > > Thanks, > Paul > "This e-mail is intended for the named addressee(s) only and may contain > information about individuals or other sensitive information and should be > handled accordingly. Unless you are the named addressee (or authorised to > receive it for the addressee) you may not copy or use it, or disclose it to > anyone else. If you have received this email in error, kindly disregard the > content of the message and notify the sender immediately. Please be aware > that all email may be subject to recording and/or monitoring in accordance > with relevant legislation." > -- next part -- > An HTML attachment was scrubbed... > -- next part -- > A non-text attachment was scrubbed... > Name: image001.png > Type: image/png > Size: 20673 bytes > Desc: image001.png > > -- > > -- > > > -- > > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > End of Geoserver-users Digest, Vol 123, Issue 17 > > "This e-mail is intended for the named addressee(s) only and may contain > information about individuals or other sensitive information and should be > handled accordingly. Unless you are the named addressee (or authorised to > receive it for the addressee) you may not copy or use it, or disclose it to > anyone else. If you have received this email in error, kindly disregard the > content of the message and notify the sender immediately. Please be aware > that all email may be subject to recording and/or monitoring in accordance > with relevant legislation." > > -- > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] How to configure Pacific raster layers spanning the 180 meridian?
PROJCS[WGS 84 / PDC Mercator, GEOGCS[WGS 84, DATUM[World Geodetic System 1984, SPHEROID[WGS 84, 6378137.0, 298.257223563, AUTHORITY[EPSG,7030]], AUTHORITY[EPSG,6326]], PRIMEM[Greenwich, 0.0, AUTHORITY[EPSG,8901]], UNIT[degree, 0.017453292519943295], AXIS[Geodetic longitude, EAST], AXIS[Geodetic latitude, NORTH], AUTHORITY[EPSG,4326]], PROJECTION[Mercator_1SP, AUTHORITY[EPSG,9804]], PARAMETER[latitude_of_origin, 0.0], PARAMETER[central_meridian, 150.0], PARAMETER[scale_factor, 1.0], PARAMETER[false_easting, 0.0], PARAMETER[false_northing, 0.0], UNIT[m, 1.0], AXIS[Easting, EAST], AXIS[Northing, NORTH], AUTHORITY[EPSG,3832]] EPSG:3832 -1.9628687512850948E7 1.5807367692644846E7 -8362698.548500745 1.0023392492023032E7 EPSG:3832 -180.0 180.0 -59.999866 66.669982 GEOGCS[WGS84(DD), DATUM[WGS84, SPHEROID[WGS84, 6378137.0, 298.257223563]], PRIMEM[Greenwich, 0.0], UNIT[degree, 0.017453292519943295], AXIS[Geodetic longitude, EAST], AXIS[Geodetic latitude, NORTH]] REPROJECT_TO_DECLARED true 0 true NONE W.m-2.Sr-1 test_NAT_3832_test_NAT_3832 CoverageStoreInfoImpl--2d5f6d1:1570f9abf84:-751f GeoTIFF 0 0 7921 13389 2284.8548262200666 -2284.8548262200666 0.0 0.0 -1.008291672173188E7 1.5294720190268923E7 EPSG:3832 GIF PNG JPEG TIFF ImageMosaic GRIB ArcGrid NetCDF GEOTIFF Gtopo30 nearest neighbor bilinear bicubic nearest neighbor RED_BAND GridSampleDimension[4.851844693347973E-33,4.851844693347973E-33] 0.0 0.0 4.851844693347973E-33 W.m-2.Sr-1 UNSIGNED_8BITS GREEN_BAND GridSampleDimension[4.851844693347973E-33,4.851844693347973E-33] 0.0 0.0 4.851844693347973E-33 W.m-2.Sr-1 UNSIGNED_8BITS BLUE_BAND GridSampleDimension[4.851844693347973E-33,4.851844693347973E-33] 0.0 0.0 4.851844693347973E-33 W.m-2.Sr-1 UNSIGNED_8BITS EPSG:3832 EPSG:3832 InputTransparentColor SUGGESTED_TILE_SIZE 512,512 test_NAT_3832 -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] HELP: creating a store ImageMosaicJDBC for raster image in Geoserver 2.9.0
Hi Tommaso, you will need to dedicate more RAM (if it's available on your computer) to the Java process running GeoServer. The exact command depends on your platform and type of GeoServer installation (which you did not mention). You'll have to find the correct config file/script where to put parameters for JVM and enter higher values to -Xmx switch (and its useful to adjust -Xms too), e.g.: |-Xms1024m -Xmx2048m| Cheers, Peter On 21. 9. 2016 17:16, Tommaso Pirini wrote: Hello, I have a problem similar to that described here, but *during the store definition in Geoserver*: http://seotoast.com/getting-a-java-lang-outofmemoryerror-error-while-importing-raster-files-from-postgis-to-geoserver/ I am trying to import raster data from PostGIS 2.2 to GeoServer 2.9.0. I follow the instructions given on this link: http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html I used the gdal_retile to make tiles of my GTiff imagery. I configured xml files and placed them at desire place. Then I used the DDL generation utility which create 4 SQL scripts file, then I ran the SQL scripts. The image tiles importing runs correctly, but *when I tried to connect the data store in Geoserver* I get this error: ... Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded at java.util.zip.ZipCoder.getBytes(ZipCoder.java:80) at java.util.zip.ZipFile.getEntry(ZipFile.java:310) at java.util.jar.JarFile.getEntry(JarFile.java:240) at java.util.jar.JarFile.getJarEntry(JarFile.java:223) at sun.misc.URLClassPath$JarLoader.getResource(URLClassPath.java:1005) at sun.misc.URLClassPath.getResource(URLClassPath.java:212) at java.net.URLClassLoader$1.run(URLClassLoader.java:365) at java.net.URLClassLoader$1.run(URLClassLoader.java:362) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:361) at org.eclipse.jetty.webapp.WebAppClassLoader.findClass(WebAppClassLoader.java:510) at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:441) at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:403) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1969) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305) ... The image size is almost 500MB. If I use the same procedure with an image of 4MB size, everything works. Could you help me, please? Thanks for your attention. Best regards, Tommaso _ Tommaso Pirini, PhD Computer Engineer email: tommaso.pir...@unibo.it <mailto:tommaso.pir...@unibo.it> phone: +39 340 3301299 Skype: tommy.piro24 -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] How many layers/resources per store?
Hi Anton, Please, keep the conversation on the mailing list so others can help you or benefit from our conversation. I don't use gsconfig, so I'm not able to help you with it. However, once you set up your PostGIS JNDI datastore, it's just another datastore and I wildly guess that gsconfig will work happily with it. In my opinion setting up JNDI manually is just a small effort for a very high reward. Cheers, Peter On 28. 9. 2016 10:40, Anton Lundkvist wrote: Ok thanks! I'm relying heavily on gsconfig.py https://github.com/boundlessgeo/gsconfig for publishing my tables. I haven't found any info on if it is possible to use JNDI with gsconfig. Does anyone know? regards, anton 2016-09-28 9:15 GMT+02:00 Peter Kovac <peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>>: Hi Anton, If you are using Apache Tomcat or another container I recommend using JNDI connection pooling. That way you have 1 connection pool shared among all of your layers and you can manage it easily. I observed significant performance gains when switching from "PostGIS" to "PostGIS (JNDI)" type of store (database connections don't have to be recreated with each request and it saves a lot of time). It works with ImageMosaic datastores with custom dimensions too. http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html <http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html> Cheers, Peter On 28. 9. 2016 8:57, Anton Lundkvist wrote: Hi GeoServer Users: I'm using GeoServer for serving vector data (from PostGis). Keeping the number of stores down e.g. many layers per store reduces the number of connections to PostGis. This is desirable as I have hundreds of tables that are published through GeoServer. Is there a recommended limit for how many layers / resources I should handle with one store? Regards, Anton Lundkvist -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net <mailto:Geoserver-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/geoserver-users <https://lists.sourceforge.net/lists/listinfo/geoserver-users> -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com> -- --- Anton Lundkvist Malmö Tel:0046 768 847 703 -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] How many layers/resources per store?
Hi Anton, If you are using Apache Tomcat or another container I recommend using JNDI connection pooling. That way you have 1 connection pool shared among all of your layers and you can manage it easily. I observed significant performance gains when switching from "PostGIS" to "PostGIS (JNDI)" type of store (database connections don't have to be recreated with each request and it saves a lot of time). It works with ImageMosaic datastores with custom dimensions too. http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html Cheers, Peter On 28. 9. 2016 8:57, Anton Lundkvist wrote: Hi GeoServer Users: I'm using GeoServer for serving vector data (from PostGis). Keeping the number of stores down e.g. many layers per store reduces the number of connections to PostGis. This is desirable as I have hundreds of tables that are published through GeoServer. Is there a recommended limit for how many layers / resources I should handle with one store? Regards, Anton Lundkvist -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] GetCapabilities returning invalid xml
Hi Alex, you'll have to check the log file for more detailed information. Look for $GEOSERVER_DATA_DIR/logs/geoserver.log. You might set the log level to VERBOSE_LOGGING (in Settings -> Global -> Logging profile) temporarily if you can't find any apparent error with default log level. Cheers, Peter On 30. 9. 2016 21:42, Alex O'Ree wrote: > geoserver/ows?service=wms=1.3.0=GetCapabilities > > is returning mostly valid XML, until it goes to some CRS element > whereby the body is actually an exception with an additiona and a ServiceExceptionREport > > RunTimeException can't obtain envelope of Layer-Groups: null > > any idea what's wrong? Running 2.8.1 > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] How many layers/resources per store?
Hi Anton, sorry, for late response: in my experience this is something you have to try and adjust yourself, because every computer setup is different. You can use e.g. Apache JMeter to create a bunch of testing WMS requests and then try to find the setting where you have the best performance. You may find out you are not bounded by database, but network or disk access... Cheers, Peter On 1. 11. 2016 17:08, Anton Lundkvist wrote: Thanks for the info! I finally had the time to implement the Jindi connection pooling. It seems to work well. I configured according to the geoserver docs. http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html Do you have any info on what the different configuration settings in the context.xml stand for or if there are any additional setting I should set to maximize performance? I use tomcat 8 and checked the docs there but did not find much. For example I would like to know what the maxActive="20" maxIdle="8" In the context.xml does. Does the connection pool allow adding unlimited amount of feature types to that store or are there still limits to what it can handle? My database is configured to accept unlimited amounts of connections Thanks again for the help! Anton Den 29 sep. 2016 8:27 AM skrev "Peter Kovac" <peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>>: Hi Anton, Please, keep the conversation on the mailing list so others can help you or benefit from our conversation. I don't use gsconfig, so I'm not able to help you with it. However, once you set up your PostGIS JNDI datastore, it's just another datastore and I wildly guess that gsconfig will work happily with it. In my opinion setting up JNDI manually is just a small effort for a very high reward. Cheers, Peter On 28. 9. 2016 10:40, Anton Lundkvist wrote: Ok thanks! I'm relying heavily on gsconfig.py https://github.com/boundlessgeo/gsconfig <https://github.com/boundlessgeo/gsconfig> for publishing my tables. I haven't found any info on if it is possible to use JNDI with gsconfig. Does anyone know? regards, anton 2016-09-28 9:15 GMT+02:00 Peter Kovac <peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>>: Hi Anton, If you are using Apache Tomcat or another container I recommend using JNDI connection pooling. That way you have 1 connection pool shared among all of your layers and you can manage it easily. I observed significant performance gains when switching from "PostGIS" to "PostGIS (JNDI)" type of store (database connections don't have to be recreated with each request and it saves a lot of time). It works with ImageMosaic datastores with custom dimensions too. http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html <http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html> Cheers, Peter On 28. 9. 2016 8:57, Anton Lundkvist wrote: Hi GeoServer Users: I'm using GeoServer for serving vector data (from PostGis). Keeping the number of stores down e.g. many layers per store reduces the number of connections to PostGis. This is desirable as I have hundreds of tables that are published through GeoServer. Is there a recommended limit for how many layers / resources I should handle with one store? Regards, Anton Lundkvist -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net <mailto:Geoserver-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/geoserver-users <https://lists.sourceforge.net/lists/listinfo/geoserver-users> -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com> -- --- Anton Lundkvist Malmö Tel:0046 768 847 703 -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com> -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http:
Re: [Geoserver-users] Missing band definitions when adding a GeoTIFF via REST
Hi Victor, usually, with REST, it works like this: If you want to update some property X of some resource Y, first try to configure similar resource via web UI and then make a GET request via REST so that you can see the full configuration with all the options and their values. In your case, try to make a GET request against this url: http://localhost:8080/geoserver/rest/workspaces/files/coveragestores/myraster/coverages/myraster.json You should get something like the attached JSON. Look especially at "dimensions" and "coverageDimension" properties. In general that's how you should format your POST request. Cheers, Peter On 11. 11. 2016 13:32, Víctor González wrote: Hi, I'm loading a new GeoTIFF layer using REST by adding a new coveragestore and coverage (requests below). After that, the layer does not have information about bands and I have to use the "Reload band definitions" option in the web GUI to load them manually (because I don't know the raster metadata and I cannot include it in the request). Why is the band information not loaded automatically? Is it possible to load it programmatically without using the web GUI? I'm using 2.9.1. $ curl -u admin:geoserver -XPOST http://localhost:8080/geoserver/rest/workspaces/files/coveragestores.json -H "Content-Type: application/json" --data '{ "coverageStore" : { "name" : "myraster", "type" : "GeoTIFF", "enabled" : true, "workspace" : { "name" : "files" }, "url" : "file:test.tif" } }' $ curl -u admin:geoserver -XPOST http://localhost:8080/geoserver/rest/workspaces/files/coveragestores/myraster/coverages.json -H "Content-Type: application/json" --data '{ "coverage" : { "name" : "myraster", "enabled" : true, "store" : { "name" : "files:myraster" } } }' Best regards. -- Víctor González http://geomati.co -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com { "coverage":{ "name":"myraster", "nativeName":"myraster", "namespace":{ "name":"files", "href":"http:\/\/localhost:8080\/geoserver\/rest\/namespaces\/files.json" }, "title":"My Raster", "description":"Generated from GeoTIFF", "keywords":{ "string":[ "WCS", "GeoTIFF" ] }, "nativeCRS":{ "@class":"projected", "$":"PROJCS[\"WGS 84 \/ Pseudo-Mercator\", \n GEOGCS[\"WGS 84\", \n DATUM[\"World Geodetic System 1984\", \n SPHEROID[\"WGS 84\", 6378137.0, 298.257223563, AUTHORITY[\"EPSG\",\"7030\"]], \n AUTHORITY[\"EPSG\",\"6326\"]], \nPRIMEM[\"Greenwich\", 0.0, AUTHORITY[\"EPSG\",\"8901\"]], \nUNIT[\"degree\", 0.017453292519943295], \n AXIS[\"Geodetic longitude\", EAST], \nAXIS[\"Geodetic latitude\", NORTH], \nAUTHORITY[\"EPSG\",\"4326\"]], \n PROJECTION[\"Popular Visualisation Pseudo Mercator\", AUTHORITY[\"EPSG\",\"1024\"]], \n PARAMETER[\"semi_minor\", 6378137.0], \n PARAMETER[\"latitude_of_origin\", 0.0], \n PARAMETER[\"central_meridian\", 0.0], \n PARAMETER[\"scale_factor\", 1.0], \n PARAMETER[\"false_easting\", 0.0], \n PARAMETER[\"false_northing\", 0.0], \n UNIT[\"m\", 1.0], \n AXIS[\"Easting\", EAST], \n AXIS[\"Northing\", NORTH], \n AUTHORITY[\"EPSG\",\"3857\"]]" }, "srs":"EPSG:3857", "nativeBoundingBox":{ "minx":-2.0037508299778014E7, "maxx":2.003121201463195E7, "miny":-1.31002474063954E7, "maxy":1.3095217057218852E7, "crs":{ "@class":"projected", "$":&quo
Re: [Geoserver-users] Windbarbs not working in geoserver 2.9.2
Dear Devin, when I had trouble with external legend images in the styles directory (I always got NullPointerException when trying to set the image name from web UI) I figured out that I can just edit the styles XML configuration file and then reload the catalog to apply changes. Somehow, it works for me. The XML file of your style has the same name as the SLD file, just different extension. See below for an example configuration with the legend.png file in the styles directory: <id>StyleInfoImpl-41238c1:157e2c81df1:-2db4</id> <name>my_style</name> <format>sld</format> <languageVersion> <version>1.0.0</version> </languageVersion> <filename>my_style.sld</filename> <legend> <width>159</width> <height>435</height> <format>image/png;charset=UTF-8</format> <onlineResource>legend.png</onlineResource> </legend> Cheers, Peter On 22. 11. 2016 17:55, Devin Eyre wrote: Yesterday, the windbarbs began working on the new server. The error below is actually for the legend. I have uploaded legend graphics to the styles directory on the server, but a call to getLegendGraphic does not return them. Is there a different format other than just an image file that's needed for this to work? *From:* Devin Eyre *Sent:* Monday, November 21, 2016 9:19 AM *To:* geoserver-users@lists.sourceforge.net *Subject:* [Geoserver-users] Windbarbs not working in geoserver 2.9.2 We had them working in version 2.9.0. We installed 2.9.2 on a new server (Ubuntu 16.04), and they haven't worked on this server. Is there a plugin that's required to make these work? Below is the error from geoserver's log: ERROR [geoserver.ows] - java.lang.IllegalArgumentException: The specified mark strConcat([strConcat([windbarbs://default(], [magnitude])], [)[mph]]) was not found! at org.geotools.renderer.style.SLDStyleFactory.createMarkStyle(SLDStyleFactory.java:713) at org.geotools.renderer.style.SLDStyleFactory.createPointStyle(SLDStyleFactory.java:676) at org.geotools.renderer.style.SLDStyleFactory.createPointStyle(SLDStyleFactory.java:543) at org.geotools.renderer.style.SLDStyleFactory.createStyleInternal(SLDStyleFactory.java:378) at org.geotools.renderer.style.SLDStyleFactory.createStyle(SLDStyleFactory.java:325) at org.geoserver.wms.legendgraphic.BufferedImageLegendGraphicBuilder.buildLegendGraphic(BufferedImageLegendGraphicBuilder.java:413) at org.geoserver.wms.legendgraphic.PNGLegendOutputFormat.produceLegendGraphic(PNGLegendOutputFormat.java:41) at org.geoserver.wms.legendgraphic.PNGLegendOutputFormat.produceLegendGraphic(PNGLegendOutputFormat.java:22) at org.geoserver.wms.GetLegendGraphic.run(GetLegendGraphic.java:49) at org.geoserver.wms.DefaultWebMapService.getLegendGraphic(DefaultWebMapService.java:349) at sun.reflect.GeneratedMethodAccessor412.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.geoserver.kml.WebMapServiceKmlInterceptor.invoke(WebMapServiceKmlInterceptor.java:34) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.geoserver.ows.util.RequestObjectLogger.invoke(RequestObjectLogger.java:55) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- ___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] SLD question - AlphaChannel RGBA Raster
Hi Danilo, have you tried using the default Raster style that's bundled with GeoServer? I'm using it on RGBA images and transparency works fine. Regards, Peter Kovac On 16. 8. 2017 23:28, Danilo da Silveira Figueira wrote: Hi all, I have the following working Sld for a RGB raster: http://www.opengis.net/sld; xmlns:sld="http://www.opengis.net/sld; xmlns:gml="http://www.opengis.net/gml; xmlns:ogc="http://www.opengis.net/ogc; version="1.0.0"> Default Styler RGB image 3 channels RGB image rgb_general 1 2 3 I have a RGBA raster, where the bands are [Red, Green, Blue, Alpha] to be shown. So i need something like a "AlphaChannel", or "Opacity" values from the 4 band. I dont found nothing in documentation, how to do this?? Ps: I can't use ColorMap because i want all values exactly as in RGB format. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] ImagePyramid using Postgresql for granules
Hi Darell, can you post your indexer.xml configuration for the imagemosaic? Regards, Peter Kovac On 28. 9. 2017 9:59, Darell van der Voort wrote: Hello everybody, I'm running Geoserver 2.11.2 on Java 1.8.0_144 32 bits on Amazon Linux together with Tomcat 9. The plugins I have installed are imagemosaic, imagepyramid, GeowebCache (internal) and Geofence. When using the imagemosaic plugin I am able to use a Postgresql DB for storing the granules and time dimension via a datastore.properties file. The file looks like: SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory schema=database_schema_name Loose\ bbox=true Estimated\ extends=false validate\ connections=true Connection\ timeout=10 preparedStatements=true jndiReferenceName=java:comp/env/jdbc/postgis Which work as expected. However when I add the same file in the imagepyramid datastructure, this setup fails. When I add this datastore.properties in just the lowest level (0) then that level gets configured in a database table, while the higher levels are configured using a shapefile. When I add a datastore.properties to all levels, geoserver returns the following error: 2017-09-28 07:39:40,780 ERROR [gce.imagemosaic] - java.io.IOException at org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createGranuleCatalogFromDatastore(ImageMosaicConfigHandler.java:406) at org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createCatalog(ImageMosaicConfigHandler.java:329) at org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.buildCatalog(ImageMosaicConfigHandler.java:962) at org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.indexingPreamble(ImageMosaicConfigHandler.java:941) at org.geotools.gce.imagemosaic.ImageMosaicDirectoryWalker$MosaicDirectoryWalker.(ImageMosaicDirectoryWalker.java:109) at org.geotools.gce.imagemosaic.ImageMosaicDirectoryWalker.run(ImageMosaicDirectoryWalker.java:197) at org.geotools.gce.imagemosaic.Utils.createMosaic(Utils.java:460) at org.geotools.gce.imagemosaic.Utils.checkSource(Utils.java:1336) at org.geotools.gce.imagemosaic.ImageMosaicReader.initReaderFromURL(ImageMosaicReader.java:532) at org.geotools.gce.imagemosaic.ImageMosaicReader.(ImageMosaicReader.java:479) at org.geotools.gce.imagemosaic.ImageMosaicFormat.getReader(ImageMosaicFormat.java:504) at org.geotools.gce.imagepyramid.Utils.checkSource(Utils.java:200) at org.geotools.gce.imagepyramid.ImagePyramidReader.(ImagePyramidReader.java:177) at org.geotools.gce.imagepyramid.ImagePyramidFormat.getReader(ImagePyramidFormat.java:249) at org.geotools.gce.imagepyramid.ImagePyramidFormat.getReader(ImagePyramidFormat.java:56) at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1511) at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1441) at org.geoserver.catalog.impl.CoverageStoreInfoImpl.getGridCoverageReader(CoverageStoreInfoImpl.java:59) . at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:264) at org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createGranuleCatalogFromDatastore(ImageMosaicConfigHandler.java:389) ... 160 more Is it possible to configure the granules of all levels in the database? And if so, how would my datastore.properties file look like? Like I said, it works fine for the lowest level (0) but it fails for all the levels above. If it may not be possible, is it sufficient to use the shapefiles as an index for the granules? The geoserver is used in a production environment and I am worried about performance issues when using the shapefiles as index. Furthermore the imagepyramid automatically names the table after the level folder (0). This folder and table name are automatically created when configuring the datastore. Is there a way to custom name the folder and thus the table name? Otherwise I could end up with multiple '0' tables in the same schema. Many thanks! Kind regards, Darell -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Peter Kovac IMS Programmer MicroStep-MIS peter.ko...@microstep-mis.com -- Check out the vibrant tech community
Re: [Geoserver-users] ImagePyramid using Postgresql for granules
I usually configure ImageMosaic for time-series plain GeoTIFF granules so my advice might not be 100% accurate but I hope it helps anyway. Firstly, your schema seems wrong to me: you have two types specified for ingestion - java.util.Date and a Double after that. Perhaps another attribute of double type is missing or the :Double part should be deleted. Otherwise, I recommend using indexer.xml instead of indexer.properties for configuration. In your case it might look like this: ref="timeCollector">ingestion *the_geom:Polygon,location:String,ingestion:java.util.Date your_coverage_name regex=([0-9]{14}),format=MMddHHmmss,fullPath=true TimestampFileNameExtractorSPI ingestion value="/path/to/directory/to/be/indexed" /> Usually my ImageMosaic folder structure is like this (/opt/geoserver_data is the GEOSERVER_DATA_DIR) * the indexer.xml and datastore.properties files are in a /opt/geoserver_data/data/ * there is a subdirectory, usually with a date tree structure for storing granules from separate days in separate directories: /opt/geoserver_data/data//tiff//MM/DD/some_file_MMDDHHmss.tiff * in indexer.xml I have *Recursive *parameter set to *true ** I usually use absolute path to the tiff directory as *IndexingDirectories* parameter value, e.g. /opt/geoserver_data/data//tiff Finally, if I encounter any problems during ImageMosaic creation I ensure to: * set GeoServer logging to VERBOSE * drop any database table created (ImageMosaic will refuse to create store if a table with the same name already exists), along with index and metadata (if using Oracle) * try it again and look into the log (usually the problem is not revealed in the last stacktrace in the log, but in some before last) * if it doesn't help or I still cannot figure out what is wrong I launch Eclipse debugger and examine what EXACTLY is wrong (I used it a lot until I figured out how to properly configure time parsing regexes) Regards, Peter Kovac On 29. 9. 2017 10:40, Darell van der Voort wrote: Hi Peter, This is my indexer.properties configuration: Caching=false TimeAttribute=ingestion Schema=*the_geom:Polygon,location:String,ingestion:java.util.Date:Double PropertyCollectors=TimestampFileNameExtractorSPI[timeregex](ingestion) And this is my 0.properties which is automatically generated for the lowest zoomlevel (0): #-Automagically created from GeoTools- #Wed Sep 27 14:50:18 UTC 2017 MosaicCRS=EPSG\:32617 Levels=0.062,0.062 Heterogeneous=false TimeAttribute=ingestion AbsolutePath=false Name=0 TypeName=0 Caching=false ExpandToRGB=false LocationAttribute=location SuggestedSPI=it.geosolutions.imageioimpl.plugins.tiff.TIFFImageReaderSpi CheckAuxiliaryMetadata=false LevelsNum=1 So like I said, the plugin automatically configures level 0 to the PostgreSQL DB if I add the datastore.properties files, but refuses to do so for other levels if I add the datastore.properties file to the folder levels. If I do not add the datastore.properties file to the additional levels, the plugin automatically creates a shapefile for these levels, while using the DB connection for level 0. This combination works, even with a time dimension. However I would like to use the DB connection for all levels and use unique table names in the DB. Kind regards, Darell On Fri, Sep 29, 2017 at 9:59 AM, Peter Kovac <peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>> wrote: Hi Darell, can you post your indexer.xml configuration for the imagemosaic? Regards, Peter Kovac On 28. 9. 2017 9:59, Darell van der Voort wrote: Hello everybody, I'm running Geoserver 2.11.2 on Java 1.8.0_144 32 bits on Amazon Linux together with Tomcat 9. The plugins I have installed are imagemosaic, imagepyramid, GeowebCache (internal) and Geofence. When using the imagemosaic plugin I am able to use a Postgresql DB for storing the granules and time dimension via a datastore.properties file. The file looks like: SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory schema=database_schema_name Loose\ bbox=true Estimated\ extends=false validate\ connections=true Connection\ timeout=10 preparedStatements=true jndiReferenceName=java:comp/env/jdbc/postgis Which work as expected. However when I add the same file in the imagepyramid datastructure, this setup fails. When I add this datastore.properties in just the lowest level (0) then that level gets configured in a database table, while the higher levels are configured using a shapefile. When I add a datastore.properties to all levels, geoserver returns the following error: 2017-09-
Re: [Geoserver-users] SLD issue with UTC time in TextSymbolizer Label
Hi Ricardo, is your data source an Oracle database? I used to have some trouble when I had DATE columns in Oracle (which, interestingly, stores also the time information, despite its type name). I proposed a fix for my use case and it has landed on 2.12, but there might be other code paths which were not covered. My issue had the same symptoms as yours - TIMESTAMP output appeared with time information zeroed. Regards, Peter Kovac On 14. 11. 2017 17:39, PEREIRA Ricardo (EMSA) wrote: Dear Andrea, In fact it is a SQL Timestamp. Cheers, Ricardo Pereira *From:*andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf Of *Andrea Aime *Sent:* Thursday, November 9, 2017 11:08 AM *To:* PEREIRA Ricardo (EMSA); GeoServer Mailing List List *Cc:* Ian Turton *Subject:* Re: [Geoserver-users] SLD issue with UTC time in TextSymbolizer Label (please keep the conversation on the list) That is weird, but I'm wondering... is the data in the data source actually a timestamp (e.g., SQL TIMESTAP)? Or is it a string? Cheers Andrea On Wed, Nov 8, 2017 at 5:49 PM, PEREIRA Ricardo (EMSA) <ricardo.pere...@emsa.europa.eu <mailto:ricardo.pere...@emsa.europa.eu>> wrote: Dear Andrea, Yes… Please take a look on the attached picture. Regards, Ricardo *From:*andrea.a...@gmail.com <mailto:andrea.a...@gmail.com> [mailto:andrea.a...@gmail.com <mailto:andrea.a...@gmail.com>] *On Behalf Of *Andrea Aime *Sent:* Wednesday, November 8, 2017 3:22 PM *To:* PEREIRA Ricardo (EMSA) *Cc:* Ian Turton; geoserver-users@lists.sourceforge.net <mailto:geoserver-users@lists.sourceforge.net> *Subject:* Re: [Geoserver-users] SLD issue with UTC time in TextSymbolizer Label Hi Ricardo, what is the data source? If you do a WFS request do you get the full time? What about doing a GetFeatureInfo in the map preview on that polygon? Cheers Andrea On Wed, Nov 8, 2017 at 12:55 PM, PEREIRA Ricardo (EMSA) <ricardo.pere...@emsa.europa.eu <mailto:ricardo.pere...@emsa.europa.eu>> wrote: Dear Ian, Thank you for your suggestion. Well, I don’t really mind with the wrapping, but I am wondering why the hours/minutes/seconds are set to “00:00:00+” as I was expecting “15:20:10Z” in this case. Cheers, Ricardo Pereira *From:*Ian Turton [mailto:ijtur...@gmail.com <mailto:ijtur...@gmail.com>] *Sent:* Wednesday, November 8, 2017 11:49 AM *To:* PEREIRA Ricardo (EMSA) *Cc:* Andrea Aime; geoserver-users@lists.sourceforge.net <mailto:geoserver-users@lists.sourceforge.net> *Subject:* Re: [Geoserver-users] SLD issue with UTC time in TextSymbolizer Label Since you have set - 60 - that is exactly what I would expect. You have asked GeoServer to wrap any label at 60px wide. Ian On 8 November 2017 at 11:44, PEREIRA Ricardo (EMSA) <ricardo.pere...@emsa.europa.eu <mailto:ricardo.pere...@emsa.europa.eu>> wrote: Dear Ian, dear Andrea, Below you may find the TextSymbolizer portion and also the .png version of the previous image. -MM-dd'T'HH:mm:ssZ some_time_property Arial 9 normal bold 0.5 0.5 #00 60 150 Thank you very much for your support, Ricardo Pereira *From:*Ian Turton [mailto:ijtur...@gmail.com <mailto:ijtur...@gmail.com>] *Sent:* Wednesday, November 8, 2017 11:37 AM *To:* PEREIRA Ricardo (EMSA) *Cc:* geoserver-users@lists.sourceforge.net <mailto:geoserver-users@lists.sourceforge.net> *Subject:* Re: [Geoserver-users] SLD issue with UTC time in TextSymbolizer Label We'd need to see the rest of the TextSymbolizer to see what was going on. Also, a larger or png image might help. Ian On 8 November 2017 at 11:10, PEREIRA Ricardo (EMSA) <ricardo.pere...@emsa.europa.eu <mailto:ricardo.pere...@emsa.europa.eu>> wrote: Hi, After reading the GeoServer documentation for the dateFormat function <http://docs.geoserver.org/stable/en/user/filter/function_reference.html> under a SLD style, I put the following in my style: -MM-dd'T'HH:mm:ss.sssZ some_time_property When applying the above, I obtain the following result (some_time_property: 2017-11-11 15:20:10.952): -Do you have an idea what I am missing or if it is even possible to show times in this format? Ricardo Pereira -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 Geoserver-users@lists.sourceforge.net <mailto:Geoserver-users@lists.sourceforge.net