About this Dataset

Blockfaces With Meters

A. SUMMARY
Blockfaces with meters. Length of blockface corresponds to where meters are spaced.

B. METHODOLOGY
Blockfaces with meters. Length of blockface corresponds to where meters are spaced.

C. UPDATE FREQUENCY
Manual updates via the SFpark data warehouse.

D. OTHER CRITICAL INFO
Updated weekly as needed, when new meters are installed blockfaces are edited so as to allow each meter point to snap to the blockface line.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:44.971819
Tags: blockfaces, meters, parking, sfpark

Tables

Table 1

@usgov.city_of_san_francisco_blockfaces_with_meters.table_1

344.85 kB
3,096 rows
27 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "blockface_id" BIGINT,
  "area_type" VARCHAR,
  "pm_district_id" BIGINT,
  "block_num" BIGINT,
  "block_id" BIGINT,
  "street_id" BIGINT,
  "street_name" VARCHAR,
  "blockface_orientation" VARCHAR,
  "str_num_parity" VARCHAR,
  "str_seg_orientation" VARCHAR,
  "fm_addr_no" DOUBLE,
  "to_addr_no" DOUBLE,
  "endpt1_longitude" DOUBLE,
  "endpt1_latitude" DOUBLE,
  "endpt2_longitude" DOUBLE,
  "endpt2_latitude" DOUBLE,
  "created_dt" TIMESTAMP,
  "last_upd_dt" TIMESTAMP,
  "last_upd_user" VARCHAR,
  "last_upd_pgm" VARCHAR,
  "neighborhood_id" DOUBLE,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" VARCHAR
);