How to combine Combining table data to perform mean center analysis? using ArcMap

I have two tables: one in Excel and one in .txt format. I need to move these into ArcMap 10.1 and combine them with a polygon shapefile of counties in a state. However, I don't know how to do this.

Afterwards I need to calculate the mean center of the population of the state by using the data provided by the two tables. Each table consists of a list of the counties and the population of each county for different years. The fields are the years and the first field states the county names.

I've tried merging the two tables in Excel and then importing my table in ArcMap, then when I try to do a join between the shapefile and the table I get null values where the attached table values should be.

Can someone explain to be how I would exactly get this data joined to the polygon shapefile? I'm fairly new to GIS so please be mindful of my lack of knowledge on this subject when answering.

How to combine table data to perform mean center analysis?

I have two tables: one in Excel and one in .txt format. I need to move these into ArcMap 10.1 and combine them with a polygon shapefile of counties in a state. However I don't know how to do this.

Afterwards I need to calculate the mean center of the population of the state by using the data provided by the two tables. Each table consists of a list of the counties and the population of each county for different years. The fields are the years and the first field states the county names.

I've tried merging the two tables in Excel and then importing my table in ArcMap, then when I try to do a join between the shapefile and the table I get null values where the attached table values should be.

Can someone explain to be how I would exactly get this data joined to the polygon shapefile? I'm fairly new to GIS so please be mindful of my lack of knowledge on this subject when answering.

Combining table data to perform mean center analysis using ArcMap

I have two tables: one in Excel and one in .txt format. I need to move these into ArcMap 10.1 and combine them with a polygon shapefile of counties in a state. However, I don't know how to do this.

Afterwards I need to calculate the mean center of the population of the state by using the data provided by the two tables. Each table consists of a list of the counties and the population of each county for different years. The fields are the years and the first field states the county names.

I've tried merging the two tables in Excel and then importing my table in ArcMap, then when I try to do a join between the shapefile and the table I get null values where the attached table values should be.

Can someone explain to be how I would exactly get this data joined to the polygon shapefile?

corrected spelling, remove thanks, improved grammar

Source Link

edited Jan 17, 2018 at 5:14

nmtoken

13.6k
5
38
89

I have two tables: one in excelExcel and one in .txt format. I need to move these in tointo ArcMap 10.1 and combine them with a polygon shapefile of counties in a statestate. However I don't know how to do this.

Afterwards I need to calculate the mean center of the population of the state by using the data provided by the two tables. Each table consists of a list of the counties and the population of each county for different years. The fields are the years and the first field states the county names.

I've tried merging the two tables in excelExcel and then importing my table in ArcMap, then when I try to do a join between the shapefile and the table I get null values where the attached table values should be.

Can someone explain to be how I would exactly get this data joined to the polygon shape fileshapefile? I'm fairly new to GIS so please be mindful of my lack of knowledge on this subject when answering. Thanks everyone!

I have two tables: one in excel and one in .txt format. I need to move these in to ArcMap 10.1 and combine them with a polygon shapefile of counties in a state. However I don't know how to do this.

Afterwards I need to calculate the mean center of the population of the state by using the data provided by the two tables. Each table consists of a list of the counties and the population of each county for different years. The fields are the years and the first field states the county names.

I've tried merging the two tables in excel and then importing my table in ArcMap, then when I try to do a join between the shapefile and the table I get null values where the attached table values should be.

Can someone explain to be how I would exactly get this data joined to the polygon shape file? I'm fairly new to GIS so please be mindful of my lack of knowledge on this subject when answering. Thanks everyone!

I have two tables: one in Excel and one in .txt format. I need to move these into ArcMap 10.1 and combine them with a polygon shapefile of counties in a state. However I don't know how to do this.

Afterwards I need to calculate the mean center of the population of the state by using the data provided by the two tables. Each table consists of a list of the counties and the population of each county for different years. The fields are the years and the first field states the county names.

I've tried merging the two tables in Excel and then importing my table in ArcMap, then when I try to do a join between the shapefile and the table I get null values where the attached table values should be.

Can someone explain to be how I would exactly get this data joined to the polygon shapefile? I'm fairly new to GIS so please be mindful of my lack of knowledge on this subject when answering.