CODEWITHSUNDEEP
sql-server-2005geocoding
Chin
Chin

Reputation: 12712

SQL Server 2005 Column Type to store LatLng Coordinates

In SQL Server 2005 what column type should I use to store a LatLng Coordinate?

For example a Lat coordinate like 135.0058554

I know there are new types in SQL Server 2008 but I'm stuck with SQL Server 2005 for the time being.

thanks

Upvotes: 2

Views: 704

Answers (3)

Robert Calhoun
Robert Calhoun

Reputation: 5153

We use "float" (8 bytes/15 digits), which has adequate (~micron) resolution for most needs and good performance/storage efficiency.

W.r.t. @OMG Ponies' point, I'm a proponent of signed decimal degrees over DMS.

p.s. a latitude of 135.0058554 is REALLY REALLY far north! :-)

Upvotes: 0

Dave Barker
Dave Barker

Reputation: 6447

We're using numeic (12,8) and haven't had any problems with 55,000 Australian geocoded addresses.

Upvotes: 0

Leniel Maccaferri
Leniel Maccaferri

Reputation: 102448

Use Decimal.

For example:

Decimal(18,15) for high precision.

Upvotes: 1

Related Questions