View In:   ArcGIS Online Map Viewer

Name: SDEPUB.SDE.Small_Business_Loans_2013_DUPLICATE

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 Community Reinvestment Act to show numbers and percentages of small business loans in 2013 classified by amount by census tract in the Atlanta region.Measures:Square MilesNumber of Small Business Loans Originated, Less Than or Equal to $100,000 in 2013Number of Small Business Loans Originated, $100,000 to $250,000 in 2013Number of Small Business Loans Originated, $250,000 to $1,000,000 in 2013Number of Small Business Loans Originated With Gross Annual Revenue Less Than or Equal to $1,000,000 in 2013Total Number of Small Business Loans Originated in 2013Total Number of Small Business Loans Originated per Square Mile in 2013Percentage of Number of Small Business Loans Originated, Less Than or Equal to $100,000 in 2013Percentage of Number of Small Business Loans Originated, $250,000 to $1,000,000 in 2013Percentage of Number of Small Business Loans Originated, Less Than or Equal to $1,000,000 in 2013Percentage of All Small Business Loans Originated With Annual Revenue Less Than or Equal to $1,000,000 in 2013Total Amount of Small Business Loans Originated (in thousands), Less Than or Equal to $100,000 in 2013Total Amount of Small Business Loans Originated (in thousands), $100,000 to $250,000 in 2013Total Amount of Small Business Loans Originated (in thousands), $250,000 to $1,000,000 in 2013Total Amount of Small Business Loans Originated (in thousands) With Annual Revenue Less Than or Equal to $1,000,000 in 2013Total Amount of Small Business Loans Originated (in thousands) in 2013Total Amount of Small Business Loans Originated (in thousands) per Square Mile in 2013Percentage of Total Small Business Loans Originated, Less Than or Equal to $100,000 in 2013Percentage of Total Small Business Loans Originated, $250,000 to $1,000,000 in 2013Percentage of Total Small Business Loans Originated, Less Than or Equal to $1,000,000 in 2013Percentage of Small Business Loans Originated With Gross Annual Revenuc Less Than or Equal to $1,000,000 in 2013Change in total Small Business Loans Originated, 2012-2013Change in total Small Business Loan Amount Originated (in thousands), 2012-2013Source: Community Reinvestment Act, Atlanta Regional CommissionDate: 2013

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: [197, 252, 248, 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 )
• Square_Miles ( type: esriFieldTypeDouble, alias: Square_Miles, editable: true, nullable: true, defaultValue: null, modelName: Square_Miles )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Pop_Chng_per_SqMi_2000_2010 ( type: esriFieldTypeDouble, alias: Population Change per Square Mile from 2000 to 2010, editable: true, nullable: true, defaultValue: null, modelName: Pop_Chng_per_SqMi_2000_2010 )
• Num_SmlBusLoans_less_100k_2013 ( type: esriFieldTypeDouble, alias: Number of Small Business Loans Originated less than or equal to $100,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Num_SmlBusLoans_less_100k_2013 )
• Num_SmlBusLoans_100k_250k_2013 ( type: esriFieldTypeSmallInteger, alias: Number of Small Business Loans Originated, $100,000 to $250,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Num_SmlBusLoans_100k_250k_2013 )
• Num_SmBusLoans_250k_1m_2013 ( type: esriFieldTypeDouble, alias: Number of Small Business Loans Originated from $250,000 to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Num_SmBusLoans_250k_1m_2013 )
• SmBusLoans_GrossAnRev_less_1m ( type: esriFieldTypeDouble, alias: Number of Small Business Loans Originated with Gross Annual Revenue less than or equal to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: SmBusLoans_GrossAnRev_less_1m )
• TotNum_SmBusLoans_2013 ( type: esriFieldTypeDouble, alias: Total Number of Small Business Loans Originated in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotNum_SmBusLoans_2013 )
• TotNum_SmBusLoans_perSqMi_2013 ( type: esriFieldTypeDouble, alias: Total Number of Small Business Loans Originated per Square Mile in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotNum_SmBusLoans_perSqMi_2013 )
• Pct_SBloans_lessEq_100k_2013 ( type: esriFieldTypeDouble, alias: Percentage of Number of Small Business Loans Originated less than or equals $100,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_SBloans_lessEq_100k_2013 )
• Pct_SBloans_250k_1M_2013 ( type: esriFieldTypeDouble, alias: Percentage of Number of Small Business Loans Originated from $250,000 to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_SBloans_250k_1M_2013 )
• Pct_SBloans_lessEq_1M_2013 ( type: esriFieldTypeDouble, alias: Percentage of Number of Small Business Loans Originated less than or equal to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_SBloans_lessEq_1M_2013 )
• Pct_SBloans_AnRev_lessEq_1M ( type: esriFieldTypeDouble, alias: Percentage of all Small Business Loans Originated with Annual Revenue less than or equal to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_SBloans_AnRev_lessEq_1M )
• TotalAmt_SBloans_lessEq_100k_k ( type: esriFieldTypeDouble, alias: Total Amount of Small Business Loans Originated less than or equal to $100,000 (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotalAmt_SBloans_lessEq_100k_k )
• TotalAmt_SBloans_100k_250k_k ( type: esriFieldTypeDouble, alias: Total Amoun of Small Business Loans Originated $100,000 to $250,000 (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotalAmt_SBloans_100k_250k_k )
• TotalAmt_SBloans_250k_1M_k ( type: esriFieldTypeDouble, alias: Total Amount of Small Business Loans Originated from $250,000 to $1,000,000 (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotalAmt_SBloans_250k_1M_k )
• TotAmt_SBloans_AnRev_lessEq_1M ( type: esriFieldTypeDouble, alias: Total Amount of Small Business Loans Originated with Annual Revenue less than or equal to $1,000,000 (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_SBloans_AnRev_lessEq_1M )
• TotAmt_SBloans_inKs_2013 ( type: esriFieldTypeDouble, alias: Total Amount of Small Business Loans Originated (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_SBloans_inKs_2013 )
• TotAmt_SBloans_per_SqMi_inKs ( type: esriFieldTypeDouble, alias: Total Amount of Small Business Loans Originated per Square Mile (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_SBloans_per_SqMi_inKs )
• Pct_Tot_SBloans_lessEq_100k ( type: esriFieldTypeDouble, alias: Percent of Total Small Business Loans Originated less than or equal to $100,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_Tot_SBloans_lessEq_100k )
• Pct_Tot_SBloans_250k_1M ( type: esriFieldTypeDouble, alias: Percentage of Total Small Business Loans Originated from $250,000 to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_Tot_SBloans_250k_1M )
• Pct_Tot_SBloans_lessEq_1M ( type: esriFieldTypeDouble, alias: Percentage of Total Small Business Loans Originated less than or equal to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_Tot_SBloans_lessEq_1M )
• Pct_SBLnAmt_GrsAnRev_lessEq_1M ( type: esriFieldTypeDouble, alias: Percentage of Small Business Loan Amount Originated with Gross Annual Revenue less than or equal to $1,000,000 in 2013, editable: true, nullable: true, defaultValue: null, modelName: Pct_SBLnAmt_GrsAnRev_lessEq_1M )
• Chng_TotSBloans_2012_2013 ( type: esriFieldTypeDouble, alias: Change in Total Small Business Loans Originated from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_TotSBloans_2012_2013 )
• Chng_TotSBloanAmt_2012_2013 ( type: esriFieldTypeDouble, alias: Change in Total Small Business Loan Amount (in thousands) Originated from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_TotSBloanAmt_2012_2013 )

Templates:

• Name: SDEPUB.SDE.Small_Business_Loans_2013_DUPLICATE
  Description:
  Prototype:
  Chng_TotSBloans_2012_2013: null
  Pct_SBLnAmt_GrsAnRev_lessEq_1M: null
  TRACTCE10: null
  GEOID10: null
  NAME10: null
  PLNG_REGIO: null
  Pct_Tot_SBloans_lessEq_1M: null
  Square_Miles: null
  Chng_TotSBloanAmt_2012_2013: null
  Pop_Chng_per_SqMi_2000_2010: null
  Num_SmlBusLoans_less_100k_2013: null
  Num_SmlBusLoans_100k_250k_2013: null
  Num_SmBusLoans_250k_1m_2013: null
  SmBusLoans_GrossAnRev_less_1m: null
  TotNum_SmBusLoans_2013: null
  TotNum_SmBusLoans_perSqMi_2013: null
  Pct_SBloans_lessEq_100k_2013: null
  Pct_SBloans_250k_1M_2013: null
  Pct_SBloans_lessEq_1M_2013: null
  Pct_SBloans_AnRev_lessEq_1M: null
  TotalAmt_SBloans_lessEq_100k_k: null
  TotalAmt_SBloans_100k_250k_k: null
  TotalAmt_SBloans_250k_1M_k: null
  TotAmt_SBloans_AnRev_lessEq_1M: null
  TotAmt_SBloans_inKs_2013: null
  TotAmt_SBloans_per_SqMi_inKs: null
  Pct_Tot_SBloans_lessEq_100k: null
  Pct_Tot_SBloans_250k_1M: 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