Census Blocks 2020
State of Maryland
@usgov.state_of_maryland_census_blocks_2020
State of Maryland
@usgov.state_of_maryland_census_blocks_2020
CREATE TABLE table_1 (
"the_geom" VARCHAR,
"gis_shape_area_m" DOUBLE -- GIS Shape Area (m),
"gis_shape_length_m" DOUBLE -- GIS Shape Length (m),
"gis_object_id" BIGINT,
"n_2020_census_state_fips_code" BIGINT -- 2020 Census State FIPS Code,
"n_2020_census_county_fips_code" BIGINT -- 2020 Census County FIPS Code,
"n_2020_census_tract_code" BIGINT -- 2020 Census Tract Code,
"n_2020_census_tabulation_block_number" BIGINT -- 2020 Census Tabulation Block Number,
"census_block_identifier" BIGINT,
"n_2020_census_tabulation_name" VARCHAR -- 2020 Census Tabulation Name,
"maf_tiger_feature_class_code" VARCHAR,
"n_2020_census_urban_rural_indicator" VARCHAR -- 2020 Census Urban Rural Indicator,
"n_2020_census_urban_area_code" VARCHAR -- 2020 Census Urban Area Code,
"n_2020_census_urban_area_type" VARCHAR -- 2020 Census Urban Area Type,
"n_2020_census_functional_status" VARCHAR -- 2020 Census Functional Status,
"n_2020_census_land_area" BIGINT -- 2020 Census Land Area,
"n_2020_census_water_area" BIGINT -- 2020 Census Water Area,
"n_2020_census_latitude_of_the_internal_point" DOUBLE -- 2020 Census Latitude Of The Internal Point,
"n_2020_census_longitude_of_the_internal_point" DOUBLE -- 2020 Census Longitude Of The Internal Point,
"total_area" DOUBLE
);
Anyone who has the link will be able to view this.