Layer Metadata¶
This page contains data types of all the map layers found within PMS available in WFS and WMS.
All Layers¶
AADT: Surveys¶
GMLID  | 
Shape  | 
AADT Survey ID  | 
Max AADT Band Id  | 
Description  | 
Label  | 
|---|---|---|---|---|---|
Text  | 
Geometry  | 
Long  | 
Long  | 
Long  | 
Text  | 
AADT: Survey Report (LatestAADT)¶
GMLID  | 
Shape  | 
AADT Survey Summary ID  | 
AADTSurveyEdgeId  | 
AADTSurveyId  | 
LocalAuthorityId  | 
EdgeId  | 
MeasureFrom  | 
MeasureTo  | 
Length  | 
Label  | 
AADTBandId  | 
|---|---|---|---|---|---|---|---|---|---|---|---|
Text  | 
Geometry  | 
Long  | 
Long  | 
Long  | 
Long  | 
Long  | 
Long  | 
Double  | 
Double  | 
Text  | 
Long  | 
AADT: SurveyEdges¶
GMLID  | 
Shape  | 
AADT Survey ID  | 
Max AADT Band Id  | 
Description  | 
Label  | 
|---|---|---|---|---|---|
Text  | 
Geometry  | 
Long  | 
Long  | 
Long  | 
Text  | 
Accidents¶
GMLID  | 
Shape  | 
Accident Id  | 
Accident Number  | 
Year  | 
AccidentTime  | 
Speed Limit  | 
Accident Type  | 
Collision Type  | 
|---|---|---|---|---|---|---|---|---|
Text  | 
Geometry  | 
Long  | 
Long  | 
Long  | 
Long  | 
Long  | 
Text  | 
Text  | 
ATI Survey Imports¶
SurveyImportId  | 
CaptureMethod  | 
UsageClass  | 
ToBeImported  | 
ImportDate  | 
integer  | 
string  | 
string  | 
boolean  | 
TimeInstantType  | 
Bridge Intersections¶
GMLID  | 
Shape  | 
Intersection Type Id  | 
intersection Type  | 
|---|---|---|---|
Text  | 
Geometry  | 
Long  | 
Long  | 
Bridges¶
GMLID  | 
Shape  | 
Structure Id  | 
Name  | 
Number Calculated  | 
Number Plate  | 
MI Latest Overall Rating  | 
Years Since MI Survey  | 
EI Latest Overall Rating  | 
MinSpan  | 
MaxSpan  | 
TotalSpan  | 
StuctureTypeName  | 
Structure Type Id  | 
Weight Sign Present  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Text  | 
Geometry  | 
Long  | 
Long  | 
Text  | 
Text  | 
Long  | 
Long  | 
Long  | 
Long  | 
Long  | 
Long  | 
Text  | 
Long  | 
Text  | 
Combined ATI Segments & Features¶
ATID  | 
Offset  | 
Name  | 
CalculatedLength  | 
MeasuredLength  | 
AvgWidth  | 
UsageClassificationId  | 
UsageClassification  | 
IsOnRoadway  | 
CalculatedMainClassCode  | 
RoadNumber  | 
CalculatedClassCode  | 
RouteNumber  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
double  | 
string  | 
double  | 
double  | 
double  | 
double  | 
string  | 
boolean  | 
string  | 
integer  | 
string  | 
string  | 
Combined ATI Segments and ATI Features¶
source  | 
LastUpdatedDate  | 
LastUpdatedBy  | 
MunicipalDistrictId  | 
MunicipalDistrict  | 
LicensingAreaId  | 
LicensingAreaName  | 
EngineersAreaId  | 
EngineersAreaName  | 
|---|---|---|---|---|---|---|---|---|
string  | 
TimeInstantType  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
Combined Edges¶
NodeIdFrom  | 
NodeIdTo  | 
MissingNodeIdFrom  | 
MissingNodeIdTo  | 
MissingEdgeClassId  | 
MissingEdgeClass  | 
Description  | 
InCharge  | 
IsResolved  | 
IsProcessed  | 
IsMarkedForDeletionFromEdges  | 
StyleOptionsId  | 
source  | 
LastUpdatedBy  | 
CreateDate  | 
LastUpdateDate  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
integer  | 
integer  | 
string  | 
string  | 
boolean  | 
boolean  | 
boolean  | 
boolean  | 
integer  | 
string  | 
string  | 
TimeInstantType  | 
TimeInstantType  | 
Combined Nodes¶
IntersectionCount  | 
NodeType  | 
source  | 
StyleOptionsId  | 
|---|---|---|---|
integer  | 
string  | 
string  | 
integer  | 
Feature Edges Union¶
FeatureTypeId  | 
Name  | 
OsiGuid  | 
Description  | 
SysStartTime  | 
SysEndTime  | 
CalculatedUserDisplayName  | 
CalculatedLength2157  | 
|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
double  | 
Feature Polygons¶
FeatureTypeId  | 
Name  | 
OsiGuid  | 
Description  | 
SysStartTime  | 
SysEndTime  | 
CalculatedUserDisplayName  | 
|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
Footway Conditions Ratings¶
SURVEYID  | 
RATING  | 
SURFACEMATERIALID  | 
HIERARCHYCATEGORYID  | 
DATE  | 
DATE_STRING  | 
Length  | 
UserName  | 
TimestampUtc  | 
|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
integer  | 
TimeInstantType  | 
string  | 
double  | 
string  | 
TimeInstantType  | 
Footways Hazards¶
HazardId  | 
Name  | 
Trip_Type  | 
Severity  | 
Date_Modified  | 
HAZARDTYPEID  | 
ShortName  | 
ClosingDate  | 
LastUpdatedBy  | 
LastUpdatedByName  | 
IsClosed  | 
|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
TimeInstantType  | 
integer  | 
string  | 
TimeInstantType  | 
string  | 
string  | 
integer  | 
MR Hazards¶
HazardId  | 
Hazard_Ref  | 
Year  | 
ROAD_ID  | 
EASTING  | 
NORTHING  | 
CATEGORY_ID  | 
Hazard_Category  | 
TYPE_ID  | 
Hazard_Type  | 
Priority  | 
STATUS_ID  | 
PRIORITY_ID  | 
DATE  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
Surface Survey¶
Latest Surfece Inventory Survey
PSCISummaryId  | 
PSCISurveyId  | 
Rating  | 
CalculatedRating  | 
IsConcrete  | 
ValidFrom  | 
ValidTo  | 
YEAR  | 
SurveyDate  | 
SegmentId  | 
SegmentCode  | 
CalculatedClassCode  | 
IncludeInSchedule  | 
MunicipalDistrictId  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
integer  | 
boolean  | 
TimeInstantType  | 
TimeInstantType  | 
integer  | 
TimeInstantType  | 
integer  | 
string  | 
string  | 
boolean  | 
integer  | 
MapRoad Road Schedule 2016¶
Geometry  | 
RoadScheduleId  | 
RoadId  | 
SegmentID  | 
|---|---|---|---|
MultiCurvePropertyType  | 
integer  | 
integer  | 
string  | 
Mechanical Tests: FWD¶
SurveyDate  | 
MechanicalSurveyFWDId  | 
Direction  | 
D1Average  | 
SCIAverage  | 
D7Average  | 
D1Design  | 
RehabType  | 
RehabThickness  | 
ResidualLife  | 
EdgeId  | 
ROADCLASS  | 
|---|---|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
double  | 
double  | 
integer  | 
string  | 
Mechanical Tests: FWD Points¶
SurveyDate  | 
MechanicalSurveyFWDId  | 
Direction  | 
D1Average  | 
SCIAverage  | 
D7Average  | 
D1Design  | 
RehabType  | 
RehabThickness  | 
ResidualLife  | 
EdgeId  | 
ROADCLASS  | 
|---|---|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
double  | 
double  | 
integer  | 
string  | 
Mechanical Tests: GPR¶
SurveyDate  | 
MechanicalSurveyId  | 
Direction  | 
MechanicalSurveyGPRId  | 
BituminousAveTh  | 
GranularAveTh  | 
ConcreteAveTh  | 
EdgeId  | 
VAL  | 
ROADCLASS  | 
|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
Mechanical Tests: GPR Points¶
SurveyDate  | 
MechanicalSurveyGPRPointId  | 
Direction  | 
MechanicalSurveyTraceId  | 
BituminousTh  | 
GranularTh  | 
ConcreteTh  | 
MechanicalSurveyProjectId  | 
SampleUnit  | 
ROADCLASS  | 
EdgeId  | 
Measure  | 
|---|---|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
integer  | 
double  | 
Mechanical Tests: IRI¶
SurveyDate  | 
MechanicalSurveyIRIId  | 
MechanicalSurveyProjectId  | 
MechanicalSurveyTraceId  | 
IRILeft  | 
IRIRight  | 
IRIAverage  | 
SampleUnit  | 
ROADCLASS  | 
EdgeId  | 
Measure  | 
|---|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
integer  | 
integer  | 
double  | 
double  | 
double  | 
integer  | 
string  | 
integer  | 
double  | 
Mechanical Tests: LPV¶
SurveyDate  | 
MechanicalSurveyLPVId  | 
MechanicalSurveyProjectId  | 
MechanicalSurveyTraceId  | 
LPVLeft  | 
LPVRight  | 
LPVAverage  | 
SampleUnit  | 
EdgeId  | 
Measure  | 
ROADCLASS  | 
|---|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
integer  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
double  | 
string  | 
Mechanical Tests: RUT¶
SurveyDate  | 
MechanicalSurveyRutId  | 
MechanicalSurveyProjectId  | 
MechanicalSurveyTraceId  | 
RutLeft  | 
RutRight  | 
RutAverage  | 
SampleUnit  | 
ROADCLASS  | 
EdgeId  | 
Measure  | 
|---|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
integer  | 
integer  | 
double  | 
double  | 
double  | 
integer  | 
string  | 
integer  | 
double  | 
Mechanical Tests: SCRIM¶
SurveyDate  | 
MechanicalSurveyScrimId  | 
MechanicalSurveyProjectId  | 
MechanicalSurveyTraceId  | 
SFC  | 
CSC  | 
ROADCLASS  | 
SampleUnit  | 
EdgeId  | 
Measure  | 
|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
integer  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
double  | 
Mechanical Tests: Survey Images¶
MechanicalSurveyTraceId  | 
Direction  | 
SurveyDate  | 
MechanicalSurveyId  | 
FileName  | 
MechanicalSurveyProjectId  | 
SampleUnit  | 
EdgeId  | 
Measure  | 
CalculatedClassCode  | 
|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
integer  | 
string  | 
integer  | 
integer  | 
integer  | 
double  | 
string  | 
Mechanical Tests: TEXTURE¶
SurveyDate  | 
MechanicalSurveyTextureId  | 
MechanicalSurveyProjectId  | 
MechanicalSurveyTraceId  | 
TextureLeft  | 
TextureRight  | 
TextureAverage  | 
SampleUnit  | 
ROADCLASS  | 
EdgeId  | 
Measure  | 
|---|---|---|---|---|---|---|---|---|---|---|
TimeInstantType  | 
integer  | 
integer  | 
integer  | 
double  | 
double  | 
double  | 
integer  | 
string  | 
integer  | 
double  | 
Missing Roads¶
MissingEdgeId  | 
PmsCode  | 
Description  | 
MissingEdgeClassId  | 
IsProcessed  | 
ProcessedEdgeId  | 
EdgeClassId  | 
EdgeClass  | 
MissingEdgeClass  | 
OldEdgeId  | 
countNewEdges  | 
minNewEdgeId  | 
ReviewerNote  | 
LastUpdatedBy  | 
LastUpdatedDate  | 
DateCreated  | 
NodeIdFrom  | 
NodeIdTo  | 
Length2157  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
integer  | 
boolean  | 
integer  | 
integer  | 
string  | 
string  | 
integer  | 
integer  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
double  | 
Municipal District Boundaries¶
LocalAuthorityId  | 
Name  | 
MunicipalDistrictCode  | 
BoundaryTypeId  | 
BoundaryType  | 
|---|---|---|---|---|
integer  | 
string  | 
string  | 
integer  | 
string  | 
OSM (All layers)¶
OsmEdgeID  | 
integer  | 
|---|---|
highway  | 
string  | 
lanes  | 
string  | 
name  | 
string  | 
surface  | 
string  | 
osm_id  | 
double  | 
version  | 
double  | 
tags  | 
string  | 
osm_type  | 
string  | 
HighwayId  | 
integer  | 
HighwayAttribute  | 
string  | 
ToBeImported  | 
boolean  | 
Osi Network Edges¶
Prime2 April 2021 Routable Road Network
EdgeId  | 
MunicipalDistrictId  | 
OsiGuid  | 
PmsGuid  | 
Geom2157  | 
NodeIdFrom  | 
NodeIdTo  | 
newnodeidto  | 
newnodeidfrom  | 
EdgeTypeId  | 
EdgeType  | 
EdgeClassId  | 
EdgeClass  | 
SplitEdgeId  | 
NationalRoadName  | 
StreetName  | 
ScenicName  | 
StreetNameGaelic  | 
Length2157  | 
IsArchived  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
integer  | 
integer  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
double  | 
boolean  | 
Prime2 Bridges¶
Name  | 
FormDescription  | 
FunctionDescription  | 
StructureId  | 
|---|---|---|---|
string  | 
string  | 
string  | 
integer  | 
Prime2 Lower Class Polygons¶
GUID  | 
FormId  | 
FormValue  | 
FuncId  | 
FuncValue  | 
|---|---|---|---|---|
string  | 
integer  | 
string  | 
integer  | 
integer  | 
Network & User Entered Missing Edges¶
Prime2 Road Network & User Entered Missing Edges
EdgeId  | 
Length2157  | 
EdgeTypeId  | 
TypeName  | 
EdgeClassId  | 
ClassName  | 
NationalRoadName  | 
OsiGuid  | 
PmsGuid  | 
NodeIdFrom  | 
NodeIdTo  | 
MunicipalDistrictId  | 
InCharge  | 
SplitEdgeId  | 
VersionId  | 
StreetName  | 
ScenicName  | 
StreetNameGaelic  | 
StyleOptionsId  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
double  | 
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
Prime2 Network Nodes¶
NodeId  | 
IntersectionCount  | 
Description  | 
StyleOption1Id  | 
StyleOption2Id  | 
Name  | 
OsiGuid  | 
PmsGuid  | 
integer  | 
integer  | 
string  | 
integer  | 
integer  | 
string  | 
string  | 
string  | 
Prime2 Road Network Nodes V1¶
NodeId  | 
OsiGuid  | 
PmsGuid  | 
IntersectionCount  | 
NodeTypeId  | 
NodeType  | 
VersionId  | 
|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
integer  | 
Prime2 Road Network Nodes V90¶
NodeId  | 
OsiGuid  | 
PmsGuid  | 
IntersectionCount  | 
NodeTypeId  | 
NodeType  | 
VersionId  | 
|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
integer  | 
Prime2 Road Network V1¶
EdgeId  | 
Length2157  | 
EdgeTypeId  | 
TypeName  | 
EdgeClassId  | 
ClassName  | 
NationalRoadName  | 
OsiGuid  | 
PmsGuid  | 
NodeIdFrom  | 
NodeIdTo  | 
StreetName  | 
ScenicName  | 
StreetNameGaelic  | 
MunicipalDistrictId  | 
InCharge  | 
MissingEdgeClassId  | 
VersionId  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
double  | 
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
integer  | 
integer  | 
Prime2 Road Network V90¶
EdgeId  | 
Length2157  | 
EdgeTypeId  | 
TypeName  | 
EdgeClassId  | 
ClassName  | 
NationalRoadName  | 
OsiGuid  | 
PmsGuid  | 
NodeIdFrom  | 
NodeIdTo  | 
StreetName  | 
ScenicName  | 
StreetNameGaelic  | 
MunicipalDistrictId  | 
InCharge  | 
MissingEdgeClassId  | 
VersionId  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
double  | 
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
integer  | 
integer  | 
Osi Network Nodes¶
Prime2 Road Network Nodes
NodeId  | 
OsiGuid  | 
PmsGuid  | 
NodeTypeId  | 
NodeType  | 
NodeType  | 
|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
integer  | 
string  | 
integer  | 
Projects Start & End Points¶
ProjectStartEndPointsId  | 
ProjectId  | 
ProjectTypeId  | 
ProjectType  | 
position  | 
Year  | 
X  | 
Y  | 
Chainage  | 
|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
string  | 
string  | 
integer  | 
double  | 
double  | 
double  | 
Projects¶
ProjectId  | 
LocalAuthorityId  | 
ProjectName  | 
ProjectTypeId  | 
ProjectType  | 
YearOfWorks  | 
TreatmentId  | 
ProjectPhaseId  | 
Phase  | 
InterventionTypeId  | 
LACode  | 
IsUrban  | 
SysStartTime  | 
IsLocked  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
integer  | 
integer  | 
string  | 
integer  | 
string  | 
boolean  | 
TimeInstantType  | 
boolean  | 
Project Works Sections¶
ProjectId  | 
WorksSectionId  | 
ProjectName  | 
ProjectTypeId  | 
ProjectType  | 
InterventionTypeId  | 
OsiGuid  | 
PmsGuid  | 
InterventionType  | 
SectionLength  | 
TotalLanes  | 
YearOfWorks  | 
LastUpdate  | 
ShortName  | 
PmsCode  | 
integer  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
double  | 
double  | 
intger  | 
TimeInstantType  | 
string  | 
integer  | 
PSCI Latest VC Ratings¶
PSCISummaryId  | 
PSCISurveyId  | 
Rating  | 
CalculatedRating  | 
IsConcrete  | 
ValidFrom  | 
ValidTo  | 
YEAR  | 
SurveyDate  | 
SegmentId  | 
SegmentCode  | 
CalculatedClassCode  | 
IncludeInSchedule  | 
MunicipalDistrictId  | 
MunicipalDistrictName  | 
EngineersAreaId  | 
EngineersAreaName  | 
Length  | 
SurveyorName  | 
UserName  | 
MaxWidth  | 
MinWidth  | 
AvgWidth  | 
RoadName  | 
RouteNumber  | 
RoadCategory  | 
SurveyDiffDaysCompliance  | 
SurveyDiffDaysStatus  | 
SurveyComplianceId  | 
SurveyCompliance  | 
SurveyStatusId  | 
SurveyStatus  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
integer  | 
boolean  | 
TimeInstantType  | 
TimeInstantType  | 
integer  | 
TimeInstantType  | 
integer  | 
string  | 
string  | 
boolean  | 
integer  | 
string  | 
integer  | 
string  | 
double  | 
string  | 
string  | 
double  | 
double  | 
double  | 
string  | 
string  | 
string  | 
integer  | 
integer  | 
integer  | 
string  | 
integer  | 
string  | 
Visual Condition Rating (Visual CR)¶
PSCI Visual Condition Ratings
PSCISummaryId  | 
MunicipalDistrictId  | 
MunicipalDistrictName  | 
Rating  | 
LocalAuthorityId  | 
LocalAuthority  | 
LocalAuthorityCode  | 
Length  | 
TimestampUtc  | 
RouteNumber  | 
|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
string  | 
integer  | 
integer  | 
string  | 
string  | 
double  | 
TimeInstantType  | 
string  | 
Public Private Split Edges¶
PublicPrivateSplitEdgeId  | 
PublicPrivateSplitId  | 
Description  | 
IsReviewed  | 
IsPublic  | 
PmsCode  | 
IsProcessed  | 
CalculatedUserDisplayName  | 
LastUpdatedDate  | 
DateCreated  | 
OsiGuid  | 
MarkedToDelete  | 
PublicLength2157  | 
PrivateLength2157  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
string  | 
boolean  | 
boolean  | 
string  | 
boolean  | 
string  | 
string  | 
string  | 
string  | 
boolean  | 
double  | 
double  | 
Mechanical Data Summary Export¶
FID  | 
SegmentId  | 
SegmentCode  | 
RoadClass  | 
ChunkStart  | 
ChunkEnd  | 
X  | 
Y  | 
Long  | 
Lat  | 
PSCIRating  | 
PSCIRatingTimestampUtc  | 
MaterialId  | 
MaterialTimestampUtc  | 
CSC  | 
TextureLeft  | 
IRILeft  | 
RutLeft  | 
LPVLeft  | 
D1  | 
D7  | 
SCI  | 
BituminousTh  | 
GranularTh  | 
ConcreteTh  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
long  | 
integer  | 
string  | 
string  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
integer  | 
TimeInstantType  | 
integer  | 
TimeInstantType  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
Pavement Projects Export¶
ProjectId  | 
LocalAuthorityId  | 
ProjectName  | 
ProjectTypeId  | 
ProjectType  | 
YearOfWorks  | 
TreatmentId  | 
ProjectPhaseId  | 
Phase  | 
InterventionTypeId  | 
IsUrban  | 
SysStartTime  | 
IsLocked  | 
Name  | 
ProjectTypeName  | 
ProjectTypeIsPaving  | 
ProjectPhaseName  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
integer  | 
integer  | 
string  | 
integer  | 
boolean  | 
TimeInstantType  | 
boolean  | 
string  | 
string  | 
boolean  | 
string  | 
Report Finance Export¶
ProjectId  | 
UniqueRef  | 
FmsCode  | 
FundingCategory  | 
FundingCategory  | 
FundingAmount  | 
EstimatedCost  | 
EstimatedUnitCost  | 
EstimatedCostPercentage  | 
ActualCost  | 
ActualUnitCost  | 
ActualCostPercentage  | 
CurrentCost  | 
CurrentUnitCost  | 
CurrentCostPercentage  | 
RoadsProgrammeName  | 
LAProgrammeName  | 
FundingCategoryTypeId  | 
FundingCategoryTypeName  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
string  | 
integer  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
string  | 
string  | 
integer  | 
string  | 
Report Material Costs Export¶
ProjectId  | 
UniqueRef  | 
WorksSectionId  | 
Section  | 
Lane  | 
TotalLanes  | 
LaneReference  | 
ConstructionMethod  | 
SectionWidth  | 
Intervention  | 
PavementLayerName  | 
Material  | 
Designation  | 
Thickness  | 
ChipSize  | 
WorksBy  | 
ContractorName  | 
Length  | 
Width  | 
Area  | 
Volume  | 
UnitCostM2  | 
UnitCostM3  | 
Cost  | 
IsValidSection  | 
MeasureFrom  | 
MeasureTo  | 
PavementLayerId  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
string  | 
string  | 
integer  | 
string  | 
string  | 
double  | 
string  | 
string  | 
string  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
double  | 
boolean  | 
double  | 
double  | 
integer  | 
Report Other Expenditure Export¶
NonPavementExpenseId  | 
Code  | 
Year  | 
FundingCode  | 
RoadsProgrammeName  | 
LAProgrammeName  | 
ExpenditureCategory  | 
Description  | 
Amount  | 
PmsCode  | 
|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
string  | 
double  | 
string  | 
Road Schedule Junctions¶
NodeId  | 
IntersectionCount  | 
Description  | 
Name  | 
|---|---|---|---|
integer  | 
integer  | 
string  | 
string  | 
Roads Programme LAS¶
RouteId  | 
Representation  | 
CreateDate  | 
InServiceDate  | 
Length2157  | 
|---|---|---|---|---|
string  | 
string  | 
TimeInstantType  | 
TimeInstantType  | 
double  | 
Roads Programme MDs¶
RoadsProgrammeId  | 
Name  | 
Description  | 
Code  | 
Year  | 
TotalCost  | 
StartDate  | 
EndDate  | 
FundingCategoryId  | 
FundingCategory  | 
FundingCode  | 
LastUpdatedBy  | 
LastUpdatedDateUtc  | 
Complete  | 
ProjectCount  | 
IsLocked  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
integer  | 
double  | 
string  | 
string  | 
integer  | 
string  | 
string  | 
string  | 
string  | 
boolean  | 
integer  | 
boolean  | 
Road Schedule¶
LACode  | 
SegmentId  | 
SegmentCode  | 
EngineersArea  | 
EngineersAreaId  | 
LicensingAreaId  | 
LicensingArea  | 
MunicipalDistrictId  | 
MunicipalDistrict  | 
Length  | 
MeasuredLength  | 
MinWidth  | 
MaxWidth  | 
AverageWidth  | 
RoadCategory  | 
RoadClassCode  | 
RoadClassName  | 
RoadName  | 
RouteNumber  | 
StartsAt  | 
EndsAt  | 
Via  | 
IncludeInSchedule  | 
IsLegacy  | 
Average_PSCI_Rating  | 
TIN  | 
IsProtectedRoad  | 
IsBusway  | 
IsLinkedSegment  | 
UsageClassificationId  | 
UsageClassification  | 
TypeOfWayId  | 
TypeOfWay  | 
StatusId  | 
Status  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
string  | 
integer  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
integer  | 
string  | 
double  | 
double  | 
double  | 
double  | 
double  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
boolean  | 
boolean  | 
integer  | 
integer  | 
boolean  | 
boolean  | 
boolean  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
Roads Schedule Full¶
LACode  | 
LocalAuthority  | 
SegmentId  | 
Length  | 
RouteNumber  | 
IncludeInSchedule  | 
LocalAuthorityId  | 
IsProtectedRoad  | 
IsBusway  | 
IsLinkedSegment  | 
UsageClassificationId  | 
UsageClassification  | 
TypeOfWayId  | 
TypeOfWay  | 
StatusId  | 
Status  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
string  | 
string  | 
integer  | 
double  | 
string  | 
boolean  | 
integer  | 
boolean  | 
boolean  | 
boolean  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
Routable Old Network¶
EdgeId  | 
NodeIdFrom  | 
NodeIdTo  | 
Length2157  | 
EdgeType  | 
|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
double  | 
string  | 
Routable Old Network Nodes¶
NodeId  | 
OsiGuid  | 
PmsGuid  | 
IntersectionCount  | 
NodeTypeId  | 
NodeType  | 
|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
integer  | 
integer  | 
string  | 
Speed Limit Signs¶
SignId  | 
Limit_A  | 
Limit_B  | 
Reference  | 
Status  | 
DateCommenced  | 
ExpiryDate  | 
SysStartTime  | 
Expired  | 
Repeater  | 
NonTSMCompliant  | 
SizeAsIntMM  | 
Size  | 
SignSizeId  | 
StatusId  | 
StatusIdWithExpiry  | 
MaxSpeed_1  | 
MaxSpeed_2  | 
DATE  | 
Description  | 
MaintenanceIssue  | 
MaintenanceIssueId  | 
MaintenancePriority  | 
MaintenancePriorityId  | 
Mounting  | 
MountingId  | 
CalculatedUserDisplayName  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
string  | 
boolean  | 
boolean  | 
boolean  | 
integer  | 
string  | 
integer  | 
integer  | 
integer  | 
integer  | 
integer  | 
TimeInstantType  | 
string  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
Speed Limit: Segments¶
LimitId  | 
Reference  | 
StatusId  | 
Status  | 
MaxSpeedId  | 
Description  | 
DateCommenced  | 
ExpiryDate  | 
LastReviewDate  | 
SysStartTime  | 
CalculatedUserDisplayName  | 
IsZone  | 
IsLocked  | 
CalculatedLength2157  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
TimeInstantType  | 
TimeInstantType  | 
TimeInstantType  | 
TimeInstantType  | 
string  | 
boolean  | 
boolean  | 
double  | 
Speed Limit: Survey¶
SpeedLimitSurveySummaryId  | 
SpeedLimitSurveyEdgeId  | 
SpeedLimitSurveyId  | 
EdgeId  | 
MeasureFrom  | 
MeasureTo  | 
Length  | 
MaxSpeedId  | 
Status  | 
StatusId  | 
IsLocked  | 
TimestampUtc  | 
ValidFromUtc  | 
ValidToUtc  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
integer  | 
double  | 
double  | 
double  | 
integer  | 
string  | 
integer  | 
boolean  | 
TimeInstantType  | 
TimeInstantType  | 
TimeInstantType  | 
Speed Limit: Zones¶
LimitId  | 
Reference  | 
StatusId  | 
Status  | 
MaxSpeedId  | 
Description  | 
DateCommenced  | 
ExpiryDate  | 
LastReviewDate  | 
SysStartTime  | 
CalculatedUserDisplayName  | 
IsZone  | 
IsLocked  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
integer  | 
string  | 
integer  | 
string  | 
TimeInstantType  | 
TimeInstantType  | 
TimeInstantType  | 
TimeInstantType  | 
string  | 
boolean  | 
boolean  | 
Speed Ramps¶
ID  | 
FileName  | 
SurveyorName  | 
YEAR  | 
DateCreated  | 
LastUpdatedDate  | 
Snapped  | 
DATE  | 
EdgeId  | 
SegmentCode  | 
RoadClass  | 
|---|---|---|---|---|---|---|---|---|---|---|
long  | 
string  | 
string  | 
string  | 
TimeInstantType  | 
TimeInstantType  | 
integer  | 
TimeInstantType  | 
integer  | 
string  | 
string  | 
Surface Survey Edges¶
SurfaceSurveyId  | 
NumMaterials  | 
MaterialId  | 
Material  | 
UsedForSurveys  | 
ProjectId  | 
Description  | 
SurveyorName  | 
CalculatedLength2157  | 
IsFieldSurvey  | 
IsZone  | 
CalculatedUserDisplayName  | 
TimestampUtc  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
string  | 
boolean  | 
integer  | 
string  | 
string  | 
double  | 
boolean  | 
boolean  | 
string  | 
TimeInstantType  | 
Surface Survey Zones¶
SurfaceSurveyId  | 
NumMaterials  | 
MaterialId  | 
Material  | 
UsedForSurveys  | 
ProjectId  | 
Description  | 
SurveyorName  | 
NetworkVersionId  | 
IsFieldSurvey  | 
IsZone  | 
CalculatedUserDisplayName  | 
TimestampUtc  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
string  | 
boolean  | 
integer  | 
string  | 
string  | 
integer  | 
boolean  | 
boolean  | 
string  | 
TimeInstantType  | 
TII Road Network¶
RouteId  | 
Representation  | 
CreateDate  | 
TimeInstantType  | 
Length2157  | 
|---|---|---|---|---|
string  | 
string  | 
TimeInstantType  | 
TimeInstantType  | 
double  | 
Tins: Survey Edges¶
TinSurveyId  | 
MaxImpactCode  | 
Label  | 
Description  | 
IsZone  | 
IsLocked  | 
|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
boolean  | 
boolean  | 
Tins: Survey Report¶
TinSurveySummaryId  | 
TinSurveyEdgeId  | 
TinSurveyId  | 
EdgeId  | 
MeasureFrom  | 
MeasureTo  | 
Length  | 
ImpactCodeId  | 
ImpactDesc  | 
TimeStampUtc  | 
IsLocked  | 
ValidFromUtc  | 
ValidToUtc  | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|
integer  | 
integer  | 
integer  | 
integer  | 
double  | 
double  | 
double  | 
integer  | 
string  | 
TimeInstantType  | 
boolean  | 
TimeInstantType  | 
TimeInstantType  | 
Tins: Surveys¶
TinSurveyId  | 
MaxImpactCode  | 
Label  | 
Description  | 
IsZone  | 
IsLocked  | 
CalculatedUserDisplayName  | 
SysStartTime  | 
SysEndTime  | 
|---|---|---|---|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
boolean  | 
boolean  | 
string  | 
TimeInstantType  | 
TimeInstantType  | 
Townland Boundaries¶
TownlandId  | 
Name  | 
Province  | 
County  | 
AreaSqKm  | 
|---|---|---|---|---|
integer  | 
string  | 
string  | 
string  | 
double  |