Discussion:
[mapguide-users] Configuration for PostGIS raster
Gabriele Monfardini
2018-10-02 17:12:29 UTC
Permalink
Hi, all,

we're exploring the feasibility of consuming PostGIS raster from MapGuide.
According to https://trac.osgeo.org/mapguide/wiki/MGOSGdalProviderFor26And30
it should be feasible.
However I cannot find any proper documentation on how to setup
FeatureSource and LayerDefinition.
In particular OSGEO.Gdal provider accepts some parameters, for instance
DefaultRasterFileLocation for file rasters.
I cannot find a list of accepted parameters, and how to define a source for
a PostGIS Raster.
Is there any documentation or may anyone point me at relevant source code?
Regards,

Gabriele Monfardini

-----
Gabriele Monfardini
LdP Progetti GIS
tel: 0577.531049
email: ***@ldpgis.it
Jackie Ng
2018-10-03 12:50:01 UTC
Permalink
Without knowing much about the GDAL provider internals, but assuming it uses
GDAL in the same way the OGR provider uses OGR, then I would assume the
DefaultRasterFileLocation property is not necessarily a physical file path,
but rather is actually just an arbitrary data source string and going by
that logic you would set DefaultRasterFileLocation to something like:

PG:host=localhost port=5432 dbname='mydb' user='postgres' password='secret'
schema='public' table=mytable

As per the PostGIS raster format documentation:
https://www.gdal.org/frmt_postgisraster.html

- Jackie



--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
Gabriele Monfardini
2018-10-03 16:19:27 UTC
Permalink
Hi,
Post by Jackie Ng
Without knowing much about the GDAL provider internals, but assuming it uses
GDAL in the same way the OGR provider uses OGR, then I would assume the
DefaultRasterFileLocation property is not necessarily a physical file path,
but rather is actually just an arbitrary data source string and going by
PG:host=localhost port=5432 dbname='mydb' user='postgres' password='secret'
schema='public' table=mytable
thank you Jackie, it workish, it does not give any error, it founds that
there is a raster but nothing is displayed if used in a map.
I will keep investigating.
Regars,

Gabriele

Loading...