{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "CartSmart_Visits", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CONTAMINANTS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ADDRESS_VISITED", "type": "esriFieldTypeSmallInteger", "alias": "ADDRESS_VISITED", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CART_BLUE", "type": "esriFieldTypeSmallInteger", "alias": "CART_BLUE", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CART_BROWN", "type": "esriFieldTypeSmallInteger", "alias": "CART_BROWN", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CART_GREEN", "type": "esriFieldTypeSmallInteger", "alias": "CART_GREEN", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OVERFILLED", "type": "esriFieldTypeSmallInteger", "alias": "OVERFILLED", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GARBAGE_BAG", "type": "esriFieldTypeSmallInteger", "alias": "GARBAGE_BAG", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BAGGED_REYC", "type": "esriFieldTypeSmallInteger", "alias": "BAGGED_REYC", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NESTED_MAT", "type": "esriFieldTypeSmallInteger", "alias": "NESTED_MAT", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VOLUME", "type": "esriFieldTypeInteger", "alias": "VOLUME", "domain": { "type": "codedValue", "name": "CartSmart_Vol", "description": "CartSmart Volume Range", "codedValues": [ { "name": "10%", "code": 1 }, { "name": "25%", "code": 2 }, { "name": "50%", "code": 3 }, { "name": "75%", "code": 4 }, { "name": "100%", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTAMINANTS", "type": "esriFieldTypeString", "alias": "CONTAMINANTS", "length": 255, "domain": null }, { "name": "OOPS_CON", "type": "esriFieldTypeSmallInteger", "alias": "OOPS_CON", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OOPS_HAZMAT", "type": "esriFieldTypeSmallInteger", "alias": "OOPS_HAZMAT", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STICKER", "type": "esriFieldTypeSmallInteger", "alias": "STICKER", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 800, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "DATE_VISITED", "type": "esriFieldTypeDate", "alias": "DATE_VISITED", "length": 8, "domain": null }, { "name": "COUNT_VISIT", "type": "esriFieldTypeInteger", "alias": "COUNT_VISIT", "domain": null }, { "name": "CON_STRECYPLAS", "type": "esriFieldTypeSmallInteger", "alias": "Stretchy_Plastic", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_CRINKLYPLAS", "type": "esriFieldTypeSmallInteger", "alias": "Crinkly_Plastic", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_MISCPLAS", "type": "esriFieldTypeSmallInteger", "alias": "Misc_Plastic", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_FOODWASTE", "type": "esriFieldTypeSmallInteger", "alias": "Food_Waste", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_YARDWASTE", "type": "esriFieldTypeSmallInteger", "alias": "Yard_Waste", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_STYROF", "type": "esriFieldTypeSmallInteger", "alias": "Styrofoam", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_PLASSTRACUT", "type": "esriFieldTypeSmallInteger", "alias": "Plastic_StrawCutlery", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_TISSUES", "type": "esriFieldTypeSmallInteger", "alias": "Tissues", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_WAXEDCUPPA", "type": "esriFieldTypeSmallInteger", "alias": "Waxed_Paper_Cup", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_LAMPAPER", "type": "esriFieldTypeSmallInteger", "alias": "Laminated_Paper", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_SMALLPLAS", "type": "esriFieldTypeSmallInteger", "alias": "Small_Plastic", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_OTHER", "type": "esriFieldTypeSmallInteger", "alias": "Other_Contaminate", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_HOUSEHOLD", "type": "esriFieldTypeSmallInteger", "alias": "Household_Waste", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_METALS", "type": "esriFieldTypeSmallInteger", "alias": "Metals", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_BUILDMATS", "type": "esriFieldTypeSmallInteger", "alias": "Building_Materials", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_ELECTRONICS", "type": "esriFieldTypeSmallInteger", "alias": "Electronics", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_HHW", "type": "esriFieldTypeSmallInteger", "alias": "Household_HazWaste", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_TEXTILES", "type": "esriFieldTypeSmallInteger", "alias": "Textiles", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_PLASRECY", "type": "esriFieldTypeSmallInteger", "alias": "Plastic_Recycling", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_PETWASTE", "type": "esriFieldTypeSmallInteger", "alias": "Pet_Waste", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_COMPLAS", "type": "esriFieldTypeSmallInteger", "alias": "Compostable_Plastic", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_WOOD", "type": "esriFieldTypeSmallInteger", "alias": "Wood", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_GLASS", "type": "esriFieldTypeSmallInteger", "alias": "Glass", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_PERSONALHY", "type": "esriFieldTypeSmallInteger", "alias": "Personal_Hygiene", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_DIAPERS", "type": "esriFieldTypeSmallInteger", "alias": "Diapers", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GLOBALID_C", "length": 38, "domain": null }, { "name": "CON_BAGGEDPLAS", "type": "esriFieldTypeSmallInteger", "alias": "Bagged_Plastic", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_BIOPLAS", "type": "esriFieldTypeSmallInteger", "alias": "Bagged_Bioplastics", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CON_FOODINPCKG", "type": "esriFieldTypeSmallInteger", "alias": "Food_InPackaging", "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A numerical Yes No field", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } } ], "indexes": [ { "name": "G155963GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R2019970_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2019970", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CartSmart", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }