Name: SBA_Data_Analysis

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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:

• Loan_type (type: esriFieldTypeString, alias: Loan type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Acceptance_date (type: esriFieldTypeDate, alias: Acceptance date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• SBA_Status (type: esriFieldTypeString, alias: SBA Status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FEMA_Declaration_Number (type: esriFieldTypeInteger, alias: FEMA Declaration Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SBA_Disaster_Number (type: esriFieldTypeString, alias: SBA Disaster Number, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SBA_Physical_Declaration_Number (type: esriFieldTypeInteger, alias: SBA Physical Declaration Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Loan_Amt (type: esriFieldTypeInteger, alias: Current Loan Amt, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_verified_loss (type: esriFieldTypeDouble, alias: Total verified loss, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Current_total_verified_loss (type: esriFieldTypeDouble, alias: Current total verified loss, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Total_amount_disbursed (type: esriFieldTypeDouble, alias: Total amount disbursed, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• EIDL_disbursed (type: esriFieldTypeString, alias: EIDL disbursed, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DP_City (type: esriFieldTypeString, alias: DP City, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DP_Zip (type: esriFieldTypeInteger, alias: DP Zip, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• DP_County (type: esriFieldTypeString, alias: DP County, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Verified_Personal_Property (type: esriFieldTypeString, alias: Verified Personal Property, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Verified_Motor_Vehicle (type: esriFieldTypeString, alias: Verified Motor Vehicle, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Verified_Manufactured_Housing (type: esriFieldTypeDouble, alias: Verified Manufactured Housing, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Verified_Real_Estate_Reloaction (type: esriFieldTypeInteger, alias: Verified Real Estate Reloaction, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Verified_Real_Estate_Repair (type: esriFieldTypeDouble, alias: Verified Real Estate Repair, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Verified_Real_Estate_Reconstruc (type: esriFieldTypeDouble, alias: Verified Real Estate Reconstruction, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Verified_Landscaping (type: esriFieldTypeDouble, alias: Verified Landscaping, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Verified_Debris_Removal (type: esriFieldTypeString, alias: Verified Debris Removal, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Verified_Other_Land_Improvement (type: esriFieldTypeString, alias: Verified Other Land Improvements, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Verified_Mitigation (type: esriFieldTypeInteger, alias: Verified Mitigation, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Verified_Code_Required_Elevatio (type: esriFieldTypeInteger, alias: Verified Code Required Elevation, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Verified_Inventory (type: esriFieldTypeString, alias: Verified Inventory, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Verified_Machinery___Equipment (type: esriFieldTypeString, alias: Verified Machinery & Equipment, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Verified_Furniture_and_Fixtures (type: esriFieldTypeString, alias: Verified Furniture and Fixtures, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Verified_Leasehold_Improvements (type: esriFieldTypeString, alias: Verified Leasehold Improvements, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Approved_EIDL (type: esriFieldTypeString, alias: Approved EIDL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Approved_Personal_Property (type: esriFieldTypeDouble, alias: Approved Personal Property, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Approved_Motor_Vehicle (type: esriFieldTypeString, alias: Approved Motor Vehicle, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Approved_Manufactured_Housing (type: esriFieldTypeInteger, alias: Approved Manufactured Housing, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Real_Estate_Reloaction (type: esriFieldTypeInteger, alias: Approved Real Estate Reloaction, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Real_Estate_Repair (type: esriFieldTypeString, alias: Approved Real Estate Repair, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Approved_Real_Estate_Reconstruc (type: esriFieldTypeInteger, alias: Approved Real Estate Reconstruction, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Landscaping (type: esriFieldTypeInteger, alias: Approved Landscaping, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Debris_Removal (type: esriFieldTypeInteger, alias: Approved Debris Removal, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Other_Land_Improvement (type: esriFieldTypeInteger, alias: Approved Other Land Improvements, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Mitigation (type: esriFieldTypeInteger, alias: Approved Mitigation, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Code_Required_Elevatio (type: esriFieldTypeInteger, alias: Approved Code Required Elevation, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Inventory (type: esriFieldTypeInteger, alias: Approved Inventory, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Machinery___Equipment (type: esriFieldTypeInteger, alias: Approved Machinery & Equipment, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Furniture_and_Fixtures (type: esriFieldTypeInteger, alias: Approved Furniture and Fixtures, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Leasehold_Improvements (type: esriFieldTypeInteger, alias: Approved Leasehold Improvements, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Approved_Refinance (type: esriFieldTypeInteger, alias: Approved Refinance, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_EIDL (type: esriFieldTypeString, alias: Current EIDL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Current_Personal_Property (type: esriFieldTypeDouble, alias: Current Personal Property, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Current_Motor_Vehicle (type: esriFieldTypeInteger, alias: Current Motor Vehicle, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Manufactured_Housing (type: esriFieldTypeInteger, alias: Current Manufactured Housing, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Refinance (type: esriFieldTypeInteger, alias: Current Refinance, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Real_Estate_Reloaction (type: esriFieldTypeInteger, alias: Current Real Estate Reloaction, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Real_Estate_Repair (type: esriFieldTypeString, alias: Current Real Estate Repair, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Current_Real_Estate_Reconstruct (type: esriFieldTypeInteger, alias: Current Real Estate Reconstruction, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Landscaping (type: esriFieldTypeInteger, alias: Current Landscaping, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Debris_Removal (type: esriFieldTypeInteger, alias: Current Debris Removal, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Other_Land_Improvements (type: esriFieldTypeInteger, alias: Current Other Land Improvements, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Mitigation (type: esriFieldTypeInteger, alias: Current Mitigation, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Code_Required_Elevation (type: esriFieldTypeInteger, alias: Current Code Required Elevation, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Inventory (type: esriFieldTypeInteger, alias: Current Inventory, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Machinery___Equipment (type: esriFieldTypeInteger, alias: Current Machinery & Equipment, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Furniture_and_Fixtures (type: esriFieldTypeInteger, alias: Current Furniture and Fixtures, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Current_Leasehold_Improvements (type: esriFieldTypeInteger, alias: Current Leasehold Improvements, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Last_disb_date (type: esriFieldTypeDate, alias: Last disb date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/3/2023 8:09:29 PM

Schema Last Edit Date: 8/3/2023 8:09:29 PM

Data Last Edit Date: 8/3/2023 8:09:29 PM

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