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

learn more… | top users | synonyms

0
votes
0answers
76 views

Converting NAD 83 to WGS 84 in PostGIS

My question is about the best way to convert from NAD 83 to WGS 84 in PostGIS. I have a PostGIS DB containing National Elevation Data rasters. The rasters are in NAD 83 and I would like to convert ...
0
votes
1answer
65 views

PostGIS: Perform a Spatial Join only joining the intersecting polygon with the maximum value

I'd like to perform a spatial join using PostGIS. I've got table_A containing 80.000 entries and table_B containing roughly 1.500.000 entries. The entries in table_B have a column "number". My goal ...
2
votes
1answer
185 views

Draw line with lon, lat, distance and azimuth

I have table in PostGIS with lon, lat, distance and azimuth columns. I want to make Geoserver draw a line through first point with given length and direction. I can turn lon and lat to geometry in ...
2
votes
2answers
123 views

geometry from relations - osm

Can someone show me the relevant documentation for relationships between tables? I'm trying to get the geometry for an entry from the relations table but I'm unable to pick out the right information ...
0
votes
1answer
119 views

Moving file flat-nodes.bin from an osm2pgsql import

I'm running PostgreSQL 9.4 and osm2pgsql 0.82.0 on Ubunt 14.04 (64bit). I'm new-ish to postgres and less new to OSM. My goal was to import the planet file. Unfortunately, when I started the import, ...
0
votes
1answer
78 views

Add columns with information OSM by osm2po?

I imported the europa.osm network within my spatial database thanks to the osm2po tool. I use this with pgrouting. My problem is that I need to know the information provided by the tag address (city, ...
-1
votes
1answer
36 views

Rotate Polygon to be Parallel with the X Axis

By default, PostGIS calculates the Envelope or Extent of a polygon based on the bounding box of the polygon ((MINX, MINY), (MINX, MAXY), (MAXX, MAXY), (MAXX, MINY), (MINX, MINY)). This gives a result ...
8
votes
3answers
1k views

Poor performance with storing large rasters in PostGIS and visualising in QGIS

my question concerns the use and performance of several software tools in conjunction, namely PostgreSQL, PostGIS, QGIS, and GDAL. I'm a long-time ArcGIS, Python, and R user who is interested in ...
0
votes
0answers
19 views

Any experience or tips for using qgis with postgis layers? [duplicate]

we want to replace our shapefiles with postgis layers for editing in QGIS. We plan to edit 1 Layer with 5 people at the same time is this possible? Is this a good idea or is there a better practice ...
2
votes
1answer
40 views

Postgis spatial query st_disjoint

I have 2 layers that I want to compare. I wish to retrieve the features in the layer 1 that have no part in common with the features in the layer 2. I try queries like that but do not returns me the ...
0
votes
1answer
25 views

PGR_Djikstra function error

I'm trying to find a shortest path between 2 nodes using djikstra method but it keeps saying ERROR: Error, query must return columns 'id', 'source', 'target' and 'cost' this is my query: ...
0
votes
1answer
113 views

Align pixels from two rasters with different cell sizes

I have two rasters in a PostGIS database that I want to be able to compare. The first raster is at 5m pixel resolution and the second raster is at 30m pixel resolution and is on a different grid. How ...
0
votes
0answers
25 views

How to remove lines made with a PostGIS query automatically if origin is not in the map window?

I have a PostGIS point layer with labels. I moved these points because they were too close. To connect label and point, I created a line vector layer which was made with a query in the DB-Manager (...
1
vote
0answers
263 views

Creating quadtree index on latitude, longitude data in PostGIS

I have a table of locations in which one of the columns represents the lat-long for the location. These coordinates have been extracted from the OpenStreetMap file. How can I create a quadtree index ...
0
votes
0answers
47 views

Up-dating postgis spatial table from CSV files

I have a PostGIS Table I produced from importing a layer file itself created from a CSV. I am getting updates to the main file through other CSV files and need a method of importing the new CSV's into ...
0
votes
2answers
79 views

Hardware Requirements ? Overpowered?

I'm running a i3 3,1 GHz Machine, 4 GB of RAM with an onboard Graphic Chip. I build a small GIS with Mapbender3, Geoserver based on PostGIS data. It's running pretty fluid from what i can see. Now i ...
1
vote
0answers
88 views

Web Application for display raster data on basis of time slider

It May act as a duplicate question to many, but i have tried refering too all the questions related to my questions, but i am still confiused. Below in attached my code. which i use for Web Mapping ...
1
vote
1answer
48 views

What can I use to generate an interconnected graph from a series of coordinates?

I have a table containing latitude and longitude coordinates, and I'd like to be able to build an interconnected graph from it to use with pgRouting. Is there an existing feature of postGIS or ...
0
votes
1answer
512 views

Import point cloud into PostgreSQL/ pdal pipeline fails

I have a point cloud dataset that I would like to upload to my postgres/postgis database. I followed this tutorial and I could install everything without problems (on ubuntu 14.04. On ubuntu 12.04 ...
0
votes
0answers
55 views

Unable to Display Postgis Database Table Geometry Column Points in Geomoose

I'm a beginner in this field.I want to plot the postgis database table geometry column in geomoose but it is showing a pink tile.Through an android device we are pushing latitude and longitude to ...
0
votes
1answer
67 views

postGIS st_equals function not working as expected

I have a situation where I need to find out if a geometry being imported into a postGIS 2.1 database matches one drawn previously (i.e we want to know if the imported geometry is less up-to-date than ...
0
votes
1answer
47 views

How does ST_SnapToGrid work using nearest neighbor interpolation?

I have rasters in a PostGIS database that are not necessarily aligned (some rasters offset from the grid). I want to use ST_SnapToGrid to align all rasters to the same grid but have some questions ...
1
vote
0answers
43 views

How does `ST_Union` treat NULL values in a raster?

My question is about how ST_Union of rasters containing NULL values are handled. For example suppose I have two rasters that intersect but the values of the intersection are NULL in one of the rasters....
0
votes
0answers
46 views

Densifying OpenStreetMap (OSM) network nodes?

I am working with osmconverter to convert osm files(*.osm) to *.pbf, then i use osm2po to get sql file that run into PostGis to get a network table. The last step is to run a createTopology ...
4
votes
1answer
923 views

How to create an exact tracking route from GPS data with animated icon?

Probably this is not purely GIS related question, its related to developing issues. I am just asking if there is any kind of suggestions from Gurus. I am building an tracking application where GPS ...
3
votes
2answers
195 views

Remove specific points from linestring postgis

I am working with a data set that has been using the (0 0) point to pad any points that were missing when the linestring was created. So now the query SELECT id, route as line FROM trips ...
0
votes
1answer
198 views

pg_dump Database that was populated with osm2pgsql

Is it possible to dump a postgres database that was created with osm2pgsql and a .osm.pbf file with pg_dump and import this into a remote postgres database? After running osm2pgsql the database is ...
1
vote
0answers
172 views

Help serializing a postGIS query to geojson

I have a query which I would like to serialize to geoJSON: select article_title, pub_date, city, geom from article, location where article.id = location.id; I can serialize the geom field easily ...
0
votes
1answer
202 views

Check if point is inside unclosed linestring using POSTGIS ST Functions [closed]

I have a table with spatial data. This table contains a single record which is a unclosed linestring. I calculated the Centroid of this geometry using query SELECT ST_AsText(ST_Centroid("geom")) ...
0
votes
1answer
38 views

Converting spatial data to table of vertices using PostGIS?

I have a spatial data table in PostGIS 2.1 that looks like this: Geom | type | cost POLYGON(0 0,1 1,2 2)| A | 123 POLYGON(3 3,4 4,5 5)| b | 123 I am trying to create a ...
14
votes
3answers
827 views

How fast should I expect PostGIS to geocode well-formatted addresses?

How fast should I expect PostGIS to geocode well-formatted addresses? I've installed PostgreSQL 9.3.7 and PostGIS 2.1.7, loaded the nation data and all states data but have found geocoding to be much ...
1
vote
2answers
248 views

Utilizing OSM Data in a Postgres/PostGIS database in ArcMap

I've been trying for over a week now, and I'm not sure what i'm doing wrong and I haven't found the answer yet. I am trying to display and symbolize the OSM dataset over Jordan in ArcGIS for Desktop ...
3
votes
1answer
109 views

How to change the “application_name” of a PostGIS-connection in QGIS?

PostGIS offers a view called pg_stat_activity, where you can see all the active connections to the database. This view includes the interesting column application_name. When a connection comes from a ...
1
vote
1answer
106 views

How to create regular point grid inside a polygon in Postgis without knowing cell size but cell number?

I need to create a grid within a polygon like it is done in How to create regular point grid inside a polygon in Postgis? There a function is created to draw the grid points. But necessary to know ...
0
votes
1answer
190 views

QGIS DB Manager - load as new layer not loading

After successfully running an SQL query on two tables and some results in 3 columns, I would really like to be able to display it in the canvas. Apparently, that function is not doing anything, not ...
1
vote
1answer
88 views

PostGIS 3D bounding box query that envolves all 3 axes (xyz)

I have some experience with PostgreSQL, but not with PostGIS, and for the life of me I can't make my bounding box take the Z axis into account. I have a points table with XYZ columns. I add another ...
1
vote
1answer
98 views

Number of Neighbors Around a Point

I need to get a count of neighbors within 100m for each point in a set of 250 million points. The result would have the id of each point accompanied by the number of neighbors around them. Can this be ...
1
vote
1answer
59 views

Best way to filter points given a starting point and max travel time

I have a database of about 1M geolocated addresses and I'm looking for a way to sort/filter these records based on a starting point and max travel time. Ex: "find every baker shop within 30 min ...
1
vote
0answers
38 views

Merging DEM files using PostGIS

I have several DEM files and I want to merge them to create a mosaic. I found the St_Union(raster) or St_MemUnion(raster) functions but I don't know how to use them. Are there any other solutions?
0
votes
1answer
1k views

How do I explode a MultiLineString using ST_Dump() in PostGIS?

I want to do what this blog post does: explode a MultiLineString into individual LineStrings. I'm using CartoDB but don't get individual LineStrings as the result of my query. I still get a ...
1
vote
0answers
102 views

OSM Bright Cartography XML

So I've successfully setup a tile server as described here: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ What's troubling is the lack of clarify surrounding OSM Bright ...
0
votes
0answers
107 views

Use QGIS and Qt dialog forms

I have a QGIS project where there are plots with a attributes like name of the owner, address of the owner, cultivate, and so on. This plots are read from a PostGIS database. The future users of this ...
0
votes
1answer
41 views

Using virtual or temporary geometry with PostGIS and pgRouting

I am attempting to find the shortest/fastest routes from GPS point to GPS point as described in this post: Create closest point on multilinestring to use in shortest_path() I have seen many solutions ...
1
vote
0answers
61 views

Displaying multiple features from a geoserver layer with time and style in a KML

I have 4 datasets organized in a PostGIS database each of the same geometry and location except they are at different times. They each have a corresponding datetime field. I can load these into a ...
3
votes
0answers
165 views

Selecting all pixels above a given value in a raster in PostGIS

I have a raster with one band whose value represents the date of the occurrence (a sequential integer). This raster file gets updated regularly, and each time that happens, I need to run a process ...
1
vote
1answer
424 views

Rendering TopoJSON in Leaflet from GeoJSON PostGIS output?

I'm using the query found here SQL query to have a complete geojson feature from PostGIS to get a geojson that I can display on a leaflet map. However, the amount of data is kinda big and the ...
0
votes
0answers
246 views

OL3 doesn't display the wms Layer

This is pretty much related to the question asked in the following link How to add Mapserver WMS to Openlayers 3 I followed the example in http://openlayers.org/en/master/examples/wms-image-custom-...
2
votes
0answers
136 views

Merge raster tiles in PostGIS

I have several raster tiles that are adjacent and non-overlapping, so they form a mosaic. I am trying to merge two adjacent rasters using PostGIS but am getting an error that they do not have the same ...
0
votes
1answer
31 views

Reprojection not generating properly the tiles

I am executing this query with cartodb.js. I am moving the markers radomnly to generate a new layer. cartodb.createLayer(map, { user_name: 'mickemr', type: 'cartodb', sublayers: [{...
3
votes
1answer
138 views

Postgis query on 3D cube does not use index

I am testing Postgis on the follow query: SELECT * FROM particles WHERE position &&& 'LINESTRING(0.08537 0.0738 0.0145,0.0953 0.0837 0.0345)'; that returns about 100k rows from a ...