Re: [postgis-users] English please (was: Get parallel some route.)

Hi Sandro, On Fri, Jan 30, 2015 at 9:13 AM, Sandro Santilli wrote: > May I ask everyone to use simple english when writing on the mailing list ? > It easily become noisy otherwise. > My 2c: I'm happy with non-English threads if people get their problems solved faster - Google Translate is wonde

Re: [postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS

Can't help with plain dblink but we have succeeded with ODBC connections & shell scripts which pipe the result from an Oracle SQL query into a Postgis SQL to transfer the data. We have not pursued another approach which we feel is probably viable, which is connecting directly from Oracle to push

[postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS

Hi, I have a mapping project for generating an atlas from multiple layers from QGIS project. All my layers are stored in PostGIS. For cons, I have many layers to add that are stored in Oracle Spatial database and must be part of the project. This tables are updated in live every day. This is the r

[postgis-users] English please (was: Get parallel some route.)

May I ask everyone to use simple english when writing on the mailing list ? It easily become noisy otherwise. Thanks. --strk; ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] ST_BandPath() returns null or ô on out-db raster

I write too fast... problematics non escaped rasters doesn't output empty string. I checked it with the length function. Also, it seems that it is juste the output of St_bandpath wich is problematic, because raster output functions like st_AsPng seems to work... 2015-01-29 16:35 GMT+01:00 Tuma

Re: [postgis-users] ST_BandPath() returns null or ô on out-db raster

Hi BBorie, Out-db rasters referenced with network path do register on postgis tables ! I use it every day. It was, like you suggested it, an escaping issue : I have tried the command raster2pgsql -R -a -F \\serveur-ad/\raster/\419/\napoleonien/\*.tif testraster | psql -U postgres -p 5434 test

Re: [postgis-users] ST_BandPath() returns null or ô on out-db raster

I'm not aware that loading out-db rasters using Windows network path names will work. What happens if you add that network path as a network drive? Can you try something like the following? All I've done is replace the backslash with a forward slash... raster2pgsql -R -a -F fileserver/raster

Re: [postgis-users] Get parallel some route.

Ah, effectivement l'erreur n'est pas du tout la même Il s'agit peut être de géométrie non valide Vous pouvez le vérifier facilement avec les fonctions ST_IsValid , et ST_IsValidDetail . Si vous avez des géomét

Re: [postgis-users] Get parallel some route.

Bonjour, Merci, encore, pour votre intérêt pour notre problème. De mémoire j'avais utilisé st_isvalid et st_isvaliddetail. Dans le doute, j'ai repassé la commande : SELECT ST_IsValid(shape) as Geom_valide, ST_IsValidDetail(shape) as detail_valide, count(*) nombre FROM web.trs_itineraire GROUP B

Re: [postgis-users] Get parallel some route.

(re) Bonjour, Merci pour votre retour rapide, mais, comme je l'indiquais dans le mail précédent, j'ai bien vérifié que mes lignes soient bien des linestring en utilisant la requête suivante : "select st_geometrytype(shape) type_geom, count (*) from web.trs_itineraire group by type_geom"

Re: [postgis-users] ST_BandPath() returns null or ô on out-db raster

Sorry, a misclick sent the message before I had finished it : St_BandPath() doesn't ouputs null but the emtpy string. 2015-01-29 13:42 GMT+01:00 Tumasgiu Rossini : > Hi List, > > I am experiencing a problem with outdb geotiff importation. > > I am using the raster2pgsql utility : > > raster2pgs

[postgis-users] ST_BandPath() returns null or ô on out-db raster

Hi List, I am experiencing a problem with outdb geotiff importation. I am using the raster2pgsql utility : raster2pgsql -R -a -F \\fileserver\raster\419\napoleonien\*.tif catalog On a particular set of geotiff ( wich are generated with the same routine as the others ), the command seems to wor