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

learn more… | top users | synonyms

1
vote
1answer
70 views

Import of OSM data into PostgreSQL with osm2pgsql polygon problem

I've mananged to import my great-britain osm file successfully into postgres and I can query everything fine. osm2pgsql -s -j -G -l --number-processes 8 -K -U james -C 10000 -d osm myfile.osm I'm ...
1
vote
1answer
130 views

Display a layer from geoserver using OpenLayers 3

I'm wondering how to display a Layer in OpenLayers 3 which I host in Geoserver. I imported the Layer from a PostGIS-DB and it is possible to display it using the geoserver preview option. The Layer ...
0
votes
1answer
45 views

I converted a KML file into a PostGIS db using ogr2ogr. How do I publish all the tables as seperate layers?

As the title says I converted/imported a KML file into my PostGIS database using the ogr2ogr command. Now I am trying to publish each table as a seperate layer onto a GeoServer. I know about cURL, but ...
4
votes
1answer
55 views

How to Specify FID column name in shp2pgsql

In ogr2ogr I can specify the name of FID column using the option -lco FID={columnname} when importing a spatial data in PostGIS database. I am using shp2pgsql in case of shapefile and cannot find a ...
0
votes
1answer
45 views

Loading a specific county dataset in PostGIS

I want to load a specific county dataset in PostGIS. I can load a state script using: SELECT loader_generate_script(ARRAY['CA'], 'linux'); However, I want to load dataset only for Los Angeles County ...
0
votes
0answers
34 views

How to get a specific street using OSM with PostGis

I want to get the polygon form a specific street from the OSM data importtes with osm2pqsql using PostGis. Since the streetname isn't the only identifier I wanted to add the postal code as a second ...
0
votes
1answer
81 views

Polygon intersection with LineString in PostGis

I have a table which contains GPS coordinates at certain times. I created a LINESTRING from them ordered from the oldest to newest. I also have a POLYGON and I would like to determine the subset of ...
0
votes
3answers
130 views

ST_Distance values in kilometers

I need to make a query to measure the distance from a given point to all points in a table and return the five closest to that point. The problem is I can't convert the distance to kilometers. Here ...
0
votes
1answer
54 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 ...
0
votes
2answers
72 views

Connect to postgres localhost in QGIS

I am firly new to actively work with databases. I wanted to try out some stuff on my home computer where I have installed pgadmin and postgres previously. I can connect to my localhost in pgadmin but ...
0
votes
0answers
20 views

Is it possible to get Metadata from railway attributes using OSM at PostGIS

I am using a query that gets me all tram stations from my data using a POstGis Database. I have OSM Data from Geofabrik. Query: SELECT point.osm_id as id, st_X(point.geom) as lng, ...
0
votes
1answer
44 views

PostGIS Raster ST_AsRaster: error when creating raster from TIN surface

ERROR: rt_raster_gdal_rasterize: Could not create OGR Geometry from WKB ********** Error ********** ERROR: rt_raster_gdal_rasterize: Could not create OGR Geometry from WKB SQL state: XX000 ...
1
vote
2answers
151 views

How to calculate the Oriented Bounding Box (OBB) of a polygon or point set?

I'd like to calculate the "Oriented Bounding Box" (OBB) which is the enclosing rectangle aligned to the longest extent of a point set (which is not necessarily aligned with the axes of the co-ordinate ...
0
votes
1answer
24 views

Is the PostGIS Raster primary key required to be named rid?

In all examples from the PostGIS Raster reference the primary key in tables with a raster column is named rid. I wonder if that naming is expected by any functionality of PostGIS itself or any client ...
0
votes
0answers
44 views

Positioning a Map

Somebody recommended me to use this site:- http://cs2cs.mygeodata.eu/ after I explained that this coordinates[-28.23078, 28.30707] which belongs to Bethlem in South Africa centers the map to towards ...
1
vote
1answer
54 views

Adding PostGIS raster to QGIS via database manager

When I attempt to add a PostGIS raster to QGIS I get a GDAL error saying I need to set PGHOST. I have set PGHOST with export PGHOST=localhost but still get the error. How can I resolve this ...
1
vote
2answers
61 views

Planet_osm_point versus Planet_osm_nodes for querying places

Hello I am using a PostGis Database with OSM Data. After importing the data with osm2pgsql in slim mode I found a table named Planet_osm_nodes that has places also. It seems really compressed and has ...
1
vote
1answer
62 views

How to detect gaps in a MultiPolygon table with Postgis?

I have mapping of land use. In it, I need running topology to detect gaps between polygons. Is there postgis's function to do this? Thanks
0
votes
1answer
83 views

pgr_drivingdistance wrapper

Pgr_drivingdistance function works as : SELECT seq, id1 AS node, cost FROM pgr_drivingDistance( 'SELECT id, source, target, cost FROM edge_table', id, distance, false, ...
0
votes
0answers
29 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 ...
0
votes
0answers
41 views

How to work with SRID using PostGIS [duplicate]

I am using PostGIS with OSM Data from Geofabrik that covers the complete area of Austria. I am used to work with calissical longitude and latitude. If you enter Vienna, Austria in ...
0
votes
2answers
68 views

How to implement a radius search using PostGIS

I am very new to this topic and after a long time of research I didn't find a solution. I want a query that I can use on my PostGIS database performing a radiussearch.. I inserted the Open Street Map ...
0
votes
0answers
54 views

Connection to Shapefiles and PostGIS

I have this HTML (see below) code, I want to connect to PostGIS to the Shapefiles I have loaded, but I can't find where and how to accomplish that. I want my map to display this Shapefiles when the ...
1
vote
0answers
48 views

Is there any VRP solver in Pgrouting 2.0?

after looking at older posts and googling for a while i guess there is not vrp solver (multiple trucks). there was DARP in pgr1.x but i can't see it in 2.x. i found a lot of information on ...
0
votes
0answers
36 views

How to Make WMS (ArcGIS Server) automatic query top raster from PostGIS Database

I've a question about using ArcGIS Server in this scenario: PostGIS table with fields (ID, time, ras:raster, linkpath to file .tif in folder:char) eachday, we put some images in this table ...
2
votes
3answers
61 views

Calculate Color of Object So No Adjacent Objects Repeat

I am attempting to assign one of 16 colors to map objects (e.g. counties, states, ZIP Codes, etc.) so that no two adjacent objects share the same color. I'm seeing tons of articles online about ...
0
votes
0answers
33 views

line features show up as polygons in GeoServer

the layers are located in a postgreSQL Enterprise Geodatabase. I created a new line feature class and added it to the database and then added it to geoserver. But in geoserver it comes in as a polygon ...
0
votes
0answers
30 views

Syntax error drivingdistance

I am new in sql and i am trying to get that works a subquery with pgr_drivingdistance and pgr_pointsaspolygon but i get the next error: subqueries in FROM must to have an alias,for example, FROM ...
1
vote
1answer
74 views

Load PostGIS or Oracle Spatial Raster Layer using PyQGIS

How do we load Rasters stored in PostgreSQL-PostGIS or Oracle Spatial 11g into QGIS using PyQGIS? I am able to load vector layers from Oracle 11g with below code. What changes are necessary to add ...
0
votes
1answer
109 views

Using Pgrouting dijkstra algorithm in PostGIS?

I own two tables one with streets and one points, i use the table with the roads to calculate routes with dijkstra algorithm. But I want when someone add one point in the table Point and this point is ...
1
vote
1answer
27 views

How to find out postgis.backend?

How can I find out which postgis.backend (geos or sfcgal) I have?
1
vote
1answer
87 views

Adding Nodes to Linestrings at Overlapping Points with Polygon Layer in Spatialite

I have two Spatialite tables. A table called 'lines' which contains a PK column called OGC_FID and a LINESTRING column called GEOM. A table called polys which contains a PK column called OGC_FID and ...
2
votes
0answers
68 views

How to get Geography data to GeoJSON in PostgreSQL?

I am using PostgreSQL database and there is a field in a table(area), i.e., public.geography(Points,4326). It contains below type of records "0101000020E6100000BA83D89942334540780B24287ED051C0" I ...
0
votes
1answer
40 views

ERROR: attempt to redefine parameter “postgis.backend”

I just install "SFCGAL". When I use "ST_3DIntersection", It get below error: ERROR: attempt to redefine parameter "postgis.backend" SQL state: XX000 How can I fix? I already saw ...
1
vote
1answer
34 views

Can I make tiles of a raster in postgis?

I am doing some work on dtms in postgis. To import the dtm, I snipped it into tiles and the work directly on the dtm works fine. Then I calculated aspect and slope of the dtm and got some bad ...
2
votes
2answers
106 views

Finding all ways that are partly within a bounding box

I'm trying to write a query that will return all OSM ways which are contained within a bounding box of min/max gps coordinates. I get these cooridinates from the greater london bounding box on ...
2
votes
1answer
42 views

Coloring multilinestringzm M values in QGIS

I have output from a geophysical technique that produces X,Y,Z and scalar value for millions of points, which have been stitched together appropriately (by networkx if it matters) into ...
1
vote
1answer
67 views

Does ST_Intersection work in 3D?

I am using "ST_Intersection" between two 3D lines which I believe do not intersect, but the result gives me their intersection. SELECT ST_ASText(ST_Intersection( ST_GeomFromText('LINESTRING( ...
3
votes
2answers
35 views

Can GeoServer Mosaic extension footprints be something other than a shapefile?

According to the GeoServer documentation for the Image Mosaic extension... http://docs.geoserver.org/2.4.x/en/user/tutorials/imagemosaic_footprint/imagemosaic_footprint.html It asks for a shapefile ...
0
votes
3answers
270 views

Postgis installation

I am installing Postgis on my Debian server, following these instructions: http://postgis.net/install/ (Ubuntu / Debian) https://wiki.postgresql.org/wiki/Apt However, after following the ...
0
votes
1answer
83 views

PgRouting function wrapper

I'm trying to adapt the pgr_fromAtoB function to pgr_fromAtoMult replacing pgr_dijkstra function to pgr_drivingdistance.Here is the code: CREATE OR REPLACE FUNCTION pgr_fromAtoMult(IN tbl character ...
5
votes
2answers
91 views

POSTGIS get the max length of the polygon and the average width

I have in postgis a polygon type table. I need to calculate automatically the maximum length of the polygon: And the second one is the average width: I am doubting rigth now if this is possible ...
3
votes
2answers
80 views

QGIS Plugin for PostGIS versioning

Does anyone of you know a QGIS-Plugin for Versioning PostGIS-Data? I know there was pgVersion of Horst Düster but as far as I know this was not updated for QGIS 2.x (at least not for the "normal" QGIS ...
7
votes
2answers
259 views

Find headwater polygons

This is a follow up question to this question. I have a river network (multiline) and some drainage polygons (see picture below). My goal is to select only the headwater polygons (green). With ...
0
votes
1answer
30 views

Postgis: Conflation of two vector layers into a single layer

If I have table A that I consider to be definitive and table B that may have some elements missing from table B but also has geometries that are "close" to those in A that I want to ignore. How could ...
0
votes
1answer
16 views

ST_AsLatLonText () rounded

I know this is a POSTGIS question… I set a field with UPDATE members SET latlong_degree = ST_AsLatLonText (the_geom) But the result is (for example) 48°37’41.742”N 9°17’55.716”E The seconds part ...
2
votes
0answers
46 views

How to get changeset tag from .osm file into PostGIS enabled Postgres db

End goal: visualize geographic data from .osm file with QGIS by adding PostGIS layers which include changeset information. I have used osm2pgsql successfully to populate PostGIS and visualize the ...
1
vote
1answer
147 views

PostGIS ST within does not exist

I'm quite new to postgresql and postgis so this error will probably due to some rookie mistake. I want to run the spatial query ST_within. When I describe the query like this SELECT nw.entity_id AS ...
0
votes
0answers
29 views

How to create unique plane with PostGIS?

How to create a unique plane, with (x , y ,z) as center and a vector as normal, in PostGIS? I already saw "Make3DBox" function, but it does not make a unique one.
0
votes
2answers
43 views

Can you do aggregate functions among nearby geometry in PostGIS?

I want to do aggregation based not on group but on geometry, is that possible in PostGIS? For example to calculate max, min, average price for all listings that's nearby a geometry point, how can I ...