Bob, I did not mention to use exactly the same select, just a similar effect when reading the geometries. In ogrmssqlspatiallayer.cpp<http://trac.osgeo.org/gdal/browser/trunk/gdal/ogr/ogrsf_frmts/mssqlspatial/ogrmssqlspatiallayer.cpp>see the function OGRMSSQLSpatialLayer::GetNextRawFeature()
nSRSId = oParser.GetSRSId(); and then: if ( GetSpatialRef() ) poGeom->assignSpatialReference( poSRS ); Best regards, Tamas 2013/11/14 Bob Cave <b...@bluemarblegeo.com> > Hi Tamas, > > I looked through the source code for the MS SQL Server Spatial driver, > version 1.10.1 and in the latest trunk download, and was unable to find > that > query. Is that something that you have added but not checked in yet? > > In any case, I will give try that query myself. Thanks. > > Cheers, > > Bob > > > Tamas Szekeres wrote > > The driver is doing something like: > > > > select top 1 ogr_geometry.STSrid from [mytable] > > > > Best regards, > > > > Tamas > > > > > > > > 2013/11/13 Bob Cave < > > > bobc@ > > > > > > > >> 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 reading the geometry_columns table, but when > >> the > >> driver is not using the geometry_columns table, it does not attempt to > >> identify the SRID. I am trying to determine how I can do this myself. > >> > >> Thanks, > >> > >> Bob > >> > >> > >> Tamas Szekeres wrote > >> > 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 < > >> > >> > bobc@ > >> > >> > > > >> > > >> >> 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 MSSQLSPATIAL_USE_GEOMETRY_COLUMNS=YES, then the SRID can > be > >> >> identified. This is fine for my test database, but I need to be able > >> to > >> >> support databases that don't have a geometry_columns table. > >> >> > >> >> Thanks, > >> >> > >> >> Bob > >> >> > >> >> > >> >> > >> >> -- > >> >> View this message in context: > >> >> > >> > http://osgeo-org.1560.x6.nabble.com/Getting-SRID-from-MS-SQL-Server-Spatial-Table-tp5089019.html > >> >> Sent from the GDAL - Dev mailing list archive at Nabble.com. > >> >> _______________________________________________ > >> >> gdal-dev mailing list > >> >> > >> > >> > gdal-dev@.osgeo > >> > >> >> http://lists.osgeo.org/mailman/listinfo/gdal-dev > >> >> > >> > > >> > _______________________________________________ > >> > gdal-dev mailing list > >> > >> > gdal-dev@.osgeo > >> > >> > http://lists.osgeo.org/mailman/listinfo/gdal-dev > >> > >> > >> > >> > >> > >> -- > >> View this message in context: > >> > http://osgeo-org.1560.x6.nabble.com/Getting-SRID-from-MS-SQL-Server-Spatial-Table-tp5089019p5089033.html > >> Sent from the GDAL - Dev mailing list archive at Nabble.com. > >> _______________________________________________ > >> gdal-dev mailing list > >> > > > gdal-dev@.osgeo > > >> http://lists.osgeo.org/mailman/listinfo/gdal-dev > >> > > > > _______________________________________________ > > gdal-dev mailing list > > > gdal-dev@.osgeo > > > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/Getting-SRID-from-MS-SQL-Server-Spatial-Table-tp5089019p5089183.html > Sent from the GDAL - Dev mailing list archive at Nabble.com. > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev