Latest Contributions by OlyPowers

I cannot be the only person to come across this problem, but I have yet to find a solution that works. I have a script that counts the number of features that intersects another feature, and cycles through the file using the UpdateCursor. Everything has been going smoothly, until I came across an attribute that has special characters in it. Due to reasons, I cannot remove the apostrophes, ampersands, forward slashes, etc. from the attribute data and have to account for these in the code.   edit.startEditing(False, True) edit.startOperation() with arcpy.da.UpdateCursor(subdivisions, ['Subd_Name', 'LOTS', 'CON_STATUS']) as subdivUpdate: for each in subdivUpdate: if subdivUpdate[2] != "UNDERCON" or subdivUpdate[2] != "ESTBLSHD": sub = subdivUpdate[0] query1 = 'Subd_Name = \'{}\''.format(sub) subDiv = arcpy.management.SelectLayerByAttribute(subdivisions, 'NEW_SELECTION', query1) selectedParcels = arcpy.management.SelectLayerByLocation(parcels, 'HAVE_THEIR_CENTER_IN', subDiv) numberOfParcels = arcpy.GetCount_management(selectedParcels) print(subdivUpdate[0]) each[1] = int(str(numberOfParcels)) print(numberOfParcels) subdivUpdate.updateRow(each) edit.stopOperation() edit.stopEditing(True)   Everything runs the way it is supposed to until it comes across a record with a special character in it, and throws the error,  arcgisscripting.ExecuteError: ERROR 000358: Invalid expression Failed to execute (SelectLayerByAttribute). I have tried several combinations of triple quotes around the query, but they've all failed as soon as it reaches a record with special characters. If there's a better way of dynamically inserting the query value I'm all ears.   Thanks in advance for any help! ... View more

I have a layout that is large and very graphics intensive. There are four map frames, and each has at least 3-4 layers that are being blended together with Blend Modes, with the smallest scale being 1:3000. So it's not encompassing a super big area. I understand this will take a while to export. The issue I'm having is that after waiting between 4-16 hours (that is not a typo) for each export, none of the documents are exporting properly. Either one of the frames is missing the blended basemap, or it's tiled the entire document, or whole sections or text are omitted from the file. I've been trying to export to a Tiff, as I've found in the past that this allows me to retain the most quality when printing. However I'm also having similar issues when exporting to PDF or JPEG. I'm using 300 dpi (450-600 dpi took over 24 hrs to export last time I tried), and using several compression options. My computer has over 300 GB of free space and 32 GB of RAM. Is there a best practice for exporting layouts like this? I want to preserve as much quality as possible as this is a for print document. Thanks in advance for any advice! ... View more

I'll admit I'm still new to parcel fabrics. I've taken over our city's parcel maintenance, and I've come across this several times now but this is the first occasion where it's a problem. The parcel in question appears to have an incorrect arc. While in the parcel details screen, two arcs appear in the lines table. When I select the line from the table, the correct arc is highlighted. I cannot find the row that corresponds to the other line in the table. When the parcel details is closed, the correct line disappears and the incorrect arc remains. I have no idea where to even being fixing this. Any help would be greatly appreciated. Thanks, Oly ... View more