Crosswalk Exercise


In this exercise you get some practice conducting a crosswalk. A crosswalk is carried out by comparing the definition of each entity and attribute in your database with entity and attribute definitions in the Cadastral Data Content Standard until you find the entity or attribute in the Standard which matches your database.

By working through this exercise, you will become familiar with the kind of crosswalk you will need to conduct when working on your own cadastral data. So, though this exercise uses for its example a small subset of BLM land and mineral records entities and attributes, think about your own data while you are doing this exercise. Don't worry if you do not completely understand everything about the BLM example used here.  The point is to get some practice doing a crosswalk.

blue divider line

Some Preliminary Information

This is an exercise in crosswalking entities and attributes between example BLM records and the Cadastral Data Content Standard.

Before actually going ahead with the crosswalk exercise, please take a few minutes to look at the information below.

The following are links essential to conducting the crosswalk in this exercise:

Here are the steps to follow to do this exercise::
  1. First use the links shown above to look at the subsets of the entity relationship diagrams for the Standard and for the BLM data. For your convenience you may wish to print out each of these so you can look at them while doing the crosswalk.
  2. Notice that the entities and attributes in each diagram have very different names, but that in general they apply to the same kind of information, that is, information about people owning rights to land, such as name, address, and so forth.
  3. Next use the links above to look at the definitions of the entities and attributes. You may wish to print out these also, so you can refer to them conveniently while carrying out this exercise.
  4. Once you are a little familiar with the entities, attributes and their definitions, proceed to the exercise below to conduct a crosswalk between the BLM records and the Cadastral Data Content Standard.

The Exercise - Crosswalking BLM Attributes to the Cadastral Data Content Standard

Listed below is a brief example of the kind of information which might be found in BLM's land records data. (Obviously, this is a fictitious example, made up for the purpose of this exercise.)

Each part of the information listed above can be correlated to attributes in BLM's land records data. Below we give you the name of the BLM entity/attribute which corresponds to each part of John Doe's information.

Your job in this exercise is to identify the Cadastral Data Content Standard entity/attribute which matches the BLM entity/attribute you are given. You get to choose the Cadastral attribute from three possible answers provided.

To simulate a real crosswalk of attributes from BLM records to the Cadastral Standard, you will have to look up the definition of the BLM attributes, and then look up the definitions of the Cadastral attributes to find the Cadastral attribute that crosswalks to each BLM attribute. While it might be easier if we simply listed all the definitions below, or provided links directly to each definition, this would be a less accurate simulation of what it actually takes do a crosswalk, which often entails spreading out entity-relationship diagrams and lists of entities, attributes and definitions on a table or tacked to a wall and searching for the connections between two models.

A couple of rules and guidelines to bear in mind:

Now, proceed to crosswalking the following eleven attributes.

"John" pertains to BLM entity/attribute customer_name/cust_idv_first_name. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Agent/Agent ID
Individual/Given Name
Individual/Surname


"William" pertains to BLM entity/attribute customer_name/cust_idv_mdl_name. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Individual/Given Name
Individual/Other Name
Agent/Alias Agent ID


"Doe" pertains to BLM entity/attribute customer_name/cust_idv_last_name. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Agent/Agent ID
Individual/Other Name
Individual/Surname


"Jr." pertains to BLM entity/attribute customer_name/cust_idv_suf_name. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Agent/Alias Agent ID
Individual/Other Name
Individual/Surname


"Junior" pertains to the BLM entity/attribute customer_historical_name/cust_idv_hist_first_name. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Individual/Given Name
Individual/Other Name
Agent/Former Agent ID


"5/14/94" pertains to the BLM entity/attribute customer_relationship/cust_rel_recs_date. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Organization/Organization Type
Restrictions/R-Source Date
None


"57 Rural Highway D" pertains to the BLM entity/attribute customer_address/cust_addr_ln1_txt. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Public Agency/County
Agent/Agent ID
None


"Smalltown" pertains to the BLM entity/attribute customer_address/cust_city_name. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Public Agency/City/Village/Town
None
Agent/Agent ID


"Wyoming" pertains to the BLM entity/attribute customer_address/cust_st_geo_cd. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

None
Public Agency/State
Agent/Agent ID


"Myland Company" pertains to the BLM entity/attribute customer_name/cust_org_ln1_name. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Organization/Organization Name
Organization/Organization Type
Organization/Division/Department


"for profit" pertains to the BLM entity/attribute customer/cust_nprof ='N'. For this BLM attribute, the corresponding Cadastral Data Content Standard entity/attribute is (choose only one):

Organization/Organization Name
Organization/Organization Type
Organization/Division/Department


If you are unsure of your answers or simply wish to start over, click on the reset button.

Go to the answers to the crosswalk to compare your crosswalk results with ours.



Links to the Course Sections and Modules: [Quick Reference] [Introduction] [Section 1: Purpose and Benefits of the Cadastral Data Content Standard] [Section 2: How the Standard Was Developed] [Section 3: Other Standards and Related Activities] [Section 4: Data Modeling Techniques, Rules and Diagram Conventions] [Section 5: Crosswalks, Translations, and Examples] [Section 6: Understanding Compliance with the Standard] [Section 7: Maintenance of the Standard] [Section 8: User and Technical Support] [County Recorder Module] [GIS Specialist Module] [Surveyor Module] [Glossary]


Learning the Cadastral Data Content Standard

Home

Presented by the United States Department of the Interior Bureau of Land Management, and

the Federal Geographic Data Committee Cadastral Subcommittee