Latest Contributions by JaredPilbeam2

Are the Data Categories restricted to a certain data type when using the Tag Query? I've added the tag Transportation to a few feature services in AGOL. I then added the same tag here in the Tag Query box. But, after clicking on this Data Category link in the website for testing I only get one result. I was expecting all the feature services to be there. I'm not sure what's going on. ... View more

Using PythonWin 2.7.10, I would like to append a date to a bunch of zipfiles in a folder. I've been using the time module which prints the current month, day and year. But, I'm not sure how to append this date to the end of my zipfiles' file name. In this case I've been running tests on the WillCounty_PLSS.zip file, which contains a shapefile. This script seems to work, but it creates an odd looking file with no content: import time import arcpy from arcpy import env ws = arcpy.env.workspace = r'\\gisfile\GISstaff\Jared' current_time = time.strftime("%m%d%Y") output_name = "WillCounty_PLSS.zip" + current_time output_file = open(ws + output_name, "w") print current_time‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Here's how the file was named:  JaredWillCounty_PLSS.zip02072018 EDIT: What do I need to do to have the look like this: WillCounty_PLSS_02072018.zip? ... View more

Using arcpy.da.SearchCursor, how do you sort data in either ascending or descending order? I noticed the old arcpy.SearchCursor had sort_fields. arcpy.SearchCursor(dataset, {where_clause}, {spatial_reference}, {fields}, {sort_fields})‍‍ I have a script that uses arcpy.da.SearchCursor to create a list of table fields. The "D" in the function of line 8 is meant to put it in descending order, but it does not. env.workspace = r'\\gisfile\GISstaff\Jared\ModelBuilder\TEST folder\TESTGDB.gdb' #variables intable = "ElectionResults_Nov2016" tbList = [] #create list #use cursor to get all unique values in field, and list them in ascending order for row in arcpy.da.SearchCursor(intable, "ContestTitle", "D"):     if row[0] not in tbList:         tbList.append(row[0])‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ EDIT: I've also been looking into sorted. It's a matter of placing it in the cursor, though. sorted()‍ ... View more

TableSelect_analysis(in_table, out_table, {where_clause})‍‍‍‍ "Selects table records matching a Structured Query Language (SQL) expression and writes them to an output table." Using this function I have this simple script: import arcpy from arcpy import env env.workspace = r'\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb' #variables intable = r"\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb\ElectionResults_Nov2016" outtable = r"\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb\Results3" where_clause = "ContestTitle = 'BALLOTS CAST - TOTAL'" arcpy.TableSelect_analysis(intable, outtable, where_clause)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ It selects all records named 'BALLOTS CAST - TOTAL' from the 'ContestTitle' column of my 'ElectionResults_Nov2016' table and writes them in the newly created 'Results3' table. 'BALLOTS CAST - TOTAL' is only one of 58 separate table record names. How can I write all 58 to their own tables? Thanks for any help. ... View more

I have a script that uses a Python package called arcpy_metdata. It basically allows you to get at ArcGIS metadata. The script is set up to write the metadata to a text file and runs without errors, but unfortunately HTML code used to format the Description and Limitation items also gets written. It interferes with the readability of the textfile. I contacted the author of the package and he suggested BeautifulSoup, which leads to my question. I have this so far, but am at a loss at how to implement it: from bs4 import BeautifulSoup cleantext = BeautifulSoup(raw_html).text‍‍‍‍ And here is my Metadata2Txt script: import arcpy import arcpy_metadata as md import re ws = r'Database Connections\ims to Plainfield.sde\gisedit.DBO.Tax_Map_LY\gisedit.DBO.Tax_Map_Parcels_LY' metadata = md.MetadataEditor(ws) path = r'\\gisfile\GISstaff\Jared\Python Scripts\Test\Parcels' ##cleantext = BeautifulSoup(raw_html).text def meta2txt():     title = metadata.title     tags = metadata.tags     purpose = metadata.purpose     abstract = metadata.abstract     credits = metadata.credits     citation = metadata.citation     limitation = metadata.limitation     extent_description = metadata.extent_description     desc = arcpy.Describe(ws)     sr = desc.spatialReference     tf = open(path + " " + "{}".format("Metadata.txt"), "w")     tf.write("Metadata Content:" + "\n")     tf.write("----------------------------------------------" + "\n")     if title:         print('Title:\n{}\n'.format(title))         tf.write('Title:\n{}\n'.format(title) + '\n')     else:         print('Title: \nThere is no title.\n')         tf.write('Title: \nThere is no title.\n' + '\n')             if tags:         print('Tags:\n{}\n'.format(tags))         tf.write('Tags:\n{}\n'.format(tags) + '\n')     else:         print("Tags: \nThere are no tags.\n")         tf.write('Tags: \nThere are no tags.\n' + '\n')     if purpose:         print('Summary:\n{}\n'.format(purpose))         tf.write('Summary:\n{}\n'.format(purpose) + '\n')     else:         print('Summary: \nThere is no summary.\n' + '\n')         tf.write('Summary: \nThere is no summary.\n' + '\n')     if abstract:         print('Description:\n{}\n'.format(abstract))         tf.write('Description:\n{}\n'.format(abstract) + '\n')     else:         print('Description: \nThere is no description.\n')         tf.write('Description: \nThere is no description.\n' + '\n')     if credits:         print('Credits:\n{}\n'.format(credits))         tf.write('Credits:\n{}\n'.format(credits) + '\n')     else:         print('Credits: \nThere are no credits.\n')         tf.write('Credits: \nThere are no credits.\n' + '\n')     if citation:         print('Citation:\n{}\n'.format(citation))         tf.write('Citation:\n{}\n'.format(citation) + '\n')     else:         print('Citation: \nThere is no citation.\n')         tf.write('Citation: \nThere is no citation.\n' + '\n')     if limitation:         print('Limitation:\n{}\n'.format(limitation))         tf.write('Limitation:\n{}\n'.format(limitation) + '\n')     else:         print('Limitation: \nThere is no limitation.\n')         tf.write('Limitation: \nThere is no limitation.\n' + '\n')     if extent_description:         print('Extent:\n{}\n'.format(extent_description))         tf.write('Extent:\n{}\n'.format(extent_description) + '\n')     else:         print('Extent: \nThere is no extent.\n')         tf.write('Extent: \nThere is no extent.\n' + '\n')     if sr:         print('Spatial Reference:\n{}\n'.format(sr.name))         tf.write('Spatial Reference:\n{}\n'.format(sr.name) + '\n')     else:         print('Spatial Reference: \nThere is no spatial reference.\n')         tf.write('Extent: \nThere is no spatial reference.\n' + '\n') meta2txt()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Here's how Description item of this particular feature class looks in the textfile after running the script: Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The tax map parcels layer is published every year normally during the spring through the Will County Clerk Tax Extension. This layer contains various parcels within Will County. The tax map parcels entered is only digitized based upon plats and recorded documents received by the Tax Extension within the Will County Clerk Office. </SPAN></P></DIV></DIV></DIV>‍‍‍‍‍‍‍‍‍‍‍‍ ... View more