The OgmAPI database works as follow:
Contains information about a data source. A data source correspond to a dataset published on https://data.gouv.fr.
Example: The full IGN Admin Express archive.
SQL table name: iedb_datasource
A data category. For example the administrative boundaries of the communes.
SQL table name: iedb_category
NULL
when the category has no parent.A subset (or the full dataset) of a DataSource linked to a category.
Example: The individual data files (i.e., communes) within the IGN Admin Express archive.
SQL table name: iedb_sourcecategory
Describe the labels provided by this dataset on it’s subsequent Zones.
SQL table name: iedb_labelsdescription
A SourceCategory that has no Zone rows. This SourceCategory has been used to enrich the labelizing Zones with new labels.
Example: The Loyers datasets enriching the IGN Admin Express Communes dataset with information about rent prices.
SQL table name: iedb_sourcecategory_label_by
from_sourcecategory_id
)source
. (SQL: to_sourcecategory_id
)Labeled geographical area. Note that internaly the Zone table is partitioned by SourceCategory that provide geometries.
SQL table name: iedb_zone