A command used to retrieve information from a database

learn more… | top users | synonyms

6
votes
0answers
159 views

Postgis database query optimisation

I have a set of rasters in DTED format which I load into postgis database using raster2pgsql command line tool. Each of rasters is simply stored in a row and described by rid and a value of raster ...
3
votes
0answers
618 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. ...
3
votes
0answers
626 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 ...
3
votes
0answers
347 views

How to get distinct values from multiple columns in GeoTools?

Is there a way to get distinct values from multiple columns in geotools? I know I can get unique values from a column like this: SimpleFeatureSource featureSource = dataStore.getFeatureSource(layer);...
2
votes
0answers
307 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
33 views

Querying a shapefile and returning values?

I have a lot of experience making maps in ArcMap. I don't have much experience programming or working with APIs. Here's the (simple) problem: I create a shapefile of a region and then load the ...
2
votes
0answers
1k 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
775 views

Proxy trouble with GeoExt Query Panel?

I got the GeoExt QueryPanel working so far, it recognizes the layers available on my Geoserver but it is not able to get the attribute columns for the dataset. I configured an osgeo proxy on my Apache ...
1
vote
0answers
22 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
35 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
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 ...
1
vote
0answers
34 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 ...
1
vote
0answers
30 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 ...
1
vote
0answers
39 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
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: ...
1
vote
0answers
43 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
38 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 ...
1
vote
0answers
34 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....
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
vote
0answers
22 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 ...
1
vote
0answers
94 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
0answers
318 views

ESRI JavaScript API Web Application and SQL Queries in ASP.NET?

My workflow (and security restrictions) for a new html/javascript based web application is making me think that I could program an ASP.NET application, inside which I load the 'map' and the 'legends' ...
1
vote
0answers
303 views

ArcGIS Android syncing geodatabase does not work after downloading it with LayerQueries

I need to download a geodatabase from ArcGIS server using layer IDs and LayerQueries in database parameter class and then be able to sync both ways. The ArcGIS Android API examples are only based on ...
1
vote
0answers
99 views

How to query a bunch of tables/feature classes which linked together by relationships

I have one feature class and 3 tables which linked together by relationship classes. The feature class, called "buildings", has the fellowing feilds: (1) FID: Feature ID and (2) ID: My own ID This ...
1
vote
0answers
69 views

Using statisticdefintion in a querytask

I have a question about using QueryTask to accomplish to jobs: Identify unique value for a county in a graphics layer via mouseover. This unique county value (from a specified field) is used to ...
1
vote
0answers
51 views

Geoexplorer - How to open query panel in a bigger window?

The query panel in Geoexplorer (displayed in lower left corner) is so narrow, that entering data in it may be cumbersome. How can i configure Geoexplorer to open this panel in a bigger window and ...
1
vote
0answers
134 views

How to count the number of coordinates within x meters grouping by distinct ids?

I have a table "items" of about 1 million rows and 40.000 distinct ids like the following: idx | id | point | lat | lon | the_geom 1 | 1 | 76 | 51.463388 | -0.16869856 | 0101000020E... 2 | 1 | 53 | ...
1
vote
0answers
138 views

How to Build Query Table from two OLE DB tables using ArcPy?

When I run the following code to create a subset of a table, the error says "An invalid SQL statement was used" [Query]. The error shows in line 39. Is there any idea you can figure this out? import ...
1
vote
0answers
146 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 ...
1
vote
0answers
85 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 ...
1
vote
0answers
245 views

Invalid spatial reference Error

I am getting the error: Invalid spatial reference. Spatial reference must match map's spatial reference. Clear the map layers collection prior to changing the spatial reference when I try to ...
1
vote
0answers
305 views

Find area with highest relative density of one type of object

I'm using PostgreSQL/PostGIS and I have an advanced type of query. My database contains two types of object - let's say pubs and churches :) Is there a way that I can find the area with the densest ...
1
vote
0answers
224 views

Querying and summarizing/reporting a multiple tables database

I have to create a database with information on Scottish buildings from 17 and 18 centuries. In order for my data to be searchable I need to have a series of tables connected with 1 to many ...
1
vote
0answers
242 views

PostGis search query on hstore tags

I am writing a search client, to query postgis db. The search query will be, SELECT tags->'name' AS name,ST_Transform(way,4326) AS pt_lonlattext FROM planet_osm_point WHERE lower(tags->'name') ...
1
vote
0answers
322 views

ArcObjects: How to Speedup Spatial Query to Feature Layer?

I have ROAD (POLYLINE) Shape File with more than 400,000 Records. I am working on a code which goes like this: Loop through all Feature of the Shape File Take First Feature Find the LAST VERTEX of ...
1
vote
0answers
207 views

Query to find lat/lon of a house by street.name & house.number

How can I get house coordinates (latitude, longitude) by street.name and house.number? If it is possible, how I can get it? Many thanks!
1
vote
0answers
507 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 ...
0
votes
0answers
11 views

Creating queries in Portal for ArcGIS that do not have to be predefined?

I am trying to figure out if there is a way to make a query widget in Portal for ArcGIS that is more free form. I want to know if there is a way a user can type in queries that are not predefined. Or ...
0
votes
0answers
21 views

When doing intersect columns are doubled in QGIS?

I am using QGIS version 2.14.1 (Essen). I am the spatial quieries (intersect function). When I do this, I save the new shapefile but it seems that in the new shapefile, the columns have been ...
0
votes
0answers
18 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": { "...
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
24 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 ...
0
votes
0answers
33 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
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
0answers
16 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 ...
0
votes
0answers
85 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....
0
votes
0answers
80 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
78 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 ...
0
votes
0answers
92 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".