PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

0
votes
0answers
26 views

Aggregate/merge data upon insert into PostGIS (via gdal)

I am working on a project where I take a large raster file (1.5GB+), put it through a number of image-processing operations, and finally convert it to vector data. Being that the raster is large, I am ...
2
votes
2answers
109 views

PostgreSQL trouble editing points / lines / polygons in QGIS

I have a problem with postgresql and QGIS : I can add points/lines/polygons and fillup field But I can't : delete points/lines/polygons modify points/lines/polygons (move or modify field) ex : ...
2
votes
1answer
35 views

How to set/update columns by using a trigger?

I want to set/update attributes (alignment_horizontal, alignment_vertical) of a PostGIS geometry (point) by using a trigger. CREATE TABLE point ( gid serial NOT NULL, geom geometry(point, SRID), ...
0
votes
0answers
19 views

To find a substring of a linestring in postgis to be used in playback in map

I have gps coordinates as point outside the linestring/road. I have interpolated to the closest point in the line using ST_Line_Interpolate_Point(). Now I need to draw line through these points and it ...
3
votes
1answer
77 views

What tools do you recommend to draw 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 some questions in this forum but I ...
2
votes
0answers
15 views

Creat point count trigger in PostgreSQL?

I wish to create a trigger in PostgreSQL for counting points in a polygon. The tweak is that the count should automatically get updated whenever the polygon is edited. Can anyone please help me on ...
0
votes
0answers
32 views

Cant able to delete features of a table inside a public schema of postgre database

I have table inside a public schema of postgre database. And i did a connection to that database and load the table inside the public schema in QGIS 2.10.1. I changed the table to edit mode and tried ...
3
votes
2answers
54 views

Is the PostGIS st_intersection function viable for very large data-sets?

I am running an area intersection query on two large multipolygon tables (a few million rows). SELECT r.geom FROM public.my_table r WHERE EXISTS ( SELECT gid FROM public.my_table_intersection ...
2
votes
2answers
107 views

Cleaning geometries in PostGIS?

I am trying to do some processing on some very large polygon layers. However I am running into various geometry errors such as: NOTICE: Ring Self-intersection at or near point 470396.52017068537 ...
0
votes
1answer
36 views

Import shapfile to Postgis using Python and ogr?

Iam not able to import a shapfile to PostGIS using the same library(ogr). I am using below link but it give me error. Import shp to Postgis using Python and ogr Error : Traceback (most recent call ...
1
vote
0answers
32 views

Nominatim CentOS 7 Install Problem

The Problem: I've installed Nominatim on CentOS 7 because I want to do some reverse geo-coding, however, when I try to load the and create a Nominatim database with this command: ./utils/setup.php ...
1
vote
1answer
69 views

driving time to the nearest facility using pgrouting

I'm using pgrouting 2.0 and postgis in postgresql. My problem is to calculate the driving time to the closest facility for each node of my OSM derived network. These are the steps to be implemented ...
0
votes
1answer
30 views

Problems with PostGIS St_closestpoint function

I'm trying to find the closest point in a line from an insertion point closest to it. To do it, in the middle of the function I use select id from rede_viaria.t_rviaria_via vias where ...
2
votes
1answer
38 views

How can I do a subquery inside a subquery in PostGIS?

I need to add a subquery to a working function. Instead of select * from table, I'd like to select * from (select * from table where height>1500) as sub, something that works in other functions I ...
1
vote
0answers
34 views

Running a custom function on each line of a PostGIS table

I am trying to run a custom function on each parcel in a PostGIS table, (in this case its a function that finds the standard deviation value of the pixels intersecting a raster) Here is the code for ...
1
vote
1answer
38 views

Is Create Spatial Type necessary

When I enable an enterprise geodatabase for a database in postgresql, the st_geometry type get installed with it. So Is it necessary to use "Create Spatial Type" tool to create st_geometry type in ...
2
votes
1answer
45 views

How to detect if point is on the left or right side of the line in PostGIS

I have a linestring table and a point table in postgis. I know the closest line to any given point. What I need to know is on which "side" of that line is the point. I guess I have to do that by ...
3
votes
1answer
41 views

GeoServer and PostgreSQL JSON column

I have a database table with a dynamic schema implemented via a JSON column named "properties". Currently GeoServer doesn't recognize my JSON column. Is there some way to make Geoserver recognize ...
0
votes
0answers
20 views

Tilemill/PostgreSQL Connection refused Error

I have been trying to set up a MBTiles Export using PostgreSQL 9.2 and the Latest version of Tilemill. According to the postgreSQL Logs, I am receiving an error, and I cannot figure out why. I have ...
2
votes
1answer
53 views

How to find Shortest Route between two points in PostGIS without using pgRouting?

I want to find shortest route between two points stored in PostGIS database. I know about pgRouting functionalities but I don't want to use it because of data processing/topology creation processes. ...
2
votes
0answers
39 views

Calculate mean value of polygon from raster in PostGIS

I started with a NetCDF .gri and .grd raster file of the UK provided by a colleague. I clipped it in R to be only London, exported and converted to a ASC file, and then imported it to PostGIS using ...
0
votes
1answer
34 views

Problem importing sqlite into Postgres (with PostGis) using ogr2ogr

I am trying to import a very large sqlite file into Postgres SQL 9.3. The first tool I tried to use was OGR2GUI (http://www.ogr2gui.ca/). The 64 Bit version does nothing, whilst the 32 bit version ...
3
votes
1answer
131 views

How to create a trigger for multiple schemas?

One of my PostgreSQL databases contains different schemas which share the same structure. -- schema region_a CREATE TABLE region_a.point ( gid serial NOT NULL, geom geometry(point, SRID), ...
0
votes
1answer
23 views

PostGIS: Invalid Input Syntax for Type Double Precision

I have this query that is trying to update my geom column that's built off of lat and lng coordinates UPDATE main_table SET geom = ST_SetSRID(ST_MakePoint(lng, lat) ,4326); However it returns that ...
2
votes
0answers
28 views

match noisy GPS data to closest linestring in road network [duplicate]

I have some noisy GPS data(Points) that they are not exactly on the road because of the noise. But I want to match them to the closest road linestrings. How to do this in PostgreSQL? Data: ...
0
votes
1answer
34 views

I'm not able to add SQL file to postgresql database

I started with basics and did these steps: createdb -U postgres -E UTF8 -O Peete gis -OK createlang -U postgres plpgsql gis (was already installed) -OK psql -U postgres -d gis -f ...
0
votes
1answer
20 views

CartoDB JQUERY function init() fail

Absolutely stumped. Simply attempting to toggle layers using cartdb and jquery much like this tutorial. After sniping the console I get init() is not defined? However this only occurs after adding ...
0
votes
0answers
16 views

How to create a polyline using multiple points using a PostgreSQL query?

I'm trying to use point data to create a polyline to show my bus route. Initially began with coordinates and used this to create geom using the ST_MakePoint function (written to the BusRouteData ...
2
votes
1answer
92 views

Trouble using ST_Difference to remove overlapping features

I am trying to use ST_Difference to create a set of polygons (processing.trimmedparcelsnew) that do not contain any of the area covered by another set of polygons (test.single_geometry_1) using ...
1
vote
0answers
23 views

Unable to load Postgresql spatial data in R (with rgdal)

I'm trying to load spatial data from a postgresql database in R, using functions from the package rgdal, but I'm having trouble getting the functions to work. For example, when trying to read a ...
1
vote
1answer
29 views

PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+

I need to obtain on each element on one table the closest point of another table. The first table contains traffic signs and the second one the Entrance Halls of the town. The thing is that I can't ...
0
votes
0answers
5 views

postgres 9.2 update query on a subset

I wish to make an update using CASE, on a subset of a table. This subset is based on a spatial query. It looks like : update t1 set f1 = CASE WHEN... WHEN... END FROM (select * from ...
0
votes
2answers
25 views

different calculation results

I spend a comparison of functions of spatial analysis and Oraсle postgresql. There are two tables with the same coordinate system - tech_bridge. oracle query select ...
1
vote
1answer
28 views

pgrouting: function driving_distance does not exist

I tried to run driving distance function but got error. function driving_distance(unknown, integer, integer, boolean, boolean) does not exist LINE 1: SELECT * FROM driving_distance(' ...
0
votes
0answers
29 views

Enable PostGIS extension on Ubuntu 14.04.2

I have troubles enabling PostGIS extension on Ubuntu 14.04.2 and PostgreSQL 9.3. I have installed the packages with this step by step procedure. PostgreSQL and pgAdminIII seem to be installed ...
1
vote
2answers
55 views

Adding additional geometry column in PostGIS

I'm importing many sets of geodata into PostGIS, and they have different SRID's. (Some have EPSG:3857, some EPSG:4326, some something else). I'd like to create an additional geometry column, eg. ...
6
votes
0answers
69 views

Best way to cut linestrings with points

i was checking the best way to cut linestrings by points. The scenario is: lots of streets, need the segments cut by intersect points, kind of this: I got linestrings (full uncuted by points) ...
0
votes
1answer
20 views

Tweaking the table after shapefile import?

I'm importing shapefiles to Postgresql with the shp2pgsql command line tool. shp2pgsql -s 3035 -W "latin1" foo.shp | psql Should I do some table (SQL) tweaks after that? Or is the import fine after ...
0
votes
0answers
34 views

Cannot find information about my.table table in raster_columns

I am running PostgreSQL 9.4 and PostGIS 2.1 and have loaded a small piece USGS SRTM data for North America successfully into my database. I am attempting to export a small piece of of the rasters I ...
4
votes
0answers
52 views

How to speed up simultaneous working with PostGIS layers in QGIS?

we are working on one big layer at the same time (10-20 people). Some of us use QGIS 2.8.1 and the other 2.6. The user with 2.8 have a lot of crashes (QGIS). The 2.6 users don't have this crashes but ...
1
vote
0answers
37 views

How to install PostGIS shp2pgsql-gui on openSUSE 13.2?

I installed PostgreSQL 9.4.4 together with pgAdminIII (1.20.00) and the PostGIS extension (2.1.7, via the Stack Builder) from http://www.enterprisedb.com/products-services-training/pgdownload on my ...
0
votes
0answers
44 views

PostGIS ST_Intersects not returning values

I recently installed the PostGIS extension for a rails app that i'm working on. Currently, i am trying to get all the polygons that intersect the vieport of the Google Maps. On running the (see ...
0
votes
0answers
43 views

Installing odbc_fdw in Postgresql 9.3.5 in Windows

I need to install odbc_fdw on my postgresql 9.3.5 which is running on Windows server 2012. So far, I've found this version which only works for postgres 9.1. I found this other version that should ...
0
votes
0answers
78 views

Problem with ST_IsValid: Unknown geometry type: 9 - CompoundCurve

The following is an example of a gml:Curve that was loaded into Postgres using FME. <gml:Curve srsName="urn:ogc:def:crs:EPSG::27700" gml:id="os.vmd.ny.38124.geom"> <gml:segments> ...
0
votes
0answers
54 views

Can't upload files to database by Nominatim

I was trying upload geofabric's netherlands-latest file into Nominatim's database. I used bellow command and all was fine: ./utils/setup.php --osm-file maps/netherlands-latest.osm.pbf --all 2>&1 | ...
1
vote
1answer
31 views

OSM import fails due to non-matching PostgreSQL version

I am trying to follow the installation of Nominatim, based on http://wiki.openstreetmap.org/wiki/Nominatim/Installation#Ubuntu.2FDebian. The command ./utils/setup.php —osm-file <pbf-file> —all ...
1
vote
0answers
29 views

how to create Topology table?

i have gis database called Madar in pgadmin with postgis and pgrouting extension, all the data inside gis database already inserted by shp2postgre tool , what i really need now is how to make topology ...
1
vote
0answers
28 views

PostgreSQL default values in QGIS 2.8.2

I think the issue outlined in this question PostgreSQL default values in QGIS 2.8.1 and ticket #12391 is not fully solved yet. Negative numeric default values, and dates are not used by QGIS 2.8.2 ...
0
votes
2answers
61 views

Index a Table with Geometry Column

I have a table called Stores with 10k rows which has a column location geometry(Point,4326). CREATE INDEX "Stores_spatial_gix" ON "Stores" USING gist (location); Upon KNN query explain analyze ...
0
votes
0answers
29 views

Use of constraints and Spatial indexes in Postgis

We'are using Postgis to manage our geo data. They are coming from several sources, like Open street map, VPF, Shape and so on. We have defined constraints on the tables, and spatial indexes on ...