{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 22, "name": "Under Review - Unable to Flow Test", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 250000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "Point geomtery representing fire hydrants with attribute data designed for contractors to field verify condition of fire hydrants. Original location of hydrants exported on 10/17/19 from data maintained by Land Records Divsion of the Planning Department. This point geometry is designed to sync with Cartegraph once the data has been verified in-house by Public Works reviewers. The new fields are to mirror Cartegraph. Extra fields are added for project management such as In-house review by Public Works reviewers.", "copyrightText": "Land Records division created original hydrant attribute data and location as of 10/17/19. Other attrbiute data designed and created by Business Intelligence/GIS Analyst in conjunction with Public Works.", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1728316844000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "hasContingentValuesDefinition": 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": 2471146.873692468, "ymin": 7050638.065065056, "xmax": 2556479.2076206356, "ymax": 7170973.4477534, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "a5f06d0d83c41096f97729c8d74831d3", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABgAAAAWCAYAAADafVyIAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABiklEQVRIieWVzUoCURiG38mjhU4oQcmMm36gpZtxk3t3btpoVzBdRucyctZBNZsW3YO7CIQ2QS6CmVCiBE0S0ROfqNk0P44ZBL0wMHN+eL7zvS9nGH5Z7P8ATNjaEIJLkJQy1NzSAUMIHpNZsd8Z4AJ25Qjq8dIAJmxNAMWtbBwEaNa6ugnbKEG9WQpgCMHldAyZA3n0/VrvEagCIPdjgAlbp+oz+fXp2E4hifurF41OFnQKX8A5HlUB6Km9NaR2V6fj9J5IR/HW6F8DUBcGRMCKAtAmrZnVdiGJu7NnhU5YgmqEBoyNrZCxVK1TNEZzzVqXvAgPmBqb/+y9UzTXrHV9Y8v8YrmZjSOaWPEE0BxBrGrbM7auAGrNpAVBIn9aD+9kuGtsmUcsNb/WOEVrx7H9ZjhziSWnymdjGaSZ2HKn4V8AEtgJAIV6H1b7hxu4PW0ol7B4GRnuAYAelSNo1XujJ4zojqK9/c5AB+AOEIBBC6xq27n/aX6U8G7ROMtzXcOYU3/nj7aoPgDx0ZKHNeUJIgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 18, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "CARTEGRAPH_ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "BonnetColor", "type": "esriFieldTypeString", "alias": "Bonnet Color", "domain": { "type": "codedValue", "name": "HydrantBonnetColor", "description": "Color of hydrant bonnet during inspections", "codedValues": [ { "name": "YELLOW", "code": "YELLOW" }, { "name": "SILVER", "code": "SILVER" }, { "name": "RED", "code": "RED" }, { "name": "BLUE", "code": "BLUE" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BonnetColor" }, { "name": "CARTEGRAPH_ID", "type": "esriFieldTypeString", "alias": "CARTEGRAPH_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CARTEGRAPH_ID" }, { "name": "FHOutletSize", "type": "esriFieldTypeString", "alias": "FH Outlet Size", "domain": { "type": "codedValue", "name": "HydrantFHOutletSize", "description": "Hydrant FHOutlet Size", "codedValues": [ { "name": "2.5", "code": "2.5" }, { "name": "4", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FHOutletSize" }, { "name": "FlowHydrantID", "type": "esriFieldTypeString", "alias": "Flow Hydrant ID", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "FlowHydrantID" }, { "name": "FTDate", "type": "esriFieldTypeDate", "alias": "Flow Test Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FTDate" }, { "name": "FTNotes", "type": "esriFieldTypeString", "alias": "Flow Test Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FTNotes" }, { "name": "FTReviewStatus", "type": "esriFieldTypeString", "alias": "FT Review Status", "domain": { "type": "codedValue", "name": "HydrantReviewStatus", "description": "Staus of reviews after hydrant inspections", "codedValues": [ { "name": "Under Review", "code": "Under Review" }, { "name": "Reviewed", "code": "Reviewed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "Under Review", "modelName": "FTReviewStatus" }, { "name": "GPM", "type": "esriFieldTypeInteger", "alias": "Gallons Per Minute", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GPM" }, { "name": "InspectedBy", "type": "esriFieldTypeString", "alias": "Inspected By", "domain": { "type": "codedValue", "name": "HydrantStaff", "description": "HydrantStaff", "codedValues": [ { "name": "Andrew", "code": "Andrew" }, { "name": "Brian", "code": "Brian" }, { "name": "Isa", "code": "Isa" }, { "name": "Nick", "code": "Nick" }, { "name": "Rick", "code": "Rick" }, { "name": "Romeo", "code": "Romeo" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "InspectedBy" }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspectionDate" }, { "name": "InspectionNotes", "type": "esriFieldTypeString", "alias": "Inspection Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "InspectionNotes" }, { "name": "Mainsize", "type": "esriFieldTypeInteger", "alias": "Main size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mainsize" }, { "name": "ManufacturerModel", "type": "esriFieldTypeString", "alias": "Manufacturer Model", "domain": { "type": "codedValue", "name": "HydrantModelManufacturer", "description": "Model Manufacturer of hydrant during inspections", "codedValues": [ { "name": "AMERICAN AVK SERIES-2780", "code": "AMERICAN AVK SERIES-2780" }, { "name": "AMERICAN DARLING B84B", "code": "AMERICAN DARLING B84B" }, { "name": "CLOW MEDALION", "code": "CLOW MEDALION" }, { "name": "KENNEDY K81A GUARDIAN", "code": "KENNEDY K81A GUARDIAN" }, { "name": "MUELLER CENTURION", "code": "MUELLER CENTURION" }, { "name": "MUELLER IMPROVED 1934-47", "code": "MUELLER IMPROVED 1934-47" }, { "name": "MUELLER IMPROVED 1948-53", "code": "MUELLER IMPROVED 1948-53" }, { "name": "MUELLER IMPROVED 1954-61", "code": "MUELLER IMPROVED 1954-61" }, { "name": "MUELLER IMPROVED 1962-72", "code": "MUELLER IMPROVED 1962-72" }, { "name": "MUELLER IMPROVED 1973-81", "code": "MUELLER IMPROVED 1973-81" }, { "name": "MUELLER SUPER CENTURION-200", "code": "MUELLER SUPER CENTURION-200" }, { "name": "MUELLER SUPER CENTURION-250", "code": "MUELLER SUPER CENTURION-250" }, { "name": "US PIPE METROPOLITAN-M-94", "code": "US PIPE METROPOLITAN-M-94" }, { "name": "WATEROUS PACER WB67", "code": "WATEROUS PACER WB67" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ManufacturerModel" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "OutofService", "type": "esriFieldTypeString", "alias": "Out of Service", "domain": { "type": "codedValue", "name": "HydrantOutOfService", "description": "Is hydrant malfuctioning or broken during inspections", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": "No", "modelName": "OutofService" }, { "name": "PaintCondition", "type": "esriFieldTypeSmallInteger", "alias": "Paint Condition", "domain": { "type": "range", "name": "HydrantPaintCondition", "description": "Condition of hydrant paint during inspections", "range": [ 0, 5 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PaintCondition" }, { "name": "PitotPSI", "type": "esriFieldTypeInteger", "alias": "Pitot PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PitotPSI" }, { "name": "PressureReading", "type": "esriFieldTypeInteger", "alias": "Pressure Reading", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PressureReading" }, { "name": "ResidualPSI", "type": "esriFieldTypeInteger", "alias": "Residual PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ResidualPSI" }, { "name": "ReviewStatus", "type": "esriFieldTypeString", "alias": "Review Status", "domain": { "type": "codedValue", "name": "HydrantReviewStatus", "description": "Staus of reviews after hydrant inspections", "codedValues": [ { "name": "Under Review", "code": "Under Review" }, { "name": "Reviewed", "code": "Reviewed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 15, "defaultValue": "Under Review", "modelName": "ReviewStatus" }, { "name": "StaticHydrantID", "type": "esriFieldTypeString", "alias": "Static Hydrant ID", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "StaticHydrantID" }, { "name": "StaticPSI", "type": "esriFieldTypeInteger", "alias": "Static PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StaticPSI" }, { "name": "StatusInField", "type": "esriFieldTypeString", "alias": "Status In Field", "domain": { "type": "codedValue", "name": "HydrantStatusInField", "description": "Hydrant Status In Field", "codedValues": [ { "name": "New", "code": "New" }, { "name": "Mark for Deletion", "code": "Mark for Deletion" }, { "name": "Field Verified", "code": "Field Verified" }, { "name": "Not Accessible", "code": "Not Accessible" }, { "name": "Needs Verification", "code": "Needs Verification" }, { "name": "High Priority - Need Verification", "code": "High Priority" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "StatusInField" }, { "name": "TestedBy", "type": "esriFieldTypeString", "alias": "Tested By", "domain": { "type": "codedValue", "name": "HydrantStaff", "description": "HydrantStaff", "codedValues": [ { "name": "Andrew", "code": "Andrew" }, { "name": "Brian", "code": "Brian" }, { "name": "Isa", "code": "Isa" }, { "name": "Nick", "code": "Nick" }, { "name": "Rick", "code": "Rick" }, { "name": "Romeo", "code": "Romeo" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TestedBy" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": { "type": "range", "name": "Year", "description": "Year found on hydrant during inspections", "range": [ 1899, 2026 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "ValveTurns", "type": "esriFieldTypeInteger", "alias": "Valve Turns", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ValveTurns" }, { "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "FTStatus", "type": "esriFieldTypeString", "alias": "Flow Test Status", "domain": { "type": "codedValue", "name": "HydrantFTStatus", "description": "Hydrant Flow Test Status", "codedValues": [ { "name": "Needs Flow Testing", "code": "Needs Flow Testing" }, { "name": "Flow Tested", "code": "Flow Tested" }, { "name": "Unable to Test", "code": "Unable to Test" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FTStatus" }, { "name": "LastFlowTestDate", "type": "esriFieldTypeDate", "alias": "Last Flow Test Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastFlowTestDate" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "gdb_ct3_3296", "isAscending": true, "isUnique": false, "description": "", "fields": "OBJECTID" }, { "name": "UUID_3296", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "S2946_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "Shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Flow Tests Completed", "description": "", "prototype": { "attributes": { "ownedby": "C", "gradlok": "N", "ResidualPSI": null, "ManufacturerModel": null, "FTStatus": null, "BonnetColor": null, "CARTEGRAPH_ID": null, "FHOutletSize": null, "FlowHydrantID": null, "FTDate": null, "FTNotes": null, "FTReviewStatus": "Under Review", "GPM": null, "InspectedBy": null, "InspectionDate": null, "InspectionNotes": null, "Mainsize": null, "OutofService": "No", "PaintCondition": null, "PitotPSI": null, "PressureReading": null, "ReviewStatus": "Under Review", "StaticHydrantID": null, "StaticPSI": null, "StatusInField": null, "TestedBy": null, "Year": null, "ValveTurns": null, "LastFlowTestDate": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "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 }