{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 853, "name": "GIS.POWEREDEQUIPMENT", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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, "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": "ASSETID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ASSETID" }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "MAKE" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "MODEL" }, { "name": "EQUIPMENTTYPE", "type": "esriFieldTypeString", "alias": "EQUIPMENTTYPE", "domain": { "type": "codedValue", "name": "Ass_PoweredEquipmentType", "description": "", "codedValues": [ { "name": "Aerator", "code": "AERATOR" }, { "name": "Air Compressor", "code": "AIR COMPRESSOR" }, { "name": "Billy Goat", "code": "BILLY GOAT" }, { "name": "Blower", "code": "BLOWER" }, { "name": "Blower/Handheld", "code": "BLOWER/HANDHELD" }, { "name": "Broom", "code": "BROOM" }, { "name": "Bush Trimmer", "code": "BUSH TRIMMER" }, { "name": "Chainsaw", "code": "CHAINSAW" }, { "name": "Compressor", "code": "COMPRESSOR" }, { "name": "Concrete Saw", "code": "CONCRETE SAW" }, { "name": "Cut-off Saw", "code": "CUT-OFF SAW" }, { "name": "Field Laser", "code": "FIELD LASER" }, { "name": "Fire Pump", "code": "FIRE PUMP" }, { "name": "Generator", "code": "GENERATOR" }, { "name": "Hedge Trimmer", "code": "HEDGE TRIMMER" }, { "name": "Ice Edger", "code": "ICE EDGER" }, { "name": "Jumping Jack", "code": "JUMPING JACK" }, { "name": "Lawn Edger", "code": "LAWN EDGER" }, { "name": "Lawn Mower", "code": "LAWN MOWER" }, { "name": "Lawn Mower - Electric", "code": "LAWN MOWER - ELECTRIC" }, { "name": "Line Laser", "code": "LINE LASER" }, { "name": "Mini Tiller", "code": "MINI TILLER" }, { "name": "Plate Tamper", "code": "PLATE TAMPER" }, { "name": "Pole Saw", "code": "POLE SAW" }, { "name": "Pole Saw - Electric", "code": "POLE SAW - ELECTRIC" }, { "name": "Power Head", "code": "POWER HEAD" }, { "name": "Power Screed", "code": "POWER SCREED" }, { "name": "Pressure Washer", "code": "PRESSURE WASHER" }, { "name": "Pruner", "code": "PRUNER" }, { "name": "Pump", "code": "PUMP" }, { "name": "Rototiller", "code": "ROTOTILLER" }, { "name": "Sodcutter", "code": "SODCUTTER" }, { "name": "Superfreeze - Rigid", "code": "SUPERFREEZE - RIGID" }, { "name": "Trailer", "code": "TRAILER" }, { "name": "Trash Pump", "code": "TRASH PUMP" }, { "name": "Trimmer", "code": "TRIMMER" }, { "name": "Trimmer - Battery", "code": "TRIMMER - BATTERY" }, { "name": "Walk Behind", "code": "WALK BEHIND" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TYPE" }, { "name": "ACQUIREDATE", "type": "esriFieldTypeDate", "alias": "ACQUIREDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACQUIREDATE" }, { "name": "CAPITALPROJECTNO", "type": "esriFieldTypeString", "alias": "CAPITALPROJECTNO", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "CAPITALPROJECTNO" }, { "name": "ASSETSTATUS", "type": "esriFieldTypeString", "alias": "AssetStatus", "domain": { "type": "codedValue", "name": "Ass_AssetStatus", "description": "", "codedValues": [ { "name": "In Service", "code": "IN SERVICE" }, { "name": "Out of Service", "code": "OUT OF SERVICE" }, { "name": "Disposed", "code": "DISPOSED" }, { "name": "Not Applicable", "code": "N/A" }, { "name": "Merge", "code": "MERGE" }, { "name": "Preliminary", "code": "PRELIMINARY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "IN SERVICE", "modelName": "AssetStatus" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "UNITNO", "type": "esriFieldTypeString", "alias": "UNITNO", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "UNITNO" }, { "name": "SUBDIVISION", "type": "esriFieldTypeString", "alias": "SUBDIVISION", "domain": { "type": "codedValue", "name": "Flt_Subdivision", "description": "", "codedValues": [ { "name": "Aboriculture", "code": "ABORICULTURE" }, { "name": "Arenas", "code": "ARENAS" }, { "name": "Building Inspection", "code": "BUILDING INSPECTION" }, { "name": "Carpentry", "code": "CARPENTRY" }, { "name": "Cemetery", "code": "CEMETERY" }, { "name": "Construction", "code": "CONSTRUCTION" }, { "name": "Courier", "code": "COURIER" }, { "name": "Electrical", "code": "ELECTRICAL" }, { "name": "Engineering Development", "code": "ENGINEERING DEVELOPMENT" }, { "name": "Environmental Services", "code": "ENVIRONMENTAL SERVICES" }, { "name": "Facilities", "code": "FACILITIES" }, { "name": "Fire Hall 1", "code": "FIRE HALL 1" }, { "name": "Fire Hall 2", "code": "FIRE HALL 2" }, { "name": "Fire Hall 3", "code": "FIRE HALL 3" }, { "name": "Fire Hall 4", "code": "FIRE HALL 4" }, { "name": "Fire Hall 5", "code": "FIRE HALL 5" }, { "name": "Fire Hall 6", "code": "FIRE HALL 6" }, { "name": "Fire Hall 7", "code": "FIRE HALL 7" }, { "name": "Fire Training Centre", "code": "FIRE TRAINING CENTRE" }, { "name": "Generators", "code": "GENERATORS" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Horticulture", "code": "HORTICULTURE" }, { "name": "Inspection", "code": "INSPECTION" }, { "name": "Irrigation", "code": "IRRIGATION" }, { "name": "Maintenance", "code": "MAINTENANCE" }, { "name": "Mechanical Loaner", "code": "MECHANICAL LOANER" }, { "name": "Millwrights", "code": "MILLWRIGHTS" }, { "name": "Natural Resources", "code": "NATURAL RESOURCES" }, { "name": "Operations", "code": "OPERATIONS" }, { "name": "Parks Operations", "code": "PARKS OPERATIONS" }, { "name": "Plumbing", "code": "PLUMBING" }, { "name": "Pool Vehicles", "code": "POOL VEHICLES" }, { "name": "Pools", "code": "POOLS" }, { "name": "Sanitary Pump Stations", "code": "SANITARY PUMP STATIONS" }, { "name": "Sanitary Waste Water Treatment", "code": "SANITARY WASTEWATER TREATMENT" }, { "name": "Sign Shop", "code": "SIGN SHOP" }, { "name": "Solid Waste", "code": "SOLID WASTE" }, { "name": "Stores", "code": "STORES" }, { "name": "Streets", "code": "STREETS" }, { "name": "Surveyor", "code": "SURVEYOR" }, { "name": "Treatment", "code": "TREATMENT" }, { "name": "Treatment - Waste Water", "code": "TREATMENT - WASTE WATER" }, { "name": "Treatment - Water", "code": "TREATMENT - WATER" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Water Pump Stations", "code": "WATER PUMP STATIONS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUBDIVISION" }, { "name": "MODELYEAR", "type": "esriFieldTypeString", "alias": "MODELYEAR", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "MODELYEAR" }, { "name": "DEALER", "type": "esriFieldTypeString", "alias": "DEALER", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DEALER" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "LOCATION" } ], "indexes": [ { "name": "R2166_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2166", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GIS.POWEREDEQUIPMENT", "description": "", "prototype": { "attributes": { "DESCRIPTION": null, "DEALER": null, "ASSETID": null, "MAKE": null, "MODEL": null, "EQUIPMENTTYPE": null, "ACQUIREDATE": null, "CAPITALPROJECTNO": null, "ASSETSTATUS": "IN SERVICE", "SERIALNO": null, "LOCATION": null, "UNITNO": null, "SUBDIVISION": null, "MODELYEAR": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bdbec7643fd1406ab84392a43f45b3ba" }