A version of the PostGIS open source spatial database

learn more… | top users | synonyms

13
votes
4answers
3k views

How to create a circle in PostGIS?

I'm using PostGIS 1.5.2, with geometries in SRID:900913. I need create a circles using a list of points as centre, with a radius of 600 kilometers. I'm using this query: INSERT INTO circles (geom) ( ...
7
votes
2answers
2k views

PostGIS ST_Buffer Radius Help

I am trying to find all points within a five-mile radius of a given point. I have a query like this: SELECT * FROM table WHERE ST_Contains(ST_Buffer(geomFromText('POINT(0 0)', 4326), ?), latlon) I ...
3
votes
0answers
425 views

How can I properly add PostGIS data into MapGuide Maestro?

I am having trouble connecting a PostGIS database to MapGuide Maestro. Actually, I have added the PostGIS data into Maestro, but when I click to validate the layer it shows an error message: ...
6
votes
1answer
2k views

How to measure length of line accurately?

In postgis 1.5 for the below given query the answer is 1540651.62674101 meters , SELECT ST_Length(ST_GeomFromText('LINESTRING(77.83042478941326 9.98463896136159,78.03469506809812 23.90398909552571 ...
5
votes
2answers
2k views

how to create a new postgis database for usage with QGIS under windows

After installing postgresql with postgis under windows xp I have 3 databases: postgis postgres template_postgis now I try to create a new spatially enabled database in pgAdminIII: I select ...
6
votes
1answer
2k views

Explode MULTILINESTRING into individual segments in PostGIS 1.5

I have a MULTILINESTRING in PostGIS consisting of several LINESTRING's. Consider each LINESTRING to have a set of POINT's P1, P2, ... PN forming the line segments L1, L2, ... LN-1 where ...
4
votes
1answer
290 views

Self-intersecting polygon using extreme values

I have this polygon POLYGON((1.2E-15 1.1E-15,1.31E-15 1.21E-15,-180 -90,180 90,1.2E-15 1.1E-15)) It uses an extreme coordinates like (1.2E-15 1.1E-15) and (180 90) When I call ST_isValidReason, ...
0
votes
0answers
37 views

driving_distance does not return all sets of distance

As title, I am working with pgRouting, trying to get the distance matrix along the river system. I use driving_distance function and it seems like I am getting what I want: But when I check the ...