A command used to retrieve information from a database

learn more… | top users | synonyms

3
votes
2answers
80 views

Copy/convert selection into filter/query builder of QGIS?

Can anyone tell me if it is possible (and how) to convert or copy a selection on a layer (that has not been created through "select by expression", but instead by irregular selections from a canvas, ...
1
vote
0answers
41 views

Find points within X distance with a specific variable

I am trying to use QGIS to find points within 5 meters of each other that all have a value of <50% for a given parameter that has been loaded through a CSV file. I looked in to doing it with a ...
1
vote
0answers
36 views

Overpass output city name instead of coordinates?

I did a query to look for certain things. However it only outputs the lat and long coordinates, there is no city data available. I'd like to have the city it belongs to / closest city though. I know ...
2
votes
2answers
101 views

Count Distinct with Where clause in OGR

I am looking to run a query in OGR to write back all instances where there is only one record of an attribute. I was thinking that I would use the following: ogrinfo -dialect sqlite -sql "SELECT ...
6
votes
2answers
249 views

ESRI Javascript FeatureLayer Select by Attributes

I am trying to select a group of features in an ESRI javascript API featureLayer by attribute. The call errors out. My code is as follows. Here is the layer definition: var fieldDefs = [{ ...
1
vote
1answer
53 views

Delete polygonal features in one layer outside polygon feature of another layer in PostGIS

For deleting polygonal features in one layer (~1000000 features) outside polygon feature of another layer (one feature) in PostGIS I use query: DELETE FROM layer WHERE layer.id IN (SELECT a.id FROM ...
0
votes
0answers
71 views

Publish postgis raster based on column value in geoserver

I have a postgis raster table with the following columns: rid, rast, year, plant I created a wms layer in geoserver pointing to the table and successfully serve out the raster when the table only has ...
0
votes
0answers
68 views

Overpass-API Ability to download the nodes and ways that intersect the ways of one relation

i am trying to do a query that will detect if a node or way that is included in a relation is also referenced by other ways,nodes or relations. Not sure if this is possbile, i had tried to do this ...
1
vote
1answer
112 views

Dojo Promise/All Array Not Populating InfoTemplate in ArcGIS Javascript

Using dojo/promise/all I'm attempting to populate an infoTemplate with results from a queryTask which runs later in the script. Our app returns an XY value from a geocoded address search and queries ...
1
vote
0answers
32 views

How to show neighboring polygons and polygon in which point exists

We have a table which has polygon related data stored. For finding if a point (long,lat) is within that polygon I am using following query in mysql SET @vasantKunjSectorC = 'polygon((77.161266 28....
2
votes
2answers
267 views

Selecting features within polygon from another layer using R or Python?

For Selecting features within polygon from another layer using QGIS? the solution was to: use the "Vector->Research tools->Select by Location" However, I would like to know how to do the same ...
1
vote
1answer
40 views

Query across layers of SHP files?

I would like to query features from a SHP vector that intersect with features from another vector. Pseudocode: "Name" IS intersects( countries) How would be the valid query composed?
1
vote
0answers
36 views

Partial extents for ArcGIS android geodatabase creation

I know how to create and download a geodatabase copy of a FeatureServer from arcgis rest services. I also know how to pass LayerQuery to the geodatabase task to filter layer objects and features. ...
-1
votes
2answers
148 views

Sql Query in Postgresql

I am trying to execute a query but I am stuck. I have two tables A and B. The a table has columns gid, geometry(line-string) and value which cells is empty , the B table has got 3 columns gid, ...
7
votes
2answers
978 views

QGIS Filtering Multiple Values using Query Builder

In the "Query Builder" I can currently filter on value from the "Values List", but I'd like to be able to filter for multiple values at once. How can I go about doing this using the SQL and "Operator'...
1
vote
1answer
47 views

Cannot find table in geodatabase

I was using the Make Query Table tool in ArcGIS. Once the tool finishes running, the result (a table whose name I specify) is automatically added to the Table of Contents and I can view the data ...
1
vote
0answers
55 views

Python code and modelbuilder [closed]

I am working with ArcGIS 10.2 and using python to use the function for zoom to selected feature. I need to have this zoom to selected feature work for any project and I also need drop down menus for ...
1
vote
1answer
1k views

SQL Server Spatial Querying

I am looking for ways to learn querying for SQL Server Spatial (2008/2012). I have a table created from Shape2SQL and have been trying to run a simple intersection query to get results from that ...
1
vote
1answer
92 views

How can I query for a list of specific road types in the same Overpass query?

I'm trying to query for a number of specific road types in the same request, and I can't get the syntax right at all. Can anyone alter the following query to select "motorway", "trunk" and "primary" ...
1
vote
1answer
118 views

Selecting entities based on first character of the attribute field being letter using QGIS?

I would like to select entities whose addresses are incomplete, i.e. the first character is a letter instead of being a number. Does QGIS have an "is numeric" -type function to accomplish this? Not ...
0
votes
0answers
87 views

GeoExplorer Querying Tool

Are there any ways to add more query options in GeoExplorer? The query options available are limited to: "=", "<>", "<", ">", "<=", ">=", "like" and "between".
1
vote
0answers
21 views

postgres 9.2 update query on a subset

I wish to make an update using CASE, on a subset of a table. This subset is based on a spatial query. It looks like : update t1 set f1 = CASE WHEN... WHEN... END FROM (select * from ...
0
votes
0answers
27 views

Geoext - Load Attribute table automatically [closed]

May be it is a basic question. I am new to Geoext programming. I have developed a web application using Geoext with East - Table of content, Center- Map display and South - Grid panel I am able to ...
2
votes
2answers
74 views

3D queryable GIS

I've used GIS for many years, and now I'm moving into 3D GIS, but I have some questions. Say I have a 3D model of a viliage, I can get this into Blender, but I want to be able to run GIS type queries....
0
votes
1answer
228 views

Selecting features by attribute in Leaflet

Is there a way to select an individual feature based on an attribute from a FeatureGroup in Leaflet? For example, when selecting a feature based on a click event, I will do something like, function ...
1
vote
1answer
107 views

Error #1064 from MySQL searching database for results near lat/long

I'm trying to run a SQL query to search for a term and a users location. I need help to search my database for locations near a user with the description of 'X'. The users location (lat, long) is ...
1
vote
0answers
91 views

Query to merge simplified polygons according to the map scale-factor

I'm trying to construct a view in PostgreSQL that simplify polygons according to the map scale-factor. Basically I was reading this thread http://linfiniti.com/2011/06/scale-dependent-generalization-...
1
vote
1answer
35 views

ArcMap Georefencing - sheet/image problem

I have a problem and I wanted to know if anyone else had experienced this. I think it is some type of bug as it doesn't occur all the time. The problem is when I am georeferencing some 'tiff' images, ...
0
votes
3answers
121 views

Selecting parcels in vector map from raster layer using ArcGIS for Desktop?

I am relatively new to Arcgis and I am stuck. I have a parcel map (vector) and a land cover map(raster). My land cover map is only 1's and 0's, flood and no flood. I want to be able to highlight or ...
2
votes
1answer
94 views

Looking to find (or build) a particular Python geoprocessing tool

So here is my situation: There is a large area (a wildlife refuge) of nearly 200,00 acres that we have loads of spatial data for, from habitat management projects from the past several years. My boss (...
0
votes
0answers
80 views

Insensitive case query in Geotools to WFS

I'm trying to make an insensitive case query from Geotools to WFS (Web feature service) datasource,I used FilterFactory2 with the method like(Expression expr, String pattern, String wildcard, String ...
0
votes
1answer
212 views

arcgis 10.2 how to order query results

is there a way to order the returned results of a query task? this: query.where = "COD > 0"; works fine, but this: query.where = "COD > 0 order by COD"; throws: dojo.io.script error ...
2
votes
1answer
38 views

Postgis spatial query st_disjoint

I have 2 layers that I want to compare. I wish to retrieve the features in the layer 1 that have no part in common with the features in the layer 2. I try queries like that but do not returns me the ...
0
votes
0answers
24 views

How to remove lines made with a PostGIS query automatically if origin is not in the map window?

I have a PostGIS point layer with labels. I moved these points because they were too close. To connect label and point, I created a line vector layer which was made with a query in the DB-Manager (...
0
votes
1answer
124 views

Clicking on points in ArcGIS Android

This seems like it should be very easy to do, but I am unable to click on a point and have the map recognize that I have clicked on the point. I first tried just creating a simple point, setting the ...
1
vote
1answer
192 views

Select ID by most recent date

I have a personal GDB table that has a non-unique SLID field and a date field. Basically there are multiple records with the same SLID numbers but different dates. I want to select only the most ...
0
votes
1answer
104 views

SQL and ArcGIS data querying: what's the difference?

I am wondering if the language used by ArcGIS for data querying (e.g., search by attribute) is part of the SQL language, or to what extent there is a connection between the two (and where does it come ...
1
vote
3answers
270 views

How to search within a string to extract data from OSM other_tags?

I am working with OSM data in QGIS and I often need to query items in the other tags field. When I download the data using the OSM download plugin the other tags come in one field so are not easy to ...
0
votes
2answers
204 views

Performing spatial join in Spatialite (QspatiaLite for QGIS)

I'm trying to spatially join and summarize the attributes of a set of buildings to a set of containing parcels. There are (potentially) many buildings to each one parcel. Here is the query as I'm ...
1
vote
2answers
90 views

SQL query new feature with loop

I'm trying to create an individual buffer feature class for each column of an input feature class, where there is a field that contains the buffer distance. I think there is a problem with my SQL ...
0
votes
1answer
112 views

How to connect SQL SSMS to ArcGIS file geodatabase

I've found this reference article talking about how to query a file geodatabase using SQL. http://resources.arcgis.com/en/help/main/10.2/index.html#/...
0
votes
0answers
328 views

Multiple LEFT JOIN in PostgreSQL

I got a "nice" problem with a query in PostgreSQL with a multiple join SELECT DISTINCT "Monitoraggio_L001_L008_2015_aprile"."ID", "Monitoraggio_L001_L008_2015_aprile"."Ordine", "...
0
votes
1answer
272 views

select by location point in polygon with sql query

I have 2 tables table a this one a polygon layer with 10000 records table b this one a point layer with 600000 records in postgresql geodatabase i select a polygon feature with the query by input ...
0
votes
0answers
59 views

Getting connected points in intersection from OpenStreetMap using PostGIS?

I'm trying to get the points that connected with the intersections. suppose that I know the point of the intersection (if we see in the pictures, I represent the intersections as black node). Now I'...
0
votes
1answer
231 views

Query table names

I want to query a table in my postgis table named Seg_060_2009 using psycopg2 and cant seem to get my query to execute. The query will execute if I name the talbe layer. Are there restrictions on ...
0
votes
1answer
205 views

Database queries using GeoServer? [closed]

I am new to GeoServer. I have a PostGIS database and GeoServer setup. How can I query the database using the GeoServer/ Boundless SDK? I have OpenGeo Suite 4.6 and I am trying to query the database ...
1
vote
3answers
399 views

Extracting difference between two massive shapefiles using QGIS?

I have two massive shapefiles and I need to create a difference shapefile output between the two. I have a layer where I have satellite coverage (orange) and then a layer where I have high resolution ...
1
vote
1answer
101 views

Running spatial query on huge table [duplicate]

I've got two tables conatining geometry: 1 containing big polygon's (regions, srid=4326) and another containing smaller polygon's (pand, srid=28992, containg ~9.9milion rows) By using one of the big ...
2
votes
2answers
218 views

Can't import certain tables from SQL Server to QGIS

This is a list of 193 zip codes and their geometries that do not import in QGIS. This is a list of 999 Census Block Groups and their geometries that do import in QGIS. This is the Add MSSQL Layer ...
1
vote
1answer
222 views

How to concatenate values from postgis table which have the same id into a new column? [closed]

I have the following table in postgres-9.3 postgis 2.1. (geom values is too long , I cut to make it short in below table): id | name | geom ------------------------- 12 | A | "01030000000" 12 | ...