Name: CAMA.MEDIA_STATS

Display Field: FILE_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: c3c940e0a517479c8294a6225fbe8f79

Copyright Text: null

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

Fields:

• ID ( type: esriFieldTypeOID, alias: ID )
• MEDIA_ID ( type: esriFieldTypeGUID, alias: MEDIA_ID, length: 38 )
• JURISDICTION ( type: esriFieldTypeSmallInteger, alias: JURISDICTION )
• VERSION ( type: esriFieldTypeInteger, alias: VERSION )
• RECORD_TYPE ( type: esriFieldTypeString, alias: RECORD_TYPE, length: 1 )
• PARCEL_ID ( type: esriFieldTypeString, alias: PARCEL_ID, length: 36 )
• TAX_YEAR ( type: esriFieldTypeSmallInteger, alias: TAX_YEAR )
• MEDIA_TYPE ( type: esriFieldTypeString, alias: MEDIA_TYPE, length: 20 )
• MEDIA_GROUP_ID ( type: esriFieldTypeGUID, alias: MEDIA_GROUP_ID, length: 38 )
• MEDIA_THUMB ( type: esriFieldTypeString, alias: MEDIA_THUMB, length: 1073741822 )
• CACHE_PATH ( type: esriFieldTypeString, alias: CACHE_PATH, length: 500 )
• FILE_EXTENSION ( type: esriFieldTypeString, alias: FILE_EXTENSION, length: 10 )
• FILE_NAME ( type: esriFieldTypeString, alias: FILE_NAME, length: 200 )
• FILE_SIZE ( type: esriFieldTypeBigInteger, alias: FILE_SIZE )
• IMAGE_HEIGHT ( type: esriFieldTypeBigInteger, alias: IMAGE_HEIGHT )
• IMAGE_WIDTH ( type: esriFieldTypeBigInteger, alias: IMAGE_WIDTH )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 200 )
• ATTACHED_TO ( type: esriFieldTypeString, alias: ATTACHED_TO, length: 20 )
• IS_FILESTREAM ( type: esriFieldTypeSmallInteger, alias: IS_FILESTREAM )
• IMP_NO ( type: esriFieldTypeBigInteger, alias: IMP_NO )
• LAND_DETAIL_ID ( type: esriFieldTypeBigInteger, alias: LAND_DETAIL_ID )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: SEGMENT_ID )
• SECTION_NUMBER ( type: esriFieldTypeSmallInteger, alias: SECTION_NUMBER )
• BUILDING_NO ( type: esriFieldTypeSmallInteger, alias: BUILDING_NO )
• WING_ID ( type: esriFieldTypeInteger, alias: WING_ID )
• BATCH_ID ( type: esriFieldTypeGUID, alias: BATCH_ID, length: 38 )
• JOB_DEFINITION_ID ( type: esriFieldTypeGUID, alias: JOB_DEFINITION_ID, length: 38 )
• PERMIT_ID ( type: esriFieldTypeGUID, alias: PERMIT_ID, length: 38 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 4000 )
• ACTIVE_FLAG ( type: esriFieldTypeSmallInteger, alias: ACTIVE_FLAG )
• PRIMARY_PHOTO_FLAG ( type: esriFieldTypeSmallInteger, alias: PRIMARY_PHOTO_FLAG )
• WEB_PHOTO_FLAG ( type: esriFieldTypeSmallInteger, alias: WEB_PHOTO_FLAG )
• PHOTO_TYPE ( type: esriFieldTypeString, alias: PHOTO_TYPE, length: 20 )
• DOCUMENT_TYPE ( type: esriFieldTypeString, alias: DOCUMENT_TYPE, length: 20 )
• UPLOAD_DATE ( type: esriFieldTypeDate, alias: UPLOAD_DATE, length: 8, precision: 1 )
• UPLOADED_BY ( type: esriFieldTypeString, alias: UPLOADED_BY, length: 30 )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, length: 8, precision: 1 )
• UPDATED_BY ( type: esriFieldTypeString, alias: UPDATED_BY, length: 30 )
• FIRST_TAX_YEAR ( type: esriFieldTypeSmallInteger, alias: FIRST_TAX_YEAR )
• ORIGIN_ID ( type: esriFieldTypeGUID, alias: ORIGIN_ID, length: 38 )
• AZURE_BLOB_URL ( type: esriFieldTypeString, alias: AZURE_BLOB_URL, length: 500 )
• EXPORT_DATE ( type: esriFieldTypeDate, alias: EXPORT_DATE, length: 8, precision: 1 )
• INSERT_DATE ( type: esriFieldTypeDate, alias: INSERT_DATE, length: 8, precision: 1 )
• EXPORT_FILE_NAME ( type: esriFieldTypeString, alias: EXPORT_FILE_NAME, length: 100 )

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

  Iteminfo   Thumbnail   Metadata