Name: IFF Projects

Display Field: NAME_1

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Name (type: esriFieldTypeInteger, alias: Name, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Account (type: esriFieldTypeString, alias: Account, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Opportunity_Type (type: esriFieldTypeString, alias: Opportunity Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Original_Closing_Date (type: esriFieldTypeDate, alias: Original Closing Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Census_Tract__Deal___Opportunit (type: esriFieldTypeString, alias: Census Tract (Deal) (Opportunity), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEOID (type: esriFieldTypeString, alias: GEOID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• TRACT (type: esriFieldTypeString, alias: TRACT, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• LOWMODPCT (type: esriFieldTypeDouble, alias: LOWMODPCT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHAPE_Leng (type: esriFieldTypeDouble, alias: SHAPE_Leng, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_Length (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_Area (type: esriFieldTypeDouble, alias: Shape_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEOID_Num (type: esriFieldTypeDouble, alias: GEOID_Num, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Majority_Minority___Greater_tha (type: esriFieldTypeString, alias: Majority Minority – Greater than or equal to 50% minority, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Persistent_Poverty_County (type: esriFieldTypeString, alias: Persistent Poverty County, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• High_Poverty_Area (type: esriFieldTypeString, alias: High_Poverty_Area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAME_1 (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATE_NAME (type: esriFieldTypeString, alias: STATE_NAME, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Very_Low_Income (type: esriFieldTypeString, alias: Very_Low_Income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Extremely_Low_Income (type: esriFieldTypeString, alias: Extremely_Low_Income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Greater_than_or_equal_to_the_90 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for expected agriculture loss rate and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_91 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for expected building loss rate and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_92 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for expected population loss rate and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_93 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for share of properties at risk of flood in 30 years and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_94 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for share of properties at risk of fire in 30 years and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_95 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for energy burden and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_96 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for PM2.5 exposure and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_97 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for diesel particulate matter and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_98 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for traffic proximity and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_the_99 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for DOT transit barriers and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_100 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for housing burden and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_101 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for lead paint, the median house value is less than 90th percentile and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_102 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for share of the tract's land area that is covered by impervious surface or cropland as a percent and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_103 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for proximity to hazardous waste facilities and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_104 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for proximity to superfund sites and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_105 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for proximity to RMP sites and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Is_there_at_least_one_Formerly_ (type: esriFieldTypeString, alias: Is there at least one Formerly Used Defense Site (FUDS) in the tract?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Is_there_at_least_one_abandoned (type: esriFieldTypeString, alias: Is there at least one abandoned mine in this census tract?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Is_there_at_least_one_Formerly1 (type: esriFieldTypeString, alias: Is there at least one Formerly Used Defense Site (FUDS) in the tract, where missing data is treated as False?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Is_there_at_least_one_abandon_1 (type: esriFieldTypeString, alias: Is there at least one abandoned mine in this census tract, where missing data is treated as False?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_106 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for wastewater discharge and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_107 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for leaky underground storage tanks and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_108 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for asthma and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_109 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for diabetes and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_110 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for heart disease and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_111 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for low life expectancy and is low income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_112 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for low median household income as a percent of area median income and has low HS attainment?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_113 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for households in linguistic isolation and has low HS attainment?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_114 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for unemployment and has low HS attainment?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_115 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for households at or below 100% federal poverty level and has low HS attainment?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_116 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for unemployment and has low HS education in 2009 (island areas)?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_117 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for households at or below 100% federal poverty level and has low HS education in 2009 (island areas)?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Greater_than_or_equal_to_th_118 (type: esriFieldTypeString, alias: Greater than or equal to the 90th percentile for low median household income as a percent of area median income and has low HS education in 2009 (island areas)?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Tract_experienced_historic_unde (type: esriFieldTypeString, alias: Tract experienced historic underinvestment and remains low income, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Indoor_Plumbing_low_income (type: esriFieldTypeString, alias: Indoor_Plumbing_low_income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• P0010001 (type: esriFieldTypeInteger, alias: Total Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P009_calc_pctWa (type: esriFieldTypeDouble, alias: Percent White alone, not Hispanic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P009_calc_pctWac (type: esriFieldTypeDouble, alias: Percent White alone or in combination with other races and ethnicities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P009_calc_pctBa (type: esriFieldTypeDouble, alias: Percent Black or African American alone, not Hispanic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P009_calc_pctBac (type: esriFieldTypeDouble, alias: Percent Black or African American alone or in combination with other races and ethnicities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P009_calc_pctH (type: esriFieldTypeDouble, alias: Percent Hispanic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P009_calc_pctDI (type: esriFieldTypeDouble, alias: Census Diversity Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P009_calc_txtPrevRank1 (type: esriFieldTypeString, alias: Most prevalent group, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• B17020_001E (type: esriFieldTypeInteger, alias: Total Population for whom Poverty Status is Determined, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B17020_002E (type: esriFieldTypeInteger, alias: Population whose income in the past 12 months is below federal poverty level, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B17020_calc_pctPovE (type: esriFieldTypeDouble, alias: Percent of Population whose income in the past 12 months is below poverty level, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tract_Family_Income (type: esriFieldTypeInteger, alias: Tract Median Family Income, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Low_Income_Community (type: esriFieldTypeString, alias: Low Income Community, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)

Templates:

Name: IFF Projects
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Deeper_Distress_Indicators_Final (0) -- Related To: CDFI Fund FA Supporting Data (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/2/2024 9:20:45 PM

Schema Last Edit Date: 2/2/2024 9:20:45 PM

Data Last Edit Date: 2/2/2024 9:20:45 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat