Hot answers tagged spatialite
rasterlite2 brings with it the wmslite wms server that can operate on rasterlite databases. So you run wmslite on your rasterlite db and then load the WMS in QGis. This https://www.gaia-gis.it/fossil/librasterlite2/wiki?name=tutorials is the index page for rasterlite2 tutorials, and in Step 5 of ...
It was obvious and I didn't read well the RTFM. See this discussion on the Spatialite mailing list. The answer is: SELECT ST_GeomFromText('POINT(1 2)', 4326); or SELECT MakePoint(1, 2, 4326); To make result as a text, do: SELECT hex(MakePoint(1, 2, 4326));
I believe you can do this through default top menu: Vector - Geometry Tools - Singleparts to Multipart... Though above the input there is written "Input line or polygon vector layer" I just tested it with point layer and it did work. Also once you create multipoint layer to edit - add / delete parts (point from multipoint) you need to use Advanced ...
Yes I guess it is possible (with spatialite at least). In spatialite for example you probably can do something like: CREATE TABLE yournewtable AS SELECT group_concat(foo), CastToMultiPoint(Gunion(GEOMETRY)) FROM your50000recordstable GROUP BY your700categories_column which should result in 700 multipoint features (1 per category), with GEOMETRY as your ...
Only top voted, non community-wiki answers of a minimum length are eligible