# Lake Macquarie City Council Open Data API

> Lake Macquarie Open Data: 15 open datasets with ODSQL search and record queries

- Vendor: `lakemacquariecitycouncilopenda` · version 1.0 · category Government Data · tags lake macquarie api, lake macquarie open data api, opendatasoft api, odsql api, open data records api, government open data api
- Datasource: custom HTTP routes
- Marketplace page: https://apiclay.com/api/lakemacquariecitycouncilopenda
- This document: https://apiclay.com/docs/lakemacquariecitycouncilopenda.md
- OpenAPI 3.1: https://apiclay.com/api/lakemacquariecitycouncilopenda/openapi.json
- MCP: connect https://api.apiclay.com/v1/mcp (see https://apiclay.com/llms.txt), then `apiclay_describe_api` with vendor `lakemacquariecitycouncilopenda`
- Updated: 2026-11-18

## About

## Lake Macquarie City Council Open Data API

The open data portal of Lake Macquarie City Council (New South Wales, Australia) (lakemac-newcastlenswiar.opendatasoft.com, run on Opendatasoft): about 15 datasets, for example business survey results. Search and filter the catalogue with ODSQL, read a dataset's metadata and field list, and query its records with filters, field selection, sorting, grouping and paging.

Data comes from **lakemac-newcastlenswiar.opendatasoft.com** (https://lakemac-newcastlenswiar.opendatasoft.com). Every route calls the source's own public API and returns it unchanged.

Typical flow: `/datasets?where=search("velo")&amp;limit=5` for a `dataset_id`, then `/dataset?dataset_id=` for its fields and `/records?dataset_id=&amp;limit=10&amp;where=...`.

### Routes

#### GET `/datasets` - Datasets
| Param | In | Type | Required | Description |
|---|---|---|---|---|
| where | query | string | no | ODSQL filter, e.g. `search("velo")` or `modified &gt; date'2026-01-01'`. |
| select | query | string | no | Fields to return, e.g. `dataset_id,metas`. |
| order_by | query | string | no | e.g. `modified desc`. |
| limit | query | number | no | Datasets per page (up to 100). |
| offset | query | number | no | Datasets to skip, for paging. |
| refine | query | string | no | Facet refinement, e.g. `theme:"Mobilite"`. |
| lang | query | string | no | Language for labels, e.g. `en` or `fr`. |

Returns: `total_count` and `results`: datasets with `dataset_id`, `metas.default` (`title`, `description`, `theme`, `keyword`, `modified`, `records_count`, `publisher`, `license`) and `fields`.

#### GET `/dataset` - Dataset
| Param | In | Type | Required | Description |
|---|---|---|---|---|
| dataset_id | path | string | yes | `dataset_id` from `/datasets`. |

Returns: one dataset with its `metas` and `fields` (`name`, `label`, `type`).

#### GET `/records` - Records
| Param | In | Type | Required | Description |
|---|---|---|---|---|
| dataset_id | path | string | yes | `dataset_id` from `/datasets`. |
| where | query | string | no | ODSQL filter on the dataset's fields. |
| select | query | string | no | Fields or aggregates, e.g. `count(*) as n`. |
| order_by | query | string | no | e.g. `date desc`. |
| group_by | query | string | no | Field to group by. |
| limit | query | number | no | Records per page (up to 100). |
| offset | query | number | no | Records to skip; `offset + limit` stays under 10,000. |
| refine | query | string | no | Facet refinement. |

Returns: `total_count` and `results`: one object per record keyed by field name.

### Caveats

- Text is mostly in the portal's language (French for French portals); `lang=en` translates labels only.
- Some datasets name individuals (licence holders, employees, drivers, arrestees) as published by the government; handle them under applicable privacy law.
- Each dataset carries its own licence (`metas.default.license`, often Licence Ouverte or ODbL); credit Lake Macquarie City Council (New South Wales, Australia).
- Upstream responses can change over time. Verify fields before relying on them.
- Not affiliated with or endorsed by lakemac-newcastlenswiar.opendatasoft.com.

## Pricing

- Pay as you go: 0.0012 credits/request
- Trial: 1 free requests per buyer
- Billing order: trial requests -> subscribed plan requests -> pay as you go. 1 credit's USD value is shown on the marketplace page.

## HTTP routes

Only the public, buyer-facing parts of each route are listed; vendor-side credentials stay on the gateway.

### GET /datasets — Datasets
- Gateway: `GET https://api.apiclay.com/v1/api/lakemacquariecitycouncilopenda/datasets`
- Public query params: `where` (string), `select` (string), `order_by` (string), `limit` (number), `offset` (number), `refine` (string), `lang` (string)
- Upstream proxy: ApiClay proxy paid by the vendor (data cap 2 MB per call). Fetched through an ApiClay proxy paid by the vendor; a response larger than the route's data cap fails with 502 and is refunded in full.

### GET /dataset — Dataset
- Gateway: `GET https://api.apiclay.com/v1/api/lakemacquariecitycouncilopenda/dataset`
- Public query params: `dataset_id` (string, required)
- Upstream proxy: ApiClay proxy paid by the vendor (data cap 2 MB per call). Fetched through an ApiClay proxy paid by the vendor; a response larger than the route's data cap fails with 502 and is refunded in full.

### GET /records — Records
- Gateway: `GET https://api.apiclay.com/v1/api/lakemacquariecitycouncilopenda/records`
- Public query params: `where` (string), `select` (string), `order_by` (string), `group_by` (string), `limit` (number), `offset` (number), `refine` (string), `dataset_id` (string, required)
- Upstream proxy: ApiClay proxy paid by the vendor (data cap 2 MB per call). Fetched through an ApiClay proxy paid by the vendor; a response larger than the route's data cap fails with 502 and is refunded in full.

## Call example

```bash
curl -X GET "https://api.apiclay.com/v1/api/lakemacquariecitycouncilopenda/datasets" \
  -H "token: <YOUR_APICLAY_TOKEN>"
```

Index of every published API: https://apiclay.com/llms.txt
