[postgis-users] Mapserver connection to Postgis Raster
Virginia Maffei
vmaffei at gmail.com
Sun Jun 5 14:03:22 PDT 2011
Hi, I installed again de postgis 2.0 and now i could load al the .sql with
the makepostgisdb.bat that de windows version brings. The only thing is that
i had to first create de DB and then in a separate .bat run the .sql load.
I installed gdal 1.8 and also have de gdal 1.8 in the mapserver (ms4w 3.0.2)
installation, but i cant connect with the data base i'm trying to run a
gdal_translate or gdal_info and it doesnt work. I created a new data base
having as template the one loaded with the postgis 2.0
This is the error that it shows:
C:\ms4w\tools\gdal-ogr>gdal_translate PG:"dbname=raster user=postgres
table=Hume*
dadDeExtincion mode=2" C:\TSIG\capas\sql2\HumedadDeExtincion.tif
*
*
*
ERROR 1: Error browsing database for PostGIS Raster properties
GDALOpen failed - 1
Error browsing database for PostGIS Raster properties
Any way...i will post this problem in another thread because the subject is
different.
regards,
Virginia
2011/6/3 Jorge Arévalo <jorge.arevalo at deimos-space.com>
> [SP] Hola Virginia. Realmente el único español, que yo sepa, soy yo,
> así que si no te importa, voy a responder a tu pregunta en inglés
>
> [EN] Hi Virginia, AFAIK, I'm the only Spanish on the list. So, I'm
> going to answer your question in english.
>
> Are you sure you loaded all the needed sql files? These are
> postgis.sql, spatial_ref_sys.sql and rtpostgis.sql
>
> Best regards,
> Jorge
>
> On Thu, Jun 2, 2011 at 11:36 PM, Virginia Maffei <vmaffei at gmail.com>
> wrote:
> > Hola! estoy intentando cargar manualmente el raster support y estoy
> > ejecutando el rtpostgissql que trae el postgis2.0
> > Pero al ejecutarlo me tira que no existe la funcion box2d(raster)
> > Alguna idea de que puede estar pasando?
> > Gracias!
> > PD: Escribí en español porque me pareció ver que son de españa y yo en
> > realidad hablo en español.
> > saludos!
> > Virginia
> >
> >
> > On Thu, Jun 2, 2011 at 11:16 AM, Virginia Maffei <vmaffei at gmail.com>
> wrote:
> >>
> >> Thank you!! I will try that installation
> >> Virginia
> >>
> >>
> >> 2011/6/2 Jorge Arévalo <jorge.arevalo at deimos-space.com>
> >>>
> >>> On Thu, Jun 2, 2011 at 3:25 PM, Virginia Maffei <vmaffei at gmail.com>
> >>> wrote:
> >>> > Thank you for your quick response!
> >>> > I have another question: can i install postgis 2.0 in windows? where
> >>> > can I
> >>> > download it?
> >>> >
> >>> >
> >>> > Virginia
> >>> >
> >>>
> >>> Yes, you can. Follow this post's instructions:
> >>>
> >>>
> http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/
> >>>
> >>> Best regards,
> >>> Jorge
> >>>
> >>>
> >>> >
> >>> > 2011/6/2 Jorge Arévalo <jorge.arevalo at deimos-space.com>
> >>> >>
> >>> >> Hi,
> >>> >>
> >>> >> The mode=2 parameter is only valid with the last version of GDAL
> >>> >> (1.8.0). So, as Regina said, you need that version to make it work
> >>> >> properly. More accurately:
> >>> >>
> >>> >> - With a GDAL version down to 1.7.1, you can't make it work in any
> >>> >> way. No driver.
> >>> >>
> >>> >> - With a GDAL version between 1.7.1 and 1.7.3, both included, you
> can
> >>> >> use the old version of the driver, thought to work with the old
> >>> >> wktraster extension, now abandoned. And it was buggy. Not
> recommended.
> >>> >> Neither GDAL 1.7.x nor wktraster.
> >>> >>
> >>> >> - With GDAL version up to 1.8.0, you can use the last version of
> GDAL
> >>> >> PostGIS Raster driver, and you'll need PostGIS 2.0, that includes
> >>> >> PostGIS Raster extension. Additionally, as Regina said, those days
> >>> >> we're working on the driver, and all the improvements will be
> included
> >>> >> in GDAL 1.8.x
> >>> >>
> >>> >> So, summarizing: You need PostGIS 2.0 plus GDAL 1.8.0 to make it
> work.
> >>> >>
> >>> >> Further information on the driver:
> >>> >> http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html
> >>> >>
> >>> >> Best regards,
> >>> >> Jorge
> >>> >>
> >>> >> On Thu, Jun 2, 2011 at 6:53 AM, Paragon Corporation <lr at pcorp.us>
> >>> >> wrote:
> >>> >> > Virginia,
> >>> >> >
> >>> >> > I think you are missing a mode='2' in your connection. That was
> a
> >>> >> > new
> >>> >> > requirement that was added for GDAL 1.8+
> >>> >> >
> >>> >> > Try putting that in. I think the speed on the loading still needs
> >>> >> > quite
> >>> >> > a
> >>> >> > bit of work though last I tried. The speed issues will hopefully
> be
> >>> >> > resolved before 2.0 release.
> >>> >> >
> >>> >> > Thanks,
> >>> >> > Regina
> >>> >> > http://www.postgis.us
> >>> >> >
> >>> >> >
> >>> >> > ________________________________
> >>> >> > From: postgis-users-bounces at postgis.refractions.net
> >>> >> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf
> Of
> >>> >> > Virginia
> >>> >> > Maffei
> >>> >> > Sent: Wednesday, June 01, 2011 8:00 PM
> >>> >> > To: postgis-users at postgis.refractions.net
> >>> >> > Subject: [postgis-users] Mapserver connection to Postgis Raster
> >>> >> >
> >>> >> > Hi, i'm new at this and i'm trying to connect to postgis raster in
> >>> >> > the
> >>> >> > mapfile.
> >>> >> > I loaded a tif file into postgis raster database with the
> >>> >> > raster2pgsql.py
> >>> >> > script. It created a table with 2 fields: rid and rast.
> >>> >> > In the mapfile i added the connection like it specifies in the
> >>> >> > postgis
> >>> >> > raster FAQ but it doesn't displays anything.
> >>> >> > This is my mapfile:
> >>> >> > MAP
> >>> >> > IMAGETYPE PNG24
> >>> >> > EXTENT 366582.2901411663 6127927.100382689
> >>> >> > 857582.2901411663
> >>> >> > 6670927.100382689
> >>> >> > SIZE 491 543
> >>> >> > SHAPEPATH "../data"
> >>> >> > LAYER # MODIS raster layer begins here
> >>> >> > NAME modis
> >>> >> > TYPE RASTER
> >>> >> > STATUS ON
> >>> >> > DATA "PG:host=localhost port=5432 dbname='postgis' user='postgres'
> >>> >> > password='postgres' schema='public' table='HumedadDeExtincion'"
> >>> >> > PROCESSING "NODATA=0"
> >>> >> > PROCESSING "SCALE=AUTO"
> >>> >> > PROCESSING "SCALE_BUCKETS=201"
> >>> >> > PROCESSING "BANDS=1"
> >>> >> > OFFSITE 71 74 65
> >>> >> > CLASS
> >>> >> > NAME "red"
> >>> >> > EXPRESSION ([pixel] < 10)
> >>> >> > COLOR 255 0 0
> >>> >> > END
> >>> >> > CLASS
> >>> >> > NAME "green"
> >>> >> > EXPRESSION ([pixel] >= 10 AND [pixel] < 15000 )
> >>> >> > COLOR 0 255 0
> >>> >> > END
> >>> >> > CLASS
> >>> >> > NAME "blue"
> >>> >> > EXPRESSION ([pixel] >= 15000 )
> >>> >> > COLOR 0 255 0
> >>> >> > END
> >>> >> > END # MODIS raster layer ends here
> >>> >> >
> >>> >> > # End of LAYER DEFINITIONS -------------------------------
> >>> >> > END # All map files must come to an end just as all other things
> >>> >> > must
> >>> >> > come
> >>> >> > to...
> >>> >> >
> >>> >> > I have gdal 1.6 , postgis 1.5 and ms4w with mapserver 5.6.6
> >>> >> > We cant see the tiff file on the browser, it only appears a white
> >>> >> > image.
> >>> >> > We did try with the tif without the database connection an it
> works.
> >>> >> > Could you help us?
> >>> >> > Thank you
> >>> >> >
> >>> >> > _______________________________________________
> >>> >> > postgis-users mailing list
> >>> >> > postgis-users at postgis.refractions.net
> >>> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>> >> >
> >>> >> >
> >>> >>
> >>> >>
> >>> >>
> >>> >> --
> >>> >> Jorge Arévalo
> >>> >> Internet & Mobilty Division, DEIMOS
> >>> >> jorge.arevalo at deimos-space.com
> >>> >> http://es.linkedin.com/in/jorgearevalo80
> >>> >> http://mobility.grupodeimos.com/
> >>> >> http://gis4free.wordpress.com
> >>> >> http://geohash.org/ezjqgrgzz0g
> >>> >> _______________________________________________
> >>> >> postgis-users mailing list
> >>> >> postgis-users at postgis.refractions.net
> >>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>> >
> >>> >
> >>> > _______________________________________________
> >>> > postgis-users mailing list
> >>> > postgis-users at postgis.refractions.net
> >>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>> >
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> Jorge Arévalo
> >>> Internet & Mobilty Division, DEIMOS
> >>> jorge.arevalo at deimos-space.com
> >>> http://es.linkedin.com/in/jorgearevalo80
> >>> http://mobility.grupodeimos.com/
> >>> http://gis4free.wordpress.com
> >>> http://geohash.org/ezjqgrgzz0g
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users at postgis.refractions.net
> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
>
>
> --
> Jorge Arévalo
> Internet & Mobilty Division, DEIMOS
> jorge.arevalo at deimos-space.com
> http://es.linkedin.com/in/jorgearevalo80
> http://mobility.grupodeimos.com/
> http://gis4free.wordpress.com
> http://geohash.org/ezjqgrgzz0g
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110605/93733518/attachment.html>
More information about the postgis-users
mailing list