Sophia Parafina spara

## gist:1116899
{
    "place" : {
        "properties" : {
            "geometry": {
                "properties": {
                    "coordinates": {
                        "type": "geo_point"
                    }
                }
            }

## gist:1117013

# first geo_point mapping: map1.json

    "place" : {
        "properties" : {
            "geometry": {
                "properties": {
                    "coordinates": {
                        "type": "geo_point"
                    }

## simplegeo-feature-categories.json
[
   {
      "category":"Administrative",
      "category_id":"10100100",
      "type":"Region",
      "subcategory":"Consolidated City"
   },
   {
      "category":"Administrative",
      "category_id":"10100101",

## mysql2sqlite.sh
#!/bin/sh

# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.

# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.

# Usage: $ ./mysql2sqlite mysqldump-opts db-name | sqlite3 database.sqlite
# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite

## 2012_Conferences.txt
possible  Shmoocon January 27-29 - no tickets
flight/hotel booked  Strata February 28-March 1st - done
longshot  SXSW Interactive March 9-13 - nope
flight/hotel booked  WhereConf April 2-4 - presentation accepted
AR Standards Meeting March 19-20, Austing - purchased
flight/hotel booked  FOSS4G North America April 10-12 - presentation accepte/moderating panel
definite  ARE2012 May 8-9 - Ignite talk accepted
definite  Google I/O June 27-29
flight/hotel booked  HOPE Number Nine July 13-15
longshot  FOSS4G Beijing??? August/Sept

## create_geo_header_staging_table.sql
CREATE TABLE geo_header_staging(data text);

copy geo_header_staging FROM '/path/to/dcgeo2010.sf1' DELIMITER AS '|';

## cut_paste_columns
paste <(awk '{print $1;}'   gtemp) <(cut -f1 gfields)

## add_list_of_numbers.sh
awk '{total+=$0}END{print total}' file

## add_list_of_numbers.sh
awk '{total+=$0}END{print total}' file

## sed_on_osc
sed -i '' -e's/apples/oranges/' file.txt
	{
	"place" : {
	"properties" : {
	"geometry": {
	"properties": {
	"coordinates": {
	"type": "geo_point"
	}
	}
	}

	# first geo_point mapping: map1.json

	"place" : {
	"properties" : {
	"geometry": {
	"properties": {
	"coordinates": {
	"type": "geo_point"
	}
	[
	{
	"category":"Administrative",
	"category_id":"10100100",
	"type":"Region",
	"subcategory":"Consolidated City"
	},
	{
	"category":"Administrative",
	"category_id":"10100101",
	#!/bin/sh

	# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
	# CREATE block and create them in separate commands _after_ all the INSERTs.

	# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
	# The mysqldump file is traversed only once.

	# Usage: $ ./mysql2sqlite mysqldump-opts db-name \| sqlite3 database.sqlite
	# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase \| sqlite3 database.sqlite
	possible Shmoocon January 27-29 - no tickets
	flight/hotel booked Strata February 28-March 1st - done
	longshot SXSW Interactive March 9-13 - nope
	flight/hotel booked WhereConf April 2-4 - presentation accepted
	AR Standards Meeting March 19-20, Austing - purchased
	flight/hotel booked FOSS4G North America April 10-12 - presentation accepte/moderating panel
	definite ARE2012 May 8-9 - Ignite talk accepted
	definite Google I/O June 27-29
	flight/hotel booked HOPE Number Nine July 13-15
	longshot FOSS4G Beijing??? August/Sept
	CREATE TABLE geo_header_staging(data text);

	copy geo_header_staging FROM '/path/to/dcgeo2010.sf1' DELIMITER AS '\|';