[OpenLayers-Users] Fwd: design question: how to geocode multiple dynamic "city, country"?

[Stephen Woodbridge]

On 4/11/2014 9:28 AM, zach cruise wrote:
> thanks steve.
>
> if i use openlayers to do this, then i need lat/lon or get lat/lon via
> ajax, as you said (openlayers would make it easier to add custom
> pop-up text).
>
> or i just select from a table of places.

Correct. You need a lat/lon to position the map so you have to get that 
from your city names somehow.

If your table is places is reasonably small, you could just define it as 
an array in Javascript and select from a dropdown list or search for the 
name and then you would not make ajax requests.

Lots of ways to do this.

-Steve

> On Thu, Apr 10, 2014 at 5:01 PM, Stephen Woodbridge
> <woodbri at swoodbridge.com> wrote:
>> Zach,
>>
>> You could do something like have a textarea where the user can enter a list
>> of cities and have a [Add] button, then in JS read the textarea, split the
>> text on linefeed into an array, the cycle through the array and make an ajax
>> request to geocode each city and add it to the map. Or you can just send the
>> whole textarea contents to the server and have it parse and geocode then
>> send back a geocode list like "city,x,y" and parse that in JS and add the
>> markers.
>>
>> -Steve
>>
>>
>> On 4/10/2014 4:39 PM, zach cruise wrote:
>>>
>>> I sent the email below, then realized I can simply add custom dynamic
>>> markers in openlayers on click (see
>>>
>>> http://stackoverflow.com/questions/4624301/adding-custom-markers-dynamically-to-map-using-openlayers,
>>> http://wiki.openstreetmap.org/wiki/OpenLayers_Marker_Example), but
>>> need some real-life examples of how this could be done in batch.
>>>
>>> ---------- Forwarded message ----------
>>> From: zach cruise
>>> Date: Thu, Apr 10, 2014 at 3:48 PM
>>> Subject: design question: how to geocode multiple dynamic "city, country"?
>>> To: PostGIS Users Discussion
>>> Cc: PostgreSQL
>>>
>>> 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?
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/openlayers-users