{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Water_Fittings", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CREATEDDATE", "creatorField" : "CREATEDBY", "editDateField" : "LASTUPDATE", "editorField" : "LASTEDITOR" }, "editingInfo" : { "lastEditDate" : 1648574215574, "schemaLastEditDate" : 1648574215574, "dataLastEditDate" : 1648574215574 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 3000, "maxScale" : 300, "extent" : { "xmin" : -9504211.6374842282, "ymin" : 3848094.9098381004, "xmax" : -9502685.9739462771, "ymax" : 3849064.0430812794, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"dcef7384-7364-48a3-a006-98e7134c2e5d","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAfElEQVQYlWXPS5GEUBBE0bN4JhgbZYO2UU9GDzbKBtgoG+joDTAT0bm9GfkZ/pT4wYJCw7jgL94RAbo7L9MceOG977t1XUFVmXMmaiAi4oGQmbZtc55njKvzS8uyPIbq7qwqmQmO49Dd7opGzTmzqu6RsKHvF/NKCsT/mx/3VTMkYOMMoQAAAABJRU5ErkJggg==","contentType":"image/png","width":6,"height":6}},"transparency":0}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "fittingtype", "type" : "esriFieldTypeString", "alias" : "Fitting Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piFittingType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Bend", "code" : "Bend" }, { "name" : "Cap", "code" : "Cap" }, { "name" : "Coupling", "code" : "Coupling" }, { "name" : "Cross", "code" : "Cross" }, { "name" : "Expansion Joint", "code" : "Expansion Joint" }, { "name" : "Over Under", "code" : "Over Under" }, { "name" : "Reducer", "code" : "Reducer" }, { "name" : "Reducing Cross", "code" : "Reducing Cross" }, { "name" : "Reducing Tee", "code" : "Reducing Tee" }, { "name" : "Sleeve", "code" : "Sleeve" }, { "name" : "Tap", "code" : "Tap" }, { "name" : "Tee", "code" : "Tee" }, { "name" : "Transition", "code" : "Transition" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "locdesc", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rotation", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "WaterType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "ProjectNumber", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "InstalledBy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hyperlink", "type" : "esriFieldTypeString", "alias" : "Hyperlink", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "jointtype", "type" : "esriFieldTypeString", "alias" : "JointType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainJointType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flange", "code" : "Flange" }, { "name" : "Weld", "code" : "Weld" }, { "name" : "Bond", "code" : "Bond" }, { "name" : "Other", "code" : "Oth" }, { "name" : "Unknown", "code" : "Unk" }, { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Push On", "code" : "PO" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Restrained", "code" : "Res" }, { "name" : "Compression", "code" : "Comp" }, { "name" : "Tapered", "code" : "Tapered" } ] }, "defaultValue" : null }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "ABS Plastic", "code" : "ABS" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Asphalt", "code" : "ASP" }, { "name" : "Brick", "code" : "BR" }, { "name" : "Cast Iron", "code" : "CAS" }, { "name" : "Clay Tile", "code" : "CT" }, { "name" : "Concrete (Non-Reinforced)", "code" : "CP" }, { "name" : "Concrete Segments (Bolted)", "code" : "CSB" }, { "name" : "Concrete Segments (Unbolted)", "code" : "CSU" }, { "name" : "Corrugated Metal", "code" : "CMP" }, { "name" : "Copper", "code" : "COP" }, { "name" : "Cured In Place", "code" : "CIPP" }, { "name" : "Ductile Iron", "code" : "DIP" }, { "name" : "Fiberglass Reinforced", "code" : "FRP" }, { "name" : "Earth & Geotextile", "code" : "EARGEO" }, { "name" : "Earthen", "code" : "EAR" }, { "name" : "Geotextile", "code" : "GEO" }, { "name" : "Galvanized Pipe", "code" : "GP" }, { "name" : "Glass Reinforced Cement", "code" : "GRC" }, { "name" : "Pitch Fiber (Orangeburg)", "code" : "OB" }, { "name" : "Plastic/Steel Composite", "code" : "PSC" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Pre-Stressed Concrete Cylinder", "code" : "PCCP" }, { "name" : "Reinforced Concrete", "code" : "RCP" }, { "name" : "Reinforced Plastic (Truss)", "code" : "RPM" }, { "name" : "Segmented Block", "code" : "SB" }, { "name" : "Steel", "code" : "SP" }, { "name" : "Transite", "code" : "TTE" }, { "name" : "Vitrified Clay", "code" : "VCP" }, { "name" : "Wood", "code" : "WD" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "Brick Masonry", "code" : "BMP" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Brass", "code" : "BRASS" } ] }, "defaultValue" : null }, { "name" : "diameter1", "type" : "esriFieldTypeDouble", "alias" : "Diameter1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "diameter2", "type" : "esriFieldTypeDouble", "alias" : "Diameter2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "diameter3", "type" : "esriFieldTypeDouble", "alias" : "Diameter3", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "diameter4", "type" : "esriFieldTypeDouble", "alias" : "Diameter4", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "minorloss", "type" : "esriFieldTypeDouble", "alias" : "MinorLoss", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "includeinmodel", "type" : "esriFieldTypeSmallInteger", "alias" : "IncludeInModel", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "benddegree", "type" : "esriFieldTypeInteger", "alias" : "BendDegree", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "wDomainDegree", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 1, 90 ] }, "defaultValue" : null }, { "name" : "connectiontype1", "type" : "esriFieldTypeString", "alias" : "ConnectionType1", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainConnection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Restrained Joint", "code" : "RJ" }, { "name" : "Flange", "code" : "Flange" }, { "name" : "Push on", "code" : "PO" }, { "name" : "Female Iron Pipe", "code" : "FIP" }, { "name" : "Male Iron Pipe", "code" : "MIP" }, { "name" : "Compression", "code" : "Compression" }, { "name" : "Flared", "code" : "Flared" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Tapered", "code" : "Tapered" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "connectiontype2", "type" : "esriFieldTypeString", "alias" : "ConnectionType2", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainConnection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Restrained Joint", "code" : "RJ" }, { "name" : "Flange", "code" : "Flange" }, { "name" : "Push on", "code" : "PO" }, { "name" : "Female Iron Pipe", "code" : "FIP" }, { "name" : "Male Iron Pipe", "code" : "MIP" }, { "name" : "Compression", "code" : "Compression" }, { "name" : "Flared", "code" : "Flared" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Tapered", "code" : "Tapered" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "connectiontype3", "type" : "esriFieldTypeString", "alias" : "ConnectionType3", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainConnection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Restrained Joint", "code" : "RJ" }, { "name" : "Flange", "code" : "Flange" }, { "name" : "Push on", "code" : "PO" }, { "name" : "Female Iron Pipe", "code" : "FIP" }, { "name" : "Male Iron Pipe", "code" : "MIP" }, { "name" : "Compression", "code" : "Compression" }, { "name" : "Flared", "code" : "Flared" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Tapered", "code" : "Tapered" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "hasthrustblock", "type" : "esriFieldTypeSmallInteger", "alias" : "HasThrustBlock", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "northing", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "easting", "type" : "esriFieldTypeDouble", "alias" : "Easting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "nodeidnumber", "type" : "esriFieldTypeInteger", "alias" : "Node ID Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nodedemand", "type" : "esriFieldTypeInteger", "alias" : "Node Demand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "CREATEDDATEIndex", "fields" : "CREATEDDATE", "isAscending" : true, "isUnique" : false, "description" : "CREATEDDATE Field index", "indexType" : "Attribute" }, { "name" : "CREATEDBYIndex", "fields" : "CREATEDBY", "isAscending" : false, "isUnique" : false, "description" : "CREATEDBY Field index", "indexType" : "Attribute" }, { "name" : "LASTUPDATEIndex", "fields" : "LASTUPDATE", "isAscending" : true, "isUnique" : false, "description" : "LASTUPDATE Field index", "indexType" : "Attribute" }, { "name" : "LASTEDITORIndex", "fields" : "LASTEDITOR", "isAscending" : false, "isUnique" : false, "description" : "LASTEDITOR Field index", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_WATER_FITTINGS_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E63210A0E87C", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "facilityid" : null, "installdate" : null, "fittingtype" : null, "locdesc" : null, "rotation" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "workorderid" : null, "watertype" : null, "projectnumber" : null, "projectname" : null, "installedby" : null, "hyperlink" : null, "comment" : null, "jointtype" : null, "material" : null, "diameter1" : null, "diameter2" : null, "diameter3" : null, "diameter4" : null, "minorloss" : null, "includeinmodel" : null, "benddegree" : null, "connectiontype1" : null, "connectiontype2" : null, "connectiontype3" : null, "hasthrustblock" : null, "northing" : null, "easting" : null, "origfacilityid" : null, "nodeidnumber" : null, "nodedemand" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "Service_Connection", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CREATEDDATE", "creatorField" : "CREATEDBY", "editDateField" : "LASTUPDATE", "editorField" : "LASTEDITOR" }, "editingInfo" : { "lastEditDate" : 1648574216135, "schemaLastEditDate" : 1648574216135, "dataLastEditDate" : 1648574216135 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 3000, "maxScale" : 300, "extent" : { "xmin" : -9504223.9036844745, "ymin" : 3848108.8767378195, "xmax" : -9502547.382849047, "ymax" : 3849067.6785813509, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"8e5378d4-f7d9-4e72-97d2-655e0e3a128c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADqUlEQVQ4jcXVS0xcVQDG8f85c+fNlBkGCkOH4Vkq0FekEqlKNDTaGNN0U9OliXHhgujChctZuHBRF4aFO2N8bJCN1WirxlfRQqQVRLHa4TnATIHMMOHO3GEe97iYFpBHY0waz/LmO7/c851zz9V4QEP7/+Cw0jBwlxWx6wZFJDr9YuM/wkrwOt6DOdocaVrcGjVVTtO1ZiO/kpPLmVfyszmpTRrdxHleFP8dHFZaZYbmao1nj9aqcwG/OOV3Yat2yPxaHsuSjlpMapMTd8wvI8Pys0JYjREWmfvDF5TFp9N+xMfLj9dz7myH8D/cgs3jRgiBDcDIom4v0Do4JoOfRmj/Y5V3NsLq2k78n3A9oVAZLzxzmPMnmvClJXYFCLEVsVoRSYXnkUakw8apj8Z5aXKNdQbUyPZatuDXlNtfpOdkLc9d7MbzeQT75RtQcRa6O7bgRAo+GIYqF+4Xu8iupDmWGDOfTl2XcwYs7oaz1NVXmqd7W6WnIYCbCCwmYDIKJ5rB5SjFbi1AchWam6DiAP4Lx1m4Pie6biwzxJ6wIHiwQhx7rBlD3l261w0bWZiNQXsjpA2IJaBagzp3KXOyBeX3ioZCjAb6lP3eUdyCJeVWmwhW+TDvPWqugbwVhmagJQjRZbBL6AiC21bKOG24vE4KmsBXKFIG7IBBKyqkVWNzd30eCPhhKgYLyxCJgbDAoUpQ6u5CBRsSlZUIS5kTi76zCotgI5MlrhtkfVaOAGgW6ApB/A588QtUuiBUA+vpUi0AShGNrQuPKcjpFja/yE1YqEJiMaH9OTqD98xxDMAJUOMHvxcGR+HMUeithZuR0hzTJBOJMze9TFDBCk7Su+AC2mxUNyPvjsrOJ9oYBp4EhN0G3YchW4TGQKme0quicnl+eOs7cjGduIAIYVHYfSp8xPMpOfrtNG2XviHmt+BoPcCjgAhVw0VfqRqLBdx2ZSZTYuL9EcYHfiWUNfkJJ7e27dc2OCxyzj41nDCp6x+ityfAz6/2MIGgU7PQojlxAzpwu7Jc/PjeiJn6ZEo+lDKYAb7iTdb2hgG9n1X6uJzMwJVZ8/R0huz5JXn1qVYGDpWTW9Ph+xlsH47i/z0mm/KKv4BBfEyBUPvCIBT9atHVx8eGlNHxOJ2/LZmBN67I+qJAk1AEDJSZFEJ+jZVrzDHP27uvzj3uY6H0flYIq6skGRfCbFBCVqCwm1BAkiIvF3AQ5ZJI756/L7zVOTBfgPl9M/cZD+yf9zekeWYTD1flRwAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16}},"transparency":0}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "accountid", "type" : "esriFieldTypeString", "alias" : "Account Number", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "metservice", "type" : "esriFieldTypeString", "alias" : "Metered Service", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "servicetype", "type" : "esriFieldTypeString", "alias" : "Service Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wServicePointType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Domestic", "code" : "Domestic" }, { "name" : "Commercial", "code" : "Commercial" }, { "name" : "Industrial", "code" : "Industrial" }, { "name" : "Fire", "code" : "Fire" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Master", "code" : "Master" }, { "name" : "Irrigation", "code" : "Irrigation" }, { "name" : "Residential", "code" : "Residential" }, { "name" : "Construction", "code" : "Construction" }, { "name" : "Process", "code" : "Process" }, { "name" : "Submeter", "code" : "Submeter" } ] }, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "locdesc", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rotation", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "locationid", "type" : "esriFieldTypeString", "alias" : "Location Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "critical", "type" : "esriFieldTypeSmallInteger", "alias" : "CriticalCustomer", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "WaterType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "ProjectNumber", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "InstalledBy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hyperlink", "type" : "esriFieldTypeString", "alias" : "Hyperlink", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "flowrange", "type" : "esriFieldTypeString", "alias" : "FlowRange", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "measurementdate", "type" : "esriFieldTypeDate", "alias" : "MeasurementDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "hasbypass", "type" : "esriFieldTypeSmallInteger", "alias" : "HasBypass", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "invault", "type" : "esriFieldTypeSmallInteger", "alias" : "InVault", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "hascheckvalve", "type" : "esriFieldTypeSmallInteger", "alias" : "HasCheckValve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "checkfacilityid", "type" : "esriFieldTypeInteger", "alias" : "CheckFacilityID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hasyokemeter", "type" : "esriFieldTypeSmallInteger", "alias" : "HasYokeMeter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "yokefacilityid", "type" : "esriFieldTypeInteger", "alias" : "YokeFacilityID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "miubatteryinstalldate", "type" : "esriFieldTypeDate", "alias" : "MIUBatteryInstallDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "locationnum", "type" : "esriFieldTypeString", "alias" : "LocationNum", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "northing", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "easting", "type" : "esriFieldTypeDouble", "alias" : "Easting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "buildingname", "type" : "esriFieldTypeString", "alias" : "BuildingName", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "address1", "type" : "esriFieldTypeString", "alias" : "Address1", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "address2", "type" : "esriFieldTypeString", "alias" : "Address2", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "fdcinstalllocation", "type" : "esriFieldTypeSmallInteger", "alias" : "FDCInstallLocation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "fdcdiameter", "type" : "esriFieldTypeDouble", "alias" : "FDCDiameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "firemaindiameter", "type" : "esriFieldTypeDouble", "alias" : "FireMainDiameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "fdcmaterial", "type" : "esriFieldTypeString", "alias" : "FDCMaterial", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "ABS Plastic", "code" : "ABS" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Asphalt", "code" : "ASP" }, { "name" : "Brick", "code" : "BR" }, { "name" : "Cast Iron", "code" : "CAS" }, { "name" : "Clay Tile", "code" : "CT" }, { "name" : "Concrete (Non-Reinforced)", "code" : "CP" }, { "name" : "Concrete Segments (Bolted)", "code" : "CSB" }, { "name" : "Concrete Segments (Unbolted)", "code" : "CSU" }, { "name" : "Corrugated Metal", "code" : "CMP" }, { "name" : "Copper", "code" : "COP" }, { "name" : "Cured In Place", "code" : "CIPP" }, { "name" : "Ductile Iron", "code" : "DIP" }, { "name" : "Fiberglass Reinforced", "code" : "FRP" }, { "name" : "Earth & Geotextile", "code" : "EARGEO" }, { "name" : "Earthen", "code" : "EAR" }, { "name" : "Geotextile", "code" : "GEO" }, { "name" : "Galvanized Pipe", "code" : "GP" }, { "name" : "Glass Reinforced Cement", "code" : "GRC" }, { "name" : "Pitch Fiber (Orangeburg)", "code" : "OB" }, { "name" : "Plastic/Steel Composite", "code" : "PSC" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Pre-Stressed Concrete Cylinder", "code" : "PCCP" }, { "name" : "Reinforced Concrete", "code" : "RCP" }, { "name" : "Reinforced Plastic (Truss)", "code" : "RPM" }, { "name" : "Segmented Block", "code" : "SB" }, { "name" : "Steel", "code" : "SP" }, { "name" : "Transite", "code" : "TTE" }, { "name" : "Vitrified Clay", "code" : "VCP" }, { "name" : "Wood", "code" : "WD" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "Brick Masonry", "code" : "BMP" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Brass", "code" : "BRASS" } ] }, "defaultValue" : null }, { "name" : "hasfirepump", "type" : "esriFieldTypeSmallInteger", "alias" : "HasFirePump", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "accesshydrantofdnum", "type" : "esriFieldTypeInteger", "alias" : "AccessHydrantOFDNum", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "runterritory", "type" : "esriFieldTypeString", "alias" : "RunTerritory", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DomainRunTerritory", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Station 1", "code" : "Station 1" }, { "name" : "Station 2", "code" : "Station 2" }, { "name" : "Station 3", "code" : "Station 3" }, { "name" : "Station 4", "code" : "Station 4" } ] }, "defaultValue" : null }, { "name" : "labled", "type" : "esriFieldTypeSmallInteger", "alias" : "Labled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "miunumber", "type" : "esriFieldTypeString", "alias" : "MIUNumber", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "bodymanufacturer", "type" : "esriFieldTypeString", "alias" : "BodyManufacturer", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wMeterBodyManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Neptune", "code" : "Neptune" }, { "name" : "Sensus", "code" : "Sensus" }, { "name" : "Rockwell", "code" : "Rockwell" }, { "name" : "Metron Farnier", "code" : "Metron Farnier" } ] }, "defaultValue" : null }, { "name" : "registermanufacturer", "type" : "esriFieldTypeString", "alias" : "RegisterManufacturer", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wMeterRegisterManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Sensus", "code" : "Sensus" }, { "name" : "Metron Farnier", "code" : "Metron Farnier" }, { "name" : "Neptune R-450", "code" : "Neptune R-450" }, { "name" : "Neptune R-900 V1", "code" : "Neptune R-900 V1" }, { "name" : "Neptune R-900 V3", "code" : "Neptune R-900 V3" }, { "name" : "Neptune R-900 V2", "code" : "Neptune R-900 V2" }, { "name" : "Neptune R-900i", "code" : "Neptune R-900i" }, { "name" : "Neptune E R-900i", "code" : "Neptune E R-900i" } ] }, "defaultValue" : null }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "wwtagkey", "type" : "esriFieldTypeSmallInteger", "alias" : "wwTagKey", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "tagname", "type" : "esriFieldTypeString", "alias" : "TagName", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "newmiunumber", "type" : "esriFieldTypeString", "alias" : "NewMIUNumber", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "oldmeterreading", "type" : "esriFieldTypeString", "alias" : "OldMeterReading", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "changeoutdate", "type" : "esriFieldTypeDate", "alias" : "ChangeOutDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "meternumber", "type" : "esriFieldTypeString", "alias" : "MeterNumber", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "serviceid", "type" : "esriFieldTypeString", "alias" : "ServiceID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "CREATEDDATEIndex", "fields" : "CREATEDDATE", "isAscending" : true, "isUnique" : false, "description" : "CREATEDDATE Field index", "indexType" : "Attribute" }, { "name" : "CREATEDBYIndex", "fields" : "CREATEDBY", "isAscending" : false, "isUnique" : false, "description" : "CREATEDBY Field index", "indexType" : "Attribute" }, { "name" : "LASTUPDATEIndex", "fields" : "LASTUPDATE", "isAscending" : true, "isUnique" : false, "description" : "LASTUPDATE Field index", "indexType" : "Attribute" }, { "name" : "LASTEDITORIndex", "fields" : "LASTEDITOR", "isAscending" : false, "isUnique" : false, "description" : "LASTEDITOR Field index", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_SERVICE_CONNECTION_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E632F128EB0B", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "facilityid" : null, "accountid" : null, "metservice" : null, "servicetype" : null, "installdate" : null, "locdesc" : null, "rotation" : null, "locationid" : null, "critical" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "workorderid" : null, "watertype" : null, "projectnumber" : null, "projectname" : null, "installedby" : null, "hyperlink" : null, "comment" : null, "diameter" : null, "flowrange" : null, "measurementdate" : null, "hasbypass" : null, "invault" : null, "hascheckvalve" : null, "checkfacilityid" : null, "hasyokemeter" : null, "yokefacilityid" : null, "miubatteryinstalldate" : null, "locationnum" : null, "northing" : null, "easting" : null, "buildingname" : null, "address1" : null, "address2" : null, "fdcinstalllocation" : null, "fdcdiameter" : null, "firemaindiameter" : null, "fdcmaterial" : null, "hasfirepump" : null, "accesshydrantofdnum" : null, "runterritory" : null, "labled" : null, "origfacilityid" : null, "miunumber" : null, "bodymanufacturer" : null, "registermanufacturer" : null, "wwtagkey" : null, "tagname" : null, "newmiunumber" : null, "oldmeterreading" : null, "changeoutdate" : null, "meternumber" : null, "serviceid" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "Hydrant", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CREATEDDATE", "creatorField" : "CREATEDBY", "editDateField" : "LASTUPDATE", "editorField" : "LASTEDITOR" }, "editingInfo" : { "lastEditDate" : 1648574207680, "schemaLastEditDate" : 1648574207680, "dataLastEditDate" : 1648574207680 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 3000, "maxScale" : 300, "extent" : { "xmin" : -9504173.0180834569, "ymin" : 3848107.8485378395, "xmax" : -9502680.9011463784, "ymax" : 3849049.7961809947, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"operable","fieldDelimiter":",","uniqueValueInfos":[{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"573154d2-847d-48da-a43a-bc86475828b6","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADKklEQVRIie2VP2wTdxTHv+/3O5/Pwk4uppFMjKCRUIYgJRahjVKCCCooarqYjQ4MdRcGZtQhW6CdUJayJWkkNpTBaiqhUpUKFMVp5EKCVCoieWhEoqI4xlUCh+37/R6DDY0d2xjFYqj6tnv/Pu/enzsD71GM/2GRSOSE1+v9nIhEhanQ3t7+7ezs7IumwYiox3Xdi0RUFsPMTjqdHgfQPBgzmwACzFwZI5VS1EiOhmG2bftaW/0IhzV8PmBjA8hkih01DMMGsNkU2NjYhZHu7s1z/f2/y5aWDIgArYG1tTbcvh2WDx/2no3FYoempqZ+3RNsfPyLaDSaGg2Hkz2GUSAifmPz+5+iszMtnj9PhUdHz6/EYrHT9YC7YJFIxDZNUwJAV1eobWBg8+uDB5O9hpHf5SsEw7Jcj2X9c+ny5R//unp1WEaj0dX19fWslJIBOIlEwqkJk1LOKaU+BIAjRwp09OiCZRiFynUvE2a2TTPzXSr1J/z+oFJKsVJqC8B1AFdqwgD4AOwrwjRM8yWAf1vnOCHMzfWDiDE4uAjL+htEQDCY8w4NbSOZDL52VQDMnYnrziwQcLFzRgBw714/4vFQSf8xzpz5odQR4PBhF4uLuma+ujDmajpZ0hO0pjJf162X7S2wTMYAc/m9njqVhNbHIQTj5Mnf3uiVAh4/NiBE7fHugjGzIiIXAB49ksjlLGmaBXo9N59vFSMjq2UxWhOePAmq+Xk/gsGiIzMrAGU93QXTWn8DoBUAkskXvrt3Pzk/PHyn2+PJe6pVywwoRdlEIjTd0dHxQTqd/kMp5RBRXghxvy5saWlpeudzX9+XD7q6Bi52ds5/JqXyCqFLEIJSBMexcplM6NLCwok123bFzMzMnWpFVYVVyrVr3/+UzX7lHjvWsm9wcPnTAweeCY8nh+1tGysrAdy8uR9a9waYXTExMVET1BAMACYnJ39JpYY+unWr5zQRCa2Lb1daBiXlxs/xeDz1tjwNf/Wz2ayztbVV1SalzDaS411+noziSlZeX5Vr3CNMa/1MSrnCzLKiiJf5fF41Fba8vHwDwI1G/fcEa4b8d2GvALOCOUl1TRPdAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20},"value":"0","label":"Out of Service"},{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"2d3057b2-e636-47fe-9418-35f26715f737","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADGklEQVRIie2VS2hcVRiAv3POnVc7SaajgTEj1UDJokIy+Aq1FVNUinUz7upCsFMXWXQtLrrztZJuFFwksdCdZBGMICpWlNLUMmoiaDGQhcEGJZPplCTzvOf8LiaRzmRmOpLBhfjv7v/6/vs/7vX4F8X7H5ZKpY6HQqEXlVK6yVQbHBx8d35+vtgzmFJq1Pf9SaVUQ4yIlHK53EWgdzARCQJ9ItIcY6y1qpscXcNisVhkIBolqR0RYN1BnnpHPc+LARs9gb352iunjxY3Xhovf2/6TR4FOIFbtUN8sZ00Px0eez6TyRyemZn5el+wi6++nE6XVi4k/eyoZ2pKIXWDgmjwT4YDOb1dXEleiJ1ZzmQyJzsB98BSqVQsGAwagJFE4tAxu/HGg9XsmEd1j69GCCs/ELZ3zr+e+/S3twdOmXQ6vbq2tlYwxghQWlhYKLWFGWOuWmsfBjiia+qR8vWwR6153RtEkFiwln9/5eZNovG4tdaKtXYT+AB4qy0MiAAHAY4EHEHKsNs6oKQSXD0wjkI4UbxBWP5AAXGvEprwtsgS33W1QPDuxB1n1qd9lJMG3bcHxpkLJajP7kme2/6k3hEFDwV8bjjXNl9HmLTSKbOjVzhUg6/fKdm9YHnnITTe6zOlLI7H0QhPF7/7W28Ffq146Ej78e6BiYhVSvkAv9QMlUDYBKmp3feM2FVOb602xDhR/F6N22suSnzHUUQs0NDTPTDn3DvAAEC2UIx8k3zqzKnalaMBqQZaVSuAdaqwUE1cGhoauj+Xy/1srS0ppapa6x86whYXFy/d/fzY5NkfR7aOTQ5Xrr1gsCG9U6ygsKIoSbiS14nz14eP34r5vp6dnb3SqqiWsGZ578OPPi+cO+c/6vcfPFFeevYBc1sHqLDlYiyX+/i4eB9uZKxPfF9PTU21BXUFA5ienv5qZWLiic+ioyeVVdrtrLf2NPRjzfr6l3Nzcyv3ytP1V79QKJQ2Nzdb2owxhW5y/JOfp1Dfh+bza3WO+4M5524bY5ZFxDQVUa5Wq7ansKWlpcvA5W799wXrhfx3YX8BZqI4zwAD+zcAAAAASUVORK5CYII=","contentType":"image/png","width":20,"height":20},"value":"1","label":"In Service"}]},"transparency":0}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "locdesc", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rotation", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "manufacturer", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wHydrantManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "American Darling", "code" : "American Darling" }, { "name" : "Kennedy Valve", "code" : "Kennedy Valve" }, { "name" : "M&H Valve", "code" : "M&H Valve" }, { "name" : "Mueller Company", "code" : "Mueller Company" }, { "name" : "US Pipe", "code" : "US Pipe" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "A.P. Smith", "code" : "A.P. Smith" } ] }, "defaultValue" : null }, { "name" : "operable", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "lastservice", "type" : "esriFieldTypeDate", "alias" : "Last Service Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "flow", "type" : "esriFieldTypeDouble", "alias" : "Flow Rate (GPM)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "WaterType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "ProjectNumber", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "InstalledBy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hyperlink", "type" : "esriFieldTypeString", "alias" : "Hyperlink", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "barreldiameter", "type" : "esriFieldTypeDouble", "alias" : "BarrelDiameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "mainvalvetype", "type" : "esriFieldTypeString", "alias" : "MainValveType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "nozzlediameter1", "type" : "esriFieldTypeDouble", "alias" : "NozzleDiameter1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "nozzlediameter2", "type" : "esriFieldTypeDouble", "alias" : "NozzleDiameter2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "nozzlediameter3", "type" : "esriFieldTypeDouble", "alias" : "NozzleDiameter3", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "nozzlediameter4", "type" : "esriFieldTypeDouble", "alias" : "NozzleDiameter4", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "outletconfiguration", "type" : "esriFieldTypeString", "alias" : "OutletConfiguration", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainNozzleArrangement", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "2-way", "code" : "2-way" }, { "name" : "3-way", "code" : "3-way" } ] }, "defaultValue" : null }, { "name" : "seatdiameter", "type" : "esriFieldTypeInteger", "alias" : "SeatDiameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "model", "type" : "esriFieldTypeString", "alias" : "Model", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "turnstoopen", "type" : "esriFieldTypeInteger", "alias" : "TurnsToOpen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "depth", "type" : "esriFieldTypeDouble", "alias" : "Depth", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hydrantvalve", "type" : "esriFieldTypeSmallInteger", "alias" : "HydrantValve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "flushinglist", "type" : "esriFieldTypeString", "alias" : "FlushingList", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainSeason", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Spring", "code" : "Spring" }, { "name" : "Fall", "code" : "Fall" }, { "name" : "Summer", "code" : "Summer" }, { "name" : "Winter", "code" : "Winter" } ] }, "defaultValue" : null }, { "name" : "flushingsequence", "type" : "esriFieldTypeInteger", "alias" : "FlushingSequence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "blowoffvalve", "type" : "esriFieldTypeSmallInteger", "alias" : "BlowOffValve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "hydranttype", "type" : "esriFieldTypeString", "alias" : "HydrantType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainHydrantType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Fire", "code" : "Fire" }, { "name" : "Flushing", "code" : "Flushing" } ] }, "defaultValue" : null }, { "name" : "relhydrantflowid1", "type" : "esriFieldTypeInteger", "alias" : "RelHydrantFlowID1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "relhydrantflowid2", "type" : "esriFieldTypeInteger", "alias" : "RelHydrantFlowID2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "relhydrantflowid3", "type" : "esriFieldTypeInteger", "alias" : "RelHydrantFlowID3", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flowsequence", "type" : "esriFieldTypeInteger", "alias" : "FlowSequence", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "firedeptnum", "type" : "esriFieldTypeInteger", "alias" : "FireDeptNum", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "staticpressure", "type" : "esriFieldTypeInteger", "alias" : "StaticPressure", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "residualpressure", "type" : "esriFieldTypeInteger", "alias" : "ResidualPressure", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "northing", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "easting", "type" : "esriFieldTypeDouble", "alias" : "Easting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flowroutenum", "type" : "esriFieldTypeDouble", "alias" : "FlowRouteNum", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hashydrantmeter", "type" : "esriFieldTypeSmallInteger", "alias" : "HasHydrantMeter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "pitot1", "type" : "esriFieldTypeDouble", "alias" : "Pitot-1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pitot2", "type" : "esriFieldTypeDouble", "alias" : "Pitot-2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "static", "type" : "esriFieldTypeDouble", "alias" : "Static", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "residual", "type" : "esriFieldTypeDouble", "alias" : "Residual", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "CREATEDDATEIndex", "fields" : "CREATEDDATE", "isAscending" : true, "isUnique" : false, "description" : "CREATEDDATE Field index", "indexType" : "Attribute" }, { "name" : "CREATEDBYIndex", "fields" : "CREATEDBY", "isAscending" : false, "isUnique" : false, "description" : "CREATEDBY Field index", "indexType" : "Attribute" }, { "name" : "LASTUPDATEIndex", "fields" : "LASTUPDATE", "isAscending" : true, "isUnique" : false, "description" : "LASTUPDATE Field index", "indexType" : "Attribute" }, { "name" : "LASTEDITORIndex", "fields" : "LASTEDITOR", "isAscending" : false, "isUnique" : false, "description" : "LASTEDITOR Field index", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_HYDRANT_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E632D1A38974", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "facilityid" : null, "installdate" : null, "locdesc" : null, "rotation" : null, "manufacturer" : null, "operable" : null, "lastservice" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "flow" : null, "workorderid" : null, "watertype" : null, "projectnumber" : null, "projectname" : null, "installedby" : null, "hyperlink" : null, "comment" : null, "barreldiameter" : null, "mainvalvetype" : null, "nozzlediameter1" : null, "nozzlediameter2" : null, "nozzlediameter3" : null, "nozzlediameter4" : null, "outletconfiguration" : null, "seatdiameter" : null, "model" : null, "turnstoopen" : null, "depth" : null, "hydrantvalve" : null, "flushinglist" : null, "flushingsequence" : null, "blowoffvalve" : null, "hydranttype" : null, "relhydrantflowid1" : null, "relhydrantflowid2" : null, "relhydrantflowid3" : null, "flowsequence" : null, "firedeptnum" : null, "staticpressure" : null, "residualpressure" : null, "northing" : null, "easting" : null, "flowroutenum" : null, "hashydrantmeter" : null, "origfacilityid" : null, "pitot1" : null, "pitot2" : null, "static" : null, "residual" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "System_Valve", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CREATEDDATE", "creatorField" : "CREATEDBY", "editDateField" : "LASTUPDATE", "editorField" : "LASTEDITOR" }, "editingInfo" : { "lastEditDate" : 1648574208740, "schemaLastEditDate" : 1648574208740, "dataLastEditDate" : 1648574208740 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 5000, "maxScale" : 0, "extent" : { "xmin" : -9504233.4902846664, "ymin" : 3848153.3001369308, "xmax" : -9502646.6343470644, "ymax" : 3849064.6510812938, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"curropen","fieldDelimiter":",","uniqueValueInfos":[{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"b37b1449-3a58-44a9-86f2-ac364e0414bc","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAcCAYAAAByDd+UAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACgUlEQVRIie3WS2hUVwAG4G9MNNOYUZGpUCyVSoRGxFd9UUgjgijUBwpVQdyoNQii+AwqDZpFdwaRbhQMdqkLBduFTzRNKaFo2lIkqAuNxEXNVdQo3tGO4+KOdEzGmMlIUegPlwPnHu53z7n3PEr9xyn9H+yRQRgXj8c/zmQypYlEoisIgnY8edvg+JnU3WfpVSrCMASpVMpHpCv5pYV9+LFYsKya/VeoTWIHsSqMRAm6cYOSn6hpoeYLfvuVZegYCDh8Ns03mHQUNejEY3TlNBol6to32MP0yfzVmUzOCYLgUiFgyVzOPGRiM8ZkK3/A3jyN06hCE7EGEueD4ELABHl6mhesYdfPzPg9B+tPhqIeN6lIcvw0n/cHHBGw+1D2rQvNUOzBeKZioR4/Ui9wLmsuU7ZoANjLfIbNuM23x94EjmZVNUYUAcawAKujIf1AzjztBd6ickkR2Mt8ig4GJZPJqiAI2l4L/kH58LcAJrJld3f3h7n1vcCRZNLRqBSVdLaMxWL/9AlO4dEdhhUL3suWYRh29glWcu0i01YUCbajmqctXO8THMyhg0yrE334geQZjuBLWlt43ifYQNNKGg9T0SDajwpNMy7hk2g6vpJ8K016Jpu2c3gGCl0AOrAW6zlbT1vP+3nX0o00NbJkMQtO4iv962l7FltMV320rPXKa7enLSz8nlNfM28b1qAO2/O0fYiTWIdN/D0q2ilSBYGwgflHy8q2nk2lvhvLkFrMFu2BJXiAP7EfE8kc4Hgty/07DQsDYXkqte8gB+bH4w03w3DFOUa3MvgeZvF8EncbOV/OtmXcftPz+nWmqeWZMNyJnbn1J7JXIXnnj4nvH/gCdCGqQU9D3fsAAAAASUVORK5CYII=","contentType":"image/png","width":21,"height":21},"value":"0","label":"Closed"},{"symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"13a7d056-7c4c-4b25-b228-69fac4955abf","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAcCAYAAAByDd+UAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADCElEQVRIie3Wa0hTYRjA8f+mtemcRW2iVs5Iu5hlOEsLygq8kEk30iCkSGlERVmBmFQaFBQl0YfSqLCgDxpEJaRoFyy7SUllZqkfWuStziya1jnVtj6MSNzUzUUU9MDhged9eH+8vOe85/XmD4f3f7BfyIFwpVI53mazeavV6veCIDQBX343GBE0ixyph5XdrfiJogiAJEkoxmAJDKXWWM9RoNxTUBGi51jXcwz+WojfgixoMqhGg1wOUi+8M+LVUEW8sZ74oFnUdTwhDTAOBxyli6Wm8w1RhvMwdS586ADxM5hNv5r8tZBWAPMz4MoRZktfaJCbNIsFQXjkDugVNp+qXjMz912FsePsxdpSqCh0bC5qg+Bw2HAM2eUjqJtuCrcQiHS2UqdgoJ7drXXM2Vf9C3MlFD6wfBd0t+M3MoBLxjvoXQFHf+shb90hCA5zHeuLLtsBBfFEA6n0e5EcQN1CMjufoYhKdh/7GcHhsDgLutrZ03htCFCjJSMyE1T+wwcBZiTC3W3oAR/6fKcOoNBJWEyKZxhAgA6kDuQajWaaIAj1A4Kdjfj6qj0HFSp7NpvN2r51B1Clxma1IPMUtFrtWSaTfR8UDImk55OAhzsIvR/tWRTFt4OCWh3Nr+4TE7fcM7CjGXSxfDU+pGVQ0FvJqXsniEnZApoJw8Ms36GmFCLieGB8iHVQsKKQs/pVFN6+gN+KHJANYzdf3ofXjyFgItn9x5ydNJZJUWwrO8CZ0GiITnQPM7VB8XZIzKK6/DD1/cednqVlezm7Op8VxetZuqkEohJcW2l7K5Rkw5wlvC8/TKqzngF/TxfzSU0/QOVJA0lJBliwFpZsheTNjr2fzfC0Es7lQEImXRofIgHJLRCgNI/krGLFzoYa6WBeLCPnZcCUueCvAbmXHXrbCNfPQGA4tvR8LpXmkg5YBppzyCvGaYN0dGMxx2csUu43vRHXvKhlXEsdI3q7ISwWa+h0TGl7uaFSsKtoE21DzefSneaUgW8g5gK5feuNFfbHnfjrr4n/HvgDtp/0oZvAThwAAAAASUVORK5CYII=","contentType":"image/png","width":21,"height":21},"value":"1","label":"Opened"}]},"transparency":0}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "locdesc", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rotation", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "valvetype", "type" : "esriFieldTypeString", "alias" : "Valve Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piSystemValveType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Ball", "code" : "Ball" }, { "name" : "Butterfly", "code" : "Butterfly" }, { "name" : "Cone", "code" : "Cone" }, { "name" : "Gate", "code" : "Gate" }, { "name" : "Plug", "code" : "Plug" }, { "name" : "Roundway", "code" : "Roundway" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "bypassvalve", "type" : "esriFieldTypeSmallInteger", "alias" : "Bypass Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "clocktoclose", "type" : "esriFieldTypeSmallInteger", "alias" : "Clockwise To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "normallyopen", "type" : "esriFieldTypeSmallInteger", "alias" : "Normally Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "turnstoclose", "type" : "esriFieldTypeInteger", "alias" : "Turns To Close", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "operable", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "hydrflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Hydrant Valve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "curropen", "type" : "esriFieldTypeSmallInteger", "alias" : "Currently Open", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "WaterType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "ProjectNumber", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "InstalledBy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hyperlink", "type" : "esriFieldTypeString", "alias" : "Hyperlink", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "motorized", "type" : "esriFieldTypeSmallInteger", "alias" : "Motorized", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "percentopen", "type" : "esriFieldTypeInteger", "alias" : "PercentOpen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pressuresetting", "type" : "esriFieldTypeString", "alias" : "PressureSetting", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "regulationtype", "type" : "esriFieldTypeString", "alias" : "RegulationType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainWHSystemValveRegulationType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flow", "code" : "Flow" }, { "name" : "Pressure", "code" : "Pressure" } ] }, "defaultValue" : null }, { "name" : "connectiontype", "type" : "esriFieldTypeString", "alias" : "ConnectionType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainConnection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Restrained Joint", "code" : "RJ" }, { "name" : "Flange", "code" : "Flange" }, { "name" : "Push on", "code" : "PO" }, { "name" : "Female Iron Pipe", "code" : "FIP" }, { "name" : "Male Iron Pipe", "code" : "MIP" }, { "name" : "Compression", "code" : "Compression" }, { "name" : "Flared", "code" : "Flared" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Tapered", "code" : "Tapered" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "hasactuator", "type" : "esriFieldTypeSmallInteger", "alias" : "HasActuator", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "directionopen", "type" : "esriFieldTypeString", "alias" : "DirectionOpen", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainTurnDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "clockwise", "code" : "clockwise" }, { "name" : "counterclockwise", "code" : "counterclockwise" } ] }, "defaultValue" : null }, { "name" : "manufacturer", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "American", "code" : "American" }, { "name" : "Brown Steel", "code" : "Brown" }, { "name" : "CB&I", "code" : "CB&I" }, { "name" : "Clow", "code" : "Clow" }, { "name" : "Crane", "code" : "Crane" }, { "name" : "Ford", "code" : "Ford" }, { "name" : "Foxboro", "code" : "Foxboro" }, { "name" : "Griffin", "code" : "Griffin" }, { "name" : "M&H", "code" : "M&H" }, { "name" : "McWane", "code" : "McWane" }, { "name" : "Mueller", "code" : "Mueller" }, { "name" : "Neptune", "code" : "Neptune" }, { "name" : "PDM", "code" : "PDM" }, { "name" : "Sensus", "code" : "Sensus" }, { "name" : "U.S. Pipe", "code" : "U.S. Pipe" }, { "name" : "ISCO", "code" : "ISCO" }, { "name" : "American Flow Control", "code" : "AFC" }, { "name" : "Cerro", "code" : "Cerro" }, { "name" : "Pratt", "code" : "Pratt" }, { "name" : "Dezurick", "code" : "DeZurick" }, { "name" : "Streamline", "code" : "Streamline" }, { "name" : "Howell", "code" : "Howell" }, { "name" : "Kennedy", "code" : "Kennedy" }, { "name" : "Ames", "code" : "Ames" }, { "name" : "Watts", "code" : "Watts" }, { "name" : "Febco", "code" : "Febco" }, { "name" : "Conbraco", "code" : "Conbraco" }, { "name" : "Ross", "code" : "Ross" }, { "name" : "Metron Farnier", "code" : "Metron Farnier" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Other", "code" : "Other" }, { "name" : "American Darling", "code" : "American Darling" }, { "name" : "A.P. Smith", "code" : "A.P. Smith" } ] }, "defaultValue" : null }, { "name" : "ishorizontal", "type" : "esriFieldTypeSmallInteger", "alias" : "IsHorizontal", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "depthtooperatingnut", "type" : "esriFieldTypeDouble", "alias" : "DepthtoOperatingNut", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "northing", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "easting", "type" : "esriFieldTypeDouble", "alias" : "Easting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "paved", "type" : "esriFieldTypeSmallInteger", "alias" : "Paved Over", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "gsurface", "type" : "esriFieldTypeString", "alias" : "Ground Surface", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wSurface", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Asphalt", "code" : "Asphalt" }, { "name" : "Brick", "code" : "Brick" }, { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Dirt", "code" : "Dirt" }, { "name" : "Grass", "code" : "Grass" }, { "name" : "Gravel", "code" : "Gravel" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Water", "code" : "Water" } ] }, "defaultValue" : null }, { "name" : "fintorque", "type" : "esriFieldTypeInteger", "alias" : "Final Torque (Ft Pounds)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "stem", "type" : "esriFieldTypeString", "alias" : "Stem OK?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "package", "type" : "esriFieldTypeString", "alias" : "Packing OK?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "gears", "type" : "esriFieldTypeString", "alias" : "Gears OK?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "lube", "type" : "esriFieldTypeString", "alias" : "Lube Req'd?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "other", "type" : "esriFieldTypeString", "alias" : "Other Maint Req'd?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "exercisedate", "type" : "esriFieldTypeDate", "alias" : "EXERCISEDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "exerciseyear", "type" : "esriFieldTypeSmallInteger", "alias" : "EXERCISEYEAR", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "CREATEDDATEIndex", "fields" : "CREATEDDATE", "isAscending" : true, "isUnique" : false, "description" : "CREATEDDATE Field index", "indexType" : "Attribute" }, { "name" : "CREATEDBYIndex", "fields" : "CREATEDBY", "isAscending" : false, "isUnique" : false, "description" : "CREATEDBY Field index", "indexType" : "Attribute" }, { "name" : "LASTUPDATEIndex", "fields" : "LASTUPDATE", "isAscending" : true, "isUnique" : false, "description" : "LASTUPDATE Field index", "indexType" : "Attribute" }, { "name" : "LASTEDITORIndex", "fields" : "LASTEDITOR", "isAscending" : false, "isUnique" : false, "description" : "LASTEDITOR Field index", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_SYSTEM_VALVE_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E63215256007", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "facilityid" : null, "installdate" : null, "locdesc" : null, "rotation" : null, "diameter" : null, "valvetype" : null, "bypassvalve" : null, "clocktoclose" : null, "normallyopen" : null, "turnstoclose" : null, "operable" : null, "hydrflag" : null, "curropen" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "workorderid" : null, "watertype" : null, "projectnumber" : null, "projectname" : null, "installedby" : null, "hyperlink" : null, "comment" : null, "motorized" : null, "percentopen" : null, "pressuresetting" : null, "regulationtype" : null, "connectiontype" : null, "hasactuator" : null, "directionopen" : null, "manufacturer" : null, "ishorizontal" : null, "depthtooperatingnut" : null, "northing" : null, "easting" : null, "origfacilityid" : null, "paved" : null, "gsurface" : null, "fintorque" : null, "stem" : null, "package" : null, "gears" : null, "lube" : null, "other" : null, "exercisedate" : null, "exerciseyear" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "Control_Valve", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "CREATEDDATE", "creatorField" : "CREATEDBY", "editDateField" : "LASTUPDATE", "editorField" : "LASTEDITOR" }, "editingInfo" : { "lastEditDate" : 1648574211092, "schemaLastEditDate" : 1648574211092, "dataLastEditDate" : 1648574211092 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 5000, "maxScale" : 0, "extent" : { "xmin" : -9504232.4055846445, "ymin" : 3848107.86443784, "xmax" : -9502800.5000439864, "ymax" : 3849065.5277813105, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"26da999c-bfea-4d3b-bdae-3e1bdf13542f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACv0lEQVRIid3VW0jTURwH8O9//jfnvMzL5tzmpiMv1Ww6MCUXNBe6EsxIlEwKK4WiYYESVEgGXR4MeqgHw6TLkzIsHxoiA7W80cuYqKCICxUv6H9qS93m1H9Phpqb28CXfo/n8v2cwzmcQ+KQi/z/AZqmifddr+7YlmxFG65NKTOQZIZHhlmliZLv0TFRjXIi2+w38KShqqriUUmtIvN4SIJchlBuMDY3t7C4sCz+ZuhTEARD1zWjN/KFwnI5cXrSF4C8VVPaFhzG0dyuKWOw2MxdnXxRFJJTj2CJ+oWWRkNOdr5qcJjuyJUTmh9eAVd0BXrVuQxNWlYKw9MOI3hc3Ki6jOa3rWEBDKJ9mO5R7N3JP0CG+thFeXrS2YPCt4tBMlBUUYD6Zx+516t49QDyPAJ8saBOW6wJ9Sb8bwgrAPmluTD1Dp0fpjvTdh78LoDH46WfzFayA4NYvuQDAOISY9Gm78QZbWYRgP0BiqKyUjPkXJ/TAYAA4hNjQS0sqXY27wLYbLZodNASMj9L+WVMWaaRkn6U7xYA4JImiJziuBi2P4BteQUki/ztFnA4HOPONcdspCBC5g9gX3MiihducgsA6DC29D5IVyt9Dt9wbWLDtQ4mm9nqCZg09ZjG5qcpYbSY59NVNfcOQnlKMZYCjdETgBHzRPXL6jeG559qQklmgFfhy5QN46MTWyVq5VWCIGiPAICRtqbuhwJJw4vKp+UyJsvzg7tstUH/7it9qUyr8/otAtD8oU6/Mj0197qy9mZ0fLIkeO+ArY0tmPuHYO4fWtMWqq+phcUt+wV5Wp7B2NTdv2q1PRZIYy6kqU5whBI+FwBr5ufc+uzU/GpSWsLnnPuFujwiz+ku5KAPZ7HPOHAXGLj3pbFdFhQUJOJwOOtWq3UcgPWAuV4B20UDsNjtdovdbvdyim+A33XowB9JFuh+vQAgCQAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":18}},"transparency":0}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "locdesc", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rotation", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "valvetype", "type" : "esriFieldTypeString", "alias" : "Valve Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piControlValveType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Altitude", "code" : "Altitude" }, { "name" : "Blowoff", "code" : "Blowoff" }, { "name" : "Combination", "code" : "Combination" }, { "name" : "Vacuum", "code" : "Vacuum" }, { "name" : "Air Control", "code" : "Air Control" }, { "name" : "Air Gap", "code" : "Air Gap" }, { "name" : "Air Release", "code" : "Air Release" }, { "name" : "Atmospheric Vacuum", "code" : "Atmospheric Vacuum" }, { "name" : "Backflow Control", "code" : "Backflow Control" }, { "name" : "Double Check", "code" : "Double Check" }, { "name" : "Pressure Vacuum", "code" : "Pressure Vacuum" }, { "name" : "Pressure Reducer", "code" : "Pressure Reducer" }, { "name" : "Simple Check", "code" : "Simple Check" }, { "name" : "Vacuum Breaker", "code" : "Vacuum Breaker" }, { "name" : "Vacuum Release", "code" : "Vacuum Release" }, { "name" : "Surge Relief", "code" : "Surge Relief" }, { "name" : "Snubber", "code" : "Snubber" }, { "name" : "CLA", "code" : "CLA" }, { "name" : "Reduced Pressure Zone", "code" : "RPZ" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "DCVA", "code" : "DCVA" } ] }, "defaultValue" : null }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "WaterType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "ProjectNumber", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "ProjectName", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "InstalledBy", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hyperlink", "type" : "esriFieldTypeString", "alias" : "Hyperlink", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "bypassvalve", "type" : "esriFieldTypeSmallInteger", "alias" : "BypassValve", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "clockwisetoclose", "type" : "esriFieldTypeSmallInteger", "alias" : "ClockwiseToClose", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "currentlyopen", "type" : "esriFieldTypeSmallInteger", "alias" : "CurrentlyOpen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "motorized", "type" : "esriFieldTypeSmallInteger", "alias" : "Motorized", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "normallyopen", "type" : "esriFieldTypeSmallInteger", "alias" : "NormallyOpen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "percentopen", "type" : "esriFieldTypeInteger", "alias" : "PercentOpen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pressuresetting", "type" : "esriFieldTypeString", "alias" : "PressureSetting", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "regulationtype", "type" : "esriFieldTypeString", "alias" : "RegulationType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainWHSystemValveRegulationType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flow", "code" : "Flow" }, { "name" : "Pressure", "code" : "Pressure" } ] }, "defaultValue" : null }, { "name" : "turnstoclose", "type" : "esriFieldTypeInteger", "alias" : "TurnsToClose", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "operable", "type" : "esriFieldTypeSmallInteger", "alias" : "Operable", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "connectiontype", "type" : "esriFieldTypeString", "alias" : "ConnectionType", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainConnection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Restrained Joint", "code" : "RJ" }, { "name" : "Flange", "code" : "Flange" }, { "name" : "Push on", "code" : "PO" }, { "name" : "Female Iron Pipe", "code" : "FIP" }, { "name" : "Male Iron Pipe", "code" : "MIP" }, { "name" : "Compression", "code" : "Compression" }, { "name" : "Flared", "code" : "Flared" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Tapered", "code" : "Tapered" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null }, { "name" : "hasactuator", "type" : "esriFieldTypeSmallInteger", "alias" : "HasActuator", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "directionopen", "type" : "esriFieldTypeString", "alias" : "DirectionOpen", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainTurnDirection", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "clockwise", "code" : "clockwise" }, { "name" : "counterclockwise", "code" : "counterclockwise" } ] }, "defaultValue" : null }, { "name" : "manufacturer", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "American", "code" : "American" }, { "name" : "Brown Steel", "code" : "Brown" }, { "name" : "CB&I", "code" : "CB&I" }, { "name" : "Clow", "code" : "Clow" }, { "name" : "Crane", "code" : "Crane" }, { "name" : "Ford", "code" : "Ford" }, { "name" : "Foxboro", "code" : "Foxboro" }, { "name" : "Griffin", "code" : "Griffin" }, { "name" : "M&H", "code" : "M&H" }, { "name" : "McWane", "code" : "McWane" }, { "name" : "Mueller", "code" : "Mueller" }, { "name" : "Neptune", "code" : "Neptune" }, { "name" : "PDM", "code" : "PDM" }, { "name" : "Sensus", "code" : "Sensus" }, { "name" : "U.S. Pipe", "code" : "U.S. Pipe" }, { "name" : "ISCO", "code" : "ISCO" }, { "name" : "American Flow Control", "code" : "AFC" }, { "name" : "Cerro", "code" : "Cerro" }, { "name" : "Pratt", "code" : "Pratt" }, { "name" : "Dezurick", "code" : "DeZurick" }, { "name" : "Streamline", "code" : "Streamline" }, { "name" : "Howell", "code" : "Howell" }, { "name" : "Kennedy", "code" : "Kennedy" }, { "name" : "Ames", "code" : "Ames" }, { "name" : "Watts", "code" : "Watts" }, { "name" : "Febco", "code" : "Febco" }, { "name" : "Conbraco", "code" : "Conbraco" }, { "name" : "Ross", "code" : "Ross" }, { "name" : "Metron Farnier", "code" : "Metron Farnier" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Other", "code" : "Other" }, { "name" : "American Darling", "code" : "American Darling" }, { "name" : "A.P. Smith", "code" : "A.P. Smith" } ] }, "defaultValue" : null }, { "name" : "ishydrant", "type" : "esriFieldTypeSmallInteger", "alias" : "IsHydrant", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ishorizontal", "type" : "esriFieldTypeSmallInteger", "alias" : "IsHorizontal", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "depthtooperatingnut", "type" : "esriFieldTypeDouble", "alias" : "DepthtoOperatingNut", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "northing", "type" : "esriFieldTypeDouble", "alias" : "Northing", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "easting", "type" : "esriFieldTypeDouble", "alias" : "Easting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "CREATEDDATEIndex", "fields" : "CREATEDDATE", "isAscending" : true, "isUnique" : false, "description" : "CREATEDDATE Field index", "indexType" : "Attribute" }, { "name" : "CREATEDBYIndex", "fields" : "CREATEDBY", "isAscending" : false, "isUnique" : false, "description" : "CREATEDBY Field index", "indexType" : "Attribute" }, { "name" : "LASTUPDATEIndex", "fields" : "LASTUPDATE", "isAscending" : true, "isUnique" : false, "description" : "LASTUPDATE Field index", "indexType" : "Attribute" }, { "name" : "LASTEDITORIndex", "fields" : "LASTEDITOR", "isAscending" : false, "isUnique" : false, "description" : "LASTEDITOR Field index", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_CONTROL_VALVE_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E632E9529955", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "facilityid" : null, "installdate" : null, "locdesc" : null, "rotation" : null, "diameter" : null, "valvetype" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "workorderid" : null, "watertype" : null, "projectnumber" : null, "projectname" : null, "installedby" : null, "hyperlink" : null, "comment" : null, "bypassvalve" : null, "clockwisetoclose" : null, "currentlyopen" : null, "motorized" : null, "normallyopen" : null, "percentopen" : null, "pressuresetting" : null, "regulationtype" : null, "turnstoclose" : null, "operable" : null, "connectiontype" : null, "hasactuator" : null, "directionopen" : null, "manufacturer" : null, "ishydrant" : null, "ishorizontal" : null, "depthtooperatingnut" : null, "northing" : null, "easting" : null, "origfacilityid" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 5, "name" : "Main", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "creationdate", "creatorField" : "creator", "editDateField" : "editdate", "editorField" : "editor" }, "editingInfo" : { "lastEditDate" : 1648574474278, "schemaLastEditDate" : 1648574474278, "dataLastEditDate" : 1648574474278 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 72224, "maxScale" : 0, "extent" : { "xmin" : -9504294.1169, "ymin" : 3847860.6137, "xmax" : -9502866.4565, "ymax" : 3849287.445, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"color":[0,197,255,255],"width":4.5,"type":"esriSLS","style":"esriSLSSolid"}},"transparency":0}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "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" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "ABS Plastic", "code" : "ABS" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Asphalt", "code" : "ASP" }, { "name" : "Brick", "code" : "BR" }, { "name" : "Cast Iron", "code" : "CAS" }, { "name" : "Clay Tile", "code" : "CT" }, { "name" : "Concrete (Non-Reinforced)", "code" : "CP" }, { "name" : "Concrete Segments (Bolted)", "code" : "CSB" }, { "name" : "Concrete Segments (Unbolted)", "code" : "CSU" }, { "name" : "Corrugated Metal", "code" : "CMP" }, { "name" : "Copper", "code" : "COP" }, { "name" : "Cured In Place", "code" : "CIPP" }, { "name" : "Ductile Iron", "code" : "DIP" }, { "name" : "Fiberglass Reinforced", "code" : "FRP" }, { "name" : "Earth & Geotextile", "code" : "EARGEO" }, { "name" : "Earthen", "code" : "EAR" }, { "name" : "Geotextile", "code" : "GEO" }, { "name" : "Galvanized Pipe", "code" : "GP" }, { "name" : "Glass Reinforced Cement", "code" : "GRC" }, { "name" : "Pitch Fiber (Orangeburg)", "code" : "OB" }, { "name" : "Plastic/Steel Composite", "code" : "PSC" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Pre-Stressed Concrete Cylinder", "code" : "PCCP" }, { "name" : "Reinforced Concrete", "code" : "RCP" }, { "name" : "Reinforced Plastic (Truss)", "code" : "RPM" }, { "name" : "Segmented Block", "code" : "SB" }, { "name" : "Steel", "code" : "SP" }, { "name" : "Transite", "code" : "TTE" }, { "name" : "Vitrified Clay", "code" : "VCP" }, { "name" : "Wood", "code" : "WD" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "Brick Masonry", "code" : "BMP" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Brass", "code" : "BRASS" } ] }, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "transmiss", "type" : "esriFieldTypeString", "alias" : "Transmission System", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flowmeasurementid", "type" : "esriFieldTypeString", "alias" : "FlowMeasurementID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exteriorcoating", "type" : "esriFieldTypeString", "alias" : "ExteriorCoating", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "jointtype1", "type" : "esriFieldTypeString", "alias" : "JointType1", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainJointType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flange", "code" : "Flange" }, { "name" : "Weld", "code" : "Weld" }, { "name" : "Bond", "code" : "Bond" }, { "name" : "Other", "code" : "Oth" }, { "name" : "Unknown", "code" : "Unk" }, { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Push On", "code" : "PO" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Restrained", "code" : "Res" }, { "name" : "Compression", "code" : "Comp" }, { "name" : "Tapered", "code" : "Tapered" } ] }, "defaultValue" : null }, { "name" : "jointtype2", "type" : "esriFieldTypeString", "alias" : "JointType2", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainJointType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flange", "code" : "Flange" }, { "name" : "Weld", "code" : "Weld" }, { "name" : "Bond", "code" : "Bond" }, { "name" : "Other", "code" : "Oth" }, { "name" : "Unknown", "code" : "Unk" }, { "name" : "Mechanical Joint", "code" : "MJ" }, { "name" : "Push On", "code" : "PO" }, { "name" : "Solder", "code" : "Solder" }, { "name" : "Restrained", "code" : "Res" }, { "name" : "Compression", "code" : "Comp" }, { "name" : "Tapered", "code" : "Tapered" } ] }, "defaultValue" : null }, { "name" : "liningtype", "type" : "esriFieldTypeString", "alias" : "LiningType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pipeclass", "type" : "esriFieldTypeString", "alias" : "PipeClass", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "roughness", "type" : "esriFieldTypeDouble", "alias" : "Roughness", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "depth", "type" : "esriFieldTypeInteger", "alias" : "Depth", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "groundsurfacetype", "type" : "esriFieldTypeString", "alias" : "GroundSurfaceType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pressurerating", "type" : "esriFieldTypeString", "alias" : "PressureRating", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "manufacturer", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "American", "code" : "American" }, { "name" : "Brown Steel", "code" : "Brown" }, { "name" : "CB&I", "code" : "CB&I" }, { "name" : "Clow", "code" : "Clow" }, { "name" : "Crane", "code" : "Crane" }, { "name" : "Ford", "code" : "Ford" }, { "name" : "Foxboro", "code" : "Foxboro" }, { "name" : "Griffin", "code" : "Griffin" }, { "name" : "M&H", "code" : "M&H" }, { "name" : "McWane", "code" : "McWane" }, { "name" : "Mueller", "code" : "Mueller" }, { "name" : "Neptune", "code" : "Neptune" }, { "name" : "PDM", "code" : "PDM" }, { "name" : "Sensus", "code" : "Sensus" }, { "name" : "U.S. Pipe", "code" : "U.S. Pipe" }, { "name" : "ISCO", "code" : "ISCO" }, { "name" : "American Flow Control", "code" : "AFC" }, { "name" : "Cerro", "code" : "Cerro" }, { "name" : "Pratt", "code" : "Pratt" }, { "name" : "Dezurick", "code" : "DeZurick" }, { "name" : "Streamline", "code" : "Streamline" }, { "name" : "Howell", "code" : "Howell" }, { "name" : "Kennedy", "code" : "Kennedy" }, { "name" : "Ames", "code" : "Ames" }, { "name" : "Watts", "code" : "Watts" }, { "name" : "Febco", "code" : "Febco" }, { "name" : "Conbraco", "code" : "Conbraco" }, { "name" : "Ross", "code" : "Ross" }, { "name" : "Metron Farnier", "code" : "Metron Farnier" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Other", "code" : "Other" }, { "name" : "American Darling", "code" : "American Darling" }, { "name" : "A.P. Smith", "code" : "A.P. Smith" } ] }, "defaultValue" : null }, { "name" : "designlength", "type" : "esriFieldTypeDouble", "alias" : "DesignLength", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "inmodel", "type" : "esriFieldTypeSmallInteger", "alias" : "InModel", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "Project Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "Installed By", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "cycle", "type" : "esriFieldTypeString", "alias" : "Cycle", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainCycle", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Cycle 1", "code" : "1" }, { "name" : "Cycle 2", "code" : "2" }, { "name" : "Cycle 3", "code" : "3" }, { "name" : "Cycle 4", "code" : "4" }, { "name" : "Cycle 5", "code" : "5" } ] }, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "Project Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "pipeidnumber", "type" : "esriFieldTypeInteger", "alias" : "Pipe ID Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pipedemand", "type" : "esriFieldTypeInteger", "alias" : "Pipe Demand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creationdate", "type" : "esriFieldTypeDate", "alias" : "creationdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "editdate", "type" : "esriFieldTypeDate", "alias" : "editdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "editor", "type" : "esriFieldTypeString", "alias" : "editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "creationdateIndex", "fields" : "creationdate", "isAscending" : true, "isUnique" : false, "description" : "creationdate Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "editdateIndex", "fields" : "editdate", "isAscending" : true, "isUnique" : false, "description" : "editdate Field index", "indexType" : "Attribute" }, { "name" : "editorIndex", "fields" : "editor", "isAscending" : false, "isUnique" : false, "description" : "editor Field index", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_MAIN_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E6320A451111", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "facilityid" : null, "installdate" : null, "material" : null, "diameter" : null, "watertype" : null, "transmiss" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "lastupdate" : null, "lasteditor" : null, "workorderid" : null, "flowmeasurementid" : null, "exteriorcoating" : null, "jointtype1" : null, "jointtype2" : null, "liningtype" : null, "pipeclass" : null, "roughness" : null, "depth" : null, "groundsurfacetype" : null, "pressurerating" : null, "manufacturer" : null, "designlength" : null, "inmodel" : null, "projectname" : null, "installedby" : null, "cycle" : null, "origfacilityid" : null, "projectnumber" : null, "comment" : null, "createdby" : null, "createddate" : null, "pipeidnumber" : null, "pipedemand" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 6, "name" : "Lateral", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "creationdate", "creatorField" : "creator", "editDateField" : "editdate", "editorField" : "editor" }, "editingInfo" : { "lastEditDate" : 1648574244881, "schemaLastEditDate" : 1648574244881, "dataLastEditDate" : 1648574244881 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -9504222.1461, "ymin" : 3848108.9536999986, "xmax" : -9502681.0912, "ymax" : 3849067.2752000014, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"color":[0,197,255,255],"width":2.5,"type":"esriSLS","style":"esriSLSSolid"}},"transparency":0}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "facilityid", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installdate", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "ABS Plastic", "code" : "ABS" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Asphalt", "code" : "ASP" }, { "name" : "Brick", "code" : "BR" }, { "name" : "Cast Iron", "code" : "CAS" }, { "name" : "Clay Tile", "code" : "CT" }, { "name" : "Concrete (Non-Reinforced)", "code" : "CP" }, { "name" : "Concrete Segments (Bolted)", "code" : "CSB" }, { "name" : "Concrete Segments (Unbolted)", "code" : "CSU" }, { "name" : "Corrugated Metal", "code" : "CMP" }, { "name" : "Copper", "code" : "COP" }, { "name" : "Cured In Place", "code" : "CIPP" }, { "name" : "Ductile Iron", "code" : "DIP" }, { "name" : "Fiberglass Reinforced", "code" : "FRP" }, { "name" : "Earth & Geotextile", "code" : "EARGEO" }, { "name" : "Earthen", "code" : "EAR" }, { "name" : "Geotextile", "code" : "GEO" }, { "name" : "Galvanized Pipe", "code" : "GP" }, { "name" : "Glass Reinforced Cement", "code" : "GRC" }, { "name" : "Pitch Fiber (Orangeburg)", "code" : "OB" }, { "name" : "Plastic/Steel Composite", "code" : "PSC" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Pre-Stressed Concrete Cylinder", "code" : "PCCP" }, { "name" : "Reinforced Concrete", "code" : "RCP" }, { "name" : "Reinforced Plastic (Truss)", "code" : "RPM" }, { "name" : "Segmented Block", "code" : "SB" }, { "name" : "Steel", "code" : "SP" }, { "name" : "Transite", "code" : "TTE" }, { "name" : "Vitrified Clay", "code" : "VCP" }, { "name" : "Wood", "code" : "WD" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "Brick Masonry", "code" : "BMP" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Brass", "code" : "BRASS" } ] }, "defaultValue" : null }, { "name" : "linetype", "type" : "esriFieldTypeString", "alias" : "Line Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wLateralType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Hydrant", "code" : "Hydrant" }, { "name" : "Irrigation", "code" : "Irrigation" }, { "name" : "Other", "code" : "Other" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Domestic", "code" : "Domestic" }, { "name" : "Fire", "code" : "Fire" }, { "name" : "Industrial", "code" : "Industrial" }, { "name" : "Commercial", "code" : "Commercial" } ] }, "defaultValue" : null }, { "name" : "locdesc", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "diameter", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "2 1/4\"", "code" : 2.25 }, { "name" : "5 1/2\"", "code" : 5.5 }, { "name" : "5\"", "code" : 5 }, { "name" : "5 1/4\"", "code" : 5.25 } ] }, "defaultValue" : null }, { "name" : "watertype", "type" : "esriFieldTypeString", "alias" : "Water Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wWaterType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable Water", "code" : "Potable" }, { "name" : "Raw Water", "code" : "Raw" }, { "name" : "Reclaimed Water", "code" : "Reclaimed" }, { "name" : "Salt Water", "code" : "Salt" }, { "name" : "Storm Runoff", "code" : "Storm" }, { "name" : "Treated Water", "code" : "Treated" }, { "name" : "Sewage", "code" : "Sewage" }, { "name" : "Waste Water Effluent", "code" : "Effluent" }, { "name" : "Combined Waste Water", "code" : "Combined" } ] }, "defaultValue" : null }, { "name" : "enabled", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "activeflag", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "ownedby", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "maintby", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Our Agency", "code" : 1 }, { "name" : "Private", "code" : -1 }, { "name" : "Other", "code" : -2 } ] }, "defaultValue" : null }, { "name" : "lastupdate", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "lasteditor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "workorderid", "type" : "esriFieldTypeString", "alias" : "WorkorderID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flowmeasurementid", "type" : "esriFieldTypeString", "alias" : "FlowMeasurementID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "manufacturer", "type" : "esriFieldTypeString", "alias" : "Manufacturer", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "wDomainManufacturer", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "American", "code" : "American" }, { "name" : "Brown Steel", "code" : "Brown" }, { "name" : "CB&I", "code" : "CB&I" }, { "name" : "Clow", "code" : "Clow" }, { "name" : "Crane", "code" : "Crane" }, { "name" : "Ford", "code" : "Ford" }, { "name" : "Foxboro", "code" : "Foxboro" }, { "name" : "Griffin", "code" : "Griffin" }, { "name" : "M&H", "code" : "M&H" }, { "name" : "McWane", "code" : "McWane" }, { "name" : "Mueller", "code" : "Mueller" }, { "name" : "Neptune", "code" : "Neptune" }, { "name" : "PDM", "code" : "PDM" }, { "name" : "Sensus", "code" : "Sensus" }, { "name" : "U.S. Pipe", "code" : "U.S. Pipe" }, { "name" : "ISCO", "code" : "ISCO" }, { "name" : "American Flow Control", "code" : "AFC" }, { "name" : "Cerro", "code" : "Cerro" }, { "name" : "Pratt", "code" : "Pratt" }, { "name" : "Dezurick", "code" : "DeZurick" }, { "name" : "Streamline", "code" : "Streamline" }, { "name" : "Howell", "code" : "Howell" }, { "name" : "Kennedy", "code" : "Kennedy" }, { "name" : "Ames", "code" : "Ames" }, { "name" : "Watts", "code" : "Watts" }, { "name" : "Febco", "code" : "Febco" }, { "name" : "Conbraco", "code" : "Conbraco" }, { "name" : "Ross", "code" : "Ross" }, { "name" : "Metron Farnier", "code" : "Metron Farnier" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Other", "code" : "Other" }, { "name" : "American Darling", "code" : "American Darling" }, { "name" : "A.P. Smith", "code" : "A.P. Smith" } ] }, "defaultValue" : null }, { "name" : "designlength", "type" : "esriFieldTypeDouble", "alias" : "DesignLength", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pipeclass", "type" : "esriFieldTypeInteger", "alias" : "PipeClass", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "inmodel", "type" : "esriFieldTypeSmallInteger", "alias" : "InModel", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "projectname", "type" : "esriFieldTypeString", "alias" : "Project Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "installedby", "type" : "esriFieldTypeString", "alias" : "Installed By", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "origfacilityid", "type" : "esriFieldTypeString", "alias" : "OrigFacilityId", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "projectnumber", "type" : "esriFieldTypeString", "alias" : "Project Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createdby", "type" : "esriFieldTypeString", "alias" : "CREATEDBY", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "createddate", "type" : "esriFieldTypeDate", "alias" : "CREATEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creationdate", "type" : "esriFieldTypeDate", "alias" : "creationdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "editdate", "type" : "esriFieldTypeDate", "alias" : "editdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "editor", "type" : "esriFieldTypeString", "alias" : "editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "creationdateIndex", "fields" : "creationdate", "isAscending" : true, "isUnique" : false, "description" : "creationdate Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "editdateIndex", "fields" : "editdate", "isAscending" : true, "isUnique" : false, "description" : "editdate Field index", "indexType" : "Attribute" }, { "name" : "editorIndex", "fields" : "editor", "isAscending" : false, "isUnique" : false, "description" : "editor Field index", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_LATERAL_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E63292719FB4", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "facilityid" : null, "installdate" : null, "material" : null, "linetype" : null, "locdesc" : null, "diameter" : null, "watertype" : null, "enabled" : null, "activeflag" : null, "ownedby" : null, "maintby" : null, "lastupdate" : null, "lasteditor" : null, "workorderid" : null, "flowmeasurementid" : null, "manufacturer" : null, "designlength" : null, "pipeclass" : null, "inmodel" : null, "projectname" : null, "installedby" : null, "origfacilityid" : null, "projectnumber" : null, "createdby" : null, "createddate" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 7, "name" : "Project_Areas", "type" : "Feature Layer", "serviceItemId" : "43f04b04284d4004830fe8abdcdadf96", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : false, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "creationdate", "creatorField" : "creator", "editDateField" : "editdate", "editorField" : "editor" }, "editingInfo" : { "lastEditDate" : 1648574207004, "schemaLastEditDate" : 1648574207004, "dataLastEditDate" : 1648574207004 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 288896, "maxScale" : 1128, "extent" : { "xmin" : -9503395.0712, "ymin" : 3848348.1120999977, "xmax" : -9502973.4732, "ymax" : 3848756.5725, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"color":[0,255,197,255],"outline":{"color":[156,156,156,255],"width":2,"type":"esriSLS","style":"esriSLSDash"},"type":"esriSFS","style":"esriSFSSolid"}},"transparency":50}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creationdate", "type" : "esriFieldTypeDate", "alias" : "creationdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "editdate", "type" : "esriFieldTypeDate", "alias" : "editdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "editor", "type" : "esriFieldTypeString", "alias" : "editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "globalid", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "creationdateIndex", "fields" : "creationdate", "isAscending" : true, "isUnique" : false, "description" : "creationdate Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "editdateIndex", "fields" : "editdate", "isAscending" : true, "isUnique" : false, "description" : "editdate Field index", "indexType" : "Attribute" }, { "name" : "editorIndex", "fields" : "editor", "isAscending" : false, "isUnique" : false, "description" : "editor Field index", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "user_290.Sample_Utility_Data_PROJECT_AREAS_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__Sample_U__5242E6326D7F28FD", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "name" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [] }