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

1 Answer 1


You should use GEOGRAPHY and yes it will work with both Open Street and Google Maps.

  • 1
    please edit your answer to include more information. Why is geography better? Your answer reads more like a comment with nothing to back up your statement. Our site works better with more detailed and thought out answers hopefully with references to back up your claims.
    – Fezter
    Commented Oct 15, 2018 at 22:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.