POST
|
Not sure where this belongs, hope I got the right forum. I'm working for a firm where I access GIS data and .mxd files across a VPN network from one state to another. The "server" is a separate drive on a regular desktop computer that is actively used during the day, it is not a dedicated server but it is a newer machine. The connection is extremely slow to the point that map redraws will take 30 seconds where they should only take 2 or 3. Is there any basic wisdom on how to set up Arc for use in an environment where multiple users in different offices need to access the same .mxds and data? My feeling is that the server should be a dedicated machine, how important is that? or will it still be slow if using the same VPN connections and networks?
... View more
06-15-2012
02:51 PM
|
0
|
5
|
8808
|
POST
|
I'm with the perceptive Mr. Quinn. You need to be very careful with .xls and .txt tables that they follows Microsoft Jet/.shp/.dbf file naming limitations: No tables or field names starting with a number, no spaces, no special characters (except "_"), short (10-chars). To avoid trouble, I try to follow these rules with all datasets. You can always be more creative with field aliases and layer names, but the datasets themselves should use "safe" names. If you do that, field names are also less likely to be garbled if the geoprocessing workflow goes through .shp or .dbf formats. If you violate these rules, the tabular data may be read okay, but joins are not likely to work. As for the Copy Features tool, I believe it's a it's a much more useful method than data/export, since when you want to do it again (say after you change the underlying data), you don't need to go wandering through the interface, you can instead pull the Copy Features out of Geoprocessing results and re-run it. The Copy Features tool also is guaranteed to honor the specified environment settings for Current Workspace and Qualified Field Names. Just wanted to get back to this after having reviewed the input table. As far as I can see, no special characters, no numbers first, no spaces etc. I always follow the same rules but hadn't specifically checked this students table so wasn't sure. It may just be a bad table creation process leading to some underlying issue with the table itself. Although I can't see how it would successfully join to a layer but not export. As for exporting dynamic joins and selections, I typically use the data>export method because its right there on the layer. For the researches and academics I work with the contextual right click tools are often easier to find than toolbox tools and it fits their one-off work processes better I think. That said, the Copy Features tool obviously works better with iffy table joins so maybe I need to switch to that tool right away.
... View more
06-12-2012
08:35 AM
|
0
|
0
|
3289
|
POST
|
That is indeed the usual approach. I was simply offering another approach, since the first appeared to be giving mixed results. I appreciate the help, my exasperation wasn't pointed at you. I'm frustrated with the software! For a workaround using the copy features tool seemed to work ok and requires less manual work than the method above but its good to have multiple solutions. But I really need to understand the underlying issue and how to resolve it not just for this student but for future ones as well. I work with dozens of students a quarter here and rely heavily on this function to make permanent copies of their analysis results and table joins and I can't be resorting to workarounds for such a basic function all the time.
... View more
06-07-2012
12:52 PM
|
0
|
0
|
3289
|
POST
|
I'm assuming you are joining your xls layer to the points feature class (not the other way around). You could create dummy empty fields before the join (with same data types as the xls table fields) and then after the join, populate those fields based on the joined table fields. That way, the data will remain permanently in the points feature class, even after the join is removed. Joining table to points, then using Data>Export Data... to make a permanent copy of the points layer. I've done this hundreds of times and is basically the primary method for making a join permanent in ArcGIS. I've encountered the empty export issue a few times here and there but not the problem I described 2) above. Either way this is generally a straightforward function that we use all the time in Arc. It may be here data that's causing the problem, but I can't think of why.
... View more
06-07-2012
12:33 PM
|
0
|
0
|
3289
|
POST
|
A couple approaches come to mind: the Near command, described here or perform a buffer around each earmark point and then geoprocess the buffers into/with the districts. I'm purposely leaving this a little vague as I'd like your student to figure out the specifics.... Thanks. We usually just help with general understanding of the software and science itself but with no actual GIS curriculum on campus we often have to delve into holding hands through analysis design as well. I'd considered buffers but there may be cases where a buffer would cross into nearby districts that don't actually belong to the city the earmark is in. Dialing in the exact right tolerance for a few thousand entrie3s across all 50 states would be difficult if not impossible. I may have come up with a solution though. I'm intersecting the ESRI placeply layer with the congressional districts to get a layer of polygons that contain both the district id and the city it falls into (or more specifically, pieces of the districts broken into their city portions). Table join the earmarks to the intersected layer by city/sate name then merge the output back into districts only on the district name. Still need to figure out the count and proportional sum issue but I think this moving in the right direction. Still looking for input though.
... View more
06-07-2012
11:08 AM
|
0
|
0
|
265
|
POST
|
I have a student with a set of geocoded points representing political earmarks. The earmarks are geocoded to the city effected by (or named in) the earmark. I also have a layer of congressional districts with district IDs. The student wants to assign the earmarks and the sum of their values to the congressional districts they fall into. Many of the cities, and therefore the earmarks associated with them, actually fall into multiple congressional districts. The student would like to assign to each district the count of all earmarks in that district and a proportional sum of the value of the earmarks. My main problem is that the earmarks are geocoded as city points so spatially they fall into only one district, but I need to represent them in each district they actually effect and get a proportional sum on their values (so an earmark in 3 districts would be divided by 3 before being summed into the total earmark value for each district).
... View more
06-07-2012
08:20 AM
|
0
|
4
|
962
|
POST
|
I have two seemingly related problems I need some help with: 1) I have a feature class of points that I joined to a table of data saved as an .xls file. The join works perfectly, however when I make the join permanent by exporting the newly joined layer the new layer has no features, zero entries in the table where it should have 143. I tried several methods of extracting the dynamically joined layer to a new permanent feature class, in the end the only thing that worked was using the copy features tool. 2) Using that now permanent copied points layer, I made a new join to a layer of polygons keeping only matching records. The new table has 7 entries out of 143 possible. Using the normal data>export... method to make the join permanent I get a new feature class but this time instead of 7 features (or none like above) I get 143 features. Does this sounds familiar to anyone? Any idea why this is happening? Dave
... View more
06-07-2012
08:09 AM
|
1
|
17
|
17765
|
POST
|
I'm attempting to convert an ESRI GRID elevation file (bathymetry actually) into an ASCII file so I can use this data in another program. When I run the Raster to ASCII tool shortly after the conversion begins I get the following error: "ArcSOCP EXE has stopped working", you then have the choice to "close the program" or "check online for a solution and close the program". The blue progress scroll continues to display the percent complete but so far all of the resulting .txt files have been empty (0kb). I'm running a student version of ArcGIS 10 in Parallels on my iMac. This is a new install, just yesterday, but I was running the same setup previously with no issues and no other changes to my software or hardware.
... View more
04-13-2012
08:17 AM
|
0
|
1
|
1491
|
POST
|
Strange.. I just tried to make the iterators connect to the ascii 3d tool, no problem, immediately connected as input. I don't know what would be wrong, have you updated to the latest SP? Interesting. What's the ASCII 3d tool? Is that the exact same tool as "ASCII to Raster"? I'll check our SP version when I'm in next (not until Tuesday). Thanks for checking.
... View more
02-17-2012
10:21 AM
|
0
|
0
|
951
|
POST
|
What i see right away is the raster iterator. have you tried using the Iterate files instead? it reads files in a folder and can push that file to a tool, such as the ascii to raster tool Tried all of the iterators, none will link as an input. The "Iterate Files" specifically only has the option to set itself as the precondition to the ASCII tool.
... View more
02-16-2012
12:26 PM
|
0
|
0
|
951
|
POST
|
I have a student who needs to run a series of ASCII to Raster conversions before merging into a single raster. In model builder I add the Raster Iterator, then the ASCII to Raster tool, but when I try to add the link all I get for options are "Environments..." and "Precondition". No option to set the Raster Iterator as the input to the tool. Same results with the other iterators as well (Features, Data-set, Files). Is this an issue with the ASCII tool? Am I missing some other component to make this work? Perhaps the ASCII files need to be in a GDB? Any help is greatly appreciated, David
... View more
02-16-2012
07:57 AM
|
0
|
6
|
4820
|
POST
|
I think Featue To Line tool (ArcInfo license) breaks lines where they intersect or share a segment. Each output line carries the FIDs of all the sharing lines, or -1 for no sharing line with an input fc. You would need to add a field to the result and calculate the count of FIDs that are not -1 by an expression. Again, thank you. That worked as well. I never look to these tools as geometry tools but should probably know more about them (meaning the "feature to..." tools). I did have to massage the table after words. There may be a more automated way of doing this but I simply used a series of selections and field calculations to change the values in each of my 6 FID fields to either a 1 or 0 then used the field calc to sum those into a new column. Now looking at how to create an accumulation of values for each segment based on its location in the river network and the values of all downstream segments. This is going to be a lot more involved and complex so I'll just post a new topic.
... View more
12-07-2011
08:15 AM
|
0
|
0
|
878
|
POST
|
Thank you for letting me know. You are welcome. I am glad it worked for you. 🙂 I have a new similar question if you're interested? I have 6 line feature classes, each one is of a particular fish species distribution in the Oregon river system. Each feature class contains only the line features where that species is present, some lines overlap between the 6 layers, some don't. I want to output a new layer that is a collection of all the river segments from the 6 layers where each segment contains the count of the species in that segment and the unique species names. Union (Analysis) looks like it does what I want but this is a polygon only tool. I think I could do this thru a series of spatial joins to a master hydrology layer but a one time merging of the 6 line layers would work better. Any ideas how I could best tackle this analysis?
... View more
12-05-2011
12:23 PM
|
0
|
0
|
878
|
POST
|
When you run Spatial Join, you can specify a Merge Rule - Count on a field. In your case, for each line you can get a count of matched dam features (FIDs). Sorry for the late reply, thank you Dan, yes this worked great.
... View more
12-05-2011
09:51 AM
|
0
|
0
|
878
|
POST
|
I have what is probably a simple operation to complete in Arc but am unsure of the exact functions or tools to use. I have two feature classes, a set of points (dam locations) and a set of lines (river network). For each section of river I want to add an attribute that is the sum of all dams on that section of river. This seems like a simple operation but I can't quite figure it out in Arc. A spatial join will give me overlapped rerecords for each line-point combination (if one-to-many), but the collect-events tool is for points only so not sure how to recombine the lines and sum the number of points. Any help is appreciated, David
... View more
11-10-2011
10:50 AM
|
0
|
7
|
2494
|
Title | Kudos | Posted |
---|---|---|
1 | 08-19-2013 03:47 PM | |
1 | 06-09-2022 09:41 AM | |
3 | 03-15-2021 03:02 PM | |
2 | 05-10-2022 11:17 AM | |
1 | 09-03-2015 11:17 AM |
Online Status |
Offline
|
Date Last Visited |
05-21-2024
12:05 AM
|