ALTER TABLE :table ALTER COLUMN decimallatitude SET NOT NULL;
ALTER TABLE :table ALTER COLUMN decimallongitude SET NOT NULL;

CREATE INDEX ON :table (decimallatitude, decimallongitude);