nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Internet open from a table with multiple query (drop-down search)

gridge

Hello,

I am trying to import data from this website: http://www.naturalheritage.state.pa.us/Species.aspx into JMP but would only like the Plant data for all of PA. When I try internet open I only get a table with the data from the first category in the drop-down search (Reptiles & Amphibians). Is there a way to get the plant data table?

Accepted answers

pmroz

Poor man's solution: select all of the data in the Plants table on the website. Had to start the selection from the bottom, selecting in an upward direction until all table cells were highlighted. Couldn't get the column headers swiping down. Hit CTRL-C. Open a new JMP table and click on Edit > Paste With Column Names.

All comments

briancorcoran

Are you using File->Internet Open and specifying "Data" as the type in the drop down, not Web Page? It should present a dialog with three tables. If you import them, you should have one with plants (the images do not import).

Brian Corcoran

JMP Development

Plant Table

briancorcoran

I should have also mentioned that if you run the "Load pictures..." table script the thumbnails will be imported.

gridge

Hi Brian,

Look at your table though, it just has the reptiles and amphibians. The plant list should at least have a couple hundred entries.

briancorcoran

Sorry about that. I should have examined the results closer. The plant table is a dynamic table that is populated after specifying a dropdown item. Since it does not have a dedicated, static link, it probably will not be possible to obtain from this site at least.

Brian

pmroz