Re: [Geoserver-users] GeoServer 2.6.3 Released

[Andrea Aime]

On Mon, Apr 20, 2015 at 10:10 PM, Chris Snider 
wrote:

>  Was wondering if  the release is 2.6.3 as most of the pointers are and
> the first sentence is a typo (2.6.4) or if it is 2.6.4 and the .3 are typos
> (question from one of my users).
>

It's 2.6.3, version 2.6.4 is going to be in two months:
https://github.com/geoserver/geoserver/wiki/Release-Schedule

Cheers
Andrea


-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] GeoServer 2.6.3 Released

[Chris Snider]

Was wondering if  the release is 2.6.3 as most of the pointers are and the 
first sentence is a typo (2.6.4) or if it is 2.6.4 and the .3 are typos 
(question from one of my users).

Chris Snider
Senior Software Engineer
Intelligent Software Solutions, Inc.
[Description: Description: Description: cid:image001.png@01CA1F1F.CBC93990]

From: Jody Garnett [mailto:jody.garn...@gmail.com]
Sent: Monday, April 20, 2015 11:02 AM
To: geoserver-users
Subject: [Geoserver-users] GeoServer 2.6.3 Released


The GeoServer team is happy to announce the release of GeoServer 2.6.4.

The release is available for download from: http://geoserver.org/release/2.6.3/

GeoServer 2.6.3 is a maintenance release of GeoServer recommended for 
production deployment. Thanks to everyone taking part, submitting fixes and new 
functionality:
· The WPS download community module is now available on the 2.6.x 
branch too
· Some WPS fixes related to requests not including the response form
· Fixed layer naming regression that prevented non XML valid names to 
be used for coverages (care on naming is still advised, different protocols 
have different requirements, check the ones you are using)
· Some WFS 2.0 join related fixes
· Speed up generation of JSON files when the native CRS is EPSG:900913
· Avoid leaks of commons-httpclient pools (which in turn can lead to a 
native thread leak)
· Check the release 
notes 
for more details
· This release is made in conjunction with GeoTools 12.3

Thanks to Andrea (GeoSolutions), Jody (Boundless) for this release
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Ahmet Temiz]

thank you

here is the excerpt from PostGIS Cookbook:

~
$ raster2pgsql -I -C -F -t 100x100 -s 4326 worldclim/tmax01.bil chp01.
tmax01 > tmax01.sql

If you decide to include the -t option, then you will cut the original
raster in tiles, each
inserted as a single row in the raster table. In this case, you decided to
cut the raster in
100x100 tiles, resulting in 198 table rows in the raster table.

pg. 45
~~

what do you say about my gdalinfo output?

regards



On Mon, Apr 20, 2015 at 4:53 PM, Christian Mueller <
christian.muel...@os-solutions.at> wrote:

> If raster2pgsql creates tiles (and overviews)  itself, you can omit
> gdal_retile. AFAIK, this was not possible at the time I wrote the
> documentation.
>
> Cheers
> Christian
>
>
>
>
>
>
>
>
> On Mon, Apr 20, 2015 at 3:39 PM, Ahmet Temiz 
> wrote:
>
>> thank you and sorry taking up your time
>>
>> untiled whole image can be loaded to postgis  with raster2pgsql normally.
>>
>> but when I tiled same image with:
>> gdal_retile.py -levels 3 -ps 256 256 -tileIndex index.shp -targetDir
>> test2 dem2_4326.tif
>>
>> gdalinfo looks like :
>>
>> orkun@orkun-HP-EliteBook-8470p:/usr/local/dem22/test2$ gdalinfo
>> dem2_4326_06_14.tif
>> Driver: GTiff/GeoTIFF
>> Files: dem2_4326_06_14.tif
>>dem2_4326_06_14.tfw
>>dem2_4326_06_14.tif.aux.xml
>> Size is 150, 101
>> Coordinate System is:
>> GEOGCS["WGS 84",
>> DATUM["WGS_1984",
>> SPHEROID["WGS 84",6378137,298.257223563,
>> AUTHORITY["EPSG","7030"]],
>> AUTHORITY["EPSG","6326"]],
>> PRIMEM["Greenwich",0],
>> UNIT["degree",0.0174532925199433],
>> AUTHORITY["EPSG","4326"]]
>> Origin = (29.526600914328423,40.467521186796759)
>> Pixel Size = (0.000225018604065,-0.000225018604065)
>> Metadata:
>>   AREA_OR_POINT=Area
>> Image Structure Metadata:
>>   INTERLEAVE=BAND
>> Corner Coordinates:
>> Upper Left  (  29.5266009,  40.4675212) ( 29d31'35.76"E, 40d28' 3.08"N)
>> Lower Left  (  29.5266009,  40.4447943) ( 29d31'35.76"E, 40d26'41.26"N)
>> Upper Right (  29.5603537,  40.4675212) ( 29d33'37.27"E, 40d28' 3.08"N)
>> Lower Right (  29.5603537,  40.4447943) ( 29d33'37.27"E, 40d26'41.26"N)
>> Center  (  29.5434773,  40.4561577) ( 29d32'36.52"E, 40d27'22.17"N)
>> Band 1 Block=150x27 Type=Int16, ColorInterp=Gray
>>   Min=0.000 Max=0.000
>>   Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
>>   Metadata:
>> STATISTICS_MAXIMUM=0
>> STATISTICS_MEAN=0
>> STATISTICS_MINIMUM=0
>> STATISTICS_STDDEV=0
>>
>> ---
>>
>> One more question
>> raster2pgsql  creates tiles so why do we need gdal_retile as extra work ?
>>
>> regards
>>
>>
>> On Mon, Apr 20, 2015 at 4:20 PM, Christian Mueller <
>> christian.muel...@os-solutions.at> wrote:
>>
>>> Check your tile with
>>>
>>> gdalinfo /test3/dem2_4326_06_14.tif
>>>
>>> Additionally try to import only the problematic tiff.
>>>
>>> Cheers
>>> Christian
>>>
>>> On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz 
>>> wrote:
>>>
 (Thank you Christian ,)

 when I tried raster2pgsql on tiles created previously with
 gdal_retile.py, I got this error message

 Processing 84/84: ./test3/dem2_4326_06_14.tif
 ERROR: diff_rastinfo: Could not run raster alignment test

 Do you have any idea ?

 regards




 On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <
 christian.muel...@os-solutions.at> wrote:

> Yep, here is the manual
>
>
> http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
>
> Cheers
> Christian
>
> On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz 
> wrote:
>
>> thank you Christian,
>>
>> So, Is this way correct ?
>>
>>  after generating tiles with gdal_retile.py,
>>
>> using these tiles, creating raster table with :
>>
>> raster2pgsql -s 4236 -I -C -M *.tif 
>>
>> regards
>>
>>
>>
>> On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <
>> christian.muel...@os-solutions.at> wrote:
>>
>>> Hi Ahmet
>>>
>>> For populating postgis raster you have to use the postgis import
>>> tool.
>>>
>>> Look here
>>> http://postgis.net/docs/using_raster_dataman.html
>>>
>>> Cheers
>>>
>>> On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz >> > wrote:
>>>
 hello

 I am trying to populate postgis raster table with  "
 gt-imagemosaic-jdbc-12.2.jar import  "

 I got this structure in postgis :

 ---
 tr2=> \d spatialtable_0
Table "public.spatialtable_0"
   Column  |Type | Modifiers
 --+-+---
  location | character(64)   | not null
  geom | geometry(MultiPolygon,4326) |
 Indexes:
 "spatialtable_0_pk" PRIMARY KEY, btree (location)

[Geoserver-users] GeoServer 2.6.3 Released

[Jody Garnett]

The GeoServer team is happy to announce the release of GeoServer 2.6.4.

The release is available for download from:
http://geoserver.org/release/2.6.3/

GeoServer 2.6.3 is a maintenance release of GeoServer recommended for
production deployment. Thanks to everyone taking part, submitting fixes and
new functionality:

   - The WPS download community module is now available on the 2.6.x branch
   too
   - Some WPS fixes related to requests not including the response form
   - Fixed layer naming regression that prevented non XML valid names to be
   used for coverages (care on naming is still advised, different protocols
   have different requirements, check the ones you are using)
   - Some WFS 2.0 join related fixes
   - Speed up generation of JSON files when the native CRS is EPSG:900913
   - Avoid leaks of commons-httpclient pools (which in turn can lead to a
   native thread leak)
   - Check the release notes
    for
   more details
   - This release is made in conjunction with GeoTools 12.3

Thanks to Andrea (GeoSolutions), Jody (Boundless) for this release
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Is there a way to change geowebcache naming convention to store tiles in z/y/x format on disk?

[Andrea Aime]

On Mon, Apr 20, 2015 at 5:16 PM,  wrote:

> Hi,
>
> Is there a way to change geowebcache naming convention to store tiles in
> z/y/x format on disk? I would prefer not to fool around with
> FilePathGenerator.java.
>

As another option, you'd have to plug-in a different BlobStore, which you'd
have to write.
Cleaner, more work than just fooling around FilePathGenerator

Mind, the z/y/x approach will work fine only on small pyramids, and/or on
selected file systems (ones that can handle millions
of files in a single directory, a single row of tiles, worldwide map,
should be around a million files at zoom level 20)

Cheers
Andrea

-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] Is there a way to change geowebcache naming convention to store tiles in z/y/x format on disk?

[stoffel]

Hi,

Is there a way to change geowebcache naming convention to store tiles in 
z/y/x format on disk? I would prefer not to fool around with 
FilePathGenerator.java.

Do you have any idea?

Best regards --
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Is Oracle Locator sufficient or do I need Oracle Spatial?

[Andrea Aime]

On Mon, Apr 20, 2015 at 3:30 PM, Nachtigall, Jens (init) <
jens.nachtig...@init.de> wrote:

>  Hi all,
>
>
>
> for an upcoming project I will store point geometries in a Oracle DB. This
> DB will serve as a data store for GeoServer which will be used for WMS
> Requests. As I understand it Oracle handles the bounding box calculations
> (on behalf of GeoServer), when there is a WMS request for certain features
> in a bbox. In Oracle there seem to be two function for this: SDO_RELATE
> (which is in Locator version) and SDO_GEOM.RELATE (available only in Oracle
> Spatial). Which one is used by GeoServer?
>
>
>
> I found this relevant link on the question (from 2012):
> http://gis.stackexchange.com/questions/36751/querying-intersecting-areas-areas-oracle-locator-or-spatial
> In the answer it says:
>
>
>
> *I once had to trace a GeoServer WMS query in Oracle and I'm pretty sure
> it used the SDO_RELATE approach, but you might want to verify this using
> your own trace, scanning through the GeoServer source, or posting a
> question on the GeoServer users mailing list*
>
>
>
> Since I am not sure, I thought I’d just ask here ;-)
>

We use SDO_RELATE. When I have to make Oracle tests, I normally do them
against a Oracle XE, which, as far as I know, does not have a full Oracle
Spatial inside, and all appears to work fine.

Cheers
Andrea

-- 
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*

Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
loro utilizzo è consentito esclusivamente al destinatario del messaggio,
per le finalità indicate nel messaggio stesso. Qualora riceviate questo
messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
darcene notizia via e-mail e di procedere alla distruzione del messaggio
stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
utilizzarlo per finalità diverse, costituisce comportamento contrario ai
principi dettati dal D.Lgs. 196/2003.



The information in this message and/or attachments, is intended solely for
the attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act
(Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
Code).Any use not in accord with its purpose, any disclosure, reproduction,
copying, distribution, or either dissemination, either whole or partial, is
strictly forbidden except previous formal approval of the named
addressee(s). If you are not the intended recipient, please contact
immediately the sender by telephone, fax or e-mail and delete the
information in this message that has been received in error. The sender
does not give any warranty or accept liability as the content, accuracy or
completeness of sent messages and accepts no responsibility  for changes
made after they were sent or for other risks which arise as a result of
e-mail transmission, viruses, etc.

---
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] CSS Styling question

[Zsolt Magyar]

Is it possible to add CSS stlye stroke-dasharray: 20 50; in meters?
Like: stroke-dasharray: 20m 50m;
I think it is impossible.
Only in SLD with: uom="http://www.opengeospatial.org/se/units/metre";

Am I right?

2015-04-15 10:14 GMT+02:00 Andrea Aime :
> On Wed, Apr 15, 2015 at 10:09 AM, Zsolt Magyar  wrote:
>>
>> Thank You Andrea!
>>
>> Yes ok. I understand the (2) indexes. Now it's works fine. The
>> specific selector setting was my problem!
>
>
> Glad to hear the problem has been solved :-)
>
> Cheers
> Andrea
>
>
> --
> ==
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/NWWaa2 for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39  339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
> file/s allegato/i sono da considerarsi strettamente riservate. Il loro
> utilizzo è consentito esclusivamente al destinatario del messaggio, per le
> finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio
> senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia
> via e-mail e di procedere alla distruzione del messaggio stesso,
> cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo
> anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per
> finalità diverse, costituisce comportamento contrario ai principi dettati
> dal D.Lgs. 196/2003.
>
>
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender does
> not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility  for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
>
>
> ---

--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Christian Mueller]

