7 Replies - 330 Views - Last Post: 02 October 2018 - 01:57 PM

#1 jeremyaz1   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 01-October 18

Cities to Metro Areas

Posted 01 October 2018 - 12:08 PM

Anyone tackle this before? I'm trying to build a job site page with employers and candidates but want to allow the results to show a larger area than the city selected. For instance, if someone chose Scottsdale, AZ I would want the results to include all of Greater Phoenix. Any thoughts where to get a list with this? Thanks!
Is This A Good Question/Topic? 0
  • +

Replies To: Cities to Metro Areas

#2 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 14685
  • View blog
  • Posts: 58,683
  • Joined: 12-June 08

Re: Cities to Metro Areas

Posted 01 October 2018 - 12:11 PM

Yes - I have used a secondary table of locations attached to one primary location. Any DB search would go about getting these extra areas to include with an 'OR'.
Was This Post Helpful? 0
  • +
  • -

#3 jeremyaz1   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 01-October 18

Re: Cities to Metro Areas

Posted 01 October 2018 - 12:16 PM

Any idea where to get that so I don't have to reinvent the wheel? Thanks!
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 14685
  • View blog
  • Posts: 58,683
  • Joined: 12-June 08

Re: Cities to Metro Areas

Posted 01 October 2018 - 12:23 PM

*shrug* I built an input form for my users to make their own connections, and empowered them to do it.

In your case - check for downloadable zipcodes and go from there? Alternatively work into your flow new job posting entries and if it's a city add the surrounding areas as needed..
Was This Post Helpful? 0
  • +
  • -

#5 astonecipher   User is offline

  • Senior Systems Engineer
  • member icon

Reputation: 2704
  • View blog
  • Posts: 10,800
  • Joined: 03-December 12

Re: Cities to Metro Areas

Posted 01 October 2018 - 12:31 PM

LinkedIn does this. "Atlanta" OR "Greater Atlanta Area". In fact most do, you can also give a zip code with a miles radius.


I'd go with the zipcode tables and then add the formula for the zip code distance.
Was This Post Helpful? 0
  • +
  • -

#6 Salem_c   User is offline

  • void main'ers are DOOMED
  • member icon

Reputation: 2278
  • View blog
  • Posts: 4,362
  • Joined: 30-May 10

Re: Cities to Metro Areas

Posted 02 October 2018 - 03:14 AM

Why not throw in all the transport information (walk, road, rail, bus, tram, boat, etc) along with travel costs, so people can also query "find all jobs less than an hour away, and cost less than $200/month in travel costs".

Many places are geographically "close" but are a real PITA to travel to on a daily basis in rush hour.

The headline salary might be attractive, but if you burn it all on travel, and stress yourself out in the process just getting there and back, would it be worth it?
Was This Post Helpful? 0
  • +
  • -

#7 jon.kiparsky   User is offline

  • Beginner
  • member icon


Reputation: 11374
  • View blog
  • Posts: 19,406
  • Joined: 19-March 11

Re: Cities to Metro Areas

Posted 02 October 2018 - 09:48 AM

Obvious thing would be to check the google maps API, though I understand they've changed their pricing model recently
Was This Post Helpful? 0
  • +
  • -

#8 Skydiver   User is online

  • Code herder
  • member icon

Reputation: 6657
  • View blog
  • Posts: 22,740
  • Joined: 05-May 12

Re: Cities to Metro Areas

Posted 02 October 2018 - 01:57 PM

If the company offers flex hours, there is a way to avoid the traffic by commuting after rush hour. I used to drive in to work at 10AM and go home at 8PM.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1