Evolução da paisagem do baixo curso do rio de Piranhas-Assu (1988-2024): uso de autômatos celulares em modelo dinâmico espacial para simulação de cenários futuros

The lower course of Piranhas-Assu river, located in the north coast of Rio Grande do Norte, Brazil, arouses a keen interest as a study field, once it concentrates, besides petroleum and gas exploration, activities related to shrimp culture, salt and horticulture, factors that also deserve special attention. Thus, the awareness of the study field environmental stage demands studies from researchers and discernment from society, as a way of understanding the inter-relation between environment and men. Therefore, this work attempts at understanding and studying the dynamics of land use in the lower course of Piranhas-Assu river, through a multitemporal analysis of present and past, accomplishing future projections through simulation models. The work is divided in stages that include the research, analysis, interpretation of results, and the generation of simulation models, to analyze the landscape tendencies, making possible to identify indicators which cause such changes in the lower course of the river. From Geographical Database, the necessary exploratory analyses were accomplished to the following items: land use evolution, natural and environmental vulnerability, multiple geodiversity indexes, and preparation of the data to be used in the simulation model. Later, the construction of the landscape simulation model was conducted. Sequentially, simulations of future sceneries were accomplished through the execution of the model in a specific software environment. Last, the analyses of landscape tendencies in the study field were carried out. The lower course of Piranhas-Assu River didn't show any intense dynamics in landscape changing, once in the period taken into account (from 1988 to 2004) class stability proved to be superior to its transformations. Activities related to agriculture and livestock are the ones that influence, mostly, the landscape dynamics. The production of sea shrimp and petroleum also infers in the landscape, although in smaller proportion. INCRA s public policies excessively determined the dynamics of the landscape in the lower course of Piranhas-Assu River, RN. In respect to its natural vulnerability, the lower course of Piranhas-Assu River, RN, features more vulnerable than stable areas. The landscape simulation, in the first taken period (2004-2009), indicated considerable increases and decreases of antropic activities, if compared to its sequent periods (2009-2014, 2014-2019 and 2019-2024). The simulation, in a wider analysis, showed that the determining factors for the space mobility of antropic activities, in the focused area, are related to the pre-existence of communities with agricultural capability and to the existence of access routes and drainage. Considering the area that features fixed and mobile dunes, located in Porto do Mangue district, we recommend its conversion into a conservation area

Desenvolvimento de um sistema computacional para geração automática de mapas de vulnerabilidade como ferramenta de auxílio às ações de prevenção ao derramamento de óleo em áreas costeiras

The northern portion of the Rio Grande do Norte State is characterized by intense coastal dynamics affecting areas with ecosystems of moderate to high environmental sensitivity. In this region are installed the main socioeconomic activities of RN State: salt industry, shrimp farm, fruit industry and oil industry. The oil industry suffers the effects of coastal dynamic action promoting problems such as erosion and exposure of wells and pipelines along the shore. Thus came the improvement of such modifications, in search of understanding of the changes which causes environmental impacts with the purpose of detecting and assessing areas with greater vulnerability to variations. Coastal areas under influence oil industry are highly vulnerable and sensitive in case of accidents involving oil spill in the vicinity. Therefore, it was established the geoenvironmental monitoring of the region with the aim of evaluating the entire coastal area evolution and check the sensitivity of the site on the presence of oil. The goal of this work was the implementation of a computer system that combines the needs of insertion and visualization of thematic maps for the generation of Environmental Vulnerability maps, using techniques of Business Intelligence (BI), from vector information previously stored in the database. The fundamental design interest was to implement a more scalable system that meets the diverse fields of study and make the appropriate system for generating online vulnerability maps, automating the methodology so as to facilitate data manipulation and fast results in cases of real time operational decision-making. In database development a geographic area was established the conceptual model of the selected data and Web system was done using the template database PostgreSQL, PostGis spatial extension, Glassfish Web server and the viewer maps Web environment, the GeoServer. To develop a geographic database it was necessary to generate the conceptual model of the selected data and the Web system development was done using the PostgreSQL database system, its spatial extension PostGIS, the web server Glassfish and GeoServer to display maps in Web

