Tagged Questions
49
votes
4answers
12k views
30
votes
4answers
682 views
Two closest points on boundary of Postgis geometry
I have a table geofences which stores geometry of polygon.
I also have a point A which is inside the geometry. What I have to do is find the two closest points from point A that lie on the surface ...
27
votes
9answers
25k 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 ...
25
votes
4answers
13k 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 ...
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 ...
22
votes
1answer
439 views
How can I query the postgres Point type from clojureql?
How can I query the postgres Point type from clojureql? I wish to use the PostGIS functionality but clojureql does not seem to include this.
19
votes
2answers
7k views
How do I convert a latitude/longitude pair into a PostGIS geography type?
I'm trying to load a bunch of latitude/longitude pairs into a PostGIS geography type so as to be able to query by location.
In particular I have a table with float latitude and longitude columns and ...
15
votes
1answer
12k views
How to change SRID of geometry column?
I have a table where one of the columns is a geometry column the_geom for polygons with an SRID. I added a new column in the same table with exactly the same geometry data as the_geom.
This new ...
10
votes
1answer
4k views
Postgis installation: type “geometry” does not exist
I am trying to create table with Postgis. I do it by this page. But when I import postgis.sql file, I get a lot of errors:
ERROR: type "geometry" does not exist
Do anybody know how can I fix it?
9
votes
2answers
3k views
Rails with PostGIS
First of all, I'm using Rails3 with Ruby 1.9.2.
I have a problem using PostgreSQL with PostGIS. I've tried two gems:
https://github.com/nofxx/georuby
...
9
votes
1answer
4k 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 ...
9
votes
3answers
2k views
K-Nearest Neighbor Query in PostGIS
I am using the following Nearest Neighbor Query in PostGIS :
SELECT g1.gid g2.gid FROM points as g1, polygons g2
WHERE g1.gid <> g2.gid
ORDER BY g1.gid, ST_Distance(g1.the_geom,g2.the_geom)
...
9
votes
2answers
1k views
MySQL Postgresql / PostGIS
I have lat/lon coordinates in a 400 million rows partitioned mysql table.
The table grows @ 2000 records a minute and old data is flushed every few weeks.
I am exploring ways to do spatial analysis of ...
8
votes
4answers
1k views
How can I query the nearest record in a given coordinates(latitude and longitude of string type)?
I am using GeoDjango with PostGIS. Then I am into trouble on how to get the nearest record from the given coordinates from my postgres db table.
8
votes
1answer
530 views
What is ST in PostGIS?
Almost all the functions in PostGIS start with ST. e.g. ST_Distance_Sphere, ST_GeomFromText, ST_Intersection, etc.
What does ST mean?
...
