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) POINT and LINESTRING geometries, respectively. For example:

nodes/0/location

POINT (-0.174 5.625)

POINT (-1.628 6.711)

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:

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.

networks table

id

identifier

name

website

publisher/name

publisher/identifier/id

publisher/identifier/scheme

publisher/identifier/legalName

publisher/identifier/uri

publicationDate

collectionDate

crs/name

crs/uri

accuracy

accuracyDetails

language

a096d627-72e1-4f9b-b129-951b1737bff4

Ghana Fibre Network

http://example.com/network

FibreCo

CS111111111

GH-RGD

FibreCo Ghana Limited

https://example.com/companies/CS111111111

2022-01-01

2021-09-30

urn:ogc:def:crs:OGC::CRS84

http://www.opengis.net/def/crs/OGC/1.3/CRS84

250

Measured according to the US National Standard for Spatial Data Accuracy.

en
nodes table

id

nodes/0/id

nodes/0/name

nodes/0/phase/id

nodes/0/phase/name

nodes/0/status

nodes/0/location

nodes/0/address/streetAddress

nodes/0/address/locality

nodes/0/address/region

nodes/0/address/postalCode

nodes/0/address/country

nodes/0/type

nodes/0/supportingInfrastructure/type

nodes/0/supportingInfrastructure/description

nodes/0/supportingInfrastructure/owner/id

nodes/0/supportingInfrastructure/owner/name

nodes/0/supportingInfrastructure/spareCapacity

nodes/0/accessPoint

nodes/0/power

nodes/0/technologies

nodes/0/transmissionMediumOwner/id

nodes/0/transmissionMediumOwner/name

a096d627-72e1-4f9b-b129-951b1737bff4

1

Accra

1

NextGen Phase 1

operational

POINT (-0.174 5.625)

Boundary Rd

Shiashie

Accra

12345

GH

pop

building

GH-RGD-CS111111111

FibreCo

True

True

True

ip

GH-RGD-CS111111111

FibreCo

a096d627-72e1-4f9b-b129-951b1737bff4

2

Kumasi

1

NextGen Phase 1

operational

POINT (-1.628 6.711)

Kejetia Road

Bantama

Kumasi

00000

GH

pop

building

GH-RGD-CS111111111

FibreCo

True

False

True

ip

GH-RGD-CS111111111

FibreCo

networks

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
identifier

string

Identifier

A local identifier for this network in an internal system.
name

string

Network name

A name for this network.
website

string

iri

Website

The URL of the website for this network.
publisher

object

Publisher

The publisher of this network.
publisher/name

string

Name

A name for this organisation.
publisher/identifier

object

Organisation identifier

An identifier for this organisation.
publisher/identifier/id

string

Identifier

The identifier assigned to the organisation in the register identified in .scheme.
publisher/identifier/scheme

string

Scheme

The register from which the identifier in .id is drawn, from the open organisationIdentifierScheme codelist.
publisher/identifier/legalName

string

Legal name

The legally registered name of the organisation
publisher/identifier/uri

string

iri

URI

A canonical URI for this identifier, such as those provided by Open Corporates. Do not use this field to provide the website of the organisation: instead, use Organisation.website.
publicationDate

string

date

Publication date

The date when this network was published.
collectionDate

string

date

Collection date

The date when the location data was collected. If a dataset was produced by digitising a map, the date that the data for the map was collected.
crs

object

Coordinate reference system

The coordinate reference system used in this network. If this network includes any coordinate data (in Node.location or Span.route) then this field must be provided.
crs/name

string

uri

Required

Name

The name of the coordinate reference system.
crs/uri

string

uri

Required

Uniform Resource Identifier

A URI for the coordinate reference system.
accuracy

number

Accuracy

The horizontal uncertainty, in metres, of the coordinates in this dataset relative to the datum of the coordinate reference system specified in crs. Further details about the accuracy of coordinates in this dataset can be provided in .accuracyDetails.
accuracyDetails

string

Accuracy details

Further details about the accuracy specified in accuracy. For example, the confidence level of the accuracy measurement, the methodology used to calculate the accuracy, or a local classification of accuracy.
language

string

Language

The default language used in text attributes,from the open language codelist. A BCP47 language tag is allowed, if there is a user need for the additional information.

nodes

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
nodes/0/id

string

Required

Identifier

A locally-unique identifier for this node.
nodes/0/name

string

Name

A name for this node. The name should be unique amongst the nodes belonging to a network.
nodes/0/phase

object

Phase

The phase to which this node belongs.
nodes/0/phase/id

string

Required

Identifier

The identifier of the phase being referenced.
nodes/0/phase/name

string

Name

The name of the phase being referenced. This must match the name of the phase referenced in .id.
nodes/0/status

string

Status

The status of this node, from the closed nodeStatus codelist.
nodes/0/location

object

Location

The physical location of this node.
nodes/0/address

object

Address

The physical address of this node.
nodes/0/address/streetAddress

string

Street address

The street address. For example, 1600 Amphitheatre Pkwy.
nodes/0/address/locality

string

Locality

The locality. For example, Mountain View.
nodes/0/address/region

string

Region

The region. For example, CA.
nodes/0/address/postalCode

string

Postal code

The postal code. For example, 94043.
nodes/0/address/country

string

Country

The country in which the address is physically located, from the closed country codelist.
nodes/0/type

array[[string]]

Type

This node’s function, from the open [nodeType codelist]https://standard.ofds.info/en/latest/reference/codelists#nodetype). For nodes with multiple network providers, the union of the node types for each provider. If a node’s only function is to serve as a junction between spans, this attribute should be omitted. Junction nodes are identified by the existence of more than two spans that begin or end at the node.
nodes/0/supportingInfrastructure

object

Supporting infrastructure

The infrastructure that supports this node.
nodes/0/supportingInfrastructure/type

string

Type

The type of supporting infrastructure, from the open nodeSupportingInfrastructure codelist.
nodes/0/supportingInfrastructure/description

string

Description

A description of the supporting infrastructure for this node.
nodes/0/supportingInfrastructure/owner

object

Owner

The organisation that owns the supporting infrastructure.
nodes/0/supportingInfrastructure/owner/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
nodes/0/supportingInfrastructure/owner/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.
nodes/0/supportingInfrastructure/spareCapacity

boolean

Spare capacity

Whether the supporting infrastructure has spare capacity for the installation of additional network equipment.
nodes/0/accessPoint

boolean

Access point

Whether active or passive transmission equipment is installed at this node which is capable of providing access to the network.
nodes/0/power

boolean

Power availability

Whether power for active network equipment is available at this node.
nodes/0/technologies

array[[string]]

Technologies

The active technologies used at this node, from the open nodeTechnologies codelist. For nodes with multiple network providers, the union of the active technologies used by each provider.
nodes/0/transmissionMediumOwner

object

Transmission medium owner

The organisation that owns the transmission media for this node, i.e. the passive network equipment such as splitters, combiners and fibre distribution panels.
nodes/0/transmissionMediumOwner/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
nodes/0/transmissionMediumOwner/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.
nodes_internationalConnections

This table is related to the following tables:

  • nodes: many-to-one by nodes/0/id

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
nodes/0/id

string

Required

Identifier

A locally-unique identifier for this node.
nodes/0/internationalConnections/0/streetAddress

string

Street address

The street address. For example, 1600 Amphitheatre Pkwy.
nodes/0/internationalConnections/0/locality

string

Locality

The locality. For example, Mountain View.
nodes/0/internationalConnections/0/region

string

Region

The region. For example, CA.
nodes/0/internationalConnections/0/postalCode

string

Postal code

The postal code. For example, 94043.
nodes/0/internationalConnections/0/country

string

Country

The country in which the address is physically located, from the closed country codelist.
nodes_networkProviders

This table is related to the following tables:

  • nodes: many-to-one by nodes/0/id

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
nodes/0/id

string

Required

Identifier

A locally-unique identifier for this node.
nodes/0/networkProviders/0/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
nodes/0/networkProviders/0/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.

spans

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
spans/0/id

string

Required

Identifier

A locally-unique identifier for this span.
spans/0/name

string

Name

A name for this span. The name should be unique amongst the spans belonging to a network.
spans/0/phase

object

Phase

The phase to which this span belongs.
spans/0/phase/id

string

Required

Identifier

The identifier of the phase being referenced.
spans/0/phase/name

string

Name

The name of the phase being referenced. This must match the name of the phase referenced in .id.
spans/0/status

string

Status

The status of the network infrastructure for this span, from the closed spanStatus codelist.
spans/0/readyForServiceDate

string

date

Ready for service date

The date this span was ready to carry traffic. For spans with multiple network providers, the earliest of the dates at which each provider’s network was ready to carry traffic on this span.
spans/0/start

string

Start

The identifier of one of two nodes that this span connects. If the span is directed, it represents the starting point of the span.
spans/0/end

string

End

The identifier of one of two nodes that this span connects. If the span is directed, it represents the end point of the span.
spans/0/directed

