Greetings All,
What is the recommended data type for a Longitude(Lon) or Latitude(Lat) Column of an Oracle dB Table? I am creating a signs inventory table in our Oracle database. The Lon and Lat fields along with some other data will be populated from a MS access file exported from Geodatabase. Currently the data type for the Lon and Lat fields of the MS access file is defined as "Double". A couple of Examples of the Lon and Lat data are as follows:
Lat Lon
------------------ -----------------------
...
59.4564555909 -135.3133542922
64.841125 -148.01808
...
What data type should these two columns be defined in the new Oracle database table??? Should the data type be defined as FLOAT(126), NUMBER(10, 6), or else? Any suggestions/help on this would be greatly appreciated.
If the data type is defined as NUMBER(10,6), would the first example of Lon "-135.3133542922" be truncated to "-135.313354" or would I receive an error while trying to import the data from an access file to the Oracle dB?
BTW, I posted this thread in the Database -> Spatial group. But, so far I have not received any response thus I am posting the same question here, and hoping to receive some help soon.
Thanks in advance for any/all the help.