Tag Info

New answers tagged


You can only write such SQL if you use Personal Geodatabase (ACCESS) and if you open the geodatabase in Access. In this case you can use the IIF function as follows: iif ( condition, value_if_true, value_if_false ) Here is an example. You can't use full featured SQL using Personal Geodatabases in ArcGIS Desktop, only limited SQL-like expressions to ...


I suggest this: SELECT TOP 3 * FROM MyTable WHERE NOT [Field2] = '%Variable%' ORDER BY [Field1] Example Let's start with an unordered table: +------------------+------------+ | rainbow_sequence | color_name | +------------------+------------+ | 2 | orange | | 3 | yellow | | 1 | red | | ...


I think that this Plugin can help you. https://plugins.qgis.org/plugins/MultipleLayerSelection/


It turns out the MXD was just corrupt. I remade my mxd and everything worked fine. There were only lines and points.


Right click the layer and select "Properties..." to open the "Layer Properties" window. Select the "Source" tab and check to see if the "Geometry Type:" is "Multipoint" or a similar type of geometry. If so than there will be multiple points/polygons that correspond to one record and will result in the behavior you describe.


If using python (as your tag suggests), and ArcGIS (maybe?), you could do something like this ... (edited) # Check to be sure there is at least one feature selected. ftrCountBefore = int(arcpy.GetCount_management(layer).getOutput(0)) # ToDo Perform a Selection # ftrCountAfter = int(arcpy.GetCount_management(layer).getOutput(0)) if (not (ftrCountBefore == ...

Top 50 recent answers are included