Yes, I just ran the 2 scripts in my current database -
spatial_ref_sys.sql and postgis.sql. Seems to work. I am able to
define a geometry column in my current existing table.
On Apr 25, 11:03 pm, George Silva <georger.si...@gmail.com> wrote:
> Yes it can, as long PostGIS is installed.
>
>
>
>
>
>
>
>
>
> On Wed, Apr 25, 2012 at 2:37 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.
>
> --
> George R. C. Silva
>
> Desenvolvimento em
> GIShttp://geoprocessamento.nethttp://blog.geoprocessamento.net
--
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.
