View In:   ArcGIS Online Map Viewer

Name: Object Marker Signage

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point layer containing signage assets owned and maintained by the Department of Transportation and Public Works, County of Sonoma. Primary data source of sign inventory is a table in Lucity (non-spatial database). This table is linked from the Lucity server and made available in our database as a view. This process reads the Road ID and postmile entries of each sign, and produces a feature class of points. Data includes location of sign (road name, road id, postmile, street side, sign direction, latitude/longitude, and x/y), content of sign (caption, MUTCD (Manual on Uniform Traffic Control Devices) code, and sign type), sign structure (position on post, post type, width, and offset).

Copyright Text: The Department of Transportation and Public Works, County of Sonoma is the owner, originator of this data; the County of Sonoma, ISD-GIS Central is the publisher, custodian of this data. You must source attribution “County of Sonoma” when displaying this data (see “Use Limitations” below).

Default Visibility: true

MaxRecordCount: 2000

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: 6153275.313292883
YMin: 1811403.1316381667
XMax: 6456793.556683138
YMax: 2073859.376031084
Spatial Reference: 102642  (2226)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: true
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: 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: true
Supports Query With Current User: true

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SV_ID ( type: esriFieldTypeInteger, alias: SV_ID, editable: true, nullable: true, defaultValue: null, modelName: SV_ID )
• RoadName ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 60, defaultValue: null, modelName: RoadName )
• RoadID ( type: esriFieldTypeString, alias: RoadID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RoadID )
• PostMile ( type: esriFieldTypeDouble, alias: PostMile, editable: true, nullable: true, defaultValue: null, modelName: PostMile )
• Caption ( type: esriFieldTypeString, alias: Caption, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Caption )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MUTCD )
• SignType ( type: esriFieldTypeString, alias: SignType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignType )
• PositionOnPost ( type: esriFieldTypeString, alias: PositionOnPost, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PositionOnPost )
• PostType ( type: esriFieldTypeString, alias: PostType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PostType )
• StreetSide ( type: esriFieldTypeString, alias: StreetSide, editable: true, nullable: true, length: 25, defaultValue: null, modelName: StreetSide )
• SignDirection ( type: esriFieldTypeString, alias: SignDirection, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SignDirection )
• WidthFt ( type: esriFieldTypeSmallInteger, alias: WidthFt, editable: true, nullable: true, defaultValue: null, modelName: WidthFt )
• RH_ID ( type: esriFieldTypeInteger, alias: RH_ID, editable: true, nullable: true, defaultValue: null, modelName: RH_ID )
• Offset ( type: esriFieldTypeSmallInteger, alias: Offset, editable: true, nullable: true, defaultValue: null, modelName: Offset )
• SV_NUM ( type: esriFieldTypeString, alias: Lucity ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SV_NUM )
• Lat ( type: esriFieldTypeDouble, alias: Lat, editable: true, nullable: true, defaultValue: null, modelName: Lat )
• Lon ( type: esriFieldTypeDouble, alias: Lon, editable: true, nullable: true, defaultValue: null, modelName: Lon )
• X ( type: esriFieldTypeInteger, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeInteger, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• SV_BKTY_CD ( type: esriFieldTypeSmallInteger, alias: SV_BKTY_CD, editable: true, nullable: true, defaultValue: null, modelName: SV_BKTY_CD )
• SV_SNAR_CD ( type: esriFieldTypeSmallInteger, alias: SV_SNAR_CD, editable: true, nullable: true, defaultValue: null, modelName: SV_SNAR_CD )
• SV_STAT_CD ( type: esriFieldTypeInteger, alias: SV_STAT_CD, editable: true, nullable: true, defaultValue: null, modelName: SV_STAT_CD )
• SV_LABEL ( type: esriFieldTypeString, alias: SV_LABEL, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SV_LABEL )

Templates:

• Name: Object Marker Signage
  Description:
  Prototype:
  SV_STAT_CD: null
  SV_LABEL: null
  SV_ID: null
  RoadName: null
  RoadID: null
  PostMile: null
  Caption: null
  MUTCD: null
  SignType: null
  PositionOnPost: null
  PostType: null
  StreetSide: null
  SignDirection: null
  WidthFt: null
  RH_ID: null
  Offset: null
  SV_NUM: null
  Lat: null
  Lon: null
  X: null
  Y: null
  SV_BKTY_CD: null
  SV_SNAR_CD: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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