Name: CRA_SmallFarms
Display Field: NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: Data Sources1) CRA Small Farm Lending (2022–2024)Source: CRA Disclosure / Aggregate reporting tables (Small Farm Loans – Originations; Table A2-1).Geography: Census tract (as reported in the CRA tables).Years included: 2022, 2023, 2024.2) Demographic context variables (latest ACS estimates)Source: Esri Living Atlas (ACS-based layers/variables).Variables used:Total population (ACS) at census tract level (B01001_001E), 2024Median household income (ACS) at census tract level (B19049_001E), 2024Unit of Analysis and GeographyThe unit of analysis is the census tract, identified by GEOID (11-digit tract identifier).CRA lending records were linked to tract geography using GEOID.Three-year aggregation (2022–2024)CRA metrics were combined across the three years (2022–2024) by summing values for each GEOID.Aggregation was performed at the GEOID level to create a single cumulative record per census tract for the 3-year period.Loan size categoriesCRA small farm lending is provided in standard loan-size categories, including:≤ $100,000$100,000–$250,000$250,000–$500,000Loan counts and amounts are provided for each category.Borrower revenue subsetThe CRA tables also include:Loans to businesses with gross annual revenues ≤ $1 million (count and amount)Important: This “revenue ≤ $1M” measure is a subset of total originations and overlaps the loan-size categories. It should be interpreted as a focused indicator of lending to smaller-revenue businesses, not an additional bucket to add to totals.Additional Derived FieldsTo improve interpretability, this layer includes normalized indicators using population context from ACS.1) Loans per 1,000 residentsField: LoansPer1000ResidentsFormula: TotalLoans / TotalPopulation * 10002) Average loan sizeField: AvgLoanSizeFormula: TotalLoanAmount / TotalLoans(If TotalLoanAmount is stored in $000s, AvgLoanSize reflects the same unit unless converted to dollars.)3) Share of loans ≤ $100K (count)Field: SmallLoanShareFormula: NumLoans_LT100k / TotalLoansInterpretation Notes and LimitationsCRA small farm lending tables reflect reported originations and are subject to CRA reporting rules and coverage.Values represent aggregate activity totals and do not include borrower-level details.“Revenue ≤ $1M” is a subset measure and should not be added to total loan counts/amounts.Demographic context variables (population and median household income) are from ACS estimates and include sampling uncertainty, especially in small geographies.Recommended UseThis layer is best used to:Compare relative lending intensity across tracts (e.g., loans per 1,000 residents)Identify areas where smaller loan activity (≤ $100K) represents a larger or smaller share of lending
Copyright Text: Data processed and published by the Eastern Shore Regional GIS Cooperative (ESRGC).
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 181234.365935587
YMin: 26659.4314861326
XMax: 569857.435625061
YMax: 231184.946463155
Spatial Reference: 103068 (6487)
Drawing Info:
{"renderer":{"type":"classBreaks","authoringInfo":{"type":"classedColor","colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[245,214,193,255],"toColor":[245,214,193,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[209,135,111,255],"toColor":[209,135,111,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,85,57,255],"toColor":[189,85,57,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[156,58,39,255],"toColor":[156,58,39,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[122,28,20,255],"toColor":[122,28,20,255]}]},"classificationMethod":"esriClassifyNaturalBreaks"},"field":"TotalLoans","classificationMethod":"esriClassifyNaturalBreaks","minValue":0,"classBreakInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[244,213,193,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":5,"label":"0 - 5"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[210,136,111,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":12,"label":"6 - 12"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[188,85,57,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":22,"label":"13 - 22"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[155,57,38,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":33,"label":"23 - 33"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[122,28,19,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":48,"label":"34 - 48"}],"legendOptions":{"order":"ascendingValues"}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- STATEFP (type: esriFieldTypeString, alias: STATEFP, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- COUNTYFP (type: esriFieldTypeString, alias: COUNTYFP, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- TRACTCE (type: esriFieldTypeString, alias: TRACTCE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- GEOID (type: esriFieldTypeString, alias: GEOID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
- GEOIDFQ (type: esriFieldTypeString, alias: GEOIDFQ, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- NAMELSAD (type: esriFieldTypeString, alias: NAMELSAD, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- MTFCC (type: esriFieldTypeString, alias: MTFCC, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- FUNCSTAT (type: esriFieldTypeString, alias: FUNCSTAT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- ALAND (type: esriFieldTypeDouble, alias: ALAND, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AWATER (type: esriFieldTypeDouble, alias: AWATER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- INTPTLAT (type: esriFieldTypeString, alias: INTPTLAT, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
- INTPTLON (type: esriFieldTypeString, alias: INTPTLON, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GEOID_1 (type: esriFieldTypeString, alias: GEOID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NumLoans_LT100k (type: esriFieldTypeInteger, alias: Loans ≤ $100K (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AmtLoans_LT100k_k (type: esriFieldTypeInteger, alias: Loans ≤ $100K (Amount), SQL Type: sqlTypeOther, nullable: true, editable: true)
- NumLoans_100_250k (type: esriFieldTypeInteger, alias: Loans $100K–$250K (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AmtLoans_100_250k_k (type: esriFieldTypeInteger, alias: Loans $100K–$250K (Amount), SQL Type: sqlTypeOther, nullable: true, editable: true)
- NumLoans_250_500k (type: esriFieldTypeInteger, alias: Loans $250K–$500K (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AmtLoans_250_500k_k (type: esriFieldTypeInteger, alias: Loans $250K–$500K (Amount), SQL Type: sqlTypeOther, nullable: true, editable: true)
- NumLoans_RevLT1M (type: esriFieldTypeInteger, alias: Loans to Businesses w/ Revenue ≤ $1M (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AmtLoans_RevLT1M_k (type: esriFieldTypeInteger, alias: Loans to Businesses w/ Revenue ≤ $1M (Amount), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TotalLoans (type: esriFieldTypeInteger, alias: Total Loans (All Sizes, Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TotalLoanAmount (type: esriFieldTypeInteger, alias: Total Loan Amount (All Sizes), SQL Type: sqlTypeOther, nullable: true, editable: true)
- B01001_001E (type: esriFieldTypeInteger, alias: Total Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
- B19049_001E (type: esriFieldTypeDouble, alias: Median Household Income in past 12 months (inflation-adjusted dollars to last year of 5-year range), SQL Type: sqlTypeOther, nullable: true, editable: true)
- LoansPer1000Residents (type: esriFieldTypeSingle, alias: LoansPer1000Residents, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AvgLoanSize (type: esriFieldTypeSingle, alias: AvgLoanSize, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SmalLoanShare (type: esriFieldTypeSingle, alias: SmalLoanShare, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: CRA_SmallFarms
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/6/2026 4:02:03 PM
Schema Last Edit Date: 3/6/2026 4:01:14 PM
Data Last Edit Date: 3/6/2026 4:02:03 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat