ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
Applications
>
Sign_Structures (FeatureServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (Applications/Sign_Structures)
Layers:
Layer:
Sign Structure
(0)
Name:
Sign Structure
Display Field:
notes
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: 1132814.9866468906
YMin: 722022.9462385625
XMax: 1853513.6197218
YMax: 818834.2782060653
Spatial Reference: 103130 (6551) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[230, 0, 0, 255]
Size:
10.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
0
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
true
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
notes
( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
sy
( type: esriFieldTypeDouble, alias: sy, editable: true, nullable: true, defaultValue: null, modelName: sy )
cy
( type: esriFieldTypeDouble, alias: cy, editable: true, nullable: true, defaultValue: null, modelName: cy )
length
( type: esriFieldTypeDouble, alias: length, editable: true, nullable: true, defaultValue: null, modelName: length )
quantity
( type: esriFieldTypeInteger, alias: quantity, editable: true, nullable: true, defaultValue: null, modelName: quantity )
pay_item
( type: esriFieldTypeInteger, alias: pay_item, editable: true, nullable: true, defaultValue: null, modelName: pay_item ,
Coded Values:
[9061: 100111000 EA - MIS-56 - Riser, Street Lighting Circuit] , [9012: 100116900 EA - MIS-500 - Pole, To Be Wired, 2-Wire] , [9071: 1001C10000 LS - MIS-1 - Streetlight Lockout/Tagout]
, ...3751 more...
)
group_pay_item
( type: esriFieldTypeInteger, alias: group_pay_item, editable: true, nullable: true, defaultValue: null, modelName: group_pay_item ,
Coded Values:
[1637: EA - INSTALL NEW SIGN] , [1624: EA - RELOCATE RESIDENTIAL STREET NAME SIGN] , [1623: EA - RELOCATE WITH NEW STOP SIGN] )
favorite_pay_item
( type: esriFieldTypeInteger, alias: favorite_pay_item, editable: true, nullable: true, defaultValue: null, modelName: favorite_pay_item ,
Coded Values:
[1734: REMOVAL OF GROUND MOUNTED SIGN AND DISPOSAL] , [1733: REMOVAL OF GROUND MOUNTED SIGN AND REERECTION] , [1823: REMOVAL OF POLE MOUNTED SIGN AND DISPOSAL] )
plan_label
( type: esriFieldTypeString, alias: plan_label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: plan_label )
plan_sheet
( type: esriFieldTypeString, alias: plan_sheet, editable: true, nullable: true, length: 255, defaultValue: null, modelName: plan_sheet )
side
( type: esriFieldTypeString, alias: side, editable: true, nullable: true, length: 255, defaultValue: null, modelName: side ,
Coded Values:
[R: Right] , [L: Left] , [M: Middle] )
PayItemOrigin
( type: esriFieldTypeInteger, alias: PayItemOrigin, editable: true, nullable: true, defaultValue: null, modelName: PayItemOrigin ,
Coded Values:
[6: ADA] , [7: CIP] , [10: NEW]
, ...4 more...
)
PayItemNumber
( type: esriFieldTypeString, alias: PayItemNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PayItemNumber ,
Coded Values:
[10: 10] , [100: 100] , [1001: 1001]
, ...121 more...
)
ProjectNumber
( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectNumber )
ProjectStatus
( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectStatus )
ParticipationCodeId
( type: esriFieldTypeInteger, alias: ParticipationCodeId, editable: true, nullable: true, defaultValue: null, modelName: ParticipationCodeId ,
Coded Values:
[12: 99 - NOV] , [1: Default - Sytem Default] , [2: PC1 - COC DPS, Resurfacing]
, ...10 more...
)
ParticipationCode
( type: esriFieldTypeString, alias: ParticipationCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ParticipationCode )
pay_item_tag
( type: esriFieldTypeSmallInteger, alias: pay_item_tag, editable: true, nullable: true, defaultValue: null, modelName: pay_item_tag ,
Coded Values:
[21: ADA PAVEMENT MARKINGS] , [20: ADA SIGNS] , [25: Adjustments]
, ...9 more...
)
ProjectId
( type: esriFieldTypeString, alias: ProjectId, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectId ,
Coded Values:
[374: 374 - 530282-922023 : Resurfacing - 2023 Project 2] , [375: 375 - 530282-999999: Unassigned - ADA] , [376: 376 - 530087-100043: ADA Ramp Projects - CDBG Curb Ramps (2023)]
, ...50 more...
)
intersection_id
( type: esriFieldTypeInteger, alias: intersection_id, editable: true, nullable: true, defaultValue: null, modelName: intersection_id ,
Coded Values:
[-1: -1] , [-10: -10] , [101679: 101679]
, ...5165 more...
)
use_default_project
( type: esriFieldTypeSmallInteger, alias: use_default_project, editable: true, nullable: true, defaultValue: 1, modelName: use_default_project ,
Coded Values:
[1: Yes] , [0: No] )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
structure_size
( type: esriFieldTypeString, alias: structure_size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_size ,
Coded Values:
[12x18: 12x18] , [30x36: 30x36] )
station
( type: esriFieldTypeString, alias: station, editable: true, nullable: true, length: 20, defaultValue: null, modelName: station )
attachment
( type: esriFieldTypeBlob, alias: attachment, editable: true, nullable: true, defaultValue: null, modelName: attachment )
sign_pay_item
( type: esriFieldTypeInteger, alias: sign_pay_item, editable: true, nullable: true, defaultValue: null, modelName: sign_pay_item ,
Coded Values:
[9061: 100111000 EA - MIS-56 - Riser, Street Lighting Circuit] , [9012: 100116900 EA - MIS-500 - Pole, To Be Wired, 2-Wire] , [9071: 1001C10000 LS - MIS-1 - Streetlight Lockout/Tagout]
, ...3751 more...
)
sign_group_pay_item
( type: esriFieldTypeInteger, alias: sign_group_pay_item, editable: true, nullable: true, defaultValue: null, modelName: sign_group_pay_item ,
Coded Values:
)
sign_favorite_pay_item
( type: esriFieldTypeInteger, alias: sign_favorite_pay_item, editable: true, nullable: true, defaultValue: null, modelName: sign_favorite_pay_item ,
Coded Values:
)
sign_pay_item_origin
( type: esriFieldTypeInteger, alias: sign_pay_item_origin, editable: true, nullable: true, defaultValue: null, modelName: sign_pay_item_origin ,
Coded Values:
[6: ADA] , [7: CIP] , [10: NEW]
, ...4 more...
)
sign_pay_item_number
( type: esriFieldTypeString, alias: sign_pay_item_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_pay_item_number ,
Coded Values:
[10: 10] , [100: 100] , [1001: 1001]
, ...121 more...
)
sign_pay_item_tag
( type: esriFieldTypeSmallInteger, alias: sign_pay_item_tag, editable: true, nullable: true, defaultValue: null, modelName: sign_pay_item_tag ,
Coded Values:
[21: ADA PAVEMENT MARKINGS] , [20: ADA SIGNS] , [25: Adjustments]
, ...9 more...
)
removal_pay_item
( type: esriFieldTypeInteger, alias: removal_pay_item, editable: true, nullable: true, defaultValue: null, modelName: removal_pay_item ,
Coded Values:
[9061: 100111000 EA - MIS-56 - Riser, Street Lighting Circuit] , [9012: 100116900 EA - MIS-500 - Pole, To Be Wired, 2-Wire] , [9071: 1001C10000 LS - MIS-1 - Streetlight Lockout/Tagout]
, ...3751 more...
)
removal_group_pay_item
( type: esriFieldTypeInteger, alias: removal_group_pay_item, editable: true, nullable: true, defaultValue: null, modelName: removal_group_pay_item ,
Coded Values:
)
removal_favorite_pay_item
( type: esriFieldTypeInteger, alias: removal_favorite_pay_item, editable: true, nullable: true, defaultValue: null, modelName: removal_favorite_pay_item ,
Coded Values:
)
removal_pay_item_origin
( type: esriFieldTypeInteger, alias: removal_pay_item_origin, editable: true, nullable: true, defaultValue: null, modelName: removal_pay_item_origin ,
Coded Values:
[6: ADA] , [7: CIP] , [10: NEW]
, ...4 more...
)
removal_pay_item_number
( type: esriFieldTypeString, alias: removal_pay_item_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: removal_pay_item_number ,
Coded Values:
[10: 10] , [100: 100] , [1001: 1001]
, ...121 more...
)
removal_pay_item_tag
( type: esriFieldTypeSmallInteger, alias: removal_pay_item_tag, editable: true, nullable: true, defaultValue: null, modelName: removal_pay_item_tag ,
Coded Values:
[21: ADA PAVEMENT MARKINGS] , [20: ADA SIGNS] , [25: Adjustments]
, ...9 more...
)
mount_type
( type: esriFieldTypeSmallInteger, alias: mount_type, editable: true, nullable: true, defaultValue: null, modelName: mount_type ,
Coded Values:
[0: Cantilever] , [1: Signal] , [2: Butterfly]
, ...1 more...
)
remove_add
( type: esriFieldTypeInteger, alias: Add or Remove Signs, editable: true, nullable: true, defaultValue: null, modelName: remove_add ,
Coded Values:
[0: Add] , [1: Remove] , [2: Both] )
work_limit_id
( type: esriFieldTypeInteger, alias: work_limit_id, editable: true, nullable: true, defaultValue: null, modelName: work_limit_id ,
Coded Values:
[10000: 10000] , [10001: 10001] , [10002: 10002]
, ...1226 more...
)
primary_association
( type: esriFieldTypeSmallInteger, alias: primary_association, editable: true, nullable: true, defaultValue: null, modelName: primary_association ,
Coded Values:
[0: ADA] , [1: Roadway] )
structure_label
( type: esriFieldTypeString, alias: Unique Structure Label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_label )
sign_cy
( type: esriFieldTypeDouble, alias: sign_cy, editable: true, nullable: true, defaultValue: null, modelName: sign_cy )
sign_sy
( type: esriFieldTypeDouble, alias: sign_sy, editable: true, nullable: true, defaultValue: null, modelName: sign_sy )
sign_length
( type: esriFieldTypeDouble, alias: sign_length, editable: true, nullable: true, defaultValue: null, modelName: sign_length )
sign_quantity
( type: esriFieldTypeInteger, alias: sign_quantity, editable: true, nullable: true, defaultValue: null, modelName: sign_quantity )
remove_sy
( type: esriFieldTypeDouble, alias: remove_sy, editable: true, nullable: true, defaultValue: null, modelName: remove_sy )
remove_cy
( type: esriFieldTypeDouble, alias: remove_cy, editable: true, nullable: true, defaultValue: null, modelName: remove_cy )
remove_length
( type: esriFieldTypeDouble, alias: remove_length, editable: true, nullable: true, defaultValue: null, modelName: remove_length )
remove_quantity
( type: esriFieldTypeInteger, alias: remove_quantity, editable: true, nullable: true, defaultValue: null, modelName: remove_quantity )
creator
( type: esriFieldTypeString, alias: creator, editable: true, nullable: true, length: 277, defaultValue: null, modelName: creator )
created
( type: esriFieldTypeDate, alias: created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created )
editor
( type: esriFieldTypeString, alias: editor, editable: true, nullable: true, length: 277, defaultValue: null, modelName: editor )
edited
( type: esriFieldTypeDate, alias: edited, editable: true, nullable: true, length: 8, defaultValue: null, modelName: edited )
sign_added
( type: esriFieldTypeString, alias: sign_added, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_added )
message
( type: esriFieldTypeString, alias: message, editable: true, nullable: true, length: 255, defaultValue: null, modelName: message )
contingency
( type: esriFieldTypeSmallInteger, alias: contingency, editable: true, nullable: true, defaultValue: 0, modelName: contingency ,
Coded Values:
[1: Yes] , [0: No] )
LocationId
( type: esriFieldTypeInteger, alias: Location ID, editable: true, nullable: true, defaultValue: null, modelName: LocationId )
Templates:
Name: Sign Structure
Description:
Prototype:
contingency:
0
notes:
null
sy:
null
cy:
null
length:
null
quantity:
null
pay_item:
null
group_pay_item:
null
favorite_pay_item:
null
plan_label:
null
plan_sheet:
null
side:
null
PayItemOrigin:
null
PayItemNumber:
null
ProjectNumber:
null
ProjectStatus:
null
ParticipationCodeId:
null
ParticipationCode:
null
pay_item_tag:
null
ProjectId:
null
intersection_id:
null
use_default_project:
1
LocationId:
null
structure_size:
null
station:
null
attachment:
null
sign_pay_item:
null
sign_group_pay_item:
null
sign_favorite_pay_item:
null
sign_pay_item_origin:
null
sign_pay_item_number:
null
sign_pay_item_tag:
null
removal_pay_item:
null
removal_group_pay_item:
null
removal_favorite_pay_item:
null
removal_pay_item_origin:
null
removal_pay_item_number:
null
removal_pay_item_tag:
null
mount_type:
null
remove_add:
null
work_limit_id:
null
primary_association:
null
structure_label:
null
sign_cy:
null
sign_sy:
null
sign_length:
null
sign_quantity:
null
remove_sy:
null
remove_cy:
null
remove_length:
null
remove_quantity:
null
creator:
null
created:
null
editor:
null
edited:
null
sign_added:
null
message:
null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
attachment_remove (0) --
Related To
:
Signs to Remove
(9)
attachment_add (1) --
Related To
:
Signs to Add
(8)
Layer:
Sign Faces
(6)
Name:
Sign Faces
Display Field:
structure_guid
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: 1132829.1286789775
YMin: 722037.0882706493
XMax: 1853527.761753887
YMax: 818848.4202381372
Spatial Reference: 103130 (6551) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[120, 120, 120, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Label:
Description:
Transparency:
0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
structure_guid
( type: esriFieldTypeString, alias: Parent Structure ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_guid )
leader_guid
( type: esriFieldTypeString, alias: Leader Line ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: leader_guid )
signs_to_add
( type: esriFieldTypeString, alias: Signs To Add, editable: true, nullable: true, length: 255, defaultValue: null, modelName: signs_to_add )
signs_to_remove
( type: esriFieldTypeString, alias: Signs To Remove, editable: true, nullable: true, length: 255, defaultValue: null, modelName: signs_to_remove )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
dimensions_to_add
( type: esriFieldTypeString, alias: dimensions_to_add, editable: true, nullable: true, length: 255, defaultValue: null, modelName: dimensions_to_add )
dimensions_to_remove
( type: esriFieldTypeString, alias: dimensions_to_add, editable: true, nullable: true, length: 255, defaultValue: null, modelName: dimensions_to_remove )
creator
( type: esriFieldTypeString, alias: creator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: creator )
created
( type: esriFieldTypeDate, alias: created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created )
editor
( type: esriFieldTypeString, alias: editor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: editor )
edited
( type: esriFieldTypeDate, alias: edited, editable: true, nullable: true, length: 8, defaultValue: null, modelName: edited )
contingency
( type: esriFieldTypeSmallInteger, alias: contingency, editable: true, nullable: true, defaultValue: 0, modelName: contingency ,
Coded Values:
[1: Yes] , [0: No] )
LocationId
( type: esriFieldTypeInteger, alias: Location ID, editable: true, nullable: true, defaultValue: null, modelName: LocationId )
Templates:
Name: Sign Faces
Description:
Prototype:
contingency:
0
edited:
null
structure_guid:
null
leader_guid:
null
signs_to_add:
null
signs_to_remove:
null
LocationId:
null
dimensions_to_add:
null
dimensions_to_remove:
null
creator:
null
created:
null
editor:
null
Drawing Tool: esriFeatureEditToolPoint
Layer:
Sign Leader Lines
(5)
Name:
Sign Leader Lines
Display Field:
structure_guid
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: 1132814.9866468906
YMin: 722022.9462385625
XMax: 1853527.761753887
YMax: 818848.4202381372
Spatial Reference: 103130 (6551) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[106, 137, 56, 255]
Width:
1
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
structure_guid
( type: esriFieldTypeString, alias: Parent Structure ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_guid )
sign_faces_guid
( type: esriFieldTypeString, alias: Sign Face ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_faces_guid )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
contingency
( type: esriFieldTypeSmallInteger, alias: contingency, editable: true, nullable: true, defaultValue: 0, modelName: contingency ,
Coded Values:
[1: Yes] , [0: No] )
LocationId
( type: esriFieldTypeInteger, alias: Location ID, editable: true, nullable: true, defaultValue: null, modelName: LocationId )
Shape__Length
( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Templates:
Name: Sign Leader Lines
Description:
Prototype:
LocationId:
null
structure_guid:
null
sign_faces_guid:
null
contingency:
0
Drawing Tool: esriFeatureEditToolLine
Tables:
Table:
Signs to Add
(8)
Name:
Signs to Add
Display Field:
p_code
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000000
MaxSelectionCount:
0
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
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
is_combined
( type: esriFieldTypeSmallInteger, alias: is_combined, editable: true, nullable: true, defaultValue: null, modelName: is_combined ,
Coded Values:
[1: Yes] , [0: No] )
structure_guid
( type: esriFieldTypeString, alias: structure_guid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_guid )
notes
( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
sy
( type: esriFieldTypeDouble, alias: sy, editable: true, nullable: true, defaultValue: null, modelName: sy )
cy
( type: esriFieldTypeDouble, alias: cy, editable: true, nullable: true, defaultValue: null, modelName: cy )
length
( type: esriFieldTypeDouble, alias: length, editable: true, nullable: true, defaultValue: null, modelName: length )
quantity
( type: esriFieldTypeInteger, alias: quantity, editable: true, nullable: true, defaultValue: null, modelName: quantity )
side
( type: esriFieldTypeString, alias: side, editable: true, nullable: true, length: 255, defaultValue: null, modelName: side ,
Coded Values:
[N: N] , [S: S] , [W: W]
, ...1 more...
)
ProjectNumber
( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectNumber )
ProjectStatus
( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectStatus )
ProjectId
( type: esriFieldTypeString, alias: ProjectId, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectId ,
Coded Values:
[374: 374 - 530282-922023 : Resurfacing - 2023 Project 2] , [375: 375 - 530282-999999: Unassigned - ADA] , [376: 376 - 530087-100043: ADA Ramp Projects - CDBG Curb Ramps (2023)]
, ...50 more...
)
intersection_id
( type: esriFieldTypeInteger, alias: intersection_id, editable: true, nullable: true, defaultValue: null, modelName: intersection_id ,
Coded Values:
[-1: -1] , [-10: -10] , [101679: 101679]
, ...5165 more...
)
use_default_project
( type: esriFieldTypeSmallInteger, alias: use_default_project, editable: true, nullable: true, defaultValue: 1, modelName: use_default_project ,
Coded Values:
[1: Yes] , [0: No] )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
REL_ID
( type: esriFieldTypeGUID, alias: REL_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_ID )
attachments
( type: esriFieldTypeBlob, alias: attachments, editable: true, nullable: true, defaultValue: null, modelName: attachments )
sign_label
( type: esriFieldTypeString, alias: sign_label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_label )
description
( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
p_code
( type: esriFieldTypeInteger, alias: p_code, editable: true, nullable: true, defaultValue: null, modelName: p_code ,
Coded Values:
[1329: 10W-10c: Combination HorizontalAlignment/Intersection] , [805: CM-R-003L.02: STOP HERE TO TRIP DETECTOR (ARROW LEFT)] , [806: CM-R-003R.02: STOP HERE TO TRIP DETECTOR (ARROW RIGHT)]
, ...1533 more...
)
s_code
( type: esriFieldTypeInteger, alias: s_code, editable: true, nullable: true, defaultValue: null, modelName: s_code ,
Coded Values:
[1329: 10W-10c: Combination HorizontalAlignment/Intersection] , [805: CM-R-003L.02: STOP HERE TO TRIP DETECTOR (ARROW LEFT)] , [806: CM-R-003R.02: STOP HERE TO TRIP DETECTOR (ARROW RIGHT)]
, ...1533 more...
)
dimensions
( type: esriFieldTypeInteger, alias: dimensions, editable: true, nullable: true, defaultValue: null, modelName: dimensions ,
Coded Values:
[658: 0 x 0] , [697: 0 x 0] , [700: 0 x 0]
, ...1533 more...
)
cmb_sign_dimensions
( type: esriFieldTypeInteger, alias: cmb_sign_dimensions, editable: true, nullable: true, defaultValue: null, modelName: cmb_sign_dimensions ,
Coded Values:
[0: 12 x 18] , [1: 20 x 25] , [2: 30 x 40] )
creator
( type: esriFieldTypeString, alias: creator, editable: false, nullable: true, length: 277, defaultValue: null, modelName: creator )
created
( type: esriFieldTypeDate, alias: created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created )
editor
( type: esriFieldTypeString, alias: editor, editable: false, nullable: true, length: 277, defaultValue: null, modelName: editor )
edited
( type: esriFieldTypeDate, alias: edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: edited )
classification
( type: esriFieldTypeInteger, alias: classification, editable: true, nullable: true, defaultValue: null, modelName: classification ,
Coded Values:
[20: CG-MK (Columbus Routes and Markers)] , [21: CG-TODS (Columbus Guide - Activities / Destinations)] , [19: CI (Columbus Guide Informational)]
, ...18 more...
)
position
( type: esriFieldTypeInteger, alias: position, editable: true, nullable: true, defaultValue: null, modelName: position ,
Coded Values:
[0: 0] , [1: 1] , [2: 2]
, ...4 more...
)
Templates:
Name: Signs to Add
Description:
Prototype:
classification:
null
is_combined:
null
structure_guid:
null
notes:
null
sy:
null
cy:
null
length:
null
quantity:
null
side:
null
ProjectNumber:
null
ProjectStatus:
null
ProjectId:
null
intersection_id:
null
use_default_project:
1
position:
null
REL_ID:
null
attachments:
null
sign_label:
null
description:
null
p_code:
null
s_code:
null
dimensions:
null
cmb_sign_dimensions:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
object (1) --
Related To
:
Sign Structure
(0)
Table:
Signs to Remove
(9)
Name:
Signs to Remove
Display Field:
p_code
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000000
MaxSelectionCount:
0
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
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
structure_guid
( type: esriFieldTypeString, alias: structure_guid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: structure_guid )
notes
( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
sy
( type: esriFieldTypeDouble, alias: sy, editable: true, nullable: true, defaultValue: null, modelName: sy )
cy
( type: esriFieldTypeDouble, alias: cy, editable: true, nullable: true, defaultValue: null, modelName: cy )
length
( type: esriFieldTypeDouble, alias: length, editable: true, nullable: true, defaultValue: null, modelName: length )
quantity
( type: esriFieldTypeInteger, alias: quantity, editable: true, nullable: true, defaultValue: null, modelName: quantity )
plan_label
( type: esriFieldTypeString, alias: plan_label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: plan_label )
plan_sheet
( type: esriFieldTypeString, alias: plan_sheet, editable: true, nullable: true, length: 255, defaultValue: null, modelName: plan_sheet )
ProjectNumber
( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectNumber )
ProjectStatus
( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectStatus )
ProjectId
( type: esriFieldTypeString, alias: ProjectId, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectId ,
Coded Values:
[374: 374 - 530282-922023 : Resurfacing - 2023 Project 2] , [375: 375 - 530282-999999: Unassigned - ADA] , [376: 376 - 530087-100043: ADA Ramp Projects - CDBG Curb Ramps (2023)]
, ...50 more...
)
intersection_id
( type: esriFieldTypeInteger, alias: intersection_id, editable: true, nullable: true, defaultValue: null, modelName: intersection_id ,
Coded Values:
[-1: -1] , [-10: -10] , [101679: 101679]
, ...5165 more...
)
use_default_project
( type: esriFieldTypeSmallInteger, alias: use_default_project, editable: true, nullable: true, defaultValue: 1, modelName: use_default_project ,
Coded Values:
[1: Yes] , [0: No] )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
REL_ID
( type: esriFieldTypeGUID, alias: REL_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_ID )
is_combined
( type: esriFieldTypeSmallInteger, alias: is_combined, editable: true, nullable: true, defaultValue: null, modelName: is_combined ,
Coded Values:
[1: Yes] , [0: No] )
attachments
( type: esriFieldTypeBlob, alias: attachments, editable: true, nullable: true, defaultValue: null, modelName: attachments )
sign_label
( type: esriFieldTypeString, alias: sign_label, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_label )
description
( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
p_code
( type: esriFieldTypeInteger, alias: p_code, editable: true, nullable: true, defaultValue: null, modelName: p_code ,
Coded Values:
[1329: 10W-10c: Combination HorizontalAlignment/Intersection] , [805: CM-R-003L.02: STOP HERE TO TRIP DETECTOR (ARROW LEFT)] , [806: CM-R-003R.02: STOP HERE TO TRIP DETECTOR (ARROW RIGHT)]
, ...1533 more...
)
s_code
( type: esriFieldTypeInteger, alias: s_code, editable: true, nullable: true, defaultValue: null, modelName: s_code ,
Coded Values:
[1329: 10W-10c: Combination HorizontalAlignment/Intersection] , [805: CM-R-003L.02: STOP HERE TO TRIP DETECTOR (ARROW LEFT)] , [806: CM-R-003R.02: STOP HERE TO TRIP DETECTOR (ARROW RIGHT)]
, ...1533 more...
)
dimensions
( type: esriFieldTypeInteger, alias: dimensions, editable: true, nullable: true, defaultValue: null, modelName: dimensions )
creator
( type: esriFieldTypeString, alias: creator, editable: false, nullable: true, length: 277, defaultValue: null, modelName: creator )
created
( type: esriFieldTypeDate, alias: created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created )
editor
( type: esriFieldTypeString, alias: editor, editable: false, nullable: true, length: 277, defaultValue: null, modelName: editor )
edited
( type: esriFieldTypeDate, alias: edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: edited )
position
( type: esriFieldTypeInteger, alias: Sign Position, editable: true, nullable: true, defaultValue: null, modelName: position ,
Coded Values:
[0: 0] , [1: 1] , [2: 2]
, ...4 more...
)
cmb_sign_dimensions
( type: esriFieldTypeInteger, alias: cmb_sign_dimensions, editable: true, nullable: true, defaultValue: null, modelName: cmb_sign_dimensions ,
Coded Values:
[0: 12 x 18] , [1: 20 x 25] , [2: 30 x 40] )
classification
( type: esriFieldTypeInteger, alias: classification, editable: true, nullable: true, defaultValue: null, modelName: classification ,
Coded Values:
[20: CG-MK (Columbus Routes and Markers)] , [21: CG-TODS (Columbus Guide - Activities / Destinations)] , [19: CI (Columbus Guide Informational)]
, ...18 more...
)
Templates:
Name: Signs to Remove
Description:
Prototype:
cmb_sign_dimensions:
null
structure_guid:
null
notes:
null
sy:
null
cy:
null
length:
null
quantity:
null
plan_label:
null
plan_sheet:
null
ProjectNumber:
null
ProjectStatus:
null
ProjectId:
null
intersection_id:
null
use_default_project:
1
classification:
null
REL_ID:
null
is_combined:
null
attachments:
null
sign_label:
null
description:
null
p_code:
null
s_code:
null
dimensions:
null
position:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
object (0) --
Related To
:
Sign Structure
(0)