21
votes

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 old file based approach but it got me thinking what other options are out there and what are the pros and cons with them.

A con I would have to say with spatialware is the fact that it is 5000ドル p/a and only MapInfo can read the objects from it. Which at the moment is fine because MapInfo is all we use.

I'm wondering what other people have gone with and what their experiences are.

PolyGeo ♦
65.5k29 gold badges115 silver badges350 bronze badges
asked Jul 22, 2010 at 22:15
0

9 Answers 9

29
votes

PostGIS based on PostgreSQL is a popular database for GIS.

I haven't used it much myself, but a pro is that it's open source and that many other GIS uses it so it have an active GIS community.

answered Jul 22, 2010 at 22:24
4
  • I find with PostGIS / pgrouting, there is a bit of a steep learning curve, but once you get over it, it's really quiet excellent and gerat Commented Jul 22, 2010 at 23:18
  • 2
    PostGIS is actually the most mature spatial implementation (comparing sql server 2008, oracle spatial, db 2 spatial blade (or whatever name it is), mysql spatial, etc.) Routing, Geocoding, Spatial logging, raster support. for free! Commented Jul 23, 2010 at 0:29
  • 1
    +1 for PostGIS. Its my central data store that works well with Arc, R and Python without a flaw so far Commented Jul 23, 2010 at 12:54
  • 1
    I've also found the learning curve steep, but postgis/postgresql is excellent. I highly recommend PostGIS in Action (postgis.us) if you do consider using it! Commented Dec 31, 2011 at 21:23
8
votes

SQL Server 2008 comes with geospatial capabilities in-built. Even the free Express Edition supports the full geospatial features, as far as I know.

Further reading:

answered Jul 22, 2010 at 22:27
3
  • 1
    SQL Server 2008 seems to work just fine but it's excruciatingly slow compared to more mature products like PostGIS and Spatialware. Commented Jul 30, 2010 at 23:36
  • 1
    any benchmarks to support that statement? Commented Jan 1, 2012 at 4:08
  • It's the best integration if you use Microsoft's technology : SQL Server 2008 / C# / VB / IIS. Commented Jan 3, 2012 at 23:23
4
votes

Although my vote would go for PostGIS as well, SpatiaLite extension for SQLite might be woth looking at as a lightweight alternative.

answered Jul 23, 2010 at 13:01
2
  • As Nathan is using MapInfo SpatialLite isn't really an option - at least not at the moment - as MapInfo doesn't support this. Commented Sep 11, 2011 at 18:41
  • From MapInfo Professional version 11.5.2 and newer versions, SQLite is also supported by MapInfo Professional Commented May 17, 2013 at 12:49
4
votes
answered Jul 23, 2010 at 13:27
4
votes

You also can use NoSQL databases to store geographic data. Scaling GIS Data in non-relational data stores is easy due to the nature of its architecture.

answered Dec 31, 2011 at 20:39
3
votes

PostGIS is certainly the best one, for most of the use cases in GIS.

If you need an advanced managment of topology, I would advice Gothic.

answered Jul 23, 2010 at 7:56
1
  • I thought Yeoman disposed of everyone that understood Gothic, or is the same name being used for new software? Commented Nov 1, 2011 at 13:24
1
vote

The most popular in the world are Postgresql-PostGIS and Oracle-Spatial (locator). Postgresql-PostGIS is the most advanced opensource Spatial DB. It is reliable, used successful in many productive systems, big community and tested on many systems. I have bad experience with Oracle-Spatial and locator. It is slower, hard to use, more complicated than PostGIS. New GIS features (implementing OGC standard) come after large time delay. The perormance of oracle is much lower than postgis.

Performance test of Oracle and PosGIS is here: http://www.gise.cse.iitb.ac.in/wiki/images/c/c4/Finalreport.pdf

neogeomat
8,3924 gold badges54 silver badges91 bronze badges
answered Dec 20, 2013 at 11:08
0
votes

Pro Postgis - bounding box which is one of the most important options for rendering big number of data. Mysql doesn't have bbox option.

answered Dec 20, 2013 at 11:50
0
votes

Here are a few real-time, big-data, geospatial databases:

answered Oct 17, 2015 at 1:43

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.