Sidlan API

Sidlan Application Programming Interface (API) is a secured interface for accessing the structured data from the PRDP's Management Information System. The return values can be requested as a CSV file or a json data. For data security, a valid api key is required as one of the parameters in the URI of the API. This key can be requested through the Sidlan app
Request API Key

GET
Infrastructure Subprojects Datasets
Parameters Description
dataset_id To optimize processing efficiency, I-BUILD-related data are organized into distinct datasets, each identified by a unique dataset_id. This allows users to retrieve only the relevant subset of data based on their needs. Refer to the list below for the available dataset_id values along with their corresponding attributes.

1.
ib-01-001
List of infrastructure subprojects with basic profile.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • municipality
  • latitude
  • longitude
  • sp_type
  • category
  • funding_source
  • project_description
  • development_objective
  • sp_indicative_cost
  • cost_during_validation
  • estimated_project_cost
  • rpab_approved_cost
  • nol1_approved_cost
  • awarded_cost
  • date_validated
  • commodity
  • stage
  • specific_status
  • Physical Progress
  • beneficiary_total_hh (house hold)
  • beneficiary_total_ff_hh (farmers/fisher household)
  • beneficiary_male
  • beneficiary_female
  • 2.
    ib-01-002
    Approval (Pre-procurement) milestones of individual infratsructure subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • sp_type
  • category
  • stage
  • specific_status
  • indicative_project_cost
  • rpab_approved_cost
  • actual_dates {pre_procurement milestones}
  • . . .

    3.
    ib-01-003a
    Procurement milestones (Request for Bids) of individual infratsructure subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • sp_type
  • sp_category
  • stage
  • specific_status
  • procurement_mode
  • cost_nol_1
  • estimated_project_cost
  • nol1_issued
  • actual_dates {procurement milestones}
  • . . .

    4.
    ib-01-003b
    Procurement milestones (Request for Quotation) of individual infratsructure subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • sp_type
  • sp_category
  • stage
  • specific_status
  • procurement_mode
  • cost_nol_1
  • estimated_project_cost
  • actual_dates {procurement milestones}
  • . . .

    5.
    ib-01-004a
    Monthly Targets of Physical Progress of infratsructure subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • sp_type
  • category
  • estimated_project_cost
  • awarded_project_cost
  • target_date {date starts from July 1, 2023 to present}
  • . . .

    6.
    ib-01-004b
    Monthly Physical Progress (Actual) of infratsructure subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • sp_type
  • category
  • estimated_project_cost
  • awarded_project_cost
  • date {date starts from July 1, 2023 to present}
  • . . .

    return_values The API allows users to specify their preferred response format. For this particular API, the user can select one of the output formats available: a CSV file or JSON data. For the specific value for this parameter, copy only one of the following:

    csv

    json

    cluster The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1.
    Luzon A
    • Cordillera Administrative Region (CAR)
    • Ilocos Region (Region I)
    • Cagayan Valley (Region II)
    • Central Luzon (Region III)
    2.
    Luzon B
    • CALABARZON (Region IV-A)
    • MIMAROPA (Region IV-B)
    • Bicol Region (Region V)
    3.
    Visayas
    • Western Visayas (Region VI)
    • Central Visayas (Region VII)
    • Eastern Visayas (Region VIII)
    4.
    Mindanao
    • Zamboanga Peninsula (Region IX)
    • Northern Mindanao (Region X)
    • Davao Region (Region XI)
    • SOCCSKSARGEN (Region XII)
    • Caraga (Region XIII)
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)

    You can select only one cluster as value of the parameter. However, if you opt to call all clusters, you can assign the value all to the cluster parameter.

    region The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1. Luzon A
    • Cordillera Administrative Region (CAR)
    • Ilocos Region (Region I)
    • Cagayan Valley (Region II)
    • Central Luzon (Region III)
    2. Luzon B
    • CALABARZON (Region IV-A)
    • MIMAROPA (Region IV-B)
    • Bicol Region (Region V)
    3. Visayas
    • Western Visayas (Region VI)
    • Central Visayas (Region VII)
    • Eastern Visayas (Region VIII)
    4. Mindanao
    • Zamboanga Peninsula (Region IX)
    • Northern Mindanao (Region X)
    • Davao Region (Region XI)
    • SOCCSKSARGEN (Region XII)
    • Caraga (Region XIII)
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)

    You can select only one region as value of the parameter. However, if you opt to call all regions of one specific cluster, you can assign the value all to the region parameter.

    province The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1. Luzon A
    • Cordillera Administrative Region (CAR)
      • Abra
      • Apayao
      • Benguet
      • Ifugao
      • Kalinga
      • Mountain Province
    • Ilocos Region (Region I)
      • Ilocos Norte
      • Ilocos Sur
      • La Union
      • Pangasinan
    • Cagayan Valley (Region II)
      • Batanes
      • Cagayan
      • Isabela
      • Nueva Vizcaya
      • Quirino
      • Santiago City (Component City)
    • Central Luzon (Region III)
      • Aurora
      • Bataan
      • Bulacan
      • Nueva Ecija
      • Pampanga
      • Tarlac
      • Zambales
    2. Luzon B
    • CALABARZON (Region IV-A)
      • Batangas
      • Cavite
      • Laguna
      • Quezon
      • Rizal
    • MIMAROPA (Region IV-B)
      • Marinduque
      • Occidental Mindoro
      • Oriental Mindoro
      • Palawan
      • Puerto Princesa City (Independent City)
      • Romblon
    • Bicol Region (Region V)
      • Albay
      • Camarines Norte
      • Camarines Sur
      • Catanduanes
      • Masbate
      • Naga City
      • Sorsogon
    3. Visayas
    • Western Visayas (Region VI)
      • Aklan
      • Antique
      • Capiz
      • Guimaras
      • Iloilo
      • Negros Occidental
    • Central Visayas (Region VII)
      • Bohol
      • Cebu
      • Negros Oriental
      • Siquijor
    • Eastern Visayas (Region VIII)
      • Biliran
      • Eastern Samar
      • Leyte
      • Northern Samar
      • Ormoc City (Independent City)
      • Samar
      • Southern Leyte
    4. Mindanao
    • Zamboanga Peninsula (Region IX)
      • Isabela City
      • Zamboanga City (Not a province)
      • Zamboanga del Norte
      • Zamboanga del Sur
      • Zamboanga Sibugay
    • Northern Mindanao (Region X)
      • Bukidnon
      • Cagayan de Oro City (Chartered City)
      • Camiguin
      • Iligan City (Chartered City)
      • Lanao del Norte
      • Misamis Occidental
      • Misamis Oriental
    • Davao Region (Region XI)
      • Davao City (Not a province)
      • Davao de Oro
      • Davao del Norte
      • Davao del Sur
      • Lanao del Norte
      • Davao Occidental
      • Davao Oriental
    • SOCCSKSARGEN (Region XII)
      • Cotabato
      • General Santos City
      • Sarangani
      • South Cotabato
      • Sultan Kudarat
    • Caraga (Region XIII)
      • Agusan del Norte
      • Agusan del Sur
      • Butuan City (Not a province)
      • Dinagat Islands
      • Surigao del Norte
      • Surigao del Sur
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)
      • Basilan
      • Lanao del Sur
      • Maguindanao del Norte
      • Maguindanao del Sur
      • Sulu
      • Tawi-Tawi

    You can select only one province as value of the parameter. However, if you opt to call all provinces of one specific region, you can assign the value all to the province parameter.

    group_status Infrastructure subprojects have to undergo the project implementation cycle with different stages. These stages are grouped into 2 - pipelined and approved.

    pipelined consists of subprjects under 'Subproject proposal validated', 'FS/DED and Safeguard requirements prepared and packaged', 'RPCO clearance for appraisal issued', 'SPA conducted (Depending on treshold)', 'SPAR issued (Depending on treshold)', 'JTR conducted (as applicable)', 'RPAB clearance issued (Depending on treshold)', 'Subproject approved by RPAB', 'RPAB resolution and POW with no objection submitted by RPCO and STEP approved'.

    approved consists of subprjects under 'Subproject Issued with No Objection Letter 1 (NOL 1)', 'procurement', 'construction', 'completed'.

    If you wish to retrieve all subprojects regardless of their status, assign the value all to the group_status parameter.

    api_key Sidlan API is secured with API Key which can be requested through the following link.
    Request API Key
    Parameters Description
    dataset_id To optimize processing efficiency, I-PLAN related data are organized into distinct datasets, each identified by a unique dataset_id. This allows users to retrieve only the relevant subset of data based on their needs. Refer to the list below for the available dataset_id values along with their corresponding attributes.

    1.
    ip-vca-001
    List of Value Chain Analysis (VCA) with investments from PRDP Scale-up's I-BUILD, I-REAP, and Non-PRDP Funded projects.
  • vca_index
  • timestamp
  • vca_title
  • commodity
  • from_year
  • to_year
  • category
  • scope
  • cluster
  • region
  • province
  • status
  • status_date
  • activity (Active/Depreciated)
  • Investment Requirement
  • no_ibuild_sps_linked
  • no_ireap_sps_linked
  • no_non-prdp_sps_linked
  • ibuild_investment
  • ireap_investment
  • non_prdp_investment
  • 2.
    ip-vca-002
    VCA Formulation Milestone
  • id
  • timestamp
  • vca_index
  • vca_title
  • commodity
  • from_year
  • to_year
  • scope
  • cluster
  • region
  • province
  • actual_dates {vca milestones}
  • . . .

    3.
    ip-vca-003
    Value Chain Analysis Matrix
  • id
  • timestamp
  • vca_index
  • vca_title
  • commodity
  • from_year
  • to_year
  • scope
  • cluster
  • region
  • province
  • value_chain_segment
  • constraints_opportunities
  • content
  • intervention
  • 4.
    ip-004
    Investment Requirements per Commodity and Value Chain Segment based on approved PCIP
  • cluster
  • region
  • province
  • pcip_title
  • validty_year_from
  • validty_year_to
  • commodity
  • vca_segment
  • investment_requirement
  • 5.
    ip-005
    Investment Requirements per Commodity and constraint based on approved PCIP
  • cluster
  • region
  • province
  • pcip_title
  • validty_year_from
  • validty_year_to
  • commodity
  • constraint
  • investment_requirement
  • 6.
    ip-006
    Funded Investment Commodities and Value Chain Segments from PRDP OL, AF1, AF2 and EU
  • cluster
  • region
  • province
  • pcip_title
  • validty_year_from
  • validty_year_to
  • commodity
  • vc_segment
  • funded_investment
  • 5.
    ip-007
    Investment Requirements and uptakes per Commodity and Value Chain Aspect of ALL PCIP versions
  • cluster
  • region
  • province
  • commodity
  • pcip_title
  • validty_year_from
  • validty_year_to
  • cetegory
  • validity_status
  • vc_segment
  • vc_segment
  • investment_requirement
  • return_values The API allows users to specify their preferred response format. For this particular API, the user can select one of the output formats available: a CSV file or JSON data. For the specific value for this parameter, copy only one of the following:

    csv

    json

    cluster The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1.
    Luzon A
    • Cordillera Administrative Region (CAR)
    • Ilocos Region (Region I)
    • Cagayan Valley (Region II)
    • Central Luzon (Region III)
    2.
    Luzon B
    • CALABARZON (Region IV-A)
    • MIMAROPA (Region IV-B)
    • Bicol Region (Region V)
    3.
    Visayas
    • Western Visayas (Region VI)
    • Central Visayas (Region VII)
    • Eastern Visayas (Region VIII)
    4.
    Mindanao
    • Zamboanga Peninsula (Region IX)
    • Northern Mindanao (Region X)
    • Davao Region (Region XI)
    • SOCCSKSARGEN (Region XII)
    • Caraga (Region XIII)
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)

    You can select only one cluster as value of the parameter. However, if you opt to call all clusters, you can assign the value all to the cluster parameter.

    region The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1. Luzon A
    • Cordillera Administrative Region (CAR)
    • Ilocos Region (Region I)
    • Cagayan Valley (Region II)
    • Central Luzon (Region III)
    2. Luzon B
    • CALABARZON (Region IV-A)
    • MIMAROPA (Region IV-B)
    • Bicol Region (Region V)
    3. Visayas
    • Western Visayas (Region VI)
    • Central Visayas (Region VII)
    • Eastern Visayas (Region VIII)
    4. Mindanao
    • Zamboanga Peninsula (Region IX)
    • Northern Mindanao (Region X)
    • Davao Region (Region XI)
    • SOCCSKSARGEN (Region XII)
    • Caraga (Region XIII)
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)

    You can select only one region as value of the parameter. However, if you opt to call all regions of one specific cluster, you can assign the value all to the region parameter.

    province The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1. Luzon A
    • Cordillera Administrative Region (CAR)
      • Abra
      • Apayao
      • Benguet
      • Ifugao
      • Kalinga
      • Mountain Province
    • Ilocos Region (Region I)
      • Ilocos Norte
      • Ilocos Sur
      • La Union
      • Pangasinan
    • Cagayan Valley (Region II)
      • Batanes
      • Cagayan
      • Isabela
      • Nueva Vizcaya
      • Quirino
      • Santiago City (Component City)
    • Central Luzon (Region III)
      • Aurora
      • Bataan
      • Bulacan
      • Nueva Ecija
      • Pampanga
      • Tarlac
      • Zambales
    2. Luzon B
    • CALABARZON (Region IV-A)
      • Batangas
      • Cavite
      • Laguna
      • Quezon
      • Rizal
    • MIMAROPA (Region IV-B)
      • Marinduque
      • Occidental Mindoro
      • Oriental Mindoro
      • Palawan
      • Puerto Princesa City (Independent City)
      • Romblon
    • Bicol Region (Region V)
      • Albay
      • Camarines Norte
      • Camarines Sur
      • Catanduanes
      • Masbate
      • Naga City
      • Sorsogon
    3. Visayas
    • Western Visayas (Region VI)
      • Aklan
      • Antique
      • Capiz
      • Guimaras
      • Iloilo
      • Negros Occidental
    • Central Visayas (Region VII)
      • Bohol
      • Cebu
      • Negros Oriental
      • Siquijor
    • Eastern Visayas (Region VIII)
      • Biliran
      • Eastern Samar
      • Leyte
      • Northern Samar
      • Ormoc City (Independent City)
      • Samar
      • Southern Leyte
    4. Mindanao
    • Zamboanga Peninsula (Region IX)
      • Isabela City
      • Zamboanga City (Not a province)
      • Zamboanga del Norte
      • Zamboanga del Sur
      • Zamboanga Sibugay
    • Northern Mindanao (Region X)
      • Bukidnon
      • Cagayan de Oro City (Chartered City)
      • Camiguin
      • Iligan City (Chartered City)
      • Lanao del Norte
      • Misamis Occidental
      • Misamis Oriental
    • Davao Region (Region XI)
      • Davao City (Not a province)
      • Davao de Oro
      • Davao del Norte
      • Davao del Sur
      • Lanao del Norte
      • Davao Occidental
      • Davao Oriental
    • SOCCSKSARGEN (Region XII)
      • Cotabato
      • General Santos City
      • Sarangani
      • South Cotabato
      • Sultan Kudarat
    • Caraga (Region XIII)
      • Agusan del Norte
      • Agusan del Sur
      • Butuan City (Not a province)
      • Dinagat Islands
      • Surigao del Norte
      • Surigao del Sur
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)
      • Basilan
      • Lanao del Sur
      • Maguindanao del Norte
      • Maguindanao del Sur
      • Sulu
      • Tawi-Tawi

    You can select only one province as value of the parameter. However, if you opt to call all provinces of one specific region, you can assign the value all to the province parameter.

    group_status VCA or CIP have to undergo the development cycle with different stages. These stages are grouped into 2 - ongoing and approved.

    ongoing consists of VCAs that udergoing review, compliance and approval.

    approved consists of VCAs with NOL issued from PDP NPCO.

    If you wish to retrieve all subprojects regardless of their status, assign the value all to the group_status parameter.

    api_key Sidlan API is secured with API Key which can be requested through the following link.
    Request API Key
    GET
    Enterprise Subprojects Datasets
    Parameters Description
    dataset_id To optimize processing efficiency, I-REAP-related data are organized into distinct datasets, each identified by a unique dataset_id. This allows users to retrieve only the relevant subset of data based on their needs. Refer to the list below for the available dataset_id values along with their corresponding attributes.

    1.
    ir-01-001
    List of enterprise subprojects with basic profile.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • municipality
  • latitude
  • longitude
  • sp_type
  • category
  • funding_source
  • project_description
  • development_objective
  • sp_indicative_cost
  • cost_during_validation
  • estimated_project_cost
  • rpab_approved_cost
  • nol1_approved_cost
  • awarded_cost
  • date_validated
  • commodity
  • stage
  • specific_status
  • Physical Progress
  • beneficiary_total_hh (house hold)
  • beneficiary_total_ff_hh (farmers/fisher household)
  • beneficiary_male
  • beneficiary_female
  • 2.
    ir-01-002
    Approval (pre-procurement) milestones of individual enterprise subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • cluster
  • region
  • province
  • sp_type
  • category
  • stage
  • specific_status
  • indicative_project_cost
  • rpab_approved_cost
  • actual_dates {pre_procurement milestones}
  • . . .

    3.
    ir-01-003a
    Procurement milestones (Simplified Public Bidding 2) of individual enterprise subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • proponent
  • cluster
  • region
  • province
  • city_municipality
  • sp_type
  • sp_category
  • commodity_sector
  • stage
  • specific_status
  • procurement_mode
  • estimated_project_cost
  • cost_nol_1
  • awarded_cost
  • nol1_issued
  • actual_dates {procurement milestones}
  • . . .

    4.
    ir-01-003b
    Procurement milestones (Community Participation (Request for Quotation)) of individual enterprise subprojects.
  • sp_index
  • timestamp
  • sp_id
  • sp_name
  • proponent
  • cluster
  • region
  • province
  • city_municipality
  • sp_type
  • sp_category
  • commodity_sector
  • stage
  • specific_status
  • procurement_mode
  • estimated_project_cost
  • cost_nol_1
  • awarded_cost
  • nol1_issued
  • actual_dates {procurement milestones}
  • . . .

    return_values The API allows users to specify their preferred response format. For this particular API, the user can select one of the output formats available: a CSV file or JSON data. For the specific value for this parameter, copy only one of the following:

    csv

    json

    cluster The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1.
    Luzon A
    • Cordillera Administrative Region (CAR)
    • Ilocos Region (Region I)
    • Cagayan Valley (Region II)
    • Central Luzon (Region III)
    2.
    Luzon B
    • CALABARZON (Region IV-A)
    • MIMAROPA (Region IV-B)
    • Bicol Region (Region V)
    3.
    Visayas
    • Western Visayas (Region VI)
    • Central Visayas (Region VII)
    • Eastern Visayas (Region VIII)
    4.
    Mindanao
    • Zamboanga Peninsula (Region IX)
    • Northern Mindanao (Region X)
    • Davao Region (Region XI)
    • SOCCSKSARGEN (Region XII)
    • Caraga (Region XIII)
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)

    You can select only one cluster as value of the parameter. However, if you opt to call all clusters, you can assign the value all to the cluster parameter.

    region The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1. Luzon A
    • Cordillera Administrative Region (CAR)
    • Ilocos Region (Region I)
    • Cagayan Valley (Region II)
    • Central Luzon (Region III)
    2. Luzon B
    • CALABARZON (Region IV-A)
    • MIMAROPA (Region IV-B)
    • Bicol Region (Region V)
    3. Visayas
    • Western Visayas (Region VI)
    • Central Visayas (Region VII)
    • Eastern Visayas (Region VIII)
    4. Mindanao
    • Zamboanga Peninsula (Region IX)
    • Northern Mindanao (Region X)
    • Davao Region (Region XI)
    • SOCCSKSARGEN (Region XII)
    • Caraga (Region XIII)
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)

    You can select only one region as value of the parameter. However, if you opt to call all regions of one specific cluster, you can assign the value all to the region parameter.

    province The PRDP operates across all 16 regions of the Philippines, which are grouped into four (4) clusters, each comprising the following regions:

    1. Luzon A
    • Cordillera Administrative Region (CAR)
      • Abra
      • Apayao
      • Benguet
      • Ifugao
      • Kalinga
      • Mountain Province
    • Ilocos Region (Region I)
      • Ilocos Norte
      • Ilocos Sur
      • La Union
      • Pangasinan
    • Cagayan Valley (Region II)
      • Batanes
      • Cagayan
      • Isabela
      • Nueva Vizcaya
      • Quirino
      • Santiago City (Component City)
    • Central Luzon (Region III)
      • Aurora
      • Bataan
      • Bulacan
      • Nueva Ecija
      • Pampanga
      • Tarlac
      • Zambales
    2. Luzon B
    • CALABARZON (Region IV-A)
      • Batangas
      • Cavite
      • Laguna
      • Quezon
      • Rizal
    • MIMAROPA (Region IV-B)
      • Marinduque
      • Occidental Mindoro
      • Oriental Mindoro
      • Palawan
      • Puerto Princesa City (Independent City)
      • Romblon
    • Bicol Region (Region V)
      • Albay
      • Camarines Norte
      • Camarines Sur
      • Catanduanes
      • Masbate
      • Naga City
      • Sorsogon
    3. Visayas
    • Western Visayas (Region VI)
      • Aklan
      • Antique
      • Capiz
      • Guimaras
      • Iloilo
      • Negros Occidental
    • Central Visayas (Region VII)
      • Bohol
      • Cebu
      • Negros Oriental
      • Siquijor
    • Eastern Visayas (Region VIII)
      • Biliran
      • Eastern Samar
      • Leyte
      • Northern Samar
      • Ormoc City (Independent City)
      • Samar
      • Southern Leyte
    4. Mindanao
    • Zamboanga Peninsula (Region IX)
      • Isabela City
      • Zamboanga City (Not a province)
      • Zamboanga del Norte
      • Zamboanga del Sur
      • Zamboanga Sibugay
    • Northern Mindanao (Region X)
      • Bukidnon
      • Cagayan de Oro City (Chartered City)
      • Camiguin
      • Iligan City (Chartered City)
      • Lanao del Norte
      • Misamis Occidental
      • Misamis Oriental
    • Davao Region (Region XI)
      • Davao City (Not a province)
      • Davao de Oro
      • Davao del Norte
      • Davao del Sur
      • Lanao del Norte
      • Davao Occidental
      • Davao Oriental
    • SOCCSKSARGEN (Region XII)
      • Cotabato
      • General Santos City
      • Sarangani
      • South Cotabato
      • Sultan Kudarat
    • Caraga (Region XIII)
      • Agusan del Norte
      • Agusan del Sur
      • Butuan City (Not a province)
      • Dinagat Islands
      • Surigao del Norte
      • Surigao del Sur
    • Bangsamoro Autonomous Region of Muslim Mindanao (BARMM)
      • Basilan
      • Lanao del Sur
      • Maguindanao del Norte
      • Maguindanao del Sur
      • Sulu
      • Tawi-Tawi

    You can select only one province as value of the parameter. However, if you opt to call all provinces of one specific region, you can assign the value all to the province parameter.

    group_status Enterprise subprojects have to undergo the project implementation cycle with different stages. These stages are grouped into 2 - pipelined and approved.

    pipelined consists of subprjects under 'Subproject confirmed', 'FS/DED and Safeguard requirements prepared and packaged', 'RPCO clearance for appraisal issued', 'SPA conducted (Depending on treshold)', 'SPAR issued (Depending on treshold)', 'JTR conducted (as applicable)', 'RPAB clearance issued (Depending on treshold)', 'Subproject approved by RPAB', 'RPAB resolution and POW with no objection submitted by RPCO and STEP approved'.

    approved consists of subprjects under 'Subproject Issued with No Objection Letter 1 (NOL 1)', 'procurement', 'implementation', 'completed'.

    If you wish to retrieve all subprojects regardless of their status, assign the value all to the group_status parameter.

    api_key Sidlan API is secured with API Key which can be requested through the following link.
    Request API Key
    GET
    LGU Datasets
    Parameters Description
    dataset_id To optimize processing efficiency, LGU-related data are organized into distinct datasets, each identified by a unique dataset_id. This allows users to retrieve only the relevant subset of data based on their needs. Refer to the list below for the available dataset_id values along with their corresponding attributes.

    1.
    lgu-01-001
    List of LGU projects with basic profile and linked one-to-one details.
  • sp_index
  • timestamp
  • project_title
  • project_description
  • project_objective
  • project_cost
  • unit_measure
  • quantity
  • funding_year
  • contractor_supplier
  • progress
  • status
  • remarks
  • cluster
  • region
  • province
  • operating_unit
  • encoding_status
  • encoder
  • target_start_date
  • actual_start_date
  • target_completion_date
  • actual_completion_date
  • vca_id
  • commodity
  • value_chain_segment
  • pcip_id
  • pcip_title
  • validity_year_from
  • validity_year_to
  • intervention_type
  • constraint_category
  • 2.
    lgu-01-002
    LGU project locations.
  • location_index
  • timestamp
  • sp_index
  • project_title
  • funding_year
  • project_cost
  • progress
  • status
  • encoding_status
  • cluster
  • region
  • province
  • municipality
  • barangay
  • encoder
  • 3.
    lgu-01-003
    LGU project beneficiaries.
  • beneficiary_index
  • timestamp
  • sp_index
  • project_title
  • funding_year
  • project_cost
  • progress
  • status
  • encoding_status
  • cluster
  • region
  • province
  • group_type
  • group_name
  • male_beneficiary
  • female_beneficiary
  • hh_beneficiary
  • af_hh_beneficiary
  • encoder
  • 4.
    lgu-01-004
    LGU project fund sources.
  • fund_source_index
  • timestamp
  • sp_index
  • project_title
  • funding_year
  • project_cost
  • progress
  • status
  • encoding_status
  • cluster
  • region
  • province
  • fund_source_agency_type
  • fund_source_agency_name
  • amount
  • disbursed_amount
  • remarks
  • encoder
  • 5.
    lgu-01-005
    LGU project leveraging mechanisms and MOV.
  • leveraging_index
  • timestamp
  • sp_index
  • project_title
  • funding_year
  • project_cost
  • progress
  • status
  • encoding_status
  • cluster
  • region
  • province
  • leveraging_mechanism
  • mov
  • mov_file
  • encoder
  • 6.
    lgu-01-006
    LGU project VCA and PCIP linkage details.
  • linkage_index
  • timestamp
  • sp_index
  • project_title
  • funding_year
  • project_cost
  • progress
  • status
  • encoding_status
  • cluster
  • region
  • province
  • vca_id
  • vca_title
  • commodity
  • vca_annex_id
  • value_chain_segment
  • pcip_id
  • pcip_title
  • validity_year_from
  • validity_year_to
  • pcip_annex_id
  • intervention_type
  • constraint_category
  • encoder
  • return_values The API allows users to specify their preferred response format. For this particular API, the user can select one of the output formats available: a CSV file or JSON data. For the specific value for this parameter, copy only one of the following:

    csv

    json

    cluster You can select only one cluster as value of the parameter. However, if you opt to call all clusters, you can assign the value all to the cluster parameter.
    region You can select only one region as value of the parameter. However, if you opt to call all regions of one specific cluster, you can assign the value all to the region parameter.
    province You can select only one province as value of the parameter. However, if you opt to call all provinces of one specific region, you can assign the value all to the province parameter.
    group_status LGU project data can be grouped by encoding status.

    approved includes records with encoding status of Approved or Verified.

    draft includes records with encoding status of Draft.

    If you wish to retrieve all LGU project records regardless of encoding status, assign the value all to the group_status parameter.

    api_key Sidlan API is secured with API Key which can be requested through the following link.
    Request API Key
    Loading...