Name: RollingStock

Display Field: ASSETNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 4e92b9041e6848ea8a331939f063cf03

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• LEGACYID ( type: esriFieldTypeString, alias: Legacy ID, length: 50 )
• ASSETNAME ( type: esriFieldTypeString, alias: Asset Name, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: Location Description, length: 255 )
• CONSEQUENCEOFFAILURE ( type: esriFieldTypeDouble, alias: Consequence of Failure )
• LIKELIHOODOFFAILURE ( type: esriFieldTypeDouble, alias: Likelihood of Failure )
• CRITICALITY ( type: esriFieldTypeDouble, alias: Criticality )
• CRITICALITYDATE ( type: esriFieldTypeDate, alias: Criticality Date, length: 8 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• PURCHASEPRICE ( type: esriFieldTypeInteger, alias: Purchase Price )
• PURCHASEDATE ( type: esriFieldTypeDate, alias: Purchase Date, length: 8 )
• CURRENTCONDITIONRATING ( type: esriFieldTypeSmallInteger, alias: Current Condition Rating )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• LASTINSPECTIONDATE ( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
• LIFEEXPECTANCY ( type: esriFieldTypeSmallInteger, alias: Life Expectancy )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 50 )
• REPLACEMENTCOST ( type: esriFieldTypeInteger, alias: Replacement Cost )
• REMAININGUSEFULLIFE ( type: esriFieldTypeInteger, alias: Remaining Useful Life )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• OWNEDBY ( type: esriFieldTypeString, alias: Owned By, length: 50 )
• MAINTAINEDBY ( type: esriFieldTypeString, alias: Maintained By, length: 50 )
• MAINTAINEDENTITY ( type: esriFieldTypeString, alias: Maintained Entity, length: 50 )
• CONTACT_URL ( type: esriFieldTypeString, alias: Contact Website URL, length: 255 )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: Contact Email Address, length: 255 )
• CONTACT_NAME ( type: esriFieldTypeString, alias: Contact Name, length: 50 )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: Contact Phone Number, length: 20 )
• CONTACT_EXTENSION ( type: esriFieldTypeString, alias: Contact Phone Extension, length: 10 )
• DATACOLLECTIONMETHOD ( type: esriFieldTypeString, alias: Data Collection Method, length: 50 )
• SOURCE_NAME ( type: esriFieldTypeString, alias: Source File Name, length: 255 )
• SOURCE_PATH ( type: esriFieldTypeString, alias: Source File Location, length: 255 )
• SOURCE_TYPE ( type: esriFieldTypeString, alias: Source File Type, length: 50 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 50 )
• COUNTRY ( type: esriFieldTypeString, alias: Country, length: 50 )
• PROVINCE ( type: esriFieldTypeString, alias: Province, length: 50 )
• POSTAL_CODE ( type: esriFieldTypeString, alias: Postal Code, length: 20 )
• UNIT ( type: esriFieldTypeString, alias: Address Unit/Suite, length: 20 )
• ATTACHMENT ( type: esriFieldTypeString, alias: Attachment URL, length: 50 )
• GLOBAL_ID ( type: esriFieldTypeGUID, alias: Global ID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Edited User, length: 50 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• SITENAME ( type: esriFieldTypeString, alias: Site Name, length: 255 )
• SYSTEMNAME ( type: esriFieldTypeString, alias: System Name, length: 100 , Coded Values: [01: 01 Potable Water Source of Supply] , [02: 02 Sewer Collection] , [03: 03 Potable Water Treatment] , ...14 more... )
• SUBSYSTEMNAME ( type: esriFieldTypeString, alias: Subsystem Name, length: 100 , Coded Values: [01.01: 01.01 Potable Interconnect] , [01.02: 01.02 Ground Water Production] , [02.01: 02.01 Sewer Interconnect] , ...68 more... )
• ROLLINGSTOCK_ID ( type: esriFieldTypeString, alias: Rolling Stock ID, length: 50 )
• UNITDESC ( type: esriFieldTypeString, alias: Unit Description, length: 50 )
• TITLENO ( type: esriFieldTypeString, alias: Title Number, length: 50 )
• VEHUSERCLASSCODE ( type: esriFieldTypeString, alias: Vehicle User Class Code, length: 50 , Coded Values: [10: SUBCOMPACT AUTOMOBILE] , [15: INTERMEDIATE AUTOMOBILE] , [20: FULL SIZE AUTOMOBILE] , ...114 more... )
• GENUSERCLASSCODE ( type: esriFieldTypeString, alias: General User Class Code, length: 50 , Coded Values: [MyCodedValue: MyCodeName] )
• CATCLASSCODE ( type: esriFieldTypeString, alias: Category Class Code, length: 50 , Coded Values: [CA: CAR] , [DE: DEPARTMENT] , [GN: GENERATORS/MOBILE] , ...10 more... )
• TANK ( type: esriFieldTypeString, alias: Tank?, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• FUELTYPECLASSCODE ( type: esriFieldTypeString, alias: Fuel Type Class Code, length: 50 , Coded Values: [AVF: AVIATION FUEL] , [BIO: BIO-DIESEL] , [E85: 85% ETHANOL] , ...5 more... )
• WEIGHTCLASSCODE ( type: esriFieldTypeString, alias: Weight Class Clode, length: 50 , Coded Values: [CL1: 8,500 OR LESS GVW] , [CL2: 8,501 TO 10,000 GVW] , [CL3: 10,001 TO 14,000 GVW] , ...10 more... )
• BODYTYPECLASSCODE ( type: esriFieldTypeString, alias: Body Type Class Code, length: 50 , Coded Values: [AB: ANIMAL BODY] , [AD: AERIAL DEVICE] , [CB: CRANE BODY] , ...27 more... )
• FEMACLASSCODE1 ( type: esriFieldTypeString, alias: FEMA Class Code 1, length: 50 )
• FEMACLASSCODE2 ( type: esriFieldTypeString, alias: FEMA Class Code 2, length: 50 )
• FEMACLASSCODE3 ( type: esriFieldTypeString, alias: FEMA Class Code 3, length: 50 )
• FEMACLASSCODE4 ( type: esriFieldTypeString, alias: FEMA Class Code 4, length: 50 )
• MAINTCLASSCODE ( type: esriFieldTypeString, alias: Maintenance Class Code, length: 50 , Coded Values: [QUARTERLY: Quarterly] , [ANNUALLY: Annually] , [SEMIANNUALLY: Semi-Annually] , ...1 more... )
• MAINTLOCCODE ( type: esriFieldTypeString, alias: Maintenance Location Code, length: 50 , Coded Values: [142: 142nd Sub Shop] , [19: US 19 Sub Shop] , [46: 46th Street Sub Shop] , ...4 more... )
• GPS ( type: esriFieldTypeString, alias: GPS?, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• VRP ( type: esriFieldTypeString, alias: VRP, length: 3 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• OWNDEPTCODE ( type: esriFieldTypeString, alias: Owner Department Code, length: 50 )
• USERDEPTCODE1 ( type: esriFieldTypeString, alias: Using Department Code 1, length: 50 )
• USERDEPTCODE2 ( type: esriFieldTypeString, alias: Using Department Code 2, length: 50 )
• USERDEPTCODE3 ( type: esriFieldTypeString, alias: Using Department Code 3, length: 50 )
• WARRANTYHELDBY ( type: esriFieldTypeString, alias: Warranty Held By, length: 50 )
• PRIMARYMETER ( type: esriFieldTypeString, alias: Primary Meter, length: 50 )
• PRIMMETERMEASURE ( type: esriFieldTypeString, alias: Primary Meter Measurement, length: 2 , Coded Values: [H: Hours] , [M: Mileage] , [NA: Not Applicable] )
• PRIMARYMETERDATE ( type: esriFieldTypeDate, alias: Primary Meter Date, length: 8 )
• PRIMMETERLTDUSAGE ( type: esriFieldTypeString, alias: Primary Meter LTD Usage, length: 50 )
• SECONDMETER ( type: esriFieldTypeDouble, alias: Secondary Meter )
• SECMETERMEASURE ( type: esriFieldTypeString, alias: Secondary Meter Measurement, length: 2 , Coded Values: [H: Hours] , [M: Mileage] , [NA: Not Applicable] )
• SECMETERDATE ( type: esriFieldTypeDate, alias: Secondary Meter Date, length: 8 )
• SECMETERLTDUSAGE ( type: esriFieldTypeString, alias: Secondary Meter LTD Usage, length: 50 )
• PRIMINSERVMETER ( type: esriFieldTypeString, alias: Primary In-Service Meter, length: 50 )
• PRIMINSERVMETERMEASURE ( type: esriFieldTypeString, alias: Primary In-Service Meter Measurement, length: 2 , Coded Values: [H: Hours] , [M: Mileage] , [NA: Not Applicable] )
• SECINSERVMETER ( type: esriFieldTypeString, alias: Secondary In-Service Meter, length: 50 )
• SECMINSERVMETERMEASURE ( type: esriFieldTypeString, alias: Secondary In-Service Meter Measurement, length: 2 , Coded Values: [H: Hours] , [M: Mileage] , [NA: Not Applicable] )
• PRIMACQMETER ( type: esriFieldTypeString, alias: Primary Acquisition Meter, length: 50 )
• PRIMACQMETERMEASURE ( type: esriFieldTypeString, alias: Primary Acquisition Meter Measurement, length: 2 , Coded Values: [H: Hours] , [M: Mileage] , [NA: Not Applicable] )
• SECACQMETER ( type: esriFieldTypeString, alias: Secondary Acquisition Meter, length: 50 )
• SECACQMETERMEASURE ( type: esriFieldTypeString, alias: Secondary Acquisition Meter Measurement, length: 2 , Coded Values: [H: Hours] , [M: Mileage] , [NA: Not Applicable] )
• WARRANTYMILEAGE ( type: esriFieldTypeDouble, alias: Warranty Mileage )
• DEPTERM ( type: esriFieldTypeSmallInteger, alias: Depreciation Term (Number of Months) )
• FUSALVAGERATE ( type: esriFieldTypeDouble, alias: Future Salvage Rate )
• SALVAGECOST ( type: esriFieldTypeInteger, alias: Salvage Cost )
• SALEPRICE ( type: esriFieldTypeInteger, alias: Sale Price )
• YEAR ( type: esriFieldTypeSmallInteger, alias: Year )
• MAKE ( type: esriFieldTypeString, alias: Make, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 50 )
• VIN ( type: esriFieldTypeString, alias: VIN, length: 50 )
• LICENSEPLATENUM ( type: esriFieldTypeString, alias: License Plate Number, length: 50 )
• REPLACESUNITNUM ( type: esriFieldTypeString, alias: Replaces Unit Number, length: 50 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata