Build a list of all Craigslist Cities, Subareas, and Neighborhoods

We are looking for a database with the full list of / a scraper that can scrape: - Craigslist "Top Level Cities" - Craigslist "Sub Areas" - Craigslist "Neighborhoods" - All US & CA Cities. Outside of US & Canada is not necessary. This script should output 4 mySQL tables: (1) craigslist_city - schema example: [login to view URL] - name = look at the name on the market's index, top-middle: [login to view URL] - alternate name = look at the drop-down box in 'my account', can be linked via code: [login to view URL] - code = look at the link "post to classifieds" on the market's index (2) craigslist_city_subarea - the "city subareas" are a mix of the city and subareas. they have links and codes like cities, but are actually a 1:1 relationship to the subareas in #3 below. you do not need to describe the 1:1 relationship between this table and the subarea table (that is, link them) since there is, as far as I know, no way to automatically link them. - schema example: [login to view URL] - pull the codes from here, [login to view URL] - once you click the code's link you will see the full name just like in [login to view URL] - if you can link it to craigslist_city that would be GREAT! But I don't see an easy way to link it since the names are SLIGHTLY different and no other common ID exists. (3) craigslist_subarea - url will be ?s=subarea, can only be scraped by going to "post to classifieds" as far as I know - this is more important than #2, these are the 'real' subareas, and once again you will find a 1:1 relationship to #2 above but I cannot find a way to link them and it's not necessary to do so. - schema example: [login to view URL] - pull data from [login to view URL] .. (for this example, go to [login to view URL], click post to classifieds, select category and subcategory) - THIS is the subarea ID that we link the neighborhoods to! (4) craigslist_hood - url will be ?s=hood, can only be scraped by going to "post to classifieds" as far as I know - if you click "san francisco" subarea as in the example in #3, you'll come to a page like this: [login to view URL] - schema example: [login to view URL] -- the city_id refers to #1 above and the subarea_id refers to #3 above [NOT 2!] That's it. I have a PDF ready that explains all of the above but in more in depth language if necessary.