{"uid":"cap__PyBKaws-4pjrZRykdEUY","slug":"coastal-observations-duplicate-key-report-secondary-measure-weighted-ded5858c","name":"Coastal Observations Duplicate Key Report & Secondary-Measure Weighted Mean","description":"Coastal observations — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied coastal observations records (wave_height_m, wave_period_seconds). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-weather-18-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station_group","date","wave_height_m","wave_period_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"station_group":{"type":"string","default":"","maxLength":80},"wave_height_m":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"wave_period_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","station_group":"group-a","wave_height_m":10,"wave_period_seconds":1},{"date":"2026-10-02","row_id":"row-2","station_group":"group-b","wave_height_m":20,"wave_period_seconds":2},{"date":"2026-10-03","row_id":"row-3","station_group":"group-a","wave_height_m":15,"wave_period_seconds":3},{"date":"2026-10-04","row_id":"row-4","station_group":"group-b","wave_height_m":30,"wave_period_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["wave_height_m","wave_period_seconds"],"type":"string","default":"wave_height_m"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_-3C1W-HX9kS1bpzKnadlU","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes up to 200 coastal observation records to produce a duplicate key report and a secondary-measure weighted mean for wave height and wave period data.","exampleAgentPrompt":"I have a batch of coastal wave observation records with station groups and dates — can you run a duplicate key report and compute the weighted mean of wave_height_m for up to 200 rows? Here are my rows: row-1, group-a, 2026-10-01, wave_height_m=10, wave_period_seconds=1; row-2, group-b, 2026-10-02, wave_height_m=20, wave_period_seconds=2.","exampleUseCases":[{"title":"Audit buoy sensor data for duplicates","prompt":"I've got 150 rows of coastal buoy readings with station groups and dates — can you run a duplicate key check and also give me the weighted mean for wave_height_m across all of them?"},{"title":"Weighted mean wave period by station","prompt":"Here are my wave observation records for the month — please compute the weighted mean of wave_period_seconds grouped by station, and flag any duplicate station-date keys in the dataset."},{"title":"Data quality check before oceanographic report","prompt":"Before I submit this coastal dataset for our quarterly report, can you check for any duplicate station group and date combinations, and also calculate the secondary-measure weighted mean for wave_height_m across my 80 observation rows?"}],"resultDescription":"Returns two analytical reports: (1) a duplicate key report identifying rows with repeated station_group and date combinations, and (2) a weighted mean calculation for the selected secondary measure field (wave_height_m or wave_period_seconds) across the supplied records. Both reports are computed locally without external lookups.","failureModes":["Exceeding 200 rows causes rejection","Missing required fields (row_id, station_group, date, wave_height_m, wave_period_seconds) causes validation error","Invalid date format (not YYYY-MM-DD) causes schema error","Null values in both measure fields may affect weighted mean computation","Empty rows array rejected by minItems constraint"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical reports — a duplicate key audit and a weighted mean calculation — on coastal wave observation data (wave height and wave period) without any live data lookup or external enrichment. Ideal for data quality checks and basic statistical summarization of up to 200 oceanographic records at low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:33:13.883Z","isFirstParty":false,"canonicalSlug":"coastal-observations-duplicate-key-report-secondary-measure-weighted-ded5858c"}