Longitude field

5 pts.
Tags:
Data management and storage
GIS software
I created a table and form for data, which includes a latitude and longitude field. Lat and Long date will be entered as degrees decimal. The lat/long data will be used for mapping purposes (exported to a GIS). For proper mapping, the longitude data must be negative. I don't want to rely on the user to remember to put a negative sign in front of their longitude data at the time of input. Is there a way that I can set up the field to automatically put a negative sign in front of the longitude value, if the user forgets to do it? Basically, I want to make sure that all data in the longitude field starts with a negative sign.
ASKED: September 10, 2008  1:42 PM
UPDATED: September 10, 2008  2:29 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You would need to setup the UI which the user users to enter the data to handle this. But what if the user needs to enter a location in Europe or Africa? In which case the longitude would need to be a positive number.

If you are using a stored procedure you could put logic in the stored procedure to multiple the value by -1 if the value is greater than 0.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following