With some guidance from Paul Ramsey, I implemented a check constraint on my sample table to allow only a single SRID in a table. As Paul indicated in his comment on my previous post, PostGIS does this for you. SQL 2008 doesn’t yet but I hope it does. The syntax for my table was:
–only allow [...]
Filed under: database, gis, postgis, sql server, sql server spatial | 2 Comments »
I’ve been playing with the SQL 2008 November CTP since it was released last week and have been generally impressed but as I have delved into its handling fo spatial references, I have noted some areas of concern. Keeping in mind that it’s a CTP, I’m hoping that some aspects may be addressed before release.
Filed under: database, gis, sql server, sql server spatial | Tagged: manifold | 3 Comments »
