View In:
ArcGIS Online Map Viewer
Name: SDEPUB.SDE.Small_Business_Loans_2012_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 2010 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 2012Number of Small Business Loans Originated, $100,000 to $250,000 in 2012Number of Small Business Loans Originated, $250,000 to $1,000,000 in 2012Number of Small Business Loans Originated With Gross Annual Revenue Less Than or Equal to $1,000,000 in 2012Total Number of Small Business Loans Originated in 2012Total Number of Small Business Loans Originated per Square Mile in 2012Percentage of Number of Small Business Loans Originated, Less Than or Equal to $100,000 in 2012Percentage of Number of Small Business Loans Originated, $250,000 to $1,000,000 in 2012Percentage of Number of Small Business Loans Originated, Less Than or Equal to $1,000,000 in 2012Percentage of All Small Business Loans Originated With Gross Annual Revenue Less Than or Equal to $1,000,000 in 2012Total Amount of Small Business Loans Originated (in thousands), Less Than or Equal to $100,000 in 2012Total Amount of Small Business Loans Originated (in thousands), $100,000 to $250,000 in 2012Total Amount of Small Business Loans Originated (in thousands), $250,000 to $1,000,000 in 2012Total Amount of Small Business Loans Originated (in thousands) With Annual Revenue Less Than or Equal to $1,000,000 in 2012Total Amount of Small Business Loans Originated (in thousands) in 2012Total Amount of Small Business Loans Originated (in thousands) per Square Mile in 2012Percentage of Total Small Business Loans Originated, Less Than or Equal to $100,000 in 2012Percentage of Total Small Business Loans Originated, $250,000 to $1,000,000 in 2012Percentage of Total Small Business Loans Originated, Less Than or Equal to $1,000,000 in 2012Percentage of Small Business Loans Originated With Gross Annual Revenuc Less Than or Equal to $1,000,000 in 2012Total Number of Small Business Loans Purchased in 2012Total Amount of Small Business Loans (in thousands) Purchased in 2012Change 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: 2012
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:
[219, 247, 205, 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
)
-
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_SBloans_lessEq_100k_2012
(
type: esriFieldTypeDouble, alias: Number of Small Business Loans Originated less than or equal to $100,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: Num_SBloans_lessEq_100k_2012
)
-
Num_SBloans_100k_250k_2012
(
type: esriFieldTypeDouble, alias: Number of Small Business Loans Originated from $100,000 to $250,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: Num_SBloans_100k_250k_2012
)
-
Num_SBloans_250k_1M_2012
(
type: esriFieldTypeDouble, alias: Number of Small Business Loans Originated from $250,000 to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: Num_SBloans_250k_1M_2012
)
-
Num_SBloans_GrAnRev_lessEq_1M
(
type: esriFieldTypeDouble, alias: Number of Small Business Loans Originated with Gross Annual Revenue less than or equal to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: Num_SBloans_GrAnRev_lessEq_1M
)
-
TotNum_SBloans_Orig_2012
(
type: esriFieldTypeDouble, alias: Total Number of Small Business Loans Originated in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotNum_SBloans_Orig_2012
)
-
PctNum_SBloans_lessEq_100k_2012
(
type: esriFieldTypeDouble, alias: Percentage of Number of Small Business Loans Originated less than or equal to $100,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctNum_SBloans_lessEq_100k_2012
)
-
PctNum_SBloans_250k_1M_2012
(
type: esriFieldTypeDouble, alias: Percentage of Number of Small Business Loans Originated from $250,000 to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctNum_SBloans_250k_1M_2012
)
-
PctNum_SBloans_lessEq_1M_2012
(
type: esriFieldTypeDouble, alias: Percentage of Number of Small Business Loans Originated less than or equal to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctNum_SBloans_lessEq_1M_2012
)
-
PctNum_SBlns_GrAnRev_lessEq_1M
(
type: esriFieldTypeDouble, alias: Percentate of Number of Small Business Loans Originated with Gross Annual Revenue less than or equal to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctNum_SBlns_GrAnRev_lessEq_1M
)
-
TotAmt_SBloans1k_lessEq_100k
(
type: esriFieldTypeDouble, alias: Total Amount of Small Business Loans Originated (in thousands) less than or equal to $100,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_SBloans1k_lessEq_100k
)
-
TotAmt_inKs_SBloans_100k_250k
(
type: esriFieldTypeDouble, alias: Total Amount (in thousands) of Small Business Loans Originated from $100,000 to $250,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_inKs_SBloans_100k_250k
)
-
TotAmt_inKs_SBloans_250k_1M
(
type: esriFieldTypeDouble, alias: Total Amount (in thousands) of Small Business Loans Originated from $250,000 to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_inKs_SBloans_250k_1M
)
-
TotAmt_SBlns_GrAnRev_lessEq_1M
(
type: esriFieldTypeDouble, alias: Total Amount (in thousands) of Small Business Loans Originated with Gross Annual Revenue less than or equal to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_SBlns_GrAnRev_lessEq_1M
)
-
TotAmt_inKs_SBloans_2012
(
type: esriFieldTypeDouble, alias: Total Amount (in thousands) of Small Business Loans Originated in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_inKs_SBloans_2012
)
-
PctTot_SBloans_lessEq_100k_2012
(
type: esriFieldTypeDouble, alias: Pecentage of Total Small Business Loans Originated less than or equal to $100,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctTot_SBloans_lessEq_100k_2012
)
-
PctTot_SBloans_250k_1M_2012
(
type: esriFieldTypeDouble, alias: Percentage of Total Small Business Loans Originated from $250,000 to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctTot_SBloans_250k_1M_2012
)
-
PctTot_SBloans_lessEq_1M_2012
(
type: esriFieldTypeDouble, alias: Percentage of Total Small Business Loans Originated less than or equal to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctTot_SBloans_lessEq_1M_2012
)
-
PctAmt_SBlns_GrAnRev_lessEq_1M
(
type: esriFieldTypeDouble, alias: Percentage of Amount of Small Business Loans Originated with Gross Annual Renenue less than or equal to $1,000,000 in 2012, editable: true, nullable: true, defaultValue: null, modelName: PctAmt_SBlns_GrAnRev_lessEq_1M
)
-
TotNum_SBloans_Purchased_2012
(
type: esriFieldTypeDouble, alias: Total Number of Small Business Loans Purchased in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotNum_SBloans_Purchased_2012
)
-
TotAmt_inKs_SBloans_Purch_2012
(
type: esriFieldTypeDouble, alias: Total Amount (in thousands) of Small Business Loans Purchased in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_inKs_SBloans_Purch_2012
)
-
TotNum_SBloans_perSqMi_2012
(
type: esriFieldTypeDouble, alias: Total Number of Small Business Loans Originated per Square Mile in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotNum_SBloans_perSqMi_2012
)
-
TotAmt_inKs_SBlns_perSqMi_2012
(
type: esriFieldTypeDouble, alias: Total Amount (in thousands) of Small Business Loans Originated per Square Mile in 2012, editable: true, nullable: true, defaultValue: null, modelName: TotAmt_inKs_SBlns_perSqMi_2012
)
Templates:
-
Name: SDEPUB.SDE.Small_Business_Loans_2012_DUPLICATE
Description:
Prototype:
TotNum_SBloans_perSqMi_2012: null
TotAmt_inKs_SBloans_Purch_2012: null
TRACTCE10: null
GEOID10: null
NAME10: null
PLNG_REGIO: null
TotNum_SBloans_Purchased_2012: null
TotAmt_inKs_SBlns_perSqMi_2012: null
Pop_Chng_per_SqMi_2000_2010: null
Num_SBloans_lessEq_100k_2012: null
Num_SBloans_100k_250k_2012: null
Num_SBloans_250k_1M_2012: null
Num_SBloans_GrAnRev_lessEq_1M: null
TotNum_SBloans_Orig_2012: null
PctNum_SBloans_lessEq_100k_2012: null
PctNum_SBloans_250k_1M_2012: null
PctNum_SBloans_lessEq_1M_2012: null
PctNum_SBlns_GrAnRev_lessEq_1M: null
TotAmt_SBloans1k_lessEq_100k: null
TotAmt_inKs_SBloans_100k_250k: null
TotAmt_inKs_SBloans_250k_1M: null
TotAmt_SBlns_GrAnRev_lessEq_1M: null
TotAmt_inKs_SBloans_2012: null
PctTot_SBloans_lessEq_100k_2012: null
PctTot_SBloans_250k_1M_2012: null
PctTot_SBloans_lessEq_1M_2012: null
PctAmt_SBlns_GrAnRev_lessEq_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