In CartoDB, I want to allow a group of students to collaboratively add rows to a single table. The issue is made more complex because the table is to contain lines, not just points, so Georeferencing is harder. Ideally, students simply draw the points on a shared public map, and the rows show up in one table in my account.
The Export function for a table won't work, as it shares the data as a file, rather than allowing multiple users to add rows to a single file. Duplicate Table and Duplicate Visualization keep the data tied to a single user. Merge tables creates considerable overhead. I dislike having a shared username/password for 20 people, and that might not even work, depending on how Carto manages lockfiles etc.
The answer may simply be "Make 20 maps, upload the KML, and merge it all", but before I go that route, I'd like to know if there is a preferred way to take input from multiple users into a single table?