A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [select]

The selection of data from a database based on some criteria.

Filter by
Sorted by
Tagged with
1
vote
1answer
38 views

Selecting elements by grouping with one attribute and specific rule using QGIS

I have a question about a specific query for a Shapefile-Layer in QGIS 3.4. I have a Point-Shapefile with the name point.shp. The Shapefile has a lot of different points with a large amount of ...
0
votes
0answers
32 views

Select and Delete from Multiple Layers at once in QGIS

I have imported a CAD drawing into QGIS as a GPK. It has imported everything that was in CAD. Now I want to delete features that I don't need. See below: I know how to turn each layer on and then ...
1
vote
2answers
45 views

ArcPy Select Layer by Attribute for Date and Time

I have a list of trips with a field, "Trip Start Timestamp" thats type is date where it appears on the attribute table as M/D/YYYY HH:MM:SS AM/PM I need group all trips with the same trip start ...
0
votes
1answer
60 views

Selecting only specific features not all, and dragging and dropping correctly [closed]

First issue: I would like to select only a few features and not select rest Let imagine I have 5 features in below code you will see that I can select all of them. Second issue The second issue is ...
0
votes
0answers
20 views

Creating Layer from Selection in ArcGIS Online

I am trying to create a layer from a selection using a layer I have hosted in ArcGIS Online. I have run into 2 issues: I'm not able to select multiple features on the map (only by scrolling thru the ...
1
vote
0answers
35 views

Creating automatic sum column in ArcMap

Using ArcGIS 10.3 I have a table with different categories and would like to summarise each of them. I want it to work as well when these data are selected inside a polygon. Below is an example of ...
1
vote
1answer
42 views

How to select one band in image using rasterio

I have two different images and I want to select one specifi band from each one of them and calculate regression between them. Each one of those bands is a result of calculation I did (in the first ...
1
vote
0answers
24 views

Defining variables by selection

I'm working on a valve isolation project for a natural gas application. I'm a design engineer foremost, but like to play with programming and GIS applications fairly often. I've got a bit of ...
2
votes
0answers
36 views

selection expression to display the first 5 rows only in QGIS 3.8.3 [closed]

I would like to display the first 5 rows only in QGIS 3.8.3 from the attribute table of a layer in ascending order. I tried many selection expressions, but, none of them seems to work. Is it ...
1
vote
0answers
19 views

OpenLayers zoom selected feature

In our OpenLayer.js we first call the maximum extent of the map: "maxExtent: new OpenLayers.Bounds (X1, Y1, X2, Y2),". After the layer definition follows "map.addLayers ([lyr1, layer3, layer4]);" ...
1
vote
0answers
19 views

Write ID f selected feature to txt/csv

I want a code or an option in QGIS or in a web map using Qgis2web (in leaflet or openlayers), when I click on a feature on the map, automatically it should register the ID (from attribute table) of ...
1
vote
2answers
46 views

Select_analysis Looping gives ERROR 000732

The script I use for select_analysis is no longer working. I believe part of the problem is the source data I use (and I'm not the administrator of) has changed the field properties of the attribute I ...
0
votes
0answers
17 views

Selection shows in Attributes but not on web map served by ArcGIS Server

In ArcGIS Online webGIS, I created a map application. I have a particular layer that if I were to try to select an object within that layer, the selection displays in the attributes table, it displays ...
0
votes
0answers
26 views

Understanding OpenLayers Multi-Select

I'm having trouble filling in the missing gaps of this OpenLayers 5 example: https://openlayers.org/en/latest/examples/select-multiple-features.html?q=select there's a selected array that they push ...
0
votes
1answer
44 views

OpenLayers 5.3 selected point feature does not return properties, but polygon does

I am having some issues in OpenLayers 5.3.0. The context is that I'm using Sharepoint lists as a backend to save feature data and OpenLayers is running in a Vue.js container. Everything works as ...
1
vote
1answer
47 views

Random selection of polygon but with certain value

i'm using QGIS, and i have a multi polygon which has more then 6000 features with population data in it, so i want to select only 400 features randomly but the selected feature need to have a certain ...
0
votes
0answers
23 views

ArcMap losing selection of asset features?

I am currently working through asset updating and wondering why this is happening. Scenario: I've selected more than 50 of the same feature class poly-lines. Now I edit to add photo numbers from an ...
0
votes
1answer
57 views

OpenLayers Get Column Value Of Currently Selected Feature Having JSON Data Source

I have a service that return data in json format as the following snippet: {"type":"FeatureCollection", "features":[{"type": "Feature", "id": 1, "sheet_no": "NF4011D", "geometry": {"type":"...
5
votes
1answer
120 views

Selecting line features by topology in QGIS (select dangles)

I want to select line features by their relationship to their neighbouring line features. To perform generalisation on the data set I need to select lines that: Do not intersect with their end point ...
2
votes
1answer
65 views

Select single features in selection

I have a selection of 30 features from a dataset in QGIS. I want to inspect every single feature one after another with the attributetable and the icon 'zoom to selected object'. If I click on one row ...
1
vote
0answers
28 views

Selecting points with specific attributes in ArcMap ModelBuilder?

This is the example of my problem: I need to collect points that are within polygons. There are some polygons that contain more than one point. In this case I need to select one point with a specific ...
1
vote
0answers
27 views

Different numbers between count points in polygon and select by location

When I'm running the points in polygon in QGIS I get one result (125) and when I try to select the points to extract as a layer, select by location, I get another result (213). If I extract the ...
0
votes
2answers
57 views

ArcPy: Select_Analysis Invalid Characters

The following script produces the ERROR 000210: Cannot create output... .shp and ERROR 000354: The name containts invalic characters Failed to execute (Select.). The line with arcpy.Select_analysis ...
1
vote
2answers
52 views

Selecting all the pixels in a raster coverage that have a specific pixel value? (in PostGIS raster)

I have a land use map in the format of TIFF. I imported this file as a table in PostGIS using raster2pgsql. The land use file has 7 different classes. How can I select all those pixels that have the ...
2
votes
0answers
27 views

Selecting annotation by color to correct Annotation Class using ArcPy?

I have some municipal data that was converted into a GIS and all of the address numbers were coded as dimensions in the annotation feature class. There is an annotation class for address, but none of ...
0
votes
1answer
47 views

Using ArcGIS Field Calculator?

I have a large shapefile with 2,5 million points and I would like to create a new field in the attribute table that groups the features into groups of 65000 features. In other words: Select the first ...
1
vote
1answer
50 views

How to break bond of select and modified feature OpenLayers

I have select and modify interaction instantiated. Also I have event onChange binded to selected feature. select.getFeatures().getArray()[0].on('change',function (){ sources.verteksi.clear() ...
1
vote
1answer
40 views

How to identify all selected features

At the moment I have selected numerous vectors in a layer using the Select By tool, but what I want to do now is go to the attribute table and only find the selected features that would be highlighted ...
3
votes
1answer
471 views

Selecting features from multiple layers for export QGIS 3.6

I have multiple features I want to select over multiple layers and then export these selected features to a new layer. The 'Multiple Layer Selection' plugin is not supported by the QGIS 3.6 so that ...
0
votes
0answers
47 views

Exporting selected features using ArcPy?

# Wetlands buffer.py # Description: Program that determines if Wetlands are within 0.5 miles of specific point files with the program returning a 'yes' or 'no' if a wetland is within the range or not. ...
2
votes
1answer
74 views

Creating Spatial View … GIS/SQL

I have created an enterprise geodatabase in my local instance of SQL Server and I want to create one select statement of multiple select statements within multiple tables and feed this into a view. ...
1
vote
1answer
29 views

Selecting features within specific area in polygon

I'm working on a water utility network. My municipality is in another multipolygon feature. The attribute field "area name" defines other cadastral municipalities. I want to select parts of the water ...
0
votes
0answers
24 views

Can only select certain polygons

I have only one vector layer on my map, and it's not letting me select some polygons. For instance, this is what happens when I try to select a certain polygon (the yellow outline with the blue star ...
0
votes
1answer
64 views

PostGIS: unable to import GeoJSON data (selected attributes) to PostgreSQL database using ogr2ogr

I downloaded sample OSM data of my area of interest via Overpass-turbo as my_map.geojson. I am trying to import this geojson file to my PostgreSQL 10 (Windows 8 x64 machine) database using ogr2ogr (...
2
votes
1answer
75 views

processing.run() returns string instead of QgsVectorLayer with QgsProcessingFeatureSourceDefinition as parameter

I try to run qgis:difference on selected features of 2 layers. But the result of my code : parameters = {'INPUT': QgsProcessingFeatureSourceDefinition(layer1.id(), True), 'OVERLAY': ...
1
vote
2answers
695 views

Selecting highest value within group using QGIS?

I have a .shp of points. This points are organized in groups with same ID (group 1, 2 ,3) Each group has 10 points. Each point has a Z column with Z values. I want to select the point with the ...
1
vote
1answer
68 views

Selection Symbology in QGIS

In ArcMap, I can change the selection outline from the default RGB (0, 255, 255) to whatever color I want by going to Selection > Selection Options > Selection Tools Settings. In the example below, I ...
1
vote
1answer
26 views

Select records from shape that do not match another table's values

New to the forum, so I apologize for my bad English and if I'm being inconvenient somehow! I read answers that are similar to my question but none of the ones I found fits my case. I have a shapefile ...
1
vote
0answers
163 views

Selecting nan values in QGIS?

I have a shapefile of a lot of polygons. I calculated perimeter of each polygon and some polygons returned nan values as they have hole/ring. I am looking for a way to select the polygons with 'nan' ...
1
vote
0answers
51 views

Arcpy multiprocessing arcpy.Select_analysis

I have the following script: import arcpy from arcpy import env import datetime import os env.workspace = r"Q:\\SDE\Direct Connection to Contours.sde" dataFC = arcpy.ListFeatureClasses("","","...
-1
votes
1answer
72 views

How to select attribute specific values? [closed]

I have table like I need to select if R_no values is more than two same values and in ANGLE select first three numbers common and more than three attributes is same Finally I want to select like ...
1
vote
2answers
156 views

QGIS Polygon Selection

I want to select a polygon using QGIS. The polygon is only represented via it's boundaries (I chose not to fill the area in order to highlight the problem). Why are not all lines that surround the ...
1
vote
2answers
154 views

Selecting latest date with QGIS field calculator?

My shapefile contains columns like "Street", "number" and "date". What I want to do is, to find the latest date (where we have done house services). If we have 2 dates for one house number ("number")...
1
vote
2answers
172 views

Adding new features to selection list using PyQGIS?

The code written by Joseph answering to the question Features to stay selected by default in QGIS? layer = qgis.utils.iface.activeLayer() # Use active layer def select(featureAdded): layer....
3
votes
1answer
142 views

Selecting polyline between two point features using ModelBuilder?

I am looking to select a segment of a polyline that is between two GPS points in ModelBuilder. The line segment is created by enabling a user to define his/hers begin end point, and then using the ...
2
votes
0answers
60 views

Create filter expression by selected elements?

Is it possible to automatically create a filter expression for the Query Builder by selected elements?
1
vote
1answer
63 views

Interactively selecting polygon in ArcMap and passing selected feature to ArcPy?

I currently have a Python 2.7 script that takes a hard-coded select by attribute from ArcMap 10.3. arcpy.SelectLayerByAttribute_management("SoilLandscapePolygons_Layer", "NEW_SELECTION", "POLY_ID = ...
1
vote
0answers
45 views

Selecting only coinciding points

I have a lot of points in the same layer. Many of these are coinciding. I only want the points that coincide slected or the points that don't coincide (then I can just reverse the selection). This is ...
1
vote
0answers
27 views

Automatically select a feature from another layer based on shared attribute in QGIS [duplicate]

I have two shapefiles, A (polygons) and B (points), and I need to select all features from shapefile B that have the same attribute (for example, "Name") as shapefile A, and I need to do this ...
2
votes
2answers
47 views

Selecting features of a shapefile using attributes of another shapefile

A newbie here trying to learn QGIS for work. How can I select specific features of a polyline with the same values as the attributes of the buffer polygons I generated? I have a layer of polylines ...