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.

1
vote
0answers
15 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
22 views

Create filter expression by selected elements?

Is it possible to automatically create a filter expression for the Query Builder by selected elements?
0
votes
1answer
36 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
34 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
20 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
43 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
28 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
27 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
38 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
21 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
103 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
32 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
19 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
117 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
33 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
40 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
47 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
69 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
53 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
121 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
38 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
40 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
85 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
288 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
154 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
33 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
107 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
29 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
79 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
35 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
32 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
117 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
39 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
39 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 ...
1
vote
1answer
411 views

How to make the selection transparent in QGIS 3.0?

Despite setting the layer or the symbology of the features to semi-transparent, when performing a selection, the features become solid. I want to edit those features based on properties of the ...
1
vote
3answers
138 views

Selecting by attributes in ArcMap?

Using ArcMap 10.6 I am trying to 'select by attribute' data that is separated by a comma. For example: passive, football, soccer or passive, playground and so on with the objective to calculate the ...
1
vote
1answer
32 views

Select Entrys by Time

I want to select entries of my GPS-Point data only recorded from 7 a.m. to 7 p.m. and close out all others. Right now, its in a String format (00:00:06). I tried "time": >= '07:00:00' and "time": &...
1
vote
1answer
207 views

Randomly selecting points within polygons in ArcGIS Desktop? [duplicate]

I have 131 polygons (point buffers) and need to randomly select a point within each buffer. Seems like it should be easy but can't find any solutions online. Running 10.5
0
votes
1answer
242 views

Using ArcPy to check for duplicates AND Latest date? [closed]

I am stumped (and new to Python). I have a feature class with a field that contains a centroid in MGRS. That field is called MGRS. I also have another field called ED_Date that is the production date ...
0
votes
0answers
43 views

Selecting .las points based on intersection with polygon in ArcGis

I'm trying to select all .las points that fall within a selected polygon. So basically like select by location, but with a .las file and a feature layer file instead of two feature layer files. I ...
0
votes
1answer
329 views

Selecting Polygon Feature using ArcGIS API for JavaScript?

I used ArcGIS JavaScript API 3.25 for developing. I want to select polygons within 1km radius. so I used a sample code that esri provides. But it works only for point features. I want to use that ...
3
votes
3answers
167 views

Deleting selected rows in ArcPy?

I am new to ArcPy and I am trying to write a code to select specific rows from a shapefile. I wrote this code, which gives back: Parsing error SyntaxError: invalid syntax (line 3) Any suggestions ...
3
votes
1answer
113 views

Cannot write a subset of features back to the source Geopackage or File Geodatabase

At QGIS 2.18.16, I have a Geopackage point layer with a selection subset. I need to write the selected records to the same Geopackage as a new layer, with a new name. When I attempt to Save As... ...
0
votes
0answers
42 views

ArcMap - wrong/no features selected when using select tools

All of a sudden my features aren't selecting properly when using the "select by rectangle" tool. Previously, I could click on an individual point feature and that feature would be selected. If I ...
0
votes
1answer
61 views

Automating select polygons by distance within same layer using QGIS?

I have say, 6,000 polygons roughly 25 acres each, all touching one another, basically a grid but with irregular shapes. Using QGIS, how do I start with one shape then in an automated process, select ...
0
votes
1answer
31 views

Selecting or identifying coastal census tract using ArcMap? [closed]

I have census tract level population data for all the U.S. I want to compare the population of coastal census tract (those adjacent to the ocean) and non-coastal census tract. What tool should I use ...
1
vote
0answers
73 views

Select by Map Content

I have a QGIS project of species presence/absence in European countries (TDWG data). That's 84 species against 63 countries. For each species I've used the exact same map layer, used Categorize to ...
3
votes
0answers
104 views

Selecting features from one layer into new layer based on IDs using PyQGIS? [closed]

I'm completely new to PYQGIS. I'm pretty handy with MapBasic in MapInfo and was wondering how I would 'translate' this command from SQL select into Python (hope that makes sense) Essentially, I have ...
0
votes
2answers
105 views

Selecting points from QGIS when button is greyed out?

I am new to QGIS. I added mailing addresses from arcgis map server url https://gis.nccde.org/agsserver/rest/services/BaseMaps/Addresses/MapServer. I want to select some points here and move them to a ...