473,670 Members | 2,609 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

storing latitude and longitude

omerbutt
638 Contributor
hi i am trying to store the longitude and latitude i have made the table with 3 columns codes, longitude , latitude and the type for longitude and latitude is decimal(15,11) but there are different lengths for the longitude and latitude value means some where it has 5 digits after decimal and somewhere 8 and when i save it in the table it places zeros for the values which do not have the length of 15 what should i do if i do not want to store extra zeros and only the exact value, temporarily i have changed it to varchar(255) :(
Dec 7 '09 #1
1 5310
kovik
1,044 Recognized Expert Top Contributor
Use a DOUBLE. It is more flexible than DECIMAL. DECIMAL is mostly for when you want to always round your values to a certain amount of decimal places. Like, money, for example.
Dec 12 '09 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3065
by: jack | last post by:
not sure exactly where I should ask this question, but im looking for a database of Australian Postcodes that included the longitude/latitude. Does anyone know of such a thing? Preferably free...fingers crossed. many thanks jack
4
4850
by: YS Sze | last post by:
If you know the exact longitude and latitude for a specific location, would anyone think it'd make any sense to find out if this set of location numbers is really part of the Fibonacci series or not? Or, another way to look at this is that: Would anyone of you think it is worth a while to find out if there is any location on earth with the set of longitude and latitude numbers that coincides with the Fibonacci series? As I see it, if...
1
2380
by: Jochen | last post by:
Hello, I'm currently trying to programm a Windows Application that embedds a MapPointControl. My question is, how I can retrieve the Longitude and Latitude from a spot on the map, e.g. the Mouse position. Unfortunately the Location Object does contain these values but I couldn't find a way to retrieve these values.
2
2528
by: kbperry | last post by:
I am not sure if this is the right place for this, but I thought it was worth a shot. What I want: Enter a From: street address and a To: street address, and then specify an interval (say every half mile). Then, I click a submit button, and it gives me latitude and longitude points (in order) from the beginning of my trip to the end of my trip in 1/2 mile increments.
6
3740
by: helpneeded | last post by:
Hi I am a novice using the <maptag. I have a question. I would really appreciate if you could answer me. I want to use the <maptag to dynamically update my map with coordinates. These coordinates are in the form of geographic coordinates (latitude, longitude). Can this be achieved ? How ? Please help. Regards
1
1612
by: dru103079 | last post by:
Say I have this code that is printing out: sum = convertSixteen(bp_dat); outFile<<sum; counter++; if (sum ==10) outFile<<setw(25)<<"ABMOC"<<endl<<endl; else if (sum == 11) outFile<<endl<<"A2C2"<<endl<<endl; else if (sum == 12) outFile<<endl<<"Battery CP"<<endl<<endl;
1
3363
by: ttamilvanan81 | last post by:
Hai everyone, I need to find the Latitude and Longitude values for any one of the Particular location from the Google Maps, using pure java class. I know, it's done by using javascript, but i need to use pure java class not javascript. If we provide full address of the location or city or state or country or pincode, then we get the Latitude and Longitude values for the particulars in the google maps. If anyone having any sample...
5
10094
by: arial | last post by:
Hi all, I have a sql .bak file which i need to convert into xml file. can someone help with this? pointing out to some tutorial or some suggetion on how to start? Thak you,
1
2738
by: alan5 | last post by:
I want to answer on the topic australian postcode db with longitude/latitude posted by jack. He wrote: not sure exactly where I should ask this question, but im looking for a database of Australian Postcodes that included the longitude/latitude. Yes, I know where to get Australian Postcodes that included the longitude/latitude. Please see here: http://www.getgeocode.com/postcodes/au/ Best Regads, Alan
0
8471
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8386
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8592
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7421
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6216
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5686
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4213
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4393
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2802
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.