PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

learn more… | top users | synonyms

0
votes
2answers
325 views

shp2pgsql srid 2262 polygons NOT in geocordinates

Imported the following shape file: shp2pgsql -c -s 2262 MCGIS_Towns_Villages public.towns | pgsql -d database Queried: SELECT gid, name,st_astext(the_geom) as the_geom FROM towns The ...
0
votes
1answer
1k views

QGIS and MapInfo Projections - EPSG 27700 (British National Grid)

I have some data in a PostGIS table with the projection EPSG 27700. If I export this data from QGIS (v1.8) to MapInfo TAB / MIF when I open the data in MapInfo it has a shift on it. Does anyone know ...
-1
votes
1answer
438 views

QGIS and Python - create line with multiple points in postgis [closed]

How can I create a line, with Python functions, with many points that are records in Postgis? Thank you
-2
votes
1answer
744 views

Postgis error on select all intersetcs of a polygon [closed]

i can get all polygon on intersects this:-7.9245860488441 -37.122384500713,-7.9245860488441 -37.11904223938,-7.9233955716106 -37.1187601948 SELECT * FROM propriedades WHERE ST_Intersects( ...