Tagged Questions

0
votes
2answers
146 views

Pass dynamic database function to psycopg2 cursor.execute(statement, params)

I run the following statement through psycopg2 (which works): self.cursor.execute( """INSERT INTO """ + self.config.schema + """.parcel ( id,geometry) VALUES (%s, ST_GeomFromGML(%s))""", ...
1
vote
1answer
379 views

postgis split polygon using points

I would like to extract polygon parts using points to cut it. I have seen ST_Dump and ST_Split but they do not seem to do the trick. Should I create more points in order to create a line segment and ...
0
votes
1answer
118 views

django-evolution doesn't work with django.contrib.gis.db.backends.postgis

I can't run "./manage.py evolve --hint --execute" for my GeoDjango project. It exits with error: File ...
0
votes
1answer
131 views

How can I create a model with compound foreign key?

anybody knows on how to create a model with compound foreign key to another model. e.g. UserInfo: userId, password, key, ... GeoInfo: id, userId, password, storeName, ... In the above sample ...
0
votes
0answers
41 views

Distance query within a certain distance based on value in 'joined' table

I have a bunch of points on a map. Each point represents a User. Users has an attribute called connection_distance which basically means "I only care about other people within this number of miles ...
0
votes
0answers
111 views

Using SQLAlchemy with the PostGIS TIGER Geocoder

I'm attempting to build a geocoder using the Tiger Geocoder extra that ships with PostGIS 2.0. I've got a couple states worth of data loaded (thanks to the relatively easy to follow documentation). ...