Name: fleet_equipment
Display Field: EMPLOYEE_NAME
Type: Table
Geometry Type: N/A
Description:
Definition Expression: N/A
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
, editable: false
, nullable: false
)
-
YEAR
(
type: esriFieldTypeSmallInteger
, alias: YEAR
, editable: true
, nullable: true
)
-
MANUFACTURER
(
type: esriFieldTypeString
, alias: Manufacturer
, editable: true
, nullable: true
, length: 1073741822
, Coded Values:
[400HP: 400HP]
, [AALAD: AALAD]
, [ALTO: ALTO]
, ...157 more...
)
-
MODEL
(
type: esriFieldTypeString
, alias: Model
, editable: true
, nullable: true
, length: 1073741822
, Coded Values:
[28: 28]
, [60: 60]
, [320: 320]
, ...303 more...
)
-
LOCATION
(
type: esriFieldTypeString
, alias: OPERATED BY
, editable: true
, nullable: true
, length: 1073741822
, Coded Values:
[BEACH MAINTENANCE: BEACH MAINTENANCE]
, [BUILDING DEPARTMENT: BUILDING DEPARTMENT]
, [CODE ENFORCEMENT: CODE ENFORCEMENT]
, ...30 more...
)
-
ODOMETER
(
type: esriFieldTypeInteger
, alias: ODOMETER
, editable: true
, nullable: true
)
-
ODOMETERDATE
(
type: esriFieldTypeDate
, alias: ODOMETERDATE
, editable: true
, nullable: true
, length: 8
)
-
LICENSETAG
(
type: esriFieldTypeString
, alias: PERMANENT TAG
, editable: true
, nullable: true
, length: 1073741822
)
-
SERIALNUMBER
(
type: esriFieldTypeString
, alias: SerialNumber
, editable: true
, nullable: true
, length: 1073741822
)
-
DESCRIPTION
(
type: esriFieldTypeString
, alias: Description
, editable: true
, nullable: true
, length: 1073741822
)
-
ASSETCATEGORY
(
type: esriFieldTypeString
, alias: ASSETCATEGORY
, editable: true
, nullable: true
, length: 1073741822
, Coded Values:
[AERIAL TRUCKS: AERIAL TRUCKS]
, [ATV CORROSIVE: ATV CORROSIVE]
, [ATVS: ATVS]
, ...16 more...
)
-
NOTES
(
type: esriFieldTypeString
, alias: Notes
, editable: true
, nullable: true
, length: 1073741822
)
-
TITLENUMBER
(
type: esriFieldTypeString
, alias: TitleNumber
, editable: true
, nullable: true
, length: 1073741822
)
-
OWNEDBY
(
type: esriFieldTypeString
, alias: OWNEDBY
, editable: true
, nullable: true
, length: 1073741822
, Coded Values:
[BEACH MAINTENANCE: BEACH MAINTENANCE]
, [BUILDING DEPARTMENT: BUILDING DEPARTMENT]
, [CODE ENFORCEMENT: CODE ENFORCEMENT]
, ...30 more...
)
-
PMSCHEDULE
(
type: esriFieldTypeString
, alias: PMSCHEDULE
, editable: true
, nullable: true
, length: 1073741822
, Coded Values:
[AERIAL INSPECTIONS: AERIAL INSPECTIONS]
, [BATTERY CHECK 6 MONTHS: BATTERY CHECK 6 MONTHS]
, [CHECK FUEL 1 MONTH: CHECK FUEL 1 MONTH]
, ...8 more...
)
-
PUCHASECOST
(
type: esriFieldTypeDouble
, alias: PUCHASECOST
, editable: true
, nullable: true
)
-
PURCHASEDATE
(
type: esriFieldTypeDate
, alias: PURCHASEDATE
, editable: true
, nullable: true
, length: 8
)
-
ASSETSOLDDATE
(
type: esriFieldTypeDate
, alias: ASSETSOLDDATE
, editable: true
, nullable: true
, length: 8
)
-
LIFEEXPECTANCY
(
type: esriFieldTypeInteger
, alias: LIFEEXPECTANCY
, editable: true
, nullable: true
)
-
INSERVICEDATE
(
type: esriFieldTypeDate
, alias: InServiceDate
, editable: true
, nullable: true
, length: 8
)
-
FUELTYPE
(
type: esriFieldTypeString
, alias: FUELTYPE
, editable: true
, nullable: true
, length: 1073741822
)
-
UNIT_ID
(
type: esriFieldTypeInteger
, alias: UNIT_ID
, editable: true
, nullable: true
)
-
POLICE_STATUS
(
type: esriFieldTypeString
, alias: P.D. STATUS
, editable: true
, nullable: true
, length: 255
, Coded Values:
[Assigned: Assigned]
, [To Be Assigned: To Be Assigned]
)
-
EMPLOYEE_NAME
(
type: esriFieldTypeString
, alias: P.D. OFFICER NAME
, editable: true
, nullable: true
, length: 255
)
-
EMPLOYEE_EMAIL
(
type: esriFieldTypeString
, alias: P.D. OFFICER EMAIL
, editable: true
, nullable: true
, length: 255
)
-
EMPLOYEE_PHONE
(
type: esriFieldTypeString
, alias: P.D. OFFICER PHONE
, editable: true
, nullable: true
, length: 255
)
-
BADGE_NUMBER
(
type: esriFieldTypeSmallInteger
, alias: P.D. OFFICER BADGE NUMBER
, editable: true
, nullable: true
)
-
POLICE_UNIT_ASSIGNMENT
(
type: esriFieldTypeString
, alias: P.D. UNIT ASSIGNMENT
, editable: true
, nullable: true
, length: 255
, Coded Values:
[Assigned: Assigned]
, [To Be Assigned: To Be Assigned]
)
-
DISPLAYLICENSETAG
(
type: esriFieldTypeString
, alias: P.D. DISPLAY TAG
, editable: true
, nullable: true
, length: 255
)
-
POOLVEHICLE
(
type: esriFieldTypeString
, alias: P.D. POOL VEHICLE
, editable: true
, nullable: true
, length: 255
, Coded Values:
[Y: Yes]
, [N: No]
)
-
CONFIDENTIAL
(
type: esriFieldTypeString
, alias: P.D. CONFIDENTIAL
, editable: true
, nullable: true
, length: 255
, Coded Values:
[Y: Yes]
, [N: No]
)
-
ACCT___USED_FOR_PURCHASE
(
type: esriFieldTypeString
, alias: ACCT # USED FOR PURCHASE
, editable: true
, nullable: true
, length: 255
)
-
AIR_FILTER
(
type: esriFieldTypeString
, alias: AIR FILTER
, editable: true
, nullable: true
, length: 500
)
-
BATTERY
(
type: esriFieldTypeString
, alias: BATTERY
, editable: true
, nullable: true
, length: 500
)
-
CABIN_FILTER
(
type: esriFieldTypeString
, alias: CABIN FILTER
, editable: true
, nullable: true
, length: 500
)
-
CONFISCATED
(
type: esriFieldTypeString
, alias: CONFISCATED
, editable: true
, nullable: true
, length: 500
)
-
CYLINDERS
(
type: esriFieldTypeString
, alias: CYLINDERS
, editable: true
, nullable: true
, length: 500
)
-
DEALER
(
type: esriFieldTypeString
, alias: DEALER
, editable: true
, nullable: true
, length: 500
, Coded Values:
[A & A PARTS & CARTS, LLC: A & A PARTS & CARTS, LLC]
, [A&A PARTS & CARTS, LLC: A&A PARTS & CARTS, LLC]
, [ABL: ABL]
, ...202 more...
)
-
ENGINE_SERIAL_NUMBER
(
type: esriFieldTypeString
, alias: ENGINE SERIAL NUMBER
, editable: true
, nullable: true
, length: 500
)
-
ENGINE_SIZE
(
type: esriFieldTypeString
, alias: ENGINE SIZE
, editable: true
, nullable: true
, length: 500
)
-
ENGINE_SPEC
(
type: esriFieldTypeString
, alias: ENGINE SPEC
, editable: true
, nullable: true
, length: 500
)
-
EXTENDED_WARRANTY
(
type: esriFieldTypeString
, alias: EXTENDED WARRANTY
, editable: true
, nullable: true
, length: 500
)
-
FILTER___AIR
(
type: esriFieldTypeString
, alias: FILTER - AIR
, editable: true
, nullable: true
, length: 500
)
-
FILTER___CABIN
(
type: esriFieldTypeString
, alias: FILTER - CABIN
, editable: true
, nullable: true
, length: 500
)
-
FILTER___FUEL
(
type: esriFieldTypeString
, alias: FILTER - FUEL
, editable: true
, nullable: true
, length: 500
)
-
FILTER___OIL
(
type: esriFieldTypeString
, alias: FILTER - OIL
, editable: true
, nullable: true
, length: 500
)
-
GVW
(
type: esriFieldTypeString
, alias: GVW
, editable: true
, nullable: true
, length: 500
)
-
GVWR
(
type: esriFieldTypeString
, alias: GVWR
, editable: true
, nullable: true
, length: 500
)
-
HIGH_PRIORITY
(
type: esriFieldTypeString
, alias: HIGH PRIORITY
, editable: true
, nullable: true
, length: 500
)
-
HP
(
type: esriFieldTypeString
, alias: HP
, editable: true
, nullable: true
, length: 500
)
-
OIL_CAPACITY
(
type: esriFieldTypeString
, alias: OIL CAPACITY
, editable: true
, nullable: true
, length: 500
)
-
OIL_FILTER
(
type: esriFieldTypeString
, alias: OIL FILTER
, editable: true
, nullable: true
, length: 500
)
-
OIL_GRADE
(
type: esriFieldTypeString
, alias: OIL GRADE
, editable: true
, nullable: true
, length: 500
)
-
PURCH_ORDER
(
type: esriFieldTypeString
, alias: PURCH ORDER
, editable: true
, nullable: true
, length: 500
)
-
TAKE_HOME
(
type: esriFieldTypeString
, alias: TAKE HOME
, editable: true
, nullable: true
, length: 500
)
-
TIRE_SIZE
(
type: esriFieldTypeString
, alias: TIRE SIZE
, editable: true
, nullable: true
, length: 500
)
-
UNIT_AVAIL_NOTIFY
(
type: esriFieldTypeString
, alias: UNIT AVAIL NOTIFY
, editable: true
, nullable: true
, length: 500
)
-
WIPER_BLADE_DRIVER_S
(
type: esriFieldTypeString
, alias: WIPER BLADE DRIVER'S
, editable: true
, nullable: true
, length: 500
)
-
WIPER_BLADE_PASSENGER
(
type: esriFieldTypeString
, alias: WIPER BLADE PASSENGER
, editable: true
, nullable: true
, length: 500
)
-
WIPER_BLADE_REAR_WINDOW
(
type: esriFieldTypeString
, alias: WIPER BLADE REAR WINDOW
, editable: true
, nullable: true
, length: 500
)
-
ASSETNUMBER
(
type: esriFieldTypeString
, alias: AssetNumber
, editable: true
, nullable: true
, length: 50
)
-
VEHICLENUMBER
(
type: esriFieldTypeString
, alias: VEHICLE NUMBER
, editable: true
, nullable: true
, length: 50
)
-
ADDRESS
(
type: esriFieldTypeString
, alias: STATUS
, editable: true
, nullable: true
, length: 50
, Coded Values:
[Active Unit: Active Unit]
, [Disposed unit: Disposed unit]
, [Ready unit for service: Ready unit for service]
)
Templates:
-
Name: fleet_equipment
Description:
Prototype:
VEHICLENUMBER: null
ADDRESS: null
YEAR: null
MANUFACTURER: null
MODEL: null
LOCATION: null
ODOMETER: null
ODOMETERDATE: null
LICENSETAG: null
SERIALNUMBER: null
DESCRIPTION: null
ASSETCATEGORY: null
NOTES: null
TITLENUMBER: null
OWNEDBY: null
PMSCHEDULE: null
PUCHASECOST: null
PURCHASEDATE: null
ASSETSOLDDATE: null
LIFEEXPECTANCY: null
INSERVICEDATE: null
FUELTYPE: null
UNIT_ID: null
POLICE_STATUS: null
EMPLOYEE_NAME: null
EMPLOYEE_EMAIL: null
EMPLOYEE_PHONE: null
BADGE_NUMBER: null
POLICE_UNIT_ASSIGNMENT: null
DISPLAYLICENSETAG: null
POOLVEHICLE: null
CONFIDENTIAL: null
ACCT___USED_FOR_PURCHASE: null
AIR_FILTER: null
BATTERY: null
CABIN_FILTER: null
CONFISCATED: null
CYLINDERS: null
DEALER: null
ENGINE_SERIAL_NUMBER: null
ENGINE_SIZE: null
ENGINE_SPEC: null
EXTENDED_WARRANTY: null
FILTER___AIR: null
FILTER___CABIN: null
FILTER___FUEL: null
FILTER___OIL: null
GVW: null
GVWR: null
HIGH_PRIORITY: null
HP: null
OIL_CAPACITY: null
OIL_FILTER: null
OIL_GRADE: null
PURCH_ORDER: null
TAKE_HOME: null
TIRE_SIZE: null
UNIT_AVAIL_NOTIFY: null
WIPER_BLADE_DRIVER_S: null
WIPER_BLADE_PASSENGER: null
WIPER_BLADE_REAR_WINDOW: null
ASSETNUMBER: null
Drawing Tool: esriFeatureEditToolNone
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Supports Query With Historic Moment: false
Supports Coordinates Quantization: false
Supported Operations:
Query
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata