[gdal-dev] Getting SRID from MS SQL Server Spatial Table

2013-11-13 Thread Bob Cave
Hello, I am using the MS SQL Server driver (1.10.1) with MSSQLSPATIAL_USE_GEOMETRY_COLUMNS=NO. When I attempt to read a table, I find that the driver does not identify the spatial reference the table is using. Is there a way to get the driver to query for the SRID? When I use

Re: [gdal-dev] Getting SRID from MS SQL Server Spatial Table

2013-11-13 Thread Tamas Szekeres
Bob, You should specify the SRID as the attribute in the geometries in the database table, which should also set the spatial reference of the layer. Best regards, Tamas 2013/11/13 Bob Cave b...@bluemarblegeo.com Hello, I am using the MS SQL Server driver (1.10.1) with

Re: [gdal-dev] Getting SRID from MS SQL Server Spatial Table

2013-11-13 Thread Bob Cave
Tamas, Thank you for the quick reply. My code is reading a table, so I am trying to identify the SRID that was used when the table was created and the geometries were added to the table. How do I query the SRID from the geometry in the table? The MS SQL Server driver does this when it is

Re: [gdal-dev] Getting SRID from MS SQL Server Spatial Table

2013-11-13 Thread Tamas Szekeres
The driver is doing something like: select top 1 ogr_geometry.STSrid from [mytable] Best regards, Tamas 2013/11/13 Bob Cave b...@bluemarblegeo.com Tamas, Thank you for the quick reply. My code is reading a table, so I am trying to identify the SRID that was used when the table was

Re: [gdal-dev] [PATCH v2] Support Mercator_2SP in GeoTIFF

2013-11-13 Thread Trent Piepho
It looks like arcgis does not support Mercator_1SP in geotiff files. It just ignores the scale factor and uses 1.0. Which means in GDAL and libgeotiff as they are now, there is no way to export Mercator projections that don't have a scale of 1.0 to arcgis. ArcGIS does support Mercator_2SP, but

Re: [gdal-dev] Using/citing GDAL documentation

2013-11-13 Thread Eli Adam
On Fri, Oct 18, 2013 at 6:13 PM, Jonathan Greenberg j...@illinois.edu wrote: GDALers: I'm working with a colleague on a new set of R wrappers for GDAL, and we are at the point where we are starting to document the functions. Our R interface is designed to be VERY close to the GDAL command