highways-hidot-hawaii-gov/pavementmessages-p73s-7984

  • barriers
  • pfes
  • row

PAVEMENT_MESSAGES

PAVEMENT_MESSAGES

This dataset is an inventory of Pavement Messages on Hawaii Highways. Information available include: location of pavement messages, condition, color intensity of the messages, if the messages are weathered./worn, if the messages are mispainted. https://highways.hidot.hawaii.gov/dataset/Pavement-Messages/eyzr-nxat

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
BMPbmpbmpNumber
B_LONb_lonb_lonNumber
EMPempempNumber
Shape__Lengthshape_lengthshape_lengthNumber
E_ELEe_elee_eleNumber
B_ELEb_eleb_eleNumber
WEATHEREDweatheredweatheredText
DSCRIPTIONdscriptiondscriptionText
B_LATb_latb_latNumber
END_FRAMEend_frameend_frameNumber
E_LONe_lone_lonNumber
BEG_FRAMEbeg_framebeg_frameNumber
Shape__Areashape_areashape_areaNumber
PFES_IDpfes_idpfes_idTextPFES link identification
LRM_NAMElrm_namelrm_nameTextLinear Reference System Name (always CDS)
TYPEtypetypeTextType of barrier: •Stock Fence •Chainlink Fence •Concrete Cast-In-Place Retaining Wall •Rock Retaining Wall •Slope Protection •Soil Nail •Rock Catchment Fencing •Shotcrete •Gabion •Bin •Precast/MSE •Soldier Pile •Other Cast-In-Place
SURVEYEDsurveyedsurveyedTextCollection Date
SESSION_NMsession_nmsession_nmTextSession Name (usually Island, type of route, direction and route name concatenation)
ROUTErouterouteTextThe route number
ASSET_IDasset_idasset_idTextUnique Asset Identifier generated by Mandli
MISSPAINTmisspaintmisspaintText
ISLANDislandislandTextThe island name
OBJECTIDobjectidobjectidNumberArcGIS object key
E_LATe_late_latNumber
NHSnhsnhsTextWhether route is on the National Highway System
DELIVERYIDdeliveryiddeliveryidTextThe data delivery date as a string
COMMENTScommentscommentsTextRater comment on feature condition
AREAareaareaNumber
GHOSTEDghostedghostedTextCopied from previous year observation or brand new observation
SOURCEsourcesourceTextCollection cycle
DIRECTIONdirectiondirectionTextRoute direction
INTENSITYintensityintensityText
LANE_IDlane_idlane_idTextThe lane that is traveled.
PREFIXprefixprefixTextThe route owner. SR is a state route, CR is a county route.
CONDITIONconditionconditionText
the_geomthe_geomthe_geomMultiPolygon