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

learn more… | top users | synonyms

2
votes
1answer
1k views

Problem in importing raster data from PostGIS to Geoserver

I am using Opengeo Suite 3.0.2, PostGIS 2.0.3 and PostgreSQl 9.2. I am trying to import raster data from PostGIS to Geoserver but facing an error. I follow this tutorial link to import the raster ...
2
votes
0answers
136 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
1k views

Access PostGIS Raster layer through mapserver

I am trying to use a cgi script calling mapserver to display a raster layer that is stored in a PostGIS database. However, only a blank white image is returned and I don't know where the problem is. ...
2
votes
3answers
673 views

PyQGIS - load PostGIS layer as editable

I can load a PostGIS layer on QGIS' map canvas but "Toggle Editing" button comes "inactive". How can I load vector layer as editable? The code given below loads PostGIS layer on map canvas & "...
2
votes
1answer
70 views

Compare features in PostGIS with updating attributes

I have two polygonal layers: "existing" and "modified". Attribute table of "existing" and "modified" layers have same column "feature_id" - number of feature. Please help me create query which write ...
2
votes
1answer
595 views

Querying PostGIS Raster with MultiPoint

For one of my projects using PostGIS 2 I have a table with GPS tracks (igc_files). It holds records including a MULTIPOINT() column that has about 1,000 points for each record and a column that has an ...
2
votes
3answers
1k 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 ...
2
votes
0answers
455 views

How do I catch PostGIS/PostgreSQL RAISE messages in QGIS?

I have a trigger set up in PostGIS/PostgreSQL which will show a RAISE WARNING when an inserted or updated polygon is within a certain distance of some predefined planning constraints. I want this ...
2
votes
2answers
4k views

Problem when calculating longitude and latitude for points

I have a PostGIS database with SRID=900913 (Google Mercator) and I would like to know the latitude and longitude of points. I use this command: ST_X(ST_TRANSFORM(the_geom,4283)) Following what is ...
2
votes
1answer
691 views

How can I get the corners of a polygon in latitude and longitude?

How can I get the corners of a polygon -a square/rectangle, to be precise- in latitude-longitude format by using its geom value -or some other way, perhaps-? Thanks.
2
votes
1answer
53 views

For Loop Maximum Minimum Distance Between Two Lines

I have a table of line/lane ids in a table called matched_lanes, and I am trying to create a lateral query that on each id in the table to find the maximumum minimum distance between each point. I.e....
1
vote
1answer
446 views

How to calculate the optimum bus route using pgrouting?

My setup for my web page is OpenLayers, Postgresql/postgis and pgrouting. What I do not understand is how I am going to do the routing.I have read many tutorials but I don't understand what my next ...
1
vote
2answers
280 views

QGIS opening file - Very slow on POSTGIS databse with many layers

When opening a qgis file with many layers (20 or so) it takes +5 minutes to load. All the layers come from a single PostGis database. When looking into the server logs, i see that there are many ...
1
vote
1answer
234 views

Problem with using a circle as polygon for querying PostGIS

I'm trying to query PostGIS and find some object features that intersect with a circular buffer created by the user using OpenLayers, JavaScript and PHP. I use the following code for creating the ...
1
vote
1answer
124 views

How to compute a line intersection point in a street layer in postgis 1.4?

I have a street layer downloaded from osm. I need to calculated intersection point as we do in qgis from vector menu -> Analysis tool -> Line intersections. I am new to postgis/postgres. any how i ...
1
vote
5answers
3k views

Unable to install the PostGIS extension to PostgreSQL on Ubuntu 12.04 LTS

I just installed Linux Ubuntu 12.04 LTS (on a virtual machine). I then successfully installed the PostgreSQL 8.4 database management system. I am now trying to install PostGIS, which is an extension ...
1
vote
2answers
3k views

How to offset point perpendicular to line direction in PostGIS

I have a postgis table of points, that are sitting on road centerlines (I've linear referenced them). And the second table with road centerlines themselves. The point table also has a field roadid and ...
1
vote
1answer
83 views

can geoserver select one of many rasters from a postgis table

I have a postgis table with many different rasters in it. Is it possible for geoserver to grab only one of the rasters from the table based on something like a where clause?
1
vote
2answers
5k views

Converting mulitlinestring to linestring in PostgreSQL with PostGIS? [duplicate]

I am using postgres with postgis and I have a set of points which I would like to interpolate with a set of lines. Now my problem is that the set of lines are of type multilinestring. Is there a ...
1
vote
2answers
297 views

Get points along a line at defined distance

I was reading a lot of similar questions here but no one ask about postgis (or I didn't find it). I have a line in postgis and I want to get the point along the line at defined distance. It is ...
1
vote
0answers
782 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 ...
1
vote
1answer
104 views

GeoDjango - save two Point fields, one for geography and one for geometry

Most of the explanations I've read for geography and geometry seem to suggest that one must only use either geometry or geography, and that the only way to use both is to cast/convert between one and ...
1
vote
2answers
3k views

How to select all points within a circle in PostGIS?

I have set of points in a PostGIS Table (Type Geometry). Now, I need to filter points that lie in a circle with a center (C) and radius (R)! I expect C to be of type Point or Coordinates.. R to be ...
1
vote
3answers
394 views

Query to find the Intersection coordinates of multiple Polyon

I am using the below Query to find out the intersection coordinates of 2 Polygon and its working fine,but how to use or modify the query to find the intersection area coordinates for multiple(or N ...
1
vote
0answers
138 views

GeoDjango: AttributeError: function 'GDALAllRegister' not found [closed]

Im trying to get started with GeoDjango. I am using this https://docs.djangoproject.com/en/1.8/ref/contrib/gis/tutorial/ tutorial. When I run "python manage.py migrate" This error occur: "...
1
vote
1answer
1k views

From a trajectory of GPS points to a multiline segment

Given a trajectory as a sequence of GPS points I would like to create a smooth linestring representing a path where a car drove. The data is stored in postgresql: the input trajectory in a table, ...
1
vote
1answer
319 views

Howto setup osm2psql

I'm following these instructions to setup osm2psql . I need it to import osm data file inside a PostGIS DB. The following steps worked fine: createdb -E UTF8 -O user mydb createlang plpgsql mydb I ...
0
votes
0answers
78 views

Is there any feature limit for Spatial data migration to Postgre SQL9.2…?

I am trying to migrate spatial data to Postgre SQL9.2 using 'Postgis Shapefile & DBF Loader 2.0'....Each time it returns a "Runtime error'. Primary data extension - .shp ; Data type - ...
0
votes
1answer
166 views

Find nearest node function

I am trying to get work the next function but i don't know if it is incomplete because the query SELECT * FROM pgr_nearest_node1('jaen',-3.75,37.779); does not provide any results. Here is the ...
11
votes
2answers
8k views

What is the unit used in ST_Distance()?

I wonder what the unit is of the float being returned from ST_Distance. In the documentation it says: ...cartesian minimum distance (based on spatial ref) between two geometries in projected ...
8
votes
3answers
5k views

How can I get the geometry length in meters?

The ST_length() function returns the length of a linestring but not in meters. Is there a function like ST_Length() but in meters?.
7
votes
1answer
161 views

Georeference raster in non horizontal plane

We have raster data which is generated from (vertical) walls. We would like to keep this data in a postgis database and have the spatial reference encoded "the most accurate way". Currently, they are ...
7
votes
4answers
6k views

Importing .shp to postgreSQL

I want to import a shp file to postgreSQL. First I create sql file and then run PostgreSQL. To create sql file, I run this command in windows cmd: shp2pgsql -s 4326 worldCountries.shp worldcountries ...
7
votes
1answer
1k views

Error when using pgsql2shp

I try to export geographical data from a postgis database to a shapefile with pgsql2shp. Normally this works fine, but now I receive the following error. Preparing table for user query... Done. ...
6
votes
4answers
166 views

PostGIS query for selecting features not connected to rest of road network?

I have a dataset of roads in a city stored in a PostGIS enabled database. I would like to identify and remove any feature which is not connected to the rest of the road network. This behavior is ...
6
votes
2answers
927 views

Programmatically setting a layer's bounding box in Geoserver

I have a system built on PostGIS/GeoServer/OpenLayers. Data (a ship's voyage track) is inserted into the database in real-time - a bunch of variables and point geometry type. This is served up via (...
6
votes
1answer
996 views

QGIS WKT Raster Plugin error, what does this mean?

I have been playing with the WKT Raster plugin. I have installed the WKT Raster experimental binaries in PostGIS successfully and followed the instructions in the read me to the letter. When i am in ...
6
votes
2answers
539 views

Find start of river

Edit: Follow-up question here (= Find headwater polygons). How can I determine the start of a river in PostGIS? I have a river network (Multiline) and want to find the startpoints of the rivers. ...
6
votes
1answer
115 views

1-center and k-center problem / maxmin facility problem in Post

is there anybody who has already solved the 1- and k-center problem within PostGIS (optionally with distance metric obtained by pgrouting)? References: 1-center problem in Wikipedia and graph ...
5
votes
1answer
543 views

How to calculate the average distance among set of points as measure of closeness

I have three series (or tables) of points in PostGIS which I want to compare. I would like to know how "close" each series is when compared to the other two. In other words I would need some measure ...
5
votes
1answer
794 views

How to get GeoNetwork to search through PostGIS fields via GeoServer WMS

I can't seem to get GeoNetwork to search through my PostGIS fields via GeoServer WMS. According to the GeoNetwork Documentation: it should loop over datasets served by the service and produce ...
5
votes
0answers
187 views

GeoServer ImageMosaic PostGIS index update

I use GeoServer where I created an ImageMosaic storage following this manual. When I create new datastore, all *.tif files are indexed into DB (PostgreSQL with PostGIS). How can I create new index in ...
5
votes
1answer
142 views

Find all intersections of a LineString and a Polygon and the order in which it intersects it

I would like to find out all intersections of a LineString (River) through Polygons (Municipalities). I would like to list the order of municipalities which the river crosses, using linear referencing....
5
votes
2answers
283 views

Can't get Tiger Geocoder to work in PostGIS

I've installed the PostGIS Tiger Geocoder according to these instructions and loaded in data for the state of New York. Unfortunately, when I try to geocode something... ny_tiger=# SELECT g.rating, ...
5
votes
1answer
1k views

Why do TIF loaded into PostGIS lose their colormap?

I have successfully loaded a TIF image (using raster2pgsql) into my PostGIS 2.0.1 database. I can load the raster image into QGIS and it displays in the correct space. However, it has lost all colour ...
5
votes
1answer
205 views

Can I identify if a point is inside a volume in PostGIS?

We are currently investigating PostGIS as an option to look up three-dimensional blocks which contain a point (and later also lines). At this point in time I cannot see any functionality that operates ...
5
votes
4answers
7k views

How to convert multipoint layer to point

I have a Spatialite layer which is multipoint (following a QGIS Save As from shapefile). I need it to be PostGIS and POINT. I have tried ogr2ogr -nlt POINT and got 'new row for relation "xxx" violates ...
5
votes
2answers
3k views

ogr2ogr kml to shp conversion created 184 shapefiles?! What am I missing?

I'm trying to convert this KML dataset of ice arenas to a shapefile using ogr2ogr (GDAL 1.8). After some initial troubleshooting to get the script running, it's creating 184 different shapefiles (736 ...
5
votes
1answer
2k views

PostGIS Dissolve/Union close polygons

I have approximately 1 million polygons that have been split by lines. However, this has caused one half of a polygon to be separated by approximately 50cm from its other half. After doing a lot of ...
5
votes
1answer
427 views

How to filter points based on proximity while inserting into PostGIS?

I have a large amount of locations that need to be inserted to a PostGIS database. However, I'd like to aggregate these points so that if there's already a location, say nearer than a kilometer, then ...