Documentation: grids
This table is deprecated and should not be used for imports
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
Required | Type | p14n | Blurred | Autogenerated | Mapping | Example | |
---|---|---|---|---|---|---|---|
external_id ID for the specific (mini-)grid as tracked by the data provider (source). |
✓ | 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. |
✓ | string | ⤫ | ⤫ | ⤫ | installations => site_name |
SMU 12 Chinsanka |
uid organization_id + data_origin + external_id; Autogenerated unique identifier of the grid |
⤫ | 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) |
⤫ | string | ✓ | ⤫ | ⤫ | installations => custom |
0123456789 will be - stored as c340f947f1f7cb83c8f40bb5a7ad24ca78486bdfb2ef587f55ea537de17efc27 |
created_at Timestamp when row was inserted |
⤫ | datetime | ⤫ | ⤫ | ✓ |
2021-05-03 6:23:55 |
|
updated_at Timestamp when row was updated |
⤫ | datetime | ⤫ | ⤫ | ✓ |
2021-05-03 6:23:55 |
|
source_id References Source of data |
⤫ | integer | ⤫ | ⤫ | ✓ |
1 |
|
import_id References Import of data |
⤫ | integer | ⤫ | ⤫ | ✓ |
1 |
|
organization_id References Organization of data |
⤫ | integer | ⤫ | ⤫ | ✓ |
1 |
|
custom Saves additional imported data out of standard structure |
⤫ | jsonb | ⤫ | ⤫ | ✓ |
{ "some": "key" } |
|
data_origin Origin of the data, generic or name of the api |
⤫ | string | ⤫ | ⤫ | ✓ |
generic |
|
last_import_id Id of the last import which updated the record |
⤫ | integer | ⤫ | ⤫ | ✓ |
337 |
|
last_source_id Id of the last Source which updated the record |
⤫ | integer | ⤫ | ⤫ | ✓ |
33 |