{ "tables": [], "layers": [ { "extent": { "ymin": -12000000, "xmin": -18000000, "ymax": 16000000, "xmax": 18000000, "spatialReference": {"wkid": 102100} }, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "type": "Feature Layer", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": null, "supportsAttachmentsResizing": true, "id": 0, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "maxFieldNameLength": 128, "isDataVersioned": false, "templates": [ { "name": "Event Staffing", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "staffstatus": null, "eventid": null, "staffemail": null, "unittype": null, "staffagency": null, "unitsquad": null, "apparatus": null, "staffpay": null, "level_id": null, "unitduties": null, "staffname": null, "unitradio": null, "staffduty": null, "staffrank": null, "unitloc": null, "unitshift": null, "staffskills": null, "unitid": null, "staffphone": null, "uniqueid": null } } } ], "supportsAdvancedQueries": true, "supportsTilesAndBasicQueriesMode": true, "currentVersion": 11.4, "hasZ": true, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "viewSourceHasAttachments": false, "name": "Event Staffing", "displayField": "unitid", "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": "eventid", "length": 255, "alias": "Event ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitid", "length": 255, "alias": "Unit ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitshift", "length": 255, "alias": "Unit shift", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitloc", "length": 255, "alias": "Unit location", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "isViewOverride": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Post Type", "type": "codedValue", "codedValues": [ { "code": "Ambulance", "name": "Ambulance" }, { "code": "Apparatus", "name": "Apparatus" }, { "code": "ATV", "name": "ATV" }, { "code": "Bicycle Unit", "name": "Bicycle Unit" }, { "code": "Boat", "name": "Boat" }, { "code": "Command Post", "name": "Command Post" }, { "code": "Drone Operator", "name": "Drone Operator" }, { "code": "Firefighter", "name": "Firefighter" }, { "code": "Foot Patrol", "name": "Foot Patrol" }, { "code": "HazMat Truck ", "name": "HazMat Truck" }, { "code": "Helicopter", "name": "Helicopter" }, { "code": "K9", "name": "K9" }, { "code": "Medical Bicycle Unit", "name": "Medical Bicycle Unit" }, { "code": "Medical Cart", "name": "Medical Cart" }, { "code": "Medical Tent", "name": "Medical Tent" }, { "code": "Mobile Surveillance Tower", "name": "Mobile Surveillance Tower" }, { "code": "Motorcycle", "name": "Motorcycle" }, { "code": "Mounted Unit", "name": "Mounted Unit" }, { "code": "Negotiator", "name": "Negotiator" }, { "code": "Paramedic", "name": "Paramedic" }, { "code": "Prisoner Transport", "name": "Prisoner Transport" }, { "code": "Segway", "name": "Segway" }, { "code": "Sniper", "name": "Sniper" }, { "code": "SUV", "name": "SUV" }, { "code": "SWAT Team", "name": "SWAT Team" }, { "code": "Traffic Control", "name": "Traffic Control" }, { "code": "UTV", "name": "UTV" }, { "code": "Vehicle", "name": "Vehicle" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "unittype", "alias": "Unit type" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitsquad", "length": 255, "alias": "Unit squad", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitradio", "length": 255, "alias": "Unit radio channel", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitduties", "length": 1000, "alias": "Unit duties", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "isViewOverride": true, "domain": { "name": "Event Staffing_staffrank_3066e53a-c24c-445d-89bf-6b37c1ff72d4", "type": "codedValue", "codedValues": [ { "code": "Off.", "name": "Off." }, { "code": "Dep.", "name": "Dep." }, { "code": "Sgt.", "name": "Sgt." }, { "code": "Lt.", "name": "Lt." }, { "code": "Cpl.", "name": "Cpl." }, { "code": "Cpt.", "name": "Cpt." }, { "code": "Maj.", "name": "Maj." } ] }, "name": "staffrank", "alias": "Rank" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staffname", "length": 255, "alias": "Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staffphone", "length": 255, "alias": "Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staffemail", "length": 255, "alias": "Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staffskills", "length": 1000, "alias": "Skills", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staffpay", "length": 255, "alias": "Pay rate", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "isViewOverride": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Duty Status", "type": "codedValue", "codedValues": [ { "code": "On Duty", "name": "On Duty" }, { "code": "Overtime", "name": "Overtime" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "staffstatus", "alias": "Duty status" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "staffduty", "length": 255, "alias": "Regular duty assignment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "isViewOverride": true, "domain": { "name": "Agency Type", "type": "codedValue", "codedValues": [ { "code": "Fire/EMS", "name": "Fire/EMS" }, { "code": "Police", "name": "Police" } ] }, "name": "staffagency", "alias": "Agency" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "isViewOverride": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Fire Apparatus Type", "type": "codedValue", "codedValues": [ { "code": "Engine", "name": "Engine" }, { "code": "Heavy Rescue", "name": "Heavy Rescue" }, { "code": "Medium Rescue", "name": "Medium Rescue" }, { "code": "Aerial Ladder", "name": "Aerial Ladder" }, { "code": "Aerial Tower", "name": "Aerial Tower" }, { "code": "Tanker/Tender", "name": "Tanker/Tender" }, { "code": "Quint", "name": "Quint" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "apparatus", "alias": "Apparatus type" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "level_id", "length": 255, "alias": "Floor level", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniqueid", "length": 1000, "alias": "Unique ID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 256, "type": "esriFieldTypeString", "isViewOverride": true, "domain": { "name": "Event Staffing_poststatus_87623a2e-f1a9-4d97-8555-1a8759d8773a", "type": "codedValue", "codedValues": [ { "code": "On post", "name": "On post" }, { "code": "Off post", "name": "Off post" } ] }, "name": "poststatus", "alias": "Location status" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "enableUseOfScaleOutReplicasWhenEditable": true, "useStandardizedQueries": true, "supportedFieldTypes": [ "esriFieldTypeSmallInteger", "esriFieldTypeInteger", "esriFieldTypeSingle", "esriFieldTypeDouble", "esriFieldTypeString", "esriFieldTypeDate", "esriFieldTypeOID", "esriFieldTypeGeometry", "esriFieldTypeBlob", "esriFieldTypeRaster", "esriFieldTypeGUID", "esriFieldTypeGlobalID", "esriFieldTypeXML", "esriFieldTypeBigInteger", "esriFieldTypeDateOnly", "esriFieldTypeTimeOnly", "esriFieldTypeTimestampOffset" ], "globalIdField": "globalid", "supportedConvertContentFormats": "LayerEditCollection,FeatureCollection", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "a43_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "r167_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_167", "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": "esriServerHTMLPopupTypeAsHTMLText", "exceedsLimitFactor": 1, "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 }, "supportedConvertFileFormats": "JSON,PBF", "layerAdminOperationsOptions": { "deleteFromDefinition": [ "xssTrustedFields", "fields", "indexes", "relationships" ], "addToDefiniton": [ "fields", "indexes" ], "updateDefinition": [ "name", "xssTrustedFields", "displayField", "description", "copyrightText", "editFieldsInfo", "minScale", "maxScale", "fields", "maxRecordCount", "drawingInfo", "types", "templates", "indexes", "defaultVisibility", "hasAttachments", "propagateVisibleFields", "hasGeometryProperties", "attachmentProperties", "lodInfos", "typeIdField", "timeInfo", "allowUpdateWithoutMValues", "maxRecordCountFactor", "allowGeometryUpdates", "capabilities", "ownershipBasedAccessControlForFeatures", "onlyAllowTrueCurveUpdatesByTrueCurveClients", "allowTrueCurvesUpdates" ] }, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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 }, "supportsValidateSql": true, "enableZDefaults": true, "serviceItemId": "8a3a1f8591c34bd5ba0a271acbdec108", "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportedSyncDataOptions": 260, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "uniqueIdField": { "isSystemMaintained": true, "name": "objectid" }, "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": null, "color": [ 0, 121, 194, 255 ], "size": 40, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSSquare", "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, "supportsLayerOverrides": true, "geometryType": "esriGeometryPoint" } ] }