Acronym for Structured Query Language. A syntax for retrieving and manipulating data from a relational database.
0
votes
0answers
12 views
using Arcgis silverlight viewer, how to autoload a layer of Lat/Long points stored in MS SQL 2008
I use Arcmap to register a layer into ArcGIS server whose source data is spatial points stored in MS SQL 2008. Everything works fine until a new entry is added into the database table, it doesn't ...
1
vote
0answers
26 views
How do I make vectorlayer with sql on PostGis via python code
I need to make a vectorLayer and fill with the SQL's results on PostGIS via python code.
I'm working with python 2.7, QGIS 1.8 and PyQt 4.5
How do I it ?
thanks
0
votes
1answer
39 views
ArcGIS - Help Using Oracle Function in Definition Query - No ArcSDE
I have set up a Query Layer pointing at an Oracle table with a SDO.Geometry column, and that is working and behaving fine.
However, when I am attempting to set up a definition query that calls a ...
0
votes
1answer
36 views
How do I write a MYSQL spatial query to find all polygons (rectangle) that contain any points in a table?
Something like:
SELECT * from polygons WHERE bounds CONTAINS(SELECT geom_point from points)
Can someone help me out with the syntax? Bounds will always be a rectangular polygon and everything is in ...
0
votes
1answer
30 views
Looping on the Select_analysis tool
Im trying to perform a loop on the Select_Analysis tool in Arcgis. Code looks like this:
inputfile = open("locality.txt", 'r') # locality.txt is a txt file of locality names
loc_list = []
for line in ...
1
vote
0answers
43 views
What is the MS SQL Spatial syntax for counting points within polygons? [duplicate]
All,
What I'm trying to do is this:
Count points within polygons
There are thousands of points and maybe 2 dozen polygons
Get a list back of the 2 dozen polygons by name and the count of points ...
1
vote
2answers
74 views
How to select all points within a circle in PostGIS?
I have set of points in a PostGIS Table (Type Geometry).
Now, I need to filter points that lie in a circle with a center (C) and radius (R)!
I expect C to be of type Point or Coordinates.. R to be ...
0
votes
0answers
29 views
SQL Spatial: MakeValid() splits a polygon into 3 separate polygons
I am trying to import one of the EPSG (http://www.epsg-registry.org/) area polygons (the polygon with area code 1999) into SQL Spatial. The polygon is in GML format and covers the southern hemisphere ...
0
votes
1answer
34 views
Html search box input with SQL
How can I go about adding a html search bar that the user can use to search an attribute field for a polygon layer, and then tie that input into the SQL statement. So far I am able to hard code the ...
2
votes
1answer
64 views
How to convert Geometry type column to degree Minutes Second in SQL Server 2008 R2
I have shape column of type geometry and I want to convert X and Y coordinates into Degree Minutes Second format using SQL query and i am using sql server 2008 R2.
Currently I got Lat and long using ...
2
votes
1answer
45 views
Trouble formatting SQL expression for where clause in “Search layer by attribute” arcpy function
I am trying to pass a variable into a where clause in the "Search Layer by Attribute" arcpy function. I cannot seem to figure out the correct format for the SQL expression so that the function reads ...
1
vote
2answers
66 views
Merge lines with the same 'name' attribute on QGIS?
I have a shapefile with a few thousand lines, each is a street segment. I'd like to merge all features with the same 'streetName' attribute into a single attribute. I only really care about the name ...
3
votes
2answers
50 views
Change polygon “handedness” for SQL 2008
I have a few hundred shapes (polygons and multipolygons) each consisting of tens of thousands of points that I am trying to get into SQL 2008.
Unfortunately, the shapes I have tried to import are ...
0
votes
1answer
37 views
Linked point geometries to linestrings in Spatialite
I have been parsing Canada's radio system frequency open data. It's a single large table per province, containing point geometries for each station callsign. Where a point-to-point link is defined, ...
2
votes
2answers
71 views
Execute SQL in File Geodatabase
Is there a way to execute SQL queries on file geodatabase from Python? I'm looking for the same functionality provided by arcpy.ArcSDESQLExecute for SDE databases.
Thanks,
0
votes
1answer
83 views
Building SQL statement in javascript and casting variables as strings
I'm working with Postgres 8.3/PostGIS which is storing some polygons. I'm writing a javascript function which will take in a parameter of a watershed id from another function. The javascript will ...
0
votes
2answers
41 views
oracle search against intersect of a region that covers the whole world doesnt find any records
I am new to Oracle Spatial, I am trying to implement a service that will take coordinates from a map, and search our database to find any geometries that intersect with that map view. I works fine for ...
0
votes
0answers
19 views
SQL Query Remove Multiple Attributes
I'd like to query a street layer by the ownership of the street (State County etc). I know I can do
"Road_Auth" <> 'IL' or "Road_Auth" <> 'Kane' and so on. This question Select by ...
0
votes
0answers
17 views
How to add column to versioned ArcSDE 9.3.1 feature class using scripts only?
how to add a column to a versioned arcsde feature class in enterprise geodatabase 9.3.1, using scripts only.
I want to give our dba a script to run on production that will add the column.
It doesn't ...
2
votes
2answers
86 views
Select by Attributes - If string has a letter
I'm running ArcMap 10.1.
I'm using a File Geodatabase.
I have a string coordinate field that I want to clean and some records have letters in it (mostly 'N' or 'E' or 'n' or 'e' e.g. '6213210N' or ...
1
vote
1answer
43 views
IQueryFilter where Clause quering two feature class at a time
I need to query two feature class at the same time using IQueryFIlter.
For eg -
FeatureClass -- A has field OBJECTID
FeatureClass -- B has field OBJECTID
what i am tring to do is --
IQueryFilter ...
1
vote
2answers
57 views
how to add a raw input to a SQL string?
I have this py script for selecting one point.
# Within selected features, select only those points of a chosen value
arcpy.SelectLayerByAttribute_management("Stations", "NEW_SELECTION", ' "OID" = ...
1
vote
2answers
49 views
Find the majority area within another area
I have a survey grid overlaid unto several administrative areas. Both are polygon features and I have performed a union on both features in order to determine the areal contribution of the segments ...
1
vote
0answers
25 views
IQueryDescription SQL Query Returning Limited Records
I created a SQL query that is working in SQL Management Studio, but as soon as I transfer the query into ArcMap's IQueryDescription to try and run it with a User Form, the results that I'm getting ...
0
votes
2answers
113 views
How to connect Dotspatial with PostGIS/PosgresSQL database and perform SQL function
I am currently doing a project that needs a GIS front-end interface to visualize geographical objects (road networks), and a back-end geo-spatial database to implement network analysis (SQL based). ...
0
votes
1answer
39 views
pgrouting shortest_path return longest_path
I've got troubles with shortest path function from pgrouting. I try to calculate the shortest path between an address and a bus stop.
I first found the nearest road points for the address and the bus ...
1
vote
1answer
57 views
How do I use the SearchCursor where_clause to get a max value from a column?
This is my first time asking a question on StackExchange. I hope I phrase my question and describe my attempts to understand my problem well enough!
While working with SearchCursor, I'm trying to ...
1
vote
1answer
69 views
Why isn't my select by attributes query working?
I'm running ArcMap 10.1.
I have a point feature class joined to a table and am trying to query a field.
If I do [field] = 'TEST', it selects all the fields.
But if I do [field] LIKE 'TES%', it ...
1
vote
1answer
92 views
Trigger a python script to run after a row is added to the feature class
I have a Python script which runs on a SDE feature class daily (as a scheduled task). I would actually like this script to run whenever a new row is added to the feature class (data is captured in the ...
2
votes
1answer
53 views
Why is Spatialite showing dates in MM-DD-YYYY format?
I have a table with a dates column that is formatted in MM-DD-YYYY format, as shown in SQL SELECT statements. I'm using Qspatilite (QGIS 1.8) and Spatialite GUI.
When I ORDER BY the date column it ...
0
votes
1answer
61 views
query syntax to select every multiple of nn record (shapefile) [duplicate]
I have data like multiples of 40.
40
80
120
160
200
and so on.
I would like to label every record that is a multiple of 100.
I have tried a couple of methods and cant get them to work either as a ...
-2
votes
1answer
47 views
Qgis: Select multiple layers in sql-Filter [closed]
I have a Shape-File with lines of streets. Now I want qgis only to show the categories: Type: primary and Type: secondary and Type: motorway.
How do I do this?
This doesn't work:
"type" = 'primary' ...
8
votes
1answer
130 views
How to trace SQL queries sent by ArcGIS Server (ArcSDE) to Oracle database?
I'd like to generate a log file containing all SQL queries sent by ArcGIS Server (ArcSDE) to Oracle database.
Is there a way to do so?
I'm using Oracle 11g and ArcGIS Server 10.0 on Windows. ArcSDE is ...
2
votes
1answer
74 views
PostgreSQL, find points near points
I'm going to have a database with a 'people' table and a 'shops' table.
I'd like to find all people within 500m of a shop, and details from both tables.
I'm used to working with mySQL, but I'm ...
4
votes
2answers
155 views
What are the benefits of using ArcGIS with Postgresql over simply ArcSDE?
I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed ...
1
vote
1answer
128 views
How to get polygons from PostGIS table to PHP array best?
Currently I fetch polygons from a database table using ST_AsText(). The results are in text format, like the following.
POLYGON((84 104,212 48,321 122,243 179,275 238,131 240,84 104))
I am not ...
3
votes
0answers
56 views
Geoserver WMST Date Format
There is table in SLQ-Server 2008 R2.
In this table i have date column with date format like this 2006-09-08 14:39:41.000. Now i make View from this table on Geoserver side but do nothing wiht date ...
0
votes
2answers
139 views
Cannot insert simple geometry data
I installed PostgreSQL 9.2.4 and PostGIS 2.0.3 on my Windows 8 machine. Then I created a table using phpPgAdmin and added a geometry column using the following statement.
SELECT ...
2
votes
1answer
88 views
GDAL SQL syntax to add field an put values
I try to make a new field in my attribute table and put in values from another field after converting from character to integer but can't get the right syntax. I run this as shell-script in MSYS.
cd ...
1
vote
1answer
77 views
arcpy: can I use SelectLayerByAttribute to compare fields from joined tables?
I can't figure out the syntax to select table records where one field's value exceeds that of another. The fields are from a pair of table views connected w/AddJoin(). One view is of a fgdb table and ...
0
votes
1answer
168 views
help to code a spatial query that returns the results from a database
I have asked this question on stack overflow, what i need help with is to retrieve the database entries that fit within a polygon, drawn with the Google maps api. The map is showing the correct ...
2
votes
2answers
89 views
Trying to use an integer in a WHERE clause
I'm trying to use an integer value in a WHERE clause (looking at an integer field).
expression = "'SERVICE' = 'Service' "
expression = expression + 'AND '
expression = expression + "'GPS_TIME_TOTAL' ...
2
votes
1answer
148 views
Select by attribute expression invalid in python
I'm not sure how my expression is failing. Any ideas?
inPoints = "points.shp"
i = 0
arcpy.MakeFeatureLayer_management(inPoints, "pts")
arcpy.SelectLayerByAttribute_management("pts", "NEW_SELECTION", ...
1
vote
1answer
120 views
Raster as Attribute Field Error
I'm using Arc 10.1. I am creating a parcel inventory where I would like to have a photo of the property attached as an attribute and view-able with an HTML popup. I have a polygon feature class built ...
3
votes
1answer
133 views
What formula does SQL Server 2008 use in STDistance?
I am analyzing the accuracy of the STDistance function for geographical objects in SQL Server 2008, in order to understand its behaviour better I need to find the underlying formula.
Does anyone ...
0
votes
1answer
140 views
How to Export to PDF after zooming to extent of each feature that meets SQL where clause?
I realize that I've asked two similar questions recently, but following suggestions in the comment chain, I'll make this a separate question (separate as it is not the no output problem in ArcPy: ...
1
vote
1answer
82 views
Why does this SQL syntax produce empty feature class with ArcGIS Select_analysis?
I'm working on a script that involves an arcpy.select_analysis function. The problem I have is that when I run the script it produces an empty file. I've verified that the whole thing works when in ...
2
votes
1answer
97 views
ArcGIS 10: How to populate SQL options for parameter in tool
I'm trying to create a tool where individuals can select a variety of records using a SQL expression that is then passed to a calculation. I can add a parameter under the tool, and select SQL ...
1
vote
2answers
166 views
Plotting large numbers of objects on a chart using R and WKT format
I am retrieving thousands of geometry lines in WKT format from a Microsoft SQL Server database. I would like to plot all of those lines in one map, but I am having some difficulty with the code. How ...
1
vote
0answers
115 views
PostGIS Better ST_Intersects Query
I am currently using the following queries to return all features that intersect a large and complex polygon. I initially tried to use a single ST_Intersect query but because the number of features it ...
