survey database program

Techniques, equipment and issues. Also visit the NSS Survey & Cartography Section.

Moderator: Moderators

survey database program

Postby gindling » May 5, 2014 2:27 pm

I was told to move this here for better topic enjoyment.

I was wondering what program people use for their cave surveys. The Montana Cave Survey is on Excel, though I feel it could be better, and I am about to compile all of our Peru points and descriptions which are just a word doc right now.

So is there a program you all use or recommend? I like the one line system of the TCS for quick reference but I would also like to have embedded links for an image of a map, entrance photo, detailed narrative, etc. And if it was searchable that would also be a bonus, for instance, all caves that have a hundred foot pit in Missoula County.

arcGIS would have many of these features I would think, but its an expensive program from what I've seen.

Thanks!
User avatar
gindling
NSS Hall Of Fame Poster
 
Posts: 235
Joined: Nov 17, 2008 3:40 pm
Location: Montana
NSS #: 53629
Primary Grotto Affiliation: Northern Rocky Mountain Grotto
  

Re: survey database program

Postby trogman » May 5, 2014 3:42 pm

AL uses Excel, although all the data is on the website in searchable format, not sure what. Excel works good for me; allows me to manipulate data easily and then convert to CSV as POIs, which I load in my GPS. If you want to know all the 100'+ pits in Jackson County, you can simply use the data filter.

Trogman :helmet:
User avatar
trogman
NSS Hall Of Fame Poster
 
Posts: 977
Joined: May 2, 2008 8:35 am
Location: North Alabama
Name: Stephen Brewer
Primary Grotto Affiliation: Gadsden Grotto
  

Re: survey database program

Postby batrotter » May 6, 2014 4:12 am

The Indiana Cave Survey uses some sort of SQL. Our last database was in MS Access.
batrotter
NSS Hall Of Fame Poster
 
Posts: 530
Joined: Sep 6, 2005 9:20 am
Location: Columbus, Indiana
Name: Bruce Trotter
NSS #: 27849RL
Primary Grotto Affiliation: Indiana Cave Survey
  

Re: survey database program

Postby Leclused » May 6, 2014 6:33 am

I use Speleobase. a speleo application written and maintained by P de Bie, a caver from Belgium..

Everything you need to know can be found here : http://www.scavalon.be/avalonuk/software/speleobase.htm

I think most of your requiremens will be fullfilled and much more.

Have fun.
User avatar
Leclused
Prolific Poster
 
Posts: 167
Joined: Oct 4, 2007 9:02 am
  

Re: survey database program

Postby Martin Sluka » May 6, 2014 8:20 am

I hope, Jeff will be not very angry. ;)

Everything is accesible after export from Therion to SQL database. It is standard export feature.
User avatar
Martin Sluka
NSS Hall Of Fame Poster
 
Posts: 383
Joined: Mar 17, 2006 11:28 am
Location: Prague, Czech Republic
Name: Martin Sluka
NSS #: 29010
  

Re: survey database program

Postby Chads93GT » May 6, 2014 10:56 am

Assuming all of the caves are mapped?
User avatar
Chads93GT
NSS Hall Of Fame Poster
 
Posts: 2294
Joined: Jun 24, 2008 1:27 pm
Location: Missouri
  

Re: survey database program

Postby gindling » May 6, 2014 11:30 am

I'm liking the SpeleoBase Leclused. You're right, it has all that I asked for and more, thanks for the link.
User avatar
gindling
NSS Hall Of Fame Poster
 
Posts: 235
Joined: Nov 17, 2008 3:40 pm
Location: Montana
NSS #: 53629
Primary Grotto Affiliation: Northern Rocky Mountain Grotto
  

Re: survey database program

Postby Leclused » May 6, 2014 2:03 pm

gindling wrote:I'm liking the SpeleoBase Leclused. You're right, it has all that I asked for and more, thanks for the link.


No problem to help other cavers is the moto of P de Bie :-) Feel free to pass the info in your speleo community.

Dagobert L'Ecluse (aka Leclused)
Antwerp-Belgium
www.scavalon.be
scavalon.blogspot.Be
User avatar
Leclused
Prolific Poster
 
Posts: 167
Joined: Oct 4, 2007 9:02 am
  

Re: survey database program

Postby rlboyce » May 6, 2014 6:54 pm

