Block Centroids
District of Columbia
@usgov.district_of_columbia_block_centroids
District of Columbia
@usgov.district_of_columbia_block_centroids
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"block_name" VARCHAR,
"full_block_name" VARCHAR,
"on_street_name" VARCHAR,
"on_street_type" VARCHAR,
"on_street_quadrant" VARCHAR,
"on_street_display" VARCHAR,
"from_street_name" VARCHAR,
"from_street_type" VARCHAR,
"from_street_quadrant" VARCHAR,
"from_street_display" VARCHAR,
"to_street_name" VARCHAR,
"to_street_type" VARCHAR,
"to_street_quadrant" VARCHAR,
"to_street_display" VARCHAR,
"from_intersectionkey" VARCHAR,
"to_intersectionkey" VARCHAR,
"on_routeid" VARCHAR,
"from_routeid" VARCHAR,
"to_routeid" VARCHAR,
"address_range_left_low" DOUBLE,
"address_range_left_high" DOUBLE,
"address_range_right_low" DOUBLE,
"address_range_right_high" DOUBLE,
"address_range_low" BIGINT,
"address_range_high" BIGINT,
"status" VARCHAR,
"ward" VARCHAR,
"blockkey" VARCHAR,
"mar_id" BIGINT,
"before_date" VARCHAR,
"before_date_source" VARCHAR,
"begin_date" VARCHAR,
"begin_date_source" VARCHAR,
"first_known_date" VARCHAR,
"first_known_date_source" VARCHAR,
"x_coordinate" DOUBLE,
"y_coordinate" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"extent_min_x" DOUBLE,
"extent_min_y" DOUBLE,
"extent_max_x" DOUBLE,
"extent_max_y" DOUBLE,
"lrs_side_address_odd" VARCHAR,
"lrs_side_address_even" VARCHAR,
"metadata_id" BIGINT,
"national_grid" VARCHAR,
"created_date" TIMESTAMP,
"last_edited_date" TIMESTAMP,
"se_anno_cad_data" VARCHAR,
"objectid" BIGINT
);
Anyone who has the link will be able to view this.