It can. I just usually consider it easier to create a new one
On Apr 25, 2012 1:38 PM, "vishy" <vishalsod...@gmail.com> wrote:
> 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.
>
>
--
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.
