Latest Contributions by AndrewRudin

I've run into a problem registering some rather large feature classes as versioned in my Oracle SDE (Oracle11g and ArcSDE 10.2.2).  I copied these 10 feature classes into my SDE and then right clicked to register as versioned.  It seems to create 3 of the sets of delta tables but then it hangs on the 4th, for 30 minutes at least before I manually ended the ArcCatalog application.  The 4th happens to be a very large table with 2+ million records.  I tried a second time and same problem.  Then I tried only importing the schema's as blank tables.  When I registered as versioned, it ran fine and finished in under 10 seconds. I'm curious why the register as versioned process would hang or take a long time on a table with a lot of records.  Doesn't the register as versioned tool just create the A and D tables and then do a tiny bit of work in the sde admin tables?  The A and D tables will be blank upon creation, and these don't have an exorbitant amount of columns, so it's not like ArcCatalog has to read those big tables and do anything with the records. Thanks, -Andrew ... View more

I'm noticing something different when joining data onto feature classes in ArcGIS Pro (And Desktop) and I'm hoping someone will have insight.  Here's my recollection of how joins work in ArcMap.  When you join data from a foreign table onto a feature class, and that foreign data has a 1:M relationship with the feature class (a.k.a. multiple records in the foreign table with the same ID as a record in the feature class) then ArcMap will only return data from the first record in the foreign table.  I actually did find a bullet about this in the Desktop 9.3 documentation (http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Add_Join_(Data_Management)).  Yesterday I was joining data from one table onto a parcel feature class in Pro 1.1, and suddenly the feature class record count in the attribute table jumped by about 2,000. Pro gave me a warning that the table no longer had unique OID's due to the join.  So did ESRI change how 1:M joins are handled somewhere along the way?  It's happening in ArcMap 10.2.1 as well.  All the data I'm joining is in a 10.2.1 file geodatabase. I don't see the bullet about only returning the first joined record anywhere in the Add Join tool's help for 10.2, so I'm wandering if that functionality was dropped.  I know for some workflows that restriction on joins was an annoyance, but in my situation I wanted it cause for my analysis the parcel layer is the primary table and I don't want "Duplicates" popping up in it.   Thanks for any help you can provide, -Andrew ... View more

Anyone have any ideas why a field calculator function would return different results than an arcpy function written in pyscripter? I'm processing hundreds of thousands of polygons in ArcGIS Desktop 10.2.2 in a model and I want to be able to capture which ones contain a donut hole (a.k.a. at least one part of the polygon forms at least one ring).  Since I don't see any pre-built tools for this, I assume the only way to do this without ArcObjects is through an iteration of each record's shape geometry using Python.  I built a python function in pyscripter using an example in the ESRI help at this location as a template and it worked on my sample data. My problem now is that I get different results when running the python function in ArcMap's field calculator. When the code reads a feature that does have a donut hole in it, the code says it doesn't. Here's my PyScripter code that gives correct results: import arcpy #Begin donut finder function def has_donut(feat):     donut = 'F'     partcount = feat.partCount     for p in range (0,partcount):         part = feat.getPart(p)         for pnt in part:             if not pnt:                 donut = 'T'                 return donut     return donut #set input polygon feature class in_fc = r"C:\my_geodatababase.gdb\my_feature_class #Loop over feature class records and print donut search result with arcpy.da.SearchCursor(in_fc,['OID@','SHAPE@']) as cur:     for row in cur:         oid = str(row[0])         donut_type = has_donut(row[1])         print oid + ": " + donut_type Here's my ArcMap field calculator setup that returns False even when a polygon contains a donut: Parser: Python Pre-Logic Script Code: def has_donut(feat):     donut = 'F'     partcount = feat.partCount     for p in range (0,partcount):         part = feat.getPart(p)         for pnt in part:             if not pnt:                 donut = 'T'                 return donut     return donut Field Calculator Expression: has_donut( !SHAPE!) ... View more

I am a graduate student who is familiar with ArcGIS Desktop and now I'm trying to learn about creating ArcGIS Online applications.  I am having problems getting started and hoping someone can answer some questions?  I am new the ArcGIS lexicon so forgive me if I use the wrong name for something: Can students at schools with Campus-wide site licenses obtain an ArcGIS Online account that can publish hosted layers?  All I did to get started was create a free public account but it doesn't seem to do what I need to test creating a simple application.  At this time I just want to learn and don't really have a big enough need to purchase a full license.  Could do the 30-day trial license if I have to but was hoping there was some sort of account that could go along with the 1-year free student Desktop license I have. Is there a way with someone with a free public account to upload a simple line and shapefile to their account and create a map and/or application with them?  I don't see an option after I upload a zip file containing my shapefile. I thought a good start would be to create a web application where a user enters 2 addresses (a from_address and a to_address), then the code would find a transit stop point near that address, grab the ID's of transit routes that stop at that point, and then  display all those routs on the map in a highlighted color.  The only layer's I would upload are a transit stop point layer and a transit route line layer.  Can I write a toolbox tool that the application would use to do the "closest stop" and route line selection query and then somehow plug it into the online application?  Or do I have to do all that in javascript? Thanks for any help you can provide getting me started ... View more

My JTX users have reported our system becoming slower, particularly when running workflows.  It seems to have gotten slower over time and now we are up to 11,000 jobs after 7 years. Below is a list of our JTX system tables and a record count for each. I'm curious if there are common things to look for with bigger JTX repositories.  My users have mainly mentioned slow response when running through our workflow.  I have some steps that execute sql and it seems to take a while and my guess is its making a new connection to the database just to populate one field in a table.  Otherwise it seems some of the other steps take some time as well.  We first thought exporting and removing some of the older jobs and job_types would help, but then we found out we can only really export abut 1000 of them, since the other 10,000 are used when we query the system.  However, by removing those 1000 we could delete a lot of old step types and job types.  I would think its the bloat in the JTX_HISTORY, JTX_JOB_STE_XREF, and JTX_JOB_STEP and JTX_STEP_STATUS and JT_STATUS_HIST that could be causing slow response when moving about the workflow. Thank you for any help you can provide, Andrew Table Name Records JTX_ADMIN.JTX_HISTORY 798894 JTX_ADMIN.JTX_JOB_STEP_XREF 533102 JTX_ADMIN.JTX_JOB_STEP 475710 JTX_ADMIN.JTX_STEP_STATUS 289752 JTX_ADMIN.JTX_STATUS_HIST 113122 JTX_ADMIN.JTXX_AMANDA_ATTACHMENT_COUNT 58931 JTX_ADMIN.JTXX_PLANSTATUS_BYGROUP_VW 15316 JTX_ADMIN.JTXX_STORMWATER_PLAN_DETAIL 14820 JTX_ADMIN.JTXX_PLANSTATUS_BYGROUP_VW_1 14618 JTX_ADMIN.JTXX_SW_MULTIPART_POLY_VW 11989 JTX_ADMIN.JTX_JOBS 11298 JTX_ADMIN.JTX_JOB_BLOB 11288 JTX_ADMIN.JTX_JOBS_DB 11084 JTX_ADMIN.JTXX_JOB_KEYINFO 10157 JTX_ADMIN.JTXX_SW_PLAN_DETAIL_JOBID_VW 9902 JTX_ADMIN.jtxx_sw_plan_page_counts 8754 JTX_ADMIN.sw_plan_page_count 8754 JTX_ADMIN.JTX_JOB_ATTACHMENTS 5101 JTX_ADMIN.JTX_TRANSACTION_SESSIONS 2195 JTX_ADMIN.CONST_PLAN_EXT_PROP 591 JTX_ADMIN.JTX_JOB_TYPE_STEP_XREF 437 JTX_ADMIN.JTX_JOB_TYPE_STEP 394 JTX_ADMIN.JTXX_SW_PLANGROUPID 209 JTX_ADMIN.JTXX_PLANGROUPSTATUS_VW 198 JTX_ADMIN.JTX_AUX_PROPS 186 JTX_ADMIN.JTX_PRIV_XREF 150 JTX_ADMIN.JTXX_SSM_EXTENDED_PROPERTIES 113 JTX_ADMIN.JTX_USER_GROUP_XREF 109 JTX_ADMIN.JTX_STEP_TYPE 87 JTX_ADMIN.JTX_LOGIN_INFO 68 JTX_ADMIN.JTX_LAYERS 63 JTX_ADMIN.JTX_JOB_TYPE_PROPERTIES 58 JTX_ADMIN.JTX_QUERY_CONTAINERS 54 JTX_ADMIN.JTX_USERS 52 JTX_ADMIN.JTX_QUERY_OWNERS 50 JTX_ADMIN.JTX_JOB_DATA 46 JTX_ADMIN.JTXX_PR_VW 41 JTX_ADMIN.JTX_PROPERTIES 39 JTX_ADMIN.JTX_JOB_TYPE_BLOB 30 JTX_ADMIN.JTX_PRIVILEGES 30 JTX_ADMIN.JTX_WORKFLOW_STORE 30 JTX_ADMIN.JTX_ACTIVITY_TYPES 29 JTX_ADMIN.JTX_JOB_TYPES 29 JTX_ADMIN.JTX_JOB_QUERIES 28 JTX_ADMIN.JTX_NOTIFICATIONS 25 JTX_ADMIN.JTX_JOB_TYPE_REL_CLASSES 15 JTX_ADMIN.JTX_STATUS 14 JTX_ADMIN.JTX_PROP_RELATIONSHIPS 10 JTX_ADMIN.JTX_USER_GROUPS 10 JTX_ADMIN.JTXX_DIG_RANDOM_NUMBER 10 JTX_ADMIN.JTX_TOKEN_PARSERS 6 JTX_ADMIN.JTX_USER_GROUP_JOB_FILTERS 6 JTX_ADMIN.JTX_JOB_TYPE_MAP_DOC 4 JTX_ADMIN.JTX_REPORT_QUERIES 4 JTX_ADMIN.JTX_REPORTS 4 JTX_ADMIN.JTX_OBJECT_PERMISSIONS 4 JTX_ADMIN.JTX_PRIORITY 3 JTX_ADMIN.JTXX_EXTRA_PROPERTIES 2 JTX_ADMIN.JTX_DATABASES 2 JTX_ADMIN.JTX_MAP_STORE 2 JTX_ADMIN.JTXX_TV_INSPECTION_WORK_ORDER 2 JTX_ADMIN.JTX_DATABASE_SCHEMA 1 JTX_ADMIN.JTXX_DIG_QC_QUOTE 1 JTX_ADMIN.JTX_HISTORY_SESSIONS 0 JTX_ADMIN.JTX_HOLD_TYPES 0 JTX_ADMIN.JTX_JOB_DEPENDENCIES 0 JTX_ADMIN.JTX_JOB_FILTER_XREF 0 JTX_ADMIN.JTX_JOB_FILTERS 0 JTX_ADMIN.JTX_JOB_HOLDS 0 JTX_ADMIN.JTX_NOTIFICATION_SUBSCRIBERS 0 JTX_ADMIN.JTX_SPAT_NOTIF_LAYERS 0 JTX_ADMIN.JTX_SPAT_NOTIF_MATCHES 0 JTX_ADMIN.JTX_SPAT_NOTIF_RULE_CONDITION 0 JTX_ADMIN.JTX_SPAT_NOTIF_RULES 0 JTX_ADMIN.JTX_STEP_COMMENTS 0 JTX_ADMIN.JTX_TASK_ASSISTANT_WORKFLOWS 0 JTX_ADMIN.JTX_TRANSACTIONS_TEMP 0 JTX_ADMIN.JTX_TRANSACTIONS 0 JTX_ADMIN.JTX_CONN_INFO 0 JTX_ADMIN.JTX_HISTORY_DATASETS 0 JTX_ADMIN.JTX_DELETED_OBJECTS 0 JTX_ADMIN.JTX_REPLICATION_INFO 0 JTX_ADMIN.Prod_ComponentVersion 0 JTX_ADMIN.JTXX_GIS_UPDATE_REQUESTS 0 ... View more

Please add an option for ArcGIS Server Map Service publishers to allow local caching of tiled services that clear out the local cache after each ArcMap session. Currently in ArcMap there is an option on Map Services that allows tiled services to be cached locally, and then cleared when the session ends.  This is a happy medium between using the same cache forever(even if the tiles on the server are updated) and not using a cache at all (super slow) However, ArcGIS Server administrators don't have this third option when they publish map services.  Currently our ArcGIS server administrators will not enable caching of our tiled services since they are concerned users will not delete their caches manually and thus could be using older tiles that might be updated.  I think if they had an option they could control that forced the user's PC to clear the cache for their service, this would provide assurance users have the latest data, and they can have the speed boost of a local cache.   Thank you ... View more

Please add an option for ArcGIS Server Map Service publishers to allow local caching of tiled services that clear out the local cache after each ArcMap session. Currently in ArcMap there is an option on Map Services that allows tiled services to be cached locally, and then cleared when the session ends.  This is a happy medium between using the same cache forever(even if the tiles on the server are updated) and not using a cache at all (super slow) However, ArcGIS Server administrators don't have this third option when they publish map services.  Currently our ArcGIS server administrators will not enable caching of our tiled services since they are concerned users will not delete their caches manually and thus could be using older tiles that might be updated.  I think if they had an option they could control that forced the user's PC to clear the cache for their service, this would provide assurance users have the latest data, and they can have the speed boost of a local cache.   Thank you ... View more

