[postgis-users] problem installing WKTRaster
George Silva
georger.silva at gmail.com
Mon Jul 19 09:10:47 PDT 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100719/94304f05/attachment.html>
More information about the postgis-users
mailing list