[Shake-dev] ShakeMap Update r1240 and workaround for time zone errors

[Bruce Worden]

Hi All,

There is a potential error that some of you may run into with the previous (and this) update. If your ShakeMap database contains events in the earthquake table for which the time zone is not found in your computer's time zone list, genex may abort and the run will fail. This may not be an issue for most of you since most earthquake times are given in GMT or UTC. However some events, particularly scenarios, may have problematic time zones, like "PDT", "CDT", or the like. If you run an event and get an error like "Invalid Offset: CDT", then you have this problem.

The solution is to log into your ShakeMap system's MySQL database (using your ShakeMap credentials) and
do the following (where 'mysql>' is your prompt):

	mysql> use shakemap;

You can check for potentially problematic time zones with a query like:

	mysql> select tzone from earthquake where tzone not in ('GMT', 'UTC');

To fix them, do:

	mysql> alter table earthquake modify tzone char(32);

Change them with one or more commands like the following:

	mysql> update earthquake set tzone = 'America/Los_Angeles' where tzone = 'PST' or tzone = 'PDT';

Where you substitute your problematic time zone(s) for 'PST', 'PDT', etc., and a time zone from the Olson database for 'America/Los_Angeles'. You can find the acceptable time zones in /usr/share/zoneinfo on most Unix-like systems. Or google "olson timezone database".

Finally, you should change any unrecognized time zones in event.xml for any events you ever expect to re-run.


The update, r1240, contains a couple of new data products:

o A new KMZ file, polygons_mi.kmz which, aside from making nice looking polygons of intensity, will work with the Weather Central software that many TV stations use for displaying weather and other geographic data. This is a nice product to help raise the profile of your ShakeMap operation. The intensity polygons are also included in the main evid.kmz file.

o A new station list file, stationlist.json, in GeoJSON format.

o Some bug fixes and performance enhancements.

If you haven't installed r1208, please see the release notes (attached), as all of it still applies. If you have installed r1208, this one is pretty easy. The change log is attached.

Bruce

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://geohazards.usgs.gov/pipermail/shake-dev/attachments/20140720/19c41657/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Update r1208.pdf
Type: application/pdf
Size: 152888 bytes
Desc: not available
URL: <http://geohazards.usgs.gov/pipermail/shake-dev/attachments/20140720/19c41657/attachment-0001.pdf>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://geohazards.usgs.gov/pipermail/shake-dev/attachments/20140720/19c41657/attachment-0004.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: r1240.txt.gz
Type: application/x-gzip
Size: 47208 bytes
Desc: not available
URL: <http://geohazards.usgs.gov/pipermail/shake-dev/attachments/20140720/19c41657/attachment-0001.gz>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://geohazards.usgs.gov/pipermail/shake-dev/attachments/20140720/19c41657/attachment-0005.html>