{"uid":"cap_zBf_5MDTpz3DwhBF1vqKR","slug":"air-quality-observations-date-by-category-pivot-c1a74e06","name":"Air Quality Observations – Date by Category Pivot","description":"Air quality observations - Date by category pivot: Date by category pivot for Air quality observations. Up to 200 supplied typed records. Local descriptive analytics; no enrichment or forecast. One of 25 new profiles across 20 shared operations in this industry. 0.01 USDC includes one bounded date by category pivot report.","url":"https://market.datapackvibe.com/x402/assistant-ar-analytics-air-quality-observations-pivot?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station","date","pm25","humidity_percent"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"pm25":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"station":{"type":"string","default":"","maxLength":80},"humidity_percent":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","pm25":10,"row_id":"row-1","station":"group-a","humidity_percent":1},{"date":"2026-10-02","pm25":20,"row_id":"row-2","station":"group-b","humidity_percent":2},{"date":"2026-10-03","pm25":15,"row_id":"row-3","station":"group-a","humidity_percent":3},{"date":"2026-10-04","pm25":30,"row_id":"row-4","station":"group-b","humidity_percent":4}],"maxItems":200,"minItems":1},"field":{"enum":["pm25","humidity_percent"],"type":"string","default":"pm25"}}},"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_4oFwNs_6dymH3W1p4P8gx","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":"Pivots up to 200 air quality observation records by date and station category, returning a descriptive analytics table for PM2.5 or humidity.","exampleAgentPrompt":"Pivot my air quality observation data by date and station — I have 4 records with station names, dates, and PM2.5 readings, and I want a date-by-station breakdown using PM2.5 as the pivot field.","exampleUseCases":[{"title":"Daily PM2.5 comparison across monitoring stations","prompt":"I have a week's worth of PM2.5 readings from two monitoring stations, group-a and group-b, and I want to see a pivot table showing PM2.5 values broken down by date and station so I can compare daily air quality between them."},{"title":"Humidity trend summary by sensor group","prompt":"Can you run a date-by-category pivot on my air quality sensor records using humidity_percent as the field? I've got about 50 rows with station names and dates and I want to see how humidity varied across groups over time."},{"title":"Environmental report prep for multiple sites","prompt":"I'm preparing an environmental summary for three monitoring sites over the past month — take my 120 air quality observation rows and pivot them by date and station category using PM2.5, so I can see which sites had the worst days."}],"resultDescription":"A bounded date-by-category pivot report (up to 200 rows) showing the selected field (PM2.5 or humidity) aggregated by date and station category. The output is a descriptive analytics table — no forecasts or enrichment — suitable for identifying patterns and comparing values across station groups and time periods.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, station, date, pm25, humidity_percent) on any row causes validation failure","Invalid date format (not YYYY-MM-DD) triggers pattern validation error","Invalid field enum value (not 'pm25' or 'humidity_percent') causes rejection","Empty rows array (minItems: 1 violated) returns an error","Payment of 0.01 USDC not provided or insufficient funds causes x402 payment failure"],"whenToPreferThis":"Choose this endpoint when you have raw air quality observation records (up to 200 rows) with station identifiers and dates and need a quick local descriptive pivot table by date and category — no external enrichment, forecasting, or machine learning required. Prefer this over general analytics tools when you specifically need a bounded date-by-category cross-tab of PM2.5 or humidity for environmental monitoring or reporting workflows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:14:46.634Z","isFirstParty":false,"canonicalSlug":"air-quality-observations-date-by-category-pivot-c1a74e06"}