Baselight

Blockfaces With Meters

City of San Francisco

@usgov.city_of_san_francisco_blockfaces_with_meters

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
  • 336.77 KB
  • 3096 rows
  • 27 columns
Loading...

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
);