Organização e implementação de um banco de dados para a sensibilidade ambiental ao óleo e avaliaçao de ações adequadas de resposta a derramamentos - São Sebastião (SP)

The need to know and to preserve the coastal ecosystems is justified by the whole importance that those ecosystems have for our society. Then, it is big the concern in guaranteeing that those places stay free from contaminations. Among the several types of potentials pollutants that can affect the coastal systems, the petroleum-derived are the ones that cause the worst impacts, given the frequency of these accidents. Rapid actions are necessary in order to minimize the oil negative effects . This answer is faster when the most sensitive areas are known and when it presents characteristics of larger importance, as for instance, the presence of sea harvesting or the habitat of an endemic specie. Besides, it is necessary to know which cleanup methods are recommended and which are not recommended for the reached areas, so, the corrected emergency plans for each coastal environment can be applied. It is in this context that this project was developed, implementing a geographical database for the different coastal environment of São Sebastião municipality, SP, and also the data about the best cleanup techniques for each segment of the coast. This database was made available by the internet, enabling the access for several types of users.

Database Engines for Geographical Information Systems

Our ability to identify, acquire, store, enquire on and analyse data is increasing as never before, especially in the GIS field. Technologies are becoming available to manage a wider variety of data and to make intelligent inferences on that data. The mainstream arrival of large-scale database engines is not far away. The experience of using the first such products tells us that they will radically change data management in the GIS field.

AstroWeb – A Graphical Representation of an Astronomical WFPDB Database Using a Web-Based Open Source Geographical Information System

ACM Computing Classification System (1998): H.5.2, H.2.8, J.2, H.5.3.

Compiling a GIS database of tree farms on Leyte Island

As part of ACIAR project ASEM/2003/052, Improving Financial Returns to Smallholder Tree Farmers in the Philippines, plantations of timber trees in Leyte Island, the Philippines were located using a systematic survey of the island. The survey was undertaken in order to compile a database of plantations which could be used to guide the planning of project activities. In addition to recording a range of qualitative and quantitative information for each plantation, the survey spatially referenced each site using a Global Positioning System (GPS) to electronic maps of the island which were held in a Geographical Information System (GIS). Microsoft Excel and Mapsource® software were used as the software links between GPS coordinates and the GIS. Mapping of farm positions was complicated by different datums being used for maps of Leyte Island and this caused GPS positions to be displaced from equivalent positions on the map. Photos of the sites were hyperlinked to their map positions in the GIS in order to assist staff to recall site characteristics.

An integrated database on ticks and tick-borne zoonoses in the tropics and subtropics with special reference to developing and emerging countries

