View In:   ArcGIS Online Map Viewer

Name: Grundy_Secure.DBO.SignsTest

Display Field: MUTCD

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: false

Supports Datum Transformation: true

Extent:

XMin: 912812.1299043298
YMin: 1617773.0699289888
XMax: 1009374.0001004115
YMax: 1745799.7498987392
Spatial Reference: 102671  (3435)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [133, 0, 11, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• OFFSET ( type: esriFieldTypeSmallInteger, alias: OFFSET, editable: true, nullable: true, defaultValue: null, modelName: OFFSET )
• MAPOFFSET ( type: esriFieldTypeSmallInteger, alias: MAPOFFSET, editable: true, nullable: true, defaultValue: null, modelName: MAPOFFSET )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MUTCD )
• LEGEND ( type: esriFieldTypeString, alias: LEGEND, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LEGEND )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• X_GPS ( type: esriFieldTypeString, alias: X_GPS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: X_GPS )
• Y_GPS ( type: esriFieldTypeString, alias: Y_GPS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Y_GPS )
• LONG_DD ( type: esriFieldTypeDouble, alias: LONG_DD, editable: true, nullable: true, defaultValue: null, modelName: LONG_DD )
• LAT_DD ( type: esriFieldTypeDouble, alias: LAT_DD, editable: true, nullable: true, defaultValue: null, modelName: LAT_DD )
• SignID ( type: esriFieldTypeInteger, alias: SignID, editable: true, nullable: false, defaultValue: null, modelName: SignID )
• Owner_1 ( type: esriFieldTypeSmallInteger, alias: Sign Owner, editable: true, nullable: true, defaultValue: 1, modelName: Owner_1 , Coded Values: [1: County] , [2: Township] , [3: Municipality] , ...2 more... )
• Sheeting_1 ( type: esriFieldTypeSmallInteger, alias: Sign Sheeting Type, editable: true, nullable: true, defaultValue: 1, modelName: Sheeting_1 , Coded Values: [1: High Intensity Prismatic] , [2: Prismatic Type III+] , [3: Beaded Type III] )
• Backing_1 ( type: esriFieldTypeSmallInteger, alias: Sign Backing Type, editable: true, nullable: true, defaultValue: 1, modelName: Backing_1 , Coded Values: [1: Aluminum] , [2: Steel] , [3: Plastic] )
• Posts_1 ( type: esriFieldTypeSmallInteger, alias: Sign Post Quality, editable: true, nullable: true, defaultValue: 1, modelName: Posts_1 , Coded Values: [1: Single Post Sign] , [2: Double Posted Sign] , [3: Triple Posted Sign] )
• PostType ( type: esriFieldTypeSmallInteger, alias: Sign Post Type, editable: true, nullable: true, defaultValue: 1, modelName: PostType , Coded Values: [1: Wood] , [2: Steel] , [3: Plastic] )
• Orientation ( type: esriFieldTypeSmallInteger, alias: Sign Orientation, editable: true, nullable: true, defaultValue: 1, modelName: Orientation , Coded Values: [1: N] , [2: S] , [3: E] , ...5 more... )
• Position_1 ( type: esriFieldTypeSmallInteger, alias: Sign Post Position, editable: true, nullable: true, defaultValue: 1, modelName: Position_1 , Coded Values: [1: Right Side] , [2: Median] , [3: Left Side] )
• Route_ID_1 ( type: esriFieldTypeSmallInteger, alias: Road Name, editable: true, nullable: true, defaultValue: null, modelName: Route_ID_1 , Coded Values: [1: BRACEVILLE RD] , [2: BROADWAY RD] , [3: CAMPUS RD] , ...37 more... )
• Sign_Width_1 ( type: esriFieldTypeSmallInteger, alias: Sign Width (Inches), editable: true, nullable: true, defaultValue: null, modelName: Sign_Width_1 , Coded Values: [1: 6] , [2: 8] , [3: 10] , ...18 more... )
• Sign_Height_1 ( type: esriFieldTypeSmallInteger, alias: Sign Height (Inches), editable: true, nullable: true, defaultValue: null, modelName: Sign_Height_1 , Coded Values: [1: 6] , [2: 8] , [3: 10] , ...18 more... )
• Post_Height ( type: esriFieldTypeSmallInteger, alias: Post Height (Sign Bottom), editable: true, nullable: true, defaultValue: null, modelName: Post_Height , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...8 more... )
• Back_Clr_1 ( type: esriFieldTypeSmallInteger, alias: Sign Background Color, editable: true, nullable: true, defaultValue: null, modelName: Back_Clr_1 , Coded Values: [1: White] , [2: Yellow] , [3: Red] , ...10 more... )
• Legend_Clr_1 ( type: esriFieldTypeSmallInteger, alias: Sign Legend Color, editable: true, nullable: true, defaultValue: null, modelName: Legend_Clr_1 , Coded Values: [1: White] , [2: Yellow] , [3: Red] , ...10 more... )
• Third_Clr_1 ( type: esriFieldTypeSmallInteger, alias: Sign Third Color, editable: true, nullable: true, defaultValue: null, modelName: Third_Clr_1 , Coded Values: [1: White] , [2: Yellow] , [3: Red] , ...10 more... )
• Alert ( type: esriFieldTypeSmallInteger, alias: Sign Maintenance Alert, editable: true, nullable: true, defaultValue: 0, modelName: Alert , Coded Values: [0: False] , [1: True] )
• Maint_Type ( type: esriFieldTypeSmallInteger, alias: Sign Maintenance Type, editable: true, nullable: true, defaultValue: null, modelName: Maint_Type , Coded Values: [1: Clean Sign] , [2: Straighten Post] , [3: Straighten Sign] , ...7 more... )
• Replace_Date ( type: esriFieldTypeDate, alias: Sign Replaced Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Replace_Date )
• Retired_1 ( type: esriFieldTypeSmallInteger, alias: Sign Retired, editable: true, nullable: false, defaultValue: 0, modelName: Retired_1 , Coded Values: [0: False] , [1: True] )
• Retire_Date ( type: esriFieldTypeDate, alias: Sign Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Retire_Date )
• Description ( type: esriFieldTypeString, alias: Sign Description, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Description )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Grundy_Secure.DBO.SignsTest
  Description:
  Prototype:
  LAT_DD: null
  SignID: 0
  Owner_1: 1
  Sheeting_1: 1
  Backing_1: 1
  Posts_1: 1
  PostType: 1
  Orientation: 1
  Third_Clr_1: null
  Replace_Date: null
  Description: null
  X: null
  Y: null
  OFFSET: null
  MAPOFFSET: null
  MUTCD: null
  LEGEND: null
  COMMENTS: null
  X_GPS: null
  Y_GPS: null
  LONG_DD: null
  Position_1: 1
  Route_ID_1: null
  Sign_Width_1: null
  Sign_Height_1: null
  Post_Height: null
  Back_Clr_1: null
  Legend_Clr_1: null
  Alert: 0
  Maint_Type: null
  Retired_1: 0
  Retire_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• SignsMaintenanceTest (0) -- Related To: Grundy_Secure.DBO.SignsMaintenanceTest (1)

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 Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata