Latest Contributions by JohnBroecher

‎04-03-2018

Couldn't find anything in the reference. I'm looking for a way to get a list of all items in my AGO account.

‎03-31-2018

Is it possible to get a list of all arcgis online items with the python module?

‎03-26-2018

Thought I'd share what I'm going to try using. It allows you to type the time as an integer, then it checks that its a valid time and stores it in a hidden field as a string in 00:00 format.

‎03-15-2018

I found the problem. The working python install has arcgis module 1.2.1 and the non-working one has 1.0.1. I had to uninstall pro completely and re-install it. There was a bug in older version of Pro that prevents updating the python modules. Now I have arcgis module 1.2.5 and it works. It was a Pro 1.X updated to 2.0.1, but not uninstalled during the update. Now its a clean Pro 2.1.0 install.

‎03-14-2018

This script works on my Anaconda Python 3.6.4 but I need to run it from the Pro Python installation and it fails saying that the item object has no attribute export. It is supposed to download create an item and download it as a GDB do disk. It seems that gis.content.get function results in a different object type. How can I get this to work in the Pro Python installation? from arcgis.gis import * import time import sys gis = GIS(username="username", password="pswd") data_item_id = '259558969c234c669667adf956e6939d' data_item = gis.content.get(data_item_id) title="Test_Export" + time.strftime("%Y%m%d-%H%M%S") print(data_item) # for testing print(sys.version) # for testing outputgdb = data_item.export(title=title,export_format="File Geodatabase",wait=True) The printed output when it works (data_item and sys.version): >>> <Item title:"Secure_SD_Roadkill" type:Feature Layer Collection owner:username> 3.6.4 |Anaconda, Inc.| (default, Jan 16 2018, 10:22:32) [MSC v.1900 64 bit (AMD64)] The printed output when it fails (data_item and sys.version): numViews=84 spatialReference='GCS_WGS_1984' listed=False scoreCompleteness=66 screenshots=[] guid=None industries=[] created=1519400137000 _portal=<arcgis._impl.portalpy.Portal object at 0x0000000001434160> categories=[] languages=[] tables=None thumbnail='thumbnail/thumbnail.png' _gis=<arcgis.gis.GIS object at 0x0000000001434128> numRatings=0 banner=None ownerFolder='71848e17504e418ea6671ab7fdfdb288' url='https://services.arcgis.com/jWPBXspaQsJStWX8/arcgis/rest/services/Secure_SD_Roadkill/FeatureServer' culture='en-us' access='org' _workdir='C:\\Users\\GFSF12~1\\AppData\\Local\\Temp' modified=1519400162000 itemControl='admin' commentsEnabled=True itemid='259558969c234c669667adf956e6939d' avgRating=0 appCategories=[] tags=['SD', 'Roadkill', 'GFP', 'South', 'Dakota', 'ArcGIS', 'Service Definition', '.sd'] protected=False owner='userName' largeThumbnail=None description=None name='Secure_SD_Roadkill' snippet='Secured Service that has records appended from SD Roadkill Survey123 Data.' proxyFilter=None id='259558969c234c669667adf956e6939d' title='Secure_SD_Roadkill' type='Feature Service' typeKeywords=['ArcGIS Server', 'Data', 'Feature Access', 'Feature Service', 'Service', 'Singlelayer', 'Hosted Service'] licenseInfo=None size=65536 properties=None accessInformation=None documentation=None extent=[[-180, -90], [180, 90]] layers=None numComments=0 _hydrated=False 3.5.3 |Continuum Analytics, Inc.| (default, May 15 2017, 10:43:23) [MSC v.1900 64 bit (AMD64)]

‎03-13-2018

Since Pro stores database connections in a project, how do we connect to a database from within a standalone python script? For example below is how I would have previously connected in ArcGIS 10.5 import arcpy GDB_directory = r"C:\Python Testing" targetEntGDB = r"Database Connections/espr1sql14.sde/" extractedGDB ="600150be54a84779a461d4fc37247f91.gdb" extractedGDB = GDB_directory + "\" +extractedGDB arcpy.Copy_management(extractedGDB, targetEntGDB)

‎11-30-2017

