Questions tagged [geometrycollection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
20 views

Is there a standard way to apply different field values to linestring vertices?

In QGIS I have several 3D points that I am creating a linestring from and each point could have a different value in one of the fields like "type". I want to somehow create the linestring and be able ...
0
votes
1answer
63 views

PostGIS Connection In QGIS. Vector Query Results of GeometryCollection Load Layer as Raster

https://postgis.net/docs/ST_VoronoiPolygons.html I am trying to load this query result using PostGIS 2.5 connection in QGIS 3.4, QGIS 2.18. SELECT ST_VoronoiPolygons(geom) As geom FROM (...
0
votes
1answer
301 views

ST_Multi returning GeometryCollection in PostGIS?

I am working in Postgres 9.6. I have a table called builtup_areas: Table "public.builtup_areas" Column | Type | Collation | ...
-1
votes
1answer
131 views

Splitting points from GeometryCollection?

I am using PostGIS ST_ClusterWithin function for clustering: SELECT row_number() over () AS id, ST_NumGeometries(gc) as total, ST_AsGeoJson(gc) as geo_collection, ...
4
votes
1answer
240 views

Export multipolygons into a GeoPackage

In FME, I use the Aggregator to merge polygons based on one attribute (desnat in my example file). When the output is Shapefile, multipolygons are created and all works fine. When the output is OGC ...
5
votes
2answers
429 views

Create a view based on table with GeometryCollection column for use in QGIS

I have a table with a geometry collection (polygon and point). QGIS can not read the geometry collection, so I want to create a view for the polygon type and the point type. My SQL function for the ...
3
votes
0answers
570 views

Working with GeometryCollection in Leaflet layer [closed]

I have a web app based on this template https://github.com/bmcbride/bootleaf The app works fine with point geometry but I would like each feature to have a point and a polygon. The geojson is: { ...
1
vote
1answer
373 views

Extracting GeometryCollections From SQL

I am trying to convert SQL Shapes to ESRI Shapefiles using the instructions in this blog post from a few years back and OSGeo4W. https://alastaira.wordpress.com/2011/09/29/exporting-spatial-data-from-...
1
vote
1answer
207 views

In PostGIS how can I do an ST_Intersection() search with a GEOMETRYCOLLECTION Geography field?

I have a Postgres table "files" with a lat/lon location field of type geography(GeometryCollection,4326). Right now the field only contains lat/lon polygons. I have succeeded in creating a gist index ...
1
vote
1answer
596 views

PostGIS do not want GeometryCollection in output

I am intersecting two layers. 1. truckmun which has multipolygon and polygon geometries in it 2. streamsw which is just multistring. The SRID is 3424 for both layers. Here is my intersecting query ...
3
votes
0answers
1k views

from geometrycollection to polygon geometry with python

I have a geojson file containing a feature with geometrycollection type (polygon and linestring). I need to produce two ESRI Shapefile from the geojson geometrycollection: one with Polygon only and a ...
0
votes
2answers
386 views

Building efficient multi geometry type database with PostGIS?

I'm trying to build a PostGIS database which must be able to store (multi)points, (multi)linestrings and (multi)polygons. The goal is to efficiently querying the data with ST_Intersects and other ...
1
vote
1answer
2k views

How to access members of GeometryCollection - Python

I am using 'intersection' function from Shapely to find junctions of a road network. As i found, intersection returns GeometryCollection. In my case it could be Point, LineString or perhaps ...
3
votes
1answer
458 views

Force ST_collect to return only a GeometryCollection

In the postgis documentation it is mentioned that ST_collect returns a MULTI* or a GEOMETRYCOLLECTION. But how can I force the function to only return a GeometryCollection not depending on it's input ...
4
votes
0answers
1k views

Can I use GeoJSON GeometryCollection in QGIS?

I want to create a GeoJSON that contains multiple geometries to be used in QGis later on. Now I red through the specs here: http://geojson.org/geojson-spec.html#geometrycollection When I simply copy ...
0
votes
1answer
1k views

GeometryCollection styling in Geoserver

I am trying to style an GeometryCollection geometry data type from PotGIS table in Geoserver. I have not found any examples on the Internet how to do it nor is it supported in Geoserver or not. When I ...