3 ms·

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,

• jandrewrogers 13y ago
  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.