# Specifying location

**URL:** <https://www.ruby-forum.com/t/specifying-location/107899>\
**Category:** Rails\
**Created:** [June 27, 2007, 7:49am UTC](https://www.ruby-forum.com/t/specifying-location/107899 "2007-06-27T07:49:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tyche](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/3da27b/32.png) [@Tyche](https://www.ruby-forum.com/u/Tyche)\
**Post date:** [June 27, 2007, 7:49am UTC](https://www.ruby-forum.com/t/specifying-location/107899/1 "2007-06-27T07:49:19Z")

</div>

Hi,  
I want the visitor of my website to specify her address. Most of the  
fields are text fileds while for country, state and city I want to  
provide a drop down menu.  
I can choose to define 3 tables like this:

1. Country\_mstr – having country code and country name
2. state\_mstr – having country code, state code and state name
3. city\_mstr – having country code, state code, city code and city  
name

It could turn out to be a tideous job to find such geographical  
information and populate in the tables. Could anybody suggest me any  
plugin if it exists?

Thanks,  
Tyche