POST
|
Thanks. I guess that makes sense. It finally finished after a couple hours.
... View more
09-18-2015
08:07 AM
|
0
|
0
|
492
|
POST
|
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
09-14-2015
03:21 PM
|
0
|
3
|
3179
|
POST
|
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
08-11-2015
06:55 AM
|
0
|
1
|
2351
|
POST
|
Thanks for the recommendation, Xander. I think a toolbox exposed python script is probably the best way to go for my situation. I wish the field calculator had a debugging function that could call pyscripter for issues like this. My only guess on the difference is that the way field calculator loops over records is different than the searchcursor in arcpy, and thus the variables are getting handled differently. Darren, on the issue of the "if not pnt" line and how it works to capture donut holes, I ran the loop again and set some watches: Here's the watch list while its on a valid point in the part: And here's what it looks like when it gets to the donut hole: The only reason I knew about it is from the ESRI Help example about reading polygon geometries. They had that if statement in there with a comment that it specifically is for inner rings. It still begs the question what the inner ring really is, but I'm not that concerned with it at this juncture in my life. Thank you everyone for your help
... View more
01-28-2015
06:46 AM
|
1
|
0
|
1624
|
POST
|
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
01-27-2015
03:00 PM
|
0
|
5
|
6567
|
POST
|
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
07-03-2014
02:01 PM
|
0
|
1
|
1659
|
POST
|
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
05-16-2014
03:00 PM
|
0
|
1
|
3482
|
POST
|
FYI, I'm still in the process of implementing this process, but here's my plan right now 1. Use FME server to update the feature classes on the second sde at night. (it is less finicky than replication and doesn't require the datasets to be versioned. You can tell it to compare an ID and whatever other fields you want to identify inserts/updates/deletes and make the appropriate edits.) 2. After the feature classes are updated the tables that drive the geometric network on the target system will be invalid since FME doesn't manage those. To fix this, I am writing an ArcPy python script that will run afterwards. It will temporarily version the target dataset, , run the repair geometric network tool, run the set flow tool, and then unversion (check option to compress edits in DEFAULT to base).
... View more
05-01-2014
12:40 PM
|
0
|
0
|
289
|
IDEA
|
-->
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
03-31-2014
11:12 AM
|
6
|
0
|
336
|