DECIMAL is the MySQL data-type for exact arithmetic. Latitudes range from -90 to +90 (degrees), so DECIMAL(10,8) is ok for that, but longitudes range from -180 to +180 (degrees) so you need DECIMAL(11,8) .Click to see full answer. People also ask, what data type is location?Location data are information about the geographic positions of devices (such as smartphones or tablets) or structures (such as buildings, attractions). The geographic positions of location data are called Coordinates, they are commonly expressed in Latitude and Longitude format.One may also ask, how do you store longitude and latitude? Longitude and latitude coordinates are stored with 15 decimal digits right of the decimal points. By default LAStools will use 7 decimal digits to store longitude and latitude coordinates to a LAS or LAZ file. People also ask, what is longitude data? The Latitude/Longitude Data Standard is a set of data elements that can be used for recording horizontal and vertical coordinates and associated metadata that define a point on the earth. Places include facilities, sites, monitoring stations, observation points, and other regulated or tracked features.What are common data types in SQL? SQL data types can be broadly divided into following categories. Numeric data types such as int, tinyint, bigint, float, real etc. Date and Time data types such as Date, Time, Datetime etc. Character and String data types such as char, varchar, text etc.