gis address data model rc a an - esri: gis mapping ... · an arcgis address data model ... a dre s....

An ArcGIS Address Data ModelFeatures with addresses Addresses and subaddresses

Names

Streets

Zones

for the city of Calgary, Alberta, Canada

Simple feature classCommunityFacility Contains Z values

Contains M valuesGeometry Point

NoNo

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A point of interest represents acommunity facility or culturallandmark.

OBJECTID OID

SHAPE Geometry Yes

RelatedCommunityCode String Yes 4 Unique ID of community served by POI.

AmenityTypeName String Yes 30 The category of the facility.

FacilityName String Yes 50 The name of the point of interest.

Address String Yes 50 Address of point of interest used for labeling.

Description String Yes 50 Instructions for navigating to point of interest.

POIID Integer Yes 0 Unique identifier for point of interest.

Simple feature classStreet Contains Z values

Contains M valuesGeometry Polyline

NoNo

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A street represents a street centerline,usually segmented at levelintersections.

OBJECTID OID

SHAPE Geometry Yes

StreetID Double Yes 0 0 The unique identifier of the street.

LeftFrom Integer Yes 0 First address found at the from node on the left side.

LeftTo Integer Yes 0 Last address found at the to node on the left side.

RightFrom Integer Yes 0 First address found at the from node on the right side.

RightTo Integer Yes 0 Last address found at the to node on the right side.

ClassCode String Yes ClassCodes 3 A code indicating the road class of the street.

BuiltCode String Yes BuildCodes 3 A code indicating the built status of the street.

RegistrationCode String Yes RegistrationCodes 2 A code indicating the registration status of the street.

BarrierCode Small Integer Yes BarrierCodes 0 0 2 A code indicating the navigability of the street.

ClosureCode String Yes ClosureCodes 1 A code indicating the closure status of the street.

PrivateCode String Yes PrivateCodes 3 A code indicating if the street is a private street.

DirectionCode String Yes DirectionCodes 3 A code indicating the directionality of the street.

BridgeCode Small Integer Yes BridgeCodes 0 0 2 A code indicating if the street passes over a bridge.

BridgeName String Yes 50 The name of the bridge over which the street passes.

SHAPE_Length Double Yes 0 0

LabelName String Yes 26 The name of the street used for labeling.

Simple feature classBuilding Contains Z values

Contains M valuesGeometry Polygon

NoNo

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A building is a polygon that representsthe roof outline of a structure, asdigitized from aerial photography.

OBJECTID OID

SHAPE Geometry Yes

BuildingCode Integer Yes BuildingCodes 0 An integer code that represents the type of building.

XCoordinate Double Yes 0 0 The x-coordinate of the building centroid.

YCoordinate Double Yes 0 0 The y-coordinate of the building centroid.

BuildingID Integer Yes 0 The unique identifier for the building.

SHAPE_Length Double Yes 0 0

SHAPE_Area Double Yes 0 0

AddressLabel String Yes 50 Address of building used for labeling.

Simple feature classSubAddress Contains Z values

Contains M valuesGeometry Point

NoNo

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A subaddress is a subdivision ofan address such as an apartmentnumber or condominiumaddress.

OBJECTID OID

SHAPE Geometry Yes

SuiteNumber Integer Yes 0 The numeric component of the subaddress.

SuiteAlpha String Yes 1 The alphabetic component of the subaddress.

AddressID Integer Yes 0 Unique ID of address of which this subaddress is a part.

SubAddressID Integer Yes 0 Unique identifier of the subaddress.

UnitDesignator String Yes UnitDesignators 10 The string used to denote the subaddress.

AddressLabel String Yes 50 The address used for labeling.TableZone

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A zone is a valid combination of city,province, and postal code that can beassigned to addresses.

OBJECTID OID

ZoneID Integer Yes 0 The unique identifier of the zone.

CityID Integer Yes 0 The unique identifier of the city.

ProvinceID Integer Yes 0 The unique identifier of the province.

PostalCode String Yes 6 The 6-character postal code.

TableRangeZone

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A range zone is a valid combinationof city, province, and forwardsortation area that can be assigned toaddress ranges.

OBJECTID OID

ZoneID Integer Yes 0 The unique identifier of the zone.

FSA String Yes 3 The forward sortation area (FSA) code.

CityID Integer Yes 0 The unique identifier of the city.

ProvinceID Integer Yes 0 The unique identifier of the province.

TableBaseName

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A base name is a base component onwhich a fully qualified name isconstructed.

OBJECTID OID

BaseName String Yes 20 The base component of a name.

TableOctant

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

An octant is a directional qualifier fora name that indicates in whichquadrant of the city the feature islocated.

OBJECTID OID

Octant String Yes 2 The quadrant component of a name.

TableType

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A type is a qualifier for a name.

OBJECTID OID

Type String Yes 2 The type qualifier for a name.

TablePostalCode

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A postal code defines adelivery area for postalmail.

OBJECTID OID

PostalCode String Yes 6 The six-character postal code.

FSA String Yes 3

LDU String Yes 3 Local delivery unit (LDU) code.

Forward sortation area (FSA) code.

TableProvince

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A province is thefirst majoradministrativedivision in Canada.

OBJECTID OID

ProvinceID Integer Yes 0 Unique identifier of province.

ProvinceName String Yes 20 The province's name.

Simple feature classCityLimit Contains Z values

Contains M valuesGeometry Polygon

NoNo

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A single polygon featurethat represents thejurisdictional limits ofthe city of Calgary.

OBJECTID OID

SHAPE Geometry Yes

CityID Integer Yes 0 The unique identifier of the city.

SHAPE_Length Double Yes 0 0

SHAPE_Area Double Yes 0 0

CityName String Yes 20 The city's name.

Simple feature classForwardSortationArea Contains Z values

Contains M valuesGeometry Point

NoNo

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A forward sortationarea defines a majorgeographic area forprimary mail sortation.

OBJECTID OID

SHAPE Geometry Yes

FSA String Yes 3 The forward sortation area code.

TableGeoName

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

A geographic name is a name thatcan be associated with geographicfeatures.

OBJECTID OID

NameStyle String Yes NameStyles 10 The style of the name.

NamingAuthorityID Integer Yes 0 Unique ID of authority responsible for assigning name.

NameID Integer Yes 0 The unique identifier of the name.

BaseName String Yes 20 The base component of the name.

Type String Yes 2 The type component of the name.

Octant String Yes 2 The directional (octant) component of the name.

Name String Yes 26 The full geographic name.

Simple feature classAddress Contains Z values

Contains M valuesGeometry Point

NoNo

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

An address describes alocation in relation to astreet.

OBJECTID OID

SHAPE Geometry Yes

XCoordinate Double Yes 0 0 The x-coordinate of the address.

YCoordinate Double Yes 0 0 The y-coordinate of the address.

Address String Yes 35 The address used for labeling.

AddressID Integer Yes 0 The unique identifier for the address.

HouseNumber Integer Yes 0 The house number component of the address.

HouseAlpha String Yes 1 The alphabetic component of the address.

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

AddressesHaveZones

Origin feature class Destination table

SimpleMany to manyNone

HasIs assigned to

AddressAddressIDAddressID

ZoneZoneIDZoneID

NamePrimary keyForeign key

Data typeField namePre-cision Scale Length

Allownulls

OBJECTID Object ID

AddressID Long integer Yes 0

ZoneID Long integer Yes 0

Category String Yes 10

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

AddressesHaveNames

Origin feature class Destination table

SimpleMany to manyNone

HasIs assigned to

AddressAddressIDAddressID

GeoNameNameIDNameID

NamePrimary keyForeign key

Data typeField namePre-cision Scale Length

Allownulls

OBJECTID Object ID

AddressID Long integer Yes 0

NameID Long integer Yes 0

Category String Yes 10

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

AddressHasSubAddresses

Origin feature class Destination feature class

SimpleOne to oneNone

HasIs a sub-address of

AddressAddressIDAddressID

SubAddressName

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

AddressRangesHaveNames

Origin table Destination table

SimpleMany to manyNone

HasIs assigned to

AddressRangeAddressRangeIDAddressRangeID

GeoNameNameIDNameID

NamePrimary keyForeign key

Data typeField namePre-cision Scale Length

Allownulls

OBJECTID Object ID

AddressRangeID Long integer Yes 0

NameID Long integer Yes 0

Category String Yes 10

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

AddressRangesHaveRangeZones

Origin table Destination table

SimpleMany to manyNone

HasIs used by

AddressRangeAddressRangeIDAddressRangeID

RangeZoneZoneIDZoneID

NamePrimary keyForeign key

Data typeField namePre-cision Scale Length

Allownulls

Category String Yes 10

RID Object ID

AddressRangeID Long integer Yes 0

ZoneID Long integer Yes 0

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

CityIsPartOfRangeZones

Origin feature class Destination table

SimpleOne to manyNone

Is part ofHas

CityLimitCityIDCityID

RangeZoneName

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

CityIsPartOfZones

Origin feature class Destination table

SimpleOne to manyNone

Is part ofHas

CityLimitCityIDCityID

ZoneName

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

FSAHasPostalCodes

Origin feature class Destination table

SimpleOne to manyNone

HasIs part of

ForwardSortationAreaFSAFSA

PostalCodeName

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

FSAIsPartOfRangeZones

Origin feature class Destination table

SimpleOne to manyNone

Is part ofHas

ForwardSortationAreaFSAFSA

RangeZoneName

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

StreetHasAddressRanges

Origin feature class Destination table

SimpleOne to manyNone

HasIs assigned to

StreetStreetIDStreetID

AddressRangeName

Data typeField namePre-cision Scale Length

Allownulls

OBJECTID Object ID

StreetID Long integer Yes 0

AddressRangeID Long integer Yes 0

Side String Yes 1

Category String Yes 10

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

ProvinceIsPartOfZones

Origin table Destination table

SimpleOne to manyNone

Is part ofHas

ProvinceProvinceIDProvinceID

ZoneName

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

ProvinceIsPartOfRangeZones

Origin table Destination table

SimpleOne to manyNone

Is part ofHas

ProvinceProvinceIDProvinceID

RangeZoneName

Relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

PostalCodeIsPartOfZones

Origin table Destination table

SimpleOne to manyNone

Is part ofHas

PostalCodePostalCodePostalCode

ZoneName

An ownership parcel is a unitof land ownership.

The x-coordinate of the parcel centroid.

The y-coordinate of the building centroid.

The section number in which parcel is located.

The unique identifier for the ownership parcel.

Address of ownership parcel used for labeling.

Simple feature classOwnershipParcel Contains Z values

Contains M valuesGeometry Polygon

NoNo

Data typeField namePre-cision Scale LengthDomain

Allownulls

OBJECTID Object ID

SHAPE Geometry Yes

XCoordinate Double Yes 0 0

YCoordinate Double Yes 0 0

SectionNumber String Yes 6

CPIDChar String Yes 10

AddressLabel String Yes 50

CPID Long integer Yes 0

SHAPE_Length Double Yes 0 0

SHAPE_Area Double Yes 0 0

Defaultvalue

TableAddressRange

Data typeField namePre-cision Scale LengthDomain

Defaultvalue

Allownulls

An address range represents the set ofaddresses that can be found along astreet.

OBJECTID OID

AddressRangeID Integer Yes 0 The unique identifier for the address range.

FromAddress Integer Yes 0 The first address found at the from node of the feature.

ToAddress Integer Yes 0 The last address found at the to node of the feature.

Parity String Yes ParityCodes 1

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

CommunityFacilitiesHaveAddresses

Origin feature class Destination feature class

SimpleMany to manyNone

HasIs assigned to

CommunityFacilityPOIIDPOIID

AddressAddressIDAddressID

NamePrimary keyForeign key

Data typeField namePre-cision Scale Length

Allownulls

OBJECTID Object ID

POIID Long integer Yes 0

AddressID Long integer Yes 0

Category String Yes 10

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

BuildingsHaveSubAddresses

Origin feature class Destination feature class

SimpleMany to manyNone

HasIs assigned to

BuildingBuildingIDBuildingID

SubAddressSubAddressIDSubAddressID

NamePrimary keyForeign key

Data typePre-cision Scale Length

Allownulls

String Yes 10

Object ID

Long integer Yes 0

Long integer Yes 0

Field name

Category

RID

BuildingID

SubAddressID

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

BuildingsHaveAddresses

Origin feature class Destination feature class

SimpleMany to manyNone

BuildingBuildingIDBuildingID

AddressAddressIDAddressID

NamePrimary keyForeign key

Data typePre-cisioncScale Length

Allownulls

String Yes 10

Object ID

Long integer Yes 0

Long integer Yes 0

Field name

Category

RID

BuildingID

AddressID

HasIs assigned to

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

CommunityFacilitiesHaveSubAddresses

Origin feature class Destination feature class

SimpleMany to manyNone

HasIs assigned to

CommunityFacilityPOIIDPOIID

SubAddressSubAddressIDSubAddressID

NamePrimary keyForeign key

Data typePre-cision Scale Length

Allownulls

Object ID

Long integer Yes 0

Long integer Yes 0

String Yes 10

Field name

OBJECTID

POIID

SubAddressID

Category

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

OwnershipParcelsHaveSubAddresses

Origin feature class Destination feature class

SimpleMany to manyNone

HasIs assigned to

OwnershipParcelCPIDCPID

SubAddressSubAddressIDSubAddressID

NamePrimary keyForeign key