I think I was assuming a related table to be treated the same as an attachment. It doesn't seem to work that way. I can get each related table to download only if I use its index in the URL and select tabular data. Still there is a global ID problem. I enabled attachments but you are saying I actually have to have an attachment in every table to make this work? How would I do that without trashing the surveys? Is there an entirely different approach that you would recommend for me? The related table with index 3 actually does have an attachment but it gives the permission denied error still. Executing: DownloadService true false http://services.arcgis.com/jWPBXspaQsJStWX8/arcgis/rest/services/service_9e43947ea8c54e23aec9c3295a7f37a6/FeatureServer/3 # false true John.Broecher ***** "Database Connections\espr1sql14 prod04 GFSurveys GFSurveys_Admin.sde\GFSurveys.GFSURVEYS_ADMIN.testMOCREEL3" true # Start Time: Thu Nov 30 08:29:25 2017 Running script DownloadService... Generating Token Copying features with ObjectIDs from 0 to 2 Retrieving geodatabase domains Adding domain cvd_Species to geodatabase The value being added to the CodedValueDomain already exists Applying domain cvd_Species to field Species Retrieving geodatabase domains Adding domain cvd_TagType to geodatabase The value being added to the CodedValueDomain already exists Applying domain cvd_TagType to field TagType Retrieving geodatabase domains Adding domain cvd_TagColor to geodatabase The value being added to the CodedValueDomain already exists Applying domain cvd_TagColor to field TagColor Retrieving Attachments Failed script DownloadService... Traceback (most recent call last): File "M:\GFP\Wildlife\Region3\Broecher\ArcGIS Tools\Download Service 11-27-2017\Download Service.py", line 22, in <module> arcpy.GetParameterAsText(8), arcpy.GetParameterAsText(9), arcpy.GetParameterAsText(10)) File "M:\GFP\Wildlife\Region3\Broecher\ArcGIS Tools\Download Service 11-27-2017\DownloadServicewithAttachments_2x.py", line 534, in downloadservice2x urllib.urlretrieve(replicaUrl, cwd + os.sep + 'myLayer.json') File "C:\Python27\ArcGIS10.5\Lib\urllib.py", line 98, in urlretrieve return opener.retrieve(url, filename, reporthook, data) File "C:\Python27\ArcGIS10.5\Lib\urllib.py", line 249, in retrieve tfp = open(filename, 'wb') IOError: [Errno 13] Permission denied: '\\myLayer.json' Failed to execute (DownloadService). Failed at Thu Nov 30 08:32:12 2017 (Elapsed Time: 2 minutes 46 seconds)

‎11-30-2017

I can't seem to share that service with you since its not in my content. I shared another one that gets the same error. This one has 3 related tables, and one of the related tables has attachments. I am trying to figure out how to download dozens of feature services that are made in Survey123 and published from desktop for collector. A lot have related tables and attachments. I have been using a script that uses the downloadSurvey123 library and it works OK but it can only see services published from S123, and sometimes it can't see a S123 because for an unknown reason the sharing in AGO doesn't carry over to S123.

‎11-29-2017

Tried enabling attachments on the parent feature service. It gives me a permission denied error now. It was successfully downloading just the parent table when I unchecked get attachments. Executing: DownloadService true false http://services.arcgis.com/jWPBXspaQsJStWX8/arcgis/rest/services/service_0ba0b35ba4b6436cbe2e9d36eaccc71a/FeatureServer/0 # true false John.Broecher ***** "Database Connections\espr1sql14 prod04 GFSurveys GFSurveys_Admin.sde\GFSurveys.GFSURVEYS_ADMIN.testWeedSpray" true # Start Time: Wed Nov 29 07:54:06 2017 Running script DownloadService... Generating Token Copying features with ObjectIDs from 10 to 659 Retrieving Attachments Failed script DownloadService... Traceback (most recent call last): File "M:\GFP\Wildlife\Region3\Broecher\ArcGIS Tools\Download Service 11-27-2017\Download Service.py", line 22, in <module> arcpy.GetParameterAsText(8), arcpy.GetParameterAsText(9), arcpy.GetParameterAsText(10)) File "M:\GFP\Wildlife\Region3\Broecher\ArcGIS Tools\Download Service 11-27-2017\DownloadServicewithAttachments_2x.py", line 534, in downloadservice2x urllib.urlretrieve(replicaUrl, cwd + os.sep + 'myLayer.json') File "C:\Python27\ArcGIS10.5\Lib\urllib.py", line 98, in urlretrieve return opener.retrieve(url, filename, reporthook, data) File "C:\Python27\ArcGIS10.5\Lib\urllib.py", line 249, in retrieve tfp = open(filename, 'wb') IOError: [Errno 13] Permission denied: '\\myLayer.json' Failed to execute (DownloadService). Failed at Wed Nov 29 07:54:32 2017 (Elapsed Time: 25.83 seconds)

‎11-28-2017

@Jake Skinner Thanks for the script! I noticed the globalid and OBJECTID are changed in the downloaded copy. How do I make this work when I want to download data with related tables that use the globalid field as the key?

‎10-13-2017

I don't see that option in the action menu.

‎10-13-2017

That was it!

‎10-13-2017

I have two accounts for a SQL Server db and two sde connections for that db using the same logins, one is an admin and one is a reader. I create tables in SQL Server using the admin account. They are visible in SQL Server and ArcCatalog using using both the reader and admin accounts. Then after registering the tables in ArcCatalog with the admin account, the tables disappear from the ArcCatalog reader account. How would I make them visible in the reader account again? I am using ArcGIS 10.5.

‎08-28-2017

Thanks for the reply James. Collecting date and time as text seems to make the full keyboard open instead of the number pad, and it would need a constraint to only accept valid dates/times. I am kind of set on collecting date as date and time as integer for this one. I changed the Date to lowercase and it allows publishing but it won't allow me to submit from the device. It gives a code 1000 string or binary data would be truncated. In connect when I view the data from 'Validate Input' it shows: "FishingStartTime": "SyntaxError: Unexpected token `identifier' in expression: format-date(date('1970-01-01') +int( /Lakes_Creel_Survey/Interview/PartyInfo/FishingStartDate )+int(((round( /Lakes_Creel_Survey/Interview/PartyInfo/FishingStartTimeInt -50,-2))div100)*3600000)+int(( /Lakes_Creel_Survey/Interview/PartyInfo/FishingStartTimeInt -(round( /Lakes_Creel_Survey/Interview/PartyInfo/FishingStartTimeInt -50,-2)))*60000),'%m/%d/%Y %H:%M')", I probably don't need the 1970 date in there at all since it is interpreted as zero. I put it there hoping it would help the expression be evaluated as a date.

‎08-24-2017

Most of our Survey123 forms do not require a time entry that is different than the current time. One particular survey does need a time manually entered and the time spinner is proving to be very disliked. I've been asked to come up with a way to enter time as an integer. I have a date field that defaults to today which is what we want, and then the time is entered as a single 24-Hr clock integer (12:15 AM = 0015 or 15, 3:59 PM = 1559). I have a constraint that checks if its a valid time. What I would like to do now is combine the date field with the integer and make a DateTime hidden field. constraint on time integer: (round(${FishingStartTimeInt}-50,-2)<2400) and ((${FishingStartTimeInt}-(round(${FishingStartTimeInt}-50,-2)))<60) For the calculation I have this non-working code: format-date(Date('1970-01-01') + int(${FishingStartDate})+int(((round(${FishingStartTimeInt}-50,-2))div100)*3600000)+int((${FishingStartTimeInt}-(round(${FishingStartTimeInt}-50,-2)))*60000),'%m/%d/%Y %H:%M') I get the error cannot handle Date function. Any suggestions?

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

My Ideas

Latest Contributions by JohnBroecher

Re: get a list of all arcgis items with arcgis python module

get a list of all arcgis items with arcgis python module

Re: Survey123 Date Time Calculation

Re: gis.content.get not working as expected

gis.content.get not working as expected

Database connections in arcgispro-py3

Re: Download ArcGIS Online Feature Service or ArcGIS Server Feature/Map Service

Re: Download ArcGIS Online Feature Service or ArcGIS Server Feature/Map Service

Re: Download ArcGIS Online Feature Service or ArcGIS Server Feature/Map Service

Re: Download ArcGIS Online Feature Service or ArcGIS Server Feature/Map Service

Re: Registering with Geodatabase causes table to disappear in other account

Re: Registering with Geodatabase causes table to disappear in other account

Registering with Geodatabase causes table to disappear in other account

Re: Survey123 Date Time Calculation

Survey123 Date Time Calculation

Re: gis.content.get not working as expected

get a list of all arcgis items with arcgis python ...