New answers tagged


what about... UPDATE munparcel_zoning SET imperv = ( SELECT pa.sum_permarea FROM ( SELECT parcelid, Sum(permarea) As sum_permarea FROM permability WHERE permtype = 'impervious' GROUP BY parcelid ) pa JOIN munparcel_zoning mz ON(pa.parcelid = mz.parcelid) ); ...does that get you any closer?


I will reply myself. This is not a direct aproach, but a workaround that it works: import subprocess["spatialite_tool", "-i", "-shp", "/xxxx/xxxxx/xxxxx/xxxxx/PARCELA_xxxxx", "-d", "/home/xxx/xxxx/xxxxx/villar.sqlite", "-t", "Parcelas", "-g", "Geometry", "-c", "UTF-8","-s","3042", "--type", "MULTIPOLYGON"])


I'd just like to add that checking for Spatialite support via ogrinfo --formats sqlite | grep 'spatialite' -i and an output of SQLite -vector- (rw+v): SQLite / Spatialite does not guarantee support. Mine outputs this but then ogr2ogr still fails claiming it does not support Spatialite. Instead, use ogrinfo --format sqlite | grep 'spatialite' -i (note the ...


You can use a local db create from a .shp using tile format stored in db called .mbtiles and for spatial querys still use spatialite. You can use ESRI sdk for android for maps visibility.

Top 50 recent answers are included