{"id":"508d22f5-1b2e-42e2-8597-22a06815994c","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","source_artifact_id":"18dae170-a31d-4972-ba4b-167866a3d9d8","family":"terminal_procedures","chart_id":"945-16609-00945r18","title":"RNAV (GPS) RWY 18","category":"IAP","region":"IA","edition":"1","status":"ready","effective_at":"2026-04-16T00:00:00","expires_at":"2026-05-14T00:00:00","bounds":{"west":-92.6899317355,"east":-92.0493570926,"south":42.2507743182,"north":43.0013789737},"live_available":true,"offline_available":true,"offline_status":"finalized","offline_content_url":"/api/v1/charts/508d22f5-1b2e-42e2-8597-22a06815994c/mbtiles","detail_url":"/api/v1/charts/508d22f5-1b2e-42e2-8597-22a06815994c","assets_url":"/api/v1/charts/508d22f5-1b2e-42e2-8597-22a06815994c/assets","primary_live_content_url":"/api/v1/chart-assets/82449396-8d94-4dda-ad8b-25512f503fcc/content","metadata_json":{"state_code":"IA","state_name":"IOWA","city_id":"WATERLOO","volume":"NC-3","airport_id":"WATERLOO RGNL","airport_alnum":"945","airport_ident":"ALO","airport_icao_ident":"KALO","airport_military":"N","chart_code":"IAP","chart_sequence":"53525","procuid":"16609","pdf_name":"00945R18.PDF","bvpage":"603","amdtnum":"1","amdtdate":"9/13/2018","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":"82449396-8d94-4dda-ad8b-25512f503fcc","chart_id":"508d22f5-1b2e-42e2-8597-22a06815994c","source_artifact_id":"8556e15d-2157-40fa-a449-5947112f8f2e","asset_kind":"pdf","filename":"00945R18.PDF","relative_path":"extracted/2026-04-16/terminal_procedures/ddtppb_zip/00945R18.PDF","media_type":"application/pdf","status":"ready","file_size_bytes":237294,"checksum_sha256":"ce14a06244650fcbdb4e4fdfb93c1e235d3c48e8800457a5dedee34d8d77571c","metadata_json":{"pdf_name":"00945R18.PDF","chart_code":"IAP","procuid":"16609","bvpage":"603","source_artifact_role":"ddtppb_zip","georeference_checked":true,"georeferenced_pdf":true,"georeference_kind":"geopdf_vp_measure","bounds":{"west":-92.6899317355,"east":-92.0493570926,"south":42.2507743182,"north":43.0013789737},"page_bbox":{"left":9.18,"bottom":2.628,"right":378.18,"top":591.372},"georeference_control_points":[{"latitude":42.25085893199,"longitude":-92.68655335141},{"latitude":42.25077431818,"longitude":-92.05310298148},{"latitude":43.00129349036,"longitude":-92.04935709262},{"latitude":43.00137897368,"longitude":-92.68993173548}],"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[\"\",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\",-92.38616666666671],PARAMETER[\"Latitude_Of_Origin\",42.64847222222221],PARAMETER[\"Standard_Parallel_1\",45.00000000000001],PARAMETER[\"Standard_Parallel_2\",33.00000000000001],UNIT[\"Inch\",0.02540005080010]]"},"content_url":"/api/v1/chart-assets/82449396-8d94-4dda-ad8b-25512f503fcc/content"}]}