Activity Feed › Discussion Forums › Business, Finance & Legal › Keeping track of project locations
Keeping track of project locations
Posted by foggyidea on February 26, 2019 at 6:42 pmSWMBO 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?
Thanks,
Don
david-kendall replied 5 years ago 12 Members · 16 Replies- 16 Replies
No!
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.
The office person is sticking pins in Google Earth….
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.
If I were to start over, I would use the Tax Accessory’s Property ID # as a filename.
I use Global Mapper:
https://www.bluemarblegeo.com/products/global-mapper.php
I’ve recently been informed that QGIS has become much more user friendly than it was a decade ago, so that might also be an option:
The only problem with either of those is getting used to the new software and how it operates. If you go with something along those lines, there is vast amount of data that can be added in to aid (imagery, road layers, etc…).
Jon P… wasn’t there a plug in for QGIS for geocoding inside the software??
Google up “OpenStreetMap”. It’s open source and with a little creative license I’m betting it could be made to work. Check out the “user’s diaries” for ideas. It’s a pretty cool platform in any case.
WillyQGIS would be a thing to look into.
- Posted by: Norman Oklahoma
QGIS would be a thing to look into.
Yep.
or get a personal esri license which has lots of fun tools for 100.00 per year. its full blown version, just can’t use it for commercial business.
I haven’t tried out this software but found it in a search for a geocoder and it looks interesting. I’ll follow up with a post if/when I use it.
Sorry Andy, I don’t get logged on quite as often as I would like to.
I’m not sure about QGIS options as I don’t use it. Since it is open-source, I would bet that almost any feature one would like could be arranged with a simple request on their forums. Someone out there would love to show their prowess at coding!
Jon
This is how it ought to be done…. Thanks for sharing!
BTW are you hiring? Willing to relocate from CA….
Log in to reply.