Name: AGENTS.md
Size: 12.03 KB
Content Type: text/markdown; charset=utf-8
Last Modified: 2 Aug 2026
Source URL: https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/AGENTS.md
Cloud URI: s3://us-west-2.opendata.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/AGENTS.md

Download

National Road Network (NWB Wegen) — Rijkswaterstaat / Netherlands

What This Dataset Is

The complete Dutch National Road Network (Nationaal Wegenbestand, NWB) — 1,626,321 road segments covering every road in the Netherlands, from motorways (A-roads) to local residential streets. Each record is a road segment (wegvak) with detailed attributes including street name, place name, municipality, road number, road type, driving direction, road manager, and kilometer markers.

The NWB is the authoritative road reference dataset for the Netherlands, maintained by Rijkswaterstaat and updated monthly. It is used for traffic management, navigation, road infrastructure planning, and spatial analysis across government and industry.

Source: https://service.pdok.nl/rws/nationaal-wegenbestand-wegen/atom/index.xml Provider: Rijkswaterstaat (RWS, part of the Ministry of Infrastructure and Water Management) License: CC0 (public domain) Update frequency: Monthly

How to Access

This is a GeoParquet file in EPSG:28992 (Amersfoort / RD New), the Dutch national coordinate reference system. The file is 779 MB. Use DuckDB with the spatial extension for efficient querying — DuckDB can stream the file via HTTP range requests without downloading the entire 779 MB.

Important: The geometry is in EPSG:28992 (metres), not WGS84. For lat/lon coordinates, transform with ST_Transform(ST_GeomFromWKB(geom), 'EPSG:28992', 'EPSG:4326') in DuckDB.

Schema — Field Meanings (Dutch to English)

Field	Type	Dutch	English Meaning
`wvk_id`	double	Wegvak ID	Road segment ID (unique identifier)
`wvk_begdat`	string	Wegvak begindatum	Segment start date
`jte_id_beg`	double	Junctie ID begin	Junction ID at start of segment
`jte_id_end`	double	Junctie ID eind	Junction ID at end of segment
`wegbehsrt`	string	Wegbeheerder soort	Road manager type: R=Rijk (national), P=Provincie, G=Gemeente (municipality), W=Waterschap (water board)
`wegbehcode`	string	Wegbeheerder code	Road manager code
`wegbehnaam`	string	Wegbeheerder naam	Road manager name (e.g., "Rijkswaterstaat", "Gemeente Amsterdam")

Important Columns

The columns you'll use most often:

stt_naam — street name (most queries start here)
wpsnaam — place name (town/city)
gme_id / gme_naam — municipality code and name
wegnummer — road number (A1, N50, etc.) for highways and provincial roads
wegtype / wgtype_oms — road type code and description
wegbehsrt — road manager type (R/P/G/W) for filtering by governance level
rijrichtng — driving direction
st_lengthshape — segment length in metres
routeltr / routenr — route letter and number (for highways)
geom — road segment geometry

Geometry Notes

CRS is EPSG:28992 (Amersfoort / RD New) — the standard Dutch national grid in metres. This is NOT WGS84. To get lat/lon, transform to EPSG:4326.
Geometry column is named geom (not geometry)
All geometries are MultiLineString
Bounding box in WGS84: approximately [3.21, 50.73, 7.24, 53.58] (all of Netherlands)
Coordinates are in metres (Dutch RD), not degrees

Road Type Categories

The wgtype_oms field contains these road type descriptions:

Dutch	English
autosnelweg	Motorway (A-road)
autoweg	Expressway
regionale weg	Regional road
lokale weg	Local road
straat	Street
overig	Other

Road Manager Types

The wegbehsrt field indicates who manages the road:

Code	Dutch	English
R	Rijk	National government (Rijkswaterstaat) — motorways and national roads
P	Provincie	Province — provincial roads (N-roads)
G	Gemeente	Municipality — local roads and streets
W	Waterschap	Water board — roads on dikes and water infrastructure

Useful Query Patterns

Find roads by street name

Find all roads in a municipality

List all highway segments (A-roads / motorways)

Total road length by road type

Total road length by road manager type

Find all roads with a specific road number (e.g., A1)

Note: Road numbers may be zero-padded (e.g., 'A001' instead of 'A1'). Check with:

Roads in a specific place (town/city)

Spatial query — roads near a point (requires coordinate transform)

Count roads per municipality

Load into GeoPandas

CBS Gebiedsindelingen (bestuurlijke_gebieden): Municipality boundaries with gme_id codes that match this dataset's gme_id field. Use for spatial joins or to get municipality polygons for the roads. URL: https://data.source.coop/cholmes/portolan-nl/cbs/gebiedsindelingen/

Caveats

EPSG:28992 coordinates: Geometry is in the Dutch national grid (metres), not WGS84. All spatial queries with lat/lon coordinates require a coordinate transform.
Geometry column is named geom, not geometry — adjust queries accordingly.
Large file (779 MB): DuckDB can stream it efficiently via HTTP range requests. For GeoPandas, consider selecting only the columns you need.
Road numbers may be zero-padded: e.g., 'A001' instead of 'A1'. Always check the actual values with a DISTINCT query before filtering.
Monthly updates: The NWB is updated monthly by Rijkswaterstaat. This copy is a point-in-time snapshot; check the source for the latest version.
MultiLineString geometry: All geometries are MultiLineString, even for simple single-part line segments.
Street names may be null: Not all road segments have a street name (stt_naam), especially motorway segments. Use wegnummer for highways.
st_lengthshape is in metres: Since the CRS is EPSG:28992 (metric), the length field is already in metres — no conversion needed.

Hand-maintained agent guide (ported from this collection's llms.txt in August 2026). Update it alongside collection.json.

National Road Network (NWB Wegen) — Rijkswaterstaat / Netherlands

What This Dataset Is

How to Access

Important: The geometry is in EPSG:28992 (metres), not WGS84. For lat/lon coordinates, transform with ST_Transform(ST_GeomFromWKB(geom), 'EPSG:28992', 'EPSG:4326') in DuckDB.

Schema — Field Meanings (Dutch to English)

Field	Type	Dutch	English Meaning
`wvk_id`	double	Wegvak ID	Road segment ID (unique identifier)
`wvk_begdat`	string	Wegvak begindatum	Segment start date
`jte_id_beg`	double	Junctie ID begin	Junction ID at start of segment
`jte_id_end`	double	Junctie ID eind	Junction ID at end of segment
`wegbehsrt`	string	Wegbeheerder soort	Road manager type: R=Rijk (national), P=Provincie, G=Gemeente (municipality), W=Waterschap (water board)
`wegbehcode`	string	Wegbeheerder code	Road manager code
`wegbehnaam`	string	Wegbeheerder naam	Road manager name (e.g., "Rijkswaterstaat", "Gemeente Amsterdam")

Important Columns

The columns you'll use most often:

stt_naam — street name (most queries start here)
wpsnaam — place name (town/city)
gme_id / gme_naam — municipality code and name
wegnummer — road number (A1, N50, etc.) for highways and provincial roads
wegtype / wgtype_oms — road type code and description
wegbehsrt — road manager type (R/P/G/W) for filtering by governance level
rijrichtng — driving direction
st_lengthshape — segment length in metres
routeltr / routenr — route letter and number (for highways)
geom — road segment geometry

Geometry Notes

CRS is EPSG:28992 (Amersfoort / RD New) — the standard Dutch national grid in metres. This is NOT WGS84. To get lat/lon, transform to EPSG:4326.
Geometry column is named geom (not geometry)
All geometries are MultiLineString
Bounding box in WGS84: approximately [3.21, 50.73, 7.24, 53.58] (all of Netherlands)
Coordinates are in metres (Dutch RD), not degrees

Road Type Categories

The wgtype_oms field contains these road type descriptions:

Dutch	English
autosnelweg	Motorway (A-road)
autoweg	Expressway
regionale weg	Regional road
lokale weg	Local road
straat	Street
overig	Other

Road Manager Types

The wegbehsrt field indicates who manages the road:

Code	Dutch	English
R	Rijk	National government (Rijkswaterstaat) — motorways and national roads
P	Provincie	Province — provincial roads (N-roads)
G	Gemeente	Municipality — local roads and streets
W	Waterschap	Water board — roads on dikes and water infrastructure

Useful Query Patterns

Find roads by street name

Find all roads in a municipality

List all highway segments (A-roads / motorways)

Total road length by road type

Total road length by road manager type

Find all roads with a specific road number (e.g., A1)

Note: Road numbers may be zero-padded (e.g., 'A001' instead of 'A1'). Check with:

Roads in a specific place (town/city)

Spatial query — roads near a point (requires coordinate transform)

Count roads per municipality

Load into GeoPandas

CBS Gebiedsindelingen (bestuurlijke_gebieden): Municipality boundaries with gme_id codes that match this dataset's gme_id field. Use for spatial joins or to get municipality polygons for the roads. URL: https://data.source.coop/cholmes/portolan-nl/cbs/gebiedsindelingen/

Caveats

EPSG:28992 coordinates: Geometry is in the Dutch national grid (metres), not WGS84. All spatial queries with lat/lon coordinates require a coordinate transform.
Geometry column is named geom, not geometry — adjust queries accordingly.
Large file (779 MB): DuckDB can stream it efficiently via HTTP range requests. For GeoPandas, consider selecting only the columns you need.
Road numbers may be zero-padded: e.g., 'A001' instead of 'A1'. Always check the actual values with a DISTINCT query before filtering.
Monthly updates: The NWB is updated monthly by Rijkswaterstaat. This copy is a point-in-time snapshot; check the source for the latest version.
MultiLineString geometry: All geometries are MultiLineString, even for simple single-part line segments.
Street names may be null: Not all road segments have a street name (stt_naam), especially motorway segments. Use wegnummer for highways.
st_lengthshape is in metres: Since the CRS is EPSG:28992 (metric), the length field is already in metres — no conversion needed.

Hand-maintained agent guide (ported from this collection's llms.txt in August 2026). Update it alongside collection.json.

1import duckdb
2
3con = duckdb.connect()
4con.execute("INSTALL spatial; LOAD spatial;")
5
6URL = 'https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet'
7
8df = con.execute(f"""
9    SELECT * FROM read_parquet('{URL}')
10    LIMIT 5
11""").df()

1import duckdb
2
3con = duckdb.connect()
4con.execute("INSTALL spatial; LOAD spatial;")
5
6URL = 'https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet'
7
8df = con.execute(f"""
9    SELECT * FROM read_parquet('{URL}')
10    LIMIT 5
11""").df()

1INSTALL spatial; LOAD spatial;
2
3SELECT stt_naam, wpsnaam, gme_naam, wgtype_oms, st_lengthshape
4FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
5WHERE stt_naam = 'Kalverstraat'

1INSTALL spatial; LOAD spatial;
2
3SELECT stt_naam, wpsnaam, gme_naam, wgtype_oms, st_lengthshape
4FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
5WHERE stt_naam = 'Kalverstraat'

1SELECT stt_naam, wpsnaam, wgtype_oms, wegnummer,
2       SUM(st_lengthshape) AS total_length_m
3FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
4WHERE gme_naam = 'Amsterdam'
5GROUP BY stt_naam, wpsnaam, wgtype_oms, wegnummer
6ORDER BY total_length_m DESC
7LIMIT 20

1SELECT stt_naam, wpsnaam, wgtype_oms, wegnummer,
2       SUM(st_lengthshape) AS total_length_m
3FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
4WHERE gme_naam = 'Amsterdam'
5GROUP BY stt_naam, wpsnaam, wgtype_oms, wegnummer
6ORDER BY total_length_m DESC
7LIMIT 20

1SELECT wegnummer, stt_naam, gme_naam, beginkm, eindkm, st_lengthshape
2FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
3WHERE routeltr = 'A'
4ORDER BY wegnummer, beginkm
5LIMIT 50

1SELECT wegnummer, stt_naam, gme_naam, beginkm, eindkm, st_lengthshape
2FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
3WHERE routeltr = 'A'
4ORDER BY wegnummer, beginkm
5LIMIT 50

1SELECT wgtype_oms,
2       COUNT(*) AS segment_count,
3       ROUND(SUM(st_lengthshape) / 1000, 1) AS total_km
4FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
5GROUP BY wgtype_oms
6ORDER BY total_km DESC

1SELECT wgtype_oms,
2       COUNT(*) AS segment_count,
3       ROUND(SUM(st_lengthshape) / 1000, 1) AS total_km
4FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
5GROUP BY wgtype_oms
6ORDER BY total_km DESC

1SELECT wegbehsrt,
2       CASE wegbehsrt
3           WHEN 'R' THEN 'Rijkswaterstaat (national)'
4           WHEN 'P' THEN 'Provincie (provincial)'
5           WHEN 'G' THEN 'Gemeente (municipal)'
6           WHEN 'W' THEN 'Waterschap (water board)'
7           ELSE 'Other'
8       END AS manager_type,
9       COUNT(*) AS segments,
10       ROUND(SUM(st_lengthshape) / 1000, 1) AS total_km
11FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
12GROUP BY wegbehsrt
13ORDER BY total_km DESC

1SELECT wegbehsrt,
2       CASE wegbehsrt
3           WHEN 'R' THEN 'Rijkswaterstaat (national)'
4           WHEN 'P' THEN 'Provincie (provincial)'
5           WHEN 'G' THEN 'Gemeente (municipal)'
6           WHEN 'W' THEN 'Waterschap (water board)'
7           ELSE 'Other'
8       END AS manager_type,
9       COUNT(*) AS segments,
10       ROUND(SUM(st_lengthshape) / 1000, 1) AS total_km
11FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
12GROUP BY wegbehsrt
13ORDER BY total_km DESC

1SELECT wegnummer, stt_naam, gme_naam, wgtype_oms,
2       rijrichtng, beginkm, eindkm, st_lengthshape
3FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
4WHERE wegnummer = 'A001'
5ORDER BY beginkm

1SELECT wegnummer, stt_naam, gme_naam, wgtype_oms,
2       rijrichtng, beginkm, eindkm, st_lengthshape
3FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
4WHERE wegnummer = 'A001'
5ORDER BY beginkm

1SELECT DISTINCT wegnummer
2FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
3WHERE wegnummer LIKE 'A%'
4ORDER BY wegnummer
5LIMIT 20

1SELECT DISTINCT wegnummer
2FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
3WHERE wegnummer LIKE 'A%'
4ORDER BY wegnummer
5LIMIT 20

1SELECT stt_naam, wgtype_oms, wegnummer,
2       ROUND(SUM(st_lengthshape), 1) AS length_m
3FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
4WHERE wpsnaam = 'Utrecht'
5GROUP BY stt_naam, wgtype_oms, wegnummer
6ORDER BY length_m DESC
7LIMIT 20

1SELECT stt_naam, wgtype_oms, wegnummer,
2       ROUND(SUM(st_lengthshape), 1) AS length_m
3FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
4WHERE wpsnaam = 'Utrecht'
5GROUP BY stt_naam, wgtype_oms, wegnummer
6ORDER BY length_m DESC
7LIMIT 20

1INSTALL spatial; LOAD spatial;
2
3-- Find roads within 500 metres of Amsterdam Centraal Station
4-- First convert WGS84 point to EPSG:28992
5SELECT stt_naam, wpsnaam, wgtype_oms, st_lengthshape
6FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
7WHERE ST_Distance(
8    ST_GeomFromWKB(geom),
9    ST_Transform(ST_Point(4.9003, 52.3792), 'EPSG:4326', 'EPSG:28992')
10) < 500

1INSTALL spatial; LOAD spatial;
2
3-- Find roads within 500 metres of Amsterdam Centraal Station
4-- First convert WGS84 point to EPSG:28992
5SELECT stt_naam, wpsnaam, wgtype_oms, st_lengthshape
6FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
7WHERE ST_Distance(
8    ST_GeomFromWKB(geom),
9    ST_Transform(ST_Point(4.9003, 52.3792), 'EPSG:4326', 'EPSG:28992')
10) < 500

1SELECT gme_naam, gme_id,
2       COUNT(*) AS segment_count,
3       ROUND(SUM(st_lengthshape) / 1000, 1) AS total_km
4FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
5WHERE gme_naam IS NOT NULL
6GROUP BY gme_naam, gme_id
7ORDER BY total_km DESC
8LIMIT 20

1SELECT gme_naam, gme_id,
2       COUNT(*) AS segment_count,
3       ROUND(SUM(st_lengthshape) / 1000, 1) AS total_km
4FROM read_parquet('https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet')
5WHERE gme_naam IS NOT NULL
6GROUP BY gme_naam, gme_id
7ORDER BY total_km DESC
8LIMIT 20

1import geopandas as gpd
2
3# Select specific columns to reduce memory usage (full file is 779 MB)
4gdf = gpd.read_parquet(
5    'https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet',
6    columns=['wvk_id', 'stt_naam', 'wpsnaam', 'gme_naam', 'wegnummer',
7             'wgtype_oms', 'st_lengthshape', 'geom']
8)
9# CRS will be EPSG:28992 — transform if needed:
10# gdf = gdf.to_crs(epsg=4326)

1import geopandas as gpd
2
3# Select specific columns to reduce memory usage (full file is 779 MB)
4gdf = gpd.read_parquet(
5    'https://data.source.coop/cholmes/portolan-nl/rijkswaterstaat/nwb_wegen/nwb_wegen.parquet',
6    columns=['wvk_id', 'stt_naam', 'wpsnaam', 'gme_naam', 'wegnummer',
7             'wgtype_oms', 'st_lengthshape', 'geom']
8)
9# CRS will be EPSG:28992 — transform if needed:
10# gdf = gdf.to_crs(epsg=4326)

Dutch Portolan Demo

Dutch Portolan Demo

National Road Network (NWB Wegen) — Rijkswaterstaat / Netherlands

What This Dataset Is

How to Access

Schema — Field Meanings (Dutch to English)

Important Columns

Geometry Notes

Road Type Categories

Road Manager Types

Useful Query Patterns

Find roads by street name

Find all roads in a municipality

List all highway segments (A-roads / motorways)

Total road length by road type

Total road length by road manager type

Find all roads with a specific road number (e.g., A1)

Roads in a specific place (town/city)

Spatial query — roads near a point (requires coordinate transform)

Count roads per municipality

Load into GeoPandas

Related Datasets

Caveats

National Road Network (NWB Wegen) — Rijkswaterstaat / Netherlands

What This Dataset Is

How to Access

Schema — Field Meanings (Dutch to English)

Important Columns

Geometry Notes

Road Type Categories

Road Manager Types

Useful Query Patterns

Find roads by street name

Find all roads in a municipality

List all highway segments (A-roads / motorways)

Total road length by road type

Total road length by road manager type

Find all roads with a specific road number (e.g., A1)

Roads in a specific place (town/city)

Spatial query — roads near a point (requires coordinate transform)

Count roads per municipality

Load into GeoPandas

Related Datasets

Caveats