Data typePre-cision Scale Length

Allownulls

Object ID

Long integer Yes 0

Long integer Yes 0

String Yes 10

Field name

OBJECTID

CPID

SubAddressID

Category

Attributed relationship class

NamePrimary keyForeign key

TypeCardinality

Notification

Forward labelBackward label

OwnershipParcelsHaveAddresses

Origin feature class Destination feature class

SimpleMany to manyNone

OwnershipParcelCPIDCPID

NamePrimary keyForeign key

Data typePre-cision Scale Length

Allownulls

Object ID

Long integer Yes 0

Long integer Yes 0

String Yes 10

Field name

OBJECTID

CPID

AddressID

Category

HasIs assigned to

AddressAddressIDAddressID

1101

1102

1103

1105

1106

1104

1107

1108

1109

1111

1112

1110

1113

1115

1116

1114

1919 University Dr NW

1919 B University Dr NW

1919 A University Dr NW

1919 D University Dr NW

1919 E University Dr NW

1919 C University Dr NW

1919 F University Dr NW

1919 H University Dr NW

1919 G University Dr NW

1919 K University Dr NW

1919 L University Dr NW

1919 J University Dr NW

1919 M University Dr NW

2108 Uxbridge Drive NW

2919 Unwin Rd NW

2029 Unwin Rd NW

Address table

ObjectID Address

Buildings can share an address, abuilding can have subaddresses

2919 Unwin Rd NWsubaddresses 1,2,3,4,5

2919 Unwin Rd NWsubaddresses 6,7

2029 Unwin Rd NW

Subaddress table

ObjectID Subaddress

1 2919 Unwin Rd NW

3 2919 Unwin Rd NW

2 2919 Unwin Rd NW

1201

1202

1203

5 2919 Unwin Rd NW

7 2919 Unwin Rd NW

6 2919 Unwin Rd NW

1205

1206

1207

4 2919 Unwin Rd NW1204

Buildings have subaddresses

BuildingIDAddressIDObjectID

854

855

1204

1205

901

901

856

857

1206

1207

902

902

851

852

1201

1202

901

901

853 1203901

Buildings have addresses

BuildingIDAddressIDObjectID

901

902

903

550

551

552

1115

1115

1116

2098

20052008

1851

1901

2198

1898

2000

2099

18991890

20102003

1800

2001

2098

16 AV NW

16 AV NW

29 ST NW

UN

IVERSITY DR N

W

ULSTER RD NW

URQ

UH

ART RD

NW

2920

2020

2010

2006

1820 B1820

2027 2025

2017

2017

2015

2011

2011

2011 2009

2005 2001

1969 B

1919 M

1919 L1919 K 1919 J 1919 H

1919 G

1919 F 1919 E 1919 D 1919 C

1919 B

1919 A

1919

A parcel can have many addresses and subaddresses

Dominican Sisters Day Care Centre

A point of interest can have many addresses

and subaddresses

Parcels and points of interest can have subaddresses, but that is not shown in this instance diagram.

Building feature class

ObjectID Shape

901

902

903

Points of interest have addresses

PointOfInterestIDAddressIDObjectID

801450 1114

Point of interest feature class

ObjectID Shape

801

Parcels have addresses

BuildingIDAddressIDObjectID

304

305

1104

1105

701

701

306 1106701

301

302

1101

1102

701

701

303 1103701

310

311

1110

1111

701

701

312 1112701

307

308

1107

1108

701

701

309 1109701

313 1113701

Parcel feature class

ObjectID Shape

701

Names

ObjectID Name

Hwy 66

W Main St

301

302

Address ranges have names

AddressRangeID Category

Secondary

Primary

Primary

Secondary

Primary

Primary

Primary

Primary

ObjectID

70

71

71

70

72

73

74

75

80

83

81

82

84

87

85

86

302

301

301

302

301

301

301

301

NameID

By modeling many-to-manyrelationships among streets, address ranges, and names,

you can represent every case.

Streets have address ranges

ObjectIDFrom

AddressTo

Address

100

101

251

200

201

250

198

199

299

248

249

298

Address ranges

70

73

71

72

74

75

100198 200

201

248

249

250

251

299

298Left

101199

Hwy 66W Main St

Right

Hwy 66

Hwy 66

2122

23

StreetIDSideAddressRangeID

CategoryObjectID

21

21

22

23

22

23

Primary

Primary

Primary

Primary

Primary

Primary

Left

Right

Right

Left

Right

Left

50

51

54

57

55

56

70

71

72

73

74

75

Streets

ObjectID Shape

21

22

23