{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "GIS.CartSmart", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26913, "latestWkid": 26913, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 153, 110, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 521391.234, "ymin": 5582897.0884, "xmax": 533565.6762, "ymax": 5594292.6908, "spatialReference": { "wkid": 26913, "latestWkid": 26913, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "GIS.CartSmart.ADDRESS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GIS.CartSmart.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS.CartSmart.ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "GIS.CartSmart.PREM_CODE", "type": "esriFieldTypeString", "alias": "PREM_CODE", "length": 30, "domain": null }, { "name": "GIS.CartSmart.TEAM", "type": "esriFieldTypeSmallInteger", "alias": "TEAM", "domain": null }, { "name": "GIS.CartSmart.ROUTE", "type": "esriFieldTypeString", "alias": "ROUTE", "length": 255, "domain": null }, { "name": "GIS.CartSmart.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GIS.CartSmart.GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "GIS.CARTSMART_VISITS_V.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "GIS.CARTSMART_VISITS_V.GUID", "type": "esriFieldTypeString", "alias": "GUID", "length": 38, "domain": null }, { "name": "GIS.CARTSMART_VISITS_V.ADDRESS_VISITED", "type": "esriFieldTypeInteger", "alias": "ADDRESS_VISITED", "domain": null }, { "name": "GIS.CARTSMART_VISITS_V.DATE_VISITED", "type": "esriFieldTypeDate", "alias": "DATE_VISITED", "length": 8, "domain": null }, { "name": "GIS.CARTSMART_VISITS_V.STICKER", "type": "esriFieldTypeInteger", "alias": "GIS.CARTSMART_VISITS_V.STICKER", "domain": null } ], "geometryField": { "name": "GIS.CartSmart.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R2019958_SDE_ROWID_UK", "fields": "GIS.CartSmart.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2019958", "fields": "GIS.CartSmart.GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "A5950_IX1", "fields": "GIS.CartSmart.SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CartSmart_Visits", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": 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 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "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 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "CARTSMART_VISITS_V", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "GUID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GUID", "type": "esriFieldTypeString", "alias": "GUID", "length": 38, "domain": null }, { "name": "ADDRESS_VISITED", "type": "esriFieldTypeInteger", "alias": "ADDRESS_VISITED", "domain": null }, { "name": "DATE_VISITED", "type": "esriFieldTypeDate", "alias": "DATE_VISITED", "length": 8, "domain": null }, { "name": "STICKER", "type": "esriFieldTypeInteger", "alias": "STICKER", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "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 } } ] }