Question : I am considering whether I should add columns to my existing tables or use a new table. The […]
Tag: spatial
Optimising latitude and longitude selection query
Question : I have table as follows the schema below. CREATE TABLE `gdata` ( `alarmTypeID` tinyint(4) NOT NULL DEFAULT ‘0’, […]
How can I store latitude and longitude without PostGIS?
Question : I know there are similar questions on here that have been answered but unfortunately none of them work […]
Geo localized database RTREE
Question : I’m using MYSQL V5.6.24 GPL I have a database with 200K rows and growing and I’m trying to […]
How to verify that at least one point fall into a polygon with Postgis?
Question : I have two tables where table A has a geometry (4326) column that contains surfaces (~20M). A second […]
Find the closest bar, when searching for a drink
Question : Problem: Find the closest bar that serves the drink(s) I’m looking for. Here you can find the generated […]
How to create a custom map report
Question : not sure if this is the right forum. But just wondering is there a way one can make […]
Improving the performance of STIntersects
Question : Table T_PIN has 300,000 pins and T_POLYGON has 36,000 polygons. T_PIN has this index: CREATE SPATIAL INDEX [T_PIN_COORD] […]
Is it possible to update all spatial index extents in one query?
Question : I work for a county government and probably 95% of the data in the GIS database (running on […]
Do mongodb’s 2dsphere index works on multidimensional coordinantes array?
Question : if i create a index like that : db.createCollection(“users”) db.users.ensureIndex({coordinates:”2dsphere”}); and then insert a point var point = […]