{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "maxUniqueIDCount": 100000, "type": "Table", "subtypes": [], "relationships": [], "indexes": [ { "name": "IDX_SKETCH_MEDIA_STATS_ORIGIN", "isUnique": false, "description": "", "fields": "ORIGIN_ID,JURISDICTION,RECORD_TYPE,PARCEL_ID,TAX_YEAR,SKETCH_ID,ACTIVE_FLAG", "isAscending": true }, { "name": "IDX_SKETCH_MEDIA_STATS_PARCEL", "isUnique": false, "description": "", "fields": "JURISDICTION,RECORD_TYPE,PARCEL_ID,TAX_YEAR", "isAscending": true }, { "name": "IDX_SKETCH_MEDIA_STATUS_ID_JURIS", "isUnique": false, "description": "", "fields": "SKETCH_MEDIA_ID,JURISDICTION", "isAscending": true }, { "name": "IDX_SKETCH_MEDIA_STATS_EXPORT_DATE", "isUnique": false, "description": "", "fields": "EXPORT_DATE", "isAscending": true }, { "name": "IDX_SKETCH_MEDIA_STATS_ID", "isUnique": false, "description": "", "fields": "SKETCH_MEDIA_ID", "isAscending": true }, { "name": "PK_SKETCH_MEDIA_STATS", "isUnique": true, "description": "", "fields": "SKETCH_MEDIA_ID", "isAscending": true }, { "name": "IDX_SKETCH_MEDIA_STATS_ACTIVE", "isUnique": false, "description": "", "fields": "JURISDICTION,RECORD_TYPE,PARCEL_ID,TAX_YEAR,SKETCH_ID,ACTIVE_FLAG,SKETCH_MEDIA_ID,VERSION,MEDIA_TYPE,MEDIA_GROUP_ID,MEDIA_THUMB,FILE_EXTENSION,FILE_NAME,FILE_SIZE,IMAGE_HEIGHT,IMAGE_WIDTH,CONTENT_TYPE,ATTACHED_TO,IMP_NO,PAGE_IDX,COMMENTS,PHOTO_TYPE,DOCUMENT_TYPE,UPLOAD_DATE,UPLOADED_BY,UPDATE_DATE,UPDATED_BY,FIRST_TAX_YEAR,ORIGIN_ID,AZURE_BLOB_URL,EXPORT_FILE_NAME,INSERT_DATE,EXPORT_DATE", "isAscending": true }, { "name": "FDO_SKETCH_MEDIA_ID", "isUnique": true, "description": "", "fields": "SKETCH_MEDIA_ID", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 0, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "312cc56d4ffd4d2fa93a12c3a4a1896a", "capabilities": "Map,Query,Data", "uniqueIdInfo": { "type": "simple", "fields": ["SKETCH_MEDIA_ID"], "OIDFieldContainsHashValue": true }, "supportsExceedsLimitStatistics": true, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "CAMA.SKETCH_MEDIA_STATS", "displayField": "FILE_NAME", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "SKETCH_MEDIA_ID", "length": 38, "alias": "SKETCH_MEDIA_ID", "type": "esriFieldTypeGUID" }, { "nullable": false, "domain": null, "name": "JURISDICTION", "alias": "JURISDICTION", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "VERSION", "alias": "VERSION", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "RECORD_TYPE", "length": 1, "alias": "RECORD_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PARCEL_ID", "length": 36, "alias": "PARCEL_ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "TAX_YEAR", "alias": "TAX_YEAR", "type": "esriFieldTypeSmallInteger" }, { "nullable": false, "domain": null, "name": "MEDIA_TYPE", "length": 20, "alias": "MEDIA_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "MEDIA_GROUP_ID", "length": 38, "alias": "MEDIA_GROUP_ID", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "MEDIA_THUMB", "length": 1073741822, "alias": "MEDIA_THUMB", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FILE_EXTENSION", "length": 10, "alias": "FILE_EXTENSION", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "FILE_NAME", "length": 200, "alias": "FILE_NAME", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "FILE_SIZE", "alias": "FILE_SIZE", "type": "esriFieldTypeBigInteger" }, { "nullable": true, "domain": null, "name": "IMAGE_HEIGHT", "alias": "IMAGE_HEIGHT", "type": "esriFieldTypeBigInteger" }, { "nullable": true, "domain": null, "name": "IMAGE_WIDTH", "alias": "IMAGE_WIDTH", "type": "esriFieldTypeBigInteger" }, { "nullable": false, "domain": null, "name": "CONTENT_TYPE", "length": 200, "alias": "CONTENT_TYPE", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "ATTACHED_TO", "length": 20, "alias": "ATTACHED_TO", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "IMP_NO", "alias": "IMP_NO", "type": "esriFieldTypeBigInteger" }, { "nullable": true, "domain": null, "name": "SKETCH_ID", "alias": "SKETCH_ID", "type": "esriFieldTypeBigInteger" }, { "nullable": true, "domain": null, "name": "PAGE_IDX", "alias": "PAGE_IDX", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "COMMENTS", "length": 4000, "alias": "COMMENTS", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "ACTIVE_FLAG", "alias": "ACTIVE_FLAG", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "PHOTO_TYPE", "length": 20, "alias": "PHOTO_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DOCUMENT_TYPE", "length": 20, "alias": "DOCUMENT_TYPE", "type": "esriFieldTypeString" }, { "nullable": false, "precision": 1, "domain": null, "name": "UPLOAD_DATE", "length": 8, "alias": "UPLOAD_DATE", "type": "esriFieldTypeDate" }, { "nullable": false, "domain": null, "name": "UPLOADED_BY", "length": 30, "alias": "UPLOADED_BY", "type": "esriFieldTypeString" }, { "nullable": false, "precision": 1, "domain": null, "name": "UPDATE_DATE", "length": 8, "alias": "UPDATE_DATE", "type": "esriFieldTypeDate" }, { "nullable": false, "domain": null, "name": "UPDATED_BY", "length": 30, "alias": "UPDATED_BY", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "FIRST_TAX_YEAR", "alias": "FIRST_TAX_YEAR", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ORIGIN_ID", "length": 38, "alias": "ORIGIN_ID", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "AZURE_BLOB_URL", "length": 500, "alias": "AZURE_BLOB_URL", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "EXPORT_FILE_NAME", "length": 100, "alias": "EXPORT_FILE_NAME", "type": "esriFieldTypeString" }, { "nullable": true, "precision": 1, "domain": null, "name": "INSERT_DATE", "length": 8, "alias": "INSERT_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "EXPORT_DATE", "length": 8, "alias": "EXPORT_DATE", "type": "esriFieldTypeDate" }, { "nullable": false, "domain": null, "name": "ESRI_OID", "length": 8, "alias": "ESRI_OID", "type": "esriFieldTypeOID" } ], "dateFieldsTimeReference": null }