Page 1 of 2

How to enter data into the NAHERP.com Database

Posted: January 1st, 2011, 1:59 pm
by Brian Hubbs
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.

Re: How to enter data into the Database

Posted: January 1st, 2011, 5:19 pm
by kyle loucks
Thanks Brian,

I forgot.





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

Re: How to enter data into the Database

Posted: January 1st, 2011, 5:46 pm
by Brian Hubbs
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.

Re: How to enter data into the Database

Posted: January 1st, 2011, 6:36 pm
by Rothdigga
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.

Re: How to enter data into the Database

Posted: January 1st, 2011, 8:22 pm
by Brian Hubbs
You're welcome...

Re: How to enter data into the Database

Posted: January 1st, 2011, 9:01 pm
by Calfirecap
Thanks Brian, I was having some trouble with this as well. Time to make some entries.

Re: How to enter data into the Database

Posted: January 2nd, 2011, 1:05 am
by -EJ
(oh... you're such a sweetie)

I was actually wondering how to contribute.

Re: How to enter data into the Database

Posted: January 2nd, 2011, 2:16 am
by jonathan
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.

Re: How to enter data into the Database

Posted: January 2nd, 2011, 7:16 am
by Viridovipera
Thanks for posting this. I think this should be a sticky!

Re: How to enter data into the Database

Posted: January 2nd, 2011, 11:06 am
by Brian Hubbs
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.

Re: How to enter data into the Database

Posted: January 2nd, 2011, 11:56 am
by spinifer
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.

Re: How to enter data into the Database

Posted: January 2nd, 2011, 1:14 pm
by Brian Hubbs
It says in the record that the gps was from google earth.

Re: How to enter data into the Database

Posted: January 2nd, 2011, 1:37 pm
by hellihooks
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

Re: How to enter data into the Database

Posted: January 2nd, 2011, 2:37 pm
by Brian Hubbs
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...

Re: How to enter data into the Database

Posted: January 2nd, 2011, 3:15 pm
by kyle loucks
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

Re: How to enter data into the Database

Posted: January 2nd, 2011, 3:41 pm
by hellihooks
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

Re: How to enter data into the Database

Posted: January 2nd, 2011, 6:59 pm
by Brian Hubbs
It is a quality entry, but not a good contest entry...he missed 25 points... :lol:

Re: How to enter data into the Database

Posted: January 2nd, 2011, 8:06 pm
by jonathan
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.

Re: How to enter data into the Database

Posted: January 2nd, 2011, 9:46 pm
by Brian Hubbs
I don't think anyone is going to dispute a rattler entry... :lol:

Re: How to enter data into the Database

Posted: January 3rd, 2011, 12:21 pm
by Brian Hubbs
This needs to stay at the top

Re: How to enter data into the Database

Posted: January 3rd, 2011, 3:49 pm
by hellihooks
Brian Hubbs wrote:This needs to stay at the top
No... it doesn't... wait...AW CRAP!!! :lol: :lol: :lol: jim

Re: How to enter data into the Database

Posted: January 3rd, 2011, 4:55 pm
by Brian Hubbs
Do you want people to learn to enter data, or not? :lol:

Re: How to enter data into the Database

Posted: January 3rd, 2011, 6:10 pm
by hellihooks
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

Re: How to enter data into the Database

Posted: January 3rd, 2011, 6:27 pm
by Brian Hubbs
I got it, but you've been giving me such a pain lately that I just thought I'd frustrate you a little... :twisted:

Re: How to enter data into the Database

Posted: January 3rd, 2011, 6:44 pm
by hellihooks
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

Re: How to enter data into the Database

Posted: January 3rd, 2011, 8:02 pm
by Brian Hubbs
Yup...

Re: How to enter data into the Database

Posted: January 3rd, 2011, 8:20 pm
by Ross Padilla
Nope....

Re: How to enter data into the Database

Posted: January 3rd, 2011, 11:03 pm
by Brian Hubbs
Yup...

Re: How to enter data into the Database

Posted: January 4th, 2011, 11:51 am
by Brian Hubbs
Yup...

Re: How to enter data into the Database

Posted: January 4th, 2011, 11:56 am
by Ross Padilla
Nope...

Re: How to enter data into the Database

Posted: January 4th, 2011, 11:56 am
by Ross Padilla
Ok maybe sometimes.

Re: How to enter data into the Database

Posted: January 4th, 2011, 5:08 pm
by Steve Bledsoe
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.

Re: How to enter data into the Database

Posted: January 4th, 2011, 5:13 pm
by spinifer
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.

Re: How to enter data into the Database

Posted: January 6th, 2011, 12:47 pm
by chrish
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

Re: How to enter data into the Database

Posted: January 6th, 2011, 8:30 pm
by Brian Hubbs
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:

Re: How to enter data into the Database

Posted: January 9th, 2011, 12:26 am
by Biker Dave
Great job Brian. I think each chapter should have a sticky link to this thread...

Re: How to enter data into the Database

Posted: January 11th, 2011, 11:19 pm
by Nature Nate
with this sticky we should get rid of the Add Records (bulk) so that we always have more complete vouchers and less short vouchers.

Re: How to enter data into the Database

Posted: January 11th, 2011, 11:50 pm
by jonathan
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.

Re: How to enter data into the Database

Posted: January 12th, 2011, 6:54 pm
by Biker Dave
I'll have to try the "copy record" this season. It will sure help documenting all the uta's and atrox!

Re: How to enter data into the Database

Posted: January 12th, 2011, 7:34 pm
by Steve Bledsoe
As for me, I always thought the "copy record" function was created specifically for Utas and atrox. :thumb:

Re: How to enter data into the Database

Posted: January 12th, 2011, 8:47 pm
by herpseeker1978
don't forget sceloporus!

Josh

Re: How to enter data into the Database

Posted: January 13th, 2011, 3:01 am
by Curtis Hart
and Chrysemys.

Re: How to enter data into the Database

Posted: January 13th, 2011, 7:59 am
by Fundad
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

Re: How to enter data into the Database

Posted: January 13th, 2011, 8:02 am
by spinifer
Perhaps a new voting system will help. 8-) I dont like the forms either. :x

Re: How to enter data into the Database

Posted: January 13th, 2011, 9:07 pm
by Biker Dave
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

Re: How to enter data into the Database

Posted: January 25th, 2011, 7:41 am
by Don Becker
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.

Re: How to enter data into the Database

Posted: January 25th, 2011, 9:09 pm
by Biker Dave
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!

Re: How to enter data into the Database

Posted: February 22nd, 2011, 9:26 pm
by sjfriend
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.

Re: How to enter data into the Database

Posted: February 22nd, 2011, 9:36 pm
by Biker Dave
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.

!~!

Posted: February 23rd, 2011, 7:50 am
by M.J.FRANETOVICH
yes :thumb: very cool