Stack Exchange Network

Stack Exchange network consists of 174 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
42 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
26 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 ...
0
votes
0answers
11 views

Remove Current Extent option in Query Tool of Geocortex

The Geocortex Essentials default Query tool has a Map Area dropdown in which two options are provided i.e. All and Current Extent.I want to remove the option of Current Extent from the dropdown Menu ...
1
vote
1answer
25 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
238 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
1answer
25 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
28 views

SQL Query OSM road types in a bounding box

I have a basic command that works to query all planet_osm_line features within a bounding box (running a PostgreSQL db of the entire OSM planet file) SELECT * FROM planet_osm_line WHERE ...
0
votes
0answers
14 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
19 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
43 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
10 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
45 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
38 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
18 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
34 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
19 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
67 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
17 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
28 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
46 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
128 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
73 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
74 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
27 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)!!
0
votes
3answers
416 views

Where is Query Builder in QGIS 3.0?

How to find the Query Builder in the freshly released QGIS version 3.0?
0
votes
1answer
78 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
60 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
14 views

using queries to return value for attribute while digitizing?

I've created a drag & drop form for digitizing point data. I'd like to fill in a value 1 in the attribute field for abundance if the condition for the field "colony" is set to "no" else should ...
0
votes
0answers
91 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
0answers
52 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
47 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 ...
0
votes
0answers
18 views

Running MS Access VB Module from ArcCatalog?

I created some VBA code that runs a make table SQL in MS Access. Whenever the MS Access database is opened it automatically runs the SQL and updates the table. I then created a database connection to ...
1
vote
0answers
45 views

Use current date of ArcGIS time slider as date input in query builder

I'm trying to formulate a query in ArcGIS query builder, returning only Features present in a certain year. The year should be definable by the user by setting the date in the time slider. My ...
1
vote
1answer
21 views

How do I query based on two tiff files in QGIS? [closed]

I'm using two raster (tiff) files of the Global Human Settlement dataset. One is representing the population in each cell, and the other one is representing the type of settlement (1=rural,2=low ...
4
votes
1answer
164 views

ArcGIS Select By Attribute with join returning extra, incorrect features?

I am attempting to run a simple Select by Attribute on a large File Geodatabase feature class (1,751,339 polygons) in ArcMap 10.6, but the query returns extra, incorrect records along with the ...
0
votes
1answer
17 views

QGIS 2.18.13 Points at intersections have More Information with the ID than what is in the database fields?

Created Point Feature Class at all street intersections. When looking at the database fields I only get two fields yet when i use the Info tool I get several paragraphs of information including the ...
1
vote
1answer
20 views

How to build SQL query in arcpy using script variable?

I am trying to build a simple query where a feature layer field needs to be smaller than a certain number and another feature layer field needs to be bigger than a variable previously created in the ...
0
votes
1answer
194 views

Querying multiple values in field using ArcGIS ModelBuilder?

This is part of a much larger project in modelbuilder. I want to use the make feature layer tool to query a field that has multiple values in each record. For example, the field name is "Animal" and ...
0
votes
0answers
18 views

Importing acad into arcgis

We have a project using ArcGIS 10.1 and silverlight and this project allows for the upload of ACAD files onto existing layers via the project. This had been working for years now however early last ...
1
vote
1answer
37 views

Selecting polygon feature classes with 1 record in ArcSDE using SQL query?

I have an ArcSDE database with many feature classes.I would like SQL query to find all the polygon feature classes with only record in its table. So far, i can only query all the feature classes. ...
1
vote
0answers
20 views

How to keep certain attribute table features selected while I clear my query builder? (QGIS)

Is this possible? I want to see all my points, and also select a few to stand out from the rest. This is for a school project. The instructions state to use query builder, go into a layer to select ...
1
vote
1answer
50 views

Why my query output misses one row?

My following query gives output of 72 rows which is correct. SELECT distinct on (st.gid) sv.timing, st.gid, st.area FROM servers sv INNER JOIN sites st ON (st_distance(sv.geom, st.geom)<8.5) ...
1
vote
1answer
32 views

How to get data from table and define the geometry on the same query?

My team is using DB2 database and I have to create and publish a map service in ArcGIS using one of the tables. The table has the XYZ column but no SRID defined in the table or database. The DB2 ...
1
vote
1answer
286 views

GeoServer WMS service CQL filter query with Mapbox GL

Is there any way to query WMS tile layer for Mapbox GL? map.addLayer({ 'id': 'wms-test-layer', 'type': 'raster', 'source': { 'type': 'raster', 'tiles': [ '...
1
vote
1answer
163 views

Query building - combining multiple fields and values

I'm using QGIS 2.18.16 and i'm learning to use the query builder to create my own layers. I have noticed two separate fields (name, building) which have similar category of values such as "schools, ...
4
votes
2answers
160 views

Sum Grouped by Query of Values from Field of Variable Length

I am trying to find the sum of watershed areas for about 30 small streams in BC. Each stream has a code that is the same as the code for its watershed. The code for each stream is derived by adding ...
1
vote
0answers
67 views

Nested polygon count and shapefile query [closed]

I have attached a subset of shapefile polygons with a number of nested polygons. Wondering How would I go about writing a query to figure out how many such nested polygons exists in one shapefile. I ...
0
votes
0answers
19 views

Query duplicate values from one field based on unique groupings in another field?

I have large amounts of dispatch data from which I want to derive time differences. However, even after sorting the data, I cannot (unfortunately) rely on the records being in the proper sequence, ...