I'm wondering what would considerations I should make for using CartoDB as a tool for collecting geo-located citizen comments.
The form inputs, as well as the XY, are then fed to a google spreadsheet where they are manually extracted to a CartoDB map on our main site.
Can CartoDB be used to replace this google doc method, and what do I need to think about in terms of using the SQL API?
Is it a good practice to expose the necessary information to use that SQL API?
How could I use the 'get my location' feature on most browsers to automatically get a users location and feed it into the geometry of row in a CartoDB table?