Sélectionnez votre langue

Documentation: grids

Cette table est obsolète et ne doit pas être utilisée pour les importations

Static data about electrical grids - minigrids as well as national grids
Pour importer des données dans ce format, vous pouvez utiliser notre API. -> Documentation API
Limite de débit : 300 requêtes par minute. Une fois la limite dépassée, toute requête ultérieure entraînera une réponse 429 (Trop de requêtes).
Vous pouvez également nous fournir des fichiers aux formats xlsx, csv ou json. -> Exemple CSV
Nom de la ligne Type Correspondance Exemple

external_id *

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

  • * requis
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.

  • * requis
string installations => site_name

SMU 12 Chinsanka

last_source_id

Id of the last Source which updated the record

  • généré automatiquement
integer

33

last_import_id

Id of the last import which updated the record

  • généré automatiquement
integer

337

data_origin

Origin of the data, generic or name of the api

  • généré automatiquement
string

generic

custom

Saves additional imported data out of standard structure

  • généré automatiquement
jsonb

{ "some": "key" }

organization_id

References Organization of data

  • généré automatiquement
integer

1

import_id

References Import of data

  • généré automatiquement
integer

1

source_id

References Source of data

  • généré automatiquement
integer

1

updated_at

Timestamp when row was updated

  • généré automatiquement
datetime

2021-05-03 6:23:55

created_at

Timestamp when row was inserted

  • généré automatiquement
datetime

2021-05-03 6:23:55

operator_phone

operator telephone (p14)

  • p14n
string installations => custom

0123456789 will be - stored as c340f947f1f7cb83c8f40bb5a7ad24ca78486bdfb2ef587f55ea537de17efc27

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

is_offgrid

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

 boolean installations => custom

true

secondary_input_source

e.g. diesel generator

 string installations => custom

diesel generator

primary_input_source

e.g. solar

 string installations => custom

solar

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_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

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

longitude

geo location longitude

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

 float installations => longitude

2.345

latitude

geo location latitude

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

 float installations => latitude

5.432

country

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

 string installations => custom

TZ

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

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_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_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

operator_company

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

 string installations => custom

Standard Microgrid

uid

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

  • généré automatiquement
string installations => uid

a2ei-X98679862w