A spatial data infrastructure (SDI) is a data infrastructure implementing a framework of geographic data, metadata, users and tools that are interactively connected in order to use spatial data in an efficient and flexible way.
1
vote
1answer
158 views
postgis problem with shortest distance calculation
while working with POSTGIS pgrouting, for calculateing the distance between two roads(lines) i got the shortest_path function.
But the logic is based on Start_point(Start_id) and end_point(end_id) ...
1
vote
0answers
45 views
Combine Oracle locator instance with Oracle spatial instance with db link
we plan to have two oracle databases, one with oracle spatial installed, the other one just has the locator option.
Is it possible to create an oracle database link between the two databases in order ...
1
vote
0answers
87 views
Why do we need myisam spatial extension anyway?
If just to determine whether a point is within a rectangle,
What is wrong with this query?
EXPLAIN SELECT DISTINCT
TB.ID,
TB.Latitude,
TB.Longitude
FROM
TableBusiness AS TB
WHERE
...
1
vote
0answers
33 views
sdo_tune.quality_degradation returning negative values
While running the sdo_tune.quality_degradation function on one of our Oracle databases most of the results were around 1 but a number had values like -556127.225.
Does this mean that these indexes ...
1
vote
0answers
132 views
PostGIS: Remove stale/obsolete geometry columns from the geometry_columns table
I understand that the function Populate_Geometry_Columns() inserts records in the geometry_columns table for geometry columns that are not yet listed there. However, an invocation of ...
0
votes
0answers
62 views
How can we combine $within and $nearSphere in mongodb
Say I am looking for the nearest location that contain the word seaworld.
I don't want mongodb to "scan" an area too wide.
So I want to limit it
I send
db.tablebusiness.find({ "LongitudeLatitude" ...
0
votes
0answers
140 views
Nearest neighbor search for 1.6 million points in myisam mysql
Say I want to find 20 closest business near me. Latter I want to see the next 20 closest, etc. Yes I have myisam. I have spatial indexes on the point. I am looking for actual command.
Note:
I am ...
