Questions tagged [query]

A command used to retrieve information from a database

Filter by
Sorted by
Tagged with
-1
votes
0answers
13 views

Data in pgAdmin 4 [closed]

I have been faced with a problem. I want to create a table that contains data in pgAdmin4 to query it. This type of data I will show below. this type of data How can I do this?
0
votes
1answer
31 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
54 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
24 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
26 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
56 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
45 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
34 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
40 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 ...
0
votes
1answer
29 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
34 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
24 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
21 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 ...
1
vote
0answers
25 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
56 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
50 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
68 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
58 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
33 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);...
0
votes
0answers
62 views

Finding buildings information with Google maps?

I am trying to extract buildings (houses, supermarkets, etc) information (latitude,Longitude) for COLAC region. However, the tagging information is incomplete in overpass turbo. For instance, there ...
0
votes
0answers
22 views

QGIS query tool with graphical modeler

I search a possibility to save querys, that other users can use them. For example: I have a polygon layer with different columns:area, id and owner. Now I want to search in my layer a specific owner ...
0
votes
1answer
125 views

Getting specific airport information with Overpass API

Hello I am new to OpenStreatMap and Overpass API. I would like to make a query in such a way that I can specify an airport name (for example: wien flughafen austria or the ICAO code) and get nodes, ...
1
vote
0answers
68 views

Powerlines query in overpass turbo

Kindly advise or assist, I want to achieve following in overpass turbo: Map/display transmission lines (power=line) and distribution lines (power=minor_line) of a specific area in map. I used below ...
1
vote
2answers
61 views

Using PostGIS to map multiple GPS tracks

I have a table which contains GPS track points from multiple vehicles. What I want to do is to produce GeoJSON polygons to overlay each trip on a map over a range of dates. My GPS table contains: ...
0
votes
1answer
42 views

Make PostgreSQL recover two geometry coordinates points split into columns

So I want to make a SQL that converts my PostgreSQL coordinates (x1,y1,x2,y2) to 4 different columns. By now this is what I have: trim ('MULTILINESTRING((' from (split_part(ST_AsText(SSDMT.geom), ' ',...
0
votes
1answer
39 views

SQL query builder in QGIS 3 doesn't display columns names

I'm creating sql queries using QGIS 3.8 DB Manager. The problem i'm facing is that when I write a query, I don't have any option to display the columns names : Is there any way to display the ...
1
vote
0answers
24 views

Locating points based on location and attribute difference using ArcMap

I am not sure if this is feasible or not but here is what I am looking to do: I have a point feature class where a certain set of the points all fall within 10-15 feet of another point. Ideally, ...
4
votes
0answers
33 views

Why does the order of queries matter in overpass?

I am new to overpass / OSM. I want to locate Dodo Pizza in Moscow, a specific chain of fastfood. Since these restaurants are sometimes tagged by brand and sometimes by name, I ve included a or ...
2
votes
0answers
31 views

Selecting a line segment with an azimuth value closest to the azimuth value of another line segment in QGIS

I have a road network dataset and a dataset that consists of multiple disconnected lines of varying lengths in QGIS. Most of these lines are (largely) parallel to the road network, but their shape ...
2
votes
1answer
52 views

Always syntax error using query builder - QGIS3

I have a problem with QGIS 3.4.12. As you can see in the image below, it's not possible to execute queries using query builder, because there's always a syntax error. This only happens using this ...
1
vote
1answer
73 views

Postgres ST_Distance_Sphere Runtime Improvements

I need to select all entries from a table, that are within a distance from a point. Each entry is a point geometry (I set a gist index on geom). Current runtime is anywhere between 3-15 seconds, ...
2
votes
0answers
66 views

LIKE operator is not case-sensitive in Filter query for shapefiles (QGIS 3.4) [closed]

When I try to filter local shapefile with Query Builder (right-click on layer > Filter) using LIKE operator (which should be case-sensitive) it does not work properly. For example query "place_name" ...
1
vote
1answer
43 views

Sort and create attribute field to the shapefile

I am creating a shapefile layer and adding an 'Area' attribute field using the following script: # Create shapefile layer drv = ogr.GetDriverByName("ESRI Shapefile") dst_ds = drv.CreateDataSource(...
0
votes
0answers
32 views

How to get geometries from this query

Im struggling with this SQL query, from Measure collected polygons in Geometry Generator, avoiding extra texts from multipart polygons. It used to work OK sometimes in some datasets; throw errors on ...
1
vote
1answer
135 views

Accessing PostGIS geometry with psycopg2

I've a PostGIS database loaded with several tables filled with shapefiles. I'm using psycopg2 to access everything via python. I'm able to access the table names with the below query: """SELECT ...
1
vote
1answer
58 views

QGIS - Execute SQL Failure

I've written an SQL query which works in the query section of the QGIS DB Manager. SELECT Max(S_order), SegmentID, S_Order, Length, Buff_Segme, Buff_Order, Buff_Lengt, Buff_Uniqu FROM "...
3
votes
2answers
132 views

Overpass API query: Get streets in city limited to a particular country

I am working with a self-installed version of the Overpass API. I need to be able to query all street names in a particular city, Inverness in the United Kingdom (GB). There is also a city called ...
1
vote
1answer
23 views

Cleaning SQL queries [closed]

I have a bit of SQL code that look similar to this: SELECT sum(case when latitude = '0' then 1 else 0 end) as count_zero, sum(case when latitude is NULL then 1 else 0 end) as count_null, sum((case ...
2
votes
1answer
40 views

Selecting more than one country to be highlighted

I can get a one country within a world shapefile to highlight, but when it comes to adding additional countries this just turns all countries back on I am using query builder to achieve highlighting ...
2
votes
1answer
226 views

OSM + PostgreSQL Queries

I'm newbie to PostGIS and am looking for some SQL examples for better understanding. I didn't understand how do I manipulate the tables, how objects relate one to another. An example: There is this ...
0
votes
0answers
13 views

Pulling road centerlines and parcel boundaries for specific county and exporting them to DXF file using QGIS

I am very new to QGIS. I want to pull road centerlines and parcel boundaries for a specific county, and export them to a DXF file. I need to have Road names included. I have found the data I ...
0
votes
3answers
75 views

Is it possible to dynamically construct the SQL query where clause in ArcGIS layer based on the URL parameters?

I have an ArcGIS layer published to my local server at: https://baseURL/myMapServer/0 I want to dynamically construct the query where clause for this layer based on the URL. For example: https://...
0
votes
1answer
56 views

QGIS Select by Expression Parser Errors

My goal is to select all of the features in a layer with certain names. I have a list of 86 Subdivision names and a I am using a county Subdivision dataset, the names in the dataset include the ...
1
vote
0answers
33 views

Spatialite queries not loading entirely on canvas

I connected a SQLite database to my QGIS project. I wrote a query in the DB manager whose result contains 261 elements. Then, I tried to load the result on the canvas (from the load button at the ...
0
votes
1answer
99 views

Querying Landsat 8 night images in Google Earth Engine? [duplicate]

Apparently, Landsat 8 occasionally acquires images at night-time during ascending passes. However, in the Google Earth Engine data catalogue (https://developers.google.com/earth-engine/datasets/...
2
votes
0answers
41 views

selection expression to display the first 5 rows only in QGIS 3.8.3 [closed]

I would like to display the first 5 rows only in QGIS 3.8.3 from the attribute table of a layer in ascending order. I tried many selection expressions, but, none of them seems to work. Is it ...
2
votes
1answer
48 views

Match by location and attribute in QGIS?

I have 2 different layers. One layer is the field layer which contains field agronomic data, name, variety, etc. The other layer is a layer with about 2000 polygons. Each polygon is tied to a ...
2
votes
1answer
44 views

Identifying layers under cursor in QGIS?

In QGIS 3.8, I've loaded hundreds of layers (georeferenced individual images), which are named by filename. I'm looking for a way to click on the map and query what image (i.e. what layer in the "...
0
votes
2answers
125 views

ArcGIS JavaScript 3.3 add ArcGIS REST API Queried Feature Layer URL as Layer

Using the Query Generator on an ArcGIS REST Feature Layer, I generated a URL that filters the data by a geometry extent ({xmin: -104, ymin: 35.6, xmax: -94.32, ymax: 41}) This returns Current River ...
2
votes
1answer
265 views

QGIS- What is the meaning of the Query Builder operators?

I am learning to filter my data, and I understand how to use the basic operators (e.g. =, OR, AND, !=, less than, more than etc) however there are some operators that are less obvious. What do the ...

1
2 3 4 5
12