I am trying to create a website where users enter posts with city, state / province, and country fields. The Location and Address modules, which work with CCK, do not have drop downs on all of these fields. I dont want users entering multiple similar values for the same city such as houston and Houston. I want the city, state and country to all be dropdowns or at least auto completes.
In addition, I need a block that lists all of the cities so that people can browse listings by the city. I would prefer for the country, city and states to be a taxonomy so that I can have a taxonomy block that lists all of the available cities. I would like to have a block for u.s. cities, europe cities, etc.
I am really looking for someone who know how to do this specifically and is not guessing or just saying check out this module or modules. I have looked at several modules and have not been able to figure out how to do this. I have also spent hours searching this site trying to find the answer. There are several similar questions that never really get answered. Most of the questions are very old and the solutions proposed are not relevant to Drupal 6. Modules like Place, Address Field for CCK, or Taxonomy Location are not available for Drupal 6.
I want functionality similar to a dating site or craiglist.com for example.
I am not looking to code a new module and I am looking for insights from people that have done something similar using existing modules and Drupal functionality.
Sort of frustrated, I thought that since Drupal is used for a lot of social sites and applications, that location entry and browing would be simple to do. Can anyone please provide specific help?
Comments
_
The problem is this data can get very large very quick. I did this to the united states city level with a single hierarchical taxonomy and the hierarchical_select module. I also used the taxonomy_csv module to import the taxonomy from an existing spreadsheet.
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.
_
As requested via email, here's where I got this info: http://www.maxmind.com/app/worldcities
They're huge files so you'll have to import the data in chunks.
There's also other sources-- both paid and free, googling a bit should locate them.
EDIT: one of the better ones is http://www.geonames.org.
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.