This series deals with developing and using macros to generate GIS data or to augment existing datasets. Test the macro with sample data As an additional benefit, this problem solving approach should help develop or refine your problem solving skills. The macro introduced in the previous article was limited in scope to linking map features and existing database records. The macros introduced in this article will insert new records into the database and populate most of the fields some based on interaction with the user as well as creating the linkages with map features. We have a design file that contains street centerlines and address numbers for our municipality and we want to add the intelligence required for routing and property location operations.
Segments are the portions of street centerlines between two intersections.
An intersection is defined as the point at which two or more streets meet, and is referred to as a node . A sample segment with address ranges and nodes labeled. Note that the qualifiers lower and upper for nodes are used only in relation to a particular segment, since a node that serves as the lower endpoint of one segment can also be the upper endpoint of another segment. In cases where two numbers are not available on at least one side of a segment, the selection of lower and upper ends is based on another segment on the same street or on a parallel street. Nodes that are common to more than one segment establish connectivity between segments.