--- a/displaySON.gexf.php
+++ b/displaySON.gexf.php
@@ -1,1 +1,98 @@
+<?php
+include_once("./lib/common.inc.php");
 
+// TODO
+// color suppliers based on value? static list of high value suppliers?
+// TODO sigma
+// link on contracts site?
+// allow higher zoom levels
+// describe methodology and yellow/red color meaning, creative commons attribution
+$used_node_ids = Array();
+$included_panel_ids = Array();
+$used_edge_ids = Array();
+function add_node($id, $label, $parent = "", $panel = false)
+{
+    global $used_node_ids;
+    if (!in_array($id, $used_node_ids)) {
+        echo "<node id='" . urlencode($id) . "' label=\"" . str_replace('"','',str_replace("&", "and", $label)) . "\" " . ($parent != "" ? "pid='$parent'><viz:size value='" . rand(1, 50) . "'/>" : "><viz:size value='2'/>")
+            . "<viz:color b='" . ($panel ? 0 : 0) . "' g='" . ($panel ? 0 : 255) . "' r='" . ($panel ? 255 : 255) . "'/>";
+        echo "</node>" . PHP_EOL;
+        $used_node_ids[] = $id;
+    }
+}
+
+function add_edge($from, $to, $weight = '1.0')
+{
+    global $used_edge_ids, $included_panel_ids;
+    $id = urlencode($from . '-' . $to);
+
+    if (!in_array($id, $used_edge_ids)) {
+        echo "<edge id='" . $id . "' source='" . urlencode($from) . "' target='" . urlencode($to) . "' weight='" . $weight . "'>" . PHP_EOL;
+        if ($weight != 0.1) {
+            echo "<viz:color b='192' g='192' r='192'/>";
+    } else {
+            echo "<viz:color b='0' g='0' r='255'/>";
+        }
+        echo "</edge>" . PHP_EOL;
+        $used_edge_ids[] = $id;
+    }
+}
+
+$edges = Array();
+header('Content-Type: application/gexf+xml');
+echo '<?xml version="1.0" encoding="UTF-8"?>
+<gexf xmlns="http://www.gexf.net/1.2draft" xmlns:viz="http://www.gexf.net/1.2draft/viz" version="1.2">
+    <meta lastmodifieddate="2009-03-20">
+        <creator>Gexf.net</creator>
+        <description>A hello world! file</description>
+    </meta>
+    <graph mode="static" defaultedgetype="directed">
+
+        <nodes>' . PHP_EOL;
+
+$query = '
+SELECT "supplierABN", min("supplierName") AS "supplierName", contractnotice."SONID", count(*), sum(value) AS value 
+FROM contractnotice 
+WHERE "childCN" IS NULL 
+AND extract(year from "publishDate") = \'2016\'
+AND "supplierABN" in (select distinct "supplierABN" from contractnotice where (left("categoryUNSPSC"::text,2) = \'43\' or left("categoryUNSPSC"::text,2) = \'80\') )
+AND contractnotice."SONID" != \'\' AND contractnotice."SONID" IS NOT NULL GROUP BY "supplierABN", contractnotice."SONID"';
+$query = $conn->prepare($query);
+$query->execute();
+databaseError($conn->errorInfo());
+foreach ($query->fetchAll() as $row) {
+    add_node($row['supplierABN'], $row['supplierName'], "",false);
+    $included_panel_ids[] = $row['SONID'];
+    $edges[] = array("head" => $row['SONID'], "tail" => $row['supplierABN'], "weight" => $row['count']);
+}
+
+$query = 'SELECT "SONID", title FROM standingoffers';
+$query = $conn->prepare($query);
+$query->execute();
+foreach ($query->fetchAll() as $row) {
+   // if (in_array($row['SONID'], $included_panel_ids)){
+    add_node($row['SONID'], $row['title'], "", true);
+   // }
+}
+
+$query = 'select "SONID", abn,name from standingoffer_suppliers';
+$query = $conn->prepare($query);
+$query->execute();
+databaseError($conn->errorInfo());
+foreach ($query->fetchAll() as $row) {
+    add_node($row['abn'], $row['name']);
+
+    $edges[] = array("head"=>$row['SONID'], "tail"=>$row['abn'], "weight"=> 0.1);
+}
+
+echo '</nodes>
+        <edges>' . PHP_EOL;
+foreach ($edges as $edge) {
+    add_edge($edge['head'], $edge['tail']);
+}
+echo ' </edges>
+    </graph>
+</gexf>' . PHP_EOL;
+
+?>
+