Rhacodactylus ciliatus database (playing with format)

[Hurley]

I've been playing with possible formats for putting up an online database for my cresties and potentially other users if they wish to use it.

I've got a rough start for a gecko's main page. It would have their assigned RCD number (assigned in order of registrants to allow the program to link any geckos from the same family tree), "registered name", and check boxes for phenotypes (sex, colors and patterns, and head shapes) to allow for searching the database. There will be a comments section for miscellaneous things not already included in the form, and links to the pedigree (text or pictoral). The database will also automatically link to RCD numbers for progeny, siblings, half-siblings, mother, and father.

The picture section would have 4 slots, 1 for an all-around general ID picture, 1 for a left lateral, 1 for a right lateral, and 1 for a dorsal shot. These could be updated at any time as the gecko ages simply by uploading new pictures.

Below is a screenshot of what I've come up with so far, anyone care to critique/make comments on anything that needs improvement? Any other colors/patterns I've missed?

http://cccorns.com/freepics/05Sep/Gecko.png

[Matthew Parks]

Looks great..............Good job! =D>

[Crested Lady]

That is EXACTLY what I've been thinking about. A friend of mine and I were working on one for awhile, but we were stumped on the layout. Looks AWESOME! :D

[max power]

i think that looks really nce but my only question would be what about the age progression pic's? since they change so much from hatchling to adult, it woulsd be nice to track what turns into what

[FrozenGecko]

that looks awesome, nice job!

How about adding hatch date?
Also under pattern - Blushing trait, knee spot/shin markings
And under Crest - Fur trait - for those really "Hairy" looking crests

[Hurley]

I could add in a couple more photo frames for keeping a couple stages of youngster coloration logged, or maybe put a link to a page with something like 4 photos for color progression stages.

Hmm, something to tinker with, thank you. :mrgreen:

[Hurley]

Ah yes, the blushers, yes, I meant to add that in.

I am unfamiliar with knee/shin spot patterning and didn't find it on a search. Are these shown somewhere?

If "Furry" or "Hairy" or something an "official" name for those hairy-crested ones?

There is always room in the "comments" section, as well, for maybe some of the less recognized traits, or some breeder's pet project to select for. :)

Yes, good call, I forgot the hatch date. Adding now.

[Hurley]

OK, I made a couple of those chages. The original picture has been changed to this new form.

Thanks for the comments, keep them coming. :mrgreen:

[KevinS]

I've got a comment: frickin awesome!
I already wanted more geckos, but if I had access to a database like that where I could keep tabs on family trees and stuff, my collection size might exceed my better judgement. I think it's a great idea.

[MintyHippo]

Awsome looking hey Sarah werent you trying to get every one on Repashy to help make one?

[DDReptiles]

Finally we get one rollin thank you :)

Looks Sweet

[Crested Lady]

Awsome looking hey Sarah werent you trying to get every one on Repashy to help make one?

Yup, Morkai and I were working on one for awhile. www.rhacdata.com/rd I did some graphics (the old one is still up there, I actually had another one that was going to replace it. Recognize Mike? Lol.) and we were working out the layout... but just never quite made it. I think she had school or something to deal with, and I since she had purchased the domain, I was unable to work on it and never got around to purchasing my own. Oh well, this one looks great though! EXACTLY what I was looking for. Great job! Keep it coming. :D [/url]

[Matthew Parks]

Incubation temp might be a nice addition.

[BadAssHerps]

man that is great I have alot of info logged and would love to use this! Also a few more traits could be added, such as
-raised dorsal crests
-red spots
-solid white tail
as well as deformities to map if they are dominant or rececive etc.
(not that I encourage breeding deformed cresteds but it would be intersting to find out as we could then acess the risk of passing on the said cosmetically negative trait.

just my 2 cents
-Eli

[Crested Lady]

LMBO! I like what you have written under the "Dam" section. Don't know why, but it really cracked me up. :D

[Hurley]

-raised dorsal crests
-red spots
-solid white tail
as well as deformities to map if they are dominant or rececive etc.
-incubation temp

Deformities can be :
A - A check box with a text write-in specific to this section. (With this option you can search for all deformities in the listing, but searching for a specific deformity will be hard across people's entries if they don't spell/write everything the same. The server is case sensitive and very selective.)

or

B - Like the pattern column where we list the most common ones and leave a checkbox for "Other - see comments" and rely on people to just fill in the less common ones."

If B, does someone have a list of most common deformities. Obviously the 6th toe thing, but what are other common ones needing tracking?


On incubation temp, would a write-in be best or would a list of check-box ranges with one box for "Fluctuating", maybe a text box after that allowing entry of the range of flutuation? Again, for searching, the check-boxes may be easier, but otherwise it can just be an entry of whatever the person wants to type in. Again, the search function is very selective, needing exact match on spaces, hyphens, etc.

If check boxes and ranges, how many categories do you think are necessary? 2 degree ranges? 3?

I'll go add in the others. :)

[Hurley]

OK, File changed again at the beginning.

I'll repost here so you don't have to go skipping back and forth to see it. :)

http://cccorns.com/freepics/05Sep/Gecko.png

Again, this is just layout tinkering. The actual online program will work very similar to http://cornguide.com/ACR if you wish to view the workable form of our Corn registry (minus the official registration part of things). The corn registry opened a few months ago, but already has over 2000 entries, so there are some that will have pedigrees with several generations in them. A couple with more info in them are:

http://cornguide.com/ACR/Registry.php?idnum=217
http://cornguide.com/ACR/Registry.php?idnum=1125

I am not fond of how the text pedigree at the bottom is displayed currently, too hard to follow, so this will be getting revamped, as well.

I hope to have the crested version ready to go this fall sometime for my own small collection and will be opening it up so others can have free use of it as well with full access to managing their own entries as they see fit. (vs. us managing the whole thing like with the ACR, preregistering clutches, getting out certificates, and all that work. LOL)

Right now I'm just trying to get format and categories down so we only have to program it once. Hehehe, unlike the total overhaul the ACR has taken multiple times. ](*,)

[Hurley]

Added a deformities section and also a "tail status" section.

Incubation temp section also added.

Background in place. :-k :mrgreen:

[Hurley]

(I guess I should state that the example is just an example, not a real record. ;) )

[Hurley]

Color Progression Page sample...


http://cccorns.com/freepics/05Sep/ColorProgression.png

[ArborealsEtc]

I have a guy working on a program now (last 2 mths) for all rhacs. Let me know if you are 100% sure you are going to run this crested reg and I will leave it out of mine and link to yours to help us all stay on the same page.

[Hurley]

Quite honestly, you are welcome to keep a database for all Rhacs including ciliatus. :D I am not trying to step on anyone's toes, here, just offering up something I'm doing for my own collection anyway. I am going to go through with my plans, either way, since my main goal was to have a record-keeping database to keep track of my future projects for ease of linking for parental info when I eventually sell some progeny. It's a format that works for me. (It has worked so nicely with the corns this year in the ACR.) If people wish to use it, they will, if they don't, I'll still have a great database that suits my needs. :)

It's being set up right now so that those inputting records have control over the information in those records and will manage the pictures, etc. We're working on the method of transferring records as geckos get sold. I want to make this as user-controlled as possible and it will mostly run itself. The information will be as good as the person inputting it.

The Rhac database is not a registry, per se. The corn registry does have control over information, assigns numbers, manages breeders lists, sends out registration certificates and certified pedigrees, etc. This project will just be a simple database. A central store of information accessible online by its users with free access and user-controlled entries. I hope people will use it, the more participation, the better, but I am not trying to register all Rhacodactylus ciliatus or be the authority on them. :) I just want to give people a place to compile information if they so choose.

[Hurley]

OK, here's the basic html shell for looks so far:
(The next step is adding all the links and php data base and programming...but it's a start. ;) )

Main Page:

http://cccorns.com/freepics/05Sep/RCDMain.html

General layout of the gecko's main page. Ignore the cheesey photos, they are just samples for layout.


Input Form:

http://cccorns.com/freepics/05Sep/RCDForm.html

Check out the drop boxes. I think it's a workable format. Not sure if I'm going to keep the numbers (from the Rhac book) on what constitutes crested vs. normal vs. reverted or not.


Color Progression Page:

http://cccorns.com/freepics/05Sep/RCDColor.html

This page will automatically add additional entries (up to 5 total) as you add them. Please ignore the cheesey pixelated sample shot, I was just working on size and placement. :mrgreen:

[FrozenGecko]

the whole thing is looking awesome!!

one thing that might be neat or even helpful with respect to maybe adding a growth chart, would to have them separated out depending on the types of diets that they are on, so you can compare growth rates and overall weight maintenance with the different diets that are currently available.

It would be a good tool for people to look back at which types of diets work best for certain factors (rapid growth, egg production, long term health, occurance of floppy tail or MBD etc.)

[RangerGrrl]

Hurley, it all looks great! I can't wait to see it in use.

I know you said it wasn't a formal registry, but if someone has a gecko from, say, Petsmart, is it going to be OK to register geckos of unknown provenance if they're used in a breeding program?

[DDReptiles]

So can we start inputting info on the site :)

[Hurley]

Nope, it's not ready yet, just getting started. This stuff is the easy stuff, the programming comes next. I'm hoping to have it up and running this fall, but it all depends on my schedule and when I find time to work on it. We will be moving the ACR (American Cornsnake Registry) to its own server and will be hosting the RCD (Rhacodactylus ciliatus database) on it as well. Probably be under something like HerpRegistries.com or ReptileRegistries.com or something, to keep them all together.

With the database, you guys will be in charge of your own info. Certainly you can register a crested from Pet Smart, just list the parents as Unknown. Family trees have to start somewhere and the babies from that crested WILL have a history, then. :mrgreen:

Anyway, thanks for the compliments, you guys will get to demo it as we go along and work out the bugs once the programming is in place.

[BadAssHerps]

=D> , Connie you need a round of applause! I can't tell you how exicted I am and I have a GOOD amount of info to put into this program.
Thanks,
Eli

[MrBoy]

=D> Can't wait to see it in action

[derekls]

Yeah looks pretty cool

[FrozenGecko]

Sounds great
I can't wait until it's ready to be used :)

[DDReptiles]

Thought I would give this thread a bump :D

Hey, anybody know when this thing will be usable???

[DDReptiles]

BUMP, what is going on with this??

[Reptile4life]

I have not heard anything yet DD but I am sure we will be hearing shortly.

[ReptileChick]

Wow, just read through and that would be awesome! Too bad I just printed off about 20 charts to use for this such thing...lol!

[Lance Carbuncle]

Anyone seen this? It hasn't been worked on for a year, but if it's ever finished it would be really cool...

http://www.genealogy.repashy.com/pedigree.php?personID=I70&tree=gecko

http://www.genealogy.repashy.com/kinship_results.php?s=1070&detail=1

http://www.genealogy.repashy.com/getperson.php?personID=I15&tree=gecko

Lance