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

learn more… | top users | synonyms

8
votes
1answer
807 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
13 views

POSTGIS query - extracting common point from polygon data

I have a polygon dataset and need to find the single common point where 3 polygons meet. I'm approaching this by creating duplicate tables and comparing them to the main one (polygon_table a). I've ...
1
vote
1answer
48 views

Strategies for managing (and ultimately merging) duplicate business locations in a spatial database

I am working on a project right now that involves using multiple (very large) "location directories" to identify with the highest possible inclusiveness, a diverse set of business locations. These ...
1
vote
2answers
412 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 ...
1
vote
0answers
21 views

PostGIS Geography data type not displaying in QGIS

I am trying to display data held in the PostGIS Geography type on a map in QGIS. Whatever I do I can't get it to work. Here is the SQL that creates my data - a single point in London. CREATE TABLE ...
1
vote
0answers
136 views

Find area with highest relative density of one type of object

I'm using PostgreSQL/PostGIS and I have an advanced type of query. My database contains two types of object - let's say pubs and churches :) Is there a way that I can find the area with the densest ...
10
votes
1answer
325 views

Open-source software for managing terabytes of different formats of geospatial data?

I have a problem that I am sure many GIS Teams or Departments have which is how to find, keep track of and manage multiple different datasets from multiple sources. I have read the responses from a ...
1
vote
1answer
40 views

Postgis ST_Distance query returning inaccurate results

I am using the following query to retrieve records from a postgresql DB @services = Service.select("*, ST_Distance(services.lon_lat, ST_GeomFromText('POINT (lat lon)', 4326)) as ...
1
vote
0answers
47 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 ...
5
votes
3answers
3k views

How to find the nearest point from POI in PostGIS?

I have Point of Interest data in MySQL. This are the fields latitude,longitude,address,types in which I have stored the data. Now i want to import it into PostGIS Database. But does it required ...
1
vote
1answer
144 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 ...
0
votes
2answers
414 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 ...
1
vote
1answer
39 views

error importing shp into postgis using ogr2ogr

I run an automated script that copies a number shapefiles into PostGIS. I have a problem with one dataset which fails during the export. As the roads.shp dataset is maintained by someone else, I ...
0
votes
1answer
154 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 ...
2
votes
1answer
476 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: ...
6
votes
1answer
1k views

Generating Interactive Tiles using Nodejs, Mapnik, and PostGIS for Leaflet

I am looking to do something like this but where I have all the data on the same server. I've been following through the set of tutorials @ sparkgeo.com/labs/big/ and I'm having some difficulty. ...
6
votes
2answers
138 views

Postgis 2.1 Inconsistent with spatialreference.org

The County of Napa, California, uses a projection "NAD_1983_StatePlane_California_II_FIPS_0402_Feet"; for example their roads.prj file has: ...
1
vote
1answer
64 views

Store a GeoJSON FeatureCollection to postgres with postgis

I am new to GeoJSON. I have a GeoJSON features collection as shown and would like to store it in postgres table (testtable). My postgres table has a serial id and geometry column. { "type": ...
6
votes
2answers
132 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 ...
1
vote
1answer
118 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 ...
0
votes
1answer
116 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 ...
6
votes
2answers
203 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 ...
1
vote
0answers
29 views

GeoDjango: AttributeError: function 'GDALAllRegister' not found

Im trying to get started with GeoDjango. I am using this https://docs.djangoproject.com/en/1.8/ref/contrib/gis/tutorial/ tutorial. When I run "python manage.py migrate" This error occur: ...
0
votes
1answer
31 views

Fast way to check if postgis bounding box contains any points/linestrings

I have a bounding box given and want to know if this bounding box contains (or better intersects) any points or linestrings. So the query should return true if the first point/linestring was found and ...
1
vote
1answer
39 views

Calculating Distances Between Geometry Columns of Differing SRIDs

I am attempting a relatively simple task but have been running into trouble. I have two tables, one which has lat and lon points which were geocoded using google (SRID 3857) and another table which ...
0
votes
0answers
12 views

pgsql2shp query error select

I need to export from postgis some data obtaining the center of my polygons, now I'm working on Ubuntu. My command looks like this: ./pgsql2shp -f /home/me/ESTADOS_POINT -h localhost -p 5432 -P ...
1
vote
2answers
159 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 ...
1
vote
0answers
21 views

Mapnik performance - large polyline dataset

I'm working with a very large set of polylines - contour data - to be rendered with Mapnik. (The contours are generated using gdal_contour from SRTM data.) At present I'm storing them in PostGIS and ...
0
votes
2answers
24 views

how to configuring geomajas wih oracle spatial db?

I have just done intial setup of the geomajas project and trying to config its data source with oracle database. I am following the given example for sqlserver and POSTGIS. My oracle layerroad xml ...
0
votes
1answer
155 views

Shp2pgsql - exec() not allowed on external server

Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise). We put these commands in a php variable and use the exec() command to execute them. This ...
0
votes
1answer
34 views

pgrouting pgr_dijkstra forcing route along a selected edge?

I have routing working where a user clicks 2 points on the map, I find the closest vertex to those 2 clicked locations and pass that to a pgr_dijkstra function. What I would like is give the edge a ...
0
votes
2answers
21 views

SRID is messed up when google-maps layer is added

I've some problems with using a PostGIS layer within QGIS. First of all, I had this same problem on both QGIS 2.4.0 and 2.6.1 I cannot display the Google Maps layer AND my PostGIS layer together. ...
1
vote
1answer
36 views

How to get pixel values/cell values for stored raster files in postgis?

Raster files in tiff format are storing into database.However I gets only an attribute table. Is there any way to retrieve pixel values/cell values in the table. I have used raster2pgsql command for ...
3
votes
1answer
35 views

ST_MakeLine within CartoDB.js

I'm building an interactive map using CartoDB.js in an HTML page. I have the user input an address that gets geocoded. I then use the user's lat/lon coordinates to perform SQL queries on CartoDB. The ...
1
vote
1answer
34 views

How to deal with multiple overlaps in PostGIS?

I've been fighting this for quite a long time and everytime I think I got it, I got it wrong actually. What's the trouble See picture below. As a result of line buffers I got overlaps that need to ...
1
vote
0answers
92 views

Do ArcGIS clients that direct-connect to postgresql/postgis databases override configuration settings?

I went in to modify some settings on a Postgresql database via the PGAdmin config editor and some of the settings don't have their default values and they are higher because they've been overridden ...
0
votes
2answers
188 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
2answers
33 views

Problem with a PostGIS trigger

I'm trying to update a lat and lon columns each time I insert a point with a trigger, but I don't know why I get an error. This is the syntax I'm writing: CREATE OR REPLACE FUNCTION update_tg2() ...
1
vote
1answer
981 views

Having trouble connecting QGIS with postgres database with postgis extension

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 ...
1
vote
2answers
228 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 ...
1
vote
1answer
241 views

How can I map data points to OpenStreetMap (OSM) line data?

my goal is to filter measuring points of vehicles by mapping them to streets. So I could filter out all the false data located in fields and rivers and so on. I imported my data into a PostGIS ...
3
votes
2answers
185 views

Where can I find the freeware ST-Links PgMap?

I am trying to connect to a PostGIS database from ArcGIS Desktop 9.3.1 Some web-searching suggested that zigGIS would be useful. Unfortunately zigGIS has reached the end of life, and the author of ...
2
votes
1answer
446 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, ...
1
vote
1answer
31 views

Geoserver GeoWebCache caches tiles of incomplete layers

I have data in a PostGIS database that is being pulled into Geoserver using a PostGIS (JNDI) store. The dataset I am using is a continuous polygon grid, but the dataset itself isn't all that large. ...
1
vote
0answers
12 views

Geoserver - How to make a psql-backed timestamp that uses timezones

I'm working on an application that extends geoserver and am frustrated as I'm trying to define a SimpleFeature that has timestamps that include timezones. I've tried declaring my timestamp field ...
0
votes
1answer
33 views

Plotting Street Map for City - Where do I start?

Please excuse my ignorance of this and if I break any of the rules please be gentle as this is my first post here and I'm not GIS expert either. I need people to steer me in right direction so that I ...
4
votes
1answer
62 views

PostGIS: Strategy for fastest select by BBox with an ORDER BY polygon area clause. Cluster?

Update 2 (below) suggests 14% of the table geometries are stored out-of-line with the rest of the table records. This may be a useful clue. The Problem: We've got a table with appx 170,000 WGS84 ...
1
vote
0answers
39 views

Installing PostGIS Layer Viewer for pgAdmin III

I have difficulties installing pgAdmin's plugin PostGIS Layer Viewer. The official repository on GitHub gives this Web site for install procedure, then the former site gives this Web site for ...
2
votes
0answers
20 views

Not able to get the PostGIS Layer Viewer running in pgAdmin or command line

I've installed PostGIS Layer Viewer as a plugin for pgAdmin. I've downloaded postgis_viewer.py from the official repository on GitHub! and followed the install instructions described on Web site!. ...
1
vote
0answers
28 views

I am getting error in PostGIS 'function st_clip(raster, integer, geometry) does not exist'? [closed]

I have to find the count of the number of pixels in a given band of a clipped raster. For clipping, I am using ST_clip(). Through clip function raster is clipped with a polygon. I am getting ...