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 24605
PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.
4
votes
3
answers
747
views
ST_Union Topology exception despite of valid geometries
EDIT
Adding versions:
PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.2 20150212 (Red Hat 4.9.2-6), 64-bit
POSTGIS="2.4.4 r16869" PGSQL="100" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel …
- 461
0
votes
ST_Union Topology exception despite of valid geometries
I've tried several things and all of them worked:
Transform geometries to a local CRS.
Clean the geometries in GRASS by creating a topology.
Simplify geometries using ST_SimplifyPreserveTopology wit …
- 461
2
votes
1
answer
742
views
PostGIS with clause not using spatial index
This query uses the spatial index and it's quite fast:
explain
select a.the_geom from
chicago_major_streets a,
stormevents_locations_2014 b
where st_intersects(a.the_geom,b.the_ge …
- 461
13
votes
1
answer
4k
views
Why is st_intersects faster than &&
0103000020110F0000010000000500000000000000441519C1000000002BC5524100000000441519C1000000C069CB524100000000048E18C1000000C069CB524100000000048E18C1000000002BC5524100000000441519C1000000002BC55241'::geometry)
Rows Removed by Filter: 798260
Planning time: 0.134 ms
Execution time: 414.343 ms
PostGIS … version
POSTGIS="2.2.2" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.0, released 2014/04/16" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.2.2" need upgrade) RASTER …
- 461