A command used to retrieve information from a database

learn more… | top users | synonyms

0
votes
0answers
12 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": { "...
2
votes
1answer
41 views

Default PostGIS type of geometry in SELECT

Is there an option in PostGIS (in query or table option) to set the return type of a Geometry? I'm using this query: select * from "locations" where "locations"."id" = 2 limit 1 And that will ...
0
votes
0answers
32 views

QGIS Custom Query Plugin

I am very new to QGIS plugin development. Is it possible to create a custom form (Field will be fixed and User can select only operator and enter value for field) to do custom attribute expression ...
0
votes
0answers
22 views

line_locate_point: 1st arg isnt a line

i used this query for routing procedure SELECT pgr_nodeNetwork('edges', .006); I am following this workshop http://workshops.boundlessgeo.com/tutorial-routing/ and this is the error, I can't ...
1
vote
1answer
19 views

How to update a line attribute in PostGIS using an attribute from the polygon in which it is contained?

I have a road dataset which I want to update using the speed information from the state polygon in which it's contained. for all roads (line) within a state (polygon) if the road speed is null road ...
1
vote
1answer
42 views

Speed up spatial query on large table on psql

How to speed up spatial query on large table of bytea. I tried the suggestion from this website to create an index using b-tree GIST but the index is exceed the maximum size of 8191. Any ...
2
votes
1answer
60 views

select living-end-streets from a local osm-road-extract with QGIS

I am looking for a method or query to select living-end-streets from a local osm-road-extract. Living-end-streets are dead-end-streets for cars but cyclists and pedestrians can continue on their way. ...
2
votes
1answer
53 views

Query over all layers in a mxd Arcpy

A newbie to python here. Ive been trying to query all layers on a mxd and have sucessfully implemented a script by advice on here. What I need to do now is to firstly make the query a parameter that ...
0
votes
0answers
31 views

Postgis Database: How can I get all gps points between specified timestamps and specified region?

I am totally new to DBMS. I have traces of vehicles in different csv files for each user. Format: name,timestamp,latitude,longitude. 1) How to implement RANGE Query which asks for all the gps points ...
0
votes
1answer
23 views

PostGIS query with external bounding box

I am editing a shapefile as wide as an island. The data are stored in a Postgres/PostGIS database. I want to display only features from my defined bounding box. The bounding box itself is a custom ...
3
votes
1answer
79 views

PostGIS crosstab on multiple point tables

I have several point tabels, lets say 3. Tables are alike with two columns: a integer value and a geometry like: table sand1 (value int, geom geometry) table sand2 (value int, geom geometry) table ...
2
votes
1answer
55 views

Using function to query text field in ArcGIS Select By Attributes?

I can do this: And get result: On the other hand, when I do this: I get an error message: Why query using function is working on numeric field and is not working on text in both shapefile ...
1
vote
0answers
12 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 wfs only curves that intersect or overlaps a geometry from a shp,so only curves of a specific ...
4
votes
1answer
35 views

Filter a range number in Query Builder of QGIS 2.8.6

I need to filter features that have attributes that start within a relative number range. I am using brackets to filter the range of numbers, but it does not work me. This is my query: CASE WHEN "...
4
votes
1answer
51 views

Change entire label style after certain extent

I need to design a dynamic label in ArcMap that changes its entire style after a certain zoom extent. The research I've done suggests to me that there is currently no way to use VBscript to manipulate ...
1
vote
1answer
51 views

Recurring SQL Expression Parsing Error on Query Builder

I am using Query Builder in QGIS 2.14.2-Essen to select one country (Peru) among 237 for which to show two layers (states_provinces, boundary lines) from the Natural Earth database. I am paying close ...
0
votes
2answers
33 views

Proper handling in PostgreSQL/PostGIS only after many queries?

I am trying to analyze GPS data of a parade on a fixed route with a certain variance due to the urban surrounding (canyoning). I'd like to project the GPS waypoints to the nearest points on the route ...
1
vote
0answers
30 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 ...
3
votes
2answers
43 views

Search for textbits in QGIS

Is there a way to search for only parts of text in QGIS. Imagine I have a field in my attributetable called myField and I have several entries there, something like This is awesome Even more awesome ...
1
vote
1answer
24 views

How to get the geometry of all tables in a postgresql database?

How can I return all tables geom?
1
vote
0answers
27 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 ...
1
vote
0answers
25 views

Selecting cells with values from DEM those are above specific value corresponding to each polygon?

i have a shapefile with 2000 polygons and a DEM. i want to calculate zonal mean for each polygon considering values from DEM which are above a particular value for each polygon. i want to it with ...
2
votes
1answer
66 views

Changing Query Layer's SQL Expression with Python

I use query layers in ArcMap 10.4. The maps need to be done/repeated periodically. The easiest way is to copy the map, change the source's SQL expression (e.g. from select * from TABLE where Period = '...
0
votes
0answers
32 views

How can I determine an appropriate query based on a join?

I am having trouble coming up with a query that will show the 12 states total population percentage in ArcMap 10.4. I created the spreadsheet below and I have already joined my excel to the states ...
0
votes
1answer
32 views

Search widget expression

I am trying to migrate my Flex eSearch widget to the CMV Search widget. The query is not working. What can I do to make it work? Flex query: <value prompt="Example: MN or MNPC">upper(...
1
vote
2answers
61 views

Calculate area parts of polygon intersections

I have a problem of calculating area sizes of intersected polygons in postgis. I would represent the problem in an example (please see the picture). I have a gridsquare table with some attributes like ...
3
votes
1answer
28 views

QGIS: Error message in query builder

I am using QGIS version 2.14.1 (Essen) and trying to update data in my table using field calculator. I am inputing the following statement: update "table_1" set "table_1" ='y' where "table_2" ='...
1
vote
2answers
50 views

How to specify two different and separate conditions in query builder?

For example, I have a table containing well log data for multiple operable units. I would like to make a query outputting a table where Operable unit=001 OR 002, AND Formation= Residuum. I would ...
0
votes
0answers
14 views

How can I create a definition query to show the next 5 years of data, based on a text field with the year on a joined table in SDE?

I need to show the next 5 years of construction data, but I want it to automatically update what is shown based on a text field called ConYearStartNbr that shows when the construction is set to start ...
2
votes
1answer
91 views

SQL / Select by Attributes query for “does not include text found in another specified field”

I'm using ArcMap 10.2 and I'd like to write a query to select features where Field A does not include text found in Field B. Specifically, Field A contains street numbers and street names. Field B ...
0
votes
0answers
70 views

Accessing array of x,y coordinates stored as MDSYS.SDO_GEOMETRY / PUBLIC.SDO_GEOMETRY attribute in Oracle 11g?

I am totally new to GIS. I am working with a table in an Oracle 11g database. In each row of this table there are two attributes of interest: one is of type MDSYS.SDO_GEOMETRY and the other PUBLIC....
1
vote
2answers
50 views

Using PostGIS to query shape files

I am very new to PostGIS (started using it this morning). My goal is to determine if a lat/long point is contained inside a polygon that is described in a shape file (The shape file has a single ...
0
votes
1answer
50 views

how to skip creating an empty feature class using featureclass to featureclass in arcpy

I have a script that finds points outside of selected areas and creates a feature class in a file geodatabase. However, sometimes there are no points outside of the selected area. Currently, the ...
1
vote
1answer
58 views

Use spatial queries on multiple layers in QGIS

Is there a way to perform spatial queries on multiple layers in QGIS without going through an external database? I would like to perform SQL-like queries on layers imported in QGIS directly, but can't ...
1
vote
0answers
31 views

Testing Oracle query produces valid results in QGIS Python Console

I have a query that searches an Oracle database using a where clause to get the geometry of an object and then zooms to the extent of that object. The value for the where clause is retrieved from a ...
1
vote
2answers
85 views

How to add state polygon information to a city point?

I have the following layers: Country border federal state borders cities (located as points) I would need the following result file (txt or csv..): A column with the name of the city and another ...
5
votes
1answer
212 views

How to build a query/expression to select specific points within a buffer? (in QGIS)

I have a point layer in QGIS. Each point represents a tree and each tree has information about its height as an attribute. I would like to build a query/expression to select all those trees that have ...
1
vote
1answer
72 views

query.where statement using date range in JS API fails with IE 11 but works fine with Chrome and Firefox

My aim to display point data from a feature layer on ArcGIS for JS map interface. I am successful doing so in Chrome and Firefox, however when I include date in a where condition of a query execute it ...
3
votes
2answers
242 views

Selecting more than 1,000 features from AGOL hosted feature service?

When data from a cloud-hosted feature service is loaded into ArcMap, it queries the first 1,000 features "to enhance performance"... I, however, need to see all the features. How can I add all ...
3
votes
1answer
128 views

Distance in meters between two geographic coordinates

I want to determine the distance in meters between two geographic coordinates. The points are: Lat (deg) Lon (deg) A: -33.3930906 -70.5452765 B: -33.3993212 -70.5468767 So if i calc the ...
0
votes
1answer
60 views

How can I add a new layer, then remove previous layer from a Leaflet/CartdoDB map without the map clearing everything

I am new to CartoDB/Leaflet. Here's my fiddle... http://jsfiddle.net/zippyferguson/fLkqgf4q/1/ If you click the play button, I want it to load data to the map year by year from 1966 to 2015 from a ...
0
votes
1answer
65 views

Arc 10.2.2 crashes when adding query layer?

I'm trying to add a query layer from an Oracle database into a blank 10.2.2. map. I enter the query, validate, finish, and the software thinks for a second and then just winks out. No error message,...
1
vote
1answer
58 views

Creating a menu interface to update an sde feature class in ArcMap using arcpy?

I work in electrical utilities and we have stacks of paper records that need to be updated into an existing SDE feature class attribute table. My problem is that someone in the city's GIS office would ...
1
vote
1answer
70 views

Making table from MySQL query with ArcPy?

I am trying to interact directly with data from a MySQL database in ArcMap using Python. So far, I have successfully connected the database using the MySQLdb.connect() function and have successfully ...
2
votes
1answer
57 views

QGIS and intersections

I have MultiLineString geometry data from an ESRI shapefile. I also have a polygon (region) that I have created in QGIS using the drawing tools. When I attempt to find the intersection between the ...
1
vote
1answer
79 views

Postgis/SpatiaLite SQL query to connect MySQL, Access or Oracle database

In SpatiaLite or Postgis, how can one create a SQL query to read a table from a MySql or Oracle database? I don't know **the correct SQL syntax to connect to a table in a MySql or Oracle database **....
1
vote
0answers
33 views

Shape comparison language (SCL) - get shapes which intersect extent border

I am trying to write a SCL string for my ArcGIS query, which should return only shapes which are intersected by a border of a rectangular shape (extent). So far the closest I've got is the following: ...
0
votes
3answers
121 views

Pass GeoJSON from .NET to Javascript

My .NET/OpenLayers/GeoServer/PostGres-PostGIS application allows users to create custom queries to get data from my PostGIS tables. The queries are called in .NET (not javascript) using a web method ...
1
vote
1answer
174 views

PostGIS Query To OpenLayers

I am trying to get data from a PostGIS datatable using .NET, pass it to javascript, create a layer in OpenLayers and add the PostGIS data to the layer. I can successfully query from the PostGres/...
1
vote
1answer
89 views

How to make a SQL query that would sum multiple records in ArcGIS?

I've got a large file geodatabase that contains a polyline feature class of water-pipes. The feature class have many fields, but the ones that I'm interested in is that of the water-pipe's Length and ...