{"id":"08b3ac51-b44d-4e52-9d87-7bb42621ae7a","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","source_artifact_id":"18dae170-a31d-4972-ba4b-167866a3d9d8","family":"terminal_procedures","chart_id":"294-17043-00294ry28r","title":"RNAV (GPS) Y RWY 28R","category":"IAP","region":"CA","edition":"4","status":"ready","effective_at":"2026-04-16T00:00:00","expires_at":"2026-05-14T00:00:00","bounds":{"west":-122.2381065558,"east":-121.8235809336,"south":37.3536057998,"north":37.8782140331},"live_available":true,"offline_available":true,"offline_status":"finalized","offline_content_url":"/api/v1/charts/08b3ac51-b44d-4e52-9d87-7bb42621ae7a/mbtiles","detail_url":"/api/v1/charts/08b3ac51-b44d-4e52-9d87-7bb42621ae7a","assets_url":"/api/v1/charts/08b3ac51-b44d-4e52-9d87-7bb42621ae7a/assets","primary_live_content_url":"/api/v1/chart-assets/3e12c82b-52ef-44f2-b947-8e830705e439/content","metadata_json":{"state_code":"CA","state_name":"CALIFORNIA","city_id":"OAKLAND","volume":"SW-2","airport_id":"OAKLAND SAN FRANCISCO BAY","airport_alnum":"294","airport_ident":"OAK","airport_icao_ident":"KOAK","airport_military":"N","chart_code":"IAP","chart_sequence":"53525","procuid":"17043","pdf_name":"00294RY28R.PDF","bvpage":"203","amdtnum":"4","amdtdate":"6/12/2025","faanfd18":null,"civil":"C","copter":null,"two_colored":"N","pdf_available":true,"georeference_checked":true,"georeferenced_pdf":true,"georeference_kind":"geopdf_vp_measure","georeference_viewport_count":1},"assets":[{"id":"3e12c82b-52ef-44f2-b947-8e830705e439","chart_id":"08b3ac51-b44d-4e52-9d87-7bb42621ae7a","source_artifact_id":"954c3942-b567-4d18-8867-2bc14c69d62c","asset_kind":"pdf","filename":"00294RY28R.PDF","relative_path":"extracted/2026-04-16/terminal_procedures/ddtppa_zip/00294RY28R.PDF","media_type":"application/pdf","status":"ready","file_size_bytes":270682,"checksum_sha256":"57754bd7412867090460f835acb5ffb07848ed602951eb1fa8e57bee3b8f0ca0","metadata_json":{"pdf_name":"00294RY28R.PDF","chart_code":"IAP","procuid":"17043","bvpage":"203","source_artifact_role":"ddtppa_zip","georeference_checked":true,"georeferenced_pdf":true,"georeference_kind":"geopdf_vp_measure","bounds":{"west":-122.2381065558,"east":-121.8235809336,"south":37.3536057998,"north":37.8782140331},"page_bbox":{"left":9.18,"bottom":2.628,"right":378.18,"top":591.372},"georeference_control_points":[{"latitude":37.35388775449,"longitude":-122.2372766073},{"latitude":37.35360579982,"longitude":-121.8255455865},{"latitude":37.877930263,"longitude":-121.8235809336},{"latitude":37.87821403311,"longitude":-122.2381065558}],"georeference_page_points":[{"x":0.1,"y":0.1},{"x":0.9,"y":0.1},{"x":0.9,"y":0.9},{"x":0.1,"y":0.9}],"georeference_viewport_count":1,"projection_wkt":"PROJCS[\"FAA LCC (0029417043)\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.000,298.25722210]],PRIMEM[\"Greenwich\",0],UNIT[\"Degree\",0.017453292519943295]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",0.000],PARAMETER[\"False_Northing\",0.000],PARAMETER[\"Central_Meridian\",-122.11499999999999],PARAMETER[\"Latitude_Of_Origin\",37.69572222222220],PARAMETER[\"Standard_Parallel_1\",38.66666666666670],PARAMETER[\"Standard_Parallel_2\",33.33333333333330],UNIT[\"Inch\",0.02540005080010]]"},"content_url":"/api/v1/chart-assets/3e12c82b-52ef-44f2-b947-8e830705e439/content"}]}