Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DbGeography.PointFromText() throws 'Latitude values must be between -90 and 90 degrees' for Japan

Google tells me that Japan's lat/long values are (36,138) but .NET throws the error

24201: Latitude values must be between -90 and 90 degrees.

Any ideas why?

like image 663
happygilmore Avatar asked May 14 '13 14:05

happygilmore


1 Answers

I have had the same issue as you, I was using DbGeography.PointFromText("Point(lat lng)") when the lat & lng arguments are expected the other way around. The complete answer is this:

// From Google, Japan's latitude: 36; longitude: 138
var lat = 36;
var lng = 138;
var location = DbGeography.PointFromText($"Point({lng} {lat})");
like image 93
David Avatar answered Oct 01 '22 18:10

David