Name: User Table
Display Field: USER_FNAME
Type: Table
Geometry Type: N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
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:
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
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
)
-
USER_LOGIN
(
type: esriFieldTypeString, alias: Login Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USER_LOGIN
)
-
USER_FNAME
(
type: esriFieldTypeString, alias: First Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USER_FNAME
)
-
USER_LNAME
(
type: esriFieldTypeString, alias: Last Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USER_LNAME
)
-
USER_TYPE
(
type: esriFieldTypeString, alias: User Type, editable: true, nullable: true, length: 15, defaultValue: USER, modelName: USER_TYPE
)
-
USER_POSITION
(
type: esriFieldTypeString, alias: Position, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USER_POSITION
)
-
USER_ORGANIZATION
(
type: esriFieldTypeString, alias: Organization, editable: true, nullable: true, length: 255, defaultValue: null, modelName: USER_ORGANIZATION
)
-
AD_JURISDICTION
(
type: esriFieldTypeString, alias: Address Jurisdiction, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AD_JURISDICTION
)
-
RD_JURISDICTION
(
type: esriFieldTypeString, alias: Road Jurisdiction, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RD_JURISDICTION
)
-
ENV_LBA
(
type: esriFieldTypeDouble, alias: Length Between Addresses, editable: true, nullable: true, defaultValue: 25, modelName: ENV_LBA
)
-
ENV_SIDE
(
type: esriFieldTypeString, alias: Default Even Side, editable: true, nullable: true, length: 10, defaultValue: RIGHT, modelName: ENV_SIDE
)
-
RULE_AD_DUP
(
type: esriFieldTypeString, alias: Rule Address Duplicate, editable: true, nullable: true, length: 50, defaultValue: HARD, modelName: RULE_AD_DUP
)
-
RULE_AD_ZERO
(
type: esriFieldTypeString, alias: Rule Address Zero, editable: true, nullable: true, length: 50, defaultValue: HARD, modelName: RULE_AD_ZERO
)
-
RULE_AD_OEM
(
type: esriFieldTypeString, alias: Rule Address OE Mismatch, editable: true, nullable: true, length: 50, defaultValue: HARD, modelName: RULE_AD_OEM
)
-
RULE_AD_OOR
(
type: esriFieldTypeString, alias: Rule Address Out of Range, editable: true, nullable: true, length: 50, defaultValue: HARD, modelName: RULE_AD_OOR
)
-
RULE_RD_OVRLP
(
type: esriFieldTypeString, alias: Rule Road Range Overlap, editable: true, nullable: true, length: 50, defaultValue: HARD, modelName: RULE_RD_OVRLP
)
-
RULE_RD_ZERO
(
type: esriFieldTypeString, alias: Rule Road Zero Ranges, editable: true, nullable: true, length: 50, defaultValue: HARD, modelName: RULE_RD_ZERO
)
-
EDIT_ENABLE_DELETE
(
type: esriFieldTypeString, alias: Enable Delete Address, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_DELETE
)
-
EDIT_ENABLE_MASS
(
type: esriFieldTypeString, alias: Enable Mass Calculate, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_MASS
)
-
EDIT_ENABLE_AUTO
(
type: esriFieldTypeString, alias: Enable AutoAddress, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_AUTO
)
-
EDIT_ENABLE_LINK
(
type: esriFieldTypeString, alias: Enable Link, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_LINK
)
-
EDIT_ENABLE_SBDV
(
type: esriFieldTypeString, alias: Enable Subdivion Edit, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_SBDV
)
-
EDIT_ENABLE_NAME
(
type: esriFieldTypeString, alias: Enable Street Name Edit, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_NAME
)
-
EDIT_ENABLE_ERROR
(
type: esriFieldTypeString, alias: Enable Error Checks, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ERROR
)
-
EDIT_ENABLE_DELETE_ROAD
(
type: esriFieldTypeString, alias: Enable Delete Road, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_DELETE_ROAD
)
-
EDIT_ENABLE_DELETE_NAME
(
type: esriFieldTypeString, alias: Enable Delete Name, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_DELETE_NAME
)
-
EDIT_ENABLE_DELETE_SUBDIV
(
type: esriFieldTypeString, alias: Enable Delete Subdivision, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_DELETE_SUBDIV
)
-
EDIT_ENABLE_ANOMALY_ADDR
(
type: esriFieldTypeString, alias: Enable Anomaly Address, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ANOMALY_ADDR
)
-
EDIT_ENABLE_ANOMALY_ROAD
(
type: esriFieldTypeString, alias: Enable Anomaly Road, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ANOMALY_ROAD
)
-
EDIT_ENABLE_MASS_DELETE
(
type: esriFieldTypeString, alias: Enable Mass Delete, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_MASS_DELETE
)
-
EDIT_ENABLE_ADD_ADDRESS
(
type: esriFieldTypeString, alias: Enable Add Address, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ADD_ADDRESS
)
-
EDIT_ENABLE_MOVE_ADDRESS
(
type: esriFieldTypeString, alias: Enable Move Address, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_MOVE_ADDRESS
)
-
EDIT_ENABLE_EDIT_ADDRESS
(
type: esriFieldTypeString, alias: Enable Edit Address, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_EDIT_ADDRESS
)
-
EDIT_ENABLE_ADD_ROAD
(
type: esriFieldTypeString, alias: Enable Add Road, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ADD_ROAD
)
-
EDIT_ENABLE_VERTEX_ROAD
(
type: esriFieldTypeString, alias: Enable Vertex Road, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_VERTEX_ROAD
)
-
EDIT_ENABLE_SPLIT_ROAD
(
type: esriFieldTypeString, alias: Enable Split Road, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_SPLIT_ROAD
)
-
EDIT_ENABLE_MERGE_ROAD
(
type: esriFieldTypeString, alias: Enable Merge Road, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_MERGE_ROAD
)
-
EDIT_FIELDS_ROAD
(
type: esriFieldTypeString, alias: Editable Road Fields, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: EDIT_FIELDS_ROAD
)
-
EDIT_FIELDS_ADDRESS
(
type: esriFieldTypeString, alias: Editable Address Fields, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: EDIT_FIELDS_ADDRESS
)
-
EDIT_ENABLE_EDIT_ROAD
(
type: esriFieldTypeString, alias: Enable Edit Road, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_EDIT_ROAD
)
-
ACTIVE
(
type: esriFieldTypeString, alias: Active, editable: true, nullable: true, length: 1, defaultValue: Y, modelName: ACTIVE
)
-
USER_ROLE
(
type: esriFieldTypeString, alias: Role, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USER_ROLE
)
-
USER_LOCAL_NAME
(
type: esriFieldTypeString, alias: Local Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USER_LOCAL_NAME
)
-
FEATURE_LAYERS
(
type: esriFieldTypeString, alias: Feature Lyaers Visible, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FEATURE_LAYERS
)
-
BACK_LAYERS
(
type: esriFieldTypeString, alias: Back Layers Visible, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BACK_LAYERS
)
-
BASEMAPS
(
type: esriFieldTypeString, alias: Base Maps Visible, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: BASEMAPS
)
-
EDIT_ENABLE_ROAD_COMMENT
(
type: esriFieldTypeString, alias: Enable Road Extended Comments, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ROAD_COMMENT
)
-
EDIT_ENABLE_ADDR_COMMENT
(
type: esriFieldTypeString, alias: Enable Address Extended Comments, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ADDR_COMMENT
)
-
EDIT_ENABLE_NAME_COMMENT
(
type: esriFieldTypeString, alias: Enable Name Extended Comments, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_NAME_COMMENT
)
-
USER_EMAIL
(
type: esriFieldTypeString, alias: eMail, editable: true, nullable: true, length: 100, defaultValue: null, modelName: USER_EMAIL
)
-
USER_ADDR_ISSUE
(
type: esriFieldTypeString, alias: Handle Address Issues, editable: true, nullable: true, length: 1, defaultValue: N, modelName: USER_ADDR_ISSUE
)
-
USER_ADDR_REQUEST
(
type: esriFieldTypeString, alias: Handle Address Requests, editable: true, nullable: true, length: 1, defaultValue: N, modelName: USER_ADDR_REQUEST
)
-
USER_ROAD_ISSUE
(
type: esriFieldTypeString, alias: Handle Road Issues, editable: true, nullable: true, length: 1, defaultValue: N, modelName: USER_ROAD_ISSUE
)
-
USER_ROAD_REQUEST
(
type: esriFieldTypeString, alias: Handle Road Requests, editable: true, nullable: true, length: 1, defaultValue: N, modelName: USER_ROAD_REQUEST
)
-
EDIT_ENABLE_ADD_NAME
(
type: esriFieldTypeString, alias: Enable Add Name, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ADD_NAME
)
-
EDIT_ENABLE_EDIT_NAME
(
type: esriFieldTypeString, alias: Enable Edit Name, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_EDIT_NAME
)
-
EDIT_ENABLE_ADD_ALIAS
(
type: esriFieldTypeString, alias: Enable Add Alias, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ADD_ALIAS
)
-
EDIT_ENABLE_EDIT_ALIAS
(
type: esriFieldTypeString, alias: Enable Edit Alias, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_EDIT_ALIAS
)
-
EDIT_ENABLE_DELETE_ALIAS
(
type: esriFieldTypeString, alias: Enable Delete Alias, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_DELETE_ALIAS
)
-
EDIT_ENABLE_ADD_BASE
(
type: esriFieldTypeString, alias: Enable Add Base, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_ADD_BASE
)
-
EDIT_ENABLE_EDIT_BASE
(
type: esriFieldTypeString, alias: Enable Edit Base, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_EDIT_BASE
)
-
EDIT_ENABLE_DELETE_BASE
(
type: esriFieldTypeString, alias: Enable Delete Base, editable: true, nullable: true, length: 1, defaultValue: N, modelName: EDIT_ENABLE_DELETE_BASE
)
Templates:
-
Name: User Table
Description:
Prototype:
EDIT_ENABLE_EDIT_BASE: N
EDIT_ENABLE_DELETE_BASE: N
USER_LOGIN: null
USER_FNAME: null
USER_LNAME: null
USER_TYPE: USER
USER_POSITION: null
USER_ORGANIZATION: null
AD_JURISDICTION: null
RD_JURISDICTION: null
ENV_LBA: 25
ENV_SIDE: RIGHT
RULE_AD_DUP: HARD
RULE_AD_ZERO: HARD
RULE_AD_OEM: HARD
RULE_AD_OOR: HARD
RULE_RD_OVRLP: HARD
RULE_RD_ZERO: HARD
EDIT_ENABLE_DELETE: N
EDIT_ENABLE_MASS: N
EDIT_ENABLE_AUTO: N
EDIT_ENABLE_LINK: N
EDIT_ENABLE_SBDV: N
EDIT_ENABLE_NAME: N
EDIT_ENABLE_ERROR: N
EDIT_ENABLE_DELETE_ROAD: N
EDIT_ENABLE_DELETE_NAME: N
EDIT_ENABLE_DELETE_SUBDIV: N
EDIT_ENABLE_ANOMALY_ADDR: N
EDIT_ENABLE_ANOMALY_ROAD: N
EDIT_ENABLE_MASS_DELETE: N
EDIT_ENABLE_ADD_ADDRESS: N
EDIT_ENABLE_MOVE_ADDRESS: N
EDIT_ENABLE_EDIT_ADDRESS: N
EDIT_ENABLE_ADD_ROAD: N
EDIT_ENABLE_VERTEX_ROAD: N
EDIT_ENABLE_SPLIT_ROAD: N
EDIT_ENABLE_MERGE_ROAD: N
EDIT_FIELDS_ROAD: null
EDIT_FIELDS_ADDRESS: null
EDIT_ENABLE_EDIT_ROAD: N
ACTIVE: Y
USER_ROLE: null
USER_LOCAL_NAME: null
FEATURE_LAYERS: null
BACK_LAYERS: null
BASEMAPS: null
EDIT_ENABLE_ROAD_COMMENT: N
EDIT_ENABLE_ADDR_COMMENT: N
EDIT_ENABLE_NAME_COMMENT: N
USER_EMAIL: null
USER_ADDR_ISSUE: N
USER_ADDR_REQUEST: N
USER_ROAD_ISSUE: N
USER_ROAD_REQUEST: N
EDIT_ENABLE_ADD_NAME: N
EDIT_ENABLE_EDIT_NAME: N
EDIT_ENABLE_ADD_ALIAS: N
EDIT_ENABLE_EDIT_ALIAS: N
EDIT_ENABLE_DELETE_ALIAS: N
EDIT_ENABLE_ADD_BASE: N
Drawing Tool: esriFeatureEditToolNone
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Supports Query With Historic Moment: false
Supports Coordinates Quantization: false
Supported Operations:
Query
Query Attachments
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata