About this Dataset

City Lands

A. SUMMARY This data represents the boundaries of City-owned lands maintained in the City's Facility System of Record (FSR). Note: Not all lands are within the City and County proper. The City owns properties outside of its boundaries, including lands managed by SF Recreation and Parks, SF Public Utilities Commission, and other agencies. Certain lands are managed by following agencies which are not directly part of the City and County of San Francisco, but are included here for reference: San Francisco Housing Authority (SFHA) , San Francisco Office of Community Investment and Infrastructure (OCII) , and City College of San Francisco. B. HOW THE DATASET IS CREATED The Enterprise GIS program in the Department of Technology is the technical custodian of the FSR. This team creates and maintains this dataset in conjunction with the Real Estate Division and the Capital Planning Program of the City Administrator’s Office, who act as the primary business data stewards for this data. C. UPDATE PROCESS There are a handful of events that may trigger changes to this dataset: 1. The sale of a property 2. The leasing of a property 3. The purchase of a property 4. The change in jurisdiction of a property (e.g. from MTA to DPW) 5. The removal or improvement of the property Each of these changes triggers a workflow that updates the FSR. The Real Estate Division and Capital Planning make updates on an ongoing basis. The full dataset is reviewed quarterly to ensure nothing is missing or needs to be corrected. Updates to the data, once approved, are immediately reflected in the internal system and are updated here in the open dataset on a monthly basis. D. HOW TO USE THIS DATASET See here for an interactive map of all the City lands in this dataset. To track the facilities on City lands, join this dataset to the City Facilities dataset using the land_id field. If you see an error in the data, you can submit a change request with the relevant information to dtis.helpdesk@sfgov.org. Please be as specific about the error as you can (including relevant land_id(s)). E. RELATED DATASETS City Facilities
Organization: City of San Francisco
Last updated: 2020-12-04T19:33:53.179380
Tags: fsr, land, property

Tables

Table 1

@usgov.city_of_san_francisco_city_lands.table_1

1.33 MB
1013 rows
12 columns


CREATE TABLE table_1 (
  "land_id" BIGINT,
  "land_name" VARCHAR,
  "dept_id" BIGINT,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip" DOUBLE,
  "category" VARCHAR,
  "department_name" VARCHAR,
  "shape" VARCHAR,
  "data_last_updated" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);