Geogebra spreadsheet8/18/2023 MassGIS also distributes the full, unprocessed set of SF1 data for Massachusetts released by the Census Bureau. To join these tables to the geographic layers (Blocks, Block Groups and Tracts), use the LOGSF1 field in the geography and the LOGRECNO field in the SF1 tables. In the list above, " geog_level" is a placeholder for the level of geography abbreviation used in the table names: "B" for Blocks, "BG" for Block Groups, and "CT" for Census Tracts. Population by Race (CEN2010_ geog-level_SF1_POP_RACE).Population by Age and Gender (CEN2010_ geog-level_SF1_POP_AGE_GENDER).Housing Residency Characteristics (CEN2010_ geog-level_SF1_HOU_RES_CHAR). Housing Owner Rental Demographics (CEN2010_ geog-level_SF1_HOU_OWN_REN_DEM).Households Size by Family (CEN2010_ geog-level_SF1_HH_SIZE_FAM).Households by Age, Family and Children (CEN2010_ geog-level_SF1_HH_AGE_FAM_CH).Group Quarters (CEN2010_ geog-level_SF1_GROUP_QUARTERS).For each level of geography are the following seven tables (21 tables in all): MassGIS acquired and processed a subset of the Massachusetts data from SF1 into a more user-friendly format with more intuitive field names. (for use with SF1 tables from other sources with LOGRECNO as a character field)Ī more expansive and detailed set of demographic data than those included in the PL-94-171 data, the SF1 tables contain information on age, sex, households, families, relationship to householder, housing units, detailed race and Hispanic or Latino origin groups, and group quarters. Joins to the LOGRECNO in the ACS 2006-2010 tables Also included is the LOGSF1C field, calculated by MassGIS from LOGSF1, which contains these values as text with the leading zeros preserved. By the time this error was realized, the attribute tables had already been processed and it was decided to retain the formatting error, as a correction would have been time-consuming and not affected the functionality of the data. This identifier field contains information that was originally a text value with leading zeroes like the other linking fields, but was converted to numeric by using instructions and database templates with formatting errors provided by the Census Bureau. (for use with SF1 tables distributed by MassGIS with LOGRECNO as a numeric field) Joins to the LOGRECNO in the PL-94-171 tables
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |