About this Dataset

Points Of Interest

Also known as place names. The dataset contains locations and attributes of address alias points, created as part of the Master Address Repository (MAR) for the Office of the Chief Technology Officer (OCTO) and participating DC government agencies. It contains address alias names in the District of Columbia which are typically placed on buildings. These alias names represent named features such as: - Schools - Federal Buildings - Military Installations - Hospitals - Museums - Monuments - University Structures - Fire and Police Stations - Libraries - Metro Facilities - Historical Landmarks - Recreation Centers - Mile Markers - Marinas and more. 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 AddressAliasPt is called PLACE_NAMES_PT and features additional useful information such as created date, last edited date, begin date, and more.
Organization: District of Columbia
Last updated: 2024-04-30T18:00:30.889099
Tags: address-alias, district-of-columbia, location, mar, mardata, mardistrict, master-address-repository, octo, places-of-interest, points-of-interest, street-address, washington-dc

Tables

Table 1

@usgov.district_of_columbia_points_of_interest_61599.table_1

843.64 kB
14,889 rows
17 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "name" VARCHAR,
  "status" VARCHAR,
  "before_date" VARCHAR,
  "before_date_source" VARCHAR,
  "begin_date" VARCHAR,
  "begin_date_source" VARCHAR,
  "first_known_date" VARCHAR,
  "first_known_date_source" VARCHAR,
  "metadata_id" BIGINT,
  "place_name_id" BIGINT,
  "mar_id" BIGINT,
  "created_date" TIMESTAMP,
  "last_edited_date" TIMESTAMP,
  "se_anno_cad_data" VARCHAR,
  "objectid" BIGINT
);