Jump to content

Ziphius

Members
  • Content Count

    184
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ziphius

  • Rank
    member

Profile Information

  • Industry
    Marine Science
  • Gender
    Male

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I've re-attached a much-simplified database with only the tables needed to address my problem. I'm hoping this will help to get some type of guidance on mapping these animal positions in a web viewer instead of in a scatter plot as I have it. I did leave in the EasyMaps layouts and scripts in case this would work but I have not been successful in replacing the Contacts table that is mapped with my animal locations. I'm really hoping someone in this forum can provide some guidance. Thank you. Plotting_Multiple _Lat_Lon_Positions.fmp12.zip
  2. Hi all, Really hoping someone can help me with this database. It is being used to collect marine mammal data from aerial surveys. Each survey has many environmental records and each environmental record can have many sightings. Because the iPad GPS is not very reliable for elevation, I import a separate table of GPS waypoints from an external GPS and use Lookup to pull Latitude and Longitude and Altitude information based on matching or near matching timestamps. Some formulas use the GPS information (i.e. plane position) and an angle to the sightings to create a position for the sighting. I would love to map the GPS positions and the sighting positions in a WebViewer (Google Maps). Having different icons colors for different species or labels would be great as well. I added the EasyMaps layouts and scripts but I am not proficient enough to know how to modify that to show the sighting information. The best I could do was plot the latitude and longitudes in scatter plots. Is anyone willing to assist? It's for a great cause - the aerial surveys are needed to get an abundance estimate of humpback whales in Hawaii, an urgent need given anecdotal evidence over th past two years suggesting they are in decline. File attached. Much appreciated. Maui_Nui_Aerial_Survey_Data_Collection_FEB2019.fmp12.zip
  3. Thank you, that did it. It wasn't a matter of looking for duplicate primary keys, it was to have someone compare the patterns on the manta ray belly with the rest of the catalog to make sure it is a unique pattern and not just a different photo of the same manta ray. I also removed the variable since it was an unnecessary step, as you pointed out. I also added a "Status" variable that can be changed from "Pending" to "Matched", that way when the user has completed matching a photo to the catalog, they can flag it as matched and move onto the next but the next photo only needs to be matched to the "Pending" photos. Basically if someone provides me with a photo they have taken of a manta ray, I would add it to the catalog but it would need to be compared with all the others to be sure its a unique animal and not a resight of an existing animal. If a match is found, that photo would just be nested in a new table (not created yet) as a resight with a date. Compare Photos Within Single Table 2.fmp12
  4. I don't understand why this is so complicated. I have a table of images. I want to show one image and compare it to all the other images in the table to be sure it's not a duplicate. So when I have the record I want to compare, I set the serial ID of that record into a global field and then create a container that should show only images where the global field matches the serial ID. Apparently I'm missing something. Your help would be greatly appreciated. Compare Photos Within Single Table.fmp12
  5. So I revisited the previous solution posted above, instead of importing key fields from the parent table first (Surveys table), I imported the primary and foreign keys from the sightings table first (grandchild table), then imported it's parent table by matching the primary key of the Environmental table with the foreign key of the sightings table and adding new records. Then did the same when importing the Survey table by matching its primary key with the Environmental table foreign key and adding additional records. With the flat table populated with all the primary and foreign keys, I could add whatever fields from any of the tables to the Flat Table Layout for export. This works but does require importing each table on its own. If there is a more automated solution, that would be great but this certainly gets at what I need. Merging_to_Flat_Table2.fmp12
  6. I posted about this before (see attached link) but was never really able to apply the solution successfully. This time I'm adding a file showing three related tables (parent, child, grandchild). The client wants one spreadsheet with all the data in it. In other words, the parent records will repeat for each child record and so on. When I export by simply grabbing the fields I need, I need to drag down the resulting export table to fill in those repeating fields, which is time consuming. If there is a way to script the process to have a one button solution, that would be superb. Merging_to_Flat_Table.fmp12
  7. Wow, I'm always amazed how you guys figure this stuff out with the simplest solution, this is great, and I truly appreciate you attaching an example file, which makes it easier for me to wrap my head around it.
  8. Would you mind providing a suggestion on how the script would work, especially for the "value setting" portion? Thanks!
  9. I have a couple of issues with the attached "mock" database and hoping to get some resolution here. I have aerial survey data. Surveys are conducted each day and each day several legs are flown (one to many relationship). Legs can be "on effort" or "off effort" and the duration of the leg is the time between the next leg timestamp and the current leg timestamp unless its the last leg of the day. A timestamp is created whenever the leg effort status changes (each new record). My objective is to total the amount of time flown "on effort" and "off effort" separately for each survey day (sub-summary when sorted by Survey day). Sometimes survey data are imported from another iPad so the unique serial fields (record numbers) may not be in chronological order. Since the GetNthRecord function is dependent on the sort order, the values aren't always the same. Other issues I am having are dealing with time and timestamp formats when using calculations, I can't seem to get them to look right. Clear as mud? Any assistance would be appreciated. GetNthRecordCalculationProblem.fmp12
  10. Ahh yes, simply copying the html global code seems to work and this then populated the Source global field. THANK YOU!
  11. I'm really struggling with the coding here, maybe someone can help. I've attached the stripped down version to show just geographic coordinates from the source provided (https://community.filemaker.com/docs/DOC-3321 ) but when I try to recreate those elements, I can't seem to get the plotting to work. I've attached the working file and the non-working file. To me they both seem identical. Can anyone tell me what is missing in the non-working file? Thanks. Mapping_Multiple_GPS_Points_Copy_Broken.fmp12 Mapping_Multiple_GPS_Points_Good.fmp12
  12. This is a great reference, thank you. Trying to wrap my head around the coding but it certainly is a solution that would work for me.
  13. Is there an easy way to plot these tracks in Google Maps in a Webviewer rather than a chart? Incidentally, this is a FM13 Advanced file version so not all records get plotted in the chart (apparently there is a limit in older versions, just FYI). Chart_Plotting_Multiple_GPS_Points.fmp12
  14. If by chance you know of an easy way to plot those tracks in Google Maps in a Webviewer, that would be sweet but I realize this question may not fall under the purview of "charting".
  15. Aahhhh, look's like I need to upgrade, thank you sir!
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.