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

learn more… | top users | synonyms

1
vote
0answers
4 views

ArcGIS dissolve analysis output issues in geoserver wfs/ PostGIS

I have an ArcGIS dissolve analysis output (parcel data) that needs to be loaded on PostGIS and published as a wfs from geoserver. The issue is that the ArcGIS dissolve output shapefile, although can ...
3
votes
0answers
15 views

Intersection of a vector linestring and underlying DEM

Following is an screen-shot where ASTER DEM raster layer has been overlaid by a road linestring vector layer. I want to extract those DEM pixels which are lying exactly beneath the linestrings. I want ...
3
votes
1answer
34 views

Bounding box of a set of MULTILINESTRINGs PostGIS

I have a PostGIS table with a geometry column (geom) and a type column. The geom column contains only MULTILINESTRINGs and the type column contains tags that tell me what each MULTILINESTRING ...
0
votes
1answer
21 views

How to get the tripoint of three or more polygons in PostGIS?

Assume that I have a column containing polygons. What is the SQL statement to get the list of points that three or more polygons touch with each other?
0
votes
0answers
30 views

QGIS WFS Error - Could not commit changes to layer

I have a PostGIS database being served by Geoserver. I can load the layers I want into QGIS no worries; however whenever I try to edit the layer I get this error message: Could not commit changes to ...
0
votes
0answers
9 views

Get a geometry point along a line from another point with distance using OGC SFSQL

I am wondering is that any quick OGC SFSQL function (or any other spatial query) which return a geometry point that: The point is x distance along a line from its A-End ? ps: I am using postgis 2.x
2
votes
1answer
25 views

Extract longitude latitude and radius from POSTGIS column

I have entered the circle in the Geometry type column (name=shape) in my POSTGIS as following: ST_Buffer(ST_MakePoint($longitude, $latitude)::geography, $radius)::geometry Then I extracted the ...
6
votes
1answer
122 views

Can PostGIS and QGIS provide dependable multi-user editing?

After considering a few options, I'm trying to give my 15-20 QGIS 2.2 users the ability to concurrently view/edit one or two basic point PostGIS layers, largest one has just 16,000 records. I've ...
2
votes
0answers
27 views

QGIS There isn't entry in geometry_columns!

In PostgreSQL v9.3 with PostGIS v2.1 extensions I created a view from two tables (sites & visits). The site table contained a point geometry column (the_geom), which was included in the created ...
0
votes
0answers
21 views

Find correct SRID

I'm learning PostGIS raster, and importing GeoTiff with raster2pgsql. This command line tool states: -s <srid> Set the raster's SRID. Defaults to 0. If SRID not provided or is 0, ...
2
votes
0answers
31 views

Point sampling along a pole-wrapping coastline with PostGIS

I am working on a task that requires me to get sample points every 1000KM along coastlines, and have run into a problem with Antarctica. From what I can tell, it seems to be an issue with the use of ...
2
votes
1answer
33 views

Why does the earth drop off faster than expected over a geodesic when converting from lat/lon to cartesian coordinates?

In PostGIS 2.1.1, I've been plotting elevations from a raster over distances, but noticed that beyond 1km, the earth's curvature seems to be greatly exaggerated. In this example over a 40km geodesic ...
1
vote
1answer
27 views

Building web application to get PostGIS query from user and view result map using GeoServer via OpenLayers?

I'm a newbie in web-map application area. I just found the small application in this tutorial interesting I am a bit confused, because when i publish a map using geoserver and openlayer, I have to ...
2
votes
1answer
35 views

Databases supporting intersection of multipolygons and a set of points

Currently we use PostGIS to store thousands of MULTIPOLYGONs and we can then use ST_Intersects to return any that rows contain any point in an input collection of points. Are there any other open ...
0
votes
1answer
21 views

Ubuntu QGIS 2.4.0 SSL connection to remote PostGIS fails b/c can't specify certificates

I can connect with SSL in PGAdmin to my remote server, but it requires specifying the filepaths for certificate files due to my having different certs for different servers. However, when connecting ...
5
votes
1answer
291 views

Using ArcGIS and QGIS together in multi-user editing environment?

We have a GIS staff of 7, and another group of about 14 who "use GIS" from time to time. We really, really want multi-user editing. Mostly of a large point file, and we're almost never in the same ...
3
votes
2answers
39 views

How can I extract all distinct values from a PostGIS Raster?

