{ "tables": [{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "maxUniqueIDCount": 100000, "type": "Table", "subtypes": [], "relationships": [], "indexes": [ { "name": "IDX_MEDIA_STATS_ORIGIN", "isUnique": false, "description": "", "fields": "MEDIA_ID,ORIGIN_ID", "isAscending": true }, { "name": "IDX_MEDIA_STATS_ID", "isUnique": false, "description": "", "fields": "MEDIA_ID", "isAscending": true }, { "name": "PK_MEDIA_STATS", "isUnique": true, "description": "", "fields": "ID", "isAscending": true }, { "name": "IDX_MEDIA_STATS_PARCEL", "isUnique": false, "description": "", "fields": "JURISDICTION,RECORD_TYPE,PARCEL_ID,TAX_YEAR,PHOTO_TYPE,IMP_NO,ACTIVE_FLAG,ATTACHED_TO,LAND_DETAIL_ID", "isAscending": true }, { "name": "FDO_ID", "isUnique": true, "description": "", "fields": "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": "c3c940e0a517479c8294a6225fbe8f79", "capabilities": "Map,Query,Data", "uniqueIdInfo": { "type": "simple", "fields": ["ID"], "OIDFieldContainsHashValue": false }, "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.MEDIA_STATS", "displayField": "FILE_NAME", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "ID", "alias": "ID", "type": "esriFieldTypeOID" }, { "nullable": false, "domain": null, "name": "MEDIA_ID", "length": 38, "alias": "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": true, "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": "CACHE_PATH", "length": 500, "alias": "CACHE_PATH", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FILE_EXTENSION", "length": 10, "alias": "FILE_EXTENSION", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FILE_NAME", "length": 200, "alias": "FILE_NAME", "type": "esriFieldTypeString" }, { "nullable": true, "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": true, "domain": null, "name": "ATTACHED_TO", "length": 20, "alias": "ATTACHED_TO", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "IS_FILESTREAM", "alias": "IS_FILESTREAM", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "IMP_NO", "alias": "IMP_NO", "type": "esriFieldTypeBigInteger" }, { "nullable": true, "domain": null, "name": "LAND_DETAIL_ID", "alias": "LAND_DETAIL_ID", "type": "esriFieldTypeBigInteger" }, { "nullable": true, "domain": null, "name": "SEGMENT_ID", "alias": "SEGMENT_ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "SECTION_NUMBER", "alias": "SECTION_NUMBER", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "BUILDING_NO", "alias": "BUILDING_NO", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "WING_ID", "alias": "WING_ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "BATCH_ID", "length": 38, "alias": "BATCH_ID", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "JOB_DEFINITION_ID", "length": 38, "alias": "JOB_DEFINITION_ID", "type": "esriFieldTypeGUID" }, { "nullable": true, "domain": null, "name": "PERMIT_ID", "length": 38, "alias": "PERMIT_ID", "type": "esriFieldTypeGUID" }, { "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": false, "domain": null, "name": "PRIMARY_PHOTO_FLAG", "alias": "PRIMARY_PHOTO_FLAG", "type": "esriFieldTypeSmallInteger" }, { "nullable": false, "domain": null, "name": "WEB_PHOTO_FLAG", "alias": "WEB_PHOTO_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": true, "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": true, "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, "precision": 1, "domain": null, "name": "EXPORT_DATE", "length": 8, "alias": "EXPORT_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "INSERT_DATE", "length": 8, "alias": "INSERT_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "EXPORT_FILE_NAME", "length": 100, "alias": "EXPORT_FILE_NAME", "type": "esriFieldTypeString" } ], "dateFieldsTimeReference": null }], "layers": [] }