New answers tagged

1

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 ...


0

The ArcGIS help site has guides for using SQL within both ArcMap and ArcGIS Pro called SQL reference for query expressions used in ArcGIS ArcGIS Desktop reference here ArcGIS Pro reference here While these may be very similar (if not identical) now, I have linked to both as the ArcGIS Pro one may change over time as the product develops. There is also ...


3

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 = ?


0

As Vince suggested, the query needed to return ST_Geometry, not ST_Point: SELECT OBJECTID, SDE.ST_GEOMETRY (SDE.ST_ASTEXT (SDE.ST_STARTPOINT (SHAPE)),300049) AS START_POINT FROM ENG.ROAD This SQL does not work for multi part lines. If you need to work with multi-part lines, my guess is you'll have to figure something out with the line string ...


3

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 ...


0

Now I have some trouble, I try to fill my geometry column with the following code : for i in range(0,len(list)): cur.execute("INSERT INTO %s (geometry) VALUES ('Polygon Z ((%s %s %s, %s %s %s, %s %s %s, %s %s %s))')" %(table_facette, Xp1[i], Yp1[i], Zp1[i], Xp2[i], Yp2[i], Zp2[i], Xp3[i], Yp3[i], Zp3[i], Xp1[i], Yp1[i], Zp1[i])) conn.commit() I got ...


0

It sounds like one or more of your layers is using invalid SQL. To determine which try: Adding a new data frame to your map Activate that new data frame and use Data View to view it Copy/paste one layer at a time into the new data frame until you see one that gives the invalid SQL statement message. Investigate the Properties of that layer to see whether ...


1

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


2

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, ...


2

SQL Server Spatial Tools is a CLR assembly that you can add to your database to assist with a number of operations that didn't come built in with the original release of SQL Server spatial objects. It has a set of functions to do similar operations as those found in Oracles SDO_CS. There is a projection example in the source code section, though it doesn't ...


2

FROM should contain table names, not column names (and 100 is missing here in the table name) The ON part should connect columns from both tables, but you have specified the same table on both sides. I suggest to put the whole sql statement in quotation marks, single ones for Linux and double for Windows. The roles of dst_datasource_name and ...



Top 50 recent answers are included