View In:   ArcGIS Online Map Viewer

Name: PRODVECTOR.GIS.tRoad

Display Field: strname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This feature class contains all of the region's road features and most of the road-related attribute fields from the year-2022 Roads &amp; Highways export file from MDOT's Open Data Portal. The features in this layer are a subset of the gRH_SEMCOG layer, which contains rail and trail features in addition to roads. Wherever SEMCOG discovered clear errors in MDOT's attribute values, SEMCOG corrected those values in both the gRH_SEMCOG layer and the tRoad layer, so that these two layers would remain in sync with one another. For numeric fields containing both null values and zeros, with no difference in meaning between the two values, SEMCOG changed the null values to zeros to avoid potential confusion. To supplement MDOT's original attribute fields, SEMCOG added several other fields to tRoad. Additions include the fields SEG_ID, VER, SEMMCDL, and SEMMCDR, which can also be found in gRH_SEMCOG, plus several more fields not stored in that layer. Some additional fields contain road-name attributes combined in useful ways; some store ID numbers that uniquely identify features in related GIS layers; some flag segments as ramps, crossovers, or turnarounds; and some provide still other information. SEMCOG chose to omit from tRoad all of the fields from gRH_SEMCOG stored "after" the control-section attributes. Although the omitted fields are road-related, SEMCOG staff have yet to closely examine their contents, and have many unanswered questions about them. The field named SEMROUNDID is simply MDOT's original ROUNDID field, with values updated as noted below. SEMCOG kept MDOT's original feature geometry intact, with the exception of 125 segment splits introduced to properly correct erroneous road-name and community-boundary attributes, plus an adjustment to fix one "undershoot" found along Peabody St at Maple Rd in Birmingham.</SPAN></P></DIV></DIV></DIV>

Service Item Id: a6606a24a2bc4d22becf100d8c88e922

Copyright Text: Southeast Michigan Council of Governments (SEMCOG)

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1.3179328478674546E7
YMin: 82060.02427820861
XMax: 1.364435214206037E7
YMax: 613667.8198818862
Spatial Reference: 2898  (2898)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [92, 41, 170, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• seg_id ( modelName: SEG_ID, nullable: true, editable: true, defaultValue: null, alias: SEG_ID, type: esriFieldTypeInteger )
• ver ( modelName: VER, nullable: true, editable: true, defaultValue: null, length: 3, alias: VER, type: esriFieldTypeString )
• pr ( modelName: PR, nullable: true, editable: true, defaultValue: null, alias: PR, type: esriFieldTypeInteger )
• bmp ( modelName: BMP, nullable: true, editable: true, defaultValue: null, alias: BMP, type: esriFieldTypeDouble )
• emp ( modelName: EMP, nullable: true, editable: true, defaultValue: null, alias: EMP, type: esriFieldTypeDouble )
• bpt ( modelName: BPT, nullable: true, editable: true, defaultValue: null, length: 38, alias: BPT, type: esriFieldTypeString )
• ept ( modelName: EPT, nullable: true, editable: true, defaultValue: null, length: 38, alias: EPT, type: esriFieldTypeString )
• strname ( modelName: STRNAME1, nullable: true, editable: true, defaultValue: null, length: 50, alias: STRNAME, type: esriFieldTypeString )
• strname2 ( modelName: STRNAME2, nullable: true, editable: true, defaultValue: null, length: 50, alias: STRNAME2, type: esriFieldTypeString )
• strname3 ( modelName: STRNAME3, nullable: true, editable: true, defaultValue: null, length: 50, alias: STRNAME3, type: esriFieldTypeString )
• fedirp ( modelName: PrefixDirectionMDOT, nullable: true, editable: true, defaultValue: null, length: 2, alias: FEDIRP, type: esriFieldTypeString )
• fename ( modelName: RoadNameMDOT, nullable: true, editable: true, defaultValue: null, length: 30, alias: FENAME, type: esriFieldTypeString )
• fetype ( modelName: RoadTypeMDOT, nullable: true, editable: true, defaultValue: null, length: 4, alias: FETYPE, type: esriFieldTypeString )
• fedirs ( modelName: SuffixDirectionMDOT, nullable: true, editable: true, defaultValue: null, length: 2, alias: FEDIRS, type: esriFieldTypeString )
• fedirp2 ( modelName: PrefixDirectionAlias, nullable: true, editable: true, defaultValue: null, length: 2, alias: FEDIRP2, type: esriFieldTypeString )
• fename2 ( modelName: RoadNameAlias, nullable: true, editable: true, defaultValue: null, length: 30, alias: FENAME2, type: esriFieldTypeString )
• fetype2 ( modelName: RoadTypeAlias, nullable: true, editable: true, defaultValue: null, length: 4, alias: FETYPE2, type: esriFieldTypeString )
• fedirs2 ( modelName: SuffixDirectionAlias, nullable: true, editable: true, defaultValue: null, length: 2, alias: FEDIRS2, type: esriFieldTypeString )
• fedirp3 ( modelName: PrefixDirectionAlias, nullable: true, editable: true, defaultValue: null, length: 2, alias: FEDIRP3, type: esriFieldTypeString )
• fename3 ( modelName: RoadNameAlias, nullable: true, editable: true, defaultValue: null, length: 30, alias: FENAME3, type: esriFieldTypeString )
• fetype3 ( modelName: RoadTypeAlias, nullable: true, editable: true, defaultValue: null, length: 4, alias: FETYPE3, type: esriFieldTypeString )
• fedirs3 ( modelName: SuffixDirectionAlias, nullable: true, editable: true, defaultValue: null, length: 2, alias: FEDIRS3, type: esriFieldTypeString )
• road_name ( modelName: ROAD_NAME, nullable: true, editable: true, defaultValue: null, length: 75, alias: ROAD_NAME, type: esriFieldTypeString )
• fcc ( modelName: FeatureClassificationCode, nullable: true, editable: true, defaultValue: null, length: 7, alias: FCC, type: esriFieldTypeString )
• nfc ( modelName: FunctionalSystem, nullable: true, editable: true, defaultValue: 0, alias: NFC, type: esriFieldTypeSmallInteger )
• legalsystem ( modelName: LegalSystem, nullable: true, editable: true, defaultValue: null, alias: LegalSystem, type: esriFieldTypeSmallInteger )
• nhs ( modelName: Nhs, nullable: true, editable: true, defaultValue: null, alias: Nhs, type: esriFieldTypeSmallInteger )
• pc_co ( modelName: JurisdictionCounty, nullable: true, editable: true, defaultValue: null, length: 2, alias: PC_CO, type: esriFieldTypeString )
• pc_city ( modelName: JurisdictionCity, nullable: true, editable: true, defaultValue: null, length: 4, alias: PC_CITY, type: esriFieldTypeString )
• ru ( modelName: RuralUrban, nullable: true, editable: true, defaultValue: null, alias: RU, type: esriFieldTypeSmallInteger )
• acub ( modelName: Acub, nullable: true, editable: true, defaultValue: null, alias: ACUB, type: esriFieldTypeSmallInteger )
• fedaid ( modelName: FedAid, nullable: true, editable: true, defaultValue: null, length: 3, alias: FedAid, type: esriFieldTypeString )
• trafalign ( modelName: TrafficAlignment, nullable: true, editable: true, defaultValue: null, length: 1, alias: TRAFALIGN, type: esriFieldTypeString )
• gsf ( modelName: GradeSeparationFrom, nullable: true, editable: true, defaultValue: null, alias: GSF, type: esriFieldTypeSmallInteger )
• gst ( modelName: GradeSeparationTo, nullable: true, editable: true, defaultValue: null, alias: GST, type: esriFieldTypeSmallInteger )
• countyl ( modelName: CountyLeft, nullable: true, editable: true, defaultValue: null, alias: COUNTYL, type: esriFieldTypeInteger )
• countyr ( modelName: CountyRight, nullable: true, editable: true, defaultValue: null, alias: COUNTYR, type: esriFieldTypeInteger )
• semmcdl ( modelName: SEMMCDL, nullable: true, editable: true, defaultValue: null, alias: SEMMCDL, type: esriFieldTypeInteger )
• semmcdr ( modelName: SEMMCDR, nullable: true, editable: true, defaultValue: null, alias: SEMMCDR, type: esriFieldTypeInteger )
• fmcdl ( modelName: MCD_Left, nullable: true, editable: true, defaultValue: null, alias: FMCDL, type: esriFieldTypeInteger )
• fmcdr ( modelName: MCD_Right, nullable: true, editable: true, defaultValue: null, alias: FMCDR, type: esriFieldTypeInteger )
• fpll ( modelName: FPL_Left, nullable: true, editable: true, defaultValue: null, alias: FPLL, type: esriFieldTypeInteger )
• fplr ( modelName: FPL_Right, nullable: true, editable: true, defaultValue: null, alias: FPLR, type: esriFieldTypeInteger )
• zipl ( modelName: ZIPL, nullable: true, editable: true, defaultValue: null, length: 5, alias: ZIPL, type: esriFieldTypeString )
• zipr ( modelName: ZIPR, nullable: true, editable: true, defaultValue: null, length: 5, alias: ZIPR, type: esriFieldTypeString )
• semroundid ( modelName: SEMROUNDID, nullable: true, editable: true, defaultValue: null, alias: SEMROUNDID, type: esriFieldTypeInteger )
• roundfunc ( modelName: ROUNDFUNC, nullable: true, editable: true, defaultValue: null, length: 20, alias: ROUNDFUNC, type: esriFieldTypeString )
• icn ( modelName: InterchangeNumber, nullable: true, editable: true, defaultValue: null, length: 9, alias: ICN, type: esriFieldTypeString )
• rampid ( modelName: MaliRampId, nullable: true, editable: true, defaultValue: null, length: 4, alias: RAMPID, type: esriFieldTypeString )
• ft ( modelName: FT, nullable: true, editable: true, defaultValue: null, alias: FT, type: esriFieldTypeSmallInteger )
• ramp ( modelName: RAMP, nullable: true, editable: true, defaultValue: null, alias: RAMP, type: esriFieldTypeSmallInteger )
• crossover ( modelName: CROSSOVER, nullable: true, editable: true, defaultValue: null, alias: CROSSOVER, type: esriFieldTypeSmallInteger )
• turnaround ( modelName: TURNAROUND, nullable: true, editable: true, defaultValue: null, alias: TURNAROUND, type: esriFieldTypeSmallInteger )
• rt1 ( modelName: RT1, nullable: true, editable: true, defaultValue: null, length: 14, alias: RT1, type: esriFieldTypeString )
• rt1sign ( modelName: RouteDirection, nullable: true, editable: true, defaultValue: null, alias: RT1SIGN, type: esriFieldTypeSmallInteger )
• rt2 ( modelName: RT2, nullable: true, editable: true, defaultValue: null, length: 14, alias: RT2, type: esriFieldTypeString )
• rt2sign ( modelName: RT2SIGN, nullable: true, editable: true, defaultValue: null, alias: RT2SIGN, type: esriFieldTypeSmallInteger )
• rt3 ( modelName: RT3, nullable: true, editable: true, defaultValue: null, length: 14, alias: RT3, type: esriFieldTypeString )
• rt3sign ( modelName: RT3SIGN, nullable: true, editable: true, defaultValue: null, alias: RT3SIGN, type: esriFieldTypeSmallInteger )
• cs ( modelName: CS, nullable: true, editable: true, defaultValue: null, length: 5, alias: CS, type: esriFieldTypeString )
• cspath ( modelName: CSBranch, nullable: true, editable: true, defaultValue: null, length: 2, alias: CSPATH, type: esriFieldTypeString )
• csbranch ( modelName: CSBRANCH, nullable: true, editable: true, defaultValue: null, length: 2, alias: CSBRANCH, type: esriFieldTypeString )
• unid ( modelName: UNID, nullable: true, editable: true, defaultValue: null, length: 4, alias: UNID, type: esriFieldTypeString )
• csbmp ( modelName: CSBMP, nullable: true, editable: true, defaultValue: null, alias: CSBMP, type: esriFieldTypeDouble )
• csemp ( modelName: CSEMP, nullable: true, editable: true, defaultValue: null, alias: CSEMP, type: esriFieldTypeDouble )
• link_id ( modelName: LINK_ID, nullable: true, editable: true, defaultValue: null, alias: LINK_ID, type: esriFieldTypeInteger )
• falink_id ( modelName: FALINK_ID, nullable: true, editable: true, defaultValue: null, alias: FALINK_ID, type: esriFieldTypeInteger )
• subtypecd ( modelName: SUBTYPECD, nullable: true, editable: true, defaultValue: 1, alias: SUBTYPECD, type: esriFieldTypeSmallInteger )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: PRODVECTOR.GIS.tRoad
  Description:
  Prototype:
  semmcdl: null
  pr: null
  acub: null
  rt2sign: null
  bmp: null
  semmcdr: null
  fedirs: null
  gst: null
  rt1sign: null
  fedirp: null
  link_id: null
  rt3sign: null
  icn: null
  fename: null
  semroundid: null
  road_name: null
  ver: null
  csbranch: null
  pc_city: null
  legalsystem: null
  ramp: null
  ept: null
  nfc: 0
  fetype: null
  rt1: null
  rt3: null
  rt2: null
  seg_id: null
  csbmp: null
  rampid: null
  falink_id: null
  subtypecd: 1
  crossover: null
  unid: null
  ru: null
  fcc: null
  strname2: null
  zipr: null
  turnaround: null
  emp: null
  strname3: null
  fedirs3: null
  fedirs2: null
  ft: null
  zipl: null
  fmcdl: null
  fmcdr: null
  fedaid: null
  trafalign: null
  pc_co: null
  fplr: null
  strname: null
  bpt: null
  fetype2: null
  roundfunc: null
  fetype3: null
  cspath: null
  cs: null
  csemp: null
  countyl: null
  fedirp3: null
  fedirp2: null
  fename2: null
  nhs: null
  fename3: null
  fpll: null
  gsf: null
  countyr: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata