{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "COC_Maintenance_Shops", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "StructureType", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 5, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 255, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "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" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location Details", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "domain": null }, { "name": "AssetCost", "type": "esriFieldTypeString", "alias": "Asset Cost", "length": 30, "domain": null }, { "name": "Process", "type": "esriFieldTypeString", "alias": "Process", "length": 255, "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "LifeExpectancy", "type": "esriFieldTypeSmallInteger", "alias": "Life Expectancy", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "Consequence of Failure", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "Probability of Failure", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "Business Risk Exposure", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "COC_Maintenance_Shops", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "Address", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A38409D1-EFB4-4FD7-B043-ABBA11EBC5D5}" }, { "id": 0, "name": "COC_Maintenance_Shops", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "Address", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{975E7334-F94A-4B45-A0EC-F1888A1063FD}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "1e893fb3503945159249ca1a33dfb0d3" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "COC_Equipment", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "CarmelID", "type": "esriFieldTypeString", "alias": "CarmelID", "length": 255, "domain": null }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 255, "domain": null }, { "name": "Subcategory", "type": "esriFieldTypeString", "alias": "Subcategory", "length": 255, "domain": null }, { "name": "UnitNumber", "type": "esriFieldTypeString", "alias": "Unit Number", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "length": 255, "domain": null }, { "name": "ModelDescription", "type": "esriFieldTypeString", "alias": "Model Description", "length": 255, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "Model Number", "length": 255, "domain": null }, { "name": "Color", "type": "esriFieldTypeString", "alias": "Color", "length": 255, "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" } }, { "name": "CWEquipDesc", "type": "esriFieldTypeString", "alias": "CW Equipment Description", "length": 255, "domain": null }, { "name": "CWEquipID", "type": "esriFieldTypeString", "alias": "CW Equipment ID", "length": 255, "domain": null }, { "name": "Plate", "type": "esriFieldTypeString", "alias": "Plate", "length": 255, "domain": null }, { "name": "Serial_VIN", "type": "esriFieldTypeString", "alias": "Serial_VIN", "length": 255, "domain": null }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "FuelType", "length": 255, "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" } }, { "name": "SCFID", "type": "esriFieldTypeString", "alias": "SCFID", "length": 255, "domain": null }, { "name": "FEMACode", "type": "esriFieldTypeString", "alias": "FEMA Code", "length": 255, "domain": null }, { "name": "FEMARate", "type": "esriFieldTypeDouble", "alias": "FEMA Rate", "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 255, "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" } }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 255, "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" } }, { "name": "MaintLocation", "type": "esriFieldTypeString", "alias": "Maintenance Location", "length": 255, "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" } }, { "name": "RelatedStructure", "type": "esriFieldTypeString", "alias": "Related Structure", "length": 255, "domain": null }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "length": 255, "domain": null }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 255, "domain": null }, { "name": "Filter", "type": "esriFieldTypeString", "alias": "Filter", "length": 255, "domain": null }, { "name": "Fluid", "type": "esriFieldTypeString", "alias": "Fluid", "length": 255, "domain": null }, { "name": "PMSchedule", "type": "esriFieldTypeString", "alias": "PM Schedule", "length": 255, "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" } }, { "name": "PMLSD", "type": "esriFieldTypeDate", "alias": "PM Last Service Date", "length": 8, "domain": null }, { "name": "Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null }, { "name": "MIleageLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced MIleage", "domain": null }, { "name": "EngineHours", "type": "esriFieldTypeDouble", "alias": "Engine Hours", "domain": null }, { "name": "EngineHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Engine Hours", "domain": null }, { "name": "AuxHours", "type": "esriFieldTypeDouble", "alias": "Auxillary Hours", "domain": null }, { "name": "AuxHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Aux Hours", "domain": null }, { "name": "EOL", "type": "esriFieldTypeDouble", "alias": "Engine Oil Life", "domain": null }, { "name": "OwnType", "type": "esriFieldTypeString", "alias": "OwnType", "length": 255, "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" } }, { "name": "LLEndDate", "type": "esriFieldTypeDate", "alias": "Lease_Loan End Date", "length": 8, "domain": null }, { "name": "DOP", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "PP", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null }, { "name": "RC", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "TargetRPLYear", "type": "esriFieldTypeInteger", "alias": "Target Replacement Year", "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "WarrantyMileage", "type": "esriFieldTypeDouble", "alias": "Warranty Mileage", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "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" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID_1", "type": "esriFieldTypeGlobalID", "alias": "GlobalID_1", "length": 38, "domain": null }, { "name": "WOID", "type": "esriFieldTypeString", "alias": "WOID", "length": 255, "domain": null }, { "name": "WOStatus", "type": "esriFieldTypeString", "alias": "WOStatus", "length": 255, "domain": null }, { "name": "PMInspectDate", "type": "esriFieldTypeDate", "alias": "PM Inspect Date", "length": 8, "domain": null }, { "name": "PMDueHrs", "type": "esriFieldTypeDouble", "alias": "PM Next Due Hours", "domain": null }, { "name": "PMDueMiles", "type": "esriFieldTypeDouble", "alias": "PM Next Due Mileage", "domain": null } ], "indexes": [ { "name": "R1115_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1115", "fields": "GlobalID_1", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "COC_Equipment", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "MaintLocation", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{975E7334-F94A-4B45-A0EC-F1888A1063FD}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1e893fb3503945159249ca1a33dfb0d3" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "COC_Vehicles", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "CarmelID", "type": "esriFieldTypeString", "alias": "CarmelID", "length": 255, "domain": null }, { "name": "UnitNumber", "type": "esriFieldTypeString", "alias": "Unit Number", "length": 255, "domain": null }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 255, "domain": null }, { "name": "Subcategory", "type": "esriFieldTypeString", "alias": "Subcategory", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "length": 255, "domain": null }, { "name": "ModelDescription", "type": "esriFieldTypeString", "alias": "Model Description", "length": 255, "domain": null }, { "name": "Color", "type": "esriFieldTypeString", "alias": "Color", "length": 255, "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" } }, { "name": "CWEquipDesc", "type": "esriFieldTypeString", "alias": "CW Equipment Description", "length": 255, "domain": null }, { "name": "CWEquipID", "type": "esriFieldTypeString", "alias": "CW Equipment ID", "length": 255, "domain": null }, { "name": "Plate", "type": "esriFieldTypeString", "alias": "Plate", "length": 255, "domain": null }, { "name": "VIN", "type": "esriFieldTypeString", "alias": "VIN", "length": 255, "domain": null }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "FuelType", "length": 255, "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" } }, { "name": "SCFID", "type": "esriFieldTypeString", "alias": "School Fuel ID", "length": 255, "domain": null }, { "name": "CKFID", "type": "esriFieldTypeString", "alias": "Circle K Fuel ID", "length": 255, "domain": null }, { "name": "MFID", "type": "esriFieldTypeString", "alias": "Meijer Fuel ID", "length": 255, "domain": null }, { "name": "EMS", "type": "esriFieldTypeString", "alias": "EMS Number", "length": 255, "domain": null }, { "name": "ShellID", "type": "esriFieldTypeString", "alias": "Shell Fuel ID", "length": 255, "domain": null }, { "name": "KNOX", "type": "esriFieldTypeString", "alias": "Knox Key", "length": 255, "domain": null }, { "name": "FEMACode", "type": "esriFieldTypeString", "alias": "FEMA Code", "length": 255, "domain": null }, { "name": "FEMARate", "type": "esriFieldTypeDouble", "alias": "FEMA Rate", "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 255, "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" } }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 255, "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" } }, { "name": "MaintLocation", "type": "esriFieldTypeString", "alias": "Maintenance Location", "length": 255, "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" } }, { "name": "RelatedStructure", "type": "esriFieldTypeString", "alias": "Related Structure", "length": 255, "domain": null }, { "name": "PoolCar", "type": "esriFieldTypeString", "alias": "Pool Car", "length": 255, "domain": { "type": "codedValue", "name": "aDomYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TakeHome", "type": "esriFieldTypeString", "alias": "TakeHome", "length": 255, "domain": { "type": "codedValue", "name": "aDomYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "length": 255, "domain": null }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 255, "domain": null }, { "name": "Filter", "type": "esriFieldTypeString", "alias": "Filter", "length": 255, "domain": null }, { "name": "Fluid", "type": "esriFieldTypeString", "alias": "Fluid", "length": 255, "domain": null }, { "name": "PMSchedule", "type": "esriFieldTypeString", "alias": "PM Schedule", "length": 255, "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" } }, { "name": "PMLSD", "type": "esriFieldTypeDate", "alias": "PM Last Service Date", "length": 8, "domain": null }, { "name": "Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null }, { "name": "MIleageLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced MIleage", "domain": null }, { "name": "EngineHours", "type": "esriFieldTypeDouble", "alias": "EngineHours", "domain": null }, { "name": "EngineHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Engine Hours", "domain": null }, { "name": "AuxHours", "type": "esriFieldTypeDouble", "alias": "Auxillary Hours", "domain": null }, { "name": "AuxHoursLS", "type": "esriFieldTypeDouble", "alias": "Last Serviced Aux Hours", "domain": null }, { "name": "EOL", "type": "esriFieldTypeDouble", "alias": "Engine Oil Life", "domain": null }, { "name": "OwnType", "type": "esriFieldTypeString", "alias": "OwnType", "length": 255, "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" } }, { "name": "LLEndDate", "type": "esriFieldTypeDate", "alias": "Lease_Loan End Date", "length": 8, "domain": null }, { "name": "DOP", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "PP", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null }, { "name": "RC", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null }, { "name": "TargetRPLYear", "type": "esriFieldTypeInteger", "alias": "Target Replacement Year", "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "WarrantyMileage", "type": "esriFieldTypeDouble", "alias": "Warranty Mileage", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "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" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID_1", "type": "esriFieldTypeGlobalID", "alias": "GlobalID_1", "length": 38, "domain": null }, { "name": "WOID", "type": "esriFieldTypeString", "alias": "WOID", "length": 255, "domain": null }, { "name": "WOStatus", "type": "esriFieldTypeString", "alias": "WOStatus", "length": 255, "domain": null }, { "name": "PMInspectDate", "type": "esriFieldTypeDate", "alias": "PM Inspect Date", "length": 8, "domain": null }, { "name": "PMDueHrs", "type": "esriFieldTypeDouble", "alias": "PM Next Due Hours", "domain": null }, { "name": "PMDueMiles", "type": "esriFieldTypeDouble", "alias": "PM Next Due Mileage", "domain": null } ], "indexes": [ { "name": "R1118_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1118", "fields": "GlobalID_1", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "COC_Vehicles", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "MaintLocation", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A38409D1-EFB4-4FD7-B043-ABBA11EBC5D5}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1e893fb3503945159249ca1a33dfb0d3" } ] }