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=1427

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=1428",
    "previous": "https://demo.lizard.net/api/v4/culverts/?format=api&page=1426",
    "results": [
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43285/?format=api",
            "id": 43285,
            "code": "B9886",
            "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.339704167357458,
                        52.11235706803842,
                        0.0
                    ],
                    [
                        4.339502663607218,
                        52.11271822088891,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.146187Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": 1.25,
            "length": 42.49,
            "height": 1.25,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43286/?format=api",
            "id": 43286,
            "code": "B9887",
            "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.341479905638279,
                        52.11070253621644,
                        0.0
                    ],
                    [
                        4.341300063381829,
                        52.11085519490024,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.161873Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": -0.65,
            "bed_level_downstream": -0.65,
            "width": 0.5,
            "length": 20.98,
            "height": 0.5,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43287/?format=api",
            "id": 43287,
            "code": "22107451",
            "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.399001785172845,
                        52.00489675160108,
                        0.0
                    ],
                    [
                        4.399016429955229,
                        52.00486932413479,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.178018Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 3.21,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43288/?format=api",
            "id": 43288,
            "code": "21520390",
            "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.379351277705126,
                        52.02929458424785,
                        0.0
                    ],
                    [
                        4.379323319926762,
                        52.02928262364114,
                        0.0
                    ],
                    [
                        4.379380587973456,
                        52.029226997337865,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.198464Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 9.67,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43289/?format=api",
            "id": 43289,
            "code": "21520391",
            "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.380283998294963,
                        52.0296358212327,
                        0.0
                    ],
                    [
                        4.380306070995766,
                        52.029643380743,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.214187Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 1.44,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43290/?format=api",
            "id": 43290,
            "code": "21704588",
            "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.412552652465974,
                        51.963741234093526,
                        0.0
                    ],
                    [
                        4.412509610986397,
                        51.96372645945091,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.229377Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 3.38,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43291/?format=api",
            "id": 43291,
            "code": "20220638",
            "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.474230464819001,
                        51.988462173975705,
                        0.0
                    ],
                    [
                        4.47468399829379,
                        51.98840323889848,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.248073Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": -6.42,
            "bed_level_downstream": -6.42,
            "width": 0.6,
            "length": 31.84,
            "height": 0.6,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43292/?format=api",
            "id": 43292,
            "code": "20220639",
            "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.473562593690801,
                        51.988484567241876,
                        0.0
                    ],
                    [
                        4.473513322289287,
                        51.98837039722858,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.260882Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": -6.92,
            "bed_level_downstream": -6.92,
            "width": 3.5,
            "length": 13.15,
            "height": 2.5,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43293/?format=api",
            "id": 43293,
            "code": "21520409",
            "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.399775990052766,
                        52.048889622882754,
                        0.0
                    ],
                    [
                        4.399804712271557,
                        52.04890011076147,
                        0.0
                    ],
                    [
                        4.399946215528294,
                        52.04892682930407,
                        0.0
                    ],
                    [
                        4.399946215528294,
                        52.04892682930407,
                        0.0
                    ],
                    [
                        4.400279153451771,
                        52.04914931605808,
                        0.0
                    ],
                    [
                        4.400765156235325,
                        52.049496997111646,
                        0.0
                    ],
                    [
                        4.400831751254258,
                        52.0495152804998,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.276365Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": -4.89,
            "bed_level_downstream": -4.89,
            "width": 0.6,
            "length": 102.35,
            "height": 0.6,
            "material": null,
            "shape": null,
            "description": null
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/43294/?format=api",
            "id": 43294,
            "code": "21704591",
            "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.427282626230422,
                        51.975960416433644,
                        0.0
                    ],
                    [
                        4.427711682473324,
                        51.97561047098032,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-10-31T13:35:50.289670Z",
            "image_url": "",
            "timeseries": [],
            "type": "",
            "bed_level_upstream": null,
            "bed_level_downstream": null,
            "width": null,
            "length": 48.84,
            "height": null,
            "material": null,
            "shape": null,
            "description": null
        }
    ]
}