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

[Tamas Szekeres]

The driver is doing something like:

select top 1 ogr_geometry.STSrid from [mytable]

Best regards,

Tamas



2013/11/13 Bob Cave <bobc at 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 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 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/20131113/230a6041/attachment.html>