Tables:

Table: CAMA.SKETCH_MEDIA_STATS (0)

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:
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: 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 )