Need Help Implementing Location-Based Filters on a Used Car Sales Website

[younes-alouani]

I am working on developing a website that lists used cars for sale, and I require guidance on how to add location-based filters for buyers and sellers.

The website’s most critical feature is to enable buyers to filter car listings by location, specifically by city, region/state, or country. Additionally, sellers should be able to select the location for their listings when creating them, so buyers can easily find cars in their preferred location.

As a developer, I am unsure about the best way to implement this feature. I am considering using a local database of locations or integrating Google API or a similar service to create an extensive location database.

I would appreciate any advice or suggestions on how to develop location-based filters that are user-friendly and easy for both buyers and sellers to use. Thank you for your help!

[Ankhers]

If you are using postgres, you will probably want to look into using postgis. From the home page.

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

Which is exactly what you are asking for.

If you are using another database, I am sure there are similar extensions. But I have no idea what they are.

[codeanpeace]

What's the best way to do geo radius by distance search?

What would be the optimal way to have a set of locations in the database, and enable search of addresses by distance. i.e. All addresses within a 10 mile radius, etc I have the longitude and latitude of every address in the db. Is there a good dep for this, or is better to go the postgis route?