Create Table from ESRL Climate Index Time Series in Text Files

Creates and populates a table of climate index values parsed from a list of text files, where each file contains the data for a single climate index in NOAA ESRL time series format.

Command line syntax

ESRLClimateIndicesFilesToArcGISTable_GeoEco <paths;paths...> <table> <fields;fields...>

Parameters

Expression	Explanation
<paths;paths...>	List of text files, each containing data for one climate index in the ERSL PSD time series format documented at http://www.cdc.noaa.gov/ClimateIndices/List/: year1 yearN year1 janval febval marval aprval mayval junval julval augval sepval octval decval year2 janval febval marval aprval mayval junval julval augval sepval octval decval ... yearN janval febval marval aprval mayval junval julval augval sepval octval decval missing_value For example, the North Atlantic Oscillation (NAO), available at http://www.cdc.noaa.gov/Correlation/nao.data, looks like this: 1948 2007 1948 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 1949 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 1950 0.92 0.40 -0.36 0.73 -0.59 -0.06 -1.26 -0.05 0.25 0.85 -1.26 -1.02 1951 0.08 0.70 -1.02 -0.22 -0.59 -1.64 1.37 -0.22 -1.36 1.87 -0.39 1.32 <Lines deleted for brevity> 2007 0.22 -0.47 1.44 0.17 0.66 -1.31 -0.58 -0.14 0.72 -99.90 -99.90 -99.90 -99.9 NAO Index from CPC http://www.cdc.noaa.gov/ClimateIndices/List/ for info Any lines following missing_value are treated as comments.
<table>	Table to create and populate. The table will have at least four fields: IndexDate (DATE) - the date of the first day of the month and year of the climate index value (e.g. 1-March-1960). IndexYear (LONG) - the year of the climate index value (e.g. 1990). IndexMonth (LONG) - the month of the climate index value, ranging from 1 to 12. Value (DOUBLE) - the index value for that month and year. There will be one of these fields created for each climate index that you provide as inputs. The names of these field are specified by the climate index value fields parameter. If the output table is a dBASE table (a DBF file), the missing_value parsed from the input data will be used to represent "no data is available". For other types of tables, a database NULL will represent "no data is available". The second two fields store the same data as the first field but are present for your convenience, in case you prefer the year and month broken out as integers. The rows will be inserted in ascending date order and all 12 months will be included for every year. If these months occur in the future they will have the missing_value or NULL as described above.
<fields;fields...>	Names of the fields to receive the climate index values. You must provide a field name for each climate index you provide as input.

Expression

Explanation

<paths;paths...>

List of text files, each containing data for one climate index in the ERSL PSD time series format documented at http://www.cdc.noaa.gov/ClimateIndices/List/:

year1 yearN
year1 janval febval marval aprval mayval junval julval augval sepval octval decval
year2 janval febval marval aprval mayval junval julval augval sepval octval decval
...
yearN janval febval marval aprval mayval junval julval augval sepval octval decval
missing_value

For example, the North Atlantic Oscillation (NAO), available at http://www.cdc.noaa.gov/Correlation/nao.data, looks like this:

1948 2007
1948 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90
1949 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90
1950   0.92   0.40  -0.36   0.73  -0.59  -0.06  -1.26  -0.05   0.25   0.85  -1.26  -1.02
1951   0.08   0.70  -1.02  -0.22  -0.59  -1.64   1.37  -0.22  -1.36   1.87  -0.39   1.32
<Lines deleted for brevity>
2007   0.22  -0.47   1.44   0.17   0.66  -1.31  -0.58  -0.14   0.72 -99.90 -99.90 -99.90
  -99.9
 NAO Index from CPC
http://www.cdc.noaa.gov/ClimateIndices/List/ for info

Any lines following missing_value are treated as comments.

<table>

Table to create and populate. The table will have at least four fields:

IndexDate (DATE) - the date of the first day of the month and year of the climate index value (e.g. 1-March-1960).

IndexYear (LONG) - the year of the climate index value (e.g. 1990).

IndexMonth (LONG) - the month of the climate index value, ranging from 1 to 12.

Value (DOUBLE) - the index value for that month and year. There will be one of these fields created for each climate index that you provide as inputs. The names of these field are specified by the climate index value fields parameter. If the output table is a dBASE table (a DBF file), the missing_value parsed from the input data will be used to represent "no data is available". For other types of tables, a database NULL will represent "no data is available".

The second two fields store the same data as the first field but are present for your convenience, in case you prefer the year and month broken out as integers.

The rows will be inserted in ascending date order and all 12 months will be included for every year. If these months occur in the future they will have the missing_value or NULL as described above.

<fields;fields...>

Names of the fields to receive the climate index values. You must provide a field name for each climate index you provide as input.

Scripting syntax

ESRLClimateIndicesFilesToArcGISTable_GeoEco (paths, table, fields)

Parameters

Expression	Explanation
Input text files (Required)	List of text files, each containing data for one climate index in the ERSL PSD time series format documented at http://www.cdc.noaa.gov/ClimateIndices/List/: year1 yearN year1 janval febval marval aprval mayval junval julval augval sepval octval decval year2 janval febval marval aprval mayval junval julval augval sepval octval decval ... yearN janval febval marval aprval mayval junval julval augval sepval octval decval missing_value For example, the North Atlantic Oscillation (NAO), available at http://www.cdc.noaa.gov/Correlation/nao.data, looks like this: 1948 2007 1948 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 1949 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 -99.90 1950 0.92 0.40 -0.36 0.73 -0.59 -0.06 -1.26 -0.05 0.25 0.85 -1.26 -1.02 1951 0.08 0.70 -1.02 -0.22 -0.59 -1.64 1.37 -0.22 -1.36 1.87 -0.39 1.32 <Lines deleted for brevity> 2007 0.22 -0.47 1.44 0.17 0.66 -1.31 -0.58 -0.14 0.72 -99.90 -99.90 -99.90 -99.9 NAO Index from CPC http://www.cdc.noaa.gov/ClimateIndices/List/ for info Any lines following missing_value are treated as comments.
Output table (Required)	Table to create and populate. The table will have at least four fields: IndexDate (DATE) - the date of the first day of the month and year of the climate index value (e.g. 1-March-1960). IndexYear (LONG) - the year of the climate index value (e.g. 1990). IndexMonth (LONG) - the month of the climate index value, ranging from 1 to 12. Value (DOUBLE) - the index value for that month and year. There will be one of these fields created for each climate index that you provide as inputs. The names of these field are specified by the climate index value fields parameter. If the output table is a dBASE table (a DBF file), the missing_value parsed from the input data will be used to represent "no data is available". For other types of tables, a database NULL will represent "no data is available". The second two fields store the same data as the first field but are present for your convenience, in case you prefer the year and month broken out as integers. The rows will be inserted in ascending date order and all 12 months will be included for every year. If these months occur in the future they will have the missing_value or NULL as described above.
Climate index value fields (Required)	Names of the fields to receive the climate index values. You must provide a field name for each climate index you provide as input.