# Working with regional data... region, city?

**URL:** <https://forum.kirupa.com/t/working-with-regional-data-region-city/270105>\
**Category:** programming\
**Created:** [September 5, 2008, 6:36am UTC](https://forum.kirupa.com/t/working-with-regional-data-region-city/270105 "2008-09-05T06:36:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![grandpaw\_broon](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/grandpaw_broon/32/3985_2.png) [@grandpaw\_broon](https://forum.kirupa.com/u/grandpaw_broon)\
**Post date:** [September 5, 2008, 6:36am UTC](https://forum.kirupa.com/t/working-with-regional-data-region-city/270105/1 "2008-09-05T06:36:59Z")

</div>

Hi there,

On job websites, property websites and pretty much any form containing a regional database, how does one work with these data sets?

Say for example, if a user creates a record and spells London “ldon” in error… this wont be good for the database as people will search for “london” most likely.

I know websites use some kind of a drop down list of firstly country, then region, then cities in that region? Well what service does this use? I dont really believe that someone sits down and adds all regions, cities and postcodes into a custom database but i dont know what to google for to find out how to do this.

Ideally i want to suggest in a tooltip as the user types, they type “Dun” and itll suggest Dunfermline, Dunfries, Duneld… so on.

Does anyone have a clue what i am talking about?

Thanks 😃