{
"isCoGoEnabled": false,
"isDataBranchVersioned": false,
"supportsApplyEditsWithGlobalIds": true,
"maxRecordCount": 2000,
"infoInEstimates": [
"extent",
"count"
],
"datesInUnknownTimezone": false,
"type": "Table",
"supportsAttachmentsByUploadId": true,
"relationships": [],
"supportsAttachmentsResizing": true,
"cimVersion": "3.1.0",
"isDataArchived": true,
"id": 2,
"supportsStatistics": true,
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"standardMaxRecordCount": 16000,
"isDataVersioned": false,
"templates": [
{
"name": "Equipment_Inventory",
"description": "",
"drawingTool": "esriFeatureEditToolNone",
"prototype": {
"attributes": {
"inventory__": null,
"notes": null,
"name": null,
"location": null,
"equipment_type": null,
"expiration_date": null,
"date_of_purchase": null,
"serial__": null,
"assigned_to": null,
"status": null
}
}
}
],
"supportsAdvancedQueries": true,
"currentVersion": 11.1,
"advancedEditingCapabilities": {
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportsReturnEditResults": true,
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportedApplyEditsUploadIDFormats": "JSON"
},
"objectIdField": "objectid",
"supportsQuantizationEditMode": true,
"name": "Equipment_Inventory",
"displayField": "name",
"supportsCalculate": true,
"fields": [
{
"nullable": false,
"defaultValue": null,
"editable": false,
"length": 4,
"type": "esriFieldTypeOID",
"modelName": "objectid",
"domain": null,
"name": "objectid",
"alias": "ObjectID"
},
{
"modelName": "inventory__",
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "inventory__",
"length": 255,
"alias": "Inventory #",
"type": "esriFieldTypeString"
},
{
"modelName": "serial__",
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "serial__",
"length": 255,
"alias": "Serial #",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 500,
"type": "esriFieldTypeString",
"modelName": "name",
"domain": null,
"name": "name",
"alias": "Model"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"type": "esriFieldTypeString",
"modelName": "equipment_type",
"domain": {
"name": "Equipment_Inventory_equipment_type_4cf6add7-dfad-4462-8f8d-0d994e8f579d",
"type": "codedValue",
"codedValues": [
{
"code": "Laptop",
"name": "Laptop"
},
{
"code": "Desktop",
"name": "Desktop"
},
{
"code": "Monitor",
"name": "Monitor"
},
{
"code": "Docking",
"name": "Docking"
},
{
"code": "Ipad",
"name": "Ipad"
},
{
"code": "Scanner",
"name": "Scanner"
},
{
"code": "Printer",
"name": "Printer"
},
{
"code": "Other",
"name": "Other"
}
]
},
"name": "equipment_type",
"alias": "Equipment Type"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"type": "esriFieldTypeString",
"modelName": "assigned_to",
"domain": {
"name": "Equipment_Inventory_assigned_to_ef657673-c048-4625-824d-03faacc9297d_1",
"type": "codedValue",
"codedValues": [
{
"code": "Anthony Rampton",
"name": "Anthony Rampton"
},
{
"code": "Dillon Hoyt",
"name": "Dillon Hoyt"
},
{
"code": "Michelle Baragona",
"name": "Michelle Baragona"
},
{
"code": "Jill Cooper",
"name": "Jill Cooper"
},
{
"code": "Jordan Lewis",
"name": "Jordan Lewis"
},
{
"code": "Sindy Smith",
"name": "Sindy Smith"
},
{
"code": "Kris Carambelas",
"name": "Kris Carambelas"
},
{
"code": "Jamie Youtz",
"name": "Jamie Youtz"
},
{
"code": "Mark Boshell",
"name": "Mark Boshell"
},
{
"code": "Stephen Ogilvie",
"name": "Stephen Ogilvie"
},
{
"code": "Shea Owens",
"name": "Shea Owens"
},
{
"code": "Hussein Yazdani",
"name": "Hussein Yazdani"
},
{
"code": "Laura Ault",
"name": "Laura Ault"
},
{
"code": "Redge Johnson",
"name": "Redge Johnson"
},
{
"code": "Cristina Houtrouw",
"name": "Cristina Houtrouw"
},
{
"code": "Jason DeForest",
"name": "Jason DeForest"
},
{
"code": "Kaitlin \"Tess\" Davis",
"name": "Kaitlin \"Tess\" Davis"
},
{
"code": "Jake Garfield",
"name": "Jake Garfield"
},
{
"code": "Nancy Merrill",
"name": "Nancy Merrill"
},
{
"code": "Stephen Kaiser",
"name": "Stephen Kaiser"
},
{
"code": "Hayden Ballard",
"name": "Hayden Ballard"
},
{
"code": "Michael Hyde",
"name": "Michael Hyde"
},
{
"code": "Roger Fairbanks",
"name": "Roger Fairbanks"
},
{
"code": "Grace Patrick",
"name": "Grace Patrick"
},
{
"code": "Kendall Laws",
"name": "Kendall Laws"
},
{
"code": "Kathy Davis",
"name": "Kathy Davis"
},
{
"code": "Kelslie Last",
"name": "Kelslie Last"
},
{
"code": "Jason Wolf",
"name": "Jason Wolf"
},
{
"code": "Ryan Sauer",
"name": "Ryan Sauer"
},
{
"code": "Other",
"name": "Other"
},
{
"code": "None",
"name": "None"
}
]
},
"name": "assigned_to",
"alias": "Assigned To"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"type": "esriFieldTypeString",
"modelName": "status",
"domain": {
"name": "Equipment_Inventory_status_8edbb597-2989-4775-8476-dc06c210b49f",
"type": "codedValue",
"codedValues": [
{
"code": "Actively in Use",
"name": "Actively in Use"
},
{
"code": "In Use by Other Person than Assigned",
"name": "In Use by Other Person than Assigned"
},
{
"code": "Needs to be Reassigned",
"name": "Needs to be Reassigned"
},
{
"code": "Extra - Not being Used",
"name": "Extra - Not being Used"
},
{
"code": "Needs to be Surplussed",
"name": "Needs to be Surplussed"
},
{
"code": "Surplussed",
"name": "Surplussed"
},
{
"code": "Unknown",
"name": "Unknown"
},
{
"code": "Other",
"name": "Other"
}
]
},
"name": "status",
"alias": "Status"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"type": "esriFieldTypeString",
"modelName": "location",
"domain": {
"name": "Equipment_Inventory_location_e689b657-ddc2-4ee0-88b0-762773706d0c",
"type": "codedValue",
"codedValues": [
{
"code": "Office",
"name": "Office"
},
{
"code": "Home",
"name": "Home"
},
{
"code": "Unknown",
"name": "Unknown"
},
{
"code": "Other",
"name": "Other"
}
]
},
"name": "location",
"alias": "Location"
},
{
"modelName": "notes",
"nullable": true,
"editable": true,
"defaultValue": null,
"domain": null,
"name": "notes",
"length": 1000,
"alias": "Notes",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"description": "{\"fieldValueType\":\"dateAndTime\",\"value\":\"\"}",
"type": "esriFieldTypeString",
"modelName": "date_of_purchase",
"domain": null,
"name": "date_of_purchase",
"alias": "Date of Purchase"
},
{
"nullable": true,
"editable": true,
"defaultValue": null,
"length": 255,
"description": "{\"fieldValueType\":\"dateAndTime\",\"value\":\"\"}",
"type": "esriFieldTypeString",
"modelName": "expiration_date",
"domain": null,
"name": "expiration_date",
"alias": "Expiration Date"
},
{
"nullable": false,
"editable": false,
"defaultValue": null,
"length": 38,
"type": "esriFieldTypeGlobalID",
"modelName": "globalid",
"domain": null,
"name": "globalid",
"alias": "GlobalID"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "created_user",
"length": 255,
"alias": "created_user",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "created_date",
"length": 29,
"alias": "created_date",
"type": "esriFieldTypeDate"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"domain": null,
"name": "last_edited_user",
"length": 255,
"alias": "last_edited_user",
"type": "esriFieldTypeString"
},
{
"nullable": true,
"editable": false,
"defaultValue": null,
"length": 29,
"description": "{\"fieldValueType\":\"dateAndTime\",\"value\":\"\"}",
"type": "esriFieldTypeDate",
"domain": null,
"name": "last_edited_date",
"alias": "last_edited_date"
}
],
"maxRecordCountFactor": 1,
"dateFieldsTimeReference": {
"respectsDaylightSaving": false,
"timeZone": "UTC"
},
"supportsFieldDescriptionProperty": true,
"allowGeometryUpdates": true,
"useStandardizedQueries": true,
"globalIdField": "globalid",
"description": "",
"syncCanReturnChanges": true,
"supportsAsyncDelete": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin"
],
"supportsRollbackOnFailureParameter": true,
"isDataReplicaTracked": true,
"indexes": [
{
"name": "r295_sde_rowid_uk",
"isUnique": false,
"description": "",
"fields": "objectid",
"isAscending": true
},
{
"name": "uuid_295",
"isUnique": true,
"description": "",
"fields": "globalid",
"isAscending": true
}
],
"editFieldsInfo": {
"editDateField": "last_edited_date",
"editorField": "last_edited_user",
"creationDateField": "created_date",
"creatorField": "created_user"
},
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"hasAttachments": false,
"advancedQueryCapabilities": {
"supportsSqlExpression": true,
"supportsStatistics": true,
"supportsQueryWithResultType": true,
"supportsOrderBy": true,
"supportsQueryRelatedPagination": true,
"supportsLod": false,
"supportsQueryWithCacheHint": false,
"supportsQueryWithDatumTransformation": true,
"supportsQueryAttachmentsWithReturnUrl": true,
"supportsQueryAttachments": true,
"supportsQueryDateBins": false,
"supportsQueryAttachmentsCountOnly": true,
"supportsReturningQueryExtent": true,
"supportsOrderByOnlyOnLayerFields": false,
"supportsOutFieldSqlExpression": true,
"supportsQueryWithLodSR": false,
"supportsTopFeaturesQuery": true,
"supportsPaginationOnAggregatedQueries": true,
"supportsMaxRecordCountFactor": true,
"supportsPagination": true,
"supportsDistinct": true,
"supportsQueryAnalytic": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true
},
"supportsValidateSQL": true,
"enableZDefaults": true,
"serviceItemId": "ae07a1b35732432b8990e111fb2c5aeb",
"allowUpdateWithoutMValues": true,
"supportsCoordinatesQuantization": true,
"types": [],
"capabilities": "Query,Create,Update,Delete,Editing,Sync,Uploads",
"supportsAppend": true,
"supportsExceedsLimitStatistics": true,
"advancedQueryAnalyticCapabilities": {
"supportsAsync": true,
"supportsLinearRegression": true,
"supportsPercentileAnalytic": false
},
"hasMetadata": true,
"supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel",
"tileMaxRecordCount": 4000,
"typeIdField": "",
"supportsASyncCalculate": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"sqlParserVersion": "PG_10.9.1",
"copyrightText": "",
"zDefault": 0,
"supportsLayerOverrides": true
}