View In:   ArcGIS Online Map Viewer

Name: SDEPUB.SDE.Worker_Characteristics

Display Field: NAME10

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This layer was developed by the Research & Analytics Division of the Atlanta Regional Commission using data from the U.S. Census Bureau's On the Map to show characteristics of workers in the Atlanta region by census tract.Measures:Total Workers, 2011Workers Age 29 or Younger, 2011Workers Age 30 to 54, 2011Workers Age 55 or Older, 2011Workers Earnings, $1250 per Month or Less, 2011Workers Earnings, $1251 to $3333 per Month, 2011Workers Earnings, Greater Than $3333 per Month, 2011Percent Workers Age 29 or Younger, 2011Percent Workers Age 30 to 54, 2011Percent Workers Age 55 or Older, 2011Percent Workers Earnings, $1250 per Month or Less, 2011Percent Workers Earnings, $1251 to $3333 per Month, 2011Percent Workers Earnings, Greater Than $3333 per Month, 2011Workers in NAICS sector 11, Agriculture, Forestry, Fishing, and Hunting, 2011Workers in NAICS sector 21, Mining, Quarrying, and Oil & Gas Extraction, 2011Workers in NAICS sector 22, Utilities, 2011Workers in NAICS sector 23, Construction, 2011Workers in NAICS sectors 31 & 33, Manufacturing, 2011Workers in NAICS sector 42, Wholesale Trade, 2011Workers in NAICS sectors 44 & 45, Retail Trade, 2011Workers in NAICS sectors 48 & 49, Transportation and Warehousing, 2011Workers in NAICS sector 51, Information, 2011Workers in NAICS sector 52, Finance and Insurance, 2011Workers in NAICS sector 53, Real Estate and Rental & Leasing, 2011Workers in NAICS sector 54, Professional, Scientific, and Technical Services, 2011Workers in NAICS sector 55, Management of Companies and Enterprises, 2011Workers in NAICS sector 56, Administrative and Support and Waste Management and Remediation Services, 2011Workers in NAICS sector 61, Educational Services, 2011Workers in NAICS sector 62, Health Care and Social Assistance, 2011Workers in NAICS sector 71, Arts, Entertainment, and Recreation, 2011Workers in NAICS sector 72, Accommodation and Food Services, 2011Workers in NAICS sector 81, Other Services, except Public Administration, 2011Workers in NAICS sector 92, Public Administration, 2011Source: U.S. Census Bureau, Atlanta Regional CommissionDate: 2011

Copyright Text:

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: 1940072.6601334997
YMin: 1156199.296826169
XMax: 2497260.917473916
YMax: 1642352.438691169
Spatial Reference: 102667  (2240)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [217, 245, 206, 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 )
• TRACTCE10 ( type: esriFieldTypeString, alias: TRACTCE10, editable: true, nullable: true, length: 6, defaultValue: null, modelName: TRACTCE10 )
• GEOID10 ( type: esriFieldTypeString, alias: GEOID10, editable: true, nullable: true, length: 11, defaultValue: null, modelName: GEOID10 )
• NAME10 ( type: esriFieldTypeString, alias: NAME10, editable: true, nullable: true, length: 7, defaultValue: null, modelName: NAME10 )
• PLNG_REGIO ( type: esriFieldTypeString, alias: PLNG_REGIO, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLNG_REGIO )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Percent_BA_or_Higher ( type: esriFieldTypeDouble, alias: Percent_BA_or_Higher, editable: true, nullable: true, defaultValue: null, modelName: Percent_BA_or_Higher )
• Median_household_income ( type: esriFieldTypeInteger, alias: Median_household_income, editable: true, nullable: true, defaultValue: null, modelName: Median_household_income )
• Total_workers__2011 ( type: esriFieldTypeInteger, alias: Total_workers__2011, editable: true, nullable: true, defaultValue: null, modelName: Total_workers__2011 )
• Workers_age_29_or_younger__2011 ( type: esriFieldTypeInteger, alias: Workers_age_29_or_younger__2011, editable: true, nullable: true, defaultValue: null, modelName: Workers_age_29_or_younger__2011 )
• Workers_age_30_to_54__2011 ( type: esriFieldTypeInteger, alias: Workers_age_30_to_54__2011, editable: true, nullable: true, defaultValue: null, modelName: Workers_age_30_to_54__2011 )
• Workers_age_55_or_older__2011 ( type: esriFieldTypeInteger, alias: Workers_age_55_or_older__2011, editable: true, nullable: true, defaultValue: null, modelName: Workers_age_55_or_older__2011 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Pop_Chng_perSqMi_2000_2010 ( type: esriFieldTypeDouble, alias: Population Change per Square Mile from 2000 to 2010, editable: true, nullable: true, defaultValue: null, modelName: Pop_Chng_perSqMi_2000_2010 )
• Workers_Earn_1250_less_perMo ( type: esriFieldTypeDouble, alias: Workers Earnings, $1250 per Month or less in 2011, editable: true, nullable: true, defaultValue: null, modelName: Workers_Earn_1250_less_perMo )
• Work_Earn_1251_3333_perMo ( type: esriFieldTypeDouble, alias: Workers Earnings, $1251 to $3333 per Month in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_Earn_1251_3333_perMo )
• Work_Earn_More_3333_perMo ( type: esriFieldTypeDouble, alias: Workers Earnings, Greater than $3333 per Month in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_Earn_More_3333_perMo )
• Pct_Work_29younger_2011 ( type: esriFieldTypeDouble, alias: Percent Workers Age 29 or Younger in 2011, editable: true, nullable: true, defaultValue: null, modelName: Pct_Work_29younger_2011 )
• Pct_Work_Age_30_54_2011 ( type: esriFieldTypeDouble, alias: Percent Workers Age 30 to 54 in 2011, editable: true, nullable: true, defaultValue: null, modelName: Pct_Work_Age_30_54_2011 )
• Pct_Work_55_orOlder_2011 ( type: esriFieldTypeDouble, alias: Percent Workers Age 55 or Older in 2011, editable: true, nullable: true, defaultValue: null, modelName: Pct_Work_55_orOlder_2011 )
• Pct_Work_Earn_1250_less_perMo ( type: esriFieldTypeDouble, alias: Percent Workers Earnings, $1250 per Month or Less in 2011, editable: true, nullable: true, defaultValue: null, modelName: Pct_Work_Earn_1250_less_perMo )
• Pct_Work_Earn_1251_3333_perMo ( type: esriFieldTypeDouble, alias: Percent Workers Earnings, $1251 to $3333 per Month in 2011, editable: true, nullable: true, defaultValue: null, modelName: Pct_Work_Earn_1251_3333_perMo )
• Pct_Work_Earn_3333_More_perMo ( type: esriFieldTypeDouble, alias: Percent Workers Earnings, Greater than $3333 per Month in 2011, editable: true, nullable: true, defaultValue: null, modelName: Pct_Work_Earn_3333_More_perMo )
• Work_NAICS11_AgForFishHunt_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 11, Agriculture, Forestry, Fishing, and Hunting in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS11_AgForFishHunt_2011 )
• Work_NAICS21_MinQuaOilGas_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 21, Mining, Quarrying, and Oil & Gas Extraction in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS21_MinQuaOilGas_2011 )
• Work_NAICS22_Utilities_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 22, Utilities in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS22_Utilities_2011 )
• Work_NAICS23_Construction_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 23, Construction in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS23_Construction_2011 )
• Work_NAICS31_33_Manuf_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sectors 31 & 33, Manufacturing in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS31_33_Manuf_2011 )
• Work_NAICS42_WholesTrade_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 42, Wholesale Trade in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS42_WholesTrade_2011 )
• Work_NAICS44_45_RetailTrad_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sectors 44 & 45, Retail Trade in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS44_45_RetailTrad_2011 )
• Work_NAICS48_49_TransWareh_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sectors 48 & 49, Transportation and Warehousing in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS48_49_TransWareh_2011 )
• Work_NAICS51_Information_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 51, Information in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS51_Information_2011 )
• Work_NAICS52_FinanceIns_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 52, Finance and Insurance in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS52_FinanceIns_2011 )
• Work_NAICS53_RealEst_Rent_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 53, Real Estate and Rental & Leasing in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS53_RealEst_Rent_2011 )
• Work_NAICS54_ProSciTecSvcs_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 54, Professional, Scientific, and Technical Services in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS54_ProSciTecSvcs_2011 )
• Work_NAICS55_Mgmt_Comps_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 55, Management of Companies and Enterprises in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS55_Mgmt_Comps_2011 )
• Work_NAICS56_AdSupWstMgmtRemed ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 56, Administrative and Support and Waste Management and Remediation Services in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS56_AdSupWstMgmtRemed )
• Work_NAICS61_EducSvcs_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 61, Educational Services in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS61_EducSvcs_2011 )
• Work_NAICS62_HlthCar_SocAs_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 62, Health Care and Social Assistance in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS62_HlthCar_SocAs_2011 )
• Work_NAICS71_ArtsEntRec_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 71, Arts & Entertainment and Recreation in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS71_ArtsEntRec_2011 )
• Work_NAICS72_Acc_FoodSvc_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 72, Accommodation and Food Services in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS72_Acc_FoodSvc_2011 )
• Work_NAICS81_Othr_excPubAdmin ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 81, Other Services, except Public Administration in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS81_Othr_excPubAdmin )
• Work_NAICS92_PublicAdmin_2011 ( type: esriFieldTypeDouble, alias: Workers in NAICS sector 92, Public Administration in 2011, editable: true, nullable: true, defaultValue: null, modelName: Work_NAICS92_PublicAdmin_2011 )

Templates:

• Name: SDEPUB.SDE.Worker_Characteristics
  Description:
  Prototype:
  Work_NAICS81_Othr_excPubAdmin: null
  Work_NAICS72_Acc_FoodSvc_2011: null
  TRACTCE10: null
  GEOID10: null
  NAME10: null
  PLNG_REGIO: null
  Work_NAICS71_ArtsEntRec_2011: null
  Percent_BA_or_Higher: null
  Median_household_income: null
  Total_workers__2011: null
  Workers_age_29_or_younger__2011: null
  Workers_age_30_to_54__2011: null
  Workers_age_55_or_older__2011: null
  Work_NAICS92_PublicAdmin_2011: null
  Pop_Chng_perSqMi_2000_2010: null
  Workers_Earn_1250_less_perMo: null
  Work_Earn_1251_3333_perMo: null
  Work_Earn_More_3333_perMo: null
  Pct_Work_29younger_2011: null
  Pct_Work_Age_30_54_2011: null
  Pct_Work_55_orOlder_2011: null
  Pct_Work_Earn_1250_less_perMo: null
  Pct_Work_Earn_1251_3333_perMo: null
  Pct_Work_Earn_3333_More_perMo: null
  Work_NAICS11_AgForFishHunt_2011: null
  Work_NAICS21_MinQuaOilGas_2011: null
  Work_NAICS22_Utilities_2011: null
  Work_NAICS23_Construction_2011: null
  Work_NAICS31_33_Manuf_2011: null
  Work_NAICS42_WholesTrade_2011: null
  Work_NAICS44_45_RetailTrad_2011: null
  Work_NAICS48_49_TransWareh_2011: null
  Work_NAICS51_Information_2011: null
  Work_NAICS52_FinanceIns_2011: null
  Work_NAICS53_RealEst_Rent_2011: null
  Work_NAICS54_ProSciTecSvcs_2011: null
  Work_NAICS55_Mgmt_Comps_2011: null
  Work_NAICS56_AdSupWstMgmtRemed: null
  Work_NAICS61_EducSvcs_2011: null
  Work_NAICS62_HlthCar_SocAs_2011: 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