Name: CAMA.MEDIA_STATS

Display Field: FILE_NAME

Type: Table

Geometry Type: N/A

Description: N/A

Service Item Id: c3c940e0a517479c8294a6225fbe8f79

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: ["ID"]
OID Field Contains Hash Value: false

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:

• ID ( nullable: false, alias: ID, type: esriFieldTypeOID )
• MEDIA_ID ( nullable: false, length: 38, alias: 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: true, 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 )
• CACHE_PATH ( nullable: true, length: 500, alias: CACHE_PATH, type: esriFieldTypeString )
• FILE_EXTENSION ( nullable: true, length: 10, alias: FILE_EXTENSION, type: esriFieldTypeString )
• FILE_NAME ( nullable: true, length: 200, alias: FILE_NAME, type: esriFieldTypeString )
• FILE_SIZE ( nullable: true, 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: true, length: 20, alias: ATTACHED_TO, type: esriFieldTypeString )
• IS_FILESTREAM ( nullable: false, alias: IS_FILESTREAM, type: esriFieldTypeSmallInteger )
• IMP_NO ( nullable: true, alias: IMP_NO, type: esriFieldTypeBigInteger )
• LAND_DETAIL_ID ( nullable: true, alias: LAND_DETAIL_ID, type: esriFieldTypeBigInteger )
• SEGMENT_ID ( nullable: true, alias: SEGMENT_ID, type: esriFieldTypeInteger )
• SECTION_NUMBER ( nullable: true, alias: SECTION_NUMBER, type: esriFieldTypeSmallInteger )
• BUILDING_NO ( nullable: true, alias: BUILDING_NO, type: esriFieldTypeSmallInteger )
• WING_ID ( nullable: true, alias: WING_ID, type: esriFieldTypeInteger )
• BATCH_ID ( nullable: true, length: 38, alias: BATCH_ID, type: esriFieldTypeGUID )
• JOB_DEFINITION_ID ( nullable: true, length: 38, alias: JOB_DEFINITION_ID, type: esriFieldTypeGUID )
• PERMIT_ID ( nullable: true, length: 38, alias: PERMIT_ID, type: esriFieldTypeGUID )
• COMMENTS ( nullable: true, length: 4000, alias: COMMENTS, type: esriFieldTypeString )
• ACTIVE_FLAG ( nullable: false, alias: ACTIVE_FLAG, type: esriFieldTypeSmallInteger )
• PRIMARY_PHOTO_FLAG ( nullable: false, alias: PRIMARY_PHOTO_FLAG, type: esriFieldTypeSmallInteger )
• WEB_PHOTO_FLAG ( nullable: false, alias: WEB_PHOTO_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: true, length: 30, alias: UPLOADED_BY, type: esriFieldTypeString )
• UPDATE_DATE ( nullable: false, precision: 1, length: 8, alias: UPDATE_DATE, type: esriFieldTypeDate )
• UPDATED_BY ( nullable: true, 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_DATE ( nullable: true, precision: 1, length: 8, alias: EXPORT_DATE, type: esriFieldTypeDate )
• INSERT_DATE ( nullable: true, precision: 1, length: 8, alias: INSERT_DATE, type: esriFieldTypeDate )
• EXPORT_FILE_NAME ( nullable: true, length: 100, alias: EXPORT_FILE_NAME, type: esriFieldTypeString )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata