Name: PPP_Loans_210331

Display Field: Loc_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: -12918177.4370834
YMin: 4438856.81127575
XMax: -10736805.7941411
YMax: 6274636.59054424
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[87,147,38,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)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: LongLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: ShortLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlaceName (type: esriFieldTypeString, alias: PlaceName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rank (type: esriFieldTypeDouble, alias: Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddBldg (type: esriFieldTypeString, alias: BuildingName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: AddressNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: AddNumFrom, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: AddNumTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: AddressRange, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StPreDir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: BldgType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: BldgName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: LevelType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: LevelName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: UnitType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: UnitName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SubAddr (type: esriFieldTypeString, alias: SubAddress, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Nbrhd (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• MetroArea (type: esriFieldTypeString, alias: MetroArea, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• RegionAbbr (type: esriFieldTypeString, alias: RegionAbbr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Territory (type: esriFieldTypeString, alias: Territory, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PostalExt (type: esriFieldTypeString, alias: PostalExt, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayX (type: esriFieldTypeDouble, alias: DisplayX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: DisplayY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmin (type: esriFieldTypeDouble, alias: Xmin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Xmax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Ymin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Ymax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: ExtraInfo, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ResultID (type: esriFieldTypeInteger, alias: ResultID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_Address (type: esriFieldTypeString, alias: Address or Place, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address3 (type: esriFieldTypeString, alias: Address3, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Subregion (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Postal (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_PostalExt (type: esriFieldTypeString, alias: ZIP4, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_CountryCode (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_Field1 (type: esriFieldTypeInteger, alias: Field1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_LoanNumber (type: esriFieldTypeDouble, alias: LoanNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DateApproved (type: esriFieldTypeDate, alias: DateApproved, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_SBAOfficeCode (type: esriFieldTypeInteger, alias: SBAOfficeCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_ProcessingMethod (type: esriFieldTypeString, alias: ProcessingMethod, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_BorrowerName (type: esriFieldTypeString, alias: BorrowerName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_BorrowerAddress (type: esriFieldTypeString, alias: BorrowerAddress, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_BorrowerCity (type: esriFieldTypeString, alias: BorrowerCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_BorrowerState (type: esriFieldTypeString, alias: BorrowerState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_BorrowerZip (type: esriFieldTypeString, alias: BorrowerZip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_LoanStatusDate (type: esriFieldTypeDate, alias: LoanStatusDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_LoanStatus (type: esriFieldTypeString, alias: LoanStatus, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Term (type: esriFieldTypeInteger, alias: Term, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_SBAGuarantyPercentage (type: esriFieldTypeInteger, alias: SBAGuarantyPercentage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_InitialApprovalAmount (type: esriFieldTypeDouble, alias: InitialApprovalAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_CurrentApprovalAmount (type: esriFieldTypeDouble, alias: CurrentApprovalAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_UndisbursedAmount (type: esriFieldTypeDouble, alias: UndisbursedAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_FranchiseName (type: esriFieldTypeString, alias: FranchiseName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ServicingLenderLocationID (type: esriFieldTypeInteger, alias: ServicingLenderLocationID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_ServicingLenderName (type: esriFieldTypeString, alias: ServicingLenderName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ServicingLenderAddress (type: esriFieldTypeString, alias: ServicingLenderAddress, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ServicingLenderCity (type: esriFieldTypeString, alias: ServicingLenderCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ServicingLenderState (type: esriFieldTypeString, alias: ServicingLenderState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ServicingLenderZip (type: esriFieldTypeString, alias: ServicingLenderZip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_RuralUrbanIndicator (type: esriFieldTypeString, alias: RuralUrbanIndicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_HubzoneIndicator (type: esriFieldTypeString, alias: HubzoneIndicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_LMIIndicator (type: esriFieldTypeString, alias: LMIIndicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_BusinessAgeDescription (type: esriFieldTypeString, alias: BusinessAgeDescription, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ProjectCity (type: esriFieldTypeString, alias: ProjectCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ProjectCountyName (type: esriFieldTypeString, alias: ProjectCountyName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ProjectState (type: esriFieldTypeString, alias: ProjectState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ProjectZip (type: esriFieldTypeString, alias: ProjectZip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_CD (type: esriFieldTypeString, alias: CD, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_JobsReported (type: esriFieldTypeString, alias: JobsReported, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_NAICSCode (type: esriFieldTypeString, alias: NAICSCode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Race (type: esriFieldTypeString, alias: Race, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Ethnicity (type: esriFieldTypeString, alias: Ethnicity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_UTILITIES_PROCEED (type: esriFieldTypeString, alias: UTILITIES_PROCEED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_PAYROLL_PROCEED (type: esriFieldTypeString, alias: PAYROLL_PROCEED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_MORTGAGE_INTEREST_PROCEED (type: esriFieldTypeString, alias: MORTGAGE_INTEREST_PROCEED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_RENT_PROCEED (type: esriFieldTypeString, alias: RENT_PROCEED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_REFINANCE_EIDL_PROCEED (type: esriFieldTypeString, alias: REFINANCE_EIDL_PROCEED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_HEALTH_CARE_PROCEED (type: esriFieldTypeString, alias: HEALTH_CARE_PROCEED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_DEBT_INTEREST_PROCEED (type: esriFieldTypeString, alias: DEBT_INTEREST_PROCEED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_BusinessType (type: esriFieldTypeString, alias: BusinessType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OriginatingLenderLocationI (type: esriFieldTypeInteger, alias: OriginatingLenderLocationID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_OriginatingLender (type: esriFieldTypeString, alias: OriginatingLender, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OriginatingLenderCity (type: esriFieldTypeString, alias: OriginatingLenderCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OriginatingLenderState (type: esriFieldTypeString, alias: OriginatingLenderState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Gender (type: esriFieldTypeString, alias: Gender, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Veteran (type: esriFieldTypeString, alias: Veteran, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_NonProfit (type: esriFieldTypeString, alias: NonProfit, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ZipCode (type: esriFieldTypeInteger, alias: ZipCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_NAICS2dig (type: esriFieldTypeString, alias: NAICS2dig, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_NAICS4dig (type: esriFieldTypeString, alias: NAICS4dig, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Jobs (type: esriFieldTypeSmallInteger, alias: Jobs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NAICS_2digit (type: esriFieldTypeInteger, alias: NAICS_2digit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NAICS_4digit (type: esriFieldTypeInteger, alias: NAICS_4digit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Seq__No_ (type: esriFieldTypeInteger, alias: Seq. No., SQL Type: sqlTypeOther, nullable: true, editable: true)
• F2017_NAICS_US___Code_1 (type: esriFieldTypeInteger, alias: 2017 NAICS US Code_4dig, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F2017_NAICS_US_Title_1 (type: esriFieldTypeString, alias: 2017 NAICS US Title_4dig, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• cluster_value (type: esriFieldTypeSmallInteger, alias: cluster_value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F2017_NAICS_US___Code (type: esriFieldTypeInteger, alias: 2017 NAICS US Code_2dig, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F2017_NAICS_US_Title (type: esriFieldTypeString, alias: 2017 NAICS US Title_2dig, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NAICS_DISP (type: esriFieldTypeString, alias: NAICS_DISP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Jobs_2 (type: esriFieldTypeInteger, alias: Jobs_long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Field1 (type: esriFieldTypeInteger, alias: Field1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LoanNumber (type: esriFieldTypeDouble, alias: LoanNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• month_year (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State_A, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: PPP_Loans_210331
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_ProcessingMethod:
• USER_BorrowerName:
• USER_BorrowerAddress:
• USER_BorrowerCity:
• USER_BorrowerState:
• USER_BorrowerZip:
• USER_LoanStatus:
• USER_FranchiseName:
• USER_ServicingLenderName:
• USER_ServicingLenderAddress:
• USER_ServicingLenderCity:
• USER_ServicingLenderState:
• USER_ServicingLenderZip:
• USER_RuralUrbanIndicator:
• USER_HubzoneIndicator:
• USER_LMIIndicator:
• USER_BusinessAgeDescription:
• USER_ProjectCity:
• USER_ProjectCountyName:
• USER_ProjectState:
• USER_ProjectZip:
• USER_CD:
• USER_JobsReported:
• USER_NAICSCode:
• USER_Race:
• USER_Ethnicity:
• USER_UTILITIES_PROCEED:
• USER_PAYROLL_PROCEED:
• USER_MORTGAGE_INTEREST_PROCEED:
• USER_RENT_PROCEED:
• USER_REFINANCE_EIDL_PROCEED:
• USER_HEALTH_CARE_PROCEED:
• USER_DEBT_INTEREST_PROCEED:
• USER_BusinessType:
• USER_OriginatingLender:
• USER_OriginatingLenderCity:
• USER_OriginatingLenderState:
• USER_Gender:
• USER_Veteran:
• USER_NonProfit:
• USER_NAICS2dig:
• USER_NAICS4dig:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/26/2021 6:13:34 PM

Schema Last Edit Date: 5/26/2021 6:13:34 PM

Data Last Edit Date: 5/26/2021 6:13:34 PM

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