Skip to content

Instantly share code, notes, and snippets.

@rajfal

rajfal/soil-frequency-across-years.cql

Last active March 2, 2018 06:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rajfal/949951cf13da69853d5c3b1f0ba166ab to your computer and use it in GitHub Desktop.
Save rajfal/949951cf13da69853d5c3b1f0ba166ab to your computer and use it in GitHub Desktop.
Download ZIP
Summarize soil issue frequency across years
Raw
soil-frequency-across-years.cql
UNWIND [2007,2008, 2009, 2010, 2011, 2012, 2013, 2014] as years
MATCH (y:Year {year: years})-[:HAS_MONTH]->(m:Month )-[:HAS_DAY]->(d:Day)<-[r:REPORTED_ON]-()-[*1..2]-(n:Soil_Issue)
WITH y.year as Y, collect( n.type) as Issues
RETURN Y,
size(filter(x IN Issues WHERE x= 'Acidification')) as Acidification,
size(filter(x IN Issues WHERE x= 'Compaction')) as Compaction,
size(filter(x IN Issues WHERE x= 'Erosion')) as Erosion,
size(filter(x IN Issues WHERE x= 'HeavyMetalContamination')) as HeavyMetalContamination,
size(filter(x IN Issues WHERE x= 'HighAlkalinity')) as HighAlkalinity,
size(filter(x IN Issues WHERE x= 'Impermeable')) as Impermeable,
size(filter(x IN Issues WHERE x= 'LowNitrogen')) as LowNitrogen,
size(filter(x IN Issues WHERE x= 'LowOrganicBiota')) as LowOrganicBiota,
size(filter(x IN Issues WHERE x= 'LowOrganicMatter')) as LowOrganicMatter,
size(filter(x IN Issues WHERE x= 'LowPhosphorus')) as LowPhosphorus,
size(filter(x IN Issues WHERE x= 'LowPotassium')) as LowPotassium,
size(filter(x IN Issues WHERE x= 'Salinity')) as Salinity
ORDER By Y
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment