reset locations table with TRUNCATE RESTART IDENTITY.