[R-sig-Geo] (no subject)

[Barry Rowlingson]

On Tue, Aug 21, 2012 at 9:09 AM, katja.flammang at tudor.lu
<katja.flammang at tudor.lu> wrote:
> Hi,
>
> I'm new to this list so I hope I'm not missing anything.
>
> I'm trying to read a file from a database and then write it to my schema in
> the same database. The readOGR function works good but I'm having
> difficulties with writeOGR.
>
> Here is what R is telling me:
>
>> flik_crop_types <- readOGR("PG:dbname=valid host=myhost user=myusername
>> password=mypassword schemas=cbraun","flik_crop_types_08_lux_recl")
>
> OGR data source with driver: PostgreSQL Source: "PG:dbname=valid host=myhost
> user=myusername password=mypassword schemas=cbraun", layer:
> "flik_crop_types_08_lux_recl" with 75836 features and 7 fields Feature type:
> wkbPolygon with 2 dimensions
>
>> writeOGR(flik_crop_types, "PG:dbname=valid host=myhost user=myusername
>> password=mypassword schemas=myschema", "flik_crop_types_08_lux_recl",
>> "PostgreSQL")
>
> Error in writeOGR(flik_crop_types, "PG:dbname=valid host=myhost
> user=myusername password=mypassword schemas=myschema", : Layer creation
> failed

 I can think that either:

 Your PostGIS driver doesn't have write support - what does ogrDrivers() say?

 Is your 'myschema' PostGIS-enabled? Does it have a "geometry_columns" table?

 Another idea is to try writing a normal table to it using the
standard R database connection stuff. That will check you have the
right write permissions...

Barry