## Create FFMP Basin_ID point shapefile 

The basinList.dat file can be found on DS1 at
/data/fxa/radar/k@@@/ffmp/basinList.dat,

Where @@@ is the WSR-88D id.

**Prepare the basinList.dat file for ArcView as a text file:**

Copy basinList.dat to ffbas@@@.txt where @@@ is your radar id

Edit ffbas@@@.txt as follows:

Original file:

5606

1486226900000\|39.7893\|-82.1701\|Turkey Run

1486222161000\|39.7944\|-82.0516\|Riders Run

1486219291000\|39.7878\|-81.992\|Brush Creek

1486217610000\|39.7778\|-81.9548\|Blue Rock Creek

1486211850000\|39.6089\|-81.5037\|Big Run

1470243900000\|39.0125\|-79.7129\|Shavers Fork

Edited file

\"Pfaf\",\"Latitude\",\"Longitude\",\"Stream name\"

\"1486226900000\",39.7893,-82.1701,\"Turkey Run\"

1486222161000,39.7944,-82.0516,Riders Run

1486219291000,39.7878,-81.992,Brush Creek

1486217610000,39.7778,-81.9548,Blue Rock Creek

1486211850000,39.6089,-81.5037,Big Run

1470243900000,39.0125,-79.7129,Shavers Fork

Change the first line of the original file, which contains the number of
basins in your FFMP dataset to:

"Pfaf","Latitude","Longitude","Stream name"

In the second line, enclose Pfastetter Id and Stream name in double
quotes.

Replace all the vertical lines (\|) in the file with commas (,)

Save the text file ffbas@@@.txt

### Create a point shapefile of FFMP_ID numbers named "ffmpbas" 

Click on Table in the main project index.

In the project menu select "Add table"

List files of type "Delimited text (\*.txt)

Select file "ffbas@@@.txt" and click OK (where @@@ is your WSR-88D ID)

Save the project.

Open a view with the aggregated basins shapefile.

Make the basins shapefile active. (basins is the aggregated basin
shapefile)

In the view menu select "Add Event Theme"

Table: ffbas@@@.txt

Xfield: Longitude

Yfield: Latitude

Click OK

Make the ffbas@@@.txt theme active

In the theme menu select "convert to shapefile"

Name the shapefile ffmpbas and click OK.

Add the shapefile to the current view? YES

Make the ffbas@@@.txt them active

In the edit menu select "delete theme"

Delete ffbas@@@.txt? YES

Make the ffmpbas shapefile active

Click on the open theme table button

In the table menu select "start editing"

In the edit menu select "add field"

Name: ffmp_id

Type: number

Width: 6

Decimal places: 0

Click OK

The field "ffmp_id" has now been added to the table

Populate this field with the correct "ffmp_id" for each basin as
follows:

Make the "ffmp_id" field active.

In the field menu select "calculate"

Type in "rec" without the quotes under \[ffmp_id\]= (click OK)

In the table menu select "stop editing"

Save edits? YES; then in the file menu select "save project" and you are
done.

#### Add the FFMP Bin_ID as a column in the bins shapefile

Make the bins shapefile active.

Click on the open theme table button. ![](media/image1.png)

In the table menu select "start editing"

In the edit menu select "add field"

Name: bin_id

Type: number

Width: 6

Decimal places: 0

Click OK

The field "bin_id" has now been added to the table

Populate this field with the correct "bin_id" for each basin as follows:

Make the "bin_id" field active.

In the field menu select "calculate"

Make \[bin_id\] = rec (click OK)

In the table menu select "stop editing"

Save edits? YES

In the file menu select "save project"

Note: The bin_id numbers generated in this manner will match the numbers
found in the binToBasin.dat file on DS1 in
/data/fxa/radar/k@@@/ffmp/binToBasin.dat.

File sample of binToBasin.dat:

5606

7 56300 56301 56302 56305 56306 56307 56308 22.6806

2 55835 55836 6.17847

5 55600 55602 55603 55604 55831 15.1407

One line for each basin starting with basin 0. For basin "0" there are 7
bins assigned. Bin_id 56300 ...56308. The area of the 7 bins is 22.6806
km^2^.

Join the FFMP Basin_id (ffmpbas.shp) to the bins shapefile

Start Arcview and open your project.

Make the bins theme active.

Click on the open theme table button. ![](media/image1.png)

Make the ffmpbas theme active.

Click on the open theme table button. ![](media/image1.png)

Close the current view, making both tables visible.

Make the "pfaf column" in the ffmpbas table active.

Make the "pfaf column" in the bins table active.

Be sure the bins table is the active table.

Join the two tables by clicking the join button. ![](media/image2.png)

Note that the columns of the inactive table are copied to the active
table.

Save the project.

**Permanently add the ffmp number to the bins table:**

Make the bins shapefile active

Click on the open theme table button. ![](media/image1.png)

In the table menu select "start editing"

In the edit menu select "add field"

Name: ffmp

Type: number

Width: 6

Decimal places: 0

Click OK

Make the "ffmp" field active.

In the field menu select "calculate"

Type in "ffmp_id" without the quotes under \[ffmp\]= (click OK)

In the table menu select "stop editing"

Save edits? YES

In the table menu select "remove all joins"

In the file menu select "save project"

The FFMP identification number is now a permanent part of the bins
shapefile.

A join is only valid for the current view. If the bins file is used in a
different view, the ffmp_id would not show up in the table for bins.
When ffmp is permanently created in the bins file, it will appear in all
views.