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)

5
votes
1answer
139 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
345 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
108 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
141 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
781 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
341 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
5k 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 ...
8
votes
2answers
4k 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. ...
8
votes
1answer
4k 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: ...
13
votes
2answers
27k 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 ...
2
votes
2answers
994 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
65 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
324 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
421 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
114 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
90 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
2k 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
244 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
255 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
171 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
586 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
129 views

Do any geodatabase schema and data migration libraries for .NET exist?

I'm performing code refactoring and database normalization in my project and looking for any .NET library for geodatabase schema and data migrations. Does any solution exist for ArcObjects? During ...
0
votes
0answers
61 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 ...
1
vote
1answer
153 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 ...
10
votes
4answers
4k 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
325 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
1k 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
95 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
616 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
490 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. ...
10
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
141 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
1answer
239 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
127 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
345 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
89 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
3answers
434 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
611 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
161 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
960 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
976 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
246 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
535 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
795 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
270 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 ...
20
votes
3answers
2k views

When should you NOT use a spatial index?

I am asking this because I was mainly working with Oracle but for the past year I've been doubling with PostGIS and SQLServer 2008. Most spatial functions in Oracle won't work without a spatial index ...
3
votes
2answers
860 views

How do I only view selected rasters from a geodatabase raster catalog in ArcGIS 10.0

I am using a geodatabase raster catalog to hold raster files for multiple countries, mostly for the sake of organization. I don't actually have the need (often) to visualize or draw these all at once. ...
8
votes
4answers
1k views

Fastest spatial storage format?

I am wondering what storage method will result in the fastest reading of the map vectors for rendering. SHP? PostGres? SQLite? (They do not change often and I do not need spatial functions for these ...
12
votes
3answers
1k views

Future of spatial databases

It may be a bit off-topic. I am eager to know the industry specific importance of Spatial Databases. Is Spatial Database a very important part of any GIS system? Or will we use other technologies to ...