Tag Info

Hot answers tagged

4

I increasingly use Spatialite with QGIS effectively as a good, portable store for projects - and would say that the quick answer is 'yes, it's usable'. Store and access spatial and non-spatial tables in one place; Create views with linked data easily; Store style data together with tables / layers. However - I am also occasionally frustrated by some of ...


2

You can do this with two UPDATE statements, one for the distance, and the second for the line ID, with a subquery to get the values from the line table. And use the ORDER BY ST_Distance(...) LIMIT 1 construct to get only the closest line. I have a cities point layer, and a hiways line layer. Each has a primary key column 'pk'. I added to the cities two ...


1

H2GIS may fit with your needs as it does not require any installation (except Java) and is really close to PostGIS (SFSQL compatible). In a nutshell: H2GIS is to H2 as PostGIS is to PostgreSQL. H2GIS adds support for (MULTI)POINT, (MULTI)LINESTRING and (MULTI)POLYGON types, the functions specified by the OpenGIS Simple Features Implementation Specification ...


1

As you said, you could use embedded instance of spatiallite. In that case, it will starts together with your application, and keep all the data as one file, somewhere with your app resources. You could try JavaTopologySuit (or it's analogue for other platform). There are no such things like SQL queries, but it could create Spatial indexes, quickly select ...



Only top voted, non community-wiki answers of a minimum length are eligible