Abstract
Management of Natural History collections, particularly paleontological collections, is usually structured around specimens. However, it might not be feasible when the collections are incorporated from sources where the whole cycle of specimen collection is unknown, making it hard to determine what fossils belong to a single specimen and if these specimens belong to a single fossil-assemblage, taxon or individual. The Sociedade de História Natural from Torres Vedras (Portugal) manages such collections using a management strategy approach based on the spatial location from where the fossils were found. To achieve this, we have implemented a methodology for field collection and developed a spatial database in PostgreSQL/PostGIS to manage the entire stages of paleontological collections management. On top of the database, a second layer of web services, Web GIS (Geographical Information System) applications, and desktop GIS, all based on QGIS, are also under development to facilitate access to data stored in the database to internal and external researchers and partners, as well public institutions. This effort is made in close collaboration with in-house actors and stakeholders and has yielded promising results. The development of this system provides four advantages: (i) it played an essential role in supporting the transfer of the collection to new storage facilities; (ii) it provides overviews of the distribution of the characteristics of the collections; (iii) it enhances institutional partnerships by providing consistent and reliable data and(iv) it supports the establishment and development of research lines.
Similar content being viewed by others
Introduction
Natural History collections hold the records of the history of life on Earth through collections of fossils that attest to the existence of a particular life form at a given time, including its evolutionary history, paleobiology and paleoecology, as well as data about the entire past ecosystems. Often, these life forms can be represented by a single whole specimen or a set of elements that can be assigned to a single specimen (e.g. a partial skeleton of a dinosaur). Constructing this record can be challenging, especially if the lineage of some fossils cannot be fully traced.
The Sociedade de História Natural (SHN), based in Torres Vedras (Portugal), is a non-profit scientific organization that manages an important paleontological collection, part of which was collected by an amateur palaeontologist. The process of discovery of these fossils and the lineage of the collection are not fully known, except for the location where they were collected, making it harder to determine and individualize specimens. The paleontological collection of the SHN corresponds to one of the most significant paleontological collections of the Iberian Peninsula, comprising numerous pieces of evidence of plants, invertebrates, and, especially, vertebrates from the Mesozoic of the Lusitanian Basin in Portugal, including fishes, mammal forms, lepidosauromorphs, crocodylomorphs, pterosaurs and dinosaurs. The researchers recognized the undeniable scientific value of the collection, which is already providing numerous contributions to the evolutionary history of Portugal's Late Jurassic-Early Cretaceous ecosystems, including some new species for science.
To better understand the characteristics of the collection, we developed a new management strategy based on the spatial location from where the fossils were found and retrieved. This new approach was based on establishing a methodology for field collection and the development of a spatial database to manage the entire stages of paleontological collections management. The new strategy proved to be extremely helpful in assisting the transferring of the collection to new storage facilities, supporting institutional partnerships and developing new research lines.
Geographic and geological context
The geographical area from where the fossils were collected consists of a stretch of approximately 90 km of the Portuguese West Coast spawning from Ericeira, in the south, to Nazaré in the north (Fig. 1), corresponding roughly to the coastal area of the central sector of the Lusitanian Basin. Furthermore, the geology also bears witness to past ecosystems, constituting what we propose to designate as a paleontological landscape by preserving testimonials other than large vertebrates. The paleontological collection of the SHN is mainly composed of fossils collected in the Mesozoic levels of the Lusitanian Basin from the Upper Jurassic deposits outcropping in this coastal area.
The Lusitanian Basin is in the west of the Iberian Peninsula and is related to the opening of the North Atlantic (Kullberg 2000). It began to be differentiated in the Triassic due to the fragmentation of Pangea and evolved during the Jurassic and Cretaceous (Kullberg et al. 2013). The Lusitanian Basin sedimentary sequence was deposited from the Middle Triassic (Ladinian-Carnian) (Rocha et al. 1996) to the Late Cretaceous (Turonian) (Rey 1999). The Upper Jurassic sedimentary sequence represents a third rifting episode (Rasmussen et al. 1998; Kullberg et al. 2013), marked by intense subsidence and an internal differentiation in three main sectors (Rocha and Soares 1984). From the lower Kimmeridgian to the top of the Upper Jurassic, the sedimentary sequence was dominated by abundant siliciclastic inputs, and the coastal environments became shallow and siliciclastics prograded into the basin, with the gradual development of fluvial (e.g., Hill 1988; Manuppella et al. 1999; Kullberg et al. 2013). During the last part of the Late Jurassic in the central sector of the Lusitanian Basin, which includes the studied area, distal fluvial-deltaic and coastal environments are dominant and give place to the richest fossil record of terrestrial vertebrates in the Lusitanian Basin (e.g. Lapparent and Zbyszewski 1957; Dantas 1990; Antunes and Mateus 2003; Ortega et al. 2009). The stratigraphy of the Upper Jurassic sequence of the Lusitanian Basin is complex due to the profuse lateral heterogeneity and the proposal of several different stratigraphic approaches (e.g. Hill 1988; Leinfelder 1993; Manuppella et al. 1999; Schneider et al. 2009; Martinius and Gowland 2011; Kullberg et al. 2013; Taylor et al. 2014; Fürsich et al. 2022).
Late Jurassic fauna of the Lusitanian Basin
The Kimmeridgian-Tithonian deposits of the Lusitanian Basin are rich in fossil vertebrates, represented by numerous taxa of fishes, mammals, amphibians, and reptiles. Non-archosaur diapsid reptiles are represented by choristoderan, squamates and sphenodontians (Malafaia et al. 2010;). Turtles are abundant and diverse and represented by plesiochelyids, non-plesiochelyid eucryptodirans and paracryptodiran pleurosternids (Pérez-García and Ortega 2011, 2014, 2022; Pérez-García 2015; Pérez-García et al. 2023). The Upper Jurassic of Portugal is known for its rich and diverse fossil record of archosaurs. Crocodyliforms are represented by some early-branching crocodyliforms, thalattosuchians, and neosuchian forms referred to Goniopholidae and Atoposauridae (Young et al. 2014; Guillaume et al. 2019). Pterosauria fossil record is sparse and represented only by a few isolated elements referred to as Pterodactyloidea or indeterminate pterosaurs (Wiechmann and Gloy 2000; Bertozzo et al. 2021).
Dinosaurs are remarkably diverse and represented by various forms of Ornithischia, Sauropoda, and Theropoda. Ornithischia is represented by thyreophorans, including members of Stegosauria and Ankylosauria (e.g. Galton 1980; Escaso et al. 2007; Costa and Mateus 2019) and iguanodontian ornithopods that have been referred to camptosaurids, dryosaurids and a possible indeterminate neornithischian (Escaso 2014; Escaso et al. 2014; Rotatori et al. 2022). Sauropods are dominated by turiasaurs, diplodocids and macronarian, including camarasaurids, brachiosaurid and early branching somphospondylans (e.g. Mannion et al. 2012; Mateus et al. 2014; Mocho et al. 2014, 2016a, 2017a, b, c, 2019a). Theropods are mainly represented by medium to large-sized forms belonging to Ceratosauria or tetanurans, including members of Megalosauridae and Allosauroidea (e.g. Mateus 1998, 2006; Hendrickx and Mateus et al. 2014; Malafaia et al. 2010, 2015; 2017a, b; 2020), but some small theropods are also recorded. The analyses of the relationship between the Late Jurassic fauna of Portugal and North America have been a source of many studies. The Portuguese faunas are characterized by a complex array of exclusive and shared forms with other domains, mainly with North America, which is explained by the shared history of these territories (e.g. Pérez-Moreno et al. 1999; Escaso et al. 2007; Hendrickx and Mateus et al. 2014; Mocho et al. 2014, 2019a; Malafaia et al. 2020).
In recent years, the significance of the Portuguese West Coast for palaeontology has been further attested by the publication of previously unknown species (e.g. Pérez-García and Ortega 2011, 2014; Mocho et al. 2019a; Malafaia et al. 2020). In this concern, the SHN paleontological collections have supported the publication of many scientific papers in SCI journals, abstracts in national and international paleontological conferences, and PhD thesis (Pérez-García 2012; Escaso 2014; Mocho 2016; Malafaia 2018). We highlight the importance of having a managing strategy for the paleontological collections behind this research. The SHN paleontological collections currently host five holotype specimens of Late Jurassic vertebrates (Pérez-García and Ortega 2011, 2014; Escaso et al. 2014; Mocho et al. 2019a; Malafaia et al. 2020). They provided relevant data on the Mesozoic ecosystems of the Lusitanian Basin and helped to understand the evolutionary history of many vertebrate groups, especially dinosaurs. Herein, we will briefly overview some of the most important findings.
An important line of research has been carried out on the Kimmeridgian-Tithonian collection of turtle remains of the SHN, including the establishment of the oldest European pleurosternid Selenemys lusitanica Pérez-García and Ortega, the description of a new species of Hylaeochelys, Hylaeochelys kappa Pérez-García and Ortega 2014; and the first occurrence of Tropidemys in the Upper Jurassic of the Iberian Peninsula (Pérez-García and Ortega 2011, 2014; Pérez-García, 2015; Pérez-García et al. 2023, 2024). A new pterosaurian specimen from the SHN was recently studied, providing new data on this poorly known group of archosaurs in the Upper Jurassic of Portugal and supporting the first occurrence of a dsungaripteroid pterosaur in the Iberian Peninsula (Bertozzo et al. 2021). Sauropods are the most abundant dinosaurian group in the collection, including many partial skeletons and isolated remains. The SHN team has recently collected some of these specimens in the Torres Vedras municipality. This fossil record shows a great diversity, including remains of turiasaurs, diplodocoids and macronarians (e.g. Mocho et al. 2016b, 2017b, d; 2019a, b) and the holotype specimen of Oceanotitan dantasi Mocho, Royo-Torres and Ortega, one of the oldest somphospondylans found worldwide (Mocho et al. 2019a). The study of the theropod remains of SHN has provided relevant data about the diversity of this clade in the Lusitanian basin during the Late Jurassic (Malafaia et al. 2015, 2017a,b,c, 2019, 2020) and the establishment of Lusovenator santosi Malafaia, Mocho, Escaso and Ortega, the oldest carcharodontosaurian allosauroid yet discovered from Laurasia (Malafaia et al. 2020). Is also relevant the sample of ornithischians dinosaurs in the collection (Escaso 2014; Escaso et al. 2014), including the type specimens the dryosaurid ornithopod, Eousdryosaurus nanohallucis Escaso, Ortega, Dantas, Malafaia, Silva, Gaulla, Mocho, Narváez and Sanz. SHN hosts an extensive collection of crocodylomorph and dinosaurian tracks with many morphotypes already identified by Castanera et al. (2020a, b). Numerous lines of research are still ongoing. They are mainly focused on the phylogenetic systematics (e.g. fishes, turtles, pterosaurs, sauropods, theropods, ornithischians), paleobiology (e.g. paleohistology, paleopathologies), paleobiogeography (e.g. Escaso 2014; Escaso et al. 2018; Camilo 2019; Mocho et al. 2019b, 2022; Costa et al. 2021, 2022; Pérez-García and Ortega 2022; Rotatori et al. 2022; Pérez-García et al. 2023 and also in paleontological heritage management (Mano 2010; e.g. Escaso 2014; Escaso et al. 2018; Mocho et al. 2019b, 2022; Costa et al. 2021, 2022; Camilo et al. 2020, 2022;).
The collection(s)
Over the last decades, professionals and amateurs have collected thousands of fossils in the Mesozoic sedimentary deposits of the Lusitanian Basin (Portugal). One such effort is the José Joaquim dos Santos Collection (JJS Collection), mainly composed of fossil remains collected in Upper Jurassic deposits of the aforementioned basin and many handwritten notes on most of these specimens.
The JJS Collection comprises thousands of fossils representative of hundreds of specimens (some of these specimens correspond to a set of several remains). The municipality of Torres Vedras, recognizing the scientific value of such a paleontological collection, decided to acquire it in 2008. Subsequently, it entrusted SHN with its management, conservation and study, which at the time was being kept in improvised and personal facilities of José Joaquim dos Santos, near Torres Vedras (Figure 2)
In addition to this collection, SHN also manages specimens collected through their field campaigns, usually conducted in collaboration with national and international academic partnerships. These specimens have a more formal acquisition cycle but only correspond to a small portion of the SHN paleontological collections compared to those in the JJS collection.
The SIGAP project
Natural History collections are usually organized around the concept of specimen – a sample attesting to the occurrence of a taxon or more at a particular time and place. Once the taxon is determined, it is associated with lithostratigraphic, paleobiogeographic and paleoecological data, related bibliography and other information that helps describe its contextual significance (Lane 1996). However, specimens whose lineage is unclear (i.e., not acquired using systematic methods and registration techniques) usually lack the link between the taxon and its context.
To understand the management strategy adopted by the SHN, it is essential to note that the fossils were stored in the best conditions that José Joaquim dos Santos could provide, albeit suboptimal. Unfortunately, the fossils were not prepared to be studied and classified accurately (i.e., they require preparation procedures to highlight morphological features), and it can be hard to determine which fossils belong together. It, therefore, could correspond to the same individual, taxon or to the same fossil assemblage. Apart from preservation issues, the most urgent issue about the collection was the lack of an inventory. The available information consisted solely of handwritten notes and the memory of José Joaquim dos Santos. These notes typically document the collection site and general anatomical characteristics when perceivable.
Before moving the JJS Collection to new storage facilities, the problems described above had to be addressed; however, establishing an inventory structured around the specimen corresponding to a single individual would take many years. Hence, the strategy chosen was to organize the collection by location and geological context because this information could be collected within a few months with the help of José Joaquim Santos's notes and memories. Determining specimens to a single individual or taxonomic unit will follow in the coming years as research fellows study the collection.
The importance of space and location as descriptors of Natural History collections specimens is widely recognized (Reed et al. 2004); what makes this case different is the role spatial information takes as the structuring element around which the paleontological collections are organized.
Once a first (location-based) catalogue of the collection is available, it would allow researchers to (a) group fossils by provenience and, from there, build specimen listings and (b) plan revisits to the locations from where collections were made to monitor if erosion uncovered further fossils, eventually requiring a systematic excavation. Such a strategy leads to a greater understanding of the fossil record and contributes to tackling challenges of Natural history collections, such as preservation and accessibility (Dorfman 2018).
Implementing a location-based approach to manage this paleontological collection took the form of a specially designed SIGAP project (GIS applied to Paleontology), an ongoing internal project initiated in 2008.Footnote 1 Its main objective is to georeference the provenience locations of the fossil remains from the JJS Collection and build a spatial database that can support the management of the paleontological collections – from on-site collection to, once it is determined, specimen registry. The following sections describe how this system was developed.
Methodology
Field collection
The first data-related task of the project was the acquisition of the locations where fossils were retrieved. These locations are designated as “paleositio”, and they can take one of two types: a site “jazida” or a dispersion area “disperso”. A site is recorded as a zero-dimensional geometry using a Global Positioning System (GPS) to identify the exact location from where one or more fossils, representative of one or more individuals, were retrieved. Thus, a site location is known with enough accuracy to determine the exact layer from where the fossils were collected. By contrast, a dispersion area represents a fuzzier type of collection and is recorded as a two-dimensional geometry. Due to the effects of erosion or human activities, this type of register is associated with findings detached from the original sedimentary layer that once encapsulated the fossil.
Field collection in the case of dispersion areas consists primarily of digitizing polygons over aerial imagery as background using QGIS open-source software (QGIS.org 2023)through visual image interpretation (Baker and Philipson 1997), focusing primarily on association properties. The association seeks proximity relationships between recognizable objects (a field, a road, a landscape feature, a building, etc.) to identify a location. It is a fast and efficient process we find suitable considering the locational fuzziness of the findings. A drawback of such an approach is that there is no accuracy level to be expected; the resulting polygons vary widely in size and shape, reflecting both the dispersion areas and what memory allows to reconstruct.
The case of sites, however, incurs subtleties that should not be ignored. Fossil sites are exposed primarily due to the effects of erosion. Once erosion exposes a fossil and its consequent discovery, the fossil is collected. However, one cannot exclude the possibility that more fossils from the same or another specimen are buried deeper into the layer and near the collected remains. Future erosion or the carrying out of paleontological works will eventually answer that question, but sites must be registered. Ideally, this site must be recorded with a spatial accuracy of under two meters so that the collection site can be monitored in the years to come if necessary.
This accuracy requirement, however, can be challenging to comply with. First, due to the harshness of the landscape (Fig. 1), very high-accuracy survey equipment like total stations or external antenna GPS systems would make the fieldwork slower and more dangerous. Secondly, most of the surveys were conducted at the bottom or halfway through the cliff, meaning degraded Dilution of Precision (DoP) index values and high reflectance errors – both well-known factors for loss of accuracy when using GPS measurements (Langley 1999; Sabatini and Palmerini 2008).
In such a scenario, the survey solution must rely on portable equipment to maximize acquisition speed and safety while supporting real-time differential corrections that minimize the loss of accuracy. The field collection used single-frequency handheld GPS receivers (Fig. 3) with support for two types of differential corrections: (i) a system of Virtual Reference Stations (VRS), a service provided by the Portuguese Army Geographic InstituteFootnote 2 allowing sub-meter accuracy, and as an alternative, (ii) the European Geostationary Navigation Overlay Service (EGNOS), allowing accuracy levels of around two meters. Both solutions eliminate the need to operate a second GPS receiver to serve as a base that corrects the rover measurements. However, the VRS network was the preferred differential method due to the higher accuracy offered.
The VRS system relies on a series of Global Navigation Satellite System (GNSS) reference stations connected to a control centre. These stations collect information that can be used to correct the positioning of the rover GNSS (i.e. GPS) receiver once its position is known to the data control centre. This bi-directional communication relies on a data link, usually established using a cell phone network like 3 or 4G (Lou and Chen 2008).
The drawback of this system is that a cellphone with data services must be used with the GPS receiver via Bluetooth pairing. Furthermore, if, for some reason, the area to survey has no third (3G) or fourth (4G) generation of wireless mobile telecommunications technology network coverage, real-time differential corrections are lost. In such scenarios, EGNOS corrections are used.
The horizontal referencing of the data resulting from the surveys and any secondary spatial datasets was projected to the ETRS89 / Portugal TM06 (EPSG:3763) system, Portugal's official spatial reference system. However, no referencing system is adopted for Z values; thus, despite elevation values being automatically registered by the GPS receiver, they are essentially ignored.
Lastly, there is also the case of measurements where no correction was made. This was the case when it was impossible to have either cell phone coverage to use the VRS or a lock into the geostationary satellites of EGNOS to get differential corrections. In such a scenario, positional accuracy is always above the 2 m requirement mentioned earlier (Table 1).
Differences in expected accuracy are essential to understanding the motivations for having different GNSS acquisition methods. Measurements that take advantage of VRS correction signals were always preferred, but in the study area, often, there are blind areas where no 3G or 4G coverage is available – a requirement to use VRS corrections. In such a scenario, the second preferred method was to use the EGNOS geostationary satellite corrections to achieve accuracies within the desirable two-meter threshold. If both differential methods cannot be used, the site must be registered using autonomous GPS.
As a complement to the spatial registry, efforts were made to minimize difficulties in locating sites when revisiting them in the future, especially when the registry did not benefit from any differential correction. A photograph with a flag attached to a mast that sits at the location from where the fossil was collected, according to José Joaquim dos Santos's memory and notes, exists for every site related to the JJS Collection. These photos are as panoramic as possible, providing many reference points from the surroundings. For the JJS collection, 361 paleosites – 265 sites and 96 dispersed areas – have been registered using the abovementioned methods.
Secondary data
In parallel with field data, additional spatial datasets provided context and spatial relationships to the paleosites (Table 2).
Topographic maps are paramount to understanding the spatial context and identifying any landscape features that might play a role when accessing the site. The geological maps provide information about the lithostratigraphic and chronostratigraphic units and structural features (e.g. faults) associated with a site. Orthophotos complement topographic maps because they are used for spatial context and visual interpretation. Finally, administrative boundaries allow for the retrieval of territorial units where the sites are located.
In the case of topographic maps, only the individual sheet number is used to refer to the paper-printed map, and in the case of the geological charts, they were scanned, georeferenced, and geometries were distilled via manual vectorization. In both cases, this workflow results from closed data policies that many Portuguese public institutions, unfortunately, still maintain (Publications Office of the European Union 2020).
A few datasets referenced in Table 1 are encoded in a reference system different from those adopted for the project (ETRS89/TM06 Portugal). In such cases, datum transformations are required to bring those datasets in line with standard horizontal spatial referencing. Datum transformations used the National Transformation version 2 (NvT2) grids developed by José GonçalvesFootnote 3 to minimize datum transformation errors introduced by standard 3 and 7 parameter transformation methods.
Management Strategy
Managing a paleontological collection comprehends several stages (Frick and Greeff 2021) whose order and nature may vary depending on local circumstances. The methodological lineage of the JJS Collection is not fully known, especially in the earlier stages when the specimens were discovered and collected. Thus, we adopted the following management stages:
-
A).
Spatial registry stage – the location where the fossils were found is registered, and all the spatial context associated with that location is also inferred (administrative unit, geology, etc.).
-
B).
Specimen registry stage – the fossils are prepared in a laboratory and given a specimen identifier.
-
C).
Specimen lineage stage – consists of keeping track of any preparation a specimen has undergone and publication works associated with that specimen. That includes keeping a record of who did those works.
-
D).
Inventory stage – specimen preservation and storage policies, including specimen loans to partner institutions, are defined in this stage.
-
E).
Landscape stage – a complementary phase that aims at planning and territory management; it includes the registration of geological landmarks, reporting incidents related to paleontological heritage, and information about susceptible areas.
For stage A (spatial registry stage), the spatial datasets described thus far allow spatial management of the collection, that is, both the locations of the paleosites, and contextual information and spatial relationships that might be relevant. The spatial context involves knowing what other spatial objects intersect the fossil paleosites and dispersion areas. From this intersection, relevant attributes should be automatically associated, a simple requirement that excludes any manual editing to ensure semantic consistency, an essential component of data quality.
Upon conclusion of the registration of Stage A, we proceed with Stage B (specimen registry stage), C (specimen lineage stage), and D (inventory stage), which correspond to the non-spatial part of the database. Stage E (Landscape stage), the last one, is not yet implemented, although the database design assumes it will be developed soon. These stages do not necessarily follow a predetermined sequence as the alphabetical enumeration may suggest. The presented order is the typical sequence of management stages we follow, but concurrent stages over the same specimen are possible.
These stages of work are a generic framework in which the specific user and organizational needs and requirements are identified. Identifying these requirements is an essential step in the process of designing a database, and it should precede any implementation effort, ideally including input from the future users of the system or other relevant actors (Yeung 2007).
Spatial database
Developing a relational spatial database is the core of the GIS approach adopted by SHN. It is an ongoing effort based on PostgreSQLFootnote 4 with PostGISFootnote 5 spatial extension enabling the handling of spatial objects. The blueprint of the database structure takes the form of a Unified Modeling Language (UML) class diagram capturing the requirements of the institution and use cases (Fig. 4; Appendix 1).
The database structure is a direct consequence of the management stages described previously. All the tables associated with the spatial registry stage, denoted with the A-label, refer to primary field data collection or spatial tables providing additional spatial context—this is the first body of data to be collected. Once the spatial registry is completed, the specimen registry stage can start – B label. This stage consists of non-spatial data about the specimen and any associated preparation and publishing.
Some of the tables relate to more than one stage. In the case of the specimen lineage stage – C label, the history of fossil preparation (including the description of conservation-restoration procedures) is kept in a separate table. However, the lineage of this information can also come in the form of publications that might also be relevant for the specimen registry stage. Once a specimen and its lineage are described, another set of tables keeps records related to inventory. That corresponds to the inventory stage – D label–- it is the most downstream stage of the collection management and can only exist once a formal cycle of acquisition and study occurs. The last tables are those related to the landscape stage – E label. That is where the information related to the paleontological landscape concept is stored, including risk assessment and geomorphological features.
A Model-Driven Architecture (Siegel 2010) approach was adopted to translate the class diagram into a Platform Specific Model implementation in the form of SQL statements valid for PostgreSQL database server (a link to access the implementation script is available under the Supplementary Materials section).
A great effort is made to ensure data consistency, particularly in semantic accuracy, a fundamental condition for having queries return complete and consistent results. That is achieved via two mechanisms: the first is to set a predefined set of allowed values for a given column using foreign keys that point to tables with a fixed structure; the other is to use spatial triggers to automatically fill in any fields whose data is obtained from a spatial predicate or a spatial function (Fig. 5). The key idea is to reduce as much as possible the amount of data to be specified by the users of the database, a principle often mentioned among data quality experts.
To further enforce data consistency, very few users have DELETE and UPDATE rights on any given table. Instead, most roles only have the SELECT right, and anytime a user with editing privileges changes a table, the record(s) that were updated or deleted are stored in the correspondent history table. This mechanism opens the possibility of recovering a previous state at any given point of the data lineage.
Along with data consistency, the database must also provide table structures the users expect. Several database views construct tables from join conditions (Fig. 6), thus sparing the users from understanding the data model and other intricacies behind the database.
Web Services and Web GIS
The usability component should not be underestimated, and along with the views, user interfaces are necessary. The outreach and usability of a database depend on the interfaces and interoperability mechanisms built over it. Interoperability is ensured by using Open Geospatial Consortium (OGC) standard web services specification. Two types of services are provided using QGIS Server: Web Map Services (WMS)Footnote 6 and Web Feature Services (WFS).Footnote 7 The first service distributes the data as a static representation and serves the cases where SHN wants to share data more restrictedly. On the other hand, the second allows vector and tabular data to be encoded in Geographic Markup Language (GML) format. This second service is suitable for sharing data with research partners without giving them direct access to the database.
Regarding user interfaces, we maintain a Web GIS based on Lizmap,Footnote 8 which integrates well with QGIS and PostgreSQL. Lizmap also has the advantage of requiring little, if any, code development while still offering essential functionalities for a platform aimed mainly at researchers: advanced searches, photo visualization, measurement tools, and user authentication (Fig. 7).
Results
The SIGAP project is an ongoing effort whose outcomes are proving valuable for SHN. The immediate result is an initial inventory of fossils that were necessary before the transfer of the SHN collection to new storage facilities (Fig. 8) without splitting sets of fossils. A set of elements can comprise a unique specimen if it results from being collected in the same location. We avoided separating or dividing the elements that comprise those specimens during the collection transfer to minimize possible data loss. The establishment of sets of fossils, i.e., specimens, based on their spatial location, in a collection with a poor collection lineage, was vital for the identification of fossil assemblages and individuals, which in turn led to the development of some already published studies (e.g. Mocho et al. 2019a; Malafaia et al. 2020).
Along with the listing, SHN also has profile information about the collections. As an example, the collection can be characterized based on its distribution by genus (Table 3), geological background (Table 4), apparent anatomical parts (Table 5) and administrative context (Table 6).
These overviews do not constitute new scientific knowledge by itself. However, they are essential to provide a preliminary characterization of the collection by delimiting groups based on their attributes to facilitate the establishment of priorities for (i) future lines of research, (ii) procedures for Conservation-Restoration and (iii) management policies for the collection. They can also take the form of cartographic products (Fig. 9) that can be used to plan field campaigns, apply for funding, and enhance internal and external communication.
From a planning and spatial perspective, the SIGAP project facilitated the inclusion of paleontological heritage as a possible restriction to some human activities within the municipality of Torres Vedras. The inclusion of paleontological elements in the new Plano Director Municipal (i.e. Master plan)Footnote 9 was based on the location data collected by SIGAP. This inclusion sets, along with the case of the Municipality of Lourinhã,Footnote 10 an important precedent for the protection of Paleontological heritage in Portugal by including a category designated Sitios de especial relevância paleontológica (i.e. Sites of particular paleontological relevance) as one of the categories of Património Natural (i.e. Natural heritage) of the Planta de Ordenamento (i.e. Ordinance plan).Footnote 11 This inclusion essentially means that in the future, impacts over sites of paleontological interest will have to be mitigated or avoided in the event of human activities or developments that incur in soil movements.
Last but not least, having information stored consistently and the ability to share that information – via web services, Web GIS, or simply raw data, allows SHN to build partnerships more efficiently due to the quality and reliability of the input.
Discussion
The spatial-led approach to managing paleontological collections we propose has shown to be a valid strategy for cases where the traceability of the collection and the storage conditions are not ideal or entirely known, as it is the case with the collection collected by José Joaquim dos Santos. Our experience supports the claims for a need for more flexible collection management approaches, as Schindel and Cook (2018) suggested. Structuring the collection of José Joaquim dos Santos around spatial information not only provides a first form of inventory, but can also assist with the fossil’s features in confirming what constitutes a specimen. Organizing the collection around a specimen is a defining characteristic of most Natural History collection management approaches, and our proposal seeks to facilitate this standard approach. Therefore, our approach is complementary to the existing one and should not be seen as a replacement.
From a technical perspective, open-source software saves scarce financial resources that can be invested in studying the collections; it is also a more sustainable and inclusive choice. By sustainable, we mean the definition provided by the Sustainability Institute as “[…]the software you use today will be available–- and continue to be improved and supported–- in the future”.Footnote 12 In the case of QGIS and PostgreSQL, there is no reason to fear the loss of the sustainability factor: the number of active contributors, commits, and institutional adoption all confirm the solidity of these projects. The inclusiveness attribute refers to the few juridical barriers to the project’s use and distribution, lowering the entry requirements for using the tools and the data.
On top of implementation approaches, the principles presiding over the development of a GIS system are of no less importance to the project’s success. The project is deeply rooted in the acquired know-how of SHN and supported the inventory of the paleontological collection of José Joaquim dos Santos, organizing thousands of fossils in specimens based on spatial location. Therefore, the continued development of the SIGAP project at SHN rests on the human capital of experiences. These are the basis for defining the project's needs, objectives, and approaches.
The assessment of the spatial-based approach is an exercise for the coming years, as there are not that many examples of applying GIS to manage paleontological collections (Garcia Ortiz de Landaluce, 2015). Nevertheless, mature examples of GIS supporting specimen collection in biology (Funk et al. 1999) or applied to broader spatial analysis in archaeological contexts (Chapman 2006) are promising examples of the value of the GIS in managing collections where location and space are part and complement of the equation.
Conclusion
A total of 371 paleosites have been recorded as of November 2020. They mainly belong to the JJS Collection managed by the SHN, from where an undetermined number of specimens, representative of an equally undetermined number of taxa, were collected. The system developed in the scope of the SIGAP project has successfully kept track of a valuable collection by providing anchoring points (location) to the initial inventory and organization of the collections. The information managed by the database is expected to grow as stages B, C and D–- specimen registry, specimen lineage, and inventory occur. The significant development for the near future is the construction of paleontological heritage risk models that will establish management strategies to tackle the challenges of the paleontological landscape concept we enunciate. To achieve this, previous experiences in developing erosion models in the scope of paleontological heritage and mitigation of spoliation risks (Blasi et al. 2021) confirm the relevance of such an effort.
Notes
Sociedade de História Natural (2008), Sistema de Informacao Geográfica Aplicado a Paleontologia – memória descritiva (internal document).
Instituto Geográfico do Exército, SERVIR Sistema de Estações de Referência GNSS VIRtuais, accessed 19 February 2024 (https://www.igeoe.pt/index.php?id=45
Gonçalves, José (2009): Conversões de Sistemas de Coordenadas Nacionais para ETRS89 Utilizando Grelhas VI Congresso Nacional de Cartografia e Geodesia.
PostgreSQL; http://www.postgresql.org/
PostGIS; http://postgis.net/
Standard OpenGIS® Implementation Specification 1.3.0, 2006: OpenGIS® Web Map Server Implementation Specification. Available online at https://www.ogc.org/standards/wms
OpenGIS® Implementation Standard 2.0, 2010: OpenGIS Web Feature Service 2.0 Interface Standard. Available online at https://www.ogc.org/standards/wfs
Camara Municipal de Torres Vedras, Revisao do PDM, accessed 19 February 2024 (https://www.cm-tvedras.pt/ordenamento/pdm-planos-de-urbanizacao-e-pormenor/planos-em-elaboracao/revisao-pdm).
Note n.º 12,180-A/2017 of 11.th October 2017, accessed 19 February 2024) https://dre.pt/dre/detalhe/aviso/12180-a-2017-108284974
Approved in the Public meeting of the board of the Municipality of Torres Vedras of 27.th July 2021, accessed 19 February 2024 (https://www.youtube.com/watch?v=wS4JzlrwRDY&t=10126s).
About the software sustainability institute, accessed 7 June 2022 (https://www.software.ac.uk/about).
References
Antunes MT, Mateus O (2003) Dinosaurs of Portugal Palevol 2:77–95. https://doi.org/10.1016/S1631-0683(03)00003-4
Baker, BW, Philipson, Warren R (1997) Manual of photographic interpretation. 2nd ed.: Bethesda (Md.) : American Society for Photogrammetry and Remote Sensing
Bertozzo F, Camilo da Silva B, Martill D, Vorderwuelbecke EM, Aureliano T, Schouten R, Aquino P (2021) A large pterosaur femur from the Kimmeridgian, Upper Jurassic of Lusitanian Basin. Portugal Acta Palaeontologica Polonica 66(4):815–825. https://doi.org/10.4202/app.00858.2020
Blasi, I, Pellicer, X, Poch, J, Galobart, A (2021) Open-air paleontological sites: A Dissemination Opportunity and a Risk to Spoliation. A Case Study in the Orígens Geopark, Spain. In Geoconservation Research 4 (2) https://doi.org/10.30486/gcr.2021.1913481.1055
Camilo B (2019) Long bone histology of Late Jurassic dryosaurids from Portugal, with emphasis on Eousdryosaurus nanohallucis, MsC dissertation. University of Opole, Poland
Camilo B, Mano A, Schouten R, Agbulut B (2020) Gestão de Património Paleontológico: o sistema de informação geográfico aplicado à paleontologia. Boletim Do Centro Português De Geo-História e Pré-História 2(1):73
Camilo, B, Dankina, D, Carvalho, V, Mulder, E, Nerinckx, I, Desmet, H, Agbulut, B, Fuchs, V, Bertozzo, F, Branco, M, Ramalheiro, G (2022) A primeira “Bone bed” com dinossauros do Jurássico Superior de Portugal, 18–19. In: Fialho, P.; Pereira, S. (eds.), Newsletter da SPdP Sociedade Portuguesa de Paleontologia, NÚMERO 1, 15 de Outubro de 2022
Castanera D, Malafaia E, Silva BC, Santos VF, Belvedere M (2020b) New dinosaur, crocodylomorph and swim tracks from the Late Jurassic of the Lusitanian Basin: implications for ichnodiversity. Lethaia 54:260–270. https://doi.org/10.1111/let.12402
Castanera, D, Silva, BC, Santos, VF, Malafaia, E, Belvedere, M (2020a) Tracking Late Jurassic ornithopods in the Lusitanian Basin of Portugal: Ichnotaxonomic implications. Acta Palaeontologica Polonica, 65. https://doi.org/10.4202/app.00707.2019
Chapman, Henry (2006) Landscape archaeology and GIS. Stroud Gloucestershire: Tempus
Costa, B, Camilo, B, Antunes, MT, Balbino, AC (2021) The hybodontiform sharks (Chondrichthyes: Euselachii) from the Upper Jurassic of Torres Vedras, Portugal. Comunicações Geológicas, 108 (Especial I): 43–46. https://doi.org/10.34637/rx8a-5283
Costa, B, Daknina, D, Camilo, B, Balbino, AC (2022) Late Jurassic Ginglymodians and Pycnodontiformes from Torres Vedras, Portugal, 20–20. In: Fialho, P.; Pereira, S. (eds.), Newsletter da SPdP Sociedade Portuguesa de Paleontologia, NÚMERO 1, 15 de Outubro de 2022
Costa F, Mateus O (2019) Dacentrurine stegosaurs (Dinosauria): A new specimen of Miragaia longicollum from the Late Jurassic of Portugal resolves taxonomical validity and shows the occurrence of the clade in North America. PLoS ONE 14(11):e0224263. https://doi.org/10.1371/journal.pone.0224263
da Silva MA (2010) Sistema de Informacao Geografica Aplicado a Paleontologia. MSc Dissertation, Universidade Nova de Lisboa, Lisbon. https://run.unl.pt/handle/10362/5349
Dantas P (1990) Dinossáurios de Portugal. Gaia 2:17–26
Dorfman E (2018) The future of natural history museums. Routledge, Milton Park Abingdon Oxon, New York NY
Escaso F, Ortega F, Dantas P, Malafaia E, Pimentel NL, Pereda-Subelbiola X, Sanz JL, Kullberg JC, Kullberg MC, Barriga F (2007) New evidence of shared Dinosaur across Upper Jurassic Proto-North Atlantic: Stegosaurus from Portugal. Naturwissenschaften 94:367–374. https://doi.org/10.1007/s00114-006-0209-8
Escaso F, Ortega F, Dantas P, Malafaia E, Silva B, Gasulla JM, Mocho P, Narváez I, Sanz JL (2014) A new dryosaurid ornithopod (Dinosauria, Ornithischia) from the Late Jurassic of Portugal. J Vertebr Paleontol 34:1102–1112. https://doi.org/10.1080/02724634.2014.849715
Escaso, F, Malafaia, E, Mocho, P, Nárvaez, I, Sanz, JL, Ortega F (2018) New material of Ankylopollexian ornithopods form the Upper Jurassic of Portugal, p.74. In: Marzola M, Mateus O, Moreno-Azanza M (Eds.), Abstract book of the XVI Annual Meeting of the European Association of Vertebrate Palaeontologists, Caparica, Portugal June 26th-July 1st, 2018
Escaso, Fernando (2014) Historia Evolutiva de los Ornitischia (Dinosauria) del Jurásico Superior de Portugal, PHd dissertation, UAM Departamento de Biología. Universidad Autónoma de Madrid https://repositorio.uam.es/handle/10486/662449
Frick, H, Greeff, M (2021) Handbook on natural history collections management – A collaborative Swiss perspective. https://doi.org/10.5281/zenodo.4316839
Funk VA, Fernanda ZM, Naseem N (1999) Testing the use of specimen collection data and GIS in biodiversity exploration and conservation decision making in Guyana. In Biodiversity and Conservation 8(6):727–751. https://doi.org/10.1023/A:1008877222842
Fürsich FT, Schneider S, Werner W, Lopez-Mir B, Pierce CS (2022) Life at the continental–marine interface: palaeoenvironments and biota of the Alcobaça Formation (Late Jurassic, Central Portugal), with a formal definition of the unit appended. Palaeobiodiversity and Palaeoenvironments 102:265–329. https://doi.org/10.1007/s12549-021-00496-x
Galton PM (1980) Partial skeleton of Dracopelta zbyszewskii n. gen. And N. SP., an ankylosaurian dinosaur from the Upper Jurassic of Portugal. Geobios. 13(3):451–457. https://doi.org/10.1016/S0016-6995(80)80081-7
García Ortiz de Landaluce E (2015) Análisis de los yacimientos de icnitas de dinosaurios de La Rioja (N de España) como recurso patrimonial y aplicación de nuevas tecnologías a su estudio. PhD dissertation, Universidad de León (Spain). https://doi.org/10.18002/10612/5461
Guillaume ARD, Moreno-Azanza M, Puértolas-Pascual E, Mateus O (2019) Palaeobiodiversity of crocodylomorphs from the Lourinhã Formation based on the tooth record: insights into the palaeoecology of the Late Jurassic of Portugal. Zool J Linn Soc 189:549–583. https://doi.org/10.1093/zoolinnean/zlz112
Hendrickx C, Mateus OV (2014) Torvosaurus gurneyi n. sp., the largest terrestrial predator from Europe, and a proposed terminology of the maxilla anatomy in nonavian Theropods. PloS ONE 9:e88905. https://doi.org/10.1371/journal.pone.0088905
Hill G (1988) The sedimentology and lithostratigraphy of the Upper Jurassic Lourinhã Formation, Lusitanian Basin, Portugal. Phd Dissertation. Open University, Milton Keynes, UK
Kullberg JC (2000) Evolução tectónica mesozóica da Bacia Lusitaniana. PhD dissertation. Faculdade de Ciências e Tecnologia Universidade Nova de Lisboa, Lisboa, Portugal
Kullberg, J.C., Rocha, R.B., Soares, A.F., Rey, J., Terrinha, P., Azerêdo, A.C., Callapez, P., Duarte, L.V., Kullberg, M.C., Martins, L., Miranda, J.R., Alves, C., Mata, J., Madeira, J., Mateus, O., Moreira, M., and Nogueira, C.R. (2013): A Bacia Lusitaniana: Estratigrafia, Paleogeografia e Tectónica, p. 989–1141. In Dias, R., Araújo, A., Terrinha, P., and Kullberg, J.C. (eds.), Geologia de Portugal no contexto da Ibéria. Escolar Editora, Lisboa
Lane MA (1996) Roles of Natural History Collections. In Annals of the Missouri Botanical Garden 83(4):536. https://doi.org/10.2307/2399994
Langley, RB (1999) Dilution of Precision, in GPS World, p. 52–59
Lapparent AF, Zbyszewski G (1957) Les dinosauriens du Portugal. Memórias Dos Serviços Geológicos De Portugal 2:1–63
Leinfelder RR (1993) A sequence stratigraphic approach to the Upper Jurassic mixed carbonate–siliciclastic succession of the central Lusitanian Basin, Portugal. Profil 5:119–140
Lou, L, Chen, Y (2008) The Precision And Accuracy Of Shanghai Vrs Network. In Michael G. Sideris (Ed.): Observing our Changing Earth, vol. 133. Berlin, Heidelberg: Springer Berlin Heidelberg (International Association of Geodesy Symposia), pp. 719–723. https://doi.org/10.1007/978-3-540-85426-5_82
Malafaia E, Ortega F, Escaso F, Dantas P, Pimentel NL, Gasulla JM, Ribeiro B, Barriga F, Sanz JL (2010) Vertebrate fauna at the Allosaurus fóssil-site of Andrés (Upper Jurassic), Pombal, Portugal. J Iber Geol 36:193–204. https://doi.org/10.5209/rev_JIGE.2010.v36.n2.7
Malafaia E, Ortega F, Escaso F, Silva B (2015) New evidence of Ceratosaurus (Dinosauria: Theropoda) from the Late Jurassic of the Lusitanian Basin, Portugal. Hist Biol 27:938–946. https://doi.org/10.1080/08912963.2014.915820
Malafaia E, Mocho P, Escaso F, Ortega F (2017a) New data on the anatomy of Torvosaurus and other remains of megalosauroid (Dinosauria, Theropoda) from the Upper Jurassic of Portugal. J Iber Geol 43:33–59. https://doi.org/10.1080/08912963.2016.12311832
Malafaia E, Escaso F, Mocho P, Serrano-Martínez A, Torices A, Cachão M, Ortega F (2017b) Analysis of diversity, stratigraphic and geographical distribution of isolated theropod teeth from the Upper Jurassic of the Lusitanian Basin. Portugal J Iberian Geol 43:257–291. https://doi.org/10.1007/s41513-017-0021-7
Malafaia E, Mocho P, Escaso F, Ortega F (2017c) A juvenile allosauroid theropod (Dinosauria, Saurischia) from the Upper Jurassic of Portugal. Hist Biol 29:664–676. https://doi.org/10.1080/08912963.2016.1231183
Malafaia E, Mocho P, Escaso F, Dantas P, Ortega F (2019) Carcharodontosaurian remains (Dinosauria, Theropoda) from the Upper Jurassic of Portugal. J Paleontol 91(1):157–172. https://doi.org/10.1017/jpa.2018.47
Malafaia E, Mocho P, Escaso F, Ortega F (2020) A new carcharodontosaurian theropod from the Lusitanian Basin: evidence of allosauroid sympatry in the European Late Jurassic. J Vertebrate Paleontol 40(1):e1768106. https://doi.org/10.1080/02724634.2020.1768106
Malafaia, E (2018) Phylogenetic analysis, paleoenvironmental and paleobiogeographic interpretation of theropod dinosaurs from the Upper Jurassic of the Lusitanian Basin. PhD Dissertation, Universidade de Lisboa https://repositorio.ul.pt/handle/10451/35031?mode=full
Mannion P, Upchurch P, Mateus O, Barnes RN, Jones MEH (2012) New information on the anatomy and systematic position of Dinheirosaurus lourinhanensis (Sauropoda: Diplodocoidea) from the Late Jurassic of Portugal, with a review of European diplodocoids. J Syst Paleontol 10:521–551. https://doi.org/10.1080/14772019.2011.595432
Manuppella, G, Antunes, MT, Pais, J, Ramalho, MM, Rey, J (1999) Notícia explicativa da Folha 30-A (Lourinhã). Departamento de Geologia do Instituto Geolégico e Minerio, Lisboa
Martinius A, Gowland S (2011) Tide-influenced fluvial bedforms and tidal bore deposits (Late Jurassic Lourinhã Formation, Lusitanian Basin, western Portugal). Sedimentology 58:285–324. https://doi.org/10.1111/j.1365-3091.2010.01185.x
Mateus O (1998) Lourinhanosaurus antunesi, a new Upper Jurassic allosauroid (Dinosauria: Theropoda) from Lourinhã, Portugal. Memórias Da Academia Das Ciências De Lisboa, Classe Ciências 37:111–124
Mateus O, Walen A, Antunes MT (2006) The large theropod fauna of the Lourinhã Formation (Portugal) and its similarity to the Morrison Formation, with a description of a new species of Allosaurus. New Mexico Museum of Natural History and Science 36:223–231
Mateus O, Mannion PD, Upchurch P (2014) Zby atlanticus, a new turiasaurian sauropod (Dinosauria, Eusauropoda) from the Late Jurassic of Portugal. J Vertebr Paleontol 34:618–634. https://doi.org/10.1080/02724634.2013.822875
Mocho P, Royo-Torres R, Ortega F (2014) Phylogenetic reassessment of Lourinhasaurus alenquerensis, a basal Macronaria (Sauropoda) from the Upper Jurassic of Portugal. Zool J Linn Soc 170:875–916. https://doi.org/10.1111/zoj.12113
Mocho P, Royo-Torres R, Malafaia E, Escaso F, Ortega F (2016a) Systematic review of Late Jurassic sauropods from the Museu Geológico collections (Lisboa, Portugal). J Iber Geol 42:227–250. https://doi.org/10.5209/rev_JIGE.2016.v42.n2.52177
Mocho P, Royo-Torres R, Malafaia E, Escaso F, Silva B, Ortega F (2016b) Turiasauria-like teeth from the Upper Jurassic of the Lusitanian Basin, Portugal. Hist Biol 28:861–880. https://doi.org/10.1080/08912963.2015.1049948
Mocho P, Royo-Torres R, Ortega F (2017a) New data of the Portuguese brachiosaurid Lusotitan atalaiensis (Sobral Formation, Upper Jurassic). Hist Biol 29:789–817. https://doi.org/10.1080/08912963.2016.1247447
Mocho P, Royo-Torres R, Malafaia E, Escaso F, Ortega F (2017b) Sauropod tooth morphotypes from the Upper Jurassic of the Lusitanian Basin (Portugal). Papers in Palaeontology 3:259–295. https://doi.org/10.1002/spp2.1075
Mocho P, Royo-Torres R, Malafaia E, Escaso F, Ortega F (2017d) First occurrences of non-neosauropod eusauropod procoelous caudal vertebrae in the Portuguese Upper Jurassic record. Geobios 50:23–36. https://doi.org/10.1016/j.geobios.2016.11.001
Mocho P, Royo-Torres R, Ortega F (2019a) A new macronarian sauropod from the Upper Jurassic of Portugal. J Vertebrate Paleontol 39(1):e1578782. https://doi.org/10.1080/02724634.2019.1578782
Mocho, P, Royo-Torres, R, Escaso, F, Malafaia, E, de Miguel Chaves, C, Narváez, I, Pérez-García, A, Pimentel, N, Silva, BC, Ortega, F (2017c) Upper Jurassic sauropod record in the Lusitanian Basin (Portugal): Geographical and lithostratigraphical distribution. Palaeontologia Electronica 20.2.27A: 1–50. https://doi.org/10.26879/662
Mocho, P, Royo-Torres, R, Escaso, F, Malafaia, E, Pérez-García, A, Pimentel, N, Ortega, F (2019b) Diversity and stratigraphic distribution of Diplodocines from the Upper Jurassic of the Lusitanian Basin (Portugal) and the importance of Lourinhã, Peniche and Torres Vedras fossil record, pp. 22. In: Fialho, P.; Silva, R. (eds.), in Livro de Resumos do Paleo Fall Meeting 2019, Universidade de Évora, Évora. ISBN:978–972–778–124–9
Mocho, P, Camilo, B, Mano, AS, Royo-Torres, R, Ortega, F (2022) Sauropods from Upper Jurassic of Portugal: how is the collection of the Sociedade de História Natural revealing new data about the systematics of these giant dinosaurs?, 25–25. In: Fialho, P.; Pereira, S. (eds.), Newsletter da SPdP Sociedade Portuguesa de Paleontologia, NÚMERO 1, 15 de Outubro de 2022
Mocho, P (2016) Evolutionary History of Upper Jurassic Sauropods from the Lusitanian Basin UAM Departamento de Biología. PhD Dissertation, Universidad Autónoma de Madrid https://repositorio.uam.es/handle/10486/675422?show=full
Ortega F, Malafaia E, Escaso F, Pérez-García A, Dantas P (2009) Faunas de répteis do Jurássico superior de Portugal. Paleolusitana 1:43–56
Pérez-García A (2015) Revision of the British record of Tropidemys (Testudines, Plesiochelyidae) and recognition of its presence in the Late Jurassic of Portugal. J Iberian Geol 41:11–20
Pérez-García Adán, Ortega Francisco (2011) Selenemys lusitanica, gen. et sp. Nov., a new pleurosternid turtle (Testudines: Paracryptodira) from the Upper Jurassic of Portugal. In J Vertebrate Paleontol 31(1):60–69. https://doi.org/10.1080/02724634.2011.540054
Pérez-García A, Ortega F (2014) A new species of the turtle Hylaeochelys (Eucryptodira) outside its known geographic and stratigraphic ranges of distribution. CR Palevol 13(3):183–188. https://doi.org/10.1016/j.crpv.2013.10.009
Pérez-García A, Ortega O (2022) New finds of the turtle Plesiochelys in the Upper Jurassic of Portugal and evaluation of its diversity in the Iberian Peninsula. Hist Biol 34:21–129. https://doi.org/10.1080/08912963.2021.1903000
Pérez-García A, Camilo B, Ortega F (2023) New Data on the Poorly Known Jurassic Record of the Turtle Hylaeochelys (Thalassochelydia), Based on New Finds from Portugal. Diversity 15:167. https://doi.org/10.3390/d15020167
Pérez-García A, Camilo B, Ortega F (2024) New data on the shell anatomy of Selenemys lusitanica, the oldest known pleurosternid turtle in Europe. J Iber Geol. https://doi.org/10.1007/s41513-024-00230-4
Pérez-García, A (2012) Las Tortugas Mesozoicas de la Península Ibérica. PhD Dissertation,Universidad Complutense de Madrid https://eprints.ucm.es/16236/
Pérez-Moreno BP, Chure DJ, Pires C, Silva CM, Santos VF, Dantas P, Póvoas L, Cachão M, Sanz JL, Galopim de Carvalho AM (1999) On the presence of Allosaurus fragilis (Theropoda, Carnosauria) in the Upper Jurassic of Portugal: first evidence of an intercontinental dinosaur species. J Geol Soc 156:449–452. https://doi.org/10.1144/gsjgs.156.3.0449
Publications Office of the European Union (2020) Open data maturity report 2019. Publications Office. https://doi.org/10.2830/073835
QGIS.org (2023) QGIS Geographic Information System. QGIS Association. http://www.qgis.org
Rasmussen ES, Lomholt S, Andersen C, Vejbaek OV (1998) Aspects of the structural evolution of the Lusitanian Basin in Portugal and the shelf and slope area offshore Portugal. Tectonophysics 300:199–225. https://doi.org/10.1016/S0040-1951(98)00241-8
Reed B, Wieczorek J, Blum S (2004) Determining Space from Place for Natural History Collections. In a Distributed Digital Library Environment. In D-Lib Magazine 10 (5). https://doi.org/10.1045/may2004-beaman
Rey, J (1999) Lower Cretaceous Depositional Sequences in the Cascais Area, p. 1–57. In European Palaeontological Association Workshop, Field trip A
Rocha, RB (coord.), Marques, BL, Kullberg, JC, Caetano, PC, Lopes, C, Soares, AF, Duarte, LV, Marques, JF, Gomes, CR (1996) The 1st and 2nd rifting phases of the Lusitanian Basin: stratigraphy, sequence analysis and sedimentary evolution. Final Report C. E. C. Proj. MILUPOBAS, Lisboa
Rocha RB, Soares AF (1984) Algumas reflexões sobre a sedimentação jurássica na orla mesocenozóica ocidental de Portugal. Memórias e Notícias 97:133–142
Rotatori FM, Moreno-Azanza M, Mateus A (2022) Reappraisal and new material of the holotype of Draconyx loureiroi (Ornithischia: Iguanodontia) provide insights on the tempo and modo of evolution of thumb-spiked dinosaurs. Zool J Linn Soc 195:125–156. https://doi.org/10.1093/zoolinnean/zlab113
Sabatini, R, Palmerini, G (2008) Differential Global Positioning System (DGPS) for Flight Testing. (Global Positioning System Différentiel (DGPS) pour les essais en vol). In Flight Test Instrumentation Series 21
Schindel DE, Cook JA (2018) The next generation of Natural History collections. In PLoS Biology 16(7):e2006125. https://doi.org/10.1371/journal.pbio.2006125
Schneider S, Fürsich FT, Werner W (2009) Srisotope of the Upper Jurassic of central Portugal (Lusitanian Basin) based on oyster shells. Int J Earth Sci Geologische Rundschau 98:1949–1970. https://doi.org/10.1007/s00531-008-0359-3
Siegel, J (2010) The MDA Foundation Model
Taylor AM, Gowland S, Leary S, Keogh KJ, Martinius AW (2014) Stratigraphical correlation of the Lourinhã Formation in the Consolação Sub-basin (Lusitanian Basin), Portugal. Geol J 49:143–162. https://doi.org/10.1002/gj.2505
Wiechmann, MF, Gloy, U (2000) Pterosaurs and urvogels from the Guimarota mine. In: Martin, T.; Krebs, B. (Eds.). Guimarota: A Jurassic ecosystem. Verlag Dr. Friedrich Pfeil, Munchen. 83–86 pp
Yeung, AKW, Hall, GB (Eds.) (2007) Spatial Database Systems. Dordrecht: Springer Netherlands (The GeoJournal Library). https://doi.org/10.1007/1-4020-5392-4
Young MT, Hua S, Steel L, Foffa D, Brusatte SL, Thüring S, Mateus O, Ruiz-Omeñaca JI, Havlik P, Lepage Y, Andrade MB (2014) Revision of the Late Jurassic teleosaurid genus Machimosaurus (Crocodylomorpha, Thalattosuchia). Royal Soc Open Sci 1:140222. https://doi.org/10.1098/rsos.140222
Acknowledgements
We thank the Municipality of Torres Vedras for their continuous financial and logistic support of SHN activities over the years. A warm word of gratitude to Mr. Jose Joaquim dos Santos for the fantastic collection he gathered and his enthusiasm and willingness to help. A word of appreciation also goes to the Instituto Geográfico do Exército for providing free access to their network of virtual reference stations. We express our appreciation to the company Natural GIS Lda, particularly Giovanni Manghi, for the professional support and consultancy in the field of Open Source GIS. To the company DigiTerra® Information Services Ltd. For providing a license of their Digiterra Explorer, which greatly facilitated field data collection back in 2010-11. To Nuno Patrício, for explaining the intricacies behind including palaeontological heritage in the municipal Master Plan of Torres Vedras, goes another word of appreciation and gratitude. Last but not least, a recognition for the many volunteers who have helped make SHN a reference institution in Paleontology.
Funding
This research was partly funded by the Municipality of Torres Vedras. Pedro Mocho research is funded by the Portuguese Fundação para a Ciência e a Tecnologia (FCT) I.P./MCTES through a CEEC Individual contract (CEECIND/00726/2017).
Author information
Authors and Affiliations
Corresponding author
Ethics declarations
Competing Interests
The authors declare no competing interests.
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Appendix 1
Appendix 1
Figure 10
Rights and permissions
Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/.
About this article
Cite this article
da Silva Mano, A., Silva, B.C., Mocho, P. et al. Location-Based Management of Paleontological Collections using Open Source GIS Software. Geoheritage 16, 38 (2024). https://doi.org/10.1007/s12371-024-00941-1
Received:
Accepted:
Published:
DOI: https://doi.org/10.1007/s12371-024-00941-1