POST
|
I ran into this yesterday but found it was a bug submitted (in pgdb form) back in 20007. I have 14 digit IDs from a vendor that are A-OK in shapefile as doubles. Copy into file gdb - no problem. Export out to dbase and the last two digits are 00. It must not be a limitation of the dbase format, because all 14 digits are in the original shapefile. I've tried GP tool and from ArcMap UI. Has this really been a bug for 5 years? I can think of two work arounds: export as text file and write the IDs into text fields. It'd be a lot better if there was some way to avoid the whole thing. NIMBUS still shows that bug as "on hold."
... View more
07-18-2012
11:58 AM
|
0
|
5
|
2835
|
POST
|
Thanks very much, guys! I was able to perform the same operation in less than an hour by: a) operating outside of ArcMap b) using Make Feature Layer, Add Join, Copy Features c) making the output a shapefile (it fit) rather than a feature class in the file GDB I'll be in San Diego, hunt me up - I owe beverages.
... View more
07-17-2012
06:19 PM
|
0
|
0
|
351
|
POST
|
I wanted to create a feature layer in a model that only had certain fields in it, but the output had all the fields anyway, which created a mess - renaming and deleting fields in field maps by hand. Is there some trick to getting this to work properly? I keep running into surprise gotchas.
... View more
07-17-2012
03:37 PM
|
0
|
1
|
700
|
POST
|
Hi Harry, an alternative approach is to do MakeFeatureLayer, AddJoin, CopyFeatures. No guarantee, but it may be significantly faster. Thanks Ghislain, I'll give that a whirl. I killed the other join.
... View more
07-17-2012
10:33 AM
|
0
|
0
|
351
|
POST
|
Both tables are in the same file GDB. Both are indexed on the join field. Running Join Field GP tool. After 13 hours, only 30% finished. It is only step one of about 10 such steps. ArcMap is only using 113 MB of my 12 GB of RAM and only one processor of 8, but I don't know how to make it go faster without chopping the data back into shapefile chunks. It's far too late for that this time and I will have to admit defeat *again* to my employer. Is ArcGIS Desktop simply not capable of handling operations on 20+million record joined file GDB tables?
... View more
07-17-2012
08:05 AM
|
0
|
4
|
686
|
POST
|
Performing a join in ArcMap with one file geodatabase, but NO geodatabase can be opened in any ArcMap session while it is happening. Why does this happen? It happens frequently and is killing my productivity. Killed the join process and magically I can open all the geodatabases I want in other sessions. What is happening, and how can I make it stop happening?
... View more
07-16-2012
06:33 PM
|
0
|
0
|
246
|
POST
|
Running in 10.0. Was trying to reset a search cursor in some code, and it didn't work. Tried this little snippet, and it didn't work either. cur = arcpy.SearchCursor("c1") row = cur.next() while row: print row.getValue("FID") row = cur.next() cur.reset() row = cur.next() print row.getValue("FID") The last print statement returns an error, saying the row is NoneType object. I was expecting the cursor to reset and respond to next. What did I do wrong?
... View more
07-16-2012
12:17 PM
|
0
|
1
|
388
|
POST
|
In Modelbuilder 10.0, I am using Iterate Tables to iterates through some DBFs. Each one is to be appended to an existing DBF. The Iterate tool runs, but no follow on tool run. If I select the follow on tool, no matter what it is, and right-click Run, it runs correctly. For some reason, the follow on tools are not running until manually fired. All I do is select Run, no edits to anything. The problem happens when I choose Run Entire Model too - the Iterate goes but no follow on tool. What am I doing wrong?
... View more
07-09-2012
05:54 PM
|
0
|
0
|
647
|
POST
|
I still haven't found a good way to get our big (46 million record) feature class to draw quickly in ArcGIS Explorer, even when zoomed in. In ArcMap at the same scale, things draw fine. On the other hand, poking around the documentation, the contributed add-ins, and the SDK has turned up support for labeling, opening non-geometry tables, showing related records, and joining. A combination of third party and home coded add-ins should allow the software to handle what we could do with ArcView 3.3. I think the thing that might get people interested in converting - maybe - is the integrated support for imagery. Right now the flow goes the other way - export shapefile to KML and load it up in a Google product. I've uninstalled the beta so that I can test out some extensions that run on the released version.
... View more
07-05-2012
05:00 PM
|
0
|
0
|
645
|
POST
|
I ran the routing tool to drive from one place to another in town. I noticed that when I clicked on the map to get my origin and destination, the flags were not added. Nothing was added until I generated directions. I think it would be better to place the flags first. When I double clicked my origin in the the Directions in the ToC, the map centered on the origin, but it zoomed way out, so that the entire rout was less than a fifth of the map extent. Why? That's pretty much opposite of what I would have expected.
... View more
07-03-2012
03:49 PM
|
0
|
0
|
645
|
POST
|
You aren't necessarily doing anything incorrectly, but you may be able to get a better user experience by trying the following: [various good tips] Mark I was able to get good performance with the shapefiles by turning off all the basemap imagery and using some hollow polygon features for the USA, Canada, Counties and points for cities to orient. And the search by Lat Lon made finding the location pretty easy. With no basemap and the map in the data's coordinate system, shapefiles were fast enough. File GDB of the entire country, even when very much zoomed in, was very slow. The File GDB has a spatial index managed by ArcGIS, so I don't know what's wrong. Is it possible to label features or look at tables and do relates in ArcGIS Explorer - I have a feeling that the answer is no, from the documentation, without custom code. If that's the case, our guys will probably stick with AV3.3 until it dies - it can do everything they need, and the data is still shipped to us in shapefiles. It's a toss up for them, though - they'd also like to have the imagery behind the streets. Right now, that's done with KML export and Google. We'd prefer to avoid that.
... View more
07-03-2012
03:19 PM
|
0
|
0
|
564
|
POST
|
Harry Please log a support call, if the output fields are not being created it may be a bug. It will help a lot if you can supply some of your data too. Regards OK. Our IT guy is the designated support person, but I'll ask him. I have a tiny snip of streets, the locator, and one address to reproduce the error. Anyone should be able to reproduce it, since it happens all the time.
... View more
07-03-2012
02:00 PM
|
0
|
0
|
219
|
POST
|
Chopping (or divide and rule) does not always yield better results. You'll have to experiment with an optimum size to divide into. From our experience your results (times) are good enough. Compared to the number of features (40+ millions), 3-4 hours for each process is really good. OK, thanks. In my original post, I said that Make Table View wasn't renaming the fields - that turned out to be user error, I guess, because Make Feature Layer certainly worked.
... View more
07-03-2012
01:40 PM
|
0
|
0
|
317
|
POST
|
Hi Harry, I would like to help your case. I think it is possible to get your job done within ArcGIS. First of all, which version of ArcGIS you are using? Let me be clear about your data. Of the two tables, is it that one of the tables contains records (IDs) of the cities on the left of the streets only and other table contains records (IDs) of the cities on the right? Is the ID of a street is same as the IDs of the cities on its both sides? Is my visualization of your data correct? Hello, Nobbir: I am using ArcGIS 10.0, ArcView license. Here is the data set up: One file geodatabase, on a local drive Streets feature class has a field, ID, that identifies the streets. L_id_name table has two fields, FID (the ID of the street), FULL_NAME (the name of the city on the left side of the street) R_id_name table has two fields, FID (the ID of the street), FULL_NAME (the name of the city on the right side of the street) Here's what I have done and it seems to have worked - but I hope there is a Faster Way: 1. Built indices for ID on streets, FID on L_id_name, FID on R_id_name 2. Joined L_id_name to streets by FID/ID. Persisted this by GP Tool Copy Features as Test1 3. Joined R_id_name to Test1 by FID/ID. Persisted this by GP Tool Copy Features as Test2 (At this point, I had a feature class containing two fields for the left and right city name.) 4. Created a model with Make Feature Layer feeding into Copy Features. I used this model to rename the fields from L_id_name.FULL_NAME, R_id_name.FULL_NAME to L_CITY and R_CITY, which is more user friendly. So, in the end, I did finish! But it took some time: 15 minutes each for the three attribute indices 4 hours each for the copy features I mistakenly ran the model in the foreground and forgot to time it, but I'd say 3-4 hours might be right I think I could have been smart about it using some sort of multi-table join, then Make Feature Layer -> Copy Features and doing all the joining and renaming and copying in one go, but I got scared off by the duplicate field names (I didn't know how ArcGIS would handle that) and went with "one step at a time." I also didn't try chopping, running in parallel, and merging - again trading time for simplicity. Thanks.
... View more
07-03-2012
01:14 PM
|
0
|
0
|
317
|
POST
|
Installed the beta last Friday. Background: I have used the previous version only a little, so there is a decent chance I am using it suboptimally and the performance issues I see are a result of user error. Use case: We have data in shapefiles representing streets in the USA and Canada. Supporting these feature classes and shapefiles are extra tables about maneuvers, etc. The data is stored centrally and is read only. I am evaluating ArcExplorer Desktop as a potential replacement for the couple copies of ArcView 3.3 the field collection guys use to study some tricky intersections. They load up the appropriate shapefile (usually half a million to a million streets) in AV 3.3 very quickly and the guys zoom to their intersection and use a combination of Identify, symbology, and occasionally relates to figure things out. We'd like to move off AV 3.3 before it stops working with some version of Windows. We'd also like to eventually move the data to geodatabase. Here's what I've tried: keeping the data in central shapefiles, local shapefiles, local filegeodatabase, local layer package. Here's what I've seen: ArcExplorer draws the shapes very, very slowing, spending a large amount of time telling me it is "streaming." I can start AV 3.3 and look at the data in the same time I am waiting for the data to render. The field guys will never accept this performance hit. In just a little looking, I was also not able to figure out how to handle the user need to look at other tables by relate. I didn't spend much time on it, though, because the slow drawing was a total deal breaker. I assume I am doing something incorrectly, but if the performance difference is unavoidable, I think our guys will want to stick with AV 3.3 - it is familiar and fast. What am I doing incorrectly?
... View more
07-02-2012
08:52 AM
|
0
|
0
|
564
|
Title | Kudos | Posted |
---|---|---|
1 | 02-21-2013 06:39 AM | |
1 | 02-15-2013 10:25 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|