- 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 installTo 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 | |
| # |