Tagged Questions
9
votes
1answer
3k views
How to debug: Internal Error current transaction is aborted, commands ignored until end of transaction block
Hi Stackoverflow people,
I do my first steps with GeoDjango and I am looking for better options to check faulty sql statements.
So far, I simply wanted to safe a lng+lat point in my postgresql ...
3
votes
2answers
10k views
SQL query for point-in-polygon using PostgreSQL
I have the following simple table:
CREATE TABLE tbl_test
(
id serial NOT NULL,
poly polygon NOT NULL
)
WITH (OIDS=FALSE);
I then try to insert a row with a polygon:
insert into tbl_test ...
22
votes
4answers
12k views
GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?
EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied.
I need to analyze a few million geocoded records, each of which will have latitude and longitude. These records ...
27
votes
9answers
22k views
good postgresql client for windows? [closed]
coming back to postgresql after several years of oracle ...
what are the state-of-the art postgresql administrative/ddl generating/data inserting frontends on windows? it would be nice if it had ...
6
votes
4answers
3k views
Can I ask Postgresql to ignore errors within a transaction
I use Postgresql with the PostGIS extensions for ad-hoc spatial analysis. I generally construct and issue SQL queries by hand from within psql. I always wrap an analysis session within a ...
0
votes
2answers
282 views
GeoServer won't write to my PostgreSQL updateable view
Following on from this earlier question I'm on PostgreSQL 8.4 and am having trouble with updatable views.
I have a view:
CREATE VIEW filedata_view
AS SELECT num, id, ST_TRANSFORM(the_geom,900913) AS ...
0
votes
1answer
398 views
How to update table when view is updated?
I want to update table when her view is updated. I use postgresql/postgis.
I create view.
CREATE VIEW filedata_view
AS SELECT num, id, ST_TRANSFORM(the_geom,900913)
FROM filedata
And now when its ...
22
votes
1answer
3k views
Error Saving geodjango PointField
I have a geo model with a PointField property. Everything works perfectly locally, but when I try to save an instance on the server, I get the following error:
django.db.utils.DatabaseError: invalid ...
5
votes
2answers
1k views
ST_DWithin takes parameter as degree , not meters , why?
The ST_DWithin document says , the third parameter(distance) is in meters. But when I execute some query , it seems it takes the 3rd parameter as 'degree' ?
Here is my simplified table structure :
...
4
votes
1answer
1k views
Migrate SPATIAL data from Oracle to Postgresql
I am trying my best to migrate a spatial database from Oracle to Postgresql and failing miserably.
I have tried many different avenues as you can see from my previous question on here and none are ...
1
vote
4answers
414 views
How can I query all my data within a distance of 5 meters?
I am using GeoDjango with PostGIS. Then I am into trouble on how to query my postgres db table to get all data within a distance of 5 meters.
UPDATES1
I am using GeoDjango 1.2.7
I found something ...
6
votes
5answers
3k views
Why is PostgreSQL so slow on Windows?
We had an applicationg running using MySql. We found MySql was not suitable for our app after we found that it didnt support some of the GIS capability that PostGIS has (note: mysql only supports ...
0
votes
2answers
305 views
Postgres combining multiple Indexes
I have the following table/indexes -
CREATE TABLE test
(
coords geography(Point,4326),
user_id varchar(50),
created_at timestamp
);
CREATE INDEX ix_coords ON test USING GIST (coords);
...
0
votes
2answers
231 views
Assign_vertex_id function
When I execute the following query;
SELECT Assign_vertex_id('ways', 0.00001, 'the_geom', 'gid')
I am getting the following error;
NOTICE: CREATE TABLE will create implicit sequence ...
0
votes
1answer
177 views
How calculate things from many tables by using a few queries?
note: this question is related to PostGIS and Postgresql and is implemented with PHP
Now I have Table A :
gid | kstart | kend | ctrl_sec_no | the_geom |
626 | 238 | 239 | 120802 | ...
