{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "InspectionSites", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 3000000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 115, 223, 255, 255 ], "size": 5, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.0614573151280513E7, "ymin": 5.664923641290895E-9, "xmax": 7871945.992248241, "ymax": 5147341.141325982, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Company_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "Operator_Name", "type": "esriFieldTypeString", "alias": "Operator Name", "length": 500, "domain": null }, { "name": "Operator_Phone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "Operator_Email", "type": "esriFieldTypeString", "alias": "Operator Email", "length": 1000, "domain": null }, { "name": "Company_Name", "type": "esriFieldTypeString", "alias": "Company Name", "length": 200, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 200, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 200, "domain": { "type": "codedValue", "name": "Cities", "description": "CitiesInErieCounty", "codedValues": [ { "name": "Bellevue", "code": "Bellevue" }, { "name": "Huron", "code": "Huron" }, { "name": "Sandusky", "code": "Sandusky" }, { "name": "Vermilion", "code": "Vermilion" }, { "name": "Berlin Heights", "code": "Berlin Heights" }, { "name": "Birmingham", "code": "Birmingham" }, { "name": "Castalia", "code": "Castalia" }, { "name": "Collins", "code": "Collins" }, { "name": "Kelleys Island", "code": "Kelleys Island" }, { "name": "Milan", "code": "Milan" }, { "name": "Monroeville", "code": "Monroeville" }, { "name": "Norwalk", "code": "Norwalk" }, { "name": "Vickery", "code": "Vickery" }, { "name": "Wakeman", "code": "Wakeman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 200, "domain": { "type": "codedValue", "name": "States", "description": "State abbreviations", "codedValues": [ { "name": "Alabama", "code": "AL" }, { "name": "Alaska", "code": "AK" }, { "name": "Arizona", "code": "AZ" }, { "name": "Arkansas", "code": "AR" }, { "name": "California", "code": "CA" }, { "name": "Colorado", "code": "CO" }, { "name": "Connecticut", "code": "CT" }, { "name": "Delaware", "code": "DE" }, { "name": "District of Columbia", "code": "DC" }, { "name": "Florida", "code": "FL" }, { "name": "Georgia", "code": "GA" }, { "name": "Hawaii", "code": "HI" }, { "name": "Idaho", "code": "ID" }, { "name": "Illinois", "code": "IL" }, { "name": "Indiana", "code": "IN" }, { "name": "Iowa", "code": "IA" }, { "name": "Kansas", "code": "KS" }, { "name": "Kentucky", "code": "KY" }, { "name": "Louisiana", "code": "LA" }, { "name": "Maine", "code": "ME" }, { "name": "Montana", "code": "MT" }, { "name": "Nebraska", "code": "NE" }, { "name": "Nevada", "code": "NV" }, { "name": "New Hampshire", "code": "NH" }, { "name": "New Jersey", "code": "NJ" }, { "name": "New Mexico", "code": "NM" }, { "name": "New York", "code": "NY" }, { "name": "North Carolina", "code": "NC" }, { "name": "North Dakota", "code": "ND" }, { "name": "Ohio", "code": "OH" }, { "name": "Oklahoma", "code": "OK" }, { "name": "Oregon", "code": "OR" }, { "name": "Maryland", "code": "MD" }, { "name": "Massachusetts", "code": "MA" }, { "name": "Michigan", "code": "MI" }, { "name": "Minnesota", "code": "MN" }, { "name": "Mississippi", "code": "MS" }, { "name": "Missouri", "code": "MO" }, { "name": "Pennsylvania", "code": "PA" }, { "name": "Rhode Island", "code": "RI" }, { "name": "South Carolina", "code": "SC" }, { "name": "South Dakota", "code": "SD" }, { "name": "Tennessee", "code": "TN" }, { "name": "Texas", "code": "TX" }, { "name": "Utah", "code": "UT" }, { "name": "Vermont", "code": "VT" }, { "name": "Virginia", "code": "VA" }, { "name": "Washington", "code": "WA" }, { "name": "West Virginia", "code": "WV" }, { "name": "Wisconsin", "code": "WI" }, { "name": "Wyoming", "code": "WY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Zip", "type": "esriFieldTypeInteger", "alias": "Zip", "domain": { "type": "codedValue", "name": "Zipcodes", "description": "Zipcodes In Erie County", "codedValues": [ { "name": "43438", "code": 43438 }, { "name": "43464", "code": 43464 }, { "name": "44089", "code": 44089 }, { "name": "44811", "code": 44811 }, { "name": "44814", "code": 44814 }, { "name": "44816", "code": 44816 }, { "name": "44824", "code": 44824 }, { "name": "44826", "code": 44826 }, { "name": "44839", "code": 44839 }, { "name": "44846", "code": 44846 }, { "name": "44870", "code": 44857 }, { "name": "44889", "code": 44889 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "County", "type": "esriFieldTypeString", "alias": "County", "length": 200, "domain": null }, { "name": "Type_of_Device", "type": "esriFieldTypeString", "alias": "Type of Device", "length": 200, "domain": { "type": "codedValue", "name": "DeviceTypesForWM", "description": "Types of devices WM tests", "codedValues": [ { "name": "Computing Scale", "code": "Computing Scale" }, { "name": "Counter/Bench Scale/Non-computing ≤ 500 lbs.", "code": "Counter/Bench Scale/Non-computing ≤ 500 lbs." }, { "name": "Platform/Floor Scale ≤ 5000 lbs.", "code": "Platform/Floor Scale ≤ 5000 lbs." }, { "name": "Other Platform > 5000 lbs.", "code": "Other Platform > 5000 lbs." }, { "name": "Monorail Scale", "code": "Monorail Scale" }, { "name": "Grain Test Scale", "code": "Grain Test Scale" }, { "name": "Hopper/Batch/Tank Scale", "code": "Hopper/Batch/Tank Scale" }, { "name": "Point-of-Sale System w/Scale", "code": "Point-of-Sale System w/Scale" }, { "name": "Misc/Customer Scale", "code": "Misc/Customer Scale" }, { "name": "Precious Metals/Jewelry", "code": "Precious Metals/Jewelry" }, { "name": "On-Board Weighing Systems", "code": "On-Board Weighing Systems" }, { "name": "Automatic Weighing Systems", "code": "Automatic Weighing Systems" }, { "name": "Vehicle Scale", "code": "Vehicle Scale" }, { "name": "Livestock/Animal Scale", "code": "Livestock/Animal Scale" }, { "name": "Shipping Scale", "code": "Shipping Scale" }, { "name": "RMFD Meter", "code": "RMFD Meter" }, { "name": "Blend Only", "code": "Blend Only" }, { "name": "Compressed Natural Gas (CNG)", "code": "Compressed Natural Gas (CNG)" }, { "name": "Diesel Exhaust Fluid (DEF)", "code": "Diesel Exhaust Fluid (DEF)" }, { "name": "Hydrogen", "code": "Hydrogen" }, { "name": "Vehicle Tank Meter", "code": "Vehicle Tank Meter" }, { "name": "Bulk Rack Meter", "code": "Bulk Rack Meter" }, { "name": "LPG Meter", "code": "LPG Meter" }, { "name": "Agri-Chemical Meter", "code": "Agri-Chemical Meter" }, { "name": "Linear Measure/Device", "code": "Linear Measure/Device" }, { "name": "Farm Milk Tanks", "code": "Farm Milk Tanks" }, { "name": "Timing Devices", "code": "Timing Devices" }, { "name": "Electric Car Charging Station", "code": "Electric Car Charging Station" }, { "name": "Taxi Meter", "code": "Taxi Meter" }, { "name": "Prepack Scale", "code": "Prepack Scale" }, { "name": "Other Non-commercial Devices", "code": "Other Non-commercial Devices" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 50, "domain": null }, { "name": "SiteType", "type": "esriFieldTypeString", "alias": "Site Type", "length": 255, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_367", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_367", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S4_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "HopperScaleTest", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "ReinspectionOrRepairs", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 2, "name": "massFlowMeterTest", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "ScaleTests", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "priceVerificationTest", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "ObservedTests", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "PumpTests", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "skimmerCheck", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "ComplaintsReceived", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "AuditPackTest", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "loadingRackTest", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645217972000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "df1e411da35243ef85d223365c03d74a" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "AuditPackSubtest", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "productDescription", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "productDescription", "type": "esriFieldTypeString", "alias": "Product Desc., Lot Code, Unit Price", "length": 50, "domain": { "type": "codedValue", "name": "PackageTypes", "description": "Audit Package Types", "codedValues": [ { "name": "Meat", "code": "Meat" }, { "name": "Produce", "code": "Produce" }, { "name": "Feed/Seed", "code": "Feed/Seed" }, { "name": "Misc.", "code": "Misc." } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "tare", "type": "esriFieldTypeDouble", "alias": "Tare", "domain": null }, { "name": "labeledWtorPrice", "type": "esriFieldTypeDouble", "alias": "Labeled Weight or Price", "domain": null }, { "name": "packageError", "type": "esriFieldTypeDouble", "alias": "Package Error", "domain": null }, { "name": "mavDimless", "type": "esriFieldTypeDouble", "alias": "MAV (dimensionless)", "domain": null }, { "name": "positiveCheck", "type": "esriFieldTypeSmallInteger", "alias": "Positive Check", "domain": null }, { "name": "negativeCheck", "type": "esriFieldTypeSmallInteger", "alias": "Negative Check", "domain": null }, { "name": "recordedWeightOrPrice", "type": "esriFieldTypeDouble", "alias": "Recorded Weight Or Price", "domain": null } ], "indexes": [ { "name": "UUID_276", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G374Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_276", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "AuditPackTest", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218615000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "AuditPackTest", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "productBrandIdentity", "type": "esriFieldTypeString", "alias": "Product/Brand Identity", "length": 50, "domain": null }, { "name": "lotCodes", "type": "esriFieldTypeString", "alias": "Lot Codes", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "containerDescription", "type": "esriFieldTypeString", "alias": "Container Description", "length": 250, "domain": null }, { "name": "measurementUnits", "type": "esriFieldTypeString", "alias": "Measurement Units", "length": 50, "domain": null }, { "name": "inspectionLotSize", "type": "esriFieldTypeSmallInteger", "alias": "Inspection Lot Size", "domain": null }, { "name": "sampleSize", "type": "esriFieldTypeSmallInteger", "alias": "Sample Size (n)", "domain": null }, { "name": "initialTareSampleSize", "type": "esriFieldTypeSmallInteger", "alias": "Init. Tare Sample Size", "domain": null }, { "name": "numberofMAVAllowed", "type": "esriFieldTypeSmallInteger", "alias": "Number of MAVs Allowed", "domain": null }, { "name": "rangeOfPackageERrors", "type": "esriFieldTypeSmallInteger", "alias": "Range of Package Errors (Rc)", "domain": null }, { "name": "rangeOfTareWeights", "type": "esriFieldTypeSmallInteger", "alias": "Range of Tare Weights (Rt)", "domain": null }, { "name": "rcDivrt", "type": "esriFieldTypeDouble", "alias": "Rc / Rt", "domain": null }, { "name": "avgTareWt", "type": "esriFieldTypeDouble", "alias": "Avg. Tare Wt.", "domain": null }, { "name": "nomialGrossWt", "type": "esriFieldTypeDouble", "alias": "Nominal Gross Wt", "domain": null }, { "name": "totalError", "type": "esriFieldTypeDouble", "alias": "Total Error", "domain": null }, { "name": "numberOfUnreasonableMinusErrors", "type": "esriFieldTypeSmallInteger", "alias": "Number of Unreasonable Minus (-) Errors", "domain": null }, { "name": "box16GTbox8", "type": "esriFieldTypeSmallInteger", "alias": "Number of Unreasonable Minus Errors > # MAVs Allowed?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AvgErrorinDimlessUnits", "type": "esriFieldTypeDouble", "alias": "Avg. Error in Dimensionless Units", "domain": null }, { "name": "avgErrorInLabeledUnits", "type": "esriFieldTypeDouble", "alias": "Avg. Error in Labeled Units", "domain": null }, { "name": "sampleStandardDeviation", "type": "esriFieldTypeDouble", "alias": "Sample Standard Deviation", "domain": null }, { "name": "sampleCorrectionFactor", "type": "esriFieldTypeDouble", "alias": "Sample Correction Factor", "domain": null }, { "name": "sampleErrorLimit", "type": "esriFieldTypeDouble", "alias": "Sample Error Limit", "domain": null }, { "name": "box18GTbox23", "type": "esriFieldTypeSmallInteger", "alias": "Disregarding Signs, is Avg. Error in Dimless Units > Sample Error Limit?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dispositionOfInspectionLot", "type": "esriFieldTypeString", "alias": "Disposition of Inspection Lot", "length": 50, "domain": { "type": "codedValue", "name": "ActionTaken", "description": "Gasoline Pump Action Taken", "codedValues": [ { "name": "Approve", "code": "APP" }, { "name": "Reject", "code": "REJ" }, { "name": "Condemned", "code": "CDM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 4000, "domain": null }, { "name": "countMinusErrors", "type": "esriFieldTypeSmallInteger", "alias": "Count of Minus Errors", "domain": null }, { "name": "countPlusErrors", "type": "esriFieldTypeSmallInteger", "alias": "Count of Plus Errors", "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator's Email", "length": 50, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "box18EqualZeroOrPlus", "type": "esriFieldTypeDouble", "alias": "Box 18 Equal Zero Or Plus", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "tareStandardizationType", "type": "esriFieldTypeString", "alias": "Tare Standardization Type", "length": 50, "domain": { "type": "codedValue", "name": "TareStandardizationType", "description": "Tare Standardization Types", "codedValues": [ { "name": "Tare Correction", "code": "Tare Correction" }, { "name": "Moisture Allowance", "code": "Moisture Allowance" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "tareWeightType", "type": "esriFieldTypeString", "alias": "Tare Weight Type", "length": 50, "domain": { "type": "codedValue", "name": "TareWeightType", "description": "Tare Weight Types", "codedValues": [ { "name": "Dry Tare", "code": "Dry" }, { "name": "Wet Tare", "code": "Wet" }, { "name": "Unused Dry Tare", "code": "Unused" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "measurementDivisions", "type": "esriFieldTypeDouble", "alias": "Measurement Divisions", "domain": null }, { "name": "samplesToTake", "type": "esriFieldTypeInteger", "alias": "Samples to Take", "domain": null }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 1000, "domain": null } ], "indexes": [ { "name": "UUID_308", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G406guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_308", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "AuditPackSubtest", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 9, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645219076000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "ComplaintsReceived", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company", "length": 200, "domain": null }, { "name": "dateReceived", "type": "esriFieldTypeDate", "alias": "Date Received", "length": 8, "domain": null }, { "name": "resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 4000, "domain": null }, { "name": "dateResolved", "type": "esriFieldTypeDate", "alias": "Date Resolved", "length": 8, "domain": null }, { "name": "Contacted", "type": "esriFieldTypeString", "alias": "Contacted", "length": 50, "domain": null }, { "name": "Title", "type": "esriFieldTypeString", "alias": "Title", "length": 50, "domain": null }, { "name": "Device", "type": "esriFieldTypeString", "alias": "Device", "length": 50, "domain": null }, { "name": "CompType", "type": "esriFieldTypeString", "alias": "Complaint Type", "length": 50, "domain": { "type": "codedValue", "name": "CompType", "description": "Complaint Types", "codedValues": [ { "name": "Motor-Fuel", "code": "Motor-Fuel" }, { "name": "Home Heating Fuel", "code": "Home Heating Fuel" }, { "name": "Price Errors", "code": "Price Errors" }, { "name": "Advertising", "code": "Advertising" }, { "name": "Fuel Quality", "code": "Fuel Quality" }, { "name": "Other Devices", "code": "Other Devices" }, { "name": "Scale Complaints", "code": "Scale Complaints" }, { "name": "Shortweight/Measure/Count", "code": "Shortweight/Measure/Count" }, { "name": "Other Complaints", "code": "Other Complaints" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "complainReceivedByName", "type": "esriFieldTypeString", "alias": "Complaint Contact", "length": 50, "domain": null }, { "name": "complainReceivedByAdd", "type": "esriFieldTypeString", "alias": "Complaint Address", "length": 50, "domain": null }, { "name": "complainReceivedByPhone", "type": "esriFieldTypeString", "alias": "Complaint Phone", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "reason", "type": "esriFieldTypeString", "alias": "Reason", "length": 200, "domain": null }, { "name": "findings", "type": "esriFieldTypeString", "alias": "Findings", "length": 200, "domain": null }, { "name": "action", "type": "esriFieldTypeString", "alias": "Action", "length": 200, "domain": null } ], "indexes": [ { "name": "UUID_303", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G401guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_303", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645219129000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "hopperAggregateTests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "WeightA", "type": "esriFieldTypeDouble", "alias": "Weight", "domain": null }, { "name": "Requested", "type": "esriFieldTypeDouble", "alias": "Requested", "domain": null }, { "name": "Delivered", "type": "esriFieldTypeDouble", "alias": "Delivered", "domain": null }, { "name": "DifferenceA", "type": "esriFieldTypeDouble", "alias": "Difference", "domain": null }, { "name": "scaleDivisionsA", "type": "esriFieldTypeString", "alias": "Scale Divisions A", "length": 50, "domain": null } ], "indexes": [ { "name": "UUID_315", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G413Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_315", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "HopperScaleTest", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645219174000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "hopperCementTests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guidg", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "WeightC", "type": "esriFieldTypeDouble", "alias": "Weight", "domain": null }, { "name": "Total", "type": "esriFieldTypeDouble", "alias": "Total", "domain": null }, { "name": "DifferenceC", "type": "esriFieldTypeDouble", "alias": "Difference", "domain": null }, { "name": "scaleDivisionsC", "type": "esriFieldTypeString", "alias": "Scale Divisions A", "length": 50, "domain": null } ], "indexes": [ { "name": "UUID_266", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G364Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_266", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "HopperScaleTest", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645219188000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 6, "name": "HopperScaleTest", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MFG", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "Capacity", "type": "esriFieldTypeDouble", "alias": "Capacity", "domain": null }, { "name": "GradSize", "type": "esriFieldTypeDouble", "alias": "Grad Size", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 4000, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator's Email", "length": 50, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "passFail", "type": "esriFieldTypeString", "alias": "Pass/Fail", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass/Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 1000, "domain": null }, { "name": "ScaleType", "type": "esriFieldTypeString", "alias": "Scale Type", "length": 255, "domain": { "type": "codedValue", "name": "StateScaleTypes", "description": "State Scale Types", "codedValues": [ { "name": "Computing Scale", "code": "Computing Scale" }, { "name": "Counter/Bench Scale Non-computing =<500", "code": "Counter/Bench Scale Non-computing =<500" }, { "name": "Platform/Floor Scale <= 5000lbs", "code": "Platform/Floor Scale <= 5000lbs" }, { "name": "Other Platform > 5000lbs", "code": "Other Platform > 5000lbs" }, { "name": "Monorail Scale", "code": "Monorail Scale" }, { "name": "Grain Test Scale", "code": "Grain Test Scale" }, { "name": "Hopper/Batch/Tank Scale", "code": "Hopper/Batch/Tank Scale" }, { "name": "Point-of-Sale System w/Scale", "code": "Point-of-Sale System w/Scale" }, { "name": "Misc/Customer Scale", "code": "Misc/Customer Scale" }, { "name": "Precious Metals/Jewelry", "code": "Precious Metals/Jewelry" }, { "name": "On-Board Weighing Systems", "code": "On-Board Weighing Systems" }, { "name": "Vehicle Scale", "code": "Vehicle Scale" }, { "name": "Livestock/Animal Scale", "code": "Livestock/Animal Scale" }, { "name": "Shipping Scale", "code": "Shipping Scale" }, { "name": "Other Non-commercial Devices", "code": "Other Non-commercial Devices" }, { "name": "LPG Meter", "code": "LPG Meter" }, { "name": "Vehicle Tank Meter", "code": "Vehicle Tank Meter" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "UUID_314", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G412Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_314", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "hopperCementTests", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 13, "name": "hopperAggregateTests", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 0, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645219204000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "loadingRackSubTests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "liquidBrandName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "liquidBrandName", "type": "esriFieldTypeString", "alias": "Liquid (Brand Name)", "length": 50, "domain": null }, { "name": "meterReading", "type": "esriFieldTypeDouble", "alias": "Meter Reading", "domain": null }, { "name": "tempCompUnComp", "type": "esriFieldTypeDouble", "alias": "Temp. Comp/Un Comp", "domain": null }, { "name": "netMeterReading", "type": "esriFieldTypeDouble", "alias": "Net Meter Reading", "domain": null }, { "name": "proverGross", "type": "esriFieldTypeDouble", "alias": "Prover Gross", "domain": null }, { "name": "proverTemp", "type": "esriFieldTypeDouble", "alias": "Prover Temp", "domain": null }, { "name": "Diff", "type": "esriFieldTypeDouble", "alias": "Diff.", "domain": null }, { "name": "correctedProver", "type": "esriFieldTypeDouble", "alias": "Corrected Prover", "domain": null }, { "name": "proverNet", "type": "esriFieldTypeDouble", "alias": "Prover Net", "domain": null }, { "name": "errorGallon", "type": "esriFieldTypeDouble", "alias": "Error Gallon", "domain": null }, { "name": "errorinCuInPlusMinus", "type": "esriFieldTypeDouble", "alias": "Error in Cu. In. (Indicate Plus/Minus)", "domain": null } ], "indexes": [ { "name": "UUID_262", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G360Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_262", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "loadingRackTest", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645219307000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "loadingRackTest", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "makeOfMeter", "type": "esriFieldTypeString", "alias": "Make of Meter", "length": 50, "domain": null }, { "name": "meterSerialNumber", "type": "esriFieldTypeString", "alias": "Meter Serial Number", "length": 50, "domain": null }, { "name": "meterSealAsFound", "type": "esriFieldTypeString", "alias": "Meter Seal As Found", "length": 50, "domain": { "type": "codedValue", "name": "SealType", "description": "Register/Make of Register Seal types", "codedValues": [ { "name": "State", "code": "State" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "meterConditionOfSeal", "type": "esriFieldTypeString", "alias": "Condition of Seal", "length": 50, "domain": { "type": "codedValue", "name": "SealCondition", "description": "Condition of seal", "codedValues": [ { "name": "Intact", "code": "Intact" }, { "name": "Broke", "code": "Broken" }, { "name": "Missing", "code": "Missing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "makeOfRegister", "type": "esriFieldTypeString", "alias": "Make of Register", "length": 50, "domain": null }, { "name": "registerSerialNumber", "type": "esriFieldTypeString", "alias": "Register Serial Number", "length": 50, "domain": null }, { "name": "registerSealAsFound", "type": "esriFieldTypeString", "alias": "Register Seal As Found", "length": 50, "domain": { "type": "codedValue", "name": "SealType", "description": "Register/Make of Register Seal types", "codedValues": [ { "name": "State", "code": "State" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "registerConditionOfSeal", "type": "esriFieldTypeString", "alias": "Register Condition of Seal", "length": 50, "domain": { "type": "codedValue", "name": "SealCondition", "description": "Condition of seal", "codedValues": [ { "name": "Intact", "code": "Intact" }, { "name": "Broke", "code": "Broken" }, { "name": "Missing", "code": "Missing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "totalizerReadingAsFound", "type": "esriFieldTypeString", "alias": "Totalizer Reading as Found", "length": 50, "domain": null }, { "name": "totalizerReadingAsLeft", "type": "esriFieldTypeString", "alias": "Totalizer Reading as Left", "length": 50, "domain": null }, { "name": "antiDrainValueFunctioning", "type": "esriFieldTypeSmallInteger", "alias": "Antidrain Value Functioning", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "recheck", "type": "esriFieldTypeSmallInteger", "alias": "Recheck", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "actionTaken", "type": "esriFieldTypeString", "alias": "Action Taken", "length": 50, "domain": { "type": "codedValue", "name": "ActionTaken", "description": "Gasoline Pump Action Taken", "codedValues": [ { "name": "Approve", "code": "APP" }, { "name": "Reject", "code": "REJ" }, { "name": "Condemned", "code": "CDM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "stateWeightsAndMeasuresInspecto", "type": "esriFieldTypeString", "alias": "State Weights & Measures Inspector", "length": 50, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator's Email", "length": 50, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "testNum", "type": "esriFieldTypeString", "alias": "Test Num.", "length": 50, "domain": null }, { "name": "permitNum", "type": "esriFieldTypeString", "alias": "Permit No.", "length": 50, "domain": null }, { "name": "truckNum", "type": "esriFieldTypeString", "alias": "Truck No.", "length": 50, "domain": null }, { "name": "productTradeName", "type": "esriFieldTypeString", "alias": "Product Trade Name", "length": 50, "domain": null }, { "name": "stateIdNum", "type": "esriFieldTypeString", "alias": "State ID No.", "length": 50, "domain": null }, { "name": "ccNum", "type": "esriFieldTypeString", "alias": "CC #", "length": 50, "domain": null }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 4000, "domain": null }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 4000, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "ScaleType", "type": "esriFieldTypeString", "alias": "Scale Type", "length": 255, "domain": { "type": "codedValue", "name": "StateScaleTypes", "description": "State Scale Types", "codedValues": [ { "name": "Computing Scale", "code": "Computing Scale" }, { "name": "Counter/Bench Scale Non-computing =<500", "code": "Counter/Bench Scale Non-computing =<500" }, { "name": "Platform/Floor Scale <= 5000lbs", "code": "Platform/Floor Scale <= 5000lbs" }, { "name": "Other Platform > 5000lbs", "code": "Other Platform > 5000lbs" }, { "name": "Monorail Scale", "code": "Monorail Scale" }, { "name": "Grain Test Scale", "code": "Grain Test Scale" }, { "name": "Hopper/Batch/Tank Scale", "code": "Hopper/Batch/Tank Scale" }, { "name": "Point-of-Sale System w/Scale", "code": "Point-of-Sale System w/Scale" }, { "name": "Misc/Customer Scale", "code": "Misc/Customer Scale" }, { "name": "Precious Metals/Jewelry", "code": "Precious Metals/Jewelry" }, { "name": "On-Board Weighing Systems", "code": "On-Board Weighing Systems" }, { "name": "Vehicle Scale", "code": "Vehicle Scale" }, { "name": "Livestock/Animal Scale", "code": "Livestock/Animal Scale" }, { "name": "Shipping Scale", "code": "Shipping Scale" }, { "name": "Other Non-commercial Devices", "code": "Other Non-commercial Devices" }, { "name": "LPG Meter", "code": "LPG Meter" }, { "name": "Vehicle Tank Meter", "code": "Vehicle Tank Meter" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "UUID_287", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G385Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_287", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "loadingRackSubTests", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 10, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645219307000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "massFlowMeterSubTest", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Time", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "TestNo", "type": "esriFieldTypeSmallInteger", "alias": "Test Number", "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 50, "domain": null }, { "name": "flowRate", "type": "esriFieldTypeDouble", "alias": "Flow Rate", "domain": null }, { "name": "Gross", "type": "esriFieldTypeDouble", "alias": "Gross", "domain": null }, { "name": "Tare", "type": "esriFieldTypeDouble", "alias": "Tare", "domain": null }, { "name": "scaleError", "type": "esriFieldTypeDouble", "alias": "Scale Error", "domain": null }, { "name": "Net", "type": "esriFieldTypeDouble", "alias": "Net", "domain": null }, { "name": "meterReading", "type": "esriFieldTypeDouble", "alias": "Meter Reading", "domain": null }, { "name": "Difference", "type": "esriFieldTypeDouble", "alias": "Difference", "domain": null }, { "name": "pcntError", "type": "esriFieldTypeDouble", "alias": "% Error", "domain": null }, { "name": "passFail", "type": "esriFieldTypeString", "alias": "Pass/Fail", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass/Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "productNumber", "type": "esriFieldTypeString", "alias": "Product Number", "length": 50, "domain": null }, { "name": "bayNum", "type": "esriFieldTypeString", "alias": "Bay Number", "length": 50, "domain": null } ], "indexes": [ { "name": "UUID_274", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G372Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_274", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "massFlowMeterTest", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218972000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "massFlowMeterTest", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator Email", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 4000, "domain": null }, { "name": "TypeOfProduct", "type": "esriFieldTypeString", "alias": "Type of Product", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "AccuracyClass", "type": "esriFieldTypeString", "alias": "Accuracy Class", "length": 50, "domain": null }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "passFail", "type": "esriFieldTypeString", "alias": "Pass/Fail", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass/Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "UUID_339", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G437Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_339", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "massFlowMeterSubTest", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 2, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218971000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "ObservedTests", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspectionType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "guid", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "ServiceCompany", "type": "esriFieldTypeString", "alias": "Service Company", "length": 100, "domain": null }, { "name": "ServiceTech", "type": "esriFieldTypeString", "alias": "Service Technician", "length": 100, "domain": null }, { "name": "StateID", "type": "esriFieldTypeString", "alias": "State ID#", "length": 50, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator Email", "length": 50, "domain": null }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Checked", "type": "esriFieldTypeSmallInteger", "alias": "Checked?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sealed", "type": "esriFieldTypeSmallInteger", "alias": "Sealed?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "outOfTolerance", "type": "esriFieldTypeSmallInteger", "alias": "Out of Tolerance?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "retest", "type": "esriFieldTypeSmallInteger", "alias": "Requires Re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspectionType", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 50, "domain": { "type": "codedValue", "name": "ObservedInspections", "description": "Observed Inspection Types", "codedValues": [ { "name": "Automatic Weighing Systems", "code": "Automatic Weighing Systems" }, { "name": "Compressed Natural Gas (CNG)", "code": "Compressed Natural Gas (CNG)" }, { "name": "Other Platform > 5000lbs.", "code": "Other Platform > 5000lbs." }, { "name": "Hydrogen", "code": "Hydrogen" }, { "name": "LPG Meter", "code": "LPG Meter" }, { "name": "Linear Measure/Device", "code": "Linear Measure/Device" }, { "name": "Timing Devices", "code": "Timing Devices" }, { "name": "Electric Car Charging Station", "code": "Electric Car Charging Station" }, { "name": "Taxi Meter", "code": "Taxi Meter" }, { "name": "Other Non-commercial Devices", "code": "Other Non-commercial Devices" }, { "name": "Hopper", "code": "Hopper" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 4000, "domain": null }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 1000, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_338", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G436guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_338", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218970000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 12, "name": "priceVerificationSubtests", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Location", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Item", "type": "esriFieldTypeString", "alias": "Item", "length": 50, "domain": null }, { "name": "Listed", "type": "esriFieldTypeDouble", "alias": "Listed", "domain": null }, { "name": "Charged", "type": "esriFieldTypeDouble", "alias": "Charged", "domain": null }, { "name": "Difference", "type": "esriFieldTypeDouble", "alias": "Plus", "domain": null } ], "indexes": [ { "name": "UUID_283", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G381Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_283", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "priceVerificationTest", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218967000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 13, "name": "priceVerificationTest", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator's Email", "length": 50, "domain": null }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 4000, "domain": null }, { "name": "Score", "type": "esriFieldTypeDouble", "alias": "Score", "domain": null }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 1000, "domain": null } ], "indexes": [ { "name": "UUID_326", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G424Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_326", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "priceVerificationSubtests", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 4, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218967000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 14, "name": "PumpSubtests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PumpNumber", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "PumpNumber", "type": "esriFieldTypeString", "alias": "Pump #", "length": 50, "domain": null }, { "name": "ProductKey", "type": "esriFieldTypeSmallInteger", "alias": "Product Key", "domain": { "type": "codedValue", "name": "ProductKey", "description": "Gasoline Pump Product Key", "codedValues": [ { "name": "Gasoline", "code": 1 }, { "name": "Diesel Fuel", "code": 2 }, { "name": "Kerosene", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "N", "type": "esriFieldTypeString", "alias": "N", "length": 50, "domain": null }, { "name": "S", "type": "esriFieldTypeString", "alias": "S", "length": 50, "domain": null }, { "name": "ProverReadingPlusCubicIn", "type": "esriFieldTypeDouble", "alias": "Prover Reading Cubic In. (+)", "domain": null }, { "name": "ProverReadingMinusCubicIn", "type": "esriFieldTypeDouble", "alias": "ProverReading Cubic In. (-)", "domain": null }, { "name": "ActionTaken", "type": "esriFieldTypeString", "alias": "Action Taken", "length": 50, "domain": { "type": "codedValue", "name": "ActionTaken", "description": "Gasoline Pump Action Taken", "codedValues": [ { "name": "Approve", "code": "APP" }, { "name": "Reject", "code": "REJ" }, { "name": "Condemned", "code": "CDM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SealBroken", "type": "esriFieldTypeSmallInteger", "alias": "Seal Broken", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 4000, "domain": null }, { "name": "TotalGallons", "type": "esriFieldTypeString", "alias": "Total Gallons", "length": 50, "domain": null }, { "name": "Amount", "type": "esriFieldTypeString", "alias": "Amount", "length": 50, "domain": null }, { "name": "PumpMeetsAllTolerances", "type": "esriFieldTypeSmallInteger", "alias": "Pump Meets All Tolerances", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pumpFuelType", "type": "esriFieldTypeString", "alias": "Pump Fuel Type", "length": 50, "domain": { "type": "codedValue", "name": "FuelType", "description": "Fuel Type", "codedValues": [ { "name": "Regular", "code": "Regular" }, { "name": "Blend", "code": "Blend" }, { "name": "Diesel", "code": "Diesel" }, { "name": "Kerosene", "code": "Kerosene" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Octane", "type": "esriFieldTypeString", "alias": "Octane", "length": 50, "domain": { "type": "codedValue", "name": "OctaneTypes", "description": "Fuel octane types", "codedValues": [ { "name": "87", "code": "87" }, { "name": "89", "code": "89" }, { "name": "93", "code": "93" }, { "name": "E85", "code": "E85" }, { "name": "Diesel", "code": "Diesel" }, { "name": "DEF", "code": "DEF" }, { "name": "E15", "code": "E15" }, { "name": "88", "code": "88" }, { "name": "91", "code": "91" }, { "name": "92", "code": "92" }, { "name": "Blend", "code": "Blend" }, { "name": "Racing Fuel", "code": "Racing Fuel" }, { "name": "K-1", "code": "K-1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PricePerGallon", "type": "esriFieldTypeString", "alias": "Price Per Gallon", "length": 50, "domain": null }, { "name": "subtestIsARetest", "type": "esriFieldTypeSmallInteger", "alias": "Subtest is a Retest", "domain": null } ], "indexes": [ { "name": "UUID_332", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G430Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_332", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "PumpTests", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218966000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 15, "name": "PumpTests", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Inspected By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Inspected Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 500, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator Email", "length": 500, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "fuelReturnedToPropertyStorage", "type": "esriFieldTypeSmallInteger", "alias": "Fuel Returned To Property Storage", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pumpCountOutOfTolerance", "type": "esriFieldTypeInteger", "alias": "Pump Count Out Of Tolerance", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null }, { "name": "ReinpectionRequired", "type": "esriFieldTypeSmallInteger", "alias": "Reinpection Required?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "fuelType", "type": "esriFieldTypeString", "alias": "Fuel Type", "length": 50, "domain": { "type": "codedValue", "name": "FuelType", "description": "Fuel Type", "codedValues": [ { "name": "Regular", "code": "Regular" }, { "name": "Blend", "code": "Blend" }, { "name": "Diesel", "code": "Diesel" }, { "name": "Kerosene", "code": "Kerosene" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 4000, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "isARetest_", "type": "esriFieldTypeSmallInteger", "alias": "Is a Retest", "domain": null } ], "indexes": [ { "name": "UUID_271", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G369Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_271", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "PumpSubtests", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 6, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218965000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 16, "name": "ReinspectionOrRepairs", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RepairCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited On", "length": 8, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "Phone", "type": "esriFieldTypeDouble", "alias": "Phone", "domain": null }, { "name": "RepairedBy", "type": "esriFieldTypeString", "alias": "Repaired By", "length": 50, "domain": null }, { "name": "RepairCompanyName", "type": "esriFieldTypeString", "alias": "Repair Company Name", "length": 50, "domain": null }, { "name": "RepairCompanyAddress", "type": "esriFieldTypeString", "alias": "Repair Company Address", "length": 50, "domain": null }, { "name": "RepairCompanyPhone", "type": "esriFieldTypeString", "alias": "Repair Company Phone", "length": 50, "domain": null }, { "name": "reinspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Reinspection", "length": 8, "domain": null } ], "indexes": [ { "name": "UUID_285", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G383Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_285", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218964000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 17, "name": "ScalePerformanceTests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "Phone", "type": "esriFieldTypeDouble", "alias": "Phone", "domain": null }, { "name": "TestD", "type": "esriFieldTypeDouble", "alias": "Test D", "domain": null }, { "name": "TestLoad", "type": "esriFieldTypeDouble", "alias": "Test Load", "domain": null }, { "name": "ErrorInD", "type": "esriFieldTypeDouble", "alias": "Error In D", "domain": null }, { "name": "Error", "type": "esriFieldTypeDouble", "alias": "Error", "domain": null } ], "indexes": [ { "name": "UUID_340", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G438Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_340", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 19, "name": "ScaleTests", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218962000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "ScaleShiftCapacityTests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited On", "length": 8, "domain": null }, { "name": "Shift1Load", "type": "esriFieldTypeDouble", "alias": "Shift 1 Load", "domain": null }, { "name": "Shift1Error", "type": "esriFieldTypeDouble", "alias": "Shift 1 Error", "domain": null }, { "name": "Shift2Load", "type": "esriFieldTypeDouble", "alias": "Shift 2 Load", "domain": null }, { "name": "Shift2Error", "type": "esriFieldTypeDouble", "alias": "Shift 2 Error", "domain": null }, { "name": "Shift3Load", "type": "esriFieldTypeDouble", "alias": "Shift 3 Load", "domain": null }, { "name": "Shift3Error", "type": "esriFieldTypeDouble", "alias": "Shift 3 Error", "domain": null }, { "name": "Shift4Load", "type": "esriFieldTypeDouble", "alias": "Shift 4 Load", "domain": null }, { "name": "Shift4Error", "type": "esriFieldTypeDouble", "alias": "Shift 4 Error", "domain": null }, { "name": "Shift1Reading", "type": "esriFieldTypeDouble", "alias": "Shift 1 Reading", "domain": null }, { "name": "Shift1ErrorInD", "type": "esriFieldTypeDouble", "alias": "Shift 1 Error In D", "domain": null }, { "name": "Shift2Reading", "type": "esriFieldTypeDouble", "alias": "Shift 2 Reading", "domain": null }, { "name": "Shift2ErrorInD", "type": "esriFieldTypeDouble", "alias": "Shift 2 Error In D", "domain": null }, { "name": "Shift3Reading", "type": "esriFieldTypeDouble", "alias": "Shift 3 Reading", "domain": null }, { "name": "Shift3ErrorInD", "type": "esriFieldTypeDouble", "alias": "Shift 3 Error In D", "domain": null }, { "name": "Shift4Reading", "type": "esriFieldTypeDouble", "alias": "Shift 4 Reading", "domain": null }, { "name": "Shift4ErrorInD", "type": "esriFieldTypeDouble", "alias": "Shift 4 Error In D", "domain": null } ], "indexes": [ { "name": "UUID_297", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G395Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_297", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 20, "name": "ScaleTests", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218961000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 19, "name": "ScaleTests", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Record Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Record Created On", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator's Email", "length": 50, "domain": null }, { "name": "TestType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ScaleType", "type": "esriFieldTypeString", "alias": "Scale Type", "length": 50, "domain": { "type": "codedValue", "name": "StateScaleTypes", "description": "State Scale Types", "codedValues": [ { "name": "Computing Scale", "code": "Computing Scale" }, { "name": "Counter/Bench Scale Non-computing =<500", "code": "Counter/Bench Scale Non-computing =<500" }, { "name": "Platform/Floor Scale <= 5000lbs", "code": "Platform/Floor Scale <= 5000lbs" }, { "name": "Other Platform > 5000lbs", "code": "Other Platform > 5000lbs" }, { "name": "Monorail Scale", "code": "Monorail Scale" }, { "name": "Grain Test Scale", "code": "Grain Test Scale" }, { "name": "Hopper/Batch/Tank Scale", "code": "Hopper/Batch/Tank Scale" }, { "name": "Point-of-Sale System w/Scale", "code": "Point-of-Sale System w/Scale" }, { "name": "Misc/Customer Scale", "code": "Misc/Customer Scale" }, { "name": "Precious Metals/Jewelry", "code": "Precious Metals/Jewelry" }, { "name": "On-Board Weighing Systems", "code": "On-Board Weighing Systems" }, { "name": "Vehicle Scale", "code": "Vehicle Scale" }, { "name": "Livestock/Animal Scale", "code": "Livestock/Animal Scale" }, { "name": "Shipping Scale", "code": "Shipping Scale" }, { "name": "Other Non-commercial Devices", "code": "Other Non-commercial Devices" }, { "name": "LPG Meter", "code": "LPG Meter" }, { "name": "Vehicle Tank Meter", "code": "Vehicle Tank Meter" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Scale", "type": "esriFieldTypeString", "alias": "Scale", "length": 50, "domain": null }, { "name": "ScaleLocation", "type": "esriFieldTypeString", "alias": "Scale Location", "length": 50, "domain": null }, { "name": "MakeOfScale", "type": "esriFieldTypeString", "alias": "Make of Scale", "length": 50, "domain": null }, { "name": "ModelType", "type": "esriFieldTypeString", "alias": "Model Type", "length": 50, "domain": null }, { "name": "SerielNo", "type": "esriFieldTypeString", "alias": "Scale Seriel Number", "length": 50, "domain": null }, { "name": "Capacity", "type": "esriFieldTypeString", "alias": "Capacity", "length": 50, "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 50, "domain": null }, { "name": "NumOfD", "type": "esriFieldTypeInteger", "alias": "Number of (d)", "domain": null }, { "name": "SealCondition", "type": "esriFieldTypeString", "alias": "Seal Condition", "length": 50, "domain": { "type": "codedValue", "name": "SealCondition", "description": "Condition of seal", "codedValues": [ { "name": "Intact", "code": "Intact" }, { "name": "Broke", "code": "Broken" }, { "name": "Missing", "code": "Missing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ZeroLoadBalance", "type": "esriFieldTypeSmallInteger", "alias": "Zero Load Balance", "domain": null }, { "name": "AZSM", "type": "esriFieldTypeSmallInteger", "alias": "AZSM", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LevelCondition", "type": "esriFieldTypeSmallInteger", "alias": "Level Condition", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SupportForScale", "type": "esriFieldTypeSmallInteger", "alias": "Support For Scale", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SuitableForEnvironment", "type": "esriFieldTypeSmallInteger", "alias": "Suitable For Environment", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CustomerIndications", "type": "esriFieldTypeSmallInteger", "alias": "Customer Indications", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PrinterRequirements", "type": "esriFieldTypeSmallInteger", "alias": "Printer Requirements", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TareCapabilities", "type": "esriFieldTypeSmallInteger", "alias": "Tare Capabilities", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SRatZero", "type": "esriFieldTypeSmallInteger", "alias": "SR at Zero", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SRatMax", "type": "esriFieldTypeSmallInteger", "alias": "SR at Max", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "IncLoadTest", "type": "esriFieldTypeSmallInteger", "alias": "Inc. Load Test", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ShiftTest", "type": "esriFieldTypeSmallInteger", "alias": "Shift Test", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DecLoadTest", "type": "esriFieldTypeSmallInteger", "alias": "Dec. Load Test", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ReturnToZero", "type": "esriFieldTypeSmallInteger", "alias": "Return To Zero", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MoneyValueComps", "type": "esriFieldTypeSmallInteger", "alias": "Money Value Comps", "domain": { "type": "codedValue", "name": "ScaleRequirementApproval", "description": "Scale Requirement Approval Choices", "codedValues": [ { "name": "Does Not Meet Requirements", "code": 0 }, { "name": "Meets Requirements", "code": 1 }, { "name": "Not Applicable", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ScaleMeetsAllTolerances", "type": "esriFieldTypeSmallInteger", "alias": "Scale Meets All Tolerances", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ScaleIs", "type": "esriFieldTypeSmallInteger", "alias": "Scale Is", "domain": { "type": "codedValue", "name": "ScaleIs", "description": "'Scale is' status.", "codedValues": [ { "name": "Sealed", "code": 0 }, { "name": "Rejected for Repair", "code": 1 }, { "name": "Condemned from Use Until Repaired", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 1000, "domain": null }, { "name": "Error", "type": "esriFieldTypeSmallInteger", "alias": "Error", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ReinspectionRequired", "type": "esriFieldTypeSmallInteger", "alias": "Reinspection Required", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 4000, "domain": null } ], "indexes": [ { "name": "UUID_318", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G416Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_318", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 20, "name": "ScaleShiftCapacityTests", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 19, "name": "ScalePerformanceTests", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 3, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218961000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 20, "name": "skimmerCheck", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "TestType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "SkimmerFound", "type": "esriFieldTypeSmallInteger", "alias": "Skimmer Found", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "numOfFuelDispensers", "type": "esriFieldTypeSmallInteger", "alias": "# of Fuel Dispensers", "domain": null }, { "name": "pumpNumber", "type": "esriFieldTypeString", "alias": "Pump Number", "length": 50, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 4000, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator's Email", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?\n", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 4000, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_306", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G404Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_306", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218959000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 21, "name": "vehicleScaleAsFoundLoadCal", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "calibrationLoadAsFound", "type": "esriFieldTypeDouble", "alias": "Calibration Load As Found", "domain": null }, { "name": "calibrationWeightAsFound", "type": "esriFieldTypeDouble", "alias": "Calibration Weight As Found", "domain": null }, { "name": "calibrationTotalAsFound", "type": "esriFieldTypeDouble", "alias": "Total Weight As Found", "domain": null }, { "name": "readingAsFound", "type": "esriFieldTypeDouble", "alias": "Reading As Found", "domain": null }, { "name": "errorAsFound", "type": "esriFieldTypeDouble", "alias": "Error As Found", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null } ], "indexes": [ { "name": "UUID_316", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G414Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_316", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218942000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 22, "name": "vehicleScaleAsFoundTestReadings", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "asFoundweightApplied", "type": "esriFieldTypeDouble", "alias": "Weight Applied", "domain": null }, { "name": "asFoundReading", "type": "esriFieldTypeDouble", "alias": "Reading", "domain": null }, { "name": "asFoundError", "type": "esriFieldTypeDouble", "alias": "Error", "domain": null }, { "name": "asFoundTotal", "type": "esriFieldTypeDouble", "alias": "Total", "domain": null } ], "indexes": [ { "name": "UUID_292", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G390Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_292", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 22, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218942000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 23, "name": "vehicleScaleAsLeftLoadCal", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "errorAsLeft", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "calibrationLoadAsLeft", "type": "esriFieldTypeDouble", "alias": "Calibration Load As Left", "domain": null }, { "name": "calibrationWeightAsLeft", "type": "esriFieldTypeDouble", "alias": "Calibration Weight As Found", "domain": null }, { "name": "calibrationTotalAsLeft", "type": "esriFieldTypeDouble", "alias": "Calibration Total As Found", "domain": null }, { "name": "readingAsLeft", "type": "esriFieldTypeDouble", "alias": "Reading", "domain": null }, { "name": "errorAsLeft", "type": "esriFieldTypeString", "alias": "Error As Left", "length": 50, "domain": null } ], "indexes": [ { "name": "UUID_325", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G423Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_325", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 23, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218940000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 24, "name": "vehicleScaleAsLeftTestReadings", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "asLeftweightApplied", "type": "esriFieldTypeDouble", "alias": "Weight Applied", "domain": null }, { "name": "asLeftReading", "type": "esriFieldTypeDouble", "alias": "Reading", "domain": null }, { "name": "asLeftError", "type": "esriFieldTypeDouble", "alias": "Error", "domain": null }, { "name": "asLeftTotal", "type": "esriFieldTypeDouble", "alias": "Total", "domain": null } ], "indexes": [ { "name": "UUID_329", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G427Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_329", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 24, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218944000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 25, "name": "vehicleScaleDecreasingLoadTests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "decreasingWtApplied", "type": "esriFieldTypeDouble", "alias": "Decreasing Wt Applied", "domain": null }, { "name": "decreasingReading", "type": "esriFieldTypeDouble", "alias": "Decreasing Reading", "domain": null }, { "name": "decreasingError", "type": "esriFieldTypeDouble", "alias": "Decreasing Error", "domain": null }, { "name": "decreasingTotal", "type": "esriFieldTypeDouble", "alias": "Decreasing Total", "domain": null } ], "indexes": [ { "name": "UUID_344", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G442guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_344", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 25, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218943000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 26, "name": "vehicleScaleIncreasingLoadTests", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_user", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "increasingWtApplied", "type": "esriFieldTypeDouble", "alias": "Increasing Weight Applied", "domain": null }, { "name": "increasingReading", "type": "esriFieldTypeDouble", "alias": "Increasing Reading", "domain": null }, { "name": "increasingError", "type": "esriFieldTypeDouble", "alias": "Increasing Error", "domain": null }, { "name": "increasingTotal", "type": "esriFieldTypeDouble", "alias": "Increasing Total", "domain": null } ], "indexes": [ { "name": "UUID_290", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G388guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_290", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 26, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218941000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 27, "name": "vehicleScaleTest", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "inspCompanyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "testType", "type": "esriFieldTypeInteger", "alias": "Test Type", "domain": { "type": "codedValue", "name": "TestType", "description": "Test Type", "codedValues": [ { "name": "Routine Inspection", "code": 0 }, { "name": "Courtesy Inspection", "code": 1 }, { "name": "Complaint", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "indicatorMake", "type": "esriFieldTypeString", "alias": "Indicator Make", "length": 50, "domain": null }, { "name": "indicatorSerial", "type": "esriFieldTypeString", "alias": "Indicator Serial #", "length": 50, "domain": null }, { "name": "indicatorModelNum", "type": "esriFieldTypeString", "alias": "Indicator Model #", "length": 50, "domain": null }, { "name": "scaleCapacity", "type": "esriFieldTypeString", "alias": "Scale Capacity", "length": 50, "domain": null }, { "name": "platformMake", "type": "esriFieldTypeString", "alias": "Platform Make", "length": 50, "domain": null }, { "name": "platformSerial", "type": "esriFieldTypeString", "alias": "Platform Serial #", "length": 50, "domain": null }, { "name": "platformModelNum", "type": "esriFieldTypeString", "alias": "Platform Model #", "length": 50, "domain": null }, { "name": "CLC", "type": "esriFieldTypeString", "alias": "CLC", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 4000, "domain": null }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 50, "domain": null }, { "name": "operatorPhone", "type": "esriFieldTypeDouble", "alias": "Operator Phone", "domain": null }, { "name": "operatorEmail", "type": "esriFieldTypeString", "alias": "Operator's Email", "length": 50, "domain": null }, { "name": "inspCompanyAdd", "type": "esriFieldTypeString", "alias": "Inspection Company Address", "length": 200, "domain": null }, { "name": "inspCompanyName", "type": "esriFieldTypeString", "alias": "Inspection Company Name", "length": 200, "domain": null }, { "name": "isARetest", "type": "esriFieldTypeSmallInteger", "alias": "Test is a re-test?", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "passFail", "type": "esriFieldTypeString", "alias": "Pass/Fail", "length": 50, "domain": { "type": "codedValue", "name": "PassFail", "description": "Pass/Fail", "codedValues": [ { "name": "Pass", "code": "Pass" }, { "name": "Fail", "code": "Fail" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "establishmentType", "type": "esriFieldTypeString", "alias": "Establishment Type", "length": 50, "domain": { "type": "codedValue", "name": "ODAEstType", "description": "ODA Establisment Types", "codedValues": [ { "name": "Supermarket", "code": "Supermarket" }, { "name": "Gas/Fuel Station", "code": "Gas/Fuel Station" }, { "name": "Convenience Store", "code": "Convenience Store" }, { "name": "Farm Market", "code": "Farm Market" }, { "name": "Specialty Food Store", "code": "Specialty Food Store" }, { "name": "Specialty Non-Food Store", "code": "Specialty Non-Food Store" }, { "name": "Farms/Livestock", "code": "Farms/Livestock" }, { "name": "Hardware/Home Improvement", "code": "Hardware/Home Improvement" }, { "name": "Variety Multiple", "code": "Variety Multiple" }, { "name": "Fuel Oil", "code": "Fuel Oil" }, { "name": "LPG", "code": "LPG" }, { "name": "Asphalt/Concrete/Quarry", "code": "Asphalt/Concrete/Quarry" }, { "name": "Salvage/Landfill", "code": "Salvage/Landfill" }, { "name": "Fabric/Sewing", "code": "Fabric/Sewing" }, { "name": "Feed, Fertilizer & Grain", "code": "Feed, Fertilizer & Grain" }, { "name": "Car Wash/Laundry/Parking", "code": "Car Wash/Laundry/Parking" }, { "name": "Shipping", "code": "Shipping" }, { "name": "Marina/Airport", "code": "Marina/Airport" }, { "name": "Bulk Fuel Rack", "code": "Bulk Fuel Rack" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Resolved", "type": "esriFieldTypeSmallInteger", "alias": "Resolved", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResolutionDate", "type": "esriFieldTypeDate", "alias": "Resolution Date", "length": 8, "domain": null }, { "name": "ResolutionComments", "type": "esriFieldTypeString", "alias": "Resolution Comments", "length": 4000, "domain": null } ], "indexes": [ { "name": "UUID_312", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G410Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_312", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 27, "name": "vehicleScaleTestSectionShiftCal", "relatedTableId": 28, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 21, "name": "vehicleScaleAsFoundLoadCal", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 24, "name": "vehicleScaleAsLeftTestReadings", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 26, "name": "vehicleScaleIncreasingLoadTests", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 23, "name": "vehicleScaleAsLeftLoadCal", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 22, "name": "vehicleScaleAsFoundTestReadings", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 25, "name": "vehicleScaleDecreasingLoadTests", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 11, "name": "InspectionSites", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218940000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 28, "name": "vehicleScaleTestSectionShiftCalibration", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "sectionNum", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edit Date", "length": 8, "domain": null }, { "name": "sectionNum", "type": "esriFieldTypeString", "alias": "Section Number", "length": 50, "domain": null }, { "name": "asFoundReading1", "type": "esriFieldTypeDouble", "alias": "As Found Reading 1", "domain": null }, { "name": "asFoundReading2", "type": "esriFieldTypeDouble", "alias": "As Found Reading 2", "domain": null }, { "name": "asFoundReading3", "type": "esriFieldTypeDouble", "alias": "As Found Reading 3", "domain": null }, { "name": "asFoundReading4", "type": "esriFieldTypeDouble", "alias": "As Found Reading 4", "domain": null }, { "name": "varianceError", "type": "esriFieldTypeDouble", "alias": "Variance/Error", "domain": null }, { "name": "tolerance", "type": "esriFieldTypeDouble", "alias": "Tolerance", "domain": null } ], "indexes": [ { "name": "UUID_336", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G434Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_336", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 27, "name": "vehicleScaleTest", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1645218648000 }, "serviceItemId": "df1e411da35243ef85d223365c03d74a" } ] }