{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "EquipmentTable", "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": "GIS_ADMINISTRATOR.Equipment", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "AssetID", "composite": false, "catalogID": "{B11EF260-8374-4D06-A31F-2F28CE171943}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": 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": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "EquipmentID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeDouble", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssetID" }, { "name": "DEPARTMENT", "type": "esriFieldTypeDouble", "alias": "Department", "domain": { "type": "codedValue", "name": "Department_Codes_CW", "description": "Desc", "codedValues": [ { "name": "FIRE DEPARTMENT", "code": 10952 }, { "name": "POLICE DEPARTMENT", "code": 10955 }, { "name": "MARINE RESOURCES", "code": 444601 }, { "name": "SCHOOL DEPARTMENT", "code": 10954 }, { "name": "SCHOOL MAINTENANCE", "code": 11179 }, { "name": "PW OPERATIONS", "code": 11012 }, { "name": "TRAFFIC SIGNALS", "code": 1145939 }, { "name": "COMMUNITY SERVICES", "code": 10956 }, { "name": "PLANNING DEPARTMENT", "code": 10957 }, { "name": "PROUTS NECK ASSOCIATION", "code": 10961 }, { "name": "SANITARY DISTRICT", "code": 10960 }, { "name": "IT", "code": 10959 }, { "name": "PRIVATE AND CONTRACTUAL", "code": 1195558 }, { "name": "RESCUE DEPARTMENT", "code": 10953 }, { "name": "VEHICLE MAINTENANCE", "code": 11013 }, { "name": "OLD ORCHARD BEACH", "code": 1111389 }, { "name": "HOLLIS", "code": 1111400 }, { "name": "WELLS", "code": 1111401 }, { "name": "KENNEBUNK", "code": 1111402 }, { "name": "OLD ORCHARD BEACH POLICE", "code": 1111403 }, { "name": "GENERATORS", "code": 1111404 }, { "name": "WESTBROOK", "code": 1111405 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Department" }, { "name": "Priority", "type": "esriFieldTypeDouble", "alias": "Priority", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Priority" }, { "name": "EquipmentID", "type": "esriFieldTypeString", "alias": "Equipment ID", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "EquipmentID" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Description" }, { "name": "EquipRate", "type": "esriFieldTypeDouble", "alias": "EquipRate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EquipRate" }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Make" }, { "name": "ModelYear", "type": "esriFieldTypeSmallInteger", "alias": "ModelYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ModelYear" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNO", "type": "esriFieldTypeString", "alias": "SerialNO", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SerialNO" }, { "name": "PLATENo", "type": "esriFieldTypeString", "alias": "PLATENo", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PLATENo" }, { "name": "PLATETYPE", "type": "esriFieldTypeString", "alias": "PLATETYPE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PLATETYPE" }, { "name": "EXPECTEDLIFE", "type": "esriFieldTypeSmallInteger", "alias": "EXPECTEDLIFE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXPECTEDLIFE" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "LastInspection", "type": "esriFieldTypeDate", "alias": "LastInspection", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastInspection" }, { "name": "InserviceDate", "type": "esriFieldTypeDate", "alias": "InserviceDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InserviceDate" }, { "name": "Outservicedate", "type": "esriFieldTypeDate", "alias": "Outservicedate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Outservicedate" }, { "name": "TmpOutSrv", "type": "esriFieldTypeSmallInteger", "alias": "TmpOutSrv", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "TmpOutSrv" }, { "name": "EstInServ", "type": "esriFieldTypeDate", "alias": "EstInServ", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EstInServ" }, { "name": "BuyDate", "type": "esriFieldTypeDate", "alias": "BuyDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BuyDate" }, { "name": "CostNew", "type": "esriFieldTypeDouble", "alias": "CostNew", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CostNew" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Notes" }, { "name": "startread", "type": "esriFieldTypeDouble", "alias": "startread", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "startread" }, { "name": "VEHICLECATEGORY", "type": "esriFieldTypeString", "alias": "VEHICLECATEGORY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VEHICLECATEGORY" }, { "name": "SellCost", "type": "esriFieldTypeDouble", "alias": "SellCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SellCost" }, { "name": "SellDate", "type": "esriFieldTypeDate", "alias": "SellDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SellDate" }, { "name": "Engine1Make", "type": "esriFieldTypeString", "alias": "Engine1Make", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Engine1Make" }, { "name": "Engine1Model", "type": "esriFieldTypeString", "alias": "Engine1Model", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Engine1Model" }, { "name": "Engine1Serial", "type": "esriFieldTypeString", "alias": "Engine1Serial", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Engine1Serial" }, { "name": "Engine2Make", "type": "esriFieldTypeString", "alias": "Engine2Make", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Engine2Make" }, { "name": "Engine2Model", "type": "esriFieldTypeString", "alias": "Engine2Model", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Engine2Model" }, { "name": "Engine2Serial", "type": "esriFieldTypeString", "alias": "Engine2Serial", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Engine2Serial" }, { "name": "TransmissionMake", "type": "esriFieldTypeString", "alias": "TransmissionMake", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "TransmissionMake" }, { "name": "TransmissionModel", "type": "esriFieldTypeString", "alias": "TransmissionModel", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "TransmissionModel" }, { "name": "TransmissionSerial", "type": "esriFieldTypeString", "alias": "TransmissionSerial", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TransmissionSerial" }, { "name": "FUELTANKVOLUME", "type": "esriFieldTypeDouble", "alias": "FUELTANKVOLUME", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FUELTANKVOLUME" }, { "name": "Weight", "type": "esriFieldTypeInteger", "alias": "Weight", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Weight" }, { "name": "itempic", "type": "esriFieldTypeString", "alias": "itempic", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "itempic" }, { "name": "Archive", "type": "esriFieldTypeSmallInteger", "alias": "Archive", "domain": { "type": "codedValue", "name": "Archive", "description": "Archive", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Archive" }, { "name": "FuelTypeID", "type": "esriFieldTypeDouble", "alias": "FuelTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FuelTypeID" }, { "name": "Details", "type": "esriFieldTypeString", "alias": "Details", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Details" }, { "name": "Hours", "type": "esriFieldTypeString", "alias": "Hours", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Hours" }, { "name": "Mileage", "type": "esriFieldTypeString", "alias": "Mileage", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Mileage" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Location" }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "COLOR", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COLOR" }, { "name": "DepartmentNO", "type": "esriFieldTypeDouble", "alias": "DepartmentNO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DepartmentNO" }, { "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": "R382_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_382", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G349AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_382", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "EquipmentTable", "description": "", "prototype": { "attributes": { "DepartmentNO": null, "AssetID": null, "DEPARTMENT": null, "Priority": null, "EquipmentID": null, "Description": null, "EquipRate": null, "Make": null, "ModelYear": null, "Model": null, "SerialNO": null, "PLATENo": null, "PLATETYPE": null, "EXPECTEDLIFE": null, "Condition": null, "LastInspection": null, "InserviceDate": null, "Outservicedate": null, "TmpOutSrv": 0, "EstInServ": null, "BuyDate": null, "CostNew": null, "Notes": null, "startread": null, "VEHICLECATEGORY": null, "SellCost": null, "SellDate": null, "Engine1Make": null, "Engine1Model": null, "Engine1Serial": null, "Engine2Make": null, "Engine2Model": null, "Engine2Serial": null, "TransmissionMake": null, "TransmissionModel": null, "TransmissionSerial": null, "FUELTANKVOLUME": null, "Weight": null, "itempic": null, "Archive": 0, "FuelTypeID": null, "Details": null, "Hours": null, "Mileage": null, "Location": null, "COLOR": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }