[postgis-users] problem installing WKTRaster
Pierre Racine
Pierre.Racine at sbf.ulaval.ca
Mon Jul 19 09:27:45 PDT 2010
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<mailto: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> [mailto: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<mailto: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<mailto: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<mailto: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<mailto:jorge.arevalo at deimos-space.com>>
On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide
<sebastian.ovide at gmail.com<mailto: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<mailto:jorge.arevalo at deimos-space.com>>
>>
>> On Mon, Jul 19, 2010 at 11:01 AM, Sebastian E. Ovide
>> <sebastian.ovide at gmail.com<mailto: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<mailto:jorge.arevalo at deimos-space.com>
>> http://gis4free.wordpress.com
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net<mailto: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<mailto: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<mailto:jorge.arevalo at deimos-space.com>
http://gis4free.wordpress.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net<mailto: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<mailto: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<mailto: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100719/dabcf7f1/attachment.html>
More information about the postgis-users
mailing list