{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "UASFlightLocations", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "epgdb.POLICE.UAS_PreFlight", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{1A6BAB30-6C08-4109-BB9A-703CDDF82A56}" }, { "id": 1, "name": "epgdb.POLICE.UAS_RiskAssessment", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{035E855A-636F-4492-9385-BDBC0DE9C5CD}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1719849972000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 471209.8976226449, "ymin": 123528.18333613873, "xmax": 485248.49913854897, "ymax": 123587.09857264161, "spatialReference": { "wkid": 103734, "latestWkid": 103734, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119096800, "falseY": -98462100, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 103734, "latestWkid": 103734, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119096800, "falseY": -98462100, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 170, 0, 191 ], "size": 8, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 255, 170, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "OBJECTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "EPPDCaseNum", "type": "esriFieldTypeString", "alias": "EPPD Case Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "EPPDCaseNum" }, { "name": "UASCaseNum", "type": "esriFieldTypeString", "alias": "UAS Case Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "UASCaseNum" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Mission", "type": "esriFieldTypeString", "alias": "Mission", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "Mission" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Location" }, { "name": "closest_city", "type": "esriFieldTypeString", "alias": "Closest City", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "closest_city" }, { "name": "tempF_01", "type": "esriFieldTypeDouble", "alias": "Temp (Next Hour)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tempF_01" }, { "name": "wind_speed_01", "type": "esriFieldTypeString", "alias": "Wind Speed (Next Hour)", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "wind_speed_01" }, { "name": "wind_dir_01", "type": "esriFieldTypeString", "alias": "Wind Direction (Next Hour)", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "wind_dir_01" }, { "name": "observed_precip", "type": "esriFieldTypeDouble", "alias": "Obersved Precip. 48 hrs", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "observed_precip" }, { "name": "probability_precip_01", "type": "esriFieldTypeSmallInteger", "alias": "Probability of Precipitation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "probability_precip_01" }, { "name": "probability_precip_time", "type": "esriFieldTypeString", "alias": "Precipitation Probability Valid Time", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "probability_precip_time" }, { "name": "cloud_alt_01", "type": "esriFieldTypeString", "alias": "Cloud Altitude", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "cloud_alt_01" }, { "name": "ceiling_height_01", "type": "esriFieldTypeDouble", "alias": "Ceiling Height (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ceiling_height_01" }, { "name": "ceiling_height_time", "type": "esriFieldTypeString", "alias": "Ceiling Height Valid Time", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ceiling_height_time" }, { "name": "visibility_dist_01", "type": "esriFieldTypeDouble", "alias": "Visibility Distance (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "visibility_dist_01" }, { "name": "forecast_01", "type": "esriFieldTypeString", "alias": "Forecast (Next Hour)", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "forecast_01" }, { "name": "Warrant", "type": "esriFieldTypeString", "alias": "Warrant", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Warrant" }, { "name": "WarrantAgency", "type": "esriFieldTypeString", "alias": "Warrant Agency", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "WarrantAgency" }, { "name": "WarrantEx1", "type": "esriFieldTypeString", "alias": "Warrant Exception 1", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "WarrantEx1" }, { "name": "WarrantEx2", "type": "esriFieldTypeString", "alias": "Warrant Exception 2", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "WarrantEx2" }, { "name": "WarrantEx3", "type": "esriFieldTypeString", "alias": "Warrant Exception 3", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "WarrantEx3" }, { "name": "Auth", "type": "esriFieldTypeString", "alias": "Authization", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Auth" }, { "name": "LAANC_Num", "type": "esriFieldTypeString", "alias": "LAANC Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LAANC_Num" }, { "name": "LAANC_Start", "type": "esriFieldTypeDate", "alias": "LAANC Start", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAANC_Start" }, { "name": "LAANC_End", "type": "esriFieldTypeDate", "alias": "LAANC End", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAANC_End" }, { "name": "NOTAM", "type": "esriFieldTypeString", "alias": "NOTAM", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "NOTAM" }, { "name": "NOTAM_Desc", "type": "esriFieldTypeString", "alias": "NOTAM Description", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "NOTAM_Desc" }, { "name": "Airclass", "type": "esriFieldTypeString", "alias": "Airclass", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Airclass" }, { "name": "Airport", "type": "esriFieldTypeString", "alias": "Airport", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Airport" }, { "name": "AltLanding", "type": "esriFieldTypeString", "alias": "Alt Landing", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "AltLanding" }, { "name": "AltLanding_Desc", "type": "esriFieldTypeString", "alias": "Alt Landing Desc", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "AltLanding_Desc" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "Notes" }, { "name": "FORECAST_JSON", "type": "esriFieldTypeString", "alias": "Forecast JSON", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "FORECAST_JSON" }, { "name": "NOAA_JSON", "type": "esriFieldTypeString", "alias": "NOAA JSON", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "NOAA_JSON" }, { "name": "FORECAST_URL", "type": "esriFieldTypeString", "alias": "NOAA Forecast URL", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "FORECAST_URL" }, { "name": "FORECASTHOURLY_URL", "type": "esriFieldTypeString", "alias": "ForecastHourlyURL", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "FORECASTHOURLY_URL" }, { "name": "FORECASTHOURLY_JSON", "type": "esriFieldTypeString", "alias": "ForecastHourly_Json", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "FORECASTHOURLY_JSON" }, { "name": "FORECASTGRID_URL", "type": "esriFieldTypeString", "alias": "NOAA Forecast Grid URL", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "FORECASTGRID_URL" }, { "name": "FORECASTGRID_JSON", "type": "esriFieldTypeString", "alias": "NOAA Forecast Grid JSON", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "FORECASTGRID_JSON" }, { "name": "openweather_api_key", "type": "esriFieldTypeString", "alias": "Open Weather API Key", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "openweather_api_key" }, { "name": "openweather_json", "type": "esriFieldTypeString", "alias": "Open Weather JSON", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "openweather_json" }, { "name": "open_meteo_URL", "type": "esriFieldTypeString", "alias": "OpenMeteoURL", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "open_meteo_URL" }, { "name": "open_meteo_json", "type": "esriFieldTypeString", "alias": "OpenMeteo JSON", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "open_meteo_json" }, { "name": "lon", "type": "esriFieldTypeDouble", "alias": "lon", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "lon" }, { "name": "lat", "type": "esriFieldTypeDouble", "alias": "lat", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "lat" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "weathertime", "type": "esriFieldTypeString", "alias": "Weather - Time", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "weathertime" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "UUID_5819", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_5819", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S3540_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "epgdb.POLICE.UAS_Flights", "description": "", "prototype": { "attributes": { "lat": null, "weathertime": null, "EPPDCaseNum": null, "UASCaseNum": null, "Date": null, "Mission": null, "Location": null, "closest_city": null, "tempF_01": null, "wind_speed_01": null, "wind_dir_01": null, "observed_precip": null, "probability_precip_01": null, "probability_precip_time": null, "cloud_alt_01": null, "ceiling_height_01": null, "ceiling_height_time": null, "visibility_dist_01": null, "forecast_01": null, "Warrant": null, "WarrantAgency": null, "WarrantEx1": null, "WarrantEx2": null, "WarrantEx3": null, "Auth": null, "LAANC_Num": null, "LAANC_Start": null, "LAANC_End": null, "NOTAM": null, "NOTAM_Desc": null, "Airclass": null, "Airport": null, "AltLanding": null, "AltLanding_Desc": null, "Notes": null, "FORECAST_JSON": null, "NOAA_JSON": null, "FORECAST_URL": null, "FORECASTHOURLY_URL": null, "FORECASTHOURLY_JSON": null, "FORECASTGRID_URL": null, "FORECASTGRID_JSON": null, "openweather_api_key": null, "openweather_json": null, "open_meteo_URL": null, "open_meteo_json": null, "lon": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "UASPreFlightChecklist", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "epgdb.POLICE.UAS_Flights", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{1A6BAB30-6C08-4109-BB9A-703CDDF82A56}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1719849974000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "OBJECTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "EPPDCaseNum_PF", "type": "esriFieldTypeString", "alias": "EPPD Case Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "EPPDCaseNum_PF" }, { "name": "UASCaseNum_PF", "type": "esriFieldTypeString", "alias": "UAS Activation Case Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "UASCaseNum_PF" }, { "name": "Date_PF", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_PF" }, { "name": "Location_PF", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 2080, "defaultValue": null, "modelName": "Location_PF" }, { "name": "Mission_PF", "type": "esriFieldTypeString", "alias": "Mission Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Mission_PF" }, { "name": "Airframe", "type": "esriFieldTypeString", "alias": "Airframe", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Airframe" }, { "name": "Video", "type": "esriFieldTypeString", "alias": "Video Available?", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Video" }, { "name": "ChkSD", "type": "esriFieldTypeString", "alias": "SD Card", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkSD" }, { "name": "ChkBatteryRem", "type": "esriFieldTypeString", "alias": "Remote Battery", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkBatteryRem" }, { "name": "ChkBatteryAC", "type": "esriFieldTypeString", "alias": "Aircraft Battery", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkBatteryAC" }, { "name": "ChkPropArm", "type": "esriFieldTypeString", "alias": "Secure Props/Extend Arms", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkPropArm" }, { "name": "ChkAF", "type": "esriFieldTypeString", "alias": "Airframe Inspected for Damage", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkAF" }, { "name": "ChkFirmware", "type": "esriFieldTypeString", "alias": "Firmware Update", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkFirmware" }, { "name": "ChkConn", "type": "esriFieldTypeString", "alias": "Airfract-Remote Connectivity", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkConn" }, { "name": "ChkLight", "type": "esriFieldTypeString", "alias": "Aircraft Lighting", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkLight" }, { "name": "ChkCompass", "type": "esriFieldTypeString", "alias": "Compass Calibrated", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkCompass" }, { "name": "ChkLimit", "type": "esriFieldTypeString", "alias": "Flight Limits Set", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkLimit" }, { "name": "ChkReturn", "type": "esriFieldTypeString", "alias": "Return Home Setting", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkReturn" }, { "name": "ChkTOLoc", "type": "esriFieldTypeString", "alias": "Takeoff Location Free of Obstancles", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkTOLoc" }, { "name": "ChkMotor", "type": "esriFieldTypeString", "alias": "Motor Start", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkMotor" }, { "name": "ChkHome", "type": "esriFieldTypeString", "alias": "Home Point Set", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ChkHome" }, { "name": "Chk5ftAlt", "type": "esriFieldTypeString", "alias": "5ft Altitude Test", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Chk5ftAlt" }, { "name": "Chk30ftAlt", "type": "esriFieldTypeString", "alias": "30ft Altitude Test", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Chk30ftAlt" }, { "name": "Notes_PF", "type": "esriFieldTypeString", "alias": "Pre-Flight Notes", "domain": null, "editable": true, "nullable": true, "length": 2048, "defaultValue": null, "modelName": "Notes_PF" }, { "name": "CompletedBy", "type": "esriFieldTypeString", "alias": "Completed By", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "CompletedBy" }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_5741", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_49452_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_5741", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "UASPreFlightChecklist", "description": "", "prototype": { "attributes": { "GUID": null, "EPPDCaseNum_PF": null, "UASCaseNum_PF": null, "Date_PF": null, "Location_PF": null, "Mission_PF": null, "Airframe": null, "Video": null, "ChkSD": null, "ChkBatteryRem": null, "ChkBatteryAC": null, "ChkPropArm": null, "ChkAF": null, "ChkFirmware": null, "ChkConn": null, "ChkLight": null, "ChkCompass": null, "ChkLimit": null, "ChkReturn": null, "ChkTOLoc": null, "ChkMotor": null, "ChkHome": null, "Chk5ftAlt": null, "Chk30ftAlt": null, "Notes_PF": null, "CompletedBy": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "f5825272e895412cb5306976e3a6cb40" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "UASRiskAssessment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "epgdb.POLICE.UAS_Flights", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{035E855A-636F-4492-9385-BDBC0DE9C5CD}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1719849974000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "OBJECTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "EPPDCaseNum_RA", "type": "esriFieldTypeString", "alias": "EPPD Case Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "EPPDCaseNum_RA" }, { "name": "UASCaseNum_RA", "type": "esriFieldTypeString", "alias": "UAS Activation Case Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "UASCaseNum_RA" }, { "name": "Date_RA", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_RA" }, { "name": "Pilot", "type": "esriFieldTypeString", "alias": "Pilot", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Pilot" }, { "name": "Mission_RA", "type": "esriFieldTypeString", "alias": "Mission", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Mission_RA" }, { "name": "Daytime", "type": "esriFieldTypeSmallInteger", "alias": "Daytime", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Daytime" }, { "name": "TrainingHours", "type": "esriFieldTypeSmallInteger", "alias": "TrainingHours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TrainingHours" }, { "name": "VisualObserver", "type": "esriFieldTypeSmallInteger", "alias": "VisualObserver", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VisualObserver" }, { "name": "EnvLocation", "type": "esriFieldTypeSmallInteger", "alias": "EnvLocation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EnvLocation" }, { "name": "WithinLast30", "type": "esriFieldTypeSmallInteger", "alias": "WithinLast30", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WithinLast30" }, { "name": "Rested", "type": "esriFieldTypeSmallInteger", "alias": "Rested", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Rested" }, { "name": "SimilarMission", "type": "esriFieldTypeSmallInteger", "alias": "SimilarMission", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SimilarMission" }, { "name": "Winds", "type": "esriFieldTypeSmallInteger", "alias": "Winds", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Winds" }, { "name": "Total", "type": "esriFieldTypeSmallInteger", "alias": "Total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total" }, { "name": "Risk", "type": "esriFieldTypeString", "alias": "Risk Assessment Score", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Risk" }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_5742", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_49453_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_5742", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "UASRiskAssessment", "description": "", "prototype": { "attributes": { "GUID": null, "EPPDCaseNum_RA": null, "UASCaseNum_RA": null, "Date_RA": null, "Pilot": null, "Mission_RA": null, "Daytime": null, "TrainingHours": null, "VisualObserver": null, "EnvLocation": null, "WithinLast30": null, "Rested": null, "SimilarMission": null, "Winds": null, "Total": null, "Risk": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "f5825272e895412cb5306976e3a6cb40" } ] }