Description: Clay County Road Centerline Data SchemaElement GroupElement NumberElement NameData Field NameTypePrecisionScaleLength Domain NameDefault ValueLookup TableDescriptionIdentification Elements1.1Road Segment Unique IdentifierROADSEG_IDText36A Globally Unique Identifier (GUID) for the road segment.1.2Route IDROUTE_IDText18A unique identifier for the road centerline based on MnDOT’s route naming system.Linear Reference Elements2.1Route SystemROUTE_SYSText2RouteSystemPrimary Route System designator based on MnDOT's routing system.2.2Route DirectionROUTE_DIRText1RouteDirectionMnDOT indicator of whether route mileage increases or decreases with direction.2.3Local to StateLOC_STATEText10LocalToStateThe relative direction of the road centerline as depicted in local data compared to its depiction in MnDOT data.2.4Primary StatusPRIME_STATText10PrimaryStatusMnDOT's primary/secondary classification of the road centerline.Geocoding Elements3.1Street Name Pre ModifierST_PRE_MODText15A word or phrase that precedes and modifies the Street Name, but is separated from it by a Street Name Pre Type or a Street Name Pre Directional or both3.2Street 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.3.3Street Name Pre TypeST_PRE_TYPText35StreetPreTypeA word or phrase that precedes the Street Name element and identifies a type of thoroughfare in a complete street name.3.4Street 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.3.5Street NameST_NAMEText60Street name that identifies the particular thoroughfare. (With ordinals: st, nd, rd, th.)3.6Street Name Post TypeST_POS_TYPText15StreetPostTypeA word or phrase that follows the Street Name and identifies a type of thoroughfare.3.7Street 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.3.8Street Name Post ModifierST_POS_MODText15A word or phrase that follows and modifies the Street Name, but is separated from it by a Street Name Post Type or a Street Name Post Directional or both.3.9Street Name FullST_CONCATText150Official complete name of the road centerline which is the concatenation of all other street name fields (3.1 to 3.8) with appropriate spacing.911 Elements7.11Legacy Street Name Pre DirectionalLST_PREDIRText2NENAStreetDirectionalThe street name pre directional abbreviated in uppercase. FIELD NOT USED in Clay County.7.12Legacy Street NameLST_NAMEText75The street name in uppercase. (Without ordinals: th, st, rd, nd.)7.13Legacy Street Name TypeLST_TYPEText4Street type abbreviated in uppercase.7.14Legacy Street Name Post DirectionalLST_POSDIRText2NENAStreetDirectionalSuffix direction abbreviated in uppercase.Clay County Elements11.1Full Street Name Abbreviated LST_CONCATText85Abbreviated name of the road centerline which is the concatenation of legacy name fields LST_NAME + LST_TYPE + LST_POSDIR with appropriate spacing.Geocoding Elements3.10Alternate Street Name 1ST_NAME_A1Text150The primary alternate or alias name for the road centerline.3.11Alt 1 Legitimate MSAG ValueA1_MSAG_VText7AltValidMSAGThe side(s) of the road centerline on which the Alternate Street Name 1 is a valid entry inthe relevant Master Street Address Guide (MSAG).3.12Alternate Street Name 2ST_NAME_A2Text150The secondary alternate or alias name for the road centerline.3.13Alt 2 Legitimate MSAG ValueA2_MSAG_VText7AltValidMSAGThe side(s) of the road centerline on which the Alternate Street Name 2 is a valid entry in the relevant Master Street Address Guide (MSAG).3.14Alternate Street Name 3ST_NAME_A3Text150The tertiary alternate or alias name for the road centerline.3.15Alt 3 Legitimate MSAG ValueA3_MSAG_VText7AltValidMSAGThe side(s) of the road centerline on which the Alternate Street Name 3 is a valid entry inthe relevant Master Street Address Guide (MSAG).Clay County Elements11.2Lowest Address NumberADD_LOWLong Integer10The first address number in the range of address numbers on the roadcenterline segment. Used in the MSAG.11.3Highest Address NumberADD_HIGHLong Integer10The last address number in the range of address numbers on the roadcenterline segment. Used in the MSAG.Geocoding Side Feature4.1Left From AddressADD_FR_LLong Integer10The first address number in the range of address numbers on the left side of the roadcenterline. Elements4.2Left To AddressADD_TO_LLong Integer10The last address number in the range of address numbers on the left side of the road centerline. 4.3Right From AddressADD_FR_RLong Integer10The first address number in the range of address numbers on the right side of the road centerline.4.4Right To AddressADD_TO_RLong Integer10The last address number in the range of address numbers on the right side of the road centerline.4.5Left ParityPARITY_LText4ParityThe even or odd property for address numbers on the left side of the road centerline4.6Right ParityPARITY_RText4ParityThe even or odd property for address numbers on the right side of the road centerline4.7Left Zip CodeZIP_LText5The ZIP code for addresses on the left side of the road centerline.4.8Right Zip CodeZIP_RText5The ZIP code for addresses on the right side of the road centerline.4.9Left CTU NameCTU_NAME_LText100CTUNameLUT_CTU_CountyThe name of the city, township or unorganized territory (CTU) in which addresses on the left side of the road centerline are physically located.4.10Right CTU NameCTU_NAME_RText100CTUNameLUT_CTU_CountyThe name of the city, township or unorganized territory (CTU) in which addresses on the right side of the road centerline are physically located.4.11Left CTU CodeCTU_ID_LText8CTUIDTextLUT_CTU_CountyThe official Federal Geographic Names Information Systems unique identifier code for the city, township or unorganized territory (CTU) in which addresses on the left side of the road centerline are physically located.4.12Right CTU CodeCTU_ID_RText8CTUIDTextLUT_CTU_CountyThe official Federal Geographic Names Information Systems unique identifier code for the city, township or unorganized territory (CTU) in which addresses on the right side of the road centerline are physically located.4.13Left Postal Community NamePOSTCOMM_LText40LUT_USPSPreferredCityCity name recognized by the USPS as valid for the ZIP Code of the addresses on the left side of the road centerline.4.14Right Postal Community NamePOSTCOMM_RText40LUT_USPSPreferredCityCity name recognized by the USPS as valid for the ZIP Code of the addresses on the right side of the road centerline.4.15Left County CodeCO_CODE_LText5CountyCode27027LUT_CountyThe combination of the two-character state numeric code and the three-character county code in which the addresses on the left side of the road centerline are physically located. 4.16Right County CodeCO_CODE_RText5CountyCode27027LUT_CountyThe combination of the two-character state numeric code and the three-character county code in which the addresses on the right side of the road centerline are physically located. 4.17Left County NameCO_NAME_LText40CountyNameClayLUT_CountyThe county in which the addresses on the left side of the road centerline are physicallylocated.4.18Right County NameCO_NAME_RText40CountyNameClayLUT_CountyThe county in which the addresses on the right side of the road centerline are physically located.4.19Left State CodeSTATE_LText2StateCodeMNLUT_StateThe two-character code of the state in which the addresses on the left side of the road centerline are physically located.4.20Right State CodeSTATE_RText2StateCodeMNLUT_StateThe two-character code of the state in which the addresses on the right side of the road centerline are physically located. Routing Elements5.1Elevation FromELEV_FROMShort Integer5ElevationToFrom0The vertical position, relative to grade (ground level), of the starting (FROM) node of the road centerline.5.2Elevation ToELEV_TOShort Integer5ElevationToFrom0The vertical position, relative to grade (ground level), of the ending (TO) node of the road centerline. 5.3One WayONEWAYText1OneWayBThe direction of traffic movement in relation to the FROM and TO nodes (i.e. direction of digitization) of the road centerline.5.4Impedance SpeedSPEED_IMPShort Integer5A speed limit parameter in miles per hour that may be used in transportation modeling to force a specific result.5.5Emergency AccessEMERG_ACCText10YesNoUnknownYesWhether the road centerline would be used in a routing model for emergency vehicles. 5.6Routing SpeedROUTESPEEDShort Integer5The posted or estimated speed limit in miles per hour (MPH) for the road segment forpurposes of routing. Cartography Elements6.1Route NumberROUTE_NUMText5The primary Route Number designator (with optional letters) for the road centerline based on MnDOT's routing system. Used mainly for map labelling.6.2Road Cartographic ClassCARTOCLASSText15RoadCartoClassThe road classification for cartographic symbology purposes.911 Elements7.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. 7.2Left Emergency Service NumberESN_LText5ESNA 3 to 5-character numeric code that identifies a single Emergency Service Zone (ESZ) for addresses on the left side of the road centerline. 7.3Right Emergency Service NumberESN_RText5ESNA 3 to 5-character numeric code that identifies a single Emergency Service Zone (ESZ) for addresses on the right side of the road centerline. 7.4Left PSAP CodePSAP_LText5PSAPCodeRRRDCThe 4 to 5-character Public Safety Answering Point (PSAP) identifier code from the ELT/ALI display for the addresses on the left side of the road centerline.7.5Right PSAP CodePSAP_RText5PSAPCodeRRRDCThe 4 to 5-character Public Safety Answering Point (PSAP) identifier code from the ELT/ALI display for the addresses on the right side of the road centerline.7.6Left MSAG Community NameMSAG_C_LText30MSAGCommunityThe Community name associated with the addresses on the left side of the road centerlineas given in the Master Street Address Guide (MSAG) used for 9-1-1 purposes. 7.7Right MSAG Community NameMSAG_C_RText30MSAGCommunityThe Community name associated with the addresses on the right side of the road centerline as given in the Master Street Address Guide (MSAG) used for 9-1-1 purposes. 7.8Left ValidationVALID_LText10YesNoUnknownYesAttribute indicates whether the primary Street name and address range on the left or right side of an RCL segment is valid for civic address validation, inclusion in a NG911 Location Validation Function (LVF), and/or inclusion in a geospatially created MSAG.7.9RightValidationVALID_RText10YesNoUnknownYesAttribute indicates whether the primary Street name and address range on the left or right side of an RCL segment is valid for civic address validation, inclusion in a NG911 Location Validation Function (LVF), and/or inclusion in a geospatially created MSAG.7.10911 Validation ErrorVERROR_911Text10YesNoUnknownNoThis attribute is used as a flag to indicate a known 911 validation error that has yet to beresolved.Data Maintenance8.1Lifecycle StatusSTATUSText20LifecycleStatusRoad ActiveThe lifecycle status of the road.Elements8.2Effective DateEFF_DATEDateDefaultThe earliest date on which the road segment is known to exist.8.3Retired DateRET_DATEDateDefaultThe date on which the road segment was retired from active status.8.4Editing OrganizationEDIT_ORGText40The organization that made the last substantial change to the data record including geospatial edits. Clay County GIS or City of Moorhead GIS.8.5Edit DateEDIT_DATEDateDefaultThe date of the last substantial change to the data record including geospatial edits.City of Moorhead Elements10.1Functional ClassificationFUNCTIONAL_CLASS Text30Functional classification of roads.10.2Functional Class - Moorhead FUNCLS_MHD Text1FunctionalClassMoorhead City of Moorhead maintained functional classification for roads within the City of Moorhead. Business Elements9.1Functional Class - FederalFUNCLS_FEDText1FunctionalClassFederalFederal functional classification defined by the United States Federal Highway Administration.9.2Functional Class - MetroFUNCLS_METText3FunctionalClassMetroMetropolitan Council maintained functional classification for roads within the Twin CitiesMetropolitan Planning Organization (MPO) Area. 9.3Surface TypeSURF_TYPEText32SurfaceTypeType of road surface.9.4Number of LanesNUM_LANESShort Integer5Number of through lanes along segment.9.5CommentsCOMMENTSText254A free form field for miscellaneous information that does not fit or is not appropriate in the other attribute fields.MN-NG911 Elements1.38Left CountryCOUNTRY_LText2USMN NG-911 mandatory field from NENA standard.1.39Right CountryCOUNTRY_RText2USMN NG-911 mandatory field from NENA standard.City of Moorhead Elements10.3Snow Route SNOW_ROUTE Text30SnowRoute Is the roadway a snow emergency route.10.4Garbage Route Day GARBAGE_ROUTE Text20DayOfWeekCity of Moorhead Garbage Route 10.5Recycling Schedule RECYCLING_SCHEDULE Text20RecycleSchedule City of Moorhead Recycling Schedule10.6Parking Restriction PARKING_RESTRICT Text36ParkingRestrictionCity of Moorhead parking restrictions.10.7State Aid Route STATE_AID_ROUTE Text50State Aid Funding 10.8State Aid Route Number STATE_AID_NUMBER Short Integer5State Aid Route Number10.9TO FROM MinutesTF_MINUTES Double388Minutes required to traverse line segment in TO FROM direction10.10FROM TO MinutesFT_MINUTES Double388Minutes required to traverse line segment in FROM TO direction10.11Alias ID ALIAS_ID Long Integer10Alias Lookup ID10.12OwnershipOwnershipText20OwnershipRoadway Owenship Type 10.13Label ClassLABEL_CLASS Text50Used for symbolization10.14RegionREGION Short Integer5Region of Clay County. A numeric value form 0 to 9Clay County Elements11.4Load RestrictionLOAD_RESTRICTIONText18Roadway weight limit listed in tons.11.5Recorded Maintenance LevelRECORDED_MText30RecordedMaintFrom recorded township road map. 11.6Owner LeftOWNER_LText30MaintJurisdictionRepresents ownership of each side of the road. Recorded Township maps are one source used.11.7Owner RightOWNER_RText30MaintJurisdictionRepresents ownership of each side of the road. Recorded Township maps are one source used.11.8Highway Control SectionHWY_CONTROL_SECTIONText18Used to tie Pavement Management data to road segments.11.9Highway SegmentHWY_SEGMENTText18Used to tie Pavement Management data to road segments.11.10ICON IDICONIDDouble388Used to tie ICON Pavement Management data to road segments.11.11Maintenance FundingMAINT_FUNDINGText30Indicates the primary funding source type for the road.11.12Maintenance OwnerMAINT_OWNERText30Which jurisdiction reponsible for the road's maintenance.11.13Maintained ByMAINT_BYText30Which organization conducts roadways maintenance11.14Maintenance DistrictMAINT_DISTText18Highway Department District that maintains the road.11.15Maintenance District AlternateMAINT_DIST_ALTText18Alternate Highway Department that could maintain the road.11.16Maintenance TypeMAINT_TYPEText18Type of maintenance roadway receives. Full, Hourly, None.11.17Maintenance WinterMAINT_WINTERText18Is the roadway maintainted in the winter? Yes or No.11.18Maintenance in Rural SubdivisionMAINT_RURAL_SUBText18Indicates if the roadway is in a Rural Subdivision. Yes or No.11.19Maintenance MileageMAINT_MILAGEDouble388Mileage of road segment for Contracted Maintenance with Township rounded to the quarter mile.