Data Input Formats

The goal of Count Dracula is to hold a lot of count data, but because of the wide variety of formats which counts can have, we don't want to waste our time writing import parsing scripts for every possible count format. Rather, it is relatively quick for us to transfer data to a fairly standard format that can be easily read by Count Dracula.

There are two main count types: mainline and turn. This page discusses how both should be formatted in order to be read in by Count Dracula.

Both count types are stored in Excel workbooks.

Mainline Counts

Name of the file (IMPORTANT)

<mainlinestreetname>_<North or Westernmost major street name on the block>.<South or Easternmost major streetname of the block>.xls

Only numbered streets need to have Ave or St

Example: 7thAve_Balboa.Cabrillo.xls ; Kearny_Bush.Pine.xls

Workbook Layout

Each day has its own worksheet/tab and is labeled with the date in the form <year>.<Month>.<day>

Example 2007.10.13

There is also a tab with the "Source" of the data, where original excel file names should be placed, or any other general information.

Worksheet Layout

First Column:

• A1 has either the word MAINLINE or MAINCLASS (if there are more than one class, i.e. truck)

• Second row (A2) has the vehicle class of the count, or a list the order of the vehicle classes that are written i.e. 1 2

• The rest of the rows are time of day for the count interval in the format where all times are represented as 4 digit 24-hour times.

Rest of the Columns for MAINCLASS:

• B1=direction of travel (EB,WB,SB,NB)

• C1=link in cube in the format ANODE BNODE THIS IS OPTIONAL; Count Dracula should be able to match this

• B2:however many classes = vehicle class name

  i.e.

   MAINCLASS EB    12345 54321
  
   1 2       AUTO  TRUCK
  
   1200-1215    10     2
  
   1215-1230    20     3
  
   .            .     .
  
   .            .     .
  
  .            .     .
  

Rest of the Columns for MAINLINE:

• B1=direction of travel (EB,WB,SB,NB)

• B2=link in cube in the format ANODE BNODE THIS IS OPTIONAL; Count Dracula should be able to match this

i.e.

 MAINLINE      EB         WB

 2         12345 54321  54321 12345 

 1200-1215     10          2

 1215-1230     20          3

 .             .          .

 .             .          .

 .             .          .

Turn Counts

Name of the file (IMPORTANT)

<NorthSouthstreetname>_<EastWestStreetname>.xls

Only numbered streets need to have Ave or St

Example: 7thAve_Balboa.xls

Workbook Layout

Each day has its own worksheet/tab and is labeled with the date in the form <year>.<Month>.<day> Example 2007.10.13

There is also a tab with the "Source" of the data, where original excel file names should be placed, or any other general information.

Worksheet Layout

First Column:

• A1 has either the word TURNS

• Second row (A2) has the number of approaches

• The rest of the rows are time of day for the count interval in the format where all times are represented as 4 digit 24-hour times.

Rest of the Columns:

• First row, has name of approach: SBRT SBTH SBLT..etc

• Second row, has the cube node of the intersection

• The rest of the rows are counts

i.e.

 **TURNS       SBRT    SBTH    SBLT    WBRT   WBTH    WBLT    NBRT    NBTH     NBLT    EBRT   EBTH    EBLT**

 4          27545   27545   27545   27545   27545   27545   27545   27545   27545   27545   27545   27545

 1600-1615   2       1       13       1       13       1      13      21      3       1       13     8

 1615-1630   2       1       12       4       16       1      13      45      3       1       23     8

 etc etc

Vehicle Type

vtype vehicles

-1 Unknown

0 All (Total)

1 Pedestrian

2 Truck

3 Bike

4 Bus

5 Cars Only

6 2 Axle Long

7 2 Axle 6 Tire

8 3 Axle Single

9 4 Axle Single

10 <5 Axle Double

11 5 Axle Double

12 >6 Axle Double

13 <6 Axle Multi

14 6 Axle Multi

15 >6 Axle Multi

---