Why do I have duplicate street names in the database?

Table of Contents

Article - fact

3
Article - opinion

0
Article - references

11
Charts

4
Configuration

32
Data

42
Data entry

9
Diagrams

22
Errors / crashes

35
Filters / queries

8
Importing

22
Installation and setup

40
Mapping

1
Networking

14
Printing

10
Related software

1
Reports

12

CreatedJune 9, 1999

Last UpdatedJuly 6, 2020

byadmin

Issue

It would appear that there are two streets with the same name causing reports to list a street twice.

Explanation

The streets file cannot have duplicates. It is more likely that one street is mis-spelled with one or more leading or trailing spaces (see also IMW0005).

Solution

Navigate to ‘reportslistingsstreets in database’, you will get a listing of streets (be sure to click on the FOR CHANGES radio button). You will need to find the two streets that look identical, and change the bad street to match exactly the good street (WITHOUT trailing or leading spaces). Answer OK to overwrite the file and then nav to ‘utilitiesdatabasechange streets’. Answer affirmatively to all prompts and you should get a message to the effect that 1 street has been removed and one added.

Tags:

Was this article helpful?

0 out Of 5 Stars

5 Stars		0%
4 Stars		0%
3 Stars		0%
2 Stars		0%
1 Stars		0%

Issue

Explanation

Solution

0 out Of 5 Stars

How can we improve this article?