Home › Sources › datasf_neighborhood_zip_crosswalk_jc98_7xvv
DataSF Analysis Neighborhoods to ZIP Code Crosswalk
Source ID datasf_neighborhood_zip_crosswalk_jc98_7xvv. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_neighborhood_zip_crosswalk_jc98_7xvv |
| Name | DataSF Analysis Neighborhoods to ZIP Code Crosswalk |
| Owner | City and County of San Francisco / DataSF |
| Layer | place_reference_context |
| Coverage | Static DataSF analysis-neighborhood to ZIP Code crosswalk: 152 source rows covering 41 analysis neighborhoods and 27 ZIP codes, latest data_loaded_at 2023-06-23T18:21:48.562Z. Rows collapse to 150 unique neighborhood/ZIP place rows plus 152 source_records. |
| Formats | JSON API, CSV |
| Join keys | nhood, neighborhood, zip_code |
| Caveats | Many-to-many ZIP/neighborhood crosswalk only; not boundary geometry., Use official boundary datasets for point-in-polygon joins., Contains no case, person, incident, or outcome facts. |
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_neighborhood_zip_crosswalk_jc98_7xvv | socrata_static_reference_extract | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | static reference dataset |
| Coverage | Static DataSF analysis-neighborhood to ZIP Code crosswalk: 152 source rows covering 41 analysis neighborhoods and 27 ZIP codes, latest data_loaded_at 2023-06-23T18:21:48.562Z. Rows collapse to 150 unique neighborhood/ZIP place rows plus 152 source_records. |
| Government Level | local_geography |
| ID | datasf_neighborhood_zip_crosswalk_jc98_7xvv |
| Layer | place_reference_context |
| Name | DataSF Analysis Neighborhoods to ZIP Code Crosswalk |
| Owner | City and County of San Francisco / DataSF |
| Profile Status | promoted_full_static_place_reference_extract |
| Canonical Records | place_context, neighborhood_zip_crosswalk, source_record |
| Caveats | Many-to-many ZIP/neighborhood crosswalk only; not boundary geometry., Use official boundary datasets for point-in-polygon joins., Contains no case, person, incident, or outcome facts. |
| Evidence | artifacts/source-discovery/datasf-catalog-gap-scan.profile.json, artifacts/source-discovery/datasf-catalog-gap-jc98_7xvv.view.json, artifacts/source-discovery/datasf-catalog-gap-jc98_7xvv.sample.json, artifacts/source-discovery/datasf-catalog-gap-jc98_7xvv.count.json, artifacts/source-discovery/datasf-neighborhood-zip-crosswalk.profile.json, data/reference_raw/datasf-neighborhood-zip-crosswalk.json, data/reference_raw/datasf-neighborhood-zip-crosswalk.manifest.json, scripts/parse_datasf_neighborhood_zip_crosswalk.py |
| Formats | JSON API, CSV |
| Join Keys | nhood, neighborhood, zip_code |
| Known Endpoints | Socrata /resource/jc98-7xvv.json |
| Rate Limit Notes | Static 152-row reference table; refresh with other geography dimensions and do not call per API request. |
| Source Urls | https://data.sfgov.org/Geographic-Locations-and-Boundaries/Analysis-Neighborhoods-to-ZIP-Code-Crosswalk/jc98-7xvv, https://data.sfgov.org/resource/jc98-7xvv.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_neighborhood_zip_crosswalk_jc98_7xvvJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_neighborhood_zip_crosswalk_jc98_7xvv&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON