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

learn more… | top users | synonyms

0
votes
1answer
142 views

CartoDB layer selector - selecting data from 2 layers

I used the CartoDB layer selector example (http://cartodb.github.io/cartodb.js/examples/layer_selector.html) with my data. Works fine. Now, what I really want to do is to select data from 2 layers at ...
0
votes
2answers
278 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 ...
7
votes
1answer
6k views

How to select features within a polygon from another layer?

I'm using QGIS 1.8 with a PostGIS database and I have three postgis-layer in qgis a lines layer, a points layer and a polygon layer. What I'm trying to do is to select a polygon in the polygon layer ...
0
votes
0answers
23 views

Selecting polygons using another polygon? [duplicate]

Hi, How is the best way or fastest(if there is) of selecting polygons of a different shapefile using a polygon of another shapefile. exercise example: i want select all the light brown polygons ...
2
votes
1answer
38 views

“Select layer by location” tool - input feature layer Error

I am trying to use the "Select layer by location" tool, in Model Builder, ArcGis. This tools has 2 input files: "Input Feature Layer" and "Selecting Features". I cannot connect the "Input Feature ...
0
votes
1answer
76 views

Call Identify Click Function on Dropdown Change

I am a web programmer with no GIS experience and I am working with a GIS specialist with no web service experience. I am using the JavaScript API 3.7 but I am not very familiar with the API. I have ...
3
votes
1answer
30 views

How to remove a feature from a layer created with “Make Layer From Selected Features”?

In ArcGIS desktop, I select some features from a feature class (say with the "Select By Location" function), and then right-click and choose "Selection--> Make Layer From Selected Features"(online ...
2
votes
0answers
34 views

Query out a specific date regardless of the time, using python

Problem: I have a feature class with an attribute table with a field called Edited_Date and its data in the field is as follows: 4/8/2015 10:00:00 PM. I want to select all records that are Edited_Date ...
1
vote
0answers
38 views

Does QGIS have a dynamic spatial join select tool, equivalent to MapInfo Boundary Select?

I´m a MapInfo user, I´ve gone over to QGIS and it´s got a lot going for it, except for some simple features from MapInfo I just can´t do without. One such is MapInfo Boundary Select, which is a basic ...
0
votes
1answer
1k views

Having trouble selecting polygon from existing layer (using OpenLayers.Control.SelectFeature)

I am hoping someone can point me in the right direction. I am not a programmer, so that is my first roadblock. ha The problem: I have an existing polygon layer and I am trying to select one of the ...
0
votes
1answer
39 views

How to add item to an existing selection layer

I have a selection layer of about 150 properties in ArcGIS ArcMap, and I want to add one more building to it (see image, area outlined in red circle). The problem is that I missed this building in ...
2
votes
1answer
23 views

TSQL Geometry Query Requires conversion to string

If I specifically define some polygons and check for containment, I get a correct result: DECLARE @g geometry; DECLARE @g2 geometry; SET @g = geometry::STGeomFromText('POLYGON((407305 100826.5, ...
1
vote
2answers
37 views

Running Select results in error 000210

I'm trying to run SELECT in order to extract specific features under "CLASS_NAME", but continue getting "ERROR 000210: Cannot create output". I've searched though other questions with the same ...
1
vote
1answer
378 views

Select polygons by attribute belonging to another layer

I'm a recent QGIS user. I have a shapefile A with a series of polygons indicating land use of an urban region (urbanised areas). Now I want to select them in relation to a second shapefile B with the ...
0
votes
1answer
17 views

Selecting Untitled polygons in Google Earth

I have an area where I'm trying to mark some polygons in it and under temporary places folder they were adding as shown below. Now how do I select some of the polygons and move them to different ...
2
votes
2answers
48 views

Is a multi-database select possible with DB Manager?

I have data in two locations: geometry data (with attributes) on a PostGIS server (read only) a geometryless table on a local SpatiaLite DB (read+write) I need to select features based on data ...
0
votes
0answers
17 views

How to select data from the table using Query Widget

I have a question regarding Query Widget of the WebApp. I made a web application using WebApp, and put a Query widget in it. The Query seems like working, because if I select parcels using Query, the ...
2
votes
1answer
48 views

Select points North of line across polygon using ArcGIS for Desktop?

I need to select all points north of a line. I'm have trouble conceptualizing what tools would allow me to do this. Any advice? I'm in ArcGIS 10.2.2 if that matters. In the poorly drawn picture I ...
1
vote
1answer
42 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
65 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
41 views

Select the first 5 rows of a selection after reverse sorting using an attribute field in ArcGIS 10.2 with Python

I have a feature class containing 380 polygons representing sedimentary basins and another polygon feature class representing oil discoveries within said basins. My plan is to: Iterate through all ...
0
votes
1answer
33 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
35 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
485 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
40 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
43 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
68 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
34 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
45 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
33 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
54 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
65 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
502 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
386 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
251 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
99 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)) ...
8
votes
2answers
1k 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
703 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
39 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
754 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 ...
13
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
88 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
17 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
45 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
49 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
489 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 ...
0
votes
1answer
90 views

Openlayers selected feature unselecting on map zoom

I have createc a select control and a StyleMap that includes default marker and select marker. var mystyle = new OpenLayers.StyleMap({ "default": new OpenLayers.Style("null", { ...
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
246 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
220 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, ...