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

learn more… | top users | synonyms

0
votes
1answer
19 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 usin Shape file and DBF loader. Then I ...
2
votes
1answer
94 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
16 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
142 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
845 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
31 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
17 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
55 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
145 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
13 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
298 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
15 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
18 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
156 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
12 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
23 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
129 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
31 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
246 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
25 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
554 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
36 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
73 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
21 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
169 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
117 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
536 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
105 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
44 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
28 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
188 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
2answers
437 views

Polygon intersection with bounding box with polygon's holes intact

I am trying to serve GeoJSON FeatureCollection tiles with each feature's geometries trimmed to the tile boundary. I am working on a Leaflet plugin to re-assemble the geometries. It works by building ...
6
votes
2answers
212 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
1answer
520 views

PostGIS: ST_Transform function conversion problem

I'm inserting map data from a GML file with srid EPSG:27700 into a PostGIS database table with srid EPSG:4326. I'm using the ST_Transform function as in this snippet: ...
1
vote
1answer
19 views

Fail to display correctly newly inserted data in PostGIS on Geoserver

I have created a postGis store in Geoserver. I have created layers with points and lines and I display them on an OpenLayers based application. I also use an FME workflow to insert new data to my ...
0
votes
1answer
28 views

Spatial join points and polygons in PostGIS

I have two spatial data sets in PostGIS tables: polygon grid (table: grid_jakarta) points (table:tweets) For each point in 'tweets', I want to retrieve the reelvant attribute 'gridID' from the ...
0
votes
0answers
16 views

Getting connected points in intersection from OpenStreetMap using PostGIS?

I'm trying to get the points that connected with the intersections. suppose that I know the point of the intersection (if we see in the pictures, I represent the intersections as black node). Now ...
6
votes
2answers
145 views

What controls the direction of TopoGeometry Linestrings?

In PostGIS, what if anything controls the direction that topogeometry LINESTRINGs will have when converted to geometry? It doesn't appear to be the order in which the edges are listed in the call to ...
2
votes
1answer
163 views

Creating a postgis database a GML application schema

Is there any open Source tool(automated or semi-automated) that converts GML application schema to a POSTGIS database/table .Specifically I have a huge application schema containing many ...
0
votes
1answer
19 views

Query table names

I want to query a table in my postgis table named Seg_060_2009 using psycopg2 and cant seem to get my query to execute. The query will execute if I name the talbe layer. Are there restrictions on ...
0
votes
1answer
20 views

Loop through table, look for word in text field, set boolean true if word exists

I want to create a function that loops through a table and checks if a specific word exists in a text field. If it does, the function should set a Boolean field true. This is what I've come up with. I ...
0
votes
0answers
32 views

Splitting lines table using point table in PostGIS

My problem is that I want to get the shortest route between multiple point pairs which are stored in a table (PostGIS). In PostGIS I also have a network created using pgr_createTopology on a table ...
1
vote
1answer
131 views

Openlayers wfs no fid being passed from tinyows

I have a webapp - OpenLayers<->tinyows<->postgis. With 1 layer I have a problem. On localhost all works well - here is a snip of the xml I get back: <gml:featureMember> <tows:trad ...
4
votes
2answers
60 views

How to extract nodes with PostGIS to a multipoint geometry

I have a line in a PostGIS table test_line. I want to extract it's nodes into a multipoint geometry. I tried the following: SELECT ST_Collect((ST_DumpPoints(the_geom)).geom) FROM test_line; But it ...