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)

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. ...
7
votes
3answers
3k views

Poor Performance when using Spatial Indexes in MySQL

Re-post of a question asked on Stack Overflow when it was suggested this would be a better forum. I'm trying a little experiment at pushing a data set which is not geo-spatial but fits it quite well ...
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
1answer
367 views

Is it possible to define a No SQL model for spatial data? [duplicate]

Possible Duplicate: Is there any way I can use a Key-Value store for geospatial data? I read somewhere about No SQL being a solution for large databases management, the kind that google ...
6
votes
2answers
192 views

How to decide what type of GIS to use for my study project?

I'm a student and currently taking a self directed project course. In our assignment, we were given a bunch of shapefiles and the goal is to make a tool, which would display all the data based on ...
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. ...
6
votes
4answers
3k views

List of language codes by country

Does anyone know of a list of countries with their associated official language codes? I haven't found anything by Googling yet. What I'm looking for is something like this: Country name/code ...
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 ...
6
votes
5answers
1k views

What are convenient uml tools to create geodatabase models?

I used to model databases with Microsoft Office Visio, then export the model to xml and import geodatabase schema to GDB with ArcGIS tools. Since Microsoft no longer support Visio export to xml, what ...
6
votes
1answer
938 views

Why can't I access a table in a personal geodatabase (.mdb) with arcpy after installing 64-bit geoprocessing?

I wrote and ran a simple script last year - it cycled through some line features, buffered them and then intersected with some other lines - it all worked fine. I'm now trying to tweak the file to ...
6
votes
3answers
805 views

Insert points into SQL Server?

I am collecting X and Y values from a web service (Twitter) via a python script. In the long run, this will run over a period of months and I intend on stopping at around the 6 million point mark. ...
6
votes
1answer
196 views

Standard for storing human metadata in spatial databases

