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 ...
