{ "currentVersion": 10.81, "id": 19, "name": "Census_2006_CT_Family and Housing", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ProfileOfCens", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ProfileOfCens", "type": "esriFieldTypeString", "alias": "ProfileOfCens", "length": 50, "domain": null }, { "name": "TotalPop15YrsOvrByLglMaritalSta", "type": "esriFieldTypeInteger", "alias": "TotalPop15YrsOvrByLglMaritalSta", "domain": null }, { "name": "NeverLegallyMarried_Single", "type": "esriFieldTypeInteger", "alias": "NeverLegallyMarried_Single", "domain": null }, { "name": "LegallyMarriedNotSeparated", "type": "esriFieldTypeInteger", "alias": "LegallyMarriedNotSeparated", "domain": null }, { "name": "SeparatedButStilLegallyMarried", "type": "esriFieldTypeInteger", "alias": "SeparatedButStilLegallyMarried", "domain": null }, { "name": "Divorced", "type": "esriFieldTypeInteger", "alias": "Divorced", "domain": null }, { "name": "Widowed", "type": "esriFieldTypeInteger", "alias": "Widowed", "domain": null }, { "name": "TotalPop15YrsOverCommonLawStat", "type": "esriFieldTypeInteger", "alias": "TotalPop15YrsOverCommonLawStat", "domain": null }, { "name": "NotInACommonLawRelationship", "type": "esriFieldTypeInteger", "alias": "NotInACommonLawRelationship", "domain": null }, { "name": "InACommonlawRelationship", "type": "esriFieldTypeInteger", "alias": "InACommonlawRelationship", "domain": null }, { "name": "TotalNumCensusFamPrivateHH", "type": "esriFieldTypeInteger", "alias": "TotalNumCensusFamPrivateHH", "domain": null }, { "name": "SizeOfCensusFamily2Persons", "type": "esriFieldTypeInteger", "alias": "SizeOfCensusFamily2Persons", "domain": null }, { "name": "SizeOfCensusFamily3Persons", "type": "esriFieldTypeInteger", "alias": "SizeOfCensusFamily3Persons", "domain": null }, { "name": "SizeOfCensusFamily4Persons", "type": "esriFieldTypeInteger", "alias": "SizeOfCensusFamily4Persons", "domain": null }, { "name": "SizeCensusFam5MorePersons", "type": "esriFieldTypeInteger", "alias": "SizeCensusFam5MorePersons", "domain": null }, { "name": "TotalNoCensusFamPrivatetHshlds", "type": "esriFieldTypeInteger", "alias": "TotalNoCensusFamPrivatetHshlds", "domain": null }, { "name": "TtlCplFamByFamStrctAndNumChldn", "type": "esriFieldTypeInteger", "alias": "TtlCplFamByFamStrctAndNumChldn", "domain": null }, { "name": "MarriedCouples", "type": "esriFieldTypeInteger", "alias": "MarriedCouples", "domain": null }, { "name": "MarriedWithoutChildrenAtHome", "type": "esriFieldTypeInteger", "alias": "MarriedWithoutChildrenAtHome", "domain": null }, { "name": "MarriedWithChildrenAtHome", "type": "esriFieldTypeInteger", "alias": "MarriedWithChildrenAtHome", "domain": null }, { "name": "Married1Child", "type": "esriFieldTypeInteger", "alias": "Married1Child", "domain": null }, { "name": "Married2Children", "type": "esriFieldTypeInteger", "alias": "Married2Children", "domain": null }, { "name": "Married3OrMoreChildren", "type": "esriFieldTypeInteger", "alias": "Married3OrMoreChildren", "domain": null }, { "name": "CommonlawCouples", "type": "esriFieldTypeInteger", "alias": "CommonlawCouples", "domain": null }, { "name": "CommonlawWithoutChildrenHome", "type": "esriFieldTypeInteger", "alias": "CommonlawWithoutChildrenHome", "domain": null }, { "name": "CommonlawWithChildrenHome", "type": "esriFieldTypeInteger", "alias": "CommonlawWithChildrenHome", "domain": null }, { "name": "Commonlaw1Child", "type": "esriFieldTypeInteger", "alias": "Commonlaw1Child", "domain": null }, { "name": "Commonlaw2Children", "type": "esriFieldTypeInteger", "alias": "Commonlaw2Children", "domain": null }, { "name": "Commonlaw3OrMoreChildren", "type": "esriFieldTypeInteger", "alias": "Commonlaw3OrMoreChildren", "domain": null }, { "name": "Ttl1ParFamBySexParAndNumChldrn", "type": "esriFieldTypeInteger", "alias": "Ttl1ParFamBySexParAndNumChldrn", "domain": null }, { "name": "FemaleParent", "type": "esriFieldTypeInteger", "alias": "FemaleParent", "domain": null }, { "name": "FemaleParent1Child", "type": "esriFieldTypeInteger", "alias": "FemaleParent1Child", "domain": null }, { "name": "FemaleParent2Children", "type": "esriFieldTypeInteger", "alias": "FemaleParent2Children", "domain": null }, { "name": "FemaleParent3OrMoreChildren", "type": "esriFieldTypeInteger", "alias": "FemaleParent3OrMoreChildren", "domain": null }, { "name": "MaleParent", "type": "esriFieldTypeInteger", "alias": "MaleParent", "domain": null }, { "name": "MaleParent1Child", "type": "esriFieldTypeInteger", "alias": "MaleParent1Child", "domain": null }, { "name": "MaleParent2Children", "type": "esriFieldTypeInteger", "alias": "MaleParent2Children", "domain": null }, { "name": "MaleParent3OrMoreChildren", "type": "esriFieldTypeInteger", "alias": "MaleParent3OrMoreChildren", "domain": null }, { "name": "TotalNumberOfChildrenAtHome", "type": "esriFieldTypeInteger", "alias": "TotalNumberOfChildrenAtHome", "domain": null }, { "name": "UnderSixYearsOfAge", "type": "esriFieldTypeInteger", "alias": "UnderSixYearsOfAge", "domain": null }, { "name": "to14Years", "type": "esriFieldTypeInteger", "alias": "to14Years", "domain": null }, { "name": "to17Years", "type": "esriFieldTypeInteger", "alias": "to17Years", "domain": null }, { "name": "to24Years", "type": "esriFieldTypeInteger", "alias": "to24Years", "domain": null }, { "name": "YearsAndOver", "type": "esriFieldTypeInteger", "alias": "YearsAndOver", "domain": null }, { "name": "AvgNumChildrenHomePerCensusFam", "type": "esriFieldTypeDouble", "alias": "AvgNumChildrenHomePerCensusFam", "domain": null }, { "name": "TotalNumPersonsInPrivateHshlds", "type": "esriFieldTypeInteger", "alias": "TotalNumPersonsInPrivateHshlds", "domain": null }, { "name": "NumPersonsNotInCensusFamilies", "type": "esriFieldTypeInteger", "alias": "NumPersonsNotInCensusFamilies", "domain": null }, { "name": "LivingWithRelatives", "type": "esriFieldTypeInteger", "alias": "LivingWithRelatives", "domain": null }, { "name": "LivingWithNonRelativesOnly", "type": "esriFieldTypeInteger", "alias": "LivingWithNonRelativesOnly", "domain": null }, { "name": "LivingAlone", "type": "esriFieldTypeInteger", "alias": "LivingAlone", "domain": null }, { "name": "NumberOfCensusFamilyPersons", "type": "esriFieldTypeInteger", "alias": "NumberOfCensusFamilyPersons", "domain": null }, { "name": "AvgNumPersonsPerCensusFam", "type": "esriFieldTypeDouble", "alias": "AvgNumPersonsPerCensusFam", "domain": null }, { "name": "TotalNumPersons65YrsAndOver", "type": "esriFieldTypeInteger", "alias": "TotalNumPersons65YrsAndOver", "domain": null }, { "name": "NumPersNotInCensusFam65YrsOver", "type": "esriFieldTypeInteger", "alias": "NumPersNotInCensusFam65YrsOver", "domain": null }, { "name": "LivingWithRelatives_1", "type": "esriFieldTypeInteger", "alias": "LivingWithRelatives_1", "domain": null }, { "name": "LivingWithNonRelativesOnly_1", "type": "esriFieldTypeInteger", "alias": "LivingWithNonRelativesOnly_1", "domain": null }, { "name": "LivingAlone_1", "type": "esriFieldTypeInteger", "alias": "LivingAlone_1", "domain": null }, { "name": "NumCensusFamPers65YearsAndOver", "type": "esriFieldTypeInteger", "alias": "NumCensusFamPers65YearsAndOver", "domain": null }, { "name": "TotalNumOfOccupiedPrivateDwell", "type": "esriFieldTypeInteger", "alias": "TotalNumOfOccupiedPrivateDwell", "domain": null }, { "name": "DwellingDensityPerSqHa", "type": "esriFieldTypeDouble", "alias": "DwellingDensityPerSqHa", "domain": null }, { "name": "AvgNumRoomsPerDwelling", "type": "esriFieldTypeDouble", "alias": "AvgNumRoomsPerDwelling", "domain": null }, { "name": "AvgNumBedroomsPerDwelling", "type": "esriFieldTypeDouble", "alias": "AvgNumBedroomsPerDwelling", "domain": null }, { "name": "TtlNumOccPrivDwelByHsingTenure", "type": "esriFieldTypeInteger", "alias": "TtlNumOccPrivDwelByHsingTenure", "domain": null }, { "name": "Owned", "type": "esriFieldTypeInteger", "alias": "Owned", "domain": null }, { "name": "Rented", "type": "esriFieldTypeInteger", "alias": "Rented", "domain": null }, { "name": "BandHousing", "type": "esriFieldTypeInteger", "alias": "BandHousing", "domain": null }, { "name": "TtlNumOccPrivDwellByConOfDwell", "type": "esriFieldTypeInteger", "alias": "TtlNumOccPrivDwellByConOfDwell", "domain": null }, { "name": "RegularMaintenanceOnly", "type": "esriFieldTypeInteger", "alias": "RegularMaintenanceOnly", "domain": null }, { "name": "MinorRepairs", "type": "esriFieldTypeInteger", "alias": "MinorRepairs", "domain": null }, { "name": "MajorRepairs", "type": "esriFieldTypeInteger", "alias": "MajorRepairs", "domain": null }, { "name": "TtlOccPrivDwelByPeriodOfConst", "type": "esriFieldTypeInteger", "alias": "TtlOccPrivDwelByPeriodOfConst", "domain": null }, { "name": "PeriodOfConstructionBefore1946", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstructionBefore1946", "domain": null }, { "name": "PeriodOfConstruction1946to1960", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction1946to1960", "domain": null }, { "name": "PeriodOfConstruction1961to1970", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction1961to1970", "domain": null }, { "name": "PeriodOfConstruction1971to1980", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction1971to1980", "domain": null }, { "name": "PeriodOfConstruction1981to1985", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction1981to1985", "domain": null }, { "name": "PeriodOfConstruction1986to1990", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction1986to1990", "domain": null }, { "name": "PeriodOfConstruction1991to1995", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction1991to1995", "domain": null }, { "name": "PeriodOfConstruction1996to2000", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction1996to2000", "domain": null }, { "name": "PeriodOfConstruction2001to2006", "type": "esriFieldTypeInteger", "alias": "PeriodOfConstruction2001to2006", "domain": null }, { "name": "TtlNumOccPrivDwellByStructType", "type": "esriFieldTypeInteger", "alias": "TtlNumOccPrivDwellByStructType", "domain": null }, { "name": "SingleDetachedHouse", "type": "esriFieldTypeInteger", "alias": "SingleDetachedHouse", "domain": null }, { "name": "SemiDetachedHouse", "type": "esriFieldTypeInteger", "alias": "SemiDetachedHouse", "domain": null }, { "name": "RowHouse", "type": "esriFieldTypeInteger", "alias": "RowHouse", "domain": null }, { "name": "ApartmentDuplex", "type": "esriFieldTypeInteger", "alias": "ApartmentDuplex", "domain": null }, { "name": "AptBldgFiveOrMoreStoreys", "type": "esriFieldTypeInteger", "alias": "AptBldgFiveOrMoreStoreys", "domain": null }, { "name": "AptBldgFewerThanFiveStoreys", "type": "esriFieldTypeInteger", "alias": "AptBldgFewerThanFiveStoreys", "domain": null }, { "name": "OtherSingleAttachedHouse", "type": "esriFieldTypeInteger", "alias": "OtherSingleAttachedHouse", "domain": null }, { "name": "MovableDwelling", "type": "esriFieldTypeInteger", "alias": "MovableDwelling", "domain": null }, { "name": "TotalNumPrivHshldsByHsldSize", "type": "esriFieldTypeInteger", "alias": "TotalNumPrivHshldsByHsldSize", "domain": null }, { "name": "Person", "type": "esriFieldTypeInteger", "alias": "Person", "domain": null }, { "name": "Persons", "type": "esriFieldTypeInteger", "alias": "Persons", "domain": null }, { "name": "Persons_1", "type": "esriFieldTypeInteger", "alias": "Persons_1", "domain": null }, { "name": "to5Persons", "type": "esriFieldTypeInteger", "alias": "to5Persons", "domain": null }, { "name": "OrMorePersons", "type": "esriFieldTypeInteger", "alias": "OrMorePersons", "domain": null }, { "name": "NumberPersonsInPrivateHshlds", "type": "esriFieldTypeInteger", "alias": "NumberPersonsInPrivateHshlds", "domain": null }, { "name": "AvgNumPersonsInPrivHshlds", "type": "esriFieldTypeDouble", "alias": "AvgNumPersonsInPrivHshlds", "domain": null }, { "name": "TotalNumPrivHshldsByHshldType", "type": "esriFieldTypeInteger", "alias": "TotalNumPrivHshldsByHshldType", "domain": null }, { "name": "OneFamilyHouseholds", "type": "esriFieldTypeInteger", "alias": "OneFamilyHouseholds", "domain": null }, { "name": "MultipleFamilyHouseholds", "type": "esriFieldTypeInteger", "alias": "MultipleFamilyHouseholds", "domain": null }, { "name": "NonFamilyHouseholds", "type": "esriFieldTypeInteger", "alias": "NonFamilyHouseholds", "domain": null } ], "indexes": [ { "name": "R89_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G103ProfileOfCen", "fields": "ProfileOfCens", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Data,Map,Query", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }