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

learn more… | top users | synonyms

1
vote
2answers
116 views

Select feature one by one not working in pyQGIS?

I have used following code for selecting the features one by one. but when i run the script it is just selecting last feature and zoom it. I want to select each feature and zoom it. def ...
1
vote
1answer
97 views

Deleting selected features with ArcPy?

I am having trouble deleting the features I have selected using 'arcpy.SelectLayerByLocation_management' tool. To use the select layer by location tool, you much pass in a .lyr file. My script ...
0
votes
0answers
33 views

Looping all features of cursor onto SQL Server feature class?

It might be me but I've been experiencing something weird. (I actually tried what suggested in this thread Arcpy MakeFeatureLayer won't loop with no luck) What I'm trying to accomplish is to use ...
2
votes
2answers
115 views

Selecting Polygons that have certain raster data within them

I am using a raster layer with either 1 or 0 in each cell. On top of this layer, I have a European countries shape file. The countries that contain a '1 cell' in the raster beneath are the Countries I ...
28
votes
3answers
2k views

Is there a “Select by Attributes” plugin/widget for ArcGIS Server JS API?

I'm hoping to find some existing code which emulates the "Select by Attributes" dialog in ArcMap, within the ArcGIS Server JavaScript API. Writing a hard-coded QueryTask is easy - I'm looking for ...
0
votes
1answer
157 views

Arc Map 10.1 Identify tool

I'm trying to identify features from multiple layers. For example, I have many locations around a river (within a 100 m buffer) which I would like to identify, but instead of having to draw rectangles ...
7
votes
1answer
239 views

How to select features based on multiple values in graphical modeler?

I'm trying to create a basic model using QGIS, the QGIS graphical modeler and the sextante toolbar. In part of the model, I need to select features based upon multiple attribute values (for example - ...
3
votes
3answers
1k views

How to select features with NULL Geometry from Shapefiles?

I have been given a Shapefile that contains records with NULL geometry, along with records with non-NULL geometry. This situation appears to cause problems in QGIS (1.8 and 2.0) when editing the ...
1
vote
2answers
100 views

List Attribute values selected by location

I would like to get a list of road features that intersect every county in a state and output it as CSV or Excel. Ex: county A intersect the Road Names a b c county B intersect the Road Names e ...
0
votes
0answers
20 views

How Show shp Selected [duplicate]

I need help with code to know if a SHP a MXD this selected or not. I have the following code which only shows me all shp'sy layers are in the layer , I need a list if there is a selecionado shp, ...
1
vote
1answer
24 views

QGIS 2.8 Change Colour of Selected features [duplicate]

How can I change the colour of the selected features in QGIS. The light yellow is not easy to see.
2
votes
2answers
102 views

QGIS Select double feature by attributes

There is this point shapefile in QGIS (2.12). There is one column with the street name and one with the housenumber. Is it possible to select all features that have the same street name and ...
3
votes
2answers
78 views

Copy/convert selection into filter/query builder of QGIS?

Can anyone tell me if it is possible (and how) to convert or copy a selection on a layer (that has not been created through "select by expression", but instead by irregular selections from a canvas, ...
14
votes
3answers
12k views

Including variable in where clause of arcpy.Select_analysis()?

I am trying to loop through a shapefile, selecting each feature in turn and copying it to a temporary shapefile to by included in a union analysis. I'm using a cursor to find the ID name for each ...
0
votes
0answers
10 views

Using predefined variables in whereclause? [duplicate]

Can't seem to figure out how to use variables for an SQL whereclause in python. e.g. want to select_analysis(layer, "new sel", field = attribute) with field and attribute being predefined by user ...
2
votes
1answer
82 views

Attribute Table Window loses highlighted selection after Addin is Opened

I'm so new to GIS that this question might seem dumb to a lot of GIS Developers. I have taken over a project that is an AddIn for an ArcGIS Desktop app. C# VS 2010 project. I can get the Selected ...
1
vote
2answers
76 views

Variable Expression In ArcGIS

I am creating many models doing many tasks. Basically, the first model will join 2 tables and the steps are as follow: make table view for each table, then add join for, then it will copy the rows for ...
2
votes
1answer
3k views

Activating and deactivating of button control not working properly

I have got two buttons, one for editing purposes and one just to see all the information related to the polygon I selected. Also I added these two buttons on my panel using OpenLayers control. I am ...
3
votes
2answers
3k views

Selecting features through ArcPy gives Assertion Error?

I would like to achieve the following functionality through arcpy: Querying an existing baselayer on time and create a new layer Apply symbology from an existing layer and add the new layer to the ...
3
votes
1answer
67 views

In ArcGIS 10.x, how do I select features of a point shapefile whose z values are above or below the elevations in a DEM?

I have a multi-point shapefile representing earthquake hypocenters (containing depth values) and I have a DEM raster representing an underground surface (the top of the PreCambrian basement). I want ...
2
votes
3answers
451 views

javascript function to search all OpenLayers vector features covering a pixel

I have an OpenLayers map that draws features in a vector layer. The features are selectable and have a popup on select. Unfortunately in a lot of cases the features overlap so it can be impossible to ...
3
votes
3answers
199 views

How can I select “ultimate perimeter” from a group of connected lines?

I have a number of drawings which I converted into geodatabase feature classes. Most drawings are composed or connected 3D polylines from which I want to construct TIN surfaces and multipatch ...
1
vote
0answers
39 views

Is there a way to select polygons by geometry (right angle)? [closed]

Is there a way to select polygons by geometry? I need to find a way to detect all the polygons that have a right angle, but I can't find a tool that can do that. I'm using QGIS 2.10.1 and ArcGIS ...
2
votes
2answers
233 views

Selecting features within polygon from another layer using R or Python?

For Selecting features within polygon from another layer using QGIS? the solution was to: use the "Vector->Research tools->Select by Location" However, I would like to know how to do the same ...
3
votes
1answer
781 views

Select Features returns There was error executing query in ArcMap when using OLE DB connection?

I have a spatial enabled OLE DB Provider corresponding to OGIS simple feature specification for OLE/COM revision 1.1 I can add spatial data as ArcMap layers successfully using this provider and by ...
0
votes
4answers
180 views

arcpy interate row, in a python script? SQL Select expression not working

I am creating a python script where I am trying to iterate over point feature class. I want to create seperate Feature classes from each individual day. So select daynumber and then export it to a new ...
1
vote
2answers
85 views

Switch selection of specific polygon

I'm using ArcGIS 10 desktop version. I have a number of polygons, let's say 300, in a layer. Each polygon contains information of schools, ranging from 100 to 250 points, in a separate point layer. ...
1
vote
2answers
297 views

How to pass only selected features in python toolbox

I have a feature class in a file geodatabase. I want to select features from the feature class and export their attribute to an excel sheet. I need a python tool in ArcGIS which does this. My problem ...
1
vote
1answer
71 views

Is there any way to select only the layer of which the features have been selected?

Is there any way to select only the layer of which the features have been selected? That is, if I have selected some roads then I want only the road layer to be selected.
1
vote
1answer
99 views

Communicate relation between two table

At this time, I'm able to create a relation (1:M) between two table or geometries. After, I user Identify tool to exploit the relation. It is only possible to use this feature when your Identify tool ...
0
votes
0answers
50 views

how I can get raster calculator select files with similar names?

The idea is to select raster files with parts of similar name, for example: Filenames (in between many others raster with other names, but in the same folder): 28feb11evs 28feb11evv 28feb11pr ...
0
votes
3answers
174 views

Show selected features on all zoom levels in ArcMap?

Is there a way to display selected features no matter the scale level in ArcMap 10.3? When I select by attribute and then zoom to selection I often just get a blank map since the layer is set not to ...
2
votes
2answers
812 views

Zoom to Selected feature, without using 'current' in ArcPy?

I am wondering if it is possible to build a zoom to geoprocessing service without using 'current' for the mxd variable in pyhton. Using 'current' my tool works in arcmap, but not in my gp service. ...
1
vote
2answers
86 views

Selecting nearest 300 buildings (polygons/centroids) from list of points using ArcGIS for Desktop?

I have been trying to look for an easy/quick way to select a certain amount of polygons (layer 1) from a 90 points shapefile (layer 2). The idea is to identify the nearest 300 buildings from each of ...
2
votes
1answer
81 views

QGIS 2.8+: How can layer.selectedFeatures() return an empty list while layer.selectedFeatureCount() returns the correct number of selected features?

I noticed some changes since qgis 2.8 but can't find any information about it. Let's say I have a very simple point layer loaded in QGIS, from a spatialite table. From this layer I select some points ...
1
vote
1answer
339 views

Label only selected feature using QGIS?

Is it possible to make an expression that labels only the selected feature in QGIS? I tried it with this expression in the label tab: attribute( $currentfeature, 'LAENGE' ) But it labels all and not ...
1
vote
2answers
85 views

Select points located within Multi Ring Buffer

I have two point datasets, 1 showing the location of road accidents, the other showing the location of traffic intersections. I have created a Multi Ring Buffer at 25m intervals around the traffic ...
1
vote
1answer
332 views

How to SELECT all points within a GeoJSON polygon in PostGIS

I have a GeoJSON polygon, and a table with lots of points. I want to SELECT all points that are within an arbitrary GeoJSON polygon. How can I do that with PostGIS SQL?
2
votes
1answer
99 views

How can I do a subquery inside a subquery in PostGIS?

I need to add a subquery to a working function. Instead of select * from table, I'd like to select * from (select * from table where height>1500) as sub, something that works in other functions I ...
0
votes
0answers
89 views

Select polygon feature(s) in ArcMap and pass this selection into Python Addin

Does anyone has an Pyhton example to select polygon feature (or features) in ArcMap and pass this selection into a Python Addin? The selection made by mouse will be better.
2
votes
2answers
3k views

Splitting single shapefile into many to use as geoprocessing extents in ModelBuilder?

I am trying to do the following things using ArcGIS model builder. select by expression to output feature class. use output feature class as spatial extent raster to point The main goal is to ...
3
votes
1answer
227 views

Getting Annotation selection using ArcObjects?

I have annotations stored in mxd document, when I select some annotation, I tried to get the selection through graphics selection, so I always get the rectangle of the dataframe (because I'm working ...
3
votes
2answers
3k views

How to select features in ArcGIS based on their relation to other features within same layer?

I want to select all the features in my Waterlines layer that share a line segment with other features in the same layer. I've done a complicated search cursor iteration in python that takes a couple ...
2
votes
1answer
132 views

Joining data of two different datasets from varying distances and integrating into one dataset in ArcGIS

I have a pointfile of some 200 electrical boxes throughout the county. While the electrical boxes are "mapped", they are done so by using township range section data, so there actual location is not ...
1
vote
2answers
260 views

How to select features containing specific text string using an expression in QGIS

I need to style a survey parcel polygon shapefile, based on whether the polygon is a mineral claim or not. Unfortunately, the only information on whether a polygon is a mineral claim or not is ...
4
votes
1answer
953 views

Selecting several disseminate features with ArcGIS API for JavaScript?

I have a cadastral map similar to this one from an ArcGIS Javascript API example: Cadastral map What I would like to do is selecting several parcels clicking on them and show the information related ...
1
vote
1answer
73 views

Working w/ Shapefiles Containing 50,000 to 300,000 Features

I work daily with shapefiles that are quite large in number of features using ArcGIS. Sometimes I am able to perform operations (joins, selections, exports, etc) on these shapefiles (though they do ...
0
votes
1answer
170 views

Python Script to Select records based on user input

I am running Arc 10.3 in a versioned environment. I am attempting to write a simple code that will select service records coming from Oracle CRM to a separate feature class containing only records ...
0
votes
0answers
104 views

Performing multiple selection in ModelBuilder?

I want to create several layers in gdb selected by field value from xls sheet. I'm tring do it in ModelBuilder, but I can't past through the SQL query in selection part. I don't know how to make it ...
0
votes
1answer
155 views

ArcObjects WPF Select layer in legend

Can I select a layer, by code, in the TOC/legend of a map in a WPF ArcGIS Runtime application? I develope in ArcGIS Runtime SDK 10.2.2 for .Net in C#.