Quantiles in areas within a layer?

2541
9
Jump to solution
07-14-2016 07:06 AM
Labels (1)
HectorBorro1
Occasional Contributor


I have a layer with polygons that have smaller areas within. Think counties/municipalities within a state.

The 3 fields in my table are STATE, MUNICIPALITY and a NUMERIC VALUE within the municipality (from 0 to 1)  that needs to be mapped.

The problem is that the Quantiles are calculated from all the values in the table (22k) and I need them to be calculated and displayed by STATE, so every state need to have the 5 quantile classes within them.

How can I achieve this without having to create a separate layer by STATE (120)?

I tried some sort of normalization, but my STATE value is text and therefore not usable...

0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Emeritus

there are many classification schemes, for example std deviations.

I prefer to produce a classification scheme that is derived from the histogram of the actual data, since any false presumptions of normalcy in the data can be dealt with.  If you are interested in between region variations then I would use one scheme.  If you are interest at within region variations, then I see the point of a separate one for each region, but I would also advise you to provide the measure of centrality and dispersion the label or within the legend so that people are forewarned that the visual pattern for the with region data is based upon these measures and their absolute values should not be directly compared to other regions.  Should wish to normalize the scheme based on their measures, I would still report them.  People sometimes get complacent when making visual comparison without knowing what the underlying statistical measures are (ie two regions showing a non-clustered normal looking pattern, can differ markedly in their fundamental values)  In short... lie with statistics and lie with maps should be avoided at all costs

View solution in original post

9 Replies
DanPatterson_Retired
MVP Emeritus

I assume you are referring to the quantiles symbology, since there is no way of calculating the quantile values for attributes in a table.  In the case of symbology, you have to produce the layers.  I would suggest that if you are going to be doing state by state comparisons, that you come up with a standard classification scheme so one can see how they stack up against one another.  If you are referring to something different, an image would help

0 Kudos
HectorBorro1
Occasional Contributor

Indeed, I'm referring to the quantiles symbology. This is quite useful to understanding relationships between areas and their values.

Well, the comparison will be more within the state than across states, that's why I need the "quantilization" to be done by municipalities...

As all the values go from 0 to 1, I don't see another classiication scheme to use. Any ideas?

Here's an example I did by CLIP the municipalities to the state:

Nationwide:     

Only one state: Much clearer classification and what I'm looking for, but impractical for 150 states as this will leave me with 150 layers!

0 Kudos
DanPatterson_Retired
MVP Emeritus

there are many classification schemes, for example std deviations.

I prefer to produce a classification scheme that is derived from the histogram of the actual data, since any false presumptions of normalcy in the data can be dealt with.  If you are interested in between region variations then I would use one scheme.  If you are interest at within region variations, then I see the point of a separate one for each region, but I would also advise you to provide the measure of centrality and dispersion the label or within the legend so that people are forewarned that the visual pattern for the with region data is based upon these measures and their absolute values should not be directly compared to other regions.  Should wish to normalize the scheme based on their measures, I would still report them.  People sometimes get complacent when making visual comparison without knowing what the underlying statistical measures are (ie two regions showing a non-clustered normal looking pattern, can differ markedly in their fundamental values)  In short... lie with statistics and lie with maps should be avoided at all costs

HectorBorro1
Occasional Contributor

Hi Dan Patterson, I've been thinking about your valued reply and now I'm in the heat as having to produce a map layout for each of the 150 areas...

Any Ideas on how I can automate this? Otherwise it will consume more than a week of my time just to clip and separate each polygon with its internal areas...

0 Kudos
DanPatterson_Retired
MVP Emeritus

hmmm haven't updated to work with geodatabases, but you can do some of the work by splitting out your file into individual area using Split Layer By Attribute

http://www.arcgis.com/home/item.html?id=15ca63aebb4647a4b07bc94f3d051da5

0 Kudos
HectorBorro1
Occasional Contributor

oh yes, I tried this for one or two areas and it works like a charm, thanks!
I'm worried about the repetitiveness of the task and the time it will take....

BTW, do you have info on geodatabases vs. SHP files? I only know that a GDB is a huge repository containing everything being mapped...

0 Kudos
DanPatterson_Retired
MVP Emeritus

Hector,  I would begin here

Geodatabase is a more modern data maintenance structure but I tend to work with geometry mostly so 95% of what it offers, I don't need, but there is definitely a place for them

Essential readings about the geodatabase—ArcGIS Help | ArcGIS for Desktop

HectorBorro1
Occasional Contributor

great read thanks!

Do you (or anyone) happen to have any ideas on how to automate the task of creating 150 layers from one by slecting by attibute or make them simpler/quicker?

cheers

0 Kudos
DanPatterson_Retired
MVP Emeritus

The Split Layer By Attributes link will do that for you.  You just need a field to use to identify the unique feature(s) within the shapefile.  If all features are unique in the shapefile, simply use the FID field