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

learn more… | top users | synonyms

1
vote
1answer
73 views

SQL query within Select tool in ArcGIS model going very slow

I have been working on finding the shortest routes from a series of residential blocks (a shapefile with polygon centroids) to a a number of recreational areas. I have a total of 9 resulting OD cost ...
1
vote
0answers
76 views

How to relate feature class and table in ModelBuilder?

I am beginner in ModelBuilder, so I have some trouble with it. I have feature class, which contains forest stands (polygons) and table with data about age of their etages. For example, one forest ...
0
votes
1answer
45 views

Postgis - get all records (lat, Log) that contain a polygon.

I have a polygon and want to get all the points inside from a georeference table. How is the sql sentence? For example. obtain all the lat/long records that are inside the department ZZ polygon. ...
1
vote
1answer
51 views

How to select from selection with PyQGIS?

The expression box has a handy "select from selection" button. Is there a way to emulate this with python? I have the basic expressions down, but can't find a way to do this.
2
votes
1answer
541 views

Select top 5 most items in a geodatabase

I'd like to know what is the best way to select the 5 most expensive items (in terms of actual monetary value) in my geodatabase where i have a price field. Prices are not necessarily ordered but can ...
2
votes
1answer
57 views

Odd performance of PostGIS Select Query with ST_AsText

I have this query: select ST_AsText(geo) as wkt, city, street_number, street_name, street_type, street_direction, street_unit from parcels_union order by id ...
0
votes
1answer
54 views

Creating Layer for Selected Features, then Moving it using ArcGIS for Desktop?

I have a frustrating problem with ArcGis 10.1. I rarely use this so don't really understand what is wrong. In an edit session I select a polygon. I would like to 'Create Layer for Selected Features'. ...
2
votes
1answer
272 views

How to select features using an expression with pyqgis?

How can I select features with pyqgis using an expression? I tried to use an QgsExpression but the select method doesn't take it: exp = QgsExpression("'ogc_fid' = 482") cLayer = ...
1
vote
2answers
41 views

Select feature based on both its own attributes and another feature's attributes

I have two points within a polygon, each representing a specific event with a date (listed as 120101 and 120719). The polygon itself represent an event for an extended time period (start: 120626 and ...
0
votes
2answers
59 views

How to select multiple text?

I am using ArcGIS 10.1. Is there a way to select on the typed text on the screen? I have standard text not assoicated with anything that I would like to delete. Is there anyway to select all?
0
votes
0answers
36 views

Trouble with select by attribute on ArcSDE

I am having trouble with some extracts on a csv table on ArcSDE. Verifying my expression results in the following pop up: "The expression was verified successfully but no records were returned."
2
votes
2answers
81 views

QGIS keyboard shortcut to launch a 'Select by expression' query

I can't find if it is possible to launch a 'Select by expression' query (not to open the dialog) with a keyboard shortcut. I can't find this option in the Settings > Configure shortcuts list... If ...
2
votes
1answer
208 views

How to zoom to selected feature with QGIS Python Console

I want to select a feature by ID and zoom to it. I tried the following but the canvas doesn't change. Any ideas? canvas = qgis.utils.iface.mapCanvas() cLayer = canvas.currentLayer() cLayer.select(51) ...
5
votes
6answers
584 views

How to divide a feature class into ranges?

I have a shapefile consisting of around 4000 polygons. The polygons are created from buffering around a similar number of islands somewhere in the Norwegian archipelago. Due to an error in the ...
1
vote
1answer
427 views

Openlayers SelectControl add multiple Layers

Heres my code to add an SelectControl with Popup for an existing layer add startup map.addLayer(window.markerLayer); window.markerLayer.events.on({ }); // Popup für Marker window.selectControl ...
1
vote
2answers
380 views

How to select island (donut hole) polygons witin the same polygon layer?

i have a dataset containing many polygons. In this dataset some polygons have other polygons (as a donut) inside of them. So those island polgons are contained by only one polygon but it originated ...
2
votes
1answer
149 views

How to query values from a list in Python?

I have a list like this... list = ['1','2','3','4'] how can I use arcpy.Select_analysis to select features that have the attributes in the list. qry = '"SECDIVNO" IN ' + str(tuple(list)) ...
9
votes
2answers
2k views

QGIS 2.4.0 How to display only selected features on map?

Not sure if this option ever existed, but the new QGIS version hides a lot of things somewhere else and this seems so simple that I'm kind of convinced it was possible to do this before. I have quite ...
0
votes
1answer
1k views

Get layer name by click on features OpenLayers3

I want to add selec interactions to my OL3 map. Adding two different select interactions like this is not working. Only the second one works. Like this: var select = new ...
1
vote
1answer
46 views

Automation of object selection to be printed in data driven page?

Is it possible to have the central object of each DDP to be automatically selected in order to be visually enhanced? The part of segment being the main cartographic object within the page, should ...
1
vote
3answers
1k views

How to select features of visible layers in QGIS

In QGIS 1.8 I used plugin "Select features of visible layers by rectangle" to know the layer that owns a visible feature. In QGIS 2.0.1 this plugin is no more available. I wonder if it is possible to ...
14
votes
4answers
4k views

Quickest way to select polygon by point in ArcGIS Desktop using ArcPy?

I keep thinking that I must be missing something, but there does not seem to be a tool in ArcGIS 10 to select features (in particular polygons) from a layer at a point (X,Y) location via ArcPy. The ...
1
vote
2answers
198 views

How to use an IF THEN statement in an sql Select expression?

I need to select the top 3 records from a table, but depending on an inline variable from an iteration, occasionally one of those top 3 records should not be selected and should be replaced by the top ...
0
votes
0answers
18 views

How can I keep selected the output feature elements from a toolbox?

I have a simple toolbox (ArcGIS 10.0). From some selected elements from one layer, the tool, create a new one. I want that all the elements inside this new layer keep selected at the end of the ...
2
votes
2answers
48 views

Using a selection tool will select everything

When I use the Selected Features tool and try to drag a box around a few small items it grabs everything. If i use the edit tool it will correctly select only features that are inside/intersect the ...
1
vote
1answer
65 views

Using Selection Sets with Python

I am trying to build a model that reads through about 30 different point feature classes and appends only the selected features to a new feature class. Some of the feature classes don't have any ...
2
votes
2answers
523 views

onSelect sometimes firing before onUnselect

I have a map that displays satellite coverage zones. Some of these coverages overlap. I am using the SelectFeature functionality to fire off onSelect and onUnselect events. However, when moving ...
1
vote
0answers
29 views

Data Transfer of a point on line using the anchor point

Can I a line feature, the anchor point touches a point feature transferred the field value, even when the point touches another line(s)? How does this work?
1
vote
1answer
272 views

ArcGIS wmslayer select feature android

I am using ArcGIS Runtime SDK for Android and it supports wmslayer but there is no sample or code for selection feature with using wmslayer. My app shows the map getting data from my wms server. Do ...
2
votes
1answer
362 views

vb.net ArcObjects is there a function the same as “Select Features by Polygon” of ArcMap's tool

I want to know whether there is a function provided by ArcObjects (vb.net) to realize the "Select Features by Polygon" on ArcMap (shown below). I am using VS 2012 (vb.net) and ArcObjects 10.2.2, ...
2
votes
1answer
61 views

Select same / select similar in ArcGIS

Can a "select similar" right click (two clicks total) like in AutoCad be created in ArcGIS as an addin or something python-related? It is listed on their "ideas" page here: arcgis ideasSelect ...
1
vote
0answers
13 views

Making point selection tool using ArcObjects with VBA? [duplicate]

I want to make a selection tool that I can use to select a feature point in ArcGIS for Desktop so I can combine it with a form that I just made to display the form after the feature selected. I use ...
3
votes
1answer
2k views

How to highlight on mouseover without wiping out select control

I am trying to highlight features of a vector layer as the mouse moves over them. I can make this work. I'm also trying to make the features selectable and have a popup box when they're clicked. this ...
1
vote
5answers
2k views

Deleting features (rows) from shapefile (attribute table) using ModelBuilder?

I run into a problem and can't figure out how to solve this one. I use the ModelBuilder and have a shapefile with loads of information. This information needs to be reduced. Therefore I want to ...
1
vote
1answer
219 views

How to transpose reclassified field values from one polygon shapefile to identical polygons of another shapefile?

I used vector output from modeling software as clip features for ecoregion input. I reclassified and dissolved the clipped layers into 3 subunits, and now would like to transpose those simplified ...
1
vote
1answer
86 views

How to show a selected polygon feature, using a single marker in its center

I've been asked to replicate a map where the selected polygon is shown with a red tick/check mark: I need to tell ArcMap to use this symbol when a polygon is selected, so that un-selecting the ...
1
vote
0answers
147 views

How to combine three data extraction functions into one button?

I am looking to simplify my code. As of right now I have some code that allows users to extract GIS data in three different ways: Extract by drawn extent Extract by extent of the a county Extract by ...
0
votes
2answers
130 views

How to set Merge output as Select Input in ModelBuilder?

I'm using ModelBuilder. I tried to take the Output from the Merge tool as Input to the Select tool. But it doesn't work. I'm trying to Merge 90 Shapefile lines into one. Then "Select" some features ...
2
votes
1answer
78 views

Finding Code in QGIS Select Features Toolset

Can anyone tell me in what directory the pre-installed Python scripts for the QGIS selection tools (i.e., Select by Point, Select by Polygon) are found? I am using on a Windows 7 installation of QGIS ...
1
vote
0answers
43 views

How to determine distances of points from closest line? (Mapinfo or QGIS) [duplicate]

I have a set of points and a set of lines. I'd like to know distances of the points from the closest line... answering the question "how many points are within 500m to 1000m of one of the lines, how ...
-1
votes
1answer
67 views

Esri ArcGIS 10 - using ArcPy to select buffer line by length

I created a buffer, then converted polygon to line (around a city block). I want to select the internal line. I'm thinking since there is no uniform way that ArcGIS labels the interior or exterior ...
3
votes
0answers
125 views

Programmatically selecting features by polygon

Expanding upon this post how could you use QGis to programmatically draw a selection polygon and select features within the polygon? I have been using QgsMapToolEmitPoint(self.canvas), to find and ...
1
vote
1answer
71 views

Openlayers active select control on layer prevents drag and zoom

I've build this web-map http://gimoya.bplaced.net/Openlayers/Trails/map.html with bike-trails (retrieved from a KML on my webserver), where several trails from a region are covered by a selectable ...
2
votes
2answers
254 views

How to populate fields for line segment with value from polygon to left and right of it?

I have a countywide roads dataset that is used by an emergency dispatch system. There are two fields, "Comm_RT" and "Comm_LT", that need to be populated by the name of the community polygon they ...
0
votes
1answer
40 views

Trouble Using Selection Expression in QGIS

I am trying to use the selection expression box to highlight counties by state FIPS. When I use the OR conditional all counties across the US get highlighted. So for example, STATEFIPS = 1 will ...
0
votes
1answer
170 views

Clip and ship by a queried layer extent and by user defined extent

I am trying add a functionality to the clip and ship script. I would also like the users to extract data by the extent of a queried feature layer. For instance, if County = "Alameda" then extract data ...
0
votes
1answer
2k views

JavaScript API - Query and Edit point from Feature Layer

I am attempting to recreate the ESRI example for attribute inspections (https://developers.arcgis.com/javascript/jssamples/ed_attribute_inspector.html). I am having an issue when I create my feature ...
1
vote
2answers
553 views

OpenLayers: WMS layer above select-controlled vector layer?

Is it possible to display an image layer (WMS or Image) above a vector layer with activated SelectFeature control in OpenLayers? The image layer (radar returns) contains only sparse, semi-transparent ...
2
votes
3answers
269 views

Select layer by attribute: return top 3 records

I have a feature class in a file geodatabase using ArcGIS 10.1. I want to create a model that selects the three features with the highest values in one field (Average Price). Basically I want my ...
0
votes
1answer
239 views

Copy selected features to another feature class

I had two polyline feture classes representing the same objects that I spatially joined together to reconsile/consolidate data about. At the time I was directed to remove some features from the ...