Questions tagged [postgis-2.0]
Version 2.0 of PostGIS brought a heavy set of new extensions for the PostgreSQL object-relational database, adding greater support for spatial objects.
445
questions
0
votes
0
answers
33
views
What kind of storage for my webgis app
I'm making a WebGIS app where users will be able to upload and visualize the data on a 3D map (with Cesium). It will be DEM, DSM raster files. For this webGIS app I have a Nodejs server for all the ...
1
vote
0
answers
107
views
QGIS, QField and PostGIS offline work
I am doing some testing on using QField to collect some data, I created all the layers on PostgreSQL, and prepare all my layers in QGIS, then export all the layers as offline editing.
The Issue, When ...
- 11
1
vote
0
answers
76
views
Intersection of major and minor roads from OSM using PostgreSQL
I found this question -> Overpass API: Find road intersection points with defined line that has an answer with a solution using overpass API:
[bbox:{{bbox}}];
way[highway~"^(motorway|trunk|...
- 31
1
vote
0
answers
39
views
Merge/union multiple row rasters into one
I stored Sentinel-2 images as tiled in the PostgreSQL DB. Now I am trying to clip it with geometry and it works fine, also converting raster to geoms (ST_PixelAsPolygons)is also working fine. ...
- 41
1
vote
0
answers
764
views
Export a postgis table to geopackage using the DB database manager in QGIS
I am working in QGIS through the DB Manager by running some spatial queries. After I create new tables with the queries I need to export the tables as new geopackages. I've tried using the Export to ...
1
vote
1
answer
42
views
PostGIS installation in Solus Budgie
Am new in Solus Budgie and am trying to install PostGIS have tried to look for any sources that has an article on same but no results.
anyone with a solution.
2
votes
0
answers
84
views
ST_Rotate in geometry Vs ST_SetRotation in raster
I have one polygon geometry (Square to be precise). I tried to rotate that geometry via ST_Rotate(). Then I stored that same geometry in a raster and tried to rotate the raster with ST_SetRotation().
...
1
vote
0
answers
60
views
raster2pgsql creates black and white tiles
im trying to build a tile from a geotiff however for some reason the output is black and white can anyone point out why and hopefully how to correct
here is a sample of the tiff
the import command ...
- 111
1
vote
1
answer
1k
views
PostGIS Column not found in geometry_columns table
I've just loaded a bunch of shapefiles into postgis using psql2shp (from the command line). All of the shapefiles appeared to have been inserted correctly and the table I created is populated. But the ...
- 177
0
votes
1
answer
294
views
pgr_dijkstra select shortest path for pairs
I have a a set of start and end nodes in a table
best_routes
start_vid | end_vid
-------------------
1 | 7
2 | 8
3 | 9
I want to use pgr_dijkstra to create shortest ...
- 85
2
votes
1
answer
125
views
Get majority value of raster data inside polygon using PostGIS
We have imported a tiff with landcover data into PostGIS as a raster table.
We also have a polygon table with provinces.
I'm trying to get the majority of the landcover in each province.
But can't get ...
- 323
2
votes
0
answers
176
views
PyQGIS 3 commit error with a PostGIS table on a nextval() column
I'm working on QGIS3.14.15 and I'm trying to update a PostGIS table with features comming from another table (pg_actual) and I have an error:
ERROR: 14 feature(s) not added. Provider errors: ...
- 612
1
vote
0
answers
286
views
How to make a PostGIS LINESTRING with only one initial point
I have a service that will be sending GPS coordinates as it moves, and these will be added to my PostgreSQL / PostGIS database.
Right now, created a table with one column that is a Geometry("...
- 269
1
vote
1
answer
94
views
Error load new layer from query result
I tried many times to create new layer from query result, but i got this error message, when loading it.
" PostgreSQL layer has no primary key."
SELECT * FROM pgr_drivingDistance('select gid::...
- 1,103
1
vote
1
answer
823
views
ST_Transform not working SRID
I have some MultiPolygon geometries in SRID 4258 and am trying to transform them into SRID 4326. When I run the following command, however, the output still seems to be in SRID 4258.
Command:
SELECT ...
- 11
2
votes
1
answer
265
views
How to remap a raster to its min / max values in PostGIS?
I have a table of 16-bit signed (!) integer heightmaps (SRTM tiles) loaded into PostGIS. This website showed me how to export a raster as a PNG to a file:
COPY (SELECT encode(ST_AsPNG(raster), ‘hex’) ...
1
vote
0
answers
73
views
Get the measure M along a CircularStringM in PostGIS without first converting to a LineStringM
I've been struggling to get PostGIS 2.5 to run any linear referencing functions on geometry containing curves (CircularStringM, CompoundCurveM for example). Is it possible to get the measure M along ...
- 3,701
3
votes
2
answers
333
views
Change of geometry type and buffer
I have a layer.
I want to transform the type of geometry from point to polygon while creating a buffer around points proportional to the population of cities.
I'm testing :
ALTER TABLE city
ALTER ...
- 841
2
votes
0
answers
205
views
Storing distance between two points in KM
I am very new to PostgreSQL and PostGIS. I am filtering a collection of messages based on their distance from a point which works great, but I would like to be able to store the distance between the ...
- 21
2
votes
1
answer
252
views
ST_3DIntersection PostGIS incorrect result
I have tried multiple times to obtain the 3D Intersection between a 3D linestring and a solid cube in both PostGIS 2.5.2 and 2.5.3 with the SFCGAL backend.
Below is a query that works as expected and ...
- 41
1
vote
2
answers
273
views
Calculate the maximum minimum distance from a geo object to multipoint?
I am working with postgis 2.0 and I would like to calculate the maximum minimum distance from a point set (multipoint) to a polygon. It seems that neither st_distance nor st_maxdistance can meet my ...
- 593
1
vote
1
answer
192
views
Creating Image Mosaic database table in GeoServer?
When I create an image mosaic store in geoserver, the table is automatically created in the PostGIS database.
If it is possible to alter the table name, how will GeoServer know what table to look to?...
- 43
0
votes
0
answers
374
views
Optimal way to find points within polygon in PostGIS
I've developed a query to find points which completely fall inside a polygon by using PostgreSQL 10 and PostGIS 2.4 database. The query took a long time (aprx 90mins) to produce the result. The number ...
- 1,051
1
vote
1
answer
364
views
Updating geometry as Multipolygon from Polygon table using PostGIS? [closed]
There are two tables in PostGIS. In which, one has polygon geometries with layer name wise and another one table has master layer name list.
The requirement is to collect the polygon geometries as ...
- 1,051
3
votes
2
answers
975
views
How to get number of Lane from OSM?
I am using OSM for my project, I have downloaded data from http://download.geofabrik.de/ in the OSM file and imported the data in POSTGIS, In the planet_osm_roads, I am not able to see any key related ...
- 169
1
vote
0
answers
92
views
How to speed up PostGIS intersects query?
I have a table which contains 5,00,000 records. I want to fetch all the rows which intersects with the given bounding box.
My query is:
select * from data_master b
where b.geom && '...
- 144
1
vote
0
answers
107
views
PostGIS ST_Within processing speed
I've created an SQL script that selects a given set of polygons ("v_rag_RenouvellementClaim") that are completeley within a specified buffer ("v_rag_RenouvellementClaimGrtr25000_Buffer") using PostGIS ...
- 285
1
vote
0
answers
239
views
Map Matching between two geometry (line string)
I have two tables in PostGIS, both having line string as the geometry type. I wanted to extract a similar or exact matching street. Can you please suggest query or algorithm for it?
Table 1
column ...
- 169
3
votes
2
answers
5k
views
Installing PostGIS after PostgreSQL Ubuntu 18.04
sudo apt-get install postgresql-9.5-postgis-2.5
returns a series of errors:
The following packages have unmet dependencies:
postgresql-9.5-postgis-2.5 :
Depends: libgdal1i (>= 1.9.0) but it is ...
- 257
1
vote
1
answer
119
views
ST_Centroid in view produces geometry without further definition from geometry(polygon, ssid)
I'm a Postgresql novice.
In a postgresql 9.2 + PostGIS instance I have one table with a geometry(polygon, ssid) column. From this table I am trying to create a view using ST_Centroid like so:
...
- 95
1
vote
1
answer
130
views
How to get the rectangular coordinates from list of line string
I have a linestring geometry in my PostgreSQL database. I want to get the corner coordinates of the rectangular bounding box. Example
"...
- 169
1
vote
1
answer
2k
views
Getting Latitude and Longitude from a Linestring
I have a linestring geometry in my Postgres database. I wanted to extract the latitude-longitude coordinates of each point inside the linestring. Example
"...
- 169
2
votes
0
answers
769
views
In QGIS, How to add the database connection in DB Manager via Python [closed]
I am using QGIS 3.0.2
I want to add connection settings in DB Manager via Python script. is it possible ? (I am interested in PostGIS and Oracle Spatial for now)
This script will save the ...
- 2,710
13
votes
5
answers
12k
views
"libintl-9.dll is missing" when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter
When I try to run PostGIS 2.0 Shapefile and DBF Loader Exporter I get the following error:
The program can't start because libintl-9.dll is missing from your
computer. Try reinstalling the ...
- 5,915
2
votes
1
answer
252
views
Intersection of touching geometries returns a polygon
I'm using Postgis 2.3.
I have two touching geometries that I got from an overlay (ST_Difference) operation:
id | st_astext
3 | MULTIPOLYGON(((0 -2,0 ...
1
vote
0
answers
179
views
Publishing web service using QGIS? [closed]
I want to show different types of surveyed land parcels which are available in shapefile format, in our country map. That map will be published in a web site and it will be available for surveyors.
...
- 149
0
votes
1
answer
3k
views
Postgis 2 - ST_area : huge difference between 3857 and 4326
I've been doing tests between projections with Postgis 2.3 and I was surprised by the result of the ST_area function with the Web Mercator projection (3857).
Here is a sample query and result on a ...
- 103
0
votes
2
answers
331
views
Problem While Selecting from table using ST_Transform
This following query is not returning any values
SELECT *
FROM leads
WHERE leads.latlong && ST_Transform( ST_MakeEnvelope(78.2137, 12.5186, 78.2460, 12.5419, 4326),3587);
Results like:
...
1
vote
1
answer
227
views
How to migrate PostGIS databases between Postgres versions?
Mac OS
I am trying to upgrade my Postgres version 9.2 to 9.6 and failing. My strategy was to follow the standard advice for Postgres databases and use pg_dumpall. This does not appear to work if ...
- 2,904
3
votes
2
answers
925
views
PostgreSQL is loading wrong PostGIS library
I am attempting to upgrade my version of PostgreSQL (from 9.2 to 9.6) on a Mac running 10.13.5.
I used pg_dumpall to backup the 9.2 database as per the instructions in the postgres documentation ...
- 2,904
1
vote
2
answers
784
views
MySQL 8 MBRIntersects 10 times slower than PostGIS equivalent
I'm trying to migrate a PostGIS database to MySQL 8 and am having a big performance hit when it comes to MBRIntersects.
Using Mapbox to render vector tiles, I need to extract geometry intersecting ...
- 11
5
votes
0
answers
153
views
pgsql2shp issue when using WITH clause
I'm using pgsql2shp.exe from a Windows batch file and I get an error when using a WITH clause:
"C:\Program Files\PostgreSQL\9.4\bin\pgsql2shp.exe" [ ... ] "WITH test AS (SELECT gid, the_geom FROM ...
- 2,690
0
votes
0
answers
241
views
Issue editing nodes on a PostGIS table via QGIS
I launch a PostGIS table via QGIS DB Manager tool [PostgreSQL 9.4.17 - PostGIS 2.1.8 - QGIS 2.18.19]. The table geometry is MultiPolygon. I can toggle both Toggle editing and Node tool buttons. When I ...
- 2,690
5
votes
1
answer
473
views
OSM2PGSQL - Openstreetmap Tiles showing no detail at certain levels
I recently built myself a Map server using this guide:
https://www.linuxbabe.com/linux-server/openstreetmap-tile-server-ubuntu-16-04
This has worked really well to an extent.
I have however noticed ...
2
votes
0
answers
201
views
Using postgis to rasterize a set of points grouping by time
I have used postgis for vector operations for years, but have recently begun a project mixing vector and raster data and I am bit confused as to what is the best way to do what I want to do. I have ...
- 121
5
votes
1
answer
1k
views
Get ST_SummaryStats from Raster Table using geoJSON polygon
I have a raster dataset imported into POSTGIS with SRS 3857. This table is named as prcp0000_normal3857.
The dataset represents statewide precipitation in Montana and can be downloaded below.
ftp://...
- 1,695
1
vote
1
answer
2k
views
PostGIS to dissolve all features
I have a multi polygon with spatial field layer with and 3000 records and I want to use dissolve all in 1 record.
On DISSOLVE algorithm in QGIS you have a choose to dissolve all features from layer ...
- 717
1
vote
2
answers
523
views
PostgreSQL query using GROUP BY question [closed]
I have a polygon layer table in PostgreSQL and I want to create a simple query using GROUP BY .
Here my fields :
fid field1
-- ----
1 text1
1 text2
1 text3
2 text1
3 text4
...
- 1,061
0
votes
0
answers
93
views
Two geometries not at same place
In the picture1 shown there is a linestring which is Area2 and a buffer of linestring which is Area1. I want to include Area2(linestring in picture) in the buffer but I cannot increase the size of the ...
- 225
1
vote
0
answers
230
views
how to split polyline where start/endpoints of the linestring touches or intersects with the nearby lines in qgis using python or postgis [closed]
I have a line layer and i want to find if the start/endpoints of the linestring touches or intersects with the nearby lines in qgis using python.
I have tried the following code but it is not ...
- 969