David Bitner bitner

I hereby claim:

To claim this, I am signing this object:

	-- PostgreSQL
	select
	row_number() over (order by date_utc asc, location, parameter),
	location,
	value,
	parameter,
	country,
	city,
	date_utc
	from measurements

	-- Procedural Function that takes in an extent and a cellsize (in extent srid units)
	-- And creates a grid bounding that extent with given cellsize with an origin that is in
	-- a multiple of the cellsize + zero
	CREATE OR REPLACE FUNCTION ST_GRID(
	IN _extent geometry,
	IN _cellsize float8,
	OUT id bigint,
	OUT r integer,
	OUT c integer,
	OUT geom geometry

	-- Convenience Functions
	CREATE OR REPLACE FUNCTION to_epoch(IN timestamptz, OUT epoch float8) AS
	$$ SELECT extract(epoch from $1) $$ LANGUAGE SQL;
	CREATE OR REPLACE FUNCTION ts_at_tod(IN timestamptz, IN timetz, OUT timestamptz) AS
	$$ SELECT date($1) + $2 $$ LANGUAGE SQL;

	-- Get list of target time between start and end
	CREATE OR REPLACE FUNCTION times_between(IN range_start timestamptz, IN range_end timestamptz, IN t timetz)
	RETURNS setof timestamptz AS $$
	SELECT * FROM

	==> django-osgeo-importer: self.distribution.run_command(command)
	==> django-osgeo-importer:
	==> django-osgeo-importer: File "/usr/lib/python2.7/distutils/dist.py", line 972, in run_command
	==> django-osgeo-importer:
	==> django-osgeo-importer: cmd_obj.run()
	==> django-osgeo-importer:
	==> django-osgeo-importer: File "/tmp/pip_build_root/numpy/numpy/distutils/command/build_src.py", line 147, in run
	==> django-osgeo-importer:
	==> django-osgeo-importer: self.build_sources()
	==> django-osgeo-importer:

	CREATE OR REPLACE FUNCTION public.dbs_ned_z(
	IN text,
	IN text,
	OUT text)
	RETURNS text AS
	$BODY$
	#!/bin/sh
	url="http://ned.usgs.gov/epqs/pqs.php?output=json&x=$1&y=$2"; /usr/bin/curl -s $url
	$BODY$
	LANGUAGE plsh VOLATILE

	bitner@dbspatialtest:/var/www/iDtest/iD$ make
	cat css/reset.css css/map.css css/app.css css/feature-icons.css > dist/iD.css
	node build.js
	/var/www/iDtest/iD/node_modules/d3/node_modules/jsdom/lib/jsdom/level1/core.js:432
	set nodeName() { throw new core.DOMException();},
	^
	SyntaxError: Unexpected token )
	at exports.runInThisContext (vm.js:73:16)
	at Module._compile (module.js:443:25)
	at Object.Module._extensions..js (module.js:478:10)

	WITH t AS (
	SELECT id, (SELECT min(val), max(val) FROM mytable WHERE st_dwithin(geom,a.geom,16093)) b,geom FROM mytable a
	)
	SELECT id, (b).min, (b).max, geom FROM t