It worked just fine. Thanks. George
On Mon, Jul 19, 2010 at 1:50 PM, George Silva <[email protected]>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 < > [email protected]> 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:* [email protected] [mailto: >> [email protected]] *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 <[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 >> >> > > > -- > George R. C. Silva > > Desenvolvimento em GIS > http://blog.geoprocessamento.net > -- 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
