<!-- docs-type: reference https://diataxis.fr/reference/ -->

# CSV

This pages describes the CSV publication format, including the structure of the tables, the relationship between the tables and the representation of location data. Example CSV files and blank templates are provided for each table.

## Location data

Node locations and span routes are represented using [well-known text (WKT)](https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry) `POINT` and `LINESTRING` geometries, respectively. For example:

::::{tab-set}

:::{tab-item} Node locations

| nodes/0/location |
| --- |
| POINT (-0.174 5.625) |
| POINT (-1.628 6.711) |

:::

:::{tab-item} Span routes

| spans/0/route |
| --- |
| LINESTRING (-0.173 5.626,-0.178 5.807,-0.112 5.971,-0.211 5.963,-0.321 6.17,-0.488 6.29,-0.56 6.421,-0.752 6.533,-0.867 6.607,-1.101 6.585,-1.304 6.623,-1.461 6.727,-1.628 6.713) |

:::

::::

## Tables and relationships

The CSV format consists of the following tables, reflecting the structure of the [data model](../data_model.md):

```{contents}
---
local: true
```

The networks table is the main table. One-to-many (1:N) and many-to-many (M:N) relationships are represented as separate tables.

Rows in 'child' tables are related to rows in parent tables using the parent row's `id`.

The following example shows a network with two nodes. Note how the network's `.id` appears in both tables.

:::{card} networks table

```{csv-table-no-translate}
:header-rows: 1
:widths: auto
:file: ../../../examples/csv/networks.csv
```

:::

:::{card} nodes table

```{csv-table-no-translate}
:header-rows: 1
:widths: auto
:file: ../../../examples/csv/nodes.csv
```

:::

### networks

This table is related to the following tables:

- [nodes](#nodes): one-to-many by `id`
- [spans](#spans): one-to-many by `id`
- [phases](#phases): one-to-many by `id`
- [organisations](#organisations): one-to-many by `id`
- [wayleaves](#wayleaves): one-to-many by `id`
- [contracts](#contracts): one-to-many by `id`
- [links](#links): one-to-many by `id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/networks.csv) or a [blank template](../../../examples/csv/template/networks.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,identifier,name,website,publisher,publicationDate,collectionDate,crs,accuracy,accuracyDetails,language
:nocrossref:
```

#### nodes

This table is related to the following tables:

- [networks](#networks): many-to-one by `id`
- [nodes_internationalConnections](#nodes_internationalconnections): one-to-many by `nodes/0/id`
- [nodes_networkProviders](#nodes_networkproviders): one-to-many by `nodes/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/nodes.csv) or a [blank template](../../../examples/csv/template/nodes.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,nodes/0/id,nodes/0/name,nodes/0/phase,nodes/0/status,nodes/0/location,nodes/0/address,nodes/0/type,nodes/0/supportingInfrastructure,nodes/0/accessPoint,nodes/0/power,nodes/0/technologies,nodes/0/transmissionMediumOwner
:collapse: nodes/0/location
:nocrossref:
```

##### nodes_internationalConnections

This table is related to the following tables:

- [nodes](#nodes): many-to-one by `nodes/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/nodes_internationalConnections.csv) or a [blank template](../../../examples/csv/template/nodes_internationalConnections.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,nodes/0/id,nodes/0/internationalConnections/0/streetAddress,nodes/0/internationalConnections/0/locality,nodes/0/internationalConnections/0/region,nodes/0/internationalConnections/0/postalCode,nodes/0/internationalConnections/0/country
:nocrossref:
```

##### nodes_networkProviders

This table is related to the following tables:

- [nodes](#nodes): many-to-one by `nodes/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/nodes_networkProviders.csv) or a [blank template](../../../examples/csv/template/nodes_networkProviders.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,nodes/0/id,nodes/0/networkProviders/0/id,nodes/0/networkProviders/0/name
:nocrossref:
```

#### spans

This table is related to the following tables:

- [networks](#networks): many-to-one by `id`
- [spans_networkProviders](#spans_networkproviders): one-to-many by `spans/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/spans.csv) or a [blank template](../../../examples/csv/template/spans.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,spans/0/id,spans/0/name,spans/0/phase,spans/0/status,spans/0/readyForServiceDate,spans/0/start,spans/0/end,spans/0/directed,spans/0/route,spans/0/transmissionMediumOwner,spans/0/supplier,spans/0/transmissionMedium,spans/0/deployment,spans/0/supportingInfrastructure,spans/0/codeployment,spans/0/cableType,spans/0/darkFibre,spans/0/fibreType,spans/0/fibreTypeDetails,spans/0/fibreCount,spans/0/fibreLength,spans/0/technologies,spans/0/capacity,spans/0/capacityDetails,spans/0/wayleaves,spans/0/countries
:collapse: spans/0/route
:nocrossref:
```

##### spans_networkProviders

This table is related to the following tables:

- [spans](#spans): many-to-one by `spans/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/spans_networkProviders.csv) or a [blank template](../../../examples/csv/template/spans_networkProviders.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,spans/0/id,spans/0/networkProviders/0/id,spans/0/networkProviders/0/name
:nocrossref:
```

#### phases

This table is related to the following tables:

- [networks](#networks): many-to-one by `id`
- [phases_funders](#phases_funders): one-to-many by `phases/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/phases.csv) or a [blank template](../../../examples/csv/template/phases.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,phases/0/id,phases/0/name,phases/0/description
:nocrossref:
```

##### phases_funders

This table is related to the following tables:

- [phases](#phases): many-to-one by `phases/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/phases_funders.csv) or a [blank template](../../../examples/csv/template/phases_funders.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,phases/0/id,phases/0/funders/0/id,phases/0/funders/0/name
:nocrossref:
```

#### organisations

This table is related to the following tables:

- [networks](#networks): many-to-one by `id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/organisations.csv) or a [blank template](../../../examples/csv/template/organisations.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,organisations/0/id,organisations/0/name,organisations/0/identifier,organisations/0/country,organisations/0/roles,organisations/0/roleDetails,organisations/0/website,organisations/0/logo
:nocrossref:
```

#### wayleaves

This table is related to the following tables:

- [networks](#networks): many-to-one by `id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/wayleaves.csv) or a [blank template](../../../examples/csv/template/wayleaves.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,wayleaves/0/id,wayleaves/0/grantor,wayleaves/0/yearSigned,wayleaves/0/term,wayleaves/0/cost
:nocrossref:
```

#### contracts

This table is related to the following tables:

- [networks](#networks): many-to-one by `id`
- [contracts_documents](#contracts_documents): one-to-many by `contracts/0/id`
- [contracts_relatedPhases](#contracts_relatedphases): one-to-many by `contracts/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/contracts.csv) or a [blank template](../../../examples/csv/template/contracts.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,contracts/0/id,contracts/0/title,contracts/0/description,contracts/0/type,contracts/0/value,contracts/0/dateSigned
:nocrossref:
```

##### contracts_documents

This table is related to the following tables:

- [contracts](#contracts): many-to-one by `contracts/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/contracts_documents.csv) or a [blank template](../../../examples/csv/template/contracts_documents.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,contracts/0/id,contracts/0/documents/0/title,contracts/0/documents/0/description,contracts/0/documents/0/url,contracts/0/documents/0/format
:nocrossref:
```

##### contracts_relatedPhases

This table is related to the following tables:

- [contracts](#contracts): many-to-one by `contracts/0/id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/contracts_relatedPhases.csv) or a [blank template](../../../examples/csv/template/contracts_relatedPhases.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,contracts/0/id,contracts/0/relatedPhases/0/id,contracts/0/relatedPhases/0/name
:nocrossref:
```

#### links

This table is related to the following tables:

- [networks](#networks): many-to-one by `id`

The columns in this table are listed below. You can also download an [example CSV file](../../../examples/csv/links.csv) or a [blank template](../../../examples/csv/template/links.csv) for this table.

```{jsonschema} ../../../_readthedocs/html/network-schema.json
:include: id,links/0/href,links/0/rel
:nocrossref:
```