First up, Morten has helped fix a number of bugs in Geoquery, and this release is no exception. While trying out his OGC conformance test map I discovered some GEOMETRY idiosyncrasies I still hadn't fixed. If you read his post and download the schema/data, this sql works best in Geoquery.
![](http://3.bp.blogspot.com/_Ba76y6K7kvs/R80ogV4-iXI/AAAAAAAAAP4/5NXcoWMiO28/s200/072_JoesBlueLake.png)
Morten also pointed out the issue with holes... (notice how the GEOGRAPHY instance is rendered on both the Shape & Map tabs!)
![](http://4.bp.blogspot.com/_Ba76y6K7kvs/R80ogl4-iYI/AAAAAAAAAQA/pYUzUg2wWNg/s200/072_Ringa.png)
![](http://2.bp.blogspot.com/_Ba76y6K7kvs/R80oqF4-iZI/AAAAAAAAAQI/zEKpfCKC-RA/s200/072_Ringb.png)
![](http://3.bp.blogspot.com/_Ba76y6K7kvs/R80oqV4-iaI/AAAAAAAAAQQ/3_2vTxwUESU/s200/072_Ringc.png)
And finally, after a month away from the code (some of it at the beach :) it was relatively quick to solve most of the problems around 'wrapping': with a bit more help from Ed Williams I was able to discard my previous efforts (using the SqlTypes) and solve the problem with some basic math - hoorah!
![](http://1.bp.blogspot.com/_Ba76y6K7kvs/R80oe14-iUI/AAAAAAAAAPg/3yq5YygTDpc/s200/072_Across180a.png)
![](http://1.bp.blogspot.com/_Ba76y6K7kvs/R80of14-iVI/AAAAAAAAAPo/xj8s2Z1Mmuw/s200/072_Across180b.png)
![](http://1.bp.blogspot.com/_Ba76y6K7kvs/R80of14-iWI/AAAAAAAAAPw/lLaYhE8x5zc/s200/072_Across180c.png)
I expect it will be a bit of a wait for the next version of this code. I have a lot of ideas to incorporate, some of which require further architectural changes. I will also update the Examples to discuss the new features in CTP6. Until then - enjoy Geoquerying...
No comments:
Post a Comment
Note: only a member of this blog may post a comment.