Culvert List – Django REST framework

List assets of type Culvert

Query parameters:

organisation Filter by organisation. Supports lookups on uuid and name.

code Exact filter on the code field. The (case-sensitive) startswith lookup is also supported.

created: Temporal filter on created. Supports various lookup types (exact, lt, lte, gt, gte; created__exact by default). Filter values should be specified in ISO 8601 YYYY-MM-DDThh:mm:ssZ format.

last_modified: Temporal filter on last_modified. Supports various lookup types (exact, lt, lte, gt, gte; last_modified__exact by default). Filter values should be specified in ISO 8601 YYYY-MM-DDThh:mm:ssZ format.

geometry The following lookups are available: isnull, contained, contains, contains_properly, covered_by, covers, crosses, disjoint, equals, intersects, overlaps, and within. Query geometries can be supplied as WKT, EWKT or HEXEWKB.

boundary__id: Filter on geometry of the region/boundary with the id boundary__id. For a list of regions/boundaries, see the boundary endpoint /api/v4/boundaries/

boundary__code: Filter on geometry of the region/boundary with the id boundary__code. For a list of regions/boundaries, see the boundary endpoint /api/v4/boundaries/

boundary__type: Spatial filter on geometry, whereby geometry is specified by a region/boundary object (see below) and filter operator is ST_Intersects. Available types are COUNTRY, PROVINCE, WATER_BOARD, MUNICIPALITY, CATCHMENT, POLDER, FIXED_DRAINAGE_LEVEL_AREA, PUMPED_DRAINAGE_AREA, MAIN_PUMPED_DRAINAGE_AREA, DISTRICT, NEIGHBOURHOOD, CADASTRE, PLANTATION, FIELD, CITY, and CUSTOM

boundary__name: Filter on name of the region/boundary with the name boundary__name. Requires boundary__type. For a list of regions/boundaries, see the boundary endpoint /api/v4/boundaries/

simplify: Simplify the query geometries (in WGS84) using this value as tolerance. A higher value may result in a better response time for detailed geometries. Defaults to 0.00001 degrees (approx. 1 meter). NB: Returned geometries are unaffected.

page_size The number of results on a single page. Defaults to 10, maximum is 100. Note that pagination is disabled for the root endpoint: the response will be truncated to page_size.

Custom route: search

Full-text search in 'code' and 'name' fields. Results are ranked.

Examples:

?code=ABC_2123

?code__startswith=ABC

?created__gte=2017-01-01T00:00:00Z

?last_modified__lt=2018-01-01T00:00:00Z

?organisation__name__startswith=Nelen

?organisation__uuid=61f5a464-c350-44c1-9bc7-d4b42d7f58cb

?organisation__name__icontains=Schuur

?geometry__intersects=POINT (5 52)

?boundary__id=198

?boundary__code=NL_GM0344

?boundary__type=PROVINCE&boundary__name=Utrecht

/search/abc/

GET /api/v4/culverts/?format=api&page=1419

HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 14497,
    "next": "https://demo.lizard.net/api/v4/culverts/?format=api&page=1420",
    "previous": "https://demo.lizard.net/api/v4/culverts/?format=api&page=1418",
    "results": [
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43205/?format=api",
            "id": 43205,
            "code": "11105508",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.31182051816362,
                        51.96945855492967,
                        0.0
                    ],
                    [
                        4.311832603732334,
                        51.96941942000206,
                        0.0
                    ],
                    [
                        4.311869019470201,
                        51.969310556094754,
                        0.0
                    ],
                    [
                        4.311879629100465,
                        51.969263776115646,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.767257Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": -3.7,
            "bed_level_downstream": -3.7,
            "width": 0.6,
            "length": 22.06,
            "height": 0.6,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43206/?format=api",
            "id": 43206,
            "code": "21310311",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.440427174557757,
                        52.00307181283153,
                        0.0
                    ],
                    [
                        4.440353432677298,
                        52.00295414208378,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.795377Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": 0.6,
            "length": 14.04,
            "height": 0.6,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43207/?format=api",
            "id": 43207,
            "code": "20220644",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.478840102050467,
                        52.0263491946909,
                        0.0
                    ],
                    [
                        4.478928022680447,
                        52.02619480161815,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.813353Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 18.21,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43208/?format=api",
            "id": 43208,
            "code": "30607095",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.139735496709555,
                        52.001358825601585,
                        0.0
                    ],
                    [
                        4.139896560776434,
                        52.00111012439527,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.829970Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 29.8,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43209/?format=api",
            "id": 43209,
            "code": "22107452",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.405349327767462,
                        52.01010873136407,
                        0.0
                    ],
                    [
                        4.405333162447876,
                        52.010135850273294,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.845558Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": 2.04,
            "bed_level_downstream": 2.04,
            "width": 0.5,
            "length": 3.21,
            "height": 0.5,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43210/?format=api",
            "id": 43210,
            "code": "40704733",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.315550348228319,
                        52.018255408798495,
                        0.0
                    ],
                    [
                        4.315493820876962,
                        52.018319352892085,
                        0.0
                    ],
                    [
                        4.315469678526182,
                        52.018346216360534,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.862263Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": -1.15,
            "bed_level_downstream": -1.15,
            "width": 2.0,
            "length": 11.52,
            "height": 1.3,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43211/?format=api",
            "id": 43211,
            "code": "10207138",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.304622372038663,
                        51.93441502845621,
                        0.0
                    ],
                    [
                        4.304744814051067,
                        51.934478049811155,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.877619Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 10.05,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43212/?format=api",
            "id": 43212,
            "code": "10207136",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.304357200292755,
                        51.934466969257855,
                        0.0
                    ],
                    [
                        4.304266116318082,
                        51.93442026874885,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.894259Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 8.14,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43213/?format=api",
            "id": 43213,
            "code": "10207133",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.297130727066099,
                        51.9310776751329,
                        0.0
                    ],
                    [
                        4.297218243936027,
                        51.93112518417994,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.909828Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 8.01,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43214/?format=api",
            "id": 43214,
            "code": "10207137",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/2cdbf687-dc6f-4898-9ce3-316c828a2121/?format=api",
                "uuid": "2cdbf687-dc6f-4898-9ce3-316c828a2121",
                "name": "Hoogheemraadschap van Delfland"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.304653993091204,
                        51.93424095246618,
                        0.0
                    ],
                    [
                        4.304565819414112,
                        51.934185730518145,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:48.925243Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 8.63,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        }
    ]
}