Tick-borne zoonoses (TBZ) are emerging diseases worldwide. A large amount of information (e.g. case reports, results of epidemiological surveillance, etc.) is dispersed through various reference sources (ISI and non-ISI journals, conference proceedings, technical reports, etc.). An integrated database-derived from the ICTTD-3 project (http://www.icttd.nl)-was developed in order to gather TBZ records in the (sub-)tropics, collected both by the authors and collaborators worldwide. A dedicated website (http://www.tickbornezoonoses.org) was created to promote collaboration and circulate information. Data collected are made freely available to researchers for analysis by spatial methods, integrating mapped ecological factors for predicting TBZ risk. The authors present the assembly process of the TBZ database: the compilation of an updated list of TBZ relevant for (sub-)tropics, the database design and its structure, the method of bibliographic search, the assessment of spatial precision of geo-referenced records. At the time of writing, 725 records extracted from 337 publications related to 59 countries in the (sub-)tropics, have been entered in the database. TBZ distribution maps were also produced. Imported cases have been also accounted for. The most important datasets with geo-referenced records were those on Spotted Fever Group rickettsiosis in Latin-America and Crimean-Congo Haemorrhagic Fever in Africa. The authors stress the need for international collaboration in data collection to update and improve the database. Supervision of data entered remains always necessary. Means to foster collaboration are discussed. The paper is also intended to describe the challenges encountered to assemble spatial data from various sources and to help develop similar data collections.

Evaluating Australia's National Medicines Policy using geographical mapping

Background: There has been a proliferation of quality use of medicines activities in Australia since the 1990s. However, knowledge of the nature and extent of these activities was lacking. A mechanism was required to map the activities to enable their coordination. Aims: To develop a geographical mapping facility as an evaluative tool to assist the planning and implementation of Australia's policy on the quality use of medicines. Methods: A web-based database incorporating geographical mapping software was developed. Quality use of medicines projects implemented across the country was identified from project listings funded by the Quality Use of Medicines Evaluation Program, the National Health and Medical Research Council, Mental Health Strategy, Rural Health Support, Education and Training Program, the Healthy Seniors Initiative, the General Practice Evaluation Program and the Drug Utilisation Evaluation Network. In addition, projects were identified through direct mail to persons working in the field. Results: The Quality Use of Medicines Mapping Project (QUMMP) was developed, providing a Web-based database that can be continuously updated. This database showed the distribution of quality use of medicines activities by: (i) geographical region, (ii) project type, (iii) target group, (iv) stakeholder involvement, (v) funding body and (vi) evaluation method. At September 2001, the database included 901 projects. Sixty-two per cent of projects had been conducted in Australian capital cities, where approximately 63% of the population reside. Distribution of projects varied between States. In Western Australia and Queensland, 36 and 73 projects had been conducted, respectively, representing approximately two projects per 100 000 people. By comparison, in South Australia and Tasmania approximately seven projects per 100 000 people were recorded, with six per 100 000 people in Victoria and three per 100 000 people in New South Wales. Rural and remote areas of the country had more limited project activity. Conclusions: The mapping of projects by geographical location enabled easy identification of high and low activity areas. Analysis of the types of projects undertaken in each region enabled identification of target groups that had not been involved or services that had not yet been developed. This served as a powerful tool for policy planning and implementation and will be used to support the continued implementation of Australia's policy on the quality use of medicines.

A Web-Based geographical information system prototype on Portuguese traditional food products

Dissertation submitted in partial fulfilment of the requirements for the Degree of Master of Science in Geospatial Technologies

Synanthropic triatomines (Hemiptera, Reduviidae) in the state of Pernambuco, Brazil: geographical distribution and natural Trypanosoma infection rates between 2006 and 2007

INTRODUCTION: The present study shows a descriptive analysis of triatomine occurrence and its natural Trypanosoma infection rates in the state of Pernambuco, Brazil, between 2006 and 2007. METHODS: Entomological data for the species, such as specimens captured in both intra and peridomiciles and natural infection index, were obtained via domiciliary capture in 147 municipalities from 11 Regional Managements of Health. The database was obtained from a sample of insects (100% infected and 20% non-infected) sent to the Central Laboratory of Pernambuco. RESULTS: A total of 18,029 triatomines were analyzed from 138 municipalities of the state. Triatoma pseudomaculata (35%), Triatoma brasiliensis (34%), and Panstrongylus lutzi (25%) were the most captured species. These species also showed a widespread geographical distribution in the state. Panstrongylus megistus, Triatoma petrocchiae, Triatoma melanocephala, Triatoma sordida, Rhodnius nasutus, Rhodnius neglectus, and Triatoma infestans showed more limited geographical distribution and lower relative abundance. The parasitological research showed that 8.8% of the triatomines were naturally infected with flagellates morphologically similar to Trypanosoma cruzi and 91.3% of them were captured inside houses in 113 municipalities. P. lutzi showed the highest rates of natural infection. CONCLUSIONS: After the control of T. infestans, synanthropic species, such as T. brasiliensis, T. pseudomaculata, and P. lutzi, maintain the risk of T. cruzi transmission to humans in the state of Pernambuco. These species are widely distributed, and infected specimens have been found inside houses. Thus, an enhanced surveillance and vector control of Chagas disease is recommended in Pernambuco.

Perceptions of Europe in political and economic elites: a geographical compared analysis of Germany, Spain and Poland

Elite perceptions about Europe are a very important point in order to understand the current European integration process, as well as the future perspectives for the continent. This study makes a comparison between the perceptions which political and economical elites in some European countries have about the European Union process and its mechanisms. The main goal is to identify the differences in positions of each type of elites, as well as the variations among three key countries. The database built thanks to the INTUNE (Integrated and United? A quest for Citizenship in an ¨ever closer Europe¨) Project Survey on European Elites and Masses, funded by the Sixth Framework Programme of the EU [Contract CIT 3-CT-2005-513421] have being used. The questionnaire was applied between February and May 2007, in a total of 18 European countries. The national teams got a total of almost 2000 valid responses at European level. In the analysis we have showed some general descriptive statistics about the perception of Europe taking as a reference two dimensions of the INTUNE project: identity (attachment to the national level, the meaning of being a truly national, and the threats from Turkey that EU is facing at this moment) and representation (trust in European and national institutions, preferences for a national or an European army). The results are presented distinguishing between political (national MP’s in low chambers) and economical elites (presidents of corporations, general managers…) and, at the same time, among three countries: Germany as an original member of the European Union; Spain, incorporated in 1986; and a new member, Poland, joining the EU in 2004.

OpenFluDB, a database for human and animal influenza virus.

Although research on influenza lasted for more than 100 years, it is still one of the most prominent diseases causing half a million human deaths every year. With the recent observation of new highly pathogenic H5N1 and H7N7 strains, and the appearance of the influenza pandemic caused by the H1N1 swine-like lineage, a collaborative effort to share observations on the evolution of this virus in both animals and humans has been established. The OpenFlu database (OpenFluDB) is a part of this collaborative effort. It contains genomic and protein sequences, as well as epidemiological data from more than 27,000 isolates. The isolate annotations include virus type, host, geographical location and experimentally tested antiviral resistance. Putative enhanced pathogenicity as well as human adaptation propensity are computed from protein sequences. Each virus isolate can be associated with the laboratories that collected, sequenced and submitted it. Several analysis tools including multiple sequence alignment, phylogenetic analysis and sequence similarity maps enable rapid and efficient mining. The contents of OpenFluDB are supplied by direct user submission, as well as by a daily automatic procedure importing data from public repositories. Additionally, a simple mechanism facilitates the export of OpenFluDB records to GenBank. This resource has been successfully used to rapidly and widely distribute the sequences collected during the recent human swine flu outbreak and also as an exchange platform during the vaccine selection procedure. Database URL: http://openflu.vital-it.ch.

Development of LRFD Procedures for Bridge Pile Foundations in Iowa, Volume I: An Electronic Database for PIle LOad Tests (PILOT), TR-573, 2011

For well over 100 years, the Working Stress Design (WSD) approach has been the traditional basis for geotechnical design with regard to settlements or failure conditions. However, considerable effort has been put forth over the past couple of decades in relation to the adoption of the Load and Resistance Factor Design (LRFD) approach into geotechnical design. With the goal of producing engineered designs with consistent levels of reliability, the Federal Highway Administration (FHWA) issued a policy memorandum on June 28, 2000, requiring all new bridges initiated after October 1, 2007, to be designed according to the LRFD approach. Likewise, regionally calibrated LRFD resistance factors were permitted by the American Association of State Highway and Transportation Officials (AASHTO) to improve the economy of bridge foundation elements. Thus, projects TR-573, TR-583 and TR-584 were undertaken by a research team at Iowa State University’s Bridge Engineering Center with the goal of developing resistance factors for pile design using available pile static load test data. To accomplish this goal, the available data were first analyzed for reliability and then placed in a newly designed relational database management system termed PIle LOad Tests (PILOT), to which this first volume of the final report for project TR-573 is dedicated. PILOT is an amalgamated, electronic source of information consisting of both static and dynamic data for pile load tests conducted in the State of Iowa. The database, which includes historical data on pile load tests dating back to 1966, is intended for use in the establishment of LRFD resistance factors for design and construction control of driven pile foundations in Iowa. Although a considerable amount of geotechnical and pile load test data is available in literature as well as in various State Department of Transportation files, PILOT is one of the first regional databases to be exclusively used in the development of LRFD resistance factors for the design and construction control of driven pile foundations. Currently providing an electronically organized assimilation of geotechnical and pile load test data for 274 piles of various types (e.g., steel H-shaped, timber, pipe, Monotube, and concrete), PILOT (http://srg.cce.iastate.edu/lrfd/) is on par with such familiar national databases used in the calibration of LRFD resistance factors for pile foundations as the FHWA’s Deep Foundation Load Test Database. By narrowing geographical boundaries while maintaining a high number of pile load tests, PILOT exemplifies a model for effective regional LRFD calibration procedures.

Objectively measured physical activity and sedentary time in youth: the International children's accelerometry database (ICAD).

BACKGROUND: Physical activity and sedentary behaviour in youth have been reported to vary by sex, age, weight status and country. However, supporting data are often self-reported and/or do not encompass a wide range of ages or geographical locations. This study aimed to describe objectively-measured physical activity and sedentary time patterns in youth. METHODS: The International Children's Accelerometry Database (ICAD) consists of ActiGraph accelerometer data from 20 studies in ten countries, processed using common data reduction procedures. Analyses were conducted on 27,637 participants (2.8-18.4 years) who provided at least three days of valid accelerometer data. Linear regression was used to examine associations between age, sex, weight status, country and physical activity outcomes. RESULTS: Boys were less sedentary and more active than girls at all ages. After 5 years of age there was an average cross-sectional decrease of 4.2 % in total physical activity with each additional year of age, due mainly to lower levels of light-intensity physical activity and greater time spent sedentary. Physical activity did not differ by weight status in the youngest children, but from age seven onwards, overweight/obese participants were less active than their normal weight counterparts. Physical activity varied between samples from different countries, with a 15-20 % difference between the highest and lowest countries at age 9-10 and a 26-28 % difference at age 12-13. CONCLUSIONS: Physical activity differed between samples from different countries, but the associations between demographic characteristics and physical activity were consistently observed. Further research is needed to explore environmental and sociocultural explanations for these differences.

Construction and validation of a scoring system for the selection of high-quality data in a Spanish population primary care database (SIDIAP)

Background Computerised databases of primary care clinical records are widely used for epidemiological research. In Catalonia, the InformationSystem for the Development of Research in Primary Care (SIDIAP) aims to promote the development of research based on high-quality validated data from primary care electronic medical records. Objective The purpose of this study is to create and validate a scoring system (Registry Quality Score, RQS) that will enable all primary care practices (PCPs) to be selected as providers of researchusable data based on the completeness of their registers. Methods Diseases that were likely to be representative of common diagnoses seen in primary care were selected for RQS calculations. The observed/ expected cases ratio was calculated for each disease. Once we had obtained an estimated value for this ratio for each of the selected conditions we added up the ratios calculated for each condition to obtain a final RQS. Rate comparisons between observed and published prevalences of diseases not included in the RQS calculations (atrial fibrillation, diabetes, obesity, schizophrenia, stroke, urinary incontinenceand Crohn’s disease) were used to set the RQS cutoff which will enable researchers to select PCPs with research-usable data. Results Apart from Crohn’s disease, all prevalences were the same as those published from the RQS fourth quintile (60th percentile) onwards. This RQS cut-off provided a total population of 1 936 443 (39.6% of the total SIDIAP population). Conclusions SIDIAP is highly representative of the population of Catalonia in terms of geographical, age and sex distributions. We report the usefulness of rate comparison as a valid method to establish research-usable data within primary care electronic medical records