Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with postgis
Search options not deleted
user 51710
PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
4
votes
Accepted
PostGIS via GeoDjango: function ST_DistanceSphere(geometry, geometry) does not exist
Function st_distancesphere is avaialble for PostGIS version 2.2 and greater. … you can check your PostGIS version by using this query
SELECT PostGIS_Version(); …
- 2,281
3
votes
2
answers
642
views
Re-order multipart polygons in PostGIS
How can I do this in PostGIS, using any query?
I have a multipart geometry e.g. …
- 2,281
4
votes
PostgreSQL command takes 11 hours after update from version 10 to 13. PostGIS update from 2....
Please check that indexes exists on the table, if does not exist create new index or if they exist, rebuild those index. As upgrading from one version to another would change the index structure somet …
- 2,281
0
votes
PostGIS out-db CloudOptimizedGeoTiff with overviews is loading very slowly with QGIS
You can create spatial index on the raster table in PostGIS, and that can speed up the performance for the raster. …
- 2,281
1
vote
1
answer
255
views
Create topology PostgreSQL break line
I am using pgRouting on PostgreSQL 9.6, and for pgRouting. I need to run pg_createToplogy on the roads data, but it splits the roads at intersections and add source and target in respective columns.
…
- 2,281
0
votes
Compatibility between versions of QGIS and PostgreSQL including PostGIS
There won't be any issue with compatibility between QGIS and PostGIS. I have used with QGIS 3.2.5, PostgreSQL 14.x, and PostGIS 3.22.x, and there wasn't any issue with any workflow in QGIS. …
- 2,281
8
votes
PostGis vs Oracle Spatial 11g performance
Oracle Spatial and Postgis both have their own pros and cons. While dealing with the spatial data Postgis always outperform Oracle Spatial. … In many case studies it has been derived that PostGIS is 300%-400% faster than Oracle Spatial. …
- 2,281
4
votes
Accepted
Advance Digitizing tools with PostgreSQL views in QGIS
One approach to this problem could be that you can implement Row Level Security on your table based on the users and your own criteria. From your problem it seems that on splitting and merging new geo …
- 2,281
1
vote