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)

12
votes
4answers
649 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 ...
3
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
728 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
215 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
160 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 ...
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
850 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
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
284 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
415 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 ...
3
votes
1answer
972 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
169 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
267 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
1k 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 ...
9
votes
2answers
878 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 ...
25
votes
3answers
3k 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
430 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 ...
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 ...
7
votes
4answers
603 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
448 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 ...
10
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
3k 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
26k 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
198 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 ...
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 ...