[mapserver-users] Does Mapserver utilise Spatialite spatial index correctly?

Jeff McKenna jmckenna at gatewaygeomatics.com
Mon Feb 13 08:26:10 EST 2012

Quite an interesting discussion!  Thanks guys.


On 12-02-11 5:44 PM, Even Rouault wrote:
> Jukka,
> I've continued playing with your OSM data.
> I've got extra performance by adding attribute indexes, so that every field you
> use in a WHERE clause is indexed. For example for the roadsclose, railways and
> landuse layers, you could create the following indexes:
> CREATE INDEX idx_osm_line_railway ON osm_line(railway)
> CREATE INDEX idx_osm_line_highway ON osm_line(highway)
> CREATE INDEX idx_osm_polygon_landuse ON osm_polygon(landuse)
> CREATE INDEX idx_osm_polygon_leisure ON osm_polygon(leisure)
> CREATE INDEX idx_osm_polygon_amenity ON osm_polygon(amenity)
> CREATE INDEX idx_osm_polygon_aeroway ON osm_polygon(aeroway)
> CREATE INDEX idx_osm_polygon_natural ON osm_polygon(natural)
> CREATE INDEX idx_osm_polygon_highway ON osm_polygon(highway)
> CREATE INDEX idx_osm_polygon_waterway ON osm_polygon(waterway)

Jeff McKenna
MapServer Consulting and Training Services

More information about the mapserver-users mailing list