Latest Contributions by OLANIYANOLAKUNLE

‎09-29-2013

I want to use arcpy to dynamically position a graphic element on my layout, I have parcels with different shape and size. The position of the parcel affects my graphic element when it is static. I want to use the number of lines that form the parcels to dynamically position the graphic element on the layout sheet i.e. if the number of lines is 4 it should be at a particular position, if it is 6 then the position should also change dynamically? Any suggestions, Thanks

‎09-29-2013

I want to dynamically place a graphic element on my layout page. I have a lot of parcels of different sizes, I intend to use the number of lines that actually makes the parcel to position the graphic element. The number of lines vary from parcel to parcel thus affecting the static location of the graphic element. Any suggestions thanks.

‎08-13-2013

Thanks for answering my question, I just found out that I need an authorization code to connect to a non-Express database, does ESRI have any installation setup for the enterprise ArcSDE geodatabase? Thank you.

‎08-13-2013

I have serious difficulties trying to connect to an SQL Server instance, different from an express instance, anytime I try to connect to the instance I get this error message "Connections to this edition of the database server are not supported" Any suggestions.

‎08-01-2013

Please can you help me with this: I want to create the following Nested folders i.e. - StateName - arcpy.CreateFolder_management("C:\\", str(val)) - LGAName(DistrictName) this would be created inside the StateName Folder - arcpy.CreateFolder_management("C:\\", str(val),outName) - PlotNo(BlockNo) this would be created inside the LGAName(DistrictName) Folder - arcpy.CreateFolder_management("C:\\", str(val)+ outName,outName1) - arcpy.mapping.ExportToPDF(mxd,r"C:\\", str(val) + outName + "\\" + outName1 + "\\" + "Land Granted To " + outName2) I'm having this "cant take more than two arguments issue especially with the last two create folder statements and the export to pdf statement this was the script I used below fc = "Parcels" field = "OBJECTID" field1 = "Plot_No" field2 = "Block_No" field3 = "Name_Allottee" field4 = "TDP_Status" field5 = "LGA" field6 = "District" field7 = "Shape.STLength()" field8 = "SitePlan_Status" cursor = arcpy.SearchCursor(fc) for row in cursor: #row.getValue(field) val = row.getValue(field) val1 = row.getValue(field1) val2 = row.getValue(field2) val3 = row.getValue(field3) val4 = row.getValue(field4) val5 = row.getValue(field5) val6 = row.getValue(field6) val7 = row.getValue(field7) val8 = row.getValue(field8) outName = str(val5) + "_LGA" + "(" + str(val6) + "_Area" + ")" outName1 = "Plot_" + str(val1) + "(" "Block_" + str(val2) + ")" outName2 = str(val3) + " Block_" + str(val2) + "_Plot_" + str(val1) + "_" + str(val6) + "_Area_of_" + str(val5) + "_LGA" + ".pdf" arcpy.CreateFolder_management("C:\\", str(val),outName) arcpy.CreateFolder_management("C:\\", str(val)+ outName,outName1) arcpy.mapping.ExportToPDF(mxd,r"C:\\", str(val) + outName + "\\" + outName1 + "\\" + "Land Granted To " + outName2) os.startfile(r"C:\\", str(val) + outName + "\\" + outName1 + "\\" + "Land Granted To " + outName2) Kindly assist please. Thanks

‎07-31-2013

Thanks that works perfectly

‎07-30-2013

I still have the same error check it below: >>> mxd = arcpy.mapping.MapDocument("Current") >>> df = arcpy.mapping.ListDataFrames(mxd)[0] >>> fc = "Parcels" >>> field = "StateName" >>> cursor = arcpy.SearchCursor(fc) >>> for row in cursor: ... val = row.getValue(field) ... >>> arcpy.CreateFolder_management("C:\\{0}".format(val)) Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 14477, in CreateFolder raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000735: Folder Name: Value is required Failed to execute (CreateFolder).

‎07-30-2013

This is my code and the error message received also mxd = arcpy.mapping.MapDocument("Current") df = arcpy.mapping.ListDataFrames(mxd)[0] fc = "Parcels" field = "StateName" cursor = arcpy.SearchCursor(fc) for row in cursor: val = row.getValue(field) arcpy.CreateFolder_management("C:\\"+ "\\" + Str(val) + "\\") Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 14477, in CreateFolder raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000735: Folder Name: Value is required Failed to execute (CreateFolder). Any suggestions?

‎07-03-2013

Is ArcGIS 10.1 Compatible with the SQL Server 2012 or SQL Server Express 2012?

‎07-02-2013

Thanks Y'All mdenil, lmwood & rzufelt you guys are the BEST.....

‎07-02-2013

I was trying to construct the sql statement below to label a feature lyr = arcpy.mapping.ListLayers(mxd, "Line_Clip")[0] for lblClass in lyr.labelClasses: lblClass.SQLQuery = '"ParcelID"' + "=" + str(val) + "AND" + "Bearing" + ">" + 180 TypeError: cannot concatenate 'str' and 'int' objects Please any help, thank you.

‎06-23-2013

I want to calculate the angle at which a line meets another line with arcpy, i dont want to use the arcpy.CalculateGridConvergenceAngle_cartography command. Please check the attached image for further illustration [ATTACH=CONFIG]25430[/ATTACH] Please any suggestions. Thank you

‎06-19-2013

I want to use Arcpy and not ordinary PYTHON

‎06-19-2013

I want to construct an SQL Statement to select even or odd FIDs/OBJECTIDs using Arcpy, I tried MOD("FID", 2) = 1, this is not working from my python window but it is from my table view. Any suggestions please?

‎05-27-2013

Thanks jscheirer I tried to insert your code into my script and this was the error message I got; arcpy.CalculateField_management("Annos","TEXTS","!TEXTSTRING!.remove_codes","PYTHON_9.3","") Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 3128, in CalculateField raise e ExecuteError: ERROR 000539: Error running expression: "{\fArial|b0|i0|c0|p34;C - 40}".remove_codes Traceback (most recent call last): File "<expression>", line 1, in <module> AttributeError: 'str' object has no attribute 'remove_codes' Failed to execute (CalculateField). Please what do you think I can do?

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by OLANIYANOLAKUNLE

I want to use arcpy to dynamically position a graphic element on my Layout

I want to dynamically place a graphic element on my layout

Re: HOW CAN I ADD AN SQL SERVER INSTANCE DIFFERENT FROM AN SQL EXPRESS INSTANCE

HOW CAN I ADD AN SQL SERVER INSTANCE DIFFERENT FROM AN SQL EXPRESS INSTANCE

Re: I want to create a folder using an attribute value from a feature

Re: I want to create a folder using an attribute value from a feature

Re: I want to create a folder using an attribute value from a feature

I want to create a folder using an attribute value from a feature

Is ArcGIS 10.1 Compatible with the SQL Server 2012 or SQL Server Express 2012

Re: I'M GETTING THIS ERROR "TypeError: cannot concatenate 'str' and 'int' objects"

I'M GETTING THIS ERROR &quot;TypeError: cannot concatenate 'str' and 'int' objects&quot;

I WANT TO CALCULATE THE ANGLE AT WHICH A LINE MEETS ANOTHER LINE WITH ARCPY

Re: I WANT TO CONSTRUCT AN SQL STATEMENT TO SELECT EVEN OR ODD FIDs USING ARCPY

I WANT TO CONSTRUCT AN SQL STATEMENT TO SELECT EVEN OR ODD FIDs USING ARCPY

Re: I NEED TO EXTRACT THE FIRST LETTER AND THE MIDDLE LETTER OF A STRING ATTRIBUTE VA

Re: Export data from Map Service

Use Arcpy to Unselect the currently selected Featu...

Re: I need to automatically calculate a field base...

Re: I need to automatically calculate a field base...

How Can I Close an mxd using arcpy script