KlimatanalysNorr/tools - Backend utilities for Klimatanalys Norr's web map.

	Commit message (Collapse)	Author	Age	Files
*	Add layer definitions for Vindbrukskollen layers.	Guilhem Moulin	2024-06-22	1
\| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \| \|	Only the land-based ones for now. Source: https://www.energimyndigheten.se/energisystem-och-analys/elproduktion/vindkraft/vindbrukskollen/ Layers: - https://ext-geodatakatalog.lansstyrelsen.se/GeodataKatalogen/srv/api/records/GetMetaDataById?id=ed5814b2-08bf-493a-a164-7819e1b590d6 LST Vindbrukskollen landbaserade vindkraftverk - https://ext-geodatakatalog.lansstyrelsen.se/GeodataKatalogen/srv/api/records/GetMetaDataById?id=c816bd1e-bc6c-487f-a962-770f05f677b6 LST Vindbrukskollen landbaserade projekteringsområden - https://ext-geodatakatalog.lansstyrelsen.se/GeodataKatalogen/srv/api/records/GetMetaDataById?id=c290bc31-1af8-497e-a9a5-87fcec55d0ce LST Vindbrukskollen havsbaserad vindkraft Webmaps: - https://vbk.lansstyrelsen.se/ - https://ext-geodatakatalog.lansstyrelsen.se/GeodataKatalogen/srv/swe/catalog.search#/map
*	Add logic for field regex substitution.	Guilhem Moulin	2024-06-19	1
\| \| \| \| \| \| \| \| \|	This is useful to replace a YYYYMMDD formatted date with YYYY-MM-DD. The target field can then be set to not-nullable and its type set to Date, as the OGR_F_SetField*() with take care of the conversion. We could also do that via an SQL query, but in our case the sources are not proper RDBMS so SQL is emulated anyway.
*	sks:UtfordAvverk: Add NOT NULL constraint on AnmaldHa column.	Guilhem Moulin	2024-06-19	1
\| \| \| \| \|	There are a couple (15) of NULL AnmaldHa's, all from Sep 1, 2005 in Borås, so we don't care about these.
*	Add logic to replace field value literals.	Guilhem Moulin	2024-06-19	1
\| \| \| \|	And set them to NULL.
*	Add schema for MRR layers.	Guilhem Moulin	2024-06-12	1
\|
*	sks:UtfordAvverk: Add UNIQUE constraint on OBJECTID.	Guilhem Moulin	2024-06-12	1
\| \| \| \| \| \|	Not sure why I thought there was duplicates but I must have done something wrong as there are none in the 667034+223463+214082+ 72656 = 1177234 features found after removing the spatial filter.
*	Add schema.sql.	Guilhem Moulin	2024-06-11	1
	This is useful to bootstrap the database without having to run GRANT CREATE ON SCHEMA postgis TO webmap_import; after DROPping the database or re-creating the cluster.