{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 74, "name": "GIS.GISADMIN.finFLEET", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DEPTNAME", "typeIdField": "SUBTYPE", "subtypeFieldName": "SUBTYPE", "subtypeField": "SUBTYPE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EQUIPFUNCTION", "type": "esriFieldTypeString", "alias": "Equipment Function", "length": 250, "domain": null }, { "name": "REPLACEYR", "type": "esriFieldTypeString", "alias": "Replacement Year", "length": 4, "domain": null }, { "name": "SOLDTRADEVALUE", "type": "esriFieldTypeDouble", "alias": "SOLDTRADEVALUE", "domain": null }, { "name": "FLEETID", "type": "esriFieldTypeString", "alias": "FLEETID", "length": 20, "domain": null }, { "name": "VIN", "type": "esriFieldTypeString", "alias": "VIN", "length": 20, "domain": null }, { "name": "FUND", "type": "esriFieldTypeString", "alias": "FUND", "length": 3, "domain": { "type": "codedValue", "name": "d_finFUND", "description": "", "codedValues": [ { "name": "101", "code": "101" }, { "name": "202", "code": "202" }, { "name": "203", "code": "203" }, { "name": "213", "code": "213" }, { "name": "222", "code": "222" }, { "name": "603", "code": "603" }, { "name": "604", "code": "604" }, { "name": "605", "code": "605" }, { "name": "606", "code": "606" }, { "name": "615", "code": "615" }, { "name": "623", "code": "623" }, { "name": "707", "code": "707" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DEPTNO", "type": "esriFieldTypeString", "alias": "DEPTNO", "length": 4, "domain": { "type": "codedValue", "name": "d_finDeptNoOnly", "description": "", "codedValues": [ { "name": "1000", "code": "1000" }, { "name": "1100", "code": "1100" }, { "name": "2110", "code": "2110" }, { "name": "2113", "code": "2113" }, { "name": "2130", "code": "2130" }, { "name": "3100", "code": "3100" }, { "name": "3200", "code": "3200" }, { "name": "4000", "code": "4000" }, { "name": "5000", "code": "5000" }, { "name": "5500", "code": "5500" }, { "name": "6210", "code": "6210" }, { "name": "6230", "code": "6230" }, { "name": "6300", "code": "6300" }, { "name": "6410", "code": "6410" }, { "name": "6420", "code": "6420" }, { "name": "6430", "code": "6430" }, { "name": "6441", "code": "6441" }, { "name": "6445", "code": "6445" }, { "name": "6510", "code": "6510" }, { "name": "6521", "code": "6521" }, { "name": "6522", "code": "6522" }, { "name": "6621", "code": "6621" }, { "name": "6622", "code": "6622" }, { "name": "6710", "code": "6710" }, { "name": "6720", "code": "6720" }, { "name": "7100", "code": "7100" }, { "name": "8200", "code": "8200" }, { "name": "8300", "code": "8300" }, { "name": "8120", "code": "8120" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCT", "type": "esriFieldTypeString", "alias": "ACCT", "length": 20, "domain": null }, { "name": "DEPTNAME", "type": "esriFieldTypeString", "alias": "DEPTNAME", "length": 30, "domain": { "type": "codedValue", "name": "d_DeptNoTxt", "description": "Finance Dept Nos", "codedValues": [ { "name": "Planning", "code": "1000" }, { "name": "Legislation", "code": "1100" }, { "name": "Manager Administration", "code": "2110" }, { "name": "Economic Development", "code": "2113" }, { "name": "Service", "code": "2130" }, { "name": "Finance", "code": "3100" }, { "name": "Tax", "code": "3200" }, { "name": "Law", "code": "4000" }, { "name": "Municipal Court", "code": "5000" }, { "name": "Probation", "code": "5500" }, { "name": "Parks", "code": "6210" }, { "name": "Cemetery", "code": "6230" }, { "name": "Street", "code": "6300" }, { "name": "Electric Administration", "code": "6410" }, { "name": "Electric Meter Reading", "code": "6420" }, { "name": "Electric Operations", "code": "6430" }, { "name": "Electric Production", "code": "6441" }, { "name": "Telecommunication", "code": "6445" }, { "name": "Water Administration", "code": "6510" }, { "name": "Water System Maintenance", "code": "6521" }, { "name": "Water Treatment", "code": "6522" }, { "name": "Auto Maintenance", "code": "6710" }, { "name": "Construction & Maintenance", "code": "6720" }, { "name": "Engineering", "code": "7100" }, { "name": "Police Department", "code": "8200" }, { "name": "Information Technology", "code": "8300" }, { "name": "Sewer System Maintenance", "code": "6622" }, { "name": "Wastewater System Maintenance", "code": "6621" }, { "name": "Fire Department", "code": "8120" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 50, "domain": null }, { "name": "MODYR", "type": "esriFieldTypeString", "alias": "MODYR", "length": 4, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "MAKE", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": null }, { "name": "COND", "type": "esriFieldTypeString", "alias": "COND", "length": 10, "domain": { "type": "codedValue", "name": "d_AutoCondition", "description": "Automobile Condition", "codedValues": [ { "name": "Good", "code": "GOOD" }, { "name": "New", "code": "NEW" }, { "name": "Ok", "code": "OK" }, { "name": "Poor", "code": "POOR" }, { "name": "Sold", "code": "SOLD" }, { "name": "Traded", "code": "TRADED" }, { "name": "Donated", "code": "DONATED" }, { "name": "Auctioned", "code": "AUCTIONED" }, { "name": "Transferred", "code": "TRANSFERRED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MILEAGE", "type": "esriFieldTypeString", "alias": "MILEAGE", "length": 10, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 250, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "SUBTYPE", "type": "esriFieldTypeInteger", "alias": "SUBTYPE", "domain": null }, { "name": "SOLDTRADEDATE", "type": "esriFieldTypeDate", "alias": "SOLDTRADEDATE", "length": 8, "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "DUPKEY", "type": "esriFieldTypeString", "alias": "DUPKEY", "length": 50, "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACQDATE", "type": "esriFieldTypeDate", "alias": "ACQDATE", "length": 8, "domain": null }, { "name": "RETDATE", "type": "esriFieldTypeDate", "alias": "RETDATE", "length": 8, "domain": null }, { "name": "FUELCARD", "type": "esriFieldTypeString", "alias": "FUELCARD", "length": 5, "domain": null }, { "name": "FUELTYPE", "type": "esriFieldTypeString", "alias": "FUELTYPE", "length": 5, "domain": { "type": "codedValue", "name": "d_finFuelType", "description": "", "codedValues": [ { "name": "Gas", "code": "G" }, { "name": "Diesel", "code": "D" }, { "name": "Both", "code": "B" }, { "name": "None", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSURED", "type": "esriFieldTypeString", "alias": "INSURED", "length": 5, "domain": { "type": "codedValue", "name": "Yes or No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LPLATE", "type": "esriFieldTypeString", "alias": "LPLATE", "length": 10, "domain": null }, { "name": "PURCHPRICE", "type": "esriFieldTypeDouble", "alias": "PURCHPRICE", "domain": null }, { "name": "FEMACODE", "type": "esriFieldTypeSmallInteger", "alias": "Fema Code", "domain": null }, { "name": "FEMACOST", "type": "esriFieldTypeDouble", "alias": "Fema Cost", "domain": null }, { "name": "UNITCOST", "type": "esriFieldTypeDouble", "alias": "Unit City Cost", "domain": null }, { "name": "HOURS", "type": "esriFieldTypeString", "alias": "HOURS", "length": 10, "domain": null } ], "indexes": [ { "name": "R14881_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_14881", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_20524_REL_GL", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_14881", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "id": 1, "name": "Dump Truck" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "id": 2, "name": "Equipment" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "id": 3, "name": "Fire" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "id": 4, "name": "Passenger" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "id": 5, "name": "Rescue/Ambulance" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "id": 6, "name": "Trucks/Vans" } ], "subtypes": [ { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "defaultValues": { "FLEETID": null, "VIN": null, "FUND": null, "DEPTNO": null, "ACCT": null, "DEPTNAME": null, "LOCATION": null, "MODYR": null, "MAKE": null, "MODEL": null, "COND": null, "MILEAGE": null, "COMMENTS": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SUBTYPE": null, "EQUIPFUNCTION": null, "REPLACEYR": null, "SOLDTRADEVALUE": null, "SOLDTRADEDATE": null, "REL_GLOBALID": null, "DUPKEY": "No", "ACQDATE": null, "RETDATE": null, "FUELCARD": "0000", "FUELTYPE": "D", "INSURED": "No", "LPLATE": null, "PURCHPRICE": null, "FEMACODE": null, "FEMACOST": null, "UNITCOST": null, "HOURS": null }, "code": 1, "name": "Dump Truck" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "defaultValues": { "FLEETID": null, "VIN": null, "FUND": null, "DEPTNO": null, "ACCT": null, "DEPTNAME": null, "LOCATION": null, "MODYR": null, "MAKE": null, "MODEL": null, "COND": null, "MILEAGE": null, "COMMENTS": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SUBTYPE": null, "EQUIPFUNCTION": null, "REPLACEYR": null, "SOLDTRADEVALUE": null, "SOLDTRADEDATE": null, "REL_GLOBALID": null, "DUPKEY": "No", "ACQDATE": null, "RETDATE": null, "FUELCARD": "0000", "FUELTYPE": "N", "INSURED": "No", "LPLATE": null, "PURCHPRICE": null, "FEMACODE": null, "FEMACOST": null, "UNITCOST": null, "HOURS": null }, "code": 2, "name": "Equipment" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "defaultValues": { "FLEETID": null, "VIN": null, "FUND": "213", "DEPTNO": "8120", "ACCT": "213-8120", "DEPTNAME": "8120", "LOCATION": null, "MODYR": null, "MAKE": null, "MODEL": null, "COND": null, "MILEAGE": null, "COMMENTS": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SUBTYPE": null, "EQUIPFUNCTION": null, "REPLACEYR": null, "SOLDTRADEVALUE": null, "SOLDTRADEDATE": null, "REL_GLOBALID": null, "DUPKEY": "No", "ACQDATE": null, "RETDATE": null, "FUELCARD": "0000", "FUELTYPE": "N", "INSURED": "No", "LPLATE": null, "PURCHPRICE": null, "FEMACODE": null, "FEMACOST": null, "UNITCOST": null, "HOURS": null }, "code": 3, "name": "Fire" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "defaultValues": { "FLEETID": null, "VIN": null, "FUND": null, "DEPTNO": null, "ACCT": null, "DEPTNAME": null, "LOCATION": null, "MODYR": null, "MAKE": null, "MODEL": null, "COND": null, "MILEAGE": null, "COMMENTS": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SUBTYPE": null, "EQUIPFUNCTION": null, "REPLACEYR": null, "SOLDTRADEVALUE": null, "SOLDTRADEDATE": null, "REL_GLOBALID": null, "DUPKEY": "No", "ACQDATE": null, "RETDATE": null, "FUELCARD": "0000", "FUELTYPE": "G", "INSURED": "No", "LPLATE": null, "PURCHPRICE": null, "FEMACODE": null, "FEMACOST": null, "UNITCOST": null, "HOURS": null }, "code": 4, "name": "Passenger" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "defaultValues": { "FLEETID": null, "VIN": null, "FUND": "213", "DEPTNO": "8120", "ACCT": "213-8120", "DEPTNAME": "8120", "LOCATION": null, "MODYR": null, "MAKE": null, "MODEL": null, "COND": null, "MILEAGE": null, "COMMENTS": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SUBTYPE": null, "EQUIPFUNCTION": null, "REPLACEYR": null, "SOLDTRADEVALUE": null, "SOLDTRADEDATE": null, "REL_GLOBALID": null, "DUPKEY": "No", "ACQDATE": null, "RETDATE": null, "FUELCARD": "0000", "FUELTYPE": "N", "INSURED": "No", "LPLATE": null, "PURCHPRICE": null, "FEMACODE": null, "FEMACOST": null, "UNITCOST": null, "HOURS": null }, "code": 5, "name": "Rescue/Ambulance" }, { "domains": { "FUND": {"type": "inherited"}, "DEPTNO": {"type": "inherited"}, "DEPTNAME": {"type": "inherited"}, "COND": {"type": "inherited"}, "DUPKEY": {"type": "inherited"}, "FUELTYPE": {"type": "inherited"}, "INSURED": {"type": "inherited"} }, "defaultValues": { "FLEETID": null, "VIN": null, "FUND": null, "DEPTNO": null, "ACCT": null, "DEPTNAME": null, "LOCATION": null, "MODYR": null, "MAKE": null, "MODEL": null, "COND": null, "MILEAGE": null, "COMMENTS": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "SUBTYPE": null, "EQUIPFUNCTION": null, "REPLACEYR": null, "SOLDTRADEVALUE": null, "SOLDTRADEDATE": null, "REL_GLOBALID": null, "DUPKEY": "No", "ACQDATE": null, "RETDATE": null, "FUELCARD": "0000", "FUELTYPE": "N", "INSURED": "No", "LPLATE": null, "PURCHPRICE": null, "FEMACODE": null, "FEMACOST": null, "UNITCOST": null, "HOURS": null }, "code": 6, "name": "Trucks/Vans" } ], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }