Acronym for Structured Query Language. A syntax for retrieving and manipulating data from a relational database.
4
votes
2answers
32 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 ...
6
votes
2answers
256 views
PostGIS SQL query to find a polygon that intersects with a line
I need to build a PostGIS query that would select every polygon inside an area the river is flowing through.
I'd better describe with an example below: There is a river (blue line) flowing through ...
1
vote
1answer
52 views
PROBLEM SQL SERVER UNION of geography feature : FULLGLOBE result
I have some trouble with sql server 2012.
I store coordinates of french cities in my database as geography object (with ESRI 4326) and i want to make the UNION of some cities.
I have in result ...
22
votes
9answers
9k views
How can I connect to a PostGIS database from ArcMap 9.3 and 10.0?
How can I connect to a PostGIS database from ArcMap 9.3 or 10.0?
Ideally, I would like to be able to perform spatially enabled queries and receive the results back (e.g. spatial and non-spatial ...
1
vote
0answers
31 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
1answer
83 views
Where Clause problems when all parts are user input variables
I have written some generic user ipnut code for a toolbox script (ArcGIS 10.0) but because everything is a variable I don't know how to write the SQL whereclause.
Please can someone help and suggest ...
9
votes
4answers
851 views
What is the best way to join lots of small polygons to form a larger polygon?
I have the following layer using SRID 27700 in postgis:
It's every administrative region in the UK, and (as you can see from the colour grouping) each of them has a text field specifying the county ...
3
votes
3answers
70 views
Sql syntax in Model builder
In ModelBuilder I am trying to perform the following query, using the select by attribute tool. I am having great difficulty with the sql syntax.
What I am trying to do is
Select Top 3 (Avg) Price, ...
1
vote
1answer
32 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 ...
0
votes
2answers
55 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 ...
1
vote
1answer
123 views
Python SQL connection causes crash in ArcMap
I have the following code which I have striped down to just included the part that is causing a crash in ArcMap.
import pymssql
# Connect to the Research db using Windows Integrated Authentication.
...
1
vote
1answer
39 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 ...
2
votes
1answer
97 views
What is the proper way to delete an SQL Server database in order to delete an SDE geodatabase?
I'm new to this SDE stuff and would like to know the best way to cleanly delete an SQL Server database in order to delete the SDE geodatabase. Is it as easy as right clicking on the database in SQL ...
1
vote
4answers
93 views
Get vector features inside a specific extent
The problem:
I have a very large vector layer with many features and a much smaller raster layer in a defined region. I want to get only those vector features which are within the raster layers ...
1
vote
0answers
72 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 ...
1
vote
1answer
50 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
90 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
78 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
71 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", ...
3
votes
1answer
59 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
55 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
54 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 ...
1
vote
2answers
100 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 ...
0
votes
1answer
72 views
Defining SQL 2008 store within GeoServer 2.3
I want to define a SQL server 2008 store within Geoserver 2.3.
I installed the sql Extension.
After defining the different attributes, I get the following error message :
Error creating data store, ...
2
votes
1answer
56 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
0answers
75 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 ...
9
votes
2answers
242 views
How do I perform a 3 parameter geotransformation and projection in Sql Server 2012?
I have a table with latitude longitude (NAD27) columns in it. I compute two other columns, X and Y, representing Web Mercator (WGS84) location.
Currently I'm using a Arcmap to do this, by applying ...
2
votes
3answers
84 views
Creating a where clause from user input/Python list
I am trying to perform a query based on values in a Python list. The where clause will then be used in an Update Cursor, so that the rows NOT equal to the values in the list will be deleted.
This is ...
1
vote
1answer
41 views
SQL Command to convert pgRouting result to GeoJSON
My goal is to produce a Web UI for pgRouting using this tutorial. I have already imported my data from an OSM pBF to PostGIS using osm2po. Using the pgRoutingLayer plugin for QGIS, I was able to ...
0
votes
0answers
20 views
query for adjacent polygons in GRASS?
i need to create a table of each district in india's adjacent districts.
i found this query but couldnt get it to work for me: SELECT p1.PK_UID, p1.Name FROM Polys p1, Polys p2 WHERE p2.PK_UID=1 AND ...
1
vote
1answer
48 views
How to share *.sql files between ArcGIS and MapInfo?
In Denmark many municipalities have the same provider of public data. These data are pushed to a local database – often a SQL Server.
The DBMS layout is the same for all municipalities.
When I create ...
5
votes
2answers
112 views
How to find the nearest land mark from a given longitude and latitude?
I have a table called osm_places with place_name geometry, place_type and many other info related to the city. My database system is PostGIS.
My requirement is:
Given a latitude and longitude ...
0
votes
1answer
47 views
ST_Box2D in PostGIS 2.0
I am getting an error trying to create a bounding box of a geometry using ST_Box2D(). Is the function deprecated? If so, what is the equivalent function?
SELECT ST_Box2D(ST_GeomFromText('LINESTRING(1 ...
2
votes
0answers
41 views
Matching points in table to polygons
this is my first post to this forum. I hope to start participating actively.
I have a table with several records (aprox 200.000), each with its own coordinates. And I need to identify the "Polygon" ...
2
votes
4answers
2k views
Using String Functions (LEFT, RIGHT, MID) in Select By Attributes against a File Geodatabase using ArcMap 10
I finally (albeit reluctantly) made the switch from a personal geodatabase (pGDB) to a file geodatabse (fGDB) not too long ago. The main reason it took so long to switch has to do with how Select by ...
0
votes
0answers
17 views
How to get sublinestring limited by two points?
Hi i have MS SQL_server R2 2008.
I have a linestring and two points on this line.
i want to get part o linestring limited by this points.
Its possible?
4
votes
2answers
162 views
Calculate Field based on field value in a second table
I have a table in a MSSQL Server Enterprise SDE database. I need to join a table from a MS SQLExpress Workgroup SDE database and then calculate 11 fields in the Enterprise table based on values in ...
8
votes
5answers
2k views
A SQL console in QGIS
I know QGIS comes with its field calculator, which is not bad. It also comes with ftools which permits several operations on geometry and attributes. But we often need more control and I haven't seen ...
12
votes
5answers
3k views
Use arcgis with SQL Server 2008 as a backend
I'm wondering how best to use arcgis] and sql 2008 together. At the moment we run manual imports and exports between sql 2008 and arcgis 10 shape files. With sql 2008 having a geography data type I ...
2
votes
1answer
108 views
Select top 5 most items in a geodatabase
I'd like to know what is the best way to select the 5 most expensive items (in terms of actual monetary value) in my geodatabase where i have a price field. Prices are not necessarily ordered but can ...
3
votes
2answers
108 views
is there a public street database that I can do SQL queries on?
Sorry if this isn't strictly a GIS question. I want to know if there's a public database of US streets and US States that I can simply connect to (e.g. JDBC) and run SQL queries. For example, I want ...
0
votes
0answers
35 views
SQL statement in MakeTableView_management
EDIT: Finally found a way around this..
expression = "[Route] = '" + route + "' AND [Trip] = " + str(trip)
arcpy.MakeTableView_management(solutionTable, "solutionView", expression )
I tried str() ...
1
vote
0answers
98 views
Function for Selecting Points in a Polygon
I've been banging on this for a few hours, but since I'm relatively new to PostgreSQL and PostGIS, I can't find the solution. I'm trying to create a stored procedure (function) which will return all ...
2
votes
1answer
91 views
Given a lat/long point, determine if it's land or water?
I have a PostGIS-enabled PostgreSQL 9.1 installation with the 10M physical dataset from Natural Earth imported. It's been converted to 900913, and in QGIS I can visualize the data. So the plumbing's ...
2
votes
1answer
191 views
STIntersects - Update field to give me count of points in polygon
I have a points layer (dbo.ptLayer)
Around 1M points
Spatial Geometry Type (dbo.ptLayer.geom)
No spatial index just yet, but will create one once data gathering complete.
I have a polygon layer ...
0
votes
1answer
532 views
MapInfo equivalent of SQL 'AS' statement
I'm trying to execute a SQL query in MapInfo, and want to change some of the column names to something more readable. The SQL command 'AS' doesn't seem to work - is there a MapInfo equivalent?
1
vote
0answers
187 views
Color polygons using SQL Database based Rules in Openlayers
I want the rules to be applied according to values in a database. Is it possible to include external database information that is not in the shapefile?
In spoken words the original rule is "Color all ...
4
votes
2answers
159 views
Which Geodatabase supports SQL and is easily portable?
I want to choose the geodatabase type, which could be:
permits direct sql queries.
easily portable, because the app would installed in one computer.
I know that the personal geodatabase is a good ...
3
votes
1answer
119 views
Routing with multiple points
I am using postgreSQL, postGIS and pgrouting. Now I am really confused on how am I going to find the shortest path between multiple points.
I know how to find it between two points through dijkstra ...
3
votes
2answers
68 views
Traversing a PostGIS table tree
I'm developing a geospatial db for a company that operates at a number of large facilities. Its primary purpose is to help staff locate themselves and equipment within each facilities' multi-storey ...
