About this Dataset

Capital Project Data

Field Name	Field Type	Field Description
FID	Integer	Unique identifier for the projects
ARP Project	Text	The ARP code assigned to project.
LAT Project	Text	The LAT code assigned to project.
Project Name	Text	The name used to identify the project.
Description	Text	An explanation of the project
Project Location	Text	The address of the project
Priority Area	Text	The priority area the project belongs.
Agency Organization	Text	The agency involves in executing the project.
Project Owner	Text	A leader in the executing agency.
Chief	Text

Tables

Table 1

@usgov.louisville_metro_government_capital_project_data.table_1

43.17 kB
14 rows
38 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "fid" BIGINT,
  "arp_projec" VARCHAR,
  "lat_projec" VARCHAR,
  "project_na" VARCHAR,
  "description" VARCHAR,
  "address_lo" VARCHAR,
  "priority_a" VARCHAR,
  "agency_org" VARCHAR,
  "project_ow" VARCHAR,
  "chief" VARCHAR,
  "executive" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "allocation" BIGINT,
  "council_di" BIGINT,
  "project" VARCHAR,
  "image_url" VARCHAR,
  "image_url1" VARCHAR,
  "image_url2" VARCHAR,
  "image_url3" VARCHAR,
  "image_url4" VARCHAR,
  "image_url5" VARCHAR,
  "image_url6" VARCHAR,
  "image_url7" VARCHAR,
  "image_url8" VARCHAR,
  "image_url9" VARCHAR,
  "fid2" BIGINT,
  "imagename" VARCHAR,
  "imagename1" VARCHAR,
  "imagename2" VARCHAR,
  "imagename3" VARCHAR,
  "imagename4" VARCHAR,
  "imagename5" VARCHAR,
  "imagename6" VARCHAR,
  "imagename7" VARCHAR,
  "link" VARCHAR
);