I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com
Hi
Are there exceptions int the log file ?
Cherers
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@anonymised.com.382…sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com…84…> wrote:
Gaurav Pathak <yash.pathak18@anonymised.comcom>
Sat, Jul 28, 3:21 PM (2 days ago)
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com.9015… System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@3e10dc6 FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.comsolutions.at> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.comsolutions.at> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com…> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@anonymised.comsourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Please find the zip file containing the configuration files in the directory “coverages” in attachment.
coverages.rar (900 Bytes)
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com16… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com84…> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Please find the zip file containing the configuration files in the directory “coverages” in attachment.
coverages.rar (900 Bytes)
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com16… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
Cheers
Christian
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@anonymised.comsourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.comsolutions.at> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.comcom>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com.9015… System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@3e10dc6 FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.comsolutions.at> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.comsolutions.at> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@anonymised.comsourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Regards
Gaurav Pathak
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@lists.sourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com…>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com16… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com84…> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.com5602…solutions.at> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
Christian
–
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@anonymised.comsourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.comsolutions.at> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.comcom>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com.9015… System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@3e10dc6 FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com.5602…solutions.at> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.comsolutions.at> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@anonymised.comsourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Hi Guarav,
I would begin by making sure PostGIS is installed correctly. By just looking at your error message, it seems like the GDAL driver can’t be found, which is usually (I think) installed with PostGIS. Try running “SELECT PostGIS_full_version();”.
Best,
Todd
On Tue, Jul 31, 2018 at 5:50 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@anonymised.com.382…sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com4…> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.coms.at> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
Christian
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@anonymised.comorge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.coms.at> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.comm>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com… System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.coms.at> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.coms.at> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@anonymised.comrge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
GIS Technician
Office: +1 (303) 284 6144
Mob: +1
Email: tj@anonymised.com
Address: 3015 W 9th Ave, Denver, CO 80204, USA
WWW.TCARTA.COM | TWITTER | LINKED IN |
CONFIDENTIALITY: This message may contain privileged and confidential information intended only for the use of the addressee. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify TCarta immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the Company. Please consider the environment before printing this e-mail.
Hi Todd
After running the query we get output given below:
POSTGIS=“2.4.1 r16012” PGSQL=“96” GEOS=“3.6.2-CAPI-1.10.2 4d2925d” PROJ=“Rel. 4.9.3, 15 August 2016” GDAL=“GDAL 2.2.2, released 2017/09/15 GDAL_DATA not found” LIBXML=“2.7.8” LIBJSON=“0.12” LIBPROTOBUF=“1.2.1” TOPOLOGY RASTER
On Tue, Jul 31, 2018 at 5:50 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
GIS Technician
Office: +1 (303) 284 6144
Mob: +1
Email: tj@anonymised.com
Address: 3015 W 9th Ave, Denver, CO 80204, USA
WWW.TCARTA.COM | TWITTER | LINKED IN |
CONFIDENTIALITY: This message may contain privileged and confidential information intended only for the use of the addressee. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify TCarta immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the Company. Please consider the environment before printing this e-mail.
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
Christian
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@lists.sourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com16… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Dear All
Thanks for your support now my table shown in geoserver image mosiac list but when i convert lattitute ,longitute and value in to raster clumn there saome problem due to my raster not showing
how i convert lat,long and value in to rater column in postgis
Regards
Gaurav Pathak
On Tue, Jul 31, 2018 at 5:50 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
GIS Technician
Office: +1 (303) 284 6144
Mob: +1
Email: tj@anonymised.com
Address: 3015 W 9th Ave, Denver, CO 80204, USA
WWW.TCARTA.COM | TWITTER | LINKED IN |
CONFIDENTIALITY: This message may contain privileged and confidential information intended only for the use of the addressee. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify TCarta immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the Company. Please consider the environment before printing this e-mail.
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
Christian
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@lists.sourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com16… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com.> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com5445…> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Hi
Can you [lease tell me how we use wps request xml in web url to get output as layer
<?xml version="1.0" encoding="UTF-8"?>ows:Identifiergt:VectorToRaster</ows:Identifier>
wps:DataInputs
wps:Input
ows:Identifierfeatures</ows:Identifier>
<wps:Reference mimeType=“text/xml” xlink:href=“http://geoserver/wfs” method=“POST”>
wps:Body
<wfs:GetFeature service=“WFS” version=“1.0.0” outputFormat=“GML2” xmlns:cite=“http://www.opengeospatial.net/cite”>
<wfs:Query typeName=“cite:cg_block_old”/>
</wfs:GetFeature>
</wps:Body>
</wps:Reference>
</wps:Input>
wps:Input
ows:IdentifierrasterWidth</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:IdentifierrasterHeight</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierattribute</ows:Identifier>
wps:Data
wps:LiteralDatabid</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierbounds</ows:Identifier>
wps:Data
<wps:BoundingBoxData crs=“EPSG:4326” dimensions=“2”>
ows:LowerCorner80.2250595092773 17.7496490478516</ows:LowerCorner>
ows:UpperCorner84.419075012207 24.1371479034424</ows:UpperCorner>
</wps:BoundingBoxData>
</wps:Data>
</wps:Input>
</wps:DataInputs>
wps:ResponseForm
<wps:RawDataOutput mimeType=“image/tiff”>
ows:Identifierresult</ows:Identifier>
</wps:RawDataOutput>
</wps:ResponseForm>
</wps:Execute>
On Tue, Jul 31, 2018 at 5:50 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
GIS Technician
Office: +1 (303) 284 6144
Mob: +1
Email: tj@anonymised.com
Address: 3015 W 9th Ave, Denver, CO 80204, USA
WWW.TCARTA.COM | TWITTER | LINKED IN |
CONFIDENTIALITY: This message may contain privileged and confidential information intended only for the use of the addressee. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify TCarta immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the Company. Please consider the environment before printing this e-mail.
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
Christian
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com…84…> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@lists.sourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com16… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
Hi
Can you [lease tell me how we use wps request xml in web url to get output as layer
<?xml version="1.0" encoding="UTF-8"?>ows:Identifiergt:VectorToRaster</ows:Identifier>
wps:DataInputs
wps:Input
ows:Identifierfeatures</ows:Identifier>
<wps:Reference mimeType=“text/xml” xlink:href=“http://geoserver/wfs” method=“POST”>
wps:Body
<wfs:GetFeature service=“WFS” version=“1.0.0” outputFormat=“GML2” xmlns:cite=“http://www.opengeospatial.net/cite”>
<wfs:Query typeName=“cite:cg_block_old”/>
</wfs:GetFeature>
</wps:Body>
</wps:Reference>
</wps:Input>
wps:Input
ows:IdentifierrasterWidth</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:IdentifierrasterHeight</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierattribute</ows:Identifier>
wps:Data
wps:LiteralDatabid</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierbounds</ows:Identifier>
wps:Data
<wps:BoundingBoxData crs=“EPSG:4326” dimensions=“2”>
ows:LowerCorner80.2250595092773 17.7496490478516</ows:LowerCorner>
ows:UpperCorner84.419075012207 24.1371479034424</ows:UpperCorner>
</wps:BoundingBoxData>
</wps:Data>
</wps:Input>
</wps:DataInputs>
wps:ResponseForm
<wps:RawDataOutput mimeType=“image/tiff”>
ows:Identifierresult</ows:Identifier>
</wps:RawDataOutput>
</wps:ResponseForm>
</wps:Execute>
On Tue, Jul 31, 2018 at 5:50 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
GIS Technician
Office: +1 (303) 284 6144
Mob: +1
Email: tj@anonymised.com
Address: 3015 W 9th Ave, Denver, CO 80204, USA
WWW.TCARTA.COM | TWITTER | LINKED IN |
CONFIDENTIALITY: This message may contain privileged and confidential information intended only for the use of the addressee. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify TCarta immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the Company. Please consider the environment before printing this e-mail.
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
Christian
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com.84…> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@lists.sourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com16… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Are there exceptions int the log file ?
Cherers
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
This is a long conversation, but here are my two cents about the issue:
On the PostGIS/PGSQL side: try storing the Lat/Long with values as an actual raster, instead of having to rely on the st_astiff() function from the database.
You cannot hope for the function to have good performance otherwise.
I would suggest interpolating your results, or just simply run a point (lat/long) to raster conversion function from a desktop suite, like QGIS and then store the resulting raster to the database.
Use the DB Manager interface in QGIS to load the raster to the database, making sure to calculate indexes for efficient database query interogation. Once the raster is in the DB then you can register it with Geoserver
On the Geoserver side:
The WPS (web-processing-service) cannot process input data and then store it as a published layer. Publishing a layer requires a multi step workflows startgin with:
setting up a new workspace/ using an existing one to use for the new GS layer
storing the resulting data somewhere, in the filesystem/in postgresql,
configuring a datastore to connect to that piece of data and then publishing the appropriate information
configuring WMS/WFS access to that layer.
All these GS publishing steps can’t, to my knoledge be performed with the WPS module, maybe you can automate some of them from the REST endpoint of GS, however you cannot call the WPS from REST.
The best thing would be to process the XY data into a raster, save it to the database, serve that as WMS/WCS through Geoserver.
Kind regards
Sorin RUSU
Pe luni, 6 august 2018, 08:13:34 EEST, Gaurav Pathak yash.pathak18@anonymised.com a scris:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Wed, Aug 1, 2018 at 5:22 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <tj@anonymised.com>
Cc: Christian Mueller <christian.mueller@anonymised.com>, <Geoserver-users@anonymised.comurceforge.net>
Hi
Can you [lease tell me how we use wps request xml in web url to get output as layer
<?xml version="1.0" encoding="UTF-8"?>ows:Identifiergt:VectorToRaster</ows:Identifier>
wps:DataInputs
wps:Input
ows:Identifierfeatures</ows:Identifier>
<wps:Reference mimeType=“text/xml” xlink:href=“http://geoserver/wfs” method=“POST”>
wps:Body
<wfs:GetFeature service=“WFS” version=“1.0.0” outputFormat=“GML2” xmlns:cite=“http://www.opengeospatial.net/cite”>
<wfs:Query typeName=“cite:cg_block_old”/>
</wfs:GetFeature>
</wps:Body>
</wps:Reference>
</wps:Input>
wps:Input
ows:IdentifierrasterWidth</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:IdentifierrasterHeight</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierattribute</ows:Identifier>
wps:Data
wps:LiteralDatabid</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierbounds</ows:Identifier>
wps:Data
<wps:BoundingBoxData crs=“EPSG:4326” dimensions=“2”>
ows:LowerCorner80.2250595092773 17.7496490478516</ows:LowerCorner>
ows:UpperCorner84.419075012207 24.1371479034424</ows:UpperCorner>
</wps:BoundingBoxData>
</wps:Data>
</wps:Input>
</wps:DataInputs>
wps:ResponseForm
<wps:RawDataOutput mimeType=“image/tiff”>
ows:Identifierresult</ows:Identifier>
</wps:RawDataOutput>
</wps:ResponseForm>
</wps:Execute>
On Wed, Aug 1, 2018 at 1:05 PM Gaurav Pathak <yash.pathak18@anonymised.com84…> wrote:
Dear All
Thanks for your support now my table shown in geoserver image mosiac list but when i convert lattitute ,longitute and value in to raster clumn there saome problem due to my raster not showing
how i convert lat,long and value in to rater column in postgis
Regards
Gaurav Pathak
On Wed, Aug 1, 2018 at 10:46 AM Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi Todd
After running the query we get output given below:
POSTGIS=“2.4.1 r16012” PGSQL=“96” GEOS=“3.6.2-CAPI-1.10.2 4d2925d” PROJ=“Rel. 4.9.3, 15 August 2016” GDAL=“GDAL 2.2.2, released 2017/09/15 GDAL_DATA not found” LIBXML=“2.7.8” LIBJSON=“0.12” LIBPROTOBUF=“1.2.1” TOPOLOGY RASTER
On Tue, Jul 31, 2018 at 7:39 PM Todd Jacobus <tj@anonymised.com> wrote:
Hi Guarav,
I would begin by making sure PostGIS is installed correctly. By just looking at your error message, it seems like the GDAL driver can’t be found, which is usually (I think) installed with PostGIS. Try running “SELECT PostGIS_full_version();”.
Best,
ToddOn Tue, Jul 31, 2018 at 5:50 AM, Christian Mueller <christian.mueller@anonymised.com445…> wrote:
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
ChristianOn Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@lists.sourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com016… FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Are there exceptions int the log file ?
Cherers
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com009…[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users–
Todd Jacobus
GIS Technician
Office: +1 (303) 284 6144
Mob: +1
Email: tj@anonymised.com
Address: 3015 W 9th Ave, Denver, CO 80204, USA
WWW.TCARTA.COM | TWITTER | LINKED IN |
CONFIDENTIALITY: This message may contain privileged and confidential information intended only for the use of the addressee. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify TCarta immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the Company. Please consider the environment before printing this e-mail.
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:
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Thanks, I’ll check it out.
On Mon, Aug 6, 2018 at 4:59 PM Rusu Sorin <rususorinvick@anonymised.com> wrote:
This is a long conversation, but here are my two cents about the issue:
On the PostGIS/PGSQL side: try storing the Lat/Long with values as an actual raster, instead of having to rely on the st_astiff() function from the database.
You cannot hope for the function to have good performance otherwise.
I would suggest interpolating your results, or just simply run a point (lat/long) to raster conversion function from a desktop suite, like QGIS and then store the resulting raster to the database.Use the DB Manager interface in QGIS to load the raster to the database, making sure to calculate indexes for efficient database query interogation. Once the raster is in the DB then you can register it with Geoserver
On the Geoserver side:
The WPS (web-processing-service) cannot process input data and then store it as a published layer. Publishing a layer requires a multi step workflows startgin with:setting up a new workspace/ using an existing one to use for the new GS layer
storing the resulting data somewhere, in the filesystem/in postgresql,
configuring a datastore to connect to that piece of data and then publishing the appropriate information
configuring WMS/WFS access to that layer.All these GS publishing steps can’t, to my knoledge be performed with the WPS module, maybe you can automate some of them from the REST endpoint of GS, however you cannot call the WPS from REST.
The best thing would be to process the XY data into a raster, save it to the database, serve that as WMS/WCS through Geoserver.
Kind regards
Sorin RUSU
Pe luni, 6 august 2018, 08:13:34 EEST, Gaurav Pathak <yash.pathak18@anonymised.com> a scris:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Wed, Aug 1, 2018 at 5:22 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <tj@anonymised.com>
Cc: Christian Mueller <christian.mueller@anonymised.com>, <Geoserver-users@lists.sourceforge.net>Hi
Can you [lease tell me how we use wps request xml in web url to get output as layer
<?xml version="1.0" encoding="UTF-8"?>ows:Identifiergt:VectorToRaster</ows:Identifier>
wps:DataInputs
wps:Input
ows:Identifierfeatures</ows:Identifier>
<wps:Reference mimeType=“text/xml” xlink:href=“http://geoserver/wfs” method=“POST”>
wps:Body
<wfs:GetFeature service=“WFS” version=“1.0.0” outputFormat=“GML2” xmlns:cite=“http://www.opengeospatial.net/cite”>
<wfs:Query typeName=“cite:cg_block_old”/>
</wfs:GetFeature>
</wps:Body>
</wps:Reference>
</wps:Input>
wps:Input
ows:IdentifierrasterWidth</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:IdentifierrasterHeight</ows:Identifier>
wps:Data
wps:LiteralData600</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierattribute</ows:Identifier>
wps:Data
wps:LiteralDatabid</wps:LiteralData>
</wps:Data>
</wps:Input>
wps:Input
ows:Identifierbounds</ows:Identifier>
wps:Data
<wps:BoundingBoxData crs=“EPSG:4326” dimensions=“2”>
ows:LowerCorner80.2250595092773 17.7496490478516</ows:LowerCorner>
ows:UpperCorner84.419075012207 24.1371479034424</ows:UpperCorner>
</wps:BoundingBoxData>
</wps:Data>
</wps:Input>
</wps:DataInputs>
wps:ResponseForm
<wps:RawDataOutput mimeType=“image/tiff”>
ows:Identifierresult</ows:Identifier>
</wps:RawDataOutput>
</wps:ResponseForm>
</wps:Execute>On Wed, Aug 1, 2018 at 1:05 PM Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Dear All
Thanks for your support now my table shown in geoserver image mosiac list but when i convert lattitute ,longitute and value in to raster clumn there saome problem due to my raster not showing
how i convert lat,long and value in to rater column in postgis
Regards
Gaurav Pathak
On Wed, Aug 1, 2018 at 10:46 AM Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi Todd
After running the query we get output given below:
POSTGIS=“2.4.1 r16012” PGSQL=“96” GEOS=“3.6.2-CAPI-1.10.2 4d2925d” PROJ=“Rel. 4.9.3, 15 August 2016” GDAL=“GDAL 2.2.2, released 2017/09/15 GDAL_DATA not found” LIBXML=“2.7.8” LIBJSON=“0.12” LIBPROTOBUF=“1.2.1” TOPOLOGY RASTER
On Tue, Jul 31, 2018 at 7:39 PM Todd Jacobus <tj@anonymised.com> wrote:
Hi Guarav,
I would begin by making sure PostGIS is installed correctly. By just looking at your error message, it seems like the GDAL driver can’t be found, which is usually (I think) installed with PostGIS. Try running “SELECT PostGIS_full_version();”.
Best,
ToddOn Tue, Jul 31, 2018 at 5:50 AM, Christian Mueller <christian.mueller@anonymised.com> wrote:
This is a problem with your Postgres/Postgis configuration. Looks like a problem with GDAL.
Time to consult somebody with Postgres/Postgis skills.
Cheers
On Tue, Jul 31, 2018 at 12:08 PM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Hi
Thanks now my raster table seen in geoserver but when i publish the table then error comes out
ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
Where: PL/pgSQL function st_astiff(raster,text,integer) line 24 at RETURN
org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driverRegards
Gaurav Pathak
On Tue, Jul 31, 2018 at 2:55 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Hi
Your file oek.pgraster.xml is not a valid XML file. It ends with
</config
but should end with
- You are using port 5433 for the db connection, I assume this is correct and not a typo since the default Postgres port is 5432.
Cheers
ChristianOn Tue, Jul 31, 2018 at 7:02 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
---------- Forwarded message ---------
From: Gaurav Pathak <yash.pathak18@anonymised.com>
Date: Mon, Jul 30, 2018 at 2:15 PM
Subject: Re: [Geoserver-users] Raster load from postgis
To: <geoserver-users@lists.sourceforge.net>Please find the zip file containing the configuration files in the directory “coverages” in attachment.
On Mon, Jul 30, 2018 at 1:50 PM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please stay on the user list, normally we do not answer private mails.
Please send a zip file containing the configuration files in the directory “coverages”.
Cheers
On Mon, Jul 30, 2018 at 8:19 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Gaurav Pathak <yash.pathak18@anonymised.com>
to ppeterpaul
Dear Christian
I have postgis database, which I am using to store latitude ,Longitute and value and try to render raster in geoserver using Image mosiac jdbc but i got a error below.
Geoserver Exception:
Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com…[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@…9015… System defaults: FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com FORCE_LONGITUDE_FIRST_AXIS_ORDER = true STYLE_FACTORY = StyleFactoryImpl LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null
I am attaching my dataset in excel sheet.
I am convert these lat long value to raster column.
Please help me to solve this issue.
On Mon, Jul 30, 2018 at 11:19 AM Christian Mueller <christian.mueller@anonymised.com> wrote:
Please post the exceptions, otherwise we have no idea about the reason.
Cheers
On Mon, Jul 30, 2018 at 6:56 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
Yes
On Sun, Jul 29, 2018 at 9:43 AM Christian Mueller <christian.mueller@anonymised.com.> wrote:
Hi
Are there exceptions int the log file ?
Cherers
On Fri, Jul 27, 2018 at 7:07 AM, Gaurav Pathak <yash.pathak18@anonymised.com> wrote:
I am using Geoserver 2.13. I am trying to load raster file from postgresql .When i try to make connection using image mosiac jdbc its gave error
log:
Failed to create reader from file:coverages/oek.pgraster.xml and hints Hints:
EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com009…[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users–
Todd Jacobus
GIS Technician
Office: +1 (303) 284 6144
Mob: +1
Email: tj@anonymised.com
Address: 3015 W 9th Ave, Denver, CO 80204, USA
WWW.TCARTA.COM | TWITTER | LINKED IN |
CONFIDENTIALITY: This message may contain privileged and confidential information intended only for the use of the addressee. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify TCarta immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the Company. Please consider the environment before printing this e-mail.
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
If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
