I am creating a map-based real estate search engine for the USA.
The ideal candidate will be familiar with OpenStreetMap API and should be able to extract ALL data that contain administrative and census polygon boundaries from the OpenStreetMap API.
Once data has been extracted, all of the different areas should be formatted in such a way where each place links to its parent all under one table. For example:
Springfield, Sangamon County, Illinois
Springfield, Hampden County, Massachusetts
Springfield, Greene County, Missouri
New York City, New York
New York, Santa Rosa County, Florida
New York, Caldwell County, Missouri
New York, Ballard County, Kentucky