scholarly journals Pengolahan Data Spasial-Geolocation Untuk Menghitung Jarak 2 Titik

2021 ◽  
Vol 8 (1) ◽  
pp. 32
Author(s):  
Ahmad Hajar ◽  
Isnan Nabawi ◽  
Lili Kartikawati ◽  
Fadya Rizka Yudana ◽  
Setia Budi ◽  
...  
Keyword(s):  
Spatial Data ◽  
Geographical Information Systems ◽  
Geographical Information ◽  
Data Types ◽  
Gis Technology ◽  
Database Development ◽  
Location Data ◽  
The City ◽  
Coordinate Data ◽  
Search Information

Perkembangan teknologi Informasi yang berkembang pesat sudah menyentuh ilmu pengetahuan lain seperti perkembangan Sistem Informasi Geografis (SIG). Teknologi SIG memungkinkan sistem dapat menentukan lokasinya dengan memanfaatkan banyak masukan seperti satelit, RFID, WIFI. Geolocation dapat memberikan informasi latitude dan longitude disebut juga dengan koordinat geografis yang merupakan informasi mendasar dari sebuah lokasi di bumi. Basis data dibutuhkan untuk mengembangkan SIG. MySQL sudah mendukung penyimpanan tipe data spasial yang salah satu kelasnya adalah point yang dapat menyimpan data koordinat latitude, longitude dan SRID. Penelitian bertujuan menerapkan teknologi dalam melakukan penyimpanan, memanipulasi data koordinat geografis dan pengolahannya sehingga mendapatkan informasi yang dibutuhkan. Penerapan penelitian dilakukan dengan menambahkan data lokasi beberapa rumah sakit yang ada di kota Yogyakarta, mengubah data lokasi, menampilkan rumah sakit yang terdekat dari titik tertentu, dan menampilkan rumah sakit pada radius tertentu dari titik tertentu. Penelitian membuktikan bahwa tipe data spasial yang menampung data lokasi berupa latitude dan longitude rumah sakit dapat diolah untuk memberikan informasi pencarian rumah sakit terdekat di Yogyakarta dari radius kurang dari sama dengan 3 kilo meter dari titik 110.361994, -7.764768 dalam database yang telah dimiliki.Kata Kunci Data Spasial, Geolocation, Koordinat Geografis, MySQL.The development of information technology that is growing rapidly has touched other sciences such as the development of Geographical Information Systems (GIS). GIS technology allows the system to determine its location by utilizing many inputs such as satellite, RFID, WIFI. Geolocation can provide latitude and longitude information - geographic coordinates which are basic information about a location on earth. Database development to support GIS. MySQL supports the storage of spatial data types, a point class that can store latitude, longitude and SRID coordinate data. This study intends to apply geolocation technology, especially in terms of storing, manipulating geographic coordinate data and processing it so that it gets the information needed. The application of research was carried out by adding the location data of several hospitals in the city of Yogyakarta, change the location data, display the closest hospital from a certain point, and display the hospital in a certain radius from a certain point. Experiments will prove that the spatial data type can be used to obtain search information for the nearest hospital in Yogyakarta from a radius less than 3 kilometers from the point 110.361994, -7.764768 in the database that has been provided.Keywords: Spatial Data, Geolocation, Geographical Coordinates, MySQL.

Spatial and Spatiotemporal Data Types as a Foundation for Representing Space-Time Data in GIS

2017 ◽  
pp. 1-28 ◽  
Author(s):  
Markus Schneider
Keyword(s):  
Spatial Data ◽  
Geographical Information Systems ◽  
Moving Objects ◽  
Spatial Databases ◽  
Query Languages ◽  
Geographical Information ◽  
Spatiotemporal Data ◽  
Data Types ◽  
Time Data ◽  
Use Of Data

A data type comprises a set of homogeneous values together with a collection of operations defined on them. This chapter emphasizes the importance of crisp spatial data types, fuzzy spatial data types, and spatiotemporal data types for representing static, vague, and time-varying geometries in Geographical Information Systems (GIS). These data types provide a fundamental abstraction for modeling the geometric structure of crisp spatial, fuzzy spatial, and moving objects in space and time as well as their relationships, properties, and operations. The goal of this chapter is to provide an overview and description of these data types and their operations that have been proposed in research and can be found in GIS, spatial databases, moving objects databases, and other spatial software tools. The use of data types, operations, and predicates will be illustrated by their embedding into query languages.

Including the spatial dimension: using geographical information systems in hydrology

1996 ◽  
Vol 20 (2) ◽  
pp. 159-177 ◽  
Author(s):  
R.A. McDonnell
Keyword(s):  
Information Systems ◽  
Spatial Data ◽  
Geographical Information Systems ◽  
Spatial Dimension ◽  
Geographical Information ◽  
Gis Technology ◽  
Gis Data ◽  
Spatial Data Models ◽  
The Many ◽  
Hydrological Applications

Developments in geographical information systems (GIS) technology have coincided with moves within hydrology to a more explicit accounting of space through distributed rather than lumped or topological representations. GIS support these spatial data models and provide integrating, measuring and analytical capabilities which have been used in many hydrological applications ranging from inventory and assessment studies through to process modelling. The many examples in the article illustrate how the technology has supported moves away from averaged value representations for catchments towards a greater inclusion of spatial variations in hydrological studies. While the potential of these systems is gradually being realized, there are still various issues, both technical and methodological, which at present limit their use. As new data sources become available, GIS data structures become more flexible and open, and, as the understanding of scale variations in processes improves, the possibilities for using the technology in hydrological research will expand.

scholarly journals Modeling accessibility of community facilities using GIS: case study of Depok City, Indonesia

2017 ◽  
Vol 1 (2) ◽  
pp. 36-43 ◽  
Author(s):  
Herika Muhamad Taki ◽  
Muhammad Zainuddin Lubis
Keyword(s):  
Land Use ◽  
Information Systems ◽  
Spatial Data ◽  
Geographical Information Systems ◽  
Social Issues ◽  
Spatial Models ◽  
Geographical Information ◽  
Community Issues ◽  
Community Facilities ◽  
The City

Improving community accessibility based on transport connectivity helps to address equity issues. Geographical information systems (GIS) provide useful techniques for capturing, maintaining and analyzing spatial data to defining community issues. The objective of this study is to model accessibility of community facilities using GIS based on private car, bus and train in the city area of Depok, Indonesia. The study modeling the accessibility of community facilities using Geographical information systems (GIS). A geodatabase of community facilities that includes the location of the mall, schools, hospital, mosque, and lake and also supporting data such as street and road network, the number of population, density and land use. The geodatabase covers defining community facilities and modeling accessibility by car, by bus, and by train and analyzing the social pattern. The results obtained from the spatial pattern of accessibility based on the different modes of transportation using the method of network analysis and buffering operations underlines the existence of different patterns. Car transport mode is a commonly accessible mode of community-related to land use interpretation and social issues. The conclusion is that there are differences in the spatial models at the city level in terms of the use of transportation accessibility

scholarly journals Transport infrastructure indicators for assessing the social comfort of the urban environment

2021 ◽  
Vol 284 ◽  
pp. 06010
Author(s):  
Natalia Martynova ◽  
Valentina Budarova
Keyword(s):  
Urban Environment ◽  
Spatial Data ◽  
Geographical Information Systems ◽  
Information Technologies ◽  
The State ◽  
Urban Transport ◽  
Transport Infrastructure ◽  
Geographical Information ◽  
Social Comfort ◽  
The City

Cities are a complex social institution. A special feature of cities is the development of engineering and transport infrastructure. In this article, to assess the state of the urban agglomeration, the transport system of the city is considered as an indicator of social comfort. As part of the support, control and management of the urban environment, administrative authorities use information technologies that are implemented using geographical information systems (GIS). These GIS take into account all indicators of social comfort, which are based on spatial data about the urban environment. From this, we present the concept of an urban environment data management model for public authorities. The model is based on geoinformation systems. Since the geoinformation analysis allows you to create thematic maps of the urban environment with their subsequent assessment and calculation of indicators of social comfort. For this purpose, an analysis algorithm is presented for the main indicators of transport infrastructure assessment. Thus, this study provides an opportunity to assess the state of the city model and set goals for the development of urban transport networks to increase the level of social comfort of the population.

Spatial Network Databases

2009 ◽  
pp. 307-315 ◽  
Author(s):  
Michael Vassilakopoulos
Keyword(s):  
Information Systems ◽  
Spatial Data ◽  
Computer Aided Design ◽  
Geographical Information Systems ◽  
Large Scale ◽  
Spatial Databases ◽  
Query Language ◽  
Geographical Information ◽  
Data Types ◽  
Large Scale Integration

A Spatial Database is a database that offers spatial data types, a query language with spatial predicates, spatial indexing techniques, and efficient processing of spatial queries. All these fields have attracted the focus of researchers over the past 25 years. The main reason for studying spatial databases has been applications that emerged during this period, such as Geographical Information Systems, Computer-Aided Design, Very Large Scale Integration design, Multimedia Information Systems, and so forth. In parallel, the field of temporal databases, databases that deal with the management of timevarying data, attracted the research community since numerous database applications (i.e., Banking, Personnel Management, Transportation Scheduling) involve the notion of time.

scholarly journals Using Social Media Data to Map Mortar Shells Falling in Damascus, Syria

2021 ◽  
Vol 27 (2) ◽  
pp. 233-240
Author(s):  
Mohamad Hasan
Keyword(s):  
Social Media ◽  
Information Systems ◽  
Spatial Data ◽  
Geographical Information Systems ◽  
Hot Spot ◽  
Geographical Information ◽  
Data Types ◽  
Social Phenomena ◽  
Social Media Data ◽  
Media Data

The paper analyzes the use of social media data in geographical information systems to map the areas most affected by mortar shells in the capital of Syria, Damascus, by using geocoded and parsed social media data in geographical information systems. This paper describes a created algorithm to collecting and store data from social media sites. For the data store both a NoSQL database to save JSON format document and an RDBMS is used to save other spatial data types. A python script was written to collect the data in social media based on certain keywords related to the search. A geocoding algorithm to locate social media posts that normalize, standardize and tokenize the text was developed. The result of the developed diagram provided a year by year from 2013 to 2018 maps for mortar shell falling locations in Damascus. These layers give an overview for the changing of the numbers of mortar shells falls or in hot spot analysis for the city. Finally, social media data can prove to be useful when creating maps for dynamic social phenomena, for example, mortar shells’ location falling in Damascus, Syria. Moreover, social media data provide easy, massive, and timestamped data which makes these phenomena easier to study.

scholarly journals Street context of various demographic groups in their daily mobility

2021 ◽  
Vol 6 (1) ◽  
Author(s):  
Ariel Salgado ◽  
Weixin Li ◽  
Fahad Alhasoun ◽  
Inés Caridi ◽  
Marta Gonzalez
Keyword(s):  
Geographical Information Systems ◽  
Building Blocks ◽  
Geographical Information ◽  
Unified Framework ◽  
Demographic Groups ◽  
Daily Mobility ◽  
Urban Science ◽  
Science Framework ◽  
The City ◽  
Racial Ethnic

AbstractWe present an urban science framework to characterize phone users’ exposure to different street context types based on network science, geographical information systems (GIS), daily individual trajectories, and street imagery. We consider street context as the inferred usage of the street, based on its buildings and construction, categorized in nine possible labels. The labels define whether the street is residential, commercial or downtown, throughway or not, and other special categories. We apply the analysis to the City of Boston, considering daily trajectories synthetically generated with a model based on call detail records (CDR) and images from Google Street View. Images are categorized both manually and using artificial intelligence (AI). We focus on the city’s four main racial/ethnic demographic groups (White, Black, Hispanic and Asian), aiming to characterize the differences in what these groups of people see during their daily activities. Based on daily trajectories, we reconstruct most common paths over the street network. We use street demand (number of times a street is included in a trajectory) to detect each group’s most relevant streets and regions. Based on their street demand, we measure the street context distribution for each group. The inclusion of images allows us to quantitatively measure the prevalence of each context and points to qualitative differences on where that context takes place. Other AI methodologies can further exploit these differences. This approach presents the building blocks to further studies that relate mobile devices’ dynamic records with the differences in urban exposure by demographic groups. The addition of AI-based image analysis to street demand can power up the capabilities of urban planning methodologies, compare multiple cities under a unified framework, and reduce the crudeness of GIS-only mobility analysis. Shortening the gap between big data-driven analysis and traditional human classification analysis can help build smarter and more equal cities while reducing the efforts necessary to study a city’s characteristics.

scholarly journals A Geospatial database of gastric cancer patients and associated potential risk factors including lifestyle and air pollution

2021 ◽  
Vol 14 (1) ◽  
Author(s):  
Fatemeh Hashemi Amin ◽  
Mahtab Ghaemi ◽  
Sayyed Mostafa Mostafavi ◽  
Ladan Goshayeshi ◽  
Khadijeh Rezaei ◽  
...  
Keyword(s):  
Risk Factors ◽  
Gastric Cancer ◽  
Cancer Patients ◽  
Spatial Data ◽  
Geographical Information Systems ◽  
Dietary Habits ◽  
Age Groups ◽  
Geographical Location ◽  
Geographical Information ◽  
Point Feature

Abstract Objectives Gastric cancer (GC) is a multifactorial disease and the fifth most frequent diagnosed cancer worldwide. It accounts for one third of cancer-related mortalities. Geospatial analysis using geographical information systems (GIS) can provide an efficient solution to identify spatial disparities associated with GC. As such, GIS enables policymakers to control cancer in a better way and identify the regions where interventions are needed. This study aims to publish a comprehensive dataset, which was applied to conduct a spatial analysis of GC patients in the city of Mashhad, Iran. Data description We provide a personal geodatabase, a Microsoft Access database that can store, query, and manage both spatial and non-spatial data, which contains four feature classes. “Male_Stomach_Cancer_Patients” and “Female_Stomach_Cancer_Patients” are point feature classes, which show the age and geographical location of 1156 GC cancer patients diagnosed between 2014 and 2017. “Air_Polution_Mashhad” is another point feature class that reveals the amount of six air pollutants, which was taken from Mashhad Environmental Pollutants Monitoring Center between 2017 and 2018. Finally, “Stomach_Cancer_and_Risk_Factors” is a polygon feature class of neighborhood division of Mashhad, consisting of contributor risk factors including dietary habits, smoking, alcohol use, body mass index and population by age groups for all 165 city neighborhoods.

A Geographical Information System (GIS) study of Triassic vertebrate biochronology

2005 ◽  
Vol 142 (4) ◽  
pp. 327-354 ◽  
Author(s):  
E. J. RAYFIELD ◽  
P. M. BARRETT ◽  
R. A. McDONNELL ◽  
K. J. WILLIS
Keyword(s):  
Spatial Data ◽  
Geographical Information Systems ◽  
Western Europe ◽  
Temporal Distribution ◽  
Geographical Information ◽  
Late Triassic ◽  
Spatial And Temporal Scales ◽  
Potential Index ◽  
The Stability ◽  
Land Vertebrate

Geographical Information Systems (GIS) have been applied extensively to analyse spatial data relating to varied environmental issues, but have not so far been used to address biostratigraphical or macroevolutionary questions over extended spatial and temporal scales. Here, we use GIS techniques to test the stability, validity and utility of proposed Middle and Late Triassic ‘Land Vertebrate Faunachrons’ (LVFs), a global biostratigraphical framework based upon terrestrial/freshwater tetrapod occurrences. A database of tetrapod and megafloral localities was constructed for North America and Western Europe that also incorporated information on relevant palaeoenvironmental variables. This database was subjected to various spatial analysis techniques. Our GIS analysis found support at a global level for Eocyclotosaurus as an Anisian index taxon and probably Aetosaurus as a Norian indicator. Other tetrapod taxa are useful biostratigraphical/biochronological markers on a regional basis, such as Longosuchus and Doswellia for Late Carnian time. Other potential index fossils are hampered, however, by taxonomic instability (Mastodonsaurus, Metoposaurus, Typothorax, Paleorhinus, Pseudopalatus, Redondasaurus, Redondasuchus) and/or are not clearly restricted in temporal distribution (Paleorhinus, Angistorhinus, Stagonolepis, Metoposaurus and Rutiodon). This leads to instability in LVF diagnosis. We found only in the western Northern Hemisphere is there some evidence for an Anisian–Ladinian biochronological unit amalgamating the Perovkan and Berdyankian LVFs, and a possible late Carnian unit integrating the Otischalkian and Adamanian.Megaplants are generally not useful for biostratigraphical correlation in the Middle and Upper Triassic of the study area, but there is some evidence for a Carnian-age floral assemblage that corresponds to the combined Otischalkian and Adamanian LVFs. Environmental biases do not appear to strongly affect the spatial distribution of either the tetrapods or megaplants that have been proposed as index taxa in biostratigraphical schemes, though several examples of apparent environmental bias were detected by the analysis. Consequently, we argue that further revision and refinement of Middle and Late Triassic LVFs is needed before they can be used to support global or multi-regional biostratigraphical correlations. Caution should therefore be exercised when using the current scheme as a platform for macroevolutionary or palaeoecological hypotheses. Finally, this study demonstrates the potential of GIS as a powerful tool for tackling palaeontological questions over extended timescales.

scholarly journals Optimal Site Selection for Sittinga Solar Park using Multi-Criteria Decision Analysis and Geographical Information Systems (GIS)

2016 ◽  
Author(s):  
Andreas Georgiou ◽  
Dimitrios Skarlatos
Keyword(s):  
Spatial Data ◽  
Geographical Information Systems ◽  
Power Plants ◽  
Solar Power ◽  
Geographical Information ◽  
Optimal Placement ◽  
Equal Weight ◽  
Analysis Tool ◽  
Study Region ◽  
Weighting Schemes

Abstract. Among the renewable powers sources, solar is rapidly becoming popular being inexhaustible, clean, and dependable. It is also becoming more efficient since the photovoltaic solar cells' power conversion efficiency is rising. Following these trends, solar power will become more affordable in years to come and considerable investments are to be expected. Despite the size of solar plants, the sitting procedure is a crucial factor for their efficiency and financial viability. Many aspects rule such decision; legal, environmental, technical, and financial to name some. This paper describes a general integrated framework to evaluate land suitability for the optimal placement of photovoltaic solar power plants, which is based on a combination of a Geographic Information System (GIS), remote sensing techniques and multi-criteria decision making methods. An application of the proposed framework for Limassol District in Cyprus is further illustrated. The combination of GIS and multi-criteria methods, consist an excellent analysis tool that creates an extensive database of spatial and non spatial data that will be used to simplify problems, to solve and promote the use of multiple criteria. A set of environmental, economic, social and technical constrains based on recent Cypriot legislation, European's Union policies and experts' advices, identifies the potential sites for solar park installation. The pair-wise comparison method in the context of the analytic hierarchy process (AHP) is applied to estimate the criteria weights in order to establish their relative importance in site evaluation. In addition, four different methods to combine information layers and check their sensitivity were used. The first considered all the criteria as being equally important and assign them equal weight, while the others grouped the criteria and graded them according to their objective perceived importance. The overall suitability of the study region for sitting solar park is appraised through the summation rule. Strict application of the framework depicts 3.0 % of the study region scoring best suitability index for solar resource exploitation, hence minimizing risk of a potential investment. However, using different weighting schemes for criteria, suitable areas may reach up to 83 % of the study region. The suggested methodological framework applied can be easily utilized by potential investors and renewable energy developers, through a front end web based application with proper GUI for personalized weighting schemes.

Sign in / Sign up

Export Citation Format

Share Document