|
POST
|
You should reexamine the abilities of the Summary Statistics tool before you dismiss it as only oriented to the needs of mere ArcView/Basic users. 1. Frequency requires you to select at least one case field and although it allows you to select multiple case fields you are limited to selecting them in the order that they occur within the data source. This means that when you select multiple fields that the sort order of the multiple unique combined case field values is restricted to the field arrangement of the original source. Summary Statistics allows you to select no case field, one case field, or multiple case fields. When you use multiple case fields they can be arranged in any order that you like. Therefore the sort order of the multiple unique combined case field values can be in any arrangement that you like and is free from any restrictions of the source data field arrangement order, 2. Frequency does not require you to include a summary value, but if you do you can only output the Sum of numeric fields. The summed fields must be arranged in the order that they appear in the source data. With Summary Statistics you are required to create at least one summary field, but it can produce any form of summary value you want (Sum, Min, Max, Mean, Range, Standard Deviation, Count, First and Last). It can summarize numeric fields and text fields (Min, Max, Count, First, Last being the most useful text summaries). The order of the summary fields can be outputted in any arrangement that you like and you can get multiple different types of summary values on any given source field. Although date fields are filtered out of the Summary fields drop down, you can actually still type them into the Summary Fields text Box and press enter to add them to the summary field list. After they are added to the summary field list you can choose any of the summary options that are available for numbers. The output of date summaries will be the numeric representations of the date (Min, Max, First, Last) or calculations based on the date (all other summaries). If you use the Field Calculator to transfer a Min, Max, First or Last date number into an actual date field the date number will be transformed back to its native date appearance. Given all of the abilities of the Summary Statistics tool, I see no reason to ever use the Frequency tool again. Thanks Rich for your extreme intelligence on the matter, like I said they serve different purposes. It seems that Riverside County Trans employees have lots of free time on their hands. Thanks for your service.
... View more
10-24-2013
04:40 PM
|
0
|
0
|
1820
|
|
POST
|
I did not recommend Frequency, because it requires an Advanced license while Summary Statistics is available with a Basic license, and in my opinion Summary Statistics can do everything Frequency can do and more. If the Summary Statistics/Frequency tool is used in Model Builder or a python script and you can script the response to duplicate values without user interaction you do not have to output a file if you output it to an in_memory table Really, unaware that there was a license restriction... Rich. I see Summarize as more oriented towards ArcView Users while Frequency is more oriented towards ArcInfo users. I see them as solving different scenarios. I see these responses as providing alternative ways to do something, like I got to learn from Tim with his Support example. Good point though about in_memory, don't use in_memory much... just love the List Comprehension example, very elegant approach.
... View more
10-24-2013
03:55 PM
|
0
|
0
|
1820
|
|
POST
|
Another cool sample that does a unique, but not necessarily a summarize is from the following help doc. This is nice because you don't have to output a table, you can see a unique list on screen, so in the end the frequency is better and more related to your question, but there is an output file. Sometimes a unique handles what you need, plus this is just a cool sample. http://resources.arcgis.com/en/help/main/10.2/index.html#//018w00000011000000 import arcpy
fc = "c:/data/base.gdb/well"
field = "Diameter"
# Use SearchCursor with list comprehension to return a
# unique set of values in the specified field
#
values = [row[0] for row in arcpy.da.SearchCursor(fc, (field))]
uniqueValues = set(values)
print(uniqueValues)
or
uniqueValues = sorted(set(values))
print(uniqueValues)
... View more
10-24-2013
03:36 PM
|
0
|
0
|
1820
|
|
POST
|
You could try the Frequency Tool as well. http://resources.arcgis.com/en/help/main/10.2/index.html#//00080000001w000000
... View more
10-24-2013
11:30 AM
|
0
|
0
|
1820
|
|
POST
|
Sweeet. Cheers Indeed. I was not seeing the expected results with just using Spaces, but explicitly insert white Space seems to do the trick. ([A-Z][A-Z]\b[0-9][0-9][0-9][0-9][0-9]\-[0-9])|([A-Z][A-Z]\b[0-9][0-9][0-9][0-9][0-9])|([A-Z][A-Z]\b[0-9][0-9][0-9][0-9]) Seems like the | can get inserted into the Help for OR, what is the symbol for AND. Currently | is Matches an alternative phrase or spelling, in the help. I also like how you use () and use \ for even /...
... View more
08-28-2013
10:14 AM
|
0
|
0
|
1351
|
|
POST
|
It would be nice to add to the Composite Check the ability to add a SQL Check and then combine the SQL Check with a Regular Expression Check, or even a couple of Regular Expressions Checks where, I can Extract out what I am referring here in an OR via SQL, then be able to stack multiple Reg Expressions, essentially.
... View more
08-28-2013
06:46 AM
|
0
|
0
|
1351
|
|
POST
|
Absolutely, that does work, but what I really need is where I have a Tract with a number and a Tract with a -1 at the end. Really bad example on my part I suppose, since I already use the [A-Z][A-Z] [0-9]+ where I can do exactly what I asked such as grabbing a 4 + digits. Other examples where I need an OR MB 000/000 OR MB 000/000 SD...
... View more
08-28-2013
05:50 AM
|
0
|
0
|
1351
|
|
POST
|
Is it possible to use an Or inside of a Regular Expression Check somehow, for example as TR 12345 or TR 1234, something to the effect of [A-Z][A-Z] [0-9][0-9][0-9][0-9][0-9] OR [A-Z][A-Z] [0-9][0-9][0-9][0-9]. I know the above does not work, but what is the recommended approach for doing Multiple Regular Expression Checks in a Single Field. Another Occurrence would be TR 12345 OR TR 12345-1, because conceptually I can solve this (TR 12345 or TR 1234) as [A-Z][A-Z] [0-9]+
... View more
08-27-2013
05:28 PM
|
0
|
5
|
4295
|
|
POST
|
In regards to the first question, Batch Validate auto-resources the batch job when you open it. Therefore when you validate all, you may not see any configuration errors. Batch Job Manager does not automatically resources the batch job you open. (You would have to do that thru the Workspace button.) Therefore if your batch job is pointing to a data path that you don't have on your computer, then you would have validation errors. For the domain check, did you double check that the data being validated was the exact same resource (version)? Good explanation. One is implicit and the other is explicit. I restate some of your explanations below along with Questions/observations... So, the Batch Validate Implicitly does the association to the version and the server for that matter, the domain check validation issue is only an error when the data is a table, when the Domain check is a layer, there are no issues with the validation. This is the way it works unless I allow Reviewer to add the data to my MXD, problem is we have Editing Templates, so now I have two instances of these tables, 1 set from the edit template, and 1 set added from Reviewer, and this is the behavior for the Batch Validate for Table domains. I do not need to allow Reviewer to add all the other layers associated with the checks. Seems inconsistent. Needed for Tables, not for Layers. The Batch Manager does not do the association unless I explicitly set the Workspace and Version, and I need to to this association to the Layer/Table and the actual Reviewer Batch Job Resource. Why does it have to be done twice, seems like when I change one workspace, all should get changed for both the Layer/Table and Reviewer Batch Job Resource. Right now our process is to build the checks on a Test Server (GIS2), then reset via the Batch manager to Set the Workspace from GIS2 to GIS3, Save as a New Batch Job. When the Checkers need to run a Batch Job, they then follow that up with a Change to a Specific version name. It seems like this process could be streamlined a bit more to follow how the process works inside of the Batch Validate, where I can run a Validate in Batch manager then just go right to a Save As to capture the version/server info as part of the layers/Checks... On an unrelated note, we are experiencing Session jumps, where we are up to Session 418, and we have not created 417 Test Sessions, not sure what's going on here. Also, a nice to have... The ability to Sort by Owner/Version in the Select Version pop up when Change Version used for Batch Manager. Currently the Version and Owner are combined in one field.
... View more
08-27-2013
09:18 AM
|
0
|
0
|
729
|
|
POST
|
Will there be updates for Viewer 3.4 for both the Dashboard and Report Widget?
... View more
08-26-2013
09:18 AM
|
0
|
0
|
791
|
|
POST
|
If I validate all on the batch job window/dialog, i see no configuration issues, but if I validate all on the Batch Job Manager, there are configuration issues. Why the discrepancy? Should these be consistent with one another, or is this the expected behavior? Also, when running the same test on a user machine, I see two tables both Domain Checks that are having issues, when on my machine, there are no issues with these tables. This is 10.2.
... View more
08-26-2013
09:16 AM
|
0
|
2
|
3510
|
|
POST
|
Seeing this pop up under 10.2, where I am running python64 with the StageService, while at Py32 no issues...
... View more
08-05-2013
12:58 PM
|
0
|
3
|
2542
|