Modeler II

Creating M2 Datasets

Hide Navigation Pane

Creating M2 Datasets

Previous topic Next topic No directory for this topic No expanding text in this topic  

Creating M2 Datasets

Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)

The "M2 dataset" is a dataset comprised of the 9 PCT12 tables for the specified geography (e.g., all census tracts in a state).

 

M2 datasets are structured in dbase format for easy transportability.

 

Two M2 datasets are provided with the M2 installer:

1.Hawaii counties and census tracts -- hitracts.dbf
2.Kansas counties and school districts -- ks_sd_cty.dbf

 

Also provided with the M2 setup is the underlying PCT12 CSV files to create the hitracts.dbf.

 

There are two general options to create M2 datasets.

 

Option 1.

Download the data from FactFinder (see next section).
Use File>Create ... to create a permanent, recallable dataset on the local computer.

Option 2.

Use Proximity predeveloped M2 datasets

 

Option 1. Creating an M2 Dataset using Downloaded FactFinder Data

After downloading the FactFinder data (see FF2 section), start with File>Create ...

 

An prompt appears for the name/location of the local/downloaded FactFinder data.  If the FF2 data have been downloaded to the C:\M2 folder and not renamed, click OK.

 

The "template" section refers to the main portion of the FF2 default download file name which is "DEC_10_SF1_PCT12".

If the data were downloaded to, for example, c:\m2\ks (Kansas), the template would be modified to show the text value:

C:\M2\KS\DEC_10_SF1_PCT12.

 

As shown in the section below about FF2 downloading, FF2 will create the names of the PCT12 files as:

DEC_10_SF1_PCT12.CSV - total population

DEC_10_SF1_PCT12A.CSV - White alone

DEC_10_SF1_PCT12B.CSV - Black alone

DEC_10_SF1_PCT12C.CSV - American Indian and Alaska Native alone

DEC_10_SF1_PCT12D.CSV - Asian alone

DEC_10_SF1_PCT12E.CSV - Native Hawaiian and Other Pacific Islander

DEC_10_SF1_PCT12F.CSV - Some other race alone

DEC_10_SF1_PCT12G.CSV - Two or more races

DEC_10_SF1_PCT12H.CSV - Hispanic or Latino

 

Note that each of the 9 files starts with the text "DEC_10_SF1_PCT12".

 

Next will be the Save File Dialog, to tell M2 how to name the new dataset and where to save it.

 

The setup includes the FF2 DEC* data used to create the Hawaii county/tracts dataset.

Replicate creating that dataset by using the default dataset name "newfile" as shown above.

 

Click Save and the Create process automatically proceeds with no further inputs required.

 

At the end of the process a "Done" message appear.  At that time the dataset c:\m2\newfile.dbf has been created.

The new dataset may be used via File>Open.

 

Comments (...)