Cypher语句

MATCH (china:Airport)-[:IN_COUNTRY]->(c:Country{code:"CN"})
WITH COLLECT(china.id) AS targets
MATCH path = (source:Airport{descr:"Zhuhai Airport"})-[r:HAS_ROUTE*2..3]->(target)
WHERE target.descr = source.descr
      AND ALL( node IN nodes(path) where node.id IN targets)
WITH path, [r in relationships(path)|r.distance] AS distances, 0.5 AS amplitude, 500 AS threshold
WITH path, apoc.coll.avg(distances) AS avgDist, apoc.coll.min(distances) as minDist, apoc.coll.max(distances) as maxDist
WHERE minDist/avgDist >= (1-amplitude) AND maxDist/avgDist <= (1+amplitude) AND avgDist >= threshold
//WITH path, apoc.coll.median(distances) AS medianDist, apoc.coll.min(distances) as minDist, apoc.coll.max(distances) as maxDist
//WHERE minDist/medianDist >= (1-amplitude) AND maxDist/medianDist <= (1+amplitude) AND medianDist >= threshold
WITH path, relationships(path) as flights
UNWIND flights AS flight
WITH DISTINCT flight
MATCH (n:Airport)-[flight]->(m:Airport)
RETURN n.descr AS source, m.descr as target, flight.distance AS distance;

选中结点

投影语句

选中结点

机场航线网络