Maintaining data with two co-ordinates schemes

Topics: User Forum
Nov 2, 2007 at 3:45 PM
I'm new to MsSqlSpatial so bear with me if the solution is obvious or impossible..

I want to maintain spatial data with both WGS84 and either a State Plane or British Nation Grid spatial references in a single table as the data maybe used in display via Google or analysis via traditional GIS.

I'm happy with creating two geometry stores in the same table with different SRIDs and I've been able to achieve what I want using the Census point data in the samples, but my main use will involve polygons.

What I need is an SQL example on how to bulk populate the second geometry field on a table using polygon data stored in the first create by a shape file import (and then I'll need a single update mechanism, but I think I should be able to work that out!!)

Many thanks