CORELMI_US_V3.DAT_STAFFING - Removing support for AREAID_TYPE "TRACT"

37 days, 23 hours, and 55 minutes
Complete
Complete

The maintenance is now complete. Thanks for your patience.

Updated

We are updating this notice to clarify the scope of the upcoming change. Support for areaIdType=ZIP will remain available; only areaIdType=TRACT is being removed.

The datarun associated with this change is now expected to take place within the next two weeks.

No action is required for ZIP-based workflows.

If you have any questions, concerns, or believe this change may impact your workflows, please reach out to your Lightcast representative.

Underway

The scheduled maintenance is now underway. We'll keep you updated on our progress.

Scheduled

Due to the increasing size of the CORELMI_US_V3.DAT_STAFFING table, we are planning an upcoming change to optimize performance and reduce storage and data transfer costs.

As part of this change, the following AREAID_TYPE levels will be removed from the table:

  • ZIP
  • TRACT

The table will continue to support the following AREAID_TYPE levels:

  • NATION
  • STATE
  • MSA
  • COUNTY

Removing these two most granular levels will reduce the overall size of the table by approximately 95%, resulting in improved query performance and lower costs associated with storage and data transfer.

If you have any questions, concerns, or believe this change may impact your workflows, please reach out to your Lightcast representative.

Affected components
  • Data Share
    • Core LMI US