1
vote
1answer
30 views

Can't get SRS from PostGIS using Proj4 text

I'm having a problem transforming a point from the Australian MGA UTM datum (eg MGA Zone 51 http://spatialreference.org/ref/epsg/28351/) to WGS84 using GeoDjango. I've narrowed that down to a problem ...
0
votes
1answer
183 views

How to use Google Maps projection with GeoDjango/PostGIS

I am building a web service with GeoDjango which involves user submitted events including a location. I created a model field for my location using django.contrib.gis.db: location = ...
0
votes
0answers
66 views

Adding GIS feature into an existing postgis table using django 1.6

i am using Django 1.6 on my web map. the problem i got is that i cannot import shapefile with features about 200. . the console has given me this traceback. . Saved: 162-05-0001-005-31 Saved: ...
1
vote
0answers
78 views

django---error in displaying data and displaying it on the map

. i am trying to display a feature queried from postgis. . i also designed a user input field to enter the id of the desired feature to be displayed. . i have already queried the attributes first ...
2
votes
1answer
123 views

Cache geodjango query with bounding box filter

Im using geodjango (postgis) to retrieve points contained inside a bounding box (made by leafletjs), it works so nice, but now I want to cache this query. A tipical query is one like this: ...
2
votes
1answer
259 views

Transform projection from EPSG:4326 into EPSG:900913

. i've got this problem about projection. .i just wanted to know what am i missing. . i already displayed map base layer using openlayers through base_layer = new OpenLayers.Layer.WMS( "OpenLayers ...
0
votes
1answer
111 views

overlay my shapefiles stored in database to the web/browser [duplicate]

I am very much strrugling on how to display my shapefiles stored in postgis database to the browser or to the web.. is there anyone there knows how to do it.? I am using geodjango framework in ...
0
votes
1answer
90 views

retrieving polygon shapes from postgis in geodjango

Can anyone explain how to extract polygon shapes that are stored in a PostGIS database and display it in the browser? I am using geodjango framework in python. I would like a step by step guide on ...
3
votes
2answers
143 views

Distance between Paris and San Francisco with PostGis (out of range coordinates?)

SELECT ST_Distance(gg1, gg2) As spheroid_dist, ST_Distance(gg1, gg2, false) As sphere_dist FROM (SELECT ST_GeographyFromText('SRID=4326;POINT(37 -122)') As gg1, ...
2
votes
1answer
150 views

GeoDjango - return SRID of geometry in GeoQuerySet

I'm wondering if there is a function in GeoDjango which would allow me to determine the SRID of a geometry column in a GeoQuerySet. I know I could do it with a raw SQL query (I'm using PostGIS) but I ...
2
votes
3answers
124 views

How should I implement a many-to-many relationship in a web mapping application?

Scenario: I am given a layer of point locations called "problems." These will be displayed on a web map. Users will then use the web map interface to create and populate field information for a point ...
1
vote
1answer
113 views

Load partial shapefile into Postgis / GeoDjango project

I have a shapefile with Canadian postal codes, but am only looking to load a small subset of the data. I can load the entire data file and use SQL or Django queries to prune the data, but the load ...
9
votes
4answers
476 views

How to use PostGIS to handle complex geoprocessing workflows?

Our organization is considering moving our geoprocessing workflow to PostGIS. We are currently using ArcGIS, with a plethora of custom Python tools used in ModelBuilder. We're moving most of our data ...
3
votes
1answer
78 views

Should states/provinces be stored as geographic or geometric data types?

While reading the GeoDjango documentation, they advise using geometric rather than the geographic data type when storing values that are on a continental scale. The Canadian province of Ontario, for ...
0
votes
1answer
84 views

Anyone recognize this (reference-system related?) pattern of distortion?

I'm new to GIS and was making some progress until getting rather stumped on this one. I've imported what I believe to be lat/lon data based on US FIPS county codes in weather alerts (NOAA SPC). When ...
1
vote
0answers
113 views

Problems combining (union) Multipolygons in geodjango

I'm using geodjango and postgis (1.x), What is the best way to combine (union) a list of multipolygons. in what i assume is rather inefficient i'm looping trough like this combined = multipolygon ...
1
vote
1answer
173 views

GeoDjango / PostGIS - Cut geometry by bounding box

I am looking for a solution to retrieve the geometry(ies) from a polygon/multipolygon within a bounding box in a GeoDjango application. The application I am developing has a requirement to serve out ...
4
votes
2answers
240 views

Shapefile postgis database to be queried by GeoDjango

I would like to create a Postgres database (postgreslq-9.1 and postgis-2.0.2) storing several shapefiles but I am uncertain on how to implement it so I'm searching for some advices. I have already ...
2
votes
1answer
159 views

How to configure and install psycogpg2 - beginner?

I need to install psycogpg2 for working with 'django'. I read the instructions but I dont understand whether to run the commands in command prompt or in python command line. I am lot used to the GUI ...
3
votes
2answers
143 views

Unit testing with postgis 1.5 and django

I'm trying to get some unit tests working in Django/PostGis. When the test database is formed, it doesn't have the postgis and postgis_topology extensions installed. Is there a way to issue commands ...
1
vote
2answers
304 views

Polygon intersection with bounding box with polygon's holes intact

I am trying to serve GeoJSON FeatureCollection tiles with each feature's geometries trimmed to the tile boundary. I am working on a Leaflet plugin to re-assemble the geometries. It works by building ...
3
votes
2answers
959 views

General GeoDjango Opinion

I'm forced to crawl out of my intranet and create a public GIS site with quite an extensive dataset. All of my data is contained within PostGIS. I started dabbling with Geoserver/Postgis/OpenLayers ...
7
votes
1answer
508 views

How to set up GeoDjango with PostGIS 2.0?

I would like to run GeoDjango (Django 1.4) with Postgis 2.0. Whenever I try to run syncdb I get the following error for geographic fields: Failed to install index for stores.Store model: operator ...
0
votes
1answer
800 views

Django client install postgresql/postgis on Ubuntu 12.04

Does anyone know what apt packages one should install for a postgres(8.4)/postgis(1.5) django (1.4) client on ubuntu 12.04? All recipes seem to assume that I want to install the full ...
2
votes
2answers
137 views

Why are the results different for the same point using GEOS Point.transform and Postgis ST_Transform?

I'm trying to define a default point setting for OSM layers in my application and I want users to be able to define the default latitude and longitude in EPSG:4326. What I'm doing right now is to use ...
3
votes
2answers
299 views

Invoke PostGIS functions outside of the database? Need to force 3D in GeoDjango

I'm looking to ensure that all geometries saved to the database are three-dimensional. It's easy enough to do with a call to the database, select ST_Force_3D( ST_GeomFromText( blah blah ) ) ...but ...
2
votes
2answers
899 views

DatabaseError: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAHY type

I am using Django 1.3, PostGIS 2.0 , Postgresql 9.0 and GeoDjango. I had a database with a table for places. This table had latitude and longitude for places in the US. I enabled this database with ...
0
votes
0answers
21 views

Unable to create spatial database for geodjango [duplicate]

Possible Duplicate: How to verify a PostGIS installation on OS X? I am trying to install PostGIS for MacOS X and uptil now this is what i got PostGIS is now configured for ...
1
vote
0answers
79 views

Install PostGIS from beginning [duplicate]

Possible Duplicate: How to verify a PostGIS installation on OS X? Ok, so i tried installing PostGIS for MacOS X from HomeBrew. Once i started installing, brew install postgis It ...
1
vote
1answer
1k views

How to verify a PostGIS installation on OS X?

I am trying to set up GeoDjango and installing PostGIS on my mac and when I am trying to ./configure I am getting this error checking PostgreSQL version... PostgreSQL 8.4.9 checking libpq-fe.h ...
5
votes
2answers
2k views

Using OpenLayers (with OpenStreetMaps) and PostGis for rendering data acquired from GPS tracking device?

I'm researching and planing to acquire data from GPS device and store them in postGIS database, then use geodjango to process/work them out and finally chart them on a map with OpenLayers. Will these ...
1
vote
1answer
188 views

Best way to exclude 0,0 from geography results (PostGIS, GeoDjango)

Using PostGis and GeoDjango with a model having a Geography field I'm trying to exclude results where the location is 0,0. I get the error PostGIS geography does not support the "exact" lookup. The ...
4
votes
1answer
720 views

Geodjango distance between two points appears incorrect

I want to show you something. I am using django+postgis and I am experiencing wrong distance values between two points. This is my model: class Location(models.Model): name = ...
2
votes
1answer
1k views

Using a geodjango PointField with geography=True, my distance calculations are wrong

Here's my model: class ExchangeArea(models.Model): """ An Exchange Service Area, calculated from a phone exchange and surrounding census tracts. """ coordinates = ...
4
votes
1answer
2k views

Why is my PostGIS query not using a spatial index?

I am having an issue with a spatial query that is not making use of indexes. My schema is: CREATE TABLE geoplanet_place ( woeid integer NOT NULL, "name" character varying(300) NOT NULL, ...
6
votes
3answers
1k views

Can Polygons be generalized to MultiPolygons in GeoDjango?

I set up a model with models.PolygonField in geodjango, using postgres as database. I try to import shp into postgres. The problem is, shp (compiled with QGIS) mixes polygon and multipolygon, hence it ...
3
votes
1answer
249 views

How to mix coordinate systems in GeoDjango?

This is a beginner question about working with different coordinate systems in GeoDjango. I've got a GeoDjango object with a polygon field, stored as OSGB coordinates: class Region(models.Model): ...
3
votes
2answers
498 views

PostGIS + pgRouting: Adding dummy links to a road network and performing routing analysis

I'm a beginner when it comes to postgis and pgrouting development. For a project I'm working on and a bit of the algorithm: I have a polygon layer that represents zones I have a line layer that ...
1
vote
2answers
611 views

PostGIS - certain MultiPolygons cause “BOOM! Could not generate outside point!”

I've just posted this at StackOverflow and someone suggested I try here. Original: http://stackoverflow.com/q/5863859/246265 I'm trying to represent a rectangular area which crosses 180 degrees ...
2
votes
4answers
3k views

struggling with GeoDjango install: ERROR: could not access file “$libdir/postgis-1.5”: No such file

I'm installing GeoDjango on Mac OSX. I've followed the official Mac install instructions, which all went smoothly, and am now creating a spatial database template for PostGIS. However, when I try to ...