Questions tagged [query]

A command used to retrieve information from a database

108 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
600 views

PostGIS (Postgres 9.6) - order bounding box query results by date (large table)

I'm querying database entries using a bounding box with ST_MakeEnvelope and intersecting that with a coordinates column (type GEOMETRY), consisting of simple POINT(lng, lat) entries. I've created a ...
5
votes
0answers
888 views

How do I determine appropriate Date query syntax for a layer?

I'm writing a web mapping query tool to query Esri mapservice layers by date using the REST API. It has been said that the syntax depends on what kind of database is behind the mapservice layer, as ...
4
votes
0answers
35 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 ...
3
votes
1answer
846 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&...
3
votes
0answers
237 views

Automatically update the result of a QueryTask

I have developed a application using the ESRI JS API to allow users to create and edit features in a web map. I have used the QueryTask to create summary statistics to report back to the user on ...
3
votes
0answers
1k views

Select features within a country or bounding box effectively using PostGIS

I imported the planet OSM file into a PostgreSQL 9.2/PostGIS 1.5 server using osm2pgsql. I now want to select certain map features which lie within the bounding box formed by a countries borders, e.g. ...
2
votes
0answers
42 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 ...
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 ...
2
votes
0answers
40 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
0answers
39 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 ...
2
votes
0answers
206 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 ...
2
votes
0answers
100 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
0answers
66 views

in QGIS version 2.18.0, can we save queries for further usage on other data sets

In QGIS version 2.18.0, using Query Builder on attribute data, can we save the defined Query for further usage on other shp files with attributes. I tried selecting a layer> properties> query ...
2
votes
0answers
337 views

MongoDB: Faster alternative to a basic $geoIntersects query

I've got a whole bunch of political boundaries defined in a MongoDB collection, which are (as you might guess) very complex polygons, with thousands of points. One of the queries I need to run is to ...
2
votes
0answers
444 views

Label only one polygon in canvas/map view per category/value in attribute table

Question: In QGIS (2.18), how do you show only one label per field of view in the map canvas for each visible category (that is displayed in the map view/canvas at any given scale/focus) of a multi-...
2
votes
0answers
181 views

How to pass time dimension to postgis DB layer WHERE clause in Geoserver?

I have successfully configured a layer with time dimension that is backed by an SQL query to a PostGIS DB. I can query it through WMS, but I just can't find a way to pass the start and end time to the ...
2
votes
0answers
381 views

ArcGIS API for Silverlight : query that displays layer attributes in a dataGrid

I'm working with ArcGIS API for Silverlight to build a webmapping application and I'm trying to display my attributes in a datagrid. I made a try by using this code : void QueryTask_ExecuteCompleted(...
2
votes
0answers
660 views

Layer Definition Query - Subqueries

Background: I want to track the movement of icebergs in ArcGIS. In my FileGeodatabase I have a single Iceberg layer. What I have thought of is to create an ID field for each object; each ArcGIS ...
2
votes
0answers
131 views

Forcing Hash Join Query Plans using PostGIS

I'm currently testing PostGIS 2.0 in a Greenplum Appliance (Postgres 8.2 based) and have hit an incompatibility between PostGIS and the MPP Greenplum environment. The basic query below can't be ...
2
votes
0answers
2k views

How to fire a query from OpenLayers to GeoServer to fetch 'the_geom' column in PostGIS table?

I am coloring the polygon shapes of world_country. I have OpenLayers in my UI, GeoServer as server and PostGIS as db. All I want is fire this query: select the_geom from world_country where cntryname=...
2
votes
0answers
588 views

Cannot join feature layer with SQL Server table with query built in it in ArcMap

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder. When I ...
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 ...
1
vote
1answer
64 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
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 ...
1
vote
0answers
204 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
0answers
25 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, ...
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 ...
1
vote
0answers
81 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 ...
1
vote
1answer
43 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 ...
1
vote
0answers
251 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 ...
1
vote
0answers
104 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 ...
1
vote
0answers
62 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://...
1
vote
1answer
34 views

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 ...
1
vote
0answers
64 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
81 views

Selecting polygon feature classes with one record in Oracle geodatabase using SQL query?

I have an Oracle Enterprise geodatabase with many feature classes. I would like a SQL query to find all the polygon feature classes with only one record in its table. So far, I can only query all the ...
1
vote
0answers
28 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
0answers
424 views

Query data within KML

Bing Maps v8 will not load multiple or complex KML files and allow me to query data within these shapes. Is there a work around for this?
1
vote
0answers
20 views

Assigning one UNITID to multiple areas

I have a city wide water distribution network that will undergo a flushing process over the next couple of years. I need to keep track of what segments of pipe have been flushed. The work is divided ...
1
vote
0answers
73 views

Query on all layer features with boundlessgeo sdk

I'm currently implementing a webgis by using the reactjs components from the boundlessgeo sdk. I'm using the QueryBuilder component in order to query for features but It always performs the query on ...
1
vote
0answers
104 views

Using ArcGIS REST Service to query particular features inside BBOX?

I really have 0,0000... knowledge about OGC web services (WMS / WFS ; only limited basics). Therefore maybe this 'stupid' question. My question might be misplaced / or have the wrong tags... But it's ...
1
vote
0answers
82 views

around filter: at least x meters away from anything

With the around filter I can find things close to anything for example: way(around.golf_course:250)["natural"="beach"]; How can I form the opposite? I need things who are at least minimum x meters ...
1
vote
0answers
140 views

WFS harvesting GeoNetwork 3.2.2

I'm having an issue harvesting a WFS (GetFeature) endpoint using GeoNetwork. I can hit the endpoint through the browser so I know that's fine. When I create the harvester I enter in the "Service ...
1
vote
0answers
87 views

natural=beach without all the wrong tagged sand areas golf bunker or sandy places in zoos

I would like to get natural=beach (places along a body of water at best places where you can have a bath). Unfortunately the query natural=beach ends up often with wrong "single" tagged sand areas ...
1
vote
0answers
48 views

Finding points near other points using ArcGIS Server 10.2 rest API?

I'm using ArcGIS server 10.2. I published my point layer in my admin. I'm going to get json file from that points which are within a fixed distance with any points that I want. Any idea?
1
vote
0answers
38 views

How to add automatically a color for a query made in Access

I made an Access database with my polygons and my Exceltable with data about floods. I linked the specific row to my shapefile table and made a query table of it. With the manual way I gave the ...
1
vote
0answers
48 views

How to query breadwinning mothers in IPUMS USA microdata?

Overall goal: Map rates of breadwinning mothers throughout South Carolina. I haven't been able to find exactly what I need in American Factfinder. I am looking for something that comes close to what ...
1
vote
0answers
673 views

Leaflet map with 'query of features' on mouseover and multiple layers

I have produced two working Leaflet maps that in total contain the features that I need for my application. However, I cannot solve how to have multiple 'overlay' layers that can be queried with ...
1
vote
0answers
400 views

MongoDB $geointersecting big polygons!

I'm using mongo to store some geolocalized data, with the goal of retriving them using $geointersect. Specifically I have this document stored in my db: { "loc": { "geometry": { "...
1
vote
0answers
29 views

WFS altimetric curves that intersect geometry?

I have a WFS with altimetric curves and I would like to perform a spatial query. I would like to load from the WFS only curves that intersect or overlap a geometry from a shapefile, so only curves of ...
1
vote
0answers
311 views

How to get all pixel values of raster within a GeoJSON FeatureCollection in PostGIS

I need to extract all pixel values in a raster within a GeoJSON mask, using ST_Intersects. Attempt (throws invalid GeoJson representation): select row_to_json(t) from (select * from table_name where ...