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:
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