as currently constructed the aggregate summary tables will omit any geographies that do not have any units. This presents a challenge to the publishing process where the output need to be standardized and each geographies should have its own row of record.
Propose Solution:
create template for each aggregate summary levels onto which the aggregate units will get joined before exporting. Ensuring that the exported table is complete. However, this might create the same null issue where no values will create NULLS instead of zeros which GIS wanted.
as currently constructed the aggregate summary tables will omit any geographies that do not have any units. This presents a challenge to the publishing process where the output need to be standardized and each geographies should have its own row of record.
Propose Solution: create template for each aggregate summary levels onto which the aggregate units will get joined before exporting. Ensuring that the exported table is complete. However, this might create the same null issue where no values will create NULLS instead of zeros which GIS wanted.