Description: Clay County Address Point Data SchemaElement GroupElement NumberElement NameData Field NameTypePrecisionScaleLengthDomain NameDefault ValueLookup TableDescriptionIdentification Elements1.1Address Unique IdentifierADD_IDText36The unique identifier assigned to an address.1.2Local Address Unique IdentifierADD_ID_LOCText50Each address authority may have an internal Unique_ID and formatting convention which can be included within this field. Address Elements2.1Address Number PrefixANUMBERPREText15The portion of the complete address number which precedes the address number itself. 2.2Address NumberANUMBERLog Integer10The numeric identifier for a land parcel, house, building or other location along a thoroughfare or within a community.2.3Address Number SuffixANUMBERSUFText15The portion of the complete address number which follows the address number itself.2.4Street Name Pre ModifierST_PRE_MODText15A word or phrase that precedes and modifies the Street Name.2.5Street Name Pre DirectionalST_PRE_DIRText9StreetDirectionalA word preceding the Street Name that indicates the direction or position of the thoroughfare relative to an arbitrary starting point or line, or the sector where it is located.2.6Street Name Pre TypeST_PRE_TYPText35StreetPreTypeA word or phrase that precedes the Street Name and identifies a type of thoroughfare in a complete street name.2.7Street Name Pre SeparatorST_PRE_SEPText20StreetPreSeparatorIf a Complete Street Name includes a prepositional phrase between a Street Name Pre Type and a Street Name, the prepositional phrase is treated as a separator.2.8Street NameST_NAMEText60Street name that identifies the particular thoroughfare. (With ordinals: st, nd, rd, th.)2.9Street Name Post TypeST_POS_TYPText15StreetPostTypeA word or phrase that follows the street name and identifies a type of thoroughfare.2.10Street Name Post DirectionalST_POS_DIRText9StreetDirectionalA word following the Street Name that indicates the direction or position of the thoroughfare relative to an arbitrary starting point or line, or the sector where it is located.2.11Street Name Post ModifierST_POS_MODText15A word or phrase that follows and modifies the Street Name.2.12Subaddress Type 1SUB_TYPE1Text12SubaddressTypeThe type of subaddress to which the associated Subaddress Identifier applies. Such as "Apartment".2.13Subaddress Identifier 1SUB_ID1Text30The letters, numbers, words or combination thereof used to distinguish different subaddresses of the same type when several occur in the same feature.2.14Subaddress Type 2SUB_TYPE2Text12SubaddressTypeThe type of subaddress to which the associated Subaddress Identifier applies. Such as "Suite".2.15Subaddress Identifier 2SUB_ID2Text30The letters, numbers, words or combination thereof used to distinguish different subaddresses of the same type when several occur in the same feature.911 Elements6.6Legacy Street Name Pre DirectionalLST_PREDIRText2NENAStreetDirectionalThe street name pre directional abbreviated in uppercase. FIELD NOT USED in Clay County.6.7Legacy Street NameLST_NAMEText75The street name in uppercase. (Without ordinals: th, st, rd, nd.)6.8Legacy Street Name TypeLST_TYPEText4Street type abbreviated in uppercase.6.9Legacy Street Name Post DirectionalLST_POSDIRText2NENAStreetDirectionalSuffix direction abbreviated in uppercase.Clay County Elements9.1Full Address AbbreviatedLST_ADDRESSText80ANUMBER + LST_NAME + LST_TYPE + LST_POSDIR City of Moorhead Elements8.1Full Address with UnitFULL_ADDRESS_UNITText85ANUMBER + ST_NAME + LST_TYPE + LST_POSDIR + SUB_ID1Address Elements2.16ZIP CodeZIPText5The 5-digit ZIP code for the address.2.17ZIP Plus 4ZIP4Text4A 4-digit extension of the5-digit ZIP Code.Area Elements3.1CTU NameCTU_NAMEText100CTUNameLUT_CTU_CountyThe name of the city, township, or unorganized territory (CTU) in which the address point is physically located. 3.2CTU CodeCTU_ID_TXTText8CTUIDTextLUT_CTU_CountyThe official Federal Geographic Names Information Systems unique identifier code for the city, township or unorganized territory in which the address point is physically located.3.3Postal Community NamePOSTCOMMText40LUT_USPSPreferredCityCity name for the ZIP Code of the address point. 3.4County CodeCO_CODEText5CountyCode27027LUT_CountyThe combination of the two-character state numeric code and the three-character county code in which the address point is physically located. 3.5County NameCO_NAMEText40CountyNameClayLUT_CountyThe name of the county in which the address point is physically located.3.6State CodeSTATE_CODEText2StateCodeMNLUT_StateThe two-character code of the state in which the address point is physically located. Functional Elements4.1Location DescriptionLOC_DESCText254A text description providing more detail on how to identify or find the addressed feature.4.2Complete Landmark NameLANDMARKText150One or more landmark names which identify a relatively permanent feature of the landscape that has recognizable identity within a particular cultural context.4.3ResidenceRESIDENCEText10YesNoUnknownIndicates if address has a residence or living quarters.4.4Mailable AddressMAILABLEText10YesNoUnknownIdentifies whether an address should have USPS mail sent to it. 4.6Placement LocationPLACE_LOCText2PlacementLocationA code that indicates the location used for placing the point. 4.7Centerline GeocodableCEN_GEOText10YesNoUnknownYesUsed to identify official addresses that have been validated by the addressing authority and confirmed to not be included in the corresponding road centerline data. 4.8Unique Without SubaddressesUNI_WO_SUBText10YesNoUnknownThis data element is used to flag one primary address point.GeoLocation Elements5.1LongitudeLONGITUDEDouble388The longitude of the address point, in decimal degrees, WGS84 datum.5.2LatitudeLATITUDEDouble388The latitude of the address point, in decimal degrees, WGS84 datum.5.3US National Grid CodeUSNG_CODEText15The code for the US National Grid cell within which the address point exists.911 Elements6.1911 GIS Point-of-ContactGIS911POCText75GIS911POCClayThe entity responsible for submitting Geographic Information System (GIS) data to the State of Minnesota to be used for NG9-1-1 service for a specified area. 6.2Emergency Service NumberESNText5ESNA 3 to 5-character numeric code that identifies a single ESZ. 6.3PSAP CodePSAP_CODEText5PSAPCodeRRRDCThe 4 to 5-character Public Safety Answering Point identifier code from the ELT/ALI display for the given address point feature.6.4MSAG Community NameMSAG_CText30MSAGCommunityThe Community name associated with an address as given in the Master Street Address Guide (MSAG) used for 9-1-1 purposes. 6.5911 Validation ErrorVERROR_911Text10YesNoUnknownNoThis attribute is used as a flag to indicate a known 911 validation error that has yet to be resolved.Management Elements7.1Lifecycle StatusSTATUSText10LifecycleStatusAddress ActiveThe lifecycle status of the address7.2Effective DateEFF_DATEDateDefaultThe earliest date on which the address is known to exist.7.3Retired DateRET_DATEDateDefaultThe date on which the address was retired from active status.7.4Source of DataSOURCEText75Source from whom the data provider obtained the address, or with whom the data provider validated the address.7.5Address AuthorityAAUTHORITYText40The name of the authority (e.g., municipality name, county name) that created or has jurisdiction over the creation, alteration, or retirement of an address.7.6Editing OrganizationEDIT_ORGText40The organization that made the last substantial change to the data record including geospatial edits. Clay County GIS or City of Moorhead GIS.7.7Edit DateEDIT_DATEDateDefaultThis is intended to indicate the date of the initial entry or last substantial change to the data record including point location. 7.8CommentsCOMMENTSText254A field for free form comments as deemed useful by the address authority.MN-NG911 Elements1.33Country "US"COUNTRYText2USMN NG-911 mandatory field from NENA standard.City of Moorhead Elements8.2Census Residential Flag CENSUS_REG_FLAGText24Used to flag residential, commercial, and group addresses for Census LUCA. 8.3BSA ExportBSAText3BSADetermines whether the address is used in the BS&A Permitting and Rental – Fire Inspections program. Yes or No. 8.4RegionREGION Short Integer5Is a numeric value form 0 to 9Functional Elements4.5Parcel ID StateSTATE_PINText28The county code (“27027-") must be added to the beginning of the PIN string.Clay County Elements9.2Parcel Identification NumberPARCEL_IDText12xx.xxx.xxxx9.3Parcel ID TextPINText10xxxxxxxxx Text9.4Parcel ID NumberPIDDouble100xxxxxxxxx Numeric9.5Section NumberSECTIONDouble100Two digit number9.6Township NumberTOWNSHIPDouble100Three digit number9.7Range NumberRANGEDouble100Two digit number9.8Type of useFEATURE_TYPEText20FEATURE_TYPEPrimary use of the feature at the addess point.9.9Address Number SignANUMBER_SIGNText16Year and Month of when the blue address sign was ordered.9.10Election PrecinctPRECINCTLong Integer100Number of the election district where the address point is located.9.11Fire District NameFIRE_DISTText30FIRE_DISTRICTSName of fire district that responds to incidents in the ESN where the address point is located.