It is currently July 23rd, 2014, 2:33 pm

All times are UTC - 8 hours




Post new topic Reply to topic  [ 89 posts ] 
Go to page 1, 2  Next
Author Message
 Post subject: How to enter data into the NAHERP.com Database
PostPosted: January 1st, 2011, 1:59 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
Your data entries are safe in the database and YOU control who sees the information. Data can only be viewed down to county level; no specific locales can be viewed by others online or elsewhere. Here's a few simple pointers on how to add data quickly to the database:

1) Go to http://www.naherp.com
2) Register
3) Click on "Add Record"
4) Fill in all the blanks (date and time can be found on your digital pic or approximated by the month and year for slides or prints)
a) gps is entered by clicking on the little tiny wrench symbol above the latitude box. dial into the map that pops up until you get to the spot, then click once.
b) adding accurate gps eliminates the need to fill in the locality or elevation, but many choose to do this also.
c) Determine whether your entry is "non-sensitive", "sensitive", or "closed". I seldom use "closed" unless I'm really, really cautious about who gets that data, so if you are very protective of an entry, use "sensitive" or "closed". At the bottom of the form there is a box that says "Restrict public access to this record." Use this box to protect the county name or date from public viewing. This should only be done if the county is small and you fear someone might find you favorite spot, or if you want an odd date kept from public knowledge (like way early in the season or something most people are just not aware of and you want to keep it that way). Then, no one but you will see anything but the name of the animal, photo, and state name. You will need to give permission for those entries to be released. If you mark an entry as "Non-sensitve", you will not need to give permission for the data to be released for an approved reason. I usually only restrict public access to entries I consider at risk for one reason or another...like Mtn Kingsnakes, certain turtles, SF Garters, certain Cal King morphs, etc, and only for rare circumstances. For example, everyone knows April is a good month to see Mtn Kings, but I might find one at a weird time of year, so I restrict that entry. Use your own judgement.
5) Upload picture from the "choose file" button, fill in the Quantity box to reflect the number of animals in your voucher pictures, note any extra animals you saw but did not photo in the notes section. For example: You vouchered 1 Cal King, but saw 3 (2 got away), so you write in the notes section "2 more seen but not vouchered".
6) Add any notes you want
7) Click "Submit"
8) To add another record for the same species, click the "copy" symbol at the top of the finished entry page (left of the red "x"). This will copy your last entry onto a new entry form. Just add the new photo, new time and date (if different), new "Age" (if different), new gps coordinates, and click "submit" and you are done with a new entry. This technique works well if you have multiples of the same species to enter or even different species from the same spot (just change the species name).
9) When you finish adding all your records, click on "My Records in Google Earth" and save it. Then, open it, and you will see little icons in your google earth map that represent each of your entries. Mine looked like this two years ago:

Image

Remember, the gps cannot be seen by anyone but you, and you will not have to fill in the elevation or locality sections of the entry form unless you really want to.
Good luck...and get that data into the database.


Last edited by Brian Hubbs on January 4th, 2014, 9:56 am, edited 14 times in total.

Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 1st, 2011, 5:19 pm 
User avatar

Joined: June 8th, 2010, 12:40 am
Posts: 3132
Location: Pennsylvania- Bucks Co. near Phila.
Thanks Brian,

I forgot.





Thanks for taking the time to post this. :thumb:


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 1st, 2011, 5:46 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
I just figured there might be a few people out there that might benefit from some instructions. Glad to help in my little limited way.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 1st, 2011, 6:36 pm 
User avatar

Joined: November 25th, 2010, 2:00 pm
Posts: 363
Location: Long Beach, CA
Thanks for the info Brian. As I'm new on here and wanted to contribute to the database in the coming year but was curious how to gather the GPS data from Google earth since that's what I'm going to be using.
Hopefully dedicating all my camping/backpacking trips this year around herps will yield some good finds.


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 1st, 2011, 8:22 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
You're welcome...


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 1st, 2011, 9:01 pm 
User avatar

Joined: June 16th, 2010, 7:09 am
Posts: 414
Location: Santa Cruz Co. California
Thanks Brian, I was having some trouble with this as well. Time to make some entries.


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 1:05 am 
User avatar

Joined: June 10th, 2010, 11:17 am
Posts: 1078
(oh... you're such a sweetie)

I was actually wondering how to contribute.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 2:16 am 
User avatar

Joined: June 7th, 2010, 7:39 am
Posts: 2731
This was great Brian, but I do want to add my own opinion on a couple things:

If you don't know an exact date and "guess", I think it would be proper to state that in the notes (as in, sighting was made the 2nd week of February, I'm not sure about the exact day). Or you can just enter the month and year. Guessing without noting that it was a guess may lead to inaccurate information - a researcher might check the weather for that (potentially incorrect) day and think that Tiger Salamanders were moving in especially cold conditions, for example.

Adding elevation is easy if you have the GPS already. There are some cases where the elevation may give away a locality, but I think in those cases it would be better to just make it a non-public record rather than leave something out of the data. Most of the time it's nice to have there. And by including both elevation and locality, you help provide a backup in case the GPS is incorrect. Some museum records have had incorrect GPS entries caught because the locality/elevation was correct.

The "copy" function works well not only for multiples of the same species, but also for different species when they are found on the same day and at the same locality.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 7:16 am 
User avatar

Joined: June 7th, 2010, 6:40 pm
Posts: 339
Thanks for posting this. I think this should be a sticky!


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 11:06 am 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
I sent Scott a PM about making it a sticky...but I haven't heard back yet...HELLO...SCOTT...where are you...?
Jonathan: I made an edit to stress your points (slightly). I am still not going to add elevation or locality if I plug in the correct gps. It's redundant.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 11:56 am 
User avatar

Joined: June 7th, 2010, 9:48 am
Posts: 2350
Location: Delmarva
jonathan wrote:
And by including both elevation and locality, you help provide a backup in case the GPS is incorrect. Some museum records have had incorrect GPS entries caught because the locality/elevation was correct.


Good points Jonathan.

As for only entering GPS, you might think "hey I double checked that is was correct so I dont have to worry about entering a locale." But the problem with that is the people you send the data to dont know how you inputted the data or whether you double checked where the GPS was on a map. All they see is a string of coords, and a number string has a much greater chance for typos than a word string in a locality field. But if you provide a geo-referrence in the locality field it removes the doubt in the GPS coords and serves as a quality control for the people using your records. A record with both GPS and locale is regarded as higher quality than "lazy" records that only have GPS.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 1:14 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
It says in the record that the gps was from google earth.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 1:37 pm 

Joined: June 8th, 2010, 7:12 am
Posts: 6908
Location: Hesperia, California.
Also, if you're not primarily concerned with winning a contest... you CAN include one or two voucher shots (but equal to the quantity box) and put something like; 'two of twelve seen at this locality' in the comments box. Just saying.... you don't HAVE to make an entry for each and every herp you see, in the case of multiples.... :D jim


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 2:37 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
A picture is worth a 1000 words, so I enter everything I see, unless it's a bunch of ringnecks under the same rock...then I just take a pic of all of them and enter the number. But, sometimes I photo every salamander under a single board separately...


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 3:15 pm 
User avatar

Joined: June 8th, 2010, 12:40 am
Posts: 3132
Location: Pennsylvania- Bucks Co. near Phila.
hellihooks wrote:
Also, if you're not primarily concerned with winning a contest... you CAN include one or two voucher shots (but equal to the quantity box) and put something like; 'two of twelve seen at this locality' in the comments box. Just saying.... you don't HAVE to make an entry for each and every herp you see, in the case of multiples.... :D jim



:thumb:
http://www.naherp.com/viewrecord.php?r_id=31881


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 3:41 pm 

Joined: June 8th, 2010, 7:12 am
Posts: 6908
Location: Hesperia, California.
kyle loucks wrote:
hellihooks wrote:
Also, if you're not primarily concerned with winning a contest... you CAN include one or two voucher shots (but equal to the quantity box) and put something like; 'two of twelve seen at this locality' in the comments box. Just saying.... you don't HAVE to make an entry for each and every herp you see, in the case of multiples.... :D jim



:thumb:
http://www.naherp.com/viewrecord.php?r_id=31881

Exactly my point... :thumb: Now THAT'S a quality entry... I'm sure any researcher would rather see that than have to open 26 'single entries' We need to be concerned with quality as well as quantity... :thumb: jim


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 6:59 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
It is a quality entry, but not a good contest entry...he missed 25 points... :lol:


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 8:06 pm 
User avatar

Joined: June 7th, 2010, 7:39 am
Posts: 2731
Brian Hubbs wrote:
I sent Scott a PM about making it a sticky...but I haven't heard back yet...HELLO...SCOTT...where are you...?
Jonathan: I made an edit to stress your points (slightly). I am still not going to add elevation or locality if I plug in the correct gps. It's redundant.


Thank you. It's a decent compromise. Like Nate said though, putting both GPS and locality is a quality check for future researchers - it helps stress that you really did find that rattler there.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 2nd, 2011, 9:46 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
I don't think anyone is going to dispute a rattler entry... :lol:


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 12:21 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
This needs to stay at the top


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 3:49 pm 

Joined: June 8th, 2010, 7:12 am
Posts: 6908
Location: Hesperia, California.
Brian Hubbs wrote:
This needs to stay at the top

No... it doesn't... wait...AW CRAP!!! :lol: :lol: :lol: jim


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 4:55 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
Do you want people to learn to enter data, or not? :lol:


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 6:10 pm 

Joined: June 8th, 2010, 7:12 am
Posts: 6908
Location: Hesperia, California.
Brian Hubbs wrote:
Do you want people to learn to enter data, or not? :lol:

yes. did you really not get that by saying no..it doesn't... i moved it back to.... ahhhhh never mind... :lol: :lol: :lol: jim


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 6:27 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
I got it, but you've been giving me such a pain lately that I just thought I'd frustrate you a little... :twisted:


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 6:44 pm 

Joined: June 8th, 2010, 7:12 am
Posts: 6908
Location: Hesperia, California.
So... it wasn't a clever ploy to get me to reply, thus keeping this topic at the top? CRAP!!! I did it again.... :roll: you are SUCH a clever fella.... :lol: :lol: :lol: jim


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 8:02 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
Yup...


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 8:20 pm 
User avatar

Joined: June 8th, 2010, 5:29 pm
Posts: 2550
Location: I love L.A.
Nope....


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 3rd, 2011, 11:03 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
Yup...


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 4th, 2011, 11:51 am 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
Yup...


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 4th, 2011, 11:56 am 
User avatar

Joined: June 8th, 2010, 5:29 pm
Posts: 2550
Location: I love L.A.
Nope...


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 4th, 2011, 11:56 am 
User avatar

Joined: June 8th, 2010, 5:29 pm
Posts: 2550
Location: I love L.A.
Ok maybe sometimes.


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 4th, 2011, 5:08 pm 
User avatar

Joined: June 7th, 2010, 5:14 am
Posts: 1516
Location: San Clemente, CA
GREAT POST Mr. Hubbs. :thumb:
Thank you for taking the time to put all of that together.
I'm sure it will help a lot of folks.


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 4th, 2011, 5:13 pm 
User avatar

Joined: June 7th, 2010, 9:48 am
Posts: 2350
Location: Delmarva
And now we have 2 copies of this post in this forum.

I knew it would get moved, but I thought it would get booted to the boardline.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 6th, 2011, 12:47 pm 
User avatar

Joined: June 7th, 2010, 10:14 pm
Posts: 2617
Location: San Antonio, TX
Some other useful (?) Google Earth user's addenda from someone who did a lot of this last year:

1. With Google Earth, you don't need to enter a push pin to get the GPS spot. Just double click or hold the mouse over the exact spot and the Lat and Long and elevation of that spot will appear on the bottom of the screen. BUT, if you move the mouse/cursor, you move the coordinates so be careful that you are positioned on the correct spot.

    Helpful ways to use this info -
    - 1a. If you have a wide screen, just open up Google Earth on one side of your screen and the NAFHA data entry form on the other side.
    - 1b. No wide screen? No problem. Open Google Earth full screen and the NAFHA entry page slightly less than full screen so you can see Google earth's coordinates at the bottom of the screen from below it.
    - 1c. If you have a Mac, buy a computer to enter data into NAFHA or figure it out yourself. :lol:

If you have already entered data without elevation, download the KML file and you can double click an entry and google earth will zoom there, giving the lat/long and elevation at the bottom of the screen.

2. It is a lot easier to enter the coordinates in the NAHerp entry fields as decimal values, not DD.MM.SS.
It is quicker to enter 40.175817 and -89.643858 than 40 10'32.94N and 89 38'37.89W (in case you found something in this plowed field near Luther, IL?).

To do this, in Google Earth, go to Tools, Options, 3D View, and choose Show Lat/Long as Decimal Degrees. Do the same on your GPS unit or just import you GPS coordinates into Google Earth with a USB cable.

3. Don't forget the minus sign on the longitude or you will end up with a bunch of Chinese entries. Make sure you check the validity of your records at this link - http://www.naherp.com/search.php?error=1

4. Export your records as a CSV file and open them up in Excel (or equivalent) ( http://www.naherp.com/user/export.php ). It is an easy way to check for missing data by sorting on particular columns, and it is a good backup of your data.

Thanks Brian for putting your "how to" together.

C


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 6th, 2011, 8:30 pm 
User avatar

Joined: June 7th, 2010, 10:41 am
Posts: 3759
Location: "Buy My Books"-land
Your welcome, and stay out of my plowed field at Luther, IL (actually, I think it's Mason City, and that's an awesome place to find corn)... :lol:


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 9th, 2011, 12:26 am 
User avatar

Joined: June 10th, 2010, 6:56 pm
Posts: 2732
Location: Litchfield Park, AZ
Great job Brian. I think each chapter should have a sticky link to this thread...


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 11th, 2011, 11:19 pm 
User avatar

Joined: August 24th, 2010, 9:14 am
Posts: 457
Location: San Diego
with this sticky we should get rid of the Add Records (bulk) so that we always have more complete vouchers and less short vouchers.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 11th, 2011, 11:50 pm 
User avatar

Joined: June 7th, 2010, 7:39 am
Posts: 2731
Nature Nate wrote:
with this sticky we should get rid of the Add Records (bulk) so that we always have more complete vouchers and less short vouchers.


I've never had much use for it anyway, and I've often entered a lot of records at the same time. Is there anyone who is still actually using it? I think the "copy record" function is so much more useful. If I flip a gopher and a ringneck at the same time, I just enter one with all the data, hit "copy record", change the species, age, sex, and upload the new voucher, and I'm done.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 12th, 2011, 6:54 pm 
User avatar

Joined: June 10th, 2010, 6:56 pm
Posts: 2732
Location: Litchfield Park, AZ
I'll have to try the "copy record" this season. It will sure help documenting all the uta's and atrox!


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 12th, 2011, 7:34 pm 
User avatar

Joined: June 7th, 2010, 5:14 am
Posts: 1516
Location: San Clemente, CA
As for me, I always thought the "copy record" function was created specifically for Utas and atrox. :thumb:


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 12th, 2011, 8:47 pm 
User avatar

Joined: June 7th, 2010, 7:05 am
Posts: 1022
Location: Albuquerque
don't forget sceloporus!

Josh


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 13th, 2011, 3:01 am 
User avatar

Joined: June 7th, 2010, 4:07 pm
Posts: 534
Location: Hillsdale County, Michigan
and Chrysemys.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 13th, 2011, 7:59 am 
User avatar

Joined: June 7th, 2010, 6:11 am
Posts: 5118
Location: Los Angeles County
Quote:
h this sticky we should get rid of the Add Records (bulk) so that we always have more complete vouchers and less short vouchers.


I've never had much use for it anyway, and I've often entered a lot of records at the same time. Is there anyone who is still actually using it? I think the "copy record" function is so much more useful. If I flip a gopher and a ringneck at the same time, I just enter one with all the data, hit "copy record", change the species, age, sex, and upload the new voucher, and I'm done.


I tried to get it removed, and I was shoot down.. Several people use it, personally I would like to get rid of it, that and the short form. There is no way to select method in those and DOR's are not entered correctly.

Fundad


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 13th, 2011, 8:02 am 
User avatar

Joined: June 7th, 2010, 9:48 am
Posts: 2350
Location: Delmarva
Perhaps a new voting system will help. 8-) I dont like the forms either. :x


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 13th, 2011, 9:07 pm 
User avatar

Joined: June 10th, 2010, 6:56 pm
Posts: 2732
Location: Litchfield Park, AZ
You know what would help me.... when a taxonomic change is put into the database drop down screen to perhaps add (formerly ______) [if it will fit]. I about went nuts with Bufos last year!

Dave


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 25th, 2011, 7:41 am 
User avatar

Joined: June 7th, 2010, 3:21 am
Posts: 3256
Location: Iowa
Steve Bledsoe wrote:
As for me, I always thought the "copy record" function was created specifically for Utas and atrox. :thumb:


Browns and garters actually.


Top
 Profile WWW 
 
 Post subject: Re: How to enter data into the Database
PostPosted: January 25th, 2011, 9:09 pm 
User avatar

Joined: June 10th, 2010, 6:56 pm
Posts: 2732
Location: Litchfield Park, AZ
I used the "copy" feature for the first time this past weekend. Very useful. However it makes it easy to repeat a stupid error that requires manually going back and editing each error individually. For some reason I thought the year was 1963. I had to manually reenter all the dates individually.. D'Oh!


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: February 22nd, 2011, 9:26 pm 
User avatar

Joined: February 20th, 2011, 1:38 pm
Posts: 223
Location: Alaska
Thanks for this post. It will help me greatly.

Now as far as the "copy record" button, it will come in really handy for my 113 C.c.cercombombus night.


Top
 Profile  
 
 Post subject: Re: How to enter data into the Database
PostPosted: February 22nd, 2011, 9:36 pm 
User avatar

Joined: June 10th, 2010, 6:56 pm
Posts: 2732
Location: Litchfield Park, AZ
Do you have a voucher photo of each of the 113? If not, I would just enter what you have vouchered and then notate in the notes section about the ones unvouchered.


Top
 Profile  
 
 Post subject: !~!
PostPosted: February 23rd, 2011, 7:50 am 
User avatar

Joined: June 7th, 2010, 9:54 pm
Posts: 538
Location: Deadhorse/California
yes :thumb: very cool


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 89 posts ]  Go to page 1, 2  Next

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to: