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

learn more… | top users | synonyms

0
votes
1answer
14 views

How can I use ST_Intersection with two rasters?

I need to query all values in raster A which intersect with raster B. Found this, but it's not accurate, and I'm getting ERROR: column reference "rast" is ambiguous. WITH first AS ( SELECT id, ...
1
vote
2answers
234 views

Utilizing OSM Data in a Postgres/PostGIS database in ArcMap

I've been trying for over a week now, and I'm not sure what i'm doing wrong and I haven't found the answer yet. I am trying to display and symbolize the OSM dataset over Jordan in ArcGIS for Desktop ...
1
vote
1answer
16 views

Filter geoserver layers based on postgis geometry

I am wondering how, and if it is possible, to filter a geoserver's layer (from a large shapefile) on a specific geometry coming from a postgis table. I have a huge shapefile for a country. I'd like ...
1
vote
1answer
31 views

To check if a geometry is contained in a geomtery collection in postgis

How can I check if a geometry is contained in a geometry collection ? Specifically , I am using ST_ClusterWithin in PostGIS to get a cluster which returns each cluster as a geometry collection. Now I ...
1
vote
1answer
34 views

Creating weighted lines on map in CartoDB

I am trying to illustrate global trade flows within CartoDb. Flows are visualized by a line connecting two lat/long points on a map. The size of the flow would be represented by the width of the line. ...
0
votes
0answers
26 views

Is it possible to use pgsql2shp utility in PL/pgsql environment?

I intend to use PL/pgSQL to generate calculation points on streets with respect to address locations. I am aware that using pgsql2shp utility, a shapefile can be generate using postgis query. I was ...
2
votes
2answers
33 views

postgis How can I obtain directional buffer?

I have a geometry (polygon) which I want to extend with a buffer while testing on it in a where clause. The problem is that I would like the buffer to be only applied according to one or more ...
1
vote
2answers
33 views

How to optimize QgsFeatureRequest with filter expression

I have a point PostGIS layer (my_layer) which has more than 66000 features. I am getting the features I want but it takes too long. My code is: resultList = [] req = ...
2
votes
1answer
36 views

Selecting polygons not covered by any other polygon (or BBox) in table in PostGIS?

In a table where many of the geometries might be completely covered by other ones, is there a query that selects only geometries that are not covered by any other geometry in the same table (excluding ...
0
votes
1answer
21 views

QGIS 2.14.3 export PostGIS layer to dxf issue

I am trying to export a PostGIS layer to dxf in QGIS (2.14.3) via Project>DXF-Export using the following settings (German GUI): When I open the resulting dxf in DWG TrueView 2016 I see nothing, but ...
0
votes
0answers
13 views

Privacy solution in a table view [on hold]

i have a table with two key columns, which are user and privacy. My idea is to write table view to query my table with reference to the relevant column. I want a table view which shows following: ...
3
votes
1answer
53 views

Dynamic Linear Referencing of events in QGIS from Excel or CSV using virtual layer

I have a PostGIS table with a geometry type LINESTRING M to represent routes. Here is the table specification: CREATE TABLE routes ( fid serial PRIMARY KEY, r_name text NOT NULL, geom ...
7
votes
1answer
208 views

PostGIS Recursive Query Based on Line Connectivity

I'm having difficulty with a query. I have a network of linestrings, each with a value in the n_type column. This can be one of a handful of options. I'd like to generate a new table that groups any ...
3
votes
1answer
534 views

How to obtain closest point of point over polylines layer in PostGIS 1.4 (without st_ClosestPoint)?

I´ve got a polylines layer (pipes) and a points layer (valves) and In Postgis 1.4 I would like to obtain the closest points but exactly on the closest polyline. In other words, i need to locate each ...
1
vote
1answer
77 views

How to add X/Y coordinates and count of overlapping points in a postgresql table?

How to add to my postgres/postgis table the following columns X coordinate | Y coordinate | count (number of points in same location) from an existing table populated with geometries type POINT
0
votes
1answer
205 views

WFS with authentication to PostGis (or to shape)

Is there a way to import data from a WFS layer to a Postgis table (or to a shape)? there are blogs explaining how to do it in 3 steps (http://anitagraser.com/2012/09/26/wfs-to-postgis-in-3-steps/) or ...
2
votes
1answer
40 views

ST_LocateAlong interpolation: difference between PostGIS and Spatialite

In a previous question, I discovered that ST_LocateAlong along a LineStringM is not implemented the same way in Spatialite than in PostGIS. While PostGIS interpolates between measures, this is not ...
0
votes
0answers
35 views

ST_Distance between ST_Centroid and ST_Y

I'm trying to make a ST_Distance between a ST_Centroid and a ST_Y... But ST_Centroid is a geometry and ST_Y is a float. How can I make this? My query: SELECT ...
1
vote
1answer
57 views

How to use shp2pgsql to import a very large shapefile into PostGIS?

I need to import very large datasets into the Postgis server so I need to use the -D option in the prompt. Problem is that I'm getting an error no matter what I do. The command lines I'm using are: ...
1
vote
2answers
571 views

can't geocode with PostGIS 2.1.1

I don't know where's the mistake... I am using the process from the PostGIS documentation (http://postgis.net/docs/manual-2.1/postgis_installation.html#loading_extras_tiger_geocoder) . I created a ...
3
votes
1answer
669 views

Uploading raster format(*.tif) to postgis through raster2pgsql

I'm new to postgis and raster file format. i currently working on netcdf files and i want to import it into postgis through curl command line tool but its failed for me.so i jump on to GDAL v1.9.2 ...
0
votes
0answers
85 views

collada2pgsql: importing 3d models into postgis [on hold]

I have been researching for a tool (open source) for importing collada (.dae) file into postgis and i have found this collada2pgsql command. It states it can import collada files to postgis but the ...
1
vote
1answer
64 views

Parse and load GPX into database? [on hold]

Having a PostgreSQL database, with the following tables: CREATE EXTENSION postgis; DROP TABLE IF EXISTS trips CASCADE; DROP TABLE IF EXISTS locations CASCADE; CREATE TABLE IF NOT EXISTS trips ( ...
1
vote
1answer
50 views

In Postgres how to create columns with geometry?

I have point data stored in the postgis server and I need to create a new table with their geometry values. How can I extract their coordinates and translate them into a table. Something like: ...
2
votes
2answers
91 views

How to convert .csv with WKB to shapefile (.shp) using open source solutions?

I have a .csv file with hundreds of rows pulled out via PostGIS. The geospatial information is in "the_geom" field which seems to be in WKB-format. How can I convert this to shapefile using simple ...
9
votes
0answers
235 views

How to extract sublinestring from a linestring with overlapping segments

Problem statement: Given a bus route (defined as a linestring ln.the_geom), and a set of bus stop locations (pt1.the_geom,pt2.the_geom,...ptn.the_geom), divide the bus route into segments between bus ...
3
votes
1answer
70 views

PostGIS crosstab on multiple point tables

I have several point tabels, lets say 3. Tables are alike with two columns: a integer value and a geometry like: table sand1 (value int, geom geometry) table sand2 (value int, geom geometry) table ...
0
votes
0answers
22 views

Look Up table from (Latitude,Longitude) to country, city etc. boundaries (Bounding Box)

I'm looking for "Standard" assume file (?) containing best practice used simple "approximately squared" boundaries of countries, major cities etc. The use case is getting (Lat,Lon) and perform look ...
0
votes
1answer
28 views

Writeogr to PostgreSQL/PostGIS database with R

I'm producing some Spatialpolygondataframes with R that I would like to upload to my PostGIS Database. I've found out that the way to do this is via the writeOGR() function using the PostgreSQL ...
1
vote
2answers
75 views

How to split a large point vector layer in QGIS?

I need to split my shapefiles into much smaller pieces so that I can upload them onto the Postgis server. Shapefiles have DBF files with 14 Go (1,000,000 rows) and I need them to be under 2 Go. I've ...
2
votes
1answer
179 views

How to transform isolines to isopolygons with postgis?

I have a table a postgis table of isolines that's defined like this: CREATE TABLE myisolines ( gid serial NOT NULL, isotime timestamp without timezone, val numeric(10,4), geom ...
1
vote
2answers
41 views

Updating table setting a CASE with ST_Intersection

I add a new geometry column to the "mad" table so I could update it with the polygons from an Intersection with the polygons of the table "clip". Since my database is huge an it was taking a lot of ...
0
votes
0answers
24 views

connecting Postgis, Python, Openlayers

I'm in the process of learning Geo-mapping and I'm curious to create a web-application Python-Django, Openlayers 3 and PostGIS. I need to know whether Django can be combined with PostGis and ...
1
vote
1answer
25 views

What needs to be installed, to use ST_ClusterDBSCAN?

I have working PostgreSQL 9.5.3 with PostGIS. I have sucessfully created table and column with geom data type. I am able to execute geometry queries, namley ST_Transform without problem. # SELECT ...
1
vote
2answers
34 views

Backup GIS data on postgis database from pgadmin3

I am using a postgis database with qgis and managing it with pgadmin3 I have already investigated the backup/restore options within pgadmin 3 and done one test run on one database I am wondering if ...
3
votes
2answers
46 views

FME - Copying a full list of 'user attributes'

I'm new to FME, so just getting used to the interface. I've loaded a template .fmw which has given me a full process, including an example 'Writer'. This writer is no use to me, and as I can't change ...
-4
votes
0answers
4 views

GeoExt:make wfs layer [on hold]

Can u help me with WFS on GEOExt ? i try this tutorial http://workshops.opengeo.org/geoext/wfs/grid.html it's work but point is not saved!! someone know the probleme ?
0
votes
0answers
19 views

run shp2pgsql command in c# application

I worked for a month on this command but in vain ; really if someone already tried to help me find the error , because when I load the application displays the message to me as the shapefile was ...
1
vote
3answers
6k views

Convert geometry to latitude-longitude using PostGIS ST_Transform

My table has a geometric field, in EPSG:3857, of type point. I need the latitude and longitude, in EPSG: 4326, of each point. Could someone give me a valid example of how to use ST_Transform().
1
vote
1answer
50 views

Tableau: Using UK Shapefiles in PostGIS Database

I'm trying to use Tableau to display data. Some of this data is suitable for mapping, and therefore I'd like to create maps in Tableau to display this data. Unfortunately, neither the basic view nor ...
2
votes
1answer
25 views

Converting PostGIS point to text causing loss of data?

I have a road network and want to test connectivity between the features. I am having trouble with two specific features, the rest of the dataset is functioning just fine. When I get those 2 links' ...
1
vote
1answer
21 views

PostGIS raster to UTFGrid

I am trying to create a UTFgrid JSON with a Raster in PostGIS. The goal is to provide weather data for web maps. I found some libraries: https://github.com/Ecotrust/create-utfgrids ...
0
votes
1answer
1k views

How do I explode a MultiLineString using ST_Dump() in PostGIS?

I want to do what this blog post does: explode a MultiLineString into individual LineStrings. I'm using CartoDB but don't get individual LineStrings as the result of my query. I still get a ...
0
votes
0answers
43 views

How can I change start and end point of a linestring?

I have a linestring from a pgRouting query. The start point and/or end poit of this line does not connect exactly the points I've clicked on the road and give me all the road segment of that edge ...
2
votes
3answers
741 views

Importing MaxSea 3D Database to PostGIS

I am currently working on a project, where I combine several MaxSea 3D databases, which contain depth measurements made by the echosounder onboard on a ship. The idea is to combine these databases to ...
5
votes
3answers
53 views

Different values while calculating distance

I'm developing a project using LeafleatJS and PostGIS. Currently I'm getting trouble while calculating distance between two coordinates. For example: Point 1 - lat: -12.99835864475412, lng: ...
2
votes
2answers
233 views

Error in displaying wfs layer from mapserver/postgis

I have read and tested all the relative posts but I still don't have a solution for my problem. I have a layer suscribers (points) stored in postgis database with srid=32232. I would like to display ...
3
votes
1answer
130 views

Drawing historical shipping routes?

I´m working on a project where I have to draw historical shipping routes of trade, whaling, etc. ships from the XIX century. I´ve done some research and checked Maritime route prediction avoiding ...
4
votes
2answers
74 views

PostGIS treating unique geometries as equal

I have two different geometries (albeit very closeby) that Postgres is treating as equal. db=> select '0101000020E6100000C5BCD8C5FEF45DC0AFE29EF87B584740'::geometry = ...
1
vote
2answers
41 views

Show results of ST_Union in QGIS

Currently, I am working on SQL in PostgreSQL and I execute query of vector data by "ST_Union" function for the spatial data. Now, I want to access the result of query in QGIS 2.14, but I can't. Is ...