Questions tagged [select]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
31 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
34 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 ...
2
votes
1answer
63 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
28 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
50 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
26 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
30 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 (...
1
vote
1answer
41 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
136 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
61 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
23 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
75 views

How to select 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' ...
0
votes
0answers
45 views

Selecting polygons based on their shape

I have a polygon shapefile consisting of a lot of irregular shapes. I would like to select longer shape polygons like the one inside the red circle in the image. Is there any tool or algorithm which ...
1
vote
0answers
40 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
50 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
127 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
73 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
89 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
87 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
45 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
47 views

How do I interactively select a polygon in ArcMap 10.3 and pass the selected feature to a Python script

I currently have a Python 2.7 script that takes a hard-coded select by attribute arcpy.SelectLayerByAttribute_management("SoilLandscapePolygons_Layer", "NEW_SELECTION", "POLY_ID = 25984) that then ...
1
vote
0answers
38 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
44 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
38 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
57 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
130 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
42 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
212 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
53 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
46 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
55 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
209 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?
0
votes
1answer
76 views

Select_analysis in ArcPy gives ERROR 000358?

Trying to learn how to use Select_analysis but the queries cause the ERROR 000358: Invalid expression. Piece of code: arcpy.Select_analysis(in_features='test1', out_feature_class=...
3
votes
1answer
166 views

Select only lines that touch both sides of polygon - PostGIS

I want to select lines that only touch both sides of a polygon. Is there a function in postgis that can do this? See image below. I only want to select lines from the circle on the left where the line ...
1
vote
1answer
137 views

Random selection of polygons in ArcMap? [duplicate]

I have thousands of buildings blocks in ArcGIS. I want to select a half of this blocks randomly. How can I do it?
0
votes
1answer
45 views

Syntax error in Where Clause using .format in arcpy.Select_analysis

I'm having a little trouble understanding the syntax for a Where Clause; e.g., for use in arcpy.Select_analysis(inSHP, clipSHP, where). input is polygon shapefile; Zone_ID field is short integer ...
3
votes
1answer
100 views

Select features in a polygon that covered the most by features of another polygon layer QGIS

I am working in QGIS. I have 2 polygon layers, One layer is the parcel polygons layer for a county called "Parcel" The other layer is the building footprints polygon layer for the same county called "...
6
votes
2answers
400 views

Selecting connected lines between start and end point in QGIS?

Is there a method in QGIS to select all connected lines that are between a start and end feature (point or selected lines)? I imagine a workflow going something like this: Choose the starting line ...
2
votes
1answer
238 views

In Vertex Tool (QGIS 3.2.2) How can I select the next (or previous) vertex?

I want to correct a duplicate vertex by deleting one. However, if I use click and drag, I select both and delete both. To select only one, I could select the previous (or next) vertex and navigate ...
1
vote
0answers
36 views

ArcMap 10.3 Attribute Table Showing Wrong Information?

I have some parcel data with addresses that I am trying to export as a selection. Every time I open the attribute table with a new selection of parcels, the information is incorrect after a certain ...
5
votes
1answer
157 views

Select point by number of overlapping features

I have this polygon layer converted to lines, and had the line nodes extracted using Extract nodes. The resulting point layer has several overlapping points because of common borders with adjacent ...
1
vote
1answer
39 views

Select/export point features where the value change in two fields within the layer is less than a 5% change

I have a point layer that has two fields representing the distance (in feet) of a point feature to coastline (old distance vs. new distance). I want to crosscheck both fields to see the accuracy of my ...
1
vote
1answer
101 views

Randomly selecting single point from within multiple fishnet grid-squares?

Using ArcGIS, I have a large data set of occurrence data many of which are in similar places. I have created a fishnet around the total area and want to select a single random point from within each ...
0
votes
1answer
47 views

Using If Then Else statement against selected records in ArcPy?

I am working on a Python script that will count how many selected features there are and if there are it will make a feature layer from them. If the script runs and finds there are 0 selected records ...