Scalar functions:
View code
Create Function DBO. fn_getdistance (@ lngbegin real, @ latbegin real, @ lngend real, @ latend real) returns float as begin declare @ distance real declare @ earth_radius real set @ earth_radius = 6378.137 -- The earth's radius is already divided by 1000, so the following calculated values are kilometers and kilometers declare @ radlatbegin real, @ radlatend real, @ radlatdiff real, @ radlngdiff real set @ radlatbegin. = @ Latbegin * Pi ()/ 180.0 Set @ radlate
Recent projects need to use the positioning function, and to obtain the latitude and longitude of the current location, consult the data to organize the following code:
function Locationposition () {var geolocation = new Bmap.geolocation ();Geolocation.getcurrentposition (function (r) {var city_lat = r.latitude;var city_lng = r.longitude;Cookies.set ("Save_city_latitude", City_lat);Cookies.set ("Save_city_longitude", CITY_LNG);Console.log (City_lat);
For example: Longitude: 10.123456 Latitude: 20.654321Get to the actual location according to the above coordinates (do not use Baidu map or the API of the map of Gao de)The code is as follows:Put it in latitude and longitude. Publicstringgetaddress (doublelatitude,doublelongitude) { geocodergeocoder=newgeocoder (this, Locale.getdefault ());try{ ListThis article is from the "Mobile Platform Development" blog
1.geopy Package Download location https://pypi.python.org/pypi/geopy2. Installation StepsRun cmd, switch to d:/python/geopy-1.11.0/directory (modified according to your own extracted directory and download version number), CD d:/python//geopy-1.11.0 Run command: setup.py build SE tup.py Installthen in the geopy-1.11.0 directory there is a geopy folder to copy this folder to the D:/python directory3. Method 1addresses=open (' C:\Users\Yilin.Wei\Documents\HR\cities6.txt ') from geopy.geocoders Imp
Because the Baidu map api,2.0+ and 3.0+ changes relatively big, API basically was completely changed, some students may 2.0+ API use is very familiar with, but update to 3.0+, but will encounter some small trouble (because the API has changed, you need to re-learn its API, the code will be re-written , which is more painful than egg). So here are some small examples, I hope to upgrade to the 3.0+ of the students have some help.1. How does the Baidu map API map move to the specified
This example describes how PHP calculates the distance between two coordinates (longitude, latitude). Share to everyone for your reference. Specific as follows:Here we use PHP to calculate the distance between two coordinates (longitude, latitude) and return the result to meters or kilometers.function distance($lat1, $lng1, $lat2, $lng2, $miles = true){$pi80 = M_PI / 180;$lat1 *= $pi80;$lng1 *= $pi80;$lat2
At a very young age, the teacher told us that any place on earth could be determined by latitude and longitude. The warp and weft are also marked on the paper map. When you use the Baidu map, you will see the warp and weft? Will you pay attention to the coordinates of a place, latitude and longitude? This article tells you how to display a place on the Baidu map of lati
Tags: long search limit Data sel technology share structure latitude and longitude return
database table Structure
2. The key is this SQLSELECT Address_, Longitude_, Latitude_, ROUND (6378.138 * 2 * ASIN (SQRT (POW () (? * PI ()/180-latitude_ * PI ()/180)/ 2), 2) + cos (? * PI ()/+) * cos (latitude_ * PI ()/+) * POW (SIN ((? * PI ()/180-longitude_ * PI ()/180)/2), 2)) ) * +) as Distance_um from xf_lfhz_health_roll_addires where business_id =?
In Android, GPS cannot be used to obtain longitude and latitude. solution:
Summary:
1. According to the Internet, two ways can be used to send latitude and longitude information to the simulator to simulate the satellite's receipt of latitude and longitude information:(1) In ddms, by setting the latitude and longit
Recently used in accordance with the latitude and longitude calculation of the Earth's surface two distance between the formula, and then use JS to achieve a bit.
There are probably two ways to calculate the distance between two points on the Earth's surface.
The first is the default Earth is a smooth spherical surface, and then calculate the distance between any two points, this distance is called the Great Circle distance (the great Circle Distance)
ctrl_ove = new Bmap.overviewmapcontrol ({anchor:bmap_anchor_bottom_right,isopen:1});
Map.addcontrol (ctrl_ove);
Add a scale control to the map
var Ctrl_sca = new Bmap.scalecontrol ({anchor:bmap_anchor_bottom_left});
Map.addcontrol (CTRL_SCA);
}
Second, click the location and then convert to address by latitude
Listens for click event
map.addeventlistener ("click", Function (e) {
map.clearoverlays ();
Alert (
Baidu Map, to achieve vehicle trajectory mapping
Implementation ideas:
1. Vehicle trajectory mapping according to latitude and longitude
2. Using the Baidu Map API two overlay implementation, Polyline (polyline) Draw track, Marker (icon) to draw the car icon
3. Connect each of the two coordinates to form a coherent trajectory line
4. After the next icon is generated, delete the last drawn icon to create a car moving animation sense
5. This example use
data from the program9876543 9876543.12 9876540mysql> INSERT into T1 values (1.21, 1.12,1.21);1. In Toad for MySQL, the display isC1 C2 C31.21 1.12 1.212. The display in MySQL Query browser isC1 C2 C31.21 1.12 1.213. Remove data from the program1.21 1.12 1.21mysql> INSERT into T1 values (1.2, 1.2,1.2);1. In Toad for MySQL, the display isC1 C2 C31.2 1.20 1.22. The display in MySQL Query browser isC1 C2 C31.20 1.20 1.23. Remove data from the program1.2 1.20 1.2mysql> INSERT INTO T1 values (987654
Use navigator of H5. the geolocation interface obtains the longitude and latitude of the user. However, a confirmation message indicating whether to agree is displayed every time the user enters the page, resulting in unfriendly user experience. Are there other ways to obtain the user's latitude and longitude? The requirement is to obtain the user's latitude and
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.