I am looking to acquire data from Wikimapia. Specifically, I would like a programmer to generate latitude and longitude coordinates for every entry in the Wikimapia interface for the United States as a centroid. The coordinates must be in decimal degree format with six decimal place precision (latitudes are positive and longitudes are negative). For example, 40.446195, [url removed, login to view]
Information associated with these features (name and keywords) is also required.
The coordinates for each entry and its associated information (name and keywords) should be delivered in .dbf or .mdb format. One entry for each record. Column formatting should be similar to the following: NAME, KEYWORD1, KEYWORD2, KEYWORD3, LAT, LON
Familiarity with Google Maps API, Geographic information systems (GIS), PERL are a plus.
Ability to provide a sample of the output would also be beneficial.