Peruttu

MySQL or FileMaker Data Base Import from U.S. Census

Export Census Data from FFIEC website and Import into MySQL or FileMaker DB

Steps:

1. Download 2012 Census Windows Application from [url removed, login to view]

2. Export all Colorado Data for Demographics, Housing, and Income. Exports are limited to 30 fields. Each Table has 300+ Fields.

3. Use 3 FileMaker or MySQL Tables for importing Demographics, Housing, and Income data. Relate tables using County Code, MSA Code, State Code, Tract Code and Year.

Numeric Fields should be type numeric. If you cant tell by the data, make it type text.

4. Import relevant Census Data into Filemaker table. Maintain Exact Field names across Import.

Notes. The 2012 Census Windows Application does not perform a clean Excel export. Rather, one should plan to export approximately 10-15 excel extracts per Census table and:

1. Export to Excel

2. Open Excel and Concatenate Rows 1 & 2 into a new row #1

3. Delete the old rows 1 and 2.

4. Save

5. Prepare the FileMaker or mySql Table for Import

6. Import into Filemaker or mySql Using original field names and in the order they originally appear.

Please save the Excel sheets with a naming convention that identifies the underlying data.

Fields. Convert the Fieldnames in this manner.

Trim Spaces

Substitute "/" with "_"

Substitute " " with "_"

Precede all Fields beginning with a number with "f"

Examples.

I have provided several examples and a base working framework.

1. [url removed, login to view] (If you would like to do this in 8,9,10 or 11 that is Fine!)

This is the started FileMaker database. I have imported the first 4 extracts of the Census Demographics table, the 1st extract of the Income table and the 1st extract of the Housing Table.

"Extract" means that you can only export 35 fields at a time. The first 5 fields of each export should be the matching fields (identified above) and then the 30 next fields.

THE FOLLOWING EXCEL FILES ARE THE EXCEL RESULTS AFTER I HAVE MODIFIED THE COLUMN NAMES.

2. [url removed, login to view] - 5 primary key fields and then the First 30 something fields.

[url removed, login to view] - 5 primary key fields and then the NEXT 30 something fields.

[url removed, login to view] - 5 primary key fields and then the NEXT 30 something fields.

[url removed, login to view] - 5 primary key fields and then the NEXT 30 something fields.

[url removed, login to view] - 5 primary key fields and then the First 30 something fields.

[url removed, login to view] - 5 primary key fields and then the First 30 something fields.

3. FFIEC [url removed, login to view] - Screenshot of the Census Windows Application.

4. If you plan on using MySQL rather than FileMaker, contact me for login details.

5. If you want to use FileMaker fm7 format, contact me for a baseline database (My example is FM12).

Taidot: Excel, FileMaker, MySQL

Näytä lisää: mysql census data, import census data mysql, excel fmp12, row 44, primary data, one key data, mysql database download windows, download mysql database windows, base code, import data filemaker mysql, msa, 300 names excel, filemaker, export mysql, data importing, data base excel, convert old, concatenate, census, baseline, base one, mysql data base, mysql excel export, excel base data, extract excel files

About the Employer:
( 4 reviews ) Amarillo, United States

Projektin tunnus: #4267896

4 freelanceria on tarjonnut keskimäärin 16 $/tunti tähän työhön

vnb400sl

i can import the census data

$15 USD / tunti
(86 arvostelua)
5.4
lokeshk9936

Please see PM

$27 USD / tunti
(4 arvostelua)
3.0
julian84

I am interested in assisting you in completing your project as i have the experience that is needed. Thanks for considering my bid.

$8 USD / tunti
(2 arvostelua)
2.0
rewati086

Excellent knowledge of excel/macros/database. Pay me on 100% satisfaction

$15 USD / tunti
(0 arvostelua)
0.0