Is there an existing, standard, universal approach (and hopefully existing tools that support managing it) for storing geospatial metadata in non-ESRI spatial databases alongside (and therefore able ...
6
votes
1answer
360 views

Metadata server and spatial server - a must? [closed]

I have been using ArcMap (only) for the past two years (read: newbie) in the oil and gas (upstream) industry. I currently have about 200 GB of files (shp, tif, grids, a few fgdb, all sitting in a ...
5
votes
2answers
2k views

What are spatial and attribute indexes?

What is the difference between a spatial index and an attribute index. What are their purposes?
5
votes
4answers
664 views

Given long, lat, x and y, how do I find the projection?

I am using an app called farsite that outputs shapefiles that show how forest fires will grow. I am getting output in coordinates as X and Y values rather than (lon,lat) and am looking for a ...
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: ...
5
votes
1answer
743 views

Creating a table containing all filenames (and possibly metadata) in a File Geodatabase

I need to create a metadata-table for all files in a File Geodatabase or Spatial Database. It would be awesome if it were possible to automatically be updated with new filenames, and possibly even ...
5
votes
2answers
519 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 ...
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 ...
5
votes
2answers
2k views

How to clip/export multiple selected vector layers in a map to extent of another raster/vector layer in ArcGIS?

Is there a way to clip/export selected vector layers (more than one) in a map to the extent of another raster/vector layer at a time?? in Arcgis or any other software. I am using Arcgis10. I am ...
5
votes
1answer
123 views

How to build query expression to display text from one-to-many relationship in ArcMap?

I have two tables in an enterprise geodatabase stored in PostgreSQL and accessed via ArcSDE: parcel and person 1 or + parcel can have 1 or + person (relationship is pll_person) I can display all ...
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 ...
5
votes
1answer
158 views

File Browsing Dialog for Tables in Spatial Databases

I am looking for a file browsing object that allows a user to navigate into the different types of geodatabases. For example, the ability to navigate into a Spatialite/PostGIS/ESRI File ...
5
votes
1answer
143 views

Grid Analysis from samples data

I'm trying to analyze set of samples into vector grids in order to generate average data in corresponding grid.I'm working with 50m separated grids but the size of grid may change over time.That's why ...
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 ...
5
votes
1answer
763 views

How to create adjacency matrix of topology graph of arc map for shortest path?

I have created a topology graph of a polygon feature and I want to find the individual FIDS of the lines of the polygon. I want to construct an adjacency matrix to create the shortest path. How can I ...
4
votes
4answers
450 views

How to test whether two countries are adjacent?

I have an interesting question: Is there a dataset by which I can use to test whether two countries are adjacent? For example, if inputs are Mexico and U.S., they are adjacent; if inputs are England ...
4
votes
2answers
236 views

Which Geodatabase supports SQL and is easily portable?

I want to choose the geodatabase type, which could be: permits direct sql queries. easily portable, because the app would installed in one computer. I know that the personal geodatabase is a good ...
4
votes
1answer
278 views

SQL Server data modelling + spatial data = what book?

What recommended book can you provide about data modelling for geographical spatial data (geometry) in SQL server?
4
votes
1answer
77 views

Extract points from regular data.frame with coordinates based on SpatialPolygonsDataFrame in R

I have a regular data.frame called datos.merged class(datosmerged) [1] "data.frame" The last two columns are the corresponding geographical coordinates datosmerged[1,c(23,24)] XCOORD ...
4
votes
1answer
155 views

Change the Default geodatabase in ArcGIS 10?

In a multi-user environment I have a need to be able to configure ArcGIS so that it uses an SDE connection as the default geodatabase instead of the Default.gdb in each users' profile. What is the ...
4
votes
2answers
295 views

PostGIS stored procedures

I am wondering if there are open source applications that make extensive uses of the special functions (the ST_* stored procedures) provided by PostGIS? I found many apps that support storing map data ...
4
votes
3answers
1k views

Delete a feature data set in SDE 10 programmatically

Is there a way to delete a feature data set and all of its feature classes programmatically either by using custom code or pre-existing command line tools? There is a tool provided by SDE called ...
4
votes
2answers
732 views

How to determine lock on file geodatabase?

I'm trying to delete a file geodatabase through Windows Explorer but I get the error message: The action can't be completed because the folder or file in it is open in another program. Close the ...
4
votes
2answers
770 views

Is there a performance hit from using a Feature Dataset?

I vaguely remember being taught not to use a Feature Dataset to make things "look neat" in the database, and that the Feature Dataset should only be used when there was some sort of spatial ...
4
votes
3answers
1k views

Global solar radiation data

I need a solar radiation data in central Asia. Is there any global dataset of solar radiation. If someone know about it, please send to me the link. thanks a lot
4
votes
1answer
177 views

Geometry Operands - BBOX vs Within - What's the difference?

What is the difference between the "BBOX" and "Within" spatial operators. Can anyone please shed some light?
4
votes
1answer
87 views

Distributed versioning of geospatial data

I'm getting started on the design of a new system that would reconcile, merge, and synchronize changes made across numerous geospatial databases of common ancestry, on an ongoing basis. These ...
4
votes
1answer
79 views

Homogeneous vs Heterogeneous schema in Postgis

Introduction I'm working on creating a spatial database in Postgis, to be viewed and edited trough QGIS to help managing some farmland areas. One of my goals is the have a centralized place where ...
4
votes
1answer
306 views

How to Reduce Decimal Precision of Image Value in ArcGIS?

I'd like to ask about the value on following image. This is an interpolated precipitation layer using IDW method in Arcgis. On this layer, the values is like this: This is a raster image. After ...
4
votes
1answer
246 views

Is it possible to run an arcpy execute SQL method without connecting to any database or server?

I want to simply process a layer by writing a tool script in a toolbox without having to connect any database, so I think I may have to set up a workspace environment in ArcMap, but I'm not sure if I ...
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 ...
4
votes
1answer
1k views

ArcSDE - Registering table with Geography spatial column fails with error -138 (SQL Server 2008)

I have a table of point features I am trying to register with ArcSDE (9.3.1 on SQL Server 2008) using the following command: sdelayer -o register -l ThirdPartyWellsSurface,Shape -e np -C OBJECTID,SDE ...
4
votes
0answers
145 views

Weather conditions forecasting / interpolation

I'm trying to carry out weather conditions interpolations. I have information of 92 weather stations for 800,000 km2. As you can imagine the extension of land is huge and I need some kind or weather ...
3
votes
3answers
2k views

Writing a plugin for Qgis using python to access PostGIS and write geometries

Sorry about the strange title didn't really know how to word it. I currently use MapInfo to do most of my GIS work however I have recently installed PostGIS 1.5 and am really liking it so far. A ...
3
votes
1answer
147 views

Does NASA DEM contain objects?

Following an answer to my previous question I am planning to work with NASA ASTER GDEM global dataset. I am trying to download it according to instructions given here for a couple of days now. ...
3
votes
3answers
3k views

STDistance Unit in SQL Server 2008

I've got a SPROC in SQL Server 2008 where I'm trying to calculate the distance between a point and a polygon, and I'm getting unexpected results. I am passing a parameter (@Radius) in miles to the ...
3
votes
2answers
162 views

epsilon in spatial data

What is epsilon and why do we need it in GIS operations?
3
votes
3answers
1k views

In a ESRI file geodatabase schema lock, what does the number after the username stand for?

I'm using the ISchemaLock interface to return schemalock info on featureclasses in a file geodatabase: // If schemalock count is >=2, then we have a problem, something else has a lock on the FC ...
3
votes
3answers
697 views

Spatial Database Design (PostGIS) - Point data that doesn't always have spatial data

I am creating a spatial database using PostGIS. I am storing the attributes and location of some species records that can be represented as points. The records are recorded from either: a) static ...