Documentation: grids

Static data about electrical grids - minigrids as well as national grids
To import data in this format you can use our API. -> API Documentation
You can also supply us with files in xlsx, csv or json format. -> Example CSV
type p14n blurred autogenerated required
uid string
organization_id + name; Autogenerated unique identifier of the grid
external_id string
ID for the specific (mini-)grid as tracked by the data provider (source)
name string
name of the (mini-)grid, typically given by operator company
operator_company string
name of the company which operates the (mini-)grid
location_area_1 string
(mini-)grid first-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country
location_area_2 string
(mini-)grid second-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country
location_area_3 string
(mini-)grid third-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country
location_area_4 string
(mini-)grid fourth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country
country string
two-letter country code according to ISO 3166-1 alpha-2
latitude float
geo location latitude
longitude float
geo location longitude
power_rating_kw float
highest power input allowed to flow through inverter in kilowatt
primary_input_installed_kw float
sum of installed primary peak power in kilowatt
secondary_input_installed_kw float
sum of installed secondary peak power in kilowatt
primary_input_source string
e.g. solar
secondary_input_source string
e.g. diesel generator
is_offgrid boolean
indicates whether the grid is a national grid (FALSE) or a mini-grid (TRUE)
storage_capacity_kwh float
maximum storage capacity in kilowatt hour
operator_phone string
operator telephone (p14)
id integer
Internal primary key
created_at datetime
Timestamp when row was inserted
updated_at datetime
Timestamp when row was updated
source_id integer
References Source of data
import_id integer
References Import of data
organization_id integer
References Organization of data
custom jsonb
Saves additional imported data out of standard structure
data_origin string
Origin of the data, generic or name of the api
trust_score float
calculated value how much we trust data
last_import_id integer
Id of the last import which updated the record
last_source_id integer
Id of the last Source which updated the record