Skip to content

Instantly share code, notes, and snippets.

View fvanderbiest's full-sized avatar

François Van Der Biest fvanderbiest

26 followers · 3 following
View GitHub Profile
@fvanderbiest
fvanderbiest / post_query.xml
Created June 4, 2018 08:07
csw:GetRecords
<?xml version="1.0" encoding="UTF-8"?>
<csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2" service="CSW" version="2.0.2" resultType="results" maxRecords="100" xmlns:gmd="http://www.isotc211.org/2005/gmd">
<csw:Query typeNames="csw:Record">
<csw:ElementSetName>full</csw:ElementSetName>
<csw:Constraint version="1.1.0">
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
<ogc:PropertyIsEqualTo matchCase="true">
<ogc:PropertyName>subject</ogc:PropertyName>
<ogc:Literal>Boden</ogc:Literal>
</ogc:PropertyIsEqualTo>
@fvanderbiest
fvanderbiest / post_query.xml
Created June 4, 2018 08:03
csw:GetRecords example
<?xml version="1.0" encoding="UTF-8"?>
<csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2" service="CSW" version="2.0.2" resultType="results" maxRecords="100" xmlns:gmd="http://www.isotc211.org/2005/gmd">
<csw:Query typeNames="csw:Record">
<csw:ElementSetName>full</csw:ElementSetName>
<csw:Constraint version="1.1.0">
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
<ogc:PropertyIsEqualTo matchCase="true">
<ogc:PropertyName>subject</ogc:PropertyName>
<ogc:Literal>Bâtiments</ogc:Literal>
</ogc:PropertyIsEqualTo>
@fvanderbiest
fvanderbiest / georchestra_1512_to_1806_ldap.diff
Created May 31, 2018 07:43
geOrchestra 15.12 to 18.06 ldap differences
diff --git a/ldap/georchestra.ldif b/ldap/georchestra.ldif
index 6eedd24..2dc73f9 100644
--- a/ldap/georchestra.ldif
+++ b/ldap/georchestra.ldif
@@ -9,6 +9,7 @@ dn: uid=testuser,ou=users,dc=georchestra,dc=org
objectClass: organizationalPerson
objectClass: person
objectClass: inetOrgPerson
+objectClass: shadowAccount
objectClass: top
@fvanderbiest
fvanderbiest / georchestra_17.12_to_18.06_db.diff
Last active May 30, 2018 14:11
geOrchestra 17.12 to 18.06 db changes
diff --git a/postgresql/04-ldapadmin.sql b/postgresql/04-console.sql
similarity index 81%
rename from postgresql/04-ldapadmin.sql
rename to postgresql/04-console.sql
index 3ae97a4ed..ed40a7eb0 100644
--- a/postgresql/04-ldapadmin.sql
+++ b/postgresql/04-console.sql
@@ -4,9 +4,9 @@
BEGIN;
@fvanderbiest
fvanderbiest / georchestra_datadir_changes_17.12_18.06.diff
Last active July 20, 2018 12:01
geOrchestra datadir changes between 17.12 and 18.06
diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..b25c15b
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1 @@
+*~
diff --git a/README.md b/README.md
index cd7bf81..2ae95bc 100644
--- a/README.md
@fvanderbiest
fvanderbiest / gist:a476e425ca6c9c8afba75e09deceb8c4
Last active March 26, 2018 11:04
SELECT imagettes FROM (
SELECT DISTINCT
id as metadataid,
unnest(xpath('//gmd:graphicOverview/gmd:MD_BrowseGraphic/gmd:fileName/gco:CharacterString/text()',
data::xml,
ARRAY[
ARRAY['gmd', 'http://www.isotc211.org/2005/gmd'],
ARRAY['gco', 'http://www.isotc211.org/2005/gco']
]))::text AS imagettes
FROM
@fvanderbiest
fvanderbiest / .htaccess
Created October 24, 2017 07:53
apache forcetype logfile utf-8
<Files "*.log">
Forcetype 'text/plain; charset=UTF-8'
</Files>
@fvanderbiest
fvanderbiest / file.sql
Created October 11, 2017 08:19
migration ogcstatistics
INSERT INTO ogcstatistics.ogc_services_log SELECT * FROM ogcstatistics.ogc_services_log_old where now() - '4 years'::interval > date and date > now() - '5 years'::interval;
INSERT INTO ogcstatistics.ogc_services_log SELECT * FROM ogcstatistics.ogc_services_log_old where now() - '3 years'::interval > date and date > now() - '4 years'::interval;
INSERT INTO ogcstatistics.ogc_services_log SELECT * FROM ogcstatistics.ogc_services_log_old where now() - '2 years'::interval > date and date > now() - '3 years'::interval;
INSERT INTO ogcstatistics.ogc_services_log SELECT * FROM ogcstatistics.ogc_services_log_old where now() - '1 years'::interval > date and date > now() - '2 years'::interval;
INSERT INTO ogcstatistics.ogc_services_log SELECT * FROM ogcstatistics.ogc_services_log_old where date > now() - '1 years'::interval;
@fvanderbiest
fvanderbiest / 503.http
Created June 27, 2017 08:21
HAProxy 503 custom page
HTTP/1.0 503 Service Unavailable
Cache-Control: no-cache
Connection: close
Content-Type: text/html
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="pragma" content="no-cache" />
@fvanderbiest
fvanderbiest / httptest-multiscale.jmx
Created February 16, 2017 15:18
<?xml version="1.0" encoding="UTF-8"?>
<jmeterTestPlan version="1.2" properties="2.3" jmeter="2.8.20130705">
<hashTree>
<TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Plan de test" enabled="true">
<stringProp name="TestPlan.comments"></stringProp>
<boolProp name="TestPlan.functional_mode">false</boolProp>
<boolProp name="TestPlan.serialize_threadgroups">true</boolProp>
<elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="Variables pré-définies" enabled="true">
<collectionProp name="Arguments.arguments"/>
</elementProp>