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

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=6",
    "previous": "https://demo.lizard.net/api/v4/culverts/?format=api&page=4",
    "results": [
        {
            "url": "https://demo.lizard.net/api/v4/culverts/14331/?format=api",
            "id": 14331,
            "code": "KDU-Q-9876",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        5.11782063603377,
                        52.76018386162414,
                        0.0
                    ],
                    [
                        5.117660620093913,
                        52.760154301736506,
                        0.0
                    ],
                    [
                        5.117500811540728,
                        52.76012477804979,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-07-18T10:18:46.579023Z",
            "created": "2014-08-08T08:15:42.611441Z",
            "image_url": "",
            "timeseries": [],
            "type": "0",
            "bed_level_upstream": -2.3,
            "bed_level_downstream": -3.8,
            "width": 1.1,
            "length": 22.0,
            "height": null,
            "material": 0,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/14340/?format=api",
            "id": 14340,
            "code": "KDU-Q-9919",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        5.117811012755043,
                        52.76019498350269,
                        0.0
                    ],
                    [
                        5.117657559813465,
                        52.760167757039255,
                        0.0
                    ],
                    [
                        5.117500718375643,
                        52.760139929581094,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-08-08T08:15:42.672933Z",
            "image_url": "",
            "timeseries": [
                "https://demo.lizard.net/api/v4/timeseries/efef97b2-349d-4857-b924-c05bf0119eb6/?format=api"
            ],
            "type": "0",
            "bed_level_upstream": -2.3,
            "bed_level_downstream": -3.8,
            "width": 1.1,
            "length": 22.0,
            "height": null,
            "material": 0,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/14395/?format=api",
            "id": 14395,
            "code": "KDU-Q-9213",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        5.261351409138936,
                        52.70902331403743,
                        0.0
                    ],
                    [
                        5.261422366838464,
                        52.70902566263528,
                        0.0
                    ],
                    [
                        5.261536082645557,
                        52.70902942229464,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-07-18T10:18:46.010564Z",
            "created": "2014-08-08T08:15:43.061652Z",
            "image_url": "",
            "timeseries": [
                "https://demo.lizard.net/api/v4/timeseries/88d828f7-ba85-4fc4-91b1-a1b630e91b37/?format=api"
            ],
            "type": "0",
            "bed_level_upstream": -3.38,
            "bed_level_downstream": -3.38,
            "width": 0.6,
            "length": 13.0,
            "height": null,
            "material": 0,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/14505/?format=api",
            "id": 14505,
            "code": "KDU-Q-13304",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        5.244968190116795,
                        52.68329498579225,
                        0.0
                    ],
                    [
                        5.245507645756962,
                        52.68327445557656,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-07-18T10:18:51.830229Z",
            "created": "2014-08-08T08:15:44.010967Z",
            "image_url": "",
            "timeseries": [],
            "type": "0",
            "bed_level_upstream": -2.9,
            "bed_level_downstream": -2.55,
            "width": 0.6,
            "length": 35.0,
            "height": null,
            "material": 0,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/14924/?format=api",
            "id": 14924,
            "code": "KDU-Q-2025",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.812152666292656,
                        52.83238119336068,
                        0.0
                    ],
                    [
                        4.812461607815264,
                        52.832497416564244,
                        0.0
                    ]
                ]
            },
            "last_modified": "2020-10-23T11:50:25.804819Z",
            "created": "2014-08-08T08:15:48.927164Z",
            "image_url": "",
            "timeseries": [
                "https://demo.lizard.net/api/v4/timeseries/122fa460-a69d-4444-af5e-95ab37c225e2/?format=api"
            ],
            "type": "0",
            "bed_level_upstream": -1.2,
            "bed_level_downstream": -1.2,
            "width": 0.6,
            "length": 9.5,
            "height": null,
            "material": 0,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/14945/?format=api",
            "id": 14945,
            "code": "KDU-Q-7445",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.720164668776305,
                        52.78271791430823,
                        0.0
                    ],
                    [
                        4.720122286182398,
                        52.78265897419944,
                        0.0
                    ],
                    [
                        4.72006335265422,
                        52.78257829181505,
                        0.0
                    ],
                    [
                        4.719960977760725,
                        52.78243816003001,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-06-25T07:20:51.659166Z",
            "created": "2014-08-08T08:15:49.175688Z",
            "image_url": "",
            "timeseries": [
                "https://demo.lizard.net/api/v4/timeseries/3d4eedab-887a-4105-9501-ead5ea3380ce/?format=api",
                "https://demo.lizard.net/api/v4/timeseries/5dc52f1d-96c6-4065-baec-898548ef39b3/?format=api"
            ],
            "type": "0",
            "bed_level_upstream": -1.27,
            "bed_level_downstream": -1.11,
            "width": 0.5,
            "length": 8.55,
            "height": null,
            "material": 0,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/15427/?format=api",
            "id": 15427,
            "code": "KDU-Q-12472",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        5.085230680646898,
                        52.68568980660804,
                        0.0
                    ],
                    [
                        5.08531022290968,
                        52.685723080461415,
                        0.0
                    ],
                    [
                        5.085569525065746,
                        52.68583154564687,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-07-18T10:18:39.250314Z",
            "created": "2014-08-08T08:15:54.294184Z",
            "image_url": "",
            "timeseries": [],
            "type": "0",
            "bed_level_upstream": -2.84,
            "bed_level_downstream": -3.29,
            "width": 1.0,
            "length": 28.1,
            "height": null,
            "material": 3,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/15447/?format=api",
            "id": 15447,
            "code": "KDU-Q-11372",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.884010188848172,
                        52.632635162598575,
                        0.0
                    ],
                    [
                        4.883711131992342,
                        52.632476387017526,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-07-18T10:18:46.306058Z",
            "created": "2014-08-08T08:15:54.438127Z",
            "image_url": "",
            "timeseries": [
                "https://demo.lizard.net/api/v4/timeseries/fa8784c0-f7c5-4717-8bb8-121401119bd6/?format=api"
            ],
            "type": "0",
            "bed_level_upstream": -1.0,
            "bed_level_downstream": -4.2,
            "width": 0.3,
            "length": 22.75,
            "height": null,
            "material": 0,
            "shape": 1,
            "description": ""
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/18535/?format=api",
            "id": 18535,
            "code": "KDU-Q-6957",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.752925667211795,
                        52.79947133516766,
                        0.0
                    ],
                    [
                        4.752786373696095,
                        52.799578041420574,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-07-18T10:18:51.466394Z",
            "created": "2014-08-08T08:16:23.676693Z",
            "image_url": "",
            "timeseries": [
                "https://demo.lizard.net/api/v4/timeseries/5611735b-eea7-42ad-a6a6-415e55576420/?format=api"
            ],
            "type": "0",
            "bed_level_upstream": -1.26,
            "bed_level_downstream": -1.21,
            "width": 0.7,
            "length": 15.0,
            "height": null,
            "material": 0,
            "shape": 2,
            "description": "Meetopdracht legger primair 2007\nDiameter wordt nog nagemeten door landmeters HHNK => hoogte = 0,5 breedte = 0,7\n"
        },
        {
            "url": "https://demo.lizard.net/api/v4/culverts/20713/?format=api",
            "id": 20713,
            "code": "KDU-Q-1837",
            "organisation": {
                "url": "https://demo.lizard.net/api/v4/organisations/474afd21-2f2e-4b4f-8261-5142f1d67acb/?format=api",
                "uuid": "474afd21-2f2e-4b4f-8261-5142f1d67acb",
                "name": "Hoogheemraadschap Hollands Noorderkwartier"
            },
            "geometry": {
                "type": "LineString",
                "coordinates": [
                    [
                        4.786477882733615,
                        52.929181131784276,
                        0.0
                    ],
                    [
                        4.786529343601612,
                        52.92919371109801,
                        0.0
                    ],
                    [
                        4.786584213590017,
                        52.929207116318366,
                        0.0
                    ]
                ]
            },
            "last_modified": "2019-07-18T10:18:46.626079Z",
            "created": "2014-08-08T08:16:46.042724Z",
            "image_url": "",
            "timeseries": [],
            "type": "0",
            "bed_level_upstream": -1.98,
            "bed_level_downstream": -2.01,
            "width": 2.0,
            "length": 7.7,
            "height": null,
            "material": 3,
            "shape": 2,
            "description": "inlaat, uitlaat dmv wachtkleppen"
        }
    ]
}