{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "Census_Blocks_Enriched_Table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Join_Count", "type": "esriFieldTypeInteger", "alias": "Join_Count", "domain": null }, { "name": "TARGET_FID", "type": "esriFieldTypeInteger", "alias": "TARGET_FID", "domain": null }, { "name": "ObjID", "type": "esriFieldTypeString", "alias": "MAF/TIGER Object Identifier", "length": 22, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State FIPS Code", "length": 1073741822, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County FIPS Code", "length": 3, "domain": null }, { "name": "TRACT", "type": "esriFieldTypeString", "alias": "Tract", "length": 255, "domain": null }, { "name": "BLKGRP", "type": "esriFieldTypeString", "alias": "Block Group", "length": 4, "domain": null }, { "name": "BLOCK", "type": "esriFieldTypeString", "alias": "Block", "length": 4, "domain": null }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "Suffix", "length": 1, "domain": null }, { "name": "GEOID", "type": "esriFieldTypeString", "alias": "Geographic Identifier", "length": 16, "domain": null }, { "name": "LWBLKTYP", "type": "esriFieldTypeString", "alias": "Land/Water Block Type", "length": 1, "domain": null }, { "name": "UR", "type": "esriFieldTypeString", "alias": "Urban/Rural Flag", "length": 1, "domain": null }, { "name": "AREAWATER", "type": "esriFieldTypeDouble", "alias": "Water Area (Square Meters)", "domain": null }, { "name": "AREALAND", "type": "esriFieldTypeDouble", "alias": "Land Area (Square Meters)", "domain": null }, { "name": "MTFCC", "type": "esriFieldTypeString", "alias": "MAF/TIGER Feature Class Code", "length": 5, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 106, "domain": null }, { "name": "BASENAME", "type": "esriFieldTypeString", "alias": "Base Name", "length": 100, "domain": null }, { "name": "LSADC", "type": "esriFieldTypeString", "alias": "Legal/Statistical Area Description Code", "length": 2, "domain": null }, { "name": "FUNCSTAT", "type": "esriFieldTypeString", "alias": "Functional Status", "length": 1, "domain": null }, { "name": "CENTLON", "type": "esriFieldTypeString", "alias": "Centroid Longitude", "length": 12, "domain": null }, { "name": "CENTLAT", "type": "esriFieldTypeString", "alias": "Centroid Latitude", "length": 11, "domain": null }, { "name": "INTPTLON", "type": "esriFieldTypeString", "alias": "Internal Point Longitude", "length": 12, "domain": null }, { "name": "INTPTLAT", "type": "esriFieldTypeString", "alias": "Internal Point Latitude", "length": 11, "domain": null }, { "name": "HU100", "type": "esriFieldTypeDouble", "alias": "Decennial Housing Count", "domain": null }, { "name": "POP100", "type": "esriFieldTypeDouble", "alias": "Decennial Population Count", "domain": null }, { "name": "DTS_YN", "type": "esriFieldTypeString", "alias": "DTS Y/N?", "length": 1, "domain": null }, { "name": "DTS_2020", "type": "esriFieldTypeInteger", "alias": "DTS_2020", "domain": null }, { "name": "Census_Urban_name", "type": "esriFieldTypeString", "alias": "Census_Urban_name", "length": 100, "domain": null }, { "name": "State_name", "type": "esriFieldTypeString", "alias": "State_name", "length": 25, "domain": null }, { "name": "County_name", "type": "esriFieldTypeString", "alias": "County_name", "length": 100, "domain": null }, { "name": "Affiliate_name", "type": "esriFieldTypeString", "alias": "Affiliate_name", "length": 250, "domain": null }, { "name": "Affiliate_ID", "type": "esriFieldTypeString", "alias": "Affiliate_ID", "length": 50, "domain": null }, { "name": "Disaffiliated_name", "type": "esriFieldTypeString", "alias": "Disaffiliated_name", "length": 255, "domain": null }, { "name": "Disaffiliated_ID", "type": "esriFieldTypeString", "alias": "Disaffiliated_ID", "length": 80, "domain": null }, { "name": "HPR_Repairs", "type": "esriFieldTypeString", "alias": "HPR_Repairs", "length": 100, "domain": null }, { "name": "HPR_Other", "type": "esriFieldTypeString", "alias": "HPR_Other", "length": 100, "domain": null }, { "name": "TRACT_hh_50_80AMI", "type": "esriFieldTypeDouble", "alias": "TRACT%hh>50-80AMI", "domain": null }, { "name": "TRACT_hh_50AMI", "type": "esriFieldTypeDouble", "alias": "TRACT%hh<50AMI", "domain": null }, { "name": "BG_hh_60AMI", "type": "esriFieldTypeDouble", "alias": "BG%hh<60AMI", "domain": null }, { "name": "BG_hh_60_80AMI", "type": "esriFieldTypeDouble", "alias": "BG%hh>60-80AMI", "domain": null }, { "name": "TRACT_n_hh_50_80AMI", "type": "esriFieldTypeInteger", "alias": "TRACT#hh>50-80AMI", "domain": null }, { "name": "TRACT_n_hh_50AMI", "type": "esriFieldTypeInteger", "alias": "TRACT#hh<50AMI", "domain": null }, { "name": "BG_n_hh_60AMI", "type": "esriFieldTypeInteger", "alias": "BG#hh<60AMI", "domain": null }, { "name": "BG_n_hh_60_80AMI", "type": "esriFieldTypeInteger", "alias": "BG#hh>60-80AMI", "domain": null }, { "name": "HPR_Repair_int", "type": "esriFieldTypeSmallInteger", "alias": "HPR_Repair_int", "domain": null }, { "name": "HPR_Other_int", "type": "esriFieldTypeSmallInteger", "alias": "HPR_Other_int", "domain": null } ], "indexes": [ { "name": "R17_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "HU100", "fields": "HU100", "isAscending": true, "isUnique": false, "description": "" }, { "name": "POP100", "fields": "POP100", "isAscending": true, "isUnique": false, "description": "" }, { "name": "DTS_2020", "fields": "DTS_2020", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Census_Urban_nam", "fields": "Census_Urban_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "State_name", "fields": "State_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "County_name", "fields": "County_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Affiliate_name", "fields": "Affiliate_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Affiliate_ID", "fields": "Affiliate_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Disaffiliated_na", "fields": "Disaffiliated_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "Disaffiliated_ID", "fields": "Disaffiliated_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "HPR_Repair_int", "fields": "HPR_Repair_int", "isAscending": true, "isUnique": false, "description": "" }, { "name": "HPR_Other_int", "fields": "HPR_Other_int", "isAscending": true, "isUnique": false, "description": "" }, { "name": "TRACT_n_hh_50_80", "fields": "TRACT_n_hh_50_80AMI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "TRACT_n_hh_50AMI", "fields": "TRACT_n_hh_50AMI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BG_n_hh_60AMI", "fields": "BG_n_hh_60AMI", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BG_n_hh_60_80AMI", "fields": "BG_n_hh_60_80AMI", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,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": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "2ae8c3441cb64670861821fec6e9d591" }