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

learn more… | top users | synonyms

6
votes
6answers
5k views

Open Source equivalent to Collector for ArcGIS to use with QGIS/PostGIS?

From my reading of the Esri web pages the Collector for ArcGIS is tightly tied to that platform. I would be delighted to learn that I am wrong about this. I have a strong interest in generic mobile ...
5
votes
1answer
76 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 ...
0
votes
0answers
5 views

Calculating slope from elevation returns hole when using ST_Slope in PostGIS

I have rasters from the National Elevation Dataset loaded into a PostGRES database and am using the built-in function ST_Slope to calculate the slope. However these contain many holes where there is ...
0
votes
0answers
55 views

PostGIS Best Practices with thousands of entries

I'm creating a PostGIS database which will hold thousands of different shapes (imported from Shapefile, GeoJSON, etc), and they'll stay there and be queried over time. Do I need to create a ...
1
vote
0answers
8 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
107 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 ...
-1
votes
0answers
31 views

How to organize lots of data in PostGIS? [duplicate]

I'm creating a PostGIS database which will hold thousands of different shapes (imported from Shapefile, GeoJSON, etc), and they'll stay there and be queried over time. Do I need to create a ...
0
votes
0answers
29 views

Windshaft + Postgres to read geojson

I am using Windshaft and trying to figure out how I can take a geojson text object from Postgres and have it rendered as a tile layer. I have tried the following query: sql: "select ...
1
vote
2answers
26 views

Find all polygons containing points specific criteria

I have searched for a bit, but couldn't find an answer for my question. So I have two tables (PostGIS), one containing points, and the other containing polygons. Right now i have this query for ...
6
votes
2answers
220 views

How to sample a 3D raster along a 3D path (or 4D raster along 4D path)?

I have a 3d raster dataset of atmospheric variables (lat x lon x altitude). I would like to sample this raster dataset along a 3d path. Any idea how I can achieve this, preferable with qgis or ...
2
votes
0answers
26 views

PostGIS for GPX analysis

I have GPX trails of vehicles/bikes of a particular city. Meaning, lat/lon, timestamp of bike trails from where a particular bike started and ended at different hours of the day. I have sets of these ...
1
vote
0answers
8 views

Make a line from a set of GPS points close to a specific GPS point with PostGIS

I have to develop a map-matching algorithm. By the moment I only match gps points with the closest road segment. I'm looking for a way to compare the directions between a gps point and a road to ...
0
votes
0answers
27 views

Web Application for display raster data on basis of time slider

It May act as a duplicate question to many, but i have tried refering too all the questions related to my questions, but i am still confiused. Below in attached my code. which i use for Web Mapping ...
3
votes
1answer
247 views

Get Multiple Shortest Path using PgRouting in One Query

I am trying to get multiple shortest path using A* Algorithm available in PgRouting. I referred Solution given by UnderDark ( Link of the Stakoverflow Post ) . But it is not giving me proper Output. ...
0
votes
1answer
25 views

Displaying raster tiles from OSM data stored in a postgis server

I have been recently tasked with setting up a raster tile server that serves tiles from data pulled from a postgis store. I have managed to get a vector tile server up and running but I'm stuck on ...
0
votes
1answer
19 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 ...
0
votes
0answers
17 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?
4
votes
2answers
575 views

How to remove redundant points using Open Source GIS (preferably)?

We have points table including vehicle routes.In huge traffic conditions,devices collecting data on route may output redundant points where at any coordinate same points may repeat.We can easily ...
0
votes
3answers
407 views

Coordinate System Google Maps API

I am making an application in java using GMaps4JSF where the person will enter the address on the map I'll take this coordinate and consult on my postgis base regions in which region this point is ...
2
votes
0answers
27 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
2answers
229 views

Conflicts while installing postgresql9.3-postgis2.1,QGIS and gdal-bin

I want to use postgresql9.3-postgis2.1 and gdal-bin parallel . I have refer instruction here for installing postgresql-9.3 on ubuntu 12.04. I have install qgis from here While installing gdal-bin it ...
0
votes
1answer
14 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 ...
8
votes
1answer
892 views

Is it possible to geocode street intersections using Nominatim?

Is it possible to geocode the location of a street intersection using Nominatim? Example geocode query Commonwealth Ave at Washington Street, Boston, MA Successful Geocode by Google ...
0
votes
1answer
12 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
45 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
1answer
811 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 ...
1
vote
1answer
256 views

SQL-query should return GeoJSON FeatureCollection

I'm trying to return a GeoJSON FeatureCollection object from a SQL-query with PostgreSQL 9.3 and PostGIS 2.1. This is my query so far: SELECT row_to_json(fc) AS p FROM (SELECT 'FeatureCollection' ...
1
vote
1answer
37 views

Why can't I import my shp file into a postgis database with SRID 102631 using shp2pgsql?

Hi I have been trying to figure out the reason shp2pgsql isn't working when I try to import a shapefile with SRID=102631. I've had no problems with other SRIDs. For all shapefiles in 102631, I get ...
2
votes
1answer
19 views

PostGIS - interfacing with CADCORP 7.1 and QGIS - user 'postgres' can import, but no other roles can

I'm new to PostGIS (reasonably) - but I'm plagued with one on-going problem: I'm able to access PostGIS from various GIS systems using the main 'postgres' user. Using a newly created user ...
2
votes
2answers
43 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 ...
1
vote
2answers
190 views

adding geometries to a source, target table for multiple rows in pgrouting

I am having an issue trying to perform the pgr_dijkstra algorithm and getting back a line in my table for multiple rows. I have a table that has a columns of source, target node id's but I cannot ...
0
votes
0answers
7 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 ...
0
votes
0answers
6 views

How to specify the new layer type in writeOGR{rgdal}?

There is a task that we copy some polygons into postgis using rgdal package. I noticed postgis is strict with geometry type so that the new multi-feature layer type must be specified. I tested the ...
0
votes
2answers
431 views

PHP PostGIS to geoJSON missing required parametar error

I'm using this PHP PostGIS to geoJSON script: https://gist.github.com/bmcbride/1913855 But I keep getting this error: 'missing required parameter: geotable' This is my code: # Retrive URL ...
0
votes
0answers
17 views

Integrate Qgis project to web based google api [on hold]

I was planning to convert the shape file into KML which google map supports. However, my project also includes TimeManager and PostGIS database. How do I handle them?
2
votes
0answers
28 views

Field Collection App for Geoserver or Any OS GIS Server

I am looking for a mobile app/interface for field data collection and mobile editing of GIS data that relies/syncs back to some type of GIS server or database. I am aware of Fulcrum and AmigoCloud, ...
0
votes
1answer
45 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
395 views

ERROR: Operation on two geometries with different SRIDs

I'm new when it comes to GIS and PostgreSQL. I have searched everywhere for the cause of this problem but I can't find the solution. I was following the documentation here First i created a table: ...
0
votes
0answers
36 views

H2GIS and POSTGIS

i use PostGIS and H2GIS and i have tested ST_Transform function on both systems: SELECT ST_AsText( ST_Transform( ST_GeomFromText('POINT('||to_char(5873455.6,'9999999.99')||' ...
2
votes
0answers
32 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
3
votes
1answer
172 views

Building a ol3 webapplication with dynamic content and user registration

My setup: currently i'm using a postgis database, get it with a geoserver and display it with openlayers 3. I use the wfs data to display the features in clusters and i'm able to edit them with wfs-t. ...
11
votes
4answers
687 views

How to add offsets to the route?

Edited: I want to ilustrate my question. Suppose that you're in "Point A" and want to go to "Point B". This points wouldn't be in "at_2po_4pgr" table cause aren't source/targets nodes. Then, I ...
1
vote
1answer
220 views

How to refresh features on a OL3 map automatically?

I am using OL3 and GeoServer and PostGIS as database. My database is connected to GeoServer and OL3 conected to GeoServer and reads the points in database as vector layer and shows on the map. My ...
1
vote
1answer
29 views

Rectangle Appears Distorted on Map

When displaying two features, a polygon a (see geoJSON) and its minimum bounding rectangle b (see geoJSON), I get the following result when viewing on geojson.io: The minimum bounding rectangle ...
3
votes
1answer
275 views

How to store data for gis system?

I'm developing a GIS solution using Postgis database and geoserver as web map server. The solution to develop will analyzes the defects (as a polygon) and process parameters values (as a linestring) ...
2
votes
1answer
40 views

Draw line with lon, lat, distance and azimuth

I have table in PostGIS with lon, lat, distance and azimuth columns. I want to make Geoserver draw a line through first point with given length and direction. I can turn lon and lat to geometry in ...
2
votes
1answer
162 views

pgsql2shp ERROR: incompatible mixed geometry types in table

I have multi-linestring in .shp files and I split the lines with postgis, but that result is only geom column. It does not works with shape file exporter error: incompatible mixed geometry types ...
0
votes
1answer
19 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
154 views

Query to Dissolve Nearby Polygons on Hive

I am using the ESRI spatial framework for Hadoop, that extends Hive to use spatial types and operations. My objective is to translate a set of simple queries on PostGIS into Hadoop, in order to ...
1
vote
1answer
50 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 ...