Questions tagged [query]

A command used to retrieve information from a database

Filter by
Sorted by
Tagged with
1
vote
1answer
17 views

Create Query either using Select by Attributes or Python

I am working on something for my job, where I have a list of water/sewer service customers. Some customers have one service or the other, while others have both which is stored as two separate entries....
2
votes
1answer
46 views

PostGIS query from three tables

I am new in PostGIS and want to learn. I faced the query where I have to find one point in two different layers or table. I created a query like this but it is not giving the desired result: SELECT b....
2
votes
0answers
29 views

MapServer Query Raster for Pixel Value at Point

I am working with a MapServer and a map file that is displaying a color-relief image. LAYER NAME "sum" DATA "sum.vrt" TYPE RASTER STATUS ...
1
vote
2answers
63 views

PostGIS: nearest neighbour computation error “No space left on device”

I have two tables: Table_1 and Table_2. Table_1 has 926019 rows. Table_2 has 3089 rows. I want to update a field of Table_1 with the distance to the closest item from Table_2. Here is my query: ...
0
votes
0answers
88 views

Query returning multiple vehicle_ids when it should only return the top 1

Using ArcGIS Desktop 10.5.1 I have a point featureclass in an Microsoft SQL Server 2012 Enterprise Geodatabase (ArcGIS Server 10.5) that holds MDS (mobility ride share scooter) data. The feature ...
2
votes
1answer
41 views

Combining two conditions in one filter expression

I have a Shapefile that shows local municipalities and ward boundaries for South Africa. I would like to filter this layer to only show the wards I am interested in. For example, my first query finds ...
0
votes
1answer
34 views

Quering out multiple values in MapInfo SQL Query

I am trying to filter out around 1000 rows and delete them in MapInfo as they are no longer required in the data set. If there was a smaller quantity then I would use an SQL Query but it has its ...
0
votes
1answer
35 views

Dataframe data handling or SQL Query in ArcMap

I'm trying to perform an SQL query in ArcMap with the following data set, and I have not been able to solve the problem. The idea is to keep all the information of the columns, but for example if the ...
2
votes
1answer
38 views

Filtering fields from a PostgresSQL/PostGIS database layer in QGIS by Query builder

I incurring in an error while trying to make the following filter of fields in the layer properties Query builder in QGIS 3 from a PostGIS database. select "field_A", "field_B2", "field_D" from ...
2
votes
1answer
40 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 ...
1
vote
1answer
41 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
113 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
109 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
80 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
30 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
387 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
19 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
39 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
73 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
36 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
51 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
32 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 ...
3
votes
1answer
67 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
41 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
70 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
36 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
85 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
42 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
123 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
54 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
50 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
55 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
55 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
32 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
47 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
270 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
151 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
33 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
470 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
63 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
55 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
23 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
114 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
191 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
70 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
64 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 ...