MobilityData / mobility-database-catalogs

The Catalogs of Sources of the Mobility Database.
Apache License 2.0
257 stars 51 forks source link

Automatically format raw data into import spreadsheet #456

Open emmambd opened 1 month ago

emmambd commented 1 month ago

What problem is your feature request trying to solve? After all the checks are done and a feed submission is certified good for ingestion into the mobility database. It's a manual process of copying required data from the source sheet into the data ingestion sheet mostly when there is a backlog of feeds to extract.

Steps involved: Organize feed information in the [CLEANED] For import tab.

Describe the solution you'd like AppScript should be written to transfer datapoints from source sheet to desired sheet for ingestion.

How will we know when this is done? Each row from the raw data tab is automated moved to the import tab, without any manual intervention.

Considerations