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

2015-01-29 Thread Tumasgiu Rossini
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

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

2015-01-29 Thread Guillaume ARNAUD
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

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

2015-01-29 Thread Rémi Cura
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 http://postgis.net/docs/ST_IsValid.html , et ST_IsValidDetail http://postgis.net/docs/ST_IsValidDetail.html. Si vous avez des

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

2015-01-29 Thread Tumasgiu Rossini
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

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

2015-01-29 Thread Bborie Park
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

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

2015-01-29 Thread Brent Wood
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] English please (was: Get parallel some route.)

2015-01-29 Thread Sandro Santilli
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] English please (was: Get parallel some route.)

2015-01-29 Thread Robert Coup
Hi Sandro, On Fri, Jan 30, 2015 at 9:13 AM, Sandro Santilli s...@keybit.net 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

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

2015-01-29 Thread Tahir Tamba
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