POST
|
Hi Julie, I don't see the script attached to this message, can you post it again?
... View more
09-18-2014
01:50 PM
|
0
|
0
|
3394
|
POST
|
No, if you want to use the Create Enterprise Geodatabase tool with a predefined tablespace for SDE, you can allow the tool to create the user and grant permissions to sde. However, you will need to specify the existing tablespace name in the tool under the Tablespace Name parameter. As long as that tablespace name exists, the tool will assign the SDE user to that tablespace.
... View more
09-18-2014
07:56 AM
|
0
|
5
|
1060
|
POST
|
Here is a picture showing the output when DefQ is outside the parameters.
... View more
08-13-2014
06:58 AM
|
1
|
1
|
2905
|
POST
|
It looks like you are missing a right parentheses on your "b" variable. #Current b variable
b = sum(row[0] for row in arcpy.da.SearchCursor(fc, 'QUANTITY_SOLID')),DefQ
#This returns both the b variable and the definition query separated by a comma similar to a tuple
#Should be to return a value of b from a search cursor with definition query DefQ
b = sum(row[0] for row in arcpy.da.SearchCursor(fc, 'QUANTITY_SOLID',DefQ))
The original script has the definition query outside the parameters of the SearchCursor tool. Then when the "b" variable is called later on, it is read as a tuple instead of a single string/integer/float/etc. By moving the definition query inside the parentheses, it should return a value "b" from search cursor with definition query "DefQ". This should return a single variable instead of a tuple.
... View more
08-13-2014
06:54 AM
|
1
|
2
|
2905
|
POST
|
I'm glad to hear this worked! The reason that it won't work in a File Geodatabase is because it requires the use of a subquery ("Elev_Diff in (select MIN(Elev_Diff) from <featureclass>”) which isn't supported in a File Geodatabase as of yet. One way that this could be worked around is by running the process through Python and finding the minimum value there instead.
... View more
08-06-2014
08:06 AM
|
0
|
0
|
874
|
POST
|
I believe that the issues being faces are related to the geodatabase referenced in G (7_Match_DTM_Assessment.gdb) and used for the FC to FC in B. This is currently a File Geodatabase (.gdb) and needs to be a Personal Geodatabase with a .mdb extension.
... View more
08-06-2014
07:43 AM
|
2
|
2
|
5468
|
POST
|
Can you send a picture of your model and the settings of the "Name” variable?
... View more
08-06-2014
07:04 AM
|
0
|
4
|
4577
|
POST
|
No problem. Do you get the error when running the model or verifying the SQL expression? If it happens during the verify, this would be expected because the verification does not substitute the value of the inline variable when evaluating an expression. When the tool runs, the value of the inline variable is substituted in the expression and the results are created based on the substituted values. (See link here)
... View more
08-05-2014
06:25 AM
|
0
|
6
|
4588
|
POST
|
Hi Jamie, Here is how I set up my model. I put all of the shapefiles into a Personal Geodatabase, then used the iterate tool to loop through them and create a new feature class using the following expression: [Area_SqFt] in (select MIN( [Area_SqFt]) from %Name%)
... View more
08-04-2014
09:01 AM
|
0
|
8
|
4593
|
POST
|
Finding the minimum value: This may be difficult to do as shapefiles don't fully support subqueries (See link here). However, if the data were stored within a Personal Geodatabase (MDB) this could be done using the following query: Elev_Diff in (select MIN(Elev_Diff) from <featureclass>) Exporting a file with the name of its input: I would suggest adding another tool to the end of the model, Copy Features, to copy the selected features to a new file.
... View more
08-04-2014
07:03 AM
|
1
|
10
|
4594
|
POST
|
Hi Harlan, I just had some quick questions about this: What is the current projection of each layer? Which tool did you use to do the projection to NAD 1983 HARN?
... View more
07-24-2014
07:30 AM
|
0
|
0
|
438
|
POST
|
Can you upload a picture or text of the feature extent from the shapefile properties?
... View more
07-24-2014
07:26 AM
|
0
|
2
|
282
|
POST
|
In this case, the two differences only point to the Schema owner in the database. If the base name "GDM_CO_AREA_83” has not changed, you could control for the schema owner name change.
... View more
07-17-2014
02:00 PM
|
0
|
1
|
813
|
POST
|
Hi Jennifer, We can handle the issue of not having the same number of layers. The layer names may be a little harder to automate, but may be doable. How have the new names changed and do you have a list of which ones line up?
... View more
07-17-2014
01:50 PM
|
0
|
3
|
813
|
POST
|
This should be some that is doable for your work. One tool that will be helpful in scripting is the Feature Compare tool which will compare a number of variables. Using this tool we should be able to script this for all of your layers. This could also be done through ModelBuilder. Feature Compare: ArcGIS Help (10.2, 10.2.1, and 10.2.2) This is a sample workflow logic that could be used to script this process: import arcpy, os
#Create DB Connections to both databases
gdb91 = r"DB Connection"
gdb101 = r"DB Connection"
#Create a list to store the feature classes from both databases
list91 = []
list101 = []
#List the feature classes
arcpy.env.workspace=gdb91
fcList = arcpy.ListFeatureClasses()
for fc in fcList:
list91.append(fc)
arcpy.env.workspace=gdb101
fcList = arcpy.ListFeatureClasses()
for fc in fcList:
list101.append(fc)
#Compare the feature name and them compare the feature classes themselves
for fc91 in list91:
try:
idx = list101.index(fc91)
fc101 = list101[idx]
path91 = os.path.join(gdb91,fc91)
path101 = os.path.join(gdb101,fc101)
arcpy.FeatureCompare_management(path91, path101, out_compare_file=r"C:\CompareFile\{0}.txt".format(fc91))
except:
print "Cannot compare layer {0}".format(fc91)
... View more
07-17-2014
01:29 PM
|
1
|
5
|
813
|
Title | Kudos | Posted |
---|---|---|
2 | 03-28-2024 05:12 AM | |
2 | 12-20-2023 06:42 AM | |
5 | 08-31-2023 05:42 PM | |
1 | 03-21-2023 11:38 AM | |
9 | 03-15-2023 08:13 AM |
Online Status |
Offline
|
Date Last Visited |
Wednesday
|