Tag Info

New answers tagged

0

Could you just use an alias, and subsequently reference the alias (in the example below, InTowns)? SELECT Towns.name, Schools.name within(Schools.geom, Towns.geom) AS InTowns from Towns, Schools As an alternative, you could do: SELECT Towns.name, Schools.name FROM Towns, Schools WHERE Within(Schools.geom, Towns.geom) In the latter case there would be ...


0

This is a much simpler method.. UPDATE lines SET GEOM = ST_LineMerge(ST_Difference(GEOM,(SELECT ST_Union(ST_Boundary(GEOM)) FROM polys WHERE ST_Intersects(GEOM,lines.GEOM) = 1))) WHERE (SELECT geometry FROM polys WHERE ...


1

QGIS print composer in > 2.6 can create georeferenced output as described in https://docs.qgis.org/2.6/en/docs/user_manual/print_composer/print_composer.html#creating-output If you need to export your layout as a georeferenced image (i.e., to load back inside QGIS), you need to enable this feature under the Composition tab. Check [checkbox] World file on ...


2

You are only inspecting osm_id field. It seems you didn't inspect your multipolygons table. On a local use case, I do : ogrinfo -so france.simple.spatialite multipolygons It returns FID Column = OGC_FID Geometry Column = GEOMETRY osm_id: String (0.0) osm_way_id: String (0.0) name: String (0.0) type: String (0.0) ... So the identifiers are not only ...


2

Try register your VIEW this manner: INSERT INTO views_geometry_columns (view_name, view_geometry, view_rowid, f_table_name, f_geometry_column, read_only) VALUES ('buffer500m', 'geometry', 'ROWID', 'point', 'geom', 1); read_only option boolean 1 for read only VIEW - read_only option boolean 0 for updatable VIEW. In Spatialite Cookbook not consign ...



Top 50 recent answers are included