Keeping track of project locations
SWMBO has asked me to ask y'all how you keep track of your project locations? We have been using google earth but it's getting very cumbersome and awkward to input that many jobs!
I am sure that this has been discussed ad nauseum, but for the life of me I couldn't find any threads. Of course the subject name could have been just about anything.
The old method of plotting them on the assessors maps won't work for me, we need a digital, simple way, and one that doesn't cost $500/year! Are there any inexpensive options?
We developed a plan using Open source GIS software and out Accounting/Bookkeeping software.
Quick books lets you define user-defined fields for the customers. so we made fields for X and Y on our state plane system. Every time a job went into Quick books we keyed in state plane coordinates for the center of the job.
We could then write this out as needed to a comma delimited file containing X, Y , Job number and type of job. We then imported this file into a GIS file with a base map of our state. Open the GIS file, zoom in to the proposed job and see if there is anything in the area.
Worked well .
You could probably do the same thing using a online tool like ArcGIS Earth.
How are you inputting them into google earth? I used an online geocoder to batch process a spreadsheet with years of data.
Spread sheet accounting program: Job#; Account #; Client name; Project Location by State, County, TRS/Subdivision-Block-Lot. Each is cross referenced to the other.
As long as I know one of them I can track down the jobs attached to them. Do some other things but the Google tracking didn't work well at all. Nor did the TGO file.