I have latitudes and longitues in a table but they are in a nvarchar(50) field althought the values are like this -> 39.7355 I need to be able to convert those values to numeric to execute a calculation and update a new field
[Code]....
my radiantlatitude field is of type 'float'
I've been struggling for the past couple of days to get this right. I'm in the process of building something that takes a whole bunch of geographic points, builds a heat map from the data, then overlays it as a tile on Google Earth / Google Maps. A bit like this: [URL]
I have all the heatmap functionality nailed using random xy points. The last part is doing the actual conversion to convert my real lat/lng pairs into x/y pixels to be rendered onto the heatmap image. Lets say I the image is 500px x 500px. I know the min and max values for the lat/lng points, so technically I need to divide the spread between the pixels to get a pixel value for each degree based on the top left pixel of the image (0,0). I've been through so many examples, but I just cant get them to work. The last one I tried was this:
[Code]....
I feed data into my heatpoint function using these 2 functions above like this. Here's a set of 4 points:
[Code]....
The problem I get is that the result is the same for all the points - they all get plotted to exactly the same point. Now, the data is fairly localised, so I dont really need to take the curvature of the earth into consideration.
If I enter the a location of: Latitude = 28 Degrees, 45 Minutes, 12 Seconds Longitude = 81 Degrees, 39 Minutes, 32.4 Seconds. It gets converted into Decimal Degrees format to be stored in the database with the following code:
Coordinates coordinates = new Coordinates();
coordinates.LatitudeDirection = this.radLatNorth.Checked ? Coordinates.Direction.North : Coordinates.Direction.South;
coordinates.LatitudeDegree = this.ConvertDouble(this.txtLatDegree.Text);
coordinates.LatitudeMinute = this.ConvertDouble(this.txtLatMinute.Text);
coordinates.LatitudeSecond = this.ConvertDouble(this.txtLatSecond.Text);
coordinates.LongitudeDirection = radLongEast.Checked ? Coordinates.Direction.East : Coordinates.Direction.West;
coordinates.LongitudeDegree = this.ConvertDouble(this.txtLongDegree.Text);
coordinates.LongitudeMinute = this.ConvertDouble(this.txtLongMinute.Text);
coordinates.LongitudeSecond = this.ConvertDouble(this.txtLongSecond.Text);
//gets the calulated fields of Lat and Long
coordinates.ConvertDegreesMinutesSeconds();
In the above code, ConvertDouble is defined as:
private double ConvertDouble(string value)
{
double newValue = 0;
double.TryParse(value, out newValue);
return newValue;
}
and ConvertDegreesMinutesSeconds is defined as:
public void ConvertDegreesMinutesSeconds()
{
this.Latitude = this.LatitudeDegree + (this.LatitudeMinute / 60) + (this.LatitudeSecond / 3600);
this.Longitude = this.LongitudeDegree + (this.LongitudeMinute / 60) + (this.LongitudeSecond / 3600);
//adds the negative sign
if (LatitudeDirection == Direction.South)
{
this.Latitude = 0 - this.Latitude;
}
else if (LongitudeDirection == Direction.West)
{
this.Longitude = 0 - this.Longitude;
}
}
If I don't make any change to the latitude or longitude and I click Apply Changes which basically does the above calucation again, it generates a different latitude and longitude in the database. This happens every time I go to edit it and don't make a change (I just click Apply Changes and it does the calculation again with a different result). In the above scenario, the new Latitude and Longitude is: Latitude = 28 Degrees, 45 Minutes, 12 Seconds Longitude = 81 Degrees, 40 Minutes, 32.4 Seconds If I do it again, it becomes:
Latitude = 28 Degrees, 45 Minutes, 12 Seconds Longitude = 81 Degrees, 41 Minutes, 32.4 Seconds The other part of this is that when I go into edit, it takes the decimal degrees format of the latitude and longitude and converts it to the degrees minutes seconds format and puts them into their respective textboxes. The code for that is:
public void SetFields()
{
Coordinates coordinateLocation = new Coordinates();
coordinateLocation.Latitude = this.Latitude;
coordinateLocation.Longitude = this.Longitude;
coordinateLocation.ConvertDecimal();
this.radLatNorth.Checked =
coordinateLocation.LatitudeDirection == Coordinates.Direction.North;
this.radLatSouth.Checked = !this.radLatNorth.Checked;
this.txtLatDegree.Text = coordinateLocation.LatitudeDegree.ToString().Replace("-", string.Empty);
this.txtLatMinute.Text = Math.Round(coordinateLocation.LatitudeMinute, 0).ToString().Replace("-", string.Empty);
this.txtLatSecond.Text = Math.Round(coordinateLocation.LatitudeSecond, 2).ToString().Replace("-", string.Empty);
this.radLongEast.Checked =
coordinateLocation.LongitudeDirection == Coordinates.Direction.East;
this.radLongWest.Checked = !this.radLongEast.Checked;
this.txtLongDegree.Text = coordinateLocation.LongitudeDegree.ToString().Replace("-", string.Empty); ;
this.txtLongMinute.Text = Math.Round(coordinateLocation.LongitudeMinute, 0).ToString().Replace("-", string.Empty);
this.txtLongSecond.Text = Math.Round(coordinateLocation.LongitudeSecond, 2).ToString().Replace("-", string.Empty);
}
From the above examples, you can see that the Minute kept increasing by 1, which would indicate why it is generating a different latitude and longitude in decimal degrees in the database, so I guess the problem is more in the above area, but I am not sure where or why it is doing it?
public void ConvertDecimal()
{
this.LatitudeDirection = this.Latitude > 0 ? Direction.North : Direction.South;
this.LatitudeDegree = (int)Math.Truncate(this.Latitude);
if (LatitudeDirection == Direction.South)
{
this.LatitudeDegree = 0 - this.LatitudeDegree;
}
this.LatitudeMinute = (this.Latitude - Math.Truncate(this.Latitude)) * 60;
this.LatitudeSecond = (this.LatitudeMinute - Math.Truncate(this.LatitudeMinute)) * 60;
this.LongitudeDirection = this.Longitude > 0 ? Direction.East : Direction.West;
this.LongitudeDegree = (int)Math.Truncate(this.Longitude);
if (LongitudeDirection == Direction.West)
{
this.LongitudeDegree = 0 - this.LongitudeDegree;
}
this.LongitudeMinute = (this.Longitude - Math.Truncate(this.Longitude)) * 60;
this.LongitudeSecond = (this.LongitudeMinute - Math.Truncate(this.LongitudeMinute)) * 60;
}
I have a feedback page with rating controls and I use a stored procedure to insert the record using C#
I get an error when I try to insert about conversion.
[Code]....
I have 20 ratings and a textbox I think the error is with the last parameter @Overall
it displays on the page as 4.9 in a label control, it is previously calculated in the Calculate_Ratings(), and it is declared as a decimal, I have also tried it declared as double. My column is declared decimal(1,1) in sqlDatabase
The Error says
System.Data.SqlClient.SqlException: Error converting data type numeric to decimal. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
Reliability Rating What is this?
Were we there on the date and times scheduled?
Rating 5 = Perfect
Rating 1 = Very Unreliable
protected void Update(object sender, EventArgs e)
{
foreach (GridViewRow row in gvStudeff.Rows)
{
[Code].....
I cant seem to find a good example of how to build the query logic. We are allowing users to search based on lat/long and need to add radius as another parameter. So you enter 29.30125 as the latitude and -95.04590 as the longitude and pick say 15miles as the radius, i need to return all records that fall within that radius.. can someone suggest a good site to review this type of query?
View 1 Replieshow to validate latitude and longitude. regex for latitude and longitude
View 3 RepliesI need to display the location name in the lable control based on passing the latitude and longitude values how could i do it
View 7 Replieshow can i raise event just after user change his position in google map using dragging map and get the latitude and longitude of center of google map and the miles its showing from center. i have got lots of pages on google related to it.. but not able to solve this.. please give me solution (i am using asp.net and javascript)
View 2 RepliesI want to get latitude and longitude from address in one of my asp.net application, i know it s possible using google apis but i want to do it without showing google map. How can i do that? I also want to get distance between two pairs of latitude and longitude.
View 1 Repliesi am trying to find distance by latitude and longtitude by using this formula mentioned in this site.
[URL]
every thing is Ok there when i do it by calculator but when i started doing it by programmatically there is a diiference in result.
here is my part of code
lat = Convert.ToDouble( (s3[a]));
longt =Convert.ToDouble( (s4[a]));
Avg_lat = pc._Latitude - lat;
Avg_longt = pc._Longitude - longt;
a_hold =( Math.Sin(Avg_lat / 2) * Math.Sin(Avg_lat / 2) )+ (Math.Cos(pc._Latitude) * Math.Cos(lat)) * (Math.Sin(Avg_longt / 2) * Math.Sin(Avg_longt / 2));
c_hold = 2 * Math.Atan2(Math.Sqrt(a_hold), Math.Sqrt(1 - a_hold));
// c_hold = (c_hold * 180) / 3.12;
distance = 6371 * c_hold;
the problem is Math funcation here calculate the things in radian i want it in degree. so i just found a formula to convert radian into degree but that formula does'nt convert the calculation correctly..
what to do bcoz there is'nt any other option to convert radian into degree..
how to get longitude and latitude of particular location using C#.net web application.
Here input values are locationame,state,coutry, out put values should longitude and latitude.
First of all im new to asp.net and am in the process of learning it.
Heres my problem, i am receiving this error when submitting the form: "Arithmetic overflow error converting numeric to data type numeric"
And it halts at command.ExecuteNonQuery();
Input form:
[Code]....
Code Behind:
[Code]....
Stored Procedure:
[Code]....
i have set the type of a column in a table numeric(6,2) but when i insert a value above 9999,99 i get the error
"Arithmetic overflow error converting numeric to data type numeric."
Do you know whats wrong??
ofc thats all through visual studio for an asp site thats why im posting here
I tried with the following but it doesn't work
var txtlat=document.getElementById('TextBox1').value=GMap1.getCenter().lat();
var txtlong=document.getElementById('TextBox2').value=GMap1.getCenter().lng();
It gives a JavaScript error as "Object doesn't support this property or method". How can i do this?
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication5._Default" %>
<%@ Register assembly="GMaps" namespace="Subgurim.Controles" tagprefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<cc1:GMap ID="GMap1" runat="server"
Key="ABQIAAAAs98ZVKM_IHFkRP_EavW_DhT2yXp_ZAY8_ufC3CFXhHIE1NvwkxQGoS16N7wYnBPhgtjTxMaUVN58kA" />
<br />
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<br />
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</div>
<script type="text/javascript">
var txtlat=document.getElementById('TextBox1').value=GMap1.getCenter().lat();
var txtlong=document.getElementById('TextBox2').value=GMap1.getCenter().lng();
</script>
</form>
</body>
</html>
i have a requirement, to find out user ipaddress and latitude and lagitude in asp.net .
View 9 RepliesI have a query in SQL Server 2008:
[Code]....
Everything looks fine but I keep getting the error: 'Conversion failed when converting the nvarchar value 'xxxx' to data type int... where xxxx is the the value of @Query.
I am using an adapter to get a list with IN where clause as:
[Code]....
I passed the parameter, CatIDList, with string value 1, 2, 3, 4, 5
However, it returns error of Error converting nvarchar value.
I have array of lattitude and longitude which is derived from one type of polygon, now i want to find all latitude and longitude from my database which are inside this polygon.So how can i achive this?
View 1 Repliesi have latitude and longitude of one city.when i give miles as input,all the cities with its latitude and longitude will display.how to do it in mvc 4
View 1 Repliesi am developing a travel application. for that I need to calculate the future local datetime of a location using Datetime (a future date),longitude and latitude. (for Eg: i want to calculate the local datetime of a location on August-10- 2010 11.23 AM . Due to the day light saving time the datetime offset may change so i need to convert the august-10- 2010 11.23 AM to local time of the location) I have the inputs longitude, latitude and Date time. i can calculate the current local date using Longitude and latitude but cannot calculate accurately for *future date because of the day light saving time off set* . off set may varies on future dates. i am using asp.net and c# .
View 3 RepliesHow to Track the Vehicles using Virtual earth control based on longitude and latitude.Every 5 seconds longitude and latitude values are coming from the database.based on these values vehicle position has to be changed. How to do it. Please give me complete code for this.
View 1 RepliesI have Postcode in my large database, which contains values like SL5 9JH, LU1 3TQ etc. Now when I am pasting above postcode to maps.google.com it's pointing to a perfect location.. My requirement is like I want to pass post codes to maps.google.com and it should return a related latitude and longitude of that pointed location, that I want to store in my database. So, most probably there should be some javascript for that If anybody have another idea regarding that please provide it
View 3 Repliesvar w = [], wp;
var rleg = directionsDisplay.directions.routes[0].legs[0];
data.start = {'lat': rleg.start_location.lat(), 'lng': rleg.start_location.lng()}
data.end = {'lat': rleg.end_location.lat(), 'lng': rleg.end_location.lng()}
var items = new Array();
[Xode] ....
Above code Output :
{"start":{"lat":22.3038548,"lng":70.80213219999996},"end":{"lat":22.470967,"lng":70.05772219999994},"waypoints":["jamnagar","kalavad"]}
But I want to output like this :
{"start":{"lat":22.3038548,"lng":70.80213219999996},"end":{"lat":22.470967,"lng":70.05772219999994},"waypoints":[[22.224905,70.62623409999992],[22.509108,70.22394120000001]]}
So how to convert waypoints location name into waypoints location latitude and longitude????
I have variable as
var from_Lati = 19.132324234 // from latitude
var from_longi = 19.11233334 // from longitude
and I have TO latitude and Longitude in Array as
var To_Lati = [18.132323,18.90941,18.31232423] // to latitude in array
var To_Longi = [18.2132123,18.242423,18.43243] // to longitude in array
I have gone through many reference on internet but can't find the solution for calculating the distance with respect to array.. Now I want to find the distance between them using JavaScript...