Choose Language Hide Translation Bar
Highlighted
gridge
Level II

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

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?Picture1.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
pmroz
Super User

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

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.

 

Plants.png

View solution in original post

5 REPLIES 5
Highlighted

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

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 TablePlant Table

Highlighted

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

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

Highlighted
gridge
Level II

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

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.

Highlighted

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

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

Highlighted
pmroz
Super User

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

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.

 

Plants.png

View solution in original post

Article Labels

    There are no labels assigned to this post.