spatial
PHP, MySQL, spatial data and design
Im building an application where vehicles coordinates are being logged by GPS. I want to implement a couple of features to start with, such as:[详细]
2023-01-05 21:01 分类:问答SQL 2008 Spatial ordering of objects
I have a dataset containing the start and end points (both OSGB36 and corresponding WGS84 coordinates) of sections of a road network.I am able to import this data in SQL and create geometry and geogra[详细]
2023-01-05 11:25 分类:问答PostgreSQL: Casting two separate numeric values to a point
I\'m trying to change the application schema of a database in Postgres...so I need to copy data from one table to another. In the original table, co-o开发者_如何学JAVArdinates are specified as numeric[详细]
2023-01-04 20:14 分类:问答can i MySQL select where row's co-ords are < x miles from target coords? (mysql proximity search)
There\'s a few questions like this on Stack Overflow but because i can\'t find any quite similar enough for me to follow.[详细]
2023-01-04 11:02 分类:问答Inverse Distance Weighted (IDW) Interpolation with Python
The Question: What is the best way to calculate inverse distance weighted (IDW) interpolation in Python, for point locations?[详细]
2023-01-04 07:42 分类:问答Spatial querying, converting metres to radians?
I have geographic data that was loaded into the geography datatype. For very specific purposes, I now need to have store this as a geometry. However, I need to perform a query like this.开发者_StackOv[详细]
2023-01-04 03:50 分类:问答org.hibernate.MappingException: No Dialect mapping for JDBC type: 2002
I\'m getting org.hibernate.MappingException: No Dialect mapping for JDBC type: 2002 when I try to do a JPA nativeQuery开发者_运维知识库 to get a geometry field type.[详细]
2023-01-04 00:32 分类:问答Unable to retrieve computed distance in Spatial Solr queries
I\'m using this plugin to allow spatial queries in Solr. I have followed the steps included in the documentation and I\'ve got the spatial queries working fine.[详细]
2023-01-03 18:04 分类:问答Importing ShapeFiles into Oracle XE
I\'m looking to import one of the S开发者_JAVA技巧hapefiles supplied with the Ordnance Survey Boundary-Line opensource set into Oracle XE.[详细]
2023-01-03 13:19 分类:问答distance between two points across land using sql server
I am looking to calculate the shortest distance between two points inside SQL Server 2008 taking into account land mass only.[详细]
2023-01-02 04:43 分类:问答