View In:   ArcGIS Online Map Viewer

Name: Blue Stakes Tickets Historical

Display Field: CompanyName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c429b0dad3d648cc9fc91b0109e73794

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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: -111.7131502777338
YMin: 40.07647530734539
XMax: 1614497.965760395
YMax: 7254425.5634102225
Spatial Reference: 102743  (3566)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [85, 130, 46, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TicketNumber ( type: esriFieldTypeString, alias: Ticket Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Ticket )
• Revision ( type: esriFieldTypeString, alias: Revision, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Rev )
• TicketType ( type: esriFieldTypeString, alias: Ticket Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Type )
• Priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Priority )
• Category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Category )
• Lookup ( type: esriFieldTypeString, alias: Lookup, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Lookup )
• Header ( type: esriFieldTypeString, alias: Header, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Header )
• TakenDate ( type: esriFieldTypeDate, alias: Taken Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Started )
• SubmittedDate ( type: esriFieldTypeDate, alias: Submitted Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Completed )
• LegalDate ( type: esriFieldTypeDate, alias: Legal Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Work_Date )
• Operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Oper )
• DoneFor ( type: esriFieldTypeString, alias: Done For, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Done_For )
• Channel ( type: esriFieldTypeString, alias: Channel, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Chan )
• CompanyName ( type: esriFieldTypeString, alias: Company Name, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Company )
• CompanyPhone ( type: esriFieldTypeString, alias: Company Phone, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Company_Phone )
• CompanyAddress1 ( type: esriFieldTypeString, alias: Company Address 1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Company_Addr1 )
• CompanyAddress2 ( type: esriFieldTypeString, alias: Company Address 2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Company_Addr2 )
• Caller ( type: esriFieldTypeString, alias: Caller, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Caller )
• CallerType ( type: esriFieldTypeString, alias: Caller Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Caller_Type )
• CallerPhone ( type: esriFieldTypeString, alias: Caller Phone, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Caller_Phone )
• CallerEmail ( type: esriFieldTypeString, alias: Caller Email, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CallerEmail )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 10, defaultValue: null, modelName: State )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 16, defaultValue: null, modelName: County )
• Place ( type: esriFieldTypeString, alias: Place, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Place )
• Subdivision ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Subdivision )
• FromAddress ( type: esriFieldTypeString, alias: From Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FromAddress )
• ToAddress ( type: esriFieldTypeString, alias: To Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ToAddress )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Street )
• CrossStreet1 ( type: esriFieldTypeString, alias: Cross Street 1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CrossStreet1 )
• CrossStreet2 ( type: esriFieldTypeString, alias: Cross Street 2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CrossStreet2 )
• Latitude ( type: esriFieldTypeString, alias: Latitude, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeString, alias: Longitude, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Longitude )
• WorkType ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: WorkType )
• FieldContact ( type: esriFieldTypeString, alias: Field Contact, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FieldContact )
• UpdateByDate ( type: esriFieldTypeDate, alias: Update By Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UpdateByDate )
• GoodThruDate ( type: esriFieldTypeDate, alias: Good Thru Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GoodThruDate )
• Lot ( type: esriFieldTypeString, alias: Lot, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Lot )
• TakenSource ( type: esriFieldTypeString, alias: Taken Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TakenSource )
• TakenVersion ( type: esriFieldTypeString, alias: Taken Version, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TakenVersion )
• Boring ( type: esriFieldTypeString, alias: Boring, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Boring , Coded Values: [Yes: Yes] , [No: No] )
• Blasting ( type: esriFieldTypeString, alias: Blasting, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Blasting , Coded Values: [Yes: Yes] , [No: No] )
• Meet ( type: esriFieldTypeString, alias: Meet, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Meet , Coded Values: [Yes: Yes] , [No: No] )
• Emergency ( type: esriFieldTypeString, alias: Emergency, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Emergency , Coded Values: [Yes: Yes] , [No: No] )
• DiggingInRoad ( type: esriFieldTypeString, alias: Digging In Road, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DiggingInRoad , Coded Values: [Yes: Yes] , [No: No] )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Location )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Remarks )
• SideOfStreet ( type: esriFieldTypeString, alias: Side Of Street, editable: true, nullable: true, length: 16, defaultValue: null, modelName: SideOfStreet )
• SideOfLot ( type: esriFieldTypeString, alias: Side Of Lot, editable: true, nullable: true, length: 16, defaultValue: null, modelName: SideOfLot )
• RoadExcavationArea ( type: esriFieldTypeString, alias: Road Excavation Area, editable: true, nullable: true, length: 254, defaultValue: null, modelName: RoadExcavationArea )
• TicketCompletedBy ( type: esriFieldTypeString, alias: Ticket Completed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TicketCompletedBy , Coded Values: [Russell Jackson: Russell Jackson] , [Travis Warren: Travis Warren] , [Shawn Jorgensen: Shawn Jorgensen] , ...2 more... )
• TicketResolution ( type: esriFieldTypeString, alias: Ticket Resolution, editable: true, nullable: true, length: 50, defaultValue: Marked, modelName: TicketResolution , Coded Values: [Canceled: Ticket Canceled] , [Not Marked: Ticket Not Marked (Why Not Marked In Notes)] , [Out Of Area: Ticket Not In Our Area] , ...23 more... )
• CompletionNotes ( type: esriFieldTypeString, alias: Completion Notes, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CompletionNotes )
• Images ( type: esriFieldTypeString, alias: Images, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Images )
• TicketCompletionDate ( type: esriFieldTypeDate, alias: Ticket Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TicketCompletionDate )
• IsCompleted ( type: esriFieldTypeString, alias: Is Completed, editable: true, nullable: true, length: 10, defaultValue: No, modelName: IsCompleted , Coded Values: [Yes: Yes] , [No: No] )
• HoursSpentOnJobHours ( type: esriFieldTypeDouble, alias: Hours Spent On Job Hours, editable: true, nullable: true, defaultValue: null, modelName: HoursSpentOnJobHours )
• LinkedFiles ( type: esriFieldTypeString, alias: Linked Files, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LinkedFiles )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• UtilitiesNotMarked ( type: esriFieldTypeString, alias: Utilities Not Marked?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: UtilitiesNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• TVNotMarked ( type: esriFieldTypeString, alias: TV Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: TVNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• WaterNotMarked ( type: esriFieldTypeString, alias: Water Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: WaterNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• FiberNotMarked ( type: esriFieldTypeString, alias: Fiber Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: FiberNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• IrrigationNotMarked ( type: esriFieldTypeString, alias: Irrigation Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: IrrigationNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• PINotMarked ( type: esriFieldTypeString, alias: PI Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: PINotMarked , Coded Values: [Yes: Yes] , [No: No] )
• PowerNotMarked ( type: esriFieldTypeString, alias: Power Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: PowerNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• SewerNotMarked ( type: esriFieldTypeString, alias: Sewer Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: SewerNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• StormwaterNotMarked ( type: esriFieldTypeString, alias: Stormwater Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: StormwaterNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• PrivateGasNotMarked ( type: esriFieldTypeString, alias: Private Gas Not Marked, editable: true, nullable: true, length: 10, defaultValue: No, modelName: PrivateGasNotMarked , Coded Values: [Yes: Yes] , [No: No] )
• Demographic ( type: esriFieldTypeString, alias: Demographic, editable: true, nullable: true, length: 100, defaultValue: Development, modelName: Demographic , Coded Values: [Development: Development] , [Residential: Residential] , [Commercial: Commercial] )
• InspectorEmail ( type: esriFieldTypeString, alias: Inspector Email, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: InspectorEmail )
• 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 )

Templates:

• Name: Blue Stakes Tickets Historical
  Description:
  Prototype:
  Demographic: Development
  InspectorEmail: null
  TicketNumber: null
  Revision: null
  TicketType: null
  Priority: null
  Category: null
  Lookup: null
  Header: null
  TakenDate: null
  SubmittedDate: null
  LegalDate: null
  Operator: null
  DoneFor: null
  Channel: null
  CompanyName: null
  CompanyPhone: null
  CompanyAddress1: null
  CompanyAddress2: null
  Caller: null
  CallerType: null
  CallerPhone: null
  CallerEmail: null
  State: null
  County: null
  Place: null
  Subdivision: null
  FromAddress: null
  ToAddress: null
  Street: null
  CrossStreet1: null
  CrossStreet2: null
  Latitude: null
  Longitude: null
  WorkType: null
  FieldContact: null
  UpdateByDate: null
  GoodThruDate: null
  Lot: null
  TakenSource: null
  TakenVersion: null
  Boring: null
  Blasting: null
  Meet: null
  Emergency: null
  DiggingInRoad: null
  Location: null
  Remarks: null
  SideOfStreet: null
  SideOfLot: null
  RoadExcavationArea: null
  TicketCompletedBy: null
  TicketResolution: Marked
  CompletionNotes: null
  Images: null
  TicketCompletionDate: null
  IsCompleted: No
  HoursSpentOnJobHours: null
  LinkedFiles: null
  PrivateGasNotMarked: No
  UtilitiesNotMarked: No
  TVNotMarked: No
  WaterNotMarked: No
  FiberNotMarked: No
  IrrigationNotMarked: No
  PINotMarked: No
  PowerNotMarked: No
  SewerNotMarked: No
  StormwaterNotMarked: No
  
  Drawing Tool: esriFeatureEditToolPoint

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

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

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata