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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJwdrzRZjWdwWvOIuFipaszqRr5o-bBH67S7vzCB5F9eBcB-bCjGsFoaPyMhCNrk-RjZd6Qo_e_ViF8wt3TKVJAyc0qFp9cLqYtlic9uSjhthZVSPWlHaG8NOgMZ1hUlRGifGh/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!)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPIxZ5MTJ9RdInU9QO9o0k99f9dkrSeWIwsOy9JLLmhR3IAd6wd20YFJdKo-tcOHuL062jIohtmgmAjQtaIhWTkalAna0BwdyqYyFqWfuo9beMJP6aj8VDzGzqB0PW8B4mmCvD/s200/072_Ringa.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFdlbPuHuC0uSF673W2_fWbOfDWW0XaLVx5zWMouZ-jWLuZXU3w5livw9wfjYQu4SZVK2DMFm6e-tvh8ZqTjSOE1jOpaiDLdBiUenFSR4PP4UjxEg0qrMkX8oF5c_RVpBKyZqs/s200/072_Ringb.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmsbAEmrYP1pjToB5LXefcU_hO-JfVRHXO9OdOPgJEVd4ZIqKfyjZclFZT9AU3Pg_jWUwmipf0kHz14B8RvixLnYrZn1PnxAJChGRhUHp7jOVAfhraK5xjvkl0sr3gHbDAasXF/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!
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT7rkOC5V7fNjO0Aw8am9_NodFzsG9YWULdqVgULD5Vveal0j4usixo8dMM3GnxjbDIgaF60d4n7yHiGcGOgvDE9wvwof-neRAiOQ2RD5gMGDaBL-ByicFzgg6hoQ2CnGjOQK6/s200/072_Across180a.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBDql3zaqAwDegzu8k8FuiE20VZe6WLqaYapBNTHNsGYjUfj7X4NhUa1_1POFtXigNHXcKKu4_7TuIOAQNqC-2LolcpXIoHGpfnyKntRqX7mY1tpLbrYYE973Qp7HiL6c_a570/s200/072_Across180b.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTdOPDclrAObUq3A6INdYoeH5VywBwFq9gEG_SXIfVi95SyTb9uVXIFAx7RxMgr5c24wVWHc-u7IrN5MJUi8LLLthS5xn3id-1UG75w-YOqHjXduitejS8VEapP22N2j-4jkD8/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.