Bert Spaan bertspaan

Python script to convert DBF database file to CSV

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

A treemap recursively subdivides area into rectangles; the area of any node in the tree corresponds to its value. This example uses color to encode different packages of the Flare visualization toolkit. Treemap design invented by Ben Shneiderman. Squarified algorithm by Bruls, Huizing and van Wijk. Data courtesy Jeff Heer.

	[
	{
	"name": "Aardappelen, bestrijdingsmaatregel AM",
	"code": 2025,
	"category": "aardappelen"
	},
	{
	"name": "Aardappelen, consumptie op klei/lössgrond",
	"code": 2951,
	"category": "aardappelen"

	require 'citysdk'

	$email = ARGV[1]
	$password = ARGV[2]

	@api = CitySDK::API.new("api.citysdk.waag.org")
	@api.authenticate(email, passw)

	layer = 'test.divv.parking.zone'

	{
	"name": "dc:title",
	"aant_inw": "http://dbpedia.org/ontology/populationTotal‎",
	"gm_code": {
	"@id": "http://citysdk.eu/layers/cbs/fields/gm_code",
	"@type": "xsd:string‎"
	},
	"opp_tot": {
	"@id": "http://citysdk.eu/layers/cbs/fields/opp_tot",
	"@type": "http://dbpedia.org/page/Hectare‎"

	{
	"@context":{
	"@base":"http://rdf.citysdk.eu/ams/",
	"name":"dc:title",
	"cdk_id":"cdk:cdk_id",
	"features":"cdk:apiResult",
	"properties":"cdk:geojsonProperties",
	"geojsonProperties": "_:geojsonProperties",
	"date_created":"dc:date",
	"layers":{

 {
   "@base": "http://rdf.citysdk.eu/ams/",
   "ah": "http://purl.org/artsholland/1.0/",
   "foaf": "http://xmlns.com/foaf/0.1/",
   "vcard": "http://www.w3.org/2006/vcard/ns#",
   "dc": "http://purl.org/dc/elements/1.1/",
   "title": "dc:title",
   "uri": "owl:sameAs",
   "website": "foaf:homepage",
   "locality": "vcard:locality",

	require 'json'

	schools = JSON.parse(File.open('schools.json').read, {symbolize_names: true})

	schools[:results].each do \|school\|
	data = school[:layers][:"duo.schools.secondary"][:data]

	lat, lon = school[:geom][:coordinates]

	csv_row = {