Free Trial Request a Demo

Order Form

Brochure

Case Study

Maptitude P&E Tech Corner

How can I display the Plan Components Report with shortened tract or block numbers?

Using shortened block or tract numbers in the Plan Components (Bill Language) Report is very easy. All you have to do is create a formula field (which you call Name) that contains the information you want displayed. For example, to show the block group and block number of a block (the last 6 digits of the 15-16 digit code), you would do the following:

  1. Make Census Block the Working Layer (the active layer; Census Block should appear in the drop-down list to the right of the printer icon).
  2. Choose Dataview-Formula Fields and type the following:

    Substring(BLK,12,10)

    Replace the default field name Formula with the name "Name" (this is case-sensitive, so the "N" should be uppercase and the "ame" should be lowercase).
  3. Click OK.

    This will create a new field in the Census Block dataview, called Name, which contains the last 10 characters of the field BLK starting with position 12.

Now when you run the Plan Components report, 1234 will appear instead to the right of BLK instead of 190011234561234.

To show only the tract for the Census Tract layer, make Census Tract and use the formula substring(Tract,6,10). In this case, 123456 would appear in the report rather than 19001123456.

 

Back to Tech Corner Support Page