Name: fleet_assets

Display Field: body_dealer_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 938975.782245472
YMin: 676405.375399813
XMax: 951129.71725513
YMax: 692753.766259387
Spatial Reference: 102719 (2264)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[141,163,42,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• assetid (type: esriFieldTypeString, alias: assetid, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• uid (type: esriFieldTypeInteger, alias: uid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• code (type: esriFieldTypeString, alias: code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• departmentdesc (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• munisorg (type: esriFieldTypeString, alias: munisOrg, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• assettypedesc (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• statusdesc (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• enddate (type: esriFieldTypeDate, alias: endDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• assetyear (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assetmakedesc (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• assetmodeldesc (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• assetclassdesc (type: esriFieldTypeString, alias: Class, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• assetcolordesc (type: esriFieldTypeString, alias: Color, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• titlenumber (type: esriFieldTypeString, alias: Title No, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• serialnumber (type: esriFieldTypeString, alias: Serial No, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• fueltypedesc (type: esriFieldTypeString, alias: Fuel Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fuelcapacity (type: esriFieldTypeInteger, alias: Fuel Capacity Gallons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oiltype (type: esriFieldTypeString, alias: Oil Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• oilcapacity (type: esriFieldTypeString, alias: Oil Capacity Quarts, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• servicevendoruid (type: esriFieldTypeString, alias: Service Vendor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• purchordnum (type: esriFieldTypeInteger, alias: PO Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• po_date (type: esriFieldTypeDate, alias: PO Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• poinvoicenum (type: esriFieldTypeString, alias: PO Invoice Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• pocost (type: esriFieldTypeDouble, alias: PO Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• residualcost (type: esriFieldTypeInteger, alias: Residual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lifeexpectancy (type: esriFieldTypeInteger, alias: Life Expectancy, SQL Type: sqlTypeOther, nullable: true, editable: true)
• postdate (type: esriFieldTypeDate, alias: postDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• rempostdate (type: esriFieldTypeDate, alias: remPostDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• attachmentscount (type: esriFieldTypeInteger, alias: attachmentsCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imagescount (type: esriFieldTypeInteger, alias: imagesCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• linkscount (type: esriFieldTypeInteger, alias: linksCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notescount (type: esriFieldTypeInteger, alias: notesCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• enginedesc (type: esriFieldTypeString, alias: Engine, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• enginehorsepower (type: esriFieldTypeInteger, alias: Horsepower, SQL Type: sqlTypeOther, nullable: true, editable: true)
• enginecylinders (type: esriFieldTypeInteger, alias: Cylinders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• enginemanufacturer (type: esriFieldTypeString, alias: Eng Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• transmissiondesc (type: esriFieldTypeString, alias: Transmission, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• drivetraindesc (type: esriFieldTypeString, alias: Drive Train, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• metertypedesc (type: esriFieldTypeString, alias: meterTypeDesc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• wometerrequired (type: esriFieldTypeString, alias: woMeterRequired, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fuelissuemeterrequired (type: esriFieldTypeString, alias: fuelIssueMeterRequired, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• meterexpectancy (type: esriFieldTypeString, alias: meterExpectancy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• licenseprimary (type: esriFieldTypeString, alias: License Primary, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• licpriissuedate (type: esriFieldTypeString, alias: Lic Prim Issue Date, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• licenseconfidential (type: esriFieldTypeString, alias: License Confidential, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• licconfissuedate (type: esriFieldTypeString, alias: Lic Conf Issue Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• license3 (type: esriFieldTypeString, alias: License 3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• licissuedate (type: esriFieldTypeDate, alias: Lic 3 Issue Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inservicedate (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inservicemileage (type: esriFieldTypeInteger, alias: In Service Mileage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gvw (type: esriFieldTypeInteger, alias: GVW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• epampg (type: esriFieldTypeInteger, alias: EPA MPG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• airconditioning (type: esriFieldTypeString, alias: Air Conditioning, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• cruisecontrol (type: esriFieldTypeString, alias: Cruise Control, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• keylocation (type: esriFieldTypeString, alias: Key Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• keycode1 (type: esriFieldTypeString, alias: Key Code 1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• keycode2 (type: esriFieldTypeString, alias: Key Code 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• offroadpercent (type: esriFieldTypeString, alias: Off Road Percent, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• odometer (type: esriFieldTypeString, alias: Odometer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• hubometer (type: esriFieldTypeString, alias: Hub meter, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• hourmeter (type: esriFieldTypeString, alias: Hourmeter, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• sparetire (type: esriFieldTypeString, alias: Tire Spare, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• edit_date (type: esriFieldTypeDate, alias: edit_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• edit_by (type: esriFieldTypeString, alias: edit_by, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• body_num (type: esriFieldTypeString, alias: Body Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• body_dealer_name (type: esriFieldTypeString, alias: Body Dealer Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• body_contact_num (type: esriFieldTypeString, alias: Body Contact Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• service_class (type: esriFieldTypeString, alias: Service Class, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• pm_threshold (type: esriFieldTypeString, alias: PM Threshold, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• tuneup_threshold (type: esriFieldTypeString, alias: Tune Up Threshold, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• attachments (type: esriFieldTypeString, alias: attachments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• trans_svc_threshold (type: esriFieldTypeString, alias: Trans Service Threshold, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fl_rollingstocktype (type: esriFieldTypeString, alias: fl_rollingstocktype, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• currentreading (type: esriFieldTypeString, alias: CurrentReading, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• tirefront (type: esriFieldTypeString, alias: Tire Front, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• tirerear (type: esriFieldTypeString, alias: Tire Rear, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• propertycontrol (type: esriFieldTypeString, alias: Property Control, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• insurance_category (type: esriFieldTypeString, alias: Insurance Category, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• avl_imei (type: esriFieldTypeString, alias: AVL IMEI, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• avl_device_model (type: esriFieldTypeString, alias: AVL Device Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• avl_add_input (type: esriFieldTypeString, alias: AVL Additional Sensor(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: fleet_assets
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/19/2024 4:46:47 PM

Schema Last Edit Date: 2/19/2024 4:46:47 PM

Data Last Edit Date: 2/19/2024 4:46:47 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat