[postgis-users] Gdal translate Error checking geometry type existence problem

[Jorge Arévalo]

Virginia, could you please send me the SQL file to load the table
causing you the problems?

Jorge

On Sun, Jun 5, 2011 at 11:08 PM, Virginia Maffei <vmaffei at gmail.com> wrote:
> Now i'm having another error. I created another post: "Problem with postgis
> raster using gdal_translate"
> thanks!
> Virginia
>
>
> On Fri, Jun 3, 2011 at 8:49 PM, Paragon Corporation <lr at pcorp.us> wrote:
>>
>> Virginia,
>>
>> I see your table is mixed casing in you statement.  Is your table mixed
>> case  in PostgreSQL.  Not sure if gdal_translate takes your casing literally
>> or not.
>>
>> I would suggest making sure all your tables are lower case in the
>> database and lower case in your gdal_translate as well just to make sure.
>>
>> Leo
>> http://www.postgis.us
>>
>> ________________________________
>> From: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Virginia
>> Maffei
>> Sent: Friday, June 03, 2011 1:49 PM
>> To: PostGIS Users Discussion
>> Subject: Re: [postgis-users] Gdal translate Error checking geometry type
>> existence problem
>>
>> Hi, thanks for the response.
>> In the gdal directory y executed this line:
>> C:\Archivos de programa\GDAL>gdal_translate PG:"dbname=template_postgis20
>> user=postgres table=HumedadDeExtincion mode=2" your_file.tif
>>
>> Does it have something wrong?
>> thanks!
>> Virginia
>>
>> 2011/6/3 Jorge Arévalo <jorge.arevalo at deimos-space.com>
>>>
>>> Hi Virginia,
>>>
>>> This is a GDAL driver's issue, not PostGIS Raster one. Did you use a
>>> where clause with unescaped single quotes in your connection string?
>>> This is a common error. Anyway, could you send me the gdal_translate
>>> line that caused the error?
>>>
>>> As Pierre said, it isn't a good idea to use template_postgis20 to
>>> store data. Create a new database using the templated instead:
>>>
>>> createdb -T template_postgis20 -U <your_user> -W testing_db
>>>
>>> Best regards,
>>> Jorge
>>>
>>> On Fri, Jun 3, 2011 at 1:24 PM, Pierre Racine
>>> <Pierre.Racine at sbf.ulaval.ca> wrote:
>>> > Did you load/execute rtpostgis.sql in the database?
>>> >
>>> >
>>> >
>>> > Also, I think this is not good practice to use your template database
>>> > (template_postgis20) to store data.
>>> >
>>> >
>>> >
>>> > Pierre
>>> >
>>> >
>>> >
>>> > From: postgis-users-bounces at postgis.refractions.net
>>> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
>>> > Virginia
>>> > Maffei
>>> > Sent: Thursday, June 02, 2011 8:22 PM
>>> > To: PostGIS Users Discussion
>>> > Subject: [postgis-users] Gdal translate Error checking geometry type
>>> > existence problem
>>> >
>>> >
>>> >
>>> > Hi, i loaded a tif with raster2pgsql into the database and now i'm
>>> > trying to
>>> > get from that table a tif with gdal_translate.
>>> >
>>> > But this error appears:
>>> >
>>> >
>>> >
>>> > C:\Archivos de programa\GDAL>gdal_translate
>>> > PG:"dbname=template_postgis20
>>> > user=postgres table=HumedadDeExtincion mode=2" your_file.tif
>>> >
>>> > ERROR 1: Error checking geometry type existence. Is PostGIS correctly
>>> >
>>> >       installed?: no connection to the server
>>> >
>>> >
>>> >
>>> > GDALOpen failed - 1
>>> >
>>> > Error checking geometry type existence. Is PostGIS correctly
>>> > installed?: no
>>> > connection to the server
>>> >
>>> >
>>> >
>>> > I installed in windows the postgis raster with gdal, python, etc.
>>> >
>>> >
>>> >
>>> > Could you please help me with this problem?
>>> >
>>> >
>>> >
>>> > Thanks!
>>> >
>>> >
>>> >
>>> > Virginia
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > _______________________________________________
>>> > postgis-users mailing list
>>> > postgis-users at postgis.refractions.net
>>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> Jorge Arévalo
>>> Internet & Mobilty Division, DEIMOS
>>> jorge.arevalo at deimos-space.com
>>> http://es.linkedin.com/in/jorgearevalo80
>>> http://mobility.grupodeimos.com/
>>> http://gis4free.wordpress.com
>>> http://geohash.org/ezjqgrgzz0g
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



-- 
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g