{ "tables": [ { "extent": { "ymin": 3929596.772782205, "xmin": -9389698.197514107, "ymax": 3981631.7189153736, "xmax": -9346283.596104734, "spatialReference": {"wkid": 102100} }, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": null, "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Collections", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "facilityid": null, "dropboxclosed": null, "notes": null, "ballotcount2team": null, "locationconditiondetails": null, "dropboxlocknew": null, "dropboxconditiondetails": null, "votinglocationglobalid": null, "fulladdr": null, "ballotcount2": null, "collectionofficer2": null, "ballotcount1": null, "collectionofficer1": null, "votinglocationcondition": null, "finalcollection": null, "hqreturntime": null, "electioneeringdetails": null, "dropboxseal": null, "departuretime": null, "dropboxcondition": null, "dropboxsealnew": null, "dropboxlock": null, "driver": null, "name": null, "arrivaltime": null, "containers": null, "electioneering": null, "electionofficial": null, "ballotcount1team": null, "containerssubmitted": null } } } ], "supportsAdvancedQueries": true, "supportsTilesAndBasicQueriesMode": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": true, "name": "Collections", "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "length": 4, "type": "esriFieldTypeOID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facilityid", "length": 40, "alias": "Voting Location ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 255, "alias": "Voting Location Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fulladdr", "length": 255, "alias": "Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "collectionofficer1", "length": 255, "alias": "Collection Team Captain", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "collectionofficer2", "length": 255, "alias": "Collection Team Assistant", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "driver", "length": 255, "alias": "Driver", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "arrivaltime", "length": 29, "alias": "Time arriving at drop box", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "isViewOverride": true, "domain": { "name": "Collections_electioneering_bff3cd51-1170-4d9c-8104-d6bfb12aa4a2", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "electioneering", "alias": "Electioneering compliance" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electioneeringdetails", "length": 2000, "alias": "electioneeringdetails", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "isViewOverride": true, "domain": { "name": "Collections_votinglocationcondition_671254a9-9aa9-47b7-8c72-3de33cd0d354", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Poor" }, { "code": 1, "name": "Fair" }, { "code": 2, "name": "Good" }, { "code": 3, "name": "Excellent" } ] }, "name": "votinglocationcondition", "alias": "Voting location condition" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationconditiondetails", "length": 2000, "alias": "locationconditiondetails", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "isViewOverride": true, "domain": { "name": "Collections_dropboxcondition_6bcc1ed4-7039-47d6-8072-a6170a244cd4", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Poor" }, { "code": 2, "name": "Good" }, { "code": 1, "name": "Fair" }, { "code": 3, "name": "Excellent" } ] }, "name": "dropboxcondition", "alias": "Ballot drop box condition" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dropboxconditiondetails", "length": 2000, "alias": "dropboxconditiondetails", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "containers", "alias": "Number of containers collected", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dropboxseal", "length": 255, "alias": "Drop box seal serial number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dropboxsealnew", "length": 255, "alias": "New drop box seal serial number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dropboxlock", "length": 255, "alias": "Drop box lock serial number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dropboxlocknew", "length": 255, "alias": "New drop box lock serial number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "departuretime", "length": 29, "alias": "Time departing from drop box", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "isViewOverride": true, "domain": null, "name": "finalcollection", "alias": "Final ballot drop collection" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dropboxclosed", "length": 29, "alias": "Time drop box is closed for the current election", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 2000, "alias": "Notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "hqreturntime", "length": 29, "alias": "Time returning to headquarters", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "containerssubmitted", "alias": "Number of containers submitted to election offical", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "electionofficial", "length": 255, "alias": "Election official receiving containers", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ballotcount1", "alias": "First number of ballots received count", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ballotcount2", "alias": "Second number of ballots received count", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "votinglocationglobalid", "length": 38, "alias": "Voting location Global ID", "type": "esriFieldTypeGUID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "Created By", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "Created On", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "Last Edited By", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "Last Edited On", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ballotcount1team", "length": 255, "alias": "First ballot count team", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ballotcount2team", "length": 255, "alias": "Second ballot count team", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "enableUseOfScaleOutReplicasWhenEditable": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "r142_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_142", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "exceedsLimitFactor": 1, "GUIDFormat": "O", "hasAttachments": true, "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": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSql": true, "serviceItemId": "e87bb6e4b0b04cfaae949384cb41b18d", "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Uploads", "supportsAppend": true, "supportedSyncDataOptions": 4, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "uniqueIdField": { "isSystemMaintained": true, "name": "objectid" }, "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true } ], "layers": [] }