View In:   ArcGIS Online Map Viewer

Name: Guide

Display Field: ADMIN

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: SamplA point based feature class that presents sign locations within the City of Gillette. This feature class contains detailed information on sign types and have been categorized into city, guide, regulatory, school, warning and unidentified signs. This feature class provides useful information related to maintenance responsibility, MUTCD Code, material the sign is made up of, barcode, size, sheeting and the reads field. To identify information regarding when data was acquired or created refer to the Source fields: Source Entity, Source Type and Source Date. To identify information regarding when data was last updated refer to the Last fields: Last Editor and Last Update Date. Additional information regarding Spatial Operations Records feature class and Sign Inspections tables can be found within the SpatialOperationsRecords and SignInspections and uses the relationship class SignHasSpatialOperationsRecords and SignHasInspections.ePoint

Service Item Id: 3c5d52bce19b4927b03e0a50e8dc5425

Copyright Text: City of Gillette, Administrative Services, Geographic Information Services Division

Default Visibility: false

MaxRecordCount: 100000

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

Supports Datum Transformation: true

Extent:

XMin: 516947.20941974595
YMin: 1345476.56606829
XMax: 695217.7724973299
YMax: 1435938.086267069
Spatial Reference: 102755  (3736)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SubtypeCD
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 3
  Label: Guilde
  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: 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: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• SIGNTYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SIGNTYPE )
• BARCODEID ( type: esriFieldTypeString, alias: Barcode, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BARCODEID )
• BACKING ( type: esriFieldTypeString, alias: Backing, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BACKING )
• SHEETING ( type: esriFieldTypeString, alias: Sheeting, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SHEETING , Coded Values: [Diamond Grade: Diamond Grade] , [Prism Grade: Prism Grade] , [Engineer Grade: Engineer Grade] , ...1 more... )
• SIGNSIZE ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SIGNSIZE )
• READS ( type: esriFieldTypeString, alias: Reads, editable: true, nullable: true, length: 100, defaultValue: null, modelName: READS )
• SOURCEDATE ( type: esriFieldTypeDate, alias: Source Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SOURCEDATE )
• REASON ( type: esriFieldTypeString, alias: Why replaced?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REASON , Coded Values: [Damaged: Damaged] , [Missing: Missing] , [Replaced: Replaced] , ...23 more... )
• DATEREPLACD ( type: esriFieldTypeDate, alias: Date Replaced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEREPLACD )
• LIFECYCLE ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LIFECYCLE , Coded Values: [Active: Active] , [Inactive: Inactive] , [Proposed: Proposed] , ...4 more... )
• COMMENT ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENT )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• SubtypeCD ( type: esriFieldTypeSmallInteger, alias: Subtype Code, editable: true, nullable: true, defaultValue: 0, modelName: SubtypeCD )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Chris: Chris Leatherman] , [Donna: Donna Moreau] , [Lee: Lee Pratt] , ...20 more... )
• ADMIN ( type: esriFieldTypeString, alias: Administration, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADMIN , Coded Values: [City: City of Gillette] , [County: Campbell County] , [Private: Private Party] , ...5 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CADblock ( type: esriFieldTypeString, alias: AutoCAD Block, editable: true, nullable: true, length: 20, defaultValue: EN-GENERIC, modelName: CADblock )
• CADlayer ( type: esriFieldTypeString, alias: AutoCAD Layer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CADlayer )
• COGID ( type: esriFieldTypeString, alias: City ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: COGID )
• HEIGHT ( type: esriFieldTypeSmallInteger, alias: Compliant Height, editable: true, nullable: true, defaultValue: 0, modelName: HEIGHT , Coded Values: [0: False] , [1: True] )
• MAINT ( type: esriFieldTypeString, alias: Maintenance, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINTENANCE , Coded Values: [Streets: Streets Division] , [Parks: Parks Division] , [Solid: Solid Waste Division] , ...17 more... )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD Code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MUTCD )
• ROTATION ( type: esriFieldTypeSmallInteger, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION , Range: [0, 360] )
• PoleID ( type: esriFieldTypeString, alias: Pole ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PoleID )
• SUBTYPEDESC ( type: esriFieldTypeString, alias: Subtype Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBTYPEDESC )
• SOURCEENTITY ( type: esriFieldTypeString, alias: Source Entity, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCEENTITY , Coded Values: [CCGIS: Campbell County GIS] , [FEMA: Federal Emergency Management Agency] , [NHD: National Hydrology Dataset] , ...38 more... )
• SOURCETYPE ( type: esriFieldTypeString, alias: Source Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCETYPE , Coded Values: [Record: Record Drawing] , [Aerial: Aerial photograph] , [Map: Mapping Grade GPS] , ...17 more... )
• TITLECASE ( type: esriFieldTypeSmallInteger, alias: Title Case, editable: true, nullable: true, defaultValue: null, modelName: TITLECASE , Coded Values: [0: False] , [1: True] )
• RFB ( type: esriFieldTypeSmallInteger, alias: Rapid Fire Beacon, editable: true, nullable: true, defaultValue: null, modelName: RFB , Coded Values: [0: False] , [1: True] )
• REPAIRED ( type: esriFieldTypeSmallInteger, alias: Repaired, editable: true, nullable: true, defaultValue: null, modelName: REPAIRED , Coded Values: [0: False] , [1: True] )
• LEDS ( type: esriFieldTypeSmallInteger, alias: Flashing LEDs, editable: true, nullable: true, defaultValue: null, modelName: LEDS , Coded Values: [0: False] , [1: True] )
• PROJECTSTATUS ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PROJECTSTATUS , Coded Values: [Proactive: Proactive] , [Reactive: Reactive] )
• DATEFOUND ( type: esriFieldTypeDate, alias: Date Found, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEFOUND )
• HYDRAULICPULLER ( type: esriFieldTypeSmallInteger, alias: Hydraulic Post Puller Used, editable: true, nullable: true, defaultValue: null, modelName: HYDRAULICPULLER , Coded Values: [0: False] , [1: True] )
• PDNOTIFIED ( type: esriFieldTypeSmallInteger, alias: PD Notified?, editable: true, nullable: true, defaultValue: null, modelName: PDNOTIFIED , Coded Values: [0: False] , [1: True] )

Types:

ID: 3
Name: Guide
Domains:
• SIGNTYPE:
  Coded Values: [Unidentified: Unidentified] , [Delineators: Delineators] , [Guide Sign: Guide Sign] , ...2 more...
• BACKING:
  Coded Values: [Aluminum: Aluminum] , [Fiberglass: Fiberglass] , [Plastic: Plastic]
• SHEETING:
  Inherited
• REASON:
  Inherited
• LIFECYCLE:
  Inherited
• LASTEDITOR:
  Inherited
• ADMIN:
  Inherited
• HEIGHT:
  Inherited
• MAINT:
  Inherited
• ROTATION:
  Inherited
• SOURCEENTITY:
  Inherited
• SOURCETYPE:
  Inherited
• TITLECASE:
  Inherited
• RFB:
  Inherited
• REPAIRED:
  Inherited
• LEDS:
  Inherited
Templates:
• Name: Guilde
  Description:
  Prototype:
  LASTEDITOR: null
  BARCODEID: null
  PDNOTIFIED: null
  CADblock: EN-GENERIC
  DATEREPLACD: null
  HEIGHT: 0
  HYDRAULICPULLER: null
  SUBTYPEDESC: Guilde
  SOURCEENTITY: COGGIS
  LASTUPDATE: null
  SubtypeCD: 3
  PoleID: null
  SIGNTYPE: null
  BACKING: Aluminum
  SHEETING: null
  SIGNSIZE: null
  READS: null
  SOURCEDATE: null
  REASON: null
  LIFECYCLE: Active
  COMMENT: null
  ADMIN: City
  CADlayer: EN-SIGN-GUID-PNTS-E
  COGID: null
  MAINT: Signs
  MUTCD: null
  ROTATION: null
  SOURCETYPE: Mobile
  TITLECASE: null
  RFB: null
  REPAIRED: null
  LEDS: null
  PROJECTSTATUS: null
  DATEFOUND: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• activities... (16) -- Related To: SDE.DBO.enActivity (11)
• reflectivities... (17) -- Related To: SDE.DBO.enReflect (12)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

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 Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata