Name: CAMA.SKETCH_MEDIA_STATS
Display Field: FILE_NAME
Type: Table
Geometry Type: N/A
Description: N/A
Service Item Id: 312cc56d4ffd4d2fa93a12c3a4a1896a
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Unique Id Infos:
Type: simple
Fields: ["SKETCH_MEDIA_ID"]
OID Field Contains Hash Value: true
Extent:
Drawing Info:
Feature Draw Order:
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: false
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: true
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: N/A
Fields:
-
SKETCH_MEDIA_ID
(
nullable: false, length: 38, alias: SKETCH_MEDIA_ID, type: esriFieldTypeGUID
)
-
JURISDICTION
(
nullable: false, alias: JURISDICTION, type: esriFieldTypeSmallInteger
)
-
VERSION
(
nullable: true, alias: VERSION, type: esriFieldTypeInteger
)
-
RECORD_TYPE
(
nullable: true, length: 1, alias: RECORD_TYPE, type: esriFieldTypeString
)
-
PARCEL_ID
(
nullable: true, length: 36, alias: PARCEL_ID, type: esriFieldTypeString
)
-
TAX_YEAR
(
nullable: true, alias: TAX_YEAR, type: esriFieldTypeSmallInteger
)
-
MEDIA_TYPE
(
nullable: false, length: 20, alias: MEDIA_TYPE, type: esriFieldTypeString
)
-
MEDIA_GROUP_ID
(
nullable: true, length: 38, alias: MEDIA_GROUP_ID, type: esriFieldTypeGUID
)
-
MEDIA_THUMB
(
nullable: true, length: 1073741822, alias: MEDIA_THUMB, type: esriFieldTypeString
)
-
FILE_EXTENSION
(
nullable: true, length: 10, alias: FILE_EXTENSION, type: esriFieldTypeString
)
-
FILE_NAME
(
nullable: false, length: 200, alias: FILE_NAME, type: esriFieldTypeString
)
-
FILE_SIZE
(
nullable: false, alias: FILE_SIZE, type: esriFieldTypeBigInteger
)
-
IMAGE_HEIGHT
(
nullable: true, alias: IMAGE_HEIGHT, type: esriFieldTypeBigInteger
)
-
IMAGE_WIDTH
(
nullable: true, alias: IMAGE_WIDTH, type: esriFieldTypeBigInteger
)
-
CONTENT_TYPE
(
nullable: false, length: 200, alias: CONTENT_TYPE, type: esriFieldTypeString
)
-
ATTACHED_TO
(
nullable: false, length: 20, alias: ATTACHED_TO, type: esriFieldTypeString
)
-
IMP_NO
(
nullable: true, alias: IMP_NO, type: esriFieldTypeBigInteger
)
-
SKETCH_ID
(
nullable: true, alias: SKETCH_ID, type: esriFieldTypeBigInteger
)
-
PAGE_IDX
(
nullable: true, alias: PAGE_IDX, type: esriFieldTypeInteger
)
-
COMMENTS
(
nullable: true, length: 4000, alias: COMMENTS, type: esriFieldTypeString
)
-
ACTIVE_FLAG
(
nullable: false, alias: ACTIVE_FLAG, type: esriFieldTypeSmallInteger
)
-
PHOTO_TYPE
(
nullable: true, length: 20, alias: PHOTO_TYPE, type: esriFieldTypeString
)
-
DOCUMENT_TYPE
(
nullable: true, length: 20, alias: DOCUMENT_TYPE, type: esriFieldTypeString
)
-
UPLOAD_DATE
(
nullable: false, precision: 1, length: 8, alias: UPLOAD_DATE, type: esriFieldTypeDate
)
-
UPLOADED_BY
(
nullable: false, length: 30, alias: UPLOADED_BY, type: esriFieldTypeString
)
-
UPDATE_DATE
(
nullable: false, precision: 1, length: 8, alias: UPDATE_DATE, type: esriFieldTypeDate
)
-
UPDATED_BY
(
nullable: false, length: 30, alias: UPDATED_BY, type: esriFieldTypeString
)
-
FIRST_TAX_YEAR
(
nullable: false, alias: FIRST_TAX_YEAR, type: esriFieldTypeSmallInteger
)
-
ORIGIN_ID
(
nullable: true, length: 38, alias: ORIGIN_ID, type: esriFieldTypeGUID
)
-
AZURE_BLOB_URL
(
nullable: true, length: 500, alias: AZURE_BLOB_URL, type: esriFieldTypeString
)
-
EXPORT_FILE_NAME
(
nullable: true, length: 100, alias: EXPORT_FILE_NAME, type: esriFieldTypeString
)
-
INSERT_DATE
(
nullable: true, precision: 1, length: 8, alias: INSERT_DATE, type: esriFieldTypeDate
)
-
EXPORT_DATE
(
nullable: true, precision: 1, length: 8, alias: EXPORT_DATE, type: esriFieldTypeDate
)
-
ESRI_OID
(
nullable: false, length: 8, alias: ESRI_OID, type: esriFieldTypeOID
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata