KML Time Animations

Option when exporting a database to KML, either on Report menu of  database table form or the export of map image.

You can use a timeline in the KML export, using TIME fields in the database.  These must follow the conventions used by Google Earth. You must set these fields near the bottom of the KML options form, with the starting date on the left and ending date on the right.

  • You can use any fields, but by default the starting field should be START_DATE.  The ending field should be END_DATE.  The program will pick these fields automatically if they exist.
  • MICRODEM can convert a number of time formats.
  • MICRODEM can enter the fields from entries in the database.
    • Dates must be in the format YYYY-MM-DD.
    • If you have time periods shorter than a day, you need to enter them as 1999-12-31T23:59:59Z (UTC), or 1999-12-31T23:59:59-07:00 (UTC +/- hour deviation for time zones)
    • This can be tricky to get in Excel.  You best bet might be to use the "Concatenate" function, or another edit option.
  • MICRODEM will take a date such as 1944-1-7 and put in the zeros required by KML so that the export will be 1944-01-07.
  • If you have daily data, you can leave out the END_DATE field blank, and MICRODEM will use the "<TimeStamp>" option in KML.  Otherwise it will use the "<TimeSpan>" option.
  • If there is a field DATE_LABEL, it will be used for the folder names in the KML file.  Otherwise the START_DATE field will be used.
  • All records must have the time fields filled in (or you must filter out the ones with blanks before exporting)

KML overview.

Time animation example

Last revision 7/8/2015