PostGIS 2.1.0 Released

Re:PostGIS 2.1.0 Released by dagw on Sunday August 18, 2013 @12:03PM (#6233040)

PostGIS is really without alternatives

unless you're willing to send Oracle a blank check.

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by jeffdavis on Sunday August 18, 2013 @12:40PM (#6233173)

Do you find the Oracle spatial solution superior?

The FAA gave a talk a few years ago about how they moved from Oracle spatial (if I remember correctly) to Postgres/PostGIS for cost reasons, and it turned out to be significantly better all around.

Some links (couldn't find a good primary source): https://twitter.com/magnushagander/status/11107130700 http://scanningpages.wordpress.com/2010/04/11/pg-east-2010-2...

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by dagw on Sunday August 18, 2013 @04:37PM (#6234128)

I've honestly never used Oracle spatial stuff directly, and begin a huge fan of PostGIS, I've never felt the need to. However based on talking to people I've worked with, at least a few years ago, Oracle was better when dealing with huge amounts of data.

That being said, PostGIS seems far more popular among practitioners from what I've seen. And it's quite common for the first step in any new GIS project to be to copy the relevant subset of data you're interested in from the Oracle database into a PostGIS database and then use that.

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by jandrewrogers on Sunday August 18, 2013 @01:14PM (#6233326)

Oracle has some additional features and implements more of the geometry operations correctly but is not materially better than PostGIS for many applications and use cases.

Neither platform offers scalability or high throughput so they are largely differentiated on features.

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by Demiurge on Sunday August 18, 2013 @03:29PM (#6233824)

This is the first time I hear about Oracle spatial stuff being better than PostGIS. Could you give some examples of what those additional operations are?

Also, what is a platform that offers scalability or high throughput?

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by jandrewrogers on Sunday August 18, 2013 @05:02PM (#6234228)

I always recommend people use PostGIS and used it myself for many years but it was behind Oracle in significant ways even though Oracle is not that great. In recent versions of PostGIS, most users won't notice the differences. Oracle still scales marginally better.

Most importantly, Oracle has always had a better geometry engine that PostGIS, though that gap has closed significantly. It wasn't that long ago that proper geodetic models were not supported at all. And last I knew the current PostGIS does not do pure geodetic for all operations (or so I've heard from the guys who wrote the geodetic geometry engine for my company). Oracle also supports a variety of related data types, operations, and indexes that are useful.

The only platform that currently offers scalability and throughput for geospatial data models is SpaceCurve, of which I am the founder. Among other things, it supports continuous online indexing at a rate of millions of geodetic polygons per second concurrent with queries on petabyte-scale data models. The technology was originally developed for building real-time sensor-fused models of the planet, though it is much more general now.

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by nobleach on Sunday August 18, 2013 @12:42PM (#6233192)

If I were going to spend a ton of money on spatial solutions, I wouldn't give Oracle a cent. ESRI's SDE is my Spatial Database Extension of choice. It runs on top of Oracle, SQL Server, Postgres and DB2 (You know... if you're an AS/400 person)

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by dagw on Sunday August 18, 2013 @04:10PM (#6234021)

Sure, ArcSDE (or whatever it's called these days) is pretty cool, but to be honest I've never seen it deployed in the wild on anything other than Oracle, and often in conjunction with Oracle Spatial. What I've heard is that while the technically support a bunch of databases, they're pretty in bed with Oracle and that is what it works best with.

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by nobleach on Monday August 19, 2013 @09:57AM (#6237222)

Around 2007ish they pledged their loyalty to Microsoft and the Oracle users became the redheaded step children. I was at the user conference in 2008 and the few Oracle related demonstrations were poorly attended. Even my organization moved to SQL server around 2011. I left shortly before that.

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by olefoo on Sunday August 18, 2013 @01:21PM (#6233357)

Or ESRI. Oracle was rather late to the Geospatial party.

[ Parent | on HN ]

Re:PostGIS 2.1.0 Released by dagw on Sunday August 18, 2013 @04:04PM (#6233985)

ESRI makes complementing, not competing products. Most big ESRI users use Oracle in my experience.

[ Parent | on HN ]