Layers:

Layer: InspectionSites (0)

Name: InspectionSites

Display Field: Company_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: df1e411da35243ef85d223365c03d74a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3000000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -1.0614573151280513E7
YMin: 5.664923641290895E-9
XMax: 7871945.992248241
YMax: 5147341.141325982
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [115, 223, 255, 255]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling 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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• Operator_Name ( type: esriFieldTypeString, alias: Operator Name, length: 500 )
• Operator_Phone ( type: esriFieldTypeDouble, alias: Operator Phone )
• Operator_Email ( type: esriFieldTypeString, alias: Operator Email, length: 1000 )
• Company_Name ( type: esriFieldTypeString, alias: Company Name, length: 200 )
• Address ( type: esriFieldTypeString, alias: Address, length: 200 )
• City ( type: esriFieldTypeString, alias: City, length: 200 , Coded Values: [Bellevue: Bellevue] , [Huron: Huron] , [Sandusky: Sandusky] , ...11 more... )
• State ( type: esriFieldTypeString, alias: State, length: 200 , Coded Values: [AL: Alabama] , [AK: Alaska] , [AZ: Arizona] , ...48 more... )
• Zip ( type: esriFieldTypeInteger, alias: Zip , Coded Values: [43438: 43438] , [43464: 43464] , [44089: 44089] , ...9 more... )
• County ( type: esriFieldTypeString, alias: County, length: 200 )
• Type_of_Device ( type: esriFieldTypeString, alias: Type of Device, length: 200 , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale/Non-computing ≤ 500 lbs.: Counter/Bench Scale/Non-computing ≤ 500 lbs.] , [Platform/Floor Scale ≤ 5000 lbs.: Platform/Floor Scale ≤ 5000 lbs.] , ...28 more... )
• Phone ( type: esriFieldTypeString, alias: Phone, length: 50 )
• SiteType ( type: esriFieldTypeString, alias: Site Type, length: 255 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 1073741822 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• HopperScaleTest (0) -- Related To: HopperScaleTest (6)
• ReinspectionOrRepairs (1) -- Related To: ReinspectionOrRepairs (16)
• massFlowMeterTest (2) -- Related To: massFlowMeterTest (10)
• ScaleTests (3) -- Related To: ScaleTests (19)
• priceVerificationTest (4) -- Related To: priceVerificationTest (13)
• ObservedTests (5) -- Related To: ObservedTests (11)
• PumpTests (6) -- Related To: PumpTests (15)
• skimmerCheck (7) -- Related To: skimmerCheck (20)
• ComplaintsReceived (8) -- Related To: ComplaintsReceived (3)
• AuditPackTest (9) -- Related To: AuditPackTest (2)
• loadingRackTest (10) -- Related To: loadingRackTest (8)
• vehicleScaleTest (11) -- Related To: vehicleScaleTest (27)

Tables:

Table: AuditPackSubtest (1)

Name: AuditPackSubtest

Display Field: productDescription

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• productDescription ( type: esriFieldTypeString, alias: Product Desc., Lot Code, Unit Price, length: 50 , Coded Values: [Meat: Meat] , [Produce: Produce] , [Feed/Seed: Feed/Seed] , ...1 more... )
• tare ( type: esriFieldTypeDouble, alias: Tare )
• labeledWtorPrice ( type: esriFieldTypeDouble, alias: Labeled Weight or Price )
• packageError ( type: esriFieldTypeDouble, alias: Package Error )
• mavDimless ( type: esriFieldTypeDouble, alias: MAV (dimensionless) )
• positiveCheck ( type: esriFieldTypeSmallInteger, alias: Positive Check )
• negativeCheck ( type: esriFieldTypeSmallInteger, alias: Negative Check )
• recordedWeightOrPrice ( type: esriFieldTypeDouble, alias: Recorded Weight Or Price )

Relationships:

• AuditPackTest (12) -- Related To: AuditPackTest (2)

Table: AuditPackTest (2)

Name: AuditPackTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• guid ( type: esriFieldTypeGUID, alias: guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• productBrandIdentity ( type: esriFieldTypeString, alias: Product/Brand Identity, length: 50 )
• lotCodes ( type: esriFieldTypeString, alias: Lot Codes, length: 50 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• containerDescription ( type: esriFieldTypeString, alias: Container Description, length: 250 )
• measurementUnits ( type: esriFieldTypeString, alias: Measurement Units, length: 50 )
• inspectionLotSize ( type: esriFieldTypeSmallInteger, alias: Inspection Lot Size )
• sampleSize ( type: esriFieldTypeSmallInteger, alias: Sample Size (n) )
• initialTareSampleSize ( type: esriFieldTypeSmallInteger, alias: Init. Tare Sample Size )
• numberofMAVAllowed ( type: esriFieldTypeSmallInteger, alias: Number of MAVs Allowed )
• rangeOfPackageERrors ( type: esriFieldTypeSmallInteger, alias: Range of Package Errors (Rc) )
• rangeOfTareWeights ( type: esriFieldTypeSmallInteger, alias: Range of Tare Weights (Rt) )
• rcDivrt ( type: esriFieldTypeDouble, alias: Rc / Rt )
• avgTareWt ( type: esriFieldTypeDouble, alias: Avg. Tare Wt. )
• nomialGrossWt ( type: esriFieldTypeDouble, alias: Nominal Gross Wt )
• totalError ( type: esriFieldTypeDouble, alias: Total Error )
• numberOfUnreasonableMinusErrors ( type: esriFieldTypeSmallInteger, alias: Number of Unreasonable Minus (-) Errors )
• box16GTbox8 ( type: esriFieldTypeSmallInteger, alias: Number of Unreasonable Minus Errors > # MAVs Allowed? , Coded Values: [0: No] , [1: Yes] )
• AvgErrorinDimlessUnits ( type: esriFieldTypeDouble, alias: Avg. Error in Dimensionless Units )
• avgErrorInLabeledUnits ( type: esriFieldTypeDouble, alias: Avg. Error in Labeled Units )
• sampleStandardDeviation ( type: esriFieldTypeDouble, alias: Sample Standard Deviation )
• sampleCorrectionFactor ( type: esriFieldTypeDouble, alias: Sample Correction Factor )
• sampleErrorLimit ( type: esriFieldTypeDouble, alias: Sample Error Limit )
• box18GTbox23 ( type: esriFieldTypeSmallInteger, alias: Disregarding Signs, is Avg. Error in Dimless Units > Sample Error Limit? , Coded Values: [0: No] , [1: Yes] )
• dispositionOfInspectionLot ( type: esriFieldTypeString, alias: Disposition of Inspection Lot, length: 50 , Coded Values: [APP: Approve] , [REJ: Reject] , [CDM: Condemned] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• countMinusErrors ( type: esriFieldTypeSmallInteger, alias: Count of Minus Errors )
• countPlusErrors ( type: esriFieldTypeSmallInteger, alias: Count of Plus Errors )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, length: 50 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• box18EqualZeroOrPlus ( type: esriFieldTypeDouble, alias: Box 18 Equal Zero Or Plus , Coded Values: [0: No] , [1: Yes] )
• tareStandardizationType ( type: esriFieldTypeString, alias: Tare Standardization Type, length: 50 , Coded Values: [Tare Correction: Tare Correction] , [Moisture Allowance: Moisture Allowance] , [Not Applicable: Not Applicable] )
• tareWeightType ( type: esriFieldTypeString, alias: Tare Weight Type, length: 50 , Coded Values: [Dry: Dry Tare] , [Wet: Wet Tare] , [Unused: Unused Dry Tare] )
• measurementDivisions ( type: esriFieldTypeDouble, alias: Measurement Divisions )
• samplesToTake ( type: esriFieldTypeInteger, alias: Samples to Take )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 1000 )

Relationships:

• AuditPackSubtest (12) -- Related To: AuditPackSubtest (1)
• InspectionSites (9) -- Related To: InspectionSites (0)

Table: ComplaintsReceived (3)

Name: ComplaintsReceived

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• guid ( type: esriFieldTypeGUID, alias: guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company, length: 200 )
• dateReceived ( type: esriFieldTypeDate, alias: Date Received, length: 8 )
• resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• dateResolved ( type: esriFieldTypeDate, alias: Date Resolved, length: 8 )
• Contacted ( type: esriFieldTypeString, alias: Contacted, length: 50 )
• Title ( type: esriFieldTypeString, alias: Title, length: 50 )
• Device ( type: esriFieldTypeString, alias: Device, length: 50 )
• CompType ( type: esriFieldTypeString, alias: Complaint Type, length: 50 , Coded Values: [Motor-Fuel: Motor-Fuel] , [Home Heating Fuel: Home Heating Fuel] , [Price Errors: Price Errors] , ...6 more... )
• complainReceivedByName ( type: esriFieldTypeString, alias: Complaint Contact, length: 50 )
• complainReceivedByAdd ( type: esriFieldTypeString, alias: Complaint Address, length: 50 )
• complainReceivedByPhone ( type: esriFieldTypeString, alias: Complaint Phone, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• reason ( type: esriFieldTypeString, alias: Reason, length: 200 )
• findings ( type: esriFieldTypeString, alias: Findings, length: 200 )
• action ( type: esriFieldTypeString, alias: Action, length: 200 )

Relationships:

• InspectionSites (8) -- Related To: InspectionSites (0)

Table: hopperAggregateTests (4)

Name: hopperAggregateTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• WeightA ( type: esriFieldTypeDouble, alias: Weight )
• Requested ( type: esriFieldTypeDouble, alias: Requested )
• Delivered ( type: esriFieldTypeDouble, alias: Delivered )
• DifferenceA ( type: esriFieldTypeDouble, alias: Difference )
• scaleDivisionsA ( type: esriFieldTypeString, alias: Scale Divisions A, length: 50 )

Relationships:

• HopperScaleTest (13) -- Related To: HopperScaleTest (6)

Table: hopperCementTests (5)

Name: hopperCementTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guidg, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• WeightC ( type: esriFieldTypeDouble, alias: Weight )
• Total ( type: esriFieldTypeDouble, alias: Total )
• DifferenceC ( type: esriFieldTypeDouble, alias: Difference )
• scaleDivisionsC ( type: esriFieldTypeString, alias: Scale Divisions A, length: 50 )

Relationships:

• HopperScaleTest (14) -- Related To: HopperScaleTest (6)

Table: HopperScaleTest (6)

Name: HopperScaleTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• MFG ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• Capacity ( type: esriFieldTypeDouble, alias: Capacity )
• GradSize ( type: esriFieldTypeDouble, alias: Grad Size )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, length: 50 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, length: 50 , Coded Values: [Pass: Pass] , [Fail: Fail] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 1000 )
• ScaleType ( type: esriFieldTypeString, alias: Scale Type, length: 255 , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale Non-computing =<500: Counter/Bench Scale Non-computing =<500] , [Platform/Floor Scale <= 5000lbs: Platform/Floor Scale <= 5000lbs] , ...14 more... )

Relationships:

• hopperCementTests (14) -- Related To: hopperCementTests (5)
• hopperAggregateTests (13) -- Related To: hopperAggregateTests (4)
• InspectionSites (0) -- Related To: InspectionSites (0)

Table: loadingRackSubTests (7)

Name: loadingRackSubTests

Display Field: liquidBrandName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• liquidBrandName ( type: esriFieldTypeString, alias: Liquid (Brand Name), length: 50 )
• meterReading ( type: esriFieldTypeDouble, alias: Meter Reading )
• tempCompUnComp ( type: esriFieldTypeDouble, alias: Temp. Comp/Un Comp )
• netMeterReading ( type: esriFieldTypeDouble, alias: Net Meter Reading )
• proverGross ( type: esriFieldTypeDouble, alias: Prover Gross )
• proverTemp ( type: esriFieldTypeDouble, alias: Prover Temp )
• Diff ( type: esriFieldTypeDouble, alias: Diff. )
• correctedProver ( type: esriFieldTypeDouble, alias: Corrected Prover )
• proverNet ( type: esriFieldTypeDouble, alias: Prover Net )
• errorGallon ( type: esriFieldTypeDouble, alias: Error Gallon )
• errorinCuInPlusMinus ( type: esriFieldTypeDouble, alias: Error in Cu. In. (Indicate Plus/Minus) )

Relationships:

• loadingRackTest (15) -- Related To: loadingRackTest (8)

Table: loadingRackTest (8)

Name: loadingRackTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• makeOfMeter ( type: esriFieldTypeString, alias: Make of Meter, length: 50 )
• meterSerialNumber ( type: esriFieldTypeString, alias: Meter Serial Number, length: 50 )
• meterSealAsFound ( type: esriFieldTypeString, alias: Meter Seal As Found, length: 50 , Coded Values: [State: State] , [Other: Other] )
• meterConditionOfSeal ( type: esriFieldTypeString, alias: Condition of Seal, length: 50 , Coded Values: [Intact: Intact] , [Broken: Broke] , [Missing: Missing] )
• makeOfRegister ( type: esriFieldTypeString, alias: Make of Register, length: 50 )
• registerSerialNumber ( type: esriFieldTypeString, alias: Register Serial Number, length: 50 )
• registerSealAsFound ( type: esriFieldTypeString, alias: Register Seal As Found, length: 50 , Coded Values: [State: State] , [Other: Other] )
• registerConditionOfSeal ( type: esriFieldTypeString, alias: Register Condition of Seal, length: 50 , Coded Values: [Intact: Intact] , [Broken: Broke] , [Missing: Missing] )
• totalizerReadingAsFound ( type: esriFieldTypeString, alias: Totalizer Reading as Found, length: 50 )
• totalizerReadingAsLeft ( type: esriFieldTypeString, alias: Totalizer Reading as Left, length: 50 )
• antiDrainValueFunctioning ( type: esriFieldTypeSmallInteger, alias: Antidrain Value Functioning , Coded Values: [0: No] , [1: Yes] )
• recheck ( type: esriFieldTypeSmallInteger, alias: Recheck , Coded Values: [0: No] , [1: Yes] )
• actionTaken ( type: esriFieldTypeString, alias: Action Taken, length: 50 , Coded Values: [APP: Approve] , [REJ: Reject] , [CDM: Condemned] )
• stateWeightsAndMeasuresInspecto ( type: esriFieldTypeString, alias: State Weights & Measures Inspector, length: 50 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, length: 50 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• testNum ( type: esriFieldTypeString, alias: Test Num., length: 50 )
• permitNum ( type: esriFieldTypeString, alias: Permit No., length: 50 )
• truckNum ( type: esriFieldTypeString, alias: Truck No., length: 50 )
• productTradeName ( type: esriFieldTypeString, alias: Product Trade Name, length: 50 )
• stateIdNum ( type: esriFieldTypeString, alias: State ID No., length: 50 )
• ccNum ( type: esriFieldTypeString, alias: CC #, length: 50 )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 4000 )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 4000 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• ScaleType ( type: esriFieldTypeString, alias: Scale Type, length: 255 , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale Non-computing =<500: Counter/Bench Scale Non-computing =<500] , [Platform/Floor Scale <= 5000lbs: Platform/Floor Scale <= 5000lbs] , ...14 more... )

Relationships:

• loadingRackSubTests (15) -- Related To: loadingRackSubTests (7)
• InspectionSites (10) -- Related To: InspectionSites (0)

Table: massFlowMeterSubTest (9)

Name: massFlowMeterSubTest

Display Field: Time

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• TestNo ( type: esriFieldTypeSmallInteger, alias: Test Number )
• Time ( type: esriFieldTypeString, alias: Time, length: 50 )
• flowRate ( type: esriFieldTypeDouble, alias: Flow Rate )
• Gross ( type: esriFieldTypeDouble, alias: Gross )
• Tare ( type: esriFieldTypeDouble, alias: Tare )
• scaleError ( type: esriFieldTypeDouble, alias: Scale Error )
• Net ( type: esriFieldTypeDouble, alias: Net )
• meterReading ( type: esriFieldTypeDouble, alias: Meter Reading )
• Difference ( type: esriFieldTypeDouble, alias: Difference )
• pcntError ( type: esriFieldTypeDouble, alias: % Error )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, length: 50 , Coded Values: [Pass: Pass] , [Fail: Fail] )
• productNumber ( type: esriFieldTypeString, alias: Product Number, length: 50 )
• bayNum ( type: esriFieldTypeString, alias: Bay Number, length: 50 )

Relationships:

• massFlowMeterTest (16) -- Related To: massFlowMeterTest (10)

Table: massFlowMeterTest (10)

Name: massFlowMeterTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator Email, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• TypeOfProduct ( type: esriFieldTypeString, alias: Type of Product, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• AccuracyClass ( type: esriFieldTypeString, alias: Accuracy Class, length: 50 )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, length: 50 , Coded Values: [Pass: Pass] , [Fail: Fail] )

Relationships:

• massFlowMeterSubTest (16) -- Related To: massFlowMeterSubTest (9)
• InspectionSites (2) -- Related To: InspectionSites (0)

Table: ObservedTests (11)

Name: ObservedTests

Display Field: inspectionType

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• guid ( type: esriFieldTypeGUID, alias: guid, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• ServiceCompany ( type: esriFieldTypeString, alias: Service Company, length: 100 )
• ServiceTech ( type: esriFieldTypeString, alias: Service Technician, length: 100 )
• StateID ( type: esriFieldTypeString, alias: State ID#, length: 50 )
• inspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator Email, length: 50 )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• Checked ( type: esriFieldTypeSmallInteger, alias: Checked? , Coded Values: [0: No] , [1: Yes] )
• Sealed ( type: esriFieldTypeSmallInteger, alias: Sealed? , Coded Values: [0: No] , [1: Yes] )
• outOfTolerance ( type: esriFieldTypeSmallInteger, alias: Out of Tolerance? , Coded Values: [0: No] , [1: Yes] )
• retest ( type: esriFieldTypeSmallInteger, alias: Requires Re-test? , Coded Values: [0: No] , [1: Yes] )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• inspectionType ( type: esriFieldTypeString, alias: Inspection Type, length: 50 , Coded Values: [Automatic Weighing Systems: Automatic Weighing Systems] , [Compressed Natural Gas (CNG): Compressed Natural Gas (CNG)] , [Other Platform > 5000lbs.: Other Platform > 5000lbs.] , ...8 more... )
• remarks ( type: esriFieldTypeString, alias: Remarks, length: 4000 )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 1000 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• InspectionSites (5) -- Related To: InspectionSites (0)

Table: priceVerificationSubtests (12)

Name: priceVerificationSubtests

Display Field: Location

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created User, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• Item ( type: esriFieldTypeString, alias: Item, length: 50 )
• Listed ( type: esriFieldTypeDouble, alias: Listed )
• Charged ( type: esriFieldTypeDouble, alias: Charged )
• Difference ( type: esriFieldTypeDouble, alias: Plus )

Relationships:

• priceVerificationTest (17) -- Related To: priceVerificationTest (13)

Table: priceVerificationTest (13)

Name: priceVerificationTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, length: 50 )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• Score ( type: esriFieldTypeDouble, alias: Score )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 1000 )

Relationships:

• priceVerificationSubtests (17) -- Related To: priceVerificationSubtests (12)
• InspectionSites (4) -- Related To: InspectionSites (0)

Table: PumpSubtests (14)

Name: PumpSubtests

Display Field: PumpNumber

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• PumpNumber ( type: esriFieldTypeString, alias: Pump #, length: 50 )
• ProductKey ( type: esriFieldTypeSmallInteger, alias: Product Key , Coded Values: [1: Gasoline] , [2: Diesel Fuel] , [3: Kerosene] )
• N ( type: esriFieldTypeString, alias: N, length: 50 )
• S ( type: esriFieldTypeString, alias: S, length: 50 )
• ProverReadingPlusCubicIn ( type: esriFieldTypeDouble, alias: Prover Reading Cubic In. (+) )
• ProverReadingMinusCubicIn ( type: esriFieldTypeDouble, alias: ProverReading Cubic In. (-) )
• ActionTaken ( type: esriFieldTypeString, alias: Action Taken, length: 50 , Coded Values: [APP: Approve] , [REJ: Reject] , [CDM: Condemned] )
• SealBroken ( type: esriFieldTypeSmallInteger, alias: Seal Broken , Coded Values: [0: No] , [1: Yes] )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 4000 )
• TotalGallons ( type: esriFieldTypeString, alias: Total Gallons, length: 50 )
• Amount ( type: esriFieldTypeString, alias: Amount, length: 50 )
• PumpMeetsAllTolerances ( type: esriFieldTypeSmallInteger, alias: Pump Meets All Tolerances , Coded Values: [0: No] , [1: Yes] )
• pumpFuelType ( type: esriFieldTypeString, alias: Pump Fuel Type, length: 50 , Coded Values: [Regular: Regular] , [Blend: Blend] , [Diesel: Diesel] , ...1 more... )
• Octane ( type: esriFieldTypeString, alias: Octane, length: 50 , Coded Values: [87: 87] , [89: 89] , [93: 93] , ...10 more... )
• PricePerGallon ( type: esriFieldTypeString, alias: Price Per Gallon, length: 50 )
• subtestIsARetest ( type: esriFieldTypeSmallInteger, alias: Subtest is a Retest )

Relationships:

• PumpTests (18) -- Related To: PumpTests (15)

Table: PumpTests (15)

Name: PumpTests

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Inspected By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Inspected Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 500 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator Email, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• fuelReturnedToPropertyStorage ( type: esriFieldTypeSmallInteger, alias: Fuel Returned To Property Storage , Coded Values: [0: No] , [1: Yes] )
• pumpCountOutOfTolerance ( type: esriFieldTypeInteger, alias: Pump Count Out Of Tolerance )
• comments ( type: esriFieldTypeString, alias: Comments, length: 1073741822 )
• ReinpectionRequired ( type: esriFieldTypeSmallInteger, alias: Reinpection Required? , Coded Values: [0: No] , [1: Yes] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• fuelType ( type: esriFieldTypeString, alias: Fuel Type, length: 50 , Coded Values: [Regular: Regular] , [Blend: Blend] , [Diesel: Diesel] , ...1 more... )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 4000 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• isARetest_ ( type: esriFieldTypeSmallInteger, alias: Is a Retest )

Relationships:

• PumpSubtests (18) -- Related To: PumpSubtests (14)
• InspectionSites (6) -- Related To: InspectionSites (0)

Table: ReinspectionOrRepairs (16)

Name: ReinspectionOrRepairs

Display Field: RepairCompanyName

Type: Table

Geometry Type: N/A

Description: null

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited On, length: 8 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• Phone ( type: esriFieldTypeDouble, alias: Phone )
• RepairedBy ( type: esriFieldTypeString, alias: Repaired By, length: 50 )
• RepairCompanyName ( type: esriFieldTypeString, alias: Repair Company Name, length: 50 )
• RepairCompanyAddress ( type: esriFieldTypeString, alias: Repair Company Address, length: 50 )
• RepairCompanyPhone ( type: esriFieldTypeString, alias: Repair Company Phone, length: 50 )
• reinspectionDate ( type: esriFieldTypeDate, alias: Date of Reinspection, length: 8 )

Relationships:

• InspectionSites (1) -- Related To: InspectionSites (0)

Table: ScalePerformanceTests (17)

Name: ScalePerformanceTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• Phone ( type: esriFieldTypeDouble, alias: Phone )
• TestD ( type: esriFieldTypeDouble, alias: Test D )
• TestLoad ( type: esriFieldTypeDouble, alias: Test Load )
• ErrorInD ( type: esriFieldTypeDouble, alias: Error In D )
• Error ( type: esriFieldTypeDouble, alias: Error )

Relationships:

• ScaleTests (19) -- Related To: ScaleTests (19)

Table: ScaleShiftCapacityTests (18)

Name: ScaleShiftCapacityTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited On, length: 8 )
• Shift1Load ( type: esriFieldTypeDouble, alias: Shift 1 Load )
• Shift1Error ( type: esriFieldTypeDouble, alias: Shift 1 Error )
• Shift2Load ( type: esriFieldTypeDouble, alias: Shift 2 Load )
• Shift2Error ( type: esriFieldTypeDouble, alias: Shift 2 Error )
• Shift3Load ( type: esriFieldTypeDouble, alias: Shift 3 Load )
• Shift3Error ( type: esriFieldTypeDouble, alias: Shift 3 Error )
• Shift4Load ( type: esriFieldTypeDouble, alias: Shift 4 Load )
• Shift4Error ( type: esriFieldTypeDouble, alias: Shift 4 Error )
• Shift1Reading ( type: esriFieldTypeDouble, alias: Shift 1 Reading )
• Shift1ErrorInD ( type: esriFieldTypeDouble, alias: Shift 1 Error In D )
• Shift2Reading ( type: esriFieldTypeDouble, alias: Shift 2 Reading )
• Shift2ErrorInD ( type: esriFieldTypeDouble, alias: Shift 2 Error In D )
• Shift3Reading ( type: esriFieldTypeDouble, alias: Shift 3 Reading )
• Shift3ErrorInD ( type: esriFieldTypeDouble, alias: Shift 3 Error In D )
• Shift4Reading ( type: esriFieldTypeDouble, alias: Shift 4 Reading )
• Shift4ErrorInD ( type: esriFieldTypeDouble, alias: Shift 4 Error In D )

Relationships:

• ScaleTests (20) -- Related To: ScaleTests (19)

Table: ScaleTests (19)

Name: ScaleTests

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Record Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Record Created On, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, length: 50 )
• TestType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• ScaleType ( type: esriFieldTypeString, alias: Scale Type, length: 50 , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale Non-computing =<500: Counter/Bench Scale Non-computing =<500] , [Platform/Floor Scale <= 5000lbs: Platform/Floor Scale <= 5000lbs] , ...14 more... )
• Scale ( type: esriFieldTypeString, alias: Scale, length: 50 )
• ScaleLocation ( type: esriFieldTypeString, alias: Scale Location, length: 50 )
• MakeOfScale ( type: esriFieldTypeString, alias: Make of Scale, length: 50 )
• ModelType ( type: esriFieldTypeString, alias: Model Type, length: 50 )
• SerielNo ( type: esriFieldTypeString, alias: Scale Seriel Number, length: 50 )
• Capacity ( type: esriFieldTypeString, alias: Capacity, length: 50 )
• Division ( type: esriFieldTypeString, alias: Division, length: 50 )
• NumOfD ( type: esriFieldTypeInteger, alias: Number of (d) )
• SealCondition ( type: esriFieldTypeString, alias: Seal Condition, length: 50 , Coded Values: [Intact: Intact] , [Broken: Broke] , [Missing: Missing] )
• ZeroLoadBalance ( type: esriFieldTypeSmallInteger, alias: Zero Load Balance )
• AZSM ( type: esriFieldTypeSmallInteger, alias: AZSM , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• LevelCondition ( type: esriFieldTypeSmallInteger, alias: Level Condition , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SupportForScale ( type: esriFieldTypeSmallInteger, alias: Support For Scale , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SuitableForEnvironment ( type: esriFieldTypeSmallInteger, alias: Suitable For Environment , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• CustomerIndications ( type: esriFieldTypeSmallInteger, alias: Customer Indications , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• PrinterRequirements ( type: esriFieldTypeSmallInteger, alias: Printer Requirements , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• TareCapabilities ( type: esriFieldTypeSmallInteger, alias: Tare Capabilities , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SRatZero ( type: esriFieldTypeSmallInteger, alias: SR at Zero , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SRatMax ( type: esriFieldTypeSmallInteger, alias: SR at Max , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• IncLoadTest ( type: esriFieldTypeSmallInteger, alias: Inc. Load Test , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• ShiftTest ( type: esriFieldTypeSmallInteger, alias: Shift Test , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• DecLoadTest ( type: esriFieldTypeSmallInteger, alias: Dec. Load Test , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• ReturnToZero ( type: esriFieldTypeSmallInteger, alias: Return To Zero , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• MoneyValueComps ( type: esriFieldTypeSmallInteger, alias: Money Value Comps , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• ScaleMeetsAllTolerances ( type: esriFieldTypeSmallInteger, alias: Scale Meets All Tolerances , Coded Values: [0: No] , [1: Yes] )
• ScaleIs ( type: esriFieldTypeSmallInteger, alias: Scale Is , Coded Values: [0: Sealed] , [1: Rejected for Repair] , [2: Condemned from Use Until Repaired] )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 1000 )
• Error ( type: esriFieldTypeSmallInteger, alias: Error , Coded Values: [0: No] , [1: Yes] )
• ReinspectionRequired ( type: esriFieldTypeSmallInteger, alias: Reinspection Required , Coded Values: [0: No] , [1: Yes] )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 4000 )

Relationships:

• ScaleShiftCapacityTests (20) -- Related To: ScaleShiftCapacityTests (18)
• ScalePerformanceTests (19) -- Related To: ScalePerformanceTests (17)
• InspectionSites (3) -- Related To: InspectionSites (0)

Table: skimmerCheck (20)

Name: skimmerCheck

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• TestType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• SkimmerFound ( type: esriFieldTypeSmallInteger, alias: Skimmer Found , Coded Values: [0: No] , [1: Yes] )
• numOfFuelDispensers ( type: esriFieldTypeSmallInteger, alias: # of Fuel Dispensers )
• pumpNumber ( type: esriFieldTypeString, alias: Pump Number, length: 50 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 4000 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 4000 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• InspectionSites (7) -- Related To: InspectionSites (0)

Table: vehicleScaleAsFoundLoadCal (21)

Name: vehicleScaleAsFoundLoadCal

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• calibrationLoadAsFound ( type: esriFieldTypeDouble, alias: Calibration Load As Found )
• calibrationWeightAsFound ( type: esriFieldTypeDouble, alias: Calibration Weight As Found )
• calibrationTotalAsFound ( type: esriFieldTypeDouble, alias: Total Weight As Found )
• readingAsFound ( type: esriFieldTypeDouble, alias: Reading As Found )
• errorAsFound ( type: esriFieldTypeDouble, alias: Error As Found )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )

Relationships:

• vehicleScaleTest (21) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleAsFoundTestReadings (22)

Name: vehicleScaleAsFoundTestReadings

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• asFoundweightApplied ( type: esriFieldTypeDouble, alias: Weight Applied )
• asFoundReading ( type: esriFieldTypeDouble, alias: Reading )
• asFoundError ( type: esriFieldTypeDouble, alias: Error )
• asFoundTotal ( type: esriFieldTypeDouble, alias: Total )

Relationships:

• vehicleScaleTest (22) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleAsLeftLoadCal (23)

Name: vehicleScaleAsLeftLoadCal

Display Field: errorAsLeft

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• calibrationLoadAsLeft ( type: esriFieldTypeDouble, alias: Calibration Load As Left )
• calibrationWeightAsLeft ( type: esriFieldTypeDouble, alias: Calibration Weight As Found )
• calibrationTotalAsLeft ( type: esriFieldTypeDouble, alias: Calibration Total As Found )
• readingAsLeft ( type: esriFieldTypeDouble, alias: Reading )
• errorAsLeft ( type: esriFieldTypeString, alias: Error As Left, length: 50 )

Relationships:

• vehicleScaleTest (23) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleAsLeftTestReadings (24)

Name: vehicleScaleAsLeftTestReadings

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• asLeftweightApplied ( type: esriFieldTypeDouble, alias: Weight Applied )
• asLeftReading ( type: esriFieldTypeDouble, alias: Reading )
• asLeftError ( type: esriFieldTypeDouble, alias: Error )
• asLeftTotal ( type: esriFieldTypeDouble, alias: Total )

Relationships:

• vehicleScaleTest (24) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleDecreasingLoadTests (25)

Name: vehicleScaleDecreasingLoadTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• guid ( type: esriFieldTypeGUID, alias: guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• decreasingWtApplied ( type: esriFieldTypeDouble, alias: Decreasing Wt Applied )
• decreasingReading ( type: esriFieldTypeDouble, alias: Decreasing Reading )
• decreasingError ( type: esriFieldTypeDouble, alias: Decreasing Error )
• decreasingTotal ( type: esriFieldTypeDouble, alias: Decreasing Total )

Relationships:

• vehicleScaleTest (25) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleIncreasingLoadTests (26)

Name: vehicleScaleIncreasingLoadTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• guid ( type: esriFieldTypeGUID, alias: guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• increasingWtApplied ( type: esriFieldTypeDouble, alias: Increasing Weight Applied )
• increasingReading ( type: esriFieldTypeDouble, alias: Increasing Reading )
• increasingError ( type: esriFieldTypeDouble, alias: Increasing Error )
• increasingTotal ( type: esriFieldTypeDouble, alias: Increasing Total )

Relationships:

• vehicleScaleTest (26) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleTest (27)

Name: vehicleScaleTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• testType ( type: esriFieldTypeInteger, alias: Test Type , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• indicatorMake ( type: esriFieldTypeString, alias: Indicator Make, length: 50 )
• indicatorSerial ( type: esriFieldTypeString, alias: Indicator Serial #, length: 50 )
• indicatorModelNum ( type: esriFieldTypeString, alias: Indicator Model #, length: 50 )
• scaleCapacity ( type: esriFieldTypeString, alias: Scale Capacity, length: 50 )
• platformMake ( type: esriFieldTypeString, alias: Platform Make, length: 50 )
• platformSerial ( type: esriFieldTypeString, alias: Platform Serial #, length: 50 )
• platformModelNum ( type: esriFieldTypeString, alias: Platform Model #, length: 50 )
• CLC ( type: esriFieldTypeString, alias: CLC, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 4000 )
• operator ( type: esriFieldTypeString, alias: Operator, length: 50 )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, length: 50 )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, length: 200 )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, length: 200 )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , Coded Values: [0: No] , [1: Yes] )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, length: 50 , Coded Values: [Pass: Pass] , [Fail: Fail] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, length: 50 , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, length: 8 )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, length: 4000 )

Relationships:

• vehicleScaleTestSectionShiftCal (27) -- Related To: vehicleScaleTestSectionShiftCalibration (28)
• vehicleScaleAsFoundLoadCal (21) -- Related To: vehicleScaleAsFoundLoadCal (21)
• vehicleScaleAsLeftTestReadings (24) -- Related To: vehicleScaleAsLeftTestReadings (24)
• vehicleScaleIncreasingLoadTests (26) -- Related To: vehicleScaleIncreasingLoadTests (26)
• vehicleScaleAsLeftLoadCal (23) -- Related To: vehicleScaleAsLeftLoadCal (23)
• vehicleScaleAsFoundTestReadings (22) -- Related To: vehicleScaleAsFoundTestReadings (22)
• vehicleScaleDecreasingLoadTests (25) -- Related To: vehicleScaleDecreasingLoadTests (25)
• InspectionSites (11) -- Related To: InspectionSites (0)

Table: vehicleScaleTestSectionShiftCalibration (28)

Name: vehicleScaleTestSectionShiftCalibration

Display Field: sectionNum

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: df1e411da35243ef85d223365c03d74a

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: Created By, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• sectionNum ( type: esriFieldTypeString, alias: Section Number, length: 50 )
• asFoundReading1 ( type: esriFieldTypeDouble, alias: As Found Reading 1 )
• asFoundReading2 ( type: esriFieldTypeDouble, alias: As Found Reading 2 )
• asFoundReading3 ( type: esriFieldTypeDouble, alias: As Found Reading 3 )
• asFoundReading4 ( type: esriFieldTypeDouble, alias: As Found Reading 4 )
• varianceError ( type: esriFieldTypeDouble, alias: Variance/Error )
• tolerance ( type: esriFieldTypeDouble, alias: Tolerance )

Relationships:

• vehicleScaleTest (27) -- Related To: vehicleScaleTest (27)