All Questions
Tagged with postgresql postgis-2.0
154
questions
0
votes
0
answers
38
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
109
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|...
1
vote
0
answers
60
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. ...
1
vote
1
answer
59
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.
1
vote
0
answers
348
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("...
1
vote
1
answer
107
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
vote
1
answer
992
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 ...
2
votes
1
answer
322
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’) ...
2
votes
0
answers
251
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 ...
2
votes
1
answer
277
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 ...
0
votes
0
answers
414
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
vote
0
answers
103
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 && '...
1
vote
0
answers
109
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 ...
1
vote
0
answers
274
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 ...
1
vote
1
answer
155
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
"...