Find Jobs
Hire Freelancers

Street-Level Address Geocoding in Node.js

€250-750 EUR

Închis
Data postării: circa 1 lună în urmă

€250-750 EUR

Plata la predare
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.
ID-ul proiectului: 38116817

Despre proiect

133 propuneri
Proiect la distanță
Activ: 29 zile în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
133 freelanceri plasează o ofertă medie de €531 EUR pentru proiect
Avatarul utilizatorului
As an 18+ year veteran in web and app development, my expertise is highly versatile. My vast experience spans across essential languages such as PHP, WordPress, WooCommerce, Data Scrapping, Buddypress,React Native and notably JavaScript. Most significantly to your project, I've dedicated significant portions of my career to master the performance capabilities and utilization procedures of Node.js and MySQL – two technologies core to your data management goals. In addition to this, I'm deeply familiar with geocoding applications and services which majorly includes the Google Maps API. This affords me a solid understanding of the nuances you'll encounter in this project – from routine retrieval of .xls files from a mailbox and normalizing them for integration into an SQL table to handling edge-cases and errors for optimized geocoding results. Lastly, my dedication to delivering tasks on time and within budget is reflected in the words of my 712+ satisfied clients who commend both the quality of work delivered by me and the smooth communication they've enjoyed during our collaborations. With proven adaptability to varying client needs coupled with strong problem-solving skills guided by attention to detail, I am confident that I am the perfect fit for your Street-Level Address Geocoding project. Let's create insightful data together!
€500 EUR în 7 zile
4,9 (330 recenzii)
8,5
8,5
Avatarul utilizatorului
Hi there I have extensive experience working with Node.js and MySQL databases, making me well-equipped to handle this project. I will create a NodeJS program to retrieve the xls file from the email inbox, normalize the data, and insert it into an SQL table. Additionally, I will configure access to the SQL database and use the Google Maps API to geocode the addresses with street-level accuracy. I am confident in my ability to efficiently handle errors and edge cases in geocoding to ensure accurate results. My attention to detail and problem-solving skills make me the ideal candidate for this project. I can provide links to similar works from my portfolio. Please go through my profile its 15 years old see the work I did over the years. ---> No Win No Fee means that your satisfaction is my utmost priority. <---- Lets discuss the job details. Moreover, I am willing to start the job and perform tasks without even being hired; it is just to show my commitment to this project. Looking forward to hear from you. Regards Shah
€488 EUR în 7 zile
4,8 (130 recenzii)
7,8
7,8
Avatarul utilizatorului
Hi there, I have reviewed your requirements and believe that my expertise aligns perfectly with them. It seems like something we can easily accomplish. Few questions: → Could you please provide a detailed outline of your requirements for this project? → Do you have a specific timeline or deadline in mind for the completion of the project? I am flexible in prices, as quality & long-term relationships are more important. Note:- This is a place holder bid. So the Actual price and time will be given after complete discussion. Looking forward to the opportunity to work together. Regards Nurul Hasan
€750 EUR în 20 zile
4,7 (48 recenzii)
7,7
7,7
Avatarul utilizatorului
Hi As a seasoned full stack developer, I am fluent in all aspects of JavaScript and Node.js along with proficiency in working with MySQL databases. My strong problem-solving skills and attention to detail are qualities that are essential to delivering accurate geocoding results at street-level accuracy. Over my tenure, I have successfully integrated various APIs including Google Maps API, streamlining data import and transforming it into meaningful SQL tables. Pitching you one step further, what sets me apart is my tenacious curiosity to master new technologies and undertake challenging projects, irrespective of their complexity. My stints with renowned organizations in enterprise and medium tiers have given me exposure to diverse and intricate problems - a cumulative experience of over one thousand successful projects. I assure you my adaptability, flexibility, and commitment towards long-term customer relationships as we tackle this project together-
€500 EUR în 7 zile
4,9 (37 recenzii)
7,2
7,2
Avatarul utilizatorului
With over a decade of experience, my team and I at Websyms are well-versed in all the key aspects you're looking for in this project. As a skilled developer, we have a demonstrated command over MongoDB, PHP, and JavaScript and have worked extensively with MySQL databases; making us well-equipped to connect to and fetch addresses from your SQL database, thus ensuring data integrity. Our proficiency in JavaScript and Node.js and our familiarity with geocoding services like Google Maps API positions us comfortably to develop the geocoding application you need. Our ability to anticipate challenges and create deft solutions is showcased in our wide array of expertise across various websites and technologies. Hatchminded team can handle every element of your project - from retrieving the xls file from your mailbox using cron every hour to importing only lines with "Mode of delivery” information beginning with Letter Q and normalizing it for MySQL integration. As an extra layer of quality that we bring to the table, our track record speaks volumes and is proof why we are one of the TOP 5 freelancers. Our painstaking attention to detail ensures street-level accuracy during geocoding; an acumen honed by years of experience which you won’t find elsewhere easily. So, if you're looking for 100% accurate deliverables completed on time without fail, let's make it happen together!
€500 EUR în 7 zile
4,9 (218 recenzii)
7,4
7,4
Avatarul utilizatorului
Hello, Greetings, I trust this message finds you well. Having reviewed your project description, I am confident and excited about the prospect of working on this project for you. With previous experience in a similar space with another client, I believe it would be beneficial for us to discuss this further. Let's arrange a brief discussion, during which I can demonstrate my capabilities. I am waiting for your response. Regards, Divya.
€750 EUR în 8 zile
4,8 (82 recenzii)
7,4
7,4
Avatarul utilizatorului
Hello, I'm excited to help you develop a Node.js program for street-level address geocoding using the Google Maps API. With proficiency in Node.js and experience working with MySQL databases, I can ensure accurate geocoding and seamless integration. Here's how I will proceed: 1. Set up a cron job to retrieve the xls file from the mailbox every hour. 2. Normalize the xls file for integration into a MySQL table, ensuring only relevant lines are imported. 3. Configure JavaScript access to the SQL database and insert data via SQL query. 4. Retrieve addresses from the SQL table and use the Google Maps API to geocode each address. 5. Insert the geographical coordinates (latitude and longitude) back into the SQL table. I am a TOP Rated Freelancer, and you can check my reviews here as well: https://www.freelancer.com/u/kamran2012 Questions: 1. Could you provide more details about the email service used for retrieving the xls file? 2. Are there any specific error handling or logging requirements for the geocoding process? 3. Do you have any preferences for the SQL table structure or additional data to be stored? Looking forward to potentially working together on this project. Best regards, Kamran
€750 EUR în 15 zile
5,0 (23 recenzii)
6,5
6,5
Avatarul utilizatorului
Hello. I have good experience with mailparser in node js. Also, i am familiar with geocoding. Please let me know once you are available. so we get started work soon. Thank you.
€400 EUR în 7 zile
4,9 (24 recenzii)
6,4
6,4
Avatarul utilizatorului
hello, i read the project and have more than 9 year experience in development and ready to start work on your project
€900 EUR în 12 zile
4,6 (56 recenzii)
6,3
6,3
Avatarul utilizatorului
Hello, Greetings! I am interested in working with you on this project, as it aligns with my skill set. Please take a look at my profile for confirmation. After talking about it, we should go ahead and finalize the specifics. Please allow me the chance to demonstrate my capabilities. I aspire to be a valuable asset to you, and I am committed to meeting your expectations with my performance. I am prepared to start immediately and can commit to 40+ hours per week. Thank you
€500 EUR în 7 zile
5,0 (17 recenzii)
5,9
5,9
Avatarul utilizatorului
Hello Mate, As an IT expert, I can develop a Node.js application to retrieve xls files from your email inbox and integrate them into a MySQL database. With proficiency in Node.js and MySQL, I'll ensure street-level accuracy in geocoding using the Google Maps API, handling errors and edge cases effectively. With experience in geocoding services and APIs, I'll deliver a robust solution that meets your project's requirements while maintaining attention to detail. Let's build a streamlined system to efficiently manage your delivery data and enhance your logistics operations.
€620 EUR în 5 zile
4,7 (22 recenzii)
6,2
6,2
Avatarul utilizatorului
Hi, GeoReference I fully understand your requirement and have an experience in developing Node project similar to your project. As an experienced developer, I have a strong proficiency in Node.js, and am familiar with several libraries such as imap, mailparser, node-cron to retrieve the data from mailbox. Also, I have an experience working with MySQL, and deep understanding of SQL query. And I have an experience in implementing API integration and several functionalities such as sort, filter, search, etc. If given opportunity, I will deliver high-quality results tailored to your requirements. Looking forward to working on this project with you. Sincerely, Diah
€500 EUR în 10 zile
5,0 (4 recenzii)
5,6
5,6
Avatarul utilizatorului
Hello, We are a team of skilled Node.js freelancers with extensive experience in database integration and geocoding. We are confident we can deliver the requested Node.js program to meet your project requirements. Our Approach: Develop a robust Node.js application to: Retrieve XLS files from your mailbox hourly using cron. Normalize data for seamless MySQL integration. Connect securely to your MySQL database. Insert and manage delivery data with geospatial coordinates. Leverage Google Maps API for accurate street-level geocoding. Implement robust error handling to ensure data integrity. Prioritize attention to detail for achieving precise geocoding results. Our Qualifications: Proven expertise in Node.js development. In-depth experience working with MySQL databases. Familiarity with various geocoding services and APIs. Strong problem-solving skills and a meticulous approach. We are confident we can efficiently handle deliveries grouped by "Mode of delivery" starting with "Q". Thank you for your time and consideration. Sincerely, Arun
€500 EUR în 7 zile
5,0 (4 recenzii)
5,8
5,8
Avatarul utilizatorului
⭐ Hi, My availability is immediate. I read your project post on React/Node Developer 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. We have extensive knowledge in MERN Stack (MongoDB/MySQL, Express JS, React, and NodeJS), as well as RESTful API integration. We are an experienced team of full-stack developers having skill sets in - React, JavaScript, jQuery, TypeScript, NextJS, React Native - NodeJS, ExpressJS - MongoDB, MySQL, PostgreSQL, SQLServer, SQLite - Redux, Thunk, GIT - JavaScript, HTML, CSS, Tailwind CSS - AWS, Azure, Digital Ocean, GoDaddy, Web Server Hosting Please send a message So we can quickly discuss your project and proceed further. I am looking forward to hearing from you. Thanks
€730 EUR în 13 zile
5,0 (24 recenzii)
5,3
5,3
Avatarul utilizatorului
Hi there, I've understood your requirements and can start work right now. I have rich experience in Node.js with Excel, Google Map API, and MySQL. Please feel free to contact to me. Thanks Alexander
€750 EUR în 7 zile
5,0 (23 recenzii)
5,3
5,3
Avatarul utilizatorului
Nice to meet you GeoReference,The requirements of your project match my areas of work and skills, to introduce myself. My name is Anthony Muñoz and i am the lead engineer for DS Pro IT agency. I have worked for over 10 years as a Full-Stack and software development engineer and have successfully done multiple jobs. It will be a pleasure to work together to make your project. Feel free to discuss about the project with me, greetings.
€1.008 EUR în 7 zile
4,7 (7 recenzii)
5,7
5,7
Avatarul utilizatorului
Hello. I've reviewed your job posting and have a good understanding of the task at hand. However, before finalizing details such as pricing, timelines, and milestones, it's crucial to ensure complete clarity. I prefer not to make generic statements like "I am confident" without concrete understanding and agreement on the project specifics. Please feel free to reach out to me so we can discuss the project in detail. I have extensive experience in google API and possess strong expertise, and if everything is clear, I'm ready to start immediately. Thank you once again for sharing your job posting. Best regards, Miroslav Pesic
€500 EUR în 7 zile
4,8 (10 recenzii)
5,2
5,2
Avatarul utilizatorului
Dear Client, I am excited about the opportunity to develop your Node.js program for retrieving and geocoding addresses from XLS files, and integrating the results into your MySQL database. With extensive experience in Node.js, MySQL, and geocoding APIs, I am confident in delivering accurate and efficient geocoding results while handling any errors or edge cases effectively. Let's collaborate to ensure your project runs smoothly and meets all requirements. Best regards, Iman Daneshi
€350 EUR în 5 zile
5,0 (12 recenzii)
4,9
4,9
Avatarul utilizatorului
Hi Benoît M., this is Umair. I have good experience with Node.js, JavaScript, MySQL and Google APIs. I am a practicing Developer/Designer Since 2015. I can perfectly work on this project regarding Street-Level Address Geocoding in Node.js. I can say this with conviction as my all reviews are 5 stars , I can do this task for you and the quality of work would be up to the mark. However, further discussions are required for more clarity. I will wait for your text to discuss the project in further detail. Thanks & Regards Umair A.
€700 EUR în 20 zile
5,0 (7 recenzii)
5,0
5,0
Avatarul utilizatorului
As an experienced Node.js developer with a background in MySQL databases and Google APIs, I'm intrigued by the Street-Level Address Geocoding project. Could you provide more details on how the geocoding application will handle errors and edge cases? Additionally, I'm curious about the specific requirements for achieving street-level accuracy in geocoding. Your insights will help me tailor my approach to meet the project's objectives effectively.
€650 EUR în 7 zile
4,3 (30 recenzii)
5,8
5,8

Despre client

Steagul FRANCE
VILLENEUVE D'ASCQ, France
5,0
4
Metoda de plată a fost confirmată
Membru din sept. 2, 2015

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.