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

learn more… | top users | synonyms

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 ...
1
vote
2answers
89 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
337 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
254 views

Creating buffer around WFS features to ease their selection in OpenLayers 2?

I'm using a WFS SelectFeature from OpenLayers 2 to show a Popup containing the features' attributes from line layers and point layers (from GeoServer). This works fine, but I would like to create a ...
1
vote
1answer
101 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
53 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
203 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 ...
1
vote
2answers
92 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
380 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
92 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 ...
2
votes
1answer
110 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 ...
1
vote
1answer
356 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?
0
votes
0answers
92 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
1answer
137 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
321 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 ...
1
vote
1answer
74 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
181 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
1answer
128 views

Counting Features to Calculate Field Value

Generally, I am trying to find the # of features in one shapefile within 1000 feet of EACH feature in a second shapefile - and then populate a field in the first shapefile with that #. More ...
1
vote
0answers
58 views

Is order of selection in Spatial Data important (attribute, location, graphic)?

When dealing with spatial data in a GIS system, does it matter which way you select the information if you're using all 3 - attribute location and graphical selection? In my experience it seems to not ...
0
votes
0answers
110 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
158 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#.
1
vote
1answer
895 views

Batch export all layers in ArcMap document that have selected features?

I have several layers in an ArcMap Document. All of these layers are stored as shape files. Specific features of the said layers are selected. I want to export the data as shapefile programatically. ...
1
vote
0answers
127 views

Quick way to select by attribute and zoom to selection in QGIS

I need to visually control hundreds of points in a layer on top of aerial photographs. Using the attribute table, selecting (with column filter expression) and zooming manually is cumbersome - so I ...
1
vote
1answer
124 views

Select / Drag or by rectangle CMV Application

Anyone able to suggest to this noob if there is a way to change the selection option in my CMV application from individual polygons (one at a time) to an option of selecting multiple polygons at once ...
3
votes
1answer
491 views

How to create and remove multiple QgsRubberBands in PyQGIS?

Currently the following code-snip works great to highlight a shape based on the 'feature' and 'layer' variables: self.rubberHighlight = QgsRubberBand(self.iface.mapCanvas(),QGis.Polygon) self....
2
votes
1answer
422 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 ...
3
votes
1answer
387 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
52 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
110 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 ...
1
vote
1answer
1k 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
133 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
51 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 ...
2
votes
2answers
67 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 ...
2
votes
1answer
135 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
126 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
121 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 ...
1
vote
1answer
124 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
66 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. ...
0
votes
1answer
180 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 ...
1
vote
1answer
89 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
84 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
89 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
2answers
84 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
149 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?
2
votes
2answers
176 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 ...
3
votes
1answer
1k 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 = canvas.currentLayer()...
2
votes
1answer
721 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) ...
0
votes
4answers
183 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 ...
0
votes
1answer
524 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 ...