Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [query]

A command used to retrieve information from a database

1
vote
1answer
32 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 ...
-1
votes
0answers
11 views

ArcGIS - how to query closed loop contours? [closed]

Once you create contours, is there a quick way to query only the ones that are closed loop?
2
votes
1answer
40 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
13 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
44 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
26 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 ...
2
votes
1answer
36 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
35 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
41 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
24 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
46 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' ...
0
votes
0answers
23 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
105 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
26 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
45 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
38 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
51 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
25 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
42 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
128 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
90 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
30 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
321 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
48 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
18 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
37 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 ...
0
votes
1answer
44 views

How can I show the roads that are below 10 ft elevations?

I have point elevation data and road layers for a region. I am trying to show the road sections that are below 10 ft elevations. How can i solve such problems with elevations? I am using ArcGIS 10.3.1....
1
vote
0answers
17 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
80 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
100 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
39 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
53 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 ...
2
votes
1answer
26 views

Turn Off the Query Ability at the Service Layer Level

I have a service with three layers that I publish to our Enterprise 10.6.1, from ArcMap 10.6.1. I know that when I publish the service from my MXD, I can check/uncheck the box in the Mapping ...
1
vote
1answer
106 views

ST_DWithin query throwing 42601 error?

I am trying to get from a particular point more informations about the surroundings (which are also points). So I wrote this: SELECT * FROM osm_point WHERE ST_DWithin(way,(ST_SetSRID(...
0
votes
0answers
18 views

Channel Easements for County: Need help with Query or Python

I have a layer for easements for a whole county and need to find each easement either MISSING or having a PART of what the county calls "STW_ARCS." These ARCS are what the county have data on for how ...
1
vote
1answer
20 views

How to query areas from DynamicMapService Layer…?

I have two dynamicMapServiceLayers, I have to query the area where three dropdowns are there. From a districts dropdown I have to select one district according to that mandals should be loaded to the ...
2
votes
1answer
29 views

Select by character limit

I'm using the select by attributes to find unique values that I am copy pasting from a spreedsheet. EX "jobnumber" = 1111116 OR "jobnumber" = 2222245 OR "jobnumber" = 5555655 .. etc The problem is ...
1
vote
1answer
74 views

Counting where multiple street names within polygon using MapInfo?

I have a dataset of address points with their associated street name, in addition to a tab file of polygons covering a catchment. I want to know if there is a way of selecting polygons which have ...
1
vote
1answer
205 views

Querying & filtering raster data from PostGIS using GeoServer

I'm currently working with raster data and serving it to a web application using Geoserver. I want to be able to perform queries to retrieve the raster data from a PostgreSQL database with the PostGIS ...
4
votes
1answer
103 views

clipping layer using query builder in QGIS

I have a global vector layer which includes several fields in the attribute table. I want to filter one field above a certain threshold and then clip the corresponding areas to make a new layer. I ...
2
votes
1answer
149 views

Using a subselect for ST_Distance query

So I am at a bit of a loss here, trying to get the distance in meters between a point stored in my table and a set of coordinates locations id | name | location(point) ---------------------...
2
votes
0answers
48 views

Attribute Values not showing when running a query

The attribute values are not displayed for the 'Model Number' field when running a query yet the attributes are stored in the attribute table(When I say all unique, nothing comes up)!!
2
votes
2answers
991 views

Where is Query Builder in QGIS 3.0?

How to find the Query Builder in the freshly released QGIS version 3.0? In previous versions (2.x), it could be found as mentioned in Displaying only selected features on map in QGIS?
0
votes
1answer
126 views

Issues flattening row from a table python

I'm trying to merge duplicates rows using this Python script. After I run the script I get this error and the output just drop the duplicates and it doesn't merge any duplicate row. I want to create a ...
1
vote
1answer
92 views

QueryTask doesn't return anything ArcGIs Javascript 3.24

I have a query that I believe I am setting up correctly, but maybe I'm missing a vital property. Does the where clause need to be set? I want to query all features, not a subset of them, so I don't ...
0
votes
0answers
165 views

Spatial Filter/query a WFS (qgis)

I am currently trying to make a query on a WFS layer, as described in https://docs.qgis.org/testing/en/docs/training_manual/online_resources/wfs.html . However, i want to do a spatial query. This ...
1
vote
1answer
30 views

Loading processed layers in QGIS

I am testing out Qgis (3.0) and have been unable to figure out how to reload a processed layer. For example I have a simple attribute query from some land use zonings where land use = 'PR'. The ...
1
vote
1answer
85 views

ArcGIS Arcade Expression: Data from a Service Query

This maybe not be possible but trying anyway. I have a Map Service with geometry features published. Two of the columns are 'Zone1' and 'Zone2' with values like 'ABC' or 'DEF'. The values of 'ABC' or '...
0
votes
2answers
49 views

Filter values to include features within a specific max/min range

I have a table of values that have a MIN and MAX integer value, i.e. I would like to select all values that range from Age_MIN >= 105 to Age_MAX <= 110. There are features in the table that ...