Tagged Questions

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

learn more… | top users | synonyms

2
votes
0answers
38 views

OpenGeo: GeoExplorer cannot upload shapefiles into PostGIS

I have installed OpenGeo 4.1 on Ubuntu Linux 12.04 following the official instructions. I then followed the tutorial Load your data with GeoExplorer. I was able to zip and upload a few shapefiles. ...
1
vote
1answer
58 views

Query to get convex hull

Is the below query correct to get a convex hull shape: DATA "the_geom from (select ST_ConvexHull(ST_Collect(the_geom)) As the_geom FROM xyz) as foo using unique id using SRID=XXXX"
1
vote
0answers
26 views

Error in querying data

I have a mapserver file as below , I get blank page with no map executing this query: NAME var DATA xyz STATUS ON TYPE POINT DUMP TRUE ...
3
votes
0answers
52 views

Create a Shape file from Sql dump file

I am trying to map data by querying a table called xyz. I need to show the the_geom data on the map. I have below query in my mapserver .map file: DATA "the_geom from xyz using unique id using ...
2
votes
1answer
62 views

Order by geometry columns

I am wondering how it really works, I mean "order by" statement when it comes to geometry/geography columns in postgis/postgresql. Besides that really need a way gather rows from a table with a point ...
0
votes
0answers
21 views

at which location to run psql2shp command in linux [duplicate]

I have linux system which I have connected remotely and I am not able to use $psql2shp command in the command line. I went to /usr/local/pgsql/data to run the command but I was unable to run. I dont ...
0
votes
1answer
54 views

Rollback error when restoring SQL dump file in postgresql using PSQL console via Pgadmin

I am trying to restore a pg_dump SQL file into my postgresql database using PSQL console , where I typed the below command: \i 'c:/../path/to/sample.sql' when I run this I get an error saying ...
2
votes
2answers
80 views

Where to type pgsql2shp command

How to convert post gis database into shapefile, I found that I need to use pgsql2shp command on postgis database query , But how to use it and where to use it. Do I have to use it in the postgre sql ...
2
votes
1answer
41 views

How to populate geography point using ST_MakePoint(long, lat)

I have a table called customer_campaign, and there is an empty column geom(geography) in it. So I want to fill it up by using ST_MakePoint(long, lat) in PostGIS, lat and long are two columns in the ...
0
votes
0answers
48 views

Geoserver ( Java.exe ) cause server to run 100%

Our server runs at 100% CPU when using map services build on geoserver + postgresql I can not find anything in geoserver logs. It is Java.exe takes 100% CPU and because of that server can not do ...
1
vote
3answers
103 views

How to export streets in a certain area from one shapefile to a new shapefile?

I have a shapefile with the roads from Europe and I want to export in a new shapefile only the roads from Greece. I tried to delete the other roads but there are too many and I have no attribute to ...
1
vote
1answer
30 views

How can I strip out M values from a MULTIPOLYGON with PostGIS?

The title is self-explanatory. I wonder if there is a simple function like ST_Force2D for the M values?
4
votes
2answers
122 views

Split lines at intersection points

I've got some linestrings covering a road network, and need to split them at the crossroads. Does anybody have any idea on how to do it? I'm using QGIS 2.4, with a Postgis 2.1.3.
1
vote
0answers
40 views

Clustering the WGS84 point features (projection transformation aspects)

My question is quite trivial and was discussed many times before (like here) but in our case it has the confounding extra requirements... The list of sparsely distributed 2d point features is stored ...
2
votes
1answer
42 views

Performing equivalent of ArcGIS Identity_analysis (line with poly) using PostGIS?

I've got a section of arcpy code that I need to port PostGIS: Identity_analysis with the in_features being a line featureclass and the identity_features being a polygon featureclass. I'm primarily ...
2
votes
0answers
44 views

Rebuilding a Polygon from the points within it, in PostGIS

This question is an update on the problem formulated here. I wanted to redefine the border of a set of polygons, in order to "smooth it". My first approach (described in the former question) was to ...
2
votes
1answer
48 views

Redefining the border of a polygon in Postgis

I have a PostGIS algorithm that writes a table with "pixelated" polygons, that I will call "clusters". My idea is to smooth the edges of these clusters using concave hulls (ST_ConcaveHull). To do ...
2
votes
1answer
57 views

Positons from GPS lanes inside a polygon

i have a lot of lanes like the orange lanes at the below picture (latitude and longitude values). Now i need all values from each lane inside the red polygon. What is the easiest way to realize ...
0
votes
1answer
32 views

A Tool for Mapping Metropolitan Statistical Areas (MSAs) to Addresses

My and team and I ran a series of zip codes from addresses within our data set against MSA to Zip Code data found on The Census' website here. We found that a relatively high number of the addresses ...
1
vote
0answers
81 views

All map services display pink tiles

I have implemented mapserver in Ubuntu 14.04 with postgresql 9.3, postgis and imposm using GitHub tutorial. After completing the tutorial all map services display pink tiles not map info. i was not ...
2
votes
0answers
20 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
62 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 ...
2
votes
0answers
42 views

A* pgRouting issue with x1,y1 and x2,y2 values

I am trying to use the A* algorithm in a topology I have made in PostgreSQL. I can fill the x1,y1 and x2,y2 the latitude/longitude, but I have read that the same version has problems with ...
3
votes
1answer
50 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
2answers
36 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?
2
votes
2answers
144 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
11 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
3
votes
1answer
58 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 ...
9
votes
1answer
240 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
47 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
35 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
51 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
42 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
63 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
60 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
40 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 ...
6
votes
2answers
377 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
96 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
47 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
12 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
24 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
41 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
28 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
37 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
56 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
35 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 ...
9
votes
1answer
167 views

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
30 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
1answer
221 views

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
48 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 ...