Sunday, September 12, 2010

OGR MS SQL 2008 Spatial driver

I've now added the initial revision of the OGR MS SQL Spatial driver to the GDAL repository. For further information please refer to the driver information page.
Working binaries (which always contain all the recent fixes) can be downloaded from the daily build system available at: http://vbkto.dyndns.org/sdk/

Since I didn't have the chance to test with all kind of the fancy spatial data types any feedback on the potential issues are graciously accepted.

Upon the experiences gathered when writing this driver, I'm also planning to add support for accessing the native SqlGeometry/SqlGeography serialization format in the MapServer sql2008 driver which appears to provide a significant increment in the performance of the data retrieval.
Posted by at

7 comments:

  1. UnknownDecember 23, 2010 at 7:24 PM

    Any updates on GEOGRAPHY support for the MapServer driver?

    ReplyDelete
  2. Tamas SzekeresDecember 23, 2010 at 7:49 PM

    Geography support has already been added in the development versions, you can download the corresponding binaries from http://vbkto.dyndns.org/sdk/

    According to the implementation, for the geography type you should specify the colum type in the DATA section explicitly, like:

    DATA "ogr_geometry(geography) from rivers USING UNIQUE ogr_fid USING SRID=4326"

    For more information about the MSSQL driver in MapServer see: http://mapserver.org/trunk/input/vector/mssql.html

    ReplyDelete
  3. gmMarch 2, 2011 at 7:50 AM

    Thank you for the SQL 2008 Spatial driver, it is very welcome!

    I have been relying upon Morten's SqlSpatialTools to import shapefiles into SQL 2008. Finally, now there is a driver that allows me to use ogr2ogr to create a shapefile directly from SQL Server! Thank You!

    I have found that geometry data type is exported to shapefile correctly. An export using SQL Server geography data type, however, appears to have the coordinates reversed. That is x=y and y=x...

    Other than that, no issues so far using the driver.

    ReplyDelete
    Replies
    1. UnknownAugust 15, 2013 at 9:45 AM

      How to make to mssql driver works in Ubuntu 13.04 with QGIS 1.8?

      Delete
  4. Paul JohnsonJuly 12, 2017 at 3:55 PM

    Thank you for your information. I love to read it much. Gamingguide

    ReplyDelete
  5. david jackFebruary 6, 2020 at 9:20 AM

    We have all of the 2020 Australian AFL football fixtures for today, this week & every afl live tv streaming season.football fixtures site for the 2020 Australian AFL.

    ReplyDelete
  6. david jackFebruary 18, 2020 at 12:18 PM

    Some of these encounters are going to be great. Emmanuel Navarrete is the Mexican and he is currently holding the WBO super welterweight bout champion. As far as he is concerned, Fury Wilder PPV the fight is due or die affair because he needs to prove that he deserves to hold that belt. Joe Santissima will pose a difficult challenge for him.

    ReplyDelete

Subscribe to: Post Comments (Atom)