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

learn more… | top users | synonyms

5
votes
1answer
427 views

How to filter points based on proximity while inserting into PostGIS?

I have a large amount of locations that need to be inserted to a PostGIS database. However, I'd like to aggregate these points so that if there's already a location, say nearer than a kilometer, then ...
5
votes
2answers
283 views

Can't get Tiger Geocoder to work in PostGIS

I've installed the PostGIS Tiger Geocoder according to these instructions and loaded in data for the state of New York. Unfortunately, when I try to geocode something... ny_tiger=# SELECT g.rating, ...
4
votes
1answer
3k views

Performing Geoprocessing SQL Queries in QGIS from a PostGIS Database

This may be a dumb question, but is there way to run a PostGIS geoprocessing SQL query in QGIS? Specifically, I am thinking of running SQLs such as ST_Union, ST_Split etc etc. I have tried the ...
4
votes
2answers
4k views

How to select segment of linestring using PostGIS?

i have PostgreSQL+PostGIS. I have a linestring: "LINESTRING(60.7014631515719 56.8441322356241,60.7023117507097 56.8445673405349,60.702948200063 56.8447993944193,60.703902874093 56.8448574076656,60....
4
votes
3answers
1k views

How to find out what features /tags are included in an .osm or .pbf file?

I would like to load osm data into a postgis (postgresql) database. In How to load OSM data into PostGIS preserving all Tags? there has been a solution posted: Download the OSM files (in .osm format)...
4
votes
1answer
2k views

How to save a newly created shapefile in PostGIS?

I am creating shapefile using shapefile.py and my database has records more that 65k which is the limit of the shapefile. How can I create shapefiles then? Is it possible that somehow I am able to ...
4
votes
1answer
334 views

How to get User and Password of a PostGIS layer from PyQGIS

I wonder if it is possible to get the user and password for a PostGIS database if they are stored in the PostGis connection information. I get the connection information at the moment from the ...
4
votes
1answer
280 views

Update PostGIS after updating GDAL?

I am using PostGIS 2.0 and I want to use the raster functionality through mapserver. It seems as if the latest official GDAL release 1.9.1 has an unstable PostGIS raster driver, as pointed out in a ...
4
votes
1answer
117 views

Why does only one of the following queries throw an error?

There are 2 SQL queries: SELECT wkb_geometry FROM building_polygon WHERE ST_Contains(wkb_geometry, ST_GeomFromText('POINT (29.4 60.1)')); SELECT wkb_geometry FROM building_polygon WHERE ST_Contains(...
4
votes
1answer
90 views

PostGIS > Intersect two circles. Each Circle must be built from Long/Lat degrees plus radius

I'm trying to figure this out, so I wanted to try asking to the experts. This question is related to PostGIS (from postgresql). What I want is: 1) Based on a longitude and latitude I want project ...
4
votes
1answer
58 views

PostGIS point distance from polygon not 0 when on edge

I have a pretty simple problem: SELECT * FROM ST_Distance(ST_GeographyFromText('POLYGON((70 -40,70 -39,71 -39,71 -40,70 -40))'), ST_GeographyFromText('POINT(70.48 -39)'), False) returns 118....
4
votes
1answer
129 views

How to interpolate missing data from neighbours in PostGIS?

I have a dataset with point data within a given country. Let's say my dataset looks somewhat like this: tree_id | species | age | geom ------------------------------ 0 | Ash | null| ... ...
4
votes
1answer
447 views

Self-intersecting polygon using extreme values

I have this polygon POLYGON((1.2E-15 1.1E-15,1.31E-15 1.21E-15,-180 -90,180 90,1.2E-15 1.1E-15)) It uses an extreme coordinates like (1.2E-15 1.1E-15) and (180 90) When I call ST_isValidReason, ...
4
votes
1answer
332 views

How to detect if point is on the left or right side of the line in PostGIS

I have a linestring table and a point table in postgis. I know the closest line to any given point. What I need to know is on which "side" of that line is the point. I guess I have to do that by ...
4
votes
2answers
927 views

Indian Latitude Longitude values

I am in need of around 10000 and odd Indian latitude and longitude values for my openlayers project. I have to load them in a postgis db. so a sql file or atleast text file would be better than a link....
4
votes
2answers
9k views

Installing postgis on postgresql 9.1 not working

I'm trying to install Postgis 2.0 on a perfectly functionig postgresql 9.1.10 database. I installed the package via: richard@srv1:/$ sudo apt-get install postgresql-9.1-postgis postgis Reading ...
4
votes
1answer
603 views

QGIS cannot view raster loaded to PostGIS through raster2pgsql

I tried to load a raster GeoTIFF image to a PostGIS database using "raster2pgsql" following the OpenGeo Suite Manual. The command I used is: C:\>raster2pgsql -s 4283 -I -C -M "C:\Program Files\...
4
votes
3answers
68 views

Unexpected behaviour using ST_Equals() with QGIS

Let's say there is a table 'polygon_a' and a table 'polygon_b'. Each table contains three polygon features. The polygon features are spatially equal. CREATE TABLE polygon_a ( gid serial NOT NULL, ...
4
votes
2answers
241 views

How to display vertex markers in QGIS for non-editable layers?

I've a PostGIS layer with read-only privileges. Is there any way to display the vertex markers of the layer?
4
votes
4answers
1k views

Create a point x meters from origin using st_translate in postgis

How do I create a point 1000 meters away from a reference point? The ST_Translate only supports geometry type. I also tried using ST_GeomFromText but that returns a unit and not in meters. Here is ...
3
votes
1answer
5k views

How to get the coordinate system from a PostGIS database?

My question is probably amazinlgy stupid, but I can't find the answer myself. I would like to extract from a database the latitude and longitude of points. For now, I'm getting x(the_geom) and y(...
3
votes
1answer
586 views

GeoWebCache seed task dies immediately after being submitted

The data comes from Geofabrik's Brazil slice: http://download.geofabrik.de/south-america/brazil.html Imported into a PostGIS DB with osm2pgsql. GeoServer is 2.4.0, running on latest Tomcat 7.0.x, on ...
3
votes
2answers
560 views

ESRI projection to SRID?

I am looking at MapX and MapY coordinates. The docs say they are "truncated State Plane coordinates: NAD 1983 State Plane Louisiana South FIPS 1702 (US Feet)." I am trying to reproject into a common ...
3
votes
2answers
433 views

Trouble using ST_Difference to remove overlapping features

I am trying to use ST_Difference to create a set of polygons (processing.trimmedparcelsnew) that do not contain any of the area covered by another set of polygons (test.single_geometry_1) using ...
3
votes
1answer
1k views

Importing grib, grib2, netcdf to PostGIS

According to grib2 to raster? (grib2 -> raster2pgsql -> PostGIS 2.0 -> GeoServer), it seems like that grib2 can be treated as raster directly. Is it the so called "standard" way? How about ...
3
votes
1answer
119 views

Update table based on closest point between its geometry(Point) and another table's geometry (MultiLinestring)

I think my question is rather simple, but being new to PostGIS, I can't figure it out myself nor being able to transfer knowledge of other questions to my issue. The problem: I have two tables (...
3
votes
1answer
3k views

PostGIS Column has Z dimension but geometry does not

I am able to create a geomtry column for 3d multiline using this: CREATE TABLE trajectories ( gid serial NOT NULL, vehid character varying(10), state integer, geom geometry(...
3
votes
2answers
558 views

How can I GROUP BY linear spatial clusters with PostGIS?

I have a series of points in a horizontal line, arranged into discrete spatial clusters by the underlying data pattern. Here's an example of what they look like: How can I use PostGIS to group them ...
3
votes
1answer
793 views

Empty geometries in GEOMETRYCOLLECTION

I just noticed some strange behavior in PostGIS, with respect to WKT parsing. A GeometryCollection containing 1 or more empty geometries postgis_test=# SELECT ST_GeomFromEWKT('GEOMETRYCOLLECTION(...
3
votes
1answer
2k 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, ...
3
votes
1answer
1k views

Getting points within a range from a postgres database?

ok so this is query i'm making which returns no result: SELECT building.gid FROM building WHERE ST_Dwithin(building.geom, ST_GeomFromText('POINT(long lat)',4326), 400) If I run this ...
3
votes
2answers
427 views

small difference in projection between tilemill and postgis

I would like to create a world map with interaction on continents created directly from a postgis database. For the moment, I have a POSTgis database with the data. I created a background with ...
3
votes
1answer
220 views

Confused about ST_DWithin function postgis

First Time here. Anyway, I have a database that I want to use to store user locations. I want to be able to get all the users with in say 15 miles. How do I do this. I'm using PostGIS 2.1. My SQL ...
3
votes
2answers
125 views

Which one of these azimuth values is the right one? And why?

First of all, let's make clear that I want the Azimuth on the surface of the Earth, i.e. the angle between two locations, for example New York and Moscow. I am testing some azimuth calculations with ...
3
votes
2answers
2k views

How to find the best route through multiple points?

I am using postgreSQL, postGIS and pgrouting. Now I am really confused on how am I going to find the shortest path between multiple points. I know how to find it between two points through dijkstra ...
3
votes
3answers
2k views

How to find polygons inside polygon with PostGIS 2.0

I have a relation representing all the counties in my country and the other one containing all the districts - e. g. each and every county is composed of several districts. How do I select them with ...
3
votes
1answer
621 views

Making calls the PostGIS functions with Java

We have Java stored procedure in Oracle that make calls to functions offered by Oracle Spatial to perform spatial analysis and return results. I am looking to the same in PostGIS, is this possible?
3
votes
1answer
72 views

Dynamic Linear Referencing of events in QGIS from Excel or CSV using virtual layer

I have a PostGIS table with a geometry type LINESTRING M to represent routes. Here is the table specification: CREATE TABLE routes ( fid serial PRIMARY KEY, r_name text NOT NULL, geom geometry(...
3
votes
1answer
146 views

Update GeoDjango models from KML?

I'm working in Django 1.9 and Postgres 9.4 with PostGIS extensions. I have a KML file, and I want to use it to update my geo fields. This is my model: class PCT(models.Model): code = models....
3
votes
2answers
318 views

Does PostGIS have separate implementation of GiST index from PostgreSQL?

I want to know if PostGIS has a separate implementation of GIST index or it reuses the GIST index implementation provided by Postgresql?
3
votes
1answer
1k views

Postgis: Is there a way to do an intersection query based on lines while taking into account the dateline?

This is an exact copy of a question I asked on Stackoverflow a few weeks back and still haven't found a good answer for it. The original question is from here: original question. I've been searching ...
3
votes
1answer
527 views

Raster Tile Merge Performance of PostGIS 2.0

I'm attempting to intersect Australian Census boundary polygons with the 1" SRTM DEM (10.5bn points across Australia), and output the result as a single raster image on the fly. The DEM is stored in ...
3
votes
1answer
332 views

how to snap two line vertex in two different layers used in QGIS

I want to snap between two poly-lines from 2 different layers (Layer1 in Brown and Layer 2(postGIS layer) in Pink color- ), but my snap option don't work. I have changed the tolerance to different ...
3
votes
2answers
2k views

Export from PostGIS to SpatiaLite?

My PostGIS database contains OSM data from my country. For transportation reasons I want to export a spatial view I created from that data to a SpatiaLite database. Is there any way to directly ...
3
votes
1answer
693 views

Uploading raster format(*.tif) to postgis through raster2pgsql

I'm new to postgis and raster file format. i currently working on netcdf files and i want to import it into postgis through curl command line tool but its failed for me.so i jump on to GDAL v1.9.2 ...
2
votes
4answers
263 views

Linking up GPS points taken from rail network

Bit of a newbie here, trying to work out whether any PostGIS functions can help with my task. Apologies in advance if my use of GIS terminology is not up to scratch yet. I have a large database of ...
2
votes
1answer
278 views

Using PostGIS functions in ArcGIS Desktop for Layer Definition Query?

I am connecting ArcGIS Desktop 10.2 to Postgis 2.0.3 with PostgreSQL 9.2.4. No SDE. I can load data with no problems and access the data in ArcMap. However I can't seem to use PostGIS functions within ...
2
votes
0answers
59 views

Creating new PostGIS connection in QGIS?

I am trying to create a new PostGIS connection and I am doing as it follows: The password I inserted is postgres, I don't know what should be inserted there. And when testing the connection, I get ...
2
votes
1answer
118 views

PostGIS: How to understand ST_RasterToWorldCoord() right? (PostGIS 2.0)

After putting raster in to postGIS by this Thank @Sorin for helping me out! Now, I want to output raster tile, then view it on QGIS. But the problem is the output of ST_RasterToWorldCoord(raster rast,...
2
votes
1answer
351 views

When would a PostGIS geometry compare using ~= return true when ST_Equals returns false?

I have a couple of featureclasses in a 10.2 geodatabase/PostgreSQL 9.2.2 database and I've been struggling with the FeatureCompare tool--it is telling me geometries are different on some features ...