{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "All Requests", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "dbo.GIS_Requests_207", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": -180, "ymin": -90, "xmax": 180, "ymax": 90, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 104, 44, 160, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "RequestID", "globalIdField": "", "displayField": "CompletedByFirstName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "RequestID", "type": "esriFieldTypeOID", "alias": "RequestID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "RequestID" }, { "name": "RequestTypeID", "type": "esriFieldTypeInteger", "alias": "RequestTypeID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "RequestTypeID" }, { "name": "RequestType", "type": "esriFieldTypeString", "alias": "RequestType", "domain": null, "editable": true, "nullable": false, "length": 500, "defaultValue": null, "modelName": "RequestType" }, { "name": "RequestStatusID", "type": "esriFieldTypeInteger", "alias": "RequestStatusID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "RequestStatusID" }, { "name": "RequestStatus", "type": "esriFieldTypeString", "alias": "RequestStatus", "domain": null, "editable": true, "nullable": false, "length": 500, "defaultValue": null, "modelName": "RequestStatus" }, { "name": "DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "DivisionID" }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null, "modelName": "Division" }, { "name": "SubmissionBy", "type": "esriFieldTypeString", "alias": "SubmissionBy", "domain": null, "editable": true, "nullable": false, "length": 2500, "defaultValue": null, "modelName": "SubmissionBy" }, { "name": "SubmissionByEmail", "type": "esriFieldTypeString", "alias": "SubmissionByEmail", "domain": null, "editable": true, "nullable": true, "length": 2500, "defaultValue": null, "modelName": "SubmissionByEmail" }, { "name": "Subject", "type": "esriFieldTypeString", "alias": "Subject", "domain": null, "editable": true, "nullable": false, "length": 2500, "defaultValue": null, "modelName": "Subject" }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Problem" }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Resolution" }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "precision": 1, "modelName": "DateCreated" }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "precision": 1, "modelName": "LastUpdated" }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Completed" }, { "name": "DateCompleted", "type": "esriFieldTypeDate", "alias": "DateCompleted", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "DateCompleted" }, { "name": "CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompletedByFirstName" }, { "name": "CompletedByLastName", "type": "esriFieldTypeString", "alias": "CompletedByLastName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompletedByLastName" }, { "name": "Cancelled", "type": "esriFieldTypeSmallInteger", "alias": "Cancelled", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Cancelled" }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LocationNo" }, { "name": "LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LOC_Address" }, { "name": "LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LOC_City" }, { "name": "CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CustomerNo" }, { "name": "CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "CUST_Name" }, { "name": "CUST_Phone1", "type": "esriFieldTypeString", "alias": "CUST_Phone1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CUST_Phone1" }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Service" }, { "name": "MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "MeterID" }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MeterNo" }, { "name": "GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GISAssetNo" }, { "name": "GISFeatureLabel", "type": "esriFieldTypeString", "alias": "GISFeatureLabel", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "GISFeatureLabel" }, { "name": "EXSLayerID", "type": "esriFieldTypeInteger", "alias": "EXSLayerID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXSLayerID" }, { "name": "EXSLayerName", "type": "esriFieldTypeString", "alias": "EXSLayerName", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "EXSLayerName" }, { "name": "AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssetNo" }, { "name": "ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "ASSET_AssetTag" }, { "name": "FacilityID", "type": "esriFieldTypeInteger", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FacilityID" }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Facility" }, { "name": "Facility_Full_Location", "type": "esriFieldTypeString", "alias": "Facility_Full_Location", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Facility_Full_Location" }, { "name": "BillableLaborHoursTotal", "type": "esriFieldTypeDouble", "alias": "BillableLaborHoursTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BillableLaborHoursTotal" }, { "name": "BillableLaborTotal", "type": "esriFieldTypeDouble", "alias": "BillableLaborTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BillableLaborTotal" }, { "name": "NonBillableLaborHoursTotal", "type": "esriFieldTypeDouble", "alias": "NonBillableLaborHoursTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NonBillableLaborHoursTotal" }, { "name": "NonBillableLaborTotal", "type": "esriFieldTypeDouble", "alias": "NonBillableLaborTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NonBillableLaborTotal" }, { "name": "LaborHoursTotal", "type": "esriFieldTypeDouble", "alias": "LaborHoursTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaborHoursTotal" }, { "name": "LaborTotal", "type": "esriFieldTypeDouble", "alias": "LaborTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaborTotal" }, { "name": "LaborCostTotal", "type": "esriFieldTypeDouble", "alias": "LaborCostTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaborCostTotal" }, { "name": "BillableInventoryTotal", "type": "esriFieldTypeDouble", "alias": "BillableInventoryTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BillableInventoryTotal" }, { "name": "NonBillableInventoryTotal", "type": "esriFieldTypeDouble", "alias": "NonBillableInventoryTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NonBillableInventoryTotal" }, { "name": "InventoryTotal", "type": "esriFieldTypeDouble", "alias": "InventoryTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InventoryTotal" }, { "name": "InventoryCostTotal", "type": "esriFieldTypeDouble", "alias": "InventoryCostTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InventoryCostTotal" }, { "name": "BillableContractorTotal", "type": "esriFieldTypeDouble", "alias": "BillableContractorTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BillableContractorTotal" }, { "name": "NonBillableContractorTotal", "type": "esriFieldTypeDouble", "alias": "NonBillableContractorTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NonBillableContractorTotal" }, { "name": "ContractorTotal", "type": "esriFieldTypeDouble", "alias": "ContractorTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ContractorTotal" }, { "name": "BillableEquipmentTotal", "type": "esriFieldTypeDouble", "alias": "BillableEquipmentTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BillableEquipmentTotal" }, { "name": "NonBillableEquipmentTotal", "type": "esriFieldTypeDouble", "alias": "NonBillableEquipmentTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NonBillableEquipmentTotal" }, { "name": "EquipmentTotal", "type": "esriFieldTypeDouble", "alias": "EquipmentTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EquipmentTotal" }, { "name": "BillableRequestTotal", "type": "esriFieldTypeDouble", "alias": "BillableRequestTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BillableRequestTotal" }, { "name": "NonBillableRequestTotal", "type": "esriFieldTypeDouble", "alias": "NonBillableRequestTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NonBillableRequestTotal" }, { "name": "RequestTotal", "type": "esriFieldTypeDouble", "alias": "RequestTotal", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RequestTotal" }, { "name": "X_COORD", "type": "esriFieldTypeDouble", "alias": "X_COORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "X_COORD" }, { "name": "Y_COORD", "type": "esriFieldTypeDouble", "alias": "Y_COORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Y_COORD" }, { "name": "SRID", "type": "esriFieldTypeInteger", "alias": "SRID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SRID" } ], "geometryField": { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "GeoShape" }, "indexes": [ { "name": "FDO_RequestID", "fields": "RequestID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "All Requests", "description": "", "prototype": { "attributes": { "Y_COORD": null, "RequestTypeID": 0, "RequestType": " ", "RequestStatusID": 0, "RequestStatus": " ", "DivisionID": 0, "Division": " ", "SubmissionBy": " ", "SubmissionByEmail": null, "Subject": " ", "Problem": null, "Resolution": null, "DateCreated": -2209161600000, "LastUpdated": -2209161600000, "Completed": 0, "DateCompleted": null, "CompletedByFirstName": null, "CompletedByLastName": null, "Cancelled": 0, "LocationNo": null, "LOC_Address": null, "LOC_City": null, "CustomerNo": null, "CUST_Name": null, "CUST_Phone1": null, "Service": null, "MeterID": null, "MeterNo": null, "GISAssetNo": null, "GISFeatureLabel": null, "EXSLayerID": null, "EXSLayerName": null, "AssetNo": null, "ASSET_AssetTag": null, "FacilityID": null, "Facility": null, "Facility_Full_Location": null, "BillableLaborHoursTotal": null, "BillableLaborTotal": null, "NonBillableLaborHoursTotal": null, "NonBillableLaborTotal": null, "LaborHoursTotal": null, "LaborTotal": null, "LaborCostTotal": null, "BillableInventoryTotal": null, "NonBillableInventoryTotal": null, "InventoryTotal": null, "InventoryCostTotal": null, "BillableContractorTotal": null, "NonBillableContractorTotal": null, "ContractorTotal": null, "BillableEquipmentTotal": null, "NonBillableEquipmentTotal": null, "EquipmentTotal": null, "BillableRequestTotal": null, "NonBillableRequestTotal": null, "RequestTotal": null, "X_COORD": null, "SRID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "a5a2c776d0eb45df820c32d8601e21c7" }