Make sure spatial index is "gist"

[agstephens]

E.g.

CREATE INDEX observations_1999_land_0_location_gist_idx ON lite.observations_1999_land_0 USING gist ( location );

Works better than btree index.

[agstephens]

Task is:

1. Find where we create the spatial index in the cdm lite code, and replace it to use this new index.

   • need to apply to main table and all partitions

2. Find where we create the spatial index for the full cdm code, and replace it.

   • need to apply to main table and all partitions

[agstephens]

They are all currently btree.

[agstephens]

Added make-indexes-sql.py and create-indexes.sql to the playbook - for CDMLite.

[agstephens]

Done for CDMLite.

[agstephens]

Done now for CDMFull.