Latest Contributions by TimHaverland4

Hi Mike, Thanks for giving this a bump. Indeed, you're right, you CAN use Google cloud for deploying ArcGIS Enterprise. Just for fun I did it myself and had no issues, although I used Windows server instances. At the latest Esri Federal GIS conference I asked the Esri cloud folks if there were any limitations to using the Google cloud platform. They said "no limits" and they focus on AWS/Azure because that's what customers are asking for. Cheers, Tim ... View more

Months later and no response ... safe to assume nobody has deployed ArcGIS Server/Portal on the Google cloud? Is it not possible? Or nobody bothers because there are plenty of resources for Azure/AWS? ... View more

Thanks for checking on this Mike. Yes we have been using AGOL for a couple of years now and because we didn't have an identity provider until recently, we have used the default invite process to create non-enterprise accounts, which bases the AGOL account names on the user's email username appended with "_" and our org name. Now to be more secure and to simplify our account management we would like to go to enterprise logins. I will check with our ID provider to see if they can change the NameID for just our ArcGIS Online org. If this is possible, then I think we could write a script using the REST API to periodically check for new enterprise logins, migrate the old content to the new account, deactivate the old account, and notify the user when the process is complete. At some point we would delete the old accounts. Of course it would be great if the enterprise login process could recognize that a matching account exists within the organization and work some magic to change it from a "local account" to an "enterprise account." I suppose if accounts weren't named properly to begin with you could have mix-ups (like mike.brown vs michael.brown), so there would have to be either an admin sign off on the process or the user would have to enter their old account credentials. May be simpler just to bite the bullet and migrate to new account names. Tim ... View more

Hi Mike, Thanks for the reply and for offering to submit this as an enhancement. I would think this is a pretty common occurrence since the default AGOL organizational account naming convention uses the username of the new user's email address, and that username is typically an organization's enterprise login username. One clarification: if an enterprise AGOL account name already exists, will the login fail, or will AGOL create a unique username using the patten <NameID>_<OrgID>? For example, if tim.haverland_noaa exists AGOL will create an account name like tim.haverland9_noaa? This has important implications for how we plan for a migration to enterprise logins. Tim ... View more

Hi David, we are in this exact same situation, having named all of our accounts with the <NameID>_<org_ID> convention (which is the default behavior when creating new accounts manually). Have you learned anything new about how these existing accounts are handled in the enterprise login process? Tim ... View more

Tim, Why are you not using the MakeQueryTable_management? LOCATIONS_T = "Database Connections\\SDE DATABASE.sde\\USERNAME.LOCATION_T" arcpy.MakeQueryTable_management(LOCATION_T, "QueryTable", "USE_KEY_FIELDS", "", "", "Job_Key = " + str(Job_Key)) This brings the queried table in to my project. Hi Scott, I really want to use the MakeQueryLayer because it allows any SQL statement to be issued (including complex joins, grouping, stored function calls, etc). Right now I'm just trying a straight select statement to see if I can get this working. ... View more

Tim, I cannot reproduce this behavior on my machine, what version of ArcGIS (including service packs) are you using? I'm running 10.1 ... no service packs are available as far as I know. I have submitted a tech support request on this (incident 1081341). The analyst on that incident can't reproduce either. I've tried this on both Oracle 11g and PostGIS 9.2 with the same results (table not added and no way to get a reference). I've also tried on a Windows 7 computer w/ connection to same Oracle database with same problem. ... View more

Tim, If you go into your geoprocessing options and check the box for 'Add results of geoprocessing operations to the display' do the results get added to your map? Yes, that option is checked. I've tried MakeQueryLayer_management using a query that returns a spatial column, and the result *does* get added to the display. So the problem seems to lie with queries that don't return a spatial column, resulting in a table (Table View?) Update: also tried this with a postgres database with same result Update 2: using File>Add Data>Add Query Layer... does add the result to ArcMap, as does running the Make Query Layer tool from model builder. Tim ... View more

in this line 'Database Connections\my_database.sde' you're referencing an SDE connection or a workspace.. not a table.. the arguments for the MakeQueryTable command indicate that first argument should be a reference to a table so maybe something like:  'Database Connections\my_database.sde\table_name' would work instead?  MakeQueryTable_management (  in_table, out_table, in_key_field_option, {in_key_field}, {in_field}, {where_clause}) Thanks for the reply. I'm using MakeQueryLayer_management, not MakeQueryTable_management. The first parameter for that tool is "input_database." Do you have any experience with MakeQueryLayer_management? Tim ... View more

Thanks guys - that's very helpful and has me on my way. I did consider the model builder route but think the all-python method will afford me more control. If I'm successful creating a script tool that does this "virtual split layer on attribute(s)" function I'll share the code or working tool. ... View more