Documentation: grids

This table is deprecated and should not be used for imports

Static data about electrical grids - minigrids as well as national grids
To import data in this format you can use our API. -> API Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
You can also supply us with files in xlsx, csv or json format. -> Example CSV
Row Name Type Mapping Example

external_id *

ID for the specific (mini-)grid as tracked by the data provider (source).

  • * required
string installations => device_external_id

X98679862w

name *

Name of the (mini-)grid, typically given by operator company. Note that this is not treated as sensitive information, and would be un-encrypted.

  • * required
string installations => site_name

SMU 12 Chinsanka

uid

organization_id + data_origin + external_id; Autogenerated unique identifier of the grid

  • auto-generated
string installations => uid

a2ei-X98679862w

operator_company

Name of the company which operates the (mini-)grid

 string installations => custom

Standard Microgrid

location_area_1

(mini-)grid first-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 string installations => location_area_1

Luapola

location_area_2

(mini-)grid second-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 string installations => location_area_2

Samfya

location_area_3

(mini-)grid third-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 string installations => location_area_3

None

location_area_4

(mini-)grid fourth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 string installations => location_area_4

None

country

two-letter country code according to ISO 3166-1 alpha-2

 string installations => custom

TZ

latitude

geo location latitude

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float installations => latitude

5.432

longitude

geo location longitude

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float installations => longitude

2.345

power_rating_kw

highest power input allowed to flow through inverter in kilowatt

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float installations => rated_power_w

2.8

primary_input_installed_kw

sum of installed primary peak power in kilowatt

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float installations => custom

2.5

secondary_input_installed_kw

sum of installed secondary peak power in kilowatt

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float installations => custom

3.2

primary_input_source

e.g. solar

 string installations => custom

solar

secondary_input_source

e.g. diesel generator

 string installations => custom

diesel generator

is_offgrid

indicates whether the grid is a national grid (FALSE) or a mini-grid (TRUE)

 boolean installations => custom

true

storage_capacity_kwh

maximum storage capacity in kilowatt hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float installations => battery_capacity_wh

5.8

operator_phone

operator telephone (p14)

  • p14n
string installations => custom

0123456789 will be - stored as c340f947f1f7cb83c8f40bb5a7ad24ca78486bdfb2ef587f55ea537de17efc27

created_at

Timestamp when row was inserted

  • auto-generated
datetime

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

  • auto-generated
datetime

2021-05-03 6:23:55

source_id

References Source of data

  • auto-generated
integer

1

import_id

References Import of data

  • auto-generated
integer

1

organization_id

References Organization of data

  • auto-generated
integer

1

custom

Saves additional imported data out of standard structure

  • auto-generated
jsonb

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

  • auto-generated
string

generic

last_import_id

Id of the last import which updated the record

  • auto-generated
integer

337

last_source_id

Id of the last Source which updated the record

  • auto-generated
integer

33