[R-sig-Geo] Bug in writeOGR MSSQLSpatial driver?

[cmundy]

Hi All,

Trying to run a well used script over the last few days has shown up an
error when writing a SpatialPolygonDataFrame to SQL SERVER using writeOGR.
This script worked 4 weeks ago, so I assume it is do with updates in the
latest version of rgdal.

The write attempt creates a new table in SQL SERVER, inserts a single row,
then exits with the following error.

> writeOGR(polyunion90df, dsn=dsn, layer=lyrout90, driver="MSSQLSpatial",
> layer_options=c("SRID=28355"))
Error in writeOGR(polyunion90df, dsn = dsnAbTrack_Analysis_SBY, layer =
lyrout90,  : 
  Failed to create feature

The single feature written to SQL Server appears normal, except the ogr_fid
field contains the following value "-2147483648".

The write attempt seems to update the geometry_column table successfully.

Using writeOGR with the ESRI shapefile driver successfully writes the SPDF
to a shapefile, which imports normally to a GIS.

writeOGR works normally if I run R 2.15.3 with rgdal 0.8-6.

quizzing the SQL SERVER spatial feature returns the following

ogrInfo returns the following

> ogrInfo(dsnAbTrack_Analysis_SBY, 'kud2012_test')
Source: "MSSQL:server=MyServer;database=MyDatabase;trusted_connection=yes",
layer: "kud2012_test"
Driver: MSSQLSpatial number of rows 1 
Feature type: wkbMultiPolygon with 2 dimensions
Extent: (608073.9 5543662) - (608322.9 5544055)
CRS: +proj=utm +zone=55 +south +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m
+no_defs  
Number of fields: 19 
            name type length typeName
1          names    4      0   String
2         diveid    4      0   String
3        dropnum    0     10  Integer
4        dvstart    4      0   String
5          dvend    4      0   String
6        avgdpth    2      0     Real
7        avgtemp    2      0     Real
8      catchblkg    2      0     Real
9      catchglkg    2      0     Real
10 blip_gps_cpue    2      0     Real
11  blip_qd_cpue    2      0     Real
12 glip_gps_cpue    2      0     Real
13  glip_qd_cpue    2      0     Real
14      duration    2      0     Real
15       numpoly    0     10  Integer
16       maxdist    2      0     Real
17         parea    2      0     Real
18         haphr    2      0     Real
19         lmphr    2      0     Real


ogrFid info provides the following

> ogrFIDs(dsnAbTrack_Analysis_SBY, 'kud2012_test')
[1] NA
attr(,"nf")
[1] 1
attr(,"i")
[1] 1

> sessionInfo()
R version 3.0.1 (2013-05-16)
Platform: x86_64-w64-mingw32/x64 (64-bit)

locale:
[1] LC_COLLATE=English_Australia.1252 
[2] LC_CTYPE=English_Australia.1252   
[3] LC_MONETARY=English_Australia.1252
[4] LC_NUMERIC=C                      
[5] LC_TIME=English_Australia.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods  
[7] base     

loaded via a namespace (and not attached):
[1] tools_3.0.1
> library(rgdal)
Loading required package: sp
rgdal: version: 0.8-9, (SVN revision 470)
Geospatial Data Abstraction Library extensions to R successfully loaded
Loaded GDAL runtime: GDAL 1.9.2, released 2012/10/08
Path to GDAL shared files: C:/Program Files/R/R-3.0.1/library/rgdal/gdal
GDAL does not use iconv for recoding strings.
Loaded PROJ.4 runtime: Rel. 4.7.1, 23 September 2009, [PJ_VERSION: 470]
Path to PROJ.4 shared files: C:/Program Files/R/R-3.0.1/library/rgdal/proj


Hoping the developers can help?

Thanks

Craig




--
View this message in context: http://r-sig-geo.2731867.n2.nabble.com/Bug-in-writeOGR-MSSQLSpatial-driver-tp7583633.html
Sent from the R-sig-geo mailing list archive at Nabble.com.