{ "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", "serviceItemId": "463f82d7c5134b9e97398b3fb52588d3" }