Baselight

Planning Department Project Application Review Metrics

City of San Francisco

@usgov.city_of_san_francisco_planning_department_project_appl_3cb31c4f

Loading...
Loading...

About this Dataset

Planning Department Project Application Review Metrics

A. SUMMARY This dataset provides review time metrics for the San Francisco Planning Department’s application review process. The following metrics are provided: total days to Planning approval, days to finish completeness review, days to first check plan letter, and days to complete resubmission review. Targets for each metric and outcomes relative to these targets are also included. These metrics allow for ongoing tracking for individual planning projects and for the calculation of summary statistics for Planning review timelines. There are both Project level metrics and project event level metrics in this table. You can see a dashboard which shows the City's current permit processing performance on sf.gov. B. HOW THE DATASET IS CREATED Planning application review is tracked within Planning’s Project and Permit Tracking System (PPTS). Planners enter review period start and end dates in PPTS when review milestones are reached. Review timeline data is extracted from PPTS and review timelines and outcomes are calculated and consolidated within this dataset. The dataset is generated by a data model that pulls from multiple raw Accela sources and joins them together. C. UPDATE PROCESS This dataset is updated daily overnight. D. HOW TO USE THIS DATASET Use this dataset to analyze project level timelines for planning projects or to calculate summary metrics related to the planning review and approval processes. The review metric type is defined in the ‘project stage’ column. Note that multiple rounds of completeness check review and resubmission review may occur for a single Planning project. The ‘potential error’ column flags records where data entry errors are likely present. Filter out rows where a value is entered in this column before building summary statistics. E. RELATED DATASETS

Tables

Table 1

@usgov.city_of_san_francisco_planning_department_project_appl_3cb31c4f.table_1
  • 665.31 KB
  • 66833 rows
  • 14 columns
Loading...

CREATE TABLE table_1 (
  "b1_alt_id" VARCHAR,
  "project_stage" VARCHAR,
  "observation_window_type" VARCHAR,
  "observation_window_date" VARCHAR,
  "start_event_type" VARCHAR,
  "start_event_date" VARCHAR,
  "end_event_type" VARCHAR,
  "end_event_date" VARCHAR,
  "metric_value" DOUBLE,
  "sla_value" DOUBLE,
  "metric_outcome" VARCHAR,
  "potential_error" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);

Share link

Anyone who has the link will be able to view this.