search

DataUSA / datausa-tracker

0 stars 0 forks source link

place names in transport time table have duplicate state suffixes #266

Closed davelandry closed 4 years ago

davelandry commented 4 years ago

Place names are coming through as "New York, NY, NY": https://halite-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJHZW9ncmFwaHkiLCJQbGFjZSIsIlBsYWNlIl1dLCJjdXRzIjpbXSwiY3ViZSI6ImFjc195Z3RfbWVhbl90cmFuc3BvcnRhdGlvbl90aW1lX3RvX3dvcmtfMSIsIm1lYXN1cmVzIjpbIkF2ZXJhZ2UgQ29tbXV0ZSBUaW1lIl19

jspeis commented 4 years ago

@Jayrmajithia It appears these suffixes became duplicated in the shapes2017.places database tables. I believe you may have recently made some changes to this table Would you be able to de-duplicate the suffixes in the name column?

Jayrmajithia commented 4 years ago

I have fixed the issue of the duplicate state suffix in the shapes2017.places in Postgres which was affected. And also fixed the other tables having issues in their short-name in the PostgresDB. There was no effect of my update in the MonetDB database

jspeis commented 4 years ago

great work @Jayrmajithia this appears to be fixed https://iron-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJHZW9ncmFwaHkiLCJQbGFjZSIsIlBsYWNlIl1dLCJjdXRzIjpbXSwiY3ViZSI6ImFjc195Z3RfbWVhbl90cmFuc3BvcnRhdGlvbl90aW1lX3RvX3dvcmtfMSIsIm1lYXN1cmVzIjpbIkF2ZXJhZ2UgQ29tbXV0ZSBUaW1lIl19

davelandry commented 4 years ago

confirmed fixed on the front-end! (just need to clear the front-end cache before launch)