About this Dataset

Construction Activities Of Open (Issued, Not Final) Public Right-of-Way Permits

This dataset contains data for all Public Right-of-Way Permit applications issued in the last five years, including status and work performed.
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:58:19.779987
Tags: constructionactivities, issued, open, permits, publicrightofway

Tables

Table 1

@usgov.montgomery_county_of_maryland_construction_activities__36308562.table_1

1.33 MB
5766 rows
25 columns


CREATE TABLE table_1 (
  "application_type" VARCHAR,
  "permit_number" BIGINT,
  "work_type" VARCHAR,
  "use_code" VARCHAR,
  "added_date" TIMESTAMP,
  "issue_date" TIMESTAMP,
  "final_date" VARCHAR,
  "status" VARCHAR,
  "description_of_work" VARCHAR,
  "street_number" DOUBLE,
  "pre_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "post_direction" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "latitude_of_construction_activities_start" DOUBLE,
  "longitude_of_construction_activities_start" DOUBLE,
  "latitude_of_construction_activities_end" DOUBLE,
  "longitude_of_construction_activities_end" DOUBLE,
  "location" VARCHAR,
  "location_for_map" VARCHAR
);