design question: how to geocode multiple dynamic "city, country"?

From: zach cruise <zachc1980(at)gmail(dot)com>
To: PostGIS Users Discussion <postgis-users(at)postgis(dot)refractions(dot)net>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: design question: how to geocode multiple dynamic "city, country"?
Date: 2014-04-10 19:48:58
Message-ID: CAL8icXz5wSrMFfzBAO5up-_93-nFYUXfv_A786to12t2=UO-sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i accept multiple "city, country" from users on-the-fly, and want to
dynamically map them.

i could create a table where i insert their multiple entries, and then
geocode that table for display.

but i also want to avoid giving write permission to the web user.

i could create a schema and restrict write to that schema.

or something better?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christofer C. Bell 2014-04-10 21:25:29 Re: Linux vs FreeBSD
Previous Message Albe Laurenz 2014-04-10 18:54:30 Re: openssl heartbleed