Skip to content

Instantly share code, notes, and snippets.

Rik Van Bruggen rvanbruggen

Block or report user

Report or block rvanbruggen

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@rvanbruggen
rvanbruggen / import_ROME.cql
Created Aug 29, 2018
Import ROME dataset into Neo4j
View import_ROME.cql
//import rome tree into Neo4j
load csv with headers from "https://docs.google.com/spreadsheets/d/1ks_hjKbO-n2We2glViM5D9RixU1ZtPi-0f7rJbfAY00/export?format=csv&id=1ks_hjKbO-n2We2glViM5D9RixU1ZtPi-0f7rJbfAY00&gid=744365839" as row
create (l:Leaf)
set l = row;
//set up the indexes
create index on :Leaf(Main);
create index on :Leaf(Category);
create index on :Leaf(Subcategory);
create index on :Leaf(Description);
View import_ESCO_csv_en.cql
//Import ESCO using CSV files
create index ON :Occupation(ISCOGroup);
create index ON :Occupation(altLabels);
create index ON :Skill(altLabels);
create index ON :ISCOGroup(code);
create index ON :Skill(conceptUri);
create index ON :ISCOGroup(conceptUri);
create index ON :Occupation(conceptUri);
create index ON :Occupation(preferredLabel);
create index ON :Skill(preferredLabel);
@rvanbruggen
rvanbruggen / load_openbeerdb.cql
Last active Jun 13, 2018
Working with OpenBeerDB in Neo4j
View load_openbeerdb.cql
//open beer database can be found at
//import script from https://github.com/aicfr/neo4j-openbeerdb
LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/aicfr/neo4j-openbeerdb/master/beerers.csv' AS row
CREATE (:Beerer { beererID: toInteger(row.id), beererName: row.name, location: row.location, description: row.descript, website: row.website, picture: row.picture });
LOAD CSV WITH HEADERS FROM 'https://github.com/aicfr/neo4j-openbeerdb/raw/master/beers.csv' AS row
CREATE (:Beer { beerID: toInteger(row.id), beerName: row.name, description: row.descript, abv: toFloat(row.abv) });
LOAD CSV WITH HEADERS FROM 'https://github.com/aicfr/neo4j-openbeerdb/raw/master/breweries.csv' AS row
@rvanbruggen
rvanbruggen / nextbuildschedule.adoc
Last active May 19, 2017
NextBuild Schedule Graph
View nextbuildschedule.adoc

The NextBuild 2017 Schedule Graph

Tomorrow I am presenting at the NextBuild conference in Eindhoven - you can see more info over here. Of course I am going to be talking a lot about Neo4j and just for fun, I decided to put the conference schedule in this graph.

A Google Sheet as the main repository

I had to of course start from the schedule on the NextBuild website, and convert that into a google sheet with all the data. Once I had that, I could add the data pretty easily.

@rvanbruggen
rvanbruggen / 1-importing_from_google_sheet.cql
Last active Aug 8, 2017
Importing and querying the web of Belgian Public companies and their ceo's/chairmen
View 1-importing_from_google_sheet.cql
//Importing from the Google Spreadsheet
//import the Person nodes
load csv with headers from
"https://docs.google.com/spreadsheets/d/1_X628w_2Lx8ZAIPQQUAGhoDTuf31MRxY821E5D3u2Nc/export?format=csv&id=1_X628w_2Lx8ZAIPQQUAGhoDTuf31MRxY821E5D3u2Nc&gid=0" as persons
create (n:Node:Person)
set n = persons;
//import the Company nodes
load csv with headers from
"https://docs.google.com/spreadsheets/d/1_X628w_2Lx8ZAIPQQUAGhoDTuf31MRxY821E5D3u2Nc/export?format=csv&id=1_X628w_2Lx8ZAIPQQUAGhoDTuf31MRxY821E5D3u2Nc&gid=2040965723" as companies
@rvanbruggen
rvanbruggen / 1-import GCE2017 schedule.cql
Last active May 19, 2017
GraphConnect Europe 2017 Schedule Graph
View 1-import GCE2017 schedule.cql
create index on :Company(name);
create index on :Floor(name);
create index on :Person(name);
create index on :Time(time);
create index on :Room(name);
create index on :Session(title);
create index on :Tag(name);
create index on :Track(name);
schema await;
@rvanbruggen
rvanbruggen / 1-graph.json
Last active Nov 28, 2016
Paris Terrorist Attack Network
View 1-graph.json
{
"nodes" : [
{
"x" : 450,
"y" : 300,
"ID" : 0,
"label" : "Salah Abdeslam",
"type" : "persoon",
"alias" : "",
"geboren" : 1989,
@rvanbruggen
rvanbruggen / 1-graphconnectsfo2016-schedule.adoc
Last active Oct 9, 2016
GraphConnect San Francisco Schedule Graph
View 1-graphconnectsfo2016-schedule.adoc

The GraphConnect San Francisco 2016 Schedule Graph

Yey! It’s that time of the year again! We are full-steam getting ready for the Bi-Yearly Festival of Graphs also known as GraphConnect. There’s another great conference lined up for us in San Francisco. The entire Neo4j crew will be there in full force - and of course we had to create another Schedule graph - just for fun. The fact that we had 14hrs on a very tight airplane seat with a guy my size sitting next to me had nothing to do with it. At all.

A Google Sheet as the main repository

I had to of course start from the schedule on the GraphConnect website, and convert that into a google sheet with all the data. Tu

View BullshitGraph.adoc

The Bullshit Graph

bullshit

So I guess we have all lived it: lots of business and/or technical folks spouting bullshit during meetings or presentations. It can be quite a laugh, but can also be quite annoying to say the least. So that’s why all kinds of cool games have appeared on the wonderful world of the interwebs, to keep our spirits high and our aggravation low :) …​ I have seen things like bullshit bingo (who actually have a big data version of the game - which is quite funny!), but there’s also been these "bullshit generators" left right and center to make up the kind of stuff that you sometimes here real people say/present.

View 1-Original Orienteering graph.cql
create index on :Control(name);
create index on :Waypoint(name);
create (zero:Control {name:'Start'}),
(one:Control {name:'1'}),
(two:Control {name:'2'}),
(three:Control {name:'Finish'}),
(oneone:Waypoint {name:'011'}),
(onetwo:Waypoint {name:'012'}),
(onethree:Waypoint {name:'013'}),
You can’t perform that action at this time.