Asset Inventory
City of Los Angeles
@usgov.city_of_los_angeles_asset_inventory_eee66
City of Los Angeles
@usgov.city_of_los_angeles_asset_inventory_eee66
CREATE TABLE table_1 (
"url" VARCHAR,
"public" BOOLEAN,
"derived_view" BOOLEAN,
"u_id" VARCHAR,
"department" VARCHAR,
"domain" VARCHAR,
"type" VARCHAR,
"name" VARCHAR,
"description" VARCHAR,
"visits" BIGINT,
"creation_date" VARCHAR,
"last_update_date_data" VARCHAR,
"category" VARCHAR,
"keywords" VARCHAR,
"downloads" BIGINT,
"owner_uid" VARCHAR,
"license" VARCHAR,
"publication_stage" VARCHAR,
"published_version_name" VARCHAR,
"published_version_uid" VARCHAR,
"data_provided_by" VARCHAR,
"source_link" VARCHAR,
"routing_approval" VARCHAR,
"api_endpoint" VARCHAR,
"system" VARCHAR,
"last_updated" TIMESTAMP,
"what_geographic_unit_is_the_data_collected" VARCHAR,
"refresh_rate" VARCHAR,
"does_this_data_have_a_location_column_yes_or_no" VARCHAR,
"geometrytype" VARCHAR,
"hasattachments" VARCHAR,
"parent_uid" VARCHAR,
"view_moderation_status" VARCHAR,
"provenance" VARCHAR,
"owner" VARCHAR,
"individual_owner_name_s_not_public" VARCHAR,
"individual_owner_email_s_not_public" VARCHAR
);
Anyone who has the link will be able to view this.