You can search "My Places" in Google Earth if you use the search window in the bottom of the "My Places" pane (not the one at the top of the program).?ÿ Works really well, I just tried it.
I was experiencing Google Earth slowdowns and crashed myself a while back, so I started paring down what I permanently kept to native Google Earth conent > Folders, paths, polygons, and associated text that I entered and photos that I linked.?ÿ This resulted in the program remaining perfectly stable.?ÿ Other content generated from outside sources like CAD, ESRI, Trimble, Websites etc.?ÿ I saved in a separate Folder and only loaded temporarily.?ÿ I think those are the source of the corruption.
I couldn't function without Google Earth!?ÿ
?ÿ
As far as what I place in Google Earth I keep it short and just drop a pin flag and job number at the job location.?ÿ
It occurred to me that you could make a very simple but effective data base using just Excel and be able to plot it to identify a key job number or other record index that could be?ÿsearched in the excel file for all the detailed record?ÿyou'd like. In excel you'd create your data base by making the first column a job number (rather than a point number), second and third column would be your northing and eastings for the location of the work, fourth column rather than an elevation you could substitute a numerical code of your choosing that might for example reference whether the job is tied to CORS or is on a local system, or whatever. Fifth column rather than a point description you could substitute a client or file name, road, whatever that would serve to jog your memory. Once you have the excel spreadsheet to your liking it's just a simple matter of doing a 'save as' to a comma delimited .csv file that can be readily imported into CAD. Once you've plotted the .csv file you would be able to quickly ID any previous work in the area and using the "Point (Job) Number",?ÿ and use that number do a search of your excel spreadsheet to garner all of the associated details. ?ÿ
So easy even a caveman stripper could do it.
If all your jobs are on a common coordinate system that would work beautifully.?ÿ If that common coordinate system was State Plane and you're current with your Autodesk subscription you would even get the aerial map overlay to correspond with the points you imported.
Been using ZTreeWin for 28+ years.
Punch in any word, survey, name, number that is in the file and it will deliver a list of files that contain what you are wanting.
Been using ZTreeWin for 28+ years.
Punch in any word, survey, name, number that is in the file and it will deliver a list of files that contain what you are wanting.
So.....this ZTreeWin, is it a Data base? I looked it up and am a bit curious and it actually reminds me of what I have seen others using but I cannot find a video (with sound) that explains what it does and how it "do" it.
You can search "My Places" in Google Earth if you use the search window in the bottom of the "My Places" pane (not the one at the top of the program).?ÿ Works really well, I just tried it.
I was experiencing Google Earth slowdowns and crashed myself a while back, so I started paring down what I permanently kept to native Google Earth conent > Folders, paths, polygons, and associated text that I entered and photos that I linked.?ÿ This resulted in the program remaining perfectly stable.?ÿ Other content generated from outside sources like CAD, ESRI, Trimble, Websites etc.?ÿ I saved in a separate Folder and only loaded temporarily.?ÿ I think those are the source of the corruption.
I couldn't function without Google Earth!?ÿ
?ÿ
?ÿ
?ÿ
WOW!?ÿ How in the world did I NOT know about the lower search bar????ÿ SHeesh!?ÿ I use google earth for a TON of stuff, and have used geocoders to convert all my spreadsheet project data to placemarks, along with bench runs, published control, etc.?ÿ ?ÿ Thanks for the tip!?ÿ?ÿ
ZTREEWIN is a search engine that finds words inside files on your computer
This is a great topic, and one that perhaps should be given stronger consideration IMO (especially by myself).
When I set mine up, I'll probably use LibreOffice or MS Access as a front end, with PostgreSQL as the engine since I have prior experience with the latter. I should add that PostgreSQL is a free, robust, enterprise-level DB which might be overkill for most here but you would never outgrow it.
Database design/setup can be rather complex- it is better to take considerable effort and get it right the first time. Just my opinion.
This is a great topic, and one that perhaps should be given stronger consideration IMO (especially by myself).
When I set mine up, I'll probably use LibreOffice or MS Access as a front end, with PostgreSQL as the engine since I have prior experience with the latter. I should add that PostgreSQL is a free, robust, enterprise-level DB which might be overkill for most here but you would never outgrow it.
Database design/setup can be rather complex- it is better to take considerable effort and get it right the first time. Just my opinion.
If you have experience with PostgreSQL, working with PostGIS would be an easy transition, and a worthwhile endeavor. Using QGIS which supports PostGIS databases natively, would provide a graphical solution, as well as spatial relationships that would be easily queried, and viewable.
I agree that there can be consider effort in designing a project management database, but I am constantly amazed at how quickly a great deal of work can be accomplished, through a properly set up spatial database.
I am also constantly amazed at how many surveyors cringe in fear when the word or term GIS is used.
The funny thing to me is how many people use Google Earth and other free imagery providers and only place a pin on a location, when with about two more minutes of effort they can place that pin, properly projected, with complete project information within Federal, State, Local, and private boundaries, along with PLSS, Found Monuments, terrain, hydro, land use, mineral, and just about any other information available, and have all of this information overlaid on imagery which can then be exported to GEOPDF, or Geo-referenced images.
I understand the philosophy of "getting out of it, what you put into it" but I have found I have gotten much more out of GIS, and database management systems than what I have put into them.
This is a great topic, and one that perhaps should be given stronger consideration IMO (especially by myself).
When I set mine up, I'll probably use LibreOffice or MS Access as a front end, with PostgreSQL as the engine since I have prior experience with the latter. I should add that PostgreSQL is a free, robust, enterprise-level DB which might be overkill for most here but you would never outgrow it.
Database design/setup can be rather complex- it is better to take considerable effort and get it right the first time. Just my opinion.
If you have experience with PostgreSQL, working with PostGIS would be an easy transition, and a worthwhile endeavor. Using QGIS which supports PostGIS databases natively, would provide a graphical solution, as well as spatial relationships that would be easily queried, and viewable.
I agree that there can be consider effort in designing a project management database, but I am constantly amazed at how quickly a great deal of work can be accomplished, through a properly set up spatial database.
I am also constantly amazed at how many surveyors cringe in fear when the word or term GIS is used.
The funny thing to me is how many people use Google Earth and other free imagery providers and only place a pin on a location, when with about two more minutes of effort they can place that pin, properly projected, with complete project information within Federal, State, Local, and private boundaries, along with PLSS, Found Monuments, terrain, hydro, land use, mineral, and just about any other information available, and have all of this information overlaid on imagery which can then be exported to GEOPDF, or Geo-referenced images.
I understand the philosophy of "getting out of it, what you put into it" but I have found I have gotten much more out of GIS, and database management systems than what I have put into them.
Thank you very much for this information- you may have saved me substantial time by not having to re-invent the wheel where applicable.
You are welcome!
If I can be of any assistance, feel free to contact me.
What I would suggest is eliminating the front end, (Access or Libre Office) and simply do all of the database management within QGIS, and the PostGIS tables.
If you simply wish to work with flat files, Spatialite is also available within QGIS, and it is very easy to work with.
Joins, and relationships are very easy no matter which database engine you choose, and the developers on all fronts are making improvements constantly.
You can search "My Places" in Google Earth if you use the search window in the bottom of the "My Places" pane (not the one at the top of the program).?ÿ Works really well, I just tried it.
I was experiencing Google Earth slowdowns and crashed myself a while back, so I started paring down what I permanently kept to native Google Earth conent > Folders, paths, polygons, and associated text that I entered and photos that I linked.?ÿ This resulted in the program remaining perfectly stable.?ÿ Other content generated from outside sources like CAD, ESRI, Trimble, Websites etc.?ÿ I saved in a separate Folder and only loaded temporarily.?ÿ I think those are the source of the corruption.
I couldn't function without Google Earth!?ÿ
?ÿ
?ÿ
?ÿ
WOW!?ÿ How in the world did I NOT know about the lower search bar????ÿ SHeesh!?ÿ I use google earth for a TON of stuff, and have used geocoders to convert all my spreadsheet project data to placemarks, along with bench runs, published control, etc.?ÿ ?ÿ Thanks for the tip!?ÿ?ÿ
Another thing I've been doing for a really long time is to keep the project details in a google doc, get the shareable link and embed the shareable link in the google earth placemark.?ÿ I use a workflow where pins are projects without solved boundaries (stakeout, scanning, monitoring, etc.), and anytime I solve a boundary I export all of the solved lines between found monuments (even tie lines) to the google earth project folder.?ÿ Some of my tie lines are pretty long and I can tell at a glance when estimating a new project if I've been in the area before.
I use SWMBO
?ÿ
You are welcome!
If I can be of any assistance, feel free to contact me.
What I would suggest is eliminating the front end, (Access or Libre Office) and simply do all of the database management within QGIS, and the PostGIS tables.
[SNIP]
I will definitely look into QGIS and PostGIS since they can read PG natively. Thank you.
One way of looking at your files is that you already have a database of information.
You need a program that will find what you are looking for within your pile of electronic data.
In the early to mid 80s I created a spreadsheet file with DBase 3, an early DOS spreadsheet program, with 13 fields that would locate the paper file of any office info in the area of a parcel to be surveyed.
It took many hours of down time to manually enter all the paper data into the spreadsheet and it paid off.
When finished I could type in an abstract number and have a list of everything we had on file in that survey.
I will definitely look into QGIS and PostGIS since they can read PG natively. Thank you.
You are welcome.
PostGIS is a bunch of spatial extensions built onto PostGRE.
QGIS is the friendliest way to visualize them.
If you are still looking for a front end for a database (Access) contact me and let me know exactly what data you want to store and format(s) for anything specific to your filing system.
I have an Access database that I have been using for 20+ years to store my job data.?ÿ We can search by job number, client name, street, town and any combination of therein.?ÿ Once the front end and macros are built there really isn't anything easier or better than Access.?ÿ I'd be willing to modify what I'm using for your use.
?ÿ
If you are still looking for a front end for a database (Access) contact me and let me know exactly what data you want to store and format(s) for anything specific to your filing system.
I have an Access database that I have been using for 20+ years to store my job data.?ÿ We can search by job number, client name, street, town and any combination of therein.?ÿ Once the front end and macros are built there really isn't anything easier or better than Access.?ÿ I'd be willing to modify what I'm using for your use.
?ÿ
Message sent
