Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [select]

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

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
25 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
17 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
26 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
27 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
71 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
57 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
55 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
41 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
38 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
48 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
116 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
60 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
51 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
64 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
39 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
44 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
29 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
50 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
118 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
34 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
165 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
41 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
43 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
49 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
27 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
118 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
68 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
149 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
81 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
42 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
95 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 "...
7
votes
2answers
355 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
216 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
131 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
34 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
89 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
44 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 ...
0
votes
1answer
33 views

Calculating area of .shp polygon that intersects with feature of another shapefile

I am using ArcMap 10.6. I created a polygon (red). Some of it overlaps with a feature that delineates a city (green). The brown is where they overlap. In case it makes a difference that the shapefiles ...
4
votes
1answer
121 views

Selecting an amount of features that together sum up to a certain value?

I am looking for a way in QGIS to randomly select features within my shapefile. The selected features together need to sum up to more or less 2000m2. So, it is not selecting 10% of the features, but ...
0
votes
1answer
45 views

Using where clause to select minimum value in Select_analysis tool of ArcPy? [closed]

I am trying to use the Select_analysis tool to select the minimum value from the input geodatabase feature class and export that to a new feature class via a where clause. I think I'm getting tripped ...
2
votes
1answer
42 views

Problems filtering using multiple parenthetical expressions in QGIS 2.18 OSX Yosemite

I'm not a QGIS power user but I've been using it for simple things for quite a while. I just updated from QGIS 2.14 to 2.18 yesterday in order to be able to edit field names. I'm now having some ...