Questions tagged [select-by-attribute]

To select data records according to logical criteria applied to their field values ("attributes")

41 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
37 views

Limit on Filter Query Stipulations?

I am novice mapper. I ran into some trouble with QGIS today when trying to add additional census tracts to a layer filter. The tract exists within the layer I'm filtering, but there seems to be a ...
3
votes
0answers
61 views

Select by attributes returning wrong records

I'm trying to select by attributes on a parcel shapefile with 555k+ records using the apn field and the statement is returning records that have completely different values. My initial statement was "...
2
votes
0answers
71 views

Exporting attribute data from vector data by selecting object in QGIS?

I'm using QGIS (2.4.0), and i need to export the attribute data of the object i select (shapefile) to another file ( Excel, txt,...it is yet to be determined depending on the solution). I know how it ...
2
votes
0answers
794 views

Shapefile From Excel Sheet Crash When Selected Spatialy or By Attributes

Using ArcGIS 10.2, I am receiving an Excel sheet, on a daily basis, which contains 105 columns(Fields) and includes has X and Y values. For whatever reason (which I cannot understand) all data types ...
2
votes
0answers
323 views

How to program select by attribute unique values using ArcGIS silverlight API?

I'd like to create a select by attribute window in my webGIS using silverlight api . this is like select by attribute in arcgis desktop . i create select layer combobox ( cbolayers)and select fields ...
2
votes
0answers
295 views

Select a distinct attribute with maximum shape area

I am trying to manipulate a large dataset containing a lot of sliver polygons resulting from an overlay operations. (The eliminate tool is very time consuming to generalize them.) I identified the ...
1
vote
0answers
28 views

Creating a dataset from attributes in QGIS Graphical Modeler

I need to select just a field from a dataset to compose a model in QGIS 3.4 modeler. How could I extract this field from the main dataset while creating another one?. I've tried with Drop field(s) ...
1
vote
0answers
45 views

Cannot set input into parameter error on second iteration

On the second iteration of the loop starting line 7 I get the following error. Everything works as intended on the first iteration. Any ideas on why this is failing the second time around? Error: ...
1
vote
0answers
31 views

Executing Select Layer By Attribute in Python Add-in Toolbar (ArcMap)

I'm having trouble with the button class of my code: class OKButton(object): """Implementation for ok.button (Button)""" def __init__(self): self.enabled = True self.checked = False def ...
1
vote
0answers
26 views

Select by attributes ModelBuilder - text string partial values for parameter

I have a feature class of suburbs that I want to do a select by attribute on the Locality (=suburb names) field, passing a user input string parameter to selection expression. I have the query ...
1
vote
0answers
60 views

Select Feature Based on Iterate Row Value in ModelBuilder

I have a table showing commuting trips from home to work. home_id represents home and work_id represents work. Now I want to step through the trips table using Iterate Row Selection in ModelBuilder, ...
1
vote
0answers
30 views

QGis Python featurerequest with lists

I want to select some features and do some actions to this selected features. Something like if attribute in field a is = abc than do something. But the selection will not fit. As written in https://...
1
vote
0answers
146 views

Calculation of fastest path with in network analysis by qgis 3.0

I have a road network (with speed limit) and different points connected to the roads. I would like to measure the distance between several points along the roads. Basically I want to do shortest path ...
1
vote
0answers
55 views

Is there a better way to use the operator to select a group in an expression in Select by Attribute?

Is there a better method to do a group like in a row or in colum that you want to select from in using the Select by Attribute? I have a point shapefile that I have has photo index. The field has all ...
1
vote
0answers
38 views

Pyscripter crashes with EOFError timed out

I am not sure whether someone ran into similar problem. I've been using PyScripter with Arcpy for the past two years and I have been happy with it most of the time. Yesterday I ran into a kind of ...
1
vote
0answers
36 views

Model Builder - Selections Add Up at the End

I am creating a model so that I can help colleagues visualize the workflow I used on a problem. My task was find all manholes in a specific area that connect to pipes >= 36". Simple enough, I did ...
1
vote
0answers
628 views

Select by Attributes iteration in ArcGIS ModelBuilder?

Trying to select all points by location that fall within a polygon select by attribute from the selected by location using an expression. so far it works fine .. I have a list of values - I need ...
1
vote
0answers
103 views

In QGIS import/update multiple layers from single spreadsheet

I have a spreadsheet I regularly update with new data. It contains X, Y and several column pairs. How does one assign in one operation information from the pairs (and associated X,Y) to their ...
1
vote
0answers
42 views

Select by location from multiple files and extract to shp with ModelBuilder?

I need to select data by location from multiple files and then to extract to separate shapefiles. I tried to implement this process using ModelBuilder through workspace iterator. However, the tool "...
1
vote
0answers
102 views

Identifying rasters with specific attribute value that intersect polygon using ArcGIS for Desktop?

I have numerous raster files that each contain an attribute field "VALUE" that can take on the values 0 or 1. How can I identify rasters that have any of their "VALUE=1" cells intersecting a focal ...
1
vote
0answers
254 views

How does getLegendGraphic, from GeoServer, handle attribute-based styles?

I have a layer with a color attribute and I write an SLD with a fill color like this: <sld:PolygonSymbolizer> <sld:Fill> <sld:CssParameter name="fill"> <...
1
vote
0answers
64 views

Querying on Household Income ranges in a dataset

I've recently been assigned a project to create an ArcGIS database to hold responses from a survey which will be used to perform analysis on the data. One column requires me to enter a dollar-range ...
1
vote
0answers
349 views

Output extent environment is not respected by Select Layer By Attribute (ArcGIS 10.2)

I cannot get the arcpy.env.extent working for Select Layer By Attribute GP tool. I can verify that I get various values for coordinates when I have panned to various areas on the map. Copy Features GP ...
1
vote
0answers
148 views

select remove layers not working second time

http://www.youtube.com/watch?v=qxVO0tFdiuA&feature i captured video. You can watch. Now i explain my problem. Firstly, when i create popup and in popup menu when i call function and select ...
0
votes
1answer
42 views

For loop with SearchCursor stops after first iteration

I'm trying to iteratively select and export a layer using da.SearchCursor, but the loop stops after the first iteration. Here is the code: arcpy.env.workspace = ScratchGDB # infc= "PA" field = '...
0
votes
0answers
26 views

SelectLayerByAttribute_management not selecting anything

I've read through most of the other similar questions and nothing so far has addressed my issue; most are about syntax. I'm trying to select by attribute from a Feature Layer. But every time, Arc ...
0
votes
0answers
19 views

Selecting Polygons of one layer with information from table using ArcGIS Desktop?

I have two 2 datasets: A shapefile with many polygons. They all have an ID. A table (.csv) that has one column with IDs. I need to select all Polygons in 1) that are mentioned in the column of ...
0
votes
0answers
33 views

Invalid expression in SelectLayerByAttribute?

I am coping with a shapefile and I want to select some rows if the values in one column are in a Python list. The following gives the code I write: tpu_involved = list(set(dataframe['SmallTPU'])) ...
0
votes
0answers
29 views

Iterating through values in Attribute field and performing selection using ArcPy?

I am using ArcGis Pro 2.4 python window. I have seen suggestions of using "SearchCursor" but am unclear how to utilize this tool in the Where-Clause in my SQL selection statement to select by ...
0
votes
1answer
44 views

How to Select Attributes from a Selection of Attributes

I have a land-cover map for an area in which I want to identify certain attributes that fall within a category. I want to select the shapes that represent wetlands that are in a grassland area. To do ...
0
votes
0answers
103 views

Why is internal memory not overwritten?

I have the following code in Python for ArcMap to first select a property polygon and then with this selection to intersect the layer which contains lines (sewers) (which pass through or are within ...
0
votes
1answer
45 views

Trying to use a SelectByAttribute_mangement after I made the XY Event layer

I imported a CSV file using the MakeXYEventLayer_management and trying to use the SelectlayerByAttribute_management function, but I am getting error message saying on "Object ID(OID)" is present.. Is ...
0
votes
1answer
39 views

SQL wildcard for Field Name?

I'm wondering if there's anyway to use a wildcard character in a field name. Like using ["Species_%" = 'Hemlock'] instead of ["Species_1" = 'Hemlock' OR "Species_2" = 'Hemlock' ...]. I tried the way ...
0
votes
0answers
40 views

Selecting layer by attribute in Python Toolbox of ArcPy?

I have this code where te input parameters are a shapefile [param0] and a string list [param1]. The second parameter is a list because I want that user select it. class Tool(object): def __init__(...
0
votes
0answers
27 views

Selecting values with date-format by using SelectLayerByAttribute_management with input Parameter

I am working on a Tool which selects records depending on the input value. Works fine, till I want to select date-records. I used def buildWhereClause(self, table, field, value): # Add DBMS-...
0
votes
1answer
52 views

Using input parameters to select layer by attribute

I am trying to create a Python-Toolbox with following Tool: inputFeature: A User has to load a Feature inputField: Then he has to to select a field from the Input Feature inputValue: At the end ...
0
votes
0answers
72 views

Selecting Points by their Spatial Location to an Attribute of a Layer

I have a large point layer of addresses within a district. Each address point has a field called "Street External Key [SEK]" which is tied (meaning identical to) the corresponding "Street External Key ...
0
votes
0answers
37 views

Can arcpy let the user enter a query expression for select layer by attribute?

I have written something like this: inFc = sys.argv[1] FLayer = sys.argv[2] FValue = sys.argv[3] arcpy.MakeFeatureLayer_management(inFc, FLayer) #feature layer created arcpy....
0
votes
0answers
80 views

Formating a query in ArcPy- why the error?

I have the following Select Layer By Attribute statement throwing a 000358 invalid expression error using Python with ArcGIS 10.4. The input feature layer is valid because I can select features using ...
0
votes
0answers
486 views

Clear selection - argument as a layer name or layer object?

I am writing a script tool that takes multiple layers, selects every item from each layer, zooms to it and exports the image. After the last row in layer, the selection is cleared and new layer comes ...
-1
votes
1answer
65 views

Finding and labeling intersections between polygons on a shapefile

I have two shapefiles-- one is labeled islands, the other is unlabeled parcels of land on some of the islands. My issue is that I need to label the islands that have parcels of land. My instinct is to ...