spatial

相关标签：javascript jquery android 多少钱 iPhone

Mysql within distance query

Options $lat = \'25.7742658\'; $lng = \'-80.1936589\'; $miles = 30; Query SELECT *, ( 3959 * acos( cos( radians($lat) )[详细]

2023-03-17 09:27 分类：问答
Storing and retrieving historical data using SQL / relational database

Given this table: CREATE TABLE DeptPeopleHistory ( DEPT_ID INTEGER, PERSON_ID INTEGER, START_DATE INTEGER,[详细]

2023-03-14 22:10 分类：问答
how to get the index of a point from geography?

How can i get the index of a point which is in my LineString? I am using SQL Server 2008 R2. I do have a geography type where a LineString is saved in.[详细]

2023-03-14 18:17 分类：问答
Zoom in on SSRS 2008 R2 Spatial Map

Is it possible to zoom in on a map which has already been generated in SSRS 2008 R2? I can see how to set the zoom level at design time, but not at run time[详细]

2023-03-14 07:56 分类：问答
Most efficient way to get points within radius of a point with sql server spatial

I am trying to work out the most efficient query to get points within a radius of a given point. The results do not have to be very accurate so I would favor speed over accuracy.[详细]

2023-03-13 05:28 分类：问答
System for storing Geometric Data for use in a WPF application

I\'m writing a WPF app that uses thousands of WPF shapes.What is the most efficient method to store a large number开发者_StackOverflow社区 of polygon coordinates for use in WPF?[详细]

2023-03-12 04:04 分类：问答
In excel how can a calculate distances between 2 large sets of points with lat/longs?

Greetings everyone, I have 2 sets of points in excel (group A and B), each set has around 1000 entries that contain lat/long.What I want to do is compare Group A against Gro开发者_JAVA百科up B and fig[详细]

2023-03-10 14:07 分类：问答
what is the MySQL function wchih is equavalent to DB2/PostGIS function "ST_Intersection"?

I\'m doing some performance comparison between DB2/MySQL spatial functions. However after I translate the DB2 spatial queries into MySQL dialect, it complains about syntax error (ERROR: Function Inter[详细]

2023-03-09 20:25 分类：问答
Mysql point data type & glength returns null

The following glength() statement returns null always. SET @mref_point1=point(12.937060,77.671280); SET @mref_point2=point(13.937060,73.271280);[详细]

2023-03-08 21:58 分类：问答
Movement Paths & Spatial-Temporal Queries in SQL Server

Hey, so I\'m trying to figure out the best way of storing movement paths and then afterwards how they might be queried.[详细]

2023-03-07 02:06 分类：问答