View In:   ArcGIS Online Map Viewer

Name: SDEPUB.SDE.Businesses_ZipCode_2005_2015

Display Field: ZIP

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This layer was developed by the Research & Analytics Group of the Atlanta Regional Commission, to show data on business establishments (U.S. Census: County Business Patterns, 2005-2015), by zip code for the Atlanta region.- - - - - -Base Attributes:ZIP = Zip code (text)ZIP_dbl = Zip code (numeric)Total_Population_2010= Total Population, 2010 CensusTotal_Population_2011_2015_ACS= Total Population, 2011-2015 American Community Survey (ACS)- - - - - - Attributes from U.S. Census: County Business Patterns:Number_of_establishments_2015= Number of establishments, 2015Establishments_perSqMi_2015= Establishments per Square Mile, 2015Establishments_per1000_Pop_2015= Establishments per 1,000 population, 2015 (Population is 2010)Paid_employees_March_2015= Paid employees for pay period including March 12 (number), 2015First_quarter_payroll_000s_2015= First-quarter payroll (000s), 2015Annual_payroll_000s_2015= Annual payroll (000s), 2015Number_of_establishments_2013= Number of establishments, 2013Establishments_perSqMi_2013= Establishments per Square Mile, 2013Establishments_per1000_Pop_2013= Establishments per 1,000 population, 2013 (Population is 2010)Annual_payroll_000s_2013= Annual payroll (000s), 2013First_quarter_payroll_000s_2013= First-quarter payroll (000s), 2013Paid_employees_March_2013= Paid employees for pay period including March 12 (number), 2013Number_of_establishments_2010= Number of establishments, 2010Paid_employees_March_2010= Paid employees for pay period including March 12 (number), 2010First_quarter_payroll_000s_2010= First-quarter payroll (000s), 2010Annual_payroll_000s_2010= Annual payroll (000s), 2010Number_of_establishments_2005= Number of establishments, 2005Paid_employees_March_2005= Paid employees for pay period including March 12 (number), 2005First_quarter_payroll_000s_2005= First-quarter payroll (000s), 2005Annual_payroll_000s_2005= Annual payroll (000s), 2005Chng_establishments_2005_2010= Change in the number of establishments between 2005-2010Chng_establishments_2005_2013= Change in the number of establishments between 2005-2013 Chng_establishments_2005_2015= Change in the number of establishments between 2005-2015Chng_estabmts_PerSqMi_2005_2010= Change in the number of establishments, Per Sq Mile, between 2005-2010Chng_estabmts_PerSqMi_2005_2013= Change in the number of establishments, Per Sq Mile, between 2005-2013 Chng_estabmts_PerSqMi_2005_2015= Change in the number of establishments, Per Sq Mile, between 2005-2015Chng_establishments_2010_2015= Change in the number of establishments between 2010-2015Chng_estabmts_PerSqMi_2010_2015= Change in the number of establishments, Per Sq Mile, between 2010-2015- - - - - - All_establishments_2015= All establishments, 2015Very_Small_Businesses_2015= Very Small businesses (1-4) employees, 2015Small_Businesses_2015= Small Businesses (5-19 employees), 2015Medium_Businesses_2015= Medium-sized businesses (20-99 employees), 2015Large_Businesses_2015= Large Businesses (100+ employees), 2015Pct_Very_Small_Businesses_2015= %, Very Small businesses (1-4) employees, 2015Pct_Small_Businesses_2015= %, Small Businesses (5-19 employees), 2015Pct_Medium_Businesses_2015= %, Medium-sized businesses (20-99 employees), 2015Pct_Large_Businesses_2015= %, Large Businesses (100+ employees), 2015All_establishments_2010= All establishments, 2010Very_Small_Businesses_2010= Very Small businesses (1-4) employees, 2010Small_Businesses_2010= Small Businesses (5-19 employees), 2010Medium_Businesses_2010= Medium-sized businesses (20-99 employees), 2010Large_Businesses_2010= Large Businesses (100+ employees), 2010Pct_Very_Small_Businesses_2010= % Very Small businesses (1-4) employees, 2010Pct_Small_Businesses_2010= % Small Businesses (5-19 employees), 2010Pct_Medium_Businesses_2010= % Medium-sized businesses (20-99 employees), 2010Pct_Large_Businesses_2010= % Large Businesses (100+ employees), 2010All_establishments_2005= All establishments, 2005Very_Small_Businesses_2005= Very Small businesses (1-4) employees, 2005Small_Businesses_2005= Small Businesses (5-19 employees), 2005Medium_Businesses_2005= Medium-sized businesses (20-99 employees), 2005Large_Businesses_2005= Large Businesses (100+ employees), 2005Pct_Very_Small_Businesses_2005= %, Very Small businesses (1-4) employees, 2005Pct_Small_Businesses_2005= %, Small Businesses (5-19 employees), 2005Pct_Medium_Businesses_2005= %, Medium-sized businesses (20-99 employees), 2005Pct_Large_Businesses_2005= %, Large Businesses (100+ employees), 2005- - - - - - Sources/Dates:U.S. Census: County Business Patterns, 2005-2015For additional information, please visit the Atlanta Regional Commission at www.atlantaregional.com.

Copyright Text: • U.S. Census: County Business Patterns • Atlanta Regional Commission

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 1926462.1604516618
YMin: 1035022.2724484056
XMax: 2497321.161775995
YMax: 1679922.515453741
Spatial Reference: 102667  (2240)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 170, 0, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ZIP ( type: esriFieldTypeString, alias: Zip code (text), editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIP )
• ZIP_dbl ( type: esriFieldTypeDouble, alias: Zip code (numeric), editable: true, nullable: true, defaultValue: null, modelName: ZIP_dbl )
• Weave_Zip_Census_ACS_Total_Popu ( type: esriFieldTypeInteger, alias: Total_Population_2010, editable: true, nullable: true, defaultValue: null, modelName: Weave_Zip_Census_ACS_Total_Population_csv_Total_Population_2010 )
• Total_Population_2011_2015_ACS ( type: esriFieldTypeInteger, alias: Total Population, 2011-2015 American Community Survey (ACS), editable: true, nullable: true, defaultValue: null, modelName: Total_Population_2011_2015_ACS )
• Number_of_establishments_2015 ( type: esriFieldTypeInteger, alias: Number of establishments, 2015, editable: true, nullable: true, defaultValue: null, modelName: Number_of_establishments_2015 )
• Establishments_perSqMi_2015 ( type: esriFieldTypeDouble, alias: Establishments per Square Mile, 2015, editable: true, nullable: true, defaultValue: null, modelName: Establishments_perSqMi_2015 )
• Establishments_per1000_Pop_2015 ( type: esriFieldTypeDouble, alias: Establishments per 1,000 population, 2015 (Population is 2010), editable: true, nullable: true, defaultValue: null, modelName: Establishments_per1000_Pop_2015 )
• Paid_employees_March_2015 ( type: esriFieldTypeString, alias: Paid employees for pay period including March 12 (number), 2015, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Paid_employees_March_2015 )
• First_quarter_payroll_000s_2015 ( type: esriFieldTypeString, alias: First-quarter payroll (000s), 2015, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: First_quarter_payroll_000s_2015 )
• Annual_payroll_000s_2015 ( type: esriFieldTypeString, alias: Annual payroll (000s), 2015, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Annual_payroll_000s_2015 )
• Number_of_establishments_2013 ( type: esriFieldTypeInteger, alias: Number of establishments, 2013, editable: true, nullable: true, defaultValue: null, modelName: Number_of_establishments_2013 )
• Establishments_perSqMi_2013 ( type: esriFieldTypeDouble, alias: Establishments per Square Mile, 2013, editable: true, nullable: true, defaultValue: null, modelName: Establishments_perSqMi_2013 )
• Establishments_per1000_Pop_2013 ( type: esriFieldTypeDouble, alias: Establishments per 1,000 population, 2013 (Population is 2010), editable: true, nullable: true, defaultValue: null, modelName: Establishments_per1000_Pop_2013 )
• Annual_payroll_000s_2013 ( type: esriFieldTypeInteger, alias: Annual payroll (000s), 2013, editable: true, nullable: true, defaultValue: null, modelName: Annual_payroll_000s_2013 )
• First_quarter_payroll_000s_2013 ( type: esriFieldTypeInteger, alias: First-quarter payroll (000s), 2013, editable: true, nullable: true, defaultValue: null, modelName: First_quarter_payroll_000s_2013 )
• Paid_employees_March_2013 ( type: esriFieldTypeInteger, alias: Paid employees for pay period including March 12 (number), 2013, editable: true, nullable: true, defaultValue: null, modelName: Paid_employees_March_2013 )
• Number_of_establishments_2010 ( type: esriFieldTypeInteger, alias: Number of establishments, 2010, editable: true, nullable: true, defaultValue: null, modelName: Number_of_establishments_2010 )
• Paid_employees_March_2010 ( type: esriFieldTypeInteger, alias: Paid employees for pay period including March 12 (number), 2010, editable: true, nullable: true, defaultValue: null, modelName: Paid_employees_March_2010 )
• First_quarter_payroll_000s_2010 ( type: esriFieldTypeInteger, alias: First-quarter payroll (000s), 2010, editable: true, nullable: true, defaultValue: null, modelName: First_quarter_payroll_000s_2010 )
• Annual_payroll_000s_2010 ( type: esriFieldTypeInteger, alias: Annual payroll (000s), 2010, editable: true, nullable: true, defaultValue: null, modelName: Annual_payroll_000s_2010 )
• Number_of_establishments_2005 ( type: esriFieldTypeInteger, alias: Number of establishments, 2005, editable: true, nullable: true, defaultValue: null, modelName: Number_of_establishments_2005 )
• Paid_employees_March_2005 ( type: esriFieldTypeInteger, alias: Paid employees for pay period including March 12 (number), 2005, editable: true, nullable: true, defaultValue: null, modelName: Paid_employees_March_2005 )
• First_quarter_payroll_000s_2005 ( type: esriFieldTypeInteger, alias: First-quarter payroll (000s), 2005, editable: true, nullable: true, defaultValue: null, modelName: First_quarter_payroll_000s_2005 )
• Annual_payroll_000s_2005 ( type: esriFieldTypeInteger, alias: Annual payroll (000s), 2005, editable: true, nullable: true, defaultValue: null, modelName: Annual_payroll_000s_2005 )
• Chng_establishments_2005_2010 ( type: esriFieldTypeInteger, alias: Change in the number of establishments between 2005-2010, editable: true, nullable: true, defaultValue: null, modelName: Chng_establishments_2005_2010 )
• Chng_establishments_2005_2013 ( type: esriFieldTypeInteger, alias: Change in the number of establishments between 2005-2013 , editable: true, nullable: true, defaultValue: null, modelName: Chng_establishments_2005_2013 )
• Chng_establishments_2005_2015 ( type: esriFieldTypeInteger, alias: Change in the number of establishments between 2005-2015, editable: true, nullable: true, defaultValue: null, modelName: Chng_establishments_2005_2015 )
• Chng_estabmts_PerSqMi_2005_2010 ( type: esriFieldTypeDouble, alias: Change in the number of establishments, Per Sq Mile, between 2005-2010, editable: true, nullable: true, defaultValue: null, modelName: Chng_estabmts_PerSqMi_2005_2010 )
• Chng_estabmts_PerSqMi_2005_2013 ( type: esriFieldTypeDouble, alias: Change in the number of establishments, Per Sq Mile, between 2005-2013 , editable: true, nullable: true, defaultValue: null, modelName: Chng_estabmts_PerSqMi_2005_2013 )
• Chng_estabmts_PerSqMi_2005_2015 ( type: esriFieldTypeDouble, alias: Change in the number of establishments, Per Sq Mile, between 2005-2015, editable: true, nullable: true, defaultValue: null, modelName: Chng_estabmts_PerSqMi_2005_2015 )
• Chng_establishments_2010_2015 ( type: esriFieldTypeInteger, alias: Change in the number of establishments between 2010-2015, editable: true, nullable: true, defaultValue: null, modelName: Chng_establishments_2010_2015 )
• Chng_estabmts_PerSqMi_2010_2015 ( type: esriFieldTypeDouble, alias: Change in the number of establishments, Per Sq Mile, between 2010-2015, editable: true, nullable: true, defaultValue: null, modelName: Chng_estabmts_PerSqMi_2010_2015 )
• All_establishments_2015 ( type: esriFieldTypeInteger, alias: All establishments, 2015, editable: true, nullable: true, defaultValue: null, modelName: All_establishments_2015 )
• Very_Small_Businesses_2015 ( type: esriFieldTypeInteger, alias: Very Small Businesses (1-4) employees, 2015, editable: true, nullable: true, defaultValue: null, modelName: Very_Small_Businesses_2015 )
• Small_Businesses_2015 ( type: esriFieldTypeInteger, alias: Small Businesses (5-19 employees), 2015, editable: true, nullable: true, defaultValue: null, modelName: Small_Businesses_2015 )
• Medium_Businesses_2015 ( type: esriFieldTypeInteger, alias: Medium-sized Businesses (20-99 employees), 2015, editable: true, nullable: true, defaultValue: null, modelName: Medium_Businesses_2015 )
• Large_Businesses_2015 ( type: esriFieldTypeInteger, alias: Large Businesses (100+ employees), 2015, editable: true, nullable: true, defaultValue: null, modelName: Large_Businesses_2015 )
• Pct_Very_Small_Businesses_2015 ( type: esriFieldTypeDouble, alias: %, Very Small Businesses (1-4) employees, 2015, editable: true, nullable: true, defaultValue: null, modelName: Pct_Very_Small_Businesses_2015 )
• Pct_Small_Businesses_2015 ( type: esriFieldTypeDouble, alias: %, Small Businesses (5-19 employees), 2015, editable: true, nullable: true, defaultValue: null, modelName: Pct_Small_Businesses_2015 )
• Pct_Medium_Businesses_2015 ( type: esriFieldTypeDouble, alias: %, Medium-sized Businesses (20-99 employees), 2015, editable: true, nullable: true, defaultValue: null, modelName: Pct_Medium_Businesses_2015 )
• Pct_Large_Businesses_2015 ( type: esriFieldTypeDouble, alias: %, Large Businesses (100+ employees), 2015, editable: true, nullable: true, defaultValue: null, modelName: Pct_Large_Businesses_2015 )
• All_establishments_2010 ( type: esriFieldTypeInteger, alias: All establishments, 2010, editable: true, nullable: true, defaultValue: null, modelName: All_establishments_2010 )
• Very_Small_Businesses_2010 ( type: esriFieldTypeInteger, alias: Very Small Businesses (1-4) employees, 2010, editable: true, nullable: true, defaultValue: null, modelName: Very_Small_Businesses_2010 )
• Small_Businesses_2010 ( type: esriFieldTypeInteger, alias: Small Businesses (5-19 employees), 2010, editable: true, nullable: true, defaultValue: null, modelName: Small_Businesses_2010 )
• Medium_Businesses_2010 ( type: esriFieldTypeInteger, alias: Medium-sized Businesses (20-99 employees), 2010, editable: true, nullable: true, defaultValue: null, modelName: Medium_Businesses_2010 )
• Large_Businesses_2010 ( type: esriFieldTypeInteger, alias: Large Businesses (100+ employees), 2010, editable: true, nullable: true, defaultValue: null, modelName: Large_Businesses_2010 )
• Pct_Very_Small_Businesses_2010 ( type: esriFieldTypeDouble, alias: % Very Small Businesses (1-4) employees, 2010, editable: true, nullable: true, defaultValue: null, modelName: Pct_Very_Small_Businesses_2010 )
• Pct_Small_Businesses_2010 ( type: esriFieldTypeDouble, alias: % Small Businesses (5-19 employees), 2010, editable: true, nullable: true, defaultValue: null, modelName: Pct_Small_Businesses_2010 )
• Pct_Medium_Businesses_2010 ( type: esriFieldTypeDouble, alias: % Medium-sized Businesses (20-99 employees), 2010, editable: true, nullable: true, defaultValue: null, modelName: Pct_Medium_Businesses_2010 )
• Pct_Large_Businesses_2010 ( type: esriFieldTypeDouble, alias: % Large Businesses (100+ employees), 2010, editable: true, nullable: true, defaultValue: null, modelName: Pct_Large_Businesses_2010 )
• All_establishments_2005 ( type: esriFieldTypeInteger, alias: All establishments, 2005, editable: true, nullable: true, defaultValue: null, modelName: All_establishments_2005 )
• Very_Small_Businesses_2005 ( type: esriFieldTypeInteger, alias: Very Small Businesses (1-4) employees, 2005, editable: true, nullable: true, defaultValue: null, modelName: Very_Small_Businesses_2005 )
• Small_Businesses_2005 ( type: esriFieldTypeInteger, alias: Small Businesses (5-19 employees), 2005, editable: true, nullable: true, defaultValue: null, modelName: Small_Businesses_2005 )
• Medium_Businesses_2005 ( type: esriFieldTypeInteger, alias: Medium-sized Businesses (20-99 employees), 2005, editable: true, nullable: true, defaultValue: null, modelName: Medium_Businesses_2005 )
• Large_Businesses_2005 ( type: esriFieldTypeInteger, alias: Large Businesses (100+ employees), 2005, editable: true, nullable: true, defaultValue: null, modelName: Large_Businesses_2005 )
• Pct_Very_Small_Businesses_2005 ( type: esriFieldTypeDouble, alias: %, Very Small Businesses (1-4) employees, 2005, editable: true, nullable: true, defaultValue: null, modelName: Pct_Very_Small_Businesses_2005 )
• Pct_Small_Businesses_2005 ( type: esriFieldTypeDouble, alias: %, Small Businesses (5-19 employees), 2005, editable: true, nullable: true, defaultValue: null, modelName: Pct_Small_Businesses_2005 )
• Pct_Medium_Businesses_2005 ( type: esriFieldTypeDouble, alias: %, Medium-sized Businesses (20-99 employees), 2005, editable: true, nullable: true, defaultValue: null, modelName: Pct_Medium_Businesses_2005 )
• Pct_Large_Businesses_2005 ( type: esriFieldTypeDouble, alias: %, Large Businesses (100+ employees), 2005, editable: true, nullable: true, defaultValue: null, modelName: Pct_Large_Businesses_2005 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: SDEPUB.SDE.Businesses_ZipCode_2005_2015
  Description:
  Prototype:
  Pct_Medium_Businesses_2005: null
  Pct_Large_Businesses_2005: null
  ZIP: null
  ZIP_dbl: null
  Weave_Zip_Census_ACS_Total_Popu: null
  Total_Population_2011_2015_ACS: null
  Number_of_establishments_2015: null
  Establishments_perSqMi_2015: null
  Establishments_per1000_Pop_2015: null
  Paid_employees_March_2015: null
  First_quarter_payroll_000s_2015: null
  Annual_payroll_000s_2015: null
  Number_of_establishments_2013: null
  Establishments_perSqMi_2013: null
  Establishments_per1000_Pop_2013: null
  Annual_payroll_000s_2013: null
  First_quarter_payroll_000s_2013: null
  Paid_employees_March_2013: null
  Number_of_establishments_2010: null
  Paid_employees_March_2010: null
  First_quarter_payroll_000s_2010: null
  Annual_payroll_000s_2010: null
  Number_of_establishments_2005: null
  Paid_employees_March_2005: null
  First_quarter_payroll_000s_2005: null
  Annual_payroll_000s_2005: null
  Chng_establishments_2005_2010: null
  Chng_establishments_2005_2013: null
  Chng_establishments_2005_2015: null
  Chng_estabmts_PerSqMi_2005_2010: null
  Chng_estabmts_PerSqMi_2005_2013: null
  Chng_estabmts_PerSqMi_2005_2015: null
  Chng_establishments_2010_2015: null
  Chng_estabmts_PerSqMi_2010_2015: null
  All_establishments_2015: null
  Very_Small_Businesses_2015: null
  Small_Businesses_2015: null
  Medium_Businesses_2015: null
  Large_Businesses_2015: null
  Pct_Very_Small_Businesses_2015: null
  Pct_Small_Businesses_2015: null
  Pct_Medium_Businesses_2015: null
  Pct_Large_Businesses_2015: null
  All_establishments_2010: null
  Very_Small_Businesses_2010: null
  Small_Businesses_2010: null
  Medium_Businesses_2010: null
  Large_Businesses_2010: null
  Pct_Very_Small_Businesses_2010: null
  Pct_Small_Businesses_2010: null
  Pct_Medium_Businesses_2010: null
  Pct_Large_Businesses_2010: null
  All_establishments_2005: null
  Very_Small_Businesses_2005: null
  Small_Businesses_2005: null
  Medium_Businesses_2005: null
  Large_Businesses_2005: null
  Pct_Very_Small_Businesses_2005: null
  Pct_Small_Businesses_2005: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata