{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 600, "name": "sde_Pub10.SDE.EnQuestaWorkOrders", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 10000, "maxScale": 0, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasMetadata": true, "extent": { "xmin": 6788080.838414714, "ymin": 1827590.2499517202, "xmax": 6843460.443206474, "ymax": 1877572.7011677325, "spatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 0, 153 ], "size": 5, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "CUSTOMERNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ORDERYEAR", "type": "esriFieldTypeInteger", "alias": "ORDERYEAR", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ORDERYEAR" }, { "name": "ORDERNUMBER", "type": "esriFieldTypeInteger", "alias": "ORDERNUMBER", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ORDERNUMBER" }, { "name": "ORDERTYPE", "type": "esriFieldTypeInteger", "alias": "ORDERTYPE", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ORDERTYPE" }, { "name": "WODESCRIPTION", "type": "esriFieldTypeString", "alias": "WODESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WODESCRIPTION" }, { "name": "WOCREATIONDATE", "type": "esriFieldTypeDate", "alias": "WOCREATIONDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WOCREATIONDATE" }, { "name": "WOSCHEDULEDDATE", "type": "esriFieldTypeDate", "alias": "WOSCHEDULEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WOSCHEDULEDDATE" }, { "name": "ENQWOCREATIONTIME", "type": "esriFieldTypeString", "alias": "ENQWOCREATIONTIME", "domain": null, "editable": true, "nullable": true, "length": 81, "defaultValue": null, "modelName": "ENQWOCREATIONTIME" }, { "name": "WOCREATIONTIME", "type": "esriFieldTypeString", "alias": "WOCREATIONTIME", "domain": null, "editable": true, "nullable": true, "length": 82, "defaultValue": null, "modelName": "WOCREATIONTIME" }, { "name": "CUSTOMERNUMBER", "type": "esriFieldTypeString", "alias": "CUSTOMERNUMBER", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CUSTOMERNUMBER" }, { "name": "ISSUEDBY", "type": "esriFieldTypeString", "alias": "ISSUEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ISSUEDBY" }, { "name": "WOCOMMENT1", "type": "esriFieldTypeString", "alias": "WOCOMMENT1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WOCOMMENT1" }, { "name": "WOCOMMENT2", "type": "esriFieldTypeString", "alias": "WOCOMMENT2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WOCOMMENT2" }, { "name": "CUSTOMERNAME", "type": "esriFieldTypeString", "alias": "CUSTOMERNAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CUSTOMERNAME" }, { "name": "SERVICEPREMISEADDRESSNUMBER", "type": "esriFieldTypeInteger", "alias": "SERVICEPREMISEADDRESSNUMBER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SERVICEPREMISEADDRESSNUMBER" }, { "name": "SERVICEPREMISENAME", "type": "esriFieldTypeString", "alias": "SERVICEPREMISENAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERVICEPREMISENAME" }, { "name": "TOWN", "type": "esriFieldTypeString", "alias": "TOWN", "domain": null, "editable": true, "nullable": true, "length": 23, "defaultValue": null, "modelName": "TOWN" }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ZIP" }, { "name": "MAP_REF", "type": "esriFieldTypeString", "alias": "MAP_REF", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAP_REF" }, { "name": "PREMISENUMBER", "type": "esriFieldTypeString", "alias": "PREMISENUMBER", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PREMISENUMBER" }, { "name": "CISNUMBER", "type": "esriFieldTypeString", "alias": "CISNUMBER", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "CISNUMBER" }, { "name": "ONSTREET", "type": "esriFieldTypeString", "alias": "ONSTREET", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ONSTREET" }, { "name": "CROSSSTREET", "type": "esriFieldTypeString", "alias": "CROSSSTREET", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CROSSSTREET" }, { "name": "METER", "type": "esriFieldTypeString", "alias": "METER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "METER" }, { "name": "METER_INSTALLED_DATE", "type": "esriFieldTypeString", "alias": "METER_INSTALLED_DATE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "METER_INSTALLED_DATE" }, { "name": "CLASS_DESCRIPTION", "type": "esriFieldTypeString", "alias": "CLASS_DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CLASS_DESCRIPTION" }, { "name": "LAST_ACTUAL_READ", "type": "esriFieldTypeString", "alias": "LAST_ACTUAL_READ", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LAST_ACTUAL_READ" }, { "name": "LAST_ACTUAL_READ_DATE", "type": "esriFieldTypeString", "alias": "LAST_ACTUAL_READ_DATE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LAST_ACTUAL_READ_DATE" }, { "name": "METER_CYCLE", "type": "esriFieldTypeString", "alias": "METER_CYCLE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "METER_CYCLE" }, { "name": "METER_ROUTE", "type": "esriFieldTypeString", "alias": "METER_ROUTE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "METER_ROUTE" }, { "name": "METER_COMMENT1", "type": "esriFieldTypeString", "alias": "METER_COMMENT1", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "METER_COMMENT1" }, { "name": "METER_COMMENT2", "type": "esriFieldTypeString", "alias": "METER_COMMENT2", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "METER_COMMENT2" }, { "name": "METER_COMMENT3", "type": "esriFieldTypeString", "alias": "METER_COMMENT3", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "METER_COMMENT3" }, { "name": "METER_COMMENT4", "type": "esriFieldTypeString", "alias": "METER_COMMENT4", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "METER_COMMENT4" }, { "name": "METER_DIAL", "type": "esriFieldTypeString", "alias": "METER_DIAL", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "METER_DIAL" }, { "name": "METER_MIU_REGISTER", "type": "esriFieldTypeString", "alias": "METER_MIU_REGISTER", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "METER_MIU_REGISTER" }, { "name": "METER_DEAD_ZERO", "type": "esriFieldTypeString", "alias": "METER_DEAD_ZERO", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "METER_DEAD_ZERO" }, { "name": "METER_MAKE", "type": "esriFieldTypeString", "alias": "METER_MAKE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "METER_MAKE" }, { "name": "METER_MODEL", "type": "esriFieldTypeString", "alias": "METER_MODEL", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "METER_MODEL" }, { "name": "METER_SIZE", "type": "esriFieldTypeString", "alias": "METER_SIZE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "METER_SIZE" }, { "name": "METER_MATERIAL", "type": "esriFieldTypeString", "alias": "METER_MATERIAL", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "METER_MATERIAL" }, { "name": "NOTEPADID", "type": "esriFieldTypeString", "alias": "NOTEPADID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "NOTEPADID" }, { "name": "LONGNOTE", "type": "esriFieldTypeString", "alias": "LONGNOTE", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "LONGNOTE" }, { "name": "SCRIPTCODE", "type": "esriFieldTypeInteger", "alias": "SCRIPTCODE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SCRIPTCODE" }, { "name": "CONTACT_PHONE", "type": "esriFieldTypeString", "alias": "CONTACT_PHONE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "CONTACT_PHONE" }, { "name": "BUS_PHONE", "type": "esriFieldTypeString", "alias": "BUS_PHONE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BUS_PHONE" }, { "name": "CUST_EMAIL", "type": "esriFieldTypeString", "alias": "CUST_EMAIL", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "CUST_EMAIL" }, { "name": "EXTRACTTIME", "type": "esriFieldTypeString", "alias": "EXTRACTTIME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTRACTTIME" }, { "name": "EXTRACTFLAG", "type": "esriFieldTypeString", "alias": "EXTRACTFLAG", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EXTRACTFLAG" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FacilityID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "SedaruComment", "type": "esriFieldTypeString", "alias": "Sedaru Comment", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "SedaruComment" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R973_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_973", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S825_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sde_Pub10.SDE.EnQuestaWorkOrders", "description": "", "prototype": { "attributes": { "SedaruComment": null, "FacilityID": null, "ORDERYEAR": 0, "ORDERNUMBER": 0, "ORDERTYPE": 0, "WODESCRIPTION": null, "WOCREATIONDATE": null, "WOSCHEDULEDDATE": null, "ENQWOCREATIONTIME": null, "WOCREATIONTIME": null, "CUSTOMERNUMBER": null, "ISSUEDBY": null, "WOCOMMENT1": null, "WOCOMMENT2": null, "CUSTOMERNAME": null, "SERVICEPREMISEADDRESSNUMBER": null, "SERVICEPREMISENAME": null, "TOWN": null, "ZIP": null, "MAP_REF": null, "PREMISENUMBER": null, "CISNUMBER": null, "ONSTREET": null, "CROSSSTREET": null, "METER": null, "METER_INSTALLED_DATE": null, "CLASS_DESCRIPTION": null, "LAST_ACTUAL_READ": null, "LAST_ACTUAL_READ_DATE": null, "METER_CYCLE": null, "METER_ROUTE": null, "METER_COMMENT1": null, "METER_COMMENT2": null, "METER_COMMENT3": null, "METER_COMMENT4": null, "METER_DIAL": null, "METER_MIU_REGISTER": null, "METER_DEAD_ZERO": null, "METER_MAKE": null, "METER_MODEL": null, "METER_SIZE": null, "METER_MATERIAL": null, "NOTEPADID": null, "LONGNOTE": null, "SCRIPTCODE": null, "CONTACT_PHONE": null, "BUS_PHONE": null, "CUST_EMAIL": null, "EXTRACTTIME": null, "EXTRACTFLAG": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 20000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "maxRecordCountFactor": 1 }