Which spatial data type should be used for UK data in SQL Server?, i.e. GEOMETRY or GEOGRAPHY?
I'm aware of OS National Grid and my understanding is it's an X/Y coordinate system, covering from Sicily Isle to Shetlands.
So it looks like best option would be GEOMETRY
But if we store our data in GEOMETRY, will it work with things like Open Street Maps, e.g. using LeafletJS with OSM base, and our data as overlays