View In:   ArcGIS Online Map Viewer

Name: TRANS Median

Display Field: MedianType

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: e3f3ad68ae9f421289050c4f2c4c21ce

Copyright Text: Ramsey County

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 540151.1619708091
YMin: 141300.3994320631
XMax: 603608.3017885536
YMax: 221778.6000238955
Spatial Reference: 103768  (103768)  VCSWkid(115808)  LatestVCSWkid(115808)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: MedianType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [130, 130, 130, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Default Label: Other/Unknown
UniqueValueInfos:
• Value: Delineated
  Label: Delineated
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [237, 81, 81, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Depressed
  Label: Depressed
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [20, 158, 206, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Gored/Flush
  Label: Gored/Flush
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [167, 198, 54, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Raised
  Label: Raised
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [158, 85, 156, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: MedianType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FeatureUniqueID ( type: esriFieldTypeString, alias: Feature Unique ID, editable: false, nullable: true, length: 20, defaultValue: null, modelName: FeatureUniqueID )
• PWStatus ( type: esriFieldTypeString, alias: Public Works Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: PWStatus , Coded Values: [Active: Active] , [Not Built: Not Built] , [Proposed: Proposed] , ...5 more... )
• AWLifecycleStatus ( type: esriFieldTypeString, alias: AssetWorks Lifecycle Status, editable: false, nullable: true, length: 2, defaultValue: null, modelName: AWLifecycleStatus , Coded Values: [A: Active] , [AC: Active Critical] , [AP: Abandoned in Place] , ...18 more... )
• ActiveDate ( type: esriFieldTypeDate, alias: Active Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActiveDate )
• LastCollectedDate ( type: esriFieldTypeDate, alias: Last Collected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastCollectedDate )
• RetiredDate ( type: esriFieldTypeDate, alias: Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RetiredDate )
• ReadyForAW ( type: esriFieldTypeString, alias: Ready for AssetWorks, editable: true, nullable: true, length: 3, defaultValue: NR, modelName: ReadyForAW , Coded Values: [NR: Needs Review] , [UR: Under Review] , [AP: Approved] , ...2 more... )
• AssetDescription ( type: esriFieldTypeString, alias: Asset Description, editable: true, nullable: true, length: 100, defaultValue: Unknown, modelName: AssetDescription )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Division , Coded Values: [Signals: Signals] , [Environmental: Environmental] , [Signs: Signs] , ...2 more... )
• DepartmentCode ( type: esriFieldTypeString, alias: Department Code, editable: false, nullable: true, length: 10, defaultValue: null, modelName: DepartmentCode , Coded Values: [000001: 000001] , [000004: 000004] , [000005: 000005] )
• MedianType ( type: esriFieldTypeString, alias: Median Type, editable: true, nullable: true, length: 50, defaultValue: Raised, modelName: MedianType , Coded Values: [Raised: Raised] , [Depressed: Depressed] , [Gored/Flush: Gored/Flush] , ...1 more... )
• LandscapingType ( type: esriFieldTypeString, alias: Landscape Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LandscapingType , Coded Values: [Grass: Grass] , [Landscape: Landscape] , [Concrete: Concrete] )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: false, nullable: true, length: 5, defaultValue: U, modelName: Condition , Coded Values: [U: Unknown] , [PW-5: 5 – Excellent] , [PW-4: 4 – Good] , ...3 more... )
• MowableSqFootage ( type: esriFieldTypeDouble, alias: Mowable Square Footage, editable: false, nullable: true, defaultValue: null, modelName: MowableSqFootage )
• MedianFlushing ( type: esriFieldTypeString, alias: Median Flushing, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MedianFlushing , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• DrainagePresent ( type: esriFieldTypeString, alias: Drainage Present, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DrainagePresent , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• LightingPresent ( type: esriFieldTypeString, alias: Lighting Present, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LightingPresent , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• IrrigationPresent ( type: esriFieldTypeString, alias: Irrigation Present, editable: true, nullable: true, length: 20, defaultValue: null, modelName: IrrigationPresent , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• FencingPresent ( type: esriFieldTypeString, alias: Fencing Present, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FencingPresent , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• GuardRailPresent ( type: esriFieldTypeString, alias: Guardrail Present, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GuardRailPresent , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• WallPresent ( type: esriFieldTypeString, alias: Wall Present, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WallPresent , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• UtilityAccess ( type: esriFieldTypeString, alias: Utility Access, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UtilityAccess , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• BeginMeasure ( type: esriFieldTypeDouble, alias: Begin Measure, editable: true, nullable: true, defaultValue: null, modelName: BeginMeasure )
• EndMeasure ( type: esriFieldTypeDouble, alias: End Measure, editable: true, nullable: true, defaultValue: null, modelName: EndMeasure )
• LengthFt ( type: esriFieldTypeDouble, alias: Length (ft), editable: true, nullable: true, defaultValue: null, modelName: LengthFt )
• WidthFt ( type: esriFieldTypeDouble, alias: Width (ft), editable: true, nullable: true, defaultValue: null, modelName: WidthFt )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Owner , Coded Values: [State of Minnesota: State of Minnesota] , [MAC: Metropolitan Airports Commission] , [Met Council: Metropolitan Council] , ...42 more... )
• OwnerType ( type: esriFieldTypeString, alias: Owner Type, editable: false, nullable: true, length: 100, defaultValue: null, modelName: OwnerType , Coded Values: [County: County] , [Municipal: Municipal] , [Private: Private] , ...12 more... )
• RoadwayMaintainer ( type: esriFieldTypeString, alias: Roadway Maintainer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RoadwayMaintainer , Coded Values: [State of Minnesota: State of Minnesota] , [MAC: Metropolitan Airports Commission] , [Met Council: Metropolitan Council] , ...42 more... )
• RoadwayMaintainerType ( type: esriFieldTypeString, alias: Roadway Maintainer Type, editable: false, nullable: true, length: 100, defaultValue: null, modelName: RoadwayMaintainerType , Coded Values: [County: County] , [Municipal: Municipal] , [Private: Private] , ...12 more... )
• LandscapeMaintainer ( type: esriFieldTypeString, alias: Landscape Maintainer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LandscapeMaintainer , Coded Values: [State of Minnesota: State of Minnesota] , [MAC: Metropolitan Airports Commission] , [Met Council: Metropolitan Council] , ...42 more... )
• LandscapeMaintainerType ( type: esriFieldTypeString, alias: Landscape Maintainer Type, editable: false, nullable: true, length: 100, defaultValue: null, modelName: LandscapeMaintainerType , Coded Values: [County: County] , [Municipal: Municipal] , [Private: Private] , ...12 more... )
• MaintenanceDistrict ( type: esriFieldTypeString, alias: Maintenance District, editable: true, nullable: true, length: 10, defaultValue: Unknown, modelName: MaintenanceDistrict , Coded Values: [District 1: District 1] , [District 2: District 2] , [St Paul: St Paul] , ...2 more... )
• PMClass ( type: esriFieldTypeString, alias: PM Class, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PMClass , Coded Values: [PW-Flush: PW-Flush] , [PW-Mow: PW-Mow] , [PW-Spray: PW-Spray] , ...1 more... )
• OnBridge ( type: esriFieldTypeString, alias: On Bridge, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OnBridge , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] )
• RouteNumber ( type: esriFieldTypeSmallInteger, alias: Route Number, editable: true, nullable: true, defaultValue: null, modelName: RouteNumber )
• SegmentDescription ( type: esriFieldTypeString, alias: Segment Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SegmentDescription )
• MedianNumber ( type: esriFieldTypeSmallInteger, alias: Median Number, editable: true, nullable: true, defaultValue: null, modelName: MedianNumber )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape Area (US Sqft), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape Perimeter Length (US ft), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1200, defaultValue: null, modelName: Comments )
• created_user ( type: esriFieldTypeString, alias: Created User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• RoadSegment ( type: esriFieldTypeString, alias: Road Segment, editable: true, nullable: true, length: 100, defaultValue: Unknown, modelName: RoadSegment , Coded Values: [Unknown: Unknown] , [1A: 1A] , [1B: 1B] , ...323 more... )

Types:

ID: Delineated
Name: Delineated
Domains:
• PWStatus:
  Inherited
• AWLifecycleStatus:
  Inherited
• ReadyForAW:
  Inherited
• Division:
  Inherited
• DepartmentCode:
  Inherited
• MedianType:
  Inherited
• LandscapingType:
  Inherited
• Condition:
  Inherited
• MedianFlushing:
  Inherited
• DrainagePresent:
  Inherited
• LightingPresent:
  Inherited
• IrrigationPresent:
  Inherited
• FencingPresent:
  Inherited
• GuardRailPresent:
  Inherited
• WallPresent:
  Inherited
• UtilityAccess:
  Inherited
• Owner:
  Inherited
• OwnerType:
  Inherited
• RoadwayMaintainer:
  Inherited
• RoadwayMaintainerType:
  Inherited
• LandscapeMaintainer:
  Inherited
• LandscapeMaintainerType:
  Inherited
• MaintenanceDistrict:
  Inherited
• PMClass:
  Inherited
• OnBridge:
  Inherited
• RoadSegment:
  Inherited
Templates:
• Name: Delineated
  Description:
  Prototype:
  Comments: null
  RoadSegment: Unknown
  PMClass: null
  PWStatus: Active
  OnBridge: null
  ActiveDate: null
  LastCollectedDate: null
  RetiredDate: null
  ReadyForAW: NR
  AssetDescription: Unknown
  Division: null
  MedianType: Delineated
  LandscapingType: null
  MaintenanceDistrict: Unknown
  RouteNumber: null
  MedianFlushing: null
  DrainagePresent: null
  LightingPresent: null
  IrrigationPresent: null
  FencingPresent: null
  GuardRailPresent: null
  WallPresent: null
  UtilityAccess: null
  BeginMeasure: null
  EndMeasure: null
  LengthFt: null
  WidthFt: null
  Owner: null
  MedianNumber: null
  RoadwayMaintainer: null
  SegmentDescription: null
  LandscapeMaintainer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Depressed
Name: Depressed
Domains:
• PWStatus:
  Inherited
• AWLifecycleStatus:
  Inherited
• ReadyForAW:
  Inherited
• Division:
  Inherited
• DepartmentCode:
  Inherited
• MedianType:
  Inherited
• LandscapingType:
  Inherited
• Condition:
  Inherited
• MedianFlushing:
  Inherited
• DrainagePresent:
  Inherited
• LightingPresent:
  Inherited
• IrrigationPresent:
  Inherited
• FencingPresent:
  Inherited
• GuardRailPresent:
  Inherited
• WallPresent:
  Inherited
• UtilityAccess:
  Inherited
• Owner:
  Inherited
• OwnerType:
  Inherited
• RoadwayMaintainer:
  Inherited
• RoadwayMaintainerType:
  Inherited
• LandscapeMaintainer:
  Inherited
• LandscapeMaintainerType:
  Inherited
• MaintenanceDistrict:
  Inherited
• PMClass:
  Inherited
• OnBridge:
  Inherited
• RoadSegment:
  Inherited
Templates:
• Name: Depressed
  Description:
  Prototype:
  Comments: null
  RoadSegment: Unknown
  PMClass: null
  PWStatus: Active
  OnBridge: null
  ActiveDate: null
  LastCollectedDate: null
  RetiredDate: null
  ReadyForAW: NR
  AssetDescription: Unknown
  Division: null
  MedianType: Depressed
  LandscapingType: null
  MaintenanceDistrict: Unknown
  RouteNumber: null
  MedianFlushing: null
  DrainagePresent: null
  LightingPresent: null
  IrrigationPresent: null
  FencingPresent: null
  GuardRailPresent: null
  WallPresent: null
  UtilityAccess: null
  BeginMeasure: null
  EndMeasure: null
  LengthFt: null
  WidthFt: null
  Owner: null
  MedianNumber: null
  RoadwayMaintainer: null
  SegmentDescription: null
  LandscapeMaintainer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Gored/Flush
Name: Gored/Flush
Domains:
• PWStatus:
  Inherited
• AWLifecycleStatus:
  Inherited
• ReadyForAW:
  Inherited
• Division:
  Inherited
• DepartmentCode:
  Inherited
• MedianType:
  Inherited
• LandscapingType:
  Inherited
• Condition:
  Inherited
• MedianFlushing:
  Inherited
• DrainagePresent:
  Inherited
• LightingPresent:
  Inherited
• IrrigationPresent:
  Inherited
• FencingPresent:
  Inherited
• GuardRailPresent:
  Inherited
• WallPresent:
  Inherited
• UtilityAccess:
  Inherited
• Owner:
  Inherited
• OwnerType:
  Inherited
• RoadwayMaintainer:
  Inherited
• RoadwayMaintainerType:
  Inherited
• LandscapeMaintainer:
  Inherited
• LandscapeMaintainerType:
  Inherited
• MaintenanceDistrict:
  Inherited
• PMClass:
  Inherited
• OnBridge:
  Inherited
• RoadSegment:
  Inherited
Templates:
• Name: Gored/Flush
  Description:
  Prototype:
  Comments: null
  RoadSegment: Unknown
  PMClass: null
  PWStatus: Active
  OnBridge: null
  ActiveDate: null
  LastCollectedDate: null
  RetiredDate: null
  ReadyForAW: NR
  AssetDescription: Unknown
  Division: null
  MedianType: Gored/Flush
  LandscapingType: null
  MaintenanceDistrict: Unknown
  RouteNumber: null
  MedianFlushing: null
  DrainagePresent: null
  LightingPresent: null
  IrrigationPresent: null
  FencingPresent: null
  GuardRailPresent: null
  WallPresent: null
  UtilityAccess: null
  BeginMeasure: null
  EndMeasure: null
  LengthFt: null
  WidthFt: null
  Owner: null
  MedianNumber: null
  RoadwayMaintainer: null
  SegmentDescription: null
  LandscapeMaintainer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Raised
Name: Raised
Domains:
• PWStatus:
  Inherited
• AWLifecycleStatus:
  Inherited
• ReadyForAW:
  Inherited
• Division:
  Inherited
• DepartmentCode:
  Inherited
• MedianType:
  Inherited
• LandscapingType:
  Inherited
• Condition:
  Inherited
• MedianFlushing:
  Inherited
• DrainagePresent:
  Inherited
• LightingPresent:
  Inherited
• IrrigationPresent:
  Inherited
• FencingPresent:
  Inherited
• GuardRailPresent:
  Inherited
• WallPresent:
  Inherited
• UtilityAccess:
  Inherited
• Owner:
  Inherited
• OwnerType:
  Inherited
• RoadwayMaintainer:
  Inherited
• RoadwayMaintainerType:
  Inherited
• LandscapeMaintainer:
  Inherited
• LandscapeMaintainerType:
  Inherited
• MaintenanceDistrict:
  Inherited
• PMClass:
  Inherited
• OnBridge:
  Inherited
• RoadSegment:
  Inherited
Templates:
• Name: Raised
  Description:
  Prototype:
  Comments: null
  RoadSegment: Unknown
  PMClass: null
  PWStatus: Active
  OnBridge: null
  ActiveDate: null
  LastCollectedDate: null
  RetiredDate: null
  ReadyForAW: NR
  AssetDescription: Unknown
  Division: null
  MedianType: Raised
  LandscapingType: null
  MaintenanceDistrict: Unknown
  RouteNumber: null
  MedianFlushing: null
  DrainagePresent: null
  LightingPresent: null
  IrrigationPresent: null
  FencingPresent: null
  GuardRailPresent: null
  WallPresent: null
  UtilityAccess: null
  BeginMeasure: null
  EndMeasure: null
  LengthFt: null
  WidthFt: null
  Owner: null
  MedianNumber: null
  RoadwayMaintainer: null
  SegmentDescription: null
  LandscapeMaintainer: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata