About this Dataset

San Francisco Mid-Block Points

A. SUMMARY This is a dataset containing points representing the midpoint of each block in the City of San Francisco. This dataset is used for geomasking (e.g. removing an exact address and replacing it with a nearby anonymized point) and other anonymization tasks. B. HOW THE DATASET IS CREATED This dataset was created by calculating the midpoint of each the street segment in the city (see Streets - Active and Retired) then returning the latitude and longitude of that midpoint. A street segment is a line between two intersections. Street midpoints are calculated for each side of the block. C. UPDATE PROCESS This dataset is updated weekly. D. HOW TO USE THIS DATASET Use this dataset for geomasking and other anonymization workflows. E. RELATED DATASETS - Streets - Active and Retired
Organization: City of San Francisco
Last updated: 2025-03-29T17:01:38.337481
Tags: block-midpoint

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_mid_block_points.table_1

1.34 MB
27,122 rows
10 columns

CREATE TABLE table_1 (
  "cnn" BIGINT,
  "parity" VARCHAR,
  "mid_block_address" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "n__point" VARCHAR  -- Point,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "n__data_as_of" VARCHAR  -- Data As Of,
  "data_loaded_at" VARCHAR
);