View In:   ArcGIS Online Map Viewer

Name: Sign Locations

Display Field: SignID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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

Supports Datum Transformation: true

Extent:

XMin: -119184000
YMin: -98325300
XMax: 554819.6455693841
YMax: 242291.534698233
Spatial Reference: PROJCS["Dakota - county coordinates - english",GEOGCS["Dakota - county coordinates - english",DATUM["",SPHEROID["",6378421.989,298.2572133677354]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",499999.999998],PARAMETER["False_Northing",99999.9999996],PARAMETER["Central_Meridian",-93.31666666666666],PARAMETER["Standard_Parallel_1",44.51666666666667],PARAMETER["Standard_Parallel_2",44.91666666666666],PARAMETER["Latitude_Of_Origin",44.47194444444445],UNIT["Foot_US",0.3048006096012192]]

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

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• IntersectionLocation ( type: esriFieldTypeString, alias: StreetSegmentName, editable: true, nullable: true, length: 300, defaultValue: null, modelName: IntersectionLocation )
• StreetSegmentName ( type: esriFieldTypeString, alias: StreetSegmentName, editable: true, nullable: true, length: 300, defaultValue: null, modelName: StreetSegmentName )
• Age ( type: esriFieldTypeDouble, alias: Age, editable: true, nullable: true, defaultValue: null, modelName: Age )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• Category ( type: esriFieldTypeString, alias: SignType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Category , Coded Values: [Regulatory: Regulatory] , [Warning: Warning] , [Guide: Guide] , ...4 more... )
• SignDescription ( type: esriFieldTypeString, alias: SignDescription, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SignDescription , Coded Values: [STOP: STOP] , [YIELD: YIELD] , [ALL WAY: ALL WAY] , ...206 more... )
• SignType ( type: esriFieldTypeString, alias: SignType, editable: true, nullable: true, length: 300, defaultValue: null, modelName: SignType , Coded Values: [BEACON: BEACON] , [BLINKERSIGN: BLINKERSIGN] , [D11-1: D11-1] , ...213 more... )
• PostPosition ( type: esriFieldTypeString, alias: PolePosition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PolePosition )
• SignManufacturer ( type: esriFieldTypeString, alias: SignManufacturer, editable: true, nullable: true, length: 50, defaultValue: Newman, modelName: SignManufacturer , Coded Values: [Newman: Newman Signs, Inc.] , [EFA/SS: Earl F Anderson / Safety Signs] , [Tapco: Traffic and Parking Control Co., Inc.] , ...2 more... )
• Width ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: Width )
• Height ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• SignMaterial ( type: esriFieldTypeString, alias: SignMaterial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignMaterial , Coded Values: [DG3: Diamond Grade 3] , [EMB: Embossed Glass Beads] , [ENG: Engineering Grade] , ...2 more... )
• SignSide ( type: esriFieldTypeString, alias: SignSide, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignSide , Coded Values: [CL: Center Left] , [CR: Center Right] , [CT: Center Lane] , ...3 more... )
• LastActivityDate ( type: esriFieldTypeDate, alias: LastActivityDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastActivityDate )
• LastActivity ( type: esriFieldTypeString, alias: LastActivity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastActivity , Coded Values: [Added to inventory: Added to Inventory] , [Changed sign type: Changed sign type] , [Cleaned sign face: Cleaned sign face] , ...19 more... )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition )
• MaintBy ( type: esriFieldTypeString, alias: MaintBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintBy , Coded Values: [CityOfEagan: City of Eagan] , [DakotaCounty: Dakota County] , [MnDOT: MnDOT] , ...5 more... )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnedBy , Coded Values: [CityOfEagan: City of Eagan] , [DakotaCounty: Dakota County] , [MnDOT: MnDOT] , ...5 more... )
• SignWork ( type: esriFieldTypeString, alias: Work, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Work_Needed , Coded Values: [Bent: Bent] , [Broken: Broken] , [Faded: Faded] , ...4 more... )
• SignFacing ( type: esriFieldTypeString, alias: SignFacing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignFaceName , Coded Values: [E: East] , [N: North] , [NE: North East] , ...6 more... )
• WorkStatus ( type: esriFieldTypeString, alias: WorkStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkStatus , Coded Values: [AttentionNeeded: Attention Needed] , [ReplacementNeeded: Replacement Needed] , [InspectionNeeded: Inspection Needed] , ...3 more... )
• AgeUpdate ( type: esriFieldTypeDate, alias: AgeUpdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AgeUpdate )
• ReplacementDate ( type: esriFieldTypeDate, alias: ReplacementDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReplacementDate )
• SignStatus ( type: esriFieldTypeString, alias: SignStatus, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Active: Active] , [Removed: Removed] , [Assumed: Assumed] , ...2 more... )
• SignText ( type: esriFieldTypeString, alias: SignText, editable: true, nullable: true, length: 300, defaultValue: null, modelName: SignText )
• QuarterSection ( type: esriFieldTypeString, alias: QuarterSection, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QuarterSection )
• Warning_SystemSerialNumber ( type: esriFieldTypeString, alias: Warning Light System Serial Number, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Warning_SystemSerialNumber )
• SNSText1 ( type: esriFieldTypeString, alias: SNSText1, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SNSText1 )
• SNSText2 ( type: esriFieldTypeString, alias: SNSText2, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SNSText2 )
• SNSText3 ( type: esriFieldTypeString, alias: SNSText3, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SNSText3 )
• ProjectSignNumber ( type: esriFieldTypeString, alias: Project Sign Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectSignNumber )
• RevitalizationProject ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RevitalizationProject )
• ProjectNotes ( type: esriFieldTypeString, alias: Project Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ProjectNotes )

Templates:

• Name: Sign Locations
  Description:
  Prototype:
  RevitalizationProject: null
  Notes: null
  ProjectSignNumber: null
  SNSText3: null
  SNSText2: null
  SNSText1: null
  ProjectNotes: null
  IntersectionLocation: null
  StreetSegmentName: null
  Age: null
  InstallDate: null
  Category: null
  SignDescription: null
  SignType: null
  PostPosition: null
  SignManufacturer: Newman
  Width: null
  Height: null
  SignMaterial: null
  SignSide: null
  LastActivityDate: null
  LastActivity: null
  Condition: null
  MaintBy: null
  OwnedBy: null
  SignWork: null
  SignFacing: null
  WorkStatus: null
  AgeUpdate: null
  ReplacementDate: null
  SignStatus: Active
  SignText: null
  QuarterSection: null
  Warning_SystemSerialNumber: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• SignActivities (2) -- Related To: SignActivities (30)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: 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:   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