So, the existing database cannot be used as a postgis db?
On Apr 25, 9:21 pm, Jeff Heard <jefferson.r.he...@gmail.com> wrote:
> Create a new spatial database and import the data. That's by far your
> easiest option. You'll need to create a POINT column (look at the PostGIS
> doc on how to add spatial columns) and then add rows either using the ORM
> or with a spatial query including something like this as part of the insert:
>
> GeomFromText('POINT(' + x + ' ' + y + ')', 4326)
>
> where 4326 is the spatial reference system for longitude/latitude.
>
>
>
>
>
>
>
> On Wed, Apr 25, 2012 at 11:17 AM, vishy <vishalsod...@gmail.com> wrote:
> > Hi,
>
> > I need to do spatial queries like find places within 5 miles of a
> > location given in latitude and longitude. So, I am thinking of
> > exploring PostGIS and GeoDjango. I have installed both. Now, I already
> > have a database which has a table for places with latitude and
> > longitude. Can I enable this db to use postgis and add column to this
> > table? Or, do I have to create a separate spatial db, create a table
> > with a column of geometry type and import data into that table (from
> > places table).? If I can use the existing database, how do I enable it
> > to use PostGIS?
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Django users" group.
> > To post to this group, send email to django-users@googlegroups.com.
> > To unsubscribe from this group, send email to
> > django-users+unsubscr...@googlegroups.com.
> > For more options, visit this group at
> >http://groups.google.com/group/django-users?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
