MySQL_Scripts/import_csv_clams_blocksplits at master · msimonson-psrc/MySQL_Scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
create database sandbox_mhs_17blocksplits;

drop table sandbox_mhs_17blocksplits.blocks_to_tod_id_network_distance;

drop table sandbox_mhs_17blocksplits.blocks_to_juris;

create table sandbox_mhs_17blocksplits.blocks_to_tod_id_network_distance
(
GEOID10 Text not null
,bCOUNTY Text not null
,bSecField Text not null
,POP2017 Float not null
,HHP2017 Float not null
,GQ2017 Float not null
,HU2017 Float not null
,OHU2017 Float not null
,rxHHpop Float not null
,rxGQpop Float not null
,splitblkHHpop Float not null
,splitblkGQpop Float not null
,splitblkTotpop Float not null
);


create table sandbox_mhs_17blocksplits.blocks_to_juris
(
GEOID10 Text not null
,bCOUNTY Text not null
,bSecField Text not null
,POP2017 Float not null
,HHP2017 Float not null
,GQ2017 Float not null
,HU2017 Float not null
,OHU2017 Float not null
,rxHHpop Float not null
,rxGQpop Float not null
,splitblkHHpop Float not null
,splitblkGQpop Float not null
,splitblkTotpop Float not null
,splitblkHH Float not null
);

LOAD DATA LOCAL INFILE 'C:/Users/msimonson/gis_files/tod_est2017.csv'
INTO TABLE sandbox_mhs_17blocksplits.blocks_to_tod_id_network_distance
FIELDS TERMINATED BY ','
#ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(
GEOID10
,bCOUNTY
,bSecField
,POP2017
,HHP2017
,GQ2017
,HU2017
,OHU2017
,rxHHpop
,rxGQpop
,splitblkHHpop
,splitblkGQpop
,splitblkTotpop
);

LOAD DATA LOCAL INFILE 'C:/Users/msimonson/gis_files/juris_est2017.csv'
INTO TABLE sandbox_mhs_17blocksplits.blocks_to_juris
FIELDS TERMINATED BY ','
#ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(
GEOID10
,bCOUNTY
,bSecField
,POP2017
,HHP2017
,GQ2017
,HU2017
,OHU2017
,rxHHpop
,rxGQpop
,splitblkHHpop
,splitblkGQpop
,splitblkTotpop
,splitblkHH
);