{
 "layers": [],
 "tables": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 0,
   "name": "CAMA.MEDIA_STATS",
   "type": "Table",
   "description": null,
   "copyrightText": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "FILE_NAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ID",
     "type": "esriFieldTypeOID",
     "alias": "ID",
     "domain": null
    },
    {
     "name": "MEDIA_ID",
     "type": "esriFieldTypeGUID",
     "alias": "MEDIA_ID",
     "length": 38,
     "domain": null
    },
    {
     "name": "JURISDICTION",
     "type": "esriFieldTypeSmallInteger",
     "alias": "JURISDICTION",
     "domain": null
    },
    {
     "name": "VERSION",
     "type": "esriFieldTypeInteger",
     "alias": "VERSION",
     "domain": null
    },
    {
     "name": "RECORD_TYPE",
     "type": "esriFieldTypeString",
     "alias": "RECORD_TYPE",
     "length": 1,
     "domain": null
    },
    {
     "name": "PARCEL_ID",
     "type": "esriFieldTypeString",
     "alias": "PARCEL_ID",
     "length": 36,
     "domain": null
    },
    {
     "name": "TAX_YEAR",
     "type": "esriFieldTypeSmallInteger",
     "alias": "TAX_YEAR",
     "domain": null
    },
    {
     "name": "MEDIA_TYPE",
     "type": "esriFieldTypeString",
     "alias": "MEDIA_TYPE",
     "length": 20,
     "domain": null
    },
    {
     "name": "MEDIA_GROUP_ID",
     "type": "esriFieldTypeGUID",
     "alias": "MEDIA_GROUP_ID",
     "length": 38,
     "domain": null
    },
    {
     "name": "MEDIA_THUMB",
     "type": "esriFieldTypeString",
     "alias": "MEDIA_THUMB",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "CACHE_PATH",
     "type": "esriFieldTypeString",
     "alias": "CACHE_PATH",
     "length": 500,
     "domain": null
    },
    {
     "name": "FILE_EXTENSION",
     "type": "esriFieldTypeString",
     "alias": "FILE_EXTENSION",
     "length": 10,
     "domain": null
    },
    {
     "name": "FILE_NAME",
     "type": "esriFieldTypeString",
     "alias": "FILE_NAME",
     "length": 200,
     "domain": null
    },
    {
     "name": "FILE_SIZE",
     "type": "esriFieldTypeBigInteger",
     "alias": "FILE_SIZE",
     "domain": null
    },
    {
     "name": "IMAGE_HEIGHT",
     "type": "esriFieldTypeBigInteger",
     "alias": "IMAGE_HEIGHT",
     "domain": null
    },
    {
     "name": "IMAGE_WIDTH",
     "type": "esriFieldTypeBigInteger",
     "alias": "IMAGE_WIDTH",
     "domain": null
    },
    {
     "name": "CONTENT_TYPE",
     "type": "esriFieldTypeString",
     "alias": "CONTENT_TYPE",
     "length": 200,
     "domain": null
    },
    {
     "name": "ATTACHED_TO",
     "type": "esriFieldTypeString",
     "alias": "ATTACHED_TO",
     "length": 20,
     "domain": null
    },
    {
     "name": "IS_FILESTREAM",
     "type": "esriFieldTypeSmallInteger",
     "alias": "IS_FILESTREAM",
     "domain": null
    },
    {
     "name": "IMP_NO",
     "type": "esriFieldTypeBigInteger",
     "alias": "IMP_NO",
     "domain": null
    },
    {
     "name": "LAND_DETAIL_ID",
     "type": "esriFieldTypeBigInteger",
     "alias": "LAND_DETAIL_ID",
     "domain": null
    },
    {
     "name": "SEGMENT_ID",
     "type": "esriFieldTypeInteger",
     "alias": "SEGMENT_ID",
     "domain": null
    },
    {
     "name": "SECTION_NUMBER",
     "type": "esriFieldTypeSmallInteger",
     "alias": "SECTION_NUMBER",
     "domain": null
    },
    {
     "name": "BUILDING_NO",
     "type": "esriFieldTypeSmallInteger",
     "alias": "BUILDING_NO",
     "domain": null
    },
    {
     "name": "WING_ID",
     "type": "esriFieldTypeInteger",
     "alias": "WING_ID",
     "domain": null
    },
    {
     "name": "BATCH_ID",
     "type": "esriFieldTypeGUID",
     "alias": "BATCH_ID",
     "length": 38,
     "domain": null
    },
    {
     "name": "JOB_DEFINITION_ID",
     "type": "esriFieldTypeGUID",
     "alias": "JOB_DEFINITION_ID",
     "length": 38,
     "domain": null
    },
    {
     "name": "PERMIT_ID",
     "type": "esriFieldTypeGUID",
     "alias": "PERMIT_ID",
     "length": 38,
     "domain": null
    },
    {
     "name": "COMMENTS",
     "type": "esriFieldTypeString",
     "alias": "COMMENTS",
     "length": 4000,
     "domain": null
    },
    {
     "name": "ACTIVE_FLAG",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ACTIVE_FLAG",
     "domain": null
    },
    {
     "name": "PRIMARY_PHOTO_FLAG",
     "type": "esriFieldTypeSmallInteger",
     "alias": "PRIMARY_PHOTO_FLAG",
     "domain": null
    },
    {
     "name": "WEB_PHOTO_FLAG",
     "type": "esriFieldTypeSmallInteger",
     "alias": "WEB_PHOTO_FLAG",
     "domain": null
    },
    {
     "name": "PHOTO_TYPE",
     "type": "esriFieldTypeString",
     "alias": "PHOTO_TYPE",
     "length": 20,
     "domain": null
    },
    {
     "name": "DOCUMENT_TYPE",
     "type": "esriFieldTypeString",
     "alias": "DOCUMENT_TYPE",
     "length": 20,
     "domain": null
    },
    {
     "name": "UPLOAD_DATE",
     "type": "esriFieldTypeDate",
     "alias": "UPLOAD_DATE",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "UPLOADED_BY",
     "type": "esriFieldTypeString",
     "alias": "UPLOADED_BY",
     "length": 30,
     "domain": null
    },
    {
     "name": "UPDATE_DATE",
     "type": "esriFieldTypeDate",
     "alias": "UPDATE_DATE",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "UPDATED_BY",
     "type": "esriFieldTypeString",
     "alias": "UPDATED_BY",
     "length": 30,
     "domain": null
    },
    {
     "name": "FIRST_TAX_YEAR",
     "type": "esriFieldTypeSmallInteger",
     "alias": "FIRST_TAX_YEAR",
     "domain": null
    },
    {
     "name": "ORIGIN_ID",
     "type": "esriFieldTypeGUID",
     "alias": "ORIGIN_ID",
     "length": 38,
     "domain": null
    },
    {
     "name": "AZURE_BLOB_URL",
     "type": "esriFieldTypeString",
     "alias": "AZURE_BLOB_URL",
     "length": 500,
     "domain": null
    },
    {
     "name": "EXPORT_DATE",
     "type": "esriFieldTypeDate",
     "alias": "EXPORT_DATE",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "INSERT_DATE",
     "type": "esriFieldTypeDate",
     "alias": "INSERT_DATE",
     "length": 8,
     "precision": 1,
     "domain": null
    },
    {
     "name": "EXPORT_FILE_NAME",
     "type": "esriFieldTypeString",
     "alias": "EXPORT_FILE_NAME",
     "length": 100,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "IDX_MEDIA_STATS_ORIGIN",
     "fields": "MEDIA_ID,ORIGIN_ID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "IDX_MEDIA_STATS_ID",
     "fields": "MEDIA_ID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "PK_MEDIA_STATS",
     "fields": "ID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "IDX_MEDIA_STATS_PARCEL",
     "fields": "JURISDICTION,RECORD_TYPE,PARCEL_ID,TAX_YEAR,PHOTO_TYPE,IMP_NO,ACTIVE_FLAG,ATTACHED_TO,LAND_DETAIL_ID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "FDO_ID",
     "fields": "ID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "uniqueIdInfo": {
    "type": "simple",
    "fields": [
     "ID"
    ],
    "OIDFieldContainsHashValue": false
   },
   "maxUniqueIDCount": 100000,
   "serviceItemId": "c3c940e0a517479c8294a6225fbe8f79"
  }
 ]
}