Fluvial Architecture Knowledge Transfer System (FAKTS): querying the database from the FRG website

1. Fluvial Architecture Knowledge Transfer System (FAKTS):querying the database from the FRG website Luca Colombera, Nigel P. Mountney, Marco Patacci Fluvial & Eolian Research Group – University of Leeds

2. Querying FAKTS • Two alternative ways to interrogate FAKTS: • WEB-BASED FRONT-END hosted on FRG website. • Easy to use, but of limited capability. • Queries can be run on the website without requiring download of software or data. • SQL QUERIES on MySQL. • More difficult to use, but it enables full database interrogation. • Queries are run locally, requiring download of software (MySQL and HeidiSQL) and database.

3. Web-accessible front end • Easy to use, • limited capability • of query: • depositional and architectural elements currently included; • dimension and transition data made available; • limited number of filters. • Further developments will follow.

4. Web-accessible front end Go to: http://frg.leeds.ac.uk/

5. Web-accessible front end Log in to ‘Sponsors’ Pages’

6. Web-accessible front end Select ‘FAKTS Database’ from left-hand panel

7. Web-accessible front end Excel spreadsheets containing example output retrieved from the fully-searchable version of FAKTS are available for download.

8. Web-accessible front end Excel spreadsheets containing example output retrieved from the fully-searchable version of FAKTS are available for download.

9. Web-accessible front end Excel spreadsheets containing example output retrieved from the fully-searchable version of FAKTS are available for download.

10. Web-accessible front end The menu-driven front-end can be accessed from the same page.

11. Web-accessible front end Queries can be formulated and run from this page.

12. Web-accessible front end (1) the scale of observation (scale of genetic unit) should be chosen from the right-hand panel.

13. Web-accessible front end Let’s say we are interested in large-scale depositional elements.

14. Web-accessible front end The number in brackets under the genetic-unit type tells us that 46 studies contain information at the depositional-element scale.

15. Web-accessible front end (2) the type of output (i.e. geometry or transition data) we are interested in should be selected next.

16. Web-accessible front end Let’s say we are interested in obtaining dimensional parameters.

17. Web-accessible front end Now we can filter the database on the parameters on which the depositional systems are classified (lower right-hand panel).

18. Web-accessible front end (3) Let’s say we are interested only in data from convergent tectonic settings.

19. Web-accessible front end (3) let’s say we are interested only in data from convergent tectonic settings: we get 22 case studies now.

20. Web-accessible front end (4) now, we want to further filter the database by selecting only systems from subhumid basins.

21. Web-accessible front end (4) now, we want to further filter the database by selecting only systems from subhumid basins.

22. Web-accessible front end 11 case studies are now left.

23. Web-accessible front end 11 case studies are now left: here you see them listed.

24. Web-accessible front end (5) let’s say that we want to exclude modern-river data from the South Saskatchewan: just click on (Remove) in its box.

25. Web-accessible front end The South Saskatchewan data has now been removed.

26. Web-accessible front end A summary of the filters applied and case studies considered is presented at the top of the central panel.

27. Web-accessible front end (6) now we can select the type of depositional element (channel-complex or floodplain) for which we want dimensional data.

28. Web-accessible front end (6) now we can select the type of depositional element (channel-complex or floodplain) for which we want dimensional data.

29. Web-accessible front end (7) now we only need to click on ‘download’ to obtain the Excel spreadsheet with the filtered channel-complex output.

30. Web-accessible front end The Excel spreadsheet with FAKTS output can now be opened or downloaded for analysis of channel-complex geometries.

31. Web-accessible front end The Excel spreadsheet contains both architectural data, listed separately for each individual channel complex, and metadata.

32. Web-accessible front end If we want to run a new query, we can reset the filters applied by clicking on ‘Reset Filters’, at the top of the right-hand panel.

33. Web-accessible front end The screen will appear as above, as a confirmation that the filters have been reset.

34. Web-accessible front end Let’s see another example: we want to derive lateral transitions statistics of CH architectural elements in braided systems.

35. Web-accessible front end (1) therefore we select the scale of genetic unit of interest, which is now ‘Architectural Elements’.

36. Web-accessible front end Now we need to select again the type of output: unit transitions.

37. Web-accessible front end (2) we therefore click on ‘Unit Transitions’.

38. Web-accessible front end Now we want to filter the database on river pattern, so that only braided systems are included in the query.

39. Web-accessible front end (3) we therefore click on ‘Braided’ under the ‘River Pattern’ filter.

40. Web-accessible front end Now, let’s say we only want to derive output from the highest-quality case studies: we can filter on case data quality index.

41. Web-accessible front end (4) we therefore click on ‘A’ under the ‘Dataset DQI’ filter.

42. Web-accessible front end (5) now we can select the direction of transition in which we are interested from the drop-down menu in the central panel.

43. Web-accessible front end (5) finally, we need to select the type of architectural element for which we want to derive transition statistics.

44. Web-accessible front end (6) now, we can download the Excel spreadsheet with the relevant output by clicking on ‘Down. Excel’.

45. Web-accessible front end The Excel spreadsheet with FAKTS output can now be opened or downloaded for analysis of CH lateral-transition data.

46. Web-accessible front end Again, the Excel spreadsheet contains the raw architectural data, each row represents a lateral transition to an individual element.

47. Web-accessible front end From these data, information can be derived in the form of transition counts, with which to obtain transition frequencies.

48. Web-accessible front end From these data, information can be derived in the form of transition counts, with which to obtain transition frequencies.

49. Web-accessible front end From these data, information can be derived in the form of transition counts, with which to obtain transition frequencies.

50. Web-accessible front end From these data, information can be derived in the form of transition counts, with which to obtain transition frequencies.