This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_LNGs.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(l:LNG {id:id}) |
iamvarol
/ borderPoints.cql
Created
April 19, 2022 10:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_BorderPoints.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(b:BorderPoint {id:id}) |
iamvarol
/ consumers.cql
Created
April 19, 2022 10:34
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_Consumers.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(c:Consumer {id:id}) |
iamvarol
/ storages.cql
Created
April 19, 2022 10:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_Storages.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(s:Storage {id:id}) |
iamvarol
/ productions.cql
Created
April 19, 2022 10:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_Productions.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(p:Production {id:id}) |
iamvarol
/ powerPlants.cql
Created
April 19, 2022 10:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_PowerPlants.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(pp:PowerPlant {id:id}) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_Nodes.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(n:Node {id:id}) |
iamvarol
/ pipeSegments.cql
Last active
April 19, 2022 14:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CALL apoc.periodic.iterate(" | |
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_PipeSegments.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| row.name as name, | |
| apoc.convert.fromJsonList(row.country_code) as countries, | |
| apoc.convert.fromJsonList(row.node_id) as nodes, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MATCH (start_p:Node {id:nodes[0]}) | |
| MATCH (end_p:Node {id:nodes[1]}) |
iamvarol
/ compressorss.cql
Created
April 19, 2022 11:07
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| LOAD CSV WITH HEADERS FROM 'https://raw.githubusercontent.com/iamvarol/blogposts/main/medium/europe_gas_network/data/IGGIELGNC3_Compressors.csv' as row | |
| FIELDTERMINATOR ';' | |
| WITH row.id as id, | |
| replace(row.name, '"','') as name, | |
| row.country_code as country_code, | |
| apoc.convert.fromJsonList(row.source_id) as source_ids, | |
| apoc.convert.fromJsonList(row.node_id) as node_ids, | |
| point({latitude:toFloat(row.lat), longitude:toFloat(row.long)}) as loc, | |
| apoc.convert.fromJsonMap(replace(row.param, 'None', 'null')) as params | |
| MERGE(c:Compressor {id:id}) |
iamvarol
/ node_distribution.cql
Created
April 19, 2022 13:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CALL db.labels() YIELD label | |
| CALL apoc.cypher.run('MATCH (:`'+label+'`) RETURN count(*) as count',{}) YIELD value | |
| RETURN label as nodes, value.count as nodeCount | |
| ORDER BY nodeCount DESC |
OlderNewer