Table of Contents

Examples of common import/create calls are provided below.

It is convenient to set up one or more import directory paths up front. For example:

string $importDir= $modelHome + "/V1/primaryData"

Specifying data directly through a parameter

hhVehOwnRelProp_hhs[hhs] = import (; data="1.03 2.01 2.32 2.38 2.41 2.41 2.31")

csv file

basic import

This is an example of importing into a very simple mask variable, zoneMask[z], indexed by a single pre-defined informant, zone. Here is the top of the source data file zonesMask.csv:

"zone","maskValue"
201,1
202,1
211,0
212,1
213,0
214,1
.
.
.

And here is the code:

zoneMask[z] = import (; dataFormat=coordinate, fileFormat=text, \
	allCoord=on, delimiter=",", firstLine=2, \
	file=$importDir/zonesMask.csv)

Note:

Alternatively one may use the heading parameter to skip over the first line:

zoneMask[z] = import (; dataFormat=coordinate, fileFormat=text, \
    allCoord=on, delimiter=",", heading=on, \
    file=$importDir/zonesMask.csv)

advanced import examples

local occPrivDwellCustSC_1[pzans,dtd] = create (; \
	dim=PLUMzoneAllNS, dim=dwellType_data, \
	entityFrom=occPrivDwellCustSC[pzans,dt,byrs][$index], \
	dataFormat=coordinate, fileFormat=text, \
	allCoord=off, delimiter=",", firstLine=2, \
	searchElemName1=",", replaceElemName1="", \
	searchElemName2="/", replaceElemName2="_", \
	searchElemName3="-", replaceElemName3="_", \
	replaceWhiteSpaceInElemName="_", \
	stripLeadingWhiteSpace=off, \
	searchData=",", replaceData="" , \
	file=$importDir/dwellUnitsByType.csv)

read localinformants

Read informant definition from column:

localinformant age_0510002[] = create (; object=set, delimiter=",", \
	allowDuplicate=on, \
	elemNamesFromColNum=3, firstLine=2, \
	searchElemName1=",", replaceElemName1="", \
	searchElemName2="/", replaceElemName2="_", \
	searchElemName3="-", replaceElemName3="_", \
	replaceWhiteSpaceInElemName="_", \
	stripLeadingWhiteSpace=off, \
	file=$importDir/051-0002.csv)

Read informant definition from line:

localinformant date_0510002[] = create (; object=set, delimiter=",", \
	allowDuplicate=off, \
	elemNamesFromLineNum=1, firstCol=4, \
	searchElemName1=",", replaceElemName1="", \
	searchElemName2="/", replaceElemName2="_", \
	searchElemName3="-", replaceElemName3="_", \
	replaceWhiteSpaceInElemName="_", \
	stripLeadingWhiteSpace=off, \
	file=$importDir/051-0002.csv)

tab delimited text odometer (block) format

This format is useful for migrating data between models in a human-readable format, as opposed to binary tool-format files.

immigration[s,ts1,a][$index] = import (; dataFormat=odometer, fileFormat=text, \
	firstCol=2, file=$importDir_V3/immigration.txt)

reads from the following (header not shown):

!	sex=male
! 	0		1		2	
"1977"	1.049407e+02	1.314661e+02	1.317941e+02
"1978"	9.129648e+01	1.133035e+02	1.212180e+02
"1979"	8.643492e+01	9.573391e+01	9.366822e+01
"1980"	9.673356e+01	9.806976e+01	9.806976e+01

Note the use of the firstCol=2 for objects of rank 2 or greater. See the corresponding export call.

TOOL file

USUseComByInd_19982008[com_du,indio_du,t_19982008] = import (; \
	format=tool, dataFile=$importDir_ind/USUseComByInd_19982008)