asked on

SQL Server: How to validate Latitude & Longitude value is valid

Hello Folks,

I've one table which contains Latitude & Longitude for each record.

Is there any ways to validate Latitude & Longitude value valid or not?

Best Regards

Walter Ritzel

The latitude must be a number between -90 and 90 and the longitude between -180 and 180.
So, you can create check constraints on your fields.

create table x (
id int not null,
latitude float CHECK (latitude > -90 and latitude < 90),
longitude float CHECK (longitude > -90 and longitude < 90))

Open in new window

MohitPandit

ASKER

Should it be >= -90 and <=90 i.e. greater than equal to 90 and less than equal to 90?

Apart, do you have any URL for this rule?

Walter Ritzel

No, I don't have. But you can get many if you simply type valid latitude longitude values on google.
Here is the fixed check constraints for that.

create table x (
id int not null,
latitude float CHECK (latitude >= -90 and latitude <= 90),
longitude float CHECK (longitude >= -180 and longitude <= 180))

Open in new window

ASKER CERTIFIED SOLUTION