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)

17
votes
6answers
2k 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
3k views

Opening geodatabase files using Browse Dialog Command (VB.NET/C#) of ArcObjects?

I am currently using the following method with ArcGIS 10 to open raster files from a form: Public Function BrowseRaster(ByVal sTitle As String, ByRef sFolder As String, ByRef sName As String) As ...
20
votes
3answers
7k 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 ...
4
votes
1answer
223 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
1k 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 ...
4
votes
2answers
2k 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
4k 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, ...
3
votes
1answer
694 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
2k 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
1answer
1k views

Creating adjacency matrix of topology graph of ArcMap for shortest path using ArcObjects? [closed]

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
681 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? ...
12
votes
5answers
1k 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 ...
4
votes
4answers
1k 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
731 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
219 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
1answer
161 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 Geodatabase......
13
votes
3answers
1k 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
857 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 ...
4
votes
3answers
5k 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
285 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
420 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 ...
9
votes
2answers
1k 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 ...
4
votes
1answer
990 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
173 views

epsilon in spatial data

What is epsilon and why do we need it in GIS operations?
5
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
268 views

What is ArcCatalog?

What is it, what does it do, and how is it related to geodatabases?
13
votes
3answers
2k 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 ...
15
votes
5answers
2k views

Is good database design less important for spatial databases?

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
3k 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 ...
10
votes
2answers
896 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 ...
26
votes
3answers
4k views

Organization and tidiness of multiple copies of layers? [closed]

Back in the days when I was in the university I had a "Organization and tidiness" problem – I was unorganized and kept my layers in different folders without distinct names and hence had multiple ...
10
votes
7answers
2k 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. ...
32
votes
2answers
2k 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
4k 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.
8
votes
5answers
435 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
432 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 features,...
13
votes
4answers
8k 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 ...
8
votes
4answers
604 views

MS SQL Spatial as Central Datastore?

I've been working on opening up our spatial data from a proprietry system to one that can be read by more products (MapGuide, ESRI, gvSIG, Map3D etc....) I've decided on using SQL Spatial as we have ...
7
votes
1answer
454 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 uses ...
11
votes
5answers
2k views

What tools are available for uploading gis data to a database?

I would like a nice graphical tool that allows me to take standard gis data such as shp files and kml files and upload them to a database such as PostGIS, MySql or Oracle. Are there any such tools? ...
29
votes
5answers
4k views

Does ArcGIS for Desktop support SpatiaLite?

SpatiaLite is playing an increasing role in my organization. As it stood in 2012, using SpatiaLite alongside ArcGIS Desktop required an amount of importing and exporting of data that was not always ...
0
votes
2answers
193 views

APDM - error exporting database from Oracle

I have a fairly large database on a slow network and I am using a third party tool to update data which calculates other fields and so on. I have a guid string with an empty box (weird glyph - seen ...
16
votes
6answers
27k views

Is a Country/State/City Database available?

I asked this question Stack Overflow but I was informed that I would get a better to this question here because it's not related to programming. I am creating a directory which uses locations to ...
2
votes
1answer
199 views

Why does SQL job choke on stored package?

I've written a stored package to pull a text file into a table in the geodatabase. It works perfectly. However, when it is a step in a SQL job, the job fails at that step. I'm looking for ideas on ...
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 ...
6
votes
3answers
2k 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 ...
21
votes
3answers
8k views

What is difference between ArcSDE and spatially enabled databases?

When would you want to use ArcSDE (available as ArcGIS Server Basic license level) versus a spatially enabled database? What are the trade-offs on either side? What are the benefits on either side?...
19
votes
3answers
2k views

What are the differences between spatial databases? [closed]

What is the difference between Oracle Spatial, PostGIS, SQLServer2008, SpatiaLite, and MySQL in terms of their spatial support. Are there specific use cases where each shines. What might you want to ...
21
votes
9answers
13k views

Choosing database for storing spatial data?

A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...