JMP Analytics - Working with geospatial properties that also varies with timeHi all,
I need some ideas and help, please. I'm looking to work with some data that varies by geographical location and also with time. I have the latitudes and longitudes of the locations and I have the hourly measurements for several time periods. How do I set this up in JMP rows and columns, such that I can graph (map) the property as it changes with time, and investigate or have JMP highlight the locations where the property exceeds a certain threshold for certain time periods, etc., etc.?
Thanks for the help
AnalyticsRe: JMP Analytics - Working with geospatial properties that also varies with timeYou will want to set the data up where you have columns for the time, latitude, longitude and any measurement. There needs to be separate rows for each of the time, location instance.Re: JMP Analytics - Working with geospatial properties that also varies with timeA perhaps useful and informative template can be found right within the JMP Sample Data Directory. It's a Graph Builder based visualization of Napolean's March. I think the data table is called NapoleansMarch.jmp or something similar. It shows a background geographic map, and shows how variables (the size of Napolean's various armies) changed over that geographic space in size. Might come close to what you are after?
Here's a link to an HTML output from the script that generates the plot...take a look and see if it's kind of like what you are after? Napolean's March HTML Output
Re: JMP Analytics - Working with geospatial properties that also varies with timeAfter setting up as Jim suggests, you can use the local data filter to see a time slice, or a latitude slice, or both, etc, in maps and other reports.
Re: JMP Analytics - Working with geospatial properties that also varies with timeThanks for the pointers. I've also taken a look at the Napoleon's March JMP table. And the visualization of Napoleon's March is similar to what I'm trying to create.
But my problem is I have only about 40 locations (40 latitudes and longitudes) but I have over 50,000 measurements (recorded hourly for over 5 years).
So, I set up the Time_stamp as the first column and the measurement associated with each location as additional columns. I'm not sure now how to associate the Lat's and Long's with each measurement.
The Napoleon's March JMP table has Latitude and Longitude as columns, but that's not "practical" in this case, I don't think.
I'd appreciate further help, please.
Re: JMP Analytics - Working with geospatial properties that also varies with timeYou could place the 40 latitudes and longitudes into a separate table, and then use a virtual join to bring them back together, but even with that, you will have to have a column that matches the rows. The end result will be a virtual table that has each latitude and longitude in each row.
