topic Re: Attempting to Create Temporal Layer Merge Creating Null Values in ArcGIS Pro Questions

Attempting to Create Temporal Layer Merge Creating Null Values

GroundworkORVGIS — Tue, 14 Feb 2023 22:57:57 GMT

I am trying to merge US Census data from 1930-2010, so I can create a temporal layer that shows how the populations changed over time. I have a census layer for each decade and when I merge them I get null values for all the datasets aside from the first one in the merge. I particularly need the % Non-White field. I checked the data types and they are all numeric. I tried appending and that didn't solve the issue. I also tried joining that got nulls again. Is there another way I can create a temporal display without having the layers combined? Maybe this isn't possible because the size of the census blocks have changed significantly over time. I'm going to try to export the merged table into excel and copy and paste the percent non-white numbers from the original layers tomorrow. That should work, but it's not the most efficient.

Re: Attempting to Create Temporal Layer Merge Creating Null Values

Kepa — Wed, 15 Feb 2023 20:06:43 GMT

Hello @GroundworkORVGIS,

As I understand, Append tool is the way to go. If field names do not match you should use field mapping to set source/target fields. Append will always modifiy the target feature class. I'm not sure about the temporal layer you mentioned... perhaps you could start copying first decade into memory workspace.

Regards,

Re: Attempting to Create Temporal Layer Merge Creating Null Values

GroundworkORVGIS — Thu, 09 Mar 2023 18:53:37 GMT

When I removed the 1930 dataset it ended up working properly with append. 1930 wasn't vital, so I'm just going without it.