Skip to content

Instantly share code, notes, and snippets.

View mtoonen's full-sized avatar

Meine Toonen mtoonen

View GitHub Profile
@mtoonen
mtoonen / dockerOracleDump.txt
Last active August 11, 2021 07:28
Load dump into oracle docker
1. install docker
voeg je user ook toe aan de docker group. Ik moest mijn laptop herstarten (logout werkte niet).
2. pull oracle docker
docker pull pvargacl/oracle-xe-18.4.0:latest
3. optioneel: installeer portainer. Je bent jezelf dankbaar later
https://www.portainer.io/installation/
4. start je oracle docker
docker run --name oracle -p 1521:1521 -p 5500:5500 pvargacl/oracle-xe-18.4.0:latest
5. vanaf host: dump kopieeren
docker cp /home/meine/docker/exp_MOB_Productie_16_04_2020/exp_MOB_Productie_16_04_2020.dmp oracle:/opt/oracle/dumps/
@mtoonen
mtoonen / gist:c09e7c639ac79a9d6c75bf4ca4819428
Last active March 23, 2020 13:54
Upgrade Hibernate 3.6.10.Final to 5.4.12.Final
Mijn notities voor het upgraden van hibernate voor het imro-harvester project. Gedaan in PR https://github.com/B3Partners/imro-harvester/pull/104
1. upgrade hibernate version to new version
2. remove all hibernate(spatial) deps and add hibernate dependencies:
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>${hibernate.version}</version>
</dependency>
@mtoonen
mtoonen / IntelliJ.md
Last active July 14, 2020 19:49
IntelliJ setup
@mtoonen
mtoonen / CreateAllSpatialIndices.sql
Created November 21, 2017 13:10
Postgis: create all spatial indices
--select 'CREATE INDEX ' || f_table_schema || '_' || f_table_name || '_' || f_geometry_column || '_idx' || ' ON ' || f_table_schema || '.' || f_table_name || ' USING GIST ( ' || f_geometry_column || ');' from geometry_columns
@mtoonen
mtoonen / BRMO installatie checklist.md
Created November 3, 2017 14:27
BRMO installatie PostgreSQL

BRMO installatie PostgreSQL

database

  • Aanmaken postgresql gebruiker brmo met hetzelfde wachtwoord
  • Aanmaken databases brmo_staging, brmo_rsgb, rsgbbgt, topnl met owner brmo
  • Postgis extensie installeren op rsgbbgt database via SQL (als superuser):
  • Postgis extensie installeren op topnl database via SQL (als superuser):
  • Postgis extensie installeren op brmo_rsgb database via SQL (als superuser):

staging

@mtoonen
mtoonen / Main.java
Created August 7, 2017 15:11
shape 2 dxf
public static void main(String[] args) throws IOException {
OGRDataStoreFactory factory = new BridjOGRDataStoreFactory();
//OGRDataStoreFactory factory = new JniOGRDataStoreFactory();
Map<String, String> connectionParamsShp = new HashMap<String, String>();
connectionParamsShp.put("DriverName", "ESRI Shapefile");
connectionParamsShp.put("DatasourceName", new File("AssetsShapePoint.shp").getAbsolutePath());
DataStore store = factory.createDataStore(connectionParamsShp);
SimpleFeatureSource source = store.getFeatureSource("AssetsShapePoint");
SimpleFeatureIterator it = source.getFeatures().features();
public static void main(String[] args) throws IOException, SAXException, ParserConfigurationException {
org.geotools.xml.Configuration configuration = new org.geotools.gml3.GMLConfiguration();
org.geotools.xml.Parser parser = new org.geotools.xml.Parser(configuration);
// Original gml snippet which failed
//String exampleString = "<gml:MultiSurface gml:id=\"id.f4e80081824b48ca9754558371125be3\"><gml:surfaceMember><gml:Surface gml:id=\"id.1004c5c688a6471fbf2b5c42054e0339\" srsName=\"urn:ogc:def:crs:EPSG::28992\"><gml:patches><gml:PolygonPatch><gml:exterior><gml:LinearRing><gml:posList>139693.376 419978.411 139675.069 419971.055 139634.307 419954.669 139633.145 419954.201 139612.624 419945.945 139613.839 419943.733 139628.533 419917.004 139638.949 419898.131 139654.115 419904.284 139674.171 419912.416 139687.148 419917.593 139700.126 419922.776 139714.122 419928.554 139702.423 419957.444 139693.376 419978.411</gml:posList></gml:LinearRing></gml:exterior></gml:PolygonPatc
@mtoonen
mtoonen / pom.xml
Created June 4, 2015 09:17
Geotools WFS Mainclass
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>nl.b3p</groupId>
<artifactId>testgetoolswfs</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>jar</packaging>
<dependencies>
<dependency>
<groupId>org.geotools</groupId>
@mtoonen
mtoonen / ComponentToRegister
Last active August 29, 2015 14:03
Dynamisch zoeken
registerAtSearch: function() {
var searchComps = this.viewerController.getComponentsByClassName("viewer.components.Search");
// Registreer bij 1 Search: kan fout gaan omdat namen veranderen
// this.viewerController.getComponentByName("print1");
for (var i = 0; i < searchComps.length; i++) {
searchComps[i].addDynamicSearchEntry(this, this.callback);
}
},
callback : function(term,searchRequestId){
var result = {
@mtoonen
mtoonen / ComponentToRegister.js
Created June 24, 2014 09:21
How To Flamingo4 dev: register een component bij Print om extra layers
constructor : function(){
// Constructing
this.viewerController.addListener(viewer.viewercontroller.controller.Event.ON_COMPONENTS_FINISHED_LOADING,this.registerAtPrintLayer,this);
},
registerAtPrintLayer: function(){
var prints = this.viewerController.getComponentsByClassName("viewer.components.Print");
// Registreer bij 1 print: kan fout gaan omdat namen veranderen