Name: ReverseMortgag_G_SpatialJoin3

Display Field: 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: 6510276.81659605
YMin: 1886112.35075507
XMax: 6532023.1992843
YMax: 1898343.59893031
Spatial Reference: 102645 (2229)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[145,116,66,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)
• Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Join_Count_1 (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID_1 (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Join_Count_12 (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID_12 (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 14, 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: 120, nullable: true, editable: true)
• House (type: esriFieldTypeString, alias: House, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PreDir (type: esriFieldTypeString, alias: PreDir, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• PreType (type: esriFieldTypeString, alias: PreType, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• StreetName (type: esriFieldTypeString, alias: StreetName, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• SufType (type: esriFieldTypeString, alias: SufType, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SufDir (type: esriFieldTypeString, alias: SufDir, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Ref_ID (type: esriFieldTypeInteger, alias: Ref_ID, 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)
• User_fld (type: esriFieldTypeString, alias: User_fld, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FromAddr (type: esriFieldTypeString, alias: FromAddr, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ToAddr (type: esriFieldTypeString, alias: ToAddr, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• IN_Street (type: esriFieldTypeString, alias: Street or Intersection, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City or Placename, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• IN_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_ZIP (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• USER_APN (type: esriFieldTypeString, alias: APN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_FIPSCode (type: esriFieldTypeInteger, alias: FIPSCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_PropertyAddress (type: esriFieldTypeString, alias: PropertyAddress, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ZIPCode (type: esriFieldTypeInteger, alias: ZIPCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_OwnerName (type: esriFieldTypeString, alias: OwnerName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OwnerType (type: esriFieldTypeString, alias: OwnerType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_LastTransactionRecordingDa (type: esriFieldTypeDate, alias: LastTransactionRecordingDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_LastTransactionSaleDate (type: esriFieldTypeDate, alias: LastTransactionSaleDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_LastTransactionSalePrice (type: esriFieldTypeInteger, alias: LastTransactionSalePrice, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_SalePrice (type: esriFieldTypeInteger, alias: SalePrice, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_SalePriceCode (type: esriFieldTypeString, alias: SalePriceCode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_SaleRecordingDate (type: esriFieldTypeString, alias: SaleRecordingDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_SaleContractDate (type: esriFieldTypeDate, alias: SaleContractDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_Bedrooms (type: esriFieldTypeInteger, alias: Bedrooms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Bathrooms (type: esriFieldTypeInteger, alias: Bathrooms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_NumberofUnits (type: esriFieldTypeInteger, alias: NumberofUnits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DetailedPropertyType (type: esriFieldTypeString, alias: DetailedPropertyType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_YearBuilt (type: esriFieldTypeInteger, alias: YearBuilt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_LegalDescription (type: esriFieldTypeString, alias: LegalDescription, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_CurrentTaxYear (type: esriFieldTypeInteger, alias: CurrentTaxYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_CurrentYearTaxAmount (type: esriFieldTypeDouble, alias: CurrentYearTaxAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_AssessedTotalValue (type: esriFieldTypeInteger, alias: AssessedTotalValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_CombinedOriginationLTV (type: esriFieldTypeString, alias: CombinedOriginationLTV, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_CurrentLTV (type: esriFieldTypeDouble, alias: CurrentLTV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_EquityPercentage (type: esriFieldTypeDouble, alias: EquityPercentage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_EquityValue (type: esriFieldTypeInteger, alias: EquityValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_NumberofLoans (type: esriFieldTypeInteger, alias: NumberofLoans, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_ReverseMortgage (type: esriFieldTypeString, alias: ReverseMortgage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_1stMortgageInterestRate (type: esriFieldTypeDouble, alias: 1stMortgageInterestRate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_1stMortgageFinancing (type: esriFieldTypeString, alias: 1stMortgageFinancing, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_1stMortgageReverseIndicato (type: esriFieldTypeString, alias: 1stMortgageReverseIndicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_1stMortgageLoanAmount (type: esriFieldTypeInteger, alias: 1stMortgageLoanAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_SaleType (type: esriFieldTypeString, alias: SaleType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_1stMortgageLoanType (type: esriFieldTypeString, alias: 1stMortgageLoanType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_1stMortgageOnly (type: esriFieldTypeString, alias: 1stMortgageOnly, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_1stMortgageMaturityDate (type: esriFieldTypeString, alias: 1stMortgageMaturityDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_1stMortgageRecordingDate (type: esriFieldTypeDate, alias: 1stMortgageRecordingDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_2ndMortgageFinancing (type: esriFieldTypeString, alias: 2ndMortgageFinancing, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_2ndMortgageInterestRate (type: esriFieldTypeDouble, alias: 2ndMortgageInterestRate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_2ndMortgageLoanAmount (type: esriFieldTypeInteger, alias: 2ndMortgageLoanAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_2ndMortgageLoanType (type: esriFieldTypeString, alias: 2ndMortgageLoanType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_2ndMortgageTransactionType (type: esriFieldTypeString, alias: 2ndMortgageTransactionType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_OwnerOccupiedResidential (type: esriFieldTypeString, alias: OwnerOccupiedResidential, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ARMResetDates (type: esriFieldTypeDate, alias: ARMResetDates, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AIN_1 (type: esriFieldTypeString, alias: AIN, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• APN_1 (type: esriFieldTypeString, alias: APN, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• SitusHouseNo (type: esriFieldTypeString, alias: SitusHouseNo, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SitusFraction (type: esriFieldTypeString, alias: SitusFraction, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• SitusDirection (type: esriFieldTypeString, alias: SitusDirection, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SitusUnit (type: esriFieldTypeString, alias: SitusUnit, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SitusStreet (type: esriFieldTypeString, alias: SitusStreet, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• SitusAddress (type: esriFieldTypeString, alias: SitusAddress, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
• SitusCity (type: esriFieldTypeString, alias: SitusCity, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• SitusZIP (type: esriFieldTypeString, alias: SitusZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SitusFullAddress (type: esriFieldTypeString, alias: SitusFullAddress, SQL Type: sqlTypeOther, length: 84, nullable: true, editable: true)
• TaxRateArea (type: esriFieldTypeString, alias: TaxRateArea, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• TaxRateCity (type: esriFieldTypeString, alias: TaxRateCity, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• AgencyClassNo (type: esriFieldTypeInteger, alias: AgencyClassNo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AgencyName (type: esriFieldTypeString, alias: AgencyName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AgencyType (type: esriFieldTypeString, alias: AgencyType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UseCode (type: esriFieldTypeString, alias: UseCode, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• UseCode_2 (type: esriFieldTypeString, alias: UseCode_2, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• UseType (type: esriFieldTypeString, alias: UseType, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• UseDescription (type: esriFieldTypeString, alias: UseDescription, SQL Type: sqlTypeOther, length: 61, nullable: true, editable: true)
• DesignType1 (type: esriFieldTypeString, alias: DesignType1, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• YearBuilt1 (type: esriFieldTypeString, alias: YearBuilt1, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• EffectiveYear1 (type: esriFieldTypeString, alias: EffectiveYear1, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Units1 (type: esriFieldTypeSmallInteger, alias: Units1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bedrooms1 (type: esriFieldTypeSmallInteger, alias: Bedrooms1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bathrooms1 (type: esriFieldTypeSmallInteger, alias: Bathrooms1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTmain1 (type: esriFieldTypeInteger, alias: SQFTmain1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DesignType2 (type: esriFieldTypeString, alias: DesignType2, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• YearBuilt2 (type: esriFieldTypeString, alias: YearBuilt2, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• EffectiveYear2 (type: esriFieldTypeString, alias: EffectiveYear2, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Units2 (type: esriFieldTypeSmallInteger, alias: Units2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bedrooms2 (type: esriFieldTypeSmallInteger, alias: Bedrooms2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bathrooms2 (type: esriFieldTypeSmallInteger, alias: Bathrooms2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTmain2 (type: esriFieldTypeInteger, alias: SQFTmain2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DesignType3 (type: esriFieldTypeString, alias: DesignType3, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• YearBuilt3 (type: esriFieldTypeString, alias: YearBuilt3, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• EffectiveYear3 (type: esriFieldTypeString, alias: EffectiveYear3, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Units3 (type: esriFieldTypeSmallInteger, alias: Units3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bedrooms3 (type: esriFieldTypeSmallInteger, alias: Bedrooms3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bathrooms3 (type: esriFieldTypeSmallInteger, alias: Bathrooms3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTmain3 (type: esriFieldTypeInteger, alias: SQFTmain3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DesignType4 (type: esriFieldTypeString, alias: DesignType4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• YearBuilt4 (type: esriFieldTypeString, alias: YearBuilt4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• EffectiveYear4 (type: esriFieldTypeString, alias: EffectiveYear4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Units4 (type: esriFieldTypeSmallInteger, alias: Units4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bedrooms4 (type: esriFieldTypeSmallInteger, alias: Bedrooms4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bathrooms4 (type: esriFieldTypeSmallInteger, alias: Bathrooms4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTmain4 (type: esriFieldTypeInteger, alias: SQFTmain4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DesignType5 (type: esriFieldTypeString, alias: DesignType5, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• YearBuilt5 (type: esriFieldTypeString, alias: YearBuilt5, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• EffectiveYear5 (type: esriFieldTypeString, alias: EffectiveYear5, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Units5 (type: esriFieldTypeSmallInteger, alias: Units5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bedrooms5 (type: esriFieldTypeSmallInteger, alias: Bedrooms5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bathrooms5 (type: esriFieldTypeSmallInteger, alias: Bathrooms5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQFTmain5 (type: esriFieldTypeInteger, alias: SQFTmain5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RecDate (type: esriFieldTypeString, alias: RecDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RecDocNo (type: esriFieldTypeInteger, alias: RecDocNo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_Year (type: esriFieldTypeString, alias: Roll_Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Roll_LandValue (type: esriFieldTypeInteger, alias: Roll_LandValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_ImpValue (type: esriFieldTypeInteger, alias: Roll_ImpValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_PersPropValue (type: esriFieldTypeInteger, alias: Roll_PersPropValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_FixtureValue (type: esriFieldTypeInteger, alias: Roll_FixtureValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_HomeOwnersExemp (type: esriFieldTypeInteger, alias: Roll_HomeOwnersExemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_RealEstateExemp (type: esriFieldTypeInteger, alias: Roll_RealEstateExemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_PersPropExemp (type: esriFieldTypeInteger, alias: Roll_PersPropExemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_FixtureExemp (type: esriFieldTypeInteger, alias: Roll_FixtureExemp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roll_LandBaseYear (type: esriFieldTypeString, alias: Roll_LandBaseYear, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Roll_ImpBaseYear (type: esriFieldTypeString, alias: Roll_ImpBaseYear, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LastSaleDate (type: esriFieldTypeString, alias: LastSaleDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastSaleAmount (type: esriFieldTypeInteger, alias: LastSaleAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QualityClass1 (type: esriFieldTypeString, alias: QualityClass1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• QualityClass2 (type: esriFieldTypeString, alias: QualityClass2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• QualityClass3 (type: esriFieldTypeString, alias: QualityClass3, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• QualityClass4 (type: esriFieldTypeString, alias: QualityClass4, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• QualityClass5 (type: esriFieldTypeString, alias: QualityClass5, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• LegalDescLine1 (type: esriFieldTypeString, alias: LegalDescLine1, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LegalDescLine2 (type: esriFieldTypeString, alias: LegalDescLine2, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LegalDescLine3 (type: esriFieldTypeString, alias: LegalDescLine3, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LegalDescLine4 (type: esriFieldTypeString, alias: LegalDescLine4, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LegalDescLine5 (type: esriFieldTypeString, alias: LegalDescLine5, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LegalDescLineLast (type: esriFieldTypeString, alias: LegalDescLineLast, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LegalDescription (type: esriFieldTypeString, alias: LegalDescription, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SpatialChangeDate (type: esriFieldTypeDate, alias: SpatialChangeDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ParcelCreateDate (type: esriFieldTypeInteger, alias: ParcelCreateDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParcelTypeCode (type: esriFieldTypeInteger, alias: ParcelTypeCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Assr_Map (type: esriFieldTypeString, alias: Assr_Map, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Assr_Index_Map (type: esriFieldTypeString, alias: Assr_Index_Map, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CENTER_LAT (type: esriFieldTypeDouble, alias: CENTER_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CENTER_LON (type: esriFieldTypeDouble, alias: CENTER_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CENTER_X (type: esriFieldTypeDouble, alias: CENTER_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CENTER_Y (type: esriFieldTypeDouble, alias: CENTER_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAT_LON (type: esriFieldTypeString, alias: LAT_LON, SQL Type: sqlTypeOther, length: 62, nullable: true, editable: true)
• Fire_Name (type: esriFieldTypeString, alias: Fire_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DAMAGE_1 (type: esriFieldTypeString, alias: * Damage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STRUCTURECATEGORY (type: esriFieldTypeString, alias: Structure Category, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Total_Units (type: esriFieldTypeSmallInteger, alias: Total_Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tot_SqFt (type: esriFieldTypeInteger, alias: Tot_SqFt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DINS_Count (type: esriFieldTypeSmallInteger, alias: DINS_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LCITY (type: esriFieldTypeString, alias: LCITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMMUNITY (type: esriFieldTypeString, alias: COMMUNITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BSD_Tag (type: esriFieldTypeString, alias: BSD_Tag, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• statefp (type: esriFieldTypeString, alias: Census State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• countyfp (type: esriFieldTypeString, alias: Census County, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• tractce (type: esriFieldTypeString, alias: Census Tract, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• geoid (type: esriFieldTypeString, alias: Census Geoid, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: Census Name, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• namelsad (type: esriFieldTypeString, alias: Census Namelsad, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• mtfcc (type: esriFieldTypeString, alias: Census Mtfcc, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• funcstat (type: esriFieldTypeString, alias: Census Funcstat, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• aland (type: esriFieldTypeDouble, alias: Census Tract Area Land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• awater (type: esriFieldTypeDouble, alias: Census Tract Area Water, SQL Type: sqlTypeOther, nullable: true, editable: true)
• intptlat (type: esriFieldTypeString, alias: Census Tract Center Lat, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• intptlon (type: esriFieldTypeString, alias: Census Tract Center Long, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• geo_id_full (type: esriFieldTypeString, alias: Geo ID Full , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• geo_id (type: esriFieldTypeString, alias: Geo ID, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• fips (type: esriFieldTypeString, alias: Fips, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• csa (type: esriFieldTypeString, alias: Countywide Statistical Area, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• sup_district (type: esriFieldTypeString, alias: Sup District (2021), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• tot_pop (type: esriFieldTypeInteger, alias: Total Population, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hud_qct (type: esriFieldTypeString, alias: HUD Qualified Census Tract, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• risk_index (type: esriFieldTypeDouble, alias: Risk Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• severity_index (type: esriFieldTypeDouble, alias: Severity Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• recovery_index (type: esriFieldTypeDouble, alias: Recovery Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• overall_index (type: esriFieldTypeDouble, alias: Overall Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• index_category (type: esriFieldTypeString, alias: Index Category, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• index_quintile (type: esriFieldTypeInteger, alias: Need Tier, SQL Type: sqlTypeOther, nullable: true, editable: true)
• overcrowding_rate (type: esriFieldTypeDouble, alias: Overcrowding Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• overcrowding_pctl (type: esriFieldTypeDouble, alias: Overcrowding Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• poverty_200_rate (type: esriFieldTypeDouble, alias: Under 200 Pct FPL Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• poverty_200_pctl (type: esriFieldTypeDouble, alias: Under 200 Pct FPL Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• poverty_senior_rate (type: esriFieldTypeDouble, alias: Seniors 75 and over in Poverty Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• poverty_senior_pctl (type: esriFieldTypeDouble, alias: Seniors 75 and over in Poverty Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unemployment_rate (type: esriFieldTypeDouble, alias: Unemployment Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unemployment_pctl (type: esriFieldTypeDouble, alias: Unemployment Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• essential_rate (type: esriFieldTypeDouble, alias: Essential Worker Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• essential_pctl (type: esriFieldTypeDouble, alias: Essential Worker Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• uninsured_rate (type: esriFieldTypeDouble, alias: Uninsured Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• uninsured_pctl (type: esriFieldTypeDouble, alias: Uninsured Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• single_parents_rate (type: esriFieldTypeDouble, alias: Single Parents Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• single_parents_pctl (type: esriFieldTypeDouble, alias: Single Parents Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• noncitizen_rate (type: esriFieldTypeDouble, alias: Noncitizen Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• noncitizen_pctl (type: esriFieldTypeDouble, alias: Noncitizen Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• guninj_rate (type: esriFieldTypeDouble, alias: Gun Injuries Rate per 10,000, SQL Type: sqlTypeOther, nullable: true, editable: true)
• guninj_pctl (type: esriFieldTypeDouble, alias: Gun Injuries Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• asthma_rate (type: esriFieldTypeDouble, alias: Asthma Hospitalizations per 10,000 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• asthma_pctl (type: esriFieldTypeDouble, alias: Asthma Hospitalizations per 10,000 Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• heart_rate (type: esriFieldTypeDouble, alias: Heart Disease Hospitalizations per 10,000, SQL Type: sqlTypeOther, nullable: true, editable: true)
• heart_pctl (type: esriFieldTypeDouble, alias: Heart Disease Hospitalizations Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diabetes_rate (type: esriFieldTypeDouble, alias: Diabetes Hospitalizations per 10,000 Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• diabetes_pctl (type: esriFieldTypeDouble, alias: Diabetes Hospitalizations per 10,000 Percentile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeString, alias: DISTRICT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LABEL (type: esriFieldTypeString, alias: LABEL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: ReverseMortgag_G_SpatialJoin3
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• IN_Street:
• IN_City:
• IN_State:
• IN_ZIP:
• USER_APN:
• USER_FIPSCode: 0
• USER_PropertyAddress:
• USER_City:
• USER_State:
• USER_ZIPCode: 0
• USER_OwnerName:
• USER_OwnerType:
• USER_LastTransactionSalePrice: 0
• USER_SalePrice: 0
• USER_SalePriceCode:
• USER_SaleRecordingDate:
• USER_Bedrooms: 0
• USER_Bathrooms: 0
• USER_NumberofUnits: 0
• USER_DetailedPropertyType:
• USER_YearBuilt: 0
• USER_LegalDescription:
• USER_CurrentTaxYear: 0
• USER_CurrentYearTaxAmount: 0
• USER_AssessedTotalValue: 0
• USER_CombinedOriginationLTV:
• USER_CurrentLTV: 0
• USER_EquityPercentage: 0
• USER_EquityValue: 0
• USER_NumberofLoans: 0
• USER_ReverseMortgage:
• USER_1stMortgageInterestRate: 0
• USER_1stMortgageFinancing:
• USER_1stMortgageReverseIndicato:
• USER_1stMortgageLoanAmount: 0
• USER_SaleType:
• USER_1stMortgageLoanType:
• USER_1stMortgageOnly:
• USER_1stMortgageMaturityDate:
• USER_2ndMortgageFinancing:
• USER_2ndMortgageInterestRate: 0
• USER_2ndMortgageLoanAmount: 0
• USER_2ndMortgageLoanType:
• USER_2ndMortgageTransactionType:
• USER_OwnerOccupiedResidential:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/8/2025 5:19:34 PM

Schema Last Edit Date: 4/8/2025 5:19:34 PM

Data Last Edit Date: 4/8/2025 5:19:34 PM

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