Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [query]

A command used to retrieve information from a database

2
votes
1answer
38 views

Query land use (Raster calculator)

I have a land use raster file and am trying to use the raster calculator to query the file for surface water. The saga formula (11 = surface water band): (a, 11) This does not work. Can anyone ...
0
votes
1answer
26 views

How to make query of MySQL connection in QGIS?

i have added a connection with a MySQL database in QGIS (Add vector layer - Database - MySQL). Is there an option to make a query over the database in QGIS?
1
vote
3answers
70 views

Extracting single boundary from multipolygon in PostGIS

I am trying to find a single external boundary either polygon or line from the multipolygon using st_boundary in PostGIS query. The function doesn't work. What could be the issue?
4
votes
1answer
107 views

QGIS: Select point(s) in other layer with similar datetime value from selection

For the interpretation of bird observations, I need to identify the position on a GPS-track (gpx-files), from which the position of a bird observation (other gpx-waypoint layer) was recorded. The ...
0
votes
1answer
78 views

Constructing query to return values from all polygons that line passes through using SpatiaLite? [closed]

I want an SQL query in Spatialite to return a list of values (Primary Key in this case, but could be any value) from all the polygons which are crossed by a line. Say, for example, a footpath passes ...
-1
votes
1answer
28 views

Using Field Calculator for subtracting values with same ID in ArcPy? [closed]

I have a line shapefile that used for some calculation. One of the calculation is subtracting values with a same group ID. The shapefile has a filed called LineID that consists of 2 lines with Side 1 ...
0
votes
0answers
26 views

How to determine shifting intersections of polygons using MapInfo SQL?

I'm looking for a Mapinfo SQL which can look at two tables and easily determine if a particular smaller bounded polygon has now moved into a different larger bounded polygon because there has been ...
2
votes
2answers
386 views

SQL Query not selecting all points that it should?

I am working on a map of 60+ monitoring wells and I plotted them through an excel data sheet and a few tools. In that data sheet, I have Benzene concentrations associated with almost each point. I ...
1
vote
1answer
28 views

Finding Rows Inside other Rows

So I have database with which I want to do the following: Find out which other rows are contained within the geometry of the row in question. To keep it simple, I am finding the envelope/bbox of the ...
0
votes
1answer
14 views

Counting (Multi)Polygons Within (Multi)Polygons on same Table

So I have a table with approximately 10k rows, with each row having its corresponding geometry entry. What I am attempting to do is count how many row geometries are contained/within the geometry of a ...
1
vote
1answer
36 views

Exporting query to identify the exact points that fall into a polygon using ArcGIS

I am using ArcGIS 10.6.1. I have a shapefile consisting of points (facilities names and adresses). I also a shapefile consisting of polygons made up of enumeration areas as well as the Local ...
2
votes
1answer
56 views

Parsing for numeric and character wildcards in a QGIS query

In an attribute table with a land use shapefile in my QGIS project there are complex combinations of numeric and alphabetic character. I wish to filter for a simple combination of numeric wildcards ...
0
votes
0answers
25 views

Arc GIS Javascript 4.1 Autocomplete search widget

I am trying now to use autocomplete widget, i fond code written for API version 3.1, i use 4.1; I changed connection links and other things that might need to change. now i have response of attributes,...
2
votes
1answer
48 views

average weighted value by region with use of Voronoi in Qgis

I have a vector layer of Voronoi polygons. This layer has three columns -longitude, latitude, Z-value. I need to cut polygons by mask of administrative area and then I need to calculate average-...
-1
votes
1answer
28 views

Zoom To Query result

I have SQL query in my code and after it responses I want to go to query result extent. What I have now is that after respond it goes somewhere in Atlantic ocean. Here is my code: //rukis Seqmna ...
2
votes
1answer
47 views

Add virtual layer to aggregate feature

newbie here of QGIS here, I was trying to aggregate a feature from a CSV with no geometries. The query is very basic: SELECT "PROV", SUM("POP_2012") AS POP_2012 FROM "municipalities-tuscany" ...
1
vote
1answer
39 views

QGIS - Cartesian Join

Is it possible to run a cartesian join in QGIS? I use Access to do this but I would like to know if I can do it directly in QGIS (or GRASS GIS) to avoid the back and forth between the GIS and Access.
1
vote
0answers
57 views

QGIS Duplicate Labels still appearing despite suggested changes. Do i need to do an expression?

I have one field called Streets. In Streets there are road beds with suffix as Pkwy, Street, Avenue, Expressway and so on. I also want to label some of these road beds. In Layer styling under ...
0
votes
1answer
30 views

Intersection of two sets in openstreetmap to find parent of any area

I am trying to determine what the parent administrative area of any given area. The idea is that the closest parent is the administrative area with the highest/deepest admin_level that is shared as a ...
0
votes
0answers
23 views

ArcMap filtering with messy data

I am working with a DEM that has a bit more data than I actually need. Specifically, even the lowest resolution version is 100ft and I'm trying to reduce it down to 500ft or even 1000ft intervals. I ...
1
vote
1answer
59 views

PostGIS SQL Query Filter by Bounding Box

I have the following query on a PostGIS Database SELECT row_to_json(fc) FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features FROM ( SELECT 'Feature' ...
1
vote
0answers
32 views

ArcGIS Pro Display Filters not working?

I love the new Display Filters feature in ArcGIS Pro. I've used them a few times and they're great! However, recently when I've tried to utilize them they don't seem to work anymore. Below is a ...
2
votes
2answers
108 views

Comparing string value in attribute table?

I am working on QGIS. It is a line feature. Say we have three consecutive links. If the first and the last link has the same attribute value and the centre differs, I need to select those. Is there ...
0
votes
1answer
41 views

arcpy.da.SearchCursor storing data in a list with a query

I am currently working with a database that hold street names, x and y coordinates and many more fields. I would like, through a search cursor, to store the x,y coordinates in a separate list for ...
0
votes
0answers
45 views

I have a shapefile where in I want to select features based on their feature ids

I have a list of feature ids and I am using layer.SetAttributeFilter for that but the code neither selects those features nor does it raise an error. I took help from these questions: OGR Filter ...
0
votes
1answer
45 views

Selecting records by SQL Query and saving SUM or COUNT result into differnt table

I am trying to create a python toolbox with the following function: I want to select points or lines within a polygon and save the selected feautres as a temporarily Feature. (That works) Then I want ...
1
vote
1answer
52 views

Different result with Query builder and the processing 'extract by expression'

I have a attribute table (xlsx sheet imported with the plugin 'spreadsheet layer'). For example, it contain only 15 lines I have filtred the data with this request that return 6 lines (correct result)...
0
votes
1answer
28 views

Seeing changeset in josm window?

When I am trying to download my changeset in JOSM and after zooming to data in the current layer, it is showing there is no object in the data layer.
1
vote
1answer
45 views

Create new vector of polygons that are within 500m of a point in vector of points P

If I have a vector of polygons A (say 200) and want to create a new vector (say 120) of the original 200 polygons that are with 500m of a vector of points P (say 50), this is the method I do. I want ...
1
vote
1answer
205 views

How to query WFS layer in ArcGIS Online?

I want to incorporate the following WFS query URL in ArcGIS Online: https://9.9.9.9:8080/geoserver/workspace/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=workspace:education&...
0
votes
1answer
119 views

Create Database View with ST_Within Query

I see several other questions similar but none that apply directly to mine. I am using ArcGIS Desktop 10.6.1 with SQL Server running my Enterprise Geodatabase. I have a very large point feature ...
1
vote
1answer
31 views

Save Attribute Query

How to save attribute query on qgis 2.14? I have more than 20 queries. The recent queries save only 20 queries. If I can save them, it will be more effiecient.
5
votes
2answers
389 views

Selecting all features except one using QGIS?

Using QGIS 2.18. I have 346 polygons on a layer and I want to display all but one. In this instance I wish to run a query using field ONSCode but show all except 17UB. I have been trying to use NOT ...
0
votes
2answers
55 views

Attribute table in QGIS showing a subset of desired features after query builder

I'm working with some OSM data in QGIS and I want to show only those points that are schools. So I go into query builder and enter "other_tags" LIKE '%"amenity"=>"school"%'. This narrows down my ...
0
votes
0answers
20 views

How to get the identify form to load with SQL query view?

I've loaded an SQL query on a table in a spaitalite database as a view. The view has loaded fine and the attributes table is showing all the data, but the Identify tool won't bring up a form. Is there ...
0
votes
1answer
48 views

How to push objectIds' array to RelationshipQuery's object in ArcGIS API JavaScript 4.9?

I need to push array of the object IDs to RelationshipQuery's object using executeForIds that generates the array. I also used executeRelationshipQuery that executes the query. I don't not why, but ...
1
vote
0answers
17 views

QGis Python featurerequest with lists

I want to select some features and do some actions to this selected features. Something like if attribute in field a is = abc than do something. But the selection will not fit. As written in https://...
0
votes
2answers
98 views

How to optimize this query for (OpenStreetMap) map tiles rendering?

I'm trying to optimize my OpenStreetMap map tiles rendering. This is one of the queries renderd makes to PostgreSQL: SELECT ST_AsBinary("way") AS geom, "type" FROM (SELECT way, ...
0
votes
2answers
134 views

NULL value not equal to empty value for attribute

I have a feature layer in a gdb. It has an attribute named uniqueid. Some of rows have a value for uniqueid and some do not. I am trying to select only the features that have a value (are not blank). ...
2
votes
1answer
52 views

Start ArcGIS Web Map Zoomed to Query

Can you have an ArcGIS Online map, you know one that you share and embed on a web page or link to, automatically start at an extent that is defined in a query of some sort? Ideally it would be great ...
1
vote
1answer
59 views

Sentinel-2 Query scihub apihub wget missunbg results

when I perform a search using https://[username]:[password]@scihub.copernicus.eu:443/dhus/search?q=footprint:"intersects(41.9000, 12.5000)" AND ((platformname:Sentinel-2)) in firefox I only get to see ...
2
votes
1answer
30 views

Turn Off the Query Ability at the Service Layer Level

I have a service with three layers that I publish to our Enterprise 10.6.1, from ArcMap 10.6.1. I know that when I publish the service from my MXD, I can check/uncheck the box in the Mapping ...
1
vote
1answer
116 views

ST_DWithin query throwing 42601 error?

I am trying to get from a particular point more informations about the surroundings (which are also points). So I wrote this: SELECT * FROM osm_point WHERE ST_DWithin(way,(ST_SetSRID(...
0
votes
0answers
18 views

Channel Easements for County: Need help with Query or Python

I have a layer for easements for a whole county and need to find each easement either MISSING or having a PART of what the county calls "STW_ARCS." These ARCS are what the county have data on for how ...
1
vote
1answer
21 views

How to query areas from DynamicMapService Layer…?

I have two dynamicMapServiceLayers, I have to query the area where three dropdowns are there. From a districts dropdown I have to select one district according to that mandals should be loaded to the ...
2
votes
1answer
30 views

Select by character limit

I'm using the select by attributes to find unique values that I am copy pasting from a spreedsheet. EX "jobnumber" = 1111116 OR "jobnumber" = 2222245 OR "jobnumber" = 5555655 .. etc The problem is ...
1
vote
1answer
87 views

Counting where multiple street names within polygon using MapInfo?

I have a dataset of address points with their associated street name, in addition to a tab file of polygons covering a catchment. I want to know if there is a way of selecting polygons which have ...
1
vote
1answer
235 views

Querying & filtering raster data from PostGIS using GeoServer

I'm currently working with raster data and serving it to a web application using Geoserver. I want to be able to perform queries to retrieve the raster data from a PostgreSQL database with the PostGIS ...
4
votes
1answer
114 views

clipping layer using query builder in QGIS

I have a global vector layer which includes several fields in the attribute table. I want to filter one field above a certain threshold and then clip the corresponding areas to make a new layer. I ...
2
votes
1answer
189 views

Using a subselect for ST_Distance query

So I am at a bit of a loss here, trying to get the distance in meters between a point stored in my table and a set of coordinates locations id | name | location(point) ---------------------...