- First download
dbfpy
: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files - Then install:
sudo python setup.py install
To convert DBF file to CSV:
./dbf2csv database.dbf
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/07_40/07_40_2_2_5m_v2.0.tar.gz | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/07_41/07_41_1_1_5m_v2.0.tar.gz | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/07_41/07_41_1_2_5m_v2.0.tar.gz | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/07_41/07_41_2_1_5m_v2.0.tar.gz | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/07_41/07_41_2_2_5m_v2.0.tar.gz | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/07_42/07_42_1_2_5m_v2.0.tar.gz | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/08_39/08_39_1_2_5m_v2.0.tar | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/08_39/08_39_2_2_5m_v2.0.tar | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/08_40/08_40_1_1_5m_v2.0.tar.gz | |
http://data.pgc.umn.edu/elev/dem/setsm/ArcticDEM/mosaic/v2.0/08_40/08_40_1_2_5m_v2.0.tar.gz |
// based on https://warpycode.wordpress.com/2009/04/13/computing-a-1d-gaussian-kernel/ | |
// see http://www.stat.wisc.edu/~mchung/teaching/MIA/reading/diffusion.gaussian.kernel.pdf.pdf for more info | |
var gaussianKernel1d = (function () { | |
var sqr2pi = Math.sqrt(2 * Math.PI); | |
return function gaussianKernel1d (size, sigma) { | |
"use strict"; | |
// ensure size is even and prepare variables |
var supportsES6 = function() { | |
try { | |
new Function("(a = 0) => a"); | |
return true; | |
} | |
catch (err) { | |
return false; | |
} | |
}(); |
var canvas_in = document.getElementById("canvas_in"); | |
var canvas_out = document.getElementById("canvas_out"); | |
var img = new Image(); | |
img.onload = function() { | |
var w = this.width; | |
var h = this.height; | |
canvas_in.width = canvas_out.width = w; | |
canvas_in.height = canvas_out.height = h; | |
// Written by Paul Kaplan | |
var AsciiStlWriter = (function() { | |
// ASCI STL files | |
function stringifyVector(vec){ | |
return ""+vec.x+" "+vec.y+" "+vec.z; | |
} | |
function stringifyVertex(vec){ |
// Written by Paul Kaplan | |
var BinaryStlWriter = (function() { | |
var that = {}; | |
var writeVector = function(dataview, offset, vector, isLittleEndian) { | |
offset = writeFloat(dataview, offset, vector.x, isLittleEndian); | |
offset = writeFloat(dataview, offset, vector.y, isLittleEndian); | |
return writeFloat(dataview, offset, vector.z, isLittleEndian); | |
}; |
# First, make a dump of the database without data (-s) | |
$ pg_dump -h localhost -U username -Fc -s -f db_dump dbName | |
# Create a list of the functions | |
$ pg_restore -l db_dump | grep FUNCTION > function_list | |
# Restore the functions in an other database | |
$ pg_restore -h localhost -U username -d other-dbName -L function_list db_dump |
dbfpy
: http://sourceforge.net/projects/dbfpy/files/latest/download?source=filessudo python setup.py install
To convert DBF file to CSV:
./dbf2csv database.dbf
CREATE OR REPLACE FUNCTION voronoi(table_name text,geom_col text) returns SETOF record as $$ | |
############################################################################# | |
# | |
# Voronoi diagram calculator/ Delaunay triangulator | |
# Translated to Python by Bill Simons | |
# September, 2005 | |
# | |
# Additional changes by Carson Farmer added November 2010 | |
# |