Latest Contributions by GeoffreyWest

I have a Collector for ArcGIS application which records the last_edited_user from the field, however post-processing needs to occur and overwrites my users from the field to my desktop user. Is there a way to lock the last_edited_user to maintain my initial edited user? I am using ArcGIS For Server 10.2.1 and SQL Server Database 2008 R2. ... View more

I have a script which writes the lat/lng of a json web service of bus routes.  The script writes the latitude and longitude to a CSV correctly.  However my table to table conversion does not work correctly in Python. # IMPORTS #Make Python understand how to read things on the Internet import urllib2 #Make Python understand the stuff in a page on the Internet is JSON import json from decimal import Decimal # Make Python understand csvs import csv # Make Python know how to take a break so we don't hammer API and exceed rate limit from time import sleep # tell computer where to put CSV outfile_path='C:\Users\Administrator\PycharmProjects\untitled\json2fgdb.csv' # open it up, the w means we will write to it writer = csv.writer(open(outfile_path, 'wb')) #create a list with headings for our columns headers = ['latitude', 'longitude'] #write the row of headings to our CSV file writer.writerow(headers) # GET JSON AND PARSE IT INTO DICTIONARY # We need a loop because we have to do this for every JSON file we grab #set a counter telling us how many times we've gone through the loop, this is the first time, so we'll set it at 1 i=1 #loop through pages of JSON returned, 100 is an arbitrary number while i<2:    #print out what number loop we are on, which will make it easier to track down problems when they appear    print i    #create the URL of the JSON file we want. We search for 'egypt', want English tweets, #and set the number of tweets per JSON file to the max of 100, so we have to do as little looping as possible    url = urllib2.Request('http://api.metro.net/agencies/lametro/routes/704/vehicles/' + str(i))    #use the JSON library to turn this file into a Pythonic data structure    parsed_json = json.load(urllib2.urlopen('http://api.metro.net/agencies/lametro/routes/704/vehicles/'))    #now you have a giant dictionary. #Type in parsed_json here to get a better look at this. #You'll see the bulk of the content is contained inside the value that goes with the key, or label "results". #Refer to results as an index. Just like list[1] refers to the second item in a list, #dict['results'] refers to values associated with the key 'results'.    print parsed_json    #run through each item in results, and jump to an item in that dictionary, ex: the text of the tweet    for items in parsed_json['items']:    #initialize the row    row = []    #add every 'cell' to the row list, identifying the item just like an index in a list    row.append(str(items['longitude']).encode('utf-8'))   row.append(str(items['latitude']).encode('utf-8'))    #once you have all the cells in there, write the row to your csv    writer.writerow(row)    #increment our loop counter, now we're on the next time through the loop    i = i +1    #tell Python to rest for 5 secs, so we don't exceed our rate limit   #sleep(5)    import arcpy   arcpy.TableToTable_conversion(outfile_path, "C:\dev_folder\orginalDev.gdb", "jsoncsv2" )      This is my table output when running in Python.               This is the output, when using ArcToolBox in ArcCatalog. ... View more

I have a script which prints the lat, lon of bus routes, how would I use arcpy to print this to a table in a file geodatabase? Example of Output 45.266759 -75.741350 45.266221 -75.741675 45.311531 -75.739158 45.355146 -75.769231 45.412336 -75.718080 import xml.etree.ElementTree as ET import urllib u = urllib.urlopen('https://api.octranspo1.com/v1.1/GetNextTripsForStop', 'appID=7a51d100&apiKey=5c5a8438efc643286006d82071852789&routeNo=95&stopNo=3044') data = u.read() f = open('route3044.xml', 'wb') f.write(data) f.close() doc = ET.parse('route3044.xml') for bus in doc.findall('.//{http://tempuri.org/}Trip'):    lat = bus.findtext('{http://tempuri.org/}Latitude')   lon = bus.findtext('{http://tempuri.org/}Longitude')    print lat, lon ... View more

My team and I have a proposed workflow where we would like to consume a SOAP service into our ArcGIS Server. I am new to SOAP services and feel as if I am missing something. The client SOAP service will have customer data, i.e. address, order type, etc entered into a CRM, we would like to retrieve this data via SOAP and have it stored into our database. Their SOAP service is not an ArcGIS Map or Feature Service. ... View more

I would like to use the Bing Hybrid map in a Web Application.  I have so far configured everything with little change to the code other than UI stuff.  Is this possible? ... View more

I have a category field with 9 categories, what's an easy method to go about selecting 1 of each category?  It can be random features, I just need one of each category. ... View more