spatial

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

How to define empty polygon for spatial column in MySQL?

I\'m trying to create spatial开发者_JS百科 index over table column (bbox polygon default NULL) but get error: All parts of a SPATIAL index must be NOT NULL.[详细]

2023-04-13 05:31 分类：问答
SQL Spatial Join

I have 2 tables one with points as geographies and other with polygons as geographies. I am able to find which polygon a single point falls(from the point table) by the following query:[详细]

2023-04-10 23:30 分类：问答
SOLR (3.1+) - Multiple Spatial Queries with OR in Same Request

Is it possible to conduct multiple spatial queries within the same SOLR (3.1+) request? We currently have a need to allow user to search for inventory with a location of their choice via a frontend s[详细]

2023-04-10 15:58 分类：问答
Using PHP pack() to Convert WKT into WKB

I\'m using prepared statements to insert data into my database, problem is I\'m not able to use INSERT INTO table (polygon) VALUES (GeomFromText(POLYGON((?,?,?,?,?,?))))[详细]

2023-04-10 15:44 分类：问答
How to use mysql spatial with prepared statements

I\'ve got two scenarios, using the following statement: INSERT INTO areas (name, polygon) VALUES (开发者_如何学编程?, POLYGON(?,?,?,?,?,?))[详细]

2023-04-10 05:50 分类：问答
mysql spatial field

one of the value updated to a field in a mysql table is \'location\' of type开发者_如何学C \'point\'.[详细]

2023-04-03 16:14 分类：问答
Creating Shape Files from SQL Server using Ogr2ogr

I am trying to run the following code in a command window. The code executes, but it gives me no values in the .SHP files. The table has GeographyCollections and Polygons stored in a Field of type Geo[详细]

2023-04-02 16:22 分类：问答
How to speed up my spatial search in SQL Server?

I have a database with about 1 million places (coordinates) placed out on the Earth. My web site has a map (Google Maps) that lets users find those places by zooming in on the map.[详细]

2023-04-01 15:28 分类：问答
Spatial vs. Temporal locality

I understand the definitions of the terms, but I am having trouble applying their concepts to code. For an exercise, we are asked to describe if the following code is spatial or temporal:[详细]

2023-04-01 13:00 分类：问答
What's wrong with my spatial instance?

I am trying to create a geography polygon (a simple box) for SQL Server 2008 spatial types: select geography::STPolyFromText(\'POLYGON((18.123632669448853 59.299458646827844,[详细]

2023-04-01 00:58 分类：问答