geospatial
SQL Server Geography datatype: weird behavior
I have an application that has been running for years now with no issues. Recently I decided to add a Geography type column to one of the table开发者_如何学JAVAs, application uses. After doing so, the[详细]
2023-03-09 06:50 分类:问答Cannot insert GeomFromText('POINT(..)') in MySQL
I\'ve created a database where one of the tables stores the geolocation of some points. I\'m trying to fill that table, which a priori seems pretty easy with GeomFromText(\'POINT(39.48280 -0.34804)\')[详细]
2023-03-09 02:03 分类:问答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 分类:问答Mixing geometry types, is there a cost when I come to querying it later?
I have a mysql table with a field of the type POLYGON, containing a number of polygons, however I have discovered I also need to store POINTS.[详细]
2023-03-08 19:38 分类:问答Building a geospatial querying REST api
I am trying to build an iOS app that takes the location of the user and then queries the backend for other users near him/her through a REST api.I have done some googling and my choices (given my expe[详细]
2023-03-08 16:46 分类:问答MySQL table with 4,000,000 record?
The website I have to manage is a search engine for worker (yellow page style) I have created a database like this:[详细]
2023-03-06 14:03 分类:问答Spatial index/query (finding k nearest points)
I have +10k points (latitude, longitude) and I\'m building an app that shows you the k nearest points to a user\'s location.[详细]
2023-03-06 04:07 分类:问答SQL Server Geo-spacial Data & C# - One of these are WRONG!
So this questions has few parts to it, but hopefully someone will have enough knowledge to help. In my SQL Server Database I have 2 Location records with the following properties latitude(nL开发者_如[详细]
2023-03-05 20:45 分类:问答Find most recent & closest posts, limit 20
Let\'s say I have a bunch of 开发者_运维百科posts (for a feed, like a Twitter/Facebook/foursquare feed) in MongoDB, and each post has a location & a timestamp.[详细]
2023-03-05 18:00 分类:问答Storing LatLonType in solr : how to insert them via solrj
I am going to index a lot of document using GeoSpatial from solr3.1. I can\'t find a way t开发者_如何学Goo add document with solrj passing latitude and longitude. Querying seems to be working.[详细]
2023-03-05 05:09 分类:问答