ArcGIS REST Services Directory
Login
Home
>
services
>
Hosted
>
workflow_baa891aed38b4b85b72ad4caa8065261_ViewLayer (FeatureServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (Hosted/workflow_baa891aed38b4b85b72ad4caa8065261_ViewLayer)
Layers:
Layer:
jobPOI
(0)
Name:
jobPOI
Display Field:
job_id
Type:
Feature Layer
Geometry Type:
esriGeometryMultipoint
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[0, 163, 46, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
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: 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:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: job_id )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobPOI
Description:
Prototype:
job_id:
null
Drawing Tool: esriFeatureEditToolPoint
Layer:
jobLOI
(1)
Name:
jobLOI
Display Field:
job_id
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[163, 0, 95, 255]
Width:
1
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: 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:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: job_id )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
SHAPE__Length
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
Templates:
Name: jobLOI
Description:
Prototype:
job_id:
null
Drawing Tool: esriFeatureEditToolLine
Layer:
jobAOI
(2)
Name:
jobAOI
Display Field:
job_id
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[196, 245, 218, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
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: 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:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: job_id )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
SHAPE__Length
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
SHAPE__Area
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
Templates:
Name: jobAOI
Description:
Prototype:
job_id:
null
Drawing Tool: esriFeatureEditToolPolygon
Layer:
jobLocations
(3)
Name:
jobLocations
Display Field:
job_id
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[210, 247, 221, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
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: 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:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: job_id )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
SHAPE__Length
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
SHAPE__Area
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
Templates:
Name: jobLocations
Description:
Prototype:
job_id:
null
Drawing Tool: esriFeatureEditToolPolygon
Layer:
v_job_search
(24)
Name:
v_job_search
Display Field:
job_name
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[222, 41, 0, 64]
Outline:
Style:
esriSLSSolid
Color:
[222, 41, 0, 255]
Width:
1
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: 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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
job_id
( nullable: false, editable: false, defaultValue: null, length: 50, alias: jobId, type: esriFieldTypeString )
job_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobName, type: esriFieldTypeString )
parent_job
( nullable: true, editable: false, defaultValue: null, length: 50, alias: parentName, type: esriFieldTypeString )
description
( nullable: true, editable: false, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
notes
( nullable: true, editable: false, defaultValue: null, length: 5000, alias: notes, type: esriFieldTypeString )
owned_by
( nullable: true, editable: false, defaultValue: null, length: 200, alias: ownedBy, type: esriFieldTypeString )
created_by
( nullable: true, editable: false, defaultValue: null, length: 200, alias: createdBy, type: esriFieldTypeString )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: createdDate, type: esriFieldTypeDate )
start_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: startDate, type: esriFieldTypeDate )
started_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: startedDate, type: esriFieldTypeDate )
due_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: dueDate, type: esriFieldTypeDate )
end_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: endDate, type: esriFieldTypeDate )
percent_complete
( nullable: true, editable: false, defaultValue: null, alias: percentComplete, type: esriFieldTypeDouble )
priority_rank
( nullable: true, editable: false, defaultValue: null, alias: priorityRank, type: esriFieldTypeSmallInteger )
priority
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobPriority, type: esriFieldTypeString )
job_status
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobStatus, type: esriFieldTypeString )
diagram
( nullable: true, editable: false, defaultValue: null, length: 200, alias: diagramId, type: esriFieldTypeString )
diagram_version
( nullable: true, editable: false, defaultValue: null, alias: diagramVersion, type: esriFieldTypeInteger )
job_template_id
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobTemplateId, type: esriFieldTypeString )
closed
( nullable: false, editable: false, defaultValue: 0, alias: closed, type: esriFieldTypeSmallInteger ,
Coded Values:
[0: No] , [1: Yes] )
active_versions
( nullable: true, editable: false, defaultValue: null, length: 10000, alias: activeVersions, type: esriFieldTypeString )
job_template_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobTemplateName, type: esriFieldTypeString )
current_step_id
( nullable: false, editable: false, defaultValue: null, length: 50, alias: currentStepID, type: esriFieldTypeString )
current_step
( nullable: false, editable: false, defaultValue: null, length: 2147483647, alias: currentStep, type: esriFieldTypeString )
assigned_to
( nullable: true, editable: false, defaultValue: null, length: 500, alias: assignedTo, type: esriFieldTypeString )
assigned_type
( nullable: false, editable: false, defaultValue: null, length: 50, alias: assignedType, type: esriFieldTypeString )
has_location
( nullable: true, editable: false, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: has_location, alias: hasLocation ,
Coded Values:
[0: No] , [1: Yes] )
parent_job_ref_id
( nullable: true, editable: true, defaultValue: null, length: 200, alias: parentJobRefId, type: esriFieldTypeString )
SHAPE__Area
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
SHAPE__Length
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
Layer:
v_jobAOI
(25)
Name:
v_jobAOI
Display Field:
job_id
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[222, 41, 0, 64]
Outline:
Style:
esriSLSSolid
Color:
[222, 41, 0, 255]
Width:
1
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: 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:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: objectid )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobId, type: esriFieldTypeString )
job_name
( nullable: true, editable: true, defaultValue: null, length: 200, alias: jobName, type: esriFieldTypeString )
parent_job
( nullable: true, editable: true, defaultValue: null, length: 50, alias: parentJob, type: esriFieldTypeString )
description
( nullable: true, editable: true, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
notes
( nullable: true, editable: true, defaultValue: null, length: 5000, alias: notes, type: esriFieldTypeString )
owned_by
( nullable: true, editable: true, defaultValue: null, length: 200, alias: ownedBy, type: esriFieldTypeString )
created_by
( nullable: true, editable: true, defaultValue: null, length: 200, alias: createdBy, type: esriFieldTypeString )
created_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: createdDate, type: esriFieldTypeDate )
start_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: startDate, type: esriFieldTypeDate )
started_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: startedDate, type: esriFieldTypeDate )
due_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: dueDate, type: esriFieldTypeDate )
end_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: endDate, type: esriFieldTypeDate )
percent_complete
( nullable: true, editable: true, defaultValue: null, alias: percentComplete, type: esriFieldTypeDouble )
priority_rank
( nullable: true, editable: true, defaultValue: null, alias: priorityRank, type: esriFieldTypeSmallInteger )
job_status
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobStatus, type: esriFieldTypeString )
diagram
( nullable: true, editable: true, defaultValue: null, length: 200, alias: diagram, type: esriFieldTypeString )
diagram_version
( nullable: true, editable: true, defaultValue: null, alias: diagramVersion, type: esriFieldTypeInteger )
job_template_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobTemplateId, type: esriFieldTypeString )
closed
( nullable: false, editable: true, defaultValue: 0, alias: closed, type: esriFieldTypeSmallInteger ,
Coded Values:
[0: No] , [1: Yes] )
active_versions
( nullable: true, editable: true, defaultValue: null, length: 10000, alias: activeVersions, type: esriFieldTypeString )
parent_job_ref_id
( nullable: true, editable: true, defaultValue: null, length: 200, alias: parentJobRefId, type: esriFieldTypeString )
SHAPE__Area
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
SHAPE__Length
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
Layer:
v_jobPOI
(26)
Name:
v_jobPOI
Display Field:
job_id
Type:
Feature Layer
Geometry Type:
esriGeometryMultipoint
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[222, 41, 0, 64]
Size:
6.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[222, 41, 0, 255]
Width:
1
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: 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:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: objectid )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobId, type: esriFieldTypeString )
job_name
( nullable: true, editable: true, defaultValue: null, length: 200, alias: jobName, type: esriFieldTypeString )
parent_job
( nullable: true, editable: true, defaultValue: null, length: 50, alias: parentJob, type: esriFieldTypeString )
description
( nullable: true, editable: true, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
notes
( nullable: true, editable: true, defaultValue: null, length: 5000, alias: notes, type: esriFieldTypeString )
owned_by
( nullable: true, editable: true, defaultValue: null, length: 200, alias: ownedBy, type: esriFieldTypeString )
created_by
( nullable: true, editable: true, defaultValue: null, length: 200, alias: createdBy, type: esriFieldTypeString )
created_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: createdDate, type: esriFieldTypeDate )
start_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: startDate, type: esriFieldTypeDate )
started_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: startedDate, type: esriFieldTypeDate )
due_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: dueDate, type: esriFieldTypeDate )
end_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: endDate, type: esriFieldTypeDate )
percent_complete
( nullable: true, editable: true, defaultValue: null, alias: percentComplete, type: esriFieldTypeDouble )
priority_rank
( nullable: true, editable: true, defaultValue: null, alias: priorityRank, type: esriFieldTypeSmallInteger )
job_status
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobStatus, type: esriFieldTypeString )
diagram
( nullable: true, editable: true, defaultValue: null, length: 200, alias: diagram, type: esriFieldTypeString )
diagram_version
( nullable: true, editable: true, defaultValue: null, alias: diagramVersion, type: esriFieldTypeInteger )
job_template_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobTemplateId, type: esriFieldTypeString )
closed
( nullable: false, editable: true, defaultValue: 0, alias: closed, type: esriFieldTypeSmallInteger ,
Coded Values:
[0: No] , [1: Yes] )
active_versions
( nullable: true, editable: true, defaultValue: null, length: 10000, alias: activeVersions, type: esriFieldTypeString )
parent_job_ref_id
( nullable: true, editable: true, defaultValue: null, length: 200, alias: parentJobRefId, type: esriFieldTypeString )
Layer:
v_jobLOI
(27)
Name:
v_jobLOI
Display Field:
job_id
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[222, 41, 0, 127]
Width:
2
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: 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:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: objectid )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobId, type: esriFieldTypeString )
job_name
( nullable: true, editable: true, defaultValue: null, length: 200, alias: jobName, type: esriFieldTypeString )
parent_job
( nullable: true, editable: true, defaultValue: null, length: 50, alias: parentJob, type: esriFieldTypeString )
description
( nullable: true, editable: true, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
notes
( nullable: true, editable: true, defaultValue: null, length: 5000, alias: notes, type: esriFieldTypeString )
owned_by
( nullable: true, editable: true, defaultValue: null, length: 200, alias: ownedBy, type: esriFieldTypeString )
created_by
( nullable: true, editable: true, defaultValue: null, length: 200, alias: createdBy, type: esriFieldTypeString )
created_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: createdDate, type: esriFieldTypeDate )
start_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: startDate, type: esriFieldTypeDate )
started_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: startedDate, type: esriFieldTypeDate )
due_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: dueDate, type: esriFieldTypeDate )
end_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: endDate, type: esriFieldTypeDate )
percent_complete
( nullable: true, editable: true, defaultValue: null, alias: percentComplete, type: esriFieldTypeDouble )
priority_rank
( nullable: true, editable: true, defaultValue: null, alias: priorityRank, type: esriFieldTypeSmallInteger )
job_status
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobStatus, type: esriFieldTypeString )
diagram
( nullable: true, editable: true, defaultValue: null, length: 200, alias: diagram, type: esriFieldTypeString )
diagram_version
( nullable: true, editable: true, defaultValue: null, alias: diagramVersion, type: esriFieldTypeInteger )
job_template_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: jobTemplateId, type: esriFieldTypeString )
closed
( nullable: false, editable: true, defaultValue: 0, alias: closed, type: esriFieldTypeSmallInteger ,
Coded Values:
[0: No] , [1: Yes] )
active_versions
( nullable: true, editable: true, defaultValue: null, length: 10000, alias: activeVersions, type: esriFieldTypeString )
parent_job_ref_id
( nullable: true, editable: true, defaultValue: null, length: 200, alias: parentJobRefId, type: esriFieldTypeString )
SHAPE__Length
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
Layer:
v_job_search_ext
(39)
Name:
v_job_search_ext
Display Field:
job_name
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
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
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[222, 41, 0, 64]
Outline:
Style:
esriSLSSolid
Color:
[222, 41, 0, 255]
Width:
1
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: 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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
job_id
( nullable: false, editable: false, defaultValue: null, length: 50, alias: jobId, type: esriFieldTypeString )
job_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobName, type: esriFieldTypeString )
parent_job
( nullable: true, editable: false, defaultValue: null, length: 50, alias: parentName, type: esriFieldTypeString )
description
( nullable: true, editable: false, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
notes
( nullable: true, editable: false, defaultValue: null, length: 5000, alias: notes, type: esriFieldTypeString )
owned_by
( nullable: true, editable: false, defaultValue: null, length: 200, alias: ownedBy, type: esriFieldTypeString )
created_by
( nullable: true, editable: false, defaultValue: null, length: 200, alias: createdBy, type: esriFieldTypeString )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: createdDate, type: esriFieldTypeDate )
start_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: startDate, type: esriFieldTypeDate )
started_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: startedDate, type: esriFieldTypeDate )
due_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: dueDate, type: esriFieldTypeDate )
end_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: endDate, type: esriFieldTypeDate )
percent_complete
( nullable: true, editable: false, defaultValue: null, alias: percentComplete, type: esriFieldTypeDouble )
priority_rank
( nullable: true, editable: false, defaultValue: null, alias: priorityRank, type: esriFieldTypeSmallInteger )
priority
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobPriority, type: esriFieldTypeString )
job_status
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobStatus, type: esriFieldTypeString )
diagram
( nullable: true, editable: false, defaultValue: null, length: 200, alias: diagramId, type: esriFieldTypeString )
diagram_version
( nullable: true, editable: false, defaultValue: null, alias: diagramVersion, type: esriFieldTypeInteger )
job_template_id
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobTemplateId, type: esriFieldTypeString )
closed
( nullable: false, editable: false, defaultValue: 0, alias: closed, type: esriFieldTypeSmallInteger ,
Coded Values:
[0: No] , [1: Yes] )
active_versions
( nullable: true, editable: false, defaultValue: null, length: 10000, alias: activeVersions, type: esriFieldTypeString )
job_template_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobTemplateName, type: esriFieldTypeString )
current_step_id
( nullable: false, editable: false, defaultValue: null, length: 50, alias: currentStepID, type: esriFieldTypeString )
current_step
( nullable: false, editable: false, defaultValue: null, length: 2147483647, alias: currentStep, type: esriFieldTypeString )
assigned_to
( nullable: true, editable: false, defaultValue: null, length: 500, alias: assignedTo, type: esriFieldTypeString )
assigned_type
( nullable: false, editable: false, defaultValue: null, length: 50, alias: assignedType, type: esriFieldTypeString )
has_location
( nullable: true, editable: false, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: has_location, alias: hasLocation ,
Coded Values:
[0: No] , [1: Yes] )
parent_job_ref_id
( nullable: true, editable: true, defaultValue: null, length: 200, alias: parentJobRefId, type: esriFieldTypeString )
SHAPE__Area
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
SHAPE__Length
( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
eyxng2dslquw3jrv9cwhnlw_globalid
( nullable: true, editable: true, defaultValue: null, length: 100, alias: request.globalid, type: esriFieldTypeString )
ebaa891aed_9f810fda2f3549aab123818fe06eff07_approvedaddress
( nullable: true, editable: true, defaultValue: null, length: 100, alias: final.approvedaddress, type: esriFieldTypeString )
ebaa891aed_9f810fda2f3549aab123818fe06eff07_requestor
( nullable: true, editable: true, defaultValue: null, length: 100, alias: final.requestor, type: esriFieldTypeString )
ebaa891aed_9f810fda2f3549aab123818fe06eff07_siteinfo
( nullable: true, editable: true, defaultValue: null, length: 100, alias: final.siteinfo, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_premise_desc
( nullable: true, editable: true, defaultValue: null, length: 255, alias: requestdetails.premise_desc, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_requestor
( nullable: true, editable: true, defaultValue: null, length: 100, alias: requestdetails.requestor, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_requestortype
( nullable: true, editable: true, defaultValue: null, length: 20, alias: requestdetails.requestortype, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_email
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.email, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_phone
( nullable: true, editable: true, defaultValue: null, length: 20, alias: requestdetails.phone, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_request_lot
( nullable: true, editable: true, defaultValue: null, length: 255, alias: requestdetails.request_lot, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_requesttype
( nullable: true, editable: true, defaultValue: null, length: 10, alias: requestdetails.requesttype, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_walkin
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.walkin, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_premise_propertyid
( nullable: true, editable: true, defaultValue: null, length: 255, alias: requestdetails.premise_propertyid, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_propid
( nullable: true, editable: true, defaultValue: null, length: 20, alias: requestdetails.propid, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_legal
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.legal, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_lot
( nullable: true, editable: true, defaultValue: null, length: 10, alias: requestdetails.lot, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_block
( nullable: true, editable: true, defaultValue: null, length: 10, alias: requestdetails.block, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_subdivision
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.subdivision, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_addinfo
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.addinfo, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_nearstreet
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.nearstreet, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_intersection
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.intersection, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_surveyglobalid
( nullable: true, editable: true, defaultValue: null, length: 60, alias: requestdetails.surveyglobalid, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_countyname
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.countyname, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_premise_entrytype
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.premise_entrytype, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_region
( nullable: true, editable: true, defaultValue: null, length: 50, alias: requestdetails.region, type: esriFieldTypeString )
etglnmfzotlcdplegmingwq_premise_intersection
( nullable: true, editable: true, defaultValue: null, length: 255, alias: requestdetails.premise_intersection, type: esriFieldTypeString )
Tables:
Table:
diagrams
(4)
Name:
diagrams
Display Field:
diagram_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
diagram_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: diagramId, alias: diagramId )
diagram_version
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: diagramVersion, alias: diagramVersion )
diagram_details
( nullable: true, editable: true, defaultValue: null, length: 1000000, type: esriFieldTypeString, modelName: diagram, alias: diagram )
description
( nullable: true, editable: true, defaultValue: null, length: 500, type: esriFieldTypeString, modelName: description, alias: description )
diagram_name
( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: diagramName, alias: diagramName )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: diagrams
Description:
Prototype:
diagram_id:
null
diagram_version:
null
diagram_details:
null
diagram_name:
null
description:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobAttachments
(5)
Name:
jobAttachments
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
true
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: job_id )
alias
( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: alias, alias: alias )
attachment_uri
( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: attachment_uri, alias: attachment_uri )
folder
( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: folder, alias: folder )
last_modified_by
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: last_modified_by, alias: last_modified_by )
last_modified
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_modified, alias: last_modified )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
globalid
( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )
Templates:
Name: jobAttachments
Description:
Prototype:
folder:
null
job_id:
null
alias:
null
last_modified_by:
null
last_modified:
null
attachment_uri:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobComments
(7)
Name:
jobComments
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: job_id )
comment_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: comment_id, alias: comment_id )
comment
( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: comment, alias: comment )
last_modified_by
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: last_modified_by, alias: last_modified_by )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobComments
Description:
Prototype:
job_id:
null
comment:
null
last_modified_by:
null
comment_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobExtPropertyDefinitions
(8)
Name:
jobExtPropertyDefinitions
Display Field:
property_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
table_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: table_id, alias: table_id )
property_name
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: property_name, alias: property_name )
property_alias
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: property_alias, alias: property_alias )
property_order
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: property_order, alias: property_order )
description
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeBlob, modelName: description, alias: description )
data_type
( nullable: true, editable: true, defaultValue: -1, type: esriFieldTypeSmallInteger, modelName: data_type, alias: data_type ,
Coded Values:
[0: FieldTypeSmallInteger] , [-1: FieldTypeUnknown] , [3: FieldTypeGUID]
, ...4 more...
)
default_value
( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: default_value, alias: default_value )
field_length
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: field_length, alias: field_length )
editable
( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: editable, alias: editable ,
Coded Values:
[0: No] , [1: Yes] )
required
( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: required, alias: required ,
Coded Values:
[0: No] , [1: Yes] )
visible
( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: visible, alias: visible ,
Coded Values:
[0: No] , [1: Yes] )
updated_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: updated_date, alias: updated_date )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobExtPropertyDefinitions
Description:
Prototype:
visible:
0
property_order:
null
editable:
0
data_type:
-1
description:
null
default_value:
null
field_length:
null
updated_date:
null
table_id:
null
required:
0
property_name:
null
property_alias:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobExtPropertyTableDefinitions
(9)
Name:
jobExtPropertyTableDefinitions
Display Field:
table_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
table_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: table_id, alias: table_id )
table_name
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: table_name, alias: table_name )
table_alias
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: table_alias, alias: table_alias )
relationship_type
( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: relationship_type, alias: relationship_type ,
Coded Values:
[1: One To Many] , [0: One To One] )
url
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: url, alias: url )
searchable
( nullable: true, editable: true, defaultValue: 1, type: esriFieldTypeSmallInteger, modelName: searchable, alias: searchable ,
Coded Values:
[0: No] , [1: Yes] )
external_url
( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: external_url, alias: external_url )
secure
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: secure, alias: secure ,
Coded Values:
[0: No] , [1: Yes] )
item_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: item_id, alias: item_id )
item_type
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: item_type, alias: itemType )
layer_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: layer_id, alias: layer_id )
portal_type
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: portal_type, alias: portal_type )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobExtPropertyTableDefinitions
Description:
Prototype:
external_url:
null
layer_id:
null
relationship_type:
0
item_id:
null
item_type:
null
portal_type:
null
table_id:
null
secure:
null
table_name:
null
table_alias:
null
url:
null
searchable:
1
Drawing Tool: esriFeatureEditToolNone
Table:
jobHistory
(10)
Name:
jobHistory
Display Field:
username
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: job_id )
action
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: action, alias: action )
username
( nullable: true, editable: true, defaultValue: null, length: 500, type: esriFieldTypeString, modelName: username, alias: username )
start_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: start_date, alias: start_date )
end_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: end_date, alias: end_date )
step_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: step_id, alias: step_id )
duration
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: duration, alias: duration )
result
( nullable: true, editable: true, defaultValue: null, length: 250, type: esriFieldTypeString, modelName: result, alias: result )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobHistory
Description:
Prototype:
result:
null
duration:
null
end_date:
null
job_id:
null
action:
null
step_id:
null
username:
null
start_date:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobHolds
(11)
Name:
jobHolds
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: false, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_id, alias: jobId )
step_id
( nullable: false, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: step_id, alias: stepId )
hold_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: hold_id, alias: holdId )
set_by
( nullable: true, editable: true, defaultValue: null, length: 500, type: esriFieldTypeString, modelName: set_by, alias: setBy )
set_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: set_date, alias: setDate )
scheduled_release
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: scheduled_release, alias: scheduledRelease )
released_by
( nullable: true, editable: true, defaultValue: null, length: 500, type: esriFieldTypeString, modelName: released_by, alias: releasedBy )
released_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: released_date, alias: releasedDate )
dependent_job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: dependent_job_id, alias: dependentJobId )
dependent_step_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: dependent_step_id, alias: dependentStepId )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobHolds
Description:
Prototype:
set_date:
null
job_id:
set_by:
null
released_by:
null
dependent_job_id:
null
hold_id:
null
dependent_step_id:
null
step_id:
released_date:
null
scheduled_release:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobProgress
(12)
Name:
jobProgress
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: jobId, alias: jobId )
step_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: stepId, alias: stepId )
step_assigned_to
( nullable: true, editable: true, defaultValue: null, length: 500, type: esriFieldTypeString, modelName: stepAssignedTo, alias: stepAssignedTo )
step_assigned_type
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: stepAssignedType, alias: stepAssignedType )
step_action
( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: stepAction, alias: stepAction )
step_details
( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: stepDetails, alias: stepDetails )
step_output
( nullable: true, editable: true, defaultValue: null, length: 1000000, type: esriFieldTypeString, modelName: step_output, alias: stepOutput )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobProgress
Description:
Prototype:
step_assigned_type:
null
job_id:
null
step_output:
null
step_id:
null
step_details:
null
step_assigned_to:
null
step_action:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobs
(13)
Name:
jobs
Display Field:
job_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: jobId, alias: jobId )
job_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: jobName, alias: jobName )
parent_job
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: parent_job, alias: parent_job )
description
( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: description, alias: description )
notes
( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: notes, alias: notes )
owned_by
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: ownedBy, alias: ownedBy )
created_by
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: createdBy, alias: createdBy )
start_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: start_date, alias: start_date )
started_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: started_date, alias: started_date )
due_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: due_date, alias: due_date )
end_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: end_date, alias: end_date )
percent_complete
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: percentComplete, alias: percentComplete )
priority_rank
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: priorityRank, alias: priorityRank )
job_status
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: jobStatus, alias: jobStatus )
diagram
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: diagram, alias: diagram )
diagram_version
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: diagramVersion, alias: diagramVersion )
job_template_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: featureLayerSchemaId, alias: jobTemplateId )
closed
( nullable: false, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: closed, alias: closed ,
Coded Values:
[0: No] , [1: Yes] )
active_versions
( nullable: true, editable: true, defaultValue: null, length: 10000, type: esriFieldTypeString, modelName: activeVersions, alias: active_versions )
has_location
( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: has_location, alias: hasLocation ,
Coded Values:
[0: No] , [1: Yes] )
parent_job_ref_id
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: parent_job_ref_id, alias: parentJobRefId )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobs
Description:
Prototype:
end_date:
null
priority_rank:
null
notes:
null
parent_job:
null
due_date:
null
description:
null
owned_by:
null
parent_job_ref_id:
null
started_date:
null
created_by:
null
job_template_id:
null
percent_complete:
null
active_versions:
null
diagram:
null
job_status:
null
diagram_version:
null
job_name:
null
job_id:
null
closed:
0
has_location:
0
start_date:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobTemplateAutomatedCreation
(14)
Name:
jobTemplateAutomatedCreation
Display Field:
automation_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
automation_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: automation_id, alias: automationId )
automation_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: automation_name, alias: automationName )
automation_type
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: automation_type, alias: automationType )
job_template_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_template_id, alias: jobTemplateId )
associated_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: associated_id, alias: associatedId )
created_by
( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_by, alias: createdBy )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobTemplateAutomatedCreation
Description:
Prototype:
automation_id:
null
associated_id:
null
automation_type:
null
created_by:
null
automation_name:
null
job_template_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobTemplates
(15)
Name:
jobTemplates
Display Field:
job_template_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
default_status
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: default_status, alias: defaultStatus )
job_template_id
( nullable: false, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_template_id, alias: jobTemplateId )
job_template_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: job_template_name, alias: jobTemplateName )
default_assigned_to
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: defaultAssignedTo, alias: defaultAssignedTo )
default_assigned_type
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: defaultAssignedType, alias: defaultAssignedType )
default_description
( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: defaultDescription, alias: defaultDescription )
default_due_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: defaultDueDate, alias: defaultDueDate )
default_job_duration
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: defaultJobDuration, alias: defaultJobDuration )
default_priority_rank
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: defaultPriorityRank, alias: defaultPriorityRank )
default_start_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: defaultStartDate, alias: defaultStartDate )
job_start_date_type
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_start_date_type, alias: jobStartDateType )
description
( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: description, alias: description )
category
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: category, alias: category )
diagram_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: diagramId, alias: diagramId )
state
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: state, alias: state )
activities
( nullable: true, editable: true, defaultValue: null, length: 1000000, type: esriFieldTypeString, modelName: activities, alias: activities )
default_final_status
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: default_final_status, alias: defaultFinalStatus )
default_job_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: default_job_name, alias: defaultJobName )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobTemplates
Description:
Prototype:
diagram_id:
null
default_assigned_type:
null
default_priority_rank:
null
default_status:
null
default_assigned_to:
null
description:
null
default_job_name:
null
job_template_id:
job_template_name:
null
default_due_date:
null
default_final_status:
null
default_start_date:
null
default_job_duration:
null
activities:
null
default_description:
null
state:
null
category:
null
job_start_date_type:
null
Drawing Tool: esriFeatureEditToolNone
Table:
jobTemplatesToExtPropertyTableDefXref
(16)
Name:
jobTemplatesToExtPropertyTableDefXref
Display Field:
table_id
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
table_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: table_id, alias: table_id )
table_order
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: table_order, alias: table_order )
job_template_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: job_template_id, alias: job_template_id )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: jobTemplatesToExtPropertyTableDefXref
Description:
Prototype:
table_order:
null
table_id:
null
job_template_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
lookups
(17)
Name:
lookups
Display Field:
lookup_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
lookup_type
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: lookup_type, alias: lookupType )
lookup_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: lookup_name, alias: lookupName )
value
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: value, alias: value )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: lookups
Description:
Prototype:
lookup_name:
null
lookup_type:
null
value:
null
Drawing Tool: esriFeatureEditToolNone
Table:
roleGroups
(18)
Name:
roleGroups
Display Field:
role_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
role_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: roleName, alias: role_name )
group_id
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: group_id, alias: group_id )
group_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: groupName, alias: groupName )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: roleGroups
Description:
Prototype:
role_name:
null
group_name:
null
group_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
roles
(19)
Name:
roles
Display Field:
role_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
role_name
( nullable: false, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: roleName, alias: roleName )
description
( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: description, alias: description )
privileges
( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: privileges, alias: privileges )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: roles
Description:
Prototype:
role_name:
privileges:
null
description:
null
Drawing Tool: esriFeatureEditToolNone
Table:
searches
(20)
Name:
searches
Display Field:
search_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
search_id
( nullable: false, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: search_id, alias: search_id )
search_name
( nullable: false, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: search_name, alias: search_name )
folder_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: folder_name, alias: folder_name )
definition
( nullable: true, editable: true, defaultValue: null, length: 10000, type: esriFieldTypeString, modelName: definition, alias: definition )
search_type
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: search_type, alias: searchType )
color_ramp
( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: color_ramp, alias: colorRamp )
sort_index
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: sort_index, alias: sortIndex )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: searches
Description:
Prototype:
color_ramp:
null
definition:
null
sort_index:
null
search_name:
folder_name:
null
search_type:
null
search_id:
Drawing Tool: esriFeatureEditToolNone
Table:
settings
(21)
Name:
settings
Display Field:
prop_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
encrypted
( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: encrypted, alias: encrypted ,
Coded Values:
[0: No] , [1: Yes] )
prop_name
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: prop_name, alias: propName )
value
( nullable: true, editable: true, defaultValue: null, length: 1000, type: esriFieldTypeString, modelName: value, alias: value )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: settings
Description:
Prototype:
prop_name:
null
encrypted:
null
value:
null
Drawing Tool: esriFeatureEditToolNone
Table:
shareRelationships
(22)
Name:
shareRelationships
Display Field:
item
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
item
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: item, alias: item )
shared_with
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: shared_with, alias: sharedWith )
type
( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: type, alias: type )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: shareRelationships
Description:
Prototype:
shared_with:
null
item:
null
type:
null
Drawing Tool: esriFeatureEditToolNone
Table:
templates
(23)
Name:
templates
Display Field:
template_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
template_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: template_id, alias: templateId )
template_type
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: template_type, alias: templateType )
template_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: template_name, alias: templateName )
template_details
( nullable: true, editable: true, defaultValue: null, length: 1000000, type: esriFieldTypeString, modelName: template_details, alias: templateDetails )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
Name: templates
Description:
Prototype:
template_name:
null
template_details:
null
template_id:
null
template_type:
null
Drawing Tool: esriFeatureEditToolNone
Table:
v_jobs
(28)
Name:
v_jobs
Display Field:
job_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
job_id
( nullable: false, editable: false, defaultValue: null, length: 50, alias: jobId, type: esriFieldTypeString )
job_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobName, type: esriFieldTypeString )
parent_job
( nullable: true, editable: false, defaultValue: null, length: 50, alias: parentName, type: esriFieldTypeString )
description
( nullable: true, editable: false, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
notes
( nullable: true, editable: false, defaultValue: null, length: 5000, alias: notes, type: esriFieldTypeString )
owned_by
( nullable: true, editable: false, defaultValue: null, length: 200, alias: ownedBy, type: esriFieldTypeString )
created_by
( nullable: true, editable: false, defaultValue: null, length: 200, alias: createdBy, type: esriFieldTypeString )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: createdDate, type: esriFieldTypeDate )
start_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: startDate, type: esriFieldTypeDate )
started_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: startedDate, type: esriFieldTypeDate )
due_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: dueDate, type: esriFieldTypeDate )
end_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: endDate, type: esriFieldTypeDate )
percent_complete
( nullable: true, editable: false, defaultValue: null, alias: percentComplete, type: esriFieldTypeDouble )
priority_rank
( nullable: true, editable: false, defaultValue: null, alias: priorityRankComplete, type: esriFieldTypeSmallInteger )
job_status
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobStatus, type: esriFieldTypeString )
diagram
( nullable: true, editable: false, defaultValue: null, length: 200, alias: diagramId, type: esriFieldTypeString )
diagram_version
( nullable: true, editable: false, defaultValue: null, alias: diagramVersion, type: esriFieldTypeInteger )
job_template_id
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobTemplateId, type: esriFieldTypeString )
closed
( nullable: false, editable: false, defaultValue: 0, alias: closed, type: esriFieldTypeSmallInteger ,
Coded Values:
[0: No] , [1: Yes] )
active_versions
( nullable: true, editable: false, defaultValue: null, length: 10000, alias: activeVersions, type: esriFieldTypeString )
job_template_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobTemplateName, type: esriFieldTypeString )
has_location
( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: has_location, alias: hasLocation ,
Coded Values:
[0: No] , [1: Yes] )
parent_job_ref_id
( nullable: true, editable: true, defaultValue: null, length: 200, alias: parentJobRefId, type: esriFieldTypeString )
Table:
v_jobprogress_latest
(29)
Name:
v_jobprogress_latest
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: jobId, alias: jobId )
step_id
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: stepId, alias: stepId )
step_assigned_to
( nullable: true, editable: true, defaultValue: null, length: 500, type: esriFieldTypeString, modelName: stepAssignedTo, alias: stepAssignedTo )
step_assigned_type
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: stepAssignedType, alias: stepAssignedType )
created_date
( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: stepTimestamp, alias: createdDate )
step_action
( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: stepAction, alias: stepAction )
step_details
( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: stepDetails, alias: stepDetails )
step_output
( nullable: true, editable: true, defaultValue: null, length: 1000000, type: esriFieldTypeString, modelName: step_output, alias: stepOutput )
Table:
v_jobTemplates
(30)
Name:
v_jobTemplates
Display Field:
job_template_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
job_template_id
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobTemplateId, type: esriFieldTypeString )
default_assigned_to
( nullable: true, editable: false, defaultValue: null, length: 200, alias: defaultAssignedTo, type: esriFieldTypeString )
default_assigned_type
( nullable: true, editable: false, defaultValue: null, length: 200, alias: defaultAssignedType, type: esriFieldTypeString )
default_description
( nullable: true, editable: false, defaultValue: null, length: 2000, alias: defaultDescription, type: esriFieldTypeString )
default_due_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: defaultDueDate, type: esriFieldTypeDate )
default_job_duration
( nullable: true, editable: false, defaultValue: null, alias: defaultJobDuration, type: esriFieldTypeInteger )
default_priority_rank
( nullable: true, editable: false, defaultValue: null, alias: defaultPriorityRank, type: esriFieldTypeInteger )
default_start_date
( nullable: true, editable: true, defaultValue: null, length: 29, alias: defaultStartDate, type: esriFieldTypeDate )
job_start_date_type
( nullable: true, editable: false, defaultValue: null, length: 50, alias: jobStartDateType, type: esriFieldTypeString )
description
( nullable: true, editable: false, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
category
( nullable: true, editable: false, defaultValue: null, length: 200, alias: category, type: esriFieldTypeString )
diagram_id
( nullable: true, editable: false, defaultValue: null, length: 50, alias: diagramId, type: esriFieldTypeString )
diagram_name
( nullable: true, editable: false, defaultValue: null, length: 100, alias: diagramName, type: esriFieldTypeString )
state
( nullable: true, editable: false, defaultValue: null, length: 50, alias: state, type: esriFieldTypeString )
job_template_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: jobTemplateName, type: esriFieldTypeString )
activities
( nullable: true, editable: true, defaultValue: null, length: 1000000, type: esriFieldTypeString, modelName: activities, alias: activities )
default_final_status
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: default_final_status, alias: defaultFinalStatus )
default_status
( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: default_status, alias: defaultStatus )
default_job_name
( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: default_job_name, alias: defaultJobName )
Table:
v_roles
(31)
Name:
v_roles
Display Field:
role_name
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
role_name
( nullable: false, editable: false, defaultValue: null, length: 200, alias: roleName, type: esriFieldTypeString )
description
( nullable: true, editable: false, defaultValue: null, length: 2000, alias: description, type: esriFieldTypeString )
privileges
( nullable: true, editable: false, defaultValue: null, length: 2000, alias: privileges, type: esriFieldTypeString )
group_id
( nullable: true, editable: false, defaultValue: null, length: 200, alias: groupId, type: esriFieldTypeString )
group_name
( nullable: true, editable: false, defaultValue: null, length: 200, alias: groupName, type: esriFieldTypeString )
Table:
ext_yxnG2DSLQUW3JrV9CwHnlw
(34)
Name:
ext_yxnG2DSLQUW3JrV9CwHnlw
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Job extended property table
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: job_id, type: esriFieldTypeString )
globalid
( nullable: true, editable: true, defaultValue: null, length: 100, alias: GlobalID, type: esriFieldTypeString )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
Table:
ext_PNmVbGPnRY-CWXMcO39Rww
(36)
Name:
ext_PNmVbGPnRY-CWXMcO39Rww
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Job extended property table
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: job_id, type: esriFieldTypeString )
approvedaddress
( nullable: true, editable: true, defaultValue: null, length: 100, alias: Approved Address, type: esriFieldTypeString )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
requestor
( nullable: true, editable: true, defaultValue: null, length: 100, alias: Requestor, type: esriFieldTypeString )
siteinfo
( nullable: true, editable: true, defaultValue: null, length: 100, alias: Site Info Reference, type: esriFieldTypeString )
Table:
ext_tglnMFZoTLCDPlEGmINGwQ
(38)
Name:
ext_tglnMFZoTLCDPlEGmINGwQ
Display Field:
job_id
Type:
Table
Geometry Type:
N/A
Description:
Job extended property table
Service Item Id:
1a2f034f406f4353b59b1f19961c0b92
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
job_id
( nullable: true, editable: true, defaultValue: null, length: 50, alias: job_id, type: esriFieldTypeString )
requestor
( nullable: true, editable: true, defaultValue: null, length: 100, alias: Requestor Name, type: esriFieldTypeString )
created_user
( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user
( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date
( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
requestortype
( nullable: true, editable: true, defaultValue: null, length: 20, alias: Requestor Type, type: esriFieldTypeString )
email
( nullable: true, editable: true, defaultValue: null, length: 50, alias: Requestor Email, type: esriFieldTypeString )
phone
( nullable: true, editable: true, defaultValue: null, length: 20, alias: Requestor Phone Number, type: esriFieldTypeString )
requesttype
( nullable: true, editable: true, defaultValue: null, length: 10, alias: Request Type, type: esriFieldTypeString )
walkin
( nullable: true, editable: true, defaultValue: null, length: 50, alias: Walk in request?, type: esriFieldTypeString )
propid
( nullable: true, editable: true, defaultValue: null, length: 20, alias: OLD Request Property ID, type: esriFieldTypeString )
legal
( nullable: true, editable: true, defaultValue: null, length: 50, alias: Request Legal Desc, type: esriFieldTypeString )
lot
( nullable: true, editable: true, defaultValue: null, length: 10, alias: Archive Request Lot, type: esriFieldTypeString )
block
( nullable: true, editable: true, defaultValue: null, length: 10, alias: Request Block, type: esriFieldTypeString )
subdivision
( nullable: true, editable: true, defaultValue: null, length: 50, alias: Subdivision, type: esriFieldTypeString )
addinfo
( nullable: true, editable: true, defaultValue: null, length: 50, alias: Additional Info, type: esriFieldTypeString )
nearstreet
( nullable: true, editable: true, defaultValue: null, length: 50, alias: Nearest Street, type: esriFieldTypeString )
intersection
( nullable: true, editable: true, defaultValue: null, length: 50, alias: OLD Nearest Intersection, type: esriFieldTypeString )
surveyglobalid
( nullable: true, editable: true, defaultValue: null, length: 60, alias: Survey Globalid, type: esriFieldTypeString )
countyname
( nullable: true, editable: true, defaultValue: null, length: 50, alias: County Name, type: esriFieldTypeString )
premise_entrytype
( nullable: true, editable: true, defaultValue: null, length: 50, alias: How customer provided the address location, type: esriFieldTypeString )
region
( nullable: true, editable: true, defaultValue: null, length: 50, alias: Region, type: esriFieldTypeString )
premise_desc
( nullable: true, editable: true, defaultValue: null, length: 255, alias: More info about request, type: esriFieldTypeString )
request_lot
( nullable: true, editable: true, defaultValue: null, length: 255, alias: Request Lot, type: esriFieldTypeString )
premise_propertyid
( nullable: true, editable: true, defaultValue: null, length: 255, alias: Property ID, type: esriFieldTypeString )
premise_intersection
( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nearest Intersection, type: esriFieldTypeString )