boolean

Directed

Whether this span is directed. If the span is directed, the span begins at the node referenced in .start and ends at the node referenced in .end. Otherwise, the span connects the nodes referenced in .start and .end with no direction implied.
spans/0/route

object

Route

The physical route that this span takes between the nodes that it connects.
spans/0/transmissionMediumOwner

object

Owner

The organisation that owns the transmission media for this span, i.e. the fibre cables.
spans/0/transmissionMediumOwner/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
spans/0/transmissionMediumOwner/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.
spans/0/supplier

object

Supplier

The organisation responsible for installing the cable for this span.
spans/0/supplier/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
spans/0/supplier/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.
spans/0/transmissionMedium

array[[string]]

Transmission medium

The physical media of this span, from the closed transmissionMedium codelist.
spans/0/deployment

array[[string]]

Deployment

The physical deployment of this span, from the closed deployment codelist. Further details of this span’s deployment can be provided in .supportingInfrastructure.
spans/0/supportingInfrastructure

object

Supporting infrastructure

The infrastructure that supports this span.
spans/0/supportingInfrastructure/type

string

Type

The type of supporting infrastructure, from the open spanSupportingInfrastructure codelist.
spans/0/supportingInfrastructure/description

string

Description

A description of the supporting infrastructure for this span.
spans/0/supportingInfrastructure/owner

object

Owner

The organisation that owns the supporting infrastructure.
spans/0/supportingInfrastructure/owner/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
spans/0/supportingInfrastructure/owner/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.
spans/0/supportingInfrastructure/spareCapacity

boolean

Spare capacity

Whether the supporting infrastructure has spare capacity for the installation of additional fibre cables.
spans/0/codeployment

string

Codeployment

The type of utility or transport infrastrucutre with which this span is codeployed.
spans/0/cableType

string

Cable type

The type of cable used in this span.
spans/0/darkFibre

boolean

Dark fibre availability

Whether access to dark fibre is available on this span.
spans/0/fibreType

string

Fibre type

The type of fibre used in this span, from the closed fibreType codelist. Further details of the span’s fibre type can be provided in .fibreTypeDetails.
spans/0/fibreTypeDetails

object

Fibre type details

Further details about this span’s fibre type.
spans/0/fibreTypeDetails/fibreSubtype

string

Subtype

The sub-category of this span’s fibre type. For example, G.652.B.
spans/0/fibreTypeDetails/description

string

Description

A description of this span’s fibre type.
spans/0/fibreCount

integer

Fibre count

The number of individual optical fibres in this span.
spans/0/fibreLength

number

Fibre length

The physical length in kilometres, of fibre optic cable used in this span.
spans/0/technologies

array[[string]]

Technologies

The active technologies used on this span, from the open spanTechnologies codelist. For spans with multiple network providers, the union of the active technologies used by each provider.
spans/0/capacity

number

Equipped capacity

The transmission rate, or throughput, of this span, expressed in Gbit/sec (Gbps). The equipped capacity is the total capacity of the circuits (e.g. E1, DS3, STM-1 etc.) which have been activated in the network transmission equipment of the span. For spans with multiple network providers, the sum of the capacity of each provider’s network on this span. Further details of this span’s capacity can be provided in .capacityDetails. For more information, see equipped capacity.
spans/0/capacityDetails

object

Capacity details

Further details about this span’s capacity.
spans/0/capacityDetails/description

string

Description

A description of this span’s capacity.
spans/0/wayleaves

array[string]

Wayleaves

The identifiers of the formal agreements that grant network operators rights to install, maintain or operate this span’s infrastructure on, over, or under grantors’ property or assets.
spans/0/countries

array[[string]]

Countries

The countries in which this span is physically located, from the closed country codelist.
spans_networkProviders

This table is related to the following tables:

  • spans: many-to-one by spans/0/id

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
spans/0/id

string

Required

Identifier

A locally-unique identifier for this span.
spans/0/networkProviders/0/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
spans/0/networkProviders/0/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.

phases

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
phases/0/id

string

Required

Identifier

A locally-unique identifier for this phase.
phases/0/name

string

Name

A name for this phase. The name should be unique amongst the phases belonging to a network.
phases/0/description

string

Description

A description for this phase.
phases_funders

This table is related to the following tables:

  • phases: many-to-one by phases/0/id

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
phases/0/id

string

Required

Identifier

A locally-unique identifier for this phase.
phases/0/funders/0/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
phases/0/funders/0/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.

organisations

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
organisations/0/id

string

Required

Local identifier

A locally-unique identifier for this organisation.
organisations/0/name

string

Name

A name for this organisation. The name should be unique amongst the organisations belonging to a network.
organisations/0/identifier

object

Organisation identifier

An identifier for this organisation.
organisations/0/identifier/id

string

Identifier

The identifier assigned to the organisation in the register identified in .scheme.
organisations/0/identifier/scheme

string

Scheme

The register from which the identifier in .id is drawn, from the open organisationIdentifierScheme codelist.
organisations/0/identifier/legalName

string

Legal name

The legally registered name of the organisation
organisations/0/identifier/uri

string

iri

URI

A canonical URI for this identifier, such as those provided by Open Corporates. Do not use this field to provide the website of the organisation: instead, use Organisation.website.
organisations/0/country

string

Country

The country in which this organisation is legally registered, from the closed country codelist.
organisations/0/roles

array[[string]]

Roles

This organisation’s roles in this network, from the open organisationRole codelist. Further details about this organisation’s roles can be provided in .roleDetails.
organisations/0/roleDetails

string

Role details

Further details about this organisation’s roles in the network
organisations/0/website

string

iri

Website

The URL of the website for this organisation.

string

iri

Logo

The URL of the logo for this organisation.

wayleaves

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
wayleaves/0/id

string

Required

Identifier

A locally-unique identifier for this wayleave.
wayleaves/0/grantor

object

Grantor

The entity that grants a network operator the legal right to install, maintain, or operate telecommunications infrastructure on, over, or under property or assets.
wayleaves/0/grantor/id

string

Required

Local identifier

The local identifier of the organisation being referenced.
wayleaves/0/grantor/name

string

Name

The name of the organisation being referenced. This must match the name of the organisation referenced in .id.
wayleaves/0/yearSigned

integer

Year signed

The year in which this wayleave was signed.
wayleaves/0/term

object

Term

Information about the duration of the wayleave.
wayleaves/0/term/indefinite

boolean

Indefinite

Whether the term of wayleave is indefinite, i.e. without an end date.
wayleaves/0/term/years

integer

Years

If the wayleave’s term is definite, its duration in years.
wayleaves/0/cost

object

Cost

Information about the cost of the wayleave.
wayleaves/0/cost/recurring

boolean

Recurring

Whether this is a recurring cost.
wayleaves/0/cost/perMetre

object

Cost per metre

The average cost per metre for this wayleave. Wayleave costs can include a mix of per length and per item fees, e.g. a fee per metre of cable and a fee per pole. The average cost per metre should be calculated by dividing the total cost of all fees by the total length in metres of cable covered by the wayleave. For recurring fees, the average cost per metre should be annualised.
wayleaves/0/cost/perMetre/amount

number

Amount

The amount of this value.
wayleaves/0/cost/perMetre/currency

string

Currency

The currency of this value, from the closed currency codelist.

contracts

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
contracts/0/id

string

Required

Identifier

A locally-unique identifier for this contract.
contracts/0/title

string

Title

A title for this contract.
contracts/0/description

string

Description

A description for this contract.
contracts/0/type

string

Type

The type of this contract, from the open contractType codelist.
contracts/0/value

object

Value

The value of this contract.
contracts/0/value/amount

number

Amount

The amount of this value.
contracts/0/value/currency

string

Currency

The currency of this value, from the closed currency codelist.
contracts/0/dateSigned

string

date

Date signed

The date this contract was signed.
contracts_documents

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
contracts/0/id

string

Required

Identifier

A locally-unique identifier for this contract.
contracts/0/documents/0/title

string

Title

A title for this document.
contracts/0/documents/0/description

string

Description

A description of this document. Descriptions should not exceed 250 words. If the document is not accessible online, the description should describe how to access a copy of the document.
contracts/0/documents/0/url

string

iri

URL

A web address for accessing this document.
contracts/0/documents/0/format

string

Format

The format of this document, from the open mediaType codelist.
contracts_relatedPhases

This table is related to the following tables:

The columns in this table are listed below. You can also download an example CSV file or a blank template for this table.

Title

Description

Type

Format

Required
id

string

uuid

Required

UUID

A universally unique identifier for this network, as defined by RFC 4122. For more information, see the identifier reference.
contracts/0/id

string

Required

Identifier

A locally-unique identifier for this contract.
contracts/0/relatedPhases/0/id

string

Required

Identifier

The identifier of the phase being referenced.
contracts/0/relatedPhases/0/name

string

Name

The name of the phase being referenced. This must match the name of the phase referenced in .id.