nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to store photos other than BLOB format?

LeeBrannon

When taking photos into the Collector app and then getting the BLOB format for them in my exported FGDB, I have not found a way to access the photos nor to see them attached to the feature they were collected with outside of AGOL. I feel like the BLOB format has my photos locked up with no way to view them - except in AGOL. The exported (from AGOL) FGDB contains the feature class with my collected features, plus an attachment table that lists my jpeg photos, plus the relationship class - see attached image.

What am I doing wrong? I'm using a hosted feature layer in AGOL. Would this work better if I used a feature service from my ArcGIS Server?

fgdb.PNG

ScratchFolder.png

Encuentra más publicaciones etiquetadas con

Accepted answers

ScottFierro2

We ran into this and if you are comfortable with some python then this will work. It will bring everything down to your FGDB and create folders named by GUID with the appropriate JPEG's extracted inside of them.

Here are the instructions for the python tool:

1) Create local file geodatabase to hold data and attachments you want to download from ArcGIS Online (called data.gdb in script)

2) Create feature class (called myLayer in script), enable attachments, add globalID's

3) Add the following field to the feature class -GlobalID_str, text, length: 50

4) Create table called MatchTable (called MatchTable in script).

5) Add the following fields to the MatchTable table:
- GlobalID_Str, text, length: 50
- PhotoPath, text length: 255

6) Enable "sync" on hosted feature service (http://resources.arcgis.com/en/help/arcgisonline/index.html#//010q000000n0000000)

7) Open AGOL_pullFeatures script in text editor and modify the following:
    -ArcGIS Online username/password
    -REST url to feature service to pull from
    -path to and name of local file geodatabase
    -fields to pull from the hosted feature service (must match local feature class)
    -name of local feature class (this will hold the data from the hosted service and the attachments)

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">,</SPAN> urllib2<SPAN class="punctuation token">,</SPAN> datetime<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> json


<SPAN class="comment token">## ============================================================================== ##</SPAN>
<SPAN class="comment token">## function to update a field - basically converts longs to dates for date fields ##</SPAN>
<SPAN class="comment token">## since json has dates as a long (milliseconds since unix epoch) and geodb wants ##</SPAN>
<SPAN class="comment token">## a proper date, not a long.</SPAN>
<SPAN class="comment token">## ============================================================================== ##</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateValue</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN>field_to_update<SPAN class="punctuation token">,</SPAN>value<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; outputfield<SPAN class="operator token">=</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>f <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fields <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN>field_to_update<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>None<SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token">#find the output field</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> outputfield <SPAN class="operator token">==</SPAN> None <SPAN class="operator token">or</SPAN> value <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#exit if no field found or empty (null) value passed in</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> outputfield<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> value <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># filter "zero" dates</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>fromtimestamp<SPAN class="punctuation token">(</SPAN>value<SPAN class="operator token">/</SPAN><SPAN class="number token">1000</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp; <SPAN class="comment token"># convert to date - this is local time, to use utc time</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>field_to_update<SPAN class="punctuation token">,</SPAN>value<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># change "fromtimestamp" to "utcfromtimestamp"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>field_to_update<SPAN class="punctuation token">,</SPAN>value<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN>
<SPAN class="comment token">## ============================================================================== ##</SPAN>

<SPAN class="comment token">### Generate Token ###</SPAN>
gtUrl <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fwww.arcgis.com%2Fsharing%2Frest%2FgenerateToken" target="_blank">https://www.arcgis.com/sharing/rest/generateToken</A><SPAN>'</SPAN></SPAN>
gtValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'username'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'password'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'referer'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fwww.arcgis.com" target="_blank">http://www.arcgis.com</A><SPAN>'</SPAN></SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'f'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'json'</SPAN> <SPAN class="punctuation token">}</SPAN>
gtData <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>gtValues<SPAN class="punctuation token">)</SPAN>
gtRequest <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>gtUrl<SPAN class="punctuation token">,</SPAN> gtData<SPAN class="punctuation token">)</SPAN>
gtResponse <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>gtRequest<SPAN class="punctuation token">)</SPAN>
gtJson <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>gtResponse<SPAN class="punctuation token">)</SPAN>
token <SPAN class="operator token">=</SPAN> gtJson<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'token'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">### Create Replica ###</SPAN>
<SPAN class="comment token">### Update service url HERE ###</SPAN>
crUrl <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fservices1.arcgis.com%2FXXX%2Farcgis%2Frest%2Fservices%2FFeatureLayerName%2FFeatureServer%2FCreateReplica" target="_blank">http://services1.arcgis.com/xyz/arcgis/rest/services/FeatureLayerName/FeatureServer/CreateReplica</A><SPAN>'</SPAN></SPAN>

crValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'json'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'layers'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'0'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'returnAttachments'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'true'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'token'</SPAN> <SPAN class="punctuation token">:</SPAN> token <SPAN class="punctuation token">}</SPAN>
crData <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>crValues<SPAN class="punctuation token">)</SPAN>
crRequest <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>crUrl<SPAN class="punctuation token">,</SPAN> crData<SPAN class="punctuation token">)</SPAN>
crResponse <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>crRequest<SPAN class="punctuation token">)</SPAN>
crJson <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>crResponse<SPAN class="punctuation token">)</SPAN>
replicaUrl <SPAN class="operator token">=</SPAN> crJson<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'URL'</SPAN><SPAN class="punctuation token">]</SPAN>
urllib<SPAN class="punctuation token">.</SPAN>urlretrieve<SPAN class="punctuation token">(</SPAN>replicaUrl<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'myLayer.json'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">### Get Attachment ###</SPAN>
cwd <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>getcwd<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'myLayer.json'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> data_file<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; data <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>data_file<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> x <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'layers'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attachments'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; gaUrl <SPAN class="operator token">=</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'url'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; gaFolder <SPAN class="operator token">=</SPAN> cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\\photos\\'</SPAN> <SPAN class="operator token">+</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'parentGlobalId'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>exists<SPAN class="punctuation token">(</SPAN>gaFolder<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>makedirs<SPAN class="punctuation token">(</SPAN>gaFolder<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; gaName <SPAN class="operator token">=</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'name'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; gaValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'token'</SPAN> <SPAN class="punctuation token">:</SPAN> token <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; gaData <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>gaValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; urllib<SPAN class="punctuation token">.</SPAN>urlretrieve<SPAN class="punctuation token">(</SPAN>url<SPAN class="operator token">=</SPAN>gaUrl <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> gaName<SPAN class="punctuation token">,</SPAN> filename<SPAN class="operator token">=</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gaFolder<SPAN class="punctuation token">,</SPAN> gaName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>data<SPAN class="operator token">=</SPAN>gaData<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">### Create Features ###</SPAN>
rows <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/myLayer'</SPAN><SPAN class="punctuation token">)</SPAN>
fields <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/myLayer'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> cfX <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'layers'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; pnt <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; pnt<SPAN class="punctuation token">.</SPAN>X <SPAN class="operator token">=</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'x'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; pnt<SPAN class="punctuation token">.</SPAN>Y <SPAN class="operator token">=</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'y'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> rows<SPAN class="punctuation token">.</SPAN>newRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>shape <SPAN class="operator token">=</SPAN> pnt

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">### Set Attribute columns HERE ###</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">## makes use of the "updatevalue function to deal with dates ##</SPAN>

&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Route_Code'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Route_Code'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Primary_Route'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Primary_Route'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Street_Name'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Street_Name'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Structure_Type'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Structure_Type'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Pole_Designation_Number'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Pole_Designation_Number'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Visible_Cracks'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Visible_Cracks'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Number_Of_Cracks'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Number_Of_Cracks'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Longest_Crack_Length'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Longest_Crack_Length'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Pole_Multi_Sided'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Pole_Multi_Sided'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Number_Of_Sides'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Number_Of_Sides'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Number_Of_Anchor_Bolts'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Number_Of_Anchor_Bolts'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Anchor_Bolt_Cracked'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Anchor_Bolt_Cracked'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Nuts_Loose'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Nuts_Loose'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Lock_Washers_OK'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Lock_Washers_OKs'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FollowUp_Status'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FollowUp_Status'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FollowUp_Comments '</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FollowUp_Comments '</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FollowUp_Complete'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FollowUp_Complete'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'District'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'District'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'County'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'County'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># leave GlobalID out - you cannot edit this field in the destination geodb</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#comment out below fields if you don't have them in your online or destination geodb (editor tracking)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'CreationDate'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'CreationDate'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Creator'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Creator'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EditDate'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'EditDate'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Editor'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Editor'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'GlobalID_str'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; rows<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN> row
<SPAN class="keyword token">del</SPAN> rows

<SPAN class="comment token">### Add Attachments ###</SPAN>
<SPAN class="comment token">### Create Match Table ###</SPAN>
rows <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/MatchTable'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> cmtX <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'layers'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attachments'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> rows<SPAN class="punctuation token">.</SPAN>newRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'GlobalID_Str'</SPAN><SPAN class="punctuation token">,</SPAN> cmtX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'parentGlobalId'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'PhotoPath'</SPAN><SPAN class="punctuation token">,</SPAN> cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\\photos\\'</SPAN> <SPAN class="operator token">+</SPAN> cmtX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'parentGlobalId'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\\'</SPAN> <SPAN class="operator token">+</SPAN> cmtX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'name'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; rows<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN> row
<SPAN class="keyword token">del</SPAN> rows

<SPAN class="comment token">### Add Attachments ###</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddAttachments_management<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/myLayer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID_Str'</SPAN><SPAN class="punctuation token">,</SPAN> cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/MatchTable'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID_Str'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PhotoPath'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

ScottFierro2

Here are the instructions for the python tool:

1) Create local file geodatabase to hold data and attachments you want to download from ArcGIS Online (called data.gdb in script)

2) Create feature class (called myLayer in script), enable attachments, add globalID's

3) Add the following field to the feature class -GlobalID_str, text, length: 50

4) Create table called MatchTable (called MatchTable in script).

