{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Flow Tests", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 10000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "DBO.FlowTestInspections", "relatedTableId": 29, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{229D057C-1122-41A2-AA6D-FB671487AFDF}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 5210806.710048392, "ymin": 3613610.489984229, "xmax": 5267531.05001156, "ymax": 3673024.869842887, "zmin": 0, "zmax": 1729.320000000007, "mmin": -9.999E35, "mmax": -9.999E35, "spatialReference": { "wkid": 102675, "latestWkid": 3417, "vcsWkid": 5703, "latestVcsWkid": 5703, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115419000, "falseY": -93897600, "xyUnits": 3.742388458866003E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102675, "latestWkid": 3417, "vcsWkid": 5703, "latestVcsWkid": 5703, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115419000, "falseY": -93897600, "xyUnits": 3.742388458866003E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "sourceSpatialReference": { "wkid": 102675, "latestWkid": 3417, "vcsWkid": 5703, "latestVcsWkid": 5703, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115419000, "falseY": -93897600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -5.0E37, "mUnits": 10000 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD_1988", "heightUnit": "meter" }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "9a4b876d7d716c794dd1defed22dc645", "imageData": "iVBORw0KGgoAAAANSUhEUgAAADsAAAA4CAYAAABDsYAdAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEmElEQVRoge2aeYgcRRTGf5ltExEvJIq3wWjwThDxWEWJkFUEo06P9wFCPP7wjIIXnngfiIq3GFGSjX94EohEVIJHVDQkorgqGkWNxvwRN7BqlJ2VZ3+VqemZcWd2Zrbbbj9Ypqq6pru+qtfvfe/NBuQIATlCQI4QkCME5AhBQs+dAnybB7IF4HHgmDyQPQLoA/YEvso62ZL3eUeWyU4Ainkheyiwk9oHjrejCkjGhP3+vVklW8wL2YNktj4OBnYGfsga2VIDhxUCD2SNbOgaJwEvVW9CpshOB/awxtbAQ8CrwHB0rRfYHvg5K2RLrnGCYs+RwFsV+WiO65GskA3jrMMKWTecCbL7AHtbYyuJYvfeXgyMRF076G2Btf91siXXmA1MVHtHyallUbcHOBF4MjNkT45dCCtk3bzEyJ4BHO06u8Dk/SKTbBrDUFgCU629pWfCPtkr1e6BWX3wZSv3H4GRj2HlWljvDb8MLGqV7EJgd+BGm/c9YH9jhZnwpNjYFGUDy6ONmbA4ynFbxTR9/qG9q0t0NLJl4FbgDWBBHanXtnxyp2tk28QAcCrwSbvv7DJgBvAEcIp/4SjgwiZXc2yD8Tkyn9EwrIxhRe2lp+XYf+uUgxrUzr0uabeZDS6VIrKnbcPYsB1w2ihz7PU5HcorIgHiYO/pBXrduuKNnwLe0QNMAvIKsD+UF0DBTrrTMA19LpQHq4l+GPHnm26HngHgEOAemQ+roWBu+1rgJgXNdvE7MBd4LOo6oiOy5uuAv8Yrzm4ALgGWAPOAyc6bvSlvthtjx6cy7c+qh9cA5+iZiYiKRTLn51xMfs/zZnER0QxMIF+hOOLBfMXZIpyogloNzAKuBm62e/4qt32+quHN4E95QFMEHsxUrwfursjo5OViGbhdVrzQWfG/Br0YJtbG21VyQh+kVRu/D3zhyG7M65qEzb+/0n2tk0S7QdbC7sxGpcRmVJZH1rLAi2Q1qSQ7G9gEea1GyuhHr1Lu4zCN23WVanoV11NJNqxpeHBK/VHgGsXkoE6p8cHq+6WS7OZ+FlccRanfJm/WH4vJpWqydpvL00j2OGBTl3Pt612YJ6k1VCfDmK6M3cXkw4EdgJ+i7q4qpJs8TBXZYtyE1ysrstOLqa8XFYp7BtWY42UYdqOHK/PDtJGdpJP9B7bYjyT5vq6e97li50q9uvOjIkiUYbyrIF2qJXtVmsj2AVuglS+VA4opdbPWy7y8823PikO3E5Zh3KXU75do3lTNsw1KBdnQ146uriSsA84DXqjzvXU6yI1WbB770trMKUwL2QA43nX0kwbe6Z3ZRPnK5cn9yiPi9zGyN3Rioe1iZp1Cha31FkWY2LobYkCl5Dt1uBZ2HayquZfmJEq2GOt/pzKsZXutYoPiquWsz+jV9U/XNi8xsgVV8h2eV13IIko7WAwcADzrCZVS0mR7pWGHVLmw2lunsEZFyblKH2dIbrdUd+okWVf2tdjZUjW/SVjCfp9+8OvX86z2lQjZVQr4VmjoJpbrx4Oz2rlJ0OYiPM3edQy1UOWpi///BTerCMgRAnKEIOkFjCf+Bo/S8b/lECAzAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 44, "height": 42, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": true, "enableZDefaults": true, "zDefault": 0, "supportsVCSProjection": true, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NUM", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NUM", "type": "esriFieldTypeString", "alias": "NUM", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "NUM" }, { "name": "NUM1", "type": "esriFieldTypeString", "alias": "NUM1", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "NUM1" }, { "name": "DEPTH", "type": "esriFieldTypeString", "alias": "DEPTH", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "DEPTH" }, { "name": "OFFSET", "type": "esriFieldTypeString", "alias": "OFFSET", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "OFFSET" }, { "name": "NUMBER", "type": "esriFieldTypeString", "alias": "NUMBER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NUMBER" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "domain": { "type": "codedValue", "name": "Water Owner", "description": "Owner of Water Structure", "codedValues": [ { "name": "CITY OF WATERLOO", "code": "CITY OF WATERLOO" }, { "name": "BLACK HAWK COUNTY", "code": "BLACK HAWK COUNTY" }, { "name": "PRIVATE", "code": "PRIVATE" }, { "name": "STATE", "code": "STATE" }, { "name": "OTHER", "code": "OTHER" }, { "name": "SCHOOLS", "code": "SCHOOLS" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "CITY OF RAYMOND", "code": "CITY OF RAYMOND" }, { "name": "DAYCARE", "code": "DAYCARE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Owner" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Asset Status", "description": "Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Removed", "code": "Removed" }, { "name": "Abandoned", "code": "Abandoned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "FLOW_TEST_ID", "type": "esriFieldTypeString", "alias": "Flow Test ID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetID" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "Notes" }, { "name": "Northing", "type": "esriFieldTypeDouble", "alias": "Northing", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Northing" }, { "name": "Easting", "type": "esriFieldTypeDouble", "alias": "Easting", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Easting" }, { "name": "FLOW_RATE", "type": "esriFieldTypeString", "alias": "Flow Rate (GPM)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FLOW_RATE" }, { "name": "FLOW_RATE_TEST_DATE", "type": "esriFieldTypeDate", "alias": "Flow Rate Test Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FLOW_RATE_TEST_DATE" }, { "name": "Static_PSI", "type": "esriFieldTypeSmallInteger", "alias": "Static PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Static_PSI" }, { "name": "Residual_PSI", "type": "esriFieldTypeSmallInteger", "alias": "Residual PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Residual_PSI" }, { "name": "QuantityAtPSI", "type": "esriFieldTypeSmallInteger", "alias": "Quantity At PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "QuantityAtPSI" }, { "name": "TakenBy", "type": "esriFieldTypeString", "alias": "TakenBy", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TakenBy" }, { "name": "PitotRDGPSI", "type": "esriFieldTypeDouble", "alias": "Pitot RDG PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PitotRDGPSI" }, { "name": "Water_Used", "type": "esriFieldTypeDouble", "alias": "Water Used", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Water_Used" }, { "name": "Paint", "type": "esriFieldTypeString", "alias": "Paint", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Paint" }, { "name": "Caps_Greased", "type": "esriFieldTypeString", "alias": "Caps Greased?", "domain": { "type": "codedValue", "name": "YesNoStandard", "description": "Yes No domain not all caps", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Caps_Greased" }, { "name": "Stems", "type": "esriFieldTypeString", "alias": "Stems", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Stems" }, { "name": "Packing", "type": "esriFieldTypeString", "alias": "Packing", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Packing" }, { "name": "O_Ring", "type": "esriFieldTypeString", "alias": "O Ring", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "O_Ring" }, { "name": "Top_Nut", "type": "esriFieldTypeString", "alias": "Top Nut", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Top_Nut" }, { "name": "Valve", "type": "esriFieldTypeString", "alias": "Valve", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Valve" }, { "name": "Valve_Seat", "type": "esriFieldTypeString", "alias": "Valve Seat", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Valve_Seat" }, { "name": "Water_Condition", "type": "esriFieldTypeString", "alias": "Water Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Water_Condition" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R551_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_551", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalID" }, { "name": "UUID_OID_551", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID" }, { "name": "Flow_Tests_Globa", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalID" }, { "name": "S507_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "Shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ALOGDB.DBO.Flow_Tests", "description": "", "prototype": { "attributes": { "Valve_Seat": null, "NUM": null, "NUM1": null, "DEPTH": null, "OFFSET": null, "NUMBER": null, "Water_Condition": null, "Valve": null, "Top_Nut": null, "O_Ring": null, "Packing": null, "Owner": null, "Status": null, "Stems": null, "Notes": null, "Northing": null, "Easting": null, "FLOW_RATE": null, "FLOW_RATE_TEST_DATE": null, "Static_PSI": null, "Residual_PSI": null, "QuantityAtPSI": null, "TakenBy": null, "PitotRDGPSI": null, "Water_Used": null, "Paint": null, "Caps_Greased": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "1cd3f9f9f36f45e8a7de7bcfd54f5907" }