References of "Kasprzyk, Jean-Paul"
     in
Bookmark and Share    
Full Text
See detailIntégration de la continuité spatiale dans la structure multidimensionnelle d’un entrepôt de données - SOLAP raster
Kasprzyk, Jean-Paul ULg

Doctoral thesis (2015)

Technological advances in recent decades have created a massive acquisition of digital data whose volume grows exponentially. To efficiently extract the information they contain, powerful tools have been ... [more ▼]

Technological advances in recent decades have created a massive acquisition of digital data whose volume grows exponentially. To efficiently extract the information they contain, powerful tools have been developed to collect, store and analyze these data. These tools are gathered in a discipline called “business intelligence”. Among them, data warehouses are responsible for archiving data by structuring them in a multidimensional way (time, space or others). They are called data hypercubes or data cubes when they are limited to three dimensions. Hypercubes can supply OLAP (On Line Analytical Processing) systems that aim at quickly synthesizing information in interactive tables and charts for decision-makers from various fields: marketing, environment, criminology, etc. Thus, users can navigate into hypercubes using OLAP operations such as slicing on dimension members (e.g. data aggregation for the month of January in the time dimension), or drilling into hierarchies (e.g. switching from the “year” level to the “month” level in the time dimension). When OLAP is coupled with spatial analysis techniques supplied by geographic information systems (GIS), a map interface then improves the exploration of data: OLAP operations can be applied to dimensions defined in the geographical space (spatial drilling or spatial slicing). This kind of tool is called SOLAP (Spatial OLAP). SOLAP tools currently available on the market all suffer from the same deficiency: they are unable to represent spatial dimensions (X, Y) in a continuous way. This representation is nevertheless essential for the management of spatially continuous phenomena (temperature, pollution, etc.) but also for visualizing spatially discrete events (product sales, crimes, etc.) while minimizing the Modifiable Areal Unit Problem (MAUP). This kind of visualization is used especially by the police to predict the location of future crimes through hotspot maps which are generated by the Kernel Density Estimation (KDE) method. In the field of GIS, raster data (as opposed to vector data) enable effective representation of spatial continuity through digital georeferenced grids. Whereas current SOLAP tools only consider vector data, our research uses the raster model to integrate spatial continuity into the multidimensional structure of a data warehouse feeding a SOLAP ("raster SOLAP"). Despite its underutilization in the SOLAP literature, the raster model has many similarities with a particular kind of data cube: the MOLAP cube (Multidimensional OLAP). Like a satellite image (raster) representing the two planimetric spatial dimensions and one "spectral band" dimension, a MOLAP cube is a three dimensional array whose cells’ coordinates (similar to raster pixels) enable an efficient indexation of dimensions’ members (describing the analyzed facts). In a first original model that we call "raster cube" we define the bases for a three-dimensional raster SOLAP, starting from the definition of a MOLAP cube. Unlike vector SOLAP - where spatiality is attached to a semantic dimension through pointers to geometries - our model directly integrates spatial dimensions (X, Y) in the multidimensional structure of the data warehouse. With this original feature, any geographical entity (country, building, road, etc.) can be imported on the fly as a member in the analysis of the user, which is hardly possible with conventional vector SOLAP tools. An extension of this SOLAP model, called "raster hypercube", is then developed by entrusting the management of extra non-spatial dimensions to a relational database management system (Relational OLAP or ROLAP). The raster hypercube is then populated by KDE raster fields representing crime densities, which are defined in a continuous space (raster dimensions) through time and crime types (ROLAP dimensions). Our model is able to combine the production of hotspot maps at different scales of analysis with SOLAP navigation operations: slicing on spatial or non-spatial members, and drilling into the hierarchy of spatial or non-spatial dimensions. Our raster hypercube model is validated by an operating prototype which is based on open source tools only. Several datasets are integrated through KDE fields, including crime data from London and Seattle. At the end of our work, the results of a comparative study between raster SOLAP and vector SOLAP demonstrate that hybrid vector/raster SOLAP architectures present the same interest for spatial data as hybrid ROLAP/MOLAP architectures do for purely semantic data (management of detailed hypercubes [less ▲]

Detailed reference viewed: 125 (37 ULg)
Full Text
Peer Reviewed
See detailPrototype SOLAP appliqué sur des champs continus en mode raster. Analyse de hot spots de criminalité.
Kasprzyk, Jean-Paul ULg

Conference (2014, November 24)

SOLAP (Spatial OnLine Analytical Processing) is a server which allows decision makers to quickly analyze archived data from a spatial datawarehouse. Until now, most of SOLAP tools only manage spatial data ... [more ▼]

SOLAP (Spatial OnLine Analytical Processing) is a server which allows decision makers to quickly analyze archived data from a spatial datawarehouse. Until now, most of SOLAP tools only manage spatial data through the vector mode. However, some visualization techniques use interpolation to transform them into continuous fields in raster mode. Crime hotspot mapping is one of them: data are modeled in raster with a KDE (Kernel Density Estimation) algorithm to offer a spatially continuous visualization of crimes. This research aims at combining hotspot mapping and SOLAP. First, we adapt SOLAP to continuous fields with a raster multidimensional data model. Then the raster model is adapted to KDE. The data model is validated with a prototype including London crime data. [less ▲]

Detailed reference viewed: 68 (17 ULg)
Full Text
See detailMéthodologie de recherche en cartographie criminelle
Donnay, Jean-Paul ULg; Trotta, Marie ULg; Kasprzyk, Jean-Paul ULg

Scientific conference (2013, April 26)

Presentation of the original research methods conducted by the Geomatics unit of the University of Liege, on environmental criminology, geographic profiling, and business intelligence in crime mapping.

Detailed reference viewed: 116 (20 ULg)
Peer Reviewed
See detailReconstitution of the Journeys to Crime and Location of Their Origin in the Context of a Crime Series. A Raster Solution for a Real Case Study
Kasprzyk, Jean-Paul ULg; Trotta, Marie ULg; Donnay, Jean-Paul ULg et al

in Leitner, Michael (Ed.) Crime Modeling and Mapping Using Geospatial Technologies (2012)

In the region of Charleroi (Belgium), a series of criminal acts were committed by the same group, using the same vehicle. The events were located in space and time. The car used during these criminal ... [more ▼]

In the region of Charleroi (Belgium), a series of criminal acts were committed by the same group, using the same vehicle. The events were located in space and time. The car used during these criminal activities was stolen (first event) and was later retrieved (last event) after a period of 4 days of offences. Police recorded a crucial clue: the total mileage covered by the vehicle between the first and the last event was estimated with an admissible approximation. Thanks to this information, we were able to choose the most probable journey-to-crime among several scenarios. These depended on the combination of cost surfaces built with distance propagation algorithms starting from each criminal event in raster mode. The distance propagations were limited to the road network and the combinations of the cost surfaces had to respect the chronology of the facts. The most plausible scenario suggested that the criminals hided the car into a withdrawal site between their activities. In order to improve the precision of the location of this withdrawal site, we used a multi-criteria analysis taking account of the journey of the vehicle and other environment variables. At the end of these treatments, the small stretch of road that we isolated actually included the withdrawal site, as confirmed by the police later [less ▲]

Detailed reference viewed: 153 (44 ULg)
Full Text
See detailSpatial data warehouses and SOLAP: a new GIS technology
Kasprzyk, Jean-Paul ULg

Scientific conference (2011, October 14)

Multiplication, both in number and variety of databases in recent decades is a potential bottleneck in the process of decision making. Therefore, data warehouses and OLAP (Online Analytical Processing ... [more ▼]

Multiplication, both in number and variety of databases in recent decades is a potential bottleneck in the process of decision making. Therefore, data warehouses and OLAP (Online Analytical Processing) were born respectively to archive and analyse these data at different levels of aggregation. SOLAP (Spatial OLAP) is a technology that combines OLAP and GIS techniques for spatial data. This presentation will discuss the various tools (particularly open source tools) and approaches in this new domain of geomatics. [less ▲]

Detailed reference viewed: 92 (6 ULg)
Full Text
See detailConception d'un entrepôt de données géographiques comme outil d'aide à l'analyse criminelle
Kasprzyk, Jean-Paul ULg

Scientific conference (2010, October)

After describing the data used by belgian federal police for criminal analysis, we justify the utility of a spatial data warehouse for the integration and the exploitation of the data: spatial online ... [more ▼]

After describing the data used by belgian federal police for criminal analysis, we justify the utility of a spatial data warehouse for the integration and the exploitation of the data: spatial online analytical processing (SOLAP) and data mining. [less ▲]

Detailed reference viewed: 279 (15 ULg)
Full Text
Peer Reviewed
See detailReconstitution of the journeys to crime and location of their origin in the context of a crime series. A solution for a real case study.
Trotta, Marie ULg; Kasprzyk, Jean-Paul ULg; Donnay, Jean-Paul ULg

Conference (2010, April 15)

Dynamic studies in crime analysis usually use distance-decay models applied on isotropic surfaces. If the distance actually traveled within the context of a crime series can be estimated, another approach ... [more ▼]

Dynamic studies in crime analysis usually use distance-decay models applied on isotropic surfaces. If the distance actually traveled within the context of a crime series can be estimated, another approach, independent of the widely discussed form of the distance decay, can be suggested. Besides, there is a need for studies on anisotropic space, especially in European cities, given their complex road network. Therefore, this study takes this aspect into account. We use data of a real case provided by the Belgian Police Department. Five criminal events have been committed in a short period of time by individuals using the same stolen car before abandoning it. The milometer allowed the Police to estimate the mileage covered by the criminals. The purpose of the analysis is to map out all the possible journeys to crime in order to find the offender's hideout. First, we generate cost surfaces propagated from the locations of the criminal events over the dense road network in a high-resolution raster file. This provides a distance value for all pixels of the potential paths to each crime. Then these distances are cumulated for all criminal events and the sum is confronted to the recorded mileage. This gives a restricted list of road sections from which all event locations can be reached under the constraint of the mileage covered. These results are then refined through a multi-criteria analysis using exogenous data, such as land covers. The small area finally identified contains indeed the hideout as confirmed by the Police Department. [less ▲]

Detailed reference viewed: 92 (26 ULg)
Full Text
Peer Reviewed
See detailA Geocodification for 3D objects terrestrial surveys
Kasprzyk, Jean-Paul ULg; Billen, Roland ULg

in Neutens, Tijs; De Ryck, Marijke; De Maeyer, Philippe (Eds.) Proceedings of the 4th International Workshop on 3D Geo-information (2009, November)

Nowadays, mean 3D data aquisition techniques are photogrammetry and laserscanning. Their advantage is the huge amount of points that can be measured in a very short time on the field. Nevertheless, the ... [more ▼]

Nowadays, mean 3D data aquisition techniques are photogrammetry and laserscanning. Their advantage is the huge amount of points that can be measured in a very short time on the field. Nevertheless, the post-processing associated to these techniques allowing to build a real 3D model from the clouds of points is very long. Therefore, we developed a geocodification ("field to finish") for the 3D data acquisition at a low and/or middle level of details. Despite each point is measured one by one with a total station, the user can gain a lot of time because of the almost-absence of post processing. This paper shows some of the developed techniques and tries to demonstrate the possible complementarity between geocodification, laserscanning and photogrammtry. [less ▲]

Detailed reference viewed: 178 (32 ULg)
Full Text
See detailDéveloppement d'une Géocodification 3D pour la modélisation du bâti
Kasprzyk, Jean-Paul ULg

Master's dissertation (2008)

Detailed reference viewed: 143 (35 ULg)