{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 6991564.417136475, "xmin": 2486116.018950969, "ymax": 7001980.451422483, "xmax": 2499393.262081474, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2276, "zTolerance": 0.001, "wkid": 102738, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "locationaccountnumber", "role": "esriRelRoleOrigin", "composite": false, "name": "ServiceLayer", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Customers", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "zip": null, "country": "USA", "customeraccountstatus": "Active", "streetname": null, "city": "University Park", "latitude": null, "streetnumber": null, "locationphone": null, "locationaccountnumber": null, "locationname": null, "customerphone": null, "lastupdateddate": null, "customeraccountnumber": null, "locationnotes": null, "state": "Texas", "customername": null, "locationemail": null, "longitude": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Customers", "allowTrueCurvesUpdates": false, "displayField": "customername", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 512, "type": "esriFieldTypeString", "modelName": "customername", "domain": null, "name": "customername", "alias": "CustomerName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "customeraccountnumber", "domain": null, "name": "customeraccountnumber", "alias": "CustomerAccountNumber" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "customerphone", "domain": null, "name": "customerphone", "alias": "CustomerPhone" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "locationname", "domain": null, "name": "locationname", "alias": "LocationName" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "locationaccountnumber", "domain": null, "name": "locationaccountnumber", "alias": "LocationAccountNumber" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "locationemail", "domain": null, "name": "locationemail", "alias": "LocationEmail" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "locationphone", "domain": null, "name": "locationphone", "alias": "LocationPhone" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 70, "type": "esriFieldTypeString", "modelName": "streetnumber", "domain": null, "name": "streetnumber", "alias": "StreetNumber" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "streetname", "domain": null, "name": "streetname", "alias": "StreetName" }, { "nullable": true, "editable": true, "defaultValue": "University Park", "length": 100, "type": "esriFieldTypeString", "modelName": "city", "domain": null, "name": "city", "alias": "City" }, { "nullable": true, "editable": true, "defaultValue": "Texas", "length": 50, "type": "esriFieldTypeString", "modelName": "state", "domain": null, "name": "state", "alias": "State" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "zip", "domain": null, "name": "zip", "alias": "Zip" }, { "nullable": true, "editable": true, "defaultValue": "USA", "length": 50, "type": "esriFieldTypeString", "modelName": "country", "domain": null, "name": "country", "alias": "Country" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "latitude", "domain": null, "name": "latitude", "alias": "Latitude" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "longitude", "domain": null, "name": "longitude", "alias": "Longitude" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "locationnotes", "domain": null, "name": "locationnotes", "alias": "LocationNotes" }, { "nullable": true, "editable": true, "defaultValue": "Active", "length": 255, "type": "esriFieldTypeString", "modelName": "customeraccountstatus", "domain": { "name": "CustomerAccountStatus_1", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "New", "name": "New" }, { "code": "Suspended", "name": "Suspended" }, { "code": "OnHold", "name": "OnHold" }, { "code": "Closed", "name": "Closed" } ] }, "name": "customeraccountstatus", "alias": "CustomerAccountStatus" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "lastupdateddate", "domain": null, "name": "lastupdateddate", "alias": "LastUpdatedDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g161locationacco", "isUnique": false, "description": "", "fields": "locationaccountnumber", "isAscending": true }, { "name": "r108_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a72_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "zip_index", "isUnique": false, "description": "zip_Index", "fields": "zip", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "436de80e746c466c87305743678e0f18", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 90, 54, 147, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 6991564.417136475, "xmin": 2486116.018950969, "ymax": 7001980.451422483, "xmax": 2499393.262081474, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2276, "zTolerance": 0.001, "wkid": 102738, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "serviceaccountnumber", "role": "esriRelRoleOrigin", "composite": false, "name": "RouteLayer", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "locationaccountnumber", "role": "esriRelRoleDestination", "composite": false, "name": "CustomerLayer", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Services", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "numberofcontainers": null, "containerlongitude": null, "wastematerialtype": null, "servicenotes": null, "effectivedate": null, "serviceaccountstatus": null, "locationaccountnumber": null, "containerlatitude": null, "servicetype": null, "pickupfrequencytype": null, "serviceaccountnumber": null, "lastupdateddate": null, "serviceday": null, "equipmentsize": null, "equipmenttype": null, "containernumber": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Services", "allowTrueCurvesUpdates": false, "displayField": "serviceaccountnumber", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 250, "type": "esriFieldTypeString", "modelName": "serviceaccountnumber", "domain": null, "name": "serviceaccountnumber", "alias": "ServiceAccountNumber" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "servicetype", "domain": { "name": "ServiceType", "type": "codedValue", "codedValues": [ { "code": "FrontLoad", "name": "Front Load" }, { "code": "RollOff", "name": "Roll Off" }, { "code": "Bulk", "name": "Bulk" }, { "code": "Toter", "name": "Toter" }, { "code": "Residential", "name": "Residential" }, { "code": "PortableToilet", "name": "PortableToilet" }, { "code": "WasteAudit", "name": "WasteAudit" } ] }, "name": "servicetype", "alias": "ServiceType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "containernumber", "domain": null, "name": "containernumber", "alias": "ContainerNumber" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "containerlatitude", "domain": null, "name": "containerlatitude", "alias": "ContainerLatitude" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "containerlongitude", "domain": null, "name": "containerlongitude", "alias": "ContainerLongitude" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "equipmenttype", "domain": { "name": "EquipmentType", "type": "codedValue", "codedValues": [ { "code": "Bags", "name": "Bags" }, { "code": "BulkItem", "name": "Bulk Item" }, { "code": "FrontLoad", "name": "Front Load" }, { "code": "HoldingTank", "name": "HoldingTank" }, { "code": "None", "name": "None" }, { "code": "OpenTop", "name": "Open Top" }, { "code": "PortableRestroomTrailer", "name": "Portable Restroom Trailer" }, { "code": "PortableSink", "name": "PortableSink" }, { "code": "PortableToilet", "name": "Portable Toiler" }, { "code": "PublicContainer", "name": "Public Container" }, { "code": "RearLoad", "name": "Rear Load" }, { "code": "ReceiverBox", "name": "Receiver Box" }, { "code": "Recycler", "name": "Recycler" }, { "code": "SelfContCompactor", "name": "SelfContCompactor" }, { "code": "StationaryCompactor", "name": "Stationary Compactor" }, { "code": "Toter", "name": "Toter" }, { "code": "VerticalCompactor", "name": "Vertical Compactor" }, { "code": "WaterTote", "name": "Water Tote" } ] }, "name": "equipmenttype", "alias": "EquipmentType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "equipmentsize", "domain": { "name": "EquipmentSize", "type": "codedValue", "codedValues": [ { "code": "0.50YardContainer", "name": "0.50YardContainer" }, { "code": "0.75YardContainer", "name": "0.75YardContainer" }, { "code": "01BagContainer", "name": "01BagContainer" }, { "code": "01YardContainer", "name": "01YardContainer" }, { "code": "02YardContainer", "name": "02YardContainer" }, { "code": "03YardContainer", "name": "03YardContainer" }, { "code": "04GallonToter", "name": "04GallonToter" }, { "code": "04YardContainer", "name": "04YardContainer" }, { "code": "05YardContainer", "name": "05YardContainer" }, { "code": "06YardContainer", "name": "06YardContainer" }, { "code": "07YardContainer", "name": "07YardContainer" }, { "code": "08YardContainer", "name": "08YardContainer" }, { "code": "09YardContainer", "name": "09YardContainer" }, { "code": "1.5YardContainer", "name": "1.5YardContainer" }, { "code": "10YardContainer", "name": "10YardContainer" }, { "code": "1100LiterContainer", "name": "1100LiterContainer" }, { "code": "120LiterContainer", "name": "120LiterContainer" }, { "code": "12YardContainer", "name": "12YardContainer" }, { "code": "14YardContainer", "name": "14YardContainer" }, { "code": "15YardContainer", "name": "15YardContainer" }, { "code": "16YardContainer", "name": "16YardContainer" }, { "code": "18YardContainer", "name": "18YardContainer" }, { "code": "2.5YardContainer", "name": "2.5YardContainer" }, { "code": "20GallonToter", "name": "20GallonToter" }, { "code": "20YardContainer", "name": "20YardContainer" }, { "code": "21GallonToter", "name": "21GallonToter" }, { "code": "22YardContainer", "name": "22YardContainer" }, { "code": "240LiterContainer", "name": "240LiterContainer" }, { "code": "24YardContainer", "name": "24YardContainer" }, { "code": "25YardContainer", "name": "25YardContainer" }, { "code": "26YardContainer", "name": "26YardContainer" }, { "code": "3.5YardContainer", "name": "3.5YardContainer" }, { "code": "300GallonToter", "name": "300GallonToter" }, { "code": "30GallonContainer", "name": "30GallonContainer" }, { "code": "30GallonToter", "name": "30GallonToter" }, { "code": "30YardContainer", "name": "30YardContainer" }, { "code": "32GallonContainer", "name": "32GallonContainer" }, { "code": "32GallonToter", "name": "32GallonToter" }, { "code": "32YardContainer", "name": "32YardContainer" }, { "code": "34YardContainer", "name": "34YardContainer" }, { "code": "35GallonContainer", "name": "35GallonContainer" }, { "code": "35GallonToter", "name": "35GallonToter" }, { "code": "35YardContainer", "name": "35YardContainer" }, { "code": "39YardContainer", "name": "39YardContainer" }, { "code": "40GallonContainer", "name": "40GallonContainer" }, { "code": "40YardContainer", "name": "40YardContainer" }, { "code": "42YardContainer", "name": "42YardContainer" }, { "code": "43YardContainer", "name": "43YardContainer" }, { "code": "440GallonToter", "name": "440GallonToter" }, { "code": "45GallonContainer", "name": "45GallonContainer" }, { "code": "45YardContainer", "name": "45YardContainer" }, { "code": "48GallonContainer", "name": "48GallonContainer" }, { "code": "48GallonToter", "name": "48GallonToter" }, { "code": "50YardContainer", "name": "50YardContainer" }, { "code": "55GallonContainer", "name": "55GallonContainer" }, { "code": "55GallonToter", "name": "55GallonToter" }, { "code": "60GallonContainer", "name": "60GallonContainer" }, { "code": "60GallonToter", "name": "60GallonToter" }, { "code": "64GallonContainer", "name": "64GallonContainer" }, { "code": "64GallonToter", "name": "64GallonToter" }, { "code": "65GallonToter", "name": "65GallonToter" }, { "code": "660LiterContainer", "name": "660LiterContainer" }, { "code": "68GallonToter", "name": "68GallonToter" }, { "code": "76GallonToter", "name": "76GallonToter" }, { "code": "78GallonToter", "name": "78GallonToter" }, { "code": "80GallonToter", "name": "80GallonToter" }, { "code": "90GallonContainer", "name": "90GallonContainer" }, { "code": "90GallonToter", "name": "90GallonToter" }, { "code": "92GallonToter", "name": "92GallonToter" }, { "code": "95GallonToter", "name": "95GallonToter" }, { "code": "96GallonContainer", "name": "96GallonContainer" }, { "code": "96GallonToter", "name": "96GallonToter" }, { "code": "BulkItem", "name": "BulkItem" }, { "code": "HoldingTankStandard", "name": "HoldingTankStandard" }, { "code": "PortableRestroomTrailer1Stall", "name": "PortableRestroomTrailer1Stall" }, { "code": "PortableRestroomTrailer2Stalls", "name": "PortableRestroomTrailer2Stalls" }, { "code": "PortableRestroomTrailer3Stalls", "name": "PortableRestroomTrailer3Stalls" }, { "code": "PortableRestroomTrailer4Stalls", "name": "PortableRestroomTrailer4Stalls" }, { "code": "PortableRestroomTrailer5Stalls", "name": "PortableRestroomTrailer5Stalls" }, { "code": "PortableRestroomTrailer6Stalls", "name": "PortableRestroomTrailer6Stalls" }, { "code": "PortableRestroomTrailer7Stalls", "name": "PortableRestroomTrailer7Stalls" }, { "code": "PortableRestroomTrailer8PlusStalls", "name": "PortableRestroomTrailer8PlusStalls" }, { "code": "PortableSinkDeluxe", "name": "PortableSinkDeluxe" }, { "code": "PortableSinkStandard", "name": "PortableSinkStandard" }, { "code": "PortableToiletDeluxe", "name": "PortableToiletDeluxe" }, { "code": "PortableToiletDeluxeWithSink", "name": "PortableToiletDeluxeWithSink" }, { "code": "PortableToiletHandicap", "name": "PortableToiletHandicap" }, { "code": "PortableToiletHandicapWithSink", "name": "PortableToiletHandicapWithSink" }, { "code": "PortableToiletStandard", "name": "PortableToiletStandard" }, { "code": "PortableToiletStandardWithSink", "name": "PortableToiletStandardWithSink" }, { "code": "WaterToteStandard", "name": "WaterToteStandard" } ] }, "name": "equipmentsize", "alias": "EquipmentSize" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "numberofcontainers", "domain": null, "name": "numberofcontainers", "alias": "NumberOfContainers" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "wastematerialtype", "domain": { "name": "WasteMaterialType", "type": "codedValue", "codedValues": [ { "code": "OCC", "name": "OCC" }, { "code": "TrashMSW", "name": "TrashMSW" }, { "code": "TrashCD", "name": "TrashCD" }, { "code": "SingleStreamRecycling", "name": "Single Stream Recycling" }, { "code": "Unknown", "name": "Unknown" }, { "code": "YardWaste", "name": "Yard Waste" }, { "code": "GL", "name": "GL" }, { "code": "Plastics", "name": "Plastics" }, { "code": "Metals", "name": "Metals" }, { "code": "Compost", "name": "Compost" }, { "code": "Concrete", "name": "Concrete" }, { "code": "Electronics", "name": "Electronics" }, { "code": "Shingles", "name": "Shingles" }, { "code": "Hazardous", "name": "Hazardous" }, { "code": "SpecialWaste", "name": "Special Waste" }, { "code": "WhiteGoods", "name": "White Goods" }, { "code": "Sludge", "name": "Sludge" }, { "code": "CleanFill", "name": "Clean Fill" }, { "code": "Other", "name": "Other" }, { "code": "FW", "name": "FW" }, { "code": "BioWaste", "name": "Bio Waste" }, { "code": "Tires", "name": "Tires" } ] }, "name": "wastematerialtype", "alias": "WasteMaterialType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "pickupfrequencytype", "domain": { "name": "FrequencyType", "type": "codedValue", "codedValues": [ { "code": "EveryWeek", "name": "Every Week" }, { "code": "EveryOtherWeek", "name": "Every Other Week" }, { "code": "Monthly", "name": "Monthly" }, { "code": "OnCall", "name": "On Call" }, { "code": "Xtimesperweek", "name": "X times per week" }, { "code": "EveryXDays", "name": "Every X Days" }, { "code": "EveryXWeeks", "name": "Every X Weeks" }, { "code": "MonthlyNonSchedule", "name": "Monthly Non Schedule" }, { "code": "Unknown", "name": "Unknown" } ] }, "name": "pickupfrequencytype", "alias": "PickupFrequencyType" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "effectivedate", "domain": null, "name": "effectivedate", "alias": "EffectiveDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "serviceday", "domain": { "name": "ServiceDay_1", "type": "codedValue", "codedValues": [ { "code": "Monday", "name": "Monday" }, { "code": "Tuesday", "name": "Tuesday" }, { "code": "Wednesday", "name": "Wednesday" }, { "code": "Thursday", "name": "Thursday" }, { "code": "Friday", "name": "Friday" }, { "code": "Saturday", "name": "Saturday" }, { "code": "Sunday", "name": "Sunday" } ] }, "name": "serviceday", "alias": "ServiceDay" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "servicenotes", "domain": null, "name": "servicenotes", "alias": "ServiceNotes" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "locationaccountnumber", "domain": null, "name": "locationaccountnumber", "alias": "LocationAccountNumber" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "serviceaccountstatus", "domain": { "name": "CustomerAccountStatus", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "New", "name": "New" }, { "code": "Suspended", "name": "Suspended" }, { "code": "OnHold", "name": "OnHold" }, { "code": "Closed", "name": "Closed" } ] }, "name": "serviceaccountstatus", "alias": "ServiceAccountStatus" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "lastupdateddate", "domain": null, "name": "lastupdateddate", "alias": "LastUpdatedDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g162locationacco", "isUnique": false, "description": "", "fields": "locationaccountnumber", "isAscending": true }, { "name": "g162serviceaccou", "isUnique": false, "description": "", "fields": "serviceaccountnumber", "isAscending": true }, { "name": "r109_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a73_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "436de80e746c466c87305743678e0f18", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 165, 54, 121, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 6991564.417136475, "xmin": 2486116.018950969, "ymax": 7001980.451422483, "xmax": 2499393.262081474, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2276, "zTolerance": 0.001, "wkid": 102738, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "serviceaccountnumber", "role": "esriRelRoleDestination", "composite": false, "name": "ServiceLayer", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Routes", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "vehicletype": null, "serviceremoved": null, "serviceaccountnumber": null, "route": null, "stop": null, "lastupdateddate": null, "serviceday": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Routes", "allowTrueCurvesUpdates": false, "displayField": "serviceaccountnumber", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "serviceaccountnumber", "domain": null, "name": "serviceaccountnumber", "alias": "ServiceAccountNumber" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "vehicletype", "domain": { "name": "VehicleType", "type": "codedValue", "codedValues": [ { "code": "FrontLoad", "name": "Front Load" }, { "code": "RollOff", "name": "Roll Off" }, { "code": "Toter", "name": "Toter" }, { "code": "Residential", "name": "Residential" }, { "code": "WasteAudit", "name": "WasteAudit" }, { "code": "Delivery", "name": "Delivery" } ] }, "name": "vehicletype", "alias": "VehicleType" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "route", "domain": null, "name": "route", "alias": "Route" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "serviceday", "domain": { "name": "ServiceDay", "type": "codedValue", "codedValues": [ { "code": "Monday", "name": "Monday" }, { "code": "Tuesday", "name": "Tuesday" }, { "code": "Wednesday", "name": "Wednesday" }, { "code": "Thursday", "name": "Thursday" }, { "code": "Friday", "name": "Friday" }, { "code": "Saturday", "name": "Saturday" }, { "code": "Sunday", "name": "Sunday" } ] }, "name": "serviceday", "alias": "ServiceDay" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "stop", "domain": null, "name": "stop", "alias": "Stop" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "lastupdateddate", "domain": null, "name": "lastupdateddate", "alias": "LastUpdatedDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "serviceremoved", "domain": null, "name": "serviceremoved", "alias": "ServiceRemoved" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g163serviceaccou", "isUnique": false, "description": "", "fields": "serviceaccountnumber", "isAscending": true }, { "name": "r110_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a74_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "vehicletype_index", "isUnique": false, "description": "vehicletype_Index", "fields": "vehicletype", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "436de80e746c466c87305743678e0f18", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 175, 80, 56, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }