Support Center

SnapSite 2016A Enhancments

Last Updated: Mar 29, 2016 11:00AM PDT

SnapSite 2016A Release Improvements


New Formula Functions

RANK (<number>, <type>, <variable1>:<variable2>)

Purpose

The RANK() function can be used to select the nth item from a ranked array of variables and display either the rank position, its value, or its percentage value of the array sum.   Its primary use is in presenting the dominant Panorama segments, but it can also be used to generate the modal class of a distribution.

Parameters

<number> = the rank position in the array <variable1>:<variable2>, must be between 1 and the
                        count of items in the array.  Numbers outside this range throw a runtime error

<type> = 1 (returns the rank position of the item)
            = 2 (returns the value of the item at the rank position)
            = 3 (returns the % of the value of the item at the rank position)

<variable1>:<variable2> is a range of variables, which must be delimited with a “:” (colon)

Examples

RANK (3,1,PMACYHD01:PMACYHD68)
  • Returns the 3rd most prevalent Panorama segment according to household counts
RANK (1,3,PMACYPP01:PMACYPP68)
  • ​Returns the % of the population found in the most dominant Panorama segment
RANK (1,1,AGECY0004:AGECYGT85)
  • Returns the modal age class (the most commonly occurring value).  Note that the function return is the class number and not a description
SnapSite includes embedded formulas for the segment number, base value, and percent of base for each of the top three Panorama segments in a geographic area.

CLASS (<number>, <bound1>, <bound2>, …, <bound number-1>, <variable>)

Purpose

The CLASS() function is used to create a classification variable.   For example, you could classify rainfall into 7 categories – 0, 0-10, 10-20, 20-30, 40-50, 50-75, and 75+, with the result presented as the class number rather than the actual value. 

Please note that in order to enable a class for zero values, ranges are computed as <= for the first class bound and as < for subsequent bounds.

Parameters

            <number>       =          the number of classes in the classification
            <bound x>       =          the class boundary (e.g. 10,20,30)
            <variable>       =          the variable to be classified

Examples

CLASS( 5, 50, 100, 150, 250, CRMTOTC)
  • Classifies total crime risk into five categories - <50, 50-100, 100-150, 150-250, and >250.  The result will be a number from 1 to 5
CLASS (2, 100, INCCYMEDHH)
  • Returns 1 if the median income is below $100K, 2 otherwise.   This can be useful in building statistical models which include categorical data.
Up to 15 classes can be specified.


Panorama is now the default segmentation system for SnapSite and is used for major functions such as Panorama coding (appending codes to records in a file), Profile Reports, MPI reports, and profile rankings.   Mosaic is no longer supported, except in database extractions.

Note that myPanorama functionality is not yet available within SnapSite.
 
 

Contact Us

7450a4eaff9812c7a8144783c5b0b22a@appliedgeographic.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete