{ "tables": [ { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "work_completed_parts_repeat", "relatedTableId": 1, "id": "1", "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "parts_repeat", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_part_onhand", "type": "codedValue", "codedValues": [ { "code": "On-hand", "name": "On-hand" }, { "code": "Purchased", "name": "Purchased" } ] }, "name": "part_onhand", "length": 255, "alias": "Was the part onhand or purchased", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pick_part_type", "length": 255, "alias": "Part Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_part_type", "length": 255, "alias": "Other Part Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "part_type", "length": 255, "alias": "part_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pick_part_size", "length": 255, "alias": "Part Size (Inches)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parts_quantity", "alias": "Quantity Used", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parts_unit_price", "alias": "Part Price Per Unit", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parts_subtotal_price", "alias": "Subtotal Price of Parts", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parts_used", "length": 255, "alias": "Part Notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_crew_p", "length": 255, "alias": "work_crew_p", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_type_p", "length": 255, "alias": "work_type_p", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "r1067_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1067", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Sync", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "" }, { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "work_completed_equipment_repeat_start", "relatedTableId": 1, "id": "2", "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "equipment_repeat_start", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_equip_class", "type": "codedValue", "codedValues": [ { "code": "12 Pressure Washer", "name": "12 Pressure Washer" }, { "code": "Arrow Board Trailer, Wanco", "name": "Arrow Board Trailer, Wanco" }, { "code": "Message Board Trailer, Wanco", "name": "Message Board Trailer, Wanco" }, { "code": "Concrete and asphalt cutter walk behind Stihl (Charged by the foot)", "name": "Concrete and asphalt cutter walk behind Stihl (Charged by the foot)" }, { "code": "181 Hydro Cleaner Truck", "name": "181 Hydro Cleaner Truck" }, { "code": "47 Hot patch Truck International", "name": "47 Hot patch Truck International" }, { "code": "71 Backhoe", "name": "71 Backhoe" }, { "code": "Kohler Hot Tapping Machine 1 inch", "name": "Kohler Hot Tapping Machine 1 inch" }, { "code": "63 Vac-Con, International", "name": "63 Vac-Con, International" }, { "code": "81 Vac-Con, Peterbilt", "name": "81 Vac-Con, Peterbilt" }, { "code": "70 Peterbilt Utility service Truck", "name": "70 Peterbilt Utility service Truck" }, { "code": "61 Vac-on International", "name": "61 Vac-on International" }, { "code": "Kohler Hot Tapping Machine 2 inch", "name": "Kohler Hot Tapping Machine 2 inch" }, { "code": "Kohler Hot Tapping Machine 6 inch and up", "name": "Kohler Hot Tapping Machine 6 inch and up" }, { "code": "Generator Small 1000Watt Honda", "name": "Generator Small 1000Watt Honda" }, { "code": "Generator Small 1700 Watt Generac", "name": "Generator Small 1700 Watt Generac" }, { "code": "Chainsaws/Stihl", "name": "Chainsaws/Stihl" }, { "code": "Blowers/Stihl", "name": "Blowers/Stihl" }, { "code": "String Trimmers/Stihl", "name": "String Trimmers/Stihl" }, { "code": "Pole Saw/Stihl", "name": "Pole Saw/Stihl" }, { "code": "Hedge Trimmer/Stihl", "name": "Hedge Trimmer/Stihl" }, { "code": "Asphalt Cutter, Walk behind/Stihl", "name": "Asphalt Cutter, Walk behind/Stihl" }, { "code": "4015 Vibraplate, Wacker Meuson", "name": "4015 Vibraplate, Wacker Meuson" }, { "code": "Jumping Jack/Compactor, Mikasa", "name": "Jumping Jack/Compactor, Mikasa" }, { "code": "Viber plate Wacker", "name": "Viber plate Wacker" }, { "code": "Generator Small 4200 Watt Generac", "name": "Generator Small 4200 Watt Generac" }, { "code": "Generator Small 3000 Watt Honda", "name": "Generator Small 3000 Watt Honda" }, { "code": "Generator Small 5000 Watt Honda, In 171 Service Van", "name": "Generator Small 5000 Watt Honda, In 171 Service Van" }, { "code": "Generator Small 7000 Watt Honda, on 118 CCTV Trailer", "name": "Generator Small 7000 Watt Honda, on 118 CCTV Trailer" }, { "code": "5219 Honda 3000 Generator", "name": "5219 Honda 3000 Generator" }, { "code": "5220 Honda 3000 Generator", "name": "5220 Honda 3000 Generator" }, { "code": "118 CCTV Trailer/Cues", "name": "118 CCTV Trailer/Cues" }, { "code": "182 Sewer Rodder, Screco", "name": "182 Sewer Rodder, Screco" }, { "code": "132 Flat Bed Trailer 14ft.", "name": "132 Flat Bed Trailer 14ft." }, { "code": "128 Flat Bed Trailer 12ft.", "name": "128 Flat Bed Trailer 12ft." }, { "code": "178 Flat Bed Trailer 22ft.", "name": "178 Flat Bed Trailer 22ft." }, { "code": "5121 Wacker 2\" Pump", "name": "5121 Wacker 2\" Pump" }, { "code": "5225 Honda 2\" pump", "name": "5225 Honda 2\" pump" }, { "code": "4044 Small Water Pump 425GPM, 3\"/Wacker", "name": "4044 Small Water Pump 425GPM, 3\"/Wacker" }, { "code": "5221 Water Pump 425 GPM, 3\"/Wacker", "name": "5221 Water Pump 425 GPM, 3\"/Wacker" }, { "code": "4044 Wacker 3\" pump", "name": "4044 Wacker 3\" pump" }, { "code": "5133 Wacker 3\" Pump", "name": "5133 Wacker 3\" Pump" }, { "code": "5221 Wacker 3\" Pump", "name": "5221 Wacker 3\" Pump" }, { "code": "5119 Asphalt Cutter, Blue Walk-Behind/Pro-Cut", "name": "5119 Asphalt Cutter, Blue Walk-Behind/Pro-Cut" }, { "code": "169 Asphalt Cutter, Yellow Walk-Behind/Stow", "name": "169 Asphalt Cutter, Yellow Walk-Behind/Stow" }, { "code": "1 Roller/Compactor", "name": "1 Roller/Compactor" }, { "code": "Mikasa Compactor Machine", "name": "Mikasa Compactor Machine" }, { "code": "6106 Generator Large 45Kv/Whisperwatt 36KW", "name": "6106 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6107 Generator Large 45Kv/Whisperwatt 36KW", "name": "6107 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6110 Generator Large 45Kv/Whisperwatt 36KW", "name": "6110 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6115 Generator Large 45Kv/Whisperwatt 36KW", "name": "6115 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "11 Portable Air Compressor, Sullair", "name": "11 Portable Air Compressor, Sullair" }, { "code": "113 Shoring Trailer/Shoring (Daily Rate)", "name": "113 Shoring Trailer/Shoring (Daily Rate)" }, { "code": "6113 Generator Large 70Kv/Whisperwatt 56KW", "name": "6113 Generator Large 70Kv/Whisperwatt 56KW" }, { "code": "6112 Generator Large 125Kv/Whisperwatt 100KW", "name": "6112 Generator Large 125Kv/Whisperwatt 100KW" }, { "code": "23 Service Truck, Supervisor, Dan Vit", "name": "23 Service Truck, Supervisor, Dan Vit" }, { "code": "206 Service Truck, Supervisor, Will Matcham", "name": "206 Service Truck, Supervisor, Will Matcham" }, { "code": "200 Service Truck", "name": "200 Service Truck" }, { "code": "36 Service Truck", "name": "36 Service Truck" }, { "code": "73 John Deere Gator for gate valve turning", "name": "73 John Deere Gator for gate valve turning" }, { "code": "75 Meter read van", "name": "75 Meter read van" }, { "code": "Trash Pumps Small Electric, Tsurum 53-100GPM", "name": "Trash Pumps Small Electric, Tsurum 53-100GPM" }, { "code": "6111 Trash Pump Large, Gorman-Rupp 4\"", "name": "6111 Trash Pump Large, Gorman-Rupp 4\"" }, { "code": "5227 Trash Pump Large Gorman-Rupp 6\"", "name": "5227 Trash Pump Large Gorman-Rupp 6\"" }, { "code": "6116 Pump Large Gorman-Rupp 6\"", "name": "6116 Pump Large Gorman-Rupp 6\"" }, { "code": "55 Flail Mower, John Deere", "name": "55 Flail Mower, John Deere" }, { "code": "188 Skid Steer/Case", "name": "188 Skid Steer/Case" }, { "code": "86 F-350 Service Truck", "name": "86 F-350 Service Truck" }, { "code": "57 F-350 Service Truck/Sign Truck", "name": "57 F-350 Service Truck/Sign Truck" }, { "code": "171 F-550 Service Truck", "name": "171 F-550 Service Truck" }, { "code": "157 F-350 Service Truck/Boom Truck for Pump Maintenance", "name": "157 F-350 Service Truck/Boom Truck for Pump Maintenance" }, { "code": "184 Chevy Boom Truck", "name": "184 Chevy Boom Truck" }, { "code": "78 Ford F 350 Service Truck", "name": "78 Ford F 350 Service Truck" }, { "code": "76 Ford F 350 Service Truck", "name": "76 Ford F 350 Service Truck" }, { "code": "75 International, Truck Bobtail Flat Bed", "name": "75 International, Truck Bobtail Flat Bed" }, { "code": "196 Backhoe/Caterpillar 420-D", "name": "196 Backhoe/Caterpillar 420-D" }, { "code": "74 Backhoe CAT 420-D", "name": "74 Backhoe CAT 420-D" }, { "code": "Bull Prick", "name": "Bull Prick" }, { "code": "105 F-550 Dump Truck, 3 Yard", "name": "105 F-550 Dump Truck, 3 Yard" }, { "code": "175 F-700 dump Truck, 5 Yard", "name": "175 F-700 dump Truck, 5 Yard" }, { "code": "104 F-650 dump Truck, 5 Yard", "name": "104 F-650 dump Truck, 5 Yard" }, { "code": "103 Ford F 650 Dump Truck 5Y", "name": "103 Ford F 650 Dump Truck 5Y" }, { "code": "116 Loader/John Deere 544G", "name": "116 Loader/John Deere 544G" }, { "code": "116 Loader/ John Deere 544G", "name": "116 Loader/ John Deere 544G" }, { "code": "176 International Dump Truck, 10 Yard", "name": "176 International Dump Truck, 10 Yard" }, { "code": "108 Peterbilt Dump Truck, 12 Yard", "name": "108 Peterbilt Dump Truck, 12 Yard" }, { "code": "51 Ford F 350 Service Truck", "name": "51 Ford F 350 Service Truck" }, { "code": "219 Ford F 350 Service Truck/Sign Truck", "name": "219 Ford F 350 Service Truck/Sign Truck" }, { "code": "218 Ford F 350 Service Truck", "name": "218 Ford F 350 Service Truck" }, { "code": "210 Ford F 150 Supervisor Truck", "name": "210 Ford F 150 Supervisor Truck" }, { "code": "Other", "name": "Other" } ] }, "name": "equip_class", "length": 255, "alias": "Equipment Class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equip_code", "length": 255, "alias": "Equipment Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eqip_other", "length": 255, "alias": "Describe Other Equipment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equip_class_calc", "length": 255, "alias": "equip_class_calc", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equip_time_cat", "length": 255, "alias": "Equipment Time Used", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_regular", "length": 255, "alias": "Equipment Cost Regular", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_ot", "length": 255, "alias": "Equipment Cost OT", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_idle", "length": 255, "alias": "Equipment Cost Idle", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_hours_regular", "alias": "Equipment Hours Regular", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_hours_ot", "alias": "Equipment Hours OT", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_hours_idle", "alias": "Equipment Hours Idle", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_hours_regular", "length": 255, "alias": "calcequipment_hours_regular", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_hours_ot", "length": 255, "alias": "calcequipment_hours_ot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_hours_idle", "length": 255, "alias": "calcequipment_hours_idle", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_cost_regular", "length": 255, "alias": "calcequipment_cost_regular", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_cost_ot", "length": 255, "alias": "calcequipment_cost_ot", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calcequipment_cost_idle", "length": 255, "alias": "calcequipment_cost_idle", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_cost_total", "alias": "Total Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipment_note", "length": 255, "alias": "Equipment Notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_crew_e", "length": 255, "alias": "work_crew_e", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_type_e", "length": 255, "alias": "work_type_e", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "r1068_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1068", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Sync", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "" } ], "layers": [ { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": true, "relationships": [ { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "Form_3_work_completed", "relatedTableId": 1, "id": "0", "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "DailyReports_05_Water", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniquerowid", "length": 38, "alias": "RowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_date", "length": 29, "alias": "Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_work_crew", "type": "codedValue", "codedValues": [ { "code": "Sewer", "name": "Sewer" }, { "code": "Water", "name": "Water" }, { "code": "Streets", "name": "Streets" } ] }, "name": "work_crew", "length": 255, "alias": "Work Crew", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_crew_support", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "crew_support", "length": 255, "alias": "Did Personnel from Another Crew Support", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "workers_water", "length": 255, "alias": "Water Crew Workers", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "workers_sewer", "length": 255, "alias": "Sewer Crew Workers", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "workers_streets", "length": 255, "alias": "Streets Crew Workers", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_vehicle", "type": "codedValue", "codedValues": [ { "code": "12 Pressure Washer", "name": "12 Pressure Washer" }, { "code": "Arrow Board Trailer, Wanco", "name": "Arrow Board Trailer, Wanco" }, { "code": "Message Board Trailer, Wanco", "name": "Message Board Trailer, Wanco" }, { "code": "Concrete and asphalt cutter walk behind Stihl (Charged by the foot)", "name": "Concrete and asphalt cutter walk behind Stihl (Charged by the foot)" }, { "code": "181 Hydro Cleaner Truck", "name": "181 Hydro Cleaner Truck" }, { "code": "47 Hot patch Truck International", "name": "47 Hot patch Truck International" }, { "code": "71 Backhoe", "name": "71 Backhoe" }, { "code": "Kohler Hot Tapping Machine 1 inch", "name": "Kohler Hot Tapping Machine 1 inch" }, { "code": "63 Vac-Con, International", "name": "63 Vac-Con, International" }, { "code": "81 Vac-Con, Peterbilt", "name": "81 Vac-Con, Peterbilt" }, { "code": "70 Peterbilt Utility service Truck", "name": "70 Peterbilt Utility service Truck" }, { "code": "61 Vac-on International", "name": "61 Vac-on International" }, { "code": "Kohler Hot Tapping Machine 2 inch", "name": "Kohler Hot Tapping Machine 2 inch" }, { "code": "Kohler Hot Tapping Machine 6 inch and up", "name": "Kohler Hot Tapping Machine 6 inch and up" }, { "code": "Generator Small 1000Watt Honda", "name": "Generator Small 1000Watt Honda" }, { "code": "Generator Small 1700 Watt Generac", "name": "Generator Small 1700 Watt Generac" }, { "code": "Chainsaws/Stihl", "name": "Chainsaws/Stihl" }, { "code": "Blowers/Stihl", "name": "Blowers/Stihl" }, { "code": "String Trimmers/Stihl", "name": "String Trimmers/Stihl" }, { "code": "Pole Saw/Stihl", "name": "Pole Saw/Stihl" }, { "code": "Hedge Trimmer/Stihl", "name": "Hedge Trimmer/Stihl" }, { "code": "Asphalt Cutter, Walk behind/Stihl", "name": "Asphalt Cutter, Walk behind/Stihl" }, { "code": "4015 Vibraplate, Wacker Meuson", "name": "4015 Vibraplate, Wacker Meuson" }, { "code": "Jumping Jack/Compactor, Mikasa", "name": "Jumping Jack/Compactor, Mikasa" }, { "code": "Viber plate Wacker", "name": "Viber plate Wacker" }, { "code": "Generator Small 4200 Watt Generac", "name": "Generator Small 4200 Watt Generac" }, { "code": "Generator Small 3000 Watt Honda", "name": "Generator Small 3000 Watt Honda" }, { "code": "Generator Small 5000 Watt Honda, In 171 Service Van", "name": "Generator Small 5000 Watt Honda, In 171 Service Van" }, { "code": "Generator Small 7000 Watt Honda, on 118 CCTV Trailer", "name": "Generator Small 7000 Watt Honda, on 118 CCTV Trailer" }, { "code": "5219 Honda 3000 Generator", "name": "5219 Honda 3000 Generator" }, { "code": "5220 Honda 3000 Generator", "name": "5220 Honda 3000 Generator" }, { "code": "118 CCTV Trailer/Cues", "name": "118 CCTV Trailer/Cues" }, { "code": "182 Sewer Rodder, Screco", "name": "182 Sewer Rodder, Screco" }, { "code": "132 Flat Bed Trailer 14ft.", "name": "132 Flat Bed Trailer 14ft." }, { "code": "128 Flat Bed Trailer 12ft.", "name": "128 Flat Bed Trailer 12ft." }, { "code": "178 Flat Bed Trailer 22ft.", "name": "178 Flat Bed Trailer 22ft." }, { "code": "5121 Wacker 2\" Pump", "name": "5121 Wacker 2\" Pump" }, { "code": "5225 Honda 2\" pump", "name": "5225 Honda 2\" pump" }, { "code": "4044 Small Water Pump 425GPM, 3\"/Wacker", "name": "4044 Small Water Pump 425GPM, 3\"/Wacker" }, { "code": "5221 Water Pump 425 GPM, 3\"/Wacker", "name": "5221 Water Pump 425 GPM, 3\"/Wacker" }, { "code": "4044 Wacker 3\" pump", "name": "4044 Wacker 3\" pump" }, { "code": "5133 Wacker 3\" Pump", "name": "5133 Wacker 3\" Pump" }, { "code": "5221 Wacker 3\" Pump", "name": "5221 Wacker 3\" Pump" }, { "code": "5119 Asphalt Cutter, Blue Walk-Behind/Pro-Cut", "name": "5119 Asphalt Cutter, Blue Walk-Behind/Pro-Cut" }, { "code": "169 Asphalt Cutter, Yellow Walk-Behind/Stow", "name": "169 Asphalt Cutter, Yellow Walk-Behind/Stow" }, { "code": "1 Roller/Compactor", "name": "1 Roller/Compactor" }, { "code": "Mikasa Compactor Machine", "name": "Mikasa Compactor Machine" }, { "code": "6106 Generator Large 45Kv/Whisperwatt 36KW", "name": "6106 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6107 Generator Large 45Kv/Whisperwatt 36KW", "name": "6107 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6110 Generator Large 45Kv/Whisperwatt 36KW", "name": "6110 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "6115 Generator Large 45Kv/Whisperwatt 36KW", "name": "6115 Generator Large 45Kv/Whisperwatt 36KW" }, { "code": "11 Portable Air Compressor, Sullair", "name": "11 Portable Air Compressor, Sullair" }, { "code": "113 Shoring Trailer/Shoring (Daily Rate)", "name": "113 Shoring Trailer/Shoring (Daily Rate)" }, { "code": "6113 Generator Large 70Kv/Whisperwatt 56KW", "name": "6113 Generator Large 70Kv/Whisperwatt 56KW" }, { "code": "6112 Generator Large 125Kv/Whisperwatt 100KW", "name": "6112 Generator Large 125Kv/Whisperwatt 100KW" }, { "code": "23 Service Truck, Supervisor, Dan Vit", "name": "23 Service Truck, Supervisor, Dan Vit" }, { "code": "206 Service Truck, Supervisor, Will Matcham", "name": "206 Service Truck, Supervisor, Will Matcham" }, { "code": "200 Service Truck", "name": "200 Service Truck" }, { "code": "36 Service Truck", "name": "36 Service Truck" }, { "code": "73 John Deere Gator for gate valve turning", "name": "73 John Deere Gator for gate valve turning" }, { "code": "75 Meter read van", "name": "75 Meter read van" }, { "code": "Trash Pumps Small Electric, Tsurum 53-100GPM", "name": "Trash Pumps Small Electric, Tsurum 53-100GPM" }, { "code": "6111 Trash Pump Large, Gorman-Rupp 4\"", "name": "6111 Trash Pump Large, Gorman-Rupp 4\"" }, { "code": "5227 Trash Pump Large Gorman-Rupp 6\"", "name": "5227 Trash Pump Large Gorman-Rupp 6\"" }, { "code": "6116 Pump Large Gorman-Rupp 6\"", "name": "6116 Pump Large Gorman-Rupp 6\"" }, { "code": "55 Flail Mower, John Deere", "name": "55 Flail Mower, John Deere" }, { "code": "188 Skid Steer/Case", "name": "188 Skid Steer/Case" }, { "code": "86 F-350 Service Truck", "name": "86 F-350 Service Truck" }, { "code": "57 F-350 Service Truck/Sign Truck", "name": "57 F-350 Service Truck/Sign Truck" }, { "code": "171 F-550 Service Truck", "name": "171 F-550 Service Truck" }, { "code": "157 F-350 Service Truck/Boom Truck for Pump Maintenance", "name": "157 F-350 Service Truck/Boom Truck for Pump Maintenance" }, { "code": "184 Chevy Boom Truck", "name": "184 Chevy Boom Truck" }, { "code": "78 Ford F 350 Service Truck", "name": "78 Ford F 350 Service Truck" }, { "code": "76 Ford F 350 Service Truck", "name": "76 Ford F 350 Service Truck" }, { "code": "75 International, Truck Bobtail Flat Bed", "name": "75 International, Truck Bobtail Flat Bed" }, { "code": "196 Backhoe/Caterpillar 420-D", "name": "196 Backhoe/Caterpillar 420-D" }, { "code": "74 Backhoe CAT 420-D", "name": "74 Backhoe CAT 420-D" }, { "code": "Bull Prick", "name": "Bull Prick" }, { "code": "105 F-550 Dump Truck, 3 Yard", "name": "105 F-550 Dump Truck, 3 Yard" }, { "code": "175 F-700 dump Truck, 5 Yard", "name": "175 F-700 dump Truck, 5 Yard" }, { "code": "104 F-650 dump Truck, 5 Yard", "name": "104 F-650 dump Truck, 5 Yard" }, { "code": "103 Ford F 650 Dump Truck 5Y", "name": "103 Ford F 650 Dump Truck 5Y" }, { "code": "116 Loader/John Deere 544G", "name": "116 Loader/John Deere 544G" }, { "code": "116 Loader/ John Deere 544G", "name": "116 Loader/ John Deere 544G" }, { "code": "176 International Dump Truck, 10 Yard", "name": "176 International Dump Truck, 10 Yard" }, { "code": "108 Peterbilt Dump Truck, 12 Yard", "name": "108 Peterbilt Dump Truck, 12 Yard" }, { "code": "51 Ford F 350 Service Truck", "name": "51 Ford F 350 Service Truck" }, { "code": "219 Ford F 350 Service Truck/Sign Truck", "name": "219 Ford F 350 Service Truck/Sign Truck" }, { "code": "218 Ford F 350 Service Truck", "name": "218 Ford F 350 Service Truck" }, { "code": "210 Ford F 150 Supervisor Truck", "name": "210 Ford F 150 Supervisor Truck" }, { "code": "Other", "name": "Other" } ] }, "name": "vehicle", "length": 255, "alias": "Vehicle Used", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "labor_grandtotal_hours", "alias": "Total Work Hours", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parts_grandtotal_price", "alias": "Grand Total Parts", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equip_grandtotal_cost", "alias": "Grand Total Equipment", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r1065_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1065", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true }, { "name": "a654_ix1", "isUnique": false, "description": "", "fields": "shape", "isAcsending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "Survey Data Locations", "label": "DailyReports_05_Water", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "geometryType": "esriGeometryPoint" }, { "extent": { "ymin": -90, "xmin": -180, "ymax": 90, "xmax": 180, "spatialReference": {"wkid": 4326}, "type": "extent" }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": true, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "Form_3_work_completed", "relatedTableId": 0, "id": "0", "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "work_completed_parts_repeat", "relatedTableId": 2, "id": "1", "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "uniquerowid", "role": "esriRelRoleOrigin", "composite": true, "name": "work_completed_equipment_repeat_start", "relatedTableId": 3, "id": "2", "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "prototype": { "attributes": {} } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "work_completed", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniquerowid", "length": 38, "alias": "RowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_map_change", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "map_change", "length": 255, "alias": "Map Change Required", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_after_hours_call", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "after_hours_call", "length": 255, "alias": "After Hours Call", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "job_time", "alias": "Hours to Complete Job", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_type", "length": 255, "alias": "Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_galvanized_replaced", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "galvanized_replaced", "length": 255, "alias": "Were Galvanized Parts Replaced", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_sso", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "sso", "length": 255, "alias": "SSO Report", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_sso_responsibility", "type": "codedValue", "codedValues": [ { "code": "City", "name": "City" }, { "code": "Private", "name": "Private" }, { "code": "HCSD", "name": "HCSD" }, { "code": "Other", "name": "Other" } ] }, "name": "sso_responsibility", "length": 255, "alias": "SSO Responsibility", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sso_gallons", "alias": "SSO Gallons Estimate", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_description", "length": 255, "alias": "Description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_juan_velasco", "alias": "Hours Juan Velasco", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_mario_zuniga", "alias": "Hours Mario Zuniga", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_michael_williams", "alias": "Hours Michael Williams", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_noah_cuadras", "alias": "Hours Noah Cuadras", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_charles_vickrey", "alias": "Hours Charles Vickrey", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_gustavo_gomez", "alias": "Hours Gustavo Gomez", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_chad_fite", "alias": "Hours Chad Fite", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_ethan_schillinger", "alias": "Hours Ethan Schillinger", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_brandon_matias", "alias": "Hours Brandon Matias", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_brandon_balke", "alias": "Hours Brandon Balke", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_scott_peugh", "alias": "Hours Scott Peugh", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_will_matcham", "alias": "Hours Will Matcham", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_lee_perry", "alias": "Hours Lee Perry", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_fermin_velasco", "alias": "Hours Fermin Velasco", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_david_witter", "alias": "Hours David Witter", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_morgan_cruz", "alias": "Hours Morgan Cruz", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_kelly_minarcin", "alias": "Hours Kelly Minarcin", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_jim_hale", "alias": "Hours Jim Hale", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_zephir_lennox", "alias": "Hours Zephir Lennox", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_chris_armstrong", "alias": "Hours Chris Armstrong", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_tim_wilson", "alias": "Hours Tim Wilson", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_dan_smith", "alias": "Hours Dan Smith", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_robert_harig", "alias": "Hours Robert Harig", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_ron_mckay", "alias": "Hours Ron McKay", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_wade_lawson", "alias": "Hours Wade Lawson", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_mike_solinsky", "alias": "Hours Mike Solinsky", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_jeff_owsley", "alias": "Hours Jeff Owsley", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_tyler_burdick", "alias": "Hours Tyler Burdick", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_chris_miller", "alias": "Hours Chris Miller", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_steve_huck", "alias": "Hours Steve Huck", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hours_robert_kirtpatrick", "alias": "Hours Robert Kirtpatrick", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_juan_velasco", "alias": "time_juan_velasco", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_mario_zuniga", "alias": "time_mario_zuniga", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_michael_williams", "alias": "time_michael_williams", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_noah_cuadras", "alias": "time_noah_cuadras", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_charles_vickrey", "alias": "time_charles_vickrey", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_gustavo_gomez", "alias": "time_gustavo_gomez", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_chad_fite", "alias": "time_chad_fite", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_ethan_schillinger", "alias": "time_ethan_schillinger", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_brandon_matias", "alias": "time_brandon_matias", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_brandon_balke", "alias": "time_brandon_balke", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_will_matcham", "alias": "time_will_matcham", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_jim_hale", "alias": "time_jim_hale", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_lee_perry", "alias": "time_lee_perry", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_zephir_lennox", "alias": "time_zephir_lennox", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_scott_peugh", "alias": "time_scott_peugh", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_fermin_velasco", "alias": "time_fermin_velasco", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_morgan_cruz", "alias": "time_morgan_cruz", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_kelly_minarcin", "alias": "time_kelly_minarcin", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_david_witter", "alias": "time_david_witter", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_chris_armstrong", "alias": "time_chris_armstrong", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_tim_wilson", "alias": "time_tim_wilson", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_dan_smith", "alias": "time_dan_smith", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_robert_harig", "alias": "time_robert_harig", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_ron_mckay", "alias": "time_ron_mckay", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_wade_lawson", "alias": "time_wade_lawson", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_mike_solinsky", "alias": "time_mike_solinsky", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_jeff_owsley", "alias": "time_jeff_owsley", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_tyler_burdick", "alias": "time_tyler_burdick", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_chris_miller", "alias": "time_chris_miller", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_steve_huck", "alias": "time_steve_huck", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "time_robert_kirtpatrick", "alias": "time_robert_kirtpatrick", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "labor_subtotal_hours", "alias": "Hours for this task", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_crew_d", "length": 255, "alias": "work_crew_d", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_type_d", "length": 255, "alias": "work_type_d", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_date_d", "length": 255, "alias": "work_date_d", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_parts_apply", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "parts_apply", "length": 255, "alias": "Were any Parts Used?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_c65bdbfa56f24a51b71816fe80921d17_cvd_equip_apply", "type": "codedValue", "codedValues": [ { "code": "yes", "name": "Yes" }, { "code": "no", "name": "No" } ] }, "name": "equip_apply", "length": 255, "alias": "Was Equipment Used", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hours_ruben_sanchez", "alias": "hours_ruben_sanchez", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "time_ruben_sanchez", "alias": "time_ruben_sanchez", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hours_eric_felix", "alias": "hours_eric_felix", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "time_eric_felix", "alias": "time_eric_felix", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hours_stetson_powell", "alias": "hours_stetson_powell", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "time_stetson_powell", "alias": "time_stetson_powell", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hours_eric_jackson", "alias": "hours_eric_jackson", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "time_eric_jackson", "alias": "time_eric_jackson", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hours_nathan_klopfenstein", "alias": "hours_nathan_klopfenstein", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "time_nathan_klopfenstein", "alias": "time_nathan_klopfenstein", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hours_david_cook", "alias": "hours_david_cook", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "time_david_cook", "alias": "time_david_cook", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "hours_isaac_bortman", "alias": "hours_isaac_bortman", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "time_isaac_bortman", "alias": "time_isaac_bortman", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r1066_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAcsending": true }, { "name": "uuid_1066", "isUnique": true, "description": "", "fields": "globalid", "isAcsending": true }, { "name": "a655_ix1", "isUnique": false, "description": "", "fields": "shape", "isAcsending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Create,Editing,Uploads,Query,Update,Delete,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 255, 255, 0, 255 ], "width": 1 }, "color": [ 255, 0, 0, 255 ], "size": 8, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "description": "Survey Data Locations", "label": "DailyReports_05_Water", "type": "simple" }, "transparency": 0, "labelingInfo": null }, "copyrightText": "", "geometryType": "esriGeometryPoint" } ] }