Upload File

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

  • Home
  • Documents
  • GIS Address Data Model rc A An - Esri: GIS Mapping ... · An ArcGIS Address Data Model ... a dre s. OBJECTID OID SHAPE Geometry Yes ... SubAddressID Integ er Yes 0 U n iq u edtf ro
1
An ArcGIS Address Data Model Features with addresses Addresses and subaddresses Names Streets Zones for the city of Calgary, Alberta, Canada Simple feature class CommunityFacility Contains Z values Contains M values Geometry Point No No Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A point of interest represents a community facility or cultural landmark. 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 class Street Contains Z values Contains M values Geometry Polyline No No Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A street represents a street centerline, usually segmented at level intersections. 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 class Building Contains Z values Contains M values Geometry Polygon No No Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A building is a polygon that represents the roof outline of a structure, as digitized 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 class SubAddress Contains Z values Contains M values Geometry Point No No Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A subaddress is a subdivision of an address such as an apartment number or condominium address. 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. Table Zone Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A zone is a valid combination of city, province, and postal code that can be assigned 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. Table RangeZone Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A range zone is a valid combination of city, province, and forward sortation area that can be assigned to address 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. Table BaseName Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A base name is a base component on which a fully qualified name is constructed. OBJECTID OID BaseName String Yes 20 The base component of a name. Table Octant Data type Field name Pre- cision Scale Length Domain Default value Allow nulls An octant is a directional qualifier for a name that indicates in which quadrant of the city the feature is located. OBJECTID OID Octant String Yes 2 The quadrant component of a name. Table Type Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A type is a qualifier for a name. OBJECTID OID Type String Yes 2 The type qualifier for a name. Table PostalCode Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A postal code defines a delivery area for postal mail. 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. Table Province Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A province is the first major administrative division in Canada. OBJECTID OID ProvinceID Integer Yes 0 Unique identifier of province. ProvinceName String Yes 20 The province's name. Simple feature class CityLimit Contains Z values Contains M values Geometry Polygon No No Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A single polygon feature that represents the jurisdictional limits of the 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 class ForwardSortationArea Contains Z values Contains M values Geometry Point No No Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A forward sortation area defines a major geographic area for primary mail sortation. OBJECTID OID SHAPE Geometry Yes FSA String Yes 3 The forward sortation area code. Table GeoName Data type Field name Pre- cision Scale Length Domain Default value Allow nulls A geographic name is a name that can be associated with geographic features. 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 class Address Contains Z values Contains M values Geometry Point No No Data type Field name Pre- cision Scale Length Domain Default value Allow nulls An address describes a location in relation to a street. 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 Name Primary key Foreign key Type Cardinality Notification Forward label Backward label AddressesHaveZones Origin feature class Destination table Simple Many to many None Has Is assigned to Address AddressID AddressID Zone ZoneID ZoneID Name Primary key Foreign key Data type Field name Pre- cision Scale Length Allow nulls OBJECTID Object ID AddressID Long integer Yes 0 ZoneID Long integer Yes 0 Category String Yes 10 Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label AddressesHaveNames Origin feature class Destination table Simple Many to many None Has Is assigned to Address AddressID AddressID GeoName NameID NameID Name Primary key Foreign key Data type Field name Pre- cision Scale Length Allow nulls OBJECTID Object ID AddressID Long integer Yes 0 NameID Long integer Yes 0 Category String Yes 10 Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label AddressHasSubAddresses Origin feature class Destination feature class Simple One to one None Has Is a sub-address of Address AddressID AddressID SubAddress Name Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label AddressRangesHaveNames Origin table Destination table Simple Many to many None Has Is assigned to AddressRange AddressRangeID AddressRangeID GeoName NameID NameID Name Primary key Foreign key Data type Field name Pre- cision Scale Length Allow nulls OBJECTID Object ID AddressRangeID Long integer Yes 0 NameID Long integer Yes 0 Category String Yes 10 Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label AddressRangesHaveRangeZones Origin table Destination table Simple Many to many None Has Is used by AddressRange AddressRangeID AddressRangeID RangeZone ZoneID ZoneID Name Primary key Foreign key Data type Field name Pre- cision Scale Length Allow nulls Category String Yes 10 RID Object ID AddressRangeID Long integer Yes 0 ZoneID Long integer Yes 0 Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label CityIsPartOfRangeZones Origin feature class Destination table Simple One to many None Is part of Has CityLimit CityID CityID RangeZone Name Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label CityIsPartOfZones Origin feature class Destination table Simple One to many None Is part of Has CityLimit CityID CityID Zone Name Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label FSAHasPostalCodes Origin feature class Destination table Simple One to many None Has Is part of ForwardSortationArea FSA FSA PostalCode Name Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label FSAIsPartOfRangeZones Origin feature class Destination table Simple One to many None Is part of Has ForwardSortationArea FSA FSA RangeZone Name Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label StreetHasAddressRanges Origin feature class Destination table Simple One to many None Has Is assigned to Street StreetID StreetID AddressRange Name Data type Field name Pre- cision Scale Length Allow nulls OBJECTID Object ID StreetID Long integer Yes 0 AddressRangeID Long integer Yes 0 Side String Yes 1 Category String Yes 10 Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label ProvinceIsPartOfZones Origin table Destination table Simple One to many None Is part of Has Province ProvinceID ProvinceID Zone Name Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label ProvinceIsPartOfRangeZones Origin table Destination table Simple One to many None Is part of Has Province ProvinceID ProvinceID RangeZone Name Relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label PostalCodeIsPartOfZones Origin table Destination table Simple One to many None Is part of Has PostalCode PostalCode PostalCode Zone Name An ownership parcel is a unit of 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 class OwnershipParcel Contains Z values Contains M values Geometry Polygon No No Data type Field name Pre- cision Scale Length Domain Allow nulls 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 Default value Table AddressRange Data type Field name Pre- cision Scale Length Domain Default value Allow nulls An address range represents the set of addresses that can be found along a street. 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 Name Primary key Foreign key Type Cardinality Notification Forward label Backward label CommunityFacilitiesHaveAddresses Origin feature class Destination feature class Simple Many to many None Has Is assigned to CommunityFacility POIID POIID Address AddressID AddressID Name Primary key Foreign key Data type Field name Pre- cision Scale Length Allow nulls OBJECTID Object ID POIID Long integer Yes 0 AddressID Long integer Yes 0 Category String Yes 10 Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label BuildingsHaveSubAddresses Origin feature class Destination feature class Simple Many to many None Has Is assigned to Building BuildingID BuildingID SubAddress SubAddressID SubAddressID Name Primary key Foreign key Data type Pre- cision Scale Length Allow nulls String Yes 10 Object ID Long integer Yes 0 Long integer Yes 0 Field name Category RID BuildingID SubAddressID Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label BuildingsHaveAddresses Origin feature class Destination feature class Simple Many to many None Building BuildingID BuildingID Address AddressID AddressID Name Primary key Foreign key Data type Pre- cisionc Scale Length Allow nulls String Yes 10 Object ID Long integer Yes 0 Long integer Yes 0 Field name Category RID BuildingID AddressID Has Is assigned to Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label CommunityFacilitiesHaveSubAddresses Origin feature class Destination feature class Simple Many to many None Has Is assigned to CommunityFacility POIID POIID SubAddress SubAddressID SubAddressID Name Primary key Foreign key Data type Pre- cision Scale Length Allow nulls Object ID Long integer Yes 0 Long integer Yes 0 String Yes 10 Field name OBJECTID POIID SubAddressID Category Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label OwnershipParcelsHaveSubAddresses Origin feature class Destination feature class Simple Many to many None Has Is assigned to OwnershipParcel CPID CPID SubAddress SubAddressID SubAddressID Name Primary key Foreign key Data type Pre- cision Scale Length Allow nulls Object ID Long integer Yes 0 Long integer Yes 0 String Yes 10 Field name OBJECTID CPID SubAddressID Category Attributed relationship class Name Primary key Foreign key Type Cardinality Notification Forward label Backward label OwnershipParcelsHaveAddresses Origin feature class Destination feature class Simple Many to many None OwnershipParcel CPID CPID Name Primary key Foreign key Data type Pre- cision Scale Length Allow nulls Object ID Long integer Yes 0 Long integer Yes 0 String Yes 10 Field name OBJECTID CPID AddressID Category Has Is assigned to Address AddressID AddressID 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, a building can have subaddresses 2919 Unwin Rd NW subaddresses 1,2,3,4,5 2919 Unwin Rd NW subaddresses 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 NW 1204 Buildings have subaddresses BuildingID AddressID ObjectID 854 855 1204 1205 901 901 856 857 1206 1207 902 902 851 852 1201 1202 901 901 853 1203 901 Buildings have addresses BuildingID AddressID ObjectID 901 902 903 550 551 552 1115 1115 1116 16 AV NW 16 AV NW 29 ST NW UNIVERSITY DR NW ULSTER RD NW URQUHART RD NW 2920 2020 2010 2006 1820 B 1820 2027 2025 2017 2017 2015 2011 2011 2011 2009 2005 2001 1969 B 1919 M 1919 L 1919 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 PointOfInterestID AddressID ObjectID 801 450 1114 Point of interest feature class ObjectID Shape 801 Parcels have addresses BuildingID AddressID ObjectID 304 305 1104 1105 701 701 306 1106 701 301 302 1101 1102 701 701 303 1103 701 310 311 1110 1111 701 701 312 1112 701 307 308 1107 1108 701 701 309 1109 701 313 1113 701 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-many relationships among streets, address ranges, and names, you can represent every case. Streets have address ranges ObjectID From Address To Address 100 101 251 200 201 250 198 199 299 248 249 298 Address ranges 70 73 71 72 74 75 100 198 200 201 248 249 250 251 299 298 Left 101 199 Hwy 66 W Main St Right Hwy 66 Hwy 66 21 22 23 StreetID Side AddressRangeID Category ObjectID 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

