About this Dataset

Stormwater Inlets, Drains And Catch Basins

The catch basin data is collected by SFDPW Hydraulics Engineering and SFPUC Wastewater Enterprise, Collection System Division engineers, drafters and operators. The data is collected from sewer reference and construction documents and field surveys. You can learn more about how the City's wastewater collection system works here: http://www.sfwater.org/index.aspx?page=399
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:42.031020
Tags: catch-basin, catchment-basin, storm-drain, stormwater

Tables

Table 1

@usgov.city_of_san_francisco_stormwater_inlets_drains_and_catch_basins.table_1

1.58 MB
24,085 rows
27 columns

CREATE TABLE table_1 (
  "dpw_node_id" BIGINT,
  "puc_maximo_asset_id" VARCHAR,
  "system_use_code" VARCHAR,
  "system_use" VARCHAR,
  "drain_type" VARCHAR,
  "point_x" DOUBLE,
  "point_y" DOUBLE,
  "priority_status" DOUBLE,
  "location" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "neighborhoods_from_fyvs_ahh9_2" DOUBLE,
  "n__old_sf_find_neighborhoods_2" DOUBLE  -- (old) SF Find Neighborhoods 2,
  "supervisorial_districts_waterline_data_from_7pkg_wer3_2" DOUBLE,
  "neighborhoods_from_6ia5_2f8k_2" DOUBLE,
  "supervisor_districts_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "neighborhoods_analysis_boundaries_2" DOUBLE  -- Neighborhoods - Analysis Boundaries 2,
  "neighborhoods_old_2" DOUBLE  -- Neighborhoods (old) 2,
  "police_districts_2" DOUBLE,
  "fire_prevention_districts_2" DOUBLE,
  "zip_codes_2" DOUBLE,
  "neighborhoods" DOUBLE,
  "current_police_districts_3" DOUBLE,
  "current_supervisor_districts" DOUBLE
);