Hot answers tagged sql
Load your shapefile(s) in as per instructions from http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/shp2pgsql.html Then query using something like SELECT sum(pointA.fieldB) FROM pointA, polygonC WHERE ST_Within(pointA.the_geom, polygonC.the_geom) AND polygonC.id = ?
You need to install the SQL Server Native Client so that your client machine (your PC) can talk to SQL Server. To connect to a database or geodatabase in SQL Server from ArcGIS for Desktop, install the SQL Server native client on the ArcGIS for Desktop computer and create a connection file in the Catalog tree See Connect to SQL Server from ArcGIS ...
The Example from the spatialite cookbook https://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/new-geom.html denotes: SELECT AddGeometryColumn('test_geom', 'the_geom', 4326, 'POINT', 'XY'); Strings are quoted here, so try to modify your comand to cur.execute("SELECT AddGeometryColumn('%s', '%s', %s, '%s', '%s')" %(table_name, geometry_column_name, ...
You have to create the view using a select statement with a casting case. For instance: SELECT CAST (miles AS INT) Once your view is created, it should appear in the catalog of your database connection.
There are several alternatives using CARTO to solve the points-overlapping problem. First, if you have a timestamp column and the deaths have happened in two different dates, you can use Torque. That is an animated map. Second, the Wizard of the old Editor allow you to aggregate points in clusters, intensity or density maps. But my favorite example is using ...
We are dealing with this issue right now and are looking at the DotSpatial library for .NET since it appears to have support for NADCON and NTv2. https://github.com/DotSpatial/DotSpatial
Only top voted, non community-wiki answers of a minimum length are eligible