A command used to retrieve information from a database
1
vote
1answer
40 views
What are the options for working around the max number of records returned for a query task on ArcGIS Server 9.3.1?
I'm trying to return polygon features that intersect a larger polygon which defines my area of interest. It is working in some cases, but when the area of interest gets large (7000 intersecting ...
1
vote
1answer
62 views
How can I change SQL query through a layer of an action (python)?
I have three layers from three diferent database tables.
When I click in other layer I want to change (with an action) the query of that three layers.
How can I do that?
Thank you
0
votes
1answer
247 views
How to make Stored Queries for WFS 2.0.0 in Geoserver
I am a new user of Geoserver. I have created a WFS and also could connect it with the QGIS WFS 2.0.0 Client plugin available now. But as like the default WFS link in that plugin I am not able to make ...
3
votes
0answers
178 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 = ...
2
votes
0answers
107 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 ...
2
votes
0answers
123 views
TO_DATE ORACLE SDE failing
I'm trying to use TO_DATE to query an Oracle SDE dataset. It's not working in the javascript API application so I tried to query the rest end point directly and I get the error:
"Unable to perform ...
2
votes
0answers
530 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
187 views
ArcGIS API Javascript - FeatureLayer from json: problem with queries and popup
Hello everybody
I've tried this code proposed by Derek Swingley in JSFIDDLE:
JSFIDDLE-FeatureLayer from JSON
Everything "seems" to work fine, but not always. If you go down to the closer scale (level ...
1
vote
0answers
82 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
95 views
Using database tables with bigint columns in ArcMap query layer
I am very new to GIS and am using the ArcMap 10 program.
Currently, I am trying to set up a query layer from a remote database. I am able to connect to the database, but I am having trouble making ...
1
vote
0answers
467 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 ...
1
vote
0answers
169 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
0answers
259 views
Administrative level and coordinates from Yahoo GeoPlanet WOEID
The Yahoo GeoPlanet data can be freely downloaded from:
http://developer.yahoo.com/geo/geoplanet/data/.
If I understand it correctly, each WOEID corresponds to a unique location on earth, with ...
0
votes
0answers
30 views
How to get the nearest line to a feature?
I have features on map, and i want to get the nearest poly-line to each one.
How to write spatial query to get the nearest one.
I tried to use ISpatialFilter but i couldn't reach anything.
0
votes
0answers
27 views
Isolate And Save Raster Features From Existing Multivalue Raster Map
I have Cyprus Corine map with 44 different types of land use.
I want to run a raster calculator query or any other way to isolate the areas with codes 10 to 22 and 26 to 34, all other values 1 to 44 ...
