<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi All,<div><br></div><div>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.</div><div><br></div><div>The solution is to log into your ShakeMap system's MySQL database (using your ShakeMap credentials) and</div><div>do the following (where 'mysql>' is your prompt):</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><font face="Courier">mysql> use shakemap;</font></div><div><br></div><div>You can check for potentially problematic time zones with a query like:</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><font face="Courier">mysql> select tzone from earthquake where tzone not in ('GMT', 'UTC');</font></div><div><br></div><div>To fix them, do:</div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><font face="Courier">mysql> alter table earthquake modify tzone char(32);</font></div><div><span style="font-family: monospace; "><br></span></div><div>Change them with one or more commands like the following:</div><div><span style="font-family: monospace; "><br></span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><font face="Courier">mysql> update earthquake set tzone = 'America/Los_Angeles' where tzone = 'PST' or tzone = 'PDT';</font></div><div><br></div><div>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".</div><div><br></div><div>Finally, you should change any unrecognized time zones in event.xml for any events you ever expect to re-run.</div><div><br></div><div><br></div><div>The update, r1240, contains a couple of new data products:</div><div><br></div><div>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.</div><div><br></div><div>o A new station list file, stationlist.json, in GeoJSON format.</div><div><br></div><div>o Some bug fixes and performance enhancements.</div><div><br></div><div>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.</div><div><br></div><div>Bruce</div><div><br></div><div></div></body></html>