Spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons.

learn more… | top users | synonyms (1)

1
vote
2answers
62 views

2 Similar Queries Run at Vastly Different Speed in a Very Surprising Way

I have to be very careful here. Both queries are so similar that the only different is the area searched. What's surprising is the query that run on BIGGER AREA, and naturally yield MORE ROWS, is the ...
2
votes
1answer
494 views

How to speed up this simple MySQL points in the box query

MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200. That way innodb doesn't have to compute ...
3
votes
3answers
415 views

Do you know of any project that stores features in a NoSQL database like Cassandra?

I'm a Master's student and software developer and I want to make a new contrib development based on NoSQL databases like Cassandra. Does anyone know any people, University or Research Group who works ...
3
votes
2answers
142 views

Is there any site which provide classified image download for soil,vegetation or water resources?

(its particularly for indian states,i need.....,but kindly quote if any other info you have) the raster data may also work for me in above aspects.
5
votes
1answer
130 views

Looking for open-source solution to show map with massive objects(3x3 polygon) on a web site

I don't have much experiance in GIS systems. I am developing a web site which need to show a map with 3m x 3m rectangles for a radius of about 400 meters.(about 58,000 polygons for one location) I ...
0
votes
0answers
245 views

MySQL SQL command to find points within a rectangle with spatial extension and index [duplicate]

Possible Duplicate: how to find 20 closest points efficiently How to find points, sort them based on closeness, and get 1-20, 21-40, etc. Efficiently using Myisam and mysql Actually I ...
1
vote
1answer
102 views

Algorithm to find distance of an uneven polygonal road

While working for my summer internship I have got a task to implement an algorithm to find the crosssecting points of two roads or more and then place that cross-section point a number and then find ...
7
votes
3answers
2k views

how to find 20 closest points efficiently

Say I want to find 20 closest business near me. My table structure is like this: BusinessID varchar(250) utf8_unicode_ci No None Browse distinct values Change Drop ...
3
votes
1answer
134 views

cannot check in related tables in arcpad 10

I'm using ArcPad Data Manager (ArcMap 10) to check in data in axf file. I can check in feature layers, but I can't check in related tables and the feature class parent of the related tables. I have ...
22
votes
7answers
708 views

GIS Software Choice for a small university research centre

I need to choose a GIS system for a small university research centre. We are handling a broad range of data, (for example, numerical tidal analyses, weather data, poverty, isolated economic activity, ...
4
votes
2answers
237 views

Calculating the space a feature class will use in ArcSDE?

Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
7
votes
3answers
3k views

How to export multiple featureclasses to shapefiles?

I have plenty features in a geodatabase. I need to save/export them into shapefiles, because my mate works with Manifold, which is not able to read geodatabases. Any Ideas? Click on every single layer ...
7
votes
2answers
3k views

QGIS supported databases?

Does anyone know if there is some kind of documentation on which database types that you can connect to in QGIS? I would also like to know if: Can I use the databes for read only or read & write. ...
5
votes
1answer
3k views

How to create a table from existing tables (applying new schemas) in postgis DB?

I have a table that is geospatially enabled; that contain world borders. I want to break it down to different schemas (global, europe etc..) . My thought is to use use something that looks like this: ...
11
votes
2answers
17k views

How to insert a point into postgis?

I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query? CREATE TABLE app ( p_id INTEGER PRIMARY KEY ); SELECT ...
1
vote
2answers
823 views

DatabaseError: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAHY type

I am using Django 1.3, PostGIS 2.0 , Postgresql 9.0 and GeoDjango. I had a database with a table for places. This table had latitude and longitude for places in the US. I enabled this database with ...
2
votes
0answers
64 views

ArcSDE Feature View in a GeoDatabase other than the Feature's Database

here is the problem I have been struggling with: We have our spatial features in an SDE enabled DB (call it DB1) and have a client DB which is SDE enabled as well (meaning geo-DB call it DB2) and ...
1
vote
2answers
289 views

Spatial query in PostgreSQL to find a route to a specific point?

I drew 2 shapefiles - point.shp and line.shp. Line.shp has some lines intersecting points in point.shp. I converted the shapefile to PostgreSQL, but how can I make a spatial query to select a line ...
2
votes
1answer
322 views

Can a spatial View in ArcSDE be viewed in ArcCatalog?

Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table? I have a feature class table and an attribute table ...
-1
votes
2answers
109 views

How to extract small portion of GIS database from entire database

Is it possible to extract a small portion of data from an entire database? If possible then how can I do it. I want data to be extracted which is within my map view only, so that other data objects ...
0
votes
2answers
82 views

Can we use FME translator for upgrading lower version GIS database into higher version GIS database

I want to upgrdae our lower version GIS database into higher version GIS database.Is it possible to do so and suggest methods to do so.I am thinking of using FME.Is it possible to use FME or any other ...
3
votes
2answers
1k views

How to design a database for continents, countries, regions, cities and POIs?

I'm brand new to GIS programming and I am designing a GIS application. Target is to create system with continents, countries, regions (including states, sub-regions, provinces), cities and places in ...
1
vote
0answers
219 views

Manifold 'Link drawing to query' - can I do this in QGIS?

Manifold GIS allows the creation of dynamic drawings linked to queries. Unfortunately I do not have access to Manifold as my employer refuses to pay for it, so am currently investigating ...
1
vote
1answer
226 views

How to get route plan with certain distance with pgRouting?

I am working for a project. I have a road network which has been imported in PostgreSQL/PostGIS database. I can query shortest path between two points. I want to get route plan with certain distance. ...
1
vote
2answers
132 views

How to fix “Error, query must return columns 'id', 'source', 'target' and 'cost'”?

I have one spatial table with gid, FNODE_, TNODE_ and LENGTH column in my Postgresql/PostGIS database. I am using pgRouting. Problem is, when i try with shortest path query it shows following error. ...
6
votes
3answers
432 views

Suggestions for an efficient way to store raster files for lab use?

I'm trying to create a repository for our raster files from various sources and Im exploring the possibilities on how to store them and deliver them in our local intranet. I have come across rasdaman ...
0
votes
0answers
120 views

Is there any geodatabase schema & data migration library for .Net exist?

I'm performing code refactoring and database normalization in my project and looking for any .Net library for geodatabase schema & data migrations. Is there any solution exist for ArcObjects?
0
votes
0answers
56 views

How to calculate sums for all fields in a table? [duplicate]

Possible Duplicate: are there any methods can choose all field and make the SUM for each fields or I must do it one by one? Are there any methods that can calculate the summary statistic ...
0
votes
1answer
128 views

geodatabase and relationship

I have two tables in a personal geodatabase and one of them has 13 records and 6 fields, the other has 118 records and 125 fields. There is a relationship class between the two tables where the first ...
7
votes
3answers
2k views

How to export shape file to SpatiaLite

I have a shapefile with one layer. I can open it with QGis. Now I want to convert this shapefile or layer to Spatialite database. How can I do it? Is it possible to do with QGis?
1
vote
2answers
270 views

Is there a way to copy/paste data & limit the attribution to match the attribution in the Target Data Set?

In an effort to avoid digitizing, I want to copy specific watercbodies from a provincial database (shapefile format) and paste it to my taget layer, which are waterbodies significant to my project. I ...
5
votes
1answer
885 views

Reset Object ID After Truncating Table In SQL Server

I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
0
votes
0answers
90 views

How to pass in a database created on the fly in code to Quick_Export in arcpy?

So I am trying to programmatically use quick_export through the arcpy package in an arcmap tool, and so I referenced the quick_export tool's dialog box that comes up when it is executing for the ...
2
votes
1answer
479 views

Oracle spatial - check polygon vertices counter clockwise

I need to import a huge number of polygons from a third party (as a csv file- array of x,y's). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to ...
6
votes
5answers
430 views

Comprehensive Intro to GIS Data Structures

I am looking for a comprehensive introduction to design and analysis of spatial data structures. If possible, please only link to online resources unless the offline resources is especially of note. ...
9
votes
2answers
2k views

Intersecting a raster with a polygon using PostGIS - artefact error

I'm using PostGIS2.0 to do some raster/polygon intersections. I'm having difficulty understanding which operation I should use, and what the quickest way of performing this is. My problem is as ...
1
vote
1answer
137 views

What are the areas, relating to database or server, that should be viewed while making map based webapplication?

This question is relating to GIS web application that are based on relational database. I have database that is not indexed with spatial column and I use geoserver to display these data as layers. But ...
2
votes
0answers
197 views

Does anyone know of a 'best practice' Seabed Survey Data Model (SSDM)?

Many of the offshore oil/gas companies are adopting an initiative from Shell for delivery of spatial data. This is called an SSDM, which is really an ESRI file geodatabase with a standardised ...
2
votes
0answers
116 views

Bounding box for app engine?

I'm using python 2.7 and app engine. To do bounding box we used geomodel but it executes more then 5 seconds in table with 350 records. It's to slow. Can you please suggest better solution ? Is ...
-1
votes
1answer
299 views

Can' t edit anything in Arcgis 9.3

My name is Ramona and I'm from Romania. I'm new to GIS. I want to digitize a topographic map in ArcGIS 9.3 and cannot. I tried these steps: I created a Personal geodatabase inside a raster dataset, ...
1
vote
0answers
88 views

Can we do replication and versioning in User schema geodatabases version with sde default version

As both are administrators to their own schemas, is there any possibility to post and reconcile data across schemas?
9
votes
2answers
394 views

PostGIS (2.0?) - Native Versioning of the Datastore

I recently have been surprised to see there are not too many solutions at all discussing the best methods of versioning datastores which are made available for editing. I am looking for a robust, ...
5
votes
2answers
518 views

Spatial metadata table in SQL Server 2008

I have a db and want to know if it contains any spatial tables. Is there a table in SQL Server that holds spatial metadata i.e. a list of all the spatial tables in the current db? Oracle has the ...
3
votes
2answers
144 views

LRS schema error in Oracle SDO_NET when validating network

I have a problem with the Oracle Spatial Network package. I'm creating NODE, LINK and PATH based on LRS. When I try the call: SELECT SDO_NET.VALIDATE_NETWORK('network_tracking') FROM DUAL then I ...
1
vote
1answer
716 views

What is geometry datatype?

What are the basic that one should know about geometry datatype? How is it computed ? Why do we need geometry data type? Edit: I wanted to know why there is a different datatype called geometry. Is ...
10
votes
1answer
812 views

Can you query overlapping user-defined polygons at a given point in Google Maps?

I need to find out the limitation of working with the Google Maps API, and the possible solutions for doing semi-complex spatial comparisons. What I'm looking to achieve is a system of comparison ...
3
votes
1answer
236 views

How to calculate the number of buildings along the left/right side of a street?

I'm struggling to find a way to get the line direction stored on shape file from its geometry, is there any tool can get it for me? Also, I have two layers of map: Roads layer (of type polyline), ...
5
votes
2answers
448 views

Reduce Tracking Data Set

I'm building an application that uses data from GPS units on board vehicles and displays it on a map. A lat/long is recorded every .5 seconds and a session can be many hours... this can add up to be a ...
3
votes
2answers
658 views

How to read MapInfo .tab files in ArcPy?

I want to use arcpy (the ESRI install of python 2.65) to analyse tab files...can this be done directly or do I need to convert them to shp files...if so would it be possible to do something like ...
0
votes
1answer
236 views

Any known problems after Tomcat-upgrade using oracle locator?

After trying to upgrade from Tomcat 5.5.28 to 5.5.29 or above I ran into a strange problem. We use a linux based gis system using an Oracle EE DB (without spatial license). Problem After the upgrade ...