Washington DC Naming Best Practice | Community
Skip to main content
A
Anonymous
April 13, 2016
Solved

Washington DC Naming Best Practice

  • April 13, 2016
  • 4 replies
  • 2122 views

We have some leads that are located in Washington DC and I'm struggling with how I should sort these across the City/State field. I have a handful that have "Washington D.C." as the city with the state being nulled out, but I thought it might be wise to have City = "Washington", State = "DC".

Is anyone aware of a best practice for this particular issue?

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Josh_Hill13

DC=State and City=Washington is the post office approved method.

You can do whatever you want of course.

4 replies

Casey_Grimes2
Casey_Grimes2
Level 10
April 13, 2016

Hi Mark,

As usual, "best practice" means "the practice your team is willing to do." Personally I prefer to do city as Washington, state as DC for standardization purposes (since, as you mention, there are always records that do otherwise, such as leaving a state blank, but that messes with any geosegmentation you may want to do for the United States.) I'd honestly just pick a standard that works for you and your team and set up some maintenance campaigns to ensure any incoming records meet that format.

A
Anonymous
April 13, 2016

We do what both you and Courtney had mentioned.

In your example City = Washington and State = DC

I wouldn't be leaving the State blank though.

Josh_Hill13
Josh_Hill13Accepted solution
Level 10
April 13, 2016

DC=State and City=Washington is the post office approved method.

You can do whatever you want of course.

    Dan_Stevens_
    Dan_Stevens_
    Level 10
    April 14, 2016

    We do the same.  For State, we spell out "District of Columbia"

    Terms & ConditionsAccessibility statement

    Loading footer...