|
POST
|
Have a look at Domain To Table—Help | ArcGIS for Desktop
... View more
04-26-2016
10:44 AM
|
1
|
0
|
1505
|
|
POST
|
I got the below to work but it's really slow. def FindLabel ( [RelateFieldofTable] ):
strWhereClause = '"' + "RelateFieldofTable" + '"' + " = '" + [RelateFieldofTable] + "'"
strpTable = "PathToRelatedTable"
rows = arcpy.SearchCursor(strpTable,strWhereClause)
strLabel = ''
for row in rows:
strLabel += '\n'+ row.FieldToLabel
return [RelateFieldofTable] + strLabel
... View more
04-26-2016
09:14 AM
|
2
|
0
|
1392
|
|
POST
|
I've looked a few times for a good answer to this question, unfortunately unless your in server or a personal geodatabase there doesn't seem to be a good answer.
... View more
04-21-2016
12:54 PM
|
0
|
1
|
3165
|
|
POST
|
Obs_data_temp LIKE '%0%' OR Obs_data_temp LIKE '%1%' OR Obs_data_temp LIKE '%2%' OR Obs_data_temp LIKE '%3%' OR Obs_data_temp LIKE '%4%' OR Obs_data_temp LIKE '%5%' OR Obs_data_temp LIKE '%6%' OR Obs_data_temp LIKE '%7%' OR Obs_data_temp LIKE '%8%' OR Obs_data_temp LIKE '%9%'
... View more
04-21-2016
12:43 PM
|
0
|
3
|
3165
|
|
POST
|
Are you in a file geodatabase? Could you post a sample 5-10 records?
... View more
04-21-2016
12:22 PM
|
0
|
1
|
3165
|
|
POST
|
Try this for a File geodatabase yourfieldhere LIKE '%[0-9]%'
... View more
04-21-2016
11:54 AM
|
0
|
3
|
3165
|
|
POST
|
If your data is stored in an sql database try this PATINDEX('%[0-9]%', yourfieldhere ) > 0
... View more
04-21-2016
11:19 AM
|
0
|
0
|
3165
|
|
POST
|
The script was created in model builder, with the two tools below. It would not be difficult to recreate in model builder and export again. You would be able to validate all the variables in model builder before you exported. Make XY Event Layer—Help | ArcGIS for Desktop Feature Class to Feature Class—Help | ArcGIS for Desktop
... View more
04-21-2016
05:14 AM
|
1
|
0
|
1559
|
|
POST
|
Do you have an advanced license? You could use Generate Near Table—Help | ArcGIS for Desktop to get the points closest.
... View more
04-20-2016
07:35 AM
|
0
|
0
|
2304
|
|
POST
|
Use Spatial Join—Help | ArcGIS for Desktop with a count field then you could symbolize by the count
... View more
04-20-2016
07:26 AM
|
2
|
2
|
477
|
|
POST
|
If you don't know the fields or feature class ahead of time use GetParameterAsText, see below import arcpy
Input_Shapefile = arcpy.GetParameterAsText(0)
field1 = arcpy.GetParameterAsText(1)#field with wanted attribute
field2 = arcpy.GetParameterAsText(2)#field with wanted attribute
field3 = arcpy.GetParameterAsText(3)#field to update
fields = [field1,field2,field3]
with arcpy.da.UpdateCursor(Input_Shapefile, fields) as rows:
for row in rows:
row[2] = "{ } { }".format(row[0], row[1])
rows.updateRow(row)
... View more
04-19-2016
06:39 AM
|
1
|
0
|
1340
|
|
POST
|
Layer files are simple pointers to the data if they can see the data in arcmap chances are they have at least read acces to the data. Layer properties—Help | ArcGIS for Desktop Here is the help on relationship classes if you get stuck somewhere please let us know RelationshipClass properties—Help | ArcGIS for Desktop
... View more
04-18-2016
11:38 AM
|
0
|
0
|
706
|
|
POST
|
Adrian, You could absolutely over complicate if you wanted. Get your domain Validate your excel against your domain Fix errors Join the tables Query for changes originField <> updatedField Calculate originField to match updatedField #import module
import arcpy
#get the feature class we want the domains for
fc = arcpy.GetParameterAsText(0)
desc = arcpy.Describe(fc)
desc1 = arcpy.Describe(desc.path)
#print desc1.datasetType
if desc1.dataType == 'FeatureDataset':
fcworkspace = desc1.path
else:
fcworkspace = desc.path
#List the domains
domains = arcpy.da.ListDomains(fcworkspace)
#List the fields
fields = arcpy.ListFields(fc)
domainList = []
#Loop through the fields, determine if they have a domain and add
#those with domains to the dictionary and assign it a default value
for field in fields:
if field.domain:
domainList.append(field.domain)
#Create a dictionary to hold the data
domaindict = {}
#Loop through domains and grab the coded values for feature class
for domain in domains:
if domain.domainType =='CodedValue':
if domain.name in domainList:
domaindict[domain.name]=domain.codedValues
textline = ""
for key,value in domaindict.iteritems():
textline = textline + key + '\n'
for k,v in value.iteritems():
textline = textline + '\t' + str(k) + '\t:\t' +str(v) + '\n'
arcpy.AddMessage(textline)
... View more
04-18-2016
11:05 AM
|
1
|
3
|
2198
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 09-14-2015 01:29 PM | |
| 1 | 01-26-2016 10:18 AM | |
| 1 | 08-18-2015 06:01 AM | |
| 1 | 06-20-2016 12:34 PM | |
| 1 | 01-19-2016 06:13 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|