[postgis-users] problem installing WKTRaster

George Silva georger.silva at gmail.com
Mon Jul 19 09:52:07 PDT 2010 

It worked just fine. Thanks.

George

On Mon, Jul 19, 2010 at 1:50 PM, George Silva <georger.silva at gmail.com>wrote:

> Yeap Pierre, this is 8.3.
>
> I'll do that and i'll get back to you. Thanks for the quick answer.
>
> George
>
>
> On Mon, Jul 19, 2010 at 1:27 PM, Pierre Racine <
> Pierre.Racine at sbf.ulaval.ca> wrote:
>
>>  You’re using PostgreSQL 8.3 right?
>>
>>
>>
>> Replace
>>
>>
>>
>> “SELECT ST_Intersection((gv).geom, $1) intgeom”
>>
>>
>>
>> with
>>
>>
>>
>> “SELECT ST_Intersection((gv).geom, $1) AS intgeom”…
>>
>>
>>
>> I’ll fix the source.
>>
>>
>>
>> Pierre
>>
>>
>>
>> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
>> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *George
>> Silva
>> *Sent:* 19 juillet 2010 12:11
>>
>> *To:* PostGIS Users Discussion
>> *Subject:* Re: [postgis-users] problem installing WKTRaster
>>
>>
>>
>> While we are at it, I've tried installing and there it complains about an
>> error here:
>>
>> My download link was:
>> http://www.postgis.org/download/windows/pg83/experimental/wktraster/wktraster_pg83.zip
>>
>> I've already placed all my files at the correct place. What is the name of
>> the environment variable for postgresql? Just "PATH"? I already have two or
>> three variables with that name...
>>
>> Any ideas? Thanks guys.
>>
>>
>> CREATE OR REPLACE FUNCTION st_intersection(geom geometry, rast raster,
>> band integer)
>>     RETURNS SETOF geomval AS
>>     $$
>>         -- Return the intersections of the geometry with the vectorized
>> parts of
>>         -- the raster and the values associated with those parts, if
>> really their
>>         -- intersection is not empty.
>>         SELECT intgeom, val
>>         FROM (
>>             SELECT ST_Intersection((gv).geom, $1) intgeom, (gv).val
>>             FROM ST_DumpAsPolygons($2, $3) gv
>>             WHERE ST_Intersects((gv).geom, $1) AND ST_Intersects($1, $2,
>> $3)) foo
>>         WHERE NOT st_isempty(intgeom)  -- eliminate empty intersections
>>         UNION ALL
>>         -- If the geometry does not intersect with the raster, return an
>> empty
>>         -- geometry and a null value
>>         SELECT emptygeom, NULL FROM
>>         ST_GeomCollFromText('GEOMETRYCOLLECTION EMPTY', st_srid($1))
>> emptygeom
>>         WHERE NOT ST_Intersects($1, $2, $3);
>>     $$
>>     LANGUAGE SQL IMMUTABLE;
>>
>> NOTICE:  type "raster" is not yet defined
>> DETAIL:  Creating a shell type definition.NOTICE:  argument type raster is
>> only a shell
>>
>> ERROR:  syntax error at or near "intgeom"
>> LINE 1219:             SELECT ST_Intersection((gv).geom, $1) intgeom, (...
>>                                                              ^
>>
>> ********** Error **********
>>
>> ERROR: syntax error at or near "intgeom"
>> SQL state: 42601
>> Character: 44614
>>
>>  On Mon, Jul 19, 2010 at 12:37 PM, Paragon Corporation <lr at pcorp.us>
>> wrote:
>>
>> Sebastian,
>>
>>
>>
>> Oops sorry about that.  Will correct the readme.txt.
>>
>>
>>
>> Leo
>>
>> http://www.postgis.us
>>
>>
>>  ------------------------------
>>
>> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
>> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Sebastian
>> E. Ovide
>> *Sent:* Monday, July 19, 2010 9:08 AM
>> *To:* PostGIS Users Discussion
>> *Subject:* Re: [postgis-users] problem installing WKTRaster
>>
>> Re reading the readme.txt
>>
>> 1) Install PostGIS into your database if you haven't already
>> 2) Copy the rtpostgis.dll to the lib folder of your PostgreSQL install
>> 3)
>> a) then Run the share\contrib\postgis\rtpostgis.sql in your postgis
>> enabled db
>> b) You can install help now too by running
>> share\contrib\postgis\wktraster_comments.sql
>> 4) Copy the contents of bin to your PostgreSQL bin folder
>> (gdal2wktraster.py, libgdal.dll) to bin folder of your PostgreSQL install.
>>
>> the point 4 should come before the point 3....
>>
>> On Mon, Jul 19, 2010 at 12:13 PM, Sebastian E. Ovide <
>> sebastian.ovide at gmail.com> wrote:
>>
>> Hi Fred,
>>
>> Thanks to that Tool I've discovered that the dll could not find
>> libgdal.dll... so I've copied it into the bin dir and now it works !
>>
>> thanks !
>>
>>
>>
>> On Mon, Jul 19, 2010 at 12:03 PM, Fred Lehodey <lehodey at gmail.com> wrote:
>>
>> Hi Sebastian,
>> you can try that free utility : http://www.dependencywalker.com/
>>
>> Sometimes helpful to discover a missing file.
>>
>> Fred.
>>
>>
>>
>>
>>
>>  On Mon, Jul 19, 2010 at 11:56 AM, Sebastian E. Ovide <
>> sebastian.ovide at gmail.com> wrote:
>>
>> same:
>>
>>
>> ERROR:  could not load library "C:/Program
>> Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not be
>> found.
>>
>> 2010/7/19 Jorge Arévalo <jorge.arevalo at deimos-space.com>
>>
>> On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide
>>
>> <sebastian.ovide at gmail.com> wrote:
>>
>> > done, same problem
>> >
>> > ERROR:  could not load library "C:/Program
>> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could not
>> be
>> > found.
>> >
>>
>> Try adding C:/Program Files/PostgreSQL/8.4/lib/ to the PATH enviroment
>> variable.
>>
>>
>>
>> > 2010/7/19 Jorge Arévalo <jorge.arevalo at deimos-space.com>
>> >>
>> >> On Mon, Jul 19, 2010 at 11:01 AM, Sebastian E. Ovide
>> >> <sebastian.ovide at gmail.com> wrote:
>> >> > Hi All,
>> >> >
>> >> > on WinXP, with PostgreSLQ 8.4, PostGis 1.5 and WKTRaster 0.1.6d.
>> >> >
>> >> > Just followed the instructions from WKTRaster 0.1.6d readme.txt and
>> when
>> >> > I'm
>> >> > running the rtpostgis.sql I'm getting this error:
>> >> >
>> >> > NOTICE:  type "raster" is not yet defined
>> >> > DETAIL:  Creating a shell type definition.
>> >> > ERROR:  could not load library "C:/Program
>> >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could
>> not
>> >> > be
>> >> > found.
>> >> >
>> >> >
>> >> > ********** Error **********
>> >> >
>> >> > ERROR: could not load library "C:/Program
>> >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll": The specified module could
>> not
>> >> > be
>> >> > found.
>> >> > SQL state: 58P01
>> >> >
>> >> >
>> >> > But I do have that file !!!!
>> >> >
>> >> > C:\Documents and Settings\sebastian ovide>dir "C:\Program
>> >> > Files\PostgreSQL\8.4\lib\rtpostgis.dll"
>> >> >  Volume in drive C has no label.
>> >> >  Volume Serial Number is 2079-A57D
>> >> >
>> >> >  Directory of C:\Program Files\PostgreSQL\8.4\lib
>> >> >
>> >> > 21/06/2010  13:52           210,432 rtpostgis.dll
>> >> >                1 File(s)        210,432 bytes
>> >> >                0 Dir(s)  450,924,576,768 bytes free
>> >> >
>> >> >
>> >> > now, If I use the backslash... ( as for the error)
>> >> >
>> >> >
>> >> > C:\Documents and Settings\sebastian ovide>dir "C:/Program
>> >> > Files/PostgreSQL/8.4/lib/rtpostgis.dll"
>> >> >  Volume in drive C has no label.
>> >> >  Volume Serial Number is 2079-A57D
>> >> >
>> >> >  Directory of C:\Program Files\PostgreSQL\8.4\lib
>> >> >
>> >> > File Not Found
>> >> >
>> >> >
>> >> >
>> >> > ideas ?
>> >> >
>> >> > thanks
>> >> >
>> >> > --
>> >> > Sebastian E. Ovide
>> >> >
>> >>
>> >> Hi,
>> >>
>> >> Try copying rtpostgis.dll in C:\Program Files\PostgreSQL\8.4\bin
>> directory
>> >>
>> >> Best regards,
>> >>
>> >> --
>> >> Jorge Arévalo
>> >> DEIMOS Space
>> >> Internet & Mobilty Division
>> >> Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º
>> >> 28760 Tres Cantos (Madrid)
>> >> Tel: +34 91 806 34 50 - ext: 155
>> >> jorge.arevalo at deimos-space.com
>> >> http://gis4free.wordpress.com
>> >> _______________________________________________
>> >> postgis-users mailing list
>> >> postgis-users at postgis.refractions.net
>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> >
>> >
>> > --
>> > Sebastian E. Ovide
>> >
>> >
>> >
>> >
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users at postgis.refractions.net
>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> >
>>
>>
>>
>> --
>> Jorge Arévalo
>> DEIMOS Space
>> Internet & Mobilty Division
>> Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º
>> 28760 Tres Cantos (Madrid)
>> Tel: +34 91 806 34 50 - ext: 155
>> jorge.arevalo at deimos-space.com
>> http://gis4free.wordpress.com
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>   --
>> Sebastian E. Ovide
>>
>> skype: sebastian.ovide
>>
>> +353 (0) 87 6340149
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>
>>
>>   --
>> Sebastian E. Ovide
>>
>>
>>
>>
>>
>>
>> --
>> Sebastian E. Ovide
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>>
>> --
>> George R. C. Silva
>>
>> Desenvolvimento em GIS
>> http://blog.geoprocessamento.net
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
> --
> George R. C. Silva
>
> Desenvolvimento em GIS
> http://blog.geoprocessamento.net
>



-- 
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100719/3546ac24/attachment.html>

More information about the postgis-users mailing list