Questions tagged [query]

A command used to retrieve information from a database

Filter by
Sorted by
Tagged with
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 ...
ReutKeller's user avatar
  • 2,117
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 ...
Char's user avatar
  • 1
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 ...
JoanB's user avatar
  • 143
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 ...
Andrew T's user avatar
  • 269
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 ...
user231744's user avatar
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 ...
user231744's user avatar
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 ...
user231744's user avatar
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 ...
user231744's user avatar
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, ...
Han's user avatar
  • 13
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="...
Alm94's user avatar
  • 81
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 ...
RRR's user avatar
  • 21
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, ...
Gerard M.'s user avatar
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 ...
bravesheeptribe's user avatar
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 ...
golo peters's user avatar
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. ...
Peter J.'s user avatar
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 ...
MAMDOUH ZALAKY's user avatar
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 ...
LIQUE Group's user avatar
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 ...
JTstone's user avatar
  • 37
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 ...
Philip Gatzlaff's user avatar
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 ...
Marek's user avatar
  • 547
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-...
Aayush Subedi's user avatar
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 ...
Andrew T's user avatar
  • 269
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 ...
Bruno B's user avatar
  • 839
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 ...
aidena's user avatar
  • 41
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... ...
Marek's user avatar
  • 547
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 ...
Norman's user avatar
  • 51
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. ...
Lc_decg's user avatar
  • 137
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 : `~!@#$%^&*_{}[]<>?/ ...
Bruno B's user avatar
  • 839
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 ...
Acperience's user avatar
  • 1,050
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 ...
dpalmeira's user avatar
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 ...
JCV's user avatar
  • 139
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 ...
Marco Escalante's user avatar
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 ...
Irfan Zahid's user avatar
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 ...
Bruno B's user avatar
  • 839
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 ...
DrewGIS's user avatar
  • 91
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 ...
nanunga's user avatar
  • 533
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 ...
Rii Pii's user avatar
  • 425
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 (...
user35117's user avatar
  • 939
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 ...
Belurd's user avatar
  • 133
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 ...
GIS Noh's user avatar
  • 321
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 ...
Mael Jézéquel's user avatar
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: ...
Stephen Lead's user avatar
  • 21.1k
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'"...
Stephen Lead's user avatar
  • 21.1k
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; ( ...
Strazz's user avatar
  • 11
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.
Chace Carpenter's user avatar
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 ...
zemken12's user avatar
  • 157
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."...
rafa's user avatar
  • 23
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 ...
Grumgog's user avatar
  • 31
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 ...
Sarge's user avatar
  • 1
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 ...
Akhila Ram's user avatar

1
2 3 4 5
14