Street-Level Address Geocoding in Node.js
Budget: €250 – €750 EUR
The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table.
You can follow these steps:
1. Retrieve the xls file from the mailbox - cron every hour
2. Normalize the xls file for integration into a MySQL table
3. Configure access to SQL database from JavaScript.
4. Insert data into table via SQL query
5. Retrieve addresses to be geocoded from the SQL table.
6. Use Google Maps API to geocode each address.
7. Insert the geographical coordinates (latitude and longitude) in the SQL table.
Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR.
The data is sorted using the “Mode of delivery” information, which allows deliveries to be grouped by truck.
During the day's import, only lines with “Mode of delivery” information beginning with the letter Q should be imported.
A SQL table will be created in the database. Each day, with each file sent, data will be added to the table.
Key Responsibilities:
- Develop a geocoding application in Node.js
- Connect to a MySQL database to fetch addresses
- Implement street-level accuracy in geocoding
- Handle errors and edge cases in geocoding
Ideal Skills and Experience:
- Proficient in Node.js
- Experience working with MySQL databases
- Familiarity with geocoding services and APIs
- Strong problem-solving skills
- Attention to detail for street-level accuracy
If you have experience with similar projects and are confident in your ability to deliver accurate and efficient geocoding results, please bid on this project.
You can follow these steps:
1. Retrieve the xls file from the mailbox - cron every hour
2. Normalize the xls file for integration into a MySQL table
3. Configure access to SQL database from JavaScript.
4. Insert data into table via SQL query
5. Retrieve addresses to be geocoded from the SQL table.
6. Use Google Maps API to geocode each address.
7. Insert the geographical coordinates (latitude and longitude) in the SQL table.
Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR.
The data is sorted using the “Mode of delivery” information, which allows deliveries to be grouped by truck.
During the day's import, only lines with “Mode of delivery” information beginning with the letter Q should be imported.
A SQL table will be created in the database. Each day, with each file sent, data will be added to the table.
Key Responsibilities:
- Develop a geocoding application in Node.js
- Connect to a MySQL database to fetch addresses
- Implement street-level accuracy in geocoding
- Handle errors and edge cases in geocoding
Ideal Skills and Experience:
- Proficient in Node.js
- Experience working with MySQL databases
- Familiarity with geocoding services and APIs
- Strong problem-solving skills
- Attention to detail for street-level accuracy
If you have experience with similar projects and are confident in your ability to deliver accurate and efficient geocoding results, please bid on this project.