New answers tagged geography
UPDATE brb_point SET geography = way::geography;
These are known as enclaves - one example is the Belgium/Dutch border towns of Baarle-Hertog and Baarle-Nassau. Until last month there were many enclaves on the Indian/Bangladeshi border but the two countries rationalised them finally. A google search for border enclaves will find you references to many more.
The only way I can think of converting Lat/Lon columns to geometry on the fly would be to create a view of your table and create a geometry column using STGeomFromText (latColumn, lonColumn, SRID). There is an article here that describes how this is done. In your case, you would publish the view in the method I describe below... I publish views of SQL ...
Top 50 recent answers are included