Name: ActiveProperties_ExcelToTable

Display Field: PropertyName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• NHPDPropertyID ( type: esriFieldTypeInteger, alias: NHPDPropertyID )
• PropertyName ( type: esriFieldTypeString, alias: PropertyName, length: 255 )
• PropertyAddress ( type: esriFieldTypeString, alias: PropertyAddress, length: 255 )
• City ( type: esriFieldTypeString, alias: City, length: 255 )
• State ( type: esriFieldTypeString, alias: State, length: 255 )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, length: 255 )
• AssistedUnits_updated ( type: esriFieldTypeInteger, alias: AssistedUnits_updated )
• TotalUnits ( type: esriFieldTypeInteger, alias: TotalUnits )
• PropertyStatus ( type: esriFieldTypeString, alias: PropertyStatus, length: 255 )
• EarliestSubsidyStartDate ( type: esriFieldTypeDate, alias: EarliestSubsidyStartDate, length: 8 )
• EarliestSubsidyEndDate ( type: esriFieldTypeDate, alias: EarliestSubsidyEndDate, length: 8 )
• LatestSubsidyEndDate ( type: esriFieldTypeDate, alias: LatestSubsidyEndDate, length: 8 )
• year_expire_cat ( type: esriFieldTypeString, alias: year_expire_cat, length: 255 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• County ( type: esriFieldTypeString, alias: County, length: 255 )
• CountyCode ( type: esriFieldTypeString, alias: CountyCode, length: 255 )
• CongressionalDistrict ( type: esriFieldTypeString, alias: CongressionalDistrict, length: 255 )
• CensusTract ( type: esriFieldTypeString, alias: CensusTract, length: 255 )
• TargetTenantTypeUpdated ( type: esriFieldTypeString, alias: TargetTenantTypeUpdated, length: 255 )
• ManagerName ( type: esriFieldTypeString, alias: ManagerName, length: 255 )
• ManagerType ( type: esriFieldTypeString, alias: ManagerType, length: 255 )
• OwnerName ( type: esriFieldTypeString, alias: OwnerName, length: 255 )
• OwnerType ( type: esriFieldTypeString, alias: OwnerType, length: 255 )
• AverageMonthsofTenancy ( type: esriFieldTypeInteger, alias: AverageMonthsofTenancy )
• OccupancyRate ( type: esriFieldTypeInteger, alias: OccupancyRate )
• PercentofELIHouseholds ( type: esriFieldTypeInteger, alias: PercentofELIHouseholds )
• EarliestConstructionDate ( type: esriFieldTypeString, alias: EarliestConstructionDate, length: 255 )
• OneBedroomUnits ( type: esriFieldTypeInteger, alias: OneBedroomUnits )
• TwoBedroomUnits ( type: esriFieldTypeInteger, alias: TwoBedroomUnits )
• ThreeBedroomUnits ( type: esriFieldTypeInteger, alias: ThreeBedroomUnits )
• funding_stream ( type: esriFieldTypeString, alias: funding_stream, length: 255 )
• home ( type: esriFieldTypeString, alias: home, length: 255 )
• hudinsured ( type: esriFieldTypeString, alias: hudinsured, length: 255 )
• lihtc ( type: esriFieldTypeString, alias: lihtc, length: 255 )
• publichousing ( type: esriFieldTypeString, alias: publichousing, length: 255 )
• section515 ( type: esriFieldTypeString, alias: section515, length: 255 )
• section514 ( type: esriFieldTypeString, alias: section514, length: 255 )
• section521 ( type: esriFieldTypeString, alias: section521, length: 255 )
• section538 ( type: esriFieldTypeString, alias: section538, length: 255 )
• section202 ( type: esriFieldTypeString, alias: section202, length: 255 )
• section236 ( type: esriFieldTypeString, alias: section236, length: 255 )
• section8 ( type: esriFieldTypeString, alias: section8, length: 255 )
• statesubsidy ( type: esriFieldTypeString, alias: statesubsidy, length: 255 )
• pbv ( type: esriFieldTypeString, alias: pbv, length: 255 )
• modrehab ( type: esriFieldTypeString, alias: modrehab, length: 255 )
• REACScore1 ( type: esriFieldTypeInteger, alias: REACScore1 )
• LastREACDate ( type: esriFieldTypeDate, alias: LastREACDate, length: 8 )
• REACScore2 ( type: esriFieldTypeInteger, alias: REACScore2 )
• REACDate2 ( type: esriFieldTypeDate, alias: REACDate2, length: 8 )
• REACScore3 ( type: esriFieldTypeInteger, alias: REACScore3 )
• REACDate3 ( type: esriFieldTypeDate, alias: REACDate3, length: 8 )
• hudinsuredunits ( type: esriFieldTypeInteger, alias: hudinsuredunits )
• section236units ( type: esriFieldTypeInteger, alias: section236units )
• stateunits ( type: esriFieldTypeInteger, alias: stateunits )
• section202units ( type: esriFieldTypeInteger, alias: section202units )
• section515units ( type: esriFieldTypeInteger, alias: section515units )
• section514units ( type: esriFieldTypeInteger, alias: section514units )
• section521units ( type: esriFieldTypeInteger, alias: section521units )
• section538units ( type: esriFieldTypeInteger, alias: section538units )
• section8units ( type: esriFieldTypeInteger, alias: section8units )
• homeunits ( type: esriFieldTypeInteger, alias: homeunits )
• lihtcunits ( type: esriFieldTypeInteger, alias: lihtcunits )
• publichousingunits ( type: esriFieldTypeInteger, alias: publichousingunits )
• pbvunits ( type: esriFieldTypeInteger, alias: pbvunits )
• modrehabunits ( type: esriFieldTypeInteger, alias: modrehabunits )
• TotalActiveSubsidies ( type: esriFieldTypeInteger, alias: TotalActiveSubsidies )
• CBSAСode ( type: esriFieldTypeString, alias: CBSAСode, length: 255 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata