Skip to main content

page search

About the Land Projects Database

 

 

The Land Projects Database is a tool that tracks development funding to projects that aim to improve land governance around the world. It is a joint initiative by Land Portal’s Foundation and the Global Donor Working Group on Land (GDWGL), intended to enhance transparency about land governance initiatives globally. With a comprehensive data collection, a user-friendly interface and optimised methods for regular updating processes, the tool provides information about the allocation of funds, the geographic distribution of projects, the approaches adopted and other information that allows donors and other groups to enhance coordination and avoid duplication of efforts in improving land governance in countries.

 

  • Download the full dataset of the Projects Database

Data collection

1. Data sources

Three main sources of data have been identified to contribute to the  Land Portal’s Projects Database.

  • Land Portal’s projects database, focusing on projects that have been manually added over the last 5 years.
  • The GDWGL’s Land Governance Programme Map 
  • The database from the International Aid Transparency Initiative (IATI), focusing on land governance projects.

2. Data selection from the International Aid Transparency Initiative (IATI)

The International Aid Transparency Initiative (IATI)  is a global initiative aimed at improving the transparency of development and humanitarian resources. Organisations involved in international development share information about projects and expenditure through an open XML data standard. 
 

Land governance IATI activities were defined as activities that in its title or description contained one of the following key terms.

 

1.    land tenure
2.    land administration
3.    land governance
4.    land management
5.    land rights
6.    tenure security
7.    land registration
8.    land reform
9.    land use planning
10.    land access
11.    land titling
12.    forest land
13.    land policies
14.    land ownership
15.    urban land
16.    customary land rights
 

17.    community land rights
18.    land conflicts
19.    indigenous lands
20.    land records
21.    land disputes
22.    land deals
23.    land law
24.    land acquisitions
25.    gender equity in access to land
26.    land register
27.    land concession
28.    land productivity
29.    land loans
30.    land degradation
31.    land use policy
32.    expropriation

The key terms were defined following this set of criteria:

  • Terms which are highly frequent in Land Portal’s website
  • Terms which are higher in the LandVoc hierarchy
  • Terms which are highly frequent in the GDWGL’s Land MapTerms frequently used by users on search engines, and which drive them to the GDWGL’s Land Map.

Land governance IATI activities were retrieved from the IATI Datastore API. Original XML documents containing each activity in its original published form were obtained using the parameters of the IATI Standard Query Parse. Information was then extracted from each individual XML activity to construct the Land Portal Projects’ Database data model. 
 


Data processing

1. Land Portal’s Projects Database model

A simplified and unified data model was created to incorporate information collected from different sources.

Field

Definition

Data processing

source

Source data collection

Abbreviations for the source data collection: IATI, LP, DM, etc.

code

Projects’ identifier

IATI identifier for Land Governance IATI activities, custom identifier for other data sources

nid

Specific identifier for projects in the LP collection

 

reporting_org

Organisation that reported the activity. Specific for projects in the IATI collection. Empty for projects coming from other data sources

 

title

Project's title

For projects coming from the IATI collection, the title represents the title narrative in ENG. When the ENG narrative was not available, any other title narrative was used. For projects from other data collections, it takes the value of projects’ title.

description

Project's description

For projects coming from the IATI collection, general description, objectives, target groups, and other activities’ description types were merged into a single HTML formatted text. Descriptions narratives of the land governance AITI activities in languages other than English were only used if an English description narrative was unavailable. Project’s “summary” in the GDWGL’s Land Map, was assumed as general description and are presented as HML formatted text. LP project description is shown as general descriptions and are presented as HML formatted text.

project_value

Committed or actual funds flowing into a project

For projects coming from the IATI collection, project_value represents the sum of committed transactions in EUR. Transactions are defined as recording committed or actual funds flowing in or out of an aid activity. Only outgoing commitment transaction type was considered. All transactions in currencies other than EUR were converted into EUR using the transaction date and forex-python 1.8. For transactions in XDR currency, exchange rates were retrieved from IMF Exchange Rates tool. “funding” and “project_value” information coming correspondlty from the GDWGL’s Land Map and LPF’s Project’s Database was assigned as project_value.

currency

project_value currency

For projects coming from the IATI collection, currency is always EUR due to executed currency conversion process. For projects from other data collections, it informs about the project_value currency.

contact_email

Project’s contact email

For projects coming from the IATI collection, contact_email reports the email item narrative from the contact-info element. Only the first email is reported, disregarding the contact info type. For projects coming from other sources, it presents the reported contact email.

contact_web

Project's website or website of a participating organisation

For projects coming from the IATI collection, contact_web reports the website item’s narrative from the contact-info element. Only the first website is reported, disregarding the contact info type. For projects coming from other sources, it presents the reported project’s website.

contact_address

Mailing addresses of participating organisations

For projects coming from the IATI collection, contact_address reports the mailing-address items’ narrative from the contact-info element. For projects coming from other sources, it presents the reported contact address.

start_date

Project’s start date

For projects coming from the IATI collection, start_date reports the actual start date of the activity-date element. Planned start dates are used when actual start dates are unavailable. For projects coming from other sources, it presents the reported project’s start date.

end_date

Project’s end date

For projects coming from the IATI collection, end_date reports the actual end date of the activity-date element. Planned end dates are used when actual end dates are unavailable. For projects coming from other sources, it presents the reported project’s end date.

funding_org

The field indicates the donor organisations funding the project

For projects coming from the IATI collection, funding_org reports the narrative of the participating-org element with the funding role. For projects coming from the GDWGL’s Land Map collection, funding_org reports the “funder_names”. For projects coming from the LPF’s Projects’ Database, the field presents the reported donor. Organisations not in the LP organisation database are labelled as “other organizations”.

implementing_org

The field indicates the organisations engaged in the project's  implementation, including accountable, extending and implementing organisations.

For projects coming from the IATI collection, implementing_org reports the merged narratives of the participating-org element with accountable, extending, and implementing organisation roles. For projects coming from the GDWGL’s Land Map collection, implementing_org reports the “implemented_by” field. For projects coming from the LPF’s Projects’ Database, the field presents the reported “implementing_org”. Organisations not in the LP organisation database are labelled as “other organizations”.

geographical focus

The field indicates the country where the project operates or where the funds are received.

 

For projects coming from the IATI collection, geographical focus is built upon the country code of the recipient-country element. For projects coming from the GDWGL’s Land Map collection, geographical focus reports the “country_names” field. For projects coming from the LPF’s Projects’ Database, the field presents the reported “country”. Countries’ full name are reported.

 

2. Donor and implementing organisation inputs

In a preliminary phase, after harvesting the datasets from the IATI Datastore API,  Land Portal’s Projects Database was sent to donors and implementing agencies to be reviewed and complemented. During this phase, 12 projects were manually added by Omidyar Network (8) and the Austrian Development Agency (4).


Limitations

As with any initiative trying to convert complex data into a simplified model, there are important limitations:

 

  • Granularity in project values: In the IATI dataset, "Budgets" and "Transactions" represent complex information, with several values for each quarter of the project's duration. We offer a simplified version of transactions for each activity, focusing on outgoing commitments. Budgets have not been considered.
  • We prioritised data integrity preservation: In the IATI datasets, despite a project's description possibly mentioning implementation in several countries, the geographical scope of the project is retained as originally reported.
  • Aggregation issues: Multiple project phases might be reported as separate projects. Similarly, programs with multiple projects might also be grouped into a single entry.

Contact us

If you have any questions about the Land Projects Database, including on the data we used or our methodoloy, please write to: data@landportal.info