North Coast GIDE Address Management Geodatabase Documentation
Date: Wednesday, July 31, 2024
Time: 3:26:10 PM
Summary Information and Links
1 Feature Datasets with 6 Feature Classes
1 Topology Dataset
No Geometric Networks
No Rasters
6 Tables (Object Classes)
6 Relationship Classes
34 Domains
Feature Datasets and Child Classes
Address - Feature Dataset
AddressEntrancePoint - Feature Class
AddressLine - Feature Class
AddressPoint - Feature Class
GeopoliticalArea - Feature Class
RoadCenterline - Feature Class
SiteAddressPoint - Feature Class
Workspace-Level Tables and Feature Classes
AliasRoadName - Table
MasterRoadName - Table
PostalAddress - Table
usersBoundary - Table
AddressingContacts - Table
Relationship Classes
AddressPointHasSiteAddresses
RoadCenterlineHasAliasNames
SiteAddressPointsHaveAddressEntrancePoints
SiteAddressHasPostalAddresses
GeopoliticalArea_usersBoundary
GeopoliticalArea_AddressingContacts
Domains
AddressParity
AddressPointType
AddressStatus
AddressUnitType
AttributeRuleType
CompassDirection
County
CountyMunicipality
CountyStrType
DirectionSide
FIPS_CodeMunicipal
GeopoliticalAreaType
GradeLevel
LeftRight
MailingAddressType
MSAGCommunity
OneWayIndicator
PointCollectionMethod
RoadClass
RoadPostDir
RoadPrefix
FullRoadType
RoadType
RouteType
SiteAddressLocation
StateAbbreviation
StructureType
SurfaceType
Validation Error Exception
Validation Error Phase
Validation Error Status
Validation Status
YesNo
ZipCode
Attribute Rules
Site Address Calculation
Site Address Constraint
Site Address Validation
Address Point Calculation
Entrance Point Calculation
Address Line Calculation
Road Centerline Calculation
Road Centerline Constraint
Road Centerline Validation
Address - FeatureDataset
Description
|
This dataset contains address layers such as the site address and other feature classes required for the administration of address information. |
AddressEntrancePoint - FeatureClass
Name
|
AddressEntrancePoint |
ShapeType
|
Point |
FeatureType
|
Simple |
AliasName
|
Entrance Points |
HasM
|
false |
HasZ
|
true |
HasAttachments
|
false |
Description
|
Address entrance points are complimentary to Site address points and represent any additional the location where the public, or a service provider, would gain access to the specific site or service delivery address. In downtowns or other urban settings, many times the most direct access to an address may not be coincident with the location in which the address was assigned. In rural areas, the address entrance point could represent an entrance to a long or shared driveway. |
Tags
|
Addresses and Names |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
entranceptid |
String |
20 |
Entrance ID |
Locally assigned Address Entrance point identifier |
|
|
true |
|
|
siteaddid |
String |
20 |
Site Address ID |
Locally assigned Site Address point identifier |
|
|
true |
|
|
pointtype |
String |
30 |
Address Point Type |
A general classification of what the Address Entrance point represents |
AddressPointType
|
|
true |
|
|
capturemeth |
String |
30 |
Capture Method |
Capture method for Address Entrance point |
PointCollectionMethod
|
|
true |
|
|
restaccess |
String |
5 |
Restricted Access |
A flag used to indicate whether the Address Entrance point has restricted access |
YesNo
|
|
true |
|
|
AddressLine - FeatureClass
Name
|
AddressLine |
ShapeType
|
Line/td>
|
FeatureType
|
Simple |
AliasName
|
Address Line |
HasM
|
false |
HasZ
|
true |
HasAttachments
|
false |
Description
|
Address Line is used by ArcGIS Pro Tasks to create address features. |
Tags
|
Addresses and Tasks |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
pointtype |
String |
30 |
Address Point Type |
A general classification of what the Address Point represents |
AddressPointType
|
|
true |
|
|
capturemeth |
String |
30 |
Capture Method |
Capture method for Address Point |
PointCollectionMethod
|
|
true |
|
|
incrementval |
SmallInteger |
2 |
Increment Value |
The address increment value (used for ArcGIS Pro Tasks) |
|
0 |
true |
|
|
AddressPoint - FeatureClass
Name
|
AddressPoint |
ShapeType
|
Point |
FeatureType
|
Simple |
AliasName
|
AddressPoint |
HasM
|
false |
HasZ
|
true |
HasAttachments
|
false |
Description
|
Address Points represent the location along the Road network where the specific site or service delivery address has been assigned. |
Tags
|
Addresses and Names |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
addressptid |
String |
20 |
Access ID |
Locally assigned Address Point identifier |
|
|
true |
|
|
pointtype |
String |
30 |
Address Point Type |
A general classification of what the Address Point represents |
AddressPointType
|
|
true |
|
|
capturemeth |
String |
30 |
Capture Method |
Capture method for Address Point |
PointCollectionMethod
|
|
true |
|
|
offdist |
Double |
8 |
Offset Distance |
The distance a related Site Address is offset from the road |
|
|
true |
|
|
offdir |
String |
5 |
Offset Direction |
The side of a related Site Address if offset from the road |
LeftRight
|
|
true |
|
|
numpoints |
SmallInteger |
2 |
# of Site Addresses |
The number of Site Addresses placed at location (used for ArcGIS Pro Tasks) |
|
1 |
true |
|
|
incrementval |
SmallInteger |
2 |
Increment Value |
The address increment value (used for ArcGIS Pro Tasks) |
|
0 |
true |
|
|
GeopoliticalArea - FeatureClass
Name
|
GeopoliticalArea |
ShapeType
|
Polygon |
FeatureType
|
Simple |
AliasName
|
Geopolitical Areas |
HasM
|
false |
HasZ
|
false |
HasAttachments
|
false |
Description
|
The geographic extent of a political governance area or civil area, referred to in US OMB Curcular A-16 as governmental units. |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
LOCALID |
String |
10 |
Local ID |
A local identifier for the Geopolitical Area |
|
|
true |
|
|
NAME |
String |
255 |
Name |
The name of the Geopolitical Area |
|
|
true |
|
|
GEOTYPE |
String |
50 |
Type |
The type of Geopolitical Area |
GeopoliticalAreaType
|
|
true |
|
|
FULLFIPS |
String |
7 |
Full FIPS |
The seven digit FIPS code that includes the state and unique county or Geopolitical Area |
|
|
true |
|
|
LEGALAREA |
Double |
8 |
Legal Area |
The legal area of the Geopolitical Area |
|
|
true |
|
|
EFFECTDATE |
Date |
8 |
Effective Date |
The effective date of the Geopolitical Area |
|
|
true |
|
|
ENDDATE |
Date |
8 |
End Date |
The end date of the Geopolitical Area |
|
|
true |
|
|
SRCREF |
String |
100 |
Source Reference |
The index number assigned to the encumbrance or other reference document |
|
|
true |
|
|
RoadCenterline - FeatureClass
Name
|
RoadCenterline |
ShapeType
|
Polyline |
FeatureType
|
Simple |
AliasName
|
Road Centerlines |
HasM
|
false |
HasZ
|
true |
HasAttachments
|
false |
Description
|
Road segments that represent the centerlines of all roadways or carriageways and used for address geocoding, as well as a source for public works and other agencies responsible for the active management of the road network. |
Tags
|
Transportation |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
centerlineid |
String |
20 |
Centerline ID |
A unique id for the Road Centerline segment |
|
|
true |
|
|
rclnguid |
String |
254 |
NENA Global ID |
The NENA Globally Unique ID |
|
|
true |
|
|
discrpagid |
String |
75 |
Discrepancy Agency ID |
The agency, as defined by NENA Master Glossary, that receives the discrepancy report, should one be discovered |
|
|
true |
|
|
rangeprefixleft |
String |
15 |
Left Address Number Prefix |
An extension of the address range number on left side of the road |
|
|
true |
|
|
fromleft |
Integer |
4 |
Left From Address |
Lowest address range on left side of the road |
|
|
true |
|
|
toleft |
Integer |
4 |
Left To Address |
Highest address range on left side of the road |
|
|
true |
|
|
parityleft |
String |
1 |
Parity Left |
The even or odd property of the address number range on left side of the road |
AddressParity
|
|
true |
|
|
rangeprefixright |
String |
15 |
Right Address Number Prefix |
An extension of the address range number on right side of the road |
|
|
true |
|
|
fromright |
Integer |
4 |
Right From Address |
Lowest address range on right side of the road |
|
|
true |
|
|
toright |
Integer |
4 |
Right To Address |
Highest address range on right side of the road |
|
|
true |
|
|
parityright |
String |
1 |
Parity Right |
The even or odd property of the address number range on right side of the road |
AddressParity
|
|
true |
|
|
fullname |
String |
300 |
Full Road Name |
The full name of the road including any prefix and/or suffix in mixed case format |
|
|
true |
|
|
fedroute |
String |
10 |
Federal Route |
The federal route name |
|
|
true |
|
|
fedrtetype |
String |
20 |
Federal Route Type |
A functional classification of route that can be used to symbolize the route if detail beyond what is provided in ROADCLASS is needed |
RouteType
|
|
true |
|
|
afedrte |
String |
10 |
Alternate Federal Route |
The alternate federal route name |
|
|
true |
|
|
afedrtetype |
String |
20 |
Alternate Federal Route Type |
A functional classification of federal route that can be used to further classify the route if different than the ROADCLASS |
RouteType
|
|
true |
|
|
stroute |
String |
10 |
State Route |
The state route name |
|
|
true |
|
|
strtetype |
String |
20 |
State Route Type |
A functional classification of route that can be used to symbolize the route if detail beyond what is provided in ROADCLASS is needed |
RouteType
|
|
true |
|
|
astrte |
String |
10 |
Alternate State Route |
The alternate state route name |
|
|
true |
|
|
astrtetype |
String |
20 |
Alternate State Route Type |
A functional classification of route that can be used to symbolize the route if detail beyond what is provided in ROADCLASS is needed |
RouteType
|
|
true |
|
|
ctyroute |
String |
10 |
County Route |
The county route name |
|
|
true |
|
|
CountyStreetType |
Short Integer |
|
County Street Type |
The type of street |
CountyStrType
|
Municipal Street |
true |
|
|
onewaydir |
String |
10 |
One Way Indicator |
A code that indicates whether the traffic flows with, or against, the direction of the vertices |
OneWayIndicator
|
|
true |
|
|
roadlevel |
Integer |
4 |
Above or Below Grade |
A code that indicates whether the traveled roadway is above or below grade |
GradeLevel
|
|
true |
|
|
inwater |
String |
5 |
In Water |
A flag that indicates whether the segment of the road is crossing water |
YesNo
|
|
true |
|
|
roadclass |
String |
20 |
Road Class |
Functional classification of roads based on type of service |
RoadClass
|
|
true |
|
|
lanes |
Long Integer |
|
Number of Lanes |
The number of lanes of the segment |
|
|
true |
|
|
speed |
Long Integer |
|
Speed Limit |
Speed Limit of the segment in miles per hour |
|
|
true |
|
|
surfacetype |
String |
255 |
Surface Type |
The type of surface of the segment |
surfacetype
|
Paved |
true |
|
|
cardinal |
String |
3 |
Cardinal |
Is the segment digitized in the Cardinal direction for LBRS purposes.(South to North/West to East) |
YesNo
|
Yes |
true |
|
|
divided |
String |
3 |
Divided Highway |
Is the segment part of a divided highway |
YesNo
|
No |
true |
|
|
Reverse Direction |
String |
3 |
Reverse Direction |
Are the address numbers on either side of the road increasing in the opposite direction of the digitized road |
YesNo
|
No |
true |
|
|
countryleft |
String |
2 |
Country on Left |
Country abbreviation on left side of the road |
|
US |
true |
|
|
countryright |
String |
2 |
Country on Right |
Country abbreviation on right side of the road |
|
US
| true |
|
|
stateleft |
String |
2 |
State on Left |
State abbreviation on left side of the road |
StateAbbreviation
|
Ohio |
true |
|
|
stateright |
String |
2 |
State on Right |
State abbreviation on right side of the road |
StateAbbreviation
|
Ohio |
true |
|
|
countyleft |
String |
40 |
County on Left |
County name on left side of the road |
|
Cuyahoga |
true |
|
|
countyright |
String |
40 |
County on Right |
County name on right side of the road |
|
Cuyahoga |
true |
|
|
munileft |
String |
100 |
Municipality on Left |
Municipal name on left side of the road |
CountyMunicipality |
|
true |
|
|
muniright |
String |
100 |
Municipality on Right |
Municipal name on right side of the road |
CountyMunicipality |
|
true |
|
|
zipleft |
String |
5 |
Zip on Left |
Zip code on left side of the road |
ZipCode |
|
true |
|
|
zipright |
String |
5 |
Zip on Right |
Zip code on right side of the road |
ZipCode |
|
true |
|
|
FIPSleft |
String |
5 |
FIPS on Left |
FIPS code on left side of the road |
FIPS_CodeMunicipal |
|
true |
|
|
FIPSright |
String |
5 |
FIPS on Right |
FIPS code on right side of the road |
FIPS_CodeMunicipal |
|
true |
|
|
msagleft |
String |
35 |
MSAG on Left |
The MSAG community on left side of the road |
MSAGCommunity |
|
true |
|
|
msagright |
String |
35 |
MSAG on Right |
The MSAG community on right side of the road |
MSAGCommunity |
|
true |
|
|
esnleft |
String |
5 |
ESN on Left |
The ESN on left side of the road |
|
|
true |
|
|
esnright |
String |
5 |
ESN on Right |
The ESN on right side of the road |
|
|
true |
|
|
precenterlineid |
String |
20 |
Previous Centerline ID |
The previous Centerline ID for the Road Centerline segment |
|
|
true |
|
|
nflid |
String |
255 |
NFL ID |
Another unique id for the Road Centerline segment for LBRS purposes |
|
|
true |
|
|
VALIDATIONSTATUS |
Short Integer |
|
Validation Status |
The Topology and Attribute Rule validation status of the road centerline segment |
Validation Status |
Calculation required, validation required, no error>
| true |
|
|
SiteAddressPoint - FeatureClass
Name
|
SiteAddressPoint |
ShapeType
|
Point |
FeatureType
|
Simple |
AliasName
|
Site Addresses |
HasM
|
false |
HasZ
|
true |
HasAttachments
|
false |
Description
|
Site Address points represent the main entrance location of site or service delivery addresses. |
Tags
|
Addresses and Names |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
siteaddid |
String |
20 |
Site Address ID |
Locally assigned Site Address point identifier |
|
|
true |
|
|
addressptid |
String |
20 |
Address Point ID |
Unique Address Point identifier - Foreign Key |
|
|
true |
|
|
rclnguid |
String |
254 |
NENA Global ID |
The NENA Globally Unique ID |
|
|
true |
|
|
discrpagid |
String |
75 |
Discrepancy Agency ID |
The agency, as defined by NENA Master Glossary, that receives the discrepancy report, should one be discovered |
|
|
true |
|
|
preaddrnum |
String |
5 |
Address Number Prefix |
The address number prefix |
|
|
true |
|
|
addrnumsuf |
String |
5 |
Address Number Suffix |
The address number suffix |
|
|
true |
|
|
addrnum |
String |
20 |
Full Address Number |
The full address number |
|
|
true |
|
|
addrrange |
String |
50 |
Address Range |
Address range when a point describes a set of addresses |
|
|
true |
|
|
unittype |
String |
10 |
Address Unit Type |
The address unit type |
AddressUnitType
|
|
true |
|
|
unitid |
String |
10 |
Address Unit Number |
The address unit designation |
|
|
true |
|
|
altunittype |
String |
10 |
Alternate Address Unit Type |
The alternate or secondary address unit type |
AddressUnitType
|
|
true |
|
|
altunitid |
String |
10 |
Alternate Address Unit Number |
The alternate or secondary address unit designation |
|
|
true |
|
|
secondaltunittype |
String |
10 |
2nd Alternate Address Unit Type |
The second alternate address unit type |
AddressUnitType
|
|
true |
|
|
secondaltunitid |
String |
10 |
2nd Alternate Address Unit Number |
The second alternate address unit designation |
|
|
true |
|
|
thirdaltunittype |
String |
10 |
3rd Alternate Address Unit Type |
The third alternate address unit type |
AddressUnitType
|
|
true |
|
|
thirdaltunitid |
String |
10 |
3rd Alternate Address Unit Number |
The third alternate address unit designation |
|
|
true |
|
|
fourthaltunittype |
String |
10 |
4th Alternate Address Unit Type |
The fourth alternate address unit type |
AddressUnitType
|
|
true |
|
|
fourthaltunitid |
String |
10 |
4th Alternate Address Unit Number |
The fourth alternate address unit designation |
|
|
true |
|
|
fullname |
String |
300 |
Full Road Name |
The full name of the road including any prefix and/or suffix in mixed case format |
|
|
true |
|
|
fulladdr |
String |
500 |
Full Address |
Address information combined into one text field. In your community, this may include the following fields: PREADDRNUM, ADDRNUM, ADDRNUMSUF, FULLNAME, UNITTYPE, UNITID, ALTUNITTYPE, and ALTUNITID. |
|
|
true |
|
|
placename |
String |
250 |
Place Name |
A common name or vanity address for the site or service delivery address |
|
|
true |
|
|
country |
String |
2 |
Country Abbreviation |
The country abbreviation the Site Address resides in |
|
US |
true |
|
|
stateabbreviation |
String |
2 |
State Abbreviation |
The state abbreviation the Site Address resides in |
StateAbbreviation
|
Ohio |
true |
|
|
county |
String |
40 |
County Name |
The name of the county the Site Address resides in |
|
Cuyahoga |
true |
|
|
municipality |
String |
100 |
Municipality Name |
The name of the physical municipality the Site Address resides in |
CountyMunicipality |
|
true |
|
|
Zip |
String |
5 |
Zip Code |
The ZIP Code for the Site Address |
CountyMunicipality |
|
true |
|
|
capturemeth |
String |
30 |
Capture Method |
Capture method for Site Address point |
PointCollectionMethod
|
|
true |
|
|
Structure_Type |
String |
6 |
Structure Type |
General structure type of the Site Address |
StructureType
|
Single Family |
true |
|
|
Floor |
String |
4 |
Floor |
The floor level of the Site Address |
|
|
true |
|
|
SubName |
String |
128 |
Subdivision Name |
The name of the subdivion the Site Address resides in |
|
|
true |
|
|
Side |
String |
1 |
Side |
The side of the road segment the Site Address resides on, base on digitized direction of road segment |
DirectionSide |
|
true |
|
|
AbsSide |
String |
2 |
Abs side |
The absolute compass direction the Site Address resides on in relation to the road segment |
CompassDirection |
|
true |
|
|
CollectionDate |
Date |
|
Collection Date |
The date the address was recorded in the system |
|
|
true |
|
|
FIPSCode |
String |
5 |
FIPSCode |
The FIPS code the Site Address resides in |
FIPS_CodeMunicipal |
|
true |
|
|
esn |
String |
5 |
Emergency Service Number |
The Emergency Service Number the Site Address resides in |
|
|
true |
|
|
msag |
String |
35 |
MSAG Community |
The valid service community name identified by the MSAG the Site Address resides in |
|
|
true |
|
|
usngcoord |
String |
50 |
USNG Coordinate |
The USNG coordinate value |
|
|
true |
|
|
centerlineid |
String |
20 |
centerlineid |
The Centerline ID of the Road Centerline the Site Address resides on |
|
|
true |
|
|
addrclass |
Long Integer |
4 |
Description |
A general classification of how the structure or location represented by the Site Address point is used - FacilitySite Subtype Classification |
|
|
true |
|
|
pointtype |
String |
30 |
Location |
A general description of the physical location represented by the Site Address point |
SiteAddressLocation
|
|
true |
|
|
status |
String |
30 |
Status |
The status of the Site Address |
AddressStatus
|
|
true |
|
|
VALIDATIONSTATUS |
Short Integer |
|
Validation Status |
The Topology and Attribute Rule validation status of the Site Address point |
Validation Status |
Calculation required, validation required, no error>
| true |
|
|
AliasRoadName - Table
Name
|
AliasRoadName |
AliasName
|
Road Name Aliases |
HasAttachments
|
false |
Description
|
A table used to store a list of valid street name aliases and the Road Centerline features they are associated with. |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
centerlineid |
String |
20 |
Centerline ID |
A unique id for the Road Centerline segment |
|
|
true |
|
|
roadpremod |
String |
50 |
Road Pre Modifier |
A word or phrase in a road name that precedes and modifies the road name |
|
|
true |
|
|
roadpredir |
String |
2 |
Road Pre Direction |
The road name pre direction |
RoadPrefix
|
|
true |
|
|
roadpretype |
String |
5 |
Road Pre Type |
The road name pre type |
FullRoadType
|
|
true |
|
|
roadpretypesep |
String |
20 |
Road Pre Type Seperator |
The road name pre type seperator |
|
|
true |
|
|
roadname |
String |
125 |
Road Name |
The road name |
|
|
true |
|
|
roadtype |
String |
5 |
Road Type |
The road type |
FullRoadType
|
|
true |
|
|
roadpostdir |
String |
2 |
Post Direction |
The road name post direction |
RoadPostDir
|
|
true |
|
|
roadpostmod |
String |
50 |
Road Post Modifier |
A word or phrase in a road name that follows and modifies the road name |
|
|
true |
|
|
fullname |
String |
300 |
Full Road Name |
The full name of the road including any prefix and/or suffix in mixed case format |
|
|
true |
|
|
municipality |
String |
100 |
Municipality Name |
The name of the physical municipality associated with the alternate road name |
|
|
true |
|
|
MasterRoadName - Table
Name
|
MasterRoadName |
AliasName
|
Master Road Names |
HasAttachments
|
false |
Description
|
A table used to store a list of valid street names used to populate names in Road Centerline and Site Address layers. |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
roadpremod |
String |
50 |
Road Pre Modifier |
A word or phrase in a road name that precedes and modifies the road name |
|
|
true |
|
|
roadpredir |
String |
2 |
Road Pre Direction |
The road name pre direction |
RoadPrefix
|
|
true |
|
|
roadpretype |
String |
5 |
Road Pre Type |
The road name pre type |
FullRoadType
|
|
true |
|
|
roadpretypesep |
String |
20 |
Road Pre Type Separator |
The road name pre type seperator |
|
|
true |
|
|
roadname |
String |
125 |
Road Name |
The road name |
|
|
true |
|
|
roadtype |
String |
5 |
Road Type |
The road type |
FullRoadType
|
|
true |
|
|
roadpostdir |
String |
2 |
Post Direction |
The road name post direction |
RoadPostDir
|
|
true |
|
|
roadpostmod |
String |
50 |
Road Post Modifier |
A word or phrase in a road name that follows and modifies the road name |
|
|
true |
|
|
fullname |
String |
300 |
Full Road Name |
The full name of the road including any prefix and/or suffix in mixed case format |
|
|
true |
|
|
municipality |
String |
100 |
Municipality Name |
The name of the physical municipality associated with the master road name |
|
|
true |
|
|
status |
String |
30 |
Status |
The status of the road name |
AddressStatus
|
|
true |
|
|
PostalAddress - Table
Name
|
PostalAddress |
AliasName
|
Postal Addresses |
HasAttachments
|
false |
Description
|
A table used to store postal, or mailing, addresses related to site or service delivery addresses. |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
pstladdid |
String |
20 |
Postal Address Identifier |
Locally assigned mailing address identifier |
|
|
true |
|
|
siteaddid |
String |
20 |
Site Address ID |
Locally assigned Site Address point identifier |
|
|
true |
|
|
ownernm1 |
String |
150 |
Owner Name |
The first name |
|
|
true |
|
|
ownernm2 |
String |
150 |
Owner Name |
The second name |
|
|
true |
|
|
pstladdress |
String |
300 |
Postal Address |
The full mailing address for the Site Address |
|
|
true |
|
|
pstlcity |
String |
100 |
Postal City |
The name of the city where mail is delivered |
|
|
true |
|
|
pstlstate |
String |
2 |
Postal State |
The two digit state abbreviation |
StateAbbreviation
|
|
true |
|
|
pstlzip5 |
String |
5 |
Postal Zip 5 |
The five digit postal zip code |
|
|
true |
|
|
pstlzip4 |
String |
4 |
Postal Zip +4 |
The +4 postal zip code |
|
|
true |
|
|
intstate |
String |
5 |
International State |
The international state abbreviation |
|
|
true |
|
|
intpstlcd |
String |
10 |
International Postal Code |
The international postal code |
|
|
true |
|
|
country |
String |
100 |
Country |
The name of the country |
|
|
true |
|
|
uspsboxtype |
String |
10 |
USPS Box Type |
The name (PO Box or Box) of the class of the container used for receipt of USPS mail |
|
|
true |
|
|
uspsboxid |
String |
25 |
USPS Box Identifier |
The numbers or letters distinguishing one box from another within a post office or route |
|
|
true |
|
|
uspsboxgrp |
String |
50 |
USPS Box Group |
A name for a type of postal delivery point or route containing a group of USPS Boxes |
|
|
true |
|
|
represent |
String |
30 |
Owner / Occupant |
A general classification of individual represented by the mailing address |
MailingAddressType
|
|
true |
|
|
status |
String |
30 |
Status |
The status of the mailing address |
AddressStatus
|
|
true |
|
|
usersBoundary - Table
Name
|
usersBoundary |
AliasName
|
usersBoundary/td>
|
HasAttachments
|
false |
Description
|
A table used to store the usernames of allowed editors of Geopolitical Areas. |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
username |
String |
255 |
username |
Username of Editor |
|
|
true |
|
|
boundaryguid |
GUID |
|
boundaryGuid |
GUID of related Geopolitical Area |
|
|
true |
|
|
AddressingContacts - Table
Name
|
AddressingContacts |
AliasName
|
Addressing Contacts |
HasAttachments
|
false |
Description
|
A table used to store the addressing contacts for geopolitical areas. |
Field
|
DataType
|
Length
|
AliasName
|
Description
|
Domain
|
DefaultValue
|
IsNullable
|
Precision
|
Scale
|
muni |
String |
100 |
Municipality |
Jurisidiction name |
|
|
true |
|
|
title |
String |
255 |
Title |
Title of contact |
|
|
true |
|
|
department |
String |
255 |
Department |
Department of contact |
|
|
true |
|
|
firstname |
String |
255 |
First Name |
First Name of contact |
|
|
true |
|
|
lastname |
String |
255 |
Last Name |
Last Name of contact |
|
|
true |
|
|
email |
String |
255 |
Email |
Email of contact |
|
|
true |
|
|
phone |
string |
255 |
Phone |
Phone number of contact |
|
|
true |
|
|
ordinace |
String |
255 |
Ordinance |
Codified ordinance for addressing in the jurisdiction |
|
|
true |
|
|
policy |
String |
255 |
Policy |
Addressing policy in the jurisdiction |
|
|
true |
|
|
engineer |
String |
255 |
Local Engineer |
Name of the jurisdiction's engineer |
|
|
true |
|
|
gisstatus |
String |
255 |
GIS |
Status of GIS in the jurisdiction |
|
|
true |
|
|
notes |
String |
255 |
Notes |
Additonal information of note |
|
|
true |
|
|
boundaryguid |
GUID |
|
boundaryGuid |
GUID of related Geopolitical Area |
|
|
true |
|
|
AddressPointHasSiteAddresses - RelationshipClass
Name
|
AddressPointHasSiteAddresses |
Cardinality
|
OneToMany |
IsAttributed
|
false |
IsComposite
|
false |
ForwardPathLabel
|
SiteAddressPoint |
BackwardPathLabel
|
AddressPoint |
Description
|
AddressPointHasSiteAddresses |
Origin Class Name
|
Origin Primary Key
|
Origin Foreign Key
|
AddressPoint |
addressptid |
addressptid |
Destination Class Name
|
Destination Primary Key
|
Destination Foreign Key
|
SiteAddressPoint |
|
|
RoadCenterlineHasAliasNames - RelationshipClass
Name
|
RoadCenterlineHasAliasNames |
Cardinality
|
OneToMany |
IsAttributed
|
false |
IsComposite
|
false |
ForwardPathLabel
|
AliasStreetName |
BackwardPathLabel
|
RoadCenterline |
Description
|
RoadCenterlineHasAliasNames |
Origin Class Name
|
Origin Primary Key
|
Origin Foreign Key
|
RoadCenterline |
centerlineid |
centerlineid |
Destination Class Name
|
Destination Primary Key
|
Destination Foreign Key
|
AliasRoadName |
|
|
SiteAddressPointsHaveAddressEntrancePoints - RelationshipClass
Name
|
SiteAddressPointsHaveAddressEntrancePoints |
Cardinality
|
ManyToMany |
IsAttributed
|
false |
IsComposite
|
false |
ForwardPathLabel
|
AddressEntrancePoint |
BackwardPathLabel
|
SiteAddressPoint |
Description
|
Site Address Points can have one or many Address Entrance Points. Address Entrance Points can have one or many Site Address Points. |
Origin Class Name
|
Origin Primary Key
|
Origin Foreign Key
|
SiteAddressPoint |
siteaddid |
siteaddfk |
Destination Class Name
|
Destination Primary Key
|
Destination Foreign Key
|
AddressEntrancePoint |
entranceptid |
entranceptfk |
SiteAddressHasPostalAddresses - RelationshipClass
Name
|
SiteAddressHasPostalAddresses |
Cardinality
|
OneToMany |
IsAttributed
|
false |
IsComposite
|
false |
ForwardPathLabel
|
PostalAddress |
BackwardPathLabel
|
SiteAddressPoint |
Description
|
Site Address Points can have one or many Postal Address records. |
Origin Class Name
|
Origin Primary Key
|
Origin Foreign Key
|
SiteAddressPoint |
siteaddid |
siteaddid |
Destination Class Name
|
Destination Primary Key
|
Destination Foreign Key
|
PostalAddress |
|
|
GeopoliticalArea_AddressingContacts - RelationshipClass
Name
|
GeopoliticalArea_AddressingContacts |
Cardinality
|
OneToMany |
IsAttributed
|
false |
IsComposite
|
false |
ForwardPathLabel
|
AddressingContacts |
BackwardPathLabel
|
GeopoliticalArea |
Description
|
Geopolitical Boundaries will have one or more addressing contacts. |
Origin Class Name
|
Origin Primary Key
|
Origin Foreign Key
|
GeopoliticalBoundary |
GlobalID |
boundaryguid |
Destination Class Name
|
Destination Primary Key
|
Destination Foreign Key
|
AddressingContacts |
|
|
GeopoliticalArea_userBoundary - RelationshipClass
Name
|
GeopoliticalArea_userBoundary |
Cardinality
|
OneToMany |
IsAttributed
|
false |
IsComposite
|
false |
ForwardPathLabel
|
usersBoundary |
BackwardPathLabel
|
GeopoliticalArea |
Description
|
Geopolitical Boundaries can limit one or many users as editors of the area. |
Origin Class Name
|
Origin Primary Key
|
Origin Foreign Key
|
GeopoliticalBoundary |
GlobalID |
boundaryguid |
Destination Class Name
|
Destination Primary Key
|
Destination Foreign Key
|
usersBoundary |
|
|
AddressParity - Domain
DomainName
|
AddressParity |
Description
|
The even or odd property of the address |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
O |
Odd |
E |
Even |
B |
Both |
Z |
Address Range 0-0 |
AddressPointType - Domain
DomainName
|
AddressPointType |
Description
|
The type of address point feature |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Driveway Entrance |
Driveway Entrance |
Building Entrance |
Building Entrance |
Other |
Other |
Unknown |
Unknown |
AddressStatus - Domain
DomainName
|
AddressStatus |
Description
|
The status of the address or related feature |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Current |
Current |
Pending |
Pending |
Retired |
Retired |
Temporary |
Temporary |
Other |
Other |
AddressUnitType - Domain
DomainName
|
AddressUnitType |
Description
|
The type of address unit as adapted from the USPS Publication 28 |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
APT |
Apartment |
BSMT |
Basement |
BLDG |
Building |
DEPT |
Department |
DUPL |
Duplex |
FL |
Floor |
FRNT |
Front |
GRGE |
Garage |
HNGR |
Hanger |
KEY |
Key |
LBBY |
Lobby |
LOFT |
Loft |
LOT |
Lot |
LOWR |
Lower |
OFC |
Office |
PH |
Penthouse |
PIER |
Pier |
REAR |
Rear |
RM |
Room |
SEAT |
Seat |
SIDE |
Side |
SLIP |
Slip |
SPC |
Space |
STOP |
Stop |
STU |
Studio |
STE |
Suite |
THSE |
Townhouse |
TRLR |
Trailer |
UNIT |
Unit |
UPPR |
Upper |
WHSE |
Warehouse |
Other |
Other |
AttributeRuleType - Domain
DomainName
|
AttributeRuleType |
Description
|
The attribute rule type that created the error record. |
FieldType
|
Short |
Domain Type
|
CodedValue |
Code
|
Name
|
0 |
Calculation |
1 |
Constraint |
2 |
Validation |
CompassDirection - Domain
DomainName
|
CompassDirection |
Description
|
Compass Directions |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
N |
N |
S |
S |
E |
E |
W |
W |
NE |
NE |
NW |
NW |
SE |
SE |
SW |
SW |
County - Domain
DomainName
|
County |
Description
|
Local List of Counties |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Cuyahoga |
Cuyahoga |
Lake |
Lake |
Portage |
Portage |
Geauga |
Geauga |
Summit |
Summit |
Medina |
Medina |
Lorain |
Lorain |
CountyMunicipality - Domain
DomainName
|
CountyMunicipality |
Description
|
Local List of Municipalities and Townships |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Bay Village |
Bay Village |
Beachwood |
Beachwood |
Bedford |
Bedford |
Bedford Heights |
Bedford Heights |
Bentleyville |
Bentleyville |
Berea |
Berea |
Bratenhal |
Bratenhal |
Brecksville |
Brecksville |
Broadview Heights |
Broadview Heights |
Brook Park |
Brook Park |
Brooklyn |
Brooklyn |
Brooklyn Heights |
Brooklyn Heights |
Chagrin Falls |
Chagrin Falls |
Chagrin Falls Township |
Chagrin Falls Township |
Cleveland |
Cleveland |
Cleveland Heights |
Cleveland Heights |
Cuyahoga Heights |
Cuyahoga Heights |
East Cleveland |
East Cleveland |
Euclid |
Euclid |
Fairview Park |
Fairview Park |
Garfield Heights |
Garfield Heights |
Gates Mills |
Gates Mills |
Glenwillow |
Glenwillow |
Highland Heights |
Highland Heights |
Highland Hills |
Highland Hills |
Hunting Valley |
Hunting Valley |
Independence |
Independence |
Lakewood |
Lakewood |
Linndale |
Linndale |
Lyndhurst |
Lyndhurst |
Maple Heights |
Maple Heights |
Mayfield |
Mayfield |
Mayfield Heights |
Mayfield Heights |
Middleburg Heights |
Middleburg Heights |
Moreland Hills |
Moreland Hills |
Newburgh Heights |
Newburgh Heights |
North Olmsted |
North Olmsted |
North Randall |
North Randall |
North Royalton |
North Royalton |
Oakwood |
Oakwood |
Olmsted Falls |
Olmsted Falls |
Olmsted Township |
Olmsted Township |
Orange |
Orange |
Parma |
Parma |
Parma Heights |
Parma Heights |
Pepper Pike |
Pepper Pike |
Richmond Heights |
Richmond Heights |
Rocky River |
Rocky River |
Seven Hills |
Seven Hills |
Shaker Heights |
Shaker Heights |
Solon |
Solon |
South Euclid |
South Euclid |
Strongsville |
Strongsville |
University Heights |
University Heights |
Valley View |
Valley View |
Walton Hills |
Walton Hills |
Warrensville Heights |
Warrensville Heights |
Westlake |
Westlake |
Woodemere |
Woodmere |
Unknown |
Unknown |
CountyStrType - Domain
DomainName
|
CountyStrType |
Description
|
Cuyahoga County Street Type |
FieldType
|
Short |
Domain Type
|
CodedValue |
Code
|
Name
|
1 |
Interstate |
2 |
US Route |
3 |
State Route |
4 |
County Road |
5 |
Township Road |
6 |
Municipal Street |
7 |
Ramp |
8 |
Residential Driveway |
9 |
Commercial Driveway |
10 |
Government Driveway |
16 |
Crossover |
11 |
Private Street |
12 |
Bike Path |
13 |
State Park Road |
14 |
Federal Park Road |
DirectionSide - Domain
DomainName
|
DirectionSide |
Description
|
Directional side of segment |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
L |
Left Side |
R |
Right Side |
FIPS_CodeMunicipal - Domain
DomainName
|
FIPS_CodeMunicipal |
Description
|
FIPS Codes of Municipalities |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
04416 |
04416 Bay Village |
04500 |
04500 Beachwood |
04878 |
04878 Bedford |
04920 |
04920 Bedford Heights |
05550 |
05550 Bentleyville |
05690 |
05690 Berea |
08336 |
08336 Bratenhal |
08364 |
08364 Brecksville |
09064 |
09064 Broadview Heights |
09288 |
09288 Brook Park |
09246 |
09276 Brooklyn |
09274 |
09274 Brooklyn Heights |
13358 |
13358 Chagrin Falls |
13372 |
13372 Chagrin Falls Township |
16000 |
16000 Cleveland |
16014 |
16014 Cleveland Heights |
19806 |
19806 Cuyahoga Heights |
23380 |
23380 East Cleveland |
25704 |
25704 Euclid |
26446 |
26446 Fairview Park |
29428 |
29428 Garfield Heights |
29498 |
29498 Gates Mills |
30632 |
30632 Glenwillow |
35252 |
35252 Highland Heights |
35255 |
35255 Highland Hills |
36918 |
36918 Hunting Valley |
37240 |
37240 Independence |
41664 |
41664 Lakewood |
43918 |
43918 Linndale |
45556 |
45556 Lyndhurst |
47306 |
47306 Maple Heights |
48468 |
48468 Mayfield |
48482 |
48482 Mayfield Heights |
49644 |
48644 Middleburg Heights |
52052 |
52052 Moreland Hills |
54250 |
54250 Newburgh Heights |
56882 |
56882 North Olmsted |
56924 |
56924 North Randall |
57008 |
57008 North Royalton |
57750 |
57750 Oakwood |
58422 |
58422 Olmsted Falls |
58408 |
58408 Olmsted Township |
58604 |
58604 Orange |
61000 |
61000 Parma |
61028 |
61028 Parma Heights |
61686 |
61686 Pepper Pike |
66894 |
66894 Richmond Heights |
68056 |
68056 Rocky River |
71416 |
71416 Seven Hills |
71682 |
71682 Shaker Heights |
72928 |
72928 Solon |
73264 |
73264 South Euclid |
75098 |
75098 Strongsville |
78932 |
78932 University Heights |
79268 |
79268 Valley View |
80738 |
80738 Walton Hills |
80990 |
80990 Warrensville Heights |
83622 |
83622 Westlake |
86394 |
86394 Woodmere |
00000 |
00000 Unknown |
GeopoliticalAreaType - Domain
DomainName
|
GeopoliticalAreaType |
Description
|
The type of geopolitical area |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Borough |
Borough |
City |
City |
County |
County |
Independent City |
Independent City |
Minor Civil Division |
Minor Civil Division |
Parish |
Parish |
Town |
Town |
Township |
Township |
Village |
Village |
Other |
Other |
GradeLevel - Domain
DomainName
|
GradeLevel |
Description
|
A classification used to identify the level above or below grade a specfic transportation (road, rail, etc.) segment is. |
FieldType
|
Integer |
Domain Type
|
CodedValue |
Code
|
Name
|
-2 |
Second Subsurface |
-1 |
Subsurface |
0 |
Ground Level |
1 |
First Level |
2 |
Second Level |
3 |
Third Level |
4 |
Fourth Level |
LeftRight - Domain
DomainName
|
LeftRight |
Description
|
A left/right flag for creating site address point |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Left |
Left |
Right |
Right |
MailingAddressType - Domain
DomainName
|
MailingAddressType |
Description
|
The type of mailing address classifies the address record by owner, occupant or both. |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Owner/Occupant |
Owner/Occupant |
Owner |
Owner |
Occupant |
Occupant |
Other |
Other |
MSAGCommunity - Domain
DomainName
|
MSAGCommunity |
Description
|
Valid MSAG Communities |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Bay Village |
Bay Village |
Beachwood |
Beachwood |
Bedford |
Bedford |
Bedford Heights |
Bedford Heights |
Bentleyville |
Bentleyville |
Berea |
Berea |
Bratenhal |
Bratenhal |
Brecksville |
Brecksville |
Broadview Heights |
Broadview Heights |
Brook Park |
Brook Park |
Brooklyn |
Brooklyn |
Brooklyn Heights |
Brooklyn Heights |
Chagrin Falls |
Chagrin Falls |
Chagrin Falls Township |
Chagrin Falls Township |
Cleveland |
Cleveland |
Cleveland Heights |
Cleveland Heights |
Cuyahoga Heights |
Cuyahoga Heights |
East Cleveland |
East Cleveland |
Euclid |
Euclid |
Fairview Park |
Fairview Park |
Garfield Heights |
Garfield Heights |
Gates Mills |
Gates Mills |
Glenwillow |
Glenwillow |
Highland Heights |
Highland Heights |
Highland Hills |
Highland Hills |
Hunting Valley |
Hunting Valley |
Independence |
Independence |
Lakewood |
Lakewood |
Linndale |
Linndale |
Lyndhurst |
Lyndhurst |
Maple Heights |
Maple Heights |
Mayfield |
Mayfield |
Mayfield Heights |
Mayfield Heights |
Middleburg Heights |
Middleburg Heights |
Moreland Hills |
Moreland Hills |
Newburgh Heights |
Newburgh Heights |
North Olmsted |
North Olmsted |
North Randall |
North Randall |
North Royalton |
North Royalton |
Oakwood |
Oakwood |
Olmsted Falls |
Olmsted Falls |
Olmsted Township |
Olmsted Township |
Orange |
Orange |
Parma |
Parma |
Parma Heights |
Parma Heights |
Pepper Pike |
Pepper Pike |
Richmond Heights |
Richmond Heights |
Rocky River |
Rocky River |
Seven Hills |
Seven Hills |
Shaker Heights |
Shaker Heights |
Solon |
Solon |
South Euclid |
South Euclid |
Strongsville |
Strongsville |
University Heights |
University Heights |
Valley View |
Valley View |
Walton Hills |
Walton Hills |
Warrensville Heights |
Warrensville Heights |
Westlake |
Westlake |
Woodemere |
Woodmere |
Unknown |
Unknown |
OneWayIndicator - Domain
DomainName
|
OneWayIndicator |
Description
|
An indicator used to determine if traffic flows with the digitized direction of the feature |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
From-To |
From-To |
To-From |
To-From |
Unknown |
Unknown |
PointCollectionMethod - Domain
DomainName
|
PointCollectionMethod |
Description
|
The collection method for a point feature |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
CAMS Update |
CAMS Update |
Community Contribution |
Community Contribution |
External Notification |
External Notification |
Internal Notification |
Internal Notification |
Other |
Other |
Plan or Drawing |
Plan or Drawing |
Site Visit |
Site Visit |
Photogrammetry |
Photogrammetry |
RoadClass - Domain
DomainName
|
RoadClass |
Description
|
A functional classification of roads as adapted from the FHWA |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Major Arterial |
Major Arterial |
Interstate |
Interstate |
Freeway |
Freeway |
Highway |
Highway |
Ramp |
Ramp |
Minor Arterial |
Minor Arterial |
Major Collector |
Major Collector |
Minor Collector |
Minor Collector |
Local |
Local |
Service |
Service |
4WD |
4WD |
Recreation |
Recreation |
Resource |
Resource |
Ferry |
Ferry |
Other |
Other |
Unknown |
Unknown |
Private |
Private |
RoadPostDir - Domain
DomainName
|
RoadPostDir |
Description
|
The road name post direction |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
N |
North |
S |
South |
E |
East |
W |
West |
NE |
Northeast |
NW |
Northwest |
SE |
Southeast |
SW |
Southwest |
NB |
Northbound |
RoadPrefix - Domain
DomainName
|
RoadPrefix |
Description
|
The road name prefix direction |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
N |
North |
S |
South |
E |
East |
W |
West |
NW |
Northwest |
NE |
Northeast |
SE |
Southeast |
SW |
Southwest |
NB |
Northbound |
SB |
Southbound |
EB |
Eastbound |
WB |
Westbound |
FullRoadType - Domain
DomainName
|
FullRoadType |
Description
|
The full road name type as adapted from the USPS Publication 28 |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Alley |
Alley |
Anex |
Anex |
Arcade |
Arcade |
Avenue |
Avenue |
Bayou |
Bayou |
Beach |
Beach |
Bend |
Bend |
Bluff |
Bluff |
Bluffs |
Bluffs |
Bottom |
Bottom |
Boulevard |
Boulevard |
Branch |
Branch |
Bridge |
Bridge |
Brook |
Brook |
Brooks |
Brooks |
Burg |
Burg |
Burgs |
Burgs |
Bypass |
Bypass |
Camp |
Camp |
Canyon |
Canyon |
Cape |
Cape |
Causeway |
Causeway |
Center |
Center |
Centers |
Centers |
Circle |
Circle |
Circles |
Circles |
Cliff |
Cliff |
Cliffs |
Cliffs |
Club |
Club |
Common |
Common |
Commons |
Commons |
Collector |
Collector |
Connector |
Connector |
Corner |
Corner |
Corners |
Corners |
Course |
Course |
Court |
Court |
Courts |
Courts |
Cove |
Cove |
Coves |
Coves |
Creek |
Creek |
Crescent |
Crescent |
Crest |
Crest |
Crossing |
Crossing |
Crossroad |
Crossroad |
Crossroads |
Crossroads |
Curv |
Curve |
Dale |
Dale |
Dam |
Dam |
Divide |
Divide |
Drive |
Drive |
Drives |
Drives |
Estate |
Estate |
Estates |
Estates |
Expressway |
Expressway |
Extension |
Extension |
Extensions |
Extensions |
Fall |
Fall |
Falls |
Falls |
Ferry |
Ferry |
Field |
Field |
Fields |
Fields |
Flat |
Flat |
Flats |
Flats |
Ford |
Ford |
Fords |
Fords |
Forest |
Forest |
Forge |
Forge |
Forges |
Forges |
Fork |
Fork |
Forks |
Forks |
Fort |
Fort |
Freeway |
Freeway |
Garden |
Garden |
Gardens |
Gardens |
Gateway |
Gateway |
Glen |
Glen |
Glens |
Glens |
Green |
Green |
Greens |
Greens |
Grove |
Grove |
Groves |
Groves |
Harbor |
Harbor |
Harbors |
Harbors |
Haven |
Haven |
Heights |
Heights |
Highway |
Highway |
Hill |
Hill |
Hills |
Hills |
Hollow |
Hollow |
Inlet |
Inlet |
Island |
Island |
Islands |
Islands |
Isle |
Isle |
Junction |
Junction |
Junctions |
Junctions |
Key |
Key |
Keys |
Keys |
Knoll |
Knoll |
Knolls |
Knolls |
Lake |
Lake |
Lakes |
Lakes |
Land |
Land |
Landing |
Landing |
Lane |
Lane |
Light |
Light |
Lights |
Lights |
Loaf |
Loaf |
Lock |
Lock |
Locks |
Locks |
Lodge |
Lodge |
Loop |
Loop |
Mall |
Mall |
Manor |
Manor |
Manors |
Manors |
Meadow |
Meadow |
Meadows |
Meadows |
Mew |
Mew |
Mews |
Mews |
Mill |
Mill |
Mills |
Mills |
Mission |
Mission |
Motorway |
Motorway |
Mount |
Mount |
Mountain |
Mountain |
Mountains |
Mountains |
Neck |
Neck |
Offramp |
Offramp |
Onramp |
Onramp |
Orchard |
Orchard |
Oval |
Oval |
Overpass |
Overpass |
Park |
Park |
Parks |
Parks |
Parkway |
Parkway |
Parkways |
Parkways |
Pass |
Pass |
Passage |
Passage |
Path |
Path |
Pike |
Pike |
Pine |
Pine |
Pines |
Pines |
Place |
Place |
Plain |
Plain |
Plains |
Plains |
Plaza |
Plaza |
Point |
Point |
Points |
Points |
Port |
Port |
Ports |
Ports |
Prairie |
Prairie |
Radial |
Radial |
Ramp |
Ramp |
Ranch |
Ranch |
Rapid |
Rapid |
Rapids |
Rapids |
Rest |
Rest |
Ridge |
Ridge |
Ridges |
Ridges |
River |
River |
Road |
Road |
Roads |
Roads |
Route |
Route |
Row |
Row |
Rue |
Rue |
Run |
Run |
Shoal |
Shoal |
Shoals |
Shoals |
Shore |
Shore |
Shores |
Shores |
Skyway |
Skyway |
Spring |
Spring |
Springs |
Springs |
Spur |
Spur |
Spurs |
Spurs |
Square |
Square |
Squares |
Squares |
Station |
Station |
Stravenue |
Stravenue |
Stream |
Stream |
Street |
Street |
Streets |
Streets |
Summit |
Summit |
Terrace |
Terrace |
Throughway |
Throughway |
Trace |
Trace |
Track |
Track |
Trafficway |
Trafficway |
Trail |
Trail |
Trailer |
Trailer |
Tunnel |
Tunnel |
Turnpike |
Turnpike |
Underpass |
Underpass |
Union |
Union |
Unions |
Unions |
Valley |
Valley |
Valleys |
Valleys |
Viaduct |
Viaduct |
View |
View |
Views |
Views |
Village |
Village |
Villages |
Villages |
Ville |
Ville |
Vista |
Vista |
Walk |
Walk |
Walks |
Walks |
Wall |
Wall |
Way |
Way |
Ways |
Ways |
Well |
Well |
Wells |
Wells |
RoadType - Domain
DomainName
|
RoadType |
Description
|
The road name type as adapted from the USPS Publication 28 |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Aly |
Alley |
Anx |
Anex |
Arc |
Arcade |
Ave |
Avenue |
Byu |
Bayou |
Bch |
Beach |
Bnd |
Bend |
Blf |
Bluff |
Blfs |
Bluffs |
Btm |
Bottom |
Blvd |
Boulevard |
Br |
Branch |
Brg |
Bridge |
Brk |
Brook |
Brks |
Brooks |
Bg |
Burg |
Bgs |
Burgs |
Byp |
Bypass |
Cp |
Camp |
Cyn |
Canyon |
Cpe |
Cape |
Cswy |
Causeway |
Ctr |
Center |
Ctrs |
Centers |
Cir |
Circle |
Cirs |
Circles |
Clf |
Cliff |
Clfs |
Cliffs |
Clb |
Club |
Cmn |
Common |
Cmns |
Commons |
Coll |
Collector |
Conn |
Connector |
Cor |
Corner |
Cors |
Corners |
Crse |
Course |
Ct |
Court |
Cts |
Courts |
Cv |
Cove |
Cvs |
Coves |
Crk |
Creek |
Cres |
Crescent |
Crst |
Crest |
Xing |
Crossing |
Xrd |
Crossroad |
Xrds |
Crossroads |
Curv |
Curve |
Dl |
Dale |
Dm |
Dam |
Dv |
Divide |
Dr |
Drive |
Drs |
Drives |
Est |
Estate |
Ests |
Estates |
Expy |
Expressway |
Ext |
Extension |
Exts |
Extensions |
Fall |
Fall |
Fls |
Falls |
Fry |
Ferry |
Fld |
Field |
Flds |
Fields |
Flt |
Flat |
Flts |
Flats |
Frd |
Ford |
Frds |
Fords |
Frst |
Forest |
Frg |
Forge |
Frgs |
Forges |
Frk |
Fork |
Frks |
Forks |
Ft |
Fort |
Fwy |
Freeway |
Gdn |
Garden |
Gdns |
Gardens |
Gtwy |
Gateway |
Gln |
Glen |
Glns |
Glens |
Grn |
Green |
Grns |
Greens |
Grv |
Grove |
Grvs |
Groves |
Hbr |
Harbor |
Hbrs |
Harbors |
Hvn |
Haven |
Hts |
Heights |
Hwy |
Highway |
Hl |
Hill |
Hls |
Hills |
Holw |
Hollow |
Inlt |
Inlet |
Is |
Island |
Iss |
Islands |
Isle |
Isle |
Jct |
Junction |
Jcts |
Junctions |
Ky |
Key |
Kys |
Keys |
Knl |
Knoll |
Knls |
Knolls |
Lk |
Lake |
Lks |
Lakes |
Land |
Land |
Lndg |
Landing |
Ln |
Lane |
Lgt |
Light |
Lgts |
Lights |
Lf |
Loaf |
Lck |
Lock |
Lcks |
Locks |
Ldg |
Lodge |
Loop |
Loop |
Mall |
Mall |
Mnr |
Manor |
Mnrs |
Manors |
Mdw |
Meadow |
Mdws |
Meadows |
Mews |
Mews |
Ml |
Mill |
Mls |
Mills |
Msn |
Mission |
Mtwy |
Motorway |
Mt |
Mount |
Mtn |
Mountain |
Mtns |
Mountains |
Nck |
Neck |
Ofrp |
Offramp |
Onrp |
Onramp |
Orch |
Orchard |
Oval |
Oval |
Opas |
Overpass |
Park |
Park |
Parks |
Parks |
Pkwy |
Parkway |
Pkwys |
Parkways |
Pass |
Pass |
Psge |
Passage |
Path |
Path |
Pike |
Pike |
Pne |
Pine |
Pnes |
Pines |
Pl |
Place |
Pln |
Plain |
Plns |
Plains |
Plz |
Plaza |
Pt |
Point |
Pts |
Points |
Prt |
Port |
Prts |
Ports |
Pr |
Prairie |
Radl |
Radial |
Ramp |
Ramp |
Rnch |
Ranch |
Rpd |
Rapid |
Rpds |
Rapids |
Rst |
Rest |
Rdg |
Ridge |
Rdgs |
Ridges |
Riv |
River |
Rd |
Road |
Rds |
Roads |
Rte |
Route |
Row |
Row |
Rue |
Rue |
Run |
Run |
Shl |
Shoal |
Shls |
Shoals |
Shr |
Shore |
Shrs |
Shores |
Skwy |
Skyway |
Spg |
Spring |
Spgs |
Springs |
Spur |
Spur |
Spurs |
Spurs |
Sq |
Square |
Sqs |
Squares |
Sta |
Station |
Stra |
Stravenue |
Strm |
Stream |
St |
Street |
Sts |
Streets |
Smt |
Summit |
Ter |
Terrace |
Trwy |
Throughway |
Trce |
Trace |
Trak |
Track |
Trfy |
Trafficway |
Trl |
Trail |
Trlr |
Trailer |
Tunl |
Tunnel |
Tpke |
Turnpike |
Upas |
Underpass |
Un |
Union |
Uns |
Unions |
Vly |
Valley |
Vlys |
Valleys |
Via |
Viaduct |
Vw |
View |
Vws |
Views |
Vlg |
Village |
Vlgs |
Villages |
Vl |
Ville |
Vis |
Vista |
Walk |
Walk |
Walks |
Walks |
Wall |
Wall |
Way |
Way |
Ways |
Ways |
Wl |
Well |
Wls |
Wells |
RouteType - Domain
DomainName
|
RouteType |
Description
|
A functional classification of route that can be used to symbolize the route if detail beyond what is provided in ROADCLASS is needed |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Freeway |
Freeway |
Highway |
Highway |
Interstate |
Interstate |
Other |
Other |
Unknown |
Unknown |
SiteAddressLocation - Domain
DomainName
|
SiteAddressLocation |
Description
|
A general description of the physical location represented by the site address point |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Building |
Building |
Mile Post |
Mile Post |
Parcel |
Parcel |
Unit, Condo, Office or Suite |
Unit, Condo, Office or Suite |
Utility Asset |
Utility Asset |
Other |
Other |
Unknown |
Unknown |
StateAbbreviation - Domain
DomainName
|
StateAbbreviation |
Description
|
The two digital abbreviation for the fifty US states as adapted from the USPS Publication 28 |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
AL |
Alabama |
AK |
Alaska |
AS |
American Samoa |
AZ |
Arizona |
AR |
Arkansas |
CA |
California |
CO |
Colorado |
CT |
Connecticut |
DE |
Delaware |
DC |
District Of Columbia |
FM |
Federated States Of Micronesia |
FL |
Florida |
GA |
Georgia |
GU |
Guam |
HI |
Hawaii |
ID |
Idaho |
IL |
Illinois |
IN |
Indiana |
IA |
Iowa |
KS |
Kansas |
KY |
Kentucky |
LA |
Louisiana |
ME |
Maine |
MH |
Marshall Islands |
MD |
Maryland |
MA |
Massachusetts |
MI |
Michigan |
MN |
Minnesota |
MS |
Mississippi |
MO |
Missouri |
MT |
Montana |
NE |
Nebraska |
NV |
Nevada |
NH |
New Hampshire |
NJ |
New Jersey |
NM |
New Mexico |
NY |
New York |
NC |
North Carolina |
ND |
North Dakota |
MP |
Northern Mariana Islands |
OH |
Ohio |
OK |
Oklahoma |
OR |
Oregon |
PW |
Palau |
PA |
Pennsylvania |
PR |
Puerto Rico |
RI |
Rhode Island |
SC |
South Carolina |
SD |
South Dakota |
TN |
Tennessee |
TX |
Texas |
UT |
Utah |
VT |
Vermont |
VI |
Virgin Islands |
VA |
Virginia |
WA |
Washington |
WV |
West Virginia |
WI |
Wisconsin |
WY |
Wyoming |
StructureType - Domain
DomainName
|
StructureType |
Description
|
Address Structure Type Codes |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
R1 |
Single Family |
R2 |
Multi Family |
R3 |
Mobile Home |
R4 |
Other Residential |
R5 |
Bungalow |
R6 |
Seasonal Home |
C1 |
Commercial |
CF |
Commercial Farm |
CL |
Lodging |
C9 |
Other Commercial |
P1 |
Government |
P2 |
Healthcare |
P3 |
Church |
P4 |
Educational |
P5 |
Cultural |
P6 |
Police |
P7 |
Fire |
P8 |
Public Gathering |
P9 |
Ambulance House |
P0 |
Cemetery |
I1 |
Industrial |
U1 |
Utility |
ET |
Public Telephone |
EH |
Hydrant |
ED |
Dry Hyrdant |
EP |
Fire Pond |
B1 |
Bridge |
B2 |
Airport |
B3 |
Helipand |
B4 |
Campground |
B9 |
Culvert |
H1 |
Hangar |
A1 |
Accessory Building |
A2 |
Abandoned |
A3 |
Group Mailbox |
A9 |
Access Point |
TB |
Town Boundary Post |
DV |
Development Site |
G1 |
Gated No Building |
G2 |
Gated With Building |
98 |
Other |
99 |
Not Visible |
PS |
PSAP |
AD |
Address Conflated |
A4 |
Demolished |
SurfaceType - Domain
DomainName
|
SurfaceType |
Description
|
Surface is paved or unpaved. |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
Paved |
Paved |
Unpaved |
Unpaved |
ValidationErrorException - Domain
DomainName
|
Validation Error Exception |
Description
|
Indicates if the error had been marked as an exception. |
FieldType
|
Short |
Domain Type
|
CodedValue |
ValidationErrorPhase - Domain
DomainName
|
Validation Error Phase |
Description
|
Indicates error lifecycle phase of an error |
FieldType
|
Long |
Domain Type
|
CodedValue |
Code
|
Name
|
2 |
Review |
4 |
Correction |
6 |
Verification |
ValidationErrorStatus - Domain
DomainName
|
Validation Error Status |
Description
|
Indicates error lifecycle status of an error |
FieldType
|
Long |
Domain Type
|
CodedValue |
Code
|
Name
|
1 |
Reviewed |
2 |
Resolved |
3 |
Mark As Exception |
4 |
Acceptable |
6 |
Unacceptable |
9 |
Exception |
ValidationStatus - Domain
DomainName
|
Validation Status |
Description
|
The current record's validation status. |
FieldType
|
Short |
Domain Type
|
CodedValue |
Code
|
Name
|
0 |
No calculation required, no validation required, no error |
1 |
No calculation required, no validation required, has error(s) |
2 |
No calculation required, validation required, no error |
3 |
No calculation required, validation required, has error(s) |
4 |
Calculation required, no validation required, no error |
5 |
Calculation required, no validation required, has error(s) |
6 |
Calculation required, validation required, no error |
7 |
Calculation required, validation required, has error(s) |
YesNo - Domain
DomainName
|
YesNo |
Description
|
A yes/no indicator |
FieldType
|
String |
Domain Type
|
CodedValue |
ZipCode - Domain
DomainName
|
ZipCode |
Description
|
Valid zip codes |
FieldType
|
String |
Domain Type
|
CodedValue |
Code
|
Name
|
44017 |
44017 |
44022 |
44022 |
44023 |
44023 |
44040 |
44040 |
44067 |
44067 |
44070 |
44070 |
44102 |
44102 |
44103 |
44103 |
44104 |
44104 |
44105 |
44105 |
44106 |
44106 |
44107 |
44107 |
44108 |
44108 |
44109 |
44109 |
44110 |
44110 |
44111 |
44111 |
44112 |
44112 |
44113 |
44113 |
44114 |
44114 |
44115 |
44115 |
44116 |
44116 |
44117 |
44117 |
44118 |
44118 |
44119 |
44119 |
44120 |
44120 |
44121 |
44121 |
44122 |
44122 |
44123 |
44123 |
44124 |
44124 |
44125 |
44125 |
44126 |
44126 |
44127 |
44127 |
44128 |
44128 |
44129 |
44129 |
44130 |
44130 |
44131 |
44131 |
44132 |
44132 |
44133 |
44133 |
44134 |
44134 |
44135 |
44135 |
44136 |
44136 |
44137 |
44137 |
44138 |
44138 |
44139 |
44139 |
44140 |
44140 |
44141 |
44141 |
44142 |
44142 |
44143 |
44143 |
44144 |
44144 |
44145 |
44145 |
44146 |
44146 |
44147 |
44147 |
44149 |
44149 |
44212 |
44212 |
44233 |
44233 |
44415 |
44415 |
Attribute Rules
Description
|
This dataset contains attribute rules that assist in editing and data integrity. |
Site Address - Calculation
Order
|
Rule Name
|
Description
|
Subtype
|
Field
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
1 |
Site Address ID |
Creates a new unique id when a site address point is created. |
|
|
2.7 |
10.9 |
1.11.0 |
2 |
Get Address From Nearest Road |
Calculates an address number and full road name based on nearest road. |
|
|
2.7 |
10.9 |
1.11.0 |
3 |
Full Address |
Calculates the full address for a site address point by concatenating several other field values. |
|
|
2.7 |
10.9 |
1.0.0 |
4 |
Municipality |
Calculates the municipality and corresponding FIPS Code the site address falls within. |
|
|
2.7 |
10.9 |
1.10.0 |
5 |
Postal Address |
Create a new owner/occupant postal address when a new site address is created. |
|
|
2.7 |
10.9 |
1.12.0 |
6 |
Update Validation Status |
Mark site addresses as requiring validation if they have the same id or full address and municipality as the feature. |
|
|
2.7 |
10.9 |
1.12.0 |
6 |
Update Address Point Offset Distance |
Updates the offset distance of the related Address Point when the site address is moved. |
|
|
2.7 |
10.9 |
1.12.0 |
Site Address - Constraint
Rule Name
|
Description
|
Subtype
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
Invalid Geometry |
Site address has a null geometry. |
|
2.1 |
10.6 |
1.0.0 |
restrictEditOutsideBoundary |
Restrict the edits of users to certain areas. |
|
2.7 |
10.9 |
1.12.0 |
Site Address - Validation
Rule Name
|
Description
|
Subtype
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
Duplicate Full Address |
Multiple site addresses with the same full address in the municipality. |
|
2.7 |
10.9 |
1.12.0 |
Duplicate ID |
Multiple site addresses with the same ID. |
|
2.6 |
10.8.1 |
1.11.0 |
Address Does Not Match Road |
Address point is outside the nearest road's valid range, is on the wrong side of the road, or doesn't match the road municipality. |
|
2.3 |
10.7 |
1.5.0 |
Address Point - Calculation
Order
|
Rule Name
|
Description
|
Subtype
|
Field
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
1 |
Address Point ID |
Creates a new unique id when an address point is created. |
|
|
2.7 |
10.9 |
1.11.0 |
2 |
Create Site Address Point |
Create a new site address point when an address point is created along a road. |
|
|
2.7 |
10.9 |
1.12.0 |
2 |
Update Address Point Offset Distance |
Updates the offset distance of the Address Point when it is moved. |
|
|
2.7 |
10.9 |
1.10.0 |
Entrance Point - Calculation
Order
|
Rule Name
|
Description
|
Subtype
|
Field
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
1 |
Entrance ID |
Creates a new unique id when an entrance point is created. |
|
|
2.7 |
10.9 |
1.11.0 |
Address Line - Calculation
Order
|
Rule Name
|
Description
|
Subtype
|
Field
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
1 |
Create Site Address Point |
Create one or more site addresses at each vertex along a line. |
|
|
2.7 |
10.9 |
1.12.0 |
Road Centerline - Calculation
Order
|
Rule Name
|
Description
|
Subtype
|
Field
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
1 |
Centerline ID |
Creates a new unique id when a centerline is created. |
|
|
2.7 |
10.9 |
1.11.0 |
2 |
Split Intersecting Road |
Splits intersecting roads at their intersection and the address ranges will be updated to reflect where the split occured. |
|
|
2.7 |
10.9 |
1.12.0 |
3 |
Copy Alias Names |
Copies the road alias names from original road centerline after a split. |
|
|
2.7 |
10.9 |
1.12.0 |
4 |
Update Site Addresses |
When the road name changes find all site addresses that fall within the address range and update their road name. |
|
|
2.7 |
10.9 |
1.12.0 |
5 |
Left & Right Parity |
Calculates the left and right parity and reversedirection of the road. |
|
|
2.7 |
10.9 |
1.0.0 |
6 |
Left & Right Municipality |
Calculates the left and right left and right municipality and FIPS for a road.. |
|
|
2.7 |
10.9 |
1.12.0 |
7 |
Logical Block Addressing |
Calculates the left to and right to address number using the left from and right from address numbers, the length of the road and an interval or distance between unique addresses. |
|
|
2.7 |
10.9 |
1.12.0 |
8 |
Update Validation Status |
Mark roads or nearby site addresses as requiring validation if a road is deleted or has its road name, address range, municipality or geometry updated. |
|
|
2.7 |
10.9 |
1.12.0 |
Road Centerline - Constraint
Rule Name
|
Description
|
Subtype
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
Invalid Full Road Name |
Full road name is not defined in the Master Road Name table. |
|
2.7 |
10.9 |
1.12.0 |
Invalid Geometry |
Road has a null or multipart geometry. |
|
2.1 |
10.6 |
1.0.0 |
restrictEditOutsideBoundary |
Restrict the edits of users to certain areas. |
|
2.7 |
10.9 |
1.12.0 |
Road Centerline - Validation
Rule Name
|
Description
|
Subtype
|
Min Pro Release
|
Min Enterprise Release
|
Min Arcade Release
|
Duplicate ID |
Multiple roads with the same ID. |
|
2.6 |
10.8.1 |
1.11.0 |
Invalid Road name |
Full road name is not defined in the Master Road Name table. |
|
2.3 |
10.7 |
1.5.0 |
Invalid Address Range |
Road left or right address range is invalid or has parity issues. |
|
2.1 |
10.6 |
1.0.0 |
Address Range Overlap |
Road left or right address range overlaps another road with same name. |
|
2.7 |
10.9 |
1.12.0 |