PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

1
vote
1answer
402 views

pgrouting php problem “pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 3”

I'm trying to build a simple routing web-app using pgrouting, followed some tutorial and the latest workshop. Because I'm using PostgreSQL 9.3(x64), Postgis 2.1.1, and pgrouting 2.0 so I did some ...
1
vote
1answer
36 views

How to check if a node is in route computed with pgRouting?

I'm new to the GIS system and I'm following the pgRouting workshop. I've imported the locations of nodes (points, highway=street_lamp) using osm2pgsql. now I'm calculating a few paths between two ...
1
vote
0answers
37 views

Optimize PostGIS query, ST_Intersects - Raster and Geom

I am trying to run a spatial query between two tables. Table one (prism_ppt_monthly - see below for details) is monthly precipitation data. Table two (usgs_basin_boundary - see below for details) are ...
1
vote
1answer
144 views

How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?

I am troubleshooting a slow st_geometry query in Postgres 9.2 that uses ST_Intersects--a basic Select from table where ST_Intersects type query. table_extent ...
0
votes
0answers
26 views

MultiPatch Shapefile import into PostGIS Database

I have geometry of buildings in Shapefile MultiPatch format. I want to import it into PostGIS database in the same format. Is that even possible? If yes, then how?
2
votes
0answers
33 views

GeoDjango and bug with bounding box query

Just some context first, I have a postgres database with PostGIS extension, running under a GeoDjango wrapper. I have a weird bug that hopefully someone can shed some light on. I'm running a query ...
0
votes
1answer
26 views

PostGIS Topology Requires Admin

I am running PostGIS on an Ubuntu server. I am able to add the Topology extension via CREATE EXTENSION, but when I try to use it as anything other than an admin I am denied permission. I ran GRANT ...
0
votes
1answer
26 views

Importing map information with osm2pgrouting

I'm importing the cartography of Spain with osm2pgrouting. I want to import address information, that is, the tag addr = *. I modified the file mapconfig.xml follows: <type name="junction" ...
1
vote
1answer
57 views

Where to store lat/lon data with additional informations?

I have huge database of lat/lon GPS coordinate points. For every point, I have several other variables (height, surface type, temperature, pressure...). Also, data will be changed every day and old ...
2
votes
2answers
59 views

geometry from relations - osm

Can someone show me the relevant documentation for relationships between tables? I'm trying to get the geometry for an entry from the relations table but I'm unable to pick out the right information ...
0
votes
0answers
13 views

OpenGeo Suite 4.0.1 Activating SSL for remote connection

I have installed OpenGeo Suite 4.0.1 on my Windows 7 OS and created a spatially database. Now i want to connect to my database remotely but then it seems like i have to generate a self-signed key. i ...
1
vote
0answers
67 views

Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases

So here's the situation - at the moment I am having a problem where the more feature classes I load into a ArcGIS 10.2 enterprise geodatabase in PostgreSQL, the slower the connection time becomes. I ...
0
votes
1answer
100 views

Import point cloud into PostgreSQL/ pdal pipeline fails

I have a point cloud dataset that I would like to upload to my postgres/postgis database. I followed this tutorial and I could install everything without problems (on ubuntu 14.04. On ubuntu 12.04 ...
0
votes
1answer
16 views

Adding data column by column in postgreSQL database

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...
0
votes
0answers
27 views

Changing postgresql security settings

I have setup a postgresql database with log ins as "admin" with full edits and "users" as read only. A number of "users" have been using this since for read only access. However, I set this up using ...
0
votes
1answer
22 views

PGR_Djikstra function error

I'm trying to find a shortest path between 2 nodes using djikstra method but it keeps saying ERROR: Error, query must return columns 'id', 'source', 'target' and 'cost' this is my query: ...
2
votes
1answer
39 views

OpenStreetMap Data Lookup Slow in PostGIS

I have imported OpenStreetMap data (Europe) into PostgreSQL 9.1 database with the help of osm2pgsql and filtered out everything expect administrative areas. I have GIST index for polygon (way) column. ...
1
vote
1answer
99 views

Split a table of Multi/Linestrings into Unique Linestrings

Is there an efficient way to split a table of Multi/Linestrings that overlap() and touch() into unique Linestrings (note: creating edges using topology is going very...very...very slow). Here is ...
8
votes
3answers
5k views

Postgis TopologyException: side location conflict at 226.001 39.5158, what's the problem?

after st_union() PgSQL returns a note: NOTE: TopologyException: side location conflict at 226.001 39.5158 And in the results there are two rows with empty geometry and other rows are ok. What ...
1
vote
2answers
321 views

How to update postgis layer from shapefile in QGIS?

My usual workflow with updating layer from shapefile was to: Open DB Manager; Load SHP files into QGIS; Open DB Manager; Import file (with drop option). Now my problem is that I have created ...
0
votes
0answers
12 views

How to render visualizations for geospatial objects (the way QGIS does it) on web interface for end users, from PostGIS database? [duplicate]

I have existing geospatial objects in PostGIS. I can visualize it using QGIS. But I want to render these visualization on a web-interface for my users as a result of some queries in the database. I ...
0
votes
1answer
38 views

Display NYC buildings where the tallest building on the block is above a certain height

There's probably a simple answer to this, but... I'm trying to figure out how to use the WHERE function to display only polygons (NYC properties, I'm using the PLUTO land use database) where the ...
-1
votes
1answer
61 views

Adding a column of WKT format in the table (postgreSQL)

I want to include this column of data that are in WKT format (they are mostly straight lines). What data type should I use? I need to create this database for mapping. There are about 30000 features ...
-1
votes
1answer
24 views

Rotate Polygon to be Parallel with the X Axis

By default, PostGIS calculates the Envelope or Extent of a polygon based on the bounding box of the polygon ((MINX, MINY), (MINX, MAXY), (MAXX, MAXY), (MAXX, MINY), (MINX, MINY)). This gives a result ...
0
votes
1answer
42 views

Moving file flat-nodes.bin from an osm2pgsql import

I'm running PostgreSQL 9.4 and osm2pgsql 0.82.0 on Ubunt 14.04 (64bit). I'm new-ish to postgres and less new to OSM. My goal was to import the planet file. Unfortunately, when I started the import, ...
1
vote
0answers
41 views

PostgreSQL owner/role administration for QGIS projects

What's the best way to administrate PostgreSQL roles for QGIS projects? I've created a separte schema for each of my QGIS projects. Is it possible to revoke all privileges except "select" for finished ...
0
votes
1answer
47 views

Add columns with information OSM by osm2po?

I imported the europa.osm network within my spatial database thanks to the osm2po tool. I use this with pgrouting. My problem is that I need to know the information provided by the tag address (city, ...
0
votes
0answers
26 views

Related Spation and non-spatial in QGIS

I am working with QGIS 2.6.1 by adding data from server using PostGIS. Now, I want to see the attribute information. So, how can relate the spatial with the information?
1
vote
0answers
27 views

Why is arcpy ChangePrivileges_management adding a second feature class to map?

I am new to GIS and pretty new to python, so sorry if this is ugly code. I am creating a feature class in a postgres database if it does not already exist and the user wants it created. That works ...
0
votes
0answers
17 views

Any experience or tips for using qgis with postgis layers? [duplicate]

we want to replace our shapefiles with postgis layers for editing in QGIS. We plan to edit 1 Layer with 5 people at the same time is this possible? Is this a good idea or is there a better practice ...
0
votes
1answer
53 views

Error when enabling ArcGIS geodatabase

We're trying to enable enterprise geodatabase functionality in an existing PostgreSQL database. We've already created the sde user (set as superuser) & sde schema. We get the following error: ...
0
votes
0answers
39 views

How to reference to user input in SQL string in R?

I am building a R Shiny interface that queries the user input in Postgresql and generate the respective map layer. However, I am unsure of the syntax to include the query in the SQL string. my codes ...
0
votes
0answers
54 views

How to convert a geojson from Postgresql to geojson format readable in rCharts in R?

I am creating a Rshiny interface on that can take in user input and SELECT the respectively map layer from Postgresql database based on the input. The package I am using to plot the map is rCharts. ...
2
votes
3answers
2k views

Unable to connect PostgreSQL to ArcMap 10.1

I'm trying to connect my local PostgreSQL database to ArcMap 10.1 but for some reason I'm unable to connect to the server. Any ideas of what might be causing the issue. For the instance option in ...
1
vote
4answers
75 views

Create Statewide Hydrologic Soil Group Map

This may be better for Engineering? Not sure. Background: Previously I have downloaded SSURGO soil data for the state of Pennsylvania by downloading each county and merging the shapefiles. I then ...
0
votes
0answers
25 views

How do I tune postgres to quickly find the shortest path on a large dataset (4M)?

My graph has ~4M rows, and I am running it on 2.55GHz machine. When postgres gave it the default amount of memory settings, it took my ~55 seconds to run the pgr_ksp function against it (where k is ...
14
votes
3answers
3k views

Identifying road intersections using PostGIS

I'm trying to identify where roads intersect each other, and to make a point at this intersection, with the number of roads that form the intersection listed. I was wondering if there was some way ...
1
vote
1answer
32 views

Simple popup for multiple WMS

I have multiple WMS in openlayers with a layer switcher and can be turned on and off. Now i have an image of each WMS, what i want is to show image of each WMS on click OF that corresponding WMS. ...
1
vote
0answers
79 views

Help serializing a postGIS query to geojson

I have a query which I would like to serialize to geoJSON: select article_title, pub_date, city, geom from article, location where article.id = location.id; I can serialize the geom field easily ...
1
vote
0answers
779 views

Import raster data from postgis and publish in geoserver

I am using geoserver 2.3.3, PostGIS 2.1 and PostgreSQl 9.1. The Image Mosaic JDBC extension is also installed correctly. I am trying to import raster data from PostGIS and publish in Geoserver but ...
2
votes
3answers
402 views

Creating feature dataset by pgAdmin (PostgreSQL) that can be useD in ArcSDE connection?

How to create feature dataset in PostgreSQL (pgAdmin) that can by use in ArcSDE conection (ArcGIS)?
1
vote
1answer
1k views

Having trouble connecting QGIS with postgres database with postgis extension [closed]

I am working on Ubuntu Precise with postgresql version 9.3 and postgis 2.0. After initially starting my postgres database and eventually getting permission errors that would prevent postgres from ...
2
votes
1answer
840 views

Installed PostGIS extension not listed for database

I have a PostgreSQL database with the PostGIS extension enabled. I know that this extension is enabled, since I am using PostGIS functions, and I can actually see the PostGIS functions. However, ...
0
votes
1answer
58 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
0answers
2k views

How to write a point-in-polygon query for Postgis?

I'm trying to write a query in Postgis which will return all rows where a dynamically changing longitude/latitude point resides within the geometric polygon of that row (in the geom column). This is ...
2
votes
2answers
466 views

How to write a new layer to PostgreSQL from QGIS plugin

The PyQGIS cookbook states that QgsVectorFileWriter can write vector layers to any format supported by OGR: https://www.qgis.org/en/docs/pyqgis_developer_cookbook/vector.html#writing-vector-layers ...
1
vote
1answer
78 views

Number of Neighbors Around a Point

I need to get a count of neighbors within 100m for each point in a set of 250 million points. The result would have the id of each point accompanied by the number of neighbors around them. Can this be ...
1
vote
2answers
32 views

Problem with MapServer WMS

Below code is showing the addition of mapserver file in openlayers 3, it is successfully showing me image in the browser but when i zoom that image it does not zoom. It comes back to originial view. ...
1
vote
0answers
53 views

OSM Bright Cartography XML

So I've successfully setup a tile server as described here: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ What's troubling is the lack of clarify surrounding OSM Bright ...
1
vote
2answers
452 views

Public PostGIS Server available?

Can anyone point me to a (if possible at all) list of public PostGIS Servers, where one can set up their own database/tables? I would need a PostGIS server on 24h/7d while not having the resources by ...