Name: ACA_Zips_Enrich_ExportTable

Display Field: Name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Name (type: esriFieldTypeString, alias: Zip Name, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• Zip_2_Club_OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Zip_2_Club_ZIP_CD (type: esriFieldTypeString, alias: ZIP_CD, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Zip_2_Club_CLUB_CD (type: esriFieldTypeString, alias: CLUB_CD, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• GeoRef_Input_OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GeoRef_Input_ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• GeoRef_Input_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GeoRef_Input_COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GeoRef_Input_BRANCH_KY (type: esriFieldTypeDouble, alias: BRANCH_KY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GeoRef_Input_BRANCH_CD (type: esriFieldTypeString, alias: BRANCH_CD, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• GeoRef_Input_BRANCH_NAME (type: esriFieldTypeString, alias: BRANCH_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GeoRef_Input_MA_CURRENT_STORE (type: esriFieldTypeDouble, alias: MA_CURRENT_STORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GeoRef_Input_Store_Type (type: esriFieldTypeString, alias: Store_Type, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GeoRef_Input_DIVISION_KY (type: esriFieldTypeDouble, alias: DIVISION_KY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GeoRef_Input_DIVISION_CD (type: esriFieldTypeString, alias: DIVISION_CD, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GeoRef_Input_DIVISION_NAME (type: esriFieldTypeString, alias: DIVISION_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GeoRef_Input_CLUB_CD (type: esriFieldTypeString, alias: CLUB_CD, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• GeoRef_Input_ACA_CLUB_CD (type: esriFieldTypeString, alias: ACA_CLUB_CD, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• GeoRef_Input_DMA (type: esriFieldTypeString, alias: DMA, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GeoRef_Input_Membership_Total (type: esriFieldTypeDouble, alias: Membership_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HasData (type: esriFieldTypeInteger, alias: HasData, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_totpop_cy (type: esriFieldTypeDouble, alias: Total Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• householdtotals_tothh_cy (type: esriFieldTypeDouble, alias: Total Households, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Update_dt (type: esriFieldTypeDate, alias: Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HasData_1 (type: esriFieldTypeInteger, alias: HasData_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aggregationMethod (type: esriFieldTypeString, alias: aggregationMethod, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• populationtotals_TOTPOP_CY_1 (type: esriFieldTypeDouble, alias: 2025 Total Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_HHPOP_CY (type: esriFieldTypeDouble, alias: 2025 Household Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_FAMPOP_CY (type: esriFieldTypeDouble, alias: 2025 Family Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_POPDENS_CY (type: esriFieldTypeDouble, alias: 2025 Population Density, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_POPGRW20CY (type: esriFieldTypeDouble, alias: 2020-2025 Growth Rate: Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_HHPGRW20CY (type: esriFieldTypeDouble, alias: 2020-2025 Growth Rate: Household Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_Length (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_Area (type: esriFieldTypeDouble, alias: Shape_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Region_ID (type: esriFieldTypeSmallInteger, alias: Region_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Region_NM (type: esriFieldTypeString, alias: Region_NM, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Component (type: esriFieldTypeString, alias: Component, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Final_Clus (type: esriFieldTypeSmallInteger, alias: Final_Clus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cluster_NM (type: esriFieldTypeString, alias: Cluster_NM, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ParentID (type: esriFieldTypeInteger, alias: Parent Territory ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParentID_1 (type: esriFieldTypeInteger, alias: Parent Territory ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParentID_12 (type: esriFieldTypeInteger, alias: Parent Territory ID, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: ACA_Zips_Enrich_ExportTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/12/2026 7:36:26 PM

Schema Last Edit Date: 8/12/2026 7:36:26 PM

Data Last Edit Date: 8/12/2026 7:36:26 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat