Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [select]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
19 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
25 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
46 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
22 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
29 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
101 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
60 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
27 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
39 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
42 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
24 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
39 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
39 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
39 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
185 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
30 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
59 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
28 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
44 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
61 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
362 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
67 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
24 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
117 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
44 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
53 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
139 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
102 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
132 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
124 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
58 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
54 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
41 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
24 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
45 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 ...
1
vote
0answers
39 views

Using ArcPy to select polygons one by one and export them? [closed]

I want to select polygons in a (double field type) and export them, and I keep getting this error: ExecuteError: ERROR 000358: Invalid expression "dobule" = '1' Failed to execute (Select). This ...
1
vote
0answers
30 views

What syntax should I use in my SQL query in the select statement in ArcMap if I want to use two In-Line substitution variables

I am trying to iterate though features in a shapefile. There are two columns I need to iterate through. First, I need to iterate through company names, and then using another iterator in a separate ...
0
votes
0answers
64 views

Select Analysis Invalid Expression

I am attempting to select nulls from an in_memory feature layer using Arcpy's Select_analysis. Code example below, as well as, various iterations of attempts to alter the SQL query with no success. ...
0
votes
0answers
22 views

Incorrect SQL syntax [duplicate]

I'm trying to execute the following code and it throws me an error. value=u'L_PARCEL_A' where_clause="'LAYER'='{0}'".format(str(value)) arcpy.Select_analysis("input_lu1",stat_feature,where_clause) ...
-1
votes
2answers
202 views

How to select a point from existing points within each grid in QGIS

How to select a point from existing points within each grid cell in QGIS? Each grid cell has multiple points and these points have 3 possible values for the "Status" attribute (Status: A, B or C). ...
2
votes
0answers
58 views

How to export a single feature (line) from multiple layers and export to individual layers?

I have multiple vector layers representing a time series. Each layer contains many lines each. I want to select a single specific line from each of these these layers and save it to another layer. ...
-1
votes
1answer
20 views

Selecting features in layer by attribute in field and exporting them in another shapefile using ModelBuilder?

I need to export some features inside a shapefile according to an attribute (e.g. field_value = 20). I know how to do it without ModelBuilder. I need it to do it in ModelBuilder because a have many ...
1
vote
2answers
278 views

Selecting/tracing part of line feature using QGIS?

I have a shapefile which comprises a number of lines, each representing a bus route. I'm wanting to create a new bus route which is the same as an existing line to a certain point, but then branches ...
0
votes
1answer
73 views

Google Earth Engine -hourly timestep

Does anybody know how to select 3-hourly time steps in a dataset on Google Earth Engine? Here is what I have tried // A function to compute CF_solar for every time step at which irradiation and ...
1
vote
1answer
53 views

Run processing only in layers with selection

First of all, I am really begginer with PyQGis... I am trying to run a random point algorithm in different vector layers of a folder. But I dont want to do it for every polygon, only for selected ...
1
vote
0answers
58 views

QGIS Select Features by Expression

I am trying to figure out what the expression is to find all the roads in a TIGER street layer for a county that are the same as roads in a small selection of roads. The small selection of roads are ...
0
votes
1answer
28 views

Select by attributes appears to not work correctly

This table: ca ca1 12333 123330 doing this query in Select_analysis: in the where parameter. ca = 'substring(ca1,1,5)' gives empty feature layer and this: ca <> 'substring(ca1,1,5)' ...
0
votes
1answer
340 views

Using %Name% variable dynamically with selection tool in ArcGIS ModelBuilder?

In ArcGIS ModelBuilder is it possible to use a %Name% field value from iterated features in a query and, if so, what syntax should I use?