View In:   ArcGIS Online Map Viewer

Name: SDEPUB.SDE.Mortgage_Lending

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 Home Mortgage Disclosure Act to show mortgage loan types and amounts originated by census tract in the Atlanta region.Measures:All Loans Originated, 2013Home Purchase Loans Originated, 2013Refinancing Loans Originated, 2013All Originated Loans per Square Mile, 2013Home Purchase Loans Originated per Square Mile, 2013Refinancing Loans Originated per Square Mile, 2013Average Amount of Home Purchase Loans Originated (in thousands), 2013Average Applicant Income of Home Purchase Loans Originated (in thousands), 2013Average Loan Amount of Refinancing Loans Originated (in thousands), 2013Average Applicant Income of Refinancing Loans Originated (in thousands), 2013All Loans Originated, 2012Home Purchase Loans Originated, 2012Refinancing Loans Originated, 2012All Originated Loans per Square Mile, 2012Home Purchase Loans Originated per Square Mile, 2012Refinancing Loans Originated per Square Mile, 2012Average Amount of Home Purchase Loans Originated (in thousands), 2012Average Applicant Income of Home Purchase Loans Originated (in thousands), 2012Average Loan Amount of Refinancing Loans Originated (in thousands), 2012Average Applicant Income of Refinancing Loans Originated (in thousands), 2012Change, All Loans Originated, 2012-2013Change, Home Purchase Loans Originated, 2012-2013Change, Refinancing Loans Originated, 2012-2013Change, All Originated Loans per Square Mile, 2012-2013Change, Home Purchase Loans Originated per Square Mile, 2012-2013Change, Refinancing Loans Originated per Square Mile, 2012-2013Square MilesSource: U.S. Census Bureau, Atlanta Regional CommissionDate: 2011, 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: [210, 227, 250, 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 )
• All_Loans_Originated__2013 ( type: esriFieldTypeInteger, alias: All_Loans_Originated__2013, editable: true, nullable: true, defaultValue: null, modelName: All_Loans_Originated__2013 )
• All_Originated_Loans__2012 ( type: esriFieldTypeInteger, alias: All_Originated_Loans__2012, editable: true, nullable: true, defaultValue: null, modelName: All_Originated_Loans__2012 )
• 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 )
• HomePurch_Loans_2013 ( type: esriFieldTypeDouble, alias: Home Purchase Loans Originated in 2013, editable: true, nullable: true, defaultValue: null, modelName: HomePurch_Loans_2013 )
• Refi_Loans_Orig_2013 ( type: esriFieldTypeDouble, alias: Refinancing Loans Originated in 2013, editable: true, nullable: true, defaultValue: null, modelName: Refi_Loans_Orig_2013 )
• All_Loans_per_SqMi_2013 ( type: esriFieldTypeDouble, alias: All Originated Loans per Square Mile in 2013, editable: true, nullable: true, defaultValue: null, modelName: All_Loans_per_SqMi_2013 )
• HomePurchLoans_perSqMi_2013 ( type: esriFieldTypeDouble, alias: Home Purchase Loans Originated per Square Mile in 2013, editable: true, nullable: true, defaultValue: null, modelName: HomePurchLoans_perSqMi_2013 )
• RefiLoans_perSqMi_2013 ( type: esriFieldTypeDouble, alias: Refinancing Loans Originated per Square Mile in 2013, editable: true, nullable: true, defaultValue: null, modelName: RefiLoans_perSqMi_2013 )
• AvgAmt_HomePurchLoans_2013 ( type: esriFieldTypeDouble, alias: Average Amount of Home Purchase Loans Originated (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: AvgAmt_HomePurchLoans_2013 )
• AvgAppIncome_HmPurch_2013 ( type: esriFieldTypeDouble, alias: Average Applicant Income of Home Purchase Loans Originated (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: AvgAppIncome_HmPurch_2013 )
• AvgLoanAmt_Refi_2013 ( type: esriFieldTypeDouble, alias: Average Loan Amount of Refinancing Loans Originated (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: AvgLoanAmt_Refi_2013 )
• AvgAppIncome_RefiLoans_2013 ( type: esriFieldTypeDouble, alias: Average Applicant Income of Refinancing Loans Originated (in thousands) in 2013, editable: true, nullable: true, defaultValue: null, modelName: AvgAppIncome_RefiLoans_2013 )
• HomePurchLoansOrig_2012 ( type: esriFieldTypeDouble, alias: Home Purchase Loans Originated in 2012, editable: true, nullable: true, defaultValue: null, modelName: HomePurchLoansOrig_2012 )
• RefiLoansOrig_2012 ( type: esriFieldTypeDouble, alias: Refinancing Loans Originated in 2012, editable: true, nullable: true, defaultValue: null, modelName: RefiLoansOrig_2012 )
• AllOrigLoans_perSqMi_2012 ( type: esriFieldTypeDouble, alias: All Originated Loans per Square Mile in 2012, editable: true, nullable: true, defaultValue: null, modelName: AllOrigLoans_perSqMi_2012 )
• HomePurchLoans_perSqMi_2012 ( type: esriFieldTypeDouble, alias: Home Purchase Loans Originated per Square Mile in 2012, editable: true, nullable: true, defaultValue: null, modelName: HomePurchLoans_perSqMi_2012 )
• RefiLoansOrig_perSqMi_2012 ( type: esriFieldTypeDouble, alias: Refinancing Loans Originated per Square Mile in 2012, editable: true, nullable: true, defaultValue: null, modelName: RefiLoansOrig_perSqMi_2012 )
• AvgAmtHomePurchLoans_2012 ( type: esriFieldTypeDouble, alias: Average Amount of Home Purchase Loans Originated (in thousands) in 2012, editable: true, nullable: true, defaultValue: null, modelName: AvgAmtHomePurchLoans_2012 )
• AvgAppIncom_HomePurchLoans_2012 ( type: esriFieldTypeDouble, alias: Average Applicant Income of Home Purchase Loans Originated (in thousands) in 2012, editable: true, nullable: true, defaultValue: null, modelName: AvgAppIncom_HomePurchLoans_2012 )
• AvgLoanAmt_RefiLoans_2012 ( type: esriFieldTypeDouble, alias: Average Loan Amount of Refinancing Loans Originated (in thousands) in 2012, editable: true, nullable: true, defaultValue: null, modelName: AvgLoanAmt_RefiLoans_2012 )
• AvgAppIncome_RefiLoans_2012 ( type: esriFieldTypeDouble, alias: Average Applicant Income of Refinancing Loans Originated (in thousands) in 2012, editable: true, nullable: true, defaultValue: null, modelName: AvgAppIncome_RefiLoans_2012 )
• Chng_AllLoansOrig_2012_2013 ( type: esriFieldTypeDouble, alias: Change in All Loans Originated from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_AllLoansOrig_2012_2013 )
• Chng_HomePurchLoans_2012_2013 ( type: esriFieldTypeDouble, alias: Change in Home Purchase Loans Originated from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_HomePurchLoans_2012_2013 )
• Chng_RefiLoans_2012_2013 ( type: esriFieldTypeDouble, alias: Change in Refinancing Loans Originated from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_RefiLoans_2012_2013 )
• Chng_AllLoans_perSqMi_2012_2013 ( type: esriFieldTypeDouble, alias: Change in All Originated Loans per Square Mile from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_AllLoans_perSqMi_2012_2013 )
• Chng_HmPurchLn_perSqM_2012_2013 ( type: esriFieldTypeDouble, alias: Change in Home Purchase Loans Originated per Square Mile from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_HmPurchLn_perSqM_2012_2013 )
• Chng_RefiLoan_perSqMi_2012_2013 ( type: esriFieldTypeDouble, alias: Change in Refinancing Loans Originated per Square Mile from 2012 to 2013, editable: true, nullable: true, defaultValue: null, modelName: Chng_RefiLoan_perSqMi_2012_2013 )

Templates:

• Name: SDEPUB.SDE.Mortgage_Lending
  Description:
  Prototype:
  Chng_HmPurchLn_perSqM_2012_2013: null
  Chng_AllLoans_perSqMi_2012_2013: null
  TRACTCE10: null
  GEOID10: null
  NAME10: null
  PLNG_REGIO: null
  Chng_RefiLoans_2012_2013: null
  All_Loans_Originated__2013: null
  All_Originated_Loans__2012: null
  Square_Miles: null
  Chng_RefiLoan_perSqMi_2012_2013: null
  Pop_Chng_per_SqMi_2000_2010: null
  HomePurch_Loans_2013: null
  Refi_Loans_Orig_2013: null
  All_Loans_per_SqMi_2013: null
  HomePurchLoans_perSqMi_2013: null
  RefiLoans_perSqMi_2013: null
  AvgAmt_HomePurchLoans_2013: null
  AvgAppIncome_HmPurch_2013: null
  AvgLoanAmt_Refi_2013: null
  AvgAppIncome_RefiLoans_2013: null
  HomePurchLoansOrig_2012: null
  RefiLoansOrig_2012: null
  AllOrigLoans_perSqMi_2012: null
  HomePurchLoans_perSqMi_2012: null
  RefiLoansOrig_perSqMi_2012: null
  AvgAmtHomePurchLoans_2012: null
  AvgAppIncom_HomePurchLoans_2012: null
  AvgLoanAmt_RefiLoans_2012: null
  AvgAppIncome_RefiLoans_2012: null
  Chng_AllLoansOrig_2012_2013: null
  Chng_HomePurchLoans_2012_2013: 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