Questions tagged [query]

A command used to retrieve information from a database

Filter by
Sorted by
Tagged with
2
votes
1answer
40 views

How to do a layer/ shapefile filling of thickness / transparent by value in QGIS?

I have a shapefile with 500 rows. My goals is to assign each row a specific value of transparency. I know I can group these and then manually assign a transparency to these groups, however I want to ...
0
votes
0answers
15 views

CMV URL Query String code/format

I am trying to pass a url query to query and zoom to a feature and I'm having a hard time doing so. I've followed a few threads on this with no luck: https://github.com/JoelHearne/CMV_InitZoomer Pass ...
3
votes
2answers
73 views

Using wildcard to find similar values between two fields with ArcPy cursor

I am using ArcMap 10.8. I have joined two street tables and am trying to correlate a couple fields. One field has a full street description ("FullStreet") and the other simply has the street ...
0
votes
0answers
38 views

Query builder - IN function returning zero rows

I have a layer of several areas (polygons) each having a unique number, I want to make a new layer only containing some of the areas. I made a duplicate of the original layer and went to query builder ...
1
vote
0answers
29 views

How to solve parse error in pgAdmin4? [closed]

I am currently trying to add Point geometries into a table. My query is the following UPDATE postal_code.postal_codes SET geom = ST_GeomFromText('POINT(' || lon || ' ' || lat || ')',4269); ...
0
votes
1answer
47 views

ArcPy - Select by Attribute for string doesn't work

I am developing a Python script, in which I want to select features based on an attribute, which is a string. I tried for hours and used a hundred different ways, but I always get the Error 000358 ...
1
vote
1answer
22 views

Customising a marker after performing a spatial search query

I'm have a geodjango app that uses leaflet for a front-end. I have integrated the search function on the front-end to be able to search a customer location in real-time, of which the code below does ...
0
votes
0answers
22 views

Python query optimization for OSM

I constructed a python query to look for all the bus routes passing by a given box. However, I need to speed up the query as much as possible. I only need the lat/lon coordinates of each node ...
0
votes
1answer
53 views

QGIS Query Builder button greyed out [closed]

I want to query features under [Layer Properties] -> [Source] -> [Query Builder] but the query builder button is greyed out. The layer I'm using is from a shapefile with multiple demographic ...
0
votes
1answer
16 views

Find number of features in ArcGIS MapServer layer

Given an ArcGIS MapServer layer URL (eg https://gis.dallascityhall.com/wwwgis/rest/services/Sdc_public/Zoning/MapServer/15), how can I find (preferably in JSON format) the number of total features in ...
0
votes
1answer
29 views

Querying for all rows that have the pattern of a constant value in one field but different values in another field using ArcMap

In ArcGIS (ArcMap 10.8 or Pro 2.6) I have a table of 4000 buildings (rows). Each row/building belongs to one of fifty groups and thus has a group ID of 1-50 in the field GROUP_ID. Each row also has a ...
0
votes
0answers
21 views

Creating an Arcade expression within a feature service

I am trying to query a set of points in relation to a polygon feature service. For example, I have dataset "A" within an RDMS that I want to query and get a count of features within Dataset &...
3
votes
1answer
116 views

How to dynamically query and visualize PostGIS data using GeoDjango and OpenLayers?

I am trying to implement dynamic query functionality in GeoDjango and OpenLayers. First, I filter the data and return it in GeoJSON format using Django serialize. Then, the return GeoJSON data ...
1
vote
1answer
94 views

Filter (query) OSM .pbf file in QGIS graphical modeler or Python (QuickOSM or related tools)

I would like to automate a simple operation in the QGIS graphical modeler or a simple Python script. add all line features from a .pbf file filter all features with certain values within a certain ...
0
votes
1answer
27 views

How to build a GET request from a CSW POST request

For accessing some data in a GeoNetwork metadata catalogue using CSW, I would need the URL for a GET request that would include also a geospatial filter (bounding box) and a time of interest (start ...
2
votes
0answers
41 views

Querying over multiple bands at one point

I have a multiband raster in PostGIS. I can obtain the value for a specific band at a specific point with SELECT ST_Value(rast, band, ST_SetSRID(ST_MakePoint(x, y), srid)) FROM table; I have 12 bands ...
0
votes
1answer
22 views

Query Items by Type

I'm having trouble with queries in my app. If you look at this page you'll notice the 'Search by Item' drop-down is blank and the 'Search by Category' displays 'Select one' by default. And when you ...
0
votes
0answers
75 views

Passing track_total_hits Param via WFS Query through GeoServer to ElasticSearch Backend

We are executing WFS 1.1.0 based queries via a GeoServer instance (2.18) backed by an ElasticSearch datastore (v7.x - not sure of the specific version), and are looking to retrieve an accurate Hit ...
0
votes
0answers
80 views

Labelling point elevations of raster (DEM) using QGIS

I'm trying to create a map with spot levels using an underlying 1m resolution DEM TIFF file. My thought process so far is to create a grid of points with a height value field over the area of interest ...
3
votes
1answer
108 views

Calling PostgreSQL procedures or functions from QGIS' Query Builder

I am trying to call either a stored procedure or function defined in the PostgreSQL/PostGIS database and use it from the QGIS Query Builder. Neither work: the function returns a table that cannot be ...
2
votes
0answers
105 views

QGIS Temporal Controller - last/most recent object within a temporal frame

i am working with temporal controller for just a cluple of days - before i've been using time manager. right now i am searching for a way to display the last/latest/most recent feature within a time ...
0
votes
0answers
76 views

Filtering layer in Query Builder with array from other layer using QGIS

I have the following situation using QGIS 3.4: 'Layer 1' with lines and a field ('Field X') and 'Layer 2' with points where values in a 'Field X' are available. Now I would like to filter all points ...
2
votes
1answer
44 views

Creating Virtual Layer with only desired fields

My question is very similar to this one. The difference being I want multiple fields where they wanted only a single field. I'm trying to create a virtual copy of my layer with only the following ...
0
votes
0answers
13 views

Getting all services for different years in GeoNetwork

I have some referential data services like country. I have different versions of my country service for each year (geometry or attributs update) (country_2020 ; country_2012 ; country_2010 ; ...). In ...
0
votes
0answers
39 views

Query geodatabase with PostgreSQL to show - schema, table, column, domain name

How to query geodatabase system tables using PostgreSQL to result this: schema, table, column, domain name I found this, but nothing for PostgreSQL https://desktop.arcgis.com/en/arcmap/10.3/manage-...
2
votes
1answer
47 views

Search for a word in FAT with QGIS

Using QGIS 3.10 I need to select all points that have the word fium and its variace like fiume, fiumara, FIUME, etc. The name of field is toponimo, I've used this query: "toponimo" = '%...
0
votes
1answer
146 views

Execute loop in PostgreSQL query

How to execute for each table in the list one fixed query replacing just %table% in PostgreSQL (like variables and loops) sql = 'select * from $table$ where...some_filter' $table = {tb1, tb2, tb3...}...
2
votes
1answer
61 views

Left join resulting in weird output in QGIS's Virtual Layer

I want to join two layers, a polygon layer "plan" and a point layer "education point". My goal is to join the data from "education point" layer to the "plan" ...
2
votes
1answer
62 views

Query to select attributes except specific fields [closed]

What is the expression in ArcGIS to select values except for specific attributes?
1
vote
1answer
125 views

Filtering Multiple Features in QGIS

How do I select multiple features in a vector layer using the Query Builder in QGIS? Using U.S. Census geographic data, I'm trying to select a large number of specific block groups using the GEOID ...
0
votes
0answers
11 views

How to let public query Enterprise Data in ESRI Webapp

I've got a webapp set up to display the information on backflow preventer devices in our city, but would like the public to be able to track their own information. Currently, they have to enter their ...
6
votes
1answer
71 views

Merging some polygons when creating Virtual Layer

I have a polygon layer 'lot' containing an attribute "lot_number". Then, I want to create a Virtual Layer that merges some of the lots while keeping others separated, as the diagram shows ...
0
votes
2answers
83 views

Not working formula in Query Builder (Filter)

I have been trying to filter a big dataset based on multiple values. The idea is to extend the formula as put in the image below. But even the first part doesn't work. When I do: "...
2
votes
1answer
120 views

Group geometry points and create a linestring for each group

I have a table of points at a Postgres database that have two main columns (geom geometry, time timestamp). I need a query to retrieve as linestrings or as array of the geometries the points that are ...
0
votes
0answers
26 views

Intersections between two Linestrings - SpatiaLite

I have two LineStrings and would like to draw the point of their intersection. The two lines are similar to this: LINESTRING(445798.43 6153379.87, 445892.89 6153340.08, 445987.35 6153300.3, 446081.82 ...
0
votes
0answers
103 views

Problems when trying to retrieve information from ArcGIS Map Image Layer instance by query (JavaScript)

Having a hard time getting access by query to the information included in a Map Image Layer object. I am trying to work with the following map image layer instance: http://banedanmark.maps.arcgis.com/...
1
vote
2answers
195 views

Overpass API Python wrapper (incomplete polygon error)

I am trying to use the following query to get all buildings from the given area in OSM with the Overpass Api, but I am receiving an "Received corrupt data from Overpass (incomplete polygon)" Error. ...
0
votes
1answer
53 views

How to Use ST_MakeLine query in leaflet to connect to Carto

I want to run in leaflet a query that works in carto Builder to connect points in a line: SELECT ST_MakeLine(the_geom_webmercator) as the_geom_webmercator, min(cartodb_id) as cartodb_id FROM my_table ...
0
votes
0answers
57 views

Reader character encoding problems in Oracle layers with where parameters in FME Desktop

I am using FME Desktop 2020 and trying to read an Oracle layer with -where- condition but i have problem because it failed with reading of character Ë or Ç. I get this error: ORA-01756: quoted ...
0
votes
1answer
64 views

QGIS 3.x issue with PG hstore colums

I have a PostgreSQL 9.6 database with tables created by imposm that include a hstore column. This hstore column looks fine in pgAdmin4. In QGIS 3.6 or 3.12, it shows up in the attributes ...
1
vote
1answer
61 views

Get all rows that have geometries which intersect with a geometry in any row of a different table in an effective way

I have two PostGIS tables containing thousands of geographic polygons each (each row has one polygon and numerous other attributes). Both tables represent different data sets but cover the same area ...
1
vote
1answer
89 views

Intersection/Addition of multiple tables in PostGIS

I want to intersect multiple table together. For each intersection geometry, I want to sum the value of all the layers intersecting at that place. My current query does it by step, getting the ...
0
votes
0answers
28 views

Identifying State Parks in the PAD-US dataset (Protected Areas Database)

I'm looking to map "State Parks," and I found this phenomenal, but complex database. Has anyone ever worked with the PAD datasets before? (or know any easier way to map State Parks?) In the PAD ...
1
vote
0answers
32 views

Fast solution to load and query shape files

I work on a .net core web API application collecting fishing events with latitudes and longitudes. For each of these positions, I need to compute the corresponding Exclusive Economic Zone (EEZ), it's ...
0
votes
0answers
95 views

GeoServer WFS buffer function

I am trying to check intersection with buffered area of shape: --This works &cql_filter=INTERSECTS(shape, POLYGON((-90 40, -90 45, -60 45, -60 40, -90 40))) --This does not &cql_filter=...
1
vote
1answer
89 views

QGIS - selection with data from excel

I have a line layer with roads. Every road has a unique start and endpointnumber, as attribute. From this layer I want to select some roads. Therefore I have an excel table with start- and endpoint, ...
0
votes
1answer
130 views

Alternate of intersects ?# operator in postgres

Is there any way to find if a path is intersecting with a box in postgres without using ?# or using an alternative? I have this query below and hibernate's EntityManager is throwing an exception ...
0
votes
1answer
117 views

Oracle query using 'with' keyword fails in ogr2ogr

I am trying to return a spatial resultant by throwing a fairly long and complex query at some datasets in an Oracle database, and returning a resultant via ogr2ogr. The goal is to return a resultant ...
1
vote
1answer
71 views

Converting a text (lat/lon) to a point or geography

In my table I have a column filled with text type lat/lon entries. I want to convert these entries to a point? Or something I can use with PostGIS functions I am aware of SELECT ST_PointFromText('...
1
vote
1answer
40 views

Query to find road paths of area [closed]

I am trying to find road information of COLAC region.My query is not working. area[name="COLAC]; way(area)[highway=living_street]->.streets; ( way(around.streets:150); node(around.streets:150);...

1
2 3 4 5
12