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

learn more… | top users | synonyms

4
votes
0answers
130 views

How to select features based upon 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 - ...
2
votes
1answer
210 views

QGIS select feature, “add to current selection” feature

I am trying to perform a feature selection on qgis similar to "add to current selection" interactive selection method in Arcgis Desktop, is that possible? An example: I perform a spatial query and ...
2
votes
1answer
1k 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 ...
0
votes
2answers
79 views

Selecting a polygon within polygon where part of its boundary is the same. PostGIS

I would like to know how can I select a A_polygon within B_polygon, but part of the boundary of the A_polygon touch the B_polygon boundary. In Postgis 2.0, I tried few options but they didn´t work ...
3
votes
0answers
118 views

QGIS Select Single Feature not correct in attribute table

For some reason, QGIS is not displaying the correct row of my data when I click on a feature with "Select Single Feature" or even the other select tools. I have a point database linked from mysql. ...
3
votes
2answers
247 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
1answer
277 views

Check if feature is selected (Openlayers)

I wonder if there is a way to check whether a pointfeature (OpenLayers.Feature.Vector) is selected. I read the API, but didn't find any solution. Any idea?
1
vote
1answer
205 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 ...
5
votes
2answers
276 views

How to detect duplicates and keep only one?

I've got a table with lots of points (200.000). Some of them are duplicates (not exactly but e.g. a metro station has eight entrances) and I want to keep only one of these metro entrances. I am able ...
3
votes
1answer
188 views

Why would Select By Location appear not to work properly after Multipart to Singlepart?

I am having issues using ArcGIS Desktop 9.3 and the multipart to singlepart feature and then selecting by location. Basically, I am able to run the multipart to single part feature to split up some ...
1
vote
2answers
266 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 ...
0
votes
1answer
75 views

Openlayers selection

Is it possible to select a polygon from a predefined Lat & Lon programmatically? eg location point: x='1234' y='5678' intersects polygon '1234', therefore SELECT POLYGON '1234' So far I have ...
4
votes
1answer
203 views

How to eliminate small polygons using ModelBuilder to iterate through feature classes

I created four large polygon feature classes of surface slope classes from a grid of 6-foot cells covering half my county. In order to repair the geometry and eliminate small polygons I broke four ...
0
votes
0answers
16 views

Selecting Particular field in attribute table in qgis [duplicate]

I am having a shape file which contains following fields such as shape area ,shape length,locality ,sub locality etc.My aim is to select only a particular field say for example locality and I want to ...
0
votes
1answer
58 views

how to select parts of a shape in QGIS

I have to have a Shapefile of France of the bigger regions: Ile-de-France, Bretagne, etc. and that is already included in my shape. But its only shown the Arrondissements (smaller regions) in France ...
0
votes
0answers
26 views

How to select areas from a target layer which do not intersect source layer? [duplicate]

I have two different layers, one is county boundary and another one is soil map. My question is I would like to select only those areas which are outside the county boundary. Using "Select by ...
0
votes
1answer
156 views

How can i select many rows from a table?

I want to create an action that select many rows from PostGIS table to show many lines in QGIS. How can i select many rows from table with python to add these rows in a layer? Thank you
2
votes
2answers
675 views

ArcObjects snipped to Select all Features currently visible on the ArcMap screen (ActiveView)

I guess I have to get the extent of the ActiveView and then use it to perform a spatial search. Is that the proper way to do it? Please share the code snipped if you have any. Thanks.
0
votes
1answer
223 views

Map Basic. Where-clause in Select Statement

what is wrong with this statement? I recon the where-clause is the problem. Select * from "BEDIRECT_POT_" + vo_num, PLZ5_2012_bereinigt where "BEDIRECT_POT_" + vo_num.PLZ like ...
3
votes
3answers
2k views

Missing tools (icons) QGIS

I lost selection and navigation tools from the GGIS 1.8 toolbar when I tried drag then to different place. I can't get them back anymore. Where they disappear? All these tools are checked but are ...
2
votes
1answer
75 views

How do I select all polygons in a layer that border 2+ polygons in the same layer?

My data consists of equal-sized polygons. I need to identify and select all the polygons that border two or more polygons.
0
votes
1answer
88 views

Selecting a Polygon based on the location of a point

Currently I have a polygon layer made up of three shapes. All the shapes are listed in the attribute table. One of these three shapes intersects a point. I would like to select just the shape that has ...
5
votes
1answer
2k views

How to select points 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 ...
1
vote
2answers
1k views

Exporting selected feature to google earth in QGIS?

Does anyone know if there is a plugin for QGIS that will export features to google earth similar to the one for MapInfo? Thanks, Alan
1
vote
2answers
225 views

Selecting an item with the mouse in MapBasic

This may seem relatively simple, but I'm pretty confused. I have written a mapbasic tool that does things to the table 'Selection' depending on user choices in a popup menu, but currently you need to ...
4
votes
3answers
4k views

How can I unselect a feature in Openlayers?

I am able to identify the selected features on my map using the following line: vector_layer.selectedFeatures I would like to be able to deselect this feature using a standalone function (not an ...
1
vote
2answers
177 views

How to select two points on a map using QGIS?

I need to select two points on a map in QGIS. I selected the element selection tool in menu view and I want to select two points. How can I accomplish this? Are there other tools or methods to ...
6
votes
1answer
2k views

Select all “NULL” values in the attribute table?

I have a quite simple syntax question. I want to select ALL my null values in an attribute table of a feature class, not just the values in a single field. So the question would be: what is the ...
0
votes
2answers
228 views

Select / Deselect and Identify Features in QGIS

Sorry if this is all a bit 101, but I'm new to QGIS. I basically have a large Arc project that I can access in QGIS for reference, so will only really be using it to identify features. For example to ...
28
votes
2answers
1k 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 ...
1
vote
1answer
163 views

Why does this SQL syntax produce empty feature class with ArcGIS Select_analysis?

I'm working on a script that involves an arcpy.select_analysis function. The problem I have is that when I run the script it produces an empty file. I've verified that the whole thing works when in ...
1
vote
1answer
178 views

Sorting points with QGIS

I have a very good idea of what I would like to do but I really do not know if it is possible with QGIS. I have points that each one corresponds to a group size and I would like to use GIS to sort ...
0
votes
2answers
74 views

How to select by polygon in PostGIS with misaligned layers?

I have two polygon layers, one which defines subregions of the other. However, the layers do not line up exactly, so there are minor discrepancies along the edges. I would like to select all minor ...
0
votes
1answer
37 views

PostGIS: Querying a record table and explanatory table

Basically I have two tables one containing a collection of records and one table that contains extra info about features in the first. i.e Records Table: GID SITE SPECIES GEOM and the second table ...
1
vote
1answer
311 views

Data Driven Pages, Graphs, and selections in ArcMap 10.1

Is it possible in python to create a selection set based on the extent from a Data Driven Page (DDP)? I have a layout view with a map and a graph. The graph is set to only plot the selected set of ...
2
votes
1answer
320 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
2answers
353 views

Using select by location to update a field in a feature class

I am using Arc 10.1 and I am working on a script that takes a value from a field within one shape file and updates a field in another shape file based on its location. Basically I have smaller parcels ...
3
votes
2answers
311 views

Listing features in the order they were selected

This is an ArcObjects-specific version of this question: Create Array From Selected Features Based on the Order in Which They Were Selected Is there a way to get the selected FIDs of a feature layer, ...
2
votes
1answer
255 views

How can I select features by map clicks

I'm developing a flex web application using the ArcGIS flex API 3.1. I have a map with a polyline feature layer. I'd like to be able to select polylines from the map by clicking on the features on ...
3
votes
2answers
856 views

Can't Select and Export from Python Script

I am a novice in python programming but I am trying to learn by doing. I got stuck with this function a while back and can't seem to find a solution or a workaround. I am writing a script that is ...
1
vote
1answer
489 views

How to select features from different WFS layers?

I'm trying to select features from different WFS layers but unfortunatelly it doesn't works in my code. This is my code: var select = new OpenLayers.Layer.Vector("Selection", {styleMap: new ...
2
votes
1answer
196 views

How can I select enclosed features within the same layer?

My problem: I have a single shapefile from a habitat-survey and need to select all hedge-features that are enclosed in meadows.The features that are to be selected were created by filling rings. ...
2
votes
2answers
1k views

zoom to cluster onClick & have hover event

I've made a simple mock-up trying to combine two openlayers examples. I want to have clusters on which I can hover (so I can display an infowindow about it's content) and I want users to be able to ...
5
votes
5answers
365 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 ...
0
votes
1answer
264 views

Change line selection display in MapInfo

can someone help me with a MapInfo query. Is it possible to change the display MapInfo uses when selecting lines? Atm I can be often difficult to see selected lines easily as the lines I am using are ...
2
votes
2answers
169 views

How can a style be set on a specific polygon using OpenLayers?

Using a polygon id, I want to highlight a polygon, while the mouse is outside of the map area. I can identify the polygon using the following approach: x = 53; for(i=0; ...
2
votes
2answers
1k views

How to select multiple polygons or points from WFS or WMS and getFeatureInfo

Is there a way to select multiple polygons and/or points from a WFS or WMS service and then get the feature information for each selected item? There are numerous examples on the OpenLayers website ...
2
votes
1answer
909 views

ArcGIS Javascript: upgrade ComboBox to FIlteringSelect using ItemFileReadStore

I would like to upgrade a web app I am working on from v2.1 to v3.1 of the Javascript API (I have tried 3.2 but I am getting some very odd rending problems, so I'm settling with 3.1 for now...) One ...
2
votes
0answers
106 views

GeoTools, add column in query with CQL

I'm trying to query the database (DataStore) and want to let the datastore calculate a value for me. In SQL I would do it like this: SELECT name, ST_Area(ST_Intersection(the_geom, ....) AS myValue ...
3
votes
2answers
426 views

Unable to select Vector Layer

I am using the following example, to select a vector layer feature on click. The example demonstrates Highlighting and selecting the layer. I was able to successfully implement the Highlighting of the ...