Baselight

Asset Inventory

City of Los Angeles

@usgov.city_of_los_angeles_asset_inventory_eee66

Loading...
Loading...

About this Dataset

Asset Inventory

This dataset is an inventory of the assets on the site. Here you can track the performance of data publishing, metadata maintenance, as well as present an overview of what data exists on the site.

Note: This is only updated once per day.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:06.033244

Tables

Table 1

@usgov.city_of_los_angeles_asset_inventory_eee66.table_1
  • 449.85 kB
  • 3,505 rows
  • 37 columns
Loading...
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  -- Last Update Date (data),
  "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  -- Routing & Approval,
  "api_endpoint" VARCHAR,
  "system" VARCHAR,
  "last_updated" TIMESTAMP,
  "what_geographic_unit_is_the_data_collected" VARCHAR  -- What Geographic Unit Is The Data Collected?,
  "refresh_rate" VARCHAR,
  "does_this_data_have_a_location_column_yes_or_no" VARCHAR  -- Does This Data Have A Location Column? (Yes Or No),
  "geometrytype" VARCHAR,
  "hasattachments" VARCHAR,
  "parent_uid" VARCHAR,
  "view_moderation_status" VARCHAR,
  "provenance" VARCHAR,
  "owner" VARCHAR,
  "individual_owner_name_s_not_public" VARCHAR  -- Individual Owner Name(s) - Not Public,
  "individual_owner_email_s_not_public" VARCHAR  -- Individual Owner Email(s) - Not Public
);

Share link

Anyone who has the link will be able to view this.