What the explorer covers
The explorer brings together PhilGEPS database diagrams, public export schemas, and mappings to the Open Contracting Data Standard (OCDS).
-
eBidding ERD
Browse 291 candidate table names and 4,267 field rows extracted from 341 diagram boxes. Pin up to three tables to align their fields. Single table shows the original boxes, continuation labels, and key markers.
-
Open Data
Compare four public CSV and Excel layouts, including column order, standardized names, and known headerless files.
-
OCDS Mapping
Search 105 PhilGEPS 1.5 and 126 mPhilGEPS workbook mappings. Browse the separate PhilGEPS 1.5 procurement-method workbook and the Open Data ETL field and codelist mappings.
-
Crosswalk
Compare all four sources across 165 OCDS stage and path combinations. Filter by stage, coverage, or ERD status, open individual ERD fields, and export the current results as CSV.
-
Search
Find ERD tables and fields, Open Data columns, and OCDS mappings from one search.
-
Sources
Download the draw.io diagram, exports, workbooks, registries, and analysis reports. Provenance manifests identify the upstream repository commits and file checksums.
How to read the results
An exact match means the workbook table and field names occur in the extracted diagram. A normalized candidate allows differences in case, spaces, and underscores. A gap means the comparison did not establish an ERD link.
Check field meaning, identifier rules, and record grain before using a match in a transformation. The diagram supplies field names and key markers. Database types and foreign-key references require another source.