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 postgresql
Search options not deleted
user 62486
PostgreSQL is an open source object-relational database system.
8
votes
3
answers
4k
views
How to make use of indexes with inner join in Postgis?
I got 2 sets of points in 2 separate tables. Table_a got 100k points and table_b got 300k of points. I trying to find nearest points in relation find me any point from table_b that is within 50 meters …
- 1,479
1
vote
Error in PostGIS intersection
It looks like postgis is getting into endless loop because of some weird geom and after while is just canceling query to not kill your machine. How many rows you got in each table?
Here's what you c …
- 1,479
3
votes
Accepted
Optimizing a nearest neighbor search in PostGIS for a large dataset
There are many ways to sort this issue and is probably duplication of multiple others, with the sole difference being a nearest neighbour search.
First of all create GIST indexes on your geometry fie …
- 1,479
4
votes
1
answer
964
views
Clip overlapping polygon in equal sharing size
I tried also to use ST_Difference postgreSQL database with the Postgis extension but also without success.
My main problem is that i can not find method to clip polygons on equal sharing size. …
- 1,479
2
votes
From QGIS 3.4.5 and 3.6 asks password repeadly to connect to PostgreSQL 10
You need to store the password during PostgreSQL connection adding.
Once you did it. QGIS should not ask you again for the password. …
- 1,479
2
votes
1
answer
2k
views
Postgis using st_geometry linestring on column
I'm trying to create a linestring based on a value in a column in PostGIS. My code looks like this:
create view left_span as
SELECT st_geomfromtext('LINESTRING(line_att.wkt_left)', 27700) as geom
FR …
- 1,479
1
vote
Finding nearest neighbor for each point in the same table
Try to use <-> function with 2D index on geometry.
CREATE INDEX points_geom ON points USING GIST(geom)
After that you can do it something like that if you want to find only the closest point to ano …
- 1,479