create multiple layers from attrubute script

jackwalker — Wed, 30 Jul 2014 09:20:08 GMT

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

topic create multiple layers from attrubute script in Python Questions

create multiple layers from attrubute script