Transcript Sources of Zipcode Data at UCLA 264a Marketing Research Print Sources Rezide Claritas Corporation HA 201R47Vol.

Sources of Zipcode Data
at UCLA
264a Marketing Research
1
Print Sources
Rezide
Claritas Corporation
HA 201
1990
R47
1994
Vol. 10 (California)
264a Marketing Research
2
CD-ROM Sources
Maps and Government Information (MGI) Library URL
Public Station #1
1990 Census Summary File 3
CD Location: Temp X-14 CD 90-3B
264a Marketing Research
3
Example:
Extracting Income by Zipcode
• Get the proper CD Loaded.
• Browse by using “Quick Reference” option.
• When you’ve found what you want back up to “Extract” option.
Extract Menu
1. Select Item
2. Select Record
3. Add Labels
8. Extract to a file
264a Marketing Research
4
1. Select Item
x
x
x
x
x
x
x
x
County
SAC1
P107001
P107002
.
.
.
.
.
.
P107025
264a Marketing Research
County
Zipcode
5
2. Select Records
S
R
* SAC1 (items with “*” can be selected in ranges)
min 90001
max 91803
Press “escape” to move back up a level.
264a Marketing Research
6
3. Add Labels
Select SAC1 -- ANPSADPI
264a Marketing Research
7
8. Extract to a File
Place a PC formatted file in drive a:
Menu
1.
2.
3.
4.
5.
.dbf
.prn
.sdf
.txt
___ Dry run to estimate file size.
Give a full path name, but not extension:
a:\incbyzip
Gives
incbyzip.dbf
264a Marketing Research
8
Part of Resulting File
ANPSADPI
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
Los Angeles County (pt.)
CNTY
SAC1 P1070001 P1070002 P1070003 P1070004 P1070005 P1070006 P1070007
037 90001
941
1369
696
664
889
649
616
037 90002
1164
1522
560
424
672
485
433
037 90003
1227
1504
1068
790
747
747
572
037 90004
1070
1280
977
668
739
690
843
037 90005
699
818
683
629
448
482
470
037 90006
1020
1948
1191
974
1256
829
824
037 90007
715
1127
735
547
447
493
515
037 90008
408
809
473
563
424
316
346
037 90010
88
87
60
59
53
104
62
037 90011
1762
2671
1427
1066
1338
1196
1118
037 90012
194
542
417
363
284
208
209
037 90013
38
80
21
56
29
12
6
264a Marketing Research
9