Questions tagged [query]
A command used to retrieve information from a database
678
questions
0
votes
0
answers
33
views
Select and display 1-n relations between shape and CSV table
I have a shapefile containing parcels borders (polygons) and a csv table with owner information. I can relate these (1:n) by the parcelnumber. So by identification I can see by clicking on the ...
- 583
0
votes
0
answers
32
views
Placing JSON data(temperature) without long, lat in OpenLayers
I executed the WCPS query for fetching the raster temperature data in JSON format using the following query:
for $c in (temperature_new) return encode($c[Lat(50:70), Long(30: 60), ansi("2022-11-...
0
votes
0
answers
23
views
Bypass Same-Origin-Policy CORS Error for Overpass API
I am trying to fetch data from the Overpass API using jQuery (just a code snippet):
$.ajax({
url: 'https://www.overpass-api.de/api/interpreter',
data: {
data: '[out:json][...
- 139
0
votes
0
answers
39
views
OSM overpass API query based on GeoJSON polygon
I understand that the polygon feature for a query response with the Overpass API has to be in form (poly:"latitude_1 longitude_1 latitude_2 longitude_2 latitude_3 longitude_3 …");.
https://...
- 139
1
vote
0
answers
36
views
REST query input geometry
I'm trying to get a list of surrounding counties using https://tigerweb.geo.census.gov/ but I am having trouble querying their ArcGIS REST server.
My goal is to send a county (I know the GEOID), get ...
- 213
2
votes
2
answers
187
views
Replace single and double quotes with QGIS expressions
I have a dataset containing special characters ' and ". I want to replace them with nothing. I tried to replace them with the replace function but it shows some error. Is there any other ...
- 749
4
votes
1
answer
74
views
PostgreSQL query not working in QGIS Graphical Modeler
Edit: For further context, my table does have a unique id in the form of an integer. Through the database manager, the query executes successfully and I am able to load the query layer into QGIS. This ...
- 41
5
votes
2
answers
82
views
QGIS - how to label values of two different polygons in one polygon setting
I'd like to display the values of two different polygons in one. I have a polygon with the border of different states, then in a separate polygon I have the borders of districts dividing the states... ...
- 583
2
votes
2
answers
142
views
Polygons within Polygons
I am using QGIS V3.30
I have a set of polygons, being farm boundaries. I have another set of building polygons comprising various features within the farms.
I would like to get a table listing all ...
- 41
5
votes
1
answer
86
views
Using eval function in Virtual Layer in QGIS
I'm now trying to use the eval() function in a Virtual Layer in QGIS.
The version of QGIS is 3.28.4-Firenze, and it contains the SpatiaLite (version 5.0.1) which includes the eval() function as below.
...
- 137
1
vote
0
answers
19
views
Identify and Seperate Special charcters in to other column [duplicate]
My dataset contains special characters. I want to identify the data which contains only special characters and separate it into a new column.
List of special characters :
`~!@#$%^&*_{}[]<>?/
...
- 749
4
votes
1
answer
45
views
Virtual Layer query connection failed at reload project
I have a QGIS project that generates a layer with point geometry from a database (Excel sheet) that I load directly into QGIS. To this table a join is established with a common field of a GPKG point ...
- 789
0
votes
0
answers
38
views
GeoServer WFS sortBy (v2.0.0) with multiple layers?
I'm using WFS with multiple layers, but the results are sorted by layer, not by the full result set.
For instance:
Layer A
a
b
c
d
Layer B
a
b
c
d
I want the results be a single list sorted by ...
0
votes
0
answers
208
views
Selecting unique values in attribute table in ArcGIS Pro
I'm moving my data from Python to ArcGIS Pro because they have spatial features. The data is a table, in excel, with X, Y coordinates and several attributes, but no geometry (no shapes). I have ...
- 139
0
votes
1
answer
185
views
ArcGIS Pro: Definition Query > Create new definition query in SQL
I have one point type feature class and another feature class with a polygon.
Using ArcGIS Pro, in the feature class type point > Definition Query > create new definition query in SQL.
I want as ...
3
votes
2
answers
155
views
Selecting features and create new field with QGIS Field Calculator
For example, Column A (1, Michigan Street, Michigan), Column B (Michigan Street) and Column C (Yes, No).
I want to use Field Calculator to update Column C in a way that it return NO if Column A ...
- 31
0
votes
2
answers
69
views
Create New Feature_ID following Series of numbers
I have two datasets of data let say set_1 and set_2. set_1 is original dataset and set_2 is modified dataset (duplicates and wrong data has been removed from the data).
Due to the modification some of ...
- 749
4
votes
2
answers
217
views
QGIS Expression: Finding DEM value at point where two lines on different layers intersect
I've been working a while on this and I'm sure I'm missing something. I have to sets of lines on a DEM, and I need to call a raster value where they intersect. I can get it to where I am getting the ...
- 91
1
vote
1
answer
137
views
Query error cannot concatenate 'str' and 'Result' objects
I wrote a simple script that iterates trough selected polygons and cuts the points of other layers, and export shapes and txt to different folders according to the zones defined by the polygons.
The ...
- 513
2
votes
0
answers
90
views
QGIS dynamic filtering parent and child features
I have in QGIS 3.22 point layer, I'm trying to visualize the table:
fid
point_name
parent_relation_to_fid
1
point-X
1
2
point-Y
1
3
point-X
2
4
point-Z
3
5
point-Y
3
6
point-X
2
7
point-Z
4
I ...
- 383
1
vote
0
answers
74
views
Filtering 'overlay_intersects' with query builder of QGIS [closed]
In order to filter a data and display only the part of the data that intersects another data, I knew the expression 'overlay_intersects' but this function does not seem to work with the query builder (...
- 839
2
votes
1
answer
75
views
QGIS: Function week(interval) does not exist
I try to query with an expression I found in older posts:
week(age(now(),end_time)) <= 1
Where end_time is of QDateTime.
I am getting back:
An error occurred when executing the query.
The data ...
- 133
1
vote
0
answers
51
views
Removing automatic filter using QGIS [closed]
I opened a layer on QGIS 3.10.3 and got an automatic filter. I checked the Query builder, and nothing appears in the Query window. My colleague checked the attribute table on ArcMap. There is no ...
- 181
0
votes
0
answers
61
views
Select polygons that intersect points in QGIS using WFS data
How to select polygons that intersect points in QGIS using WFS data? I am trying to select polygons from a WFS remote database that intersect a local point shapefile. The selection by location does ...
0
votes
0
answers
41
views
Finding character position in string field using SQL in file geodatabase and Data Reviewer with ArcMap
I need to compare data in two text fields using the Data Reviewer Table checks. More specificly the SQL Check. I'm hoping to find features where the data in one field doesn't match the data in a ...
- 1
0
votes
1
answer
287
views
How to abort pending query requests?
Using ArcGIS JavaScript API 4.24 I have a map which is configured to query a layer each time the map extent changes. This means that multiple sequential requests are sent if the map is moved quickly:
...
- 20.9k
0
votes
1
answer
49
views
How to match a query's response to its parent query?
Using ArcGIS JavaScript API 4.24 I'm triggering a series of queries, then sending the responses to a function to handle them. Here is a simplified example:
let whereClauses = ["capital = 'Y'"...
- 20.9k
1
vote
0
answers
219
views
Querying countries per continent via Overpass API
I managed to get all states from a specific country by using the following code via the Overpass API:
[out:json][timeout:600];
area["name:en"="{country.Name}"]->.country;
(
...
- 11
5
votes
2
answers
2k
views
Can you use SQL in QGIS?
Is there a way to use SQL on a shapefile dataset in QGIS? I am used to using SQL to analyze my data.
- 191
3
votes
1
answer
269
views
Querying by GlobalID in ArcGIS Pro
I can't figure out the syntax to query a feature class by GlobalID because the GlobalID is not a string, float, etc.
What is the syntax to query by GlobalID in SQL using ArcGIS Pro?
SELECT * FROM ...
- 157
1
vote
1
answer
242
views
QuickOSM does not return results
I'm trying to use the QuickOSM plugin so I can automate the search of addresses and creation of layers. Right now I'm just trying with one address using the key -> addr:street "Bäckerstr."...
- 23
0
votes
0
answers
140
views
Querying for data on the border of city on Overpass API
I'd like to collect features inside a city and 5km outside its official borders from the Overpass API. I've been using 'rivers' in 'berlin' as example but without success. Here's my code:
[out:json][...
2
votes
1
answer
112
views
QGIS - Merging two tables and make lines
I need help with merging two table and create geometry.
I have two points layer with features tables and try create polyline layer.
When I create virtual layer with next querry then result is polyline ...
- 31
0
votes
0
answers
60
views
Improving performance of Overpass area search queries
I am building an application that retrieves lists of location names within geographical boundaries like cities and postal codes. The queries take up to 15 seconds to complete and I would like to make ...
- 1
1
vote
0
answers
126
views
Query GeoTIFF file by lat/lon programmatically in python [closed]
I am trying to query data from a GeoTIFF file by latitude and longitude. I have a dataset that has ~1 million data points in the U.S., and for each point, I need to query the CDL data by lat/lon ...
- 29
4
votes
1
answer
353
views
Spatial queries with QGIS provider feature filter (layer filter)
QGIS offers the option to use layer filters: Layer Properties > Source > Provider Feature Filter, see documentation: Query Builder.
As far as I can see, this filter is only able to filter based ...
- 61k
1
vote
1
answer
300
views
Data extraction from imagery in Google Earth Engine using neighborhoodToArray
I am new to Google Earth Engine and I'm working with a dataset contained multiple points with lat/lon coordinate. I want to query these points and extract the band value in the form of 2D array of ...
1
vote
1
answer
218
views
Filtering active date between two date fields using file geodatabase in QGIS
I would like to save a .qlr with data stored in a file geodatabase that displays active records that fall between two DateTime fields: Start date field and End Date field (inclusive). I had this query ...
- 11
0
votes
1
answer
46
views
Web AppBuilder DE - Use an uploaded shapefile to query
The shapfile is zipped and uploaded through the "Add Data" widget. I am looking to use an customized widget to read the feature layer from the upload and query another feature layer. Since ...
- 333
0
votes
1
answer
37
views
Wrong polygons displayed in QGIS spatial query
I have two polygons, one is a virtual layer that generates a buffer around a site, the other is a set of polygons representing locations of interest.
I have tried to create a query that gives me only ...
- 1
1
vote
1
answer
38
views
Reviewing query from which Virtual Layer was originated in QGIS
I created a Virtual Layer by going in Layer > Add Layer > Add or Edit Virtual Layer. This new layer was created by building a query on another layer I had in my project.
Ho can I check, ...
- 785
2
votes
1
answer
1k
views
Constructing query in Nominatim
I wonder how to construct the structured query URL for the OSM Nominatim? According to the documentation, one can use the free-form-query or the structured-query. This is the base url https://...
- 3,298
6
votes
1
answer
112
views
QGIS point layer: Select first point in each category
I have a point shapefile layer with several thousand points. Each record has a timestamp field and another field which defines a category to which that record belongs. There are about 200 different ...
- 403
2
votes
1
answer
122
views
Date operation in the Query Builder withPostGIS layer
I would like to filter a PostGIS layer by a datetime (QDateTime) field. I only want to show elements newer then 14 days. I tried the following expression in the Quary Builder:
(day(now() - "...
- 23
2
votes
1
answer
98
views
Using LIKE with a Real field
Is it posible to use a wildcard in a field with real values? I am using QGIS.
For example. I have a field with values from 0 to 10000, with increments of 10 metre, but would only like to display every ...
2
votes
1
answer
61
views
MapInfo SQL Query with Metacharacters?
I have +8 million edge in MapInfo. I want to select character+digit but I can't.
I tried querying as [a-z]+[0-9] but failed to use metacharacters in MapInfo.
"New York 1. Street" is true.
&...
- 31
5
votes
2
answers
405
views
Matching colour of point to colour of polygon based on shared attribute using QGIS
I am setting a query on the symbology in QGIS.
I have a layer of point locations (586 points which show the location that data has been collected) and I have a layer of polygon areas (576 polygons the ...
- 51
0
votes
0
answers
134
views
SQL query on array data in ArcGIS attribute table
I have an attribute table where courses offered by different colleges are in an array, I am trying to Query using ArcGIS query builder so as to return colleges offering a specific course within the ...
- 9
0
votes
1
answer
185
views
KML File - Python - Log Query
I want to know how many records are there in a KML file. Through what Python 2 code can I know this information?
- 191
1
vote
0
answers
111
views
QGIS virtual layer SQL Query Arrays
I have a polygon layer (A) with a field containing the farmers that use that polygon (the UUID of each farmer):
In each polygon feature can work from one to several farmers as it can be seen in the ...
- 53