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)

18
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
710 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
928 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 ...
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
2
votes
1answer
581 views

Convert SqlGeometry data from SQL directly to Tiles / PNG file

I would like to know a basic method for 'exporting' SqlGeometry data from SQL Server 2008 to a Tile Server / PNG File generator. I already have a Silverlight Map application which uses a Custom Tile ...
12
votes
2answers
1k views

Mixing geometry types in one PostGIS table

I've faced with the following problem. I have to migrate from Oracle database to PostgreSQL+PostGIS. Currently all geometries of all types are stored in one table and each record contains "lid" field ...
2
votes
1answer
305 views

MapGuide with RDBMS database design guidelines

I'm brand new to GIS programming and I am designing a GIS application and I think I want to use MapGuide because of its user selection features (Digitizing and Redlining - or can I do this easily with ...
18
votes
7answers
1k views

Spatial databases learning resources for newbies

Would be taking up a course on spatial databases next semester. Would anybody know a newbie friendly introductory resource? A vendor neutral one would be preferable. Thanks.
3
votes
2answers
2k views

ArcGIS 10 - How can you open geodatabase files using a Browse Dialog Command (VB.NET/C#)?

I am currently using the following method to open raster files from a form: Public Function BrowseRaster(ByVal sTitle As String, ByRef sFolder As String, ByRef sName As String) As Boolean Dim ...
18
votes
3answers
4k views

How to store lines and polygons in JSON documents?

Looking at the increasing NoSQL movement and considering that databases like MongoDB offers a new perspective in flexible data storage for GIS. What is the best way to store lines and polygons in ...
21
votes
6answers
606 views

Open access repository of general GIS spatial data?

As a newcomer to using GIS for research, I am wondering if there are online repositories for spatial data, similar to package repositories for Linux distributions. For instance, I would be able to ...
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?
3
votes
3answers
596 views

Looking for a Java library for tracking positions, and querying regions

I have a deceptively simple requirement to create a software component to record and update some mobile position information, then be able to perform simple queries concerning mobiles in a particular ...
3
votes
1answer
1k views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
9
votes
3answers
2k views

Beginner PostGIS question: getting geometry from multiple tables

I am very new to PostGIS, PostgreSQL, and SQL in general. I have 44 tables in my PostGIS database, and each one represents a different layer of vector data. Each was loaded from a separate shapefile, ...
1
vote
1answer
279 views

How do I edit feature attributes, e.g. a text field with a typo

A feature class in a file geodatabase has a hand full of features where a text field is typo'd. How do I edit this to fix the typos?
3
votes
1answer
383 views

Sharding of geospatial data

Reading through Rosenberg & Mateos' The Cloud at Your Service I stumbled upon the concept of database sharding. Authors point out to several advantages of such approach including high (online) ...
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 ...
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 ...
12
votes
4answers
401 views

What is a suitable Global/Universal Unique Identifier for a PostGIS database?

I have read that using OIDs as a primary key in a postgreSQL/PostGIS db is poor practice because there are instances where these can be reset. Sounds logical, but then what is a suitable alternative? ...
1
vote
2answers
167 views

Accessing PAT,NAT of coverages using arcobjects

I want to access the polygon attribute table (PAT) and node attribute table (NAT) of an arcgis coverage using arcobjects VBA, is this possible?
12
votes
5answers
900 views

Quality of free geodata compared to commercial sources

What are the sources of excellent geo-location data as possessed by Google Maps ? I am wondering that, even with large amount of volunteer work involved, why is OSM data not comparable to theirs in ...
3
votes
4answers
973 views

Creating a multiversioned view with ArcSDE and SQL Server 2008 R2

I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2. Everything appears to be working correctly with one exception: The ...
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 ...
0
votes
0answers
182 views

how to write Topology Graph Edges geometry to polyline feature class

i have created topologygraph of a polygon feature . and iwant individual ids of polylines i want to write Topology Graph Edges geometry to new polyline feature class any samples OR documentation ...
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
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 ...
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 ...
12
votes
3answers
890 views

Centralizing shapefile data into database

I've got hundreds of shapefiles from various different GIS projects that I want to start consolidating into a single database platform, currently attempting this with Postgres / PostGIS. Hardly any ...
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 ...
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 ...
1
vote
0answers
256 views

Export topology tables to txt files using ArcObjects, generating directed graph, and finding intersections

I want to export topology tables to text files: for points: 1 id x y for lines: line id fompoint.x from point.y topoint.x topoint.y for polygons: id line id 1, line id 2... 2 arc ...
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 ...
8
votes
2answers
757 views

Future for geospatial on App Engine?

2 years ago, this question was posted here at Gillies's blog, on date of 2009-05-15. Future for geospatial on App Engine? At that time there was no news relating to any apps of GIS web services ...
8
votes
3answers
2k views

Where can I find free building height dataset for major cities around the world?

I am searching for building/property data which include building height, building area, lot size, and building type classifications(preferably as complete as possible). I am working on an Earthquake ...
3
votes
1answer
746 views

Configuring WMS from a MSSQL data source with MapGuide Open Source

I've having trouble configuring WMS out of MapGuide Open Source. Here's what I've done so far: Installed MapGuide Downloaded MapGuide Maestro Created a "feature" in Maestro that connects to ...
3
votes
2answers
162 views

epsilon in spatial data

What is epsilon and why do we need it in GIS operations?
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 ...
3
votes
2answers
250 views

What is ArcCatalog?

What is it, what does it do, and how is it related to geodatabases?
11
votes
3answers
1k views

What is a good taxonomy or naming convention for files and folders containing GIS data?

My company has collected about 30 TBs of GIS data over the past 8 years, and I always find myself asking the following questions: What type of data do we have for a given geographic area? What are ...
13
votes
6answers
1k views

Is good database design less important for a spatial database

I have a strong feeling that database design and normalisation often comes in second hand when dealing with spatial data. With software costing a fortune and databases with over 100 fields tables I ...
20
votes
4answers
2k views

Would PostGIS offer an advantage over MySQL for a produce farm application?

I have a web app that stores the locations of farms in West Michigan. You can search for a product (e.g. "broccoli") and it will show you all the farms that grow that product. Right now I'm using ...
8
votes
2answers
621 views

Find duplicate vertices in SQL Server geometry line (ArcSDE)

I have a line in a ZM polyline featureclass that has a invalid geometry. My suspicion is that the line doubles back on itself somewhere, which I've found SQL Server doesn't like. Anyone know of a ...
10
votes
7answers
952 views

assign unique id to point features

The MassGIS parcel standard (http://www.mass.gov/mgis/ParstndrdVer1_5_1.pdf) utilizes a concatenation of the whole number portion of x- and y-coordinates to create a unique id (LOC_ID) for features. ...
28
votes
2answers
1k views

What coordinate system should be used to store geography data for celestial coordinates?

I am doing an astronomy project. I want to have the information about our images stored in a spatially enabled database. This, I would think, should be a very easy special case for GIS functions ...
8
votes
4answers
2k views

Embedded spatial database for Java

Are there any embedded spatial databases for Java? I've come across H2 Spatial, but it was difficult to tell the status of that and if it can be used as an embedded spatial database. thanks, Jeff
9
votes
5answers
392 views

Another Student in Need of Career Advice

I would like to apologize in advance for asking yet another "what should I do with my life" type of question. I am currently a senior who is very close to finishing up my B.S. in Information Systems. ...
3
votes
2answers
365 views

Visualize feature class with many relationship classes?

I have a feature class in a geodatabase that I want to review. It has many relationship classes - possibly a hundred or more. If I load the feature class into ArcMap and identify one of the ...