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

[Tamas Szekeres]

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 at 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 at .osgeo
> >>
> >> >> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> >> >>
> >> >
> >> > _______________________________________________
> >> > gdal-dev mailing list
> >>
> >> > gdal-dev at .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 at .osgeo
>
> >> http://lists.osgeo.org/mailman/listinfo/gdal-dev
> >>
> >
> > _______________________________________________
> > gdal-dev mailing list
>
> > gdal-dev at .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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20131114/fc768983/attachment.html>