Upload: vudien

Post on 15-Dec-2018

226 views

Category:

Documents


0 download

Report

TRANSCRIPT

Page 1: GIS Address Data Model rc A An - Esri: GIS Mapping ... · An ArcGIS Address Data Model ... a dre s. OBJECTID OID SHAPE Geometry Yes ... SubAddressID Integ er Yes 0 U n iq u edtf ro

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

 · Redtrax raise drill transporter Yes Yes Yes Yes Yes Yes Yes N/A N/A Erector System Yes Yes Yes Yes Yes Yes Yes Yes Yes * All dimensions without rod handler. ** Deflectors are

BROADCAST DUAL server15 · FireFly Particle System YES YES YES Realtime 3D Particle System YES YES YES Playlists YES YES YES Venue Sites 3D Pre-Visualisation Tool YES YES YES Web

Leading Practice Examples of EDTF Recommendations

SAN Midrange Comparison Matrix 9/7/2012 - Evaluator Group · Windows Server 2000 Yes Yes Yes Yes -- Yes Windows Server 2003 Yes Yes Yes Yes Yes Yes Windows Server 2008 Yes Yes Yes

Lecture 14: Dictatorships - MIT OpenCourseWare · -.1531 (.582) Countryf.e. Yes Yes Yes Yes Yes Yes Yes Decadef.e. Yes Yes Yes Yes Yes Yes Yes Threshold 365days 365days 365days 365days

Comparison of Forest Management Software Suites - August 2014 · Cactos /Cryptos Database Architecture Relational Inventory Database Yes None None Yes None None None None Active GIS

PowerTrace - lauterbach.com · ceva-xs1200 yes yes cortex-a15 yes yes yes yes cortex-a15mpcore yes yes yes yes cortex-a5 yes yes yes yes cortex-a5mpcore yes yes yes yes cortex-a7

37-B 38-A 38-B 40.A 100 500 250 100 Yes Yes Yes Yes No No Yes Yes No Yes No Yes Yes Yes Yes Yes yes Yes Yes Yes Yes No No No Yes No Yes Yes Yes Smt Shabana Parveen Sh_ Sh_ Masque Masjid

thefloridacatholic.org · Location Name Location Type Time Zone Available Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Location Name Location Type Time Zone Available Yes Yes

HCU DOUNGLEG610 G610-C00 Qualcomm MSM8625Q 2013 Yes Yes Yes - - Yes Yes Yes Yes Yes - Yes - Ascend G610 G610-T00 MTK MT6589 2012 Yes Yes - - - Yes - Yes Yes Yes - Yes - Ascend G610

jkkspine.com Patient Paperwork...Hurst, TX 76054 Phone: 817.377.0143 817.377.0173 Fax: NAME. , F.A.C.S. REVIEW OF SYSTEMS Left Both YES YES YES YES YES YES YES YES YES YES YES YES

OWB2ODI - smart- · PDF fileOWB Oracle OWB2ODI Modules Yes Yes Locations Yes Yes Data Objects table Yes Yes view Yes Yes materialized view Yes Yes external table Yes Yes file Yes Yes

GUIDE D’UTILISATION RFP1000 · DOMIA/ARC 433.920 Yes Yes Yes Yes X10 433.920 Yes Yes Yes Yes DELTADORE X2D 433.920 DELTADORE X2D 868.350 SOMFY RTS 433.420 Yes Yes Yes Yes ... Une

Security Matters - Foresite · CISCO ASA Yes Yes Yes Yes Meraki (MX / MS / MR) Yes Yes Yes Yes FirePOWER Yes Yes Yes Yes ASR / ISR (routing) Yes Yes No No Catalyst/IOS (switching)

 · 2015. 7. 21. · CURRICULUM VITAE Yes Yes yes Yes Yes Yes Yes Yes Yes Yes Yes Yes yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes CERTIFICATE YES/NO/ Yes Yes

sbmjckgf.in 4.1.1/4.1.1_Any Additional Information.pdf · working condition yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes yes name of the equipment

TRANSITIONAL PROVISIONS - …northexcastudycircle.com/Image/GST_TP_BY_CA_Anoop_Gupta.pdfLuxury Tax Yes Yes Yes Yes VAT Yes Yes Yes Yes Service tax Yes Yes Yes Yes Excise Yes Yes Yes

fsa imagery [Read-Only] · PDF fileObjectives of Presentation: ... FSA Imagery Requirements ... FSA Ortho Large Format FSA Ortho DOQs Small Format GIS Possible Yes Yes FAA

of the EDTF disclosures made in banks’ 2012 of the EDTF’s … · 2014. 9. 19. · 2012 recommendations as well as banks’ plans for further implementation in 2013. For each EDTF

PowerTrace - LAUTERBACH DEVELOPMENT · PDF file200 mhz powerpc ... efm32gg230f yes yes yes yes efm32gg232f yes yes yes yes efm32gg280f yes yes yes yes efm32gg290f yes yes yes yes efm32gg295f

Remote graphic workloads and clients - TeamRGE · 2019-07-21 · MacOS Mojave MacBook ProYes Yes Yes No* Yes Yes Yes Yes Yes Ubuntu 19.04 Intel NUC Yes Yes Yes No* Yes Yes Yes Yes

27-Feb-20 Student Name ECC At Risk FormTraining ... · Cedeno, Mo'shea yes yes yes yes yes yes 09/11/2019 Cerdas, Gabriel yes yes yes yes yes yes 02/19/2020 Cerino, Ashley yes yes

eproc.punjab.gov.pkeproc.punjab.gov.pk/BiddingDocuments/65442_Bidding... · Affidavit (on judicial paper) Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

High Speed Dome Cameraf=3.6 - 82.8mmf=3.4 - 102mmf=3.4 - 119mm Yes Yes Yes 23X 30X 35X 12X 12X 12X Yes Yes Yes Yes Yes Yes N/A Yes Yes Yes Yes Yes N/A Yes Max1.3X Yes AWB / ATW / Indoor

Read Vendor FRP / Unlock Custom bootloader custom. IMEI ...Ascend G7 Plius RIO-AL00 2015 Yes Yes Yes - - Yes Yes Yes Yes Yes - Yes Yes Ascend G7 Plius RIO-CL00 2015 Yes Yes Yes - -

ich.unesco.org · Web viewAdi Shurairah Lampung Yes Yes Not yet Yes Heryanto Banten + Yes Yes Yes Yes Dede Suryani DKIJakarta+ Yes Yes Yes (small) Yes Sisca Pratiwi W W. Java+ Yes

Olcott...Multiple Sclerosis Mumps Osteoporosis Pacemaker Yes Cl Yes [2 Yes Yes Yes [2 Yes Parkinson's Disease [2 Yes ... Yes [2 Yes D Yes Yes C] Yes Yes Rheumatoid Arthritis Yes HABITS

Chest a b)thersome cwghing of b"? Or between cdds? wheezng or *histiing in dust? of breath when Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes ... age 10 Frs.?

THE STATE OF CHARTER AUTHORIZING 2016€¦ · Lindenwood University MO 12 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes School District CA 12 Yes Yes Yes Yes Yes Yes Yes ... THE

SUMMER MENU INFORMATION · PORK BELLY PORCHETTA Yes Yes, Wheat Yes Yes Yes Yes None SEABASS AL FORNO Yes Yes Yes Yes Yes Yes None SLOW COOKED BEEF IN CHIANTI SAUCE Yes, Wheat, Barley

Product Quick Reference Guide... · Carbo 1-1-0 Supplemental Yes Yes 2 g/A Yes Yes Yes Yes Yes Protriastim 1%N Supplemental Yes* Yes 0.5 pt/A Yes Yes Yes Yes Yes Nutritional Transplant

rulindo.gov.rwrulindo.gov.rw/fileadmin/templates/Jobs/Abakozi_bashinzwe_iter...N/A N/A N/A Yes Yes Yes Yes Yes Yes Yes Yes Yes yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Dell Lifecycle Controller Graphical User Interface · Yes Yes Yes Yes Operating system deployment Yes Yes Yes Yes Device configuration Yes Yes Yes Yes Diagnostics Yes Yes Yes Yes

MergedFile - Jiwaji University offic… ·  · 2017-05-30PATIRAM SHIVHARE INSTITUTE OF TEACHER EDUCATION (Id: YES YES ycs YES YES YES NO YES YES YES NO YES YES YES YES ... HIYA dr

Start | Kettenbach Dental€¦ · Marginal Yes Yes Yes Super Fast: Yes Classic: Yes Yes Reg: Yes Fast: Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Mouth Removal Time (From Start of Mix)