Stratigraphic names and intervals API results doubled

[davenquinn]

This can be traced to duplicate results in this API call.

[davenquinn]

@amyfromandi we should get this one solved since it has user-facing effects

[amyfromandi]

@amyfromandi we should get this one solved since it has user-facing effects

@davenquinn I found that the macrostrat.autocomplete table has many duplicate rows that came over to PostgreSQL after we migrated the MariaDb data over. The name, type and category columns are duplicated. Our goal is to delete all of the duplicate rows in PostgreSQL and add this new code to our post migration scripts.

Example of duplicate data in macrostrat.autocomplete:

name,type,category,duplicate_count
Column B,columns,column,12
Column A,columns,column,11
Column C,columns,column,9
"",groups,group,9
"Site 504, Hole B",columns,column,7
V19,columns,column,5
Column D,columns,column,5
Column E,columns,column,4
Yard Coal (Bashkirian),strat_name_concepts,strat_name,3
Thompson,strat_name_concepts,strat_name,3
Rockland (Middle Ordovician),strat_name_concepts,strat_name,3
Main Coal (Serpukhovian),strat_name_concepts,strat_name,3