Geographic Information Systems

PostGIS

I have used PostGIS for many analyses. See among others the Project gismissions .

DROP VIEW IF EXISTS houses_cagayan_distances;
CREATE VIEW houses_cagayan_distances AS
---
--- We calculate distances with ST_DISTANCESPHEROID() and have to transform to 4326
---
WITH calculate AS
(SELECT a.house_id AS house_id1, a.casa AS house_name1, a.wkb_geometry AS geom1,
       b.house_id AS house_id2, b.casa AS house_name2, b.wkb_geometry AS geom2,
       ST_DISTANCESPHEROID(st_transform(a.wkb_geometry, 4326), st_transform(b.wkb_geometry, 4326)) / 1000 AS dist
FROM all_houses A, all_houses b
WHERE a.valleylocation = 'cagayan' AND b.valleylocation = 'cagayan'
ORDER BY a.wkb_geometry <-> b.wkb_geometry)
---
--- We create a line between the houses
---
SELECT ROW_NUMBER() OVER() AS fid,
       house_id1, house_name1, house_id2, house_name2,
       st_makeline(geom1, geom2) AS linebetweenhouses,
       dist
FROM calculate;

QGIS

I frequently use QGIS for my publications. I am able to use very advanced features such as georeferencing, personalized styles, time manager, etc. And I also have published maps created for the books of other authors. For instance for the book Federico II y la prusia del siglo XVIII (by José Ignacio Ruiz Rodríguez).

OpenLayers

I extensively use OpenLayers for many frontend projects, like the webpage of the Atlantocracies project .