If raster2pgsql creates tiles (and overviews)  itself, you can omit
gdal_retile. AFAIK, this was not possible at the time I wrote the
documentation.

Cheers
Christian








On Mon, Apr 20, 2015 at 3:39 PM, Ahmet Temiz  wrote:

> thank you and sorry taking up your time
>
> untiled whole image can be loaded to postgis  with raster2pgsql normally.
>
> but when I tiled same image with:
> gdal_retile.py -levels 3 -ps 256 256 -tileIndex index.shp -targetDir test2
> dem2_4326.tif
>
> gdalinfo looks like :
>
> orkun@orkun-HP-EliteBook-8470p:/usr/local/dem22/test2$ gdalinfo
> dem2_4326_06_14.tif
> Driver: GTiff/GeoTIFF
> Files: dem2_4326_06_14.tif
>dem2_4326_06_14.tfw
>dem2_4326_06_14.tif.aux.xml
> Size is 150, 101
> Coordinate System is:
> GEOGCS["WGS 84",
> DATUM["WGS_1984",
> SPHEROID["WGS 84",6378137,298.257223563,
> AUTHORITY["EPSG","7030"]],
> AUTHORITY["EPSG","6326"]],
> PRIMEM["Greenwich",0],
> UNIT["degree",0.0174532925199433],
> AUTHORITY["EPSG","4326"]]
> Origin = (29.526600914328423,40.467521186796759)
> Pixel Size = (0.000225018604065,-0.000225018604065)
> Metadata:
>   AREA_OR_POINT=Area
> Image Structure Metadata:
>   INTERLEAVE=BAND
> Corner Coordinates:
> Upper Left  (  29.5266009,  40.4675212) ( 29d31'35.76"E, 40d28' 3.08"N)
> Lower Left  (  29.5266009,  40.4447943) ( 29d31'35.76"E, 40d26'41.26"N)
> Upper Right (  29.5603537,  40.4675212) ( 29d33'37.27"E, 40d28' 3.08"N)
> Lower Right (  29.5603537,  40.4447943) ( 29d33'37.27"E, 40d26'41.26"N)
> Center  (  29.5434773,  40.4561577) ( 29d32'36.52"E, 40d27'22.17"N)
> Band 1 Block=150x27 Type=Int16, ColorInterp=Gray
>   Min=0.000 Max=0.000
>   Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
>   Metadata:
> STATISTICS_MAXIMUM=0
> STATISTICS_MEAN=0
> STATISTICS_MINIMUM=0
> STATISTICS_STDDEV=0
>
> ---
>
> One more question
> raster2pgsql  creates tiles so why do we need gdal_retile as extra work ?
>
> regards
>
>
> On Mon, Apr 20, 2015 at 4:20 PM, Christian Mueller <
> christian.muel...@os-solutions.at> wrote:
>
>> Check your tile with
>>
>> gdalinfo /test3/dem2_4326_06_14.tif
>>
>> Additionally try to import only the problematic tiff.
>>
>> Cheers
>> Christian
>>
>> On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz 
>> wrote:
>>
>>> (Thank you Christian ,)
>>>
>>> when I tried raster2pgsql on tiles created previously with
>>> gdal_retile.py, I got this error message
>>>
>>> Processing 84/84: ./test3/dem2_4326_06_14.tif
>>> ERROR: diff_rastinfo: Could not run raster alignment test
>>>
>>> Do you have any idea ?
>>>
>>> regards
>>>
>>>
>>>
>>>
>>> On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <
>>> christian.muel...@os-solutions.at> wrote:
>>>
 Yep, here is the manual

 http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

 Cheers
 Christian

 On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz 
 wrote:

> thank you Christian,
>
> So, Is this way correct ?
>
>  after generating tiles with gdal_retile.py,
>
> using these tiles, creating raster table with :
>
> raster2pgsql -s 4236 -I -C -M *.tif 
>
> regards
>
>
>
> On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <
> christian.muel...@os-solutions.at> wrote:
>
>> Hi Ahmet
>>
>> For populating postgis raster you have to use the postgis import tool.
>>
>> Look here
>> http://postgis.net/docs/using_raster_dataman.html
>>
>> Cheers
>>
>> On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz 
>> wrote:
>>
>>> hello
>>>
>>> I am trying to populate postgis raster table with  "
>>> gt-imagemosaic-jdbc-12.2.jar import  "
>>>
>>> I got this structure in postgis :
>>>
>>> ---
>>> tr2=> \d spatialtable_0
>>>Table "public.spatialtable_0"
>>>   Column  |Type | Modifiers
>>> --+-+---
>>>  location | character(64)   | not null
>>>  geom | geometry(MultiPolygon,4326) |
>>> Indexes:
>>> "spatialtable_0_pk" PRIMARY KEY, btree (location)
>>> "ix_spatialtable_0" gist (geom)
>>>
>>> tr2=> \d tiletable_0
>>>   Table "public.tiletable_0"
>>>   Column  | Type  | Modifiers
>>> --+---+---
>>>  location | character(64) | not null
>>>  data | bytea |
>>> Indexes:
>>> "tiletable_0_pk" PRIMARY KEY, btree (location)
>>>
>>> ​---
>>>
>>> I am not sure if it is correct structure ?
>>> What am I doing wrong ?
>>>
>>> regards
>>>
>>> --
>>> Ahmet Temiz
>>> Jeoloji Müh.
>>> Afet ve Acil Durum Yönetimi Başkanlığı
>>> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>>>
>>>
>>> 
>>>
>>> Ahmet Temiz
>>> Geological Eng.
>>>

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Ahmet Temiz]

thank you and sorry taking up your time

untiled whole image can be loaded to postgis  with raster2pgsql normally.

but when I tiled same image with:
gdal_retile.py -levels 3 -ps 256 256 -tileIndex index.shp -targetDir test2
dem2_4326.tif

gdalinfo looks like :

orkun@orkun-HP-EliteBook-8470p:/usr/local/dem22/test2$ gdalinfo
dem2_4326_06_14.tif
Driver: GTiff/GeoTIFF
Files: dem2_4326_06_14.tif
   dem2_4326_06_14.tfw
   dem2_4326_06_14.tif.aux.xml
Size is 150, 101
Coordinate System is:
GEOGCS["WGS 84",
DATUM["WGS_1984",
SPHEROID["WGS 84",6378137,298.257223563,
AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich",0],
UNIT["degree",0.0174532925199433],
AUTHORITY["EPSG","4326"]]
Origin = (29.526600914328423,40.467521186796759)
Pixel Size = (0.000225018604065,-0.000225018604065)
Metadata:
  AREA_OR_POINT=Area
Image Structure Metadata:
  INTERLEAVE=BAND
Corner Coordinates:
Upper Left  (  29.5266009,  40.4675212) ( 29d31'35.76"E, 40d28' 3.08"N)
Lower Left  (  29.5266009,  40.4447943) ( 29d31'35.76"E, 40d26'41.26"N)
Upper Right (  29.5603537,  40.4675212) ( 29d33'37.27"E, 40d28' 3.08"N)
Lower Right (  29.5603537,  40.4447943) ( 29d33'37.27"E, 40d26'41.26"N)
Center  (  29.5434773,  40.4561577) ( 29d32'36.52"E, 40d27'22.17"N)
Band 1 Block=150x27 Type=Int16, ColorInterp=Gray
  Min=0.000 Max=0.000
  Minimum=0.000, Maximum=0.000, Mean=0.000, StdDev=0.000
  Metadata:
STATISTICS_MAXIMUM=0
STATISTICS_MEAN=0
STATISTICS_MINIMUM=0
STATISTICS_STDDEV=0

---

One more question
raster2pgsql  creates tiles so why do we need gdal_retile as extra work ?

regards


On Mon, Apr 20, 2015 at 4:20 PM, Christian Mueller <
christian.muel...@os-solutions.at> wrote:

> Check your tile with
>
> gdalinfo /test3/dem2_4326_06_14.tif
>
> Additionally try to import only the problematic tiff.
>
> Cheers
> Christian
>
> On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz 
> wrote:
>
>> (Thank you Christian ,)
>>
>> when I tried raster2pgsql on tiles created previously with
>> gdal_retile.py, I got this error message
>>
>> Processing 84/84: ./test3/dem2_4326_06_14.tif
>> ERROR: diff_rastinfo: Could not run raster alignment test
>>
>> Do you have any idea ?
>>
>> regards
>>
>>
>>
>>
>> On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <
>> christian.muel...@os-solutions.at> wrote:
>>
>>> Yep, here is the manual
>>>
>>> http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
>>>
>>> Cheers
>>> Christian
>>>
>>> On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz 
>>> wrote:
>>>
 thank you Christian,

 So, Is this way correct ?

  after generating tiles with gdal_retile.py,

 using these tiles, creating raster table with :

 raster2pgsql -s 4236 -I -C -M *.tif 

 regards



 On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <
 christian.muel...@os-solutions.at> wrote:

> Hi Ahmet
>
> For populating postgis raster you have to use the postgis import tool.
>
> Look here
> http://postgis.net/docs/using_raster_dataman.html
>
> Cheers
>
> On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz 
> wrote:
>
>> hello
>>
>> I am trying to populate postgis raster table with  "
>> gt-imagemosaic-jdbc-12.2.jar import  "
>>
>> I got this structure in postgis :
>>
>> ---
>> tr2=> \d spatialtable_0
>>Table "public.spatialtable_0"
>>   Column  |Type | Modifiers
>> --+-+---
>>  location | character(64)   | not null
>>  geom | geometry(MultiPolygon,4326) |
>> Indexes:
>> "spatialtable_0_pk" PRIMARY KEY, btree (location)
>> "ix_spatialtable_0" gist (geom)
>>
>> tr2=> \d tiletable_0
>>   Table "public.tiletable_0"
>>   Column  | Type  | Modifiers
>> --+---+---
>>  location | character(64) | not null
>>  data | bytea |
>> Indexes:
>> "tiletable_0_pk" PRIMARY KEY, btree (location)
>>
>> ​---
>>
>> I am not sure if it is correct structure ?
>> What am I doing wrong ?
>>
>> regards
>>
>> --
>> Ahmet Temiz
>> Jeoloji Müh.
>> Afet ve Acil Durum Yönetimi Başkanlığı
>> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>>
>>
>> 
>>
>> Ahmet Temiz
>> Geological Eng.
>> Information Systems - GIS Group
>> Disaster and Emergency Management
>> of Presidency
>>
>>
>> --
>> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
>> Develop your own process in accordance with the BPMN 2 standard
>> Learn Process modeling best practices with Bonita BPM through live
>> exercises
>> http://www.bonitas

[Geoserver-users] Is Oracle Locator sufficient or do I need Oracle Spatial?

[Nachtigall, Jens (init)]

Hi all,

for an upcoming project I will store point geometries in a Oracle DB. This DB 
will serve as a data store for GeoServer which will be used for WMS Requests. 
As I understand it Oracle handles the bounding box calculations (on behalf of 
GeoServer), when there is a WMS request for certain features in a bbox. In 
Oracle there seem to be two function for this: SDO_RELATE (which is in Locator 
version) and SDO_GEOM.RELATE (available only in Oracle Spatial). Which one is 
used by GeoServer?

I found this relevant link on the question (from 2012): 
http://gis.stackexchange.com/questions/36751/querying-intersecting-areas-areas-oracle-locator-or-spatial
 In the answer it says:

I once had to trace a GeoServer WMS query in Oracle and I'm pretty sure it used 
the SDO_RELATE approach, but you might want to verify this using your own 
trace, scanning through the GeoServer source, or posting a question on the 
GeoServer users mailing list

Since I am not sure, I thought I'd just ask here ;-)

The project is just starting off and I need to know whether Locator is 
sufficient or Spatial needs to be purchased (PostGIS cannot be used for other 
reasons).

Best regards,
Jens


--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Christian Mueller]

Check your tile with

gdalinfo /test3/dem2_4326_06_14.tif

Additionally try to import only the problematic tiff.

Cheers
Christian

On Mon, Apr 20, 2015 at 2:57 PM, Ahmet Temiz  wrote:

> (Thank you Christian ,)
>
> when I tried raster2pgsql on tiles created previously with
> gdal_retile.py, I got this error message
>
> Processing 84/84: ./test3/dem2_4326_06_14.tif
> ERROR: diff_rastinfo: Could not run raster alignment test
>
> Do you have any idea ?
>
> regards
>
>
>
>
> On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <
> christian.muel...@os-solutions.at> wrote:
>
>> Yep, here is the manual
>>
>> http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
>>
>> Cheers
>> Christian
>>
>> On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz 
>> wrote:
>>
>>> thank you Christian,
>>>
>>> So, Is this way correct ?
>>>
>>>  after generating tiles with gdal_retile.py,
>>>
>>> using these tiles, creating raster table with :
>>>
>>> raster2pgsql -s 4236 -I -C -M *.tif 
>>>
>>> regards
>>>
>>>
>>>
>>> On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <
>>> christian.muel...@os-solutions.at> wrote:
>>>
 Hi Ahmet

 For populating postgis raster you have to use the postgis import tool.

 Look here
 http://postgis.net/docs/using_raster_dataman.html

 Cheers

 On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz 
 wrote:

> hello
>
> I am trying to populate postgis raster table with  "
> gt-imagemosaic-jdbc-12.2.jar import  "
>
> I got this structure in postgis :
>
> ---
> tr2=> \d spatialtable_0
>Table "public.spatialtable_0"
>   Column  |Type | Modifiers
> --+-+---
>  location | character(64)   | not null
>  geom | geometry(MultiPolygon,4326) |
> Indexes:
> "spatialtable_0_pk" PRIMARY KEY, btree (location)
> "ix_spatialtable_0" gist (geom)
>
> tr2=> \d tiletable_0
>   Table "public.tiletable_0"
>   Column  | Type  | Modifiers
> --+---+---
>  location | character(64) | not null
>  data | bytea |
> Indexes:
> "tiletable_0_pk" PRIMARY KEY, btree (location)
>
> ​---
>
> I am not sure if it is correct structure ?
> What am I doing wrong ?
>
> regards
>
> --
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>
>
> 
>
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
>
>
> --
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live
> exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


 --
 DI Christian Mueller MSc (GIS), MSc (IT-Security)
 OSS Open Source Solutions GmbH


>>>
>>>
>>> --
>>> Ahmet Temiz
>>> Jeoloji Müh.
>>> Afet ve Acil Durum Yönetimi Başkanlığı
>>> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>>>
>>>
>>> 
>>>
>>> Ahmet Temiz
>>> Geological Eng.
>>> Information Systems - GIS Group
>>> Disaster and Emergency Management
>>> of Presidency
>>>
>>
>>
>>
>> --
>> DI Christian Mueller MSc (GIS), MSc (IT-Security)
>> OSS Open Source Solutions GmbH
>>
>>
>
>
> --
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>
>
> 
>
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
>



-- 
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Ahmet Temiz]

(Thank you Christian ,)

when I tried raster2pgsql on tiles created previously with
gdal_retile.py, I got this error message

Processing 84/84: ./test3/dem2_4326_06_14.tif
ERROR: diff_rastinfo: Could not run raster alignment test

Do you have any idea ?

regards




On Mon, Apr 20, 2015 at 11:43 AM, Christian Mueller <
christian.muel...@os-solutions.at> wrote:

> Yep, here is the manual
>
> http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
>
> Cheers
> Christian
>
> On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz 
> wrote:
>
>> thank you Christian,
>>
>> So, Is this way correct ?
>>
>>  after generating tiles with gdal_retile.py,
>>
>> using these tiles, creating raster table with :
>>
>> raster2pgsql -s 4236 -I -C -M *.tif 
>>
>> regards
>>
>>
>>
>> On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <
>> christian.muel...@os-solutions.at> wrote:
>>
>>> Hi Ahmet
>>>
>>> For populating postgis raster you have to use the postgis import tool.
>>>
>>> Look here
>>> http://postgis.net/docs/using_raster_dataman.html
>>>
>>> Cheers
>>>
>>> On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz 
>>> wrote:
>>>
 hello

 I am trying to populate postgis raster table with  "
 gt-imagemosaic-jdbc-12.2.jar import  "

 I got this structure in postgis :

 ---
 tr2=> \d spatialtable_0
Table "public.spatialtable_0"
   Column  |Type | Modifiers
 --+-+---
  location | character(64)   | not null
  geom | geometry(MultiPolygon,4326) |
 Indexes:
 "spatialtable_0_pk" PRIMARY KEY, btree (location)
 "ix_spatialtable_0" gist (geom)

 tr2=> \d tiletable_0
   Table "public.tiletable_0"
   Column  | Type  | Modifiers
 --+---+---
  location | character(64) | not null
  data | bytea |
 Indexes:
 "tiletable_0_pk" PRIMARY KEY, btree (location)

 ​---

 I am not sure if it is correct structure ?
 What am I doing wrong ?

 regards

 --
 Ahmet Temiz
 Jeoloji Müh.
 Afet ve Acil Durum Yönetimi Başkanlığı
 Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu


 

 Ahmet Temiz
 Geological Eng.
 Information Systems - GIS Group
 Disaster and Emergency Management
 of Presidency


 --
 BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
 Develop your own process in accordance with the BPMN 2 standard
 Learn Process modeling best practices with Bonita BPM through live
 exercises
 http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
 event?utm_
 source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
 ___
 Geoserver-users mailing list
 Geoserver-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/geoserver-users


>>>
>>>
>>> --
>>> DI Christian Mueller MSc (GIS), MSc (IT-Security)
>>> OSS Open Source Solutions GmbH
>>>
>>>
>>
>>
>> --
>> Ahmet Temiz
>> Jeoloji Müh.
>> Afet ve Acil Durum Yönetimi Başkanlığı
>> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>>
>>
>> 
>>
>> Ahmet Temiz
>> Geological Eng.
>> Information Systems - GIS Group
>> Disaster and Emergency Management
>> of Presidency
>>
>
>
>
> --
> DI Christian Mueller MSc (GIS), MSc (IT-Security)
> OSS Open Source Solutions GmbH
>
>


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Puppeting Geoserver

[Ian Turton]

For example to set up a workspace (ian) you can GET
http://localhost:8080/geoserver/rest/workspaces/ian.xml  and then when
setting up a new one POST that xm l to
http://localhost:8080/geoserver/rest/workspaces

The same follows for the other resources - I haven't yet found out how to
create a new grid set for GWC but I suspect that I need to change my
endpoint.

Ian

On Mon, Apr 20, 2015 at 1:07 PM Tobias Reinicke  wrote:

> Thanks Ian, good to know.
> When you say grab the REST output - from where would I theoretically be
> grabbing this? The logs?
>
> Thanks
> Toby
>
> On 20 April 2015 at 12:57, Ian Turton  wrote:
>
>> I've been doing something similar with Chef, though I'm falling out of
>> love with it. I went with the configuring with REST - once you have the
>> data loaded the first time you can grab the REST output and then edit as
>> needed and store it for upload later.
>>
>> Ian
>>
>> On Mon, Apr 20, 2015 at 11:53 AM Tobias Reinicke 
>> wrote:
>>
>>> Hello All,
>>>
>>> I am working on a new project and part of it is to use Puppet for
>>> deploying machines, some of which are to have geoserver on them.
>>>
>>> It's not that complex, basically puppet allows you to provision hosts
>>> with files / data / packages etc - whatever you want.
>>>
>>> When it comes to geoserver, I am just getting to a point where I need to
>>> basically tackle configuration. What I am doing at the moment is building a
>>> machine (linux) and installing the pre-reqs (tomcat etc) and then
>>> installing geoserver (all via aptitude). Once that is all up and running I
>>> need to configure it with the data and layers I want. Data isn't an issue -
>>> it's how the config works.
>>>
>>> Currently I am building up my required layers manually via the gui the
>>> way I want, and then take a copy of the 'workspaces' folder which I then
>>> want to inject into any new build of my geoserver machine. (as well as the
>>> data source obviously, local tiff files for now).
>>>
>>> Is this something that might theoretically work?
>>>
>>> What I have found is that my workspace is created as required - as long
>>> as I have;
>>> /workspaces/default.xml
>>> /workspaces/[myworkspace]/namespace.xml
>>> /workspaces/[myworkspace]/workspace.xml
>>>
>>> But continuing down this route, and adding my layers and coverages in
>>> the same way doesn't work.
>>>
>>> I'm aware I could do all this with REST API commands (as well as with
>>> GUI) - and the REST interface is my next port of call, but I'd be
>>> interested in any insights to the above.
>>>
>>> Thanks
>>>
>>> Toby
>>>
>>>
>>>
>>> --
>>> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
>>> Develop your own process in accordance with the BPMN 2 standard
>>> Learn Process modeling best practices with Bonita BPM through live
>>> exercises
>>> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
>>> event?utm_
>>>
>>> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
>>> Geoserver-users mailing list
>>> Geoserver-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>
>
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Puppeting Geoserver

[Tobias Reinicke]

Thanks Ian, good to know.
When you say grab the REST output - from where would I theoretically be
grabbing this? The logs?

Thanks
Toby

On 20 April 2015 at 12:57, Ian Turton  wrote:

> I've been doing something similar with Chef, though I'm falling out of
> love with it. I went with the configuring with REST - once you have the
> data loaded the first time you can grab the REST output and then edit as
> needed and store it for upload later.
>
> Ian
>
> On Mon, Apr 20, 2015 at 11:53 AM Tobias Reinicke 
> wrote:
>
>> Hello All,
>>
>> I am working on a new project and part of it is to use Puppet for
>> deploying machines, some of which are to have geoserver on them.
>>
>> It's not that complex, basically puppet allows you to provision hosts
>> with files / data / packages etc - whatever you want.
>>
>> When it comes to geoserver, I am just getting to a point where I need to
>> basically tackle configuration. What I am doing at the moment is building a
>> machine (linux) and installing the pre-reqs (tomcat etc) and then
>> installing geoserver (all via aptitude). Once that is all up and running I
>> need to configure it with the data and layers I want. Data isn't an issue -
>> it's how the config works.
>>
>> Currently I am building up my required layers manually via the gui the
>> way I want, and then take a copy of the 'workspaces' folder which I then
>> want to inject into any new build of my geoserver machine. (as well as the
>> data source obviously, local tiff files for now).
>>
>> Is this something that might theoretically work?
>>
>> What I have found is that my workspace is created as required - as long
>> as I have;
>> /workspaces/default.xml
>> /workspaces/[myworkspace]/namespace.xml
>> /workspaces/[myworkspace]/workspace.xml
>>
>> But continuing down this route, and adding my layers and coverages in the
>> same way doesn't work.
>>
>> I'm aware I could do all this with REST API commands (as well as with
>> GUI) - and the REST interface is my next port of call, but I'd be
>> interested in any insights to the above.
>>
>> Thanks
>>
>> Toby
>>
>>
>>
>> --
>> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
>> Develop your own process in accordance with the BPMN 2 standard
>> Learn Process modeling best practices with Bonita BPM through live
>> exercises
>> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
>> event?utm_
>>
>> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Puppeting Geoserver

[Ian Turton]

I've been doing something similar with Chef, though I'm falling out of love
with it. I went with the configuring with REST - once you have the data
loaded the first time you can grab the REST output and then edit as needed
and store it for upload later.

Ian

On Mon, Apr 20, 2015 at 11:53 AM Tobias Reinicke  wrote:

> Hello All,
>
> I am working on a new project and part of it is to use Puppet for
> deploying machines, some of which are to have geoserver on them.
>
> It's not that complex, basically puppet allows you to provision hosts with
> files / data / packages etc - whatever you want.
>
> When it comes to geoserver, I am just getting to a point where I need to
> basically tackle configuration. What I am doing at the moment is building a
> machine (linux) and installing the pre-reqs (tomcat etc) and then
> installing geoserver (all via aptitude). Once that is all up and running I
> need to configure it with the data and layers I want. Data isn't an issue -
> it's how the config works.
>
> Currently I am building up my required layers manually via the gui the way
> I want, and then take a copy of the 'workspaces' folder which I then want
> to inject into any new build of my geoserver machine. (as well as the data
> source obviously, local tiff files for now).
>
> Is this something that might theoretically work?
>
> What I have found is that my workspace is created as required - as long as
> I have;
> /workspaces/default.xml
> /workspaces/[myworkspace]/namespace.xml
> /workspaces/[myworkspace]/workspace.xml
>
> But continuing down this route, and adding my layers and coverages in the
> same way doesn't work.
>
> I'm aware I could do all this with REST API commands (as well as with GUI)
> - and the REST interface is my next port of call, but I'd be interested in
> any insights to the above.
>
> Thanks
>
> Toby
>
>
>
> --
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live
> exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> event?utm_
>
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] Puppeting Geoserver

[Tobias Reinicke]

Hello All,

I am working on a new project and part of it is to use Puppet for deploying
machines, some of which are to have geoserver on them.

It's not that complex, basically puppet allows you to provision hosts with
files / data / packages etc - whatever you want.

When it comes to geoserver, I am just getting to a point where I need to
basically tackle configuration. What I am doing at the moment is building a
machine (linux) and installing the pre-reqs (tomcat etc) and then
installing geoserver (all via aptitude). Once that is all up and running I
need to configure it with the data and layers I want. Data isn't an issue -
it's how the config works.

Currently I am building up my required layers manually via the gui the way
I want, and then take a copy of the 'workspaces' folder which I then want
to inject into any new build of my geoserver machine. (as well as the data
source obviously, local tiff files for now).

Is this something that might theoretically work?

What I have found is that my workspace is created as required - as long as
I have;
/workspaces/default.xml
/workspaces/[myworkspace]/namespace.xml
/workspaces/[myworkspace]/workspace.xml

But continuing down this route, and adding my layers and coverages in the
same way doesn't work.

I'm aware I could do all this with REST API commands (as well as with GUI)
- and the REST interface is my next port of call, but I'd be interested in
any insights to the above.

Thanks

Toby
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Christian Mueller]

Yep, here is the manual

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Cheers
Christian

On Mon, Apr 20, 2015 at 10:35 AM, Ahmet Temiz 
wrote:

> thank you Christian,
>
> So, Is this way correct ?
>
>  after generating tiles with gdal_retile.py,
>
> using these tiles, creating raster table with :
>
> raster2pgsql -s 4236 -I -C -M *.tif 
>
> regards
>
>
>
> On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <
> christian.muel...@os-solutions.at> wrote:
>
>> Hi Ahmet
>>
>> For populating postgis raster you have to use the postgis import tool.
>>
>> Look here
>> http://postgis.net/docs/using_raster_dataman.html
>>
>> Cheers
>>
>> On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz 
>> wrote:
>>
>>> hello
>>>
>>> I am trying to populate postgis raster table with  "
>>> gt-imagemosaic-jdbc-12.2.jar import  "
>>>
>>> I got this structure in postgis :
>>>
>>> ---
>>> tr2=> \d spatialtable_0
>>>Table "public.spatialtable_0"
>>>   Column  |Type | Modifiers
>>> --+-+---
>>>  location | character(64)   | not null
>>>  geom | geometry(MultiPolygon,4326) |
>>> Indexes:
>>> "spatialtable_0_pk" PRIMARY KEY, btree (location)
>>> "ix_spatialtable_0" gist (geom)
>>>
>>> tr2=> \d tiletable_0
>>>   Table "public.tiletable_0"
>>>   Column  | Type  | Modifiers
>>> --+---+---
>>>  location | character(64) | not null
>>>  data | bytea |
>>> Indexes:
>>> "tiletable_0_pk" PRIMARY KEY, btree (location)
>>>
>>> ​---
>>>
>>> I am not sure if it is correct structure ?
>>> What am I doing wrong ?
>>>
>>> regards
>>>
>>> --
>>> Ahmet Temiz
>>> Jeoloji Müh.
>>> Afet ve Acil Durum Yönetimi Başkanlığı
>>> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>>>
>>>
>>> 
>>>
>>> Ahmet Temiz
>>> Geological Eng.
>>> Information Systems - GIS Group
>>> Disaster and Emergency Management
>>> of Presidency
>>>
>>>
>>> --
>>> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
>>> Develop your own process in accordance with the BPMN 2 standard
>>> Learn Process modeling best practices with Bonita BPM through live
>>> exercises
>>> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
>>> event?utm_
>>> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
>>> ___
>>> Geoserver-users mailing list
>>> Geoserver-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>>>
>>
>>
>> --
>> DI Christian Mueller MSc (GIS), MSc (IT-Security)
>> OSS Open Source Solutions GmbH
>>
>>
>
>
> --
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>
>
> 
>
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
>



-- 
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Ahmet Temiz]

thank you Christian,

So, Is this way correct ?

 after generating tiles with gdal_retile.py,

using these tiles, creating raster table with :

raster2pgsql -s 4236 -I -C -M *.tif 

regards



On Mon, Apr 20, 2015 at 10:31 AM, Christian Mueller <
christian.muel...@os-solutions.at> wrote:

> Hi Ahmet
>
> For populating postgis raster you have to use the postgis import tool.
>
> Look here
> http://postgis.net/docs/using_raster_dataman.html
>
> Cheers
>
> On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz 
> wrote:
>
>> hello
>>
>> I am trying to populate postgis raster table with  "
>> gt-imagemosaic-jdbc-12.2.jar import  "
>>
>> I got this structure in postgis :
>>
>> ---
>> tr2=> \d spatialtable_0
>>Table "public.spatialtable_0"
>>   Column  |Type | Modifiers
>> --+-+---
>>  location | character(64)   | not null
>>  geom | geometry(MultiPolygon,4326) |
>> Indexes:
>> "spatialtable_0_pk" PRIMARY KEY, btree (location)
>> "ix_spatialtable_0" gist (geom)
>>
>> tr2=> \d tiletable_0
>>   Table "public.tiletable_0"
>>   Column  | Type  | Modifiers
>> --+---+---
>>  location | character(64) | not null
>>  data | bytea |
>> Indexes:
>> "tiletable_0_pk" PRIMARY KEY, btree (location)
>>
>> ​---
>>
>> I am not sure if it is correct structure ?
>> What am I doing wrong ?
>>
>> regards
>>
>> --
>> Ahmet Temiz
>> Jeoloji Müh.
>> Afet ve Acil Durum Yönetimi Başkanlığı
>> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>>
>>
>> 
>>
>> Ahmet Temiz
>> Geological Eng.
>> Information Systems - GIS Group
>> Disaster and Emergency Management
>> of Presidency
>>
>>
>> --
>> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
>> Develop your own process in accordance with the BPMN 2 standard
>> Learn Process modeling best practices with Bonita BPM through live
>> exercises
>> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
>> event?utm_
>> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
>> ___
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>
>
>
> --
> DI Christian Mueller MSc (GIS), MSc (IT-Security)
> OSS Open Source Solutions GmbH
>
>


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gt-imagemosaic-jdbc-12.2.jar import creates wrong structure ?

[Christian Mueller]

Hi Ahmet

For populating postgis raster you have to use the postgis import tool.

Look here
http://postgis.net/docs/using_raster_dataman.html

Cheers

On Sun, Apr 19, 2015 at 6:35 PM, Ahmet Temiz  wrote:

> hello
>
> I am trying to populate postgis raster table with  "
> gt-imagemosaic-jdbc-12.2.jar import  "
>
> I got this structure in postgis :
>
> ---
> tr2=> \d spatialtable_0
>Table "public.spatialtable_0"
>   Column  |Type | Modifiers
> --+-+---
>  location | character(64)   | not null
>  geom | geometry(MultiPolygon,4326) |
> Indexes:
> "spatialtable_0_pk" PRIMARY KEY, btree (location)
> "ix_spatialtable_0" gist (geom)
>
> tr2=> \d tiletable_0
>   Table "public.tiletable_0"
>   Column  | Type  | Modifiers
> --+---+---
>  location | character(64) | not null
>  data | bytea |
> Indexes:
> "tiletable_0_pk" PRIMARY KEY, btree (location)
>
> ​---
>
> I am not sure if it is correct structure ?
> What am I doing wrong ?
>
> regards
>
> --
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu
>
>
> 
>
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
>
>
> --
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live
> exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


-- 
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users