Questions tagged [query]

A command used to retrieve information from a database

Filter by
Sorted by
Tagged with
3
votes
2answers
61 views

Customize QGIS interface

I'm writing here to ask some questions for a thesis project. My ideas are confused, but I'll try to be clear. I have a GIS project that represents some historical goods in a region. Each good has ...
2
votes
0answers
30 views

Getting distance between point and line with specific values?

I have a table named "housenumbers" that contains points with addresses fields, and one of them is "street_name". And I also have another table named "streets", that contains lines that are the ...
-1
votes
0answers
16 views

Refining Features from ArcGIS for Portal Webmap

I have a portal webmap with a few layers that i need to query so only matching results are displayed to the user. Portal webmap is accessed from a javascript webpage. I have found where the layers ...
-1
votes
0answers
20 views

Querying using Boolean operator in ArcGIS Pro [duplicate]

If it is possible in ArcGIS Pro to use a Boolean operator to select 2 raster values (in the same raster) at the same time, then how do I do it?
0
votes
0answers
22 views

Using Boolean operator in ArcGIS Pro [duplicate]

I have 2 datasets: Dataset1: raster = 6 classes of land use: water, forest, urban, agriculture, etc. Dataset 2: raster = 3 classes of risks: 1: low , 2: medium, 3: high What Boolean (logic) operator ...
0
votes
0answers
19 views

Using QGIS Queries With ArcGIS Server FeatureServer

I am trying to load USGS Transportation Vector Data from the US National Map data set. REST Link: https://carto.nationalmap.gov/arcgis/rest/services/transportation/MapServer If I use the feature ...
0
votes
1answer
97 views

Use single sign-on username in Web AppBuilder filter widget?

I have an Portal web map: Details: The map has a Web AppBuilder filter widget It uses single sign-on (SSO) authentication The map has a work order layer that is integrated from a Workorder ...
0
votes
0answers
15 views

How could I put drawing info in JSON file when I am creating query via ArcGIS?

I need GeoJSON file in order to use in qlik view. I am using ArcGIS map server and I created a query. But in my JSON File there are not the information related to drawing inf and I don't know which is ...
4
votes
1answer
63 views

Find nearby points in space and time

I have a table that has an ID, point geometry and time. It's basically GPS coords and some other data. I want to be able to select all rows that interact (come close in space and time) to my target ID....
0
votes
0answers
22 views

Return URL of a query on a feature layer using arcgis API

I am familiarizing myself with the arcgis API for Python, and I would like to view the query I perform on a feature layer as a URL: from arcgis.features import FeatureLayer from arcgis.geometry ...
2
votes
1answer
46 views

Changing color of columns names in query builder

Does anybody know if it is possible to change the colors of the names of the columns (attributes) when writing a query in QGIS? (e.g. when selecting by expression in the attributes table).
0
votes
1answer
39 views

Query to intersect polygons in PostGIS with points in MongoDB

Question: Is it possible to intersect geometries from No-SQL and SQL databases? Background: I need to delete the polygons from a PostGIS database that intersects with points (Lat/Long) in a MongoDB. ...
1
vote
1answer
24 views

Create Query either using Select by Attributes or Python [closed]

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
60 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
35 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
65 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
92 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
42 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
70 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
38 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
40 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
44 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
58 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
161 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
112 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
31 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
27 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
30 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
22 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
86 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
45 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
53 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
35 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
74 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
42 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
78 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
42 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
25 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
96 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
45 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
128 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
78 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
53 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
68 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
57 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
33 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
51 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 ...