Re: [postgis-users] raster2pgsql loader error

2012-02-02 Thread Sandro Santilli
On Thu, Feb 02, 2012 at 09:38:13AM +0100, Andreas Forø Tollefsen wrote: Hi people, Sorry for spamming, but i simply cant find a solution to this. Has no one ever experienced this issue with the raster loader? Did you seek in the bug tracker ? If you can't find anything in there please file

Re: [postgis-users] raster2pgsql loader error

2012-02-02 Thread Andreas Forø Tollefsen
Hi strk, Thank you for your response. I now tried two different Arcinfo Binary grids. One worked, the other did not. Both worked using the previous raster2pgsql.py python script. I have submitted a bug with links to the related raster files. http://trac.osgeo.org/postgis/ticket/1531 best,

Re: [postgis-users] raster2pgsql loader error

2012-02-02 Thread Mateusz Loskot
Check your data files with gdalinfo (http://gdal.org). The loader relies on GDAL, so if GDAL can't open, the loader will fail too. Mateusz Loskot (Sent from my mobile, so apology for top-posting or no quoting) ___ postgis-users mailing list

Re: [postgis-users] raster2pgsql loader error

2012-02-02 Thread Andreas Forø Tollefsen
Hi Mateusz, Thanks for your advice. I tested both files using GDAL Info, and both works fine and shows up with the correct information. What i dont understand is why some of my rasters will not load when they loaded without a hitch using the python script. Output from gdal_info: Driver:

Re: [postgis-users] raster2pgsql loader error

2012-02-02 Thread Mateusz Loskot
On 2 February 2012 10:30, Andreas Forø Tollefsen andrea...@gmail.com wrote: Hi Mateusz, Thanks for your advice. I tested both files using GDAL Info, and both works fine and shows up with the correct information. What i dont understand is why some of my rasters will not load when they loaded

Re: [postgis-users] raster2pgsql loader error

2012-02-02 Thread Andreas Forø Tollefsen
Great. Yes, I have already attached the gdalinfo output to the ticket. Best, Andreas 2012/2/2 Mateusz Loskot mate...@loskot.net On 2 February 2012 10:30, Andreas Forø Tollefsen andrea...@gmail.com wrote: Hi Mateusz, Thanks for your advice. I tested both files using GDAL Info, and both

Re: [postgis-users] raster2pgsql loader error

2012-02-02 Thread Andreas Forø Tollefsen
Thumbs up for looking at the bug report! Appreciate it! Best, Andreas 2012/2/2 Andreas Forø Tollefsen andrea...@gmail.com Great. Yes, I have already attached the gdalinfo output to the ticket. Best, Andreas 2012/2/2 Mateusz Loskot mate...@loskot.net On 2 February 2012 10:30, Andreas

[postgis-users] PostGIS support of Geography data type in java jdbc driver?

2012-02-02 Thread Jay Moss
Is there any support for the Geography data type in the PostGIS JDBC driver? I received a classCastException if I try to cast a Geography colum to a PGgeometry: my table: CREATE TABLE k16View ( id character varying(255) NOT NULL, locGeog geography CONSTRAINT k16View_pkey PRIMARY KEY

Re: [postgis-users] PostGIS support of Geography data type in java jdbc driver?

2012-02-02 Thread Charles Galpin
I'm not sure about the support for geography but I see you need a comma between id and locGeog -- charles On Feb 2, 2012, at 5:58 PM, Jay Moss jaymo...@gmail.com wrote: Is there any support for the Geography data type in the PostGIS JDBC driver? I received a classCastException if I try to

Re: [postgis-users] PostGIS support of Geography data type in java jdbc driver?

2012-02-02 Thread Jay Moss
the real code has correct syntax, that's a copy/paste error on my part. On Thu, Feb 2, 2012 at 4:13 PM, Charles Galpin cgal...@lhsw.com wrote: I'm not sure about the support for geography but I see you need a comma between id and locGeog -- charles On Feb 2, 2012, at 5:58 PM, Jay Moss

[postgis-users] Osmosis or osm2pgsql

2012-02-02 Thread mdoake...@verizon.net
Hello, could someone explain the.difference between using osmosis and osm2pgsql to load osm data. Which is better, easier to load, more efficient, etc. Most of our queries are nearest neighbor type, and general map displays. Thanks ___

Re: [postgis-users] Osmosis or osm2pgsql

2012-02-02 Thread Frederik Ramm
Hi, On 02/03/2012 03:49 AM, mdoake...@verizon.net wrote: Hello, could someone explain the.difference between using osmosis and osm2pgsql to load osm data. Which is better, easier to load, more efficient, etc. Most of our queries are nearest neighbor type, and general map displays. Thanks You