Will Woodlief willwoodlief

Raw CSV data is made available by Common Data Hub here:

http://www.commondatahub.com/live/geography/state_province_region/iso_3166_2_state_codes

http://www.commondatahub.com/live/geography/country/iso_3166_country_codes

The table cdh_state_codes (see cdh-schema.sql below) is designed to hold the raw data, which should import readily using most common database tools, or directly into MySQL via LOAD DATA, e.g.:

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE iso3166.cdh_state_codes;

	openapi: 3.0.0
	info:
	version: 1.0.1
	title: GeoJSON format
	description: >
	This document defines the GeoJSON format as an OpenAPI.
	It contains the definitions for 'Feature' object and 'FeatureCollection'
	objects, as well as the definitions for all 'Geometry' objects.
	It conforms with the 'RFC-7946' standard from IETF (August 2016 version)

	from tkinter import *
	from bokeh.colors.named import black, grey, whitesmoke

	root = Tk()
	root.title("Homemade Calculator")
	root.iconbitmap("C:/Users/Avery/Desktop/Python Programs/Images/Calc.ico")

	e = Entry(root, width=90, borderwidth=5, bg=black, fg=whitesmoke)
	e.grid(row=0, column=0, columnspan=9, padx=10, pady=10)

	#!/bin/sh -

	# this script is from https://gist.github.com/timkuijsten/6067107
	# The important part is not to put the password as an argument to the mysql
	# commands, i.e. don't use the -p option. Instead use a .my.cnf file in the home
	# dir of the user you are running this script as, i.e. /home/records/.my.cnf if running
	# as root. Make the file readable for the owner only: chmod 400 /home/records/.my.cnf
	# See: http://stackoverflow.com/questions/17829659/securing-backup-credentials-for-mysqldump/17844997#17844997

	umask 007

	<?php
	class Db_core
	{
	private $sqlite;
	private $mode;

	function __construct( $filename, $mode = SQLITE3_ASSOC )
	{
	$this->mode = $mode;
	$this->sqlite = new SQLite3($filename);

	<?php
	/*
	* Virtual Themed Page class
	*
	* This class implements virtual pages for a plugin.
	*
	* It is designed to be included then called for each part of the plugin
	* that wants virtual pages.
	*
	* It supports multiple virtual pages and content generation functions.