Difference between revisions of "User:Wenslayer/KMLGenerator"

From Geohashing
imported>Wenslayer
(New page: I've created a script that can take the data from [http://www.amipsychic.net/geohashing.html here] and with a few inputs, generate a .kml file to read into Google Earth so you can see all ...)
 
imported>Wenslayer
m (Usage: Updated usage from updated script (thanks Jiml!))
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
I've created a script that can take the data from [http://www.amipsychic.net/geohashing.html here] and with a few inputs, generate a .kml file to read into Google Earth so you can see all the Geohash points of the dates selected.
+
== Problem ==
  
Screen shot:
+
Have you wondered what historical Geohashes have occurred in your graticule?  Have you wanted to see them all at once, instead of typing each date in via peeron?  Well this script might help you out here.
  
[[Image:KML Generator - Google Earth screen shot 1.jpg]]
+
== Solution ==
 +
I've submitted a script to the [http://public.perforce.com:8080 Perforce Public Depot]: [http://public.perforce.com:8080/@rev1=head@//guest/marc_wensauer/geohash/gen_geohash_kml.pl gen_geohash_kml.pl]
  
Note how few Geohash coordinates actually fall in Victoria and the Saanich Peninsula?  Should make it easy to sweep up those retro Geohashes.
+
Kudos to [[User:Polysylabic Pseudonym|Psud]] for providing the [http://www.amipsychic.net/geohashing.html Geohashing historical coordinates].
  
To do:
+
See [[User_talk:{{PAGENAME}}|discussion page]] for to-do's.
* Convert script from Bash to Perl to run faster.
+
 
* Allow sourcing data from a file or URL
+
== Usage ==
* Pretty-up each placemark's description to include hyperlinks to this Wiki and peeron map.
+
<pre>
* Add format checking of source data
+
Usage: ./gen_geohash_kml.pl -g <graticule[:<graticule>]> [-i <input file>] [-n <name>] [-l] [-v]
* Properly account for W30 graticules.
+
-g: graticule of interest (format: "<latitude>,<longitude>")
 +
add more with colon separator
 +
-i: input file to use (file format: "YYYY-MM-DD,<DOW>,<LAT>,<LON>")
 +
default: '-' for standard input
 +
-n: name of top-level KML folder holding place markers
 +
default: "Geohash History for {graticule}"
 +
"{graticule}" is replaced with actual graticule(s) supplied
 +
-l: generate a label for each place marker corresponding to its date
 +
default is to suppress a label for the place marker
 +
-v: enable verbose logging
 +
 
 +
Notes:
 +
* You can get *all* retro Geohash data from:
 +
  http://www.amipsychic.net/geohashing.html
 +
* Resulting KML file is displayed to standard out.
 +
* The resulting KML file will organize the place markers into folders by:
 +
  Graticule -> Year -> Year-Month
 +
 
 +
Reference:
 +
* http://wiki.xkcd.com/geohashing
 +
 
 +
Examples:
 +
* You can choose to generate a resulting KML file from the source data all
 +
  in one command, like this:
 +
  $ wget -O - http://www.amipsychic.net/coords/allcoords.csv.bz2 |
 +
    bzip2 -d | gen_geohash_kml.pl -g 49,-123 > Van_all.kml
 +
 
 +
  ...or first stage the data to a local file:
 +
  $ wget -O - http://www.amipsychic.net/coords/allcoords.csv.bz2 |
 +
    bzip2 -d > allcoords.csv
 +
 
 +
  ...and then generate the KML file from the local file:
 +
  $ gen_geohash_kml.pl -g 48,-123:49,-123 -i allcoords.csv > VicVan_all.kml
 +
 
 +
* You may wish to pre-process the source file to only show dates of interest:
 +
  $ grep "^2009" allcoords.csv |
 +
    gen_geohash_kml.pl -g 49,-123:49,-122:48,-122 > VanSurBham_2009.kml
 +
 
 +
* Use of -l and -n flag:
 +
  $ sed -nre '/-(07-01|12-25)/p' allcoords.csv | gen_geohash_kml.pl \
 +
    -g 48,-123 -l -n "Canada/Xmas Day in {graticule}" > Vic_7.1_12.25.kml
 +
 
 +
* Multiple graticules since a particular date:
 +
  $ sed -ne '/^2008-05-21/,$p' allcoords.csv | gen_geohash_kml.pl \
 +
    -g 49,-123:48,-123:49,-122:48,-122 > VanVicSurBham_since_2008-05-21.kml
 +
</pre>

Latest revision as of 00:50, 8 July 2009

Problem

Have you wondered what historical Geohashes have occurred in your graticule? Have you wanted to see them all at once, instead of typing each date in via peeron? Well this script might help you out here.

Solution

I've submitted a script to the Perforce Public Depot: gen_geohash_kml.pl

Kudos to Psud for providing the Geohashing historical coordinates.

See discussion page for to-do's.

Usage

Usage: ./gen_geohash_kml.pl -g <graticule[:<graticule>]> [-i <input file>] [-n <name>] [-l] [-v]
	-g: graticule of interest (format: "<latitude>,<longitude>")
		add more with colon separator
	-i: input file to use (file format: "YYYY-MM-DD,<DOW>,<LAT>,<LON>")
		default: '-' for standard input
	-n: name of top-level KML folder holding place markers
		default: "Geohash History for {graticule}"
		"{graticule}" is replaced with actual graticule(s) supplied
	-l: generate a label for each place marker corresponding to its date
		default is to suppress a label for the place marker
	-v: enable verbose logging

Notes:
* You can get *all* retro Geohash data from:
  http://www.amipsychic.net/geohashing.html
* Resulting KML file is displayed to standard out.
* The resulting KML file will organize the place markers into folders by:
  Graticule -> Year -> Year-Month

Reference:
* http://wiki.xkcd.com/geohashing

Examples:
* You can choose to generate a resulting KML file from the source data all
  in one command, like this:
   $ wget -O - http://www.amipsychic.net/coords/allcoords.csv.bz2 |
     bzip2 -d | gen_geohash_kml.pl -g 49,-123 > Van_all.kml

  ...or first stage the data to a local file:
   $ wget -O - http://www.amipsychic.net/coords/allcoords.csv.bz2 |
     bzip2 -d > allcoords.csv

  ...and then generate the KML file from the local file:
   $ gen_geohash_kml.pl -g 48,-123:49,-123 -i allcoords.csv > VicVan_all.kml

* You may wish to pre-process the source file to only show dates of interest:
   $ grep "^2009" allcoords.csv | 
     gen_geohash_kml.pl -g 49,-123:49,-122:48,-122 > VanSurBham_2009.kml

* Use of -l and -n flag:
   $ sed -nre '/-(07-01|12-25)/p' allcoords.csv | gen_geohash_kml.pl \
     -g 48,-123 -l -n "Canada/Xmas Day in {graticule}" > Vic_7.1_12.25.kml

* Multiple graticules since a particular date:
   $ sed -ne '/^2008-05-21/,$p' allcoords.csv | gen_geohash_kml.pl \
     -g 49,-123:48,-123:49,-122:48,-122 > VanVicSurBham_since_2008-05-21.kml