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

learn more… | top users | synonyms

1
vote
2answers
624 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 ...
1
vote
1answer
535 views

Circle features missing in PostGIS after import from ArcGIS using ogr2ogr

I have a ArcGIS feature class of geometry type polygon. It was created as a convex hull with a 200 meter buffer on a point dataset, aggregating rows on a particular field. The number of points used to ...
0
votes
1answer
47 views

PostGIS Column has Z dimension but geometry does not

I am able to create a geomtry column for 3d multiline using this: CREATE TABLE trajectories ( gid serial NOT NULL, vehid character varying(10), state integer, geom ...
0
votes
1answer
64 views

How can I find the segment of a line that lies within a polygon using Postgis?

Given a "road", represented by a line, that crosses a "state", represented by a polygon: What is the SQL query I can use to find the segment of the road that is within the state? A concrete example. ...
0
votes
2answers
158 views

Unable to implement pgrouting(plugin) pgr_astar routing algorithm (shortest path) [duplicate]

I have been working on a project for indoor navigation. I made the floorplan of the building and road-map for routing purposes as shp files (using JOSM, making GeoJSON and then converting to shp file ...
0
votes
0answers
10 views

Prepare OSM file for PGROUTING use [duplicate]

Well I am new in the GIS World :p well I have a webGIS to realise and I want use OpenStreetMap. well the region I need wasn't vectorised so I modified it with JOSM ( Added Roads and buildings) and ...
0
votes
1answer
288 views

Will MapInfo only read PostGIS data that has been loaded via EasyLoader?

NMZ says in this thread that MapInfo will only read data in PostGIS that has been loaded by MapInfo's EasyLoader. I wasn't sure if this was still the case so I've loaded data into postgis via ogr2ogr ...
0
votes
1answer
120 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
166 views

Aiming to retrieve source and destination from Android, use pgrouting dijkstra to find shortest path and display it back on Android

I have created an Android application that will accept source and destination from the user. It then calls a php page which takes in the lattitude and longitude of the destination and the source. I am ...
0
votes
1answer
114 views

How to automatically convert line features into polygons using QGIS/PostGIS?

I have a master table of line features and a number of tables that I use to join (in the SQL sense) to produce various layers. Some of theses layers consist of boundaries of administrative zones ...
0
votes
1answer
97 views

cartodb: query for the points within a radio from another point - postgis

I've georreferenced a couple of points in a CartoDb table, so now I have a the_geom column of type point I'd like to get all the points that are x meters away from a certain x,y point. So far now, ...
0
votes
1answer
496 views

PostGIS error reads “Geometry has Z dimension but column does not” [duplicate]

I try to store a polygon in GeoJSON format into my PostGIS table. Both are using the CRS EPSG:3857. This is how the polygon is defined. Note that I put in some whitespace to make it more readable. { ...
0
votes
1answer
184 views

What should I start with WebGis Mapserver?

I'm not native English Speaker and I'm a graduated student who want to have a master degree in software engineering. I have a thesis relative with "Build a WebGis for air pollution in Vietnam's ...
0
votes
2answers
120 views

Manually add a new point to PostGIS table [duplicate]

I did accidently delete a table row - or well, in fact a whole subway station. My attempt to solve the problem was this PostGIS function: ST_GeomFromText('POINT(coordinates)') But then PostgreSQL ...
0
votes
2answers
852 views

QGIS: using postgis can I define a layer using sql?

I have a vector layer (call it master) that is stored in postgis and consists of a number of line segments. I also have a collection of sub layers that consist of subsets of the master layer. I can ...
0
votes
1answer
114 views

How to find features within a distance? [duplicate]

I insert the values from lat/long into the points. Those users move around and send me new Lat/long and of course , I made an update of the position. I need to find people that are in a distance ...
0
votes
0answers
480 views

why preview image is blank for ImageMosaicJDBC (postgis raster) layer?

I follow http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html to publish a ImageMosaicJDBC layer in geoserver. the layer seems published ok and saved, but the preview of this layer ...
0
votes
1answer
399 views

How to insert non-spatial data through WFS-T insert?

When i perform wfs-t insert operation using postgis database only spatial data and primary key gets inserted. Can anyone point me to some examples in which attribute data are also inserted along ...
0
votes
0answers
490 views

How to add ECW support to GDAL bundled with PostGIS Windows

I'm currently trying the new raster functionalities of PostGIS 2.0 and I successfully imported some GeoTIFF file into PostGIS (although it only find one band so it's all black and white for some ...
-2
votes
1answer
282 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
480 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( ...