1

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

-2

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

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

  • 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 Oct 15 '18 at 22:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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