Planned Bike Facilities
City of Seattle
@usgov.city_of_seattle_planned_bike_facilities_e4336
City of Seattle
@usgov.city_of_seattle_planned_bike_facilities_e4336
CREATE TABLE table_1 (
"objectid" BIGINT,
"compkey" BIGINT,
"comptype" BIGINT,
"segkey" BIGINT,
"unitid" VARCHAR,
"unittype" VARCHAR,
"unitdesc" VARCHAR,
"category" VARCHAR,
"material" VARCHAR,
"style" VARCHAR,
"model_type" VARCHAR,
"asset_width" BIGINT,
"asset_height" BIGINT,
"install_date" VARCHAR,
"asblt" VARCHAR,
"attachment_1" VARCHAR,
"attachment_2" VARCHAR,
"attachment_3" VARCHAR,
"attachment_4" VARCHAR,
"attachment_5" VARCHAR,
"attachment_6" VARCHAR,
"attachment_7" VARCHAR,
"attachment_8" VARCHAR,
"attachment_9" VARCHAR,
"attachment_10" VARCHAR,
"num_attachments" BIGINT,
"comments" VARCHAR,
"current_status" VARCHAR,
"current_status_date" VARCHAR,
"condition" VARCHAR,
"condition_assessment_date" VARCHAR,
"last_asset_verification_date" VARCHAR,
"primarydistrictcd" VARCHAR,
"secondarydistrictcd" VARCHAR,
"overrideyn" VARCHAR,
"overridecomment" VARCHAR,
"ownership" VARCHAR,
"ownership_date" VARCHAR,
"maintained_by" VARCHAR,
"maintenance_agreement" VARCHAR,
"maintenance_financial_resp" VARCHAR,
"addby" VARCHAR,
"adddttm" VARCHAR,
"modby" VARCHAR,
"moddttm" VARCHAR,
"date_mvw_last_updated" VARCHAR,
"color" VARCHAR,
"mount_type" VARCHAR,
"mount_material" VARCHAR,
"expby" VARCHAR,
"expdate" VARCHAR,
"maint_grp_paint" VARCHAR,
"maint_grp_plants" VARCHAR,
"maint_grp_post" VARCHAR,
"maint_grp_snow" VARCHAR,
"maint_grp_sweep" VARCHAR,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.