I am working with an integer raster in PostGIS 2.1 and I would like to extract all distinct values in that raster. I was hoping to be able to do something along the lines of the following query, but I ...
1
vote
0answers
37 views

List of vector to one raster in PostGIS

Hi PostGIS developers! I need to rasterize a part of OSM map by coordinates. I found rather good algorithm, but can’t finish it. I have problems in STEP 3. I described all algorithm here – may be ...
0
votes
0answers
10 views

What do pixeltypes in PostGIS raster mean?

I'm trying to build a raster in PostGIS from a vector layer and I was curious as to the meaning of pixeltypes in the raster geometry? How does it effect my raster?
0
votes
1answer
15 views

Run pgr_createTopology() on custom geometry(linestring) table

How could I create a topology for a custom generated geometry table having just the_geom geometry(linestring) column? Because pgr_createTopolgy() asks for the gid column also for a given table, which ...
2
votes
1answer
27 views

Find a path between an origin and destination given scattered points

We have a postgis database containing a lot of ordered (by date/time) nautical point (lat/long). Each of these points are affected to a leg between an origin and a destination (both origin and ...
0
votes
0answers
17 views

Export qgis vector layer to PostGIS table using python

I've created script, which does bunch of stuff, and in the end, I would like to export it to postGIS table. What is easiest way to do such export using qgis api or sth. I dont want to write SQL ...
1
vote
0answers
34 views

From QGIS to PostGIS [duplicate]

I want to download my data from QGIS to an existing table in Postgresql. I tried to use DB Manager, but the field add to existing table doesn't work. Maybe somebody knows what the problem is? Or is ...
1
vote
1answer
18 views

Configuring SFCGAL to PostGIS Db

I was using PostgreSQL with PostGIS and Pgrouting. Recently I needed to install SFCGAL for some extra functions for my PostGIS db. After installing SFCGAL, now I don't know how to update my PostGIS db ...
1
vote
0answers
25 views

Create geometry column of type 'PointZM' in PostGIS

I want to add a geometry column with geometry like "PointZM", "PolygonZM". I have written something like this: SELECT AddGeometryColumn ('data_rivne','geo_point','geom2',0,'POINTZM',0); But it ...
5
votes
0answers
87 views
+50

How to compute the smallest network that connects all points using PostGIS?

I have a set of postgis scripts which generates two tables - one of a set of points and the second a set of roads which surround them. All data is in the same projection and both outputs are stored in ...
1
vote
1answer
12 views

Collecting multipolygons into a single multipolygon with ST_Collect() in PostGIS

I would like to collect 50,000 individual multipolygons into one big multipolygon. Unfortunately when I perform ST_Collect(geom) it bundles them into a geometry collection and cannot be cast as ...
6
votes
0answers
75 views
+50

How to use ST_DelaunayTriangles to construct a Voronoi diagram?

With PostGIS 2.1+ we can use ST_DelaunayTriangles() to generate a Delaunay triangulation, that is a dual graph of its Voronoi diagram, and, in theory, they have an exact and reversible conversion. ...
1
vote
1answer
46 views

PostGIS query losing geometry column information

Using PostGIS I want to collect all attributes into one polygon. The old table looks like this: Column | Type ---------+------ xyz_cols | `xyz` geometry | geometry(MultipolgyonZ, 2193) Performing ...
1
vote
2answers
64 views

How to validate OpenLayers area calculation using PostGIS?

I am working on a GIS API that work on top of OpenLayers. I have a feature that calculates the area of a drawn polygon. I have tested it on the browser and the areas I got, appear to be correct. For ...
2
votes
2answers
38 views

Did I set up Tiger Geocoder incorrectly?

I set up Tiger Geocoder in PostGIS on my local box (PostGIS 2.1.3, PostgreSQL 9.3.5, Tiger 2013 data). The problem I'm running into is that on almost every street most of the points are clustered, ...
0
votes
0answers
32 views

R PostGIS convert SpatialPolygon to PostGIS table

I've been having some success in scraping some webdata and converting it from HTML to spatial data as originally asked here: Parse PHP/HTML to shapefile or similar I've been using R to both fetch the ...
3
votes
1answer
100 views

Extracting centerline of a Complex-Polygon in PostGIS/Python

Any idea how to extract the centerline of the following polygon (Fig1) using PostGIS functions or Python modules? I was trying Voronoi Function but thats not helpful for this kind of shape. I want ...
2
votes
0answers
42 views

N Nearest Neighbours efficiently PostGIS/Python

The data is worldwide about a million points, lat/lons, with an id and an importance value (0.0 to 1.0), and it's limited to being on land. Ideally I need to cluster all 1 million points into 100,000 ...
3
votes
1answer
47 views

PostGIS: Get closest point between geometry and Multipoint

I think my question is not that difficult for GIS professionals, but i didn't found an answer to my problem (even not in other questions). Problem: I have given two tables (table1,table2) with Points ...
2
votes
1answer
64 views

PostGIS - How do I create a line that directly connects two earth points without travelling over a geodesic?

In PostGIS 2.1.1, I've noticed that if I create two distant earth points with equal altitude and then create a line connecting them, as I gather interpolated Z coordinate data along the line my Z ...
1
vote
0answers
33 views

Convert multiline to polygon

perfect result Shapefiles How I can convert this closed line to polygon with PostGIS? I tried many functions like ST_Polygonize, ST_MakePolygon, ST_BuildArea. I got some results, but not a perfect ...
1
vote
0answers
23 views

Finding areas with high POINT density from PostGIS table using Python

I have a PostGIS table with thousands of POINT objects and I want to find areas that have a high density of points. I have the DBSCAN clustering algorithm implemented in Python which does exactly ...
1
vote
0answers
32 views

Why does the postGIS file lose geometry?

I am loading shapefile data from a GPS into PostGIS via Leica ZenoOffice. This apparently imports fine with it's geometry in the attribute table. However, when I add a postGIS layer in QGIS the file ...
0
votes
0answers
9 views

Dot density inside polygon (kml co-ordinates)

I have a kmz url(its not in local), which has so many polygons in it. Which contains co-ordinates something like: <LinearRing> <coordinates>138.878021,-34.971903,0.0 ...
0
votes
0answers
20 views

GDAL_Translate not compressing when NoData value is set

I am trying to compress a .TIF file using GDAL_Translate or GDAL_Warp. My Raster is 32mb to start with. When I use GDAL_Translate with the COMPRESS=PACKBITS option, it compresses to 1.9mb. However ...
4
votes
1answer
48 views

Should geometries be drawn using rhumb-line or great-circle paths?

I work with WGS-84 coordinates and, most of the time, my map display (luciadmap) is in Mercator projection. My client is surprised to see that, for a rectangular geometry: the line between the 2 ...
0
votes
0answers
8 views

openlayer wfs protocall reset on map zoom

By considering wfs-example example. I have added one layer on map with BBOX and savestrtegy and add controls(add,delete,modify and save). wfs = new OpenLayers.Layer.Vector("Editable Features", { ...
1
vote
0answers
23 views

Create “grid” of polygons with the same 3D area based on an underlying raster variable (e.g. DTM height)

This could apply to point or raster values but imagine a raster of a continuous variable such as height (DTM). Is there a way to create a complete coverage of polygons that will have an equal area, ...
2
votes
1answer
30 views

Error in installing PostGIS 1.5?

I am installing PostGIS 1.5. After giving the command ./configure, it is showing that: pQserverversion in -lpq not found. configure: error: could not find libpq. What does it mean? I am ...
1
vote
1answer
24 views

How to calculate the intersection between WFS layer and a PostGIS table

I need to calculate the intersections betweek a WFS layer and the geometries stored in PostGIS table. Then I should save the geometries of the intersections in a separate PostGIS table. Do you have ...
1
vote
0answers
36 views

Error when trying to visualize geography data with QGIS

I use PostGis, and want to use QGIS to visualize data. But I get error message when trying to show the points in the table. I create a table: CREATE TABLE poi ( id text NOT NULL, coord ...
1
vote
1answer
31 views

PostGIS - How to do ST_UNION on each feature of a geojson FeatureCollection

I have a simple geoJSON featureCollection composed of 2 features: featureCollection = {u'type': u'FeatureCollection', u'features': [{u'geometry': {u'type': `u'MultiPolygon', u'coordinates': ...
1
vote
2answers
71 views

Export polygon in geojson as multipolygon

Anyone knows if is there any way to export a polygon layer in geojson, as multipolygon? I have a multipolygon shapefile. But there are single and multi polygons. When I export it to geojson, I got ...
0
votes
0answers
17 views

uploading raster format tif to postgis through raster2pgsql

I have the same problem Uploading raster format(*.tif) to postgis through raster2pgsql How to you fix it, if it is a problem? Because my raster column is empty. Of if it's ok, what does it mean? ...