Check out Google Forms (http://forms.google.com/). You can setup a generalized questionnaire with inputs (Cave name, length, county, etc), and when the form is submitted it can upload the data into a properly organized Google Spreadsheet. Completely customizable. Shareable with anyone (or no one, if you prefer). Accessible from any device connected to the internet. Kind of cool. I am seriously considering doing this for myself.

If you know how to copy and paste, it sounds like you may be able add additional functionality to the Google Form with user scripts, such as uploading images as part of the questionnaire process (map, photos, etc.). It's not standard though.
http://stackoverflow.com/questions/1546 ... 2#15474002.

Here's something else that isn't quite the same thing, but is somewhat related:
http://www.labnol.org/internet/receive- ... ive/19697/

Sounds like there are some online database tools (not free) that incorporate image uploading as well. Could make it a little easier for you... for a price. Several services are mentioned in this thread: https://productforums.google.com/forum/ ... rhneYXs6sJ
Happiness can be measured in mud/in².
User avatar
rlboyce
NSS Hall Of Fame Poster
 
Posts: 727
Joined: Jan 22, 2010 7:26 pm
Location: Chambersburg, Pennsylvania
Name: Ryan Boyce
  

Re: survey database program

Postby gindling » May 6, 2014 8:48 pm

Is this a correct format to import into SpeleoBase Leclused? There is no length as it is just a pit.
Waypoint|cave name|depth|length|entrance type|coords|elevation|founder|surveyed?
BIRDAY|Birthday Pit|46.1||vertical|12 M 208701 9218946|4145m|Jim/john|Y
User avatar
gindling
NSS Hall Of Fame Poster
 
Posts: 235
Joined: Nov 17, 2008 3:40 pm
Location: Montana
NSS #: 53629
Primary Grotto Affiliation: Northern Rocky Mountain Grotto
  

Re: survey database program

Postby Leclused » May 7, 2014 1:06 am

gindling wrote:Is this a correct format to import into SpeleoBase Leclused? There is no length as it is just a pit.
Waypoint|cave name|depth|length|entrance type|coords|elevation|founder|surveyed?
BIRDAY|Birthday Pit|46.1||vertical|12 M 208701 9218946|4145m|Jim/john|Y


Hi,

Can you sent me a PM explaining what you are trying. Perhaps with some screen shots or sample data file ? Then I'll take a look at it tonight at home. It's a while ago that I did an import in Speleobase myself.

But when I look at the structure above I would think it's ok. Now back to the office work :grin:

Dagobert L'Elcuse
User avatar
Leclused
Prolific Poster
 
Posts: 167
Joined: Oct 4, 2007 9:02 am
  

Re: survey database program

Postby Leclused » May 7, 2014 1:01 pm

Gindling

I've tried the import starting from your sample data and had no problems.

First a few hints !
- Take a look in speleobase to the names of the fields that can be imported and the sequence. The sequence doesn't matter but if you make your text file in the same sequence as the standard import sequence from speleobase the ordering for import goes a lot quiker.Open "Text conversion wizard" in "import function", click on "ok" and you will see a screen with the coversion steps, in step 1 you see the list of all fields that can be imported.
- Try it out with a file with one or two caves in it and you will see that it is not difficult at all.

Now the import proces

step 1:
make a txt file from the data that you want to import divided by pipe. Try to match your columns already with the fieldnames from speleobase. That will make following step easier.
Now go to "import functions" in speleobase
step 2:
Use "Text conversion Wizard" to convert the txt to and import dBF file via speleobase. Follow the steps in Speleobase it is very simple
Step 3
Use the "Import Wizard" to load the import dbf file into speleobase. Follow the steps in spelobase, again very simple.

And finish


BR

Dagobert
Sc Avalon - Belgium
User avatar
Leclused
Prolific Poster
 
Posts: 167
Joined: Oct 4, 2007 9:02 am
  

Re: survey database program

Postby gindling » May 9, 2014 12:20 pm

Thanks! I appreciate your help.

Unfortunately I don't have access so I am having to put in all the pipes by hand and delete unwanted data from when I exported the waypoints from Garmin Basecamp program, and there are @400 waypoints... but at least I dont have to enter all the coords by hand!

And I found the Replace function on the text program. Speeds things up considerably.
User avatar
gindling
NSS Hall Of Fame Poster
 
Posts: 235
Joined: Nov 17, 2008 3:40 pm
Location: Montana
NSS #: 53629
Primary Grotto Affiliation: Northern Rocky Mountain Grotto
  


Return to Survey and Cartography Forum

Who is online

Users browsing this forum: No registered users