[gdal-dev] Recommended OGR Driver For Very Large Vector Data

[Jeff McKenna]

Hi Patrick,

In terms of speed and MapServer, considering you have large vector data 
and require good indexing, I always use and recommend PostGIS.

(of course if you asked this on the MapServer-users list you would get a 
whole lot of different opinions)

But that is my initial recommendation, for your stated needs.

-jeff



-- 
Jeff McKenna
MapServer Consulting and Training Services
https://gatewaygeomatics.com/



On 2018-08-03 3:45 PM, Patrick Young wrote:
> Hi all,
> 
> I've been trying to figure out a good format to store some very large 
> vector data in.  Basically, its a bunch of really dense polygons 
> describing the cutlines that compose a mosaic.  We've had reasonable 
> success using zipped shapefiles, but on the larger guys we're exceeding 
> the 2GB file size, so a more modern alternative is desired.
> 
> FileGBD worked alright but having to build GDAL with the ESRI driver to 
> write them is not desirable.  We also tried a GeoPackage, but it seemed 
> a little slow to read in QGIS.
> 
> The dream would be a nicely compressed format that can be spatially 
> indexed so that we can serve them up efficiently with mapserver.  Any 
> recommendations are greatly appreciated!
> 
> Thanks,
> Patrick
> 
>