Skip to content

Latest commit

 

History

History
31 lines (18 loc) · 1.14 KB

README.md

File metadata and controls

31 lines (18 loc) · 1.14 KB
Raw

graph-geography

Investigation into storing ONS geography in Neo4j and tying to CMD heirarchies.

Setup

Install NEO4j: http://brewformulas.org/Neo4j

Loading the dummy data

This is split into 3 steps to remind me what these steps are and allow one to be consistent with CMD.

  1. Go to http://127.0.0.1:7474/browser/ Paste contents of codelists.cypher

  2. On command line: cypher-shell < hierarchy.cypher

  3. On command line: cypher-shell < relationships.cypher

##Test queries

List of all regions match(n:`_geography_group_` {code:'GOR10'})-[:usedBy]-(m:`_geography_location_`) return m Return heirarchy for a given region match(n:`_geography_location_` {code:'E10000031'})-[:usedBy*]-(m:`_geography_hierarchy_`) return m Return with wildcard match(n:`_geography_group_` {code:'GOR10'})-[:usedBy]-(m:`_geography_location_`) where m.label =~ 'North.*' return m Return groups created before a specific year (2015) match(n:`_geography_group_`) where n.year < 2015 return n

##Notes

WD16_LAD16_CTY16_OTH_UK_LU.csv is example of heirarchy file provided by ONS Geography team