Tagged Questions
8
votes
3answers
651 views
Are there any training resources in SQL and Python as applied to GIS database management?
I've taken ESRI database courses, which have been helpful to my work. But I also need training in SQL and Python as applied to GIS database management. Any suggestions?
6
votes
3answers
132 views
Are there any open source Python modules compatible with arcpy that will allow complex SQL queries?
I am trying to handle string (non-geometry) duplicates in a large attribute table of a shapefile without having to convert to gdb and back or connect to a postgres db. I need to be able to use a count ...
5
votes
2answers
679 views
Using an integer variable in where-clause in arcgis python script
I've seen some questions on this, but there seem to be many different answers... and none have seemed to work. I'm trying to include an integer variable in the SQL where-clause of a tool like this ...
4
votes
3answers
960 views
Select features by attribute if in Python list
I believe this will amount to largely a sql syntax question. Essentially, I am trying to complete a select by attribute in Python but based on the query of whether an attribute is present in a list.
...
4
votes
2answers
5k views
'Select by attribute' using python in ArcMap 10
I need to select a feature using SQL before zooming to it in python. What I'm looking for are replacements for the commented lines in this code:
import arcpy
parcel_num = "123456"
mxd = ...
4
votes
2answers
416 views
Using a bounding polygon, instead of a bounding box
I've got a large set of LAT/LON coordinates. Up until now, when I needed to select out those that fell within a certain region, I'd just create a bounding box using some MINx, MAXx, MINy, MAXy values ...
4
votes
3answers
267 views
arcgis10 filter dataset
Using ArcGIS 10 SP-4
I have a large dataset of sites that needs to be filtered down to a usable size. There is an attribute for the site_ID and another one for the site_type. There are duplicate ...
4
votes
1answer
145 views
Is it possible to run an arcpy execute SQL method without connecting to any database or server?
I want to simply process a layer by writing a tool script in a toolbox without having to connect any database, so I think I may have to set up a workspace environment in ArcMap, but I'm not sure if I ...
3
votes
1answer
538 views
ArcGIS Select Analysis using Unique Values from Field
I am trying to create separate shapefile using Select analysis with ArcPy by doing an SQL query to create them based on a unique value from the field. I want to create a list of the unique values in ...
3
votes
1answer
1k views
Arcpy cursors, WHERE clauses, and date/time fields
I'm having trouble making a selection of rows that meet certain date criteria using my arcpy.UpdateCursor(). I need to update records in a field in a geodatabase table with an ascending value based on ...
3
votes
2answers
832 views
How to write a SQL WHERE Clause using Multiple Choice values in FME?
I published a parameter which is of Choice Multiple type. I wish to
use values from this parameter for WHERE Clause when Reading Inputed
Data in the begin of Workbench.
So there is no problem if I ...
3
votes
1answer
122 views
raster2pgsql: Strange error when creating a table
Hi GIS Stackexchange people,
When I try to load a asc file into my psql setup, I get a strange error message.
I have created the sql input file via
raster2pgsql -s 4236 -I -C -M gis_data.asc -F ...
3
votes
1answer
401 views
Python script for constructing a WHERE clause from user input
I'm trying to construct a where clause from user input that will eventually be passed through as a SQL statement in the select tool or the select by attributes tool. I've started a script thats been ...
2
votes
3answers
95 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 ...
2
votes
1answer
82 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", ...
