POST
|
What is the best way to get in touch with the right people?
... View more
05-29-2020
07:08 AM
|
0
|
1
|
594
|
POST
|
I tried both ways, still have the same issue as before. The only difference now is it will keep the first feature class called out (In this case it is Fibercable) in the table of contents but all other features called out in the script are removed even though the syntax and operations are exactly the same for those features as they are for the Fibercable feature class.
... View more
05-28-2020
12:55 PM
|
0
|
3
|
594
|
POST
|
The Feature class to feature class works for the Fibercable but every other feature is removed from the table of Contents. I do not know what could be doing this.
... View more
05-28-2020
12:26 PM
|
0
|
5
|
1874
|
POST
|
I am running this script from a toolbox. I can confirm that after running the tool. Any Feature class that the script copies is removed from the Table of Contents except for Transfers in this run. It is not always the Transfer Feature class that is kept in the table of contents, but one Feature that is copied is not removed from the TOC while the rest are removed. I also tried running the tool with the geoprocessing option for removing layers unchecked and I still get the same issue.
... View more
05-21-2020
04:00 PM
|
0
|
0
|
1874
|
POST
|
import arcpy
import os
# Variables #
GlobalGDB = r"C:\Users\BB0322\Desktop\DesktopProjects\VanBuran\VanBuran\VanBuran.gdb"
plottingGDB = r"C:\Users\BB0322\Desktop\DesktopProjects\VanBuran\Plotting\Plotting.gdb"
FeederNumber = arcpy.GetParameterAsText(0)
FeederNumber1 = ("'" + FeederNumber + "'")
expression = ("FeederNumber = " + FeederNumber1)
name = FeederNumber.replace('-', '_')
#Book = r"C:\Users\BB0322\Desktop\DesktopProjects\VanBuran\VanBuran\VanBuran.gdb\StakingGrids\StakingGrid_JohnHobbs_6_1"
Book = arcpy.GetParameterAsText(1)
arcpy.env.overwriteOutput = True
try:
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Fibercable", "FiberCable", "", "", "")
fibercableSelect = arcpy.SelectLayerByAttribute_management("FiberCable", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(fibercableSelect, plottingGDB + "\\" + "Fibercable")
print("Fibercable has been saved to the Plotting.gdb")
arcpy.AddMessage("Fibercable has been saved to the Plotting.gdb")
arcpy.CopyFeatures_management(Book, plottingGDB + "\\" + "Book")
print("Book has been saved to the Plotting.gdb")
arcpy.AddMessage("Book has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Aerial", "Aerial", "", "", "")
AerialSelect = arcpy.SelectLayerByAttribute_management("Aerial", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(AerialSelect, plottingGDB + "\\" + "Aerial")
print("Aerial has been saved to the Plotting.gdb")
arcpy.AddMessage("Aerial has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Underground", "Underground", "", "", "")
UndergroundSelect = arcpy.SelectLayerByAttribute_management("Underground", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(UndergroundSelect, plottingGDB + "\\" + "Underground")
print("Underground has been saved to the Plotting.gdb")
arcpy.AddMessage("Underground has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Storage", "Storage", "", "", "")
StorageSelect = arcpy.SelectLayerByAttribute_management("Storage", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(StorageSelect, plottingGDB + "\\" + "Storage")
print("Storage has been saved to the Plotting.gdb")
arcpy.AddMessage("Storage has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "SpliceClosure", "Splice", "", "", "")
SpliceSelect = arcpy.SelectLayerByAttribute_management("Splice", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(SpliceSelect, plottingGDB + "\\" + "Splice")
print("Splice has been saved to the Plotting.gdb")
arcpy.AddMessage("Splice has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Tranfers", "Tranfers", "", "", "")
TransferSelect = arcpy.SelectLayerByAttribute_management("Tranfers", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(TransferSelect, plottingGDB + "\\" + "Transfers")
print("Transfers has been saved to the Plotting.gdb")
arcpy.AddMessage("Transfers has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Removal", "Removal", "", "", "")
RemovalSelect = arcpy.SelectLayerByAttribute_management("Removal", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(RemovalSelect, plottingGDB + "\\" + "Removal")
print("Removal has been saved to the Plotting.gdb")
arcpy.AddMessage("Removal has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Riser", "Riser", "", "", "")
RiserSelect = arcpy.SelectLayerByAttribute_management("Riser", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(RiserSelect, plottingGDB + "\\" + "Riser")
print("Riser has been saved to the Plotting.gdb")
arcpy.AddMessage("Riser has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "AnchorGuy", "AnchorGuy", "", "", "")
AnchorSelect = arcpy.SelectLayerByAttribute_management("AnchorGuy", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(AnchorSelect, plottingGDB + "\\" + "AnchorGuy")
print("AnchorGuy has been saved to the Plotting.gdb")
arcpy.AddMessage("AnchorGuy has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Protection", "Protection", "", "", "")
ProtectSelect = arcpy.SelectLayerByAttribute_management("Protection", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(ProtectSelect, plottingGDB + "\\" + "Protection")
print("Protection has been saved to the Plotting.gdb")
arcpy.AddMessage("Protection has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Equipment", "Equipment", "", "", "")
EquipmentSelect = arcpy.SelectLayerByAttribute_management("Equipment", "NEW_SELECTION", expression, "")
arcpy.CopyFeatures_management(EquipmentSelect, plottingGDB + "\\" + "Equipment")
print("Equipment has been saved to the Plotting.gdb")
arcpy.AddMessage("Equipment has been saved to the Plotting.gdb")
arcpy.MakeFeatureLayer_management(GlobalGDB + "\\" + "Billing" + "\\" + "Poles", "Poles", "", "", "")
PolesSelect = arcpy.SelectLayerByAttribute_management("Poles", "NEW_SELECTION", "Feeder = " + FeederNumber1, "")
arcpy.CopyFeatures_management(PolesSelect, plottingGDB + "\\" + "Poles")
print("Poles has been saved to the Plotting.gdb")
arcpy.AddMessage("Poles has been saved to the Plotting.gdb")
except Exception as e:
print("ERROR: " + e.args[0])
... View more
05-21-2020
01:07 PM
|
0
|
8
|
1874
|
POST
|
I have a python script that copies features based on a query and saves them to a new GDB. When the script copies a feature class, that feature class is removed from the table of contents. How do I keep pro or the script from removing the feature classes when it makes the copies?
... View more
05-21-2020
12:46 PM
|
0
|
13
|
2567
|
POST
|
I am trying to set up an attribute Rule that will calculate the geodesic length of the polyline upon creation. However I keep getting a message saying the projection is invalid. The feature, dataframe and the Dataset in the GDb that it is reading from are all set to the exact same projection. How can I do this? Is it an issue with Arcade language?
... View more
05-14-2020
02:26 PM
|
0
|
2
|
1459
|
POST
|
When you have a callout box with a label text, the text fills in the box perfectly. However if you are using map series in the layout view and the data frame is rotated to the orientation of the individual pages, such as with the strip maps. The text shifts out of the callout box where the greater the rotation of the page the farther offset the text becomes. if the page is oriented at perfect east west or north south the text is positioned perfect but if the page is rotated at all from those positions then the text is offset. This happens even if you convert the labels into annotation and try to manually rotate the label. Is this a bug or is there some way to correct this.
... View more
11-22-2019
10:19 AM
|
1
|
1
|
933
|
POST
|
I have a script that takes an excel, imports it as a table then runs a query to get the needed rows and exports them to a new table. After that a search cursor runs through the table and creates a list of values. It then loops through the list of values and uses the values as an input for the Where Clause for select by attribute to select the correct polygon. That permit polygon is then used to select poles from another feature class and then export those poles as a new feature class named by the value used to select the permit polygon. The problem is passing the value from the list of values into the where clause of the SelectLayerByAttribute_management tool. import arcpy
import datetime
# Variables
time = datetime.date.today()
raw = r"C:\Users\BB0322\Desktop\Projects\MRE_Coversheet\KC\MRE_Table.xlsx"
mre_table = r"C:\Users\BB0322\Desktop\Projects\MRE_Coversheet\KC\KC_MRE.gdb\MRE_Tb"
permits = r"C:\Users\BB0322\Desktop\Projects\MRE_Coversheet\KC\KC_MRE.gdb\Permits"
Poles = r"C:\Users\BB0322\Desktop\Projects\MRE_Coversheet\KC\KC_MRE.gdb\Poles"
work_table = r"C:\Users\BB0322\Desktop\Projects\MRE_Coversheet\KC\KC_MRE.gdb\MRE_workTB"
geoDB = r"C:\Users\BB0322\Desktop\Projects\MRE_Coversheet\KC\KC_MRE.gdb"
arcpy.env.workspace = r"C:\Users\BB0322\Desktop\Projects\MRE_Coversheet\KC\KC_MRE.gdb"
arcpy.env.overwriteOutput = True
try:
print("Creating Table: " + mre_table)
arcpy.ExcelToTable_conversion(raw, mre_table, "Sheet1")
mre_tview = arcpy.MakeTableView_management(mre_table, "MRE_TableView")
arcpy.SelectLayerByAttribute_management(mre_tview, "NEW_SELECTION", "Ticket_Number IS NOT NULL", None)
arcpy.SelectLayerByAttribute_management(mre_tview, "REMOVE_FROM_SELECTION", "Permit_Name = ' '", None)
arcpy.CopyRows_management(mre_tview, work_table)
permitview = arcpy.MakeFeatureLayer_management(permits, "Permits_Layer")
poleview = arcpy.MakeFeatureLayer_management(Poles, "Poles_Layer")
# Creating a list of permit names to pass into the select by attributes for the permit grids
AllValues = []
with arcpy.da.SearchCursor(work_table, ("Permit_Name", "Ticket_Number")) as search:
for row in search:
if row[0] not in AllValues:
AllValues.append(row[0])
# looping through the list and selecting a polygon then using that polygon to select poles located within and exporting those poles into individual feature Classes
for Value in AllValues:
print(Value)
itsa = "permit_name = {}".format(Value)
print(itsa)
expression = str(itsa)
permitSelect = arcpy.SelectLayerByAttribute_management(permitview, "NEW_SELECTION", expression, None)
permitPoly = arcpy.MakeFeatureLayer_management(permitSelect, "permitPoly_" + Value)
poleSelect = arcpy.SelectLayerByLocation_management(poleview, "INTERSECT", permitPoly, "30 FEET", "NEW_SELECTION", "")
arcpy.CopyFeatures_management(poleSelect, geoDB + "\\" + Value)
except Exception as e:
print("ERROR: " + e.args[0]) The error that I am receiving is: ERROR: ERROR 000358: Invalid expression Failed to execute (SelectLayerByAttribute). Thanks for the help.
... View more
08-02-2019
09:16 AM
|
0
|
1
|
1659
|
Title | Kudos | Posted |
---|---|---|
1 | 11-22-2019 10:19 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|