2022 118th Congressional District (CD) to 2022 County for Connecticut Relationship File Layout (acs22_cd11822_county22_st09.txt)
| Relationship File Column Name |
Maximum Length |
Column Definition |
|---|
| OID_CD118_22 |
22 |
OID of 2022 CD118 |
| GEOID_CD118_22 |
4 |
GEOID of the 2022 CD118 |
| NAMELSAD_CD118_22 |
100 |
Name with translated Legal/Statistical Area Description of 2022 CD118 |
| AREALAND_CD118_22 |
14 |
Total land area of 2022 CD118 in square meters |
| AREAWATER_CD118_22 |
14 |
Total water area of 2022 CD118 in square meters |
| MTFCC_CD118_22 |
5 |
MAFTIGER feature class code of 2022 CD118 |
| FUNCSTAT_CD118_22 |
1 |
Functional status of 2022 CD118 |
| OID_COUNTY_22 |
22 |
OID of 2022 county |
| GEOID_COUNTY_22 |
5 |
GEOID of the 2022 county |
| NAMELSAD_COUNTY_22 |
100 |
Name with translated Legal/Statistical Area Description of 2022 county |
| AREALAND_COUNTY_22 |
14 |
Land area of 2022 county in square meters |
| AREAWATER_COUNTY_22 |
14 |
Water area of 2022 county in square meters |
| MTFCC_COUNTY_22 |
5 |
MAFTIGER feature class code of 2022 county |
| CLASSFP_COUNTY_22 |
2 |
FIPS class code of 2022 county |
| FUNCSTAT_COUNTY_22 |
1 |
Functional status of 2022 county |
| AREALAND_PART |
14 |
Calculated land area of the overlapping part in square meters |
| AREAWATER_PART |
14 |
Calculated water area of the overlapping part in square meters |
2022 County Subdivision to 2020 Block Groups for Connecticut Relationship File Layout (acs22_cousub22_blkgrp20_st09.txt)
| Relationship File Column Name |
Maximum Length |
Column Definition |
|---|
| OID_COUSUB_22 |
22 |
OID of the 2022 county subdivision |
| GEOID_COUSUB_22 |
10 |
GEOID of the 2022 county subdivision |
| NAMELSAD_COUSUB_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 county subdivision |
| AREALAND_COUSUB_22 |
14 |
Total land area of the 2022 county subdivision in square meters |
| AREAWATER_COUSUB_22 |
14 |
Total water area of the 2022 county subdivision in square meters |
| MTFCC_COUSUB_22 |
5 |
MAFTIGER feature class code of the 2022 county subdivision |
| CLASSFP_COUSUB_22 |
2 |
FIPS class code of the 2022 county subdivision |
| FUNCSTAT_COUSUB_22 |
1 |
Functional status of the 2022 county subdivision |
| OID_BLKGRP_20 |
22 |
OID of the 2020 block group |
| GEOID_BLKGRP_20 |
12 |
GEOID of the 2020 block group |
| NAMELSAD_BLKGRP_20 |
100 |
Name with translated Legal/Statistical Area Description of the 2020 block group |
| AREALAND_BLKGRP_20 |
14 |
Land area of the 2020 block group in square meters |
| AREAWATER_BLKGRP_20 |
14 |
Water area of the 2020 block group in square meters |
| MTFCC_BLKGRP_20 |
5 |
MAFTIGER feature class code of the 2020 block group |
| FUNCSTAT_BLKGRP_20 |
1 |
Functional status of the 2020 block group |
| AREALAND_PART |
14 |
Calculated land area of the overlapping part in square meters |
| AREAWATER_PART |
14 |
Calculated water area of the overlapping part in square meters |
2022 County Subdivision to 2020 Public Use Microdata Areas (PUMA) for Connecticut Relationship File Layout (acs22_cousub22_puma520_st09.txt)
| Relationship File Column Name |
Maximum Length |
Column Definition |
|---|
| OID_COUSUB_22 |
22 |
OID of the 2022 county subdivision |
| GEOID_COUSUB_22 |
10 |
GEOID of the 2022 county subdivision |
| NAMELSAD_COUSUB_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 county subdivision |
| AREALAND_COUSUB_22 |
14 |
Total land area of the 2022 county subdivision in square meters |
| AREAWATER_COUSUB_22 |
14 |
Total water area of the 2022 county subdivision in square meters |
| MTFCC_COUSUB_22 |
5 |
MAFTIGER feature class code of the 2022 county subdivision |
| CLASSFP_COUSUB_22 |
2 |
FIPS class code of the 2022 county subdivision |
| FUNCSTAT_COUSUB_22 |
1 |
Functional status of the 2022 county subdivision |
| OID_PUMA5_20 |
22 |
OID of the 2020 PUMA5 |
| GEOID_PUMA5_20 |
7 |
GEOID of the 2020 PUMA5 |
| NAMELSAD_PUMA5_20 |
100 |
Name with translated Legal/Statistical Area Description of the 2020 PUMA5 |
| AREALAND_PUMA5_20 |
14 |
Land area of the 2020 PUMA5 in square meters |
| AREAWATER_PUMA5_20 |
14 |
Water area of the 2020 PUMA5 in square meters |
| MTFCC_PUMA5_20 |
5 |
MAFTIGER feature class code of the 2020 PUMA5 |
| FUNCSTAT_PUMA5_20 |
1 |
Functional status of the 2020 PUMA5 |
| AREALAND_PART |
14 |
Calculated land area of the overlapping part in square meters |
| AREAWATER_PART |
14 |
Calculated water area of the overlapping part in square meters |
2022 County Subdivision to 2022 Census Tract for Connecticut Relationship File Layout (acs22_cousub22_tract22_st09.txt)
| Relationship File Column Name |
Maximum Length |
Column Definition |
|---|
| OID_COUSUB_22 |
22 |
OID of the 2022 county subdivision |
| GEOID_COUSUB_22 |
10 |
GEOID of the 2022 county subdivision |
| NAMELSAD_COUSUB_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 county subdivision |
| AREALAND_COUSUB_22 |
14 |
Total land area of the 2022 county subdivision in square meters |
| AREAWATER_COUSUB_22 |
14 |
Total water area of the 2022 county subdivision in square meters |
| MTFCC_COUSUB_22 |
5 |
MAFTIGER feature class code of the 2022 county subdivision |
| CLASSFP_COUSUB_22 |
2 |
FIPS class code of the 2022 county subdivision |
| FUNCSTAT_COUSUB_22 |
1 |
Functional status of the 2022 county subdivision |
| OID_TRACT_22 |
22 |
OID of the 2022 tract |
| GEOID_TRACT_22 |
11 |
GEOID of the 2022 tract |
| NAMELSAD_TRACT_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 tract |
| AREALAND_TRACT_22 |
14 |
Land area of the 2022 tract in square meters |
| AREAWATER_TRACT_22 |
14 |
Water area of the 2022 tract in square meters |
| MTFCC_TRACT_22 |
5 |
MAFTIGER feature class code of the 2022 tract |
| FUNCSTAT_TRACT_22 |
1 |
Functional status of the 2022 tract |
| AREALAND_PART |
14 |
Calculated land area of the overlapping part in square meters |
| AREAWATER_PART |
14 |
Calculated water area of the overlapping part in square meters |
2022 County Subdivision to 2020 ZIP Code Tabulation Area (ZCTA) for Connecticut Relationship File Layout (acs22_cousub22_zcta520_st09.txt)
| Relationship File Column Name |
Maximum Length |
Column Definition |
|---|
| OID_COUSUB_22 |
22 |
OID of the 2022 county subdivision |
| GEOID_COUSUB_22 |
10 |
GEOID of the 2022 county subdivision |
| NAMELSAD_COUSUB_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 county subdivision |
| AREALAND_COUSUB_22 |
14 |
Total land area of the 2022 county subdivision in square meters |
| AREAWATER_COUSUB_22 |
14 |
Total water area of the 2022 county subdivision in square meters |
| MTFCC_COUSUB_22 |
5 |
MAFTIGER feature class code of the 2022 county subdivision |
| CLASSFP_COUSUB_22 |
2 |
FIPS class code of the 2022 county subdivision |
| FUNCSTAT_COUSUB_22 |
1 |
Functional status of the 2022 county subdivision |
| OID_ZCTA5_20 |
22 |
OID of the 2020 ZCTA5 |
| GEOID_ZCTA5_20 |
5 |
GEOID of the 2020 ZCTA5 |
| NAMELSAD_ZCTA5_20 |
100 |
Name with translated Legal/Statistical Area Description of the 2020 ZCTA5 |
| AREALAND_ZCTA5_20 |
14 |
Land area of the 2020 ZCTA5 in square meters |
| AREAWATER_ZCTA5_20 |
14 |
Water area of the 2020 ZCTA5 in square meters |
| MTFCC_ZCTA5_20 |
5 |
MAFTIGER feature class code of the 2020 ZCTA5 |
| CLASSFP_ZCTA5_20 |
2 |
FIPS class code of the 2020 ZCTA5 |
| FUNCSTAT_ZCTA5_20 |
1 |
Functional status of the 2020 ZCTA5 |
| AREALAND_PART |
14 |
Calculated land area of the overlapping part in square meters |
| AREAWATER_PART |
14 |
Calculated water area of the overlapping part in square meters |
2022 State Legislative District-Lower Chamber (SLDL) to 2022 County for Connecticut Relationship File Layout (acs22_sldl202222_county22_st09.txt)
| Relationship File Column Name |
Maximum Length |
Column Definition |
|---|
| OID_SLDL2022_22 |
22 |
OID of the 2022 SLDL |
| GEOID_SLDL2022_22 |
5 |
GEOID of the 2022 SLDL |
| NAMELSAD_SLDL2022_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 SLDL |
| AREALAND_SLDL2022_22 |
14 |
Total land area of the 2022 SLDL in square meters |
| AREAWATER_SLDL2022_22 |
14 |
Total water area of the 2022 SLDL in square meters |
| MTFCC_SLDL2022_22 |
5 |
MAFTIGER feature class code of the 2022 SLDL |
| FUNCSTAT_SLDL2022_22 |
1 |
Functional status of the 2022 SLDL |
| OID_COUNTY_22 |
22 |
OID of the 2022 county |
| GEOID_COUNTY_22 |
5 |
GEOID of the 2022 county |
| NAMELSAD_COUNTY_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 county |
| AREALAND_COUNTY_22 |
14 |
Land area of the 2022 county in square meters |
| AREAWATER_COUNTY_22 |
14 |
Water area of the 2022 county in square meters |
| MTFCC_COUNTY_22 |
5 |
MAFTIGER feature class code of the 2022 county |
| CLASSFP_COUNTY_22 |
2 |
FIPS class code of the 2022 county |
| FUNCSTAT_COUNTY_22 |
1 |
Functional status of the 2022 county |
| AREALAND_PART |
14 |
Calculated land area of the overlapping part in square meters |
| AREAWATER_PART |
14 |
Calculated water area of the overlapping part in square meters |
2022 State Legislative District-Upper Chamber (SLDU) to 2022 County for Connecticut Relationship File Layout (acs22_sldu202222_county22_st09.txt)
| Relationship File Column Name |
Maximum Length |
Column Definition |
|---|
| OID_SLDU2022_22 |
22 |
OID of the 2022 SLDU |
| GEOID_SLDU2022_22 |
5 |
GEOID of the 2022 SLDU |
| NAMELSAD_SLDU2022_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 SLDU |
| AREALAND_SLDU2022_22 |
14 |
Total land area of the 2022 SLDU in square meters |
| AREAWATER_SLDU2022_22 |
14 |
Total water area of the 2022 SLDU in square meters |
| MTFCC_SLDU2022_22 |
5 |
MAFTIGER feature class code of the 2022 SLDU |
| FUNCSTAT_SLDU2022_22 |
1 |
Functional status of the 2022 SLDU |
| OID_COUNTY_22 |
22 |
OID of the 2022 county |
| GEOID_COUNTY_22 |
5 |
GEOID of the 2022 county |
| NAMELSAD_COUNTY_22 |
100 |
Name with translated Legal/Statistical Area Description of the 2022 county |
| AREALAND_COUNTY_22 |
14 |
Land area of the 2022 county in square meters |
| AREAWATER_COUNTY_22 |
14 |
Water area of the 2022 county in square meters |
| MTFCC_COUNTY_22 |
5 |
MAFTIGER feature class code of the 2022 county |
| CLASSFP_COUNTY_22 |
2 |
FIPS class code of the 2022 county |
| FUNCSTAT_COUNTY_22 |
1 |
Functional status of the 2022 county |
| AREALAND_PART |
14 |
Calculated land area of the overlapping part in square meters |
| AREAWATER_PART |
14 |
Calculated water area of the overlapping part in square meters |