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

How to do linear interpolation with mask in postgis

I have a point shapefile and a grid shapefile and want to do interpolation so that each of grids has it own value which is followed by the point shapefiles, also I want to add a polygon shapefile as ...
1
vote
0answers
12 views

How to create isometric 3D map with postgis

I am looking for a way to create isometric 3D maps based on data stored in a PostGIS database. My idea is to create a PostGIS function that will return a SVG image like the one below. It is easy to ...
1
vote
0answers
3 views

Import postgis layer from S3 link

I have a postgis layer (layer.sql), which I am trying to add to my postgres database (mydatabase). The postgis layer is stored on S3 (https://s3.us.../layer.sql). I can add the layer to my database ...
0
votes
0answers
16 views

from two tables make a new one

I have two tables both of them has linestring geometry. I try to make a new one which contain the first one and from the second take only the decimal v when the linestring of the first table touch a ...
0
votes
0answers
14 views

PostGIS Clustering. Group by geographic point location proximity

I have a table where i keep user's location history. The system gets user's current location each minute and writes it into "user_locations" table. Later on; when showing the locations that the user ...
0
votes
1answer
17 views

Creating an intersecting linestring layer from two polygon layers using some tolerance

I have two postgis layers: The first layer contains the sidewalks of my town (polygons in blue). The second one contains the pavements (roads) of my town (polygons in brown). The map looks like ...
0
votes
0answers
21 views

Store WGS-84 degree decimal minute coordinates in postgis database [duplicate]

I have some data in a texfile where the coordinates are given in this format: lat lon 23S19.69 66W45.87 24S01.73 66W55.61 I already learned that it is some kind of WGS-84 with degree and ...
2
votes
2answers
24 views

Combining ST_Touches and ST_Buffer

I'm looking for a PostGIS/Postgres query thats a bit tricky. I want to find all polygons within a specified radius and all neighboring polygons to the polygon where I have my coordinates SELECT * ...
0
votes
0answers
16 views

Use postgis functions in restful web service java

I am trying to access Postgis functions in Restful web service JAVA. I am using netbeans 8.0.2, Glass Fish, J2EE 7 to create web service, PostGres 9.2 and postgis 2.1.1. Connection to postgres is ...
0
votes
2answers
32 views

How to create a bounding box around a point using postgis

How to create a bounding box around a geom (POINT) and find all the intersecting geoms(POINTS) within that bounding box? Thanks in Advance
1
vote
1answer
147 views

Creating GeoJSON from Postgres

We are transitioning from Google Maps to Mapbox. Mapbox is a proponent of geoJSON and uses it extensively, so we are considering adopting it for all of our maps. An issue is the creation of the ...
0
votes
0answers
20 views

How to use interacting PostgreSQL/PostGIS triggers in QGIS?

I use point geometries (table 'label_point') to place multiple labels on polygon geometries (table 'soil'). After doing layer edits I've to update the affected label_point features. Therefore I've ...
0
votes
2answers
31 views

CartoDB's SQL API: Row too large

I am trying to run the following PostGIS query using CartoDB's SQL API: SELECT the_geom, ST_Area(ST_Intersection(the_geom::geography, ST_Buffer(ST_SetSRID(ST_MakePoint(-52.4379, -12.6235), ...
0
votes
0answers
18 views

Instruction to create OSM dump for PostGIS in windows

I want to import OSM data into a PostGIS database running under windows. After a web search I learned that I should use osmosis. But most of the explanations are for Linux. But I have to use windows. ...
1
vote
1answer
41 views

PostgreSQL 'forgot' PostGIS functionality

System details: PostgreSQL 9.3.5 64bit on Windows 7 Ultimate; PostGIS 2.1.3 Two days ago I re-organised my schema structure - effectively moving a series of tables of the form ...
3
votes
1answer
189 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. ...
3
votes
1answer
33 views

Adding vertices to polygon in PostGIS?

For example I have rectangular polygon (4 vertices). I want to add mid-point on each line of the polygon, so in total now I have 8 vertices. And from them I want to build new polygon who will have ...
1
vote
2answers
29 views

Intersection between line & polygon in PostGIS?

I have a linestrings consist of 2 vertices. I want to get all lines that don't intersects with any polygons on the way. In my example: blue line Not intersects - only touches some polygons, but black ...
0
votes
1answer
153 views

TileStache:TileStache.Core.KnownUnknown: Couldn't get a layer from data source!

I want to use tilestache to get geojson files. I hava run tilestache-server.py -c tilestache.cfg ,and it works well. However,I want to get tiles from data stored in postgis. Maybe it will need to run ...
3
votes
0answers
70 views

How to develop a QGIS plugin to fully run spatial queries with PostGIS?

I am developing a QGIS plugin that fully runs spatial queries with PostGIS. I developed all spatial queries which need some adjustment. I am looking for some resources or documents to know how to ...
1
vote
1answer
266 views

Conversion of EPSG:3857 coordinate to UTM

I'm trying to convert coordinates from Google Maps using the PostGIS. I'm using this query: SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(-29.16297 -51.1795034)', 900913), 29182)); The ...
0
votes
2answers
61 views

PostGIS polygon clip inaccurate using ST_Clip and ST_Union from tiled raster

I have a RGB raster tiled at 128x128 in PostGIS enabled database. I am trying to clip from the raster using a polygon as follows: SELECT ST_AsGDALRaster(rast,'GTiff') FROM ( ...
0
votes
0answers
33 views

Equivalent for PostGIS ST_SnapToGrid in ArcMap 9.3

I'm new with ArcGIS and ArcMap. I need to round coordinates on precision of 2 decimals while maintaining relations between them. So basically I need to make something to be equivalent of ...
1
vote
1answer
26 views

Postgis How to populate column with geography data from geometric data?

I stored my point date in geometry format with SRID 4326 supposed EWKB (data looks like this "0101000020E610000071F1A611E9392640AECD10D8E68C4A40") = way geometry(Point,4326) I want to have the ...
1
vote
1answer
24 views

SRID awareness in Postgis functions

I have a column named position with geo data. Query: SELECT ST_SRID(position) FROM checkpoint LIMIT 1; returns 4326 If I try to simplify/compress points with SELECT ...
2
votes
1answer
203 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 ...
1
vote
1answer
26 views

How to calculate overlap area of two polygons?

I am a beginner in the world of GIS. I have one table polygons with each polygon having north-east and south-west coordinates. And for every polygon, I need to find area of overlap with other ...
-1
votes
2answers
116 views

Sql Query in Postgresql

I am trying to execute a query but I am stuck. I have two tables A and B. The a table has columns gid, geometry(line-string) and value which cells is empty , the B table has got 3 columns gid, ...
3
votes
2answers
53 views

ST_Area of a buffer differs by coordinate

Why are these results different? The only difference is the coordinate. Seem like the area should be the same. select st_area(st_buffer(st_setsrid(st_point(-70, 40), 4326)::geography, 10)) AS ...
3
votes
1answer
187 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
0answers
29 views

Incomplete data - lines missing from osm2pgrouting

I am importing OSM data into PostGIS using osm2pgrouting but some data is missing/did not import. I am using the default mapconfig.xml and this appears to work for most roads. For example in below ...
0
votes
0answers
27 views

Snapping points to nearest road - query is extremely slow

I have a two tables containing (1) all parishes in Denmark (centroids) and (2) a road network of Denmark (OSM data). I am trying to find the nearest road for each parish centroid. To do this I'm ...
0
votes
0answers
22 views

Postgis reverse geocoding for other countries

I have tried using postgis_tiger_geocoder extension for reverse geocoding and it just has the U.S related data(56 states or so) but I need to have few more countries like canada and few more. Is there ...
3
votes
2answers
2k views

Loading shapefile to a specific table in postgis using ogr2ogr

I have already created a geometry table in postgis. I want to load several shapefiles into that table using ogr2ogr. But I didn't find the parameter which could specify that table. ogr2ogr -append ...
0
votes
0answers
10 views

Getting netCDF data into PostGIS database using Python?

I can read the netCDF file data with netCDF-python or with gdalinfo, but I am unsure of the easiest way to get it into a PostGIS database. It would be really easy if I could convert the netCDF file ...
2
votes
1answer
589 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: ...
0
votes
1answer
228 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
0answers
10 views

removing point cloud data from PostGIS

I'm ingesting dozens of LAS files into one table in PostGIS using PDAL using the example from pdal.io: <?xml version="1.0" encoding="utf-8"?> <Pipeline version="1.0"> <Writer ...
3
votes
1answer
50 views

Find all points within 5m with same name on large dataset

I have a large dataset (500,000 rows) in cartoddb which contains data like this.(abbreviated for easier typing) cartodb_id | count | lat | long | name | the_geom 1 ...
2
votes
3answers
626 views

ST_MakePoint or ST_PointFromText to generate points

I'm new to postGIS and am having trouble finding an answer to this question. I have loaded UK postcode data (OSGB36, SRID 27700 with eastings and northings fields) into a postGIS database. I now want ...
5
votes
1answer
94 views

Intersection of a vector linestring and underlying DEM

Following is an screen-shot where ASTER DEM raster layer has been overlaid by a road linestring vector layer. I want to extract those DEM pixels which are lying exactly beneath the linestrings. I want ...
2
votes
2answers
382 views

QGIS/PostGIS: Select Counties within Region via Spatial Query

I'm using GQIS 2.2 and PostGIS on Postgresql 9.3. I have 5 regions in the contiguous United States. Each region has states, and each state has counties. I would like to think that the data I'm given ...
1
vote
1answer
273 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
36 views

How to transform from a SRID to another?

How can I transform a geometric column of table from "SRID=4326" to "SRID=32650". I saw "ST_Transfom" and " ST_SETSRID" operator before. To do so, I used follow construction operator, But it dosen't ...
0
votes
1answer
25 views

How to identify the right road using postgres and postgis

I want to identify a road at particular point of intrest using post gis. Example Input String : 16th cross near xyz mall. Problem I am facing As there will be many "16th cross roads" in the map , ...
0
votes
2answers
440 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
2answers
482 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 ...
0
votes
1answer
18 views

Selecting points from intersecting an arbitrary (non-database) polygon with PostGIS

Determining a polygon as follows, and the points to check against, in ruby @poly = GEOFACTORY.polygon(@line_string1) @locations = Location.all @valid_locations = ...
0
votes
1answer
469 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: ...
1
vote
1answer
742 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: ...