Find Jobs
Hire Freelancers

Geocode my Website's Access database

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I run a website that has a database of 6,000 addresses of locations around the world. This information is kept in a Microsoft Access database on the server. Most of the locations in the database already have latitude/longitude information, but there are new addresses being submitted to the database all the time. Therefore, I need a way to geocode any addresses in the databases that don't already have latitude/longitude information, and put that information into the database. There are two ways I envision this can be done, but I'm open to other suggestions, as well: 1. You can develop a private web page (password protected) that I navigate to, and there, I click a button that runs your code. The code goes line by line through the database, and for any address that doesn't have latitude/longitude already there (those fields are either null or zero), it uses the google maps geocoding API to geocode and put in the information. I want some kind of feedback displayed, that lists the addresses successfully geocoded, as well as addresses that failed geocoding for any reason. 2. Alternatively, you can develop code that does the above, but instead of me running it manually, it runs itself automatically once a day, and then emails me a report of what it did, as above.
Project ID: 12252512

About the project

20 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi! I would like to offer my service to create a script for geocoding addresses in your website's Access database, using Google API. I am a programmer for web, client/server & mobile applications. Proficient in PHP + MySQL, Microsoft .NET + MS SQL Server, and Android platform, I also do graphic design works, primarily UI designs and image editing. I have good attention to details in client's requirements, and once a project starts, I am 100% committed to its completion. I live in Indonesia, my timezone is GMT +7. I look forward to hearing from you. Thank you.
$100 USD in 3 days
5.0 (6 reviews)
3.9
3.9
20 freelancers are bidding on average $174 USD for this job
User Avatar
Hi, I can see both the approach is doable. however, for the 2nd option need to have dedicated server which allow to schedule & run the application on a specified time. I can develop the app which can be fit in both the scenerio. Let me know if you have any query or concern. Look forward to hear from you. Regards
$277 USD in 3 days
4.8 (252 reviews)
7.9
7.9
User Avatar
Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I'm thinking about the second option you mentioned in the description, but instead of having the code run every 24 hours I'd suggest you add an event that gets the geocode information every time an address is added to the database. This is a simpler and user-friendly way to satisfy your needs. I have done similar assignments previously, so check my profile for details. I'm looking forward to hear from you. Regards,
$150 USD in 1 day
4.9 (72 reviews)
5.9
5.9
User Avatar
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you would like to use google maps geocoding API to geocode and put in the latitude/longitude in database for any address that doesn't have latitude/longitude already there. Also you want some kind of feedback displayed, that lists the addresses successfully geocoded, as well as addresses that failed geocoding for any reason. For second option (code runs itself automatically once a day, and then emails you a report of what it did, as above instead of you login each day to click on a button). I have to see if your hosting provider has been provided the feature to run scheduled tasks on your server. I have 3 year's experience of web development. I would love to speak with you further about taking this project on. Thank you. Have a nice day...
$144 USD in 3 days
4.9 (71 reviews)
6.0
6.0
User Avatar
A proposal has not yet been provided
$166 USD in 2 days
5.0 (44 reviews)
5.1
5.1
User Avatar
Hi Employer, I have read your description and been interested in your project. I'm ready to discuss and start to work on it now. ================================= Please discuss before awarding the project.
$210 USD in 5 days
5.0 (6 reviews)
4.7
4.7
User Avatar
Hi there! I can help you preparing your solution on the requirements described. I would go for the Email solution. With a .NET small application that I can develop, I can read your database access, if applies, I will fetch location trought the google Maps API and then prepare you an Email report. My delivery time is 2-3 days. Please let me know if interested, Regards, Sergio
$110 USD in 3 days
4.9 (8 reviews)
4.7
4.7
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$166 USD in 7 days
4.9 (31 reviews)
4.5
4.5
User Avatar
Hello, I'm an experienced Python developer and I have a lot of experience with GIS: - applications: QGIS, PostGIS, Google Earth - file formats: SHP, GeoJSON, GPX, KML - libraries: fiona, shapely, pyproj, rtree - mapping platforms: Google Maps APIs, OpenStreetMap, Here APIs, OpenLayers For this project I would write a Python script that processes the entries and sends an email report and can be run as a scheduled task (cron). What environment does the server have? Best wishes, iticus
$150 USD in 3 days
4.8 (8 reviews)
4.7
4.7
User Avatar
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$156 USD in 3 days
5.0 (12 reviews)
4.2
4.2
User Avatar
Hi, This is interesting project. I can use other variant, I can create hidden iframe to collect geo data and save it in DB. Is it classic ASP (.asp pages)? Thanks, Denis
$166 USD in 7 days
5.0 (2 reviews)
1.1
1.1
User Avatar
Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned .I have checked your requirements.i have right skills to work on this assignmentWe find our expertise, skills and capabilities are perfectly blends with your project requirements because we have already worked on many projects. You'll love the whole layout, interface design , cross-browser compatibility and mobile-device-friendly interfaces that we design Our team has created over dozen of windows, and web based appliations iPhone/iPad games and apps, and over 10 Windows and Linux server APIs and security tools Don't waste any more time in your development We take care of all these things for you . Advanced custom coding for our clients. Anytime. [Removed for encouraging offsite communication which is against our Terms and Conditions.]. plz add me to discus I am ready to discuss with you Looking forward to hear from you. with best Regards
$194 USD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Bergenfield, United States
5.0
14
Payment method verified
Member since Jan 1, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.