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

learn more… | top users | synonyms

0
votes
0answers
2 views

SLD styling rule for first and last geometry feature in PostGIS table

Writing a SLD file to style a Points layer which I publish as WMS with GeoServer, is it possible to specify a rule that is only applied to the first and last features in the underlying PostGIS table? ...
0
votes
1answer
634 views

Unable to load Shapefile using pgShapeloader / shp2pgsql-gui (pgAdmin3's PostGIS Shapefile Import/Export Tool)

I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool. However its not ...
1
vote
1answer
230 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
2answers
177 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
19 views

Is there any method to retrieve SQL queries into a GeoJSON file using JSP?

I want to display the contents of my PostGIS database of various shape-files in leaflet pop-up dynamically. I know there are static methods available that retrieves attributes. But I need to by ...
2
votes
1answer
576 views

Create isochrone from multiple start points

I want to create an isochrone. For this I could use the pgr_drivingDistance function with pgRouting (http://docs.pgrouting.org/dev/src/driving_distance/doc/index.html) but it only takes one start ...
1
vote
1answer
161 views

Connecting to PostGIS (LATIN1) from Microsoft Access 2010 - Encoding problem?

I want to connect to a PostGIS table Using MS Access. The table has been created using the PostGIS Shapefile loader in pgAdmin. It has been encoded at LATIN1 (it wouldn't load with UTF-8 default). I ...
3
votes
1answer
42 views

Prevent PostGIS Topology from splitting edges on line insert

I'm dealing with a large amount of road data represented with PostGIS Topology types. Anytime I add an edge over another edge, the edge is automatically split and a new node is created at the ...
0
votes
1answer
21 views

I have not found shp2pgsql in postgis installation

I have been installed postgis following this guide. All is OK. SELECT postgis_full_version(); "POSTGIS="2.1.7 r13414" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, ...
0
votes
2answers
214 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 ...
3
votes
3answers
546 views

Visualization of a big graph in 3D from postgresql/postgis

We have a graph in 3D in a PostgreSQL/PostGIS database. It contains something like 50'000 edges and 50'000 vertices, with x-y coordinates and floors. We would like to visualize this graph with ...
0
votes
1answer
41 views

How to bring my PostGIS map from GeoServer to Leaflet based web application?

I have created a group of shape-files using QGIS and I have stored their corresponding information in PostGIS database by importing the shape-file into pgAdmin3 using shape-file and DBF loader. Then I ...
0
votes
1answer
362 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: ...
6
votes
4answers
836 views

Can GeoNetwork store metadata for a PostGIS table?

Can GeoNetwork be used to store Metadata for a PostGIS table? Or is it only for WMS/WFS services? If it can be used to create a store metadata for a PostGIS table, how is it done? I can't seem to ...
1
vote
1answer
99 views

Point of intersection issues with PostgreSQL/PostGIS?

I have a table containing a set of points of intersections. Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of ...
0
votes
2answers
20 views

Create point on a line with given distance from end in PostGIS

Does anyone know how to create points along a line (MultiLineString geometry) with a given distance in PostGIS? I'd like to create points at a regular distance over a line, which represents a ...
2
votes
1answer
220 views

Why is the QGIS 2.2 database tab missing?

I have recently installed QGIS-2.2.0 but the Database tab in the top-menu bar is missing. It looks the main reason is missing libgdal1h library. But when I am installing it, it's removing ...
2
votes
1answer
144 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 ...
8
votes
1answer
849 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 ...
1
vote
1answer
35 views

How to fix “Detected out of bounds geographic extent”

I hope someone can help me to solve this problem. i want to make a map with TileMill v.01, when i try to add layer using shapefile (i use QGIS to edit *.shp file) or postGIS i always get error ...
0
votes
0answers
19 views

Method to translate PgRouting to ESRI Network Analyst network dataset?

I have a network dataset in a PostGIS database that is set up and routable via PgRouting. I would like to take this dataset and import it into Network Analyst in ArcMap in order to make some ...
1
vote
0answers
28 views

Tool, API of or code samples for calculating spatial similarity between Lines

I am migrating a database with a road network to an other external data provider. We have joined our own data about roadworks, temporary speed-limits, etc., using ID and linear referencing on this ...
3
votes
1answer
249 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) ...
0
votes
2answers
58 views

Why the execution of a query is very slow using PostGis?

I'm applying this Query to 8257800 point but it's taking 15 hours and it didn't return a results. SELECT a.gid , b.gid, st_distance(a.geom,b.geom) FROM shp1 a, shp2 b where ...
0
votes
2answers
148 views

Store GPS trace with timestamps, then interpolate location by time

I'd like to: Load a 1-second interval GPS trace (not GPX) into PostGIS Then query the table at sub-second accuracy (about 5Hz), and get PostGIS to interpolate the location by time. Is this ...
1
vote
0answers
17 views

Server-side map generation from postGIS database

I have loaded some OSM data into a postGIS database, using imposm. Now using this data base, I computed a value associated to every point of the map (could be anything, real-estate average price or ...
0
votes
1answer
299 views

Drawing curved lines in CartoDB?

I am experimenting drawing curved line from Origin to Destination in Cartodb. I was able to do so once, however, failed the second and third time. Could anyone offer me some insights into the ...
1
vote
1answer
16 views

Error when creating new view using ST_Union (PostGIS)

I have a table in PostGIS (2.1.7) containing adjacent multipolygons, and I'd like to create a view containing polygons which are merged versions of the multipolygons based on some field value. I ...
1
vote
0answers
23 views

OS Terrain 50 into Postgresql/PostGIS for lat/long analysis

I am performing analysis using line of sight's and followed a very useful blog post at http://davidrowley.blogspot.co.uk/2013/08/calculating-line-of-sight-with-postgis.html which detailed how to load ...
3
votes
1answer
158 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. ...
0
votes
0answers
13 views

Cannot draw geometery on WorldWind

I'm trying to draw my geometery on worldwind but it keeps saying WARNING: Unspecified coordinate system and draws a default blue line in the middle of nowhere. The procedure is that I populate ...
0
votes
1answer
25 views

how to insert area of polygon into a column named area in a polygon map in cartodb?

SELECT ST_Area(the_geom) FROM cartodb_query gives the area but trying to insert it into an area column using: UPDATE cartodb_query SET area = ST_Area(the_geom) doesn't work.
2
votes
1answer
130 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 ...
0
votes
1answer
33 views

How to create a polygon from the union of the areas formed by a circle running in a line formed by two geographic points?

How can I create a polygon like in the right side of the picture from a line formed by two geographic points like in the left side of the picture in PostGIS? I was thinking in calculating the area ...
0
votes
1answer
33 views

Create blank table from unix shell

I am in the middle of trying to create my first PostGiS database and seem to be running into problems developing scripts to automate importing the various spatial formats so I can use them in my ...
1
vote
2answers
247 views

Create shapefile from data PostGIS or KML using Java

I'm working on a geographic information system project, whose products form shapefiles. I am using the Java programming language and a PostGIS database. Is there a way to generate a shapefile from ...
0
votes
1answer
28 views

where to download gdal_polygonize.py?

I am trying to help out a friend of mine. She learnt GIS in school in the past using ArcGIS but has recently installed QGIS package on her Mac OSX. When she tries to render raster into shape file, ...
1
vote
1answer
561 views

Error saving polygon with hibernate spatial and postgis

I'm trying to persist a com.vividsolutions.jts.geom.Polygon in my PostgreSQL (with PostGIS enabled) database, using Hibernate and Hibernate-Spatial plugin. Caused by: ...
0
votes
0answers
48 views
+50

KNN combined with other clauses

I have a table with columns:- wkb_geometry (geometry), road_id character varying, year INTEGER The data set has multiples of road_id across many years. I want to get the nearest 10 values to a ...
0
votes
0answers
19 views

Need to find polygon info from postgis

After importing shapefile into postgis I got geom data as MultiPoligon Like: ...
1
vote
2answers
77 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 ...
1
vote
1answer
22 views

Postgis 4D Range Query

Is it possible to express a 4D range query in Postgis? I would like to know what 4d points lie within a hypercube. This is my table: CREATE TABLE myTable ( point geometry, attrib ...
0
votes
1answer
171 views

ST_Dump not working with geometry_dump

I am trying to ST_Dump a geometry_dump column comprised of points and paths in PostGIS 2.0 using SELECT (ST_Dump(geom)).geom FROM pointdump However, I get the error message 'function ...
0
votes
2answers
423 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 ...
6
votes
1answer
119 views

PostGIS polygon edge analysis (orientation, edge length)

I am rather new to the world of GIS and especially PostGIS, so please excuse me if the answer seems evident... I would like to do analysis on a number of buildings. One thing I am interested in is ...
2
votes
1answer
540 views

Postgresql view with Point geometry returns QGIS error “(the_geom) sql = is an invalid layer and cannot be loaded”

I want to create a Postgresql view using point data. When I create the view, the geometry_columns table updates appropriately. Attempting to load in QGIS produces the error “(the_geom) sql = is an ...
1
vote
2answers
106 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
45 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 ...
1
vote
1answer
29 views

In PostGIS, why does ST_Covers return f on this query?

In general this query functions fine. In my PHP application I tested it with a large number of points, and they all seemed to be true or false as appropriate (when I pasted data into two online WKT ...
1
vote
1answer
190 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 ...