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 <[email protected]> wrote: > Sebastian, > > Oops sorry about that. Will correct the readme.txt. > > Leo > http://www.postgis.us > > ------------------------------ > *From:* [email protected] [mailto: > [email protected]] *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 < > [email protected]> 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 <[email protected]> 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 < >>> [email protected]> 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 <[email protected]> >>>> >>>>> On Mon, Jul 19, 2010 at 11:32 AM, Sebastian E. Ovide >>>>> <[email protected]> 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 <[email protected]> >>>>> >> >>>>> >> On Mon, Jul 19, 2010 at 11:01 AM, Sebastian E. Ovide >>>>> >> <[email protected]> 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 >>>>> >> [email protected] >>>>> >> http://gis4free.wordpress.com >>>>> >> _______________________________________________ >>>>> >> postgis-users mailing list >>>>> >> [email protected] >>>>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>> > >>>>> > >>>>> > >>>>> > -- >>>>> > Sebastian E. Ovide >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > _______________________________________________ >>>>> > postgis-users mailing list >>>>> > [email protected] >>>>> > 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 >>>>> [email protected] >>>>> http://gis4free.wordpress.com >>>>> _______________________________________________ >>>>> postgis-users mailing list >>>>> [email protected] >>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>> >>>> >>>> >>>> >>>> -- >>>> Sebastian E. Ovide >>>> >>>> skype: sebastian.ovide >>>> >>>> +353 (0) 87 6340149 >>>> >>>> >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>> >>>> >>> >> >> >> -- >> Sebastian E. Ovide >> >> >> >> >> > > > -- > Sebastian E. Ovide > > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- George R. C. Silva Desenvolvimento em GIS http://blog.geoprocessamento.net
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
