{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "COC_Maintenance_Shops", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "COC_Maintenance_Shops", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Address", "composite": false, "catalogID": "{A38409D1-EFB4-4FD7-B043-ABBA11EBC5D5}" }, { "id": 0, "name": "COC_Maintenance_Shops", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Address", "composite": false, "catalogID": "{975E7334-F94A-4B45-A0EC-F1888A1063FD}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 173036.59962107986, "ymin": 1704491.590998657, "xmax": 212684.57478691265, "ymax": 1723775.8690310717, "spatialReference": { "wkid": 2244, "latestWkid": 2965, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -18119800, "falseY": -45615400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 2244, "latestWkid": 2965, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -18119800, "falseY": -45615400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 228, 252, 186, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "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": 50, "defaultValue": null, "modelName": "AssetID" }, { "name": "StructureType", "type": "esriFieldTypeString", "alias": "Structure Type", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "StructureType" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Location", "domain": { "type": "codedValue", "name": "FleetEquipment_MaintenanceLocations", "description": "City fleet & equipment maintenance locations", "codedValues": [ { "name": "Street Maintenance Shop", "code": "Street Maintenance Shop" }, { "name": "Water Distribution", "code": "Water Distribution" }, { "name": "WWTP", "code": "WWTP" }, { "name": "Police Garage", "code": "Police Garage" }, { "name": "Fire Garage", "code": "Fire Garage" }, { "name": "Non-City Facility", "code": "Non-City Facility" }, { "name": "Utilities Maintenance Shop", "code": "Utilities Maintenance Shop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location Details", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Location" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Status" }, { "name": "AssetCost", "type": "esriFieldTypeString", "alias": "Asset Cost", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "AssetCost" }, { "name": "Process", "type": "esriFieldTypeString", "alias": "Process", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Process" }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "LifeExpectancy", "type": "esriFieldTypeSmallInteger", "alias": "Life Expectancy", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LifeExpectancy" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "Consequence of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "Probability of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "Business Risk Exposure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R1145_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1145", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_26609_Locati", "fields": "Location", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_26609_AssetI", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_26609_Addres", "fields": "Address", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S810_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "COC_Maintenance_Shops", "description": "", "prototype": { "attributes": { "last_edited_date": null, "last_edited_user": null, "AssetID": null, "StructureType": null, "LegacyID": null, "Address": null, "Location": null, "InstallDate": null, "WarrantyDate": null, "Status": null, "AssetCost": null, "Process": null, "Condition": null, "ConditionDate": null, "LifeExpectancy": null, "COF": null, "POF": null, "BRE": null, "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "694748f2bf324fbb9a129e999a2a59ea" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "COC_Equipment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "COC_Equipment", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "MaintLocation", "composite": false, "catalogID": "{975E7334-F94A-4B45-A0EC-F1888A1063FD}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID_1", "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": 255, "defaultValue": null, "modelName": "AssetID" }, { "name": "CarmelID", "type": "esriFieldTypeString", "alias": "CarmelID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CarmelID" }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Category" }, { "name": "Subcategory", "type": "esriFieldTypeString", "alias": "Subcategory", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Subcategory" }, { "name": "UnitNumber", "type": "esriFieldTypeString", "alias": "Unit Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UnitNumber" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Make" }, { "name": "ModelDescription", "type": "esriFieldTypeString", "alias": "Model Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ModelDescription" }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "Model Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ModelNumber" }, { "name": "Color", "type": "esriFieldTypeString", "alias": "Color", "domain": { "type": "codedValue", "name": "FleetEquip_Color", "description": "Color of fleet or equipment", "codedValues": [ { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Brown", "code": "Brown" }, { "name": "Gray", "code": "Gray" }, { "name": "Green", "code": "Green" }, { "name": "Orange", "code": "Orange" }, { "name": "Other", "code": "Other" }, { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Purple", "code": "Purple" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Color" }, { "name": "CWEquipDesc", "type": "esriFieldTypeString", "alias": "CW Equipment Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CWEquipDesc" }, { "name": "CWEquipID", "type": "esriFieldTypeString", "alias": "CW Equipment ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CWEquipID" }, { "name": "Plate", "type": "esriFieldTypeString", "alias": "Plate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Plate" }, { "name": "Serial_VIN", "type": "esriFieldTypeString", "alias": "Serial_VIN", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Serial_VIN" }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "FuelType", "domain": { "type": "codedValue", "name": "FleetEquip_FuelType", "description": "Fleet and equipment fuel type", "codedValues": [ { "name": "Biodiesel", "code": "Biodiesel" }, { "name": "Diesel", "code": "Diesel" }, { "name": "Electric", "code": "Electric" }, { "name": "Gas", "code": "Gas" }, { "name": "Hybrid", "code": "Hybrid" }, { "name": "Natural Gas", "code": "Natural Gas" }, { "name": "Propane", "code": "Propane" }, { "name": "2-Cycle", "code": "2-Cycle" }, { "name": "4-Cycle", "code": "4-Cycle" }, { "name": "Flex / Fuel", "code": "Flex / Fuel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FuelType" }, { "name": "SCFID", "type": "esriFieldTypeString", "alias": "SCFID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SCFID" }, { "name": "FEMACode", "type": "esriFieldTypeString", "alias": "FEMA Code", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FEMACode" }, { "name": "FEMARate", "type": "esriFieldTypeDouble", "alias": "FEMA Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEMARate" }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "domain": { "type": "codedValue", "name": "aDomDepartment", "description": "CIty Departments", "codedValues": [ { "name": "Engineering", "code": "Engineering" }, { "name": "Street", "code": "Street" }, { "name": "Utilities", "code": "Utilities" }, { "name": "ICS", "code": "ICS" }, { "name": "Police", "code": "Police" }, { "name": "Fire", "code": "Fire" }, { "name": "DOCS", "code": "DOCS" }, { "name": "Administration", "code": "Administration" }, { "name": "CRC", "code": "CRC" }, { "name": "Brookshire", "code": "Brookshire" }, { "name": "Law", "code": "Law" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Department" }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "domain": { "type": "codedValue", "name": "aDomDivision", "description": "City Divisions", "codedValues": [ { "name": "Wastewater", "code": "Wastewater" }, { "name": "Water", "code": "Water" }, { "name": "Locators", "code": "Locators" }, { "name": "Meter Readers", "code": "Meter Readers" }, { "name": "Utility Administration", "code": "Utility Administration" }, { "name": "Fleet", "code": "Fleet" }, { "name": "Events", "code": "Events" }, { "name": "Signs & Lights", "code": "Signs & Lights" }, { "name": "Drainage", "code": "Drainage" }, { "name": "Trails & Curb", "code": "Trails & Curb" }, { "name": "Street", "code": "Street" }, { "name": "Landscaping", "code": "Landscaping" }, { "name": "Trees", "code": "Trees" }, { "name": "Fountains & Irrigation", "code": "Fountains & Irrigation" }, { "name": "Pool Car", "code": "Pool Car" }, { "name": "Communications", "code": "Communications" }, { "name": "IT Administration", "code": "IT Administration" }, { "name": "Street Administration", "code": "Street Administration" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Division" }, { "name": "MaintLocation", "type": "esriFieldTypeString", "alias": "Maintenance Location", "domain": { "type": "codedValue", "name": "FleetEquipment_MaintenanceLocations", "description": "City fleet & equipment maintenance locations", "codedValues": [ { "name": "Street Maintenance Shop", "code": "Street Maintenance Shop" }, { "name": "Water Distribution", "code": "Water Distribution" }, { "name": "WWTP", "code": "WWTP" }, { "name": "Police Garage", "code": "Police Garage" }, { "name": "Fire Garage", "code": "Fire Garage" }, { "name": "Non-City Facility", "code": "Non-City Facility" }, { "name": "Utilities Maintenance Shop", "code": "Utilities Maintenance Shop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintLocation" }, { "name": "RelatedStructure", "type": "esriFieldTypeString", "alias": "Related Structure", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RelatedStructure" }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssignedTo" }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Operator" }, { "name": "Filter", "type": "esriFieldTypeString", "alias": "Filter", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Filter" }, { "name": "Fluid", "type": "esriFieldTypeString", "alias": "Fluid", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Fluid" }, { "name": "PMSchedule", "type": "esriFieldTypeString", "alias": "PM Schedule", "domain": { "type": "codedValue", "name": "FleetEquip_PM", "description": "Fleet and equipment PM Schedules", "codedValues": [ { "name": "Engine Oil Life", "code": "Engine Oil Life" }, { "name": "Mileage", "code": "Mileage" }, { "name": "Hours", "code": "Hours" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PMSchedule" }, { "name": "PMLSD", "type": "esriFieldTypeDate", "alias": "PM Last Service Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PMLSD" }, { "name": "Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mileage" }, { "name": "MIleageLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced MIleage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MIleageLS" }, { "name": "EngineHours", "type": "esriFieldTypeDouble", "alias": "Engine Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EngineHours" }, { "name": "EngineHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Engine Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EngineHoursLS" }, { "name": "AuxHours", "type": "esriFieldTypeDouble", "alias": "Auxillary Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AuxHours" }, { "name": "AuxHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Aux Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AuxHoursLS" }, { "name": "EOL", "type": "esriFieldTypeDouble", "alias": "Engine Oil Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EOL" }, { "name": "OwnType", "type": "esriFieldTypeString", "alias": "OwnType", "domain": { "type": "codedValue", "name": "FleetEquip_OwnType", "description": "Ownership type of fleet and equipment", "codedValues": [ { "name": "Own", "code": "Own" }, { "name": "Leased", "code": "Leased" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OwnType" }, { "name": "LLEndDate", "type": "esriFieldTypeDate", "alias": "Lease_Loan End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LLEndDate" }, { "name": "DOP", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DOP" }, { "name": "PP", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PP" }, { "name": "RC", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RC" }, { "name": "TargetRPLYear", "type": "esriFieldTypeInteger", "alias": "Target Replacement Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetRPLYear" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "WarrantyMileage", "type": "esriFieldTypeDouble", "alias": "Warranty Mileage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WarrantyMileage" }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "FleetEquip_Status", "description": "Status of fleet & equipment", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Planned", "code": "Planned" }, { "name": "Sold", "code": "Sold" }, { "name": "Transferred", "code": "Transferred" }, { "name": "Traded", "code": "Traded" }, { "name": "Missing", "code": "Missing" }, { "name": "Pending", "code": "Pending" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "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": "GlobalID_1", "type": "esriFieldTypeGlobalID", "alias": "GlobalID_1", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID_1" }, { "name": "WOID", "type": "esriFieldTypeString", "alias": "WOID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WOID" }, { "name": "WOStatus", "type": "esriFieldTypeString", "alias": "WOStatus", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WOStatus" }, { "name": "PMInspectDate", "type": "esriFieldTypeDate", "alias": "PM Inspect Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PMInspectDate" }, { "name": "PMDueHrs", "type": "esriFieldTypeDouble", "alias": "PM Next Due Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PMDueHrs" }, { "name": "PMDueMiles", "type": "esriFieldTypeDouble", "alias": "PM Next Due Mileage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PMDueMiles" } ], "indexes": [ { "name": "R1115_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1115", "fields": "GlobalID_1", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "COC_Equipment", "description": "", "prototype": { "attributes": { "PMDueHrs": null, "PMInspectDate": null, "AssetID": null, "CarmelID": null, "Category": null, "Subcategory": null, "UnitNumber": null, "Year": null, "Make": null, "ModelDescription": null, "ModelNumber": null, "Color": null, "CWEquipDesc": null, "CWEquipID": null, "Plate": null, "Serial_VIN": null, "FuelType": null, "SCFID": null, "FEMACode": null, "FEMARate": null, "Department": null, "Division": null, "MaintLocation": null, "RelatedStructure": null, "AssignedTo": null, "Operator": null, "Filter": null, "Fluid": null, "PMSchedule": null, "PMLSD": null, "Mileage": null, "MIleageLS": null, "EngineHours": null, "EngineHoursLS": null, "AuxHours": null, "AuxHoursLS": null, "EOL": null, "OwnType": null, "LLEndDate": null, "DOP": null, "PP": null, "RC": null, "TargetRPLYear": null, "WarrantyDate": null, "WarrantyMileage": null, "COF": null, "POF": null, "BRE": null, "Comments": null, "Status": null, "WOStatus": null, "WOID": null, "PMDueMiles": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "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": 2000, "maxRecordCountFactor": 1, "serviceItemId": "694748f2bf324fbb9a129e999a2a59ea" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "COC_Vehicles", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "COC_Vehicles", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "MaintLocation", "composite": false, "catalogID": "{A38409D1-EFB4-4FD7-B043-ABBA11EBC5D5}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID_1", "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": 255, "defaultValue": null, "modelName": "AssetID" }, { "name": "CarmelID", "type": "esriFieldTypeString", "alias": "CarmelID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CarmelID" }, { "name": "UnitNumber", "type": "esriFieldTypeString", "alias": "Unit Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UnitNumber" }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Category" }, { "name": "Subcategory", "type": "esriFieldTypeString", "alias": "Subcategory", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Subcategory" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Make" }, { "name": "ModelDescription", "type": "esriFieldTypeString", "alias": "Model Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ModelDescription" }, { "name": "Color", "type": "esriFieldTypeString", "alias": "Color", "domain": { "type": "codedValue", "name": "FleetEquip_Color", "description": "Color of fleet or equipment", "codedValues": [ { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Brown", "code": "Brown" }, { "name": "Gray", "code": "Gray" }, { "name": "Green", "code": "Green" }, { "name": "Orange", "code": "Orange" }, { "name": "Other", "code": "Other" }, { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Purple", "code": "Purple" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Color" }, { "name": "CWEquipDesc", "type": "esriFieldTypeString", "alias": "CW Equipment Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CWEquipDesc" }, { "name": "CWEquipID", "type": "esriFieldTypeString", "alias": "CW Equipment ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CWEquipID" }, { "name": "Plate", "type": "esriFieldTypeString", "alias": "Plate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Plate" }, { "name": "VIN", "type": "esriFieldTypeString", "alias": "VIN", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "VIN" }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "FuelType", "domain": { "type": "codedValue", "name": "FleetEquip_FuelType", "description": "Fleet and equipment fuel type", "codedValues": [ { "name": "Biodiesel", "code": "Biodiesel" }, { "name": "Diesel", "code": "Diesel" }, { "name": "Electric", "code": "Electric" }, { "name": "Gas", "code": "Gas" }, { "name": "Hybrid", "code": "Hybrid" }, { "name": "Natural Gas", "code": "Natural Gas" }, { "name": "Propane", "code": "Propane" }, { "name": "2-Cycle", "code": "2-Cycle" }, { "name": "4-Cycle", "code": "4-Cycle" }, { "name": "Flex / Fuel", "code": "Flex / Fuel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FuelType" }, { "name": "SCFID", "type": "esriFieldTypeString", "alias": "School Fuel ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SCFID" }, { "name": "CKFID", "type": "esriFieldTypeString", "alias": "Circle K Fuel ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CKFID" }, { "name": "MFID", "type": "esriFieldTypeString", "alias": "Meijer Fuel ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MFID" }, { "name": "EMS", "type": "esriFieldTypeString", "alias": "EMS Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EMS" }, { "name": "ShellID", "type": "esriFieldTypeString", "alias": "Shell Fuel ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ShellID" }, { "name": "KNOX", "type": "esriFieldTypeString", "alias": "Knox Key", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "KNOX" }, { "name": "FEMACode", "type": "esriFieldTypeString", "alias": "FEMA Code", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FEMACode" }, { "name": "FEMARate", "type": "esriFieldTypeDouble", "alias": "FEMA Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEMARate" }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "domain": { "type": "codedValue", "name": "aDomDepartment", "description": "CIty Departments", "codedValues": [ { "name": "Engineering", "code": "Engineering" }, { "name": "Street", "code": "Street" }, { "name": "Utilities", "code": "Utilities" }, { "name": "ICS", "code": "ICS" }, { "name": "Police", "code": "Police" }, { "name": "Fire", "code": "Fire" }, { "name": "DOCS", "code": "DOCS" }, { "name": "Administration", "code": "Administration" }, { "name": "CRC", "code": "CRC" }, { "name": "Brookshire", "code": "Brookshire" }, { "name": "Law", "code": "Law" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Department" }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "domain": { "type": "codedValue", "name": "aDomDivision", "description": "City Divisions", "codedValues": [ { "name": "Wastewater", "code": "Wastewater" }, { "name": "Water", "code": "Water" }, { "name": "Locators", "code": "Locators" }, { "name": "Meter Readers", "code": "Meter Readers" }, { "name": "Utility Administration", "code": "Utility Administration" }, { "name": "Fleet", "code": "Fleet" }, { "name": "Events", "code": "Events" }, { "name": "Signs & Lights", "code": "Signs & Lights" }, { "name": "Drainage", "code": "Drainage" }, { "name": "Trails & Curb", "code": "Trails & Curb" }, { "name": "Street", "code": "Street" }, { "name": "Landscaping", "code": "Landscaping" }, { "name": "Trees", "code": "Trees" }, { "name": "Fountains & Irrigation", "code": "Fountains & Irrigation" }, { "name": "Pool Car", "code": "Pool Car" }, { "name": "Communications", "code": "Communications" }, { "name": "IT Administration", "code": "IT Administration" }, { "name": "Street Administration", "code": "Street Administration" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Division" }, { "name": "MaintLocation", "type": "esriFieldTypeString", "alias": "Maintenance Location", "domain": { "type": "codedValue", "name": "FleetEquipment_MaintenanceLocations", "description": "City fleet & equipment maintenance locations", "codedValues": [ { "name": "Street Maintenance Shop", "code": "Street Maintenance Shop" }, { "name": "Water Distribution", "code": "Water Distribution" }, { "name": "WWTP", "code": "WWTP" }, { "name": "Police Garage", "code": "Police Garage" }, { "name": "Fire Garage", "code": "Fire Garage" }, { "name": "Non-City Facility", "code": "Non-City Facility" }, { "name": "Utilities Maintenance Shop", "code": "Utilities Maintenance Shop" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintLocation" }, { "name": "RelatedStructure", "type": "esriFieldTypeString", "alias": "Related Structure", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RelatedStructure" }, { "name": "PoolCar", "type": "esriFieldTypeString", "alias": "Pool Car", "domain": { "type": "codedValue", "name": "aDomYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoolCar" }, { "name": "TakeHome", "type": "esriFieldTypeString", "alias": "TakeHome", "domain": { "type": "codedValue", "name": "aDomYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TakeHome" }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssignedTo" }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Operator" }, { "name": "Filter", "type": "esriFieldTypeString", "alias": "Filter", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Filter" }, { "name": "Fluid", "type": "esriFieldTypeString", "alias": "Fluid", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Fluid" }, { "name": "PMSchedule", "type": "esriFieldTypeString", "alias": "PM Schedule", "domain": { "type": "codedValue", "name": "FleetEquip_PM", "description": "Fleet and equipment PM Schedules", "codedValues": [ { "name": "Engine Oil Life", "code": "Engine Oil Life" }, { "name": "Mileage", "code": "Mileage" }, { "name": "Hours", "code": "Hours" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PMSchedule" }, { "name": "PMLSD", "type": "esriFieldTypeDate", "alias": "PM Last Service Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PMLSD" }, { "name": "Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mileage" }, { "name": "MIleageLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced MIleage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MIleageLS" }, { "name": "EngineHours", "type": "esriFieldTypeDouble", "alias": "EngineHours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EngineHours" }, { "name": "EngineHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Engine Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EngineHoursLS" }, { "name": "AuxHours", "type": "esriFieldTypeDouble", "alias": "Auxillary Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AuxHours" }, { "name": "AuxHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Aux Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AuxHoursLS" }, { "name": "EOL", "type": "esriFieldTypeDouble", "alias": "Engine Oil Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EOL" }, { "name": "OwnType", "type": "esriFieldTypeString", "alias": "OwnType", "domain": { "type": "codedValue", "name": "FleetEquip_OwnType", "description": "Ownership type of fleet and equipment", "codedValues": [ { "name": "Own", "code": "Own" }, { "name": "Leased", "code": "Leased" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OwnType" }, { "name": "LLEndDate", "type": "esriFieldTypeDate", "alias": "Lease_Loan End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LLEndDate" }, { "name": "DOP", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DOP" }, { "name": "PP", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PP" }, { "name": "RC", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RC" }, { "name": "TargetRPLYear", "type": "esriFieldTypeInteger", "alias": "Target Replacement Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetRPLYear" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "WarrantyMileage", "type": "esriFieldTypeDouble", "alias": "Warranty Mileage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WarrantyMileage" }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "FleetEquip_Status", "description": "Status of fleet & equipment", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Planned", "code": "Planned" }, { "name": "Sold", "code": "Sold" }, { "name": "Transferred", "code": "Transferred" }, { "name": "Traded", "code": "Traded" }, { "name": "Missing", "code": "Missing" }, { "name": "Pending", "code": "Pending" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "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": "GlobalID_1", "type": "esriFieldTypeGlobalID", "alias": "GlobalID_1", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID_1" }, { "name": "WOID", "type": "esriFieldTypeString", "alias": "WOID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WOID" }, { "name": "WOStatus", "type": "esriFieldTypeString", "alias": "WOStatus", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WOStatus" }, { "name": "PMInspectDate", "type": "esriFieldTypeDate", "alias": "PM Inspect Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PMInspectDate" }, { "name": "PMDueHrs", "type": "esriFieldTypeDouble", "alias": "PM Next Due Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PMDueHrs" }, { "name": "PMDueMiles", "type": "esriFieldTypeDouble", "alias": "PM Next Due Mileage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PMDueMiles" } ], "indexes": [ { "name": "R1118_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1118", "fields": "GlobalID_1", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "COC_Vehicles", "description": "", "prototype": { "attributes": { "PMDueHrs": null, "PMInspectDate": null, "AssetID": null, "CarmelID": null, "UnitNumber": null, "Category": null, "Subcategory": null, "Year": null, "Make": null, "ModelDescription": null, "Color": null, "CWEquipDesc": null, "CWEquipID": null, "Plate": null, "VIN": null, "FuelType": null, "SCFID": null, "CKFID": null, "MFID": null, "EMS": null, "ShellID": null, "KNOX": null, "FEMACode": null, "FEMARate": null, "Department": null, "Division": null, "MaintLocation": null, "RelatedStructure": null, "PoolCar": null, "TakeHome": null, "AssignedTo": null, "Operator": null, "Filter": null, "Fluid": null, "PMSchedule": null, "PMLSD": null, "Mileage": null, "MIleageLS": null, "EngineHours": null, "EngineHoursLS": null, "AuxHours": null, "AuxHoursLS": null, "EOL": null, "OwnType": null, "LLEndDate": null, "DOP": null, "PP": null, "RC": null, "TargetRPLYear": null, "WarrantyDate": null, "WarrantyMileage": null, "COF": null, "POF": null, "BRE": null, "Comments": null, "Status": null, "WOStatus": null, "WOID": null, "PMDueMiles": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "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": "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": 2000, "maxRecordCountFactor": 1, "serviceItemId": "694748f2bf324fbb9a129e999a2a59ea" } ] }