-
Notifications
You must be signed in to change notification settings - Fork 0
/
setup.sh
1174 lines (1140 loc) · 79.8 KB
/
setup.sh
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
if [ -z $1 ]; then
DB_HOSTNAME="localhost"
else
DB_HOSTNAME=$1
fi
if [ -z $2 ]; then
DB_USERNAME=$USER
else
DB_USERNAME=$2
fi
if [ -z $3 ]; then
DATABASE="postgres"
else
DATABASE=$3
fi
if [ -z $4 ]; then
DB_PORT="5432"
else
DB_PORT=$4
fi
if [ -z $5 ]; then
DB_SCHEMA="public"
else
DB_SCHEMA=$5
fi
LOOPFLAG=0
while [ 0 -eq $LOOPFLAG ]; do
echo "The hostname is $DB_HOSTNAME, the username is $DB_USERNAME, the database name is $DATABASE, the port is $DB_PORT, and the schema name is $DB_SCHEMA"
echo "Is this correct and do you have the password in your ~/.pgpass file (y/n)? (your life will suck for the next 20 minutes if it's not the right host or you don't have the configuration information in .pgpass so check it now)"
read response
if [ $response = "y" ]; then
LOOPFLAG=1
else
echo "Enter hostname"
read DB_HOSTNAME
echo "Enter username"
read DB_USERNAME
echo "Enter database name"
read DATABASE
echo "Enter port number"
read DB_PORT
echo "Enter schema name"
read DB_SCHEMA
fi
done
#end variable setting process
#create folder for demographic data
mkdir -m 755 demographics_data/
#enter into folder
cd demographics_data/
echo "Downloading demographic profile table from US Census website"
#Download the 2010 demographic profile file from census website
wget "http://www2.census.gov/geo/tiger/TIGER2010DP1/Tract_2010Census_DP1.zip"
#unzip file
unzip -d ./ Tract_2010Census_DP1.zip
#upload to DATABASE
shp2pgsql -I -s 4269 "Tract_2010Census_DP1.shp" $DB_SCHEMA.dp1 | psql -h $DB_HOSTNAME -U $DB_USERNAME -p $DB_PORT -d $DATABASE -q
echo "Uploaded demographic profile to database"
echo "Reformatting and normalizing the demographic profile table (dp1)"
#add new_dp1 table (create_new_dp1.sql)
psql -h $DB_HOSTNAME -U $DB_USERNAME -p $DB_PORT -d $DATABASE -c "
--Alter existing table to recast geoid type
ALTER TABLE $DB_SCHEMA.dp1
ADD geoid_2 bigint;
UPDATE $DB_SCHEMA.dp1
SET geoid_2 = geoid10::bigint;
ALTER TABLE $DB_SCHEMA.dp1 DROP COLUMN geoid10;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN geoid_2 TO geoid;
--Alter column names
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010001 TO total_pop;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010002 TO total_under_5;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010003 TO total_5_9;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010004 TO total_10_14;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010005 TO total_15_19;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010006 TO total_20_24;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010007 TO total_25_29;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010008 TO total_30_34;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010009 TO total_35_39;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010010 TO total_40_44;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010011 TO total_45_49;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010012 TO total_50_54;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010013 TO total_55_59;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010014 TO total_60_64;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010015 TO total_65_69;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010016 TO total_70_74;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010017 TO total_75_79;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010018 TO total_80_84;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010019 TO total_85_over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010020 TO total_male;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010021 TO male_under_5;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010022 TO male_5_9;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010023 TO male_10_14;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010024 TO male_15_19;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010025 TO male_20_24;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010026 TO male_25_29;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010027 TO male_30_34;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010028 TO male_35_39;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010029 TO male_40_44;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010030 TO male_45_49;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010031 TO male_50_54;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010032 TO male_55_59;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010033 TO male_60_64;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010034 TO male_65_69;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010035 TO male_70_74;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010036 TO male_75_79;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010037 TO male_80_84;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010038 TO male_85_over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010039 TO total_female;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010040 TO female_under_5;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010041 TO female_5_9;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010042 TO female_10_14;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010043 TO female_15_19;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010044 TO female_20_24;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010045 TO female_25_29;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010046 TO female_30_34;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010047 TO female_35_39;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010048 TO female_40_44;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010049 TO female_45_49;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010050 TO female_50_54;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010051 TO female_55_59;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010052 TO female_60_64;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010053 TO female_65_69;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010054 TO female_70_74;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010055 TO female_75_79;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010056 TO female_80_84;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0010057 TO female_85_over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0020001 TO median_age;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0020002 TO median_age_male;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0020003 TO median_age_female;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0030001 TO total_pop_over_16;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0030002 TO total_male_over_16;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0030003 TO total_female_over_16;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0040001 TO total_pop_over_18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0040002 TO total_male_over_18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0040003 TO total_female_over_18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0050001 TO total_pop_over_21;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0050002 TO total_male_over_21;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0050003 TO total_female_over_21;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0060001 TO total_pop_over_62;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0060002 TO total_male_over_62;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0060003 TO total_female_over_62;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0070001 TO total_pop_over_65;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0070002 TO total_male_over_65;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0070003 TO total_female_over_65;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080001 TO total_pop2;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080002 TO pop_oneRace;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080003 TO pop_oneRace_white;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080004 TO pop_oneRace_aa;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080005 TO pop_oneRace_aian;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080006 TO pop_oneRace_asian;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080007 TO pop_oneRace_asian_asianIndian;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080008 TO pop_oneRace_asian_chinese;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080009 TO pop_oneRace_asian_filipino;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080010 TO pop_oneRace_asian_japanese;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080011 TO pop_oneRace_asian_korean;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080012 TO pop_oneRace_asian_vietnamese;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080013 TO pop_oneRace_asian_other;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080014 TO pop_oneRace_nhopi;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080015 TO pop_oneRace_nhopi_nh;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080016 TO pop_oneRace_nhopi_guam;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080017 TO pop_oneRace_nhopi_samoan;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080018 TO pop_oneRace_nhopi_opi;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080019 TO pop_oneRace_other;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080020 TO pop_twoRaceOrMore;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080021 TO pop_twoRaceOrMore_whiteAian;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080022 TO pop_twoRaceOrMore_whiteAsian;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080023 TO pop_twoRaceOrMore_whiteAA;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0080024 TO pop_twoRaceOrMore_whiteOther;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0090001 TO whiteAloneOrCombo;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0090002 TO aaAloneOrCombo;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0090003 TO aianAloneOrCombo;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0090004 TO asianAloneOrCombo;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0090005 TO nhopiAloneOrCombo;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0090006 TO otherAloneOrCombo;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0100001 TO total_pop3;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0100002 TO total_hispAnyRace;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0100003 TO hispAnyRace_mexican;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0100004 TO hispAnyRace_puertoRican;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0100005 TO hispAnyRace_cuban;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0100006 TO hispAnyRace_otherHisp;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0100007 TO total_nonHisp;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110001 TO total_pop4;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110002 TO total_hisp;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110003 TO hisp_whiteAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110004 TO hisp_aaAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110005 TO hisp_aianAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110006 TO hisp_asianAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110007 TO hisp_nhopiAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110008 TO hisp_otherAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110009 TO hisp_twoOrMore;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110010 TO total_nonHisp2;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110011 TO nonHisp_whiteAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110012 TO nonHisp_aaAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110013 TO nonHisp_aianAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110014 TO nonHisp_asianAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110015 TO nonHisp_nhopiAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110016 TO nonHisp_otherAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0110017 TO nonHisp_twoOrMore;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120001 TO total_pop5;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120002 TO pop_inHH;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120003 TO pop_hh_householder;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120004 TO pop_hh_spouse;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120005 TO pop_hh_child;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120006 TO pop_hh_child_ownChildUnder18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120007 TO pop_hh_otherRelative;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120008 TO pop_hh_otherRelative_under18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120009 TO pop_hh_otherRelative_65over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120010 TO pop_hh_nonrelatives;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120011 TO pop_hh_nonrelatives_under18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120012 TO pop_hh_nonrelatives_65over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120013 TO pop_hh_nonrelatives_unmarriedPartner;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120014 TO pop_in_group;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120015 TO pop_group_inst;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120016 TO pop_group_inst_male;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120017 TO pop_group_inst_female;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120018 TO pop_group_noninst;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120019 TO pop_group_noninst_male;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0120020 TO pop_group_noninst_female;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130001 TO total_households;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130002 TO hh_family;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130003 TO hh_family_ownChildrenUnder18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130004 TO hh_husbandWifeFam;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130005 TO hh_husbandWifeFam_ownChildrenUnder18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130006 TO hh_maleNoWifeFam;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130007 TO hh_maleNoWifeFam_ownChildrenUnder18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130008 TO hh_femaleNoHusbandFam;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130009 TO hh_femaleNoHusbandFam_ownChildrenUnder18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130010 TO hh_nonFamily;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130011 TO hh_nonFamily_livingAlone;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130012 TO hh_nonFamily_livingAlone_male;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130013 TO hh_nonFamily_livingAlone_male_65over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130014 TO hh_nonFamily_livingAlone_female;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0130015 TO hh_nonFamily_livingAlone_female_65over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0140001 TO hh_withUnder18;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0150001 TO hh_with65over;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0160001 TO avgHouseholdSize;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0170001 TO avgFamilySize;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180001 TO total_HousingUnits;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180002 TO housingUnits_occupied;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180003 TO housingUnits_vacant;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180004 TO housingUnits_vacant_forRent;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180005 TO housingUnits_vacant_rentedNotOcc;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180006 TO housingUnits_vacant_forSaleOnly;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180007 TO housingUnits_vacant_soldNotOcc;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180008 TO housingUnits_vacant_occasionalUse;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0180009 TO housingUnits_vacant_otherVacant;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0190001 TO homeownerVacancyRate;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0200001 TO rentalVacancyRate;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0210001 TO total_housingUnits_occupied;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0210002 TO housingUnits_occupied_ownerOccupied;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0210003 TO housingUnits_occupied_renterOccupied;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0220001 TO popInOwnerOccupiedHousingUnits;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0220002 TO popInRenterOccupiedHousingUnits;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0230001 TO avgHouseholdSizeOwnerOccupiedHousingUnits;
ALTER TABLE $DB_SCHEMA.dp1 RENAME COLUMN DP0230002 TO avgHouseholdSizeRenterOccupiedHousingUnits;
--Create new_dp1 table
DROP TABLE IF EXISTS $DB_SCHEMA.new_dp1;
CREATE TABLE $DB_SCHEMA.new_dp1 AS (
SELECT geoid,
aland10,
awater10,
intptlat10,
intptlon10,
total_pop,
total_under_5,
total_5_9,
total_10_14,
total_15_19,
total_20_24,
total_25_29,
total_30_34,
total_35_39,
total_40_44,
total_45_49,
total_50_54,
total_55_59,
total_60_64,
total_65_69,
total_70_74,
total_75_79,
total_80_84,
total_85_over,
total_male,
male_under_5,
male_5_9,
male_10_14,
male_15_19,
male_20_24,
male_25_29,
male_30_34,
male_35_39,
male_40_44,
male_45_49,
male_50_54,
male_55_59,
male_60_64,
male_65_69,
male_70_74,
male_75_79,
male_80_84,
male_85_over,
total_female,
female_under_5,
female_5_9,
female_10_14,
female_15_19,
female_20_24,
female_25_29,
female_30_34,
female_35_39,
female_40_44,
female_45_49,
female_50_54,
female_55_59,
female_60_64,
female_65_69,
female_70_74,
female_75_79,
female_80_84,
female_85_over,
median_age,
median_age_male,
median_age_female,
total_pop_over_16,
total_male_over_16,
total_female_over_16,
total_pop_over_18,
total_male_over_18,
total_female_over_18,
total_pop_over_21,
total_male_over_21,
total_female_over_21,
total_pop_over_62,
total_male_over_62,
total_female_over_62,
total_pop_over_65,
total_male_over_65,
total_female_over_65,
total_pop2,
pop_oneRace,
pop_oneRace_white,
pop_oneRace_aa,
pop_oneRace_aian,
pop_oneRace_asian,
pop_oneRace_asian_asianIndian,
pop_oneRace_asian_chinese,
pop_oneRace_asian_filipino,
pop_oneRace_asian_japanese,
pop_oneRace_asian_korean,
pop_oneRace_asian_vietnamese,
pop_oneRace_asian_other,
pop_oneRace_nhopi,
pop_oneRace_nhopi_nh,
pop_oneRace_nhopi_guam,
pop_oneRace_nhopi_samoan,
pop_oneRace_nhopi_opi,
pop_oneRace_other,
pop_twoRaceOrMore,
pop_twoRaceOrMore_whiteAian,
pop_twoRaceOrMore_whiteAsian,
pop_twoRaceOrMore_whiteAA,
pop_twoRaceOrMore_whiteOther,
whiteAloneOrCombo,
aaAloneOrCombo,
aianAloneOrCombo,
asianAloneOrCombo,
nhopiAloneOrCombo,
otherAloneOrCombo,
total_pop3,
total_hispAnyRace,
hispAnyRace_mexican,
hispAnyRace_puertoRican,
hispAnyRace_cuban,
hispAnyRace_otherHisp,
total_nonHisp,
total_pop4,
total_hisp,
hisp_whiteAlone,
hisp_aaAlone,
hisp_aianAlone,
hisp_asianAlone,
hisp_nhopiAlone,
hisp_otherAlone,
hisp_twoOrMore,
total_nonHisp2,
nonHisp_whiteAlone,
nonHisp_aaAlone,
nonHisp_aianAlone,
nonHisp_asianAlone,
nonHisp_nhopiAlone,
nonHisp_otherAlone,
nonHisp_twoOrMore,
total_pop5,
pop_inHH,
pop_hh_householder,
pop_hh_spouse,
pop_hh_child,
pop_hh_child_ownChildUnder18,
pop_hh_otherRelative,
pop_hh_otherRelative_under18,
pop_hh_otherRelative_65over,
pop_hh_nonrelatives,
pop_hh_nonrelatives_under18,
pop_hh_nonrelatives_65over,
pop_hh_nonrelatives_unmarriedPartner,
pop_in_group,
pop_group_inst,
pop_group_inst_male,
pop_group_inst_female,
pop_group_noninst,
pop_group_noninst_male,
pop_group_noninst_female,
total_households,
hh_family,
hh_family_ownChildrenUnder18,
hh_husbandWifeFam,
hh_husbandWifeFam_ownChildrenUnder18,
hh_maleNoWifeFam,
hh_maleNoWifeFam_ownChildrenUnder18,
hh_femaleNoHusbandFam,
hh_femaleNoHusbandFam_ownChildrenUnder18,
hh_nonFamily,
hh_nonFamily_livingAlone,
hh_nonFamily_livingAlone_male,
hh_nonFamily_livingAlone_male_65over,
hh_nonFamily_livingAlone_female,
hh_nonFamily_livingAlone_female_65over,
hh_withUnder18,
hh_with65over,
avgHouseholdSize,
avgFamilySize,
total_HousingUnits,
housingUnits_occupied,
housingUnits_vacant,
housingUnits_vacant_forRent,
housingUnits_vacant_rentedNotOcc,
housingUnits_vacant_forSaleOnly,
housingUnits_vacant_soldNotOcc,
housingUnits_vacant_occasionalUse,
housingUnits_vacant_otherVacant,
homeownerVacancyRate,
rentalVacancyRate,
total_housingUnits_occupied,
housingUnits_occupied_ownerOccupied,
housingUnits_occupied_renterOccupied,
popInOwnerOccupiedHousingUnits,
popInRenterOccupiedHousingUnits,
avgHouseholdSizeOwnerOccupiedHousingUnits,
avgHouseholdSizeRenterOccupiedHousingUnits,
shape_leng,
shape_area,
geom
FROM $DB_SCHEMA.dp1
ORDER BY geoid
);
DROP TABLE $DB_SCHEMA.dp1;
ALTER TABLE $DB_SCHEMA.new_dp1 RENAME TO dp1;
--Change data type
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_under_5 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_5_9 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_10_14 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_15_19 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_20_24 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_25_29 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_30_34 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_35_39 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_40_44 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_45_49 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_50_54 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_55_59 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_60_64 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_65_69 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_70_74 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_75_79 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_80_84 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_85_over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_under_5 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_5_9 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_10_14 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_15_19 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_20_24 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_25_29 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_30_34 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_35_39 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_40_44 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_45_49 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_50_54 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_55_59 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_60_64 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_65_69 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_70_74 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_75_79 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_80_84 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_85_over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_under_5 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_5_9 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_10_14 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_15_19 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_20_24 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_25_29 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_30_34 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_35_39 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_40_44 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_45_49 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_50_54 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_55_59 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_60_64 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_65_69 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_70_74 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_75_79 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_80_84 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_85_over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_16 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_16 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_16 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_21 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_21 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_21 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_62 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_62 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_62 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_65 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_65 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_65 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_white TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_aa TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_aian TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian_asianindian TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian_chinese TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian_filipino TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian_japanese TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian_korean TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian_vietnamese TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_asian_other TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_nhopi TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_nhopi_nh TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_nhopi_guam TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_nhopi_samoan TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_nhopi_opi TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_onerace_other TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_tworaceormore TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_tworaceormore_whiteaian TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_tworaceormore_whiteasian TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_tworaceormore_whiteaa TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_tworaceormore_whiteother TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN whitealoneorcombo TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN aaaloneorcombo TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN aianaloneorcombo TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN asianaloneorcombo TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nhopialoneorcombo TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN otheraloneorcombo TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_hispanyrace TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispanyrace_mexican TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispanyrace_puertorican TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispanyrace_cuban TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispanyrace_otherhisp TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_nonhisp TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_hisp TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_whitealone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_aaalone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_aianalone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_asianalone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_nhopialone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_otheralone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_twoormore TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonhisp_whitealone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonhisp_aaalone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonhisp_aianalone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonhisp_asianalone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonhisp_nhopialone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonhisp_otheralone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonhisp_twoormore TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_inhh TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_householder TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_spouse TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_child TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_child_ownchildunder18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_otherrelative TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_otherrelative_under18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_otherrelative_65over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives_under18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives_65over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives_unmarriedpartner TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_in_group TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_inst TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_inst_male TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_inst_female TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_noninst TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_noninst_male TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_noninst_female TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_households TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_family TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_family_ownchildrenunder18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_husbandwifefam TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_husbandwifefam_ownchildrenunder18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_malenowifefam TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_malenowifefam_ownchildrenunder18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_femalenohusbandfam TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_femalenohusbandfam_ownchildrenunder18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonfamily TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonfamily_livingalone TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonfamily_livingalone_male TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonfamily_livingalone_male_65over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonfamily_livingalone_female TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonfamily_livingalone_female_65over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_withunder18 TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_with65over TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_housingunits TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_occupied TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_vacant TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_vacant_forrent TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_vacant_rentednotocc TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_vacant_forsaleonly TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_vacant_soldnotocc TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_vacant_occasionaluse TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_vacant_othervacant TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_housingunits_occupied TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_occupied_owneroccupied TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingunits_occupied_renteroccupied TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN popinowneroccupiedhousingunits TYPE numeric;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN popinrenteroccupiedhousingunits TYPE numeric;
--Add column constraints
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN aland10 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN awater10 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN intptlat10 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN intptlon10 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_under_5 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_5_9 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_10_14 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_15_19 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_20_24 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_25_29 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_30_34 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_35_39 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_40_44 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_45_49 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_50_54 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_55_59 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_60_64 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_65_69 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_70_74 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_75_79 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_80_84 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_85_over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_under_5 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_5_9 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_10_14 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_15_19 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_20_24 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_25_29 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_30_34 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_35_39 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_40_44 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_45_49 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_50_54 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_55_59 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_60_64 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_65_69 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_70_74 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_75_79 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_80_84 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN male_85_over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_under_5 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_5_9 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_10_14 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_15_19 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_20_24 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_25_29 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_30_34 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_35_39 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_40_44 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_45_49 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_50_54 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_55_59 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_60_64 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_65_69 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_70_74 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_75_79 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_80_84 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN female_85_over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN median_age SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN median_age_male SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN median_age_female SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_16 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_16 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_16 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_21 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_21 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_21 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_62 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_62 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_62 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop_over_65 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_male_over_65 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_female_over_65 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop2 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_white SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_aa SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_aian SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian_asianIndian SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian_chinese SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian_filipino SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian_japanese SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian_korean SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian_vietnamese SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_asian_other SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_nhopi SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_nhopi_nh SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_nhopi_guam SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_nhopi_samoan SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_nhopi_opi SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_oneRace_other SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_twoRaceOrMore SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_twoRaceOrMore_whiteAian SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_twoRaceOrMore_whiteAsian SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_twoRaceOrMore_whiteAA SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_twoRaceOrMore_whiteOther SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN whiteAloneOrCombo SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN aaAloneOrCombo SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN aianAloneOrCombo SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN asianAloneOrCombo SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nhopiAloneOrCombo SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN otherAloneOrCombo SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop3 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_hispAnyRace SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispAnyRace_mexican SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispAnyRace_puertoRican SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispAnyRace_cuban SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hispAnyRace_otherHisp SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_nonHisp SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop4 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_hisp SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_whiteAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_aaAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_aianAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_asianAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_nhopiAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_otherAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hisp_twoOrMore SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_nonHisp2 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonHisp_whiteAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonHisp_aaAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonHisp_aianAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonHisp_asianAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonHisp_nhopiAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonHisp_otherAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN nonHisp_twoOrMore SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_pop5 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_inHH SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_householder SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_spouse SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_child SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_child_ownChildUnder18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_otherRelative SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_otherRelative_under18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_otherRelative_65over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives_under18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives_65over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_hh_nonrelatives_unmarriedPartner SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_in_group SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_inst SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_inst_male SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_inst_female SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_noninst SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_noninst_male SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN pop_group_noninst_female SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_households SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_family SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_family_ownChildrenUnder18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_husbandWifeFam SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_husbandWifeFam_ownChildrenUnder18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_maleNoWifeFam SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_maleNoWifeFam_ownChildrenUnder18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_femaleNoHusbandFam SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_femaleNoHusbandFam_ownChildrenUnder18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonFamily SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonFamily_livingAlone SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonFamily_livingAlone_male SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonFamily_livingAlone_male_65over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonFamily_livingAlone_female SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_nonFamily_livingAlone_female_65over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_withUnder18 SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN hh_with65over SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN avgHouseholdSize SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN avgFamilySize SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_HousingUnits SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_occupied SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_vacant SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_vacant_forRent SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_vacant_rentedNotOcc SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_vacant_forSaleOnly SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_vacant_soldNotOcc SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_vacant_occasionalUse SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_vacant_otherVacant SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN homeownerVacancyRate SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN rentalVacancyRate SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN total_housingUnits_occupied SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_occupied_ownerOccupied SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN housingUnits_occupied_renterOccupied SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN popInOwnerOccupiedHousingUnits SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN popInRenterOccupiedHousingUnits SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN avgHouseholdSizeOwnerOccupiedHousingUnits SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN avgHouseholdSizeRenterOccupiedHousingUnits SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN shape_area SET NOT NULL;
ALTER TABLE $DB_SCHEMA.dp1 ALTER COLUMN shape_leng SET NOT NULL;
--Add primary key constraints
ALTER TABLE $DB_SCHEMA.dp1 DROP CONSTRAINT IF EXISTS new_dp1_pkey;
ALTER TABLE $DB_SCHEMA.dp1 DROP CONSTRAINT IF EXISTS dp1_pkey;
ALTER TABLE $DB_SCHEMA.dp1 ADD PRIMARY KEY (geoid);
--Add table comments
COMMENT ON TABLE $DB_SCHEMA.dp1 IS 'Demographic data by US Census Tract from Demographic Profile Table 1 availabe at http://www2.census.gov/geo/tiger/TIGER2010DP1/Tract_2010Census_DP1.zip';
COMMENT ON COLUMN $DB_SCHEMA.dp1.geoid IS 'Census tract identifier; a concatenation of 2010 Census state FIPS code, county FIPS code, and census tract code; Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.aland10 IS '2010 Census land area (square meters); Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.awater10 IS '2010 Census water area (square meters); Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.intptlat10 IS '2010 Census latitude of the internal point; Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.intptlon10 IS '2010 Census longitude of the internal point; Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop IS 'Total population in tract; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_under_5 IS 'Total population in tract under 5 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_5_9 IS 'Total population in tract between the ages of 5 and 9; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_10_14 IS 'Total population in tract between the ages of 10 and 14; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_15_19 IS 'Total population in tract between the ages of 15 and 19; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_20_24 IS 'Total population in tract between the ages of 20 and 24; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_25_29 IS 'Total population in tract between the ages of 25 and 29; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_30_34 IS 'Total population in tract between the ages of 30 and 34; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_35_39 IS 'Total population in tract between the ages of 35 and 39; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_40_44 IS 'Total population in tract between the ages of 40 and 44; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_45_49 IS 'Total population in tract between the ages of 45 and 49; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_50_54 IS 'Total population in tract between the ages of 50 and 54; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_55_59 IS 'Total population in tract between the ages of 55 and 59; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_60_64 IS 'Total population in tract between the ages of 60 and 64; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_65_69 IS 'Total population in tract between the ages of 65 and 69; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_70_74 IS 'Total population in tract between the ages of 70 and 74; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_75_79 IS 'Total population in tract between the ages of 75 and 79; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_80_84 IS 'Total population in tract between the ages of 80 and 84; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_85_over IS 'Total population in the tract 85 years of age or over; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_male IS 'Total population of males in tract; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_under_5 IS 'Total population of males in tract under 5 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_5_9 IS 'Total population of males in tract between the ages of 5 and 9; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_10_14 IS 'Total population of males in tract between the ages of 10 and 14; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_15_19 IS 'Total population of males in tract between the ages of 15 and 19; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_20_24 IS 'Total population of males in tract between the ages of 20 and 24; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_25_29 IS 'Total population of males in tract between the ages of 25 and 29; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_30_34 IS 'Total population of males in tract between the ages of 30 and 34; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_35_39 IS 'Total population of males in tract between the ages of 35 and 39; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_40_44 IS 'Total population of males in tract between the ages of 40 and 44; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_45_49 IS 'Total population of males in tract between the ages of 45 and 49; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_50_54 IS 'Total population of males in tract between the ages of 50 and 54; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_55_59 IS 'Total population of males in tract between the ages of 55 and 59; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_60_64 IS 'Total population of males in tract between the ages of 60 and 64; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_65_69 IS 'Total population of males in tract between the ages of 65 and 69; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_70_74 IS 'Total population of males in tract between the ages of 70 and 74; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_75_79 IS 'Total population of males in tract between the ages of 75 and 79; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_80_84 IS 'Total population of males in tract between the ages of 80 and 84; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.male_85_over IS 'Total population of males in tract 85 years of age and over; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_female IS 'Total population of females in tract; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_under_5 IS 'Total population of females in tract under 5 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_5_9 IS 'Total population of females in tract between the ages of 5 and 9; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_10_14 IS 'Total population of females in tract between the ages of 10 and 14; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_15_19 IS 'Total population of females in tract between the ages of 15 and 19; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_20_24 IS 'Total population of females in tract between the ages of 20 and 24; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_25_29 IS 'Total population of females in tract between the ages of 25 and 29; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_30_34 IS 'Total population of females in tract between the ages of 30 and 34; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_35_39 IS 'Total population of females in tract between the ages of 35 and 39; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_40_44 IS 'Total population of females in tract between the ages of 40 and 44; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_45_49 IS 'Total population of females in tract between the ages of 45 and 49; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_50_54 IS 'Total population of females in tract between the ages of 50 and 54; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_55_59 IS 'Total population of females in tract between the ages of 55 and 59; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_60_64 IS 'Total population of females in tract between the ages of 60 and 64; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_65_69 IS 'Total population of females in tract between the ages of 65 and 69; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_70_74 IS 'Total population of females in tract between the ages of 70 and 74; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_75_79 IS 'Total population of females in tract between the ages of 75 and 79; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_80_84 IS 'Total population of females in tract between the ages of 80 and 84; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.female_85_over IS 'Total population of females in tract 85 years of age and over; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.median_age IS 'Median age of population in tract; Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.median_age_male IS 'Median age of male population in tract ; Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.median_age_female IS 'Median age of female population in tract; Universe: NA';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop_over_16 IS 'Total population in tract over 16 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_male_over_16 IS 'Total population of males in tract over 16 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_female_over_16 IS 'Total population of females in tract over 16 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop_over_18 IS 'Total population in tract over 18 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_male_over_18 IS 'Total population of males in tract over 18 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_female_over_18 IS 'Total population of females in tract over 18 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop_over_21 IS 'Total population in tract over 21 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_male_over_21 IS 'Total population of males in tract over 21 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_female_over_21 IS 'Total population of females in tract over 21 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop_over_62 IS 'Total population in tract over 62 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_male_over_62 IS 'Total population of males in tract over 62 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_female_over_62 IS 'Total population of females in tract over 62 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop_over_65 IS 'Total population in tract over 65 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_male_over_65 IS 'Total population of males in tract over 65 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_female_over_65 IS 'Total population of females in tract over 65 years of age; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop2 IS 'Total population in tract; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace IS 'Total population in tract reporting one race; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_white IS 'Total population in tract reporting one race as white; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_aa IS 'Total population in tract reporting one race as black/African-American; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_aian IS 'Total population in tract reporting one race as American Indian/Alaska Native (aian); Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian IS 'Total population in tract reporting one race as asian; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian_asianindian IS 'Total population in tract reporting one race as asian, asian-indian; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian_chinese IS 'Total population in tract reporting one race as asian, chinese; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian_filipino IS 'Total population in tract reporting one race as asian, filipino; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian_japanese IS 'Total population in tract reporting one race as asian, japanese; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian_korean IS 'Total population in tract reporting one race as asian, korean; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian_vietnamese IS 'Total population in tract reporting one race as asian, vietnamese; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_asian_other IS 'Total population in tract reporting one race as asian, other; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_nhopi IS 'Total population in tract reporting one race as Native Hawaiian or other Pacific Islander (nhopi); Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_nhopi_nh IS 'Total population in tract reporting one race as nhopi, native Hawaiian; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_nhopi_guam IS 'Total population in tract reporting one race as nhopi, guam; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_nhopi_samoan IS 'Total population in tract reporting one race as nhopi, samoan; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_nhopi_opi IS 'Total population in tract reporting one race as nhopi, other Pacific Islander; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_onerace_other IS 'Total population in tract reporting one race as other; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_tworaceormore IS 'Total population in tract reporting two races or more; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_tworaceormore_whiteaian IS 'Total population in tract reporting two races or more as white and American Indian/Alaska Native; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_tworaceormore_whiteasian IS 'Total population in tract reporting two races or more as white and asian; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_tworaceormore_whiteaa IS 'Total population in tract reporting two races or more as white and black or African-American; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_tworaceormore_whiteother IS 'Total population in tract reporting two races or more as white and some other race; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.whitealoneorcombo IS 'Total population in tract reporting white alone or in combination with one or more other races; Universe: Races tallied';
COMMENT ON COLUMN $DB_SCHEMA.dp1.aaaloneorcombo IS 'Total population in tract reporting black or African American alone or in combination with one or more other races; Universe: Races tallied';
COMMENT ON COLUMN $DB_SCHEMA.dp1.aianaloneorcombo IS 'Total population in tract reporting American Indian and Alaska Native alone or in combination with one or more other races; Universe: Races tallied';
COMMENT ON COLUMN $DB_SCHEMA.dp1.asianaloneorcombo IS 'Total population in tract reporting Asian alone or in combination with one or more other races; Universe: Races tallied';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nhopialoneorcombo IS 'Total population in tract reporting Native Hawaiian and Other Pacific Islander alone or in combination with one or more other races; Universe: Races tallied';
COMMENT ON COLUMN $DB_SCHEMA.dp1.otheraloneorcombo IS 'Some Other Race alone or in combination with one or more other races; Universe: Races tallied';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop3 IS 'Total population in tract; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_hispanyrace IS 'Total population in tract reporting hispanic of any race; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hispanyrace_mexican IS 'Total population in tract reporting hispanic of any race as Mexican; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hispanyrace_puertorican IS 'Total population in tract reporting hispanic of any race as Puerto Rican; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hispanyrace_cuban IS 'Total population in tract reporting hispanic of any race Cuban; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hispanyrace_otherhisp IS 'Total population in tract reporting hispanic of any race other Hispanic; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_nonhisp IS 'Total population in tract reporting as non-Hispanic; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop4 IS 'Total population in tract; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_hisp IS 'Total population in tract reporting as Hispanic; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hisp_whitealone IS 'Total population in community reporting as Hispanic and white alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hisp_aaalone IS 'Total population in community reporting as Hispanic and black/African-American alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hisp_aianalone IS 'Total population in community reporting as Hispanic and American Indian/Alaskan Native alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hisp_asianalone IS 'Total population in community reporting as Hispanic and asian alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hisp_nhopialone IS 'Total population in community reporting as Hispanic and Native Hawaiian or other Pacific Islander alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hisp_otheralone IS 'Total population in community reporting as Hispanic and other race alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.hisp_twoormore IS 'Total population in community reporting as Hispanic and two or more races; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_nonhisp2 IS 'Total population in tract reporting as non-Hispanic; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nonhisp_whitealone IS 'Total population in community reporting as non-Hispanic and white alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nonhisp_aaalone IS 'Total population in community reporting as non-Hispanic and black/African-American alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nonhisp_aianalone IS 'Total population in community reporting as non-Hispanic and American Indian/Alaskan Native alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nonhisp_asianalone IS 'Total population in community reporting as non-Hispanic and asian alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nonhisp_nhopialone IS 'Total population in community reporting as non-Hispanic and Native Hawaiian or other Pacific Islander alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nonhisp_otheralone IS 'Total population in community reporting as non-Hispanic and other race alone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.nonhisp_twoormore IS 'Total population in community reporting as non-Hispanic and two or more races; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.total_pop5 IS 'Total population in tract; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_inhh IS 'Total population in tract in households; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_hh_householder IS 'Total population in community in households who are a aaalone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_hh_spouse IS 'Total population in community in households who are a aianalone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_hh_child IS 'Total population in community in households who are a asianalone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_hh_child_ownchildunder18 IS 'Total population in tract in households who are an own child under 18 ; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_hh_otherrelative IS 'Total population in community in households who are an otheralone; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_hh_otherrelative_under18 IS 'Total population in tract in households who are an otherrelative under the age of 18; Universe: total_pop';
COMMENT ON COLUMN $DB_SCHEMA.dp1.pop_hh_otherrelative_65over IS 'Total population in tract in households who are an otherrelative 65 years of age or older; Universe: total_pop';