Does anyone know how to use python to find every field (and fields on subtypes) that use a particular domain? Our SDE is 10.2 and on an Oracle database, and I have desktop 10.2.1. Basically if I need to change a domain (like change it's data type from string to integer) I need to delete it and recreate it.  In order to delete it I need to find every place it's used and un-reference it. This is hard to do in a large SDE where domains are shared between many fields and feature classes. The out of the box method seems to be looping through EVERY feature class(and subtype) on the database and running arcpy.describe on every field see if they use a particular domain.  This seems extremely inefficient and will take forever on our large SDE.  Surely there must be a better way. I figured querying the SDE administration tables would be quicker but ran into some walls.  By querying the GDB_Items and GDB_ItemRelationship tables I was able to see what feature classes reference a domain, but these don't seem to tell you which field(s) are using the domain, nor does it seems to show if a particular subtype uses a domain. I was curious how SDE at 10.2 actually stores that a field is using domain x, and also how it tracks that subtype y uses domain x.  This way I can query the administration tables directly to make this process much faster. I plan to use the proper toolbox tools to make the domain assignment changes, I just want to query the administrative tables to find the references and quickly as possible. Thank you for any help you can provide, Andrew ... View more

Are the flow directions of edges in a geometric network supposed to come over when sync'd through a replica?  The flow direction I set in the parent geodatabase did not appear in the child geodatabase after my one-way replica was sync'd.  The feature comes over and it looks like the network connectivity is intact, so its just the network flow that's not updating.  In the parent system if I create a feature and then set the network flow 'with digitized direction' and then do a sync, the replicated feature has indeterminate flow.  Wasn't sure if this was a bug or by design. Here's my setup: Desktop 10.2 (Not 10.2.1) SDE 10.2 on Oracle 11gR2 database Replicating to 10.2 file geodatabase Geometric network consists of one point and one line feature class. Line feature class is a complex edge One-way replica- Parent to child Replica Access Type set to Full Tried replication with and without archiving and get same result. Thanks for any help you can provide, Andrew ... View more