{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 23, "name": "Building Janitorial Issues", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SpaceType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "SpaceType", "type": "esriFieldTypeString", "alias": "SpaceType", "length": 75, "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" } }, { "name": "SpaceNum", "type": "esriFieldTypeString", "alias": "SpaceNum", "length": 30, "domain": null }, { "name": "Building", "type": "esriFieldTypeString", "alias": "Building", "length": 30, "domain": null }, { "name": "Floor", "type": "esriFieldTypeString", "alias": "Floor", "length": 30, "domain": null }, { "name": "Issues", "type": "esriFieldTypeString", "alias": "Issues", "length": 150, "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" } }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 15, "domain": { "type": "codedValue", "name": "BuildingJanitorialStatus", "description": "Active or Inactive Issue", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "OCDPW.DPW_BuildingInteriorSpaces_Second", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B0883012-1230-4691-A7AF-A0D2F3353FE4}" }, { "id": 17, "name": "OCDPW.DPW_BuildingInteriorSpaces_Fourth", "relatedTableId": 17, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B873DC02-7820-4DB8-9F45-CC41B614BD2B}" }, { "id": 14, "name": "OCDPW.DPW_BuildingInteriorSpaces_First", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FE38CDB9-21DE-4F5D-819B-5FC273DA39EF}" }, { "id": 9, "name": "OCDPW.DPW_BuildingInteriorSpace", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{20ABF5D7-A6E1-4110-AD76-A9D87F60CC83}" }, { "id": 18, "name": "OCDPW.DPW_BuildingInteriorSpaces_Mechanical", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{233577E6-6133-448F-8B68-EF10FAC3E793}" }, { "id": 13, "name": "OCDPW.DPW_BuildingInteriorSpaces_Basement", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{289DB71A-65CF-4B09-AD44-888557AEDF6F}" }, { "id": 16, "name": "OCDPW.DPW_BuildingInteriorSpaces_Third", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{67E64AA4-D2C0-475E-8F4E-BF8E3AC279BA}" }, { "id": 7, "name": "OCDPW.DPW_BuildingInteriorSpaces_Fifth", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C1E4BC37-6384-4C99-A5F4-FAFFB66730DC}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "3531178ad1bc43e7956545517d3d6857" }