View In:   ArcGIS Online Map Viewer

Name: csvtest_XYTableToPoint

Display Field: loggedbyname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c097fd02211843a68a0889824c50b198

Copyright Text:

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

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1251038.2101100832
YMin: 100117.07548230886
XMax: 1280253.3836349994
YMax: 131720.17041248083
Spatial Reference: 2926  (2926)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: statusname
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 10.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: Closed
  Label: Closed
  Description: N/A
  Symbol:
  
• Value: Open
  Label: Open
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:

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: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: statusname

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID )
• id ( nullable: true, editable: true, defaultValue: null, alias: ID, type: esriFieldTypeInteger )
• servicerequestid ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: ServiceRequestID, type: esriFieldTypeString )
• refid ( nullable: true, editable: true, defaultValue: null, alias: RefID, type: esriFieldTypeInteger )
• loggeddate ( nullable: true, editable: true, defaultValue: null, length: 29, alias: LoggedDate, type: esriFieldTypeDate )
• loggedbyid ( nullable: true, editable: true, defaultValue: null, alias: LoggedByID, type: esriFieldTypeInteger )
• loggedbyname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: LoggedByName, type: esriFieldTypeString )
• assigneddate ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: AssignedDate, type: esriFieldTypeString )
• assignedtoid ( nullable: true, editable: true, defaultValue: null, alias: AssignedToID, type: esriFieldTypeInteger )
• assignedtoname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: AssignedToName, type: esriFieldTypeString )
• assignedbyid ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: AssignedByID, type: esriFieldTypeString )
• notificationlist ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: NotificationList, type: esriFieldTypeString )
• assignedbyname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: AssignedByName, type: esriFieldTypeString )
• typeid ( nullable: true, editable: true, defaultValue: null, alias: TypeID, type: esriFieldTypeInteger )
• typename ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: TypeName, type: esriFieldTypeString )
• groupid ( nullable: true, editable: true, defaultValue: null, alias: GroupID, type: esriFieldTypeInteger )
• groupname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: GroupName, type: esriFieldTypeString )
• issueid ( nullable: true, editable: true, defaultValue: null, alias: IssueID, type: esriFieldTypeInteger )
• departmentid ( nullable: true, editable: true, defaultValue: null, alias: DepartmentID, type: esriFieldTypeInteger )
• departmentname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: DepartmentName, type: esriFieldTypeString )
• complaint ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Complaint, type: esriFieldTypeString )
• location ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Location, type: esriFieldTypeString )
• status ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Status, type: esriFieldTypeString )
• priorityname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: PriorityName, type: esriFieldTypeString )
• statusname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: StatusName, type: esriFieldTypeString )
• openeddate ( nullable: true, editable: true, defaultValue: null, length: 29, alias: OpenedDate, type: esriFieldTypeDate )
• resolveddate ( nullable: true, editable: true, defaultValue: null, length: 29, alias: ResolvedDate, type: esriFieldTypeDate )
• closeddate ( nullable: true, editable: true, defaultValue: null, length: 29, alias: ClosedDate, type: esriFieldTypeDate )
• closedbyid ( nullable: true, editable: true, defaultValue: null, alias: ClosedByID, type: esriFieldTypeInteger )
• closedbyname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: ClosedByName, type: esriFieldTypeString )
• duration ( nullable: true, editable: true, defaultValue: null, alias: Duration, type: esriFieldTypeInteger )
• closedduration ( nullable: true, editable: true, defaultValue: null, alias: ClosedDuration, type: esriFieldTypeInteger )
• iscomplete ( nullable: true, editable: true, defaultValue: null, alias: IsComplete, type: esriFieldTypeInteger )
• callername ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CallerName, type: esriFieldTypeString )
• callerrelation ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CallerRelation, type: esriFieldTypeString )
• calleraddress ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CallerAddress, type: esriFieldTypeString )
• callerhphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CallerHPhone, type: esriFieldTypeString )
• callerwphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CallerWPhone, type: esriFieldTypeString )
• callermphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CallerMPhone, type: esriFieldTypeString )
• calleremail ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CallerEmail, type: esriFieldTypeString )
• callerautosend ( nullable: true, editable: true, defaultValue: null, alias: CallerAutoSend, type: esriFieldTypeInteger )
• description ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Description, type: esriFieldTypeString )
• occupantname ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OccupantName, type: esriFieldTypeString )
• occupanthphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OccupantHPhone, type: esriFieldTypeString )
• occupantwphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OccupantWPhone, type: esriFieldTypeString )
• occupantmphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OccupantMPhone, type: esriFieldTypeString )
• occupantemail ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OccupantEmail, type: esriFieldTypeString )
• occupantautosend ( nullable: true, editable: true, defaultValue: null, alias: OccupantAutoSend, type: esriFieldTypeInteger )
• ownername ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OwnerName, type: esriFieldTypeString )
• ownerref ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OwnerRef, type: esriFieldTypeString )
• owneraddress ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OwnerAddress, type: esriFieldTypeString )
• ownerhphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OwnerHPhone, type: esriFieldTypeString )
• ownerwphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OwnerWPhone, type: esriFieldTypeString )
• ownermphone ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OwnerMPhone, type: esriFieldTypeString )
• owneremail ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: OwnerEmail, type: esriFieldTypeString )
• ownerautosend ( nullable: true, editable: true, defaultValue: null, alias: OwnerAutoSend, type: esriFieldTypeInteger )
• response ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Response, type: esriFieldTypeString )
• hasasset ( nullable: true, editable: true, defaultValue: null, alias: HasAsset, type: esriFieldTypeInteger )
• hasdocs ( nullable: true, editable: true, defaultValue: null, alias: HasDocs, type: esriFieldTypeInteger )
• hasnotify ( nullable: true, editable: true, defaultValue: null, alias: HasNotify, type: esriFieldTypeInteger )
• hasworkorders ( nullable: true, editable: true, defaultValue: null, alias: HasWorkOrders, type: esriFieldTypeInteger )
• layerid ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: LayerID, type: esriFieldTypeString )
• assetid ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: AssetID, type: esriFieldTypeString )
• pointx ( nullable: true, editable: true, defaultValue: null, alias: PointX, type: esriFieldTypeDouble )
• pointy ( nullable: true, editable: true, defaultValue: null, alias: PointY, type: esriFieldTypeDouble )
• latitude ( nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• spatialreference ( nullable: true, editable: true, defaultValue: null, alias: SpatialReference, type: esriFieldTypeInteger )
• watchid ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: WatchID, type: esriFieldTypeString )

Types:

ID: Closed
Name: Closed
Domains:
Templates:
• Name: Closed
  Description:
  Prototype:
  ownerautosend: null
  openeddate: null
  resolveddate: null
  callermphone: null
  issueid: null
  pointx: null
  pointy: null
  occupanthphone: null
  spatialreference: null
  notificationlist: null
  occupantmphone: null
  assignedtoid: null
  occupantemail: null
  hasasset: null
  typeid: null
  id: null
  refid: null
  ownerhphone: null
  longitude: null
  owneraddress: null
  ownerref: null
  ownername: null
  hasworkorders: null
  groupid: null
  statusname: Closed
  assignedbyid: null
  groupname: null
  assignedtoname: null
  servicerequestid: null
  calleremail: null
  callerhphone: null
  watchid: null
  departmentname: null
  ownerwphone: null
  callerrelation: null
  status: null
  owneremail: null
  iscomplete: null
  closedbyid: null
  closeddate: null
  hasdocs: null
  calleraddress: null
  latitude: null
  closedduration: null
  description: null
  occupantwphone: null
  duration: null
  layerid: null
  assigneddate: null
  callerautosend: null
  loggeddate: null
  callerwphone: null
  callername: null
  loggedbyid: null
  assignedbyname: null
  departmentid: null
  loggedbyname: null
  closedbyname: null
  hasnotify: null
  priorityname: null
  occupantautosend: null
  complaint: null
  response: null
  assetid: null
  occupantname: null
  ownermphone: null
  location: null
  typename: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open
Name: Open
Domains:
Templates:
• Name: Open
  Description:
  Prototype:
  ownerautosend: null
  openeddate: null
  resolveddate: null
  callermphone: null
  issueid: null
  pointx: null
  pointy: null
  occupanthphone: null
  spatialreference: null
  notificationlist: null
  occupantmphone: null
  assignedtoid: null
  occupantemail: null
  hasasset: null
  typeid: null
  id: null
  refid: null
  ownerhphone: null
  longitude: null
  owneraddress: null
  ownerref: null
  ownername: null
  hasworkorders: null
  groupid: null
  statusname: Open
  assignedbyid: null
  groupname: null
  assignedtoname: null
  servicerequestid: null
  calleremail: null
  callerhphone: null
  watchid: null
  departmentname: null
  ownerwphone: null
  callerrelation: null
  status: null
  owneremail: null
  iscomplete: null
  closedbyid: null
  closeddate: null
  hasdocs: null
  calleraddress: null
  latitude: null
  closedduration: null
  description: null
  occupantwphone: null
  duration: null
  layerid: null
  assigneddate: null
  callerautosend: null
  loggeddate: null
  callerwphone: null
  callername: null
  loggedbyid: null
  assignedbyname: null
  departmentid: null
  loggedbyname: null
  closedbyname: null
  hasnotify: null
  priorityname: null
  occupantautosend: null
  complaint: null
  response: null
  assetid: null
  occupantname: null
  ownermphone: null
  location: null
  typename: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata