Business Services - Inventory Accuracy
The percent of inventory value/level stored in the warehouse is accurate and is verified by using daily blind physical counts. This is calculated by annualizing the gross amount of discrepancies and dividing it by the inventory value: Inventory Accuracy Rate =1-(Gross Discrepancies*12/Inventory value). This dataset is used in combination with "Business Services - Warehouse Inventory" (https://citydata.mesaaz.gov/Business-Services/Business-Services-Warehouse-Inventory-Turnover-Det/ghh3-25pq) to create the view "Inventory Accuracy by Month" (https://citydata.mesaaz.gov/Business-Services/Inventory-Accuracy-by-Month/vqxg-fftr).
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"citydata-mesaaz-gov/business-services-inventory-accuracy-gcba-kfd3\".\"business_services_inventory_accuracy\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
