Hi Tamas, It looks like I misunderstood what you were saying. Thank you for the clarification.
Cheers, Bob Tamas Szekeres wrote > 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 < > bobc@ > > > >> 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 >> >> >> >> >> >> >> > [email protected] >> >> >> >> >> http://lists.osgeo.org/mailman/listinfo/gdal-dev >> >> >> >> >> > >> >> > _______________________________________________ >> >> > gdal-dev mailing list >> >> >> >> > [email protected] >> >> >> >> > 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 >> >> >> >> > [email protected] >> >> >> http://lists.osgeo.org/mailman/listinfo/gdal-dev >> >> >> > >> > _______________________________________________ >> > gdal-dev mailing list >> >> > [email protected] >> >> > 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 >> > [email protected] >> http://lists.osgeo.org/mailman/listinfo/gdal-dev >> > > _______________________________________________ > gdal-dev mailing list > [email protected] > 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-tp5089019p5089210.html Sent from the GDAL - Dev mailing list archive at Nabble.com. _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
