Hi everyone,
I was wondering if someone knows of any available tools or
scripts available for the problem. I am working with a database which is
updated at various times within the year.
Within Arc the different attributes within the table are saved out as
layers. As information is updated, the layers need to be updated.
At the moment this is a manual task. The Symbology is run on
the field of interest and then then the layer name is manually changed and a
layer file is saved out. There are lots of layers, so it makes the task very manual;
also when the updates need to be done the process has to be started off again.
I was wondering if there is a tool or a script out there
that would look into a table and allow the user to define the fields that they
would like to create layer files for
Using the field name automatically as the layer file
Within the table I am working in when there is no value it
has been entered as a null value. This happened when the data was joined from an
Excel table.
For the Symbology initially it would be ok to have unique
values and have some way of dealing with the null values.
The out being a layer file that contains only values that
have a number
So I have put in a mock table below. If the tool was to prompt the user to be able
to pick the Graduates, Girls, Boys, Medical and Sports Fields
| Header 1 |
|---|
| Objectid | Name | Lat | Long | Date | Graduates | Girls | Boys | Medical | Sports | | 1 | New Pit | x | x | 05/04/2569 | Null | 1 | 20 | 2 | 1 | | 2 | New Deer | x | x | 06/04/2569 | 10 | Null | 34 | 6 | 2 | | 3 | New way | x | x | 07/04/2569 | Null | 38 | 65 | 4 | 3 | | 4 | New York | x | x | 08/04/2569 | 2 | Null | 765 | 6 | 4 | | 5 | Old Deer | x | x | 09/04/2569 | Null | 34 | 23 | 10 | 5 | | 6 | Ellon | x | x | 10/04/2569 | 1 | Null | 1 | 30 | 6 | | 7 | Tarvis | x | x | 11/04/2569 | Null | Null | Null | Null | 60 | | 8 | Aberdour | x | x | 12/04/2569 | 67 | 28 | Null | 3 | 23 | | 9 | Capatian | x | x | 13/04/2569 | 2 | Null | 3 | 4 | 3 | | 10 | Alder | x | x | 14/04/2569 | Null | 5 | 5 | 5 | 45 |
|
The output, would be
5 layer files, names Graduates , Girls , Boys , Medical and
Sports , that only had points when there was a value and did not show the null
values
I have not much experience with python , but this seems like
it might have been something that has been asked before , or there is an
existing script for. Anyone has any experience of something such as this ?
Thanks a lot for your time
