CSV Grid Files: Sample Workflow

This topic describes a sample workflow for importing CSV Grid files. In the example used in this workflow, there are seven columns with numeric data and there is one column with text data. (The CSV file was converted to an Excel table for viewing purposes.)

ModelID

EventID

Latitude

Longitude

MaxWindSpeed

Duration

Surge_Height

Storm_Name

60

24

42.91016

143.996704

47

8

0

Songda (2004)

60

24

42.920158

144.006699

47

8

0

Songda (2004)

60

24

42.900162

143.996705

47

8

0

Songda (2004)

Procedure

To import a CSV Grid file:

  1. Open the Map Layer Import dialog box from Home > Default > Map Layer Import or from Administration Console > Object Management > Custom Map Layers > Import.
  2. In the Map Layer Import dialog box, next to the File Selection field, click Browse, and then navigate to the location of the CSV Grid file that you want to import.
  3. In the Open dialog box:
    1. Select Comma Separated Grid File (*.csv, .txt) as the file type.
    2. Select the CSV file.
    3. Click Open.

      You only need to import the .csv file.

  4. In the Import Options area, specify the following options:
    Layer Name

    Enter a unique name that describes the specific type of map layer being imported. For example, to display wind speed bands for the Songda storm, enter Songda Windspeed Bands. The layer name is useful when you are searching for the layer to display on your exposure data or to use with Geospatial Analysis results (you must have a Geospatial Analysis license to use AIR Geospatial layers .

    Group Name

    Select an existing group or create a new group. A group name is a unique name that describes a collection of map layers of the same spatial data type (all event layers, all boundary layers, or all hazard layers) that are associated with a given event. The group can contain a mixture of shapefiles and CSV Grid files. Click Map Layer Grouping Considerations for important map layer grouping considerations. For the example used in this workflow, create a group named "Songda Windspeed" that will contain a grid file and a shapefile (for the typhoon track).

    Note:

    Usage examples for group names: For tropical cyclone events, Touchstone uses the group name to associate the wind speed footprint (grid file) and the storm track (polyline shapefile) as separate layers for the same event. For earthquake events, Touchstone uses the group name to associate the PGA (peak ground acceleration) footprint (grid file), and the epicenter (point shape file) as separate layers for the same event. During mapping, this grouping enables you to select a given event in the layer menus, displaying both associated layers simply by selecting the event name—you do not have to select each layer. For Geospatial Analysis, this grouping enables you to select a given event for analysis, and then have access to both associated layers to perform either an exposure concentration analysis by PGA bands or an exposure concentration analysis by distance for the storm track or epicenter.

    Data Type

    Select the data type associated with the selected import. When selecting a data type, consider where you want the map layer to appear on the Touchstone Mapping ribbon. For example, you could select "Historical Event".

    Peril

    Select the appropriate peril based on your import data. The peril list includes four categories: Earthquake, Tropical Cyclone, Severe Storm, and Other. Using the sample CSV Grid file, select the Wind peril under Tropical Cyclone.

    Event Year

    [Optional] Appears only if you select Historical Event or World Scenario as the data type. For example, specify an event year, such as "2004" for the Songda 2004 event. This can be useful when you are viewing map layers because you can display layers by the specified event year.

  5. In the Field Mappings area, select the appropriate field based on the column headings in your CSV Grid file.

    For example, since the sample data includes columns labeled “Latitude” and “Longitude”, select Latitude in the Latitude Field list and Longitude in the Longitude Field list. The latitude and longitude coordinates in the import file must be in decimal degrees (DD) format using positive or negative values (+/-DD). If the data is in units such as degree/minute/second or degree/decimal/minute, you must first convert them to decimal degrees before importing the file.

    Note:

    If your import file contains columns labeled "Lat" and "Long", you must change them. They are reserved for system use.

  6. Click Next.
  7. Define how you want the map layer to be displayed.

    Map Layer Import > CSV Grid Files > Legend > Global Controls

  8. In the Existing Legend field, select the legend that describes the map layer you are importing.

    The data in the import file, such as maximum wind speed, should intersect with the data associated with the map layer associated with the selected legend. The selected legend determines the legend type. In this example, selecting AIR Windspeed Footprint, a pre-defined legend provided by AIR; results in selection of “Banded Ranges” as the legend type, the type that was saved with the AIR legend.

    Note:

    AIR provides predefined legends that are associated with particular map layers; you cannot modify the AIR legends. For example, when you select a pre-defined AIR legend, you cannot modify any information in the Global Controls or Display pane, such as the palette. However, you can duplicate any existing legend and then modify it, or you can create a new legend from scratch. Legends that you created previously will also appear under Existing Legends.

  9. In the Analysis Field or Legend Field list, select the field that contains the categorical data that you want to map. For example, select "Maxwind_speed".
  10. [Optional] Set the following global controls and display options.

    If you selected a predefined legend, as in this sample workflow, you cannot modify the display options. The content of the Global Controls and Display panes vary according to the selected legend and legend field.

    • Fill: The fill opacity is useful for displaying layers with other layers. Adding transparency to the top layers enables users to view them while still viewing underlying layers. Fill values are based on values in percent. For example, use 85% for the fill opacity and 100% for the border.

    • Border: This is useful for displaying background images on the map.

    • Palette: This is useful for assigning different colors to associate with each unique value, such as each unique maximum wind speed value. Select colors from the palette. The Palette option appears only for Discrete Values and Banded Ranges. The palette offers four settings: Warm, Cool, Ice, and Monochrome.

  11. Click Next . Map Layer Import displays a summary of your settings.
  12. If you are satisfied with the settings, click Import to submit the job.
  13. To monitor the status of the import, open the Activity Monitor.

    In the Activity Monitor, the name of the activity is “ShapeFile Import <LayerName>” and the type is “GIS Shape File Import”. When the status is “Completed,” you are ready to view the map layer on a contract, or use the imported layer in Geospatial Analysis results.

  14. To add a shapefile for the Songda track to the Songda group, open Map Layer Import, navigate to the location of the shapefile, such as "event24_pathlinefile.shp", and click Open. Enter a layer name, such as "Songda Track" and then select "Songda" from the Group Name list. Select Historical Event as the data type, Wind as the peril, and enter 2004 for the event year. Leave the Label Field blank and then click Next. Click Add and enter a legend name, such as "Songda Track". You can leave all the other defaults in this sample workflow. Click Next and then click Import.

    After you run a Geospatial Analysis, open the analysis results. Select Map Tools > Mapping and then, in the Custom Defined Layers area, select Events > Wind. You will see the Songda group that includes the grid and the track.