topic Joining census data- keeps populating as null in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/joining-census-data-keeps-populating-as-null/m-p/384307#M1282 <HTML><HEAD></HEAD><BODY><P>I'm trying to join ACS data to a tiger line shapefile of block groups. Edited the file to get rid of periods, spaces, etc, and saved as a CSV, but when I join, the demographic data keeps showing up as null.</P><P></P><P>I've done some troubleshooting through previous threads, but nothing seems to be working. I don't really know how to use code, but if someone is able to break things down for a beginner, my instinct at this point is that the join is failing because the CSV data type doesn't match the shapefile data type...I included some pictures of things if that helps.&nbsp;</P><P></P><P>(I couldn't get a picture, but the data type for the shapefile's GEOID is "Text (12)".&nbsp;</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/413275_acs_1.PNG" /></P><P><IMG alt="" class="image-2 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/413285_acs_2.PNG" /></P><P><IMG alt="" class="image-3 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/413286_acs_3.PNG" /></P><P>Thank you!&nbsp;</P></BODY></HTML> Thu, 05 Jul 2018 15:33:19 GMT MarlanaZink1 2018-07-05T15:33:19Z Joining census data- keeps populating as null https://community.esri.com/t5/arcgis-mapping-and-charting-questions/joining-census-data-keeps-populating-as-null/m-p/384307#M1282 <HTML><HEAD></HEAD><BODY><P>I'm trying to join ACS data to a tiger line shapefile of block groups. Edited the file to get rid of periods, spaces, etc, and saved as a CSV, but when I join, the demographic data keeps showing up as null.</P><P></P><P>I've done some troubleshooting through previous threads, but nothing seems to be working. I don't really know how to use code, but if someone is able to break things down for a beginner, my instinct at this point is that the join is failing because the CSV data type doesn't match the shapefile data type...I included some pictures of things if that helps.&nbsp;</P><P></P><P>(I couldn't get a picture, but the data type for the shapefile's GEOID is "Text (12)".&nbsp;</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/413275_acs_1.PNG" /></P><P><IMG alt="" class="image-2 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/413285_acs_2.PNG" /></P><P><IMG alt="" class="image-3 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/413286_acs_3.PNG" /></P><P>Thank you!&nbsp;</P></BODY></HTML> Thu, 05 Jul 2018 15:33:19 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/joining-census-data-keeps-populating-as-null/m-p/384307#M1282 MarlanaZink1 2018-07-05T15:33:19Z