search

kevinrae / mosskey

Multiple entry key for North American Mosses
0 stars 0 forks source link

eFloras Taxon ID Numbers and DETAIL page #35

Open stephenprae opened 6 years ago

stephenprae commented 6 years ago

I have started the process to obtain the ID numbers to put into URLs for linking our DETAIL page to the taxon page in the FNA website. Assumption: URLId is the place in the TAXA table where the FNA taxon ID number goes.

kevinrae commented 6 years ago

Assumption is incorrect. Stop!

We are storing complete URLs in the URL table.

For example:

SELECT * FROM URL;

"id";"Name";"AltText";"Description";"Type";"TimeStamp"
"1";"http://www.efloras.org/florataxon.aspx?flora_id=1&taxon_id=200000987";NULL;NULL;"other";"2017-03-05 14:43:32"
"2";"http://www.efloras.org/florataxon.aspx?flora_id=1&taxon_id=250099223";NULL;NULL;"other";"2018-03-08 12:56:05"

You need to gather complete URLs.

The URLid in the Taxa table refers to the URL.id column from the URL table. (See above). Make sense? If not, we need to discuss.

stephenprae commented 6 years ago

Have not yet begun to assemble info. Understand the URL table now. A good way to make sure the URL is easy to dissect. My assumption could easily lead to errors and losing necessary parts of the URL. Your solution best.

On Tue, Apr 3, 2018 at 16:58 kevinrae notifications@github.com wrote:

Assumption is incorrect. Stop!

We are storing complete URLs in the URL table.

For example:

SELECT * FROM URL;

"id";"Name";"AltText";"Description";"Type";"TimeStamp" "1";"http://www.efloras.org/florataxon.aspx?flora_id=1&taxon_id=200000987";NULL;NULL;"other";"2017-03-05 14:43:32" "2";"http://www.efloras.org/florataxon.aspx?flora_id=1&taxon_id=250099223";NULL;NULL;"other";"2018-03-08 12:56:05"

You need to gather complete URLs.

The URLid in the Taxa table refers to the URL.id column from the URL table. (See above). Make sense? If not, we need to discuss.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/kevinrae/mosskey/issues/35#issuecomment-378436358, or mute the thread https://github.com/notifications/unsubscribe-auth/AjUNqnQ9CmsxoVRRdVYw4pGuDIXv1Z39ks5tlAyxgaJpZM4TF6R- .

-- Stephen P. Rae, Bryologist - Plant Ecologist Napa Valley California