5) Add the following fields to the MatchTable table:
- GlobalID_Str, text, length: 50
- PhotoPath, text length: 255

6) Enable "sync" on hosted feature service (http://resources.arcgis.com/en/help/arcgisonline/index.html#//010q000000n0000000)

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">,</SPAN> urllib2<SPAN class="punctuation token">,</SPAN> datetime<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> json


<SPAN class="comment token">## ============================================================================== ##</SPAN>
<SPAN class="comment token">## function to update a field - basically converts longs to dates for date fields ##</SPAN>
<SPAN class="comment token">## since json has dates as a long (milliseconds since unix epoch) and geodb wants ##</SPAN>
<SPAN class="comment token">## a proper date, not a long.</SPAN>
<SPAN class="comment token">## ============================================================================== ##</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">updateValue</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN>field_to_update<SPAN class="punctuation token">,</SPAN>value<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; outputfield<SPAN class="operator token">=</SPAN>next<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>f <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fields <SPAN class="keyword token">if</SPAN> f<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">==</SPAN>field_to_update<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>None<SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token">#find the output field</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> outputfield <SPAN class="operator token">==</SPAN> None <SPAN class="operator token">or</SPAN> value <SPAN class="operator token">==</SPAN> None<SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#exit if no field found or empty (null) value passed in</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> outputfield<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Date'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> value <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># filter "zero" dates</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>fromtimestamp<SPAN class="punctuation token">(</SPAN>value<SPAN class="operator token">/</SPAN><SPAN class="number token">1000</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp; <SPAN class="comment token"># convert to date - this is local time, to use utc time</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>field_to_update<SPAN class="punctuation token">,</SPAN>value<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># change "fromtimestamp" to "utcfromtimestamp"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>field_to_update<SPAN class="punctuation token">,</SPAN>value<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN>
<SPAN class="comment token">## ============================================================================== ##</SPAN>

<SPAN class="comment token">### Generate Token ###</SPAN>
gtUrl <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fwww.arcgis.com%2Fsharing%2Frest%2FgenerateToken" target="_blank">https://www.arcgis.com/sharing/rest/generateToken</A><SPAN>'</SPAN></SPAN>
gtValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'username'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'password'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'referer'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fwww.arcgis.com" target="_blank">http://www.arcgis.com</A><SPAN>'</SPAN></SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'f'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'json'</SPAN> <SPAN class="punctuation token">}</SPAN>
gtData <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>gtValues<SPAN class="punctuation token">)</SPAN>
gtRequest <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>gtUrl<SPAN class="punctuation token">,</SPAN> gtData<SPAN class="punctuation token">)</SPAN>
gtResponse <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>gtRequest<SPAN class="punctuation token">)</SPAN>
gtJson <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>gtResponse<SPAN class="punctuation token">)</SPAN>
token <SPAN class="operator token">=</SPAN> gtJson<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'token'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token">### Create Replica ###</SPAN>
<SPAN class="comment token">### Update service url HERE ###</SPAN>
crUrl <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fservices1.arcgis.com%2FXXX%2Farcgis%2Frest%2Fservices%2FFeatureLayerName%2FFeatureServer%2FCreateReplica" target="_blank">http://services1.arcgis.com/xyz/arcgis/rest/services/FeatureLayerName/FeatureServer/CreateReplica</A><SPAN>'</SPAN></SPAN>

crValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'json'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'layers'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'0'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'returnAttachments'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'true'</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">'token'</SPAN> <SPAN class="punctuation token">:</SPAN> token <SPAN class="punctuation token">}</SPAN>
crData <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>crValues<SPAN class="punctuation token">)</SPAN>
crRequest <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>crUrl<SPAN class="punctuation token">,</SPAN> crData<SPAN class="punctuation token">)</SPAN>
crResponse <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>crRequest<SPAN class="punctuation token">)</SPAN>
crJson <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>crResponse<SPAN class="punctuation token">)</SPAN>
replicaUrl <SPAN class="operator token">=</SPAN> crJson<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'URL'</SPAN><SPAN class="punctuation token">]</SPAN>
urllib<SPAN class="punctuation token">.</SPAN>urlretrieve<SPAN class="punctuation token">(</SPAN>replicaUrl<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'myLayer.json'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">### Get Attachment ###</SPAN>
cwd <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>getcwd<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'myLayer.json'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> data_file<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; data <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>data_file<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> x <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'layers'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attachments'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; gaUrl <SPAN class="operator token">=</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'url'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; gaFolder <SPAN class="operator token">=</SPAN> cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\\photos\\'</SPAN> <SPAN class="operator token">+</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'parentGlobalId'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>exists<SPAN class="punctuation token">(</SPAN>gaFolder<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>makedirs<SPAN class="punctuation token">(</SPAN>gaFolder<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; gaName <SPAN class="operator token">=</SPAN> x<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'name'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; gaValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'token'</SPAN> <SPAN class="punctuation token">:</SPAN> token <SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; gaData <SPAN class="operator token">=</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>gaValues<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; urllib<SPAN class="punctuation token">.</SPAN>urlretrieve<SPAN class="punctuation token">(</SPAN>url<SPAN class="operator token">=</SPAN>gaUrl <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> gaName<SPAN class="punctuation token">,</SPAN> filename<SPAN class="operator token">=</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>gaFolder<SPAN class="punctuation token">,</SPAN> gaName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>data<SPAN class="operator token">=</SPAN>gaData<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">### Create Features ###</SPAN>
rows <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/myLayer'</SPAN><SPAN class="punctuation token">)</SPAN>
fields <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/myLayer'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> cfX <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'layers'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; pnt <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; pnt<SPAN class="punctuation token">.</SPAN>X <SPAN class="operator token">=</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'x'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; pnt<SPAN class="punctuation token">.</SPAN>Y <SPAN class="operator token">=</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'y'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> rows<SPAN class="punctuation token">.</SPAN>newRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>shape <SPAN class="operator token">=</SPAN> pnt

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">### Set Attribute columns HERE ###</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">## makes use of the "updatevalue function to deal with dates ##</SPAN>

&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Route_Code'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Route_Code'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Primary_Route'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Primary_Route'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Street_Name'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Street_Name'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Structure_Type'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Structure_Type'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Pole_Designation_Number'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Pole_Designation_Number'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Visible_Cracks'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Visible_Cracks'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Number_Of_Cracks'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Number_Of_Cracks'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Longest_Crack_Length'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Longest_Crack_Length'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Pole_Multi_Sided'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Pole_Multi_Sided'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Number_Of_Sides'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Number_Of_Sides'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Number_Of_Anchor_Bolts'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Number_Of_Anchor_Bolts'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Anchor_Bolt_Cracked'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Anchor_Bolt_Cracked'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Nuts_Loose'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Nuts_Loose'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Lock_Washers_OK'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Lock_Washers_OKs'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FollowUp_Status'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FollowUp_Status'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FollowUp_Comments '</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FollowUp_Comments '</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FollowUp_Complete'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'FollowUp_Complete'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'District'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'District'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'County'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'County'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'NLFID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># leave GlobalID out - you cannot edit this field in the destination geodb</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#comment out below fields if you don't have them in your online or destination geodb (editor tracking)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'CreationDate'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'CreationDate'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Creator'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Creator'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EditDate'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'EditDate'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Editor'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Editor'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; updateValue<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'GlobalID_str'</SPAN><SPAN class="punctuation token">,</SPAN> cfX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; rows<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN> row
<SPAN class="keyword token">del</SPAN> rows

<SPAN class="comment token">### Add Attachments ###</SPAN>
<SPAN class="comment token">### Create Match Table ###</SPAN>
rows <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/MatchTable'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> cmtX <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'layers'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attachments'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> rows<SPAN class="punctuation token">.</SPAN>newRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'GlobalID_Str'</SPAN><SPAN class="punctuation token">,</SPAN> cmtX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'parentGlobalId'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'PhotoPath'</SPAN><SPAN class="punctuation token">,</SPAN> cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\\photos\\'</SPAN> <SPAN class="operator token">+</SPAN> cmtX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'parentGlobalId'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\\'</SPAN> <SPAN class="operator token">+</SPAN> cmtX<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'name'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; rows<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN> row
<SPAN class="keyword token">del</SPAN> rows

<SPAN class="comment token">### Add Attachments ###</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddAttachments_management<SPAN class="punctuation token">(</SPAN>cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/myLayer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID_Str'</SPAN><SPAN class="punctuation token">,</SPAN> cwd <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/data.gdb/MatchTable'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID_Str'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PhotoPath'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

LeeBrannon

Thanks Scott. I'm still trying to get the script to work without error. Will the script work as is with polygons? Polygons are what I am testing it on, but I see a code reference in there in the ### Create Features ### section for "row.shape = pnt" ...aka arcpy.Point().

zkovacs

Lee

I've seen quite a few Python scripts trying to download the content from AGOL, but I like this one best. It creates and downloads a replica of your hosted data (all features and photos) as a FGDB with much less code then above for example. Then you can use another code (or compile them together if needed) to extract the photos from the attachment table - and maybe write the extracted photos' path back to the feature table. (Like one of my past projects required).

I hope this helps.

Zoltan

ScottFierro2

Ours was a point data set and that piece is building the records. Can't quote off top of my head but should be a somewhat similar logic to generate and build polygon records instead of point records.

Quick Google search I did find this page which at the bottom provides logic for looping to generate the polygons.

http://pro.arcgis.com/en/pro-app/arcpy/get-started/reading-geometries.htm

LeeBrannon

Thanks for the other option Zoltan, but I did finally get the script from Scott working, just this morning and will focus on that solution.

LeeBrannon

Scott, I just got the pullFeatures script to work on point data, which is great and will probably suffice for our requirement for photo points. Thanks again!

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.