Colin Broderick rustyb

## upgrade-postgres-9.3-to-9.5.md

      
              1 file
            
          
              31 forks
            
          
              35 comments
            
          
              111 stars
            
          
                johanndt
                / upgrade-postgres-9.3-to-9.5.md
            
            
              Last active
              July 15, 2022 12:35
                — forked from dideler/upgrade-postgres-9.3-to-9.4.md
            
              
                Upgrading PostgreSQL from 9.3 to 9.5 on Ubuntu
              
          
    TL;DR
Install Postgres 9.5, and then:
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main

  
## dataset-management.md

      
              1 file
            
          
              3 forks
            
          
              1 comment
            
          
              11 stars
            
          
                mheadd
                / dataset-management.md
            
            
              Last active
              October 12, 2023 07:53
            
              
                Sample API calls for creating, updating and deleting things in CKAN via the CKAN API.
              
          
    Get package list

~$ curl http://www.civicdata.com/api/action/package_list

Get package details

~$ curl http://www.civicdata.com/api/action/package_show?id={package_id}

Upload a file to storage

~$ curl http://www.civicdata.com/api/storage/auth/form/testdata/test.csv -H "Authorization: <API-KEY>"


## miriam-xml2csv.rb
#!/usr/bin/env ruby
#
# Convert MIRIAM Registry XML file (http://www.ebi.ac.uk/miriam/main/export/) to CSV
# for browsing at TogoDB (http://semantic.togodb.dbcls.jp/togodb/view/miriam)
#
# Copyright (C) 2012 Toshiaki Katayama <k@bioruby.org>
#
# Pre requirements:
#  % curl http://www.ebi.ac.uk/miriam/main/export/xml/ > resources_all.xml
#  % gem install nokogiri

## csv_to_json.rb
#!/usr/bin/env ruby
require 'csv'
require 'json'

if ARGV.size != 2
  puts 'Usage: csv_to_json input_file.csv output_file.json'
  puts 'This script uses the first line of the csv file as the keys for the JSON properties of the objects'
  exit(1)
end

## install_postgis_osx.sh
# Some good references are:
# http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x
# http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/
# http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2630392

#1. Install PostgreSQL postgis and postgres

brew install postgis
initdb /usr/local/var/postgres
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

## Ruby script to convert CSV to YAML
#!/usr/bin/env ruby
#
# Originally written by http://redartisan.com/tags/csv
# Added and minor changes by Gavin Laking
# Rewritten by Andrew Bennett for Ruby 1.9
#
# Usage: ruby csv_to_fixture.rb file.csv [--json]
#
# "id","name","mime_type","extensions","icon_url"
# "1","unknown","unknown/unknown","||","/images/icon/file_unknown.gif"
	#!/usr/bin/env ruby
	#
	# Convert MIRIAM Registry XML file (http://www.ebi.ac.uk/miriam/main/export/) to CSV
	# for browsing at TogoDB (http://semantic.togodb.dbcls.jp/togodb/view/miriam)
	#
	# Copyright (C) 2012 Toshiaki Katayama <k@bioruby.org>
	#
	# Pre requirements:
	# % curl http://www.ebi.ac.uk/miriam/main/export/xml/ > resources_all.xml
	# % gem install nokogiri
	#!/usr/bin/env ruby
	require 'csv'
	require 'json'

	if ARGV.size != 2
	puts 'Usage: csv_to_json input_file.csv output_file.json'
	puts 'This script uses the first line of the csv file as the keys for the JSON properties of the objects'
	exit(1)
	end
	# Some good references are:
	# http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x
	# http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/
	# http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2630392

	#1. Install PostgreSQL postgis and postgres

	brew install postgis
	initdb /usr/local/var/postgres
	pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start
	#!/usr/bin/env ruby
	#
	# Originally written by http://redartisan.com/tags/csv
	# Added and minor changes by Gavin Laking
	# Rewritten by Andrew Bennett for Ruby 1.9
	#
	# Usage: ruby csv_to_fixture.rb file.csv [--json]
	#
	# "id","name","mime_type","extensions","icon_url"
	# "1","unknown","unknown/unknown","\|\|","/images/icon/file_unknown.gif"