{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Dumpster Inspection Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "CommercialMultiFamilyDumpsterLoc", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "DUMPSTEROBJECTID", "composite": false, "catalogID": "{A6505E20-D47E-47F4-A5C5-48880E21BC01}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ComDumpsterIssues", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ComDumpsterIssues", "type": "esriFieldTypeString", "alias": "Com Dumpster Issues", "domain": { "type": "codedValue", "name": "DumpsterIssues", "description": "Dumpster Concern and Issues", "codedValues": [ { "name": "Overage", "code": "Overage" }, { "name": "Incorrect Placement", "code": "Incorrect Placement" }, { "name": "Fire Damage", "code": "Fire Damge" }, { "name": "Prohibited Materials - Hazardous Materials", "code": "Hazardous Materials" }, { "name": "Container Rusted or Holes", "code": "Container Rusted" }, { "name": "Wheel Damaged or Missing", "code": "Wheel Damaged" }, { "name": "Lid Cracked or Missing", "code": "Lid Cracked" }, { "name": "Label Faded or Missing", "code": "Label Faded" }, { "name": "Prohibited Materials - Construction and Demolition", "code": "Construction and Demolition" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComDumpsterIssues" }, { "name": "ComDumsterIssuesResolved", "type": "esriFieldTypeString", "alias": "Com Dumster Issues Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComDumsterIssuesResolved" }, { "name": "ComRollOffDumsterConcernIssues", "type": "esriFieldTypeString", "alias": "Com Roll Off Dumster Concern Issues", "domain": { "type": "codedValue", "name": "RolloffDumpsterIssues", "description": "Roll Off Dumpster Concern and Issues", "codedValues": [ { "name": "Incorrect Placement", "code": "Incorrect Placement" }, { "name": "Gate Unable to Open or Close", "code": "Gate Unable to Open" }, { "name": "Graffiti Paint", "code": "Graffiti Paint" }, { "name": "Container Rusted or Holes", "code": "Container Rusted" }, { "name": "Label faded or Missing", "code": "Label Faded" }, { "name": "Missed Delivery Date", "code": "Missed Delivery Date" }, { "name": "Missed Removal Date", "code": "Missed Removal Date" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComRollOffDumsterConcernIssues" }, { "name": "ComRollOffDumsterConcernIssuesR", "type": "esriFieldTypeString", "alias": "Com Roll Off Dumster Concern Issues Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComRollOffDumsterConcernIssuesResolved" }, { "name": "ComEnclosureConcernIssues", "type": "esriFieldTypeString", "alias": "Com Enclosure Concern Issues", "domain": { "type": "codedValue", "name": "EnclosureConcernIssues", "description": "Enclosure Concern and Issues", "codedValues": [ { "name": "Debris Left on Ground", "code": "Debris" }, { "name": "Gate or Door Damage or Missing", "code": "Gate Door Damage" }, { "name": "Bulk Items Inside or Outside", "code": "Bulk Items" }, { "name": "Hazardous Materials Inside or Outside", "code": "Hazardous Materials" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComEnclosureConcernIssues" }, { "name": "ComEnclosureConcernIssuesResolv", "type": "esriFieldTypeString", "alias": "Com Enclosure Concern Issues Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComEnclosureConcernIssuesResolved" }, { "name": "ComCollectionVehicle", "type": "esriFieldTypeString", "alias": "Com Collection Vehicle", "domain": { "type": "codedValue", "name": "CollectionVehicle", "description": "Collection Vehicle", "codedValues": [ { "name": "No Tarp in Use", "code": "No Tarp" }, { "name": "Vehicle Requires Washing", "code": "Vehicle Requires Washing" }, { "name": "Decal Faded or Missing", "code": "Decal Faded" }, { "name": "Erratic Driving", "code": "Erratic Driving" }, { "name": "Leaking Leachate", "code": "Leaking Leachate" }, { "name": "Leaking Oil", "code": "Leaking Oil" }, { "name": "Fire Damage", "code": "Fire Damage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComCollectionVehicle" }, { "name": "ComCollectionVehicleResolved", "type": "esriFieldTypeString", "alias": "Com Collection Vehicle Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComCollectionVehicleResolved" }, { "name": "ComSitePropertyConcernsIssues", "type": "esriFieldTypeString", "alias": "Com Site Property Concerns Issues", "domain": { "type": "codedValue", "name": "SitePropertyConcernsIssues", "description": "Site Property Concerns and Issues", "codedValues": [ { "name": "Dumpster Left Outside Enclosure", "code": "Dumpster Outside" }, { "name": "Debris Left in Roadway", "code": "Debris in Roadway" }, { "name": "Property Damage Structure", "code": "Property Damage Structure" }, { "name": "Property Damage Enclosure", "code": "Property Damage Enclosure" }, { "name": "Property Damage Mailbox", "code": "Property Damage Mailbox" }, { "name": "Property Damage Landscape or Swale", "code": "Property Damage Landscape" }, { "name": "Property Damge Vehicle", "code": "Property Damage Vehicle" }, { "name": "Property Damage Oil", "code": "Property Damage Oil" }, { "name": "Oil Spill", "code": "Oil Spill" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComSitePropertyConcernsIssues" }, { "name": "ComSitePropertyConcernsIssuesRe", "type": "esriFieldTypeString", "alias": "Com Site Property Concerns Issues", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComSitePropertyConcernsIssuesResolved" }, { "name": "ComDumpsterMissedCollection", "type": "esriFieldTypeString", "alias": "ComDumpsterIssues", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComDumpsterMissedCollection" }, { "name": "ComDumpsterMissedCollectionCons", "type": "esriFieldTypeString", "alias": "Com Dumpster Missed Collection Construction and Demolition", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComDumpsterMissedCollectionConstructionandDemolition" }, { "name": "ComDumpsterMissedCollectionHaza", "type": "esriFieldTypeString", "alias": "Com Dumpster Missed Collection Hazardous Materials", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComDumpsterMissedCollectionHazardousMaterials" }, { "name": "ComDumpsterMissedCollectionTooH", "type": "esriFieldTypeString", "alias": "Com Dumpster Missed Collection Too Heavy", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComDumpsterMissedCollectionTooHeavy" }, { "name": "ComSitePropertyConcernIssuesRes", "type": "esriFieldTypeDate", "alias": "Commercial Site Property Concern Issues Resolved Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComSitePropertyConcernIssuesResolvedDate" }, { "name": "ComSitePropertyConcernIssuesR_1", "type": "esriFieldTypeString", "alias": "Commercial Site Property Concern Issues Resolved Comment", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComSitePropertyConcernIssuesResolvedComment" }, { "name": "ComSitePropertyConcernIssuesR_2", "type": "esriFieldTypeDate", "alias": "Commercial Site Property Concern Issues Resolved Follow Up Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComSitePropertyConcernIssuesResolvedFollowUpDate" }, { "name": "ComRollOffDumpsterConcernIssues", "type": "esriFieldTypeString", "alias": "Commercial Roll Off Dumpster", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComRollOffDumpsterConcernIssues" }, { "name": "ComRollOffDumpsterConcernIssu_1", "type": "esriFieldTypeDate", "alias": "Commercial Roll Off DumpsterConcern Issues Resolved Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComRollOffDumpsterConcernIssu_1" }, { "name": "ComRollOffDumpsterConcernIssu_2", "type": "esriFieldTypeString", "alias": "Com Roll Off Dumpster Concern Issues Resolved Comments", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComRollOffDumpsterConcernIssu_2" }, { "name": "ComRollOffDumpsterConcernIssu_3", "type": "esriFieldTypeDate", "alias": "Commercial Roll Off Dumpster Concern Issues Resolved Follow Up Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComRollOffDumpsterConcernIssu_3" }, { "name": "ComEnclosureConcernIssuesYesNo", "type": "esriFieldTypeString", "alias": "Commercial Enclosure Concern Issues Yes or No", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComEnclosureConcernIssuesYesNo" }, { "name": "ComEnclosureConcernIssuesReso_1", "type": "esriFieldTypeDate", "alias": "Commercial Enclosure Concern Issues Resolved Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComEnclosureConcernIssuesReso_1" }, { "name": "ComEnclosureConcernIssuesReso_2", "type": "esriFieldTypeString", "alias": "Commercial Enclosure Concern Issues Resolved Comments", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComEnclosureConcernIssuesReso_2" }, { "name": "ComEnclosureConcernIssuesFollow", "type": "esriFieldTypeDate", "alias": "Commercial Enclosure Concern Issues Follow Up Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComEnclosureConcernIssuesFollow" }, { "name": "ComCollectionVehicleYesNo", "type": "esriFieldTypeString", "alias": "Commercial Collection Vehicle Yes No", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComCollectionVehicleYesNo" }, { "name": "ComCollectionVehicleResolvedDat", "type": "esriFieldTypeDate", "alias": "Commercial Collection Vehicle Resolved Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComCollectionVehicleResolvedDat" }, { "name": "ComCollectionVehicleResolvedCom", "type": "esriFieldTypeString", "alias": "Commercial Collection Vehicle Resolved Comments", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComCollectionVehicleResolvedCom" }, { "name": "ComCollectionVehicleFollowUpDat", "type": "esriFieldTypeDate", "alias": "Commercial Collection Vehicle Follow Up Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComCollectionVehicleFollowUpDat" }, { "name": "ComSitePropertyConcernsIssuesYe", "type": "esriFieldTypeString", "alias": "Commercial Site Property Concerns Issues Yes No", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Domain", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ComSitePropertyConcernsIssuesYe" }, { "name": "ComDumpsterIssuesResolvedDate", "type": "esriFieldTypeDate", "alias": "Commercial Dumpster Issues Resolved Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComDumpsterIssuesResolvedDate" }, { "name": "ComDumpsterIssuesResolvedCommen", "type": "esriFieldTypeString", "alias": "Commercial Dumpster Issues Resolved Comments", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ComDumpsterIssuesResolvedCommen" }, { "name": "ComDumpsterIssuesFollowUpDate", "type": "esriFieldTypeDate", "alias": "Commercial Dumpster Issues Follow Up Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ComDumpsterIssuesFollowUpDate" }, { "name": "DUMPSTEROBJECTID", "type": "esriFieldTypeInteger", "alias": "DUMPSTEROBJECTID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DUMPSTEROBJECTID" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspector" } ], "indexes": [ { "name": "R361_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "GDB_309_DUMPSTER", "isAscending": true, "isUnique": false, "description": "", "fields": "DUMPSTEROBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Dumpster Inspection Table", "description": "", "prototype": { "attributes": { "DUMPSTEROBJECTID": null, "Inspector": null, "ComDumpsterIssues": null, "ComDumsterIssuesResolved": null, "ComRollOffDumsterConcernIssues": null, "ComRollOffDumsterConcernIssuesR": null, "ComEnclosureConcernIssues": null, "ComEnclosureConcernIssuesResolv": null, "ComCollectionVehicle": null, "ComCollectionVehicleResolved": null, "ComSitePropertyConcernsIssues": null, "ComSitePropertyConcernsIssuesRe": null, "ComDumpsterMissedCollection": null, "ComDumpsterMissedCollectionCons": null, "ComDumpsterMissedCollectionHaza": null, "ComDumpsterMissedCollectionTooH": null, "ComSitePropertyConcernIssuesRes": null, "ComSitePropertyConcernIssuesR_1": null, "ComSitePropertyConcernIssuesR_2": null, "ComRollOffDumpsterConcernIssues": null, "ComRollOffDumpsterConcernIssu_1": null, "ComRollOffDumpsterConcernIssu_2": null, "ComRollOffDumpsterConcernIssu_3": null, "ComEnclosureConcernIssuesYesNo": null, "ComEnclosureConcernIssuesReso_1": null, "ComEnclosureConcernIssuesReso_2": null, "ComEnclosureConcernIssuesFollow": null, "ComCollectionVehicleYesNo": null, "ComCollectionVehicleResolvedDat": null, "ComCollectionVehicleResolvedCom": null, "ComCollectionVehicleFollowUpDat": null, "ComSitePropertyConcernsIssuesYe": null, "ComDumpsterIssuesResolvedDate": null, "ComDumpsterIssuesResolvedCommen": null, "ComDumpsterIssuesFollowUpDate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "e38fa64605804b45aea4b3f9bbbddc82" }