{ "layers": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 0, "name": "wWaterSources", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 158, 79, 110, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": { "expression": "$feature.facname", "title": "Custom" }, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "stackLabel": true, "stackRowLength": 24, "stackAlignment": "dynamic", "removeDuplicates": "none", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 6584773.711237252, "ymin": 1862522.3014786392, "xmax": 6599033.29459466, "ymax": 1883249.2249197215, "spatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "sitename", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "facilityid", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "sitename", "type": "esriFieldTypeString", "alias": "SiteName", "length": 50, "domain": null }, { "name": "factype", "type": "esriFieldTypeString", "alias": "FacType", "length": 25, "domain": null }, { "name": "activeflag", "type": "esriFieldTypeString", "alias": "ActiveFlag", "length": 30, "domain": null }, { "name": "installdate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "pumpid", "type": "esriFieldTypeString", "alias": "PumpID", "length": 30, "domain": null }, { "name": "pumpmfg", "type": "esriFieldTypeString", "alias": "PumpMfg", "length": 30, "domain": null }, { "name": "pumptype", "type": "esriFieldTypeString", "alias": "PumpType", "length": 25, "domain": null }, { "name": "pressurezone", "type": "esriFieldTypeString", "alias": "Pressure Zone", "length": 30, "domain": null }, { "name": "multiplier", "type": "esriFieldTypeDouble", "alias": "multiplier", "domain": null }, { "name": "capacity", "type": "esriFieldTypeDouble", "alias": "Capacity", "domain": null }, { "name": "suctionsize", "type": "esriFieldTypeDouble", "alias": "Suction", "domain": null }, { "name": "dischargesize", "type": "esriFieldTypeDouble", "alias": "Discharge", "domain": null }, { "name": "suctionpsi", "type": "esriFieldTypeSmallInteger", "alias": "Suction", "domain": null }, { "name": "dischargepsi", "type": "esriFieldTypeSmallInteger", "alias": "Discharge", "domain": null }, { "name": "ratedpsi", "type": "esriFieldTypeString", "alias": "RatedPSI", "length": 20, "domain": null }, { "name": "ratedflow", "type": "esriFieldTypeString", "alias": "RatedFlow", "length": 20, "domain": null }, { "name": "designgpm", "type": "esriFieldTypeDouble", "alias": "DesignGPM", "domain": null }, { "name": "maxgpm", "type": "esriFieldTypeSmallInteger", "alias": "MaxGPM", "domain": null }, { "name": "horsepower", "type": "esriFieldTypeSmallInteger", "alias": "Horsepower", "domain": null }, { "name": "tdh", "type": "esriFieldTypeSmallInteger", "alias": "TDH", "domain": null }, { "name": "shutoffhead", "type": "esriFieldTypeDouble", "alias": "ShutOffHead", "domain": null }, { "name": "designhead", "type": "esriFieldTypeDouble", "alias": "DesignHead", "domain": null }, { "name": "maxophead", "type": "esriFieldTypeDouble", "alias": "MaxOpHead", "domain": null }, { "name": "maxopdisch", "type": "esriFieldTypeDouble", "alias": "MaxOpDisch", "domain": null }, { "name": "elevation", "type": "esriFieldTypeDouble", "alias": "Elevation", "domain": null }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "address", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "locdesc", "type": "esriFieldTypeString", "alias": "LocDesc", "length": 200, "domain": null }, { "name": "ownedby", "type": "esriFieldTypeSmallInteger", "alias": "OwnedBy", "domain": null }, { "name": "maintby", "type": "esriFieldTypeSmallInteger", "alias": "MaintBy", "domain": null }, { "name": "lastservice", "type": "esriFieldTypeDate", "alias": "LastService", "length": 8, "domain": null }, { "name": "pumpmanual", "type": "esriFieldTypeString", "alias": "Pump Manual", "length": 250, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": null }, { "name": "ancillaryrole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": null }, { "name": "facname", "type": "esriFieldTypeString", "alias": "FacName", "length": 30, "domain": null }, { "name": "facnameold", "type": "esriFieldTypeString", "alias": "FacNameOld", "length": 50, "domain": null }, { "name": "storagetype", "type": "esriFieldTypeString", "alias": "StorageType", "length": 30, "domain": null }, { "name": "overflow", "type": "esriFieldTypeDouble", "alias": "Overflow", "domain": null }, { "name": "topelev", "type": "esriFieldTypeDouble", "alias": "TopElev", "domain": null }, { "name": "topelevtrigger", "type": "esriFieldTypeDouble", "alias": "TopElevTrigger", "domain": null }, { "name": "bottomelev", "type": "esriFieldTypeDouble", "alias": "BottomElev", "domain": null }, { "name": "lowelevtrigger", "type": "esriFieldTypeDouble", "alias": "LowElevTrigger", "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "Material", "length": 30, "domain": null }, { "name": "lining", "type": "esriFieldTypeString", "alias": "Lining", "length": 30, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape" }, "indexes": [ { "name": "R361_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1433_facilit", "fields": "facilityid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_361", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_361", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S258_idx", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISPROD.DBO.wTankHistoryWellProduction", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "facilityid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "ba73603159fa4decae7009d96ad84104" } ], "tables": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 3, "name": "wTankHistoryWellProduction", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "facname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "length": 20, "domain": null }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "workdate", "length": 8, "domain": null }, { "name": "workby", "type": "esriFieldTypeString", "alias": "WorkBy", "length": 50, "domain": { "type": "codedValue", "name": "wStaffOperations", "description": "Water Reporting Staff Names", "codedValues": [ { "name": "Carlos Solis", "code": "Carlos Solis" }, { "name": "Ed Cazares", "code": "Ed Cazares" }, { "name": "Emanuel Cardoso", "code": "Emanuel Cardoso" }, { "name": "Paul Branconier", "code": "Paul Branconier" }, { "name": "Scott Hallimore", "code": "Scott Hallimore" }, { "name": "Melissa Barbosa", "code": "Melissa Barbosa" }, { "name": "Adrian Martinez", "code": "Adrian Martinez" }, { "name": "Gerard Palacios", "code": "Gerard Palacios" }, { "name": "Jason Kromer", "code": "Jason Kromer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "worktype", "length": 50, "domain": { "type": "codedValue", "name": "wTanksWorktype", "description": "Water Report Tanks Worktype", "codedValues": [ { "name": "Well Production", "code": "Well Production" }, { "name": "Well Inspection", "code": "Well Inspection" }, { "name": "Well Sounding", "code": "Well Sounding" }, { "name": "Vulcan Production", "code": "Vulcan Production" }, { "name": "C9 Diversion", "code": "C9 Diversion" }, { "name": "Basin Level", "code": "Basin Level" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "attachmentid1", "type": "esriFieldTypeInteger", "alias": "AttachmentID1", "domain": null }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "AttachmentID2", "domain": null }, { "name": "bearinghouse", "type": "esriFieldTypeString", "alias": "bearinghouse", "length": 50, "domain": { "type": "codedValue", "name": "wEquipCheckStatus", "description": "Water Report Equipment Status", "codedValues": [ { "name": "Okay", "code": "Okay" }, { "name": "N/A", "code": "N/A" }, { "name": "Issue", "code": "Issue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "c9flow", "type": "esriFieldTypeDouble", "alias": "c9flow", "domain": null }, { "name": "c9flow_diff", "type": "esriFieldTypeDouble", "alias": "c9flow_diff", "domain": null }, { "name": "c9flow_last", "type": "esriFieldTypeDouble", "alias": "c9flow_last", "domain": null }, { "name": "capacity", "type": "esriFieldTypeDouble", "alias": "capacity", "domain": null }, { "name": "cl2pump", "type": "esriFieldTypeSmallInteger", "alias": "cl2pump", "domain": null }, { "name": "cl2pumpspeed", "type": "esriFieldTypeSmallInteger", "alias": "cl2pumpspeed", "domain": null }, { "name": "cl2residual", "type": "esriFieldTypeDouble", "alias": "cl2residual", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 1000, "domain": null }, { "name": "demand_last", "type": "esriFieldTypeDouble", "alias": "demand_last", "domain": null }, { "name": "demandkw", "type": "esriFieldTypeDouble", "alias": "demandkw", "domain": null }, { "name": "dischargepsi", "type": "esriFieldTypeDouble", "alias": "dischargepsi", "domain": null }, { "name": "diversionaf", "type": "esriFieldTypeDouble", "alias": "diversionaf", "domain": null }, { "name": "diversionaf_diff", "type": "esriFieldTypeDouble", "alias": "diversionaf_diff", "domain": null }, { "name": "diversionaf_last", "type": "esriFieldTypeDouble", "alias": "diversionaf_last", "domain": null }, { "name": "flow", "type": "esriFieldTypeDouble", "alias": "flow", "domain": null }, { "name": "flowaf", "type": "esriFieldTypeDouble", "alias": "flowaf", "domain": null }, { "name": "flowaf_last", "type": "esriFieldTypeDouble", "alias": "flowaf_last", "domain": null }, { "name": "flowccf", "type": "esriFieldTypeDouble", "alias": "flowccf", "domain": null }, { "name": "flowccf_last", "type": "esriFieldTypeDouble", "alias": "flowccf_last", "domain": null }, { "name": "gpm", "type": "esriFieldTypeDouble", "alias": "gpm", "domain": null }, { "name": "hourmeter", "type": "esriFieldTypeDouble", "alias": "hourmeter", "domain": null }, { "name": "hourmeter_last", "type": "esriFieldTypeDouble", "alias": "hourmeter_last", "domain": null }, { "name": "initials", "type": "esriFieldTypeString", "alias": "initials", "length": 30, "domain": { "type": "codedValue", "name": "wStaffOperations", "description": "Water Reporting Staff Names", "codedValues": [ { "name": "Carlos Solis", "code": "Carlos Solis" }, { "name": "Ed Cazares", "code": "Ed Cazares" }, { "name": "Emanuel Cardoso", "code": "Emanuel Cardoso" }, { "name": "Paul Branconier", "code": "Paul Branconier" }, { "name": "Scott Hallimore", "code": "Scott Hallimore" }, { "name": "Melissa Barbosa", "code": "Melissa Barbosa" }, { "name": "Adrian Martinez", "code": "Adrian Martinez" }, { "name": "Gerard Palacios", "code": "Gerard Palacios" }, { "name": "Jason Kromer", "code": "Jason Kromer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "kwhmeter", "type": "esriFieldTypeDouble", "alias": "kwhmeter", "domain": null }, { "name": "kwhmeter_diff", "type": "esriFieldTypeDouble", "alias": "kwhmeter_diff", "domain": null }, { "name": "kwhmeter_last", "type": "esriFieldTypeDouble", "alias": "kwhmeter_last", "domain": null }, { "name": "kwhperccf", "type": "esriFieldTypeDouble", "alias": "kwhperccf", "domain": null }, { "name": "kwhperhr", "type": "esriFieldTypeDouble", "alias": "kwhperhr", "domain": null }, { "name": "kwhused", "type": "esriFieldTypeDouble", "alias": "kwhused", "domain": null }, { "name": "localcntrlswtch", "type": "esriFieldTypeString", "alias": "localcntrlswtch", "length": 50, "domain": { "type": "codedValue", "name": "wLocalControlSwitch", "description": "Water Report LocalControlSwitch", "codedValues": [ { "name": "Hand", "code": "Hand" }, { "name": "Off", "code": "Off" }, { "name": "Time Clock", "code": "Time Clock" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "lowelevtrigger", "type": "esriFieldTypeDouble", "alias": "lowelevtrigger", "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "material", "length": 50, "domain": { "type": "codedValue", "name": "wTankMaterial_1", "description": "Tank Material", "codedValues": [ { "name": "Concrete", "code": "Concrete" }, { "name": "Steel", "code": "Steel" }, { "name": "Glass Infused Steel", "code": "Glass Infused Steel" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "motorheat", "type": "esriFieldTypeString", "alias": "motorheat", "length": 50, "domain": { "type": "codedValue", "name": "wEquipCheckStatus", "description": "Water Report Equipment Status", "codedValues": [ { "name": "Okay", "code": "Okay" }, { "name": "N/A", "code": "N/A" }, { "name": "Issue", "code": "Issue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "oillevel", "type": "esriFieldTypeString", "alias": "oillevel", "length": 50, "domain": { "type": "codedValue", "name": "wEquipCheckStatus", "description": "Water Report Equipment Status", "codedValues": [ { "name": "Okay", "code": "Okay" }, { "name": "N/A", "code": "N/A" }, { "name": "Issue", "code": "Issue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "operationalcntrl", "type": "esriFieldTypeString", "alias": "operationalcntrl", "length": 50, "domain": { "type": "codedValue", "name": "wOperationalControl", "description": "Water Report OperationalControl", "codedValues": [ { "name": "Local / Manual", "code": "Local / Manual" }, { "name": "Remote / Auto", "code": "Remote / Auto" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pressurezone", "type": "esriFieldTypeString", "alias": "pressurezone", "length": 30, "domain": null }, { "name": "productiontotal_af", "type": "esriFieldTypeDouble", "alias": "productiontotal_af", "domain": null }, { "name": "productiontotal_ccf", "type": "esriFieldTypeDouble", "alias": "productiontotal_ccf", "domain": null }, { "name": "productiontotal_gal", "type": "esriFieldTypeDouble", "alias": "productiontotal_gal", "domain": null }, { "name": "productiontotal_mg", "type": "esriFieldTypeDouble", "alias": "productiontotal_mg", "domain": null }, { "name": "pumpvibration", "type": "esriFieldTypeString", "alias": "pumpvibration", "length": 50, "domain": { "type": "codedValue", "name": "wEquipCheckStatus", "description": "Water Report Equipment Status", "codedValues": [ { "name": "Okay", "code": "Okay" }, { "name": "N/A", "code": "N/A" }, { "name": "Issue", "code": "Issue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pwl", "type": "esriFieldTypeDouble", "alias": "pwl", "domain": null }, { "name": "runtime", "type": "esriFieldTypeDouble", "alias": "runtime", "domain": null }, { "name": "sewermeter_diff", "type": "esriFieldTypeDouble", "alias": "sewermeter_diff", "domain": null }, { "name": "sightoiler", "type": "esriFieldTypeDouble", "alias": "sightoiler", "domain": null }, { "name": "sounding_date_time", "type": "esriFieldTypeDate", "alias": "soundingdatetime", "length": 8, "domain": null }, { "name": "sounding_method", "type": "esriFieldTypeString", "alias": "sounding_method", "length": 50, "domain": { "type": "codedValue", "name": "wSoundingMethod", "description": "Water Report Sounding Method", "codedValues": [ { "name": "Tape", "code": "Tape" }, { "name": "Automated Pressure Transducer", "code": "Automated Pressure Transducer" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "spreadwateraf", "type": "esriFieldTypeDouble", "alias": "spreadwateraf", "domain": null }, { "name": "starttime", "type": "esriFieldTypeDate", "alias": "starttime", "length": 8, "domain": null }, { "name": "storagetype", "type": "esriFieldTypeString", "alias": "storagetype", "length": 30, "domain": { "type": "codedValue", "name": "wStorageType", "description": "The type of water structures", "codedValues": [ { "name": "Hydropillar", "code": "Hydropillar" }, { "name": "Standpipe", "code": "Standpipe" }, { "name": "Reservoir", "code": "Reservoir" }, { "name": "Tank", "code": "Tank" }, { "name": "Well", "code": "Well" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "swl", "type": "esriFieldTypeDouble", "alias": "swl", "domain": null }, { "name": "timeclockoff", "type": "esriFieldTypeDouble", "alias": "timeclockoff", "domain": null }, { "name": "timeclockon", "type": "esriFieldTypeDouble", "alias": "timeclockon", "domain": null }, { "name": "topelevtrigger", "type": "esriFieldTypeDouble", "alias": "topelevtrigger", "domain": null }, { "name": "totalkwh", "type": "esriFieldTypeDouble", "alias": "totalkwh", "domain": null }, { "name": "waterlevel", "type": "esriFieldTypeDouble", "alias": "waterlevel", "domain": null }, { "name": "waterlevelrunning", "type": "esriFieldTypeDouble", "alias": "waterlevelrunning", "domain": null }, { "name": "watersource", "type": "esriFieldTypeString", "alias": "watersource", "length": 25, "domain": { "type": "codedValue", "name": "wWaterSource", "description": "Water Report Watersource", "codedValues": [ { "name": "Conduit", "code": "Conduit" }, { "name": "River", "code": "River" }, { "name": "Off", "code": "Off" }, { "name": "USG3", "code": "USG3" }, { "name": "Four Cities", "code": "Four Cities" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "well_running_static", "type": "esriFieldTypeString", "alias": "well_running_static", "length": 50, "domain": { "type": "codedValue", "name": "wWellSoundingStatus", "description": "Water Report Well Sounding Status", "codedValues": [ { "name": "Running", "code": "Running" }, { "name": "Static", "code": "Static" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "wellfield", "type": "esriFieldTypeString", "alias": "wellfield", "length": 50, "domain": { "type": "codedValue", "name": "wWellField", "description": "Water Report Well Field", "codedValues": [ { "name": "Hand", "code": "Hand" }, { "name": "Off", "code": "Off" }, { "name": "Auto", "code": "Auto" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "wellstatus", "type": "esriFieldTypeString", "alias": "wellstatus", "length": 50, "domain": { "type": "codedValue", "name": "wWellStatus", "description": "Water Report Well Status", "codedValues": [ { "name": "On", "code": "On" }, { "name": "Off", "code": "Off" }, { "name": "Out of Service", "code": "Out of Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "woaddress", "type": "esriFieldTypeString", "alias": "woaddress", "length": 100, "domain": null }, { "name": "wocreatedby", "type": "esriFieldTypeString", "alias": "wocreatedby", "length": 50, "domain": null }, { "name": "wocreateddate", "type": "esriFieldTypeDate", "alias": "wocreateddate", "length": 8, "domain": null }, { "name": "wocustomer", "type": "esriFieldTypeString", "alias": "wocustomer", "length": 50, "domain": null }, { "name": "wodescription", "type": "esriFieldTypeString", "alias": "wodescription", "length": 1000, "domain": null }, { "name": "wonotes", "type": "esriFieldTypeString", "alias": "wonotes", "length": 1000, "domain": null }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "length": 50, "domain": null }, { "name": "wtpinfluentaf", "type": "esriFieldTypeDouble", "alias": "wtpinfluentaf", "domain": null }, { "name": "wtpinfluentaf_diff", "type": "esriFieldTypeDouble", "alias": "wtpinfluentaf_diff", "domain": null }, { "name": "wtpinfluentaf_last", "type": "esriFieldTypeDouble", "alias": "wtpinfluentaf_last", "domain": null }, { "name": "facname", "type": "esriFieldTypeString", "alias": "facname", "length": 50, "domain": null }, { "name": "allocationaf", "type": "esriFieldTypeDouble", "alias": "allocationaf", "domain": null }, { "name": "multiplier", "type": "esriFieldTypeDouble", "alias": "multiplier", "domain": null }, { "name": "WorkDate2", "type": "esriFieldTypeDate", "alias": "WorkDate2", "length": 8, "domain": null } ], "indexes": [ { "name": "R377_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1843_assetke", "fields": "assetkey", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GISPROD.DBO.wWaterSources", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "assetkey", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ba73603159fa4decae7009d96ad84104" } ] }