Name: Illinois_USA_Spending

Display Field: AWARDING_AGENCY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: -91.4125119999999
YMin: 37.002847
XMax: -87.529892
YMax: 42.4980390000001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[121,132,50,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• ASSISTANCE_AWARD_UNIQUE_KEY (type: esriFieldTypeString, alias: assistance_award_unique_key, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• AWARD_ID_FAIN (type: esriFieldTypeString, alias: award_id_fain, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• AWARD_ID_URI (type: esriFieldTypeString, alias: award_id_uri, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• SAI_NUMBER (type: esriFieldTypeString, alias: sai_number, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• DISASTER_EMERGENCY_FUND_CODES (type: esriFieldTypeString, alias: disaster_emergency_fund_codes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• OUTLAYED_AMOUNT_FUNDED_BY_COVI (type: esriFieldTypeDouble, alias: outlayed_amount_funded_by_COVID-19_supplementals, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBLIGATED_AMOUNT_FUNDED_BY_COV (type: esriFieldTypeDouble, alias: obligated_amount_funded_by_COVID-19_supplementals, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_OBLIGATED_AMOUNT (type: esriFieldTypeDouble, alias: total_obligated_amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_NON_FEDERAL_FUNDING_AMOU (type: esriFieldTypeDouble, alias: total_non_federal_funding_amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_FUNDING_AMOUNT (type: esriFieldTypeDouble, alias: total_funding_amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_FACE_VALUE_OF_LOAN (type: esriFieldTypeDouble, alias: total_face_value_of_loan, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_LOAN_SUBSIDY_COST (type: esriFieldTypeDouble, alias: total_loan_subsidy_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AWARD_BASE_ACTION_DATE (type: esriFieldTypeDate, alias: award_base_action_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AWARD_BASE_ACTION_DATE_FISCAL_ (type: esriFieldTypeInteger, alias: award_base_action_date_fiscal_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AWARD_LATEST_ACTION_DATE (type: esriFieldTypeDate, alias: award_latest_action_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AWARD_LATEST_ACTION_DATE_FISCA (type: esriFieldTypeInteger, alias: award_latest_action_date_fiscal_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERIOD_OF_PERFORMANCE_START_DA (type: esriFieldTypeDate, alias: period_of_performance_start_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PERIOD_OF_PERFORMANCE_CURRENT_ (type: esriFieldTypeDate, alias: period_of_performance_current_end_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AWARDING_AGENCY_CODE (type: esriFieldTypeInteger, alias: awarding_agency_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AWARDING_AGENCY_NAME (type: esriFieldTypeString, alias: awarding_agency_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• AWARDING_SUB_AGENCY_CODE (type: esriFieldTypeString, alias: awarding_sub_agency_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AWARDING_SUB_AGENCY_NAME (type: esriFieldTypeString, alias: awarding_sub_agency_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• AWARDING_OFFICE_CODE (type: esriFieldTypeString, alias: awarding_office_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• AWARDING_OFFICE_NAME (type: esriFieldTypeString, alias: awarding_office_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FUNDING_AGENCY_CODE (type: esriFieldTypeString, alias: funding_agency_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FUNDING_AGENCY_NAME (type: esriFieldTypeString, alias: funding_agency_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FUNDING_SUB_AGENCY_CODE (type: esriFieldTypeString, alias: funding_sub_agency_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FUNDING_SUB_AGENCY_NAME (type: esriFieldTypeString, alias: funding_sub_agency_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FUNDING_OFFICE_CODE (type: esriFieldTypeString, alias: funding_office_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FUNDING_OFFICE_NAME (type: esriFieldTypeString, alias: funding_office_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• TREASURY_ACCOUNTS_FUNDING_THIS (type: esriFieldTypeString, alias: treasury_accounts_funding_this_award, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FEDERAL_ACCOUNTS_FUNDING_THIS_ (type: esriFieldTypeString, alias: federal_accounts_funding_this_award, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• OBJECT_CLASSES_FUNDING_THIS_AW (type: esriFieldTypeString, alias: object_classes_funding_this_award, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PROGRAM_ACTIVITIES_FUNDING_THI (type: esriFieldTypeString, alias: program_activities_funding_this_award, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_DUNS (type: esriFieldTypeInteger, alias: recipient_duns, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECIPIENT_UEI (type: esriFieldTypeString, alias: recipient_uei, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_NAME (type: esriFieldTypeString, alias: recipient_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_PARENT_DUNS (type: esriFieldTypeInteger, alias: recipient_parent_duns, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECIPIENT_PARENT_UEI (type: esriFieldTypeString, alias: recipient_parent_uei, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_PARENT_NAME (type: esriFieldTypeString, alias: recipient_parent_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_COUNTRY_CODE (type: esriFieldTypeString, alias: recipient_country_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_COUNTRY_NAME (type: esriFieldTypeString, alias: recipient_country_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_ADDRESS_LINE_1 (type: esriFieldTypeString, alias: recipient_address_line_1, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_ADDRESS_LINE_2 (type: esriFieldTypeString, alias: recipient_address_line_2, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_CITY_CODE (type: esriFieldTypeString, alias: recipient_city_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RECIPIENT_CITY_NAME (type: esriFieldTypeString, alias: recipient_city_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_COUNTY_CODE (type: esriFieldTypeDate, alias: recipient_county_code, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RECIPIENT_COUNTY_NAME (type: esriFieldTypeString, alias: recipient_county_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_STATE_CODE (type: esriFieldTypeString, alias: recipient_state_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_STATE_NAME (type: esriFieldTypeString, alias: recipient_state_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_ZIP_CODE (type: esriFieldTypeString, alias: recipient_zip_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RECIPIENT_ZIP_LAST_4_CODE (type: esriFieldTypeString, alias: recipient_zip_last_4_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RECIPIENT_CONGRESSIONAL_DISTRI (type: esriFieldTypeString, alias: recipient_congressional_district, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RECIPIENT_FOREIGN_CITY_NAME (type: esriFieldTypeString, alias: recipient_foreign_city_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_FOREIGN_PROVINCE_NAM (type: esriFieldTypeString, alias: recipient_foreign_province_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECIPIENT_FOREIGN_POSTAL_CODE (type: esriFieldTypeString, alias: recipient_foreign_postal_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_S (type: esriFieldTypeString, alias: primary_place_of_performance_scope, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_C (type: esriFieldTypeString, alias: primary_place_of_performance_country_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_1 (type: esriFieldTypeString, alias: primary_place_of_performance_country_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_2 (type: esriFieldTypeString, alias: primary_place_of_performance_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_3 (type: esriFieldTypeString, alias: primary_place_of_performance_city_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_4 (type: esriFieldTypeInteger, alias: primary_place_of_performance_county_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_5 (type: esriFieldTypeString, alias: primary_place_of_performance_county_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_6 (type: esriFieldTypeString, alias: primary_place_of_performance_state_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_Z (type: esriFieldTypeString, alias: primary_place_of_performance_zip_4, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_7 (type: esriFieldTypeInteger, alias: primary_place_of_performance_congressional_district, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRIMARY_PLACE_OF_PERFORMANCE_F (type: esriFieldTypeString, alias: primary_place_of_performance_foreign_location, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• CFDA_NUMBERS_AND_TITLES (type: esriFieldTypeString, alias: cfda_numbers_and_titles, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ASSISTANCE_TYPE_CODE (type: esriFieldTypeInteger, alias: assistance_type_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSISTANCE_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: assistance_type_description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• AWARD_DESCRIPTION (type: esriFieldTypeString, alias: award_description, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• BUSINESS_FUNDS_INDICATOR_CODE (type: esriFieldTypeString, alias: business_funds_indicator_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BUSINESS_FUNDS_INDICATOR_DESCR (type: esriFieldTypeString, alias: business_funds_indicator_description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BUSINESS_TYPES_CODE (type: esriFieldTypeString, alias: business_types_code, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BUSINESS_TYPES_DESCRIPTION (type: esriFieldTypeString, alias: business_types_description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• RECORD_TYPE_CODE (type: esriFieldTypeInteger, alias: record_type_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECORD_TYPE_DESCRIPTION (type: esriFieldTypeString, alias: record_type_description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_1_N (type: esriFieldTypeString, alias: highly_compensated_officer_1_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_1_A (type: esriFieldTypeString, alias: highly_compensated_officer_1_amount, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_2_N (type: esriFieldTypeString, alias: highly_compensated_officer_2_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_2_A (type: esriFieldTypeString, alias: highly_compensated_officer_2_amount, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_3_N (type: esriFieldTypeString, alias: highly_compensated_officer_3_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_3_A (type: esriFieldTypeString, alias: highly_compensated_officer_3_amount, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_4_N (type: esriFieldTypeString, alias: highly_compensated_officer_4_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_4_A (type: esriFieldTypeString, alias: highly_compensated_officer_4_amount, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_5_N (type: esriFieldTypeString, alias: highly_compensated_officer_5_name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HIGHLY_COMPENSATED_OFFICER_5_A (type: esriFieldTypeString, alias: highly_compensated_officer_5_amount, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• USASPENDING_PERMALINK (type: esriFieldTypeString, alias: usaspending_permalink, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• LAST_MODIFIED_DATE (type: esriFieldTypeString, alias: last_modified_date, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• MATCH_ADDR (type: esriFieldTypeString, alias: MATCH_ADDR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SCORE (type: esriFieldTypeString, alias: SCORE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Illinois_USA_Spending
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/14/2022 4:36:17 PM

Schema Last Edit Date: 6/14/2022 4:36:17 PM

Data Last Edit Date: 6/14/2022 4:36:17 PM

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