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.

45 comments:

  1. Any updates on GEOGRAPHY support for the MapServer driver?

    ReplyDelete
  2. 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. 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. How to make to mssql driver works in Ubuntu 13.04 with QGIS 1.8?

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

    ReplyDelete
  5. 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. 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
  7. Our buyers are our assets. And we don’t hesitate to go the extra mile to halal meat philadelphia serve them with the best. We make sure no one waits and keep shelves full of groceries 24 hours a day.

    ReplyDelete
  8. Dr. Samra-Latif Estafan is committed to helping you achieve wellness strawberry lipo near me and total health through a holistic and integrative approach to dedicated healthcare.

    ReplyDelete
  9. Law Offices Of Rizwan M. Khalid is here to protect your legal rights and help defend you in need. Immigration clients are Best Lawyers Near Me served throughout the United States and the world. Other legal services are offered only in New Jersey and Pennsylvania.

    ReplyDelete
  10. Kabobi serves you Halal kabobeesh food. We offer you healthy and delicious food. You can order a variety of food from our Halal food menu, which would be served to you in minutes.

    ReplyDelete
  11. Williamson Caterers is a preferred caterer for venues and historic locations Caterers Philadelphia throughout the region. We also bring our services to your home, place of worship, office, school or any unique location you may find.

    ReplyDelete
  12. I believe you have noted some very interesting details , thankyou for the post. VerzuzBattleOnline

    ReplyDelete
  13. Zonas online store selling women clothing underwear and accessories all over Australia. Our exclusive products are menstrual and maternity range. We want to cater women's with all their special needs giving them comfier apparel at affordable prices. Our menstrual panties are highly absorbent, leakproof, breathable, reusable, environmental friendly, odorless and easy wash. We have a wide range of sizes, styles Sexy Panties and colors. Soon we gonna launch our maternity and activewear range. That's not enough much more to come, variety of fashionable attires + under garments so keep in touch.

    ReplyDelete
  14. Prolific Studio as an Animation Company offers a wide animation company logos and extensive range of animated video production services with creative ideas and flawless designs in competitive prices and affordable packages. We focus on delivering quality animations.

    ReplyDelete
  15. Lil’ Kim has been a fixture on the hip-hop scene for more than two decades. Now 46, the “Crush On You” rapper’s appearance has changed dramatically over the years. Lil Kim Before And After Plastic Surgery Prompting fans to closely examine Lil’ Kim before and after photos to determine if she’s gone under the knife. How To Watch Money Heist Season 5 Free Online.

    ReplyDelete
  16. Thank you for the post. It will be helpful for me. I am sharing that best 4000 watt generator are suitable for heavy-duty applications like microwaves, washing machines, hair dryers, and refrigerators. This makes them an ideal source of portable power on the go.

    ReplyDelete
  17. Great Post....!!!!!! Best 15000 Watt Generator for the money. It can run all night using either gas or propane.

    ReplyDelete
  18. Digital Marketing Company Houston providing eCommerce Website Solutions, WordPress & Magento Development, eCommerce Website Design & Local SEO Houston.

    ReplyDelete
  19. the encounters assembled when composing this driver, Write My Essay Online likewise wanting to add support for getting to the local.

    ReplyDelete
  20. Amazing blog man. Really impressed with this blog. Thanks for posting this.
    Mobilemall Bangladesh

    ReplyDelete
  21. We specialize in providing ecommerce business license, consultancy & services based company license and trading license services in Company setup Ajman media city. We also offer Freelance Visa ajman services company in Dubai.

    ReplyDelete
  22. Who else, except guys above the age of 25, requires a woman's assistance? And there was a time when I needed the help of a lady. One day, I came across an amazing article on how to find a russian bride. I read it and became intrigued in this alternative. Now I'm in contact with a girl who likes me, and we're even thinking about creating a life together. I'd want to thank you very much for these opportunity to transform our life and suggest these gentlemen to everyone.

    ReplyDelete
  23. Chase My Cloud is the leading online vape shop in Pakistan, providing uwell vape shops near me and other best vape flavours in Pakistan. Buy online vape from best vape shop in Pakistan.

    ReplyDelete
  24. In business since 2010, Primlink is one of the largest quality control company providing product inspections, supplier quality assessments and factory audits services at Asia, America, Australia, Turkey, and other countries. pre shipment inspection procedure

    ReplyDelete
  25. Hi, I really enjoyed reading your post, and hope to read more. thank you so much for sharing this informative blog. You may also like.Buy leather jacket

    ReplyDelete
  26. we are a leading local seo chicago company provides, digital marketing, search engine optimization, ecomerce marketing, magento development and ecommerce web design services in Chicago

    ReplyDelete
  27. We're a top online shopping store in karachi providing beauty care products, home & kitchen products and kids accessories and schools kids items, buy home decor products items online in karachi

    ReplyDelete
  28. Very well-written article, thank you for the valuable and useful information you provide in this post. seo services dubai

    ReplyDelete
  29. Thanks for sharing this useful and helpful content may be this link also very useful for others
    sell samsung galaxy s2
    sell samsung galaxy s2
    https://www.recyclepro.co.uk/products.php?b=Samsung&bid=21&pc=2

    ReplyDelete
  30. Thank you for the great article. Are you meet the situation that the site you want to access is denied? Node Unblocker you can utilize proxies to get to and partake in the ideal content. In this way, we should figure out additional proxies.

    ReplyDelete
  31. Great piece of information here on your website. Keep up the good work, I am really glad that I found your website and I will gladly subscribe your blog for more interesting information.
    Sell Samsung Galaxy S21 Ultra 5G 128GB

    ReplyDelete
  32. We often offer special discounts and coupons for OriginPC discount code. Check back often to see what's available!

    ReplyDelete
  33. Your Article Is Well Written And Simple To Understand. You Make Excellent Points. Thanks For The Blog…..

    ReplyDelete
  34. My Sql article is informative one. Thanks for sharing this tech blog for us. Keep sharing more blogs. Abogado Conducción Imprudente Rockingham VA

    ReplyDelete