View In:   ArcGIS Online Map Viewer

Name: SignSupports

Display Field: imagename2

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Inventory of city-owned signs and sign supports in Monroe, MI. Data were collected primarily using mobile LiDAR but also manual measurements using GPS and ortho-imagery. Support locations and a variety of attribute data were collected for each support. Associated signs installed on supports were collected as well, along with numerous attributes. Signs are organized in a related geodatabase table and linked to the sign support feature class using SupportID. Photographs exist for all supports either as html images in a street-view program or as hyperlinks in an ArcGIS map document.</SPAN></P></DIV></DIV></DIV>

Service Item Id: 59fcb79bc2344620b8075879aac5f415

Copyright Text: Initial LiDAR data was collected by Surveying Solutions, Inc. during fall 2014. Location extraction, measurements and attrubute entry was completed by RS&GIS, Michigan State University during winter 2015 and spring 2016.

Default Visibility: true

MaxRecordCount: 1000

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.3375709811351702E7
YMin: 144436.3838582635
XMax: 1.3399965521981627E7
YMax: 162164.62959317863
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: signname
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Bike Route
  Label: Bike Route
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 196, 189, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Dead End
  Label: Dead End
  Description: N/A
  Symbol:
  
• Value: Do Not Enter
  Label: Do Not Enter
  Description: N/A
  Symbol:
  
• Value: No Left Turn
  Label: No Left Turn
  Description: N/A
  Symbol:
  
• Value: No Parking (Symbol)
  Label: No Parking
  Description: N/A
  Symbol:
  
• Value: One-Way Left
  Label: One-Way Left
  Description: N/A
  Symbol:
  
• Value: One-Way Right
  Label: One-Way Right
  Description: N/A
  Symbol:
  
• Value: Other
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [169, 0, 230, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Railroad Crossing
  Label: Railroad Crossing
  Description: N/A
  Symbol:
  
• Value: Stop
  Label: Stop
  Description: N/A
  Symbol:
  
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: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: signname

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• comment ( nullable: true, editable: true, defaultValue: null, length: 254, type: esriFieldTypeString, modelName: COMMENT, alias: COMMENT )
• x ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: X, alias: X )
• y ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: Y, alias: Y )
• z ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: Z, alias: Z )
• visit ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Visit, alias: Visit , Coded Values: [YES: YES] , [NO: NO] )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• imagename2 ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: ImageName2, alias: ImageName2 )
• supportid ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: SupportID, alias: SupportID )
• supporttype ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SupportType, alias: SupportType , Coded Values: [TubularMetal: TubularMetal] , [SquareMetal: SquareMetal] , [U_Channel: U_Channel] , ...10 more... )
• numsupports ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: NumSupports, alias: NumSupports )
• supportlean ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SupportLean, alias: SupportLean , Coded Values: [Minimal: Minimal] , [Moderate: Moderate] , [Excessive: Excessive] )
• supportbasetype ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SupportBaseType, alias: SupportBaseType , Coded Values: [VLoc: V-Loc] , [SqrBrkwy: Square Breakaway] , [None: None] , ...2 more... )
• signname ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SignName, alias: SignName )
• created_user ( nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Types:

ID: Bike Route
Name: Bike Route
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: Bike Route
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Dead End
Name: Dead End
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: Dead End
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Do Not Enter
Name: Do Not Enter
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: Do Not Enter
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: No Left Turn
Name: No Left Turn
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: No Left Turn
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: No Parking (Symbol)
Name: No Parking
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: No Parking (Symbol)
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: One-Way Left
Name: One-Way Left
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: One-Way Left
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: One-Way Right
Name: One-Way Right
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: One-Way Right
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Other
Name: Other
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Railroad Crossing
Name: Railroad Crossing
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: Railroad Crossing
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Stop
Name: Stop
Domains:
• supportbasetype:
  Inherited
• supportlean:
  Inherited
• visit:
  Inherited
• supporttype:
  Inherited
Templates:
• Name: Stop
  Description:
  Prototype:
  signname: null
  supportbasetype: null
  supportlean: null
  imagename2: null
  x: null
  y: null
  comment: null
  z: null
  visit: null
  supportid: null
  numsupports: null
  supporttype: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Signs (0) -- Related To: SignsTable (1)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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 Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata