Petra Karin · University of Split Repository · 2025
Ovaj rad istražuje prostorne baze podataka s fokusom na implementaciju unutar Microsoft SQL Servera. Cilj rada je kroz teorijsku analizu i praktičnu demonstraciju dati pregledosnovnih principa prostornih baza podataka uključujući pregled tipova prostornih podatakate prikaz njihove obrade kroz primjenu prostornih upita i prostornih indeksa.
Cited by 0Open access
2013
Cited by 0
Petr Glos · 2006
Cited by 0
Albert K. W. Yeung, G. Brent Hall · The Geojournal library · 2007
Cited by 4
Polách, Ondřej · Brno University of Technology Digital Library (Brno University of Technology) · 2012
Na databázové systémy jsou kladeny stále vyšší požadavky, protože uživatelé potřebují pracovat se stále složitějšími daty.Díky historickému vývoji databázových systémů, se v dnešní době používají hlavně postrelační databázové systémy. Jak již plyne z jejich názvu, jsou postaveny na relačních databázových systémech a rozšiřují je tak, aby byly schopny pracovat se složitějšími daty. Velká většina dnešních prostorových databázových systémů je založena právě na postrelačních databázích. Tato práce se ovšem bude snažit najít spojení mezi objektovými a prostorovými databázemi a nabité poznatky reflektovat do implementace prostorového rozšíření objektové databáze.
Cited by 0
Elsevier eBooks · 1991
Cited by 0
Peter Dahlhaus · FedUni ResearchOnline (Federation University Australia)
The UB Spatial erosion database is part of an interoperable web-GIS maintained by the University of Ballarat. It records data on the spatial distribution of soil erosion points, lines and polygons that have been mapped for soil erosion research projects undertaken by the University. The UB Spatial website was initially developed with funding support from the Corangamite Catchment Management Authority and contained four environmental datasets: groundwater bores, salinity, erosion and landslides, covering the Corangamite region. The UB Spatial erosion database contains information on the spatial extents, type, source, capture method and assessment date of the erosion in the Corangamite Catchment Authority region. The UB spatial erosion database is infrequently updated. https://soilhealth.ccmaknowledgebase.vic.gov.au/soils_map.php
Cited by 0
Timothy Nyerges · Geographic Information Science & Technology Body of Knowledge · 2021
Cited by 2Open access
Mooney, Fintan, Black-Ingersoll, Flannery, Willis, Mary · Harvard Dataverse · 2025
The Highway Reclamation Spatial Database contains geospatial data for major U.S. highway reclamation projects (1991–2022). These projects involve the full or partial removal of highway infrastructure and their conversion to at-grade boulevards, streets, parks, or other public open spaces. We created this database to provide researchers with accurate georeferenced locations and attributes of major highway reclamation projects. For more information on the potential health implications of highway reclamation, please see: Willis, M. D., Mooney, F., Weuve, J., Hystad, P., Walker, H., Walker, A., Stelly, A., Fox, S., & Lees, L. (2024). The Promises and Potential Pitfalls of Highway Reclamation for Population Health: A Research Framework. Journal of urban health : bulletin of the New York Academy of Medicine, 101(6), 1270–1273. https://doi.org/10.1007/s11524-024-00933-0.
Cited by 0Open access
Jinfeng Ni, Chinya V. Ravishankar, Bir Bhanu · Lecture notes in computer science · 2003
Cited by 29
Zuhal Akyürek, Çağrı Hasan Karaman, Mustafa Berkay AKPINAR et al. · Zenodo (CERN European Organization for Nuclear Research) · 2022
The spatial distribution of the pondscapes in Europe were obtained from global and local databases and presented in deliverable D3.2 (report on spatial distribution of pondscapes in Europe). However, the information was too coarse and necessary features of the ponds could not be retrieved from the available local databases. Therefore, available datasets from each participant country were collected and a common database was created. This database consists of spatial information such as latitude and longitude of the ponds in geographic coordinates, name, code, land cover, intensity, hydro period, surface area, perimeter, maximum depth, mean depth, altitude, measurement year, created year, information about work packages and installed sensor information. Geocoded and detailed GIS layers showing all ponds were created and it will be used as ground truth for mapping and validating hydro period information. A web application has been developed to display spatial distribution and available information of ponds from the individual countries. The application allows users to dynamically visualize the ponds and download pond’s available data, hydro period information and pond database spatially: https://ponderful.hidrosaf.com/.
Cited by 0Open access
Madison R. E. Swayne (16542250), Jerel P. Calzo (16542253), Jennifer K. Felner (16542256) et al. · Figshare · 2023
<div><p>Access to basic sanitation is a human right and a critical environmental determinant of health. In this paper, we detail the development of three tools to investigate sanitation justice: (1) our public restroom spatial database, (2) our field assessment tool, and (3) survey of restroom access experiences. We document our process to collect these data in a consistent, health equity-driven framework. Together, these tools comprise a suite of methods for the examination of public restrooms from the macro- to the micro-level, and highlight key opportunities to promote health and well-being among restroom-reliant populations (e.g., people experiencing homelessness) by advancing sanitation justice in the built environment. With an illustrative case study, we demonstrate how methods triangulation, using the tools in concert, can provide a comprehensive assessment of basic sanitation access in a given region–San Diego, CA. We also detail how each tool can also be used separately to assess key sanitation justice and health equity questions that may be of interest to researchers, public health practitioners, policymakers, and advocates, including: (1) where do public restrooms exist (mapping)?; (2) how accessible are public restroom facilities, and what health-supportive features do they have (field assessment)?; and (3) what are the experiences of people most reliant on the available public restroom facilities (survey)? The results of our case study demonstrate that these adaptable tools can be used to provide meaningful data on and a holistic picture of public restroom quantity, quality, accessibility, and the experiences of public restroom users in a given region.</p></div>
Cited by 0Open access
Peter Dahlhaus · 2013
Cited by 0
Mengquan Wu, Wuihong Cui, Xiaodong Yanga et al. · 2007
Cited by 0
Zhao Chun-yu · 2006
A new algorithm of spatial data partitioning is presented based on Hilbert curve which is one of the space filling curves.The new spatial data partitioning HCSDP algorithm gives a new vector data partitioning policy on the parallel spatial database system.Taking the characteristic of the variant-length of vector data records into account,HCSDP algorithm divides uniformly the huge volume of spatial data set into multiple parts and putting them onto the different processing nodes for avoiding the data skew.The advantages of HCSDP comparing are discassed with the algorithm used in Oracle spatial,and the validity and the efficiency of the algorithm are illustrated by the experimental results.
Cited by 7
Shijie Li, Dongping Wang, Liang Liu et al. · 2025
Spatial Database Management Systems (SDBMSs) utilize spatial data models for data storage. They efficiently handle spatial queries, such as KNN and spatial range queries. SDBMSs also perform topological analysis. They are widely applied in Geographic Information Systems (GIS) and navigation systems. SDBMSs are foundational software, similar to Relational Database Management Systems (RDBMSs). Logic bugs in SDBMSs lead to unexpected results. This causes functional defects or unavailability in upper-layer applications. Therefore, the automated detection of SDBMS logic bugs is an urgent issue that requires resolution.We propose a testing technique called Spatial Equivalent Transformation (SET). SET constructs the test oracle for SDBMS logic bugs. The technique generates equivalent variants of a seed query to test diverse and complex spatial operations by checking the consistency of their result sets. Simultaneously, we introduce a Geometric Generator utilizing geometric transformations. This generator efficiently creates representative spatial query test cases. We implemented this method as a tool named Spader, and then comprehensively evaluated its effectiveness on three widely used SDBMSs: PostGIS, MySQL, and MariaDB. The experimental results show that the method detected a total of 16 logic bugs. The developers have confirmed 15 of these bugs and 4 have already been fixed.
Cited by 0
Chenghua Wang, Huiling Gong, Betsy George et al. · Encyclopedia of GIS · 2015
Cited by 0
D. A. Bell, S.S. Anand, C. M. Shapcott · 2007
The past few years has seen an explosion in the amount of data stored in databases. Apart from textual data, there has been an increase in the amount of pictorial information being stored on computers. Within this data is a lot of implicit, potentially useful information that cannot be extracted manually, simply because of the size of the data and the scarcity of human resources. Thus, the need for automated discovery tools is clear and a lot of effort is being devoted to building such tools. In this paper we present a method for discovery in spatial databases. A general framework for databases mining in relational databases based on evidential theory [ANAN93] is extended to incorporate spatial discovery. We discuss the role of the Dempster-Shafer orthogonal sum combination rule in such a framework. Keywords : Database Mining, Spatial Reasoning, Evidential Theory, Dempster-Shafer Orthogonal Sum. 1. Introduction The discovery of knowledge can come about in many ways. Various modes of d...
Cited by 0
Moellering, Harold and Richard Hogan · Infoscience (Ecole Polytechnique Fédérale de Lausanne) · 1996
Cited by 1
Christine Parent, Stefano Spaccapietra, Thomas Devogèle · Infoscience (Ecole Polytechnique Fédérale de Lausanne) · 1996
Keywords: spatio-temporal databases Reference LBD-CONF-1996-004 Record created on 2007-01-16, modified on 2016-08-08
Cited by 8