Baselight

Block Centroids

District of Columbia

@usgov.district_of_columbia_block_centroids

Loading...
Loading...

About this Dataset

Block Centroids

The dataset contains locations and attributes of blocks, created as part of the Master Address Repository (MAR) for the Office of the Chief Technology Officer (OCTO) and participating DC government agencies. The blocks used street centerlines information from DDOT. Blocks include named alleys in DC (such as 'WALTER ALLEY NE'). A block represents a street segment which usually has two bordering streets. The coordinates for the blocks are located at the midpoint of the street segment. More information on the MAR can be found at https://opendata.dc.gov/pages/addressing-in-dc. The data dictionary is available: https://opendata.dc.gov/documents/2a4b3d59aade43188b6d18e3811f4fd3/explore. In the MAR 2, the BlocksPt is called BLOCKS_PT and is primarily based off of street data from DC Department of Transportation's Roads & Highways database, it also features additional useful information such as created date, last edited date, begin date, and more.
Organization: District of Columbia
Last updated: 2024-04-30T18:37:45.029544
Tags: address-blocks, district-of-columbia, location, mar, mardata, mardistrict, master-address-repository, octo, street-address, washington-dc

Tables

Table 1

@usgov.district_of_columbia_block_centroids.table_1
  • 3.64 MB
  • 16532 rows
  • 53 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.