Home › Sources › datasf_sfpd_drone_flight_logs_giw5_ttjs
San Francisco Police Department Drone Flight Logs
Source ID datasf_sfpd_drone_flight_logs_giw5_ttjs. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_sfpd_drone_flight_logs_giw5_ttjs |
| Name | San Francisco Police Department Drone Flight Logs |
| Owner | San Francisco Police Department / DataSF |
| Layer | public_safety_response_context |
| Coverage | Full small DataSF SFPD drone-flight log extract: 5,363 rows from 2024-05-16 through 2026-03-31. Rows include date, case_cad_event_number, flight duration, reason for flight, location, neighborhood, supervisor district, and point geometry, and now load into public_safety_events as sfpd_drone_flight context. |
| Formats | JSON API, CSV, GeoJSON |
| Join keys | case_cad_event_number, date, location, analysis_neighborhood, supervisor_district |
| Caveats | Drone flight rows are source-labeled agency response context, not court outcomes or proof of criminal conduct., Treat case_cad_event_number as a CAD/case-event bridge candidate only when another promoted source exposes the same identifier exactly. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | datasf_sfpd_drone_flight_logs_giw5_ttjs | full_small_public_safety_extract | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | open-data refresh; current extract observed through 2026-03-31 |
| Coverage | Full small DataSF SFPD drone-flight log extract: 5,363 rows from 2024-05-16 through 2026-03-31. Rows include date, case_cad_event_number, flight duration, reason for flight, location, neighborhood, supervisor district, and point geometry, and now load into public_safety_events as sfpd_drone_flight context. |
| Government Level | local_police |
| ID | datasf_sfpd_drone_flight_logs_giw5_ttjs |
| Layer | public_safety_response_context |
| Name | San Francisco Police Department Drone Flight Logs |
| Owner | San Francisco Police Department / DataSF |
| Profile Status | promoted_full_small_public_safety_extract |
| Canonical Records | public_safety_event, source_record |
| Caveats | Drone flight rows are source-labeled agency response context, not court outcomes or proof of criminal conduct., Treat case_cad_event_number as a CAD/case-event bridge candidate only when another promoted source exposes the same identifier exactly. |
| Evidence | artifacts/source-discovery/datasf-catalog-gap-scan.profile.json, artifacts/source-discovery/datasf-catalog-gap-giw5_ttjs.view.json, artifacts/source-discovery/datasf-catalog-gap-giw5_ttjs.sample.json, artifacts/source-discovery/datasf-catalog-gap-giw5_ttjs.count.json, artifacts/source-discovery/datasf-sfpd-drone-flight-logs.profile.json, data/public_safety_raw/datasf-sfpd-drone-flight-logs.json, data/public_safety_raw/datasf-sfpd-drone-flight-logs.manifest.json, scripts/profile_datasf_catalog_gap_scan.py, scripts/parse_datasf_sfpd_drone_flight_logs.py |
| Formats | JSON API, CSV, GeoJSON |
| Join Keys | case_cad_event_number, date, location, analysis_neighborhood, supervisor_district |
| Known Endpoints | Socrata /resource/giw5-ttjs.json |
| Rate Limit Notes | Small 5,363-row source; scheduled full refresh is simpler than incremental paging, with source_row_id drift checks. |
| Source Urls | https://data.sfgov.org/Public-Safety/San-Francisco-Police-Department-Drone-Flight-Logs/giw5-ttjs, https://data.sfgov.org/resource/giw5-ttjs.json |
Get this page with API
Rendered from the bluedoor SF Superior Court API. Reproduce it:
GET https://api.bluedoor.sh/sf-superior-court/v1/sources/datasf_sfpd_drone_flight_logs_giw5_ttjsJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_sfpd_drone_flight_logs_giw5_ttjs&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON