Questions tagged [query]
A command used to retrieve information from a database
692
questions
0
votes
0
answers
5
views
Get administrative boundaries using quickOSM plugin in qgis
I'm trying to access the administrative boundaries of different countries using the quickOSM plugin in qgis. The query runs successfully but with no results. This is the query I try to run with the ...
0
votes
1
answer
44
views
Query polygon layer by geometry size
This is something I know I can do with ArcGIS but I don't know how to perform on QGIS.
I have a layer containing multiple polygons of size x. I want to query the layer to remove every polygon of size ...
2
votes
1
answer
41
views
Compare field attributes
I am using ArcMap 10.8.2. I have two point layers from different sources which contain the educational facilities of Catalonia. Each layer may contain facilities that are not contained in the other ...
2
votes
1
answer
58
views
ST_Contains Removes Invalid Geometry & ST_MakeValid PostGIS Query Gives Error
I'm trying to query a list of polygons (geo_parcels) and get all of them, and also spatially add any points or polygons (geo_buildings) that are in or on that polygon. Normally I'd use a query like ...
0
votes
0
answers
37
views
Quick OSM in Modeler - Line Filter
I am using a working OSM Query module, mostly extracted from HERE. My only trouble is that I would like to filter some of the extracted data.
The raw query is a pretty open call for everything and ...
0
votes
1
answer
41
views
Spatial Join with no Related Primary Key
The example I am showing is a VERY simplified version of my dataset which actually represents 100's of points. I have point A representing a building (centroid of the building polygon), but no other ...
1
vote
1
answer
61
views
Model Designer - Available Algorithms
Is it possible to add an algorithm from the Processing Toolbox to the list of available algorithms in the Model Designer? Looking at the question HERE, I see that they are in the designer and are ...
2
votes
2
answers
80
views
Filter out point layer from Quick OSM using raw query
I want to be able to create an OSM Query for 'highways' and 'buildings' only (no OSMQuery Points) in the Model Designer, so I need to be able to understand all of the code required to create an OSM ...
0
votes
0
answers
39
views
How to run a yes/no query on QGIS using multiple layers for specific requirements?
I am unsure how to really word my question properly. However, I am attempting to do something specific with the data I have obtained.
I have some different layers, such as soil, topography, ...
2
votes
1
answer
52
views
How to intersect with ST_Buffer in PostGIS
I have a table called "gebaeude_salzburg" with all types of buildings in the city.
In the following I want to use a Buffer around the central train station that has the osm_id="...
2
votes
1
answer
43
views
Download every nth node overpass turbo
I would like to download OSM Data of admin borders and highways for a very large area. This would produce a very large file and is way too much for the osm overpass (I used overpass turbo but am happy ...
0
votes
0
answers
51
views
Querying nested latitude and longitude fields in Opendatasoft API
I'm working with the Opendatasoft API, specifically accessing the "geonames-all-cities-with-a-population-1000@public" dataset. I need to perform queries based on the latitude and longitude, ...
0
votes
0
answers
37
views
How can you search dates using the ArcGIS REST API's find tool
Basically, I am trying to use a date as the searchText (e.g. `...MapServer/find?searchText=2023-10-19...), however it is not returning any results. The searchField I am using is a date time field, so ...
1
vote
1
answer
54
views
Filter for next value
I'm working with QGIS 3.28.5.
I'm working on breeding bird data. I have a set of points where I heard a bird on a specific date. Now I want to separate the territories.
My problem is, that I have to ...
1
vote
1
answer
88
views
How to query a WMS in QGIS and pan/zoom to selected feature
I'd like to find a way in QGIS (plugin, script) to query a WMS service (Italian cadastral Agency) with specific parameters (municipality, map sheet, parcel no.) and pan/zoom to the selected feature.
...
1
vote
3
answers
121
views
Changing query for layer does not change table inserted in layout using ArcMap
I have a layer in the TOC, with a query on a field. Then in layout view, I insert the table to the layout.
When I change the query the table does not update automatically. Then I double click on the ...
1
vote
1
answer
56
views
Query - Select By Attribute
I have contour data of 1 foot contours. How do I write a select by attribute query to only select 10 foot intervals. ie: 750, 760, 770, 780......
Than data range is between 10ft and 900ft, est. So I ...
0
votes
1
answer
75
views
Using Arcmap to Join two tables based on a field with similar values
I am working in Arcmap and attempting to understand a way to join two tables based on similar values.
In Service_Points I have a field called Address where the value is 1862 Waterfall Rd
In ...
0
votes
0
answers
17
views
Compiling all OSM data with the Key:Wheelchair
I want to analyze the data coverage of wheelchair data in OSM.
Therefore I want to compare the ratio of all OSM data that has the Key:wheelchair and if the data is tracked or not.
I am looking for an ...
1
vote
1
answer
74
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 ...
0
votes
0
answers
51
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-...
1
vote
0
answers
130
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 ...
2
votes
2
answers
335
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 ...
4
votes
1
answer
140
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 ...
5
votes
2
answers
108
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... ...
2
votes
2
answers
143
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 ...
5
votes
1
answer
116
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.
...
1
vote
0
answers
21
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 :
`~!@#$%^&*_{}[]<>?/
...
4
votes
1
answer
61
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 ...
0
votes
0
answers
93
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
501
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 ...
0
votes
2
answers
442
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
326
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 ...
0
votes
2
answers
99
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 ...
4
votes
2
answers
290
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 ...
1
vote
1
answer
318
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 ...
2
votes
1
answer
148
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 ...
1
vote
0
answers
102
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 (...
2
votes
1
answer
88
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 ...
1
vote
0
answers
94
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 ...
0
votes
0
answers
73
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
1
answer
548
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:
...
0
votes
1
answer
114
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'"...
1
vote
0
answers
409
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;
(
...
5
votes
2
answers
4k
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.
3
votes
1
answer
543
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 ...
1
vote
1
answer
366
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."...
2
votes
1
answer
196
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 ...
0
votes
0
answers
103
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 ...
2
votes
0
answers
220
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 ...