mapcentia’s gists

mapcentia / gist:abaf42194cb2728c6e190ff31d9bb2bc

Last active June 28, 2024 13:28

mapcentia / gist:1bc1e30cadc89ddc6591708950c15062

Last active March 15, 2023 20:41

Links

	https://1drv.ms/p/s!Al0uFf_saOg2jFwRfU1kurKjTWIa?e=nnFEcE

	https://mapcentia.limesurvey.net/755975?lang=da

	https://vidi.swarm.gc2.io/app/tryg/?config=/api/v2/configuration/tryg/configuration_survey_63dbbba8b1359327058051.json

	https://dstfyn.vidi.gc2.io/app/destinationfyn/?state=state_snapshot_f6c9a4d0-c330-11ed-a874-e7b6d8419d41&config=/api/v2/configuration/destinationfyn/configuration_mapcentia_test_63a039228f835047461000.json&dps=1

mapcentia / gist:d5f4d10e63c7def3bb4a22cf33825b9b

Created September 7, 2022 09:48

	<html>
	<header>
	<script src="https://cdn.plot.ly/plotly-latest.min.js"></script>
	<script>
	let res = {"success":true,"forStore":[{"name":"test","type":"json"}],"forGrid":[{"header":"test","dataIndex":"test","type":"json","typeObj":null}],"type":"FeatureCollection","features":[{"type":"Feature","properties":{"test":{"data":[{"mmsi":"219370000","name":"WIND ENTERPRISE","type":"line","x":["2022-09-06T11:45:06","2022-09-06T12:54:05","2022-09-06T13:45:05","2022-09-06T14:54:05","2022-09-06T15:45:05","2022-09-06T16:48:02","2022-09-06T17:57:05","2022-09-06T18:42:08","2022-09-06T18:54:07","2022-09-06T19:54:03","2022-09-06T20:39:07","2022-09-06T20:48:12","2022-09-06T21:27:08","2022-09-06T21:39:06","2022-09-06T21:48:07","2022-09-06T21:54:08","2022-09-06T21:57:08","2022-09-06T22:00:09","2022-09-06T22:18:07","2022-09-06T22:24:06","2022-09-06T22:54:06","2022-09-06T23:39:03","2022-09-07T00:48:06","2022-09-07T01:12:07","2022-09-07T01:24:06","2022-09-07T01:48:05","2022-09-07T02:48:05","2022-09-07T03:54:06","202

mapcentia / gist:b3ec12690c0aab01e2cc98929a3a4117

Created August 18, 2022 09:01

	cmake_minimum_required(VERSION 3.22)
	project(ogr2postgis)

	set(CMAKE_CXX_STANDARD 17)
	set(CMAKE_SYSTEM_NAME Windows)


	SET(CMAKE_C_COMPILER x86_64-w64-mingw32-gcc)
	SET(CMAKE_CXX_COMPILER x86_64-w64-mingw32-c++)

mapcentia / gist:b0ae1a09d10833cb771071f33d1861ab

Created April 22, 2021 10:26

Demo SQLs

	https://geofa.geodanmark.dk/api/v2/sql/fkg?q=SELECT navn,facil_ty_k,facil_ty,geometri FROM fkg.t_5800_fac_pkt WHERE facil_ty='Toilet'&format=excel&geoformat=geojson&srs=4326

	https://geofa.geodanmark.dk/api/v2/sql/fkg?q=SELECT navn,rute_ty,ST_Length(geometri) FROM fkg.t_5802_fac_li WHERE ST_Length(geometri) > 500000&format=excel

	https://geofa.geodanmark.dk/api/v2/sql/fkg?q=select a.facil_ty, a.navn, st_distance(a.geometri, b.geometri) from t_5800_fac_pkt a, t_5800_fac_pkt b where a.kommunekode = 851 and a.facil_ty='Shelter' and b.facil_ty='Toilet' and st_distance(a.geometri,b.geometri)<200&format=excel

mapcentia / gist:0befb0c6d3c2e0c7201f6267375abcd7

Last active January 28, 2021 08:15

https://gc2-cli.s3-eu-west-1.amazonaws.com/gc2-win32-x64.tar.gz

mapcentia / gist:681ec26583ca61672d90d53f1f6f7734

Created October 21, 2020 19:24

gc2.cli

https://gc2-cli.s3-eu-west-1.amazonaws.com/gc2-win32-x64.tar.gz

mapcentia / gist:958d6e3db6387823cffc3e409efc54ff

Created February 20, 2020 14:10

	/*
	* @author Martin Høgh <[email protected]>
	* @copyright 2013-2020 MapCentia ApS
	* @license http://www.gnu.org/licenses/#AGPL GNU AFFERO GENERAL PUBLIC LICENSE 3
	*/

	module.exports = {

	// Following settings are set under build/startup.
	// They can not be altered in run-time.

mapcentia / gist:1b198ec7b025594d2e85a901c021a989

Created October 11, 2019 08:05

vkdb.InsideSelection

	CREATE OR REPLACE FUNCTION vkdb.InsideSelection(InputUdvaelgelsesPolygon INT)
	RETURNS TABLE(
	ogc_fid INT,
	boreholeno VARCHAR(10),
	xutm DOUBLE PRECISION,
	yutm DOUBLE PRECISION,
	elevation DOUBLE PRECISION,
	drilldepth DOUBLE PRECISION,
	intakeno NUMERIC(10),
	mintop DOUBLE PRECISION,

mapcentia / gist:60a25e0fab081c90d90ea7077d4d0c42

Last active April 27, 2020 06:49

Martin Høgh mapcentia