Name: Zip_Member_Data_Enrich

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: false

Views

Description: Zip_Member_Data_Enrich

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -11618942.9084415
YMin: 3977353.34586635
XMax: -7991311.20993416
YMax: 5813324.42392786
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[235,179,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

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_CD (type: esriFieldTypeString, alias: ZIP_CD, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CLUB_CD (type: esriFieldTypeString, alias: CLUB_CD, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DMA (type: esriFieldTypeString, alias: DMA, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Total_Population (type: esriFieldTypeDouble, alias: Total Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Households (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)
• Member_Count (type: esriFieldTypeDouble, alias: Member Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HH_Count (type: esriFieldTypeDouble, alias: Membership Household Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• New_Members (type: esriFieldTypeDouble, alias: New Member Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_HoH_Age (type: esriFieldTypeDouble, alias: Average Primary Member Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Growth_Rate (type: esriFieldTypeDouble, alias: Member Growth Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Renewal_rate (type: esriFieldTypeDouble, alias: Membership Renewal Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AR_Member_Count (type: esriFieldTypeDouble, alias: AR Member Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AR_HH_Count (type: esriFieldTypeDouble, alias: AR Membership HH Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• acq_mail (type: esriFieldTypeDouble, alias: acq_mail, SQL Type: sqlTypeOther, nullable: true, editable: true)
• acq_response (type: esriFieldTypeDouble, alias: acq_response, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assoc_mail (type: esriFieldTypeDouble, alias: assoc_mail, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assoc_respose (type: esriFieldTypeDouble, alias: assoc_respose, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_mail (type: esriFieldTypeDouble, alias: total_mail, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_response (type: esriFieldTypeDouble, alias: total_response, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BS_Member_Pct (type: esriFieldTypeDouble, alias: Classic Member, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BS_HH_Pct (type: esriFieldTypeDouble, alias: Classic Membership , SQL Type: sqlTypeOther, nullable: true, editable: true)
• PL_Member_Pct (type: esriFieldTypeDouble, alias: Plus Member, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PL_HH_Pct (type: esriFieldTypeDouble, alias: Plus Membership, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PM_Member_Pct (type: esriFieldTypeDouble, alias: Premier Member, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PM_HH_Pct (type: esriFieldTypeDouble, alias: Premier Membership, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aggregationMethod (type: esriFieldTypeString, alias: aggregationMethod, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• householdincome_medhinc_cy (type: esriFieldTypeDouble, alias: Total Median Household Income, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gender_medage_cy (type: esriFieldTypeDouble, alias: Total Median Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_popgrw10cy (type: esriFieldTypeDouble, alias: Growth Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_popdens_cy (type: esriFieldTypeDouble, alias: 2019 Population Density, SQL Type: sqlTypeOther, nullable: true, editable: true)
• populationtotals_incmort_cy (type: esriFieldTypeDouble, alias: 2019 Pct of Income for Mortgage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Membership_Penetration (type: esriFieldTypeDouble, alias: Membership Penetration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AR_Penetration (type: esriFieldTypeDouble, alias: AR Penetration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_Member (type: esriFieldTypeDouble, alias: Non Member, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Zip_Member_Data_Enrich
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/15/2020 7:48:04 PM

Schema Last Edit Date: 7/15/2020 7:48:04 PM

Data Last Edit Date: 7/15/2020 7:48:04 PM

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