Closest User Locator Backend - PostgreSQL - PostGIS

Job ID: 37742877

Budget: $250 – $750 USD

I need a backend that utilizes PostgreSQL and PostGIS. I need a very simple UI, which can use HTML tags if the developer prefers (Or Reactjs, no other option), where a data profile can be created saving coordinates. For example, a profile is:

Latitude: -989898
Longitude: -409390
User ID: 123
Name: Rafael
Type: Singer
There are 10 of these profiles. I want to be able to find the one closest to me. To determine my location, the geolocation from my browser should be used.

Additionally, I want to be able to search for the closest profile of a certain type.

An open-source map, OpenStreetMap, should be used to display the closest profiles on a map and also show simple balloons above each coordinate (No need for elaborate design; it can just display the name.)

The delivery includes:

(Page 1) A very simple page where a profile can be created based on geolocation.
(Page 1) A button on the page that creates the profile in the database.
(Page 2) A page featuring an open-source map, OpenStreetMap, that pinpoints my location with a marker on the map (Using my geolocation, and the open-source map, it's not real-time, it gets the geolocation from the browser's API) and allows only my location to be moved.
(Page 2) There should be a button and the necessary UI to search either by location only or by location and type (An additional search index).
(Page 2) Display the results on the open-source map of the page.
(Page 3) Delete and update users by ID, inputs, and a button, no UI needed, just to activate the functionality.
For the backend, Node.js with Express should be used just for the routes, which will connect to the database, a simple Node - Express app.js structure, routes, no middleware, routes that perform the creation requests, and the queries to search by proximity or proximity and type. Node.js file, start the server with Nodemon, or a GitHub repo (Preferred).

The database should be available for local installation, such as a .zip file, or a GitHub repo (Preferred).

The frontend can be HTML JS (If you wish to use something, only React.js is allowed), no styles unless desired. The only requirement for responsiveness is the map, and since OpenStreetMap is going to be used, I assume it's already well-optimized for mobile.

This is a job for a backend developer. Key points in the architecture will be discussed during a video call.

Finally, a short video/video call is needed to understand the project, how it works, and how it is structured.