Discussion on answer by Morgan Tocker: Tweaking indexes for tables with "geographical" data

Imported from a comment discussion on http://dba.stackexchange.com/questions/151703/tweaking-indexes-for-tables-with-geographical-data/151712#151712