dfsfdsdsfs


		<?php
		/*
		echo "<pre>";
		var_dump( $vars['elasticresult_activecities'] );
		echo "<pre>";
		die();
*/
		?>		



	<?php foreach ($vars['elasticresult_activecities']['query']['docs'] as $key => $result):?>
	
		<?php

		var_dump($result['_id']);
			
		?>		
	<?php endforeach;?>

	<?php


		foreach ($vars['elasticresult_activecities']['buckets'] as $aggrow) {
			
			if ($aggrow['key'] == 0) {
				// undefined value
				$label = "not set";
			} else {
				$label = $aggrow['key'];

				$data_constructionyearbyregion[] = array(
					"year" => $label,
					"count" => $aggrow['doc_count']
				);

			}
		}

		$jsondata_constructionyearbyregion = json_encode($data_constructionyearbyregion);
	
			echo "<pre>";
			var_dump($data_constructionyearbyregion);
			echo "</pre>";

		$columnwidth = 32;
		$numberofcolumns = count($data_constructionyearbyregion);
		$chartwidth = $columnwidth*$numberofcolumns;		
	?>

	<style>
	
	svg.constructionyearbyregion .axis--x path {
	  display: none;
	}
	
	svg.constructionyearbyregion .line {
	  fill: none;
	  stroke: steelblue;
	  stroke-width: 1.5px;
	}
	
	</style>
	
	<svg class="constructionyearbyregion" width="960" height="500"></svg>
	
	<script>
	
	
	
	var svg = d3.select("svg.constructionyearbyregion"),
	    margin = {top: 20, right: 80, bottom: 30, left: 50},
	    width = svg.attr("width") - margin.left - margin.right,
	    height = svg.attr("height") - margin.top - margin.bottom,
	    g = svg.append("g").attr("transform", "translate(" + margin.left + "," + margin.top + ")");
	
	var parseTime = d3.timeParse("%Y%m%d");
	
	var x = d3.scaleTime().range([0, width]),
	    y = d3.scaleLinear().range([height, 0]),
	    z = d3.scaleOrdinal(d3.schemeCategory10);
	
	var line = d3.line()
	    .curve(d3.curveBasis)
	    .x(function(d) { return x(d.date); })
	    .y(function(d) { return y(d.temperature); });
	
	d3.tsv("data.tsv", type, function(error, data) {
	  if (error) throw error;
	
	  var cities = data.columns.slice(1).map(function(id) {
	    return {
	      id: id,
	      values: data.map(function(d) {
	        return {date: d.date, temperature: d[id]};
	      })
	    };
	  });
	
	  x.domain(d3.extent(data, function(d) { return d.date; }));
	
	  y.domain([
	    d3.min(cities, function(c) { return d3.min(c.values, function(d) { return d.temperature; }); }),
	    d3.max(cities, function(c) { return d3.max(c.values, function(d) { return d.temperature; }); })
	  ]);
	
	  z.domain(cities.map(function(c) { return c.id; }));
	
	  g.append("g")
	      .attr("class", "axis axis--x")
	      .attr("transform", "translate(0," + height + ")")
	      .call(d3.axisBottom(x));
	
	  g.append("g")
	      .attr("class", "axis axis--y")
	      .call(d3.axisLeft(y))
	    .append("text")
	      .attr("transform", "rotate(-90)")
	      .attr("y", 6)
	      .attr("dy", "0.71em")
	      .attr("fill", "#000")
	      .text("Temperature, ºF");
	
	  var city = g.selectAll(".city")
	    .data(cities)
	    .enter().append("g")
	      .attr("class", "city");
	
	  city.append("path")
	      .attr("class", "line")
	      .attr("d", function(d) { return line(d.values); })
	      .style("stroke", function(d) { return z(d.id); });
	
	  city.append("text")
	      .datum(function(d) { return {id: d.id, value: d.values[d.values.length - 1]}; })
	      .attr("transform", function(d) { return "translate(" + x(d.value.date) + "," + y(d.value.temperature) + ")"; })
	      .attr("x", 3)
	      .attr("dy", "0.35em")
	      .style("font", "10px sans-serif")
	      .text(function(d) { return d.id; });
	});
	
	function type(d, _, columns) {
	  d.date = parseTime(d.date);
	  for (var i = 1, n = columns.length, c; i < n; ++i) d[c = columns[i]] = +d[c];
	  return d;
	}
	
	</script>