search

ojalaquellueva / gnrs

Geographic Name Resolution Service
MIT License
6 stars 0 forks source link

Add dynamic data dictionary to DB & API #11

Closed ojalaquellueva closed 3 years ago

ojalaquellueva commented 3 years ago

Adapt data dictionary code from BIEN DB to generate table dd_tables, dd_cols and dd_col_values, containing table descriptions, column descriptions and lookup column value lists and definitions. Table and column values should be embedded in schema DDL; first two tables generated automatically from this information. Lookup column values either (a) generated from CSV, which forms part of input data package for DB build, or (b) harvested empirically from populated tables and expanded/edited in CSV dumped. Although method (b) is used for BIEN because of large number of open pick lists, method (a) is probably fine for GNRS as most lists are closed and short.

Also add API routes to serve this information. Among other uses, GNRSweb should call this information and use to construct online data dictionary on the fly. Once finished and tested, this feature should be transferred to TNRS and all future BIEN services.

ojalaquellueva commented 3 years ago

Resolved with version 1.7