Google Maps/Google Earth/Excel developer
- or -
Post a project like this$$$
- Posted:
- Proposals: 6
- Remote
- #1430906
- Expired
Description
Experience Level: Expert
General information for the business: Drilling company that needs help to automate underground utility locating time
Description of every module: I believe I am looking for a Google Maps/Google Earth/Excel developer. We are a drilling company and often call in hundreds of utility locates which is very time consuming.
Description of requirements/functionality: We are looking to automatically generate specific information that will reduce the prep time required to inform the various state One-Call centers where we will be drilling to make sure we do not drill into underground utilities such as cable, electric, gas, etc. Each state has their own system and I am not looking to automate submitting tickets but rather to gather the information needed to enter information in each of the different state systems.
CMS and Admin requirements: I would like columns that I could copy and paste from client information: hole #, latitude, longitude and notes section as the last column. The information I would like to auto generate would be: X & Y UTM83m, closest intersection (two road names in separate columns), driving directions (keep in mind most locations are rural with limited roads and would need to use whatever roads and drive into the field to the gps coordinate).
There are a few ways that clients provide information to me:
(1) Excel spreadsheet with the hole number and gps coordinates and/or utm coordinates. They also provide me with a kmz google earth file with all the coordinates pinned on it.
(2) JPG of site with hand drawn outline of the area that we will drill multiple holes. In this scenario, I could create a Google Earth kmz path to outline the site.
(3) Site Address
Project Part 2 - Another option that would be bonus is to be able to somehow be able to have access to this information in the field, maybe a smart phone?
OS requirements: Windows
Extra notes:
Description of every module: I believe I am looking for a Google Maps/Google Earth/Excel developer. We are a drilling company and often call in hundreds of utility locates which is very time consuming.
Description of requirements/functionality: We are looking to automatically generate specific information that will reduce the prep time required to inform the various state One-Call centers where we will be drilling to make sure we do not drill into underground utilities such as cable, electric, gas, etc. Each state has their own system and I am not looking to automate submitting tickets but rather to gather the information needed to enter information in each of the different state systems.
CMS and Admin requirements: I would like columns that I could copy and paste from client information: hole #, latitude, longitude and notes section as the last column. The information I would like to auto generate would be: X & Y UTM83m, closest intersection (two road names in separate columns), driving directions (keep in mind most locations are rural with limited roads and would need to use whatever roads and drive into the field to the gps coordinate).
There are a few ways that clients provide information to me:
(1) Excel spreadsheet with the hole number and gps coordinates and/or utm coordinates. They also provide me with a kmz google earth file with all the coordinates pinned on it.
(2) JPG of site with hand drawn outline of the area that we will drill multiple holes. In this scenario, I could create a Google Earth kmz path to outline the site.
(3) Site Address
Project Part 2 - Another option that would be bonus is to be able to somehow be able to have access to this information in the field, maybe a smart phone?
OS requirements: Windows
Extra notes:
Sherri M.
20% (1)Projects Completed
3
Freelancers worked with
3
Projects awarded
80%
Last project
6 May 2021
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies