{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "ActiveProperties_ExcelToTable", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PropertyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NHPDPropertyID", "type": "esriFieldTypeInteger", "alias": "NHPDPropertyID", "domain": null }, { "name": "PropertyName", "type": "esriFieldTypeString", "alias": "PropertyName", "length": 255, "domain": null }, { "name": "PropertyAddress", "type": "esriFieldTypeString", "alias": "PropertyAddress", "length": 255, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 255, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 255, "domain": null }, { "name": "ZipCode", "type": "esriFieldTypeString", "alias": "ZipCode", "length": 255, "domain": null }, { "name": "AssistedUnits_updated", "type": "esriFieldTypeInteger", "alias": "AssistedUnits_updated", "domain": null }, { "name": "TotalUnits", "type": "esriFieldTypeInteger", "alias": "TotalUnits", "domain": null }, { "name": "PropertyStatus", "type": "esriFieldTypeString", "alias": "PropertyStatus", "length": 255, "domain": null }, { "name": "EarliestSubsidyStartDate", "type": "esriFieldTypeDate", "alias": "EarliestSubsidyStartDate", "length": 8, "domain": null }, { "name": "EarliestSubsidyEndDate", "type": "esriFieldTypeDate", "alias": "EarliestSubsidyEndDate", "length": 8, "domain": null }, { "name": "LatestSubsidyEndDate", "type": "esriFieldTypeDate", "alias": "LatestSubsidyEndDate", "length": 8, "domain": null }, { "name": "year_expire_cat", "type": "esriFieldTypeString", "alias": "year_expire_cat", "length": 255, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "County", "type": "esriFieldTypeString", "alias": "County", "length": 255, "domain": null }, { "name": "CountyCode", "type": "esriFieldTypeString", "alias": "CountyCode", "length": 255, "domain": null }, { "name": "CongressionalDistrict", "type": "esriFieldTypeString", "alias": "CongressionalDistrict", "length": 255, "domain": null }, { "name": "CensusTract", "type": "esriFieldTypeString", "alias": "CensusTract", "length": 255, "domain": null }, { "name": "TargetTenantTypeUpdated", "type": "esriFieldTypeString", "alias": "TargetTenantTypeUpdated", "length": 255, "domain": null }, { "name": "ManagerName", "type": "esriFieldTypeString", "alias": "ManagerName", "length": 255, "domain": null }, { "name": "ManagerType", "type": "esriFieldTypeString", "alias": "ManagerType", "length": 255, "domain": null }, { "name": "OwnerName", "type": "esriFieldTypeString", "alias": "OwnerName", "length": 255, "domain": null }, { "name": "OwnerType", "type": "esriFieldTypeString", "alias": "OwnerType", "length": 255, "domain": null }, { "name": "AverageMonthsofTenancy", "type": "esriFieldTypeInteger", "alias": "AverageMonthsofTenancy", "domain": null }, { "name": "OccupancyRate", "type": "esriFieldTypeInteger", "alias": "OccupancyRate", "domain": null }, { "name": "PercentofELIHouseholds", "type": "esriFieldTypeInteger", "alias": "PercentofELIHouseholds", "domain": null }, { "name": "EarliestConstructionDate", "type": "esriFieldTypeString", "alias": "EarliestConstructionDate", "length": 255, "domain": null }, { "name": "OneBedroomUnits", "type": "esriFieldTypeInteger", "alias": "OneBedroomUnits", "domain": null }, { "name": "TwoBedroomUnits", "type": "esriFieldTypeInteger", "alias": "TwoBedroomUnits", "domain": null }, { "name": "ThreeBedroomUnits", "type": "esriFieldTypeInteger", "alias": "ThreeBedroomUnits", "domain": null }, { "name": "funding_stream", "type": "esriFieldTypeString", "alias": "funding_stream", "length": 255, "domain": null }, { "name": "home", "type": "esriFieldTypeString", "alias": "home", "length": 255, "domain": null }, { "name": "hudinsured", "type": "esriFieldTypeString", "alias": "hudinsured", "length": 255, "domain": null }, { "name": "lihtc", "type": "esriFieldTypeString", "alias": "lihtc", "length": 255, "domain": null }, { "name": "publichousing", "type": "esriFieldTypeString", "alias": "publichousing", "length": 255, "domain": null }, { "name": "section515", "type": "esriFieldTypeString", "alias": "section515", "length": 255, "domain": null }, { "name": "section514", "type": "esriFieldTypeString", "alias": "section514", "length": 255, "domain": null }, { "name": "section521", "type": "esriFieldTypeString", "alias": "section521", "length": 255, "domain": null }, { "name": "section538", "type": "esriFieldTypeString", "alias": "section538", "length": 255, "domain": null }, { "name": "section202", "type": "esriFieldTypeString", "alias": "section202", "length": 255, "domain": null }, { "name": "section236", "type": "esriFieldTypeString", "alias": "section236", "length": 255, "domain": null }, { "name": "section8", "type": "esriFieldTypeString", "alias": "section8", "length": 255, "domain": null }, { "name": "statesubsidy", "type": "esriFieldTypeString", "alias": "statesubsidy", "length": 255, "domain": null }, { "name": "pbv", "type": "esriFieldTypeString", "alias": "pbv", "length": 255, "domain": null }, { "name": "modrehab", "type": "esriFieldTypeString", "alias": "modrehab", "length": 255, "domain": null }, { "name": "REACScore1", "type": "esriFieldTypeInteger", "alias": "REACScore1", "domain": null }, { "name": "LastREACDate", "type": "esriFieldTypeDate", "alias": "LastREACDate", "length": 8, "domain": null }, { "name": "REACScore2", "type": "esriFieldTypeInteger", "alias": "REACScore2", "domain": null }, { "name": "REACDate2", "type": "esriFieldTypeDate", "alias": "REACDate2", "length": 8, "domain": null }, { "name": "REACScore3", "type": "esriFieldTypeInteger", "alias": "REACScore3", "domain": null }, { "name": "REACDate3", "type": "esriFieldTypeDate", "alias": "REACDate3", "length": 8, "domain": null }, { "name": "hudinsuredunits", "type": "esriFieldTypeInteger", "alias": "hudinsuredunits", "domain": null }, { "name": "section236units", "type": "esriFieldTypeInteger", "alias": "section236units", "domain": null }, { "name": "stateunits", "type": "esriFieldTypeInteger", "alias": "stateunits", "domain": null }, { "name": "section202units", "type": "esriFieldTypeInteger", "alias": "section202units", "domain": null }, { "name": "section515units", "type": "esriFieldTypeInteger", "alias": "section515units", "domain": null }, { "name": "section514units", "type": "esriFieldTypeInteger", "alias": "section514units", "domain": null }, { "name": "section521units", "type": "esriFieldTypeInteger", "alias": "section521units", "domain": null }, { "name": "section538units", "type": "esriFieldTypeInteger", "alias": "section538units", "domain": null }, { "name": "section8units", "type": "esriFieldTypeInteger", "alias": "section8units", "domain": null }, { "name": "homeunits", "type": "esriFieldTypeInteger", "alias": "homeunits", "domain": null }, { "name": "lihtcunits", "type": "esriFieldTypeInteger", "alias": "lihtcunits", "domain": null }, { "name": "publichousingunits", "type": "esriFieldTypeInteger", "alias": "publichousingunits", "domain": null }, { "name": "pbvunits", "type": "esriFieldTypeInteger", "alias": "pbvunits", "domain": null }, { "name": "modrehabunits", "type": "esriFieldTypeInteger", "alias": "modrehabunits", "domain": null }, { "name": "TotalActiveSubsidies", "type": "esriFieldTypeInteger", "alias": "TotalActiveSubsidies", "domain": null }, { "name": "CBSAСode", "type": "esriFieldTypeString", "alias": "CBSAСode", "length": 255, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }