{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 23, "name": "Building Janitorial Issues", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": {"creationDateField": "Date"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 15, "name": "OCDPW.DPW_BuildingInteriorSpaces_Second", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{B0883012-1230-4691-A7AF-A0D2F3353FE4}" }, { "id": 17, "name": "OCDPW.DPW_BuildingInteriorSpaces_Fourth", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{B873DC02-7820-4DB8-9F45-CC41B614BD2B}" }, { "id": 14, "name": "OCDPW.DPW_BuildingInteriorSpaces_First", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{FE38CDB9-21DE-4F5D-819B-5FC273DA39EF}" }, { "id": 9, "name": "OCDPW.DPW_BuildingInteriorSpace", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{20ABF5D7-A6E1-4110-AD76-A9D87F60CC83}" }, { "id": 18, "name": "OCDPW.DPW_BuildingInteriorSpaces_Mechanical", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{233577E6-6133-448F-8B68-EF10FAC3E793}" }, { "id": 13, "name": "OCDPW.DPW_BuildingInteriorSpaces_Basement", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{289DB71A-65CF-4B09-AD44-888557AEDF6F}" }, { "id": 16, "name": "OCDPW.DPW_BuildingInteriorSpaces_Third", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{67E64AA4-D2C0-475E-8F4E-BF8E3AC279BA}" }, { "id": 7, "name": "OCDPW.DPW_BuildingInteriorSpaces_Fifth", "relatedTableId": 19, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{C1E4BC37-6384-4C99-A5F4-FAFFB66730DC}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "SpaceType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "SpaceType", "type": "esriFieldTypeString", "alias": "SpaceType", "domain": { "type": "codedValue", "name": "BuildingJanitorialSpaceType", "description": "Space Types for Janitorial Issues", "codedValues": [ { "name": "Restroom", "code": "Restroom" }, { "name": "Kitchen", "code": "Kitchen" }, { "name": "Break Room", "code": "Break Room" }, { "name": "Office", "code": "Office" }, { "name": "Office Cubicle", "code": "Office Cubicle" }, { "name": "Hallway", "code": "Hallway" }, { "name": "Entry Lobby", "code": "Entry Lobby" }, { "name": "Laundry", "code": "Laundry" }, { "name": "Conference Room", "code": "Conference Room" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "SpaceType" }, { "name": "SpaceNum", "type": "esriFieldTypeString", "alias": "SpaceNum", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SpaceNum" }, { "name": "Building", "type": "esriFieldTypeString", "alias": "Building", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Building" }, { "name": "Floor", "type": "esriFieldTypeString", "alias": "Floor", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Floor" }, { "name": "Issues", "type": "esriFieldTypeString", "alias": "Issues", "domain": { "type": "codedValue", "name": "BuildingJanitorialIssues", "description": "Noted Janitorial Issues", "codedValues": [ { "name": "Carpets/Baseboards", "code": "Carpets/Baseboards" }, { "name": "Cobwebs on Walls, Ceiling or Windowsills", "code": "Cobwebs on Walls, Ceiling or Windowsills" }, { "name": "Countertops", "code": "Countertops" }, { "name": "Dispenser Dirty on Outside", "code": "Dispenser Dirty on Outside" }, { "name": "Dispenser Not Filled (Toilet Paper, Soap, Paper Towels)", "code": "Dispenser Not Filled (Toilet Paper, Soap, Paper Towels)" }, { "name": "Door Glass", "code": "Door Glass" }, { "name": "Floor", "code": "Floor" }, { "name": "Floor Dirt & Debris", "code": "Floor Dirt & Debris" }, { "name": "Garbage Cans Dirty", "code": "Garbage Cans Dirty" }, { "name": "Garbage Not Taken", "code": "Garbage Not Taken" }, { "name": "High & Low Dusting (Bookcases, Top of Cubicles)", "code": "High & Low Dusting (Bookcases, Top of Cubicles)" }, { "name": "Inside Sinks", "code": "Inside Sinks" }, { "name": "Inside Toilet", "code": "Inside Toilet" }, { "name": "Inside Urinals", "code": "Inside Urinals" }, { "name": "Interior Door Glass", "code": "Interior Door Glass" }, { "name": "Interior Office Windowsills", "code": "Interior Office Windowsills" }, { "name": "Microwave Inside/Outside", "code": "Microwave Inside/Outside" }, { "name": "Mirrors", "code": "Mirrors" }, { "name": "Outside Sinks", "code": "Outside Sinks" }, { "name": "Outside Toilet", "code": "Outside Toilet" }, { "name": "Outside Urinals", "code": "Outside Urinals" }, { "name": "Recycling Not Taken", "code": "Recycling Not Taken" }, { "name": "Refrigerator Outside", "code": "Refrigerator Outside" }, { "name": "Showers", "code": "Showers" }, { "name": "Sink Dirty", "code": "Sink Dirty" }, { "name": "Sink/Drinking Fountain Not Cleaned w/Stainless Steel Cleaner", "code": "Sink/Drinking Fountain Not Cleaned w/Stainless Steel Cleaner" }, { "name": "Tables", "code": "Tables" }, { "name": "Walls", "code": "Walls" }, { "name": "Walls/Partitions", "code": "Walls/Partitions" }, { "name": "Water Marks", "code": "Water Marks" }, { "name": "Windowsills", "code": "Windowsills" }, { "name": "Equipment Left Out", "code": "Equipment Left Out" }, { "name": "Improper Recycling Disposal", "code": "Improper Recycling Disposal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Issues" }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "BuildingJanitorialStatus", "description": "Active or Inactive Issue", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "Active", "modelName": "Status" } ], "indexes": [ { "name": "R417_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_417", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_417", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2774_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Building Janitorial Issues", "description": "", "prototype": { "attributes": { "GUID": null, "Issues": null, "Status": "Active", "Floor": null, "SpaceType": null, "SpaceNum": null, "Building": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "efdb09e89d7a44528455